Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 1 | espaco | 1 | /*========tur===================================================*/ |
| 2 | /* DBMS name: PostgreSQL 8 */ |
||
| 3 | /* Criado em: 17/05/2015 */ |
||
| 4 | /* Autor: Bruno Lopes Peixoto */ |
||
| 5 | /*==============================================================*/ |
||
| 6 | |||
| 7 | SET search_path = sc_sec; |
||
| 8 | |||
| 9 | DROP SEQUENCE sc_sec.sq_histconta; |
||
| 10 | |||
| 11 | CREATE SEQUENCE sq_taxa |
||
| 12 | INCREMENT 1 |
||
| 13 | minvalue 1 |
||
| 14 | maxvalue 99999999 |
||
| 15 | START 1; |
||
| 16 | ALTER TABLE sc_sec.sq_taxa owner TO sc_sec; |
||
| 17 | |||
| 18 | /*==============================================================*/ |
||
| 19 | /* Table: sec_taxa */ |
||
| 20 | /*==============================================================*/ |
||
| 21 | CREATE TABLE sec_taxa ( |
||
| 22 | seq_taxa INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_taxa'::regclass), |
||
| 23 | cod_formapagament INT8 NOT NULL, |
||
| 24 | seq_loja INT8 NOT NULL, |
||
| 25 | cod_conta_bancaria INT8 NOT NULL, |
||
| 26 | val_taxa NUMERIC(10,2) NOT NULL, |
||
| 27 | ind_ativo BOOL NOT NULL, |
||
| 28 | CONSTRAINT pk_taxa PRIMARY KEY (seq_taxa), |
||
| 29 | CONSTRAINT uk_taxa UNIQUE (cod_formapagament, seq_loja) |
||
| 30 | ); |
||
| 31 | |||
| 32 | -- set table ownership |
||
| 33 | ALTER TABLE sec_taxa owner TO sc_sec |
||
| 34 | ; |
||
| 35 | /*==============================================================*/ |
||
| 36 | /* Index: ix_taxa */ |
||
| 37 | /*==============================================================*/ |
||
| 38 | CREATE UNIQUE INDEX ix_taxa ON sec_taxa ( |
||
| 39 | seq_taxa |
||
| 40 | ); |
||
| 41 | |||
| 42 | /*==============================================================*/ |
||
| 43 | /* Index: ix_taxa_formapagament */ |
||
| 44 | /*==============================================================*/ |
||
| 45 | CREATE INDEX ix_taxa_formapagament ON sec_taxa ( |
||
| 46 | cod_formapagament |
||
| 47 | ); |
||
| 48 | |||
| 49 | /*==============================================================*/ |
||
| 50 | /* Index: ix_taxa_loja */ |
||
| 51 | /*==============================================================*/ |
||
| 52 | CREATE INDEX ix_taxa_loja ON sec_taxa ( |
||
| 53 | seq_loja |
||
| 54 | ); |
||
| 55 | |||
| 56 | /*==============================================================*/ |
||
| 57 | /* Index: ix_taxa_contabancaria */ |
||
| 58 | /*==============================================================*/ |
||
| 59 | CREATE INDEX ix_taxa_contabancaria ON sec_taxa ( |
||
| 60 | cod_conta_bancaria |
||
| 61 | ); |
||
| 62 | |||
| 63 | ALTER TABLE sec_taxa |
||
| 64 | ADD CONSTRAINT fk_taxa_contabancaria FOREIGN KEY (cod_conta_bancaria) |
||
| 65 | REFERENCES sec_conta_bancaria (cod_conta_bancaria) |
||
| 66 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 67 | |||
| 68 | ALTER TABLE sec_taxa |
||
| 69 | ADD CONSTRAINT fk_taxa_formapagament FOREIGN KEY (cod_formapagament) |
||
| 70 | REFERENCES sec_forma_pagamento (cod_formapagament) |
||
| 71 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 72 | |||
| 73 | ALTER TABLE sec_taxa |
||
| 74 | ADD CONSTRAINT fk_taxa_loja FOREIGN KEY (seq_loja) |
||
| 75 | REFERENCES sec_loja (seq_loja) |
||
| 76 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 77 | |||
| 78 | ALTER TABLE sec_cliente ADD COLUMN seq_modelo int8; |
||
| 79 | ALTER TABLE sec_cliente ADD COLUMN ind_novidades BOOL; |
||
| 80 | |||
| 81 | ALTER TABLE sec_cliente |
||
| 82 | ADD CONSTRAINT fk_cliente_modelo FOREIGN KEY (seq_modelo) |
||
| 83 | REFERENCES sec_modelo (seq_modelo) |
||
| 84 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 85 | |||
| 86 | UPDATE sec_compra SET ind_pago = FALSE WHERE ind_pago IS NULL; |
||
| 87 | UPDATE sec_cliente SET ind_novidades = FALSE; |
||
| 88 | |||
| 89 | SET search_path = public; |