summaryrefslogtreecommitdiff
path: root/app/Schema/Sql
diff options
context:
space:
mode:
authorAurélien <cadiou.aurelien@gmail.com>2018-04-02 23:07:04 +0200
committerFrédéric Guillot <fred@kanboard.net>2018-04-02 14:07:04 -0700
commit5f7a3442d61b99e2fbad732bd0eaf9ad64398274 (patch)
tree78d2b159be9d2df92e28c90164430fdac2a4cac7 /app/Schema/Sql
parentbc4457c4cb096a448d88ca882d30bae15aff56c3 (diff)
Add default filter per user
Diffstat (limited to 'app/Schema/Sql')
-rw-r--r--app/Schema/Sql/mysql.sql1
-rw-r--r--app/Schema/Sql/postgres.sql3
2 files changed, 3 insertions, 1 deletions
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql
index 37da98cc..199fd797 100644
--- a/app/Schema/Sql/mysql.sql
+++ b/app/Schema/Sql/mysql.sql
@@ -752,6 +752,7 @@ CREATE TABLE `users` (
`is_active` tinyint(1) DEFAULT '1',
`avatar_path` varchar(255) DEFAULT NULL,
`api_access_token` varchar(255) DEFAULT NULL,
+ `filter` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_username_idx` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql
index 1d45870a..e43248c3 100644
--- a/app/Schema/Sql/postgres.sql
+++ b/app/Schema/Sql/postgres.sql
@@ -1299,7 +1299,8 @@ CREATE TABLE "users" (
"role" character varying(25) DEFAULT 'app-user'::character varying NOT NULL,
"is_active" boolean DEFAULT true,
"avatar_path" character varying(255),
- "api_access_token" character varying(255) DEFAULT NULL::character varying
+ "api_access_token" character varying(255) DEFAULT NULL::character varying,
+ "filter" character varying(255) DEFAULT NULL::character varying
);