|
Last change
on this file since 238 was
238,
checked in by quinn, 17 years ago
|
|
Q - added upgrade_v1-to-v2.mysql SQL upgrade script.
|
|
File size:
443 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; |
|---|
Note: See
TracBrowser
for help on using the repository browser.
