From 5f7a3442d61b99e2fbad732bd0eaf9ad64398274 Mon Sep 17 00:00:00 2001 From: Aurélien Date: Mon, 2 Apr 2018 23:07:04 +0200 Subject: Add default filter per user --- app/Schema/Sql/mysql.sql | 1 + app/Schema/Sql/postgres.sql | 3 ++- 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'app/Schema/Sql') 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 ); -- cgit v1.2.3