Update SQL schema exports

2 files changed, 173 insertions, 97 deletions

diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql
index 280735f1..bb87a6ca 100644
--- a/app/Schema/Sql/mysql.sql
+++ b/app/Schema/Sql/mysql.sql
@@ -87,6 +87,7 @@ CREATE TABLE `custom_filters` (
   `user_id` int(11) NOT NULL,
   `name` varchar(100) NOT NULL,
   `is_shared` tinyint(1) DEFAULT '0',
+  `append` tinyint(1) DEFAULT '0',
   PRIMARY KEY (`id`),
   KEY `project_id` (`project_id`),
   KEY `user_id` (`user_id`),
@@ -213,6 +214,29 @@ CREATE TABLE `project_has_categories` (
   CONSTRAINT `project_has_categories_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `project_has_metadata`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `project_has_metadata` (
+  `project_id` int(11) NOT NULL,
+  `name` varchar(50) NOT NULL,
+  `value` varchar(255) DEFAULT '',
+  UNIQUE KEY `project_id` (`project_id`,`name`),
+  CONSTRAINT `project_has_metadata_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `project_has_notification_types`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `project_has_notification_types` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `project_id` int(11) NOT NULL,
+  `notification_type` varchar(50) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `project_id` (`project_id`,`notification_type`),
+  CONSTRAINT `project_has_notification_types_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
 DROP TABLE IF EXISTS `project_has_users`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -228,31 +252,6 @@ CREATE TABLE `project_has_users` (
   CONSTRAINT `project_has_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
-DROP TABLE IF EXISTS `project_integrations`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `project_integrations` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `project_id` int(11) NOT NULL,
-  `hipchat` tinyint(1) DEFAULT '0',
-  `hipchat_api_url` varchar(255) DEFAULT 'https://api.hipchat.com',
-  `hipchat_room_id` varchar(255) DEFAULT NULL,
-  `hipchat_room_token` varchar(255) DEFAULT NULL,
-  `slack` tinyint(1) DEFAULT '0',
-  `slack_webhook_url` varchar(255) DEFAULT NULL,
-  `jabber` int(11) DEFAULT '0',
-  `jabber_server` varchar(255) DEFAULT '',
-  `jabber_domain` varchar(255) DEFAULT '',
-  `jabber_username` varchar(255) DEFAULT '',
-  `jabber_password` varchar(255) DEFAULT '',
-  `jabber_nickname` varchar(255) DEFAULT 'kanboard',
-  `jabber_room` varchar(255) DEFAULT '',
-  `slack_webhook_channel` varchar(255) DEFAULT '',
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `project_id` (`project_id`),
-  CONSTRAINT `project_integrations_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
 DROP TABLE IF EXISTS `projects`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -376,6 +375,17 @@ CREATE TABLE `task_has_links` (
   CONSTRAINT `task_has_links_ibfk_3` FOREIGN KEY (`opposite_task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `task_has_metadata`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `task_has_metadata` (
+  `task_id` int(11) NOT NULL,
+  `name` varchar(50) NOT NULL,
+  `value` varchar(255) DEFAULT '',
+  UNIQUE KEY `task_id` (`task_id`,`name`),
+  CONSTRAINT `task_has_metadata_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
 DROP TABLE IF EXISTS `tasks`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -443,6 +453,17 @@ CREATE TABLE `transitions` (
   CONSTRAINT `transitions_ibfk_5` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `user_has_metadata`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_has_metadata` (
+  `user_id` int(11) NOT NULL,
+  `name` varchar(50) NOT NULL,
+  `value` varchar(255) DEFAULT '',
+  UNIQUE KEY `user_id` (`user_id`,`name`),
+  CONSTRAINT `user_has_metadata_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
 DROP TABLE IF EXISTS `user_has_notification_types`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -530,7 +551,7 @@ CREATE TABLE `users` (
 
 LOCK TABLES `settings` WRITE;
 /*!40000 ALTER TABLE `settings` DISABLE KEYS */;
-INSERT INTO `settings` VALUES ('api_token','37d92e3bc7e2ede57948401870a1ab70d59265930853fd65954ca22a09ed'),('application_currency','USD'),('application_date_format','m/d/Y'),('application_language','en_US'),('application_stylesheet',''),('application_timezone','UTC'),('application_url',''),('board_columns',''),('board_highlight_period','172800'),('board_private_refresh_interval','10'),('board_public_refresh_interval','60'),('calendar_project_tasks','date_started'),('calendar_user_subtasks_time_tracking','0'),('calendar_user_tasks','date_started'),('cfd_include_closed_tasks','1'),('default_color','yellow'),('integration_gravatar','0'),('integration_hipchat','0'),('integration_hipchat_api_url','https://api.hipchat.com'),('integration_hipchat_room_id',''),('integration_hipchat_room_token',''),('integration_jabber','0'),('integration_jabber_domain',''),('integration_jabber_nickname','kanboard'),('integration_jabber_password',''),('integration_jabber_room',''),('integration_jabber_server',''),('integration_jabber_username',''),('integration_slack_webhook','0'),('integration_slack_webhook_channel',''),('integration_slack_webhook_url',''),('project_categories',''),('subtask_restriction','0'),('subtask_time_tracking','1'),('webhook_token','4f0986fa4a12fab97e0f54615c40a87e74a1e0ac65a8486b0710b5ff6a8d'),('webhook_url','');
+INSERT INTO `settings` VALUES ('api_token','ccff8d37146322410479c8c6707cdaddde840af28ccbd6fbb5a7d7908844'),('application_currency','USD'),('application_date_format','m/d/Y'),('application_language','en_US'),('application_stylesheet',''),('application_timezone','UTC'),('application_url',''),('board_columns',''),('board_highlight_period','172800'),('board_private_refresh_interval','10'),('board_public_refresh_interval','60'),('calendar_project_tasks','date_started'),('calendar_user_subtasks_time_tracking','0'),('calendar_user_tasks','date_started'),('cfd_include_closed_tasks','1'),('default_color','yellow'),('integration_gravatar','0'),('project_categories',''),('subtask_restriction','0'),('subtask_time_tracking','1'),('webhook_token','7a9d4cd8c7fc4d52c60f01b775d4f2bd6e186d2e44f5b3723157b8eb372b'),('webhook_url','');
 /*!40000 ALTER TABLE `settings` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -559,4 +580,4 @@ UNLOCK TABLES;
 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
-INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$ZkZIbCTR/OrzhRTOx.UZZeaInO85/1N/j4zxb7WCrNpO9hjFM1mUC', '1');INSERT INTO schema_version VALUES ('90');
+INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$fDbO.nKAjDxm70DyghADCuqIhF919BAkRTAq0bARDTGwcxZscqIZq', '1');INSERT INTO schema_version VALUES ('93');
diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql
index 5b3bb551..8738010f 100644
--- a/app/Schema/Sql/postgres.sql
+++ b/app/Schema/Sql/postgres.sql
@@ -177,7 +177,8 @@ CREATE TABLE custom_filters (
     project_id integer NOT NULL,
     user_id integer NOT NULL,
     name character varying(100) NOT NULL,
-    is_shared boolean DEFAULT false
+    is_shared boolean DEFAULT false,
+    append boolean DEFAULT false
 );
 
 
@@ -420,22 +421,32 @@ ALTER SEQUENCE project_has_categories_id_seq OWNED BY project_has_categories.id;
 
 
 --
--- Name: project_has_users; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: project_has_metadata; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
 
-CREATE TABLE project_has_users (
+CREATE TABLE project_has_metadata (
+    project_id integer NOT NULL,
+    name character varying(50) NOT NULL,
+    value character varying(255) DEFAULT ''::character varying
+);
+
+
+--
+-- Name: project_has_notification_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE TABLE project_has_notification_types (
     id integer NOT NULL,
     project_id integer NOT NULL,
-    user_id integer NOT NULL,
-    is_owner boolean DEFAULT false
+    notification_type character varying(50) NOT NULL
 );
 
 
 --
--- Name: project_has_users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
+-- Name: project_has_notification_types_id_seq; Type: SEQUENCE; Schema: public; Owner: -
 --
 
-CREATE SEQUENCE project_has_users_id_seq
+CREATE SEQUENCE project_has_notification_types_id_seq
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -444,41 +455,29 @@ CREATE SEQUENCE project_has_users_id_seq
 
 
 --
--- Name: project_has_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
+-- Name: project_has_notification_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
 --
 
-ALTER SEQUENCE project_has_users_id_seq OWNED BY project_has_users.id;
+ALTER SEQUENCE project_has_notification_types_id_seq OWNED BY project_has_notification_types.id;
 
 
 --
--- Name: project_integrations; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: project_has_users; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
 
-CREATE TABLE project_integrations (
+CREATE TABLE project_has_users (
     id integer NOT NULL,
     project_id integer NOT NULL,
-    hipchat boolean DEFAULT false,
-    hipchat_api_url character varying(255) DEFAULT 'https://api.hipchat.com'::character varying,
-    hipchat_room_id character varying(255),
-    hipchat_room_token character varying(255),
-    slack boolean DEFAULT false,
-    slack_webhook_url character varying(255),
-    jabber integer DEFAULT 0,
-    jabber_server character varying(255) DEFAULT ''::character varying,
-    jabber_domain character varying(255) DEFAULT ''::character varying,
-    jabber_username character varying(255) DEFAULT ''::character varying,
-    jabber_password character varying(255) DEFAULT ''::character varying,
-    jabber_nickname character varying(255) DEFAULT 'kanboard'::character varying,
-    jabber_room character varying(255) DEFAULT ''::character varying,
-    slack_webhook_channel character varying(255) DEFAULT ''::character varying
+    user_id integer NOT NULL,
+    is_owner boolean DEFAULT false
 );
 
 
 --
--- Name: project_integrations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
+-- Name: project_has_users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
 --
 
-CREATE SEQUENCE project_integrations_id_seq
+CREATE SEQUENCE project_has_users_id_seq
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
@@ -487,10 +486,10 @@ CREATE SEQUENCE project_integrations_id_seq
 
 
 --
--- Name: project_integrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
+-- Name: project_has_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
 --
 
-ALTER SEQUENCE project_integrations_id_seq OWNED BY project_integrations.id;
+ALTER SEQUENCE project_has_users_id_seq OWNED BY project_has_users.id;
 
 
 --
@@ -721,6 +720,17 @@ ALTER SEQUENCE task_has_links_id_seq OWNED BY task_has_links.id;
 
 
 --
+-- Name: task_has_metadata; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE TABLE task_has_metadata (
+    task_id integer NOT NULL,
+    name character varying(50) NOT NULL,
+    value character varying(255) DEFAULT ''::character varying
+);
+
+
+--
 -- Name: task_has_subtasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
 --
 
@@ -831,6 +841,17 @@ ALTER SEQUENCE transitions_id_seq OWNED BY transitions.id;
 
 
 --
+-- Name: user_has_metadata; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE TABLE user_has_metadata (
+    user_id integer NOT NULL,
+    name character varying(50) NOT NULL,
+    value character varying(255) DEFAULT ''::character varying
+);
+
+
+--
 -- Name: user_has_notification_types; Type: TABLE; Schema: public; Owner: -; Tablespace: 
 --
 
@@ -1038,14 +1059,14 @@ ALTER TABLE ONLY project_has_categories ALTER COLUMN id SET DEFAULT nextval('pro
 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
 --
 
-ALTER TABLE ONLY project_has_users ALTER COLUMN id SET DEFAULT nextval('project_has_users_id_seq'::regclass);
+ALTER TABLE ONLY project_has_notification_types ALTER COLUMN id SET DEFAULT nextval('project_has_notification_types_id_seq'::regclass);
 
 
 --
 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
 --
 
-ALTER TABLE ONLY project_integrations ALTER COLUMN id SET DEFAULT nextval('project_integrations_id_seq'::regclass);
+ALTER TABLE ONLY project_has_users ALTER COLUMN id SET DEFAULT nextval('project_has_users_id_seq'::regclass);
 
 
 --
@@ -1254,35 +1275,43 @@ ALTER TABLE ONLY project_has_categories
 
 
 --
--- Name: project_has_users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: project_has_metadata_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 
-ALTER TABLE ONLY project_has_users
-    ADD CONSTRAINT project_has_users_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY project_has_metadata
+    ADD CONSTRAINT project_has_metadata_project_id_name_key UNIQUE (project_id, name);
 
 
 --
--- Name: project_has_users_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: project_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 
-ALTER TABLE ONLY project_has_users
-    ADD CONSTRAINT project_has_users_project_id_user_id_key UNIQUE (project_id, user_id);
+ALTER TABLE ONLY project_has_notification_types
+    ADD CONSTRAINT project_has_notification_types_pkey PRIMARY KEY (id);
+
+
+--
+-- Name: project_has_notification_types_project_id_notification_type_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY project_has_notification_types
+    ADD CONSTRAINT project_has_notification_types_project_id_notification_type_key UNIQUE (project_id, notification_type);
 
 
 --
--- Name: project_integrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: project_has_users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 
-ALTER TABLE ONLY project_integrations
-    ADD CONSTRAINT project_integrations_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY project_has_users
+    ADD CONSTRAINT project_has_users_pkey PRIMARY KEY (id);
 
 
 --
--- Name: project_integrations_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: project_has_users_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 
-ALTER TABLE ONLY project_integrations
-    ADD CONSTRAINT project_integrations_project_id_key UNIQUE (project_id);
+ALTER TABLE ONLY project_has_users
+    ADD CONSTRAINT project_has_users_project_id_user_id_key UNIQUE (project_id, user_id);
 
 
 --
@@ -1358,6 +1387,14 @@ ALTER TABLE ONLY task_has_links
 
 
 --
+-- Name: task_has_metadata_task_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY task_has_metadata
+    ADD CONSTRAINT task_has_metadata_task_id_name_key UNIQUE (task_id, name);
+
+
+--
 -- Name: task_has_subtasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 
@@ -1382,6 +1419,14 @@ ALTER TABLE ONLY transitions
 
 
 --
+-- Name: user_has_metadata_user_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+--
+
+ALTER TABLE ONLY user_has_metadata
+    ADD CONSTRAINT user_has_metadata_user_id_name_key UNIQUE (user_id, name);
+
+
+--
 -- Name: user_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
 --
 
@@ -1643,27 +1688,35 @@ ALTER TABLE ONLY project_has_categories
 
 
 --
--- Name: project_has_users_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: project_has_metadata_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
-ALTER TABLE ONLY project_has_users
-    ADD CONSTRAINT project_has_users_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
+ALTER TABLE ONLY project_has_metadata
+    ADD CONSTRAINT project_has_metadata_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
 
 
 --
--- Name: project_has_users_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: project_has_notification_types_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY project_has_notification_types
+    ADD CONSTRAINT project_has_notification_types_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
+
+
+--
+-- Name: project_has_users_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY project_has_users
-    ADD CONSTRAINT project_has_users_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
+    ADD CONSTRAINT project_has_users_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
 
 
 --
--- Name: project_integrations_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: project_has_users_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
-ALTER TABLE ONLY project_integrations
-    ADD CONSTRAINT project_integrations_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
+ALTER TABLE ONLY project_has_users
+    ADD CONSTRAINT project_has_users_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
 
 
 --
@@ -1731,6 +1784,14 @@ ALTER TABLE ONLY task_has_links
 
 
 --
+-- Name: task_has_metadata_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY task_has_metadata
+    ADD CONSTRAINT task_has_metadata_task_id_fkey FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE;
+
+
+--
 -- Name: task_has_subtasks_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
@@ -1795,6 +1856,14 @@ ALTER TABLE ONLY transitions
 
 
 --
+-- Name: user_has_metadata_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY user_has_metadata
+    ADD CONSTRAINT user_has_metadata_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
+
+
+--
 -- Name: user_has_notification_types_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
@@ -1831,8 +1900,8 @@ ALTER TABLE ONLY user_has_unread_notifications
 --
 
 REVOKE ALL ON SCHEMA public FROM PUBLIC;
-REVOKE ALL ON SCHEMA public FROM f;
-GRANT ALL ON SCHEMA public TO f;
+REVOKE ALL ON SCHEMA public FROM fred;
+GRANT ALL ON SCHEMA public TO fred;
 GRANT ALL ON SCHEMA public TO PUBLIC;
 
 
@@ -1861,8 +1930,8 @@ INSERT INTO settings (option, value) VALUES ('board_highlight_period', '172800')
 INSERT INTO settings (option, value) VALUES ('board_public_refresh_interval', '60');
 INSERT INTO settings (option, value) VALUES ('board_private_refresh_interval', '10');
 INSERT INTO settings (option, value) VALUES ('board_columns', '');
-INSERT INTO settings (option, value) VALUES ('webhook_token', '94aa75d5d88c8e7084721c3a1c97c06630f494a31741f8cf3b6d9eadf6a1');
-INSERT INTO settings (option, value) VALUES ('api_token', '3f0a1683800e9104b6e8ec15cb254738eebf24028f2169546e17fa2a3801');
+INSERT INTO settings (option, value) VALUES ('webhook_token', '29877f0b69d230e57bee9d02e0aa9034a69f7a2c0ba1e3b5d3b390241f36');
+INSERT INTO settings (option, value) VALUES ('api_token', '5682955e965bd0cd7618559a25131fe6094d9fff3bb56c31291d64991353');
 INSERT INTO settings (option, value) VALUES ('application_language', 'en_US');
 INSERT INTO settings (option, value) VALUES ('application_timezone', 'UTC');
 INSERT INTO settings (option, value) VALUES ('application_url', '');
@@ -1871,25 +1940,11 @@ INSERT INTO settings (option, value) VALUES ('project_categories', '');
 INSERT INTO settings (option, value) VALUES ('subtask_restriction', '0');
 INSERT INTO settings (option, value) VALUES ('application_stylesheet', '');
 INSERT INTO settings (option, value) VALUES ('application_currency', 'USD');
-INSERT INTO settings (option, value) VALUES ('integration_slack_webhook', '0');
-INSERT INTO settings (option, value) VALUES ('integration_slack_webhook_url', '');
-INSERT INTO settings (option, value) VALUES ('integration_hipchat', '0');
-INSERT INTO settings (option, value) VALUES ('integration_hipchat_api_url', 'https://api.hipchat.com');
-INSERT INTO settings (option, value) VALUES ('integration_hipchat_room_id', '');
-INSERT INTO settings (option, value) VALUES ('integration_hipchat_room_token', '');
 INSERT INTO settings (option, value) VALUES ('integration_gravatar', '0');
-INSERT INTO settings (option, value) VALUES ('integration_jabber', '0');
-INSERT INTO settings (option, value) VALUES ('integration_jabber_server', '');
-INSERT INTO settings (option, value) VALUES ('integration_jabber_domain', '');
-INSERT INTO settings (option, value) VALUES ('integration_jabber_username', '');
-INSERT INTO settings (option, value) VALUES ('integration_jabber_password', '');
-INSERT INTO settings (option, value) VALUES ('integration_jabber_nickname', 'kanboard');
-INSERT INTO settings (option, value) VALUES ('integration_jabber_room', '');
 INSERT INTO settings (option, value) VALUES ('calendar_user_subtasks_time_tracking', '0');
 INSERT INTO settings (option, value) VALUES ('calendar_user_tasks', 'date_started');
 INSERT INTO settings (option, value) VALUES ('calendar_project_tasks', 'date_started');
 INSERT INTO settings (option, value) VALUES ('webhook_url', '');
-INSERT INTO settings (option, value) VALUES ('integration_slack_webhook_channel', '');
 INSERT INTO settings (option, value) VALUES ('default_color', 'yellow');
 INSERT INTO settings (option, value) VALUES ('subtask_time_tracking', '1');
 INSERT INTO settings (option, value) VALUES ('cfd_include_closed_tasks', '1');
@@ -1940,4 +1995,4 @@ SELECT pg_catalog.setval('links_id_seq', 11, true);
 -- PostgreSQL database dump complete
 --
 
-INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$ZkZIbCTR/OrzhRTOx.UZZeaInO85/1N/j4zxb7WCrNpO9hjFM1mUC', '1');INSERT INTO schema_version VALUES ('70');
+INSERT INTO users (username, password, is_admin) VALUES ('admin', '$2y$10$fDbO.nKAjDxm70DyghADCuqIhF919BAkRTAq0bARDTGwcxZscqIZq', '1');INSERT INTO schema_version VALUES ('73');