source: branches/2.2.0.1/agileProjects/TABELAS.SQL @ 4269

Revision 4269, 2.9 KB checked in by rafaelraymundo, 13 years ago (diff)

Ticket #1823 - Adicionada primeira versao do modulo de kanban para avaliacao.

Line 
1/* TODO: ESSAS TABELAS SERAO INCLUIDAS PARA SEREM INSTALADAS JUNTAMENTE COM A FERRAMENTA*/
2/********* CRIANDO AS SEQUENCES ********************************************************/
3
4CREATE SEQUENCE seq_egw_wf_agile_projects
5    START WITH 1
6    INCREMENT BY 1
7    NO MAXVALUE
8    NO MINVALUE
9    CACHE 1;
10
11CREATE SEQUENCE seq_egw_wf_agile_tasks
12    START WITH 1
13    INCREMENT BY 1
14    NO MAXVALUE
15    NO MINVALUE
16    CACHE 1;
17
18CREATE 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
25CREATE SEQUENCE seq_egw_wf_agile_sprints
26    START WITH 1
27    INCREMENT BY 1
28    NO MAXVALUE
29    NO MINVALUE
30    CACHE 1;
31
32ALTER TABLE public.seq_egw_wf_agile_projects OWNER TO postgres;
33ALTER TABLE public.seq_egw_wf_agile_tasks OWNER TO postgres;
34ALTER TABLE public.seq_egw_wf_agile_users_projects OWNER TO postgres;
35ALTER TABLE public.seq_egw_wf_agile_sprints OWNER TO postgres;
36
37SELECT pg_catalog.setval('seq_egw_wf_agile_projects', 1, false);
38SELECT pg_catalog.setval('seq_egw_wf_agile_tasks', 1, false);
39SELECT pg_catalog.setval('seq_egw_wf_agile_users_projects', 1, false);
40SELECT pg_catalog.setval('seq_egw_wf_agile_sprints', 1, false);
41
42/****************CRIANDO AS TABELAS***************/
43
44CREATE 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
51CREATE 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
62CREATE 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
74CREATE TABLE phpgw_agile_users_projects(uprojects_id_user varchar(100) NOT NULL,
75uprojects_id_project integer NOT NULL,
76uprojects_user_admin boolean NOT NULL,
77uprojects_active boolean NOT NULL,
78FOREIGN KEY(uprojects_id_project) references phpgw_agile_projects(proj_id) ON DELETE CASCADE
79);
80
81/* ALTERANDO AS PERMISSÕES */
82ALTER TABLE public.phpgw_agile_projects OWNER TO postgres;
83ALTER TABLE public.phpgw_agile_sprints OWNER TO postgres;
84ALTER TABLE public.phpgw_agile_tasks OWNER TO postgres;
85ALTER TABLE public.phpgw_agile_users_projects OWNER TO postgres;
86
Note: See TracBrowser for help on using the repository browser.