diff options
| author | Christian Pointner <equinox@helsinki.at> | 2017-01-06 01:55:32 (GMT) |
|---|---|---|
| committer | Christian Pointner <equinox@helsinki.at> | 2017-01-06 01:55:32 (GMT) |
| commit | 92105037860702b69444e9e9bf687eb961b16e53 (patch) | |
| tree | 5918d2924ef0ee9dcffe05a1e0d0efdab8dfe0a7 | |
| parent | f093e02546f1752f2c9fea5581aa20d0e8bfb848 (diff) | |
added migration script for database on rdimport
| -rw-r--r-- | src/db-migrate.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/db-migrate.sql b/src/db-migrate.sql new file mode 100644 index 0000000..16c2dca --- /dev/null +++ b/src/db-migrate.sql @@ -0,0 +1,4 @@ +alter table master drop column ismusic, add column carttype ENUM('show','pool','jingle') default 'pool'; +alter table master modify column carttype ENUM('show','pool','jingle'); +alter table standby drop column ismusic, add column carttype ENUM('show','pool','jingle') default 'pool'; +alter table standby modify column carttype ENUM('show','pool','jingle'); |