Changeset 261 for trunk/docs

Timestamp:

Jun 19, 2007 5:34:34 AM (17 years ago)

Author:

quinn

Message:

Updated v1-v2 mysql upgrade script.

File:

• trunk/docs/upgrade_v1-to-v2.mysql (modified) (1 diff)

trunk/docs/upgrade_v1-to-v2.mysql

@@ -1 @@
-# Upgrade version_tbl.
+## Update user_tbl.
+## (If it exists.)
+# ALTER TABLE `user_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id;
+# ALTER TABLE `user_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id;
+# ALTER TABLE `user_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime;
+
+## Update admin_tbl.
+ALTER TABLE `admin_tbl` ADD login_abuse_exempt enum('true') default NULL AFTER priv;
+ALTER TABLE `admin_tbl` ADD blocked enum('true') default NULL AFTER login_abuse_exempt;
+ALTER TABLE `admin_tbl` ADD blocked_reason varchar(255) NOT NULL default '' AFTER blocked;
+ALTER TABLE `admin_tbl` ADD abuse_warning_level tinyint(4) NOT NULL default '0' AFTER blocked_reason;
+ALTER TABLE `admin_tbl` ADD added_by_user_id smallint(11) default NULL AFTER last_login_ip;
+ALTER TABLE `admin_tbl` ADD modified_by_user_id smallint(11) default NULL AFTER added_by_user_id;
+ALTER TABLE `admin_tbl` MODIFY added_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER modified_by_user_id;
+ALTER TABLE `admin_tbl` ADD modified_datetime datetime NOT NULL default '0000-00-00 00:00:00' AFTER added_datetime;
+
+## Upgrade version_tbl.
 ALTER TABLE `version_tbl` ADD version_number SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER version_title;
 ALTER TABLE `version_tbl` ADD version_notes VARCHAR(255) NOT NULL DEFAULT '' AFTER version_number;
-ALTER TABLE `version_tbl` ADD saved_by_user_id SMALLINT(11) NOT NULL DEFAULT '0' AFTER version_notes;
-UPDATE `version_tbl` SET saved_by_user_id = saved_by_admin_id;
-ALTER TABLE `version_tbl` DROP saved_by_admin_id;
+ALTER TABLE `version_tbl` CHANGE saved_by_admin_id saved_by_user_id smallint(11) default NULL;
 
+## Rename added_by_admin_id -> added_by_user_id in all tables.
+## Changing these will require source code modifications.
+ALTER TABLE `client_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
+ALTER TABLE `config_event_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
+ALTER TABLE `invoice_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
+ALTER TABLE `payment_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;
+ALTER TABLE `site_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;