diff options
| author | Frédéric Guillot <fred@kanboard.net> | 2018-12-19 16:01:50 -0800 |
|---|---|---|
| committer | Frédéric Guillot <fred@kanboard.net> | 2018-12-19 16:01:50 -0800 |
| commit | f070ad87d6ff33b5fb18fa13463955d93cf08a4d (patch) | |
| tree | f8a25e2ce31821e34ed89efd17db5de7701d22e3 | |
| parent | 5238f0bc99ad693ab1af69f4eff6d08facf4cb5e (diff) | |
Update SQL dumps
| -rw-r--r-- | Makefile | 4 | ||||
| -rw-r--r-- | app/Schema/Sql/mysql.sql | 6 | ||||
| -rw-r--r-- | app/Schema/Sql/postgres.sql | 814 |
3 files changed, 427 insertions, 397 deletions
@@ -53,7 +53,7 @@ integration-test-sqlite: @ docker-compose -f tests/docker/compose.integration.sqlite.yaml down sql: - @ pg_dump --schema-only --no-owner --no-privileges --quote-all-identifiers -n public --file app/Schema/Sql/postgres.sql kanboard + @ pg_dump -x -O --schema-only --no-owner --no-privileges --quote-all-identifiers -n public --file app/Schema/Sql/postgres.sql kanboard @ pg_dump -d kanboard --column-inserts --data-only --table settings >> app/Schema/Sql/postgres.sql @ pg_dump -d kanboard --column-inserts --data-only --table links >> app/Schema/Sql/postgres.sql @@ -61,7 +61,7 @@ sql: @ mysqldump -uroot --quote-names --no-create-info --skip-comments --no-set-names kanboard settings >> app/Schema/Sql/mysql.sql @ mysqldump -uroot --quote-names --no-create-info --skip-comments --no-set-names kanboard links >> app/Schema/Sql/mysql.sql - @ php -r "echo 'INSERT INTO users (username, password, role) VALUES (\'admin\', \''.password_hash('admin', PASSWORD_DEFAULT).'\', \'app-admin\');';" | \ + @ php -r "echo 'INSERT INTO users (username, password, role) VALUES (\'admin\', \''.password_hash('admin', PASSWORD_DEFAULT).'\', \'app-admin\');'.PHP_EOL;" | \ tee -a app/Schema/Sql/postgres.sql app/Schema/Sql/mysql.sql >/dev/null @ let mysql_version=`echo 'select version from schema_version;' | mysql -N -uroot kanboard` ;\ diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index 9cd7c19e..1c46ed58 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -459,7 +459,7 @@ DROP TABLE IF EXISTS `settings`; SET character_set_client = utf8mb4 ; CREATE TABLE `settings` ( `option` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, - `value` text COLLATE utf8mb4_unicode_ci, + `value` mediumtext COLLATE utf8mb4_unicode_ci, `changed_by` int(11) NOT NULL DEFAULT '0', `changed_on` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`option`) @@ -778,7 +778,7 @@ CREATE TABLE `users` ( LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; -INSERT INTO `settings` VALUES ('api_token','e9b892140931a1b5deb2ab4a5347a65b985ca766c79956e6733529697708',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','25b8b8204e355c76e47df6205abfad3925898eaa709a289342bbafa1df87',0,0),('webhook_url','',0,0); +INSERT INTO `settings` VALUES ('api_token','0fde96ab43568a586f9e4ab95e6a38e7a955dcc6124a073f023e951a4197',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','b652b0d2d3e086025f8c3b6797f571b2139ea7bbfdca534f680ba7e41a32',0,0),('webhook_url','',0,0); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -807,5 +807,5 @@ 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$I5O18nLDOZ436DXzIRZal.ArrFe69gSMoegHDwV.8lChQHz6K4Kku', 'app-admin'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$GzDCeQl/GdH.pCZfz4fWdO3qmayutRCmxEIY9U9t1k9q9F89VNDCm', 'app-admin'); INSERT INTO schema_version VALUES ('133'); diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql index b964cce2..f1810ca3 100644 --- a/app/Schema/Sql/postgres.sql +++ b/app/Schema/Sql/postgres.sql @@ -2,13 +2,14 @@ -- PostgreSQL database dump -- --- Dumped from database version 9.6.3 --- Dumped by pg_dump version 9.6.3 +-- Dumped from database version 10.5 +-- Dumped by pg_dump version 10.5 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; +SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; @@ -20,8 +21,6 @@ SET row_security = off; COMMENT ON SCHEMA "public" IS 'standard public schema'; -SET search_path = "public", pg_catalog; - SET default_tablespace = ''; SET default_with_oids = false; @@ -30,7 +29,7 @@ SET default_with_oids = false; -- Name: action_has_params; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "action_has_params" ( +CREATE TABLE "public"."action_has_params" ( "id" integer NOT NULL, "action_id" integer NOT NULL, "name" "text" NOT NULL, @@ -42,7 +41,8 @@ CREATE TABLE "action_has_params" ( -- Name: action_has_params_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "action_has_params_id_seq" +CREATE SEQUENCE "public"."action_has_params_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -54,14 +54,14 @@ CREATE SEQUENCE "action_has_params_id_seq" -- Name: action_has_params_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "action_has_params_id_seq" OWNED BY "action_has_params"."id"; +ALTER SEQUENCE "public"."action_has_params_id_seq" OWNED BY "public"."action_has_params"."id"; -- -- Name: actions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "actions" ( +CREATE TABLE "public"."actions" ( "id" integer NOT NULL, "project_id" integer NOT NULL, "event_name" "text" NOT NULL, @@ -73,7 +73,8 @@ CREATE TABLE "actions" ( -- Name: actions_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "actions_id_seq" +CREATE SEQUENCE "public"."actions_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -85,14 +86,14 @@ CREATE SEQUENCE "actions_id_seq" -- Name: actions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "actions_id_seq" OWNED BY "actions"."id"; +ALTER SEQUENCE "public"."actions_id_seq" OWNED BY "public"."actions"."id"; -- -- Name: column_has_move_restrictions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "column_has_move_restrictions" ( +CREATE TABLE "public"."column_has_move_restrictions" ( "restriction_id" integer NOT NULL, "project_id" integer NOT NULL, "role_id" integer NOT NULL, @@ -106,7 +107,8 @@ CREATE TABLE "column_has_move_restrictions" ( -- Name: column_has_move_restrictions_restriction_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "column_has_move_restrictions_restriction_id_seq" +CREATE SEQUENCE "public"."column_has_move_restrictions_restriction_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -118,14 +120,14 @@ CREATE SEQUENCE "column_has_move_restrictions_restriction_id_seq" -- Name: column_has_move_restrictions_restriction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "column_has_move_restrictions_restriction_id_seq" OWNED BY "column_has_move_restrictions"."restriction_id"; +ALTER SEQUENCE "public"."column_has_move_restrictions_restriction_id_seq" OWNED BY "public"."column_has_move_restrictions"."restriction_id"; -- -- Name: column_has_restrictions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "column_has_restrictions" ( +CREATE TABLE "public"."column_has_restrictions" ( "restriction_id" integer NOT NULL, "project_id" integer NOT NULL, "role_id" integer NOT NULL, @@ -138,7 +140,8 @@ CREATE TABLE "column_has_restrictions" ( -- Name: column_has_restrictions_restriction_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "column_has_restrictions_restriction_id_seq" +CREATE SEQUENCE "public"."column_has_restrictions_restriction_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -150,14 +153,14 @@ CREATE SEQUENCE "column_has_restrictions_restriction_id_seq" -- Name: column_has_restrictions_restriction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "column_has_restrictions_restriction_id_seq" OWNED BY "column_has_restrictions"."restriction_id"; +ALTER SEQUENCE "public"."column_has_restrictions_restriction_id_seq" OWNED BY "public"."column_has_restrictions"."restriction_id"; -- -- Name: columns; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "columns" ( +CREATE TABLE "public"."columns" ( "id" integer NOT NULL, "title" character varying(255) NOT NULL, "position" integer, @@ -172,7 +175,8 @@ CREATE TABLE "columns" ( -- Name: columns_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "columns_id_seq" +CREATE SEQUENCE "public"."columns_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -184,14 +188,14 @@ CREATE SEQUENCE "columns_id_seq" -- Name: columns_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "columns_id_seq" OWNED BY "columns"."id"; +ALTER SEQUENCE "public"."columns_id_seq" OWNED BY "public"."columns"."id"; -- -- Name: comments; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "comments" ( +CREATE TABLE "public"."comments" ( "id" integer NOT NULL, "task_id" integer NOT NULL, "user_id" integer DEFAULT 0, @@ -206,7 +210,8 @@ CREATE TABLE "comments" ( -- Name: comments_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "comments_id_seq" +CREATE SEQUENCE "public"."comments_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -218,14 +223,14 @@ CREATE SEQUENCE "comments_id_seq" -- Name: comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "comments_id_seq" OWNED BY "comments"."id"; +ALTER SEQUENCE "public"."comments_id_seq" OWNED BY "public"."comments"."id"; -- -- Name: currencies; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "currencies" ( +CREATE TABLE "public"."currencies" ( "currency" character(3) NOT NULL, "rate" real DEFAULT 0 ); @@ -235,7 +240,7 @@ CREATE TABLE "currencies" ( -- Name: custom_filters; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "custom_filters" ( +CREATE TABLE "public"."custom_filters" ( "id" integer NOT NULL, "filter" "text" NOT NULL, "project_id" integer NOT NULL, @@ -250,7 +255,8 @@ CREATE TABLE "custom_filters" ( -- Name: custom_filters_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "custom_filters_id_seq" +CREATE SEQUENCE "public"."custom_filters_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -262,14 +268,14 @@ CREATE SEQUENCE "custom_filters_id_seq" -- Name: custom_filters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "custom_filters_id_seq" OWNED BY "custom_filters"."id"; +ALTER SEQUENCE "public"."custom_filters_id_seq" OWNED BY "public"."custom_filters"."id"; -- -- Name: group_has_users; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "group_has_users" ( +CREATE TABLE "public"."group_has_users" ( "group_id" integer NOT NULL, "user_id" integer NOT NULL ); @@ -279,7 +285,7 @@ CREATE TABLE "group_has_users" ( -- Name: groups; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "groups" ( +CREATE TABLE "public"."groups" ( "id" integer NOT NULL, "external_id" character varying(255) DEFAULT ''::character varying, "name" "text" NOT NULL @@ -290,7 +296,8 @@ CREATE TABLE "groups" ( -- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "groups_id_seq" +CREATE SEQUENCE "public"."groups_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -302,14 +309,14 @@ CREATE SEQUENCE "groups_id_seq" -- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "groups_id_seq" OWNED BY "groups"."id"; +ALTER SEQUENCE "public"."groups_id_seq" OWNED BY "public"."groups"."id"; -- -- Name: invites; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "invites" ( +CREATE TABLE "public"."invites" ( "email" character varying(255) NOT NULL, "project_id" integer NOT NULL, "token" character varying(255) NOT NULL @@ -320,7 +327,7 @@ CREATE TABLE "invites" ( -- Name: last_logins; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "last_logins" ( +CREATE TABLE "public"."last_logins" ( "id" integer NOT NULL, "auth_type" character varying(25), "user_id" integer, @@ -334,7 +341,8 @@ CREATE TABLE "last_logins" ( -- Name: last_logins_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "last_logins_id_seq" +CREATE SEQUENCE "public"."last_logins_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -346,14 +354,14 @@ CREATE SEQUENCE "last_logins_id_seq" -- Name: last_logins_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "last_logins_id_seq" OWNED BY "last_logins"."id"; +ALTER SEQUENCE "public"."last_logins_id_seq" OWNED BY "public"."last_logins"."id"; -- -- Name: links; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "links" ( +CREATE TABLE "public"."links" ( "id" integer NOT NULL, "label" character varying(255) NOT NULL, "opposite_id" integer DEFAULT 0 @@ -364,7 +372,8 @@ CREATE TABLE "links" ( -- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "links_id_seq" +CREATE SEQUENCE "public"."links_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -376,14 +385,14 @@ CREATE SEQUENCE "links_id_seq" -- Name: links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "links_id_seq" OWNED BY "links"."id"; +ALTER SEQUENCE "public"."links_id_seq" OWNED BY "public"."links"."id"; -- -- Name: password_reset; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "password_reset" ( +CREATE TABLE "public"."password_reset" ( "token" character varying(80) NOT NULL, "user_id" integer NOT NULL, "date_expiration" integer NOT NULL, @@ -398,7 +407,7 @@ CREATE TABLE "password_reset" ( -- Name: plugin_schema_versions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "plugin_schema_versions" ( +CREATE TABLE "public"."plugin_schema_versions" ( "plugin" character varying(80) NOT NULL, "version" integer DEFAULT 0 NOT NULL ); @@ -408,7 +417,7 @@ CREATE TABLE "plugin_schema_versions" ( -- Name: predefined_task_descriptions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "predefined_task_descriptions" ( +CREATE TABLE "public"."predefined_task_descriptions" ( "id" integer NOT NULL, "project_id" integer NOT NULL, "title" "text" NOT NULL, @@ -420,7 +429,8 @@ CREATE TABLE "predefined_task_descriptions" ( -- Name: predefined_task_descriptions_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "predefined_task_descriptions_id_seq" +CREATE SEQUENCE "public"."predefined_task_descriptions_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -432,14 +442,14 @@ CREATE SEQUENCE "predefined_task_descriptions_id_seq" -- 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"; +ALTER SEQUENCE "public"."predefined_task_descriptions_id_seq" OWNED BY "public"."predefined_task_descriptions"."id"; -- -- Name: project_activities; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_activities" ( +CREATE TABLE "public"."project_activities" ( "id" integer NOT NULL, "date_creation" bigint NOT NULL, "event_name" "text" NOT NULL, @@ -454,7 +464,8 @@ CREATE TABLE "project_activities" ( -- Name: project_activities_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_activities_id_seq" +CREATE SEQUENCE "public"."project_activities_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -466,14 +477,14 @@ CREATE SEQUENCE "project_activities_id_seq" -- Name: project_activities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_activities_id_seq" OWNED BY "project_activities"."id"; +ALTER SEQUENCE "public"."project_activities_id_seq" OWNED BY "public"."project_activities"."id"; -- -- Name: project_daily_column_stats; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_daily_column_stats" ( +CREATE TABLE "public"."project_daily_column_stats" ( "id" integer NOT NULL, "day" character(10) NOT NULL, "project_id" integer NOT NULL, @@ -487,7 +498,7 @@ CREATE TABLE "project_daily_column_stats" ( -- Name: project_daily_stats; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_daily_stats" ( +CREATE TABLE "public"."project_daily_stats" ( "id" integer NOT NULL, "day" character(10) NOT NULL, "project_id" integer NOT NULL, @@ -500,7 +511,8 @@ CREATE TABLE "project_daily_stats" ( -- Name: project_daily_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_daily_stats_id_seq" +CREATE SEQUENCE "public"."project_daily_stats_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -512,14 +524,15 @@ CREATE SEQUENCE "project_daily_stats_id_seq" -- Name: project_daily_stats_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_daily_stats_id_seq" OWNED BY "project_daily_stats"."id"; +ALTER SEQUENCE "public"."project_daily_stats_id_seq" OWNED BY "public"."project_daily_stats"."id"; -- -- Name: project_daily_summaries_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_daily_summaries_id_seq" +CREATE SEQUENCE "public"."project_daily_summaries_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -531,19 +544,19 @@ CREATE SEQUENCE "project_daily_summaries_id_seq" -- Name: project_daily_summaries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_daily_summaries_id_seq" OWNED BY "project_daily_column_stats"."id"; +ALTER SEQUENCE "public"."project_daily_summaries_id_seq" OWNED BY "public"."project_daily_column_stats"."id"; -- -- Name: project_has_categories; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_categories" ( +CREATE TABLE "public"."project_has_categories" ( "id" integer NOT NULL, "name" character varying(255) NOT NULL, "project_id" integer NOT NULL, "description" "text", - "color_id" character varying(255) + "color_id" character varying(50) DEFAULT NULL::character varying ); @@ -551,7 +564,8 @@ CREATE TABLE "project_has_categories" ( -- Name: project_has_categories_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_has_categories_id_seq" +CREATE SEQUENCE "public"."project_has_categories_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -563,14 +577,14 @@ CREATE SEQUENCE "project_has_categories_id_seq" -- Name: project_has_categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_has_categories_id_seq" OWNED BY "project_has_categories"."id"; +ALTER SEQUENCE "public"."project_has_categories_id_seq" OWNED BY "public"."project_has_categories"."id"; -- -- Name: project_has_files; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_files" ( +CREATE TABLE "public"."project_has_files" ( "id" integer NOT NULL, "project_id" integer NOT NULL, "name" "text" NOT NULL, @@ -586,7 +600,8 @@ CREATE TABLE "project_has_files" ( -- Name: project_has_files_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_has_files_id_seq" +CREATE SEQUENCE "public"."project_has_files_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -598,14 +613,14 @@ CREATE SEQUENCE "project_has_files_id_seq" -- Name: project_has_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_has_files_id_seq" OWNED BY "project_has_files"."id"; +ALTER SEQUENCE "public"."project_has_files_id_seq" OWNED BY "public"."project_has_files"."id"; -- -- Name: project_has_groups; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_groups" ( +CREATE TABLE "public"."project_has_groups" ( "group_id" integer NOT NULL, "project_id" integer NOT NULL, "role" character varying(255) NOT NULL @@ -616,7 +631,7 @@ CREATE TABLE "project_has_groups" ( -- Name: project_has_metadata; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_metadata" ( +CREATE TABLE "public"."project_has_metadata" ( "project_id" integer NOT NULL, "name" character varying(50) NOT NULL, "value" character varying(255) DEFAULT ''::character varying, @@ -629,7 +644,7 @@ CREATE TABLE "project_has_metadata" ( -- Name: project_has_notification_types; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_notification_types" ( +CREATE TABLE "public"."project_has_notification_types" ( "id" integer NOT NULL, "project_id" integer NOT NULL, "notification_type" character varying(50) NOT NULL @@ -640,7 +655,8 @@ CREATE TABLE "project_has_notification_types" ( -- Name: project_has_notification_types_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_has_notification_types_id_seq" +CREATE SEQUENCE "public"."project_has_notification_types_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -652,14 +668,14 @@ CREATE SEQUENCE "project_has_notification_types_id_seq" -- Name: project_has_notification_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_has_notification_types_id_seq" OWNED BY "project_has_notification_types"."id"; +ALTER SEQUENCE "public"."project_has_notification_types_id_seq" OWNED BY "public"."project_has_notification_types"."id"; -- -- Name: project_has_roles; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_roles" ( +CREATE TABLE "public"."project_has_roles" ( "role_id" integer NOT NULL, "role" character varying(255) NOT NULL, "project_id" integer NOT NULL @@ -670,7 +686,8 @@ CREATE TABLE "project_has_roles" ( -- Name: project_has_roles_role_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_has_roles_role_id_seq" +CREATE SEQUENCE "public"."project_has_roles_role_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -682,14 +699,14 @@ CREATE SEQUENCE "project_has_roles_role_id_seq" -- Name: project_has_roles_role_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_has_roles_role_id_seq" OWNED BY "project_has_roles"."role_id"; +ALTER SEQUENCE "public"."project_has_roles_role_id_seq" OWNED BY "public"."project_has_roles"."role_id"; -- -- Name: project_has_users; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_has_users" ( +CREATE TABLE "public"."project_has_users" ( "project_id" integer NOT NULL, "user_id" integer NOT NULL, "role" character varying(255) DEFAULT 'project-viewer'::character varying NOT NULL @@ -700,7 +717,7 @@ CREATE TABLE "project_has_users" ( -- Name: project_role_has_restrictions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "project_role_has_restrictions" ( +CREATE TABLE "public"."project_role_has_restrictions" ( "restriction_id" integer NOT NULL, "project_id" integer NOT NULL, "role_id" integer NOT NULL, @@ -712,7 +729,8 @@ CREATE TABLE "project_role_has_restrictions" ( -- Name: project_role_has_restrictions_restriction_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "project_role_has_restrictions_restriction_id_seq" +CREATE SEQUENCE "public"."project_role_has_restrictions_restriction_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -724,14 +742,14 @@ CREATE SEQUENCE "project_role_has_restrictions_restriction_id_seq" -- Name: project_role_has_restrictions_restriction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "project_role_has_restrictions_restriction_id_seq" OWNED BY "project_role_has_restrictions"."restriction_id"; +ALTER SEQUENCE "public"."project_role_has_restrictions_restriction_id_seq" OWNED BY "public"."project_role_has_restrictions"."restriction_id"; -- -- Name: projects; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "projects" ( +CREATE TABLE "public"."projects" ( "id" integer NOT NULL, "name" "text" NOT NULL, "is_active" boolean DEFAULT true, @@ -756,7 +774,8 @@ CREATE TABLE "projects" ( -- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "projects_id_seq" +CREATE SEQUENCE "public"."projects_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -768,14 +787,14 @@ CREATE SEQUENCE "projects_id_seq" -- Name: projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "projects_id_seq" OWNED BY "projects"."id"; +ALTER SEQUENCE "public"."projects_id_seq" OWNED BY "public"."projects"."id"; -- -- Name: remember_me; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "remember_me" ( +CREATE TABLE "public"."remember_me" ( "id" integer NOT NULL, "user_id" integer, "ip" character varying(45), @@ -791,7 +810,8 @@ CREATE TABLE "remember_me" ( -- Name: remember_me_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "remember_me_id_seq" +CREATE SEQUENCE "public"."remember_me_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -803,14 +823,14 @@ CREATE SEQUENCE "remember_me_id_seq" -- Name: remember_me_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "remember_me_id_seq" OWNED BY "remember_me"."id"; +ALTER SEQUENCE "public"."remember_me_id_seq" OWNED BY "public"."remember_me"."id"; -- -- Name: schema_version; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "schema_version" ( +CREATE TABLE "public"."schema_version" ( "version" integer DEFAULT 0 ); @@ -819,7 +839,7 @@ CREATE TABLE "schema_version" ( -- Name: sessions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "sessions" ( +CREATE TABLE "public"."sessions" ( "id" "text" NOT NULL, "expire_at" integer NOT NULL, "data" "text" DEFAULT ''::"text" @@ -830,7 +850,7 @@ CREATE TABLE "sessions" ( -- Name: settings; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "settings" ( +CREATE TABLE "public"."settings" ( "option" character varying(100) NOT NULL, "value" "text" DEFAULT ''::character varying, "changed_by" integer DEFAULT 0 NOT NULL, @@ -842,7 +862,7 @@ CREATE TABLE "settings" ( -- Name: subtask_time_tracking; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "subtask_time_tracking" ( +CREATE TABLE "public"."subtask_time_tracking" ( "id" integer NOT NULL, "user_id" integer NOT NULL, "subtask_id" integer NOT NULL, @@ -856,7 +876,8 @@ CREATE TABLE "subtask_time_tracking" ( -- Name: subtask_time_tracking_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "subtask_time_tracking_id_seq" +CREATE SEQUENCE "public"."subtask_time_tracking_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -868,14 +889,14 @@ CREATE SEQUENCE "subtask_time_tracking_id_seq" -- Name: subtask_time_tracking_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "subtask_time_tracking_id_seq" OWNED BY "subtask_time_tracking"."id"; +ALTER SEQUENCE "public"."subtask_time_tracking_id_seq" OWNED BY "public"."subtask_time_tracking"."id"; -- -- Name: subtasks; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "subtasks" ( +CREATE TABLE "public"."subtasks" ( "id" integer NOT NULL, "title" "text" NOT NULL, "status" smallint DEFAULT 0, @@ -891,7 +912,7 @@ CREATE TABLE "subtasks" ( -- Name: swimlanes; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "swimlanes" ( +CREATE TABLE "public"."swimlanes" ( "id" integer NOT NULL, "name" "text" NOT NULL, "position" integer DEFAULT 1, @@ -905,7 +926,8 @@ CREATE TABLE "swimlanes" ( -- Name: swimlanes_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "swimlanes_id_seq" +CREATE SEQUENCE "public"."swimlanes_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -917,18 +939,18 @@ CREATE SEQUENCE "swimlanes_id_seq" -- Name: swimlanes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "swimlanes_id_seq" OWNED BY "swimlanes"."id"; +ALTER SEQUENCE "public"."swimlanes_id_seq" OWNED BY "public"."swimlanes"."id"; -- -- Name: tags; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "tags" ( +CREATE TABLE "public"."tags" ( "id" integer NOT NULL, "name" character varying(255) NOT NULL, "project_id" integer NOT NULL, - "color_id" character varying(255) + "color_id" character varying(50) DEFAULT NULL::character varying ); @@ -936,7 +958,8 @@ CREATE TABLE "tags" ( -- Name: tags_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "tags_id_seq" +CREATE SEQUENCE "public"."tags_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -948,14 +971,14 @@ CREATE SEQUENCE "tags_id_seq" -- Name: tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "tags_id_seq" OWNED BY "tags"."id"; +ALTER SEQUENCE "public"."tags_id_seq" OWNED BY "public"."tags"."id"; -- -- Name: task_has_external_links; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "task_has_external_links" ( +CREATE TABLE "public"."task_has_external_links" ( "id" integer NOT NULL, "link_type" character varying(100) NOT NULL, "dependency" character varying(100) NOT NULL, @@ -972,7 +995,8 @@ CREATE TABLE "task_has_external_links" ( -- Name: task_has_external_links_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "task_has_external_links_id_seq" +CREATE SEQUENCE "public"."task_has_external_links_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -984,14 +1008,14 @@ CREATE SEQUENCE "task_has_external_links_id_seq" -- Name: task_has_external_links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "task_has_external_links_id_seq" OWNED BY "task_has_external_links"."id"; +ALTER SEQUENCE "public"."task_has_external_links_id_seq" OWNED BY "public"."task_has_external_links"."id"; -- -- Name: task_has_files; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "task_has_files" ( +CREATE TABLE "public"."task_has_files" ( "id" integer NOT NULL, "name" "text" NOT NULL, "path" "text", @@ -1007,7 +1031,8 @@ CREATE TABLE "task_has_files" ( -- Name: task_has_files_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "task_has_files_id_seq" +CREATE SEQUENCE "public"."task_has_files_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1019,14 +1044,14 @@ CREATE SEQUENCE "task_has_files_id_seq" -- Name: task_has_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "task_has_files_id_seq" OWNED BY "task_has_files"."id"; +ALTER SEQUENCE "public"."task_has_files_id_seq" OWNED BY "public"."task_has_files"."id"; -- -- Name: task_has_links; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "task_has_links" ( +CREATE TABLE "public"."task_has_links" ( "id" integer NOT NULL, "link_id" integer NOT NULL, "task_id" integer NOT NULL, @@ -1038,7 +1063,8 @@ CREATE TABLE "task_has_links" ( -- Name: task_has_links_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "task_has_links_id_seq" +CREATE SEQUENCE "public"."task_has_links_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1050,14 +1076,14 @@ CREATE SEQUENCE "task_has_links_id_seq" -- Name: task_has_links_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "task_has_links_id_seq" OWNED BY "task_has_links"."id"; +ALTER SEQUENCE "public"."task_has_links_id_seq" OWNED BY "public"."task_has_links"."id"; -- -- Name: task_has_metadata; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "task_has_metadata" ( +CREATE TABLE "public"."task_has_metadata" ( "task_id" integer NOT NULL, "name" character varying(50) NOT NULL, "value" character varying(255) DEFAULT ''::character varying, @@ -1070,7 +1096,8 @@ CREATE TABLE "task_has_metadata" ( -- Name: task_has_subtasks_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "task_has_subtasks_id_seq" +CREATE SEQUENCE "public"."task_has_subtasks_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1082,14 +1109,14 @@ CREATE SEQUENCE "task_has_subtasks_id_seq" -- Name: task_has_subtasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "task_has_subtasks_id_seq" OWNED BY "subtasks"."id"; +ALTER SEQUENCE "public"."task_has_subtasks_id_seq" OWNED BY "public"."subtasks"."id"; -- -- Name: task_has_tags; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "task_has_tags" ( +CREATE TABLE "public"."task_has_tags" ( "task_id" integer NOT NULL, "tag_id" integer NOT NULL ); @@ -1099,7 +1126,7 @@ CREATE TABLE "task_has_tags" ( -- Name: tasks; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "tasks" ( +CREATE TABLE "public"."tasks" ( "id" integer NOT NULL, "title" "text" NOT NULL, "description" "text", @@ -1139,7 +1166,8 @@ CREATE TABLE "tasks" ( -- Name: tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "tasks_id_seq" +CREATE SEQUENCE "public"."tasks_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1151,14 +1179,14 @@ CREATE SEQUENCE "tasks_id_seq" -- Name: tasks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "tasks_id_seq" OWNED BY "tasks"."id"; +ALTER SEQUENCE "public"."tasks_id_seq" OWNED BY "public"."tasks"."id"; -- -- Name: transitions; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "transitions" ( +CREATE TABLE "public"."transitions" ( "id" integer NOT NULL, "user_id" integer NOT NULL, "project_id" integer NOT NULL, @@ -1174,7 +1202,8 @@ CREATE TABLE "transitions" ( -- Name: transitions_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "transitions_id_seq" +CREATE SEQUENCE "public"."transitions_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1186,14 +1215,14 @@ CREATE SEQUENCE "transitions_id_seq" -- Name: transitions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "transitions_id_seq" OWNED BY "transitions"."id"; +ALTER SEQUENCE "public"."transitions_id_seq" OWNED BY "public"."transitions"."id"; -- -- Name: user_has_metadata; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "user_has_metadata" ( +CREATE TABLE "public"."user_has_metadata" ( "user_id" integer NOT NULL, "name" character varying(50) NOT NULL, "value" character varying(255) DEFAULT ''::character varying, @@ -1206,7 +1235,7 @@ CREATE TABLE "user_has_metadata" ( -- Name: user_has_notification_types; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "user_has_notification_types" ( +CREATE TABLE "public"."user_has_notification_types" ( "id" integer NOT NULL, "user_id" integer NOT NULL, "notification_type" character varying(50) @@ -1217,7 +1246,8 @@ CREATE TABLE "user_has_notification_types" ( -- Name: user_has_notification_types_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "user_has_notification_types_id_seq" +CREATE SEQUENCE "public"."user_has_notification_types_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1229,14 +1259,14 @@ CREATE SEQUENCE "user_has_notification_types_id_seq" -- Name: user_has_notification_types_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "user_has_notification_types_id_seq" OWNED BY "user_has_notification_types"."id"; +ALTER SEQUENCE "public"."user_has_notification_types_id_seq" OWNED BY "public"."user_has_notification_types"."id"; -- -- Name: user_has_notifications; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "user_has_notifications" ( +CREATE TABLE "public"."user_has_notifications" ( "user_id" integer NOT NULL, "project_id" integer ); @@ -1246,7 +1276,7 @@ CREATE TABLE "user_has_notifications" ( -- Name: user_has_unread_notifications; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "user_has_unread_notifications" ( +CREATE TABLE "public"."user_has_unread_notifications" ( "id" integer NOT NULL, "user_id" integer NOT NULL, "date_creation" bigint NOT NULL, @@ -1259,7 +1289,8 @@ CREATE TABLE "user_has_unread_notifications" ( -- Name: user_has_unread_notifications_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "user_has_unread_notifications_id_seq" +CREATE SEQUENCE "public"."user_has_unread_notifications_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1271,14 +1302,14 @@ CREATE SEQUENCE "user_has_unread_notifications_id_seq" -- Name: user_has_unread_notifications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "user_has_unread_notifications_id_seq" OWNED BY "user_has_unread_notifications"."id"; +ALTER SEQUENCE "public"."user_has_unread_notifications_id_seq" OWNED BY "public"."user_has_unread_notifications"."id"; -- -- Name: users; Type: TABLE; Schema: public; Owner: - -- -CREATE TABLE "users" ( +CREATE TABLE "public"."users" ( "id" integer NOT NULL, "username" "text" NOT NULL, "password" character varying(255), @@ -1289,7 +1320,7 @@ CREATE TABLE "users" ( "github_id" character varying(30), "notifications_enabled" boolean DEFAULT false, "timezone" character varying(50), - "language" character varying(5), + "language" character varying(11), "disable_login_form" boolean DEFAULT false, "twofactor_activated" boolean DEFAULT false, "twofactor_secret" character(16), @@ -1310,7 +1341,8 @@ CREATE TABLE "users" ( -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- -CREATE SEQUENCE "users_id_seq" +CREATE SEQUENCE "public"."users_id_seq" + AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE @@ -1322,245 +1354,245 @@ CREATE SEQUENCE "users_id_seq" -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- -ALTER SEQUENCE "users_id_seq" OWNED BY "users"."id"; +ALTER SEQUENCE "public"."users_id_seq" OWNED BY "public"."users"."id"; -- -- Name: action_has_params id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "action_has_params" ALTER COLUMN "id" SET DEFAULT "nextval"('"action_has_params_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."action_has_params" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."action_has_params_id_seq"'::"regclass"); -- -- Name: actions id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "actions" ALTER COLUMN "id" SET DEFAULT "nextval"('"actions_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."actions" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."actions_id_seq"'::"regclass"); -- -- Name: column_has_move_restrictions restriction_id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" ALTER COLUMN "restriction_id" SET DEFAULT "nextval"('"column_has_move_restrictions_restriction_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."column_has_move_restrictions" ALTER COLUMN "restriction_id" SET DEFAULT "nextval"('"public"."column_has_move_restrictions_restriction_id_seq"'::"regclass"); -- -- Name: column_has_restrictions restriction_id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_restrictions" ALTER COLUMN "restriction_id" SET DEFAULT "nextval"('"column_has_restrictions_restriction_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."column_has_restrictions" ALTER COLUMN "restriction_id" SET DEFAULT "nextval"('"public"."column_has_restrictions_restriction_id_seq"'::"regclass"); -- -- Name: columns id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "columns" ALTER COLUMN "id" SET DEFAULT "nextval"('"columns_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."columns" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."columns_id_seq"'::"regclass"); -- -- Name: comments id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "comments" ALTER COLUMN "id" SET DEFAULT "nextval"('"comments_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."comments" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."comments_id_seq"'::"regclass"); -- -- Name: custom_filters id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "custom_filters" ALTER COLUMN "id" SET DEFAULT "nextval"('"custom_filters_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."custom_filters" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."custom_filters_id_seq"'::"regclass"); -- -- Name: groups id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "groups" ALTER COLUMN "id" SET DEFAULT "nextval"('"groups_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."groups" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."groups_id_seq"'::"regclass"); -- -- Name: last_logins id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "last_logins" ALTER COLUMN "id" SET DEFAULT "nextval"('"last_logins_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."last_logins" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."last_logins_id_seq"'::"regclass"); -- -- Name: links id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "links" ALTER COLUMN "id" SET DEFAULT "nextval"('"links_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."links" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."links_id_seq"'::"regclass"); -- -- 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"); +ALTER TABLE ONLY "public"."predefined_task_descriptions" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."predefined_task_descriptions_id_seq"'::"regclass"); -- -- Name: project_activities id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_activities" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_activities_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_activities" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."project_activities_id_seq"'::"regclass"); -- -- Name: project_daily_column_stats id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_column_stats" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_daily_summaries_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_daily_column_stats" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."project_daily_summaries_id_seq"'::"regclass"); -- -- Name: project_daily_stats id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_stats" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_daily_stats_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_daily_stats" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."project_daily_stats_id_seq"'::"regclass"); -- -- Name: project_has_categories id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_categories" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_has_categories_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_has_categories" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."project_has_categories_id_seq"'::"regclass"); -- -- Name: project_has_files id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_files" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_has_files_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_has_files" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."project_has_files_id_seq"'::"regclass"); -- -- Name: project_has_notification_types id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_notification_types" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_has_notification_types_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_has_notification_types" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."project_has_notification_types_id_seq"'::"regclass"); -- -- Name: project_has_roles role_id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_roles" ALTER COLUMN "role_id" SET DEFAULT "nextval"('"project_has_roles_role_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_has_roles" ALTER COLUMN "role_id" SET DEFAULT "nextval"('"public"."project_has_roles_role_id_seq"'::"regclass"); -- -- Name: project_role_has_restrictions restriction_id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_role_has_restrictions" ALTER COLUMN "restriction_id" SET DEFAULT "nextval"('"project_role_has_restrictions_restriction_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."project_role_has_restrictions" ALTER COLUMN "restriction_id" SET DEFAULT "nextval"('"public"."project_role_has_restrictions_restriction_id_seq"'::"regclass"); -- -- Name: projects id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "projects" ALTER COLUMN "id" SET DEFAULT "nextval"('"projects_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."projects" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."projects_id_seq"'::"regclass"); -- -- Name: remember_me id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "remember_me" ALTER COLUMN "id" SET DEFAULT "nextval"('"remember_me_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."remember_me" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."remember_me_id_seq"'::"regclass"); -- -- Name: subtask_time_tracking id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtask_time_tracking" ALTER COLUMN "id" SET DEFAULT "nextval"('"subtask_time_tracking_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."subtask_time_tracking" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."subtask_time_tracking_id_seq"'::"regclass"); -- -- Name: subtasks id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtasks" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_subtasks_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."subtasks" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."task_has_subtasks_id_seq"'::"regclass"); -- -- Name: swimlanes id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "swimlanes" ALTER COLUMN "id" SET DEFAULT "nextval"('"swimlanes_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."swimlanes" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."swimlanes_id_seq"'::"regclass"); -- -- Name: tags id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tags" ALTER COLUMN "id" SET DEFAULT "nextval"('"tags_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."tags" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."tags_id_seq"'::"regclass"); -- -- Name: task_has_external_links id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_external_links" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_external_links_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."task_has_external_links" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."task_has_external_links_id_seq"'::"regclass"); -- -- Name: task_has_files id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_files" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_files_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."task_has_files" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."task_has_files_id_seq"'::"regclass"); -- -- Name: task_has_links id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_links" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_links_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."task_has_links" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."task_has_links_id_seq"'::"regclass"); -- -- Name: tasks id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tasks" ALTER COLUMN "id" SET DEFAULT "nextval"('"tasks_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."tasks" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."tasks_id_seq"'::"regclass"); -- -- Name: transitions id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" ALTER COLUMN "id" SET DEFAULT "nextval"('"transitions_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."transitions" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."transitions_id_seq"'::"regclass"); -- -- Name: user_has_notification_types id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_notification_types" ALTER COLUMN "id" SET DEFAULT "nextval"('"user_has_notification_types_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."user_has_notification_types" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."user_has_notification_types_id_seq"'::"regclass"); -- -- Name: user_has_unread_notifications id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_unread_notifications" ALTER COLUMN "id" SET DEFAULT "nextval"('"user_has_unread_notifications_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."user_has_unread_notifications" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."user_has_unread_notifications_id_seq"'::"regclass"); -- -- Name: users id; Type: DEFAULT; Schema: public; Owner: - -- -ALTER TABLE ONLY "users" ALTER COLUMN "id" SET DEFAULT "nextval"('"users_id_seq"'::"regclass"); +ALTER TABLE ONLY "public"."users" ALTER COLUMN "id" SET DEFAULT "nextval"('"public"."users_id_seq"'::"regclass"); -- -- Name: action_has_params action_has_params_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "action_has_params" +ALTER TABLE ONLY "public"."action_has_params" ADD CONSTRAINT "action_has_params_pkey" PRIMARY KEY ("id"); @@ -1568,7 +1600,7 @@ ALTER TABLE ONLY "action_has_params" -- Name: actions actions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "actions" +ALTER TABLE ONLY "public"."actions" ADD CONSTRAINT "actions_pkey" PRIMARY KEY ("id"); @@ -1576,7 +1608,7 @@ ALTER TABLE ONLY "actions" -- Name: column_has_move_restrictions column_has_move_restrictions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" +ALTER TABLE ONLY "public"."column_has_move_restrictions" ADD CONSTRAINT "column_has_move_restrictions_pkey" PRIMARY KEY ("restriction_id"); @@ -1584,7 +1616,7 @@ ALTER TABLE ONLY "column_has_move_restrictions" -- Name: column_has_move_restrictions column_has_move_restrictions_role_id_src_column_id_dst_colu_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" +ALTER TABLE ONLY "public"."column_has_move_restrictions" ADD CONSTRAINT "column_has_move_restrictions_role_id_src_column_id_dst_colu_key" UNIQUE ("role_id", "src_column_id", "dst_column_id"); @@ -1592,7 +1624,7 @@ ALTER TABLE ONLY "column_has_move_restrictions" -- Name: column_has_restrictions column_has_restrictions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_restrictions" +ALTER TABLE ONLY "public"."column_has_restrictions" ADD CONSTRAINT "column_has_restrictions_pkey" PRIMARY KEY ("restriction_id"); @@ -1600,7 +1632,7 @@ ALTER TABLE ONLY "column_has_restrictions" -- Name: column_has_restrictions column_has_restrictions_role_id_column_id_rule_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_restrictions" +ALTER TABLE ONLY "public"."column_has_restrictions" ADD CONSTRAINT "column_has_restrictions_role_id_column_id_rule_key" UNIQUE ("role_id", "column_id", "rule"); @@ -1608,7 +1640,7 @@ ALTER TABLE ONLY "column_has_restrictions" -- Name: columns columns_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "columns" +ALTER TABLE ONLY "public"."columns" ADD CONSTRAINT "columns_pkey" PRIMARY KEY ("id"); @@ -1616,7 +1648,7 @@ ALTER TABLE ONLY "columns" -- Name: columns columns_title_project_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "columns" +ALTER TABLE ONLY "public"."columns" ADD CONSTRAINT "columns_title_project_id_key" UNIQUE ("title", "project_id"); @@ -1624,7 +1656,7 @@ ALTER TABLE ONLY "columns" -- Name: comments comments_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "comments" +ALTER TABLE ONLY "public"."comments" ADD CONSTRAINT "comments_pkey" PRIMARY KEY ("id"); @@ -1632,7 +1664,7 @@ ALTER TABLE ONLY "comments" -- Name: currencies currencies_currency_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "currencies" +ALTER TABLE ONLY "public"."currencies" ADD CONSTRAINT "currencies_currency_key" UNIQUE ("currency"); @@ -1640,7 +1672,7 @@ ALTER TABLE ONLY "currencies" -- Name: custom_filters custom_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "custom_filters" +ALTER TABLE ONLY "public"."custom_filters" ADD CONSTRAINT "custom_filters_pkey" PRIMARY KEY ("id"); @@ -1648,7 +1680,7 @@ ALTER TABLE ONLY "custom_filters" -- Name: group_has_users group_has_users_group_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "group_has_users" +ALTER TABLE ONLY "public"."group_has_users" ADD CONSTRAINT "group_has_users_group_id_user_id_key" UNIQUE ("group_id", "user_id"); @@ -1656,7 +1688,7 @@ ALTER TABLE ONLY "group_has_users" -- Name: groups groups_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "groups" +ALTER TABLE ONLY "public"."groups" ADD CONSTRAINT "groups_name_key" UNIQUE ("name"); @@ -1664,7 +1696,7 @@ ALTER TABLE ONLY "groups" -- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "groups" +ALTER TABLE ONLY "public"."groups" ADD CONSTRAINT "groups_pkey" PRIMARY KEY ("id"); @@ -1672,7 +1704,7 @@ ALTER TABLE ONLY "groups" -- Name: invites invites_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "invites" +ALTER TABLE ONLY "public"."invites" ADD CONSTRAINT "invites_pkey" PRIMARY KEY ("email", "token"); @@ -1680,7 +1712,7 @@ ALTER TABLE ONLY "invites" -- Name: last_logins last_logins_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "last_logins" +ALTER TABLE ONLY "public"."last_logins" ADD CONSTRAINT "last_logins_pkey" PRIMARY KEY ("id"); @@ -1688,7 +1720,7 @@ ALTER TABLE ONLY "last_logins" -- Name: links links_label_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "links" +ALTER TABLE ONLY "public"."links" ADD CONSTRAINT "links_label_key" UNIQUE ("label"); @@ -1696,7 +1728,7 @@ ALTER TABLE ONLY "links" -- Name: links links_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "links" +ALTER TABLE ONLY "public"."links" ADD CONSTRAINT "links_pkey" PRIMARY KEY ("id"); @@ -1704,7 +1736,7 @@ ALTER TABLE ONLY "links" -- Name: password_reset password_reset_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "password_reset" +ALTER TABLE ONLY "public"."password_reset" ADD CONSTRAINT "password_reset_pkey" PRIMARY KEY ("token"); @@ -1712,7 +1744,7 @@ ALTER TABLE ONLY "password_reset" -- Name: plugin_schema_versions plugin_schema_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "plugin_schema_versions" +ALTER TABLE ONLY "public"."plugin_schema_versions" ADD CONSTRAINT "plugin_schema_versions_pkey" PRIMARY KEY ("plugin"); @@ -1720,7 +1752,7 @@ 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" +ALTER TABLE ONLY "public"."predefined_task_descriptions" ADD CONSTRAINT "predefined_task_descriptions_pkey" PRIMARY KEY ("id"); @@ -1728,7 +1760,7 @@ ALTER TABLE ONLY "predefined_task_descriptions" -- Name: project_activities project_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_activities" +ALTER TABLE ONLY "public"."project_activities" ADD CONSTRAINT "project_activities_pkey" PRIMARY KEY ("id"); @@ -1736,7 +1768,7 @@ ALTER TABLE ONLY "project_activities" -- Name: project_daily_stats project_daily_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_stats" +ALTER TABLE ONLY "public"."project_daily_stats" ADD CONSTRAINT "project_daily_stats_pkey" PRIMARY KEY ("id"); @@ -1744,7 +1776,7 @@ ALTER TABLE ONLY "project_daily_stats" -- Name: project_daily_column_stats project_daily_summaries_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_column_stats" +ALTER TABLE ONLY "public"."project_daily_column_stats" ADD CONSTRAINT "project_daily_summaries_pkey" PRIMARY KEY ("id"); @@ -1752,7 +1784,7 @@ ALTER TABLE ONLY "project_daily_column_stats" -- Name: project_has_categories project_has_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_categories" +ALTER TABLE ONLY "public"."project_has_categories" ADD CONSTRAINT "project_has_categories_pkey" PRIMARY KEY ("id"); @@ -1760,7 +1792,7 @@ ALTER TABLE ONLY "project_has_categories" -- Name: project_has_categories project_has_categories_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_categories" +ALTER TABLE ONLY "public"."project_has_categories" ADD CONSTRAINT "project_has_categories_project_id_name_key" UNIQUE ("project_id", "name"); @@ -1768,7 +1800,7 @@ ALTER TABLE ONLY "project_has_categories" -- Name: project_has_files project_has_files_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_files" +ALTER TABLE ONLY "public"."project_has_files" ADD CONSTRAINT "project_has_files_pkey" PRIMARY KEY ("id"); @@ -1776,7 +1808,7 @@ ALTER TABLE ONLY "project_has_files" -- Name: project_has_groups project_has_groups_group_id_project_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_groups" +ALTER TABLE ONLY "public"."project_has_groups" ADD CONSTRAINT "project_has_groups_group_id_project_id_key" UNIQUE ("group_id", "project_id"); @@ -1784,7 +1816,7 @@ ALTER TABLE ONLY "project_has_groups" -- Name: project_has_metadata project_has_metadata_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_metadata" +ALTER TABLE ONLY "public"."project_has_metadata" ADD CONSTRAINT "project_has_metadata_project_id_name_key" UNIQUE ("project_id", "name"); @@ -1792,7 +1824,7 @@ ALTER TABLE ONLY "project_has_metadata" -- Name: project_has_notification_types project_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_notification_types" +ALTER TABLE ONLY "public"."project_has_notification_types" ADD CONSTRAINT "project_has_notification_types_pkey" PRIMARY KEY ("id"); @@ -1800,7 +1832,7 @@ ALTER TABLE ONLY "project_has_notification_types" -- Name: project_has_notification_types project_has_notification_types_project_id_notification_type_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_notification_types" +ALTER TABLE ONLY "public"."project_has_notification_types" ADD CONSTRAINT "project_has_notification_types_project_id_notification_type_key" UNIQUE ("project_id", "notification_type"); @@ -1808,7 +1840,7 @@ ALTER TABLE ONLY "project_has_notification_types" -- Name: project_has_roles project_has_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_roles" +ALTER TABLE ONLY "public"."project_has_roles" ADD CONSTRAINT "project_has_roles_pkey" PRIMARY KEY ("role_id"); @@ -1816,7 +1848,7 @@ ALTER TABLE ONLY "project_has_roles" -- Name: project_has_roles project_has_roles_project_id_role_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_roles" +ALTER TABLE ONLY "public"."project_has_roles" ADD CONSTRAINT "project_has_roles_project_id_role_key" UNIQUE ("project_id", "role"); @@ -1824,7 +1856,7 @@ ALTER TABLE ONLY "project_has_roles" -- Name: project_has_users project_has_users_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_users" +ALTER TABLE ONLY "public"."project_has_users" ADD CONSTRAINT "project_has_users_project_id_user_id_key" UNIQUE ("project_id", "user_id"); @@ -1832,7 +1864,7 @@ ALTER TABLE ONLY "project_has_users" -- Name: project_role_has_restrictions project_role_has_restrictions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_role_has_restrictions" +ALTER TABLE ONLY "public"."project_role_has_restrictions" ADD CONSTRAINT "project_role_has_restrictions_pkey" PRIMARY KEY ("restriction_id"); @@ -1840,7 +1872,7 @@ ALTER TABLE ONLY "project_role_has_restrictions" -- Name: project_role_has_restrictions project_role_has_restrictions_role_id_rule_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_role_has_restrictions" +ALTER TABLE ONLY "public"."project_role_has_restrictions" ADD CONSTRAINT "project_role_has_restrictions_role_id_rule_key" UNIQUE ("role_id", "rule"); @@ -1848,7 +1880,7 @@ ALTER TABLE ONLY "project_role_has_restrictions" -- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "projects" +ALTER TABLE ONLY "public"."projects" ADD CONSTRAINT "projects_pkey" PRIMARY KEY ("id"); @@ -1856,7 +1888,7 @@ ALTER TABLE ONLY "projects" -- Name: remember_me remember_me_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "remember_me" +ALTER TABLE ONLY "public"."remember_me" ADD CONSTRAINT "remember_me_pkey" PRIMARY KEY ("id"); @@ -1864,7 +1896,7 @@ ALTER TABLE ONLY "remember_me" -- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "sessions" +ALTER TABLE ONLY "public"."sessions" ADD CONSTRAINT "sessions_pkey" PRIMARY KEY ("id"); @@ -1872,7 +1904,7 @@ ALTER TABLE ONLY "sessions" -- Name: settings settings_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "settings" +ALTER TABLE ONLY "public"."settings" ADD CONSTRAINT "settings_pkey" PRIMARY KEY ("option"); @@ -1880,7 +1912,7 @@ ALTER TABLE ONLY "settings" -- Name: subtask_time_tracking subtask_time_tracking_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtask_time_tracking" +ALTER TABLE ONLY "public"."subtask_time_tracking" ADD CONSTRAINT "subtask_time_tracking_pkey" PRIMARY KEY ("id"); @@ -1888,7 +1920,7 @@ ALTER TABLE ONLY "subtask_time_tracking" -- Name: swimlanes swimlanes_name_project_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "swimlanes" +ALTER TABLE ONLY "public"."swimlanes" ADD CONSTRAINT "swimlanes_name_project_id_key" UNIQUE ("name", "project_id"); @@ -1896,7 +1928,7 @@ ALTER TABLE ONLY "swimlanes" -- Name: swimlanes swimlanes_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "swimlanes" +ALTER TABLE ONLY "public"."swimlanes" ADD CONSTRAINT "swimlanes_pkey" PRIMARY KEY ("id"); @@ -1904,7 +1936,7 @@ ALTER TABLE ONLY "swimlanes" -- Name: tags tags_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tags" +ALTER TABLE ONLY "public"."tags" ADD CONSTRAINT "tags_pkey" PRIMARY KEY ("id"); @@ -1912,7 +1944,7 @@ ALTER TABLE ONLY "tags" -- Name: tags tags_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tags" +ALTER TABLE ONLY "public"."tags" ADD CONSTRAINT "tags_project_id_name_key" UNIQUE ("project_id", "name"); @@ -1920,7 +1952,7 @@ ALTER TABLE ONLY "tags" -- Name: task_has_external_links task_has_external_links_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_external_links" +ALTER TABLE ONLY "public"."task_has_external_links" ADD CONSTRAINT "task_has_external_links_pkey" PRIMARY KEY ("id"); @@ -1928,7 +1960,7 @@ ALTER TABLE ONLY "task_has_external_links" -- Name: task_has_files task_has_files_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_files" +ALTER TABLE ONLY "public"."task_has_files" ADD CONSTRAINT "task_has_files_pkey" PRIMARY KEY ("id"); @@ -1936,7 +1968,7 @@ ALTER TABLE ONLY "task_has_files" -- Name: task_has_links task_has_links_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_links" +ALTER TABLE ONLY "public"."task_has_links" ADD CONSTRAINT "task_has_links_pkey" PRIMARY KEY ("id"); @@ -1944,7 +1976,7 @@ ALTER TABLE ONLY "task_has_links" -- Name: task_has_metadata task_has_metadata_task_id_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_metadata" +ALTER TABLE ONLY "public"."task_has_metadata" ADD CONSTRAINT "task_has_metadata_task_id_name_key" UNIQUE ("task_id", "name"); @@ -1952,7 +1984,7 @@ ALTER TABLE ONLY "task_has_metadata" -- Name: subtasks task_has_subtasks_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtasks" +ALTER TABLE ONLY "public"."subtasks" ADD CONSTRAINT "task_has_subtasks_pkey" PRIMARY KEY ("id"); @@ -1960,7 +1992,7 @@ ALTER TABLE ONLY "subtasks" -- Name: task_has_tags task_has_tags_tag_id_task_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_tags" +ALTER TABLE ONLY "public"."task_has_tags" ADD CONSTRAINT "task_has_tags_tag_id_task_id_key" UNIQUE ("tag_id", "task_id"); @@ -1968,7 +2000,7 @@ ALTER TABLE ONLY "task_has_tags" -- Name: tasks tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tasks" +ALTER TABLE ONLY "public"."tasks" ADD CONSTRAINT "tasks_pkey" PRIMARY KEY ("id"); @@ -1976,7 +2008,7 @@ ALTER TABLE ONLY "tasks" -- Name: transitions transitions_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" +ALTER TABLE ONLY "public"."transitions" ADD CONSTRAINT "transitions_pkey" PRIMARY KEY ("id"); @@ -1984,7 +2016,7 @@ ALTER TABLE ONLY "transitions" -- Name: user_has_metadata user_has_metadata_user_id_name_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_metadata" +ALTER TABLE ONLY "public"."user_has_metadata" ADD CONSTRAINT "user_has_metadata_user_id_name_key" UNIQUE ("user_id", "name"); @@ -1992,7 +2024,7 @@ ALTER TABLE ONLY "user_has_metadata" -- Name: user_has_notification_types user_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_notification_types" +ALTER TABLE ONLY "public"."user_has_notification_types" ADD CONSTRAINT "user_has_notification_types_pkey" PRIMARY KEY ("id"); @@ -2000,7 +2032,7 @@ ALTER TABLE ONLY "user_has_notification_types" -- Name: user_has_notifications user_has_notifications_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_notifications" +ALTER TABLE ONLY "public"."user_has_notifications" ADD CONSTRAINT "user_has_notifications_project_id_user_id_key" UNIQUE ("project_id", "user_id"); @@ -2008,7 +2040,7 @@ ALTER TABLE ONLY "user_has_notifications" -- Name: user_has_unread_notifications user_has_unread_notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_unread_notifications" +ALTER TABLE ONLY "public"."user_has_unread_notifications" ADD CONSTRAINT "user_has_unread_notifications_pkey" PRIMARY KEY ("id"); @@ -2016,7 +2048,7 @@ ALTER TABLE ONLY "user_has_unread_notifications" -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "users" +ALTER TABLE ONLY "public"."users" ADD CONSTRAINT "users_pkey" PRIMARY KEY ("id"); @@ -2024,598 +2056,598 @@ ALTER TABLE ONLY "users" -- Name: categories_project_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "categories_project_idx" ON "project_has_categories" USING "btree" ("project_id"); +CREATE INDEX "categories_project_idx" ON "public"."project_has_categories" USING "btree" ("project_id"); -- -- Name: columns_project_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "columns_project_idx" ON "columns" USING "btree" ("project_id"); +CREATE INDEX "columns_project_idx" ON "public"."columns" USING "btree" ("project_id"); -- -- Name: comments_reference_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "comments_reference_idx" ON "comments" USING "btree" ("reference"); +CREATE INDEX "comments_reference_idx" ON "public"."comments" USING "btree" ("reference"); -- -- Name: comments_task_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "comments_task_idx" ON "comments" USING "btree" ("task_id"); +CREATE INDEX "comments_task_idx" ON "public"."comments" USING "btree" ("task_id"); -- -- Name: files_task_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "files_task_idx" ON "task_has_files" USING "btree" ("task_id"); +CREATE INDEX "files_task_idx" ON "public"."task_has_files" USING "btree" ("task_id"); -- -- Name: project_daily_column_stats_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE UNIQUE INDEX "project_daily_column_stats_idx" ON "project_daily_column_stats" USING "btree" ("day", "project_id", "column_id"); +CREATE UNIQUE INDEX "project_daily_column_stats_idx" ON "public"."project_daily_column_stats" USING "btree" ("day", "project_id", "column_id"); -- -- Name: project_daily_stats_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE UNIQUE INDEX "project_daily_stats_idx" ON "project_daily_stats" USING "btree" ("day", "project_id"); +CREATE UNIQUE INDEX "project_daily_stats_idx" ON "public"."project_daily_stats" USING "btree" ("day", "project_id"); -- -- Name: subtasks_task_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "subtasks_task_idx" ON "subtasks" USING "btree" ("task_id"); +CREATE INDEX "subtasks_task_idx" ON "public"."subtasks" USING "btree" ("task_id"); -- -- Name: swimlanes_project_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "swimlanes_project_idx" ON "swimlanes" USING "btree" ("project_id"); +CREATE INDEX "swimlanes_project_idx" ON "public"."swimlanes" USING "btree" ("project_id"); -- -- Name: task_has_links_task_index; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "task_has_links_task_index" ON "task_has_links" USING "btree" ("task_id"); +CREATE INDEX "task_has_links_task_index" ON "public"."task_has_links" USING "btree" ("task_id"); -- -- Name: task_has_links_unique; Type: INDEX; Schema: public; Owner: - -- -CREATE UNIQUE INDEX "task_has_links_unique" ON "task_has_links" USING "btree" ("link_id", "task_id", "opposite_task_id"); +CREATE UNIQUE INDEX "task_has_links_unique" ON "public"."task_has_links" USING "btree" ("link_id", "task_id", "opposite_task_id"); -- -- Name: tasks_project_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "tasks_project_idx" ON "tasks" USING "btree" ("project_id"); +CREATE INDEX "tasks_project_idx" ON "public"."tasks" USING "btree" ("project_id"); -- -- Name: tasks_reference_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "tasks_reference_idx" ON "tasks" USING "btree" ("reference"); +CREATE INDEX "tasks_reference_idx" ON "public"."tasks" USING "btree" ("reference"); -- -- Name: transitions_project_index; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "transitions_project_index" ON "transitions" USING "btree" ("project_id"); +CREATE INDEX "transitions_project_index" ON "public"."transitions" USING "btree" ("project_id"); -- -- Name: transitions_task_index; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "transitions_task_index" ON "transitions" USING "btree" ("task_id"); +CREATE INDEX "transitions_task_index" ON "public"."transitions" USING "btree" ("task_id"); -- -- Name: transitions_user_index; Type: INDEX; Schema: public; Owner: - -- -CREATE INDEX "transitions_user_index" ON "transitions" USING "btree" ("user_id"); +CREATE INDEX "transitions_user_index" ON "public"."transitions" USING "btree" ("user_id"); -- -- Name: user_has_notification_types_user_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE UNIQUE INDEX "user_has_notification_types_user_idx" ON "user_has_notification_types" USING "btree" ("user_id", "notification_type"); +CREATE UNIQUE INDEX "user_has_notification_types_user_idx" ON "public"."user_has_notification_types" USING "btree" ("user_id", "notification_type"); -- -- Name: users_username_idx; Type: INDEX; Schema: public; Owner: - -- -CREATE UNIQUE INDEX "users_username_idx" ON "users" USING "btree" ("username"); +CREATE UNIQUE INDEX "users_username_idx" ON "public"."users" USING "btree" ("username"); -- -- Name: action_has_params action_has_params_action_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "action_has_params" - ADD CONSTRAINT "action_has_params_action_id_fkey" FOREIGN KEY ("action_id") REFERENCES "actions"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."action_has_params" + ADD CONSTRAINT "action_has_params_action_id_fkey" FOREIGN KEY ("action_id") REFERENCES "public"."actions"("id") ON DELETE CASCADE; -- -- Name: actions actions_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "actions" - ADD CONSTRAINT "actions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."actions" + ADD CONSTRAINT "actions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: column_has_move_restrictions column_has_move_restrictions_dst_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" - ADD CONSTRAINT "column_has_move_restrictions_dst_column_id_fkey" FOREIGN KEY ("dst_column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_move_restrictions" + ADD CONSTRAINT "column_has_move_restrictions_dst_column_id_fkey" FOREIGN KEY ("dst_column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: column_has_move_restrictions column_has_move_restrictions_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" - ADD CONSTRAINT "column_has_move_restrictions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_move_restrictions" + ADD CONSTRAINT "column_has_move_restrictions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: column_has_move_restrictions column_has_move_restrictions_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" - ADD CONSTRAINT "column_has_move_restrictions_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "project_has_roles"("role_id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_move_restrictions" + ADD CONSTRAINT "column_has_move_restrictions_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "public"."project_has_roles"("role_id") ON DELETE CASCADE; -- -- Name: column_has_move_restrictions column_has_move_restrictions_src_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_move_restrictions" - ADD CONSTRAINT "column_has_move_restrictions_src_column_id_fkey" FOREIGN KEY ("src_column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_move_restrictions" + ADD CONSTRAINT "column_has_move_restrictions_src_column_id_fkey" FOREIGN KEY ("src_column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: column_has_restrictions column_has_restrictions_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_restrictions" - ADD CONSTRAINT "column_has_restrictions_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_restrictions" + ADD CONSTRAINT "column_has_restrictions_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: column_has_restrictions column_has_restrictions_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_restrictions" - ADD CONSTRAINT "column_has_restrictions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_restrictions" + ADD CONSTRAINT "column_has_restrictions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: column_has_restrictions column_has_restrictions_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "column_has_restrictions" - ADD CONSTRAINT "column_has_restrictions_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "project_has_roles"("role_id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."column_has_restrictions" + ADD CONSTRAINT "column_has_restrictions_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "public"."project_has_roles"("role_id") ON DELETE CASCADE; -- -- Name: columns columns_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "columns" - ADD CONSTRAINT "columns_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."columns" + ADD CONSTRAINT "columns_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: comments comments_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "comments" - ADD CONSTRAINT "comments_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."comments" + ADD CONSTRAINT "comments_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: group_has_users group_has_users_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "group_has_users" - ADD CONSTRAINT "group_has_users_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."group_has_users" + ADD CONSTRAINT "group_has_users_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "public"."groups"("id") ON DELETE CASCADE; -- -- Name: group_has_users group_has_users_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "group_has_users" - ADD CONSTRAINT "group_has_users_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."group_has_users" + ADD CONSTRAINT "group_has_users_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: last_logins last_logins_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "last_logins" - ADD CONSTRAINT "last_logins_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."last_logins" + ADD CONSTRAINT "last_logins_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: password_reset password_reset_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "password_reset" - ADD CONSTRAINT "password_reset_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."password_reset" + ADD CONSTRAINT "password_reset_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- 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; +ALTER TABLE ONLY "public"."predefined_task_descriptions" + ADD CONSTRAINT "predefined_task_descriptions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_activities project_activities_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_activities" - ADD CONSTRAINT "project_activities_creator_id_fkey" FOREIGN KEY ("creator_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_activities" + ADD CONSTRAINT "project_activities_creator_id_fkey" FOREIGN KEY ("creator_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: project_activities project_activities_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_activities" - ADD CONSTRAINT "project_activities_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_activities" + ADD CONSTRAINT "project_activities_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_activities project_activities_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_activities" - ADD CONSTRAINT "project_activities_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_activities" + ADD CONSTRAINT "project_activities_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: project_daily_stats project_daily_stats_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_stats" - ADD CONSTRAINT "project_daily_stats_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_daily_stats" + ADD CONSTRAINT "project_daily_stats_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_daily_column_stats project_daily_summaries_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_column_stats" - ADD CONSTRAINT "project_daily_summaries_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_daily_column_stats" + ADD CONSTRAINT "project_daily_summaries_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: project_daily_column_stats project_daily_summaries_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_daily_column_stats" - ADD CONSTRAINT "project_daily_summaries_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_daily_column_stats" + ADD CONSTRAINT "project_daily_summaries_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_categories project_has_categories_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_categories" - ADD CONSTRAINT "project_has_categories_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_has_categories" + ADD CONSTRAINT "project_has_categories_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_files project_has_files_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_files" - ADD CONSTRAINT "project_has_files_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_has_files" + ADD CONSTRAINT "project_has_files_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_groups project_has_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_groups" - ADD CONSTRAINT "project_has_groups_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_has_groups" + ADD CONSTRAINT "project_has_groups_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "public"."groups"("id") ON DELETE CASCADE; -- -- Name: project_has_groups project_has_groups_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_groups" - ADD CONSTRAINT "project_has_groups_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_has_groups" + ADD CONSTRAINT "project_has_groups_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_metadata project_has_metadata_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_metadata" - ADD CONSTRAINT "project_has_metadata_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_has_metadata" + ADD CONSTRAINT "project_has_metadata_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_notification_types 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; +ALTER TABLE ONLY "public"."project_has_notification_types" + ADD CONSTRAINT "project_has_notification_types_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_roles project_has_roles_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_has_roles" - ADD CONSTRAINT "project_has_roles_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_has_roles" + ADD CONSTRAINT "project_has_roles_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_users project_has_users_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 "public"."project_has_users" + ADD CONSTRAINT "project_has_users_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_has_users project_has_users_user_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; +ALTER TABLE ONLY "public"."project_has_users" + ADD CONSTRAINT "project_has_users_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: project_role_has_restrictions project_role_has_restrictions_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_role_has_restrictions" - ADD CONSTRAINT "project_role_has_restrictions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_role_has_restrictions" + ADD CONSTRAINT "project_role_has_restrictions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: project_role_has_restrictions project_role_has_restrictions_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "project_role_has_restrictions" - ADD CONSTRAINT "project_role_has_restrictions_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "project_has_roles"("role_id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."project_role_has_restrictions" + ADD CONSTRAINT "project_role_has_restrictions_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "public"."project_has_roles"("role_id") ON DELETE CASCADE; -- -- Name: remember_me remember_me_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "remember_me" - ADD CONSTRAINT "remember_me_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."remember_me" + ADD CONSTRAINT "remember_me_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: subtask_time_tracking subtask_time_tracking_subtask_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtask_time_tracking" - ADD CONSTRAINT "subtask_time_tracking_subtask_id_fkey" FOREIGN KEY ("subtask_id") REFERENCES "subtasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."subtask_time_tracking" + ADD CONSTRAINT "subtask_time_tracking_subtask_id_fkey" FOREIGN KEY ("subtask_id") REFERENCES "public"."subtasks"("id") ON DELETE CASCADE; -- -- Name: subtask_time_tracking subtask_time_tracking_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtask_time_tracking" - ADD CONSTRAINT "subtask_time_tracking_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."subtask_time_tracking" + ADD CONSTRAINT "subtask_time_tracking_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: swimlanes swimlanes_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "swimlanes" - ADD CONSTRAINT "swimlanes_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."swimlanes" + ADD CONSTRAINT "swimlanes_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: task_has_external_links task_has_external_links_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_external_links" - ADD CONSTRAINT "task_has_external_links_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_external_links" + ADD CONSTRAINT "task_has_external_links_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: task_has_files task_has_files_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_files" - ADD CONSTRAINT "task_has_files_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_files" + ADD CONSTRAINT "task_has_files_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: task_has_links task_has_links_link_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_links" - ADD CONSTRAINT "task_has_links_link_id_fkey" FOREIGN KEY ("link_id") REFERENCES "links"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_links" + ADD CONSTRAINT "task_has_links_link_id_fkey" FOREIGN KEY ("link_id") REFERENCES "public"."links"("id") ON DELETE CASCADE; -- -- Name: task_has_links task_has_links_opposite_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_links" - ADD CONSTRAINT "task_has_links_opposite_task_id_fkey" FOREIGN KEY ("opposite_task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_links" + ADD CONSTRAINT "task_has_links_opposite_task_id_fkey" FOREIGN KEY ("opposite_task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: task_has_links task_has_links_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_links" - ADD CONSTRAINT "task_has_links_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_links" + ADD CONSTRAINT "task_has_links_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: task_has_metadata 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; +ALTER TABLE ONLY "public"."task_has_metadata" + ADD CONSTRAINT "task_has_metadata_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: subtasks task_has_subtasks_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "subtasks" - ADD CONSTRAINT "task_has_subtasks_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."subtasks" + ADD CONSTRAINT "task_has_subtasks_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: task_has_tags task_has_tags_tag_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_tags" - ADD CONSTRAINT "task_has_tags_tag_id_fkey" FOREIGN KEY ("tag_id") REFERENCES "tags"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_tags" + ADD CONSTRAINT "task_has_tags_tag_id_fkey" FOREIGN KEY ("tag_id") REFERENCES "public"."tags"("id") ON DELETE CASCADE; -- -- Name: task_has_tags task_has_tags_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "task_has_tags" - ADD CONSTRAINT "task_has_tags_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."task_has_tags" + ADD CONSTRAINT "task_has_tags_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: tasks tasks_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tasks" - ADD CONSTRAINT "tasks_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."tasks" + ADD CONSTRAINT "tasks_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: tasks tasks_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "tasks" - ADD CONSTRAINT "tasks_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."tasks" + ADD CONSTRAINT "tasks_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."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; +ALTER TABLE ONLY "public"."tasks" + ADD CONSTRAINT "tasks_swimlane_id_fkey" FOREIGN KEY ("swimlane_id") REFERENCES "public"."swimlanes"("id") ON DELETE CASCADE; -- -- Name: transitions transitions_dst_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" - ADD CONSTRAINT "transitions_dst_column_id_fkey" FOREIGN KEY ("dst_column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."transitions" + ADD CONSTRAINT "transitions_dst_column_id_fkey" FOREIGN KEY ("dst_column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: transitions transitions_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" - ADD CONSTRAINT "transitions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."transitions" + ADD CONSTRAINT "transitions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: transitions transitions_src_column_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" - ADD CONSTRAINT "transitions_src_column_id_fkey" FOREIGN KEY ("src_column_id") REFERENCES "columns"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."transitions" + ADD CONSTRAINT "transitions_src_column_id_fkey" FOREIGN KEY ("src_column_id") REFERENCES "public"."columns"("id") ON DELETE CASCADE; -- -- Name: transitions transitions_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" - ADD CONSTRAINT "transitions_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."transitions" + ADD CONSTRAINT "transitions_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "public"."tasks"("id") ON DELETE CASCADE; -- -- Name: transitions transitions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "transitions" - ADD CONSTRAINT "transitions_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."transitions" + ADD CONSTRAINT "transitions_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: user_has_metadata 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; +ALTER TABLE ONLY "public"."user_has_metadata" + ADD CONSTRAINT "user_has_metadata_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: user_has_notification_types user_has_notification_types_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_notification_types" - ADD CONSTRAINT "user_has_notification_types_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."user_has_notification_types" + ADD CONSTRAINT "user_has_notification_types_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: user_has_notifications user_has_notifications_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_notifications" - ADD CONSTRAINT "user_has_notifications_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."user_has_notifications" + ADD CONSTRAINT "user_has_notifications_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "public"."projects"("id") ON DELETE CASCADE; -- -- Name: user_has_notifications user_has_notifications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_notifications" - ADD CONSTRAINT "user_has_notifications_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."user_has_notifications" + ADD CONSTRAINT "user_has_notifications_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- -- Name: user_has_unread_notifications user_has_unread_notifications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - -- -ALTER TABLE ONLY "user_has_unread_notifications" - ADD CONSTRAINT "user_has_unread_notifications_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE; +ALTER TABLE ONLY "public"."user_has_unread_notifications" + ADD CONSTRAINT "user_has_unread_notifications_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE; -- @@ -2626,46 +2658,45 @@ ALTER TABLE ONLY "user_has_unread_notifications" -- PostgreSQL database dump -- --- Dumped from database version 9.6.3 --- Dumped by pg_dump version 9.6.3 +-- Dumped from database version 10.5 +-- Dumped by pg_dump version 10.5 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; +SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; -SET search_path = public, pg_catalog; - -- -- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: postgres -- -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_highlight_period', '172800', 0, 0); -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', '60a9320b2835f6fa01f6ec445212e3eb6d919887a81a0414d9928d908315', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '5713f6ffb5fdef788497bf45e43cedaeff565135f8ad3a5015ab338f5251', 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); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_date_format', 'm/d/Y', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('project_categories', '', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('subtask_restriction', '0', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_stylesheet', '', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_currency', 'USD', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('integration_gravatar', '0', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('calendar_user_subtasks_time_tracking', '0', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('calendar_user_tasks', 'date_started', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('calendar_project_tasks', 'date_started', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_url', '', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('default_color', 'yellow', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('subtask_time_tracking', '1', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('cfd_include_closed_tasks', '1', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('password_reset', '1', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('board_highlight_period', '172800', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('board_public_refresh_interval', '60', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('board_private_refresh_interval', '10', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('board_columns', '', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '1a9fe6b6651d4f17db363279ec08b6b44c8ee4f205d0c9527848a648436c', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('api_token', '8e6d6c81e25529d4d83e8b30385922ce1a99af3908743e888aa87344f8f3', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('application_language', 'en_US', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('application_timezone', 'UTC', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('application_url', '', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('application_date_format', 'm/d/Y', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('project_categories', '', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('subtask_restriction', '0', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('application_stylesheet', '', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('application_currency', 'USD', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('integration_gravatar', '0', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('calendar_user_subtasks_time_tracking', '0', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('calendar_user_tasks', 'date_started', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('calendar_project_tasks', 'date_started', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('webhook_url', '', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('default_color', 'yellow', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('subtask_time_tracking', '1', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('cfd_include_closed_tasks', '1', 0, 0); +INSERT INTO public.settings (option, value, changed_by, changed_on) VALUES ('password_reset', '1', 0, 0); -- @@ -2676,46 +2707,45 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('password_r -- PostgreSQL database dump -- --- Dumped from database version 9.6.3 --- Dumped by pg_dump version 9.6.3 +-- Dumped from database version 10.5 +-- Dumped by pg_dump version 10.5 SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; +SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; -SET search_path = public, pg_catalog; - -- -- Data for Name: links; Type: TABLE DATA; Schema: public; Owner: postgres -- -INSERT INTO links (id, label, opposite_id) VALUES (1, 'relates to', 0); -INSERT INTO links (id, label, opposite_id) VALUES (2, 'blocks', 3); -INSERT INTO links (id, label, opposite_id) VALUES (3, 'is blocked by', 2); -INSERT INTO links (id, label, opposite_id) VALUES (4, 'duplicates', 5); -INSERT INTO links (id, label, opposite_id) VALUES (5, 'is duplicated by', 4); -INSERT INTO links (id, label, opposite_id) VALUES (6, 'is a child of', 7); -INSERT INTO links (id, label, opposite_id) VALUES (7, 'is a parent of', 6); -INSERT INTO links (id, label, opposite_id) VALUES (8, 'targets milestone', 9); -INSERT INTO links (id, label, opposite_id) VALUES (9, 'is a milestone of', 8); -INSERT INTO links (id, label, opposite_id) VALUES (10, 'fixes', 11); -INSERT INTO links (id, label, opposite_id) VALUES (11, 'is fixed by', 10); +INSERT INTO public.links (id, label, opposite_id) VALUES (1, 'relates to', 0); +INSERT INTO public.links (id, label, opposite_id) VALUES (2, 'blocks', 3); +INSERT INTO public.links (id, label, opposite_id) VALUES (3, 'is blocked by', 2); +INSERT INTO public.links (id, label, opposite_id) VALUES (4, 'duplicates', 5); +INSERT INTO public.links (id, label, opposite_id) VALUES (5, 'is duplicated by', 4); +INSERT INTO public.links (id, label, opposite_id) VALUES (6, 'is a child of', 7); +INSERT INTO public.links (id, label, opposite_id) VALUES (7, 'is a parent of', 6); +INSERT INTO public.links (id, label, opposite_id) VALUES (8, 'targets milestone', 9); +INSERT INTO public.links (id, label, opposite_id) VALUES (9, 'is a milestone of', 8); +INSERT INTO public.links (id, label, opposite_id) VALUES (10, 'fixes', 11); +INSERT INTO public.links (id, label, opposite_id) VALUES (11, 'is fixed by', 10); -- -- Name: links_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- -SELECT pg_catalog.setval('links_id_seq', 11, true); +SELECT pg_catalog.setval('public.links_id_seq', 11, true); -- -- PostgreSQL database dump complete -- -INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$eu5txjAlmBRZYmAcWjHAx.BSCIYL6RMTIyrIWG4eqWFtf62DCJPWy', 'app-admin'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$GzDCeQl/GdH.pCZfz4fWdO3qmayutRCmxEIY9U9t1k9q9F89VNDCm', 'app-admin'); INSERT INTO schema_version VALUES ('111'); |