summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0006.sql2
-rw-r--r--schema/mysql.sql1
-rw-r--r--schema/sqlite.sql5
3 files changed, 6 insertions, 2 deletions
diff --git a/schema/migrations/0006.sql b/schema/migrations/0006.sql
new file mode 100644
index 0000000..3ca725c
--- /dev/null
+++ b/schema/migrations/0006.sql
@@ -0,0 +1,2 @@
+ALTER TABLE users
+ADD COLUMN `supported_post_types` LONGTEXT;
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 402218a..bbe0dd4 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -24,5 +24,6 @@ CREATE TABLE `users` (
`instagram_access_token` text,
`email_username` varchar(255) DEFAULT NULL,
`default_timezone` varchar(255) DEFAULT NULL,
+ `supported_post_types` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/schema/sqlite.sql b/schema/sqlite.sql
index 00e5f1c..948b3ef 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -23,5 +23,6 @@ CREATE TABLE users (
twitter_username TEXT,
instagram_access_token TEXT,
email_username TEXT,
- default_timezone TEXT
-); \ No newline at end of file
+ default_timezone TEXT,
+ supported_post_types TEXT,
+);