add a dropdown to choose post visibility

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
 );