diff options
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/migrations/0011.sql | 6 | ||||
| -rw-r--r-- | schema/migrations/0012.sql | 2 | ||||
| -rw-r--r-- | schema/mysql.sql | 1 | ||||
| -rw-r--r-- | schema/sqlite.sql | 1 |
4 files changed, 9 insertions, 1 deletions
diff --git a/schema/migrations/0011.sql b/schema/migrations/0011.sql index 763ea58..4b0ca61 100644 --- a/schema/migrations/0011.sql +++ b/schema/migrations/0011.sql @@ -1,2 +1,6 @@ ALTER TABLE users -ADD COLUMN `weight_unit` VARCHAR(255) DEFAULT 'kg'; +DROP COLUMN flightaware_username, +DROP COLUMN flightaware_apikey; + +ALTER TABLE users +ADD COLUMN `channels` TEXT AFTER syndication_targets; diff --git a/schema/migrations/0012.sql b/schema/migrations/0012.sql new file mode 100644 index 0000000..763ea58 --- /dev/null +++ b/schema/migrations/0012.sql @@ -0,0 +1,2 @@ +ALTER TABLE users +ADD COLUMN `weight_unit` VARCHAR(255) DEFAULT 'kg'; diff --git a/schema/mysql.sql b/schema/mysql.sql index 4ee94b0..d6210d9 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 7f73dd8..310b2ae 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, |