add channel selection to event interface

3 files changed, 8 insertions, 0 deletions

diff --git a/schema/migrations/0011.sql b/schema/migrations/0011.sql
new file mode 100644
index 0000000..4b0ca61
--- /dev/null
+++ b/schema/migrations/0011.sql
@@ -0,0 +1,6 @@
+ALTER TABLE users
+DROP COLUMN flightaware_username,
+DROP COLUMN flightaware_apikey;
+
+ALTER TABLE users
+ADD COLUMN `channels` TEXT AFTER syndication_targets;
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 5a91e55..0a0accb 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -17,6 +17,7 @@ CREATE TABLE `users` (
   `last_micropub_response_date` datetime DEFAULT NULL,
   `location_enabled` tinyint(4) NOT NULL DEFAULT '0',
   `syndication_targets` text,
+  `channels` text,
   `twitter_access_token` text,
   `twitter_token_secret` text,
   `twitter_username` varchar(255) DEFAULT NULL,
diff --git a/schema/sqlite.sql b/schema/sqlite.sql
index ca495cd..dd041b3 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -17,6 +17,7 @@ CREATE TABLE users (
   last_micropub_response_date datetime,
   location_enabled INTEGER NOT NULL default 0,
   syndication_targets TEXT,
+  channels TEXT,
   twitter_access_token TEXT,
   twitter_token_secret TEXT,
   twitter_username TEXT,