From 92105037860702b69444e9e9bf687eb961b16e53 Mon Sep 17 00:00:00 2001
From: Christian Pointner <equinox@helsinki.at>
Date: Fri, 6 Jan 2017 02:55:32 +0100
Subject: added migration script for database on rdimport


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');
-- 
cgit v0.10.2