|
Last change
on this file since 239 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.
