4
DROP TABLE IF EXISTS alm_role CASCADE;
5
CREATE TABLE alm_role (idalm_role varchar(8) PRIMARY KEY, alm_role varchar(100));
6
ALTER TABLE public.alm_role OWNER TO almidondemo;
8
DROP TABLE IF EXISTS alm_user CASCADE;
9
CREATE TABLE alm_user (idalm_user varchar(16) PRIMARY KEY, idalm_role varchar(8) REFERENCES alm_role, password varchar(200) NOT NULL, alm_user varchar(200) NOT NULL, email varchar(200));
10
ALTER TABLE public.alm_user OWNER TO almidondemo;
12
DROP TABLE IF EXISTS alm_table CASCADE;
13
CREATE TABLE alm_table (idalm_table varchar(48) PRIMARY KEY, alm_table varchar(100), pkey varchar(50), orden varchar (100), rank int, hidden bool, parent varchar(32), child varchar(200), restrictby varchar(50));
14
ALTER TABLE public.alm_table OWNER TO almidondemo;
16
DROP TABLE IF EXISTS alm_column CASCADE;
17
CREATE TABLE alm_column (idalm_column varchar (50), idalm_table varchar (48) REFERENCES alm_table, type varchar (16), size int, pk bool, fk varchar(48), alm_column varchar(250), extra text, rank int, idalm_role varchar(8) REFERENCES alm_role, label_bool varchar(100), display varchar(200), help text, search bool, cdn bool, list_values varchar(500), PRIMARY KEY (idalm_column, idalm_table));
18
ALTER TABLE public.alm_column OWNER TO almidondemo;
20
DROP TABLE IF EXISTS alm_access CASCADE;
21
CREATE TABLE alm_access (idalm_role varchar(8) REFERENCES alm_role NULL, idalm_user varchar(16) REFERENCES alm_user , idalm_table varchar(48) REFERENCES alm_table, idalm_access serial PRIMARY KEY);
22
ALTER TABLE public.alm_access OWNER TO almidondemo;
24
INSERT INTO alm_role VALUES ('full', 'Control Total');
25
INSERT INTO alm_role VALUES ('edit', 'Edicion');
26
INSERT INTO alm_role VALUES ('delete', 'Correccion');
27
INSERT INTO alm_role VALUES ('read', 'Lectura');
28
INSERT INTO alm_role VALUES ('deny', 'Sin Accesso');
30
INSERT INTO alm_user VALUES ('admin', 'full', '21232f297a57a5a743894a0e4a801fc3', 'Admin', 'admin@example.com');