Update SQL dumps

2 files changed, 81 insertions, 14 deletions

diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql
index 08e9b365..ca2b6d09 100644
--- a/app/Schema/Sql/mysql.sql
+++ b/app/Schema/Sql/mysql.sql
@@ -220,6 +220,19 @@ CREATE TABLE `plugin_schema_versions` (
   PRIMARY KEY (`plugin`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
+DROP TABLE IF EXISTS `predefined_task_descriptions`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `predefined_task_descriptions` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `project_id` int(11) NOT NULL,
+  `title` text NOT NULL,
+  `description` text NOT NULL,
+  PRIMARY KEY (`id`),
+  KEY `project_id` (`project_id`),
+  CONSTRAINT `predefined_task_descriptions_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_activities`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -393,7 +406,6 @@ CREATE TABLE `projects` (
   `last_modified` bigint(20) DEFAULT NULL,
   `is_public` tinyint(1) DEFAULT '0',
   `is_private` tinyint(1) DEFAULT '0',
-  `is_everybody_allowed` tinyint(1) DEFAULT '0',
   `description` text,
   `identifier` varchar(50) DEFAULT '',
   `start_date` varchar(10) DEFAULT '',
@@ -403,6 +415,7 @@ CREATE TABLE `projects` (
   `priority_start` int(11) DEFAULT '0',
   `priority_end` int(11) DEFAULT '3',
   `email` varchar(255) DEFAULT NULL,
+  `predefined_email_subjects` text,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -752,7 +765,7 @@ CREATE TABLE `users` (
 
 LOCK TABLES `settings` WRITE;
 /*!40000 ALTER TABLE `settings` DISABLE KEYS */;
-INSERT INTO `settings` VALUES ('api_token','7b7306fb38aa10046043df6e9631f51193ef58dc14b0b62836d00b2bb03e',0,0),('application_currency','USD',0,0),('application_date_format','m/d/Y',0,0),('application_language','en_US',0,0),('application_stylesheet','',0,0),('application_timezone','UTC',0,0),('application_url','',0,0),('board_columns','',0,0),('board_highlight_period','172800',0,0),('board_private_refresh_interval','10',0,0),('board_public_refresh_interval','60',0,0),('calendar_project_tasks','date_started',0,0),('calendar_user_subtasks_time_tracking','0',0,0),('calendar_user_tasks','date_started',0,0),('cfd_include_closed_tasks','1',0,0),('default_color','yellow',0,0),('integration_gravatar','0',0,0),('password_reset','1',0,0),('project_categories','',0,0),('subtask_restriction','0',0,0),('subtask_time_tracking','1',0,0),('webhook_token','384d5b69ffd7315f2cf1eef2c170b5ed0dbf6d2a2e63462e39dca5d24db2',0,0),('webhook_url','',0,0);
+INSERT INTO `settings` VALUES ('api_token','ce57483b40f4b618e5c7e5fcb9cf7727ef1c95ad58858780be9a7636e0f4',0,0),('application_currency','USD',0,0),('application_date_format','m/d/Y',0,0),('application_language','en_US',0,0),('application_stylesheet','',0,0),('application_timezone','UTC',0,0),('application_url','',0,0),('board_columns','',0,0),('board_highlight_period','172800',0,0),('board_private_refresh_interval','10',0,0),('board_public_refresh_interval','60',0,0),('calendar_project_tasks','date_started',0,0),('calendar_user_subtasks_time_tracking','0',0,0),('calendar_user_tasks','date_started',0,0),('cfd_include_closed_tasks','1',0,0),('default_color','yellow',0,0),('integration_gravatar','0',0,0),('password_reset','1',0,0),('project_categories','',0,0),('subtask_restriction','0',0,0),('subtask_time_tracking','1',0,0),('webhook_token','dc12854fc4c1526078a806aa7f7b7e802d3ccb45d90e8d5fe1bc98fa402e',0,0),('webhook_url','',0,0);
 /*!40000 ALTER TABLE `settings` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -781,4 +794,4 @@ UNLOCK TABLES;
 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
-INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$0WR8YPAwOCrDQTRFjji6u.krMgA4PcVsmw3ypmXAkqFKFLwnFOpAG', 'app-admin');INSERT INTO schema_version VALUES ('123');
+INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$6sRRMAp4Iu4UQiH.4aIAC.ExaWKfF0192hke5JheV.4hLIhhrbW1C', 'app-admin');INSERT INTO schema_version VALUES ('126');
diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql
index 52ba11cb..cb152d28 100644
--- a/app/Schema/Sql/postgres.sql
+++ b/app/Schema/Sql/postgres.sql
@@ -2,8 +2,8 @@
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.6.1
--- Dumped by pg_dump version 9.6.1
+-- Dumped from database version 9.6.4
+-- Dumped by pg_dump version 9.6.4
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -405,6 +405,37 @@ CREATE TABLE "plugin_schema_versions" (
 
 
 --
+-- Name: predefined_task_descriptions; Type: TABLE; Schema: public; Owner: -
+--
+
+CREATE TABLE "predefined_task_descriptions" (
+    "id" integer NOT NULL,
+    "project_id" integer NOT NULL,
+    "title" "text" NOT NULL,
+    "description" "text" NOT NULL
+);
+
+
+--
+-- Name: predefined_task_descriptions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
+--
+
+CREATE SEQUENCE "predefined_task_descriptions_id_seq"
+    START WITH 1
+    INCREMENT BY 1
+    NO MINVALUE
+    NO MAXVALUE
+    CACHE 1;
+
+
+--
+-- Name: predefined_task_descriptions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
+--
+
+ALTER SEQUENCE "predefined_task_descriptions_id_seq" OWNED BY "predefined_task_descriptions"."id";
+
+
+--
 -- Name: project_activities; Type: TABLE; Schema: public; Owner: -
 --
 
@@ -707,7 +738,6 @@ CREATE TABLE "projects" (
     "last_modified" bigint DEFAULT 0,
     "is_public" boolean DEFAULT false,
     "is_private" boolean DEFAULT false,
-    "is_everybody_allowed" boolean DEFAULT false,
     "description" "text",
     "identifier" character varying(50) DEFAULT ''::character varying,
     "start_date" character varying(10) DEFAULT ''::character varying,
@@ -716,7 +746,8 @@ CREATE TABLE "projects" (
     "priority_default" integer DEFAULT 0,
     "priority_start" integer DEFAULT 0,
     "priority_end" integer DEFAULT 3,
-    "email" character varying(255)
+    "email" character varying(255),
+    "predefined_email_subjects" "text"
 );
 
 
@@ -1351,6 +1382,13 @@ ALTER TABLE ONLY "links" ALTER COLUMN "id" SET DEFAULT "nextval"('"links_id_seq"
 
 
 --
+-- Name: predefined_task_descriptions id; Type: DEFAULT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY "predefined_task_descriptions" ALTER COLUMN "id" SET DEFAULT "nextval"('"predefined_task_descriptions_id_seq"'::"regclass");
+
+
+--
 -- Name: project_activities id; Type: DEFAULT; Schema: public; Owner: -
 --
 
@@ -1665,6 +1703,14 @@ ALTER TABLE ONLY "plugin_schema_versions"
 
 
 --
+-- Name: predefined_task_descriptions predefined_task_descriptions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY "predefined_task_descriptions"
+    ADD CONSTRAINT "predefined_task_descriptions_pkey" PRIMARY KEY ("id");
+
+
+--
 -- Name: project_activities project_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
@@ -2199,6 +2245,14 @@ ALTER TABLE ONLY "password_reset"
 
 
 --
+-- Name: predefined_task_descriptions predefined_task_descriptions_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
+--
+
+ALTER TABLE ONLY "predefined_task_descriptions"
+    ADD CONSTRAINT "predefined_task_descriptions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
+
+
+--
 -- Name: project_activities project_activities_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
@@ -2550,8 +2604,8 @@ ALTER TABLE ONLY "user_has_unread_notifications"
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.6.1
--- Dumped by pg_dump version 9.6.1
+-- Dumped from database version 9.6.4
+-- Dumped by pg_dump version 9.6.4
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -2571,8 +2625,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_high
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_public_refresh_interval', '60', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_private_refresh_interval', '10', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_columns', '', 0, 0);
-INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', 'd5afda7f7444f8600138b276ae9a3d1e36781c3111ed35a55fc1a3ca3ff5', 0, 0);
-INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '8814fa59e03411e82772826d166f5cf444324efefcf334ae64b4921d53f3', 0, 0);
+INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '4068b2e47aafbe0d16602d53b1a9f02466b4f9ff89a94858af9e9f959b92', 0, 0);
+INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '0f9e776201c7e58f8b3c3867af69e91548e4eb887563c053e76162b9464e', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_language', 'en_US', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_timezone', 'UTC', 0, 0);
 INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_url', '', 0, 0);
@@ -2600,8 +2654,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('password_r
 -- PostgreSQL database dump
 --
 
--- Dumped from database version 9.6.1
--- Dumped by pg_dump version 9.6.1
+-- Dumped from database version 9.6.4
+-- Dumped by pg_dump version 9.6.4
 
 SET statement_timeout = 0;
 SET lock_timeout = 0;
@@ -2641,4 +2695,4 @@ SELECT pg_catalog.setval('links_id_seq', 11, true);
 -- PostgreSQL database dump complete
 --
 
-INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$0WR8YPAwOCrDQTRFjji6u.krMgA4PcVsmw3ypmXAkqFKFLwnFOpAG', 'app-admin');INSERT INTO schema_version VALUES ('102');
+INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$6sRRMAp4Iu4UQiH.4aIAC.ExaWKfF0192hke5JheV.4hLIhhrbW1C', 'app-admin');INSERT INTO schema_version VALUES ('105');