summaryrefslogtreecommitdiff
path: root/app
diff options
context:
space:
mode:
authorFrederic Guillot <fred@kanboard.net>2016-05-22 21:11:19 -0400
committerFrederic Guillot <fred@kanboard.net>2016-05-22 21:11:19 -0400
commitdc6176fca23ea697380ab115aea976fa8271f047 (patch)
tree0be03361ab229d7504459edc1bc0766dd31f79c4 /app
parent5b0a298ded04ee0b01ba7cf19b866daa30320c5a (diff)
Improve Postgres SQL dump
Diffstat (limited to 'app')
-rw-r--r--app/Schema/Sql/mysql.sql4
-rw-r--r--app/Schema/Sql/postgres.sql1365
2 files changed, 687 insertions, 682 deletions
diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql
index ce2374f0..92ca3686 100644
--- a/app/Schema/Sql/mysql.sql
+++ b/app/Schema/Sql/mysql.sql
@@ -647,7 +647,7 @@ CREATE TABLE `users` (
LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
-INSERT INTO `settings` VALUES ('api_token','9c55053ae1d523893efc820e2e8338c4cf47f5c6c2c26861fec637eba62b',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','aaed762f4f6b0860902af0e2a87e5ad3427d24ff9e3ce8a2e0b005b58dfc',0,0),('webhook_url','',0,0);
+INSERT INTO `settings` VALUES ('api_token','e8a7a983f25efa80e203d44a832c9570a5083d3fefa91366989c00e931d0',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','296892f9c821909a92df539b028fdb384e47c9f7a34a8f9cad598e0edbba',0,0),('webhook_url','',0,0);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -676,4 +676,4 @@ UNLOCK TABLES;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$e.SftITKuBvXeNbxtmTKS.KAbIy4Mx09t254BAiEAuWOxkuS4xfLG', 'app-admin');INSERT INTO schema_version VALUES ('110');
+INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$kliMGeKgDYtx9Igek9jGDu0eZM.KXivgzvqtnMuWMkjvZiIc.8p8S', 'app-admin');INSERT INTO schema_version VALUES ('110');
diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql
index 48a269d3..6c17c1b1 100644
--- a/app/Schema/Sql/postgres.sql
+++ b/app/Schema/Sql/postgres.sql
@@ -2,42 +2,39 @@
-- PostgreSQL database dump
--
+-- Dumped from database version 9.5.2
+-- Dumped by pg_dump version 9.5.2
+
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
+SET row_security = off;
--
--- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
+-- Name: SCHEMA "public"; Type: COMMENT; Schema: -; Owner: -
--
-CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
-
-
---
--- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
---
+COMMENT ON SCHEMA "public" IS 'standard public schema';
-COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
-
-SET search_path = public, pg_catalog;
+SET search_path = "public", pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
--- Name: action_has_params; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: action_has_params; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE action_has_params (
- id integer NOT NULL,
- action_id integer NOT NULL,
- name character varying(50) NOT NULL,
- value character varying(50) NOT NULL
+CREATE TABLE "action_has_params" (
+ "id" integer NOT NULL,
+ "action_id" integer NOT NULL,
+ "name" character varying(50) NOT NULL,
+ "value" character varying(50) NOT NULL
);
@@ -45,7 +42,7 @@ 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 "action_has_params_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -57,18 +54,18 @@ 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 "action_has_params_id_seq" OWNED BY "action_has_params"."id";
--
--- Name: actions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: actions; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE actions (
- id integer NOT NULL,
- project_id integer NOT NULL,
- event_name character varying(50) NOT NULL,
- action_name character varying(255) NOT NULL
+CREATE TABLE "actions" (
+ "id" integer NOT NULL,
+ "project_id" integer NOT NULL,
+ "event_name" character varying(50) NOT NULL,
+ "action_name" character varying(255) NOT NULL
);
@@ -76,7 +73,7 @@ CREATE TABLE actions (
-- Name: actions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE actions_id_seq
+CREATE SEQUENCE "actions_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -88,20 +85,20 @@ 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 "actions_id_seq" OWNED BY "actions"."id";
--
--- Name: columns; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: columns; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE columns (
- id integer NOT NULL,
- title character varying(255) NOT NULL,
+CREATE TABLE "columns" (
+ "id" integer NOT NULL,
+ "title" character varying(255) NOT NULL,
"position" integer,
- project_id integer NOT NULL,
- task_limit integer DEFAULT 0,
- description text
+ "project_id" integer NOT NULL,
+ "task_limit" integer DEFAULT 0,
+ "description" "text"
);
@@ -109,7 +106,7 @@ CREATE TABLE columns (
-- Name: columns_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE columns_id_seq
+CREATE SEQUENCE "columns_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -121,20 +118,20 @@ 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 "columns_id_seq" OWNED BY "columns"."id";
--
--- Name: comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: comments; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE comments (
- id integer NOT NULL,
- task_id integer NOT NULL,
- user_id integer DEFAULT 0,
- date_creation bigint NOT NULL,
- comment text,
- reference character varying(50) DEFAULT ''::character varying
+CREATE TABLE "comments" (
+ "id" integer NOT NULL,
+ "task_id" integer NOT NULL,
+ "user_id" integer DEFAULT 0,
+ "date_creation" bigint NOT NULL,
+ "comment" "text",
+ "reference" character varying(50) DEFAULT ''::character varying
);
@@ -142,7 +139,7 @@ CREATE TABLE comments (
-- Name: comments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE comments_id_seq
+CREATE SEQUENCE "comments_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -154,31 +151,31 @@ 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 "comments_id_seq" OWNED BY "comments"."id";
--
--- Name: currencies; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: currencies; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE currencies (
- currency character(3) NOT NULL,
- rate real DEFAULT 0
+CREATE TABLE "currencies" (
+ "currency" character(3) NOT NULL,
+ "rate" real DEFAULT 0
);
--
--- Name: custom_filters; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: custom_filters; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE custom_filters (
- id integer NOT NULL,
- filter character varying(100) NOT NULL,
- project_id integer NOT NULL,
- user_id integer NOT NULL,
- name character varying(100) NOT NULL,
- is_shared boolean DEFAULT false,
- append boolean DEFAULT false
+CREATE TABLE "custom_filters" (
+ "id" integer NOT NULL,
+ "filter" character varying(100) NOT NULL,
+ "project_id" integer NOT NULL,
+ "user_id" integer NOT NULL,
+ "name" character varying(100) NOT NULL,
+ "is_shared" boolean DEFAULT false,
+ "append" boolean DEFAULT false
);
@@ -186,7 +183,7 @@ CREATE TABLE custom_filters (
-- Name: custom_filters_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE custom_filters_id_seq
+CREATE SEQUENCE "custom_filters_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -198,27 +195,27 @@ 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 "custom_filters_id_seq" OWNED BY "custom_filters"."id";
--
--- Name: group_has_users; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: group_has_users; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE group_has_users (
- group_id integer NOT NULL,
- user_id integer NOT NULL
+CREATE TABLE "group_has_users" (
+ "group_id" integer NOT NULL,
+ "user_id" integer NOT NULL
);
--
--- Name: groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: groups; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE groups (
- id integer NOT NULL,
- external_id character varying(255) DEFAULT ''::character varying,
- name character varying(100) NOT NULL
+CREATE TABLE "groups" (
+ "id" integer NOT NULL,
+ "external_id" character varying(255) DEFAULT ''::character varying,
+ "name" character varying(100) NOT NULL
);
@@ -226,7 +223,7 @@ CREATE TABLE groups (
-- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE groups_id_seq
+CREATE SEQUENCE "groups_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -238,20 +235,20 @@ 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 "groups_id_seq" OWNED BY "groups"."id";
--
--- Name: last_logins; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: last_logins; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE last_logins (
- id integer NOT NULL,
- auth_type character varying(25),
- user_id integer,
- ip character varying(45),
- user_agent character varying(255),
- date_creation bigint
+CREATE TABLE "last_logins" (
+ "id" integer NOT NULL,
+ "auth_type" character varying(25),
+ "user_id" integer,
+ "ip" character varying(45),
+ "user_agent" character varying(255),
+ "date_creation" bigint
);
@@ -259,7 +256,7 @@ CREATE TABLE last_logins (
-- Name: last_logins_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE last_logins_id_seq
+CREATE SEQUENCE "last_logins_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -271,17 +268,17 @@ 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 "last_logins_id_seq" OWNED BY "last_logins"."id";
--
--- Name: links; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: links; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE links (
- id integer NOT NULL,
- label character varying(255) NOT NULL,
- opposite_id integer DEFAULT 0
+CREATE TABLE "links" (
+ "id" integer NOT NULL,
+ "label" character varying(255) NOT NULL,
+ "opposite_id" integer DEFAULT 0
);
@@ -289,7 +286,7 @@ CREATE TABLE links (
-- Name: links_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE links_id_seq
+CREATE SEQUENCE "links_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -301,46 +298,46 @@ 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 "links_id_seq" OWNED BY "links"."id";
--
--- Name: password_reset; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: password_reset; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE password_reset (
- token character varying(80) NOT NULL,
- user_id integer NOT NULL,
- date_expiration integer NOT NULL,
- date_creation integer NOT NULL,
- ip character varying(45) NOT NULL,
- user_agent character varying(255) NOT NULL,
- is_active boolean NOT NULL
+CREATE TABLE "password_reset" (
+ "token" character varying(80) NOT NULL,
+ "user_id" integer NOT NULL,
+ "date_expiration" integer NOT NULL,
+ "date_creation" integer NOT NULL,
+ "ip" character varying(45) NOT NULL,
+ "user_agent" character varying(255) NOT NULL,
+ "is_active" boolean NOT NULL
);
--
--- Name: plugin_schema_versions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: plugin_schema_versions; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE plugin_schema_versions (
- plugin character varying(80) NOT NULL,
- version integer DEFAULT 0 NOT NULL
+CREATE TABLE "plugin_schema_versions" (
+ "plugin" character varying(80) NOT NULL,
+ "version" integer DEFAULT 0 NOT NULL
);
--
--- Name: project_activities; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_activities; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_activities (
- id integer NOT NULL,
- date_creation bigint NOT NULL,
- event_name character varying(50) NOT NULL,
- creator_id integer,
- project_id integer,
- task_id integer,
- data text
+CREATE TABLE "project_activities" (
+ "id" integer NOT NULL,
+ "date_creation" bigint NOT NULL,
+ "event_name" character varying(50) NOT NULL,
+ "creator_id" integer,
+ "project_id" integer,
+ "task_id" integer,
+ "data" "text"
);
@@ -348,7 +345,7 @@ CREATE TABLE project_activities (
-- Name: project_activities_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE project_activities_id_seq
+CREATE SEQUENCE "project_activities_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -360,33 +357,33 @@ 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 "project_activities_id_seq" OWNED BY "project_activities"."id";
--
--- Name: project_daily_column_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_daily_column_stats; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_daily_column_stats (
- id integer NOT NULL,
- day character(10) NOT NULL,
- project_id integer NOT NULL,
- column_id integer NOT NULL,
- total integer DEFAULT 0 NOT NULL,
- score integer DEFAULT 0 NOT NULL
+CREATE TABLE "project_daily_column_stats" (
+ "id" integer NOT NULL,
+ "day" character(10) NOT NULL,
+ "project_id" integer NOT NULL,
+ "column_id" integer NOT NULL,
+ "total" integer DEFAULT 0 NOT NULL,
+ "score" integer DEFAULT 0 NOT NULL
);
--
--- Name: project_daily_stats; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_daily_stats; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_daily_stats (
- id integer NOT NULL,
- day character(10) NOT NULL,
- project_id integer NOT NULL,
- avg_lead_time integer DEFAULT 0 NOT NULL,
- avg_cycle_time integer DEFAULT 0 NOT NULL
+CREATE TABLE "project_daily_stats" (
+ "id" integer NOT NULL,
+ "day" character(10) NOT NULL,
+ "project_id" integer NOT NULL,
+ "avg_lead_time" integer DEFAULT 0 NOT NULL,
+ "avg_cycle_time" integer DEFAULT 0 NOT NULL
);
@@ -394,7 +391,7 @@ 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 "project_daily_stats_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -406,14 +403,14 @@ 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 "project_daily_stats_id_seq" OWNED BY "project_daily_stats"."id";
--
-- Name: project_daily_summaries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE project_daily_summaries_id_seq
+CREATE SEQUENCE "project_daily_summaries_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -425,18 +422,18 @@ 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 "project_daily_summaries_id_seq" OWNED BY "project_daily_column_stats"."id";
--
--- Name: project_has_categories; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_categories; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_has_categories (
- id integer NOT NULL,
- name character varying(255) NOT NULL,
- project_id integer NOT NULL,
- description text
+CREATE TABLE "project_has_categories" (
+ "id" integer NOT NULL,
+ "name" character varying(255) NOT NULL,
+ "project_id" integer NOT NULL,
+ "description" "text"
);
@@ -444,7 +441,7 @@ 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 "project_has_categories_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -456,22 +453,22 @@ 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 "project_has_categories_id_seq" OWNED BY "project_has_categories"."id";
--
--- Name: project_has_files; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_files; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_has_files (
- id integer NOT NULL,
- project_id integer NOT NULL,
- name character varying(255) NOT NULL,
- path character varying(255) NOT NULL,
- is_image boolean DEFAULT false,
- size integer DEFAULT 0 NOT NULL,
- user_id integer DEFAULT 0 NOT NULL,
- date integer DEFAULT 0 NOT NULL
+CREATE TABLE "project_has_files" (
+ "id" integer NOT NULL,
+ "project_id" integer NOT NULL,
+ "name" character varying(255) NOT NULL,
+ "path" character varying(255) NOT NULL,
+ "is_image" boolean DEFAULT false,
+ "size" integer DEFAULT 0 NOT NULL,
+ "user_id" integer DEFAULT 0 NOT NULL,
+ "date" integer DEFAULT 0 NOT NULL
);
@@ -479,7 +476,7 @@ 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 "project_has_files_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -491,41 +488,41 @@ 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 "project_has_files_id_seq" OWNED BY "project_has_files"."id";
--
--- Name: project_has_groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_groups; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_has_groups (
- group_id integer NOT NULL,
- project_id integer NOT NULL,
- role character varying(25) NOT NULL
+CREATE TABLE "project_has_groups" (
+ "group_id" integer NOT NULL,
+ "project_id" integer NOT NULL,
+ "role" character varying(25) NOT NULL
);
--
--- Name: project_has_metadata; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_metadata; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_has_metadata (
- project_id integer NOT NULL,
- name character varying(50) NOT NULL,
- value character varying(255) DEFAULT ''::character varying,
- changed_by integer DEFAULT 0 NOT NULL,
- changed_on integer DEFAULT 0 NOT NULL
+CREATE TABLE "project_has_metadata" (
+ "project_id" integer NOT NULL,
+ "name" character varying(50) NOT NULL,
+ "value" character varying(255) DEFAULT ''::character varying,
+ "changed_by" integer DEFAULT 0 NOT NULL,
+ "changed_on" integer DEFAULT 0 NOT NULL
);
--
--- Name: project_has_notification_types; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_notification_types; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_has_notification_types (
- id integer NOT NULL,
- project_id integer NOT NULL,
- notification_type character varying(50) NOT NULL
+CREATE TABLE "project_has_notification_types" (
+ "id" integer NOT NULL,
+ "project_id" integer NOT NULL,
+ "notification_type" character varying(50) NOT NULL
);
@@ -533,7 +530,7 @@ 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 "project_has_notification_types_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -545,43 +542,43 @@ 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 "project_has_notification_types_id_seq" OWNED BY "project_has_notification_types"."id";
--
--- Name: project_has_users; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_users; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE project_has_users (
- project_id integer NOT NULL,
- user_id integer NOT NULL,
- role character varying(25) DEFAULT 'project-viewer'::character varying NOT NULL
+CREATE TABLE "project_has_users" (
+ "project_id" integer NOT NULL,
+ "user_id" integer NOT NULL,
+ "role" character varying(25) DEFAULT 'project-viewer'::character varying NOT NULL
);
--
--- Name: projects; Type: TABLE; Schema: public; Owner: -; Tablespace:
---
-
-CREATE TABLE projects (
- id integer NOT NULL,
- name character varying(255) NOT NULL,
- is_active boolean DEFAULT true,
- token character varying(255),
- last_modified bigint DEFAULT 0,
- is_public boolean DEFAULT false,
- is_private boolean DEFAULT false,
- is_everybody_allowed boolean DEFAULT false,
- default_swimlane character varying(200) DEFAULT 'Default swimlane'::character varying,
- show_default_swimlane boolean DEFAULT true,
- description text,
- identifier character varying(50) DEFAULT ''::character varying,
- start_date character varying(10) DEFAULT ''::character varying,
- end_date character varying(10) DEFAULT ''::character varying,
- owner_id integer DEFAULT 0,
- priority_default integer DEFAULT 0,
- priority_start integer DEFAULT 0,
- priority_end integer DEFAULT 3
+-- Name: projects; Type: TABLE; Schema: public; Owner: -
+--
+
+CREATE TABLE "projects" (
+ "id" integer NOT NULL,
+ "name" character varying(255) NOT NULL,
+ "is_active" boolean DEFAULT true,
+ "token" character varying(255),
+ "last_modified" bigint DEFAULT 0,
+ "is_public" boolean DEFAULT false,
+ "is_private" boolean DEFAULT false,
+ "is_everybody_allowed" boolean DEFAULT false,
+ "default_swimlane" character varying(200) DEFAULT 'Default swimlane'::character varying,
+ "show_default_swimlane" boolean DEFAULT true,
+ "description" "text",
+ "identifier" character varying(50) DEFAULT ''::character varying,
+ "start_date" character varying(10) DEFAULT ''::character varying,
+ "end_date" character varying(10) DEFAULT ''::character varying,
+ "owner_id" integer DEFAULT 0,
+ "priority_default" integer DEFAULT 0,
+ "priority_start" integer DEFAULT 0,
+ "priority_end" integer DEFAULT 3
);
@@ -589,7 +586,7 @@ CREATE TABLE projects (
-- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE projects_id_seq
+CREATE SEQUENCE "projects_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -601,22 +598,22 @@ 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 "projects_id_seq" OWNED BY "projects"."id";
--
--- Name: remember_me; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: remember_me; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE remember_me (
- id integer NOT NULL,
- user_id integer,
- ip character varying(45),
- user_agent character varying(255),
- token character varying(255),
- sequence character varying(255),
- expiration integer,
- date_creation bigint
+CREATE TABLE "remember_me" (
+ "id" integer NOT NULL,
+ "user_id" integer,
+ "ip" character varying(45),
+ "user_agent" character varying(255),
+ "token" character varying(255),
+ "sequence" character varying(255),
+ "expiration" integer,
+ "date_creation" bigint
);
@@ -624,7 +621,7 @@ CREATE TABLE remember_me (
-- Name: remember_me_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE remember_me_id_seq
+CREATE SEQUENCE "remember_me_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -636,41 +633,41 @@ 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 "remember_me_id_seq" OWNED BY "remember_me"."id";
--
--- Name: schema_version; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: schema_version; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE schema_version (
- version integer DEFAULT 0
+CREATE TABLE "schema_version" (
+ "version" integer DEFAULT 0
);
--
--- Name: settings; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: settings; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE settings (
- option character varying(100) NOT NULL,
- value character varying(255) DEFAULT ''::character varying,
- changed_by integer DEFAULT 0 NOT NULL,
- changed_on integer DEFAULT 0 NOT NULL
+CREATE TABLE "settings" (
+ "option" character varying(100) NOT NULL,
+ "value" character varying(255) DEFAULT ''::character varying,
+ "changed_by" integer DEFAULT 0 NOT NULL,
+ "changed_on" integer DEFAULT 0 NOT NULL
);
--
--- Name: subtask_time_tracking; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: subtask_time_tracking; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE subtask_time_tracking (
- id integer NOT NULL,
- user_id integer NOT NULL,
- subtask_id integer NOT NULL,
- start bigint DEFAULT 0,
+CREATE TABLE "subtask_time_tracking" (
+ "id" integer NOT NULL,
+ "user_id" integer NOT NULL,
+ "subtask_id" integer NOT NULL,
+ "start" bigint DEFAULT 0,
"end" bigint DEFAULT 0,
- time_spent real DEFAULT 0
+ "time_spent" real DEFAULT 0
);
@@ -678,7 +675,7 @@ 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 "subtask_time_tracking_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -690,36 +687,36 @@ 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 "subtask_time_tracking_id_seq" OWNED BY "subtask_time_tracking"."id";
--
--- Name: subtasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: subtasks; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE subtasks (
- id integer NOT NULL,
- title character varying(255) NOT NULL,
- status smallint DEFAULT 0,
- time_estimated double precision DEFAULT 0,
- time_spent double precision DEFAULT 0,
- task_id integer NOT NULL,
- user_id integer,
+CREATE TABLE "subtasks" (
+ "id" integer NOT NULL,
+ "title" character varying(255) NOT NULL,
+ "status" smallint DEFAULT 0,
+ "time_estimated" double precision DEFAULT 0,
+ "time_spent" double precision DEFAULT 0,
+ "task_id" integer NOT NULL,
+ "user_id" integer,
"position" integer DEFAULT 1
);
--
--- Name: swimlanes; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: swimlanes; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE swimlanes (
- id integer NOT NULL,
- name character varying(200) NOT NULL,
+CREATE TABLE "swimlanes" (
+ "id" integer NOT NULL,
+ "name" character varying(200) NOT NULL,
"position" integer DEFAULT 1,
- is_active boolean DEFAULT true,
- project_id integer,
- description text
+ "is_active" boolean DEFAULT true,
+ "project_id" integer,
+ "description" "text"
);
@@ -727,7 +724,7 @@ CREATE TABLE swimlanes (
-- Name: swimlanes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE swimlanes_id_seq
+CREATE SEQUENCE "swimlanes_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -739,23 +736,23 @@ 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 "swimlanes_id_seq" OWNED BY "swimlanes"."id";
--
--- Name: task_has_external_links; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_external_links; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE task_has_external_links (
- id integer NOT NULL,
- link_type character varying(100) NOT NULL,
- dependency character varying(100) NOT NULL,
- title character varying(255) NOT NULL,
- url character varying(255) NOT NULL,
- date_creation integer NOT NULL,
- date_modification integer NOT NULL,
- task_id integer NOT NULL,
- creator_id integer DEFAULT 0
+CREATE TABLE "task_has_external_links" (
+ "id" integer NOT NULL,
+ "link_type" character varying(100) NOT NULL,
+ "dependency" character varying(100) NOT NULL,
+ "title" character varying(255) NOT NULL,
+ "url" character varying(255) NOT NULL,
+ "date_creation" integer NOT NULL,
+ "date_modification" integer NOT NULL,
+ "task_id" integer NOT NULL,
+ "creator_id" integer DEFAULT 0
);
@@ -763,7 +760,7 @@ 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 "task_has_external_links_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -775,22 +772,22 @@ 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 "task_has_external_links_id_seq" OWNED BY "task_has_external_links"."id";
--
--- Name: task_has_files; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_files; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE task_has_files (
- id integer NOT NULL,
- name character varying(255) NOT NULL,
- path character varying(255),
- is_image boolean DEFAULT false,
- task_id integer NOT NULL,
- date bigint DEFAULT 0 NOT NULL,
- user_id integer DEFAULT 0 NOT NULL,
- size integer DEFAULT 0 NOT NULL
+CREATE TABLE "task_has_files" (
+ "id" integer NOT NULL,
+ "name" character varying(255) NOT NULL,
+ "path" character varying(255),
+ "is_image" boolean DEFAULT false,
+ "task_id" integer NOT NULL,
+ "date" bigint DEFAULT 0 NOT NULL,
+ "user_id" integer DEFAULT 0 NOT NULL,
+ "size" integer DEFAULT 0 NOT NULL
);
@@ -798,7 +795,7 @@ 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 "task_has_files_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -810,18 +807,18 @@ 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 "task_has_files_id_seq" OWNED BY "task_has_files"."id";
--
--- Name: task_has_links; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_links; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE task_has_links (
- id integer NOT NULL,
- link_id integer NOT NULL,
- task_id integer NOT NULL,
- opposite_task_id integer NOT NULL
+CREATE TABLE "task_has_links" (
+ "id" integer NOT NULL,
+ "link_id" integer NOT NULL,
+ "task_id" integer NOT NULL,
+ "opposite_task_id" integer NOT NULL
);
@@ -829,7 +826,7 @@ 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 "task_has_links_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -841,19 +838,19 @@ 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 "task_has_links_id_seq" OWNED BY "task_has_links"."id";
--
--- Name: task_has_metadata; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_metadata; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE task_has_metadata (
- task_id integer NOT NULL,
- name character varying(50) NOT NULL,
- value character varying(255) DEFAULT ''::character varying,
- changed_by integer DEFAULT 0 NOT NULL,
- changed_on integer DEFAULT 0 NOT NULL
+CREATE TABLE "task_has_metadata" (
+ "task_id" integer NOT NULL,
+ "name" character varying(50) NOT NULL,
+ "value" character varying(255) DEFAULT ''::character varying,
+ "changed_by" integer DEFAULT 0 NOT NULL,
+ "changed_on" integer DEFAULT 0 NOT NULL
);
@@ -861,7 +858,7 @@ 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 "task_has_subtasks_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -873,44 +870,44 @@ 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 "task_has_subtasks_id_seq" OWNED BY "subtasks"."id";
--
--- Name: tasks; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: tasks; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE tasks (
- id integer NOT NULL,
- title character varying(255) NOT NULL,
- description text,
- date_creation bigint,
- color_id character varying(255),
- project_id integer NOT NULL,
- column_id integer NOT NULL,
- owner_id integer DEFAULT 0,
+CREATE TABLE "tasks" (
+ "id" integer NOT NULL,
+ "title" character varying(255) NOT NULL,
+ "description" "text",
+ "date_creation" bigint,
+ "color_id" character varying(255),
+ "project_id" integer NOT NULL,
+ "column_id" integer NOT NULL,
+ "owner_id" integer DEFAULT 0,
"position" integer,
- is_active boolean DEFAULT true,
- date_completed bigint,
- score integer,
- date_due bigint,
- category_id integer DEFAULT 0,
- creator_id integer DEFAULT 0,
- date_modification integer DEFAULT 0,
- reference character varying(50) DEFAULT ''::character varying,
- date_started bigint,
- time_spent double precision DEFAULT 0,
- time_estimated double precision DEFAULT 0,
- swimlane_id integer DEFAULT 0,
- date_moved bigint DEFAULT 0,
- recurrence_status integer DEFAULT 0 NOT NULL,
- recurrence_trigger integer DEFAULT 0 NOT NULL,
- recurrence_factor integer DEFAULT 0 NOT NULL,
- recurrence_timeframe integer DEFAULT 0 NOT NULL,
- recurrence_basedate integer DEFAULT 0 NOT NULL,
- recurrence_parent integer,
- recurrence_child integer,
- priority integer DEFAULT 0
+ "is_active" boolean DEFAULT true,
+ "date_completed" bigint,
+ "score" integer,
+ "date_due" bigint,
+ "category_id" integer DEFAULT 0,
+ "creator_id" integer DEFAULT 0,
+ "date_modification" integer DEFAULT 0,
+ "reference" character varying(50) DEFAULT ''::character varying,
+ "date_started" bigint,
+ "time_spent" double precision DEFAULT 0,
+ "time_estimated" double precision DEFAULT 0,
+ "swimlane_id" integer DEFAULT 0,
+ "date_moved" bigint DEFAULT 0,
+ "recurrence_status" integer DEFAULT 0 NOT NULL,
+ "recurrence_trigger" integer DEFAULT 0 NOT NULL,
+ "recurrence_factor" integer DEFAULT 0 NOT NULL,
+ "recurrence_timeframe" integer DEFAULT 0 NOT NULL,
+ "recurrence_basedate" integer DEFAULT 0 NOT NULL,
+ "recurrence_parent" integer,
+ "recurrence_child" integer,
+ "priority" integer DEFAULT 0
);
@@ -918,7 +915,7 @@ CREATE TABLE tasks (
-- Name: tasks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE tasks_id_seq
+CREATE SEQUENCE "tasks_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -930,22 +927,22 @@ 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 "tasks_id_seq" OWNED BY "tasks"."id";
--
--- Name: transitions; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: transitions; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE transitions (
- id integer NOT NULL,
- user_id integer NOT NULL,
- project_id integer NOT NULL,
- task_id integer NOT NULL,
- src_column_id integer NOT NULL,
- dst_column_id integer NOT NULL,
- date bigint NOT NULL,
- time_spent integer DEFAULT 0
+CREATE TABLE "transitions" (
+ "id" integer NOT NULL,
+ "user_id" integer NOT NULL,
+ "project_id" integer NOT NULL,
+ "task_id" integer NOT NULL,
+ "src_column_id" integer NOT NULL,
+ "dst_column_id" integer NOT NULL,
+ "date" bigint NOT NULL,
+ "time_spent" integer DEFAULT 0
);
@@ -953,7 +950,7 @@ CREATE TABLE transitions (
-- Name: transitions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE transitions_id_seq
+CREATE SEQUENCE "transitions_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -965,30 +962,30 @@ 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 "transitions_id_seq" OWNED BY "transitions"."id";
--
--- Name: user_has_metadata; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_metadata; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE user_has_metadata (
- user_id integer NOT NULL,
- name character varying(50) NOT NULL,
- value character varying(255) DEFAULT ''::character varying,
- changed_by integer DEFAULT 0 NOT NULL,
- changed_on integer DEFAULT 0 NOT NULL
+CREATE TABLE "user_has_metadata" (
+ "user_id" integer NOT NULL,
+ "name" character varying(50) NOT NULL,
+ "value" character varying(255) DEFAULT ''::character varying,
+ "changed_by" integer DEFAULT 0 NOT NULL,
+ "changed_on" integer DEFAULT 0 NOT NULL
);
--
--- Name: user_has_notification_types; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_notification_types; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE user_has_notification_types (
- id integer NOT NULL,
- user_id integer NOT NULL,
- notification_type character varying(50)
+CREATE TABLE "user_has_notification_types" (
+ "id" integer NOT NULL,
+ "user_id" integer NOT NULL,
+ "notification_type" character varying(50)
);
@@ -996,7 +993,7 @@ 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 "user_has_notification_types_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -1008,29 +1005,29 @@ 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 "user_has_notification_types_id_seq" OWNED BY "user_has_notification_types"."id";
--
--- Name: user_has_notifications; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_notifications; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE user_has_notifications (
- user_id integer NOT NULL,
- project_id integer
+CREATE TABLE "user_has_notifications" (
+ "user_id" integer NOT NULL,
+ "project_id" integer
);
--
--- Name: user_has_unread_notifications; Type: TABLE; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_unread_notifications; Type: TABLE; Schema: public; Owner: -
--
-CREATE TABLE user_has_unread_notifications (
- id integer NOT NULL,
- user_id integer NOT NULL,
- date_creation bigint NOT NULL,
- event_name character varying(50) NOT NULL,
- event_data text NOT NULL
+CREATE TABLE "user_has_unread_notifications" (
+ "id" integer NOT NULL,
+ "user_id" integer NOT NULL,
+ "date_creation" bigint NOT NULL,
+ "event_name" character varying(50) NOT NULL,
+ "event_data" "text" NOT NULL
);
@@ -1038,7 +1035,7 @@ 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 "user_has_unread_notifications_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -1050,36 +1047,36 @@ 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;
-
-
---
--- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
---
-
-CREATE TABLE users (
- id integer NOT NULL,
- username character varying(50) NOT NULL,
- password character varying(255),
- is_ldap_user boolean DEFAULT false,
- name character varying(255),
- email character varying(255),
- google_id character varying(255),
- github_id character varying(30),
- notifications_enabled boolean DEFAULT false,
- timezone character varying(50),
- language character varying(5),
- disable_login_form boolean DEFAULT false,
- twofactor_activated boolean DEFAULT false,
- twofactor_secret character(16),
- token character varying(255) DEFAULT ''::character varying,
- notifications_filter integer DEFAULT 4,
- nb_failed_login integer DEFAULT 0,
- lock_expiration_date bigint DEFAULT 0,
- gitlab_id integer,
- role character varying(25) DEFAULT 'app-user'::character varying NOT NULL,
- is_active boolean DEFAULT true,
- avatar_path character varying(255)
+ALTER SEQUENCE "user_has_unread_notifications_id_seq" OWNED BY "user_has_unread_notifications"."id";
+
+
+--
+-- Name: users; Type: TABLE; Schema: public; Owner: -
+--
+
+CREATE TABLE "users" (
+ "id" integer NOT NULL,
+ "username" character varying(50) NOT NULL,
+ "password" character varying(255),
+ "is_ldap_user" boolean DEFAULT false,
+ "name" character varying(255),
+ "email" character varying(255),
+ "google_id" character varying(255),
+ "github_id" character varying(30),
+ "notifications_enabled" boolean DEFAULT false,
+ "timezone" character varying(50),
+ "language" character varying(5),
+ "disable_login_form" boolean DEFAULT false,
+ "twofactor_activated" boolean DEFAULT false,
+ "twofactor_secret" character(16),
+ "token" character varying(255) DEFAULT ''::character varying,
+ "notifications_filter" integer DEFAULT 4,
+ "nb_failed_login" integer DEFAULT 0,
+ "lock_expiration_date" bigint DEFAULT 0,
+ "gitlab_id" integer,
+ "role" character varying(25) DEFAULT 'app-user'::character varying NOT NULL,
+ "is_active" boolean DEFAULT true,
+ "avatar_path" character varying(255)
);
@@ -1087,7 +1084,7 @@ CREATE TABLE users (
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
-CREATE SEQUENCE users_id_seq
+CREATE SEQUENCE "users_id_seq"
START WITH 1
INCREMENT BY 1
NO MINVALUE
@@ -1099,1034 +1096,1034 @@ 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 "users_id_seq" OWNED BY "users"."id";
--
-- Name: 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 "action_has_params" ALTER COLUMN "id" SET DEFAULT "nextval"('"action_has_params_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY actions ALTER COLUMN id SET DEFAULT nextval('actions_id_seq'::regclass);
+ALTER TABLE ONLY "actions" ALTER COLUMN "id" SET DEFAULT "nextval"('"actions_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY columns ALTER COLUMN id SET DEFAULT nextval('columns_id_seq'::regclass);
+ALTER TABLE ONLY "columns" ALTER COLUMN "id" SET DEFAULT "nextval"('"columns_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY comments ALTER COLUMN id SET DEFAULT nextval('comments_id_seq'::regclass);
+ALTER TABLE ONLY "comments" ALTER COLUMN "id" SET DEFAULT "nextval"('"comments_id_seq"'::"regclass");
--
-- Name: 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 "custom_filters" ALTER COLUMN "id" SET DEFAULT "nextval"('"custom_filters_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY groups ALTER COLUMN id SET DEFAULT nextval('groups_id_seq'::regclass);
+ALTER TABLE ONLY "groups" ALTER COLUMN "id" SET DEFAULT "nextval"('"groups_id_seq"'::"regclass");
--
-- Name: 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 "last_logins" ALTER COLUMN "id" SET DEFAULT "nextval"('"last_logins_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY links ALTER COLUMN id SET DEFAULT nextval('links_id_seq'::regclass);
+ALTER TABLE ONLY "links" ALTER COLUMN "id" SET DEFAULT "nextval"('"links_id_seq"'::"regclass");
--
-- Name: 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 "project_activities" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_activities_id_seq"'::"regclass");
--
-- Name: 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 "project_daily_column_stats" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_daily_summaries_id_seq"'::"regclass");
--
-- Name: 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 "project_daily_stats" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_daily_stats_id_seq"'::"regclass");
--
-- Name: 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 "project_has_categories" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_has_categories_id_seq"'::"regclass");
--
-- Name: 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 "project_has_files" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_has_files_id_seq"'::"regclass");
--
-- Name: 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 "project_has_notification_types" ALTER COLUMN "id" SET DEFAULT "nextval"('"project_has_notification_types_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY projects ALTER COLUMN id SET DEFAULT nextval('projects_id_seq'::regclass);
+ALTER TABLE ONLY "projects" ALTER COLUMN "id" SET DEFAULT "nextval"('"projects_id_seq"'::"regclass");
--
-- Name: 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 "remember_me" ALTER COLUMN "id" SET DEFAULT "nextval"('"remember_me_id_seq"'::"regclass");
--
-- Name: 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 "subtask_time_tracking" ALTER COLUMN "id" SET DEFAULT "nextval"('"subtask_time_tracking_id_seq"'::"regclass");
--
-- Name: 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 "subtasks" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_subtasks_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY swimlanes ALTER COLUMN id SET DEFAULT nextval('swimlanes_id_seq'::regclass);
+ALTER TABLE ONLY "swimlanes" ALTER COLUMN "id" SET DEFAULT "nextval"('"swimlanes_id_seq"'::"regclass");
--
-- Name: 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 "task_has_external_links" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_external_links_id_seq"'::"regclass");
--
-- Name: 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 "task_has_files" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_files_id_seq"'::"regclass");
--
-- Name: 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 "task_has_links" ALTER COLUMN "id" SET DEFAULT "nextval"('"task_has_links_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY tasks ALTER COLUMN id SET DEFAULT nextval('tasks_id_seq'::regclass);
+ALTER TABLE ONLY "tasks" ALTER COLUMN "id" SET DEFAULT "nextval"('"tasks_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY transitions ALTER COLUMN id SET DEFAULT nextval('transitions_id_seq'::regclass);
+ALTER TABLE ONLY "transitions" ALTER COLUMN "id" SET DEFAULT "nextval"('"transitions_id_seq"'::"regclass");
--
-- Name: 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 "user_has_notification_types" ALTER COLUMN "id" SET DEFAULT "nextval"('"user_has_notification_types_id_seq"'::"regclass");
--
-- Name: 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 "user_has_unread_notifications" ALTER COLUMN "id" SET DEFAULT "nextval"('"user_has_unread_notifications_id_seq"'::"regclass");
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
-ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
+ALTER TABLE ONLY "users" ALTER COLUMN "id" SET DEFAULT "nextval"('"users_id_seq"'::"regclass");
--
--- Name: action_has_params_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: action_has_params_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY action_has_params
- ADD CONSTRAINT action_has_params_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "action_has_params"
+ ADD CONSTRAINT "action_has_params_pkey" PRIMARY KEY ("id");
--
--- Name: actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY actions
- ADD CONSTRAINT actions_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "actions"
+ ADD CONSTRAINT "actions_pkey" PRIMARY KEY ("id");
--
--- Name: columns_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: columns_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY columns
- ADD CONSTRAINT columns_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "columns"
+ ADD CONSTRAINT "columns_pkey" PRIMARY KEY ("id");
--
--- Name: columns_title_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: columns_title_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY columns
- ADD CONSTRAINT columns_title_project_id_key UNIQUE (title, project_id);
+ALTER TABLE ONLY "columns"
+ ADD CONSTRAINT "columns_title_project_id_key" UNIQUE ("title", "project_id");
--
--- Name: comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY comments
- ADD CONSTRAINT comments_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "comments"
+ ADD CONSTRAINT "comments_pkey" PRIMARY KEY ("id");
--
--- Name: currencies_currency_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: currencies_currency_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY currencies
- ADD CONSTRAINT currencies_currency_key UNIQUE (currency);
+ALTER TABLE ONLY "currencies"
+ ADD CONSTRAINT "currencies_currency_key" UNIQUE ("currency");
--
--- Name: custom_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: custom_filters_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY custom_filters
- ADD CONSTRAINT custom_filters_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "custom_filters"
+ ADD CONSTRAINT "custom_filters_pkey" PRIMARY KEY ("id");
--
--- Name: group_has_users_group_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: group_has_users_group_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY group_has_users
- ADD CONSTRAINT group_has_users_group_id_user_id_key UNIQUE (group_id, user_id);
+ALTER TABLE ONLY "group_has_users"
+ ADD CONSTRAINT "group_has_users_group_id_user_id_key" UNIQUE ("group_id", "user_id");
--
--- Name: groups_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: groups_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY groups
- ADD CONSTRAINT groups_name_key UNIQUE (name);
+ALTER TABLE ONLY "groups"
+ ADD CONSTRAINT "groups_name_key" UNIQUE ("name");
--
--- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY groups
- ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "groups"
+ ADD CONSTRAINT "groups_pkey" PRIMARY KEY ("id");
--
--- Name: last_logins_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: last_logins_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY last_logins
- ADD CONSTRAINT last_logins_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "last_logins"
+ ADD CONSTRAINT "last_logins_pkey" PRIMARY KEY ("id");
--
--- Name: links_label_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: links_label_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY links
- ADD CONSTRAINT links_label_key UNIQUE (label);
+ALTER TABLE ONLY "links"
+ ADD CONSTRAINT "links_label_key" UNIQUE ("label");
--
--- Name: links_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY links
- ADD CONSTRAINT links_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "links"
+ ADD CONSTRAINT "links_pkey" PRIMARY KEY ("id");
--
--- Name: password_reset_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: password_reset_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY password_reset
- ADD CONSTRAINT password_reset_pkey PRIMARY KEY (token);
+ALTER TABLE ONLY "password_reset"
+ ADD CONSTRAINT "password_reset_pkey" PRIMARY KEY ("token");
--
--- Name: plugin_schema_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: plugin_schema_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY plugin_schema_versions
- ADD CONSTRAINT plugin_schema_versions_pkey PRIMARY KEY (plugin);
+ALTER TABLE ONLY "plugin_schema_versions"
+ ADD CONSTRAINT "plugin_schema_versions_pkey" PRIMARY KEY ("plugin");
--
--- Name: project_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_activities_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_activities
- ADD CONSTRAINT project_activities_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "project_activities"
+ ADD CONSTRAINT "project_activities_pkey" PRIMARY KEY ("id");
--
--- Name: project_daily_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_daily_stats_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_daily_stats
- ADD CONSTRAINT project_daily_stats_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "project_daily_stats"
+ ADD CONSTRAINT "project_daily_stats_pkey" PRIMARY KEY ("id");
--
--- Name: project_daily_summaries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_daily_summaries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_daily_column_stats
- ADD CONSTRAINT project_daily_summaries_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "project_daily_column_stats"
+ ADD CONSTRAINT "project_daily_summaries_pkey" PRIMARY KEY ("id");
--
--- Name: project_has_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_categories_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_categories
- ADD CONSTRAINT project_has_categories_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "project_has_categories"
+ ADD CONSTRAINT "project_has_categories_pkey" PRIMARY KEY ("id");
--
--- Name: project_has_categories_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_categories_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_categories
- ADD CONSTRAINT project_has_categories_project_id_name_key UNIQUE (project_id, name);
+ALTER TABLE ONLY "project_has_categories"
+ ADD CONSTRAINT "project_has_categories_project_id_name_key" UNIQUE ("project_id", "name");
--
--- Name: project_has_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_files
- ADD CONSTRAINT project_has_files_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "project_has_files"
+ ADD CONSTRAINT "project_has_files_pkey" PRIMARY KEY ("id");
--
--- Name: project_has_groups_group_id_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_groups_group_id_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_groups
- ADD CONSTRAINT project_has_groups_group_id_project_id_key UNIQUE (group_id, project_id);
+ALTER TABLE ONLY "project_has_groups"
+ ADD CONSTRAINT "project_has_groups_group_id_project_id_key" UNIQUE ("group_id", "project_id");
--
--- Name: project_has_metadata_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_metadata_project_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_metadata
- ADD CONSTRAINT project_has_metadata_project_id_name_key UNIQUE (project_id, name);
+ALTER TABLE ONLY "project_has_metadata"
+ ADD CONSTRAINT "project_has_metadata_project_id_name_key" UNIQUE ("project_id", "name");
--
--- Name: project_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_notification_types
- ADD CONSTRAINT project_has_notification_types_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "project_has_notification_types"
+ ADD CONSTRAINT "project_has_notification_types_pkey" PRIMARY KEY ("id");
--
--- Name: project_has_notification_types_project_id_notification_type_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_notification_types_project_id_notification_type_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_notification_types
- ADD CONSTRAINT project_has_notification_types_project_id_notification_type_key UNIQUE (project_id, notification_type);
+ALTER TABLE ONLY "project_has_notification_types"
+ ADD CONSTRAINT "project_has_notification_types_project_id_notification_type_key" UNIQUE ("project_id", "notification_type");
--
--- Name: project_has_users_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: project_has_users_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_users
- ADD CONSTRAINT project_has_users_project_id_user_id_key UNIQUE (project_id, user_id);
+ALTER TABLE ONLY "project_has_users"
+ ADD CONSTRAINT "project_has_users_project_id_user_id_key" UNIQUE ("project_id", "user_id");
--
--- Name: projects_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: projects_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY projects
- ADD CONSTRAINT projects_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "projects"
+ ADD CONSTRAINT "projects_pkey" PRIMARY KEY ("id");
--
--- Name: remember_me_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: remember_me_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY remember_me
- ADD CONSTRAINT remember_me_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "remember_me"
+ ADD CONSTRAINT "remember_me_pkey" PRIMARY KEY ("id");
--
--- Name: settings_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: settings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY settings
- ADD CONSTRAINT settings_pkey PRIMARY KEY (option);
+ALTER TABLE ONLY "settings"
+ ADD CONSTRAINT "settings_pkey" PRIMARY KEY ("option");
--
--- Name: subtask_time_tracking_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: subtask_time_tracking_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY subtask_time_tracking
- ADD CONSTRAINT subtask_time_tracking_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "subtask_time_tracking"
+ ADD CONSTRAINT "subtask_time_tracking_pkey" PRIMARY KEY ("id");
--
--- Name: swimlanes_name_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: swimlanes_name_project_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY swimlanes
- ADD CONSTRAINT swimlanes_name_project_id_key UNIQUE (name, project_id);
+ALTER TABLE ONLY "swimlanes"
+ ADD CONSTRAINT "swimlanes_name_project_id_key" UNIQUE ("name", "project_id");
--
--- Name: swimlanes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: swimlanes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY swimlanes
- ADD CONSTRAINT swimlanes_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "swimlanes"
+ ADD CONSTRAINT "swimlanes_pkey" PRIMARY KEY ("id");
--
--- Name: task_has_external_links_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_external_links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY task_has_external_links
- ADD CONSTRAINT task_has_external_links_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "task_has_external_links"
+ ADD CONSTRAINT "task_has_external_links_pkey" PRIMARY KEY ("id");
--
--- Name: task_has_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY task_has_files
- ADD CONSTRAINT task_has_files_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "task_has_files"
+ ADD CONSTRAINT "task_has_files_pkey" PRIMARY KEY ("id");
--
--- Name: task_has_links_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_links_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY task_has_links
- ADD CONSTRAINT task_has_links_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "task_has_links"
+ ADD CONSTRAINT "task_has_links_pkey" PRIMARY KEY ("id");
--
--- Name: task_has_metadata_task_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_metadata_task_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY task_has_metadata
- ADD CONSTRAINT task_has_metadata_task_id_name_key UNIQUE (task_id, name);
+ALTER TABLE ONLY "task_has_metadata"
+ ADD CONSTRAINT "task_has_metadata_task_id_name_key" UNIQUE ("task_id", "name");
--
--- Name: task_has_subtasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: task_has_subtasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY subtasks
- ADD CONSTRAINT task_has_subtasks_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "subtasks"
+ ADD CONSTRAINT "task_has_subtasks_pkey" PRIMARY KEY ("id");
--
--- Name: tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY tasks
- ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "tasks"
+ ADD CONSTRAINT "tasks_pkey" PRIMARY KEY ("id");
--
--- Name: transitions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: transitions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY transitions
- ADD CONSTRAINT transitions_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "transitions"
+ ADD CONSTRAINT "transitions_pkey" PRIMARY KEY ("id");
--
--- Name: user_has_metadata_user_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_metadata_user_id_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY user_has_metadata
- ADD CONSTRAINT user_has_metadata_user_id_name_key UNIQUE (user_id, name);
+ALTER TABLE ONLY "user_has_metadata"
+ ADD CONSTRAINT "user_has_metadata_user_id_name_key" UNIQUE ("user_id", "name");
--
--- Name: user_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_notification_types_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY user_has_notification_types
- ADD CONSTRAINT user_has_notification_types_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "user_has_notification_types"
+ ADD CONSTRAINT "user_has_notification_types_pkey" PRIMARY KEY ("id");
--
--- Name: user_has_notifications_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_notifications_project_id_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY user_has_notifications
- ADD CONSTRAINT user_has_notifications_project_id_user_id_key UNIQUE (project_id, user_id);
+ALTER TABLE ONLY "user_has_notifications"
+ ADD CONSTRAINT "user_has_notifications_project_id_user_id_key" UNIQUE ("project_id", "user_id");
--
--- Name: user_has_unread_notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: user_has_unread_notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY user_has_unread_notifications
- ADD CONSTRAINT user_has_unread_notifications_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "user_has_unread_notifications"
+ ADD CONSTRAINT "user_has_unread_notifications_pkey" PRIMARY KEY ("id");
--
--- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
+-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY users
- ADD CONSTRAINT users_pkey PRIMARY KEY (id);
+ALTER TABLE ONLY "users"
+ ADD CONSTRAINT "users_pkey" PRIMARY KEY ("id");
--
--- Name: categories_project_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "project_has_categories" USING "btree" ("project_id");
--
--- Name: columns_project_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "columns" USING "btree" ("project_id");
--
--- Name: comments_reference_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "comments" USING "btree" ("reference");
--
--- Name: comments_task_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "comments" USING "btree" ("task_id");
--
--- Name: files_task_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "task_has_files" USING "btree" ("task_id");
--
--- Name: project_daily_column_stats_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "project_daily_column_stats" USING "btree" ("day", "project_id", "column_id");
--
--- Name: project_daily_stats_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "project_daily_stats" USING "btree" ("day", "project_id");
--
--- Name: subtasks_task_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "subtasks" USING "btree" ("task_id");
--
--- Name: swimlanes_project_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "swimlanes" USING "btree" ("project_id");
--
--- Name: task_has_links_task_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "task_has_links" USING "btree" ("task_id");
--
--- Name: task_has_links_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "task_has_links" USING "btree" ("link_id", "task_id", "opposite_task_id");
--
--- Name: tasks_project_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "tasks" USING "btree" ("project_id");
--
--- Name: tasks_reference_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "tasks" USING "btree" ("reference");
--
--- Name: transitions_project_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "transitions" USING "btree" ("project_id");
--
--- Name: transitions_task_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "transitions" USING "btree" ("task_id");
--
--- Name: transitions_user_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "transitions" USING "btree" ("user_id");
--
--- Name: user_has_notification_types_user_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "user_has_notification_types" USING "btree" ("user_id", "notification_type");
--
--- Name: users_username_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
+-- 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 "users" USING "btree" ("username");
--
-- Name: 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 "action_has_params"
+ ADD CONSTRAINT "action_has_params_action_id_fkey" FOREIGN KEY ("action_id") REFERENCES "actions"("id") ON DELETE CASCADE;
--
-- Name: 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 "actions"
+ ADD CONSTRAINT "actions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "columns"
+ ADD CONSTRAINT "columns_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "comments"
+ ADD CONSTRAINT "comments_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "group_has_users"
+ ADD CONSTRAINT "group_has_users_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE CASCADE;
--
-- Name: 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 "group_has_users"
+ ADD CONSTRAINT "group_has_users_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "last_logins"
+ ADD CONSTRAINT "last_logins_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "password_reset"
+ ADD CONSTRAINT "password_reset_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_activities"
+ ADD CONSTRAINT "project_activities_creator_id_fkey" FOREIGN KEY ("creator_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_activities"
+ ADD CONSTRAINT "project_activities_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_activities"
+ ADD CONSTRAINT "project_activities_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_daily_stats"
+ ADD CONSTRAINT "project_daily_stats_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_daily_column_stats"
+ ADD CONSTRAINT "project_daily_summaries_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "columns"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_daily_column_stats"
+ ADD CONSTRAINT "project_daily_summaries_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_has_categories"
+ ADD CONSTRAINT "project_has_categories_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_has_files"
+ ADD CONSTRAINT "project_has_files_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_has_groups"
+ ADD CONSTRAINT "project_has_groups_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_has_groups"
+ ADD CONSTRAINT "project_has_groups_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "project_has_metadata"
+ ADD CONSTRAINT "project_has_metadata_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: project_has_notification_types_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_notification_types
- ADD CONSTRAINT project_has_notification_types_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
+ALTER TABLE ONLY "project_has_notification_types"
+ ADD CONSTRAINT "project_has_notification_types_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: project_has_users_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY project_has_users
- ADD CONSTRAINT project_has_users_project_id_fkey FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE;
+ALTER TABLE ONLY "project_has_users"
+ ADD CONSTRAINT "project_has_users_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: project_has_users_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-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 "project_has_users"
+ ADD CONSTRAINT "project_has_users_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "remember_me"
+ ADD CONSTRAINT "remember_me_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "subtask_time_tracking"
+ ADD CONSTRAINT "subtask_time_tracking_subtask_id_fkey" FOREIGN KEY ("subtask_id") REFERENCES "subtasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "subtask_time_tracking"
+ ADD CONSTRAINT "subtask_time_tracking_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "swimlanes"
+ ADD CONSTRAINT "swimlanes_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "task_has_external_links"
+ ADD CONSTRAINT "task_has_external_links_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "task_has_files"
+ ADD CONSTRAINT "task_has_files_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "task_has_links"
+ ADD CONSTRAINT "task_has_links_link_id_fkey" FOREIGN KEY ("link_id") REFERENCES "links"("id") ON DELETE CASCADE;
--
-- Name: 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 "task_has_links"
+ ADD CONSTRAINT "task_has_links_opposite_task_id_fkey" FOREIGN KEY ("opposite_task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "task_has_links"
+ ADD CONSTRAINT "task_has_links_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: task_has_metadata_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY task_has_metadata
- ADD CONSTRAINT task_has_metadata_task_id_fkey FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE;
+ALTER TABLE ONLY "task_has_metadata"
+ ADD CONSTRAINT "task_has_metadata_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: task_has_subtasks_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-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 "subtasks"
+ ADD CONSTRAINT "task_has_subtasks_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "tasks"
+ ADD CONSTRAINT "tasks_column_id_fkey" FOREIGN KEY ("column_id") REFERENCES "columns"("id") ON DELETE CASCADE;
--
-- Name: 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 "tasks"
+ ADD CONSTRAINT "tasks_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "transitions"
+ ADD CONSTRAINT "transitions_dst_column_id_fkey" FOREIGN KEY ("dst_column_id") REFERENCES "columns"("id") ON DELETE CASCADE;
--
-- Name: 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 "transitions"
+ ADD CONSTRAINT "transitions_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "transitions"
+ ADD CONSTRAINT "transitions_src_column_id_fkey" FOREIGN KEY ("src_column_id") REFERENCES "columns"("id") ON DELETE CASCADE;
--
-- Name: 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 "transitions"
+ ADD CONSTRAINT "transitions_task_id_fkey" FOREIGN KEY ("task_id") REFERENCES "tasks"("id") ON DELETE CASCADE;
--
-- Name: 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 "transitions"
+ ADD CONSTRAINT "transitions_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: user_has_metadata_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-ALTER TABLE ONLY user_has_metadata
- ADD CONSTRAINT user_has_metadata_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;
+ALTER TABLE ONLY "user_has_metadata"
+ ADD CONSTRAINT "user_has_metadata_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: user_has_notification_types_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
-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 "user_has_notification_types"
+ ADD CONSTRAINT "user_has_notification_types_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "user_has_notifications"
+ ADD CONSTRAINT "user_has_notifications_project_id_fkey" FOREIGN KEY ("project_id") REFERENCES "projects"("id") ON DELETE CASCADE;
--
-- Name: 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 "user_has_notifications"
+ ADD CONSTRAINT "user_has_notifications_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
-- Name: 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 "user_has_unread_notifications"
+ ADD CONSTRAINT "user_has_unread_notifications_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE CASCADE;
--
@@ -2137,12 +2134,16 @@ ALTER TABLE ONLY user_has_unread_notifications
-- PostgreSQL database dump
--
+-- Dumped from database version 9.5.2
+-- Dumped by pg_dump version 9.5.2
+
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
+SET row_security = off;
SET search_path = public, pg_catalog;
@@ -2154,8 +2155,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_high
INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_public_refresh_interval', '60', 0, 0);
INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_private_refresh_interval', '10', 0, 0);
INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_columns', '', 0, 0);
-INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '67545fef6a0a3f43d60c7d57632d6e4af9930f064c12e72266b1c9b42381', 0, 0);
-INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', 'c16b1c5896b258409a5eb344152b5b33c8ef4c58902bc543fc1348c37975', 0, 0);
+INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '85b9f242e49f4c50176591a2f9b812c626384b89ff985a02068455a5be07', 0, 0);
+INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '207d1aaeb9d6d5c01f9ef1e6d61baca86c4c66fdd0b95e76b5c5953681e4', 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);
@@ -2183,12 +2184,16 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('password_r
-- PostgreSQL database dump
--
+-- Dumped from database version 9.5.2
+-- Dumped by pg_dump version 9.5.2
+
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
+SET row_security = off;
SET search_path = public, pg_catalog;
@@ -2220,4 +2225,4 @@ SELECT pg_catalog.setval('links_id_seq', 11, true);
-- PostgreSQL database dump complete
--
-INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$e.SftITKuBvXeNbxtmTKS.KAbIy4Mx09t254BAiEAuWOxkuS4xfLG', 'app-admin');INSERT INTO schema_version VALUES ('89');
+INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$kliMGeKgDYtx9Igek9jGDu0eZM.KXivgzvqtnMuWMkjvZiIc.8p8S', 'app-admin');INSERT INTO schema_version VALUES ('89');