# HG changeset patch # User Dan # Date 1183843193 14400 # Node ID 436e7a3a40130765bdb0c613ed4c434406a1e976 # Parent 5e9bb8b7bbdfbb7e04068a06fcc3421a7a6f3d9b Fixed even more bugs in the upgrade schema (there may be a number of commits like this, as we are testing the upgrade script on a temp server) diff -r 5e9bb8b7bbdf -r 436e7a3a4013 themes/stpatty/css/shamrock.css --- a/themes/stpatty/css/shamrock.css Sat Jul 07 16:43:38 2007 -0400 +++ b/themes/stpatty/css/shamrock.css Sat Jul 07 17:19:53 2007 -0400 @@ -427,7 +427,7 @@ background-color: #73b038; } -input:active { +input:active, input:focus { background-color: #83c048; } diff -r 5e9bb8b7bbdf -r 436e7a3a4013 upgrade.sql --- a/upgrade.sql Sat Jul 07 16:43:38 2007 -0400 +++ b/upgrade.sql Sat Jul 07 17:19:53 2007 -0400 @@ -7,6 +7,9 @@ ---BEGIN 1.0RC3--- ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_coppa tinyint(1) NOT NULL DEFAULT 0; UPDATE {{TABLE_PREFIX}}sidebar SET block_content='[[User:$USERNAME$|User page]]\n[[Special:Contributions/$USERNAME$|My Contributions]]\n{if user_logged_in}\n[[$NS_SPECIAL$Preferences|Preferences]]\n[[Special:PrivateMessages|Private messages ($UNREAD_PMS$)]]\n[[Special:Usergroups|Group control panel]]\n$THEME_LINK$\n{/if}\n{if user_logged_in}\n$LOGOUT_LINK$\n{else}\n[[Special:Register|Create an account]]\n$LOGIN_LINK$\n[[Special:Login/Special:PrivateMessages|Private messages]]\n{/if}' WHERE item_id=3; +-- Updated PHP-ized search box +-- block_type=3: 3 = BLOCK_PHP +UPDATE {{TABLE_PREFIX}}sidebar SET block_content='?>
',block_type=3 WHERE block_name='Search'; ---END 1.0RC3--- ---BEGIN 1.0RC2--- -- Add the "Moderators" group @@ -20,6 +23,8 @@ INSERT INTO {{TABLE_PREFIX}}acl(target_type,target_id,page_id,namespace,rules) VALUES(1,3,NULL,NULL,'read=4;post_comments=4;edit_comments=4;edit_page=4;view_source=4;mod_comments=4;history_view=4;history_rollback=4;history_rollback_extra=4;protect=4;rename=3;clear_logs=2;vote_delete=4;vote_reset=4;delete_page=4;set_wiki_mode=2;password_set=2;password_reset=2;mod_misc=2;edit_cat=4;even_when_protected=4;upload_files=2;upload_new_version=3;create_page=3;php_in_pages=2;edit_acl=2;'); -- Create table with extra user information CREATE TABLE users_extra( user_id mediumint(8) NOT NULL, user_aim varchar(63) default NULL, user_yahoo varchar(63) default NULL, user_msn varchar(255) default NULL, user_xmpp varchar(255) default NULL, user_homepage text, user_location text, user_job text, user_hobbies text, email_public tinyint(1) NOT NULL default '0', userpage_comments smallint(5) NOT NULL default '0', PRIMARY KEY ( user_id ) ); +-- Turn on the Enano button on the sidebar +INSERT INTO {{TABLE_PREFIX}}config(config_name,config_value) VALUES('powered_btn', '1'); ---END 1.0RC2--- ---BEGIN 1.0RC1--- -- Not too many DB changes in this release - that's a good sign ;-)