From 8dec126e7dd19ebb068b1a4f42804f8c0205af9d Mon Sep 17 00:00:00 2001 From: Aaron Parecki Date: Mon, 30 Mar 2020 10:26:46 -0700 Subject: add channel selection to event interface --- schema/migrations/0011.sql | 6 ++++++ schema/mysql.sql | 1 + schema/sqlite.sql | 1 + 3 files changed, 8 insertions(+) create mode 100644 schema/migrations/0011.sql (limited to 'schema') 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, -- cgit v1.2.3