From 63a460724dbb3996e4c7c6790b0ec271eb5f99f5 Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Mon, 20 Feb 2017 22:11:15 -0500 Subject: Update SQL dumps --- app/Schema/Sql/mysql.sql | 12 ++++++------ app/Schema/Sql/postgres.sql | 18 ++++++++++++------ 2 files changed, 18 insertions(+), 12 deletions(-) (limited to 'app/Schema') diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index f8a2c80a..d861823a 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -393,8 +393,6 @@ CREATE TABLE `projects` ( `is_public` tinyint(1) DEFAULT '0', `is_private` tinyint(1) DEFAULT '0', `is_everybody_allowed` tinyint(1) DEFAULT '0', - `default_swimlane` varchar(200) DEFAULT 'Default swimlane', - `show_default_swimlane` int(11) DEFAULT '1', `description` text, `identifier` varchar(50) DEFAULT '', `start_date` varchar(10) DEFAULT '', @@ -604,7 +602,7 @@ CREATE TABLE `tasks` ( `date_started` bigint(20) DEFAULT NULL, `time_spent` float DEFAULT '0', `time_estimated` float DEFAULT '0', - `swimlane_id` int(11) DEFAULT '0', + `swimlane_id` int(11) NOT NULL, `date_moved` bigint(20) DEFAULT NULL, `recurrence_status` int(11) NOT NULL DEFAULT '0', `recurrence_trigger` int(11) NOT NULL DEFAULT '0', @@ -621,8 +619,10 @@ CREATE TABLE `tasks` ( KEY `column_id` (`column_id`), KEY `tasks_reference_idx` (`reference`), KEY `tasks_project_idx` (`project_id`), + KEY `tasks_swimlane_ibfk_1` (`swimlane_id`), CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE, - CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE + CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`column_id`) REFERENCES `columns` (`id`) ON DELETE CASCADE, + CONSTRAINT `tasks_swimlane_ibfk_1` FOREIGN KEY (`swimlane_id`) REFERENCES `swimlanes` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; DROP TABLE IF EXISTS `transitions`; @@ -751,7 +751,7 @@ CREATE TABLE `users` ( LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; -INSERT INTO `settings` VALUES ('api_token','864a110558759aa439bce24b9ecd6ef3beadc06ecc167aaa01106f3cd872',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','14ff430cbc64fa931040553fda6580778dd04541a5ecfc045a836a51f421',0,0),('webhook_url','',0,0); +INSERT INTO `settings` VALUES ('api_token','af0d1f150c4f64ad61dcfdd28d5544c767656994c05bce919ca4c78ab704',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','9dc22b7faf57e4a9978c7ee30ce7ff85763fe3ebe5d595967a283610a321',0,0),('webhook_url','',0,0); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -780,4 +780,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$Pq1KoC3G3bH/MUrwzwl3l.ZcAM4k99yLhGoX0XLXrTvcdySMisBC2', 'app-admin');INSERT INTO schema_version VALUES ('121'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$rArU1OPUgo7QhObLvFaq1.d7FlIaC4XEsBBWLxIfifNJapk9h71uO', 'app-admin');INSERT INTO schema_version VALUES ('122'); diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql index 7d851e63..c4310963 100644 --- a/app/Schema/Sql/postgres.sql +++ b/app/Schema/Sql/postgres.sql @@ -707,8 +707,6 @@ CREATE TABLE "projects" ( "is_public" boolean DEFAULT false, "is_private" boolean DEFAULT false, "is_everybody_allowed" boolean DEFAULT false, - "default_swimlane" character varying(200) DEFAULT 'Default swimlane'::character varying, - "show_default_swimlane" boolean DEFAULT true, "description" "text", "identifier" character varying(50) DEFAULT ''::character varying, "start_date" character varying(10) DEFAULT ''::character varying, @@ -1077,7 +1075,7 @@ CREATE TABLE "tasks" ( "date_started" bigint, "time_spent" double precision DEFAULT 0, "time_estimated" double precision DEFAULT 0, - "swimlane_id" integer DEFAULT 0, + "swimlane_id" integer NOT NULL, "date_moved" bigint DEFAULT 0, "recurrence_status" integer DEFAULT 0 NOT NULL, "recurrence_trigger" integer DEFAULT 0 NOT NULL, @@ -2455,6 +2453,14 @@ ALTER TABLE ONLY "tasks" ADD CONSTRAINT "tasks_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +-- +-- Name: tasks tasks_swimlane_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY "tasks" + ADD CONSTRAINT "tasks_swimlane_id_fkey" FOREIGN KEY ("swimlane_id") REFERENCES "swimlanes"("id") ON DELETE CASCADE; + + -- -- Name: transitions transitions_dst_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- @@ -2564,8 +2570,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', 'caef28d453c52e4fdc0fd4ce4456698e242d839b496cc1fc580b291b7b47', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', 'ca7200b622dc8483622f83088ccc5c337fce75b6ce2d8f33f92e391a1348', 0, 0); +INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', 'eb478afd6da3ca2b1bda2e5ef2b47d83f0ebdeef5cdebc02e01d5b568835', 0, 0); +INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '32cf0d4f136c1adffb9475b9a4c910f3231dcac5c44777eb467f0e714e51', 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); @@ -2634,4 +2640,4 @@ SELECT pg_catalog.setval('links_id_seq', 11, true); -- PostgreSQL database dump complete -- -INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$Pq1KoC3G3bH/MUrwzwl3l.ZcAM4k99yLhGoX0XLXrTvcdySMisBC2', 'app-admin');INSERT INTO schema_version VALUES ('100'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$rArU1OPUgo7QhObLvFaq1.d7FlIaC4XEsBBWLxIfifNJapk9h71uO', 'app-admin');INSERT INTO schema_version VALUES ('101'); -- cgit v1.2.3