1 | /* TODO: ESSAS TABELAS SERAO INCLUIDAS PARA SEREM INSTALADAS JUNTAMENTE COM A FERRAMENTA*/ |
---|
2 | /********* CRIANDO AS SEQUENCES ********************************************************/ |
---|
3 | |
---|
4 | CREATE SEQUENCE seq_egw_wf_agile_projects |
---|
5 | START WITH 1 |
---|
6 | INCREMENT BY 1 |
---|
7 | NO MAXVALUE |
---|
8 | NO MINVALUE |
---|
9 | CACHE 1; |
---|
10 | |
---|
11 | CREATE SEQUENCE seq_egw_wf_agile_tasks |
---|
12 | START WITH 1 |
---|
13 | INCREMENT BY 1 |
---|
14 | NO MAXVALUE |
---|
15 | NO MINVALUE |
---|
16 | CACHE 1; |
---|
17 | |
---|
18 | CREATE SEQUENCE seq_egw_wf_agile_users_projects |
---|
19 | START WITH 1 |
---|
20 | INCREMENT BY 1 |
---|
21 | NO MAXVALUE |
---|
22 | NO MINVALUE |
---|
23 | CACHE 1; |
---|
24 | |
---|
25 | CREATE SEQUENCE seq_egw_wf_agile_sprints |
---|
26 | START WITH 1 |
---|
27 | INCREMENT BY 1 |
---|
28 | NO MAXVALUE |
---|
29 | NO MINVALUE |
---|
30 | CACHE 1; |
---|
31 | |
---|
32 | ALTER TABLE public.seq_egw_wf_agile_projects OWNER TO postgres; |
---|
33 | ALTER TABLE public.seq_egw_wf_agile_tasks OWNER TO postgres; |
---|
34 | ALTER TABLE public.seq_egw_wf_agile_users_projects OWNER TO postgres; |
---|
35 | ALTER TABLE public.seq_egw_wf_agile_sprints OWNER TO postgres; |
---|
36 | |
---|
37 | SELECT pg_catalog.setval('seq_egw_wf_agile_projects', 1, false); |
---|
38 | SELECT pg_catalog.setval('seq_egw_wf_agile_tasks', 1, false); |
---|
39 | SELECT pg_catalog.setval('seq_egw_wf_agile_users_projects', 1, false); |
---|
40 | SELECT pg_catalog.setval('seq_egw_wf_agile_sprints', 1, false); |
---|
41 | |
---|
42 | /****************CRIANDO AS TABELAS***************/ |
---|
43 | |
---|
44 | CREATE TABLE phpgw_agile_projects ( |
---|
45 | proj_id integer DEFAULT nextval('seq_egw_wf_agile_projects'::regclass) PRIMARY KEY NOT NULL, |
---|
46 | proj_name varchar (100) NOT NULL, |
---|
47 | proj_description varchar (255), |
---|
48 | proj_owner varchar (20) |
---|
49 | ); |
---|
50 | |
---|
51 | CREATE TABLE phpgw_agile_sprints( |
---|
52 | sprints_id integer DEFAULT nextval('seq_egw_wf_agile_sprints'::regclass) PRIMARY KEY NOT NULL, |
---|
53 | sprints_id_proj integer references phpgw_agile_projects(proj_id) ON DELETE CASCADE NOT NULL, |
---|
54 | sprints_name varchar (100) NOT NULL, |
---|
55 | sprints_goal varchar (255) NOT NULL, |
---|
56 | sprints_dt_start date NOT NULL, |
---|
57 | sprints_dt_end date NOT NULL, |
---|
58 | sprints_retrospective varchar (255), |
---|
59 | sprints_status boolean DEFAULT false |
---|
60 | ); |
---|
61 | |
---|
62 | CREATE TABLE phpgw_agile_tasks( |
---|
63 | tasks_id integer DEFAULT nextval('seq_egw_wf_agile_tasks'::regclass) PRIMARY KEY NOT NULL, |
---|
64 | tasks_id_sprints integer references phpgw_agile_sprints(sprints_id) ON DELETE CASCADE, |
---|
65 | tasks_id_proj integer references phpgw_agile_projects(proj_id) ON DELETE CASCADE, |
---|
66 | tasks_id_owner integer, |
---|
67 | tasks_estimate integer, |
---|
68 | tasks_title varchar (255), |
---|
69 | tasks_description varchar (255), |
---|
70 | tasks_priority boolean DEFAULT false, |
---|
71 | tasks_status varchar(20) |
---|
72 | ); |
---|
73 | |
---|
74 | CREATE TABLE phpgw_agile_users_projects(uprojects_id_user varchar(100) NOT NULL, |
---|
75 | uprojects_id_project integer NOT NULL, |
---|
76 | uprojects_user_admin boolean NOT NULL, |
---|
77 | uprojects_active boolean NOT NULL, |
---|
78 | FOREIGN KEY(uprojects_id_project) references phpgw_agile_projects(proj_id) ON DELETE CASCADE |
---|
79 | ); |
---|
80 | |
---|
81 | /* ALTERANDO AS PERMISSÃES */ |
---|
82 | ALTER TABLE public.phpgw_agile_projects OWNER TO postgres; |
---|
83 | ALTER TABLE public.phpgw_agile_sprints OWNER TO postgres; |
---|
84 | ALTER TABLE public.phpgw_agile_tasks OWNER TO postgres; |
---|
85 | ALTER TABLE public.phpgw_agile_users_projects OWNER TO postgres; |
---|
86 | |
---|