source: trunk/docs/upgrade_v1-to-v2.mysql @ 261

Last change on this file since 261 was 261, checked in by quinn, 17 years ago

Updated v1-v2 mysql upgrade script.

File size: 2.1 KB
Line 
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.
8ALTER TABLE `admin_tbl` ADD login_abuse_exempt enum('true') default NULL AFTER priv;
9ALTER TABLE `admin_tbl` ADD blocked enum('true') default NULL AFTER login_abuse_exempt;
10ALTER TABLE `admin_tbl` ADD blocked_reason varchar(255) NOT NULL default '' AFTER blocked;
11ALTER TABLE `admin_tbl` ADD abuse_warning_level tinyint(4) NOT NULL default '0' AFTER blocked_reason;
12ALTER TABLE `admin_tbl` ADD added_by_user_id smallint(11) default NULL AFTER last_login_ip;
13ALTER TABLE `admin_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id;
14ALTER TABLE `admin_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id;
15ALTER TABLE `admin_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime;
16
17## Upgrade version_tbl.
18ALTER TABLE `version_tbl` ADD version_number SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER version_title;
19ALTER TABLE `version_tbl` ADD version_notes VARCHAR(255) NOT NULL DEFAULT '' AFTER version_number;
20ALTER TABLE `version_tbl` CHANGE saved_by_admin_id saved_by_user_id smallint(11) default NULL;
21
22## Rename added_by_admin_id -> added_by_user_id in all tables.
23## Changing these will require source code modifications.
24ALTER TABLE `client_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
25ALTER TABLE `config_event_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
26ALTER TABLE `invoice_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
27ALTER TABLE `payment_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
28ALTER TABLE `site_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
Note: See TracBrowser for help on using the repository browser.