Changeset 266 for trunk/docs

Timestamp:

Jul 3, 2007 8:41:36 AM (17 years ago)

Author:

quinn

Message:

Bugfixes found during strangecode site upgrade.

File:

• trunk/docs/upgrade_v1-to-v2.mysql (modified) (2 diffs)

trunk/docs/upgrade_v1-to-v2.mysql

@@ -1 +1 @@
 ## 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;
+## (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;
+## NOTE: This first one might need customizing.
+ALTER TABLE `admin_tbl` CHANGE priv user_type enum('root','admin','editor') default NULL;
+
+ALTER TABLE `admin_tbl` ADD login_abuse_exempt enum('true') default NULL AFTER user_type;
 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;
@@ -22 +25 @@
 ## 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;
+## This is just an EXAMPLE!
+# ALTER TABLE `client_tbl` CHANGE added_by_admin_id added_by_user_id smallint(11) default NULL;