summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
Diffstat (limited to 'schema')
-rw-r--r--schema/migrations/0007.sql2
-rw-r--r--schema/mysql.sql1
-rw-r--r--schema/sqlite.sql3
3 files changed, 5 insertions, 1 deletions
diff --git a/schema/migrations/0007.sql b/schema/migrations/0007.sql
new file mode 100644
index 0000000..2d51a15
--- /dev/null
+++ b/schema/migrations/0007.sql
@@ -0,0 +1,2 @@
+ALTER TABLE users
+ADD COLUMN `supported_visibility` LONGTEXT;
diff --git a/schema/mysql.sql b/schema/mysql.sql
index bbe0dd4..1007256 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -25,5 +25,6 @@ CREATE TABLE `users` (
`email_username` varchar(255) DEFAULT NULL,
`default_timezone` varchar(255) DEFAULT NULL,
`supported_post_types` longtext,
+ `supported_visibility` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/schema/sqlite.sql b/schema/sqlite.sql
index 8eaa7b0..37365cd 100644
--- a/schema/sqlite.sql
+++ b/schema/sqlite.sql
@@ -24,5 +24,6 @@ CREATE TABLE users (
instagram_access_token TEXT,
email_username TEXT,
default_timezone TEXT,
- supported_post_types TEXT
+ supported_post_types TEXT,
+ supported_visibility TEXT
);