Changeset 239 for trunk/docs/upgrade_v1-to-v2.mysql

Timestamp:

Mar 25, 2007 8:43:40 PM (17 years ago)

Author:

jordan

Message:

Q - fixed ; in mysql upgrade. Jordan - many fixes to upgrade checklist.

File:

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

trunk/docs/upgrade_v1-to-v2.mysql

@@ -1 +1 @@
 # 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
+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;
+