Last change
on this file since 361 was
239,
checked in by jordan, 17 years ago
|
Q - fixed ; in mysql upgrade. Jordan - many fixes to upgrade checklist.
|
File size:
447 bytes
|
Line | |
---|
1 | # Upgrade version_tbl. |
---|
2 | ALTER TABLE `version_tbl` ADD version_number SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0' AFTER version_title; |
---|
3 | 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; |
---|
7 | |
---|
Note: See
TracBrowser
for help on using the repository browser.