[6779] | 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 | |
---|