upgrade.sql
changeset 213 0fe1f610698d
parent 205 62ee6685ad18
child 218 e0ec986c0af3
equal deleted inserted replaced
212:d57af0b0302e 213:0fe1f610698d
    50 INSERT INTO {{TABLE_PREFIX}}config(config_name,config_value) VALUES('powered_btn', '1');
    50 INSERT INTO {{TABLE_PREFIX}}config(config_name,config_value) VALUES('powered_btn', '1');
    51 ---END 1.0RC2---
    51 ---END 1.0RC2---
    52 ---BEGIN 1.0RC1---
    52 ---BEGIN 1.0RC1---
    53 -- Not too many DB changes in this release - that's a good sign ;-)
    53 -- Not too many DB changes in this release - that's a good sign ;-)
    54 ALTER TABLE {{TABLE_PREFIX}}search_index MODIFY COLUMN word varbinary(64) NOT NULL;
    54 ALTER TABLE {{TABLE_PREFIX}}search_index MODIFY COLUMN word varbinary(64) NOT NULL;
       
    55 -- This is to correct an issue encountered upgrading a stock Win2k3 + IIS setup
       
    56 ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM;
    55 CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id,namespace,page_text);
    57 CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id,namespace,page_text);
    56 UPDATE {{TABLE_PREFIX}}users SET user_level=3 WHERE user_level=2;
    58 UPDATE {{TABLE_PREFIX}}users SET user_level=3 WHERE user_level=2;
    57 UPDATE {{TABLE_PREFIX}}sidebar SET block_content='[[$NS_USER$$USERNAME$|User page]]\n[[$NS_SPECIAL$Contributions/$USERNAME$|My Contributions]]\n{if user_logged_in}\n[[$NS_SPECIAL$Preferences|Preferences]]\n[[$NS_SPECIAL$PrivateMessages|Private messages]]\n[[$NS_SPECIAL$Usergroups|Group control panel]]\n$THEME_LINK$\n{/if}\n{if user_logged_in}\n$LOGOUT_LINK$\n{else}\n[[$NS_SPECIAL$Register|Create an account]]\n$LOGIN_LINK$\n[[$NS_SPECIAL$Login/$NS_SPECIAL$PrivateMessages|Private messages]]\n{/if}',block_name='$USERNAME$' WHERE ( block_name='$USERNAME' OR block_name='$USERNAME$' ) AND item_id=3;
    59 UPDATE {{TABLE_PREFIX}}sidebar SET block_content='[[$NS_USER$$USERNAME$|User page]]\n[[$NS_SPECIAL$Contributions/$USERNAME$|My Contributions]]\n{if user_logged_in}\n[[$NS_SPECIAL$Preferences|Preferences]]\n[[$NS_SPECIAL$PrivateMessages|Private messages]]\n[[$NS_SPECIAL$Usergroups|Group control panel]]\n$THEME_LINK$\n{/if}\n{if user_logged_in}\n$LOGOUT_LINK$\n{else}\n[[$NS_SPECIAL$Register|Create an account]]\n$LOGIN_LINK$\n[[$NS_SPECIAL$Login/$NS_SPECIAL$PrivateMessages|Private messages]]\n{/if}',block_name='$USERNAME$' WHERE ( block_name='$USERNAME' OR block_name='$USERNAME$' ) AND item_id=3;
    58 ---END 1.0RC1---
    60 ---END 1.0RC1---
    59 ---BEGIN 1.0b4---
    61 ---BEGIN 1.0b4---