Changeset 261
- Timestamp:
- Jun 19, 2007 5:34:34 AM (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/docs/upgrade_v1-to-v2.mysql
r239 r261 1 # Upgrade version_tbl. 1 ## Update user_tbl. 2 ## (If it exists.) 3 # ALTER TABLE `user_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id; 4 # ALTER TABLE `user_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id; 5 # ALTER TABLE `user_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime; 6 7 ## Update admin_tbl. 8 ALTER TABLE `admin_tbl` ADD login_abuse_exempt enum('true') default NULL AFTER priv; 9 ALTER TABLE `admin_tbl` ADD blocked enum('true') default NULL AFTER login_abuse_exempt; 10 ALTER TABLE `admin_tbl` ADD blocked_reason varchar(255) NOT NULL default '' AFTER blocked; 11 ALTER TABLE `admin_tbl` ADD abuse_warning_level tinyint(4) NOT NULL default '0' AFTER blocked_reason; 12 ALTER TABLE `admin_tbl` ADD added_by_user_id smallint(11) default NULL AFTER last_login_ip; 13 ALTER TABLE `admin_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id; 14 ALTER TABLE `admin_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id; 15 ALTER TABLE `admin_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime; 16 17 ## Upgrade version_tbl. 2 18 ALTER TABLE `version_tbl` ADD version_number SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER version_title; 3 19 ALTER TABLE `version_tbl` ADD version_notes VARCHAR(255) NOT NULL DEFAULT '' AFTER version_number; 4 ALTER TABLE `version_tbl` ADD saved_by_user_id SMALLINT(11) NOT NULL DEFAULT '0' AFTER version_notes; 5 UPDATE `version_tbl` SET saved_by_user_id = saved_by_admin_id; 6 ALTER TABLE `version_tbl` DROP saved_by_admin_id; 20 ALTER TABLE `version_tbl` CHANGE saved_by_admin_id saved_by_user_id smallint(11) default NULL; 7 21 22 ## Rename added_by_admin_id -> added_by_user_id in all tables. 23 ## Changing these will require source code modifications. 24 ALTER TABLE `client_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL; 25 ALTER TABLE `config_event_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL; 26 ALTER TABLE `invoice_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL; 27 ALTER TABLE `payment_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL; 28 ALTER TABLE `site_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
Note: See TracChangeset
for help on using the changeset viewer.