Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | /*========tur===================================================*/ |
| 2 | /* DBMS name: PostgreSQL 8 */ |
||
| 3 | /* Criado em: 29/07/2020 */ |
||
| 4 | /* Autor: Bruno Lopes Peixoto */ |
||
| 5 | /*==============================================================*/ |
||
| 6 | |||
| 7 | SET search_path = sc_sec; |
||
| 8 | |||
| 9 | ALTER TABLE sec_produto_loja RENAME COLUMN dat_contagem_preparacao TO dth_contagem_preparacao; |
||
| 10 | ALTER TABLE sec_produto_loja ALTER COLUMN dat_contagem TYPE TIMESTAMP; |
||
| 11 | |||
| 12 | CREATE SEQUENCE sq_unimodulo |
||
| 13 | INCREMENT 1 |
||
| 14 | minvalue 1 |
||
| 15 | maxvalue 99999999 |
||
| 16 | START 1; |
||
| 17 | |||
| 18 | ALTER TABLE sq_unimodulo owner TO sc_sec |
||
| 19 | ; |
||
| 20 | |||
| 21 | CREATE SEQUENCE sq_unimoduloperfil |
||
| 22 | INCREMENT 1 |
||
| 23 | minvalue 1 |
||
| 24 | maxvalue 99999999 |
||
| 25 | START 1; |
||
| 26 | |||
| 27 | ALTER TABLE sq_unimoduloperfil owner TO sc_sec |
||
| 28 | ; |
||
| 29 | |||
| 30 | CREATE SEQUENCE sq_uniconteudo |
||
| 31 | INCREMENT 1 |
||
| 32 | minvalue 1 |
||
| 33 | maxvalue 99999999 |
||
| 34 | START 1; |
||
| 35 | |||
| 36 | ALTER TABLE sq_uniconteudo owner TO sc_sec |
||
| 37 | ; |
||
| 38 | |||
| 39 | CREATE SEQUENCE sq_unitopico |
||
| 40 | INCREMENT 1 |
||
| 41 | minvalue 1 |
||
| 42 | maxvalue 99999999 |
||
| 43 | START 1; |
||
| 44 | |||
| 45 | ALTER TABLE sq_unitopico owner TO sc_sec |
||
| 46 | ; |
||
| 47 | |||
| 48 | CREATE SEQUENCE sq_unimodulousuario |
||
| 49 | INCREMENT 1 |
||
| 50 | minvalue 1 |
||
| 51 | maxvalue 99999999 |
||
| 52 | START 1; |
||
| 53 | |||
| 54 | ALTER TABLE sq_unimodulousuario owner TO sc_sec |
||
| 55 | ; |
||
| 56 | |||
| 57 | /*==============================================================*/ |
||
| 58 | /* Table: sec_unimodulo */ |
||
| 59 | /*==============================================================*/ |
||
| 60 | CREATE TABLE sec_unimodulo ( |
||
| 61 | seq_unimodulo INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_unimodulo'::regclass), |
||
| 62 | dsc_unimodulo VARCHAR(120) NOT NULL, |
||
| 63 | dsc_resumo VARCHAR(400) NULL, |
||
| 64 | num_ordem INT4 NOT NULL, |
||
| 65 | ind_ativo BOOL NOT NULL, |
||
| 66 | CONSTRAINT pk_unimodulo PRIMARY KEY (seq_unimodulo) |
||
| 67 | ); |
||
| 68 | |||
| 69 | -- set table ownership |
||
| 70 | ALTER TABLE sec_unimodulo owner TO sc_sec |
||
| 71 | ; |
||
| 72 | |||
| 73 | /*==============================================================*/ |
||
| 74 | /* Table: sec_unitopico */ |
||
| 75 | /*==============================================================*/ |
||
| 76 | CREATE TABLE sec_unitopico ( |
||
| 77 | seq_unitopico INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_unitopico'::regclass), |
||
| 78 | seq_unimodulo INT8 NOT NULL, |
||
| 79 | dsc_unitopico VARCHAR(120) NOT NULL, |
||
| 80 | dsc_resumo VARCHAR(400) NULL, |
||
| 81 | num_ordem INT4 NOT NULL, |
||
| 82 | ind_ativo BOOL NOT NULL, |
||
| 83 | CONSTRAINT pk_unitopico PRIMARY KEY (seq_unitopico) |
||
| 84 | ); |
||
| 85 | |||
| 86 | -- set table ownership |
||
| 87 | ALTER TABLE sec_unitopico owner TO sc_sec |
||
| 88 | ; |
||
| 89 | ALTER TABLE sec_unitopico |
||
| 90 | ADD CONSTRAINT fk_unitopico_unimodulo FOREIGN KEY (seq_unimodulo) |
||
| 91 | REFERENCES sec_unimodulo (seq_unimodulo) |
||
| 92 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 93 | |||
| 94 | |||
| 95 | /*==============================================================*/ |
||
| 96 | /* Table: sec_unitopico_usuario */ |
||
| 97 | /*==============================================================*/ |
||
| 98 | CREATE TABLE sec_unitopico_usuario ( |
||
| 99 | seq_unimodulo_usuario INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_unimodulousuario'::regclass), |
||
| 100 | seq_unitopico INT8 NOT NULL, |
||
| 101 | seq_usuario INT8 NOT NULL, |
||
| 102 | dth_acesso TIMESTAMP NOT NULL, |
||
| 103 | CONSTRAINT pk_unitopicousuario PRIMARY KEY (seq_unimodulo_usuario) |
||
| 104 | ); |
||
| 105 | |||
| 106 | -- set table ownership |
||
| 107 | ALTER TABLE sec_unitopico_usuario owner TO sc_sec |
||
| 108 | ; |
||
| 109 | ALTER TABLE sec_unitopico_usuario |
||
| 110 | ADD CONSTRAINT fk_unitopicousuario_unitopico FOREIGN KEY (seq_unitopico) |
||
| 111 | REFERENCES sec_unitopico (seq_unitopico) |
||
| 112 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 113 | |||
| 114 | ALTER TABLE sec_unitopico_usuario |
||
| 115 | ADD CONSTRAINT fk_unitopicousuario_usuario FOREIGN KEY (seq_usuario) |
||
| 116 | REFERENCES sec_usuario (seq_usuario) |
||
| 117 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 118 | |||
| 119 | |||
| 120 | /*==============================================================*/ |
||
| 121 | /* Table: sec_uniconteudo */ |
||
| 122 | /*==============================================================*/ |
||
| 123 | CREATE TABLE sec_uniconteudo ( |
||
| 124 | seq_uniconteudo INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_uniconteudo'::regclass), |
||
| 125 | seq_unitopico INT8 NULL, |
||
| 126 | dsc_titulo VARCHAR(120) NOT NULL, |
||
| 127 | dsc_resumo VARCHAR(400) NULL, |
||
| 128 | dsc_conteudo VARCHAR(400) NULL, |
||
| 129 | tip_uniconteudo CHAR(1) NOT NULL |
||
| 130 | CONSTRAINT ck_tipuniconteudo CHECK (tip_uniconteudo IN ('T','V','L','P')), |
||
| 131 | num_ordem INT4 NULL, |
||
| 132 | ind_ativo BOOL NOT NULL, |
||
| 133 | CONSTRAINT pk_uniconteudo PRIMARY KEY (seq_uniconteudo) |
||
| 134 | ); |
||
| 135 | |||
| 136 | comment ON COLUMN sec_uniconteudo.tip_uniconteudo IS |
||
| 137 | 'Valores possíveis: |
||
| 138 | T - Texto |
||
| 139 | V - Vídeo |
||
| 140 | L - Link |
||
| 141 | P - Arquivo PDF'; |
||
| 142 | |||
| 143 | -- set table ownership |
||
| 144 | ALTER TABLE sec_uniconteudo owner TO sc_sec |
||
| 145 | ; |
||
| 146 | ALTER TABLE sec_uniconteudo |
||
| 147 | ADD CONSTRAINT fk_uniconteudo_unitopico FOREIGN KEY (seq_unitopico) |
||
| 148 | REFERENCES sec_unitopico (seq_unitopico) |
||
| 149 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 150 | |||
| 151 | /*==============================================================*/ |
||
| 152 | /* Table: sec_unimodulo_perfil */ |
||
| 153 | /*==============================================================*/ |
||
| 154 | CREATE TABLE sec_unimodulo_perfil ( |
||
| 155 | seq_unimodulo_perfil INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_unimoduloperfil'::regclass), |
||
| 156 | seq_unimodulo INT8 NOT NULL, |
||
| 157 | cod_perfil INT8 NOT NULL, |
||
| 158 | CONSTRAINT pk_unimoduloperfil PRIMARY KEY (seq_unimodulo_perfil) |
||
| 159 | ); |
||
| 160 | |||
| 161 | -- set table ownership |
||
| 162 | ALTER TABLE sec_unimodulo_perfil owner TO sc_sec |
||
| 163 | ; |
||
| 164 | ALTER TABLE sec_unimodulo_perfil |
||
| 165 | ADD CONSTRAINT fk_unimoduloperfil_perfil FOREIGN KEY (cod_perfil) |
||
| 166 | REFERENCES sec_perfil (cod_perfil) |
||
| 167 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 168 | |||
| 169 | ALTER TABLE sec_unimodulo_perfil |
||
| 170 | ADD CONSTRAINT fk_unimoduloperfil_unimodulo FOREIGN KEY (seq_unimodulo) |
||
| 171 | REFERENCES sec_unimodulo (seq_unimodulo) |
||
| 172 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 173 | |||
| 174 | |||
| 175 | |||
| 176 | SET search_path = public; |