diff options
| -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'); |