Rev 766 | Go to most recent revision | Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 760 | blopes | 1 | /*==============================================================*/ |
| 2 | /* DBMS name: PostgreSQL 8 */ |
||
| 3 | /* Criado em: 22/11/2025 */ |
||
| 4 | /* Autor: Bruno Lopes Peixoto */ |
||
| 5 | /*==============================================================*/ |
||
| 6 | |||
| 7 | SET search_path = sc_slp; |
||
| 8 | |||
| 9 | CREATE SEQUENCE sq_pessoa |
||
| 10 | INCREMENT 1 |
||
| 11 | minvalue 1 |
||
| 12 | maxvalue 99999999 |
||
| 13 | START 1; |
||
| 14 | |||
| 15 | /*==============================================================*/ |
||
| 16 | /* Table: slp_pessoa */ |
||
| 17 | /*==============================================================*/ |
||
| 18 | CREATE TABLE slp_pessoa ( |
||
| 19 | seq_pessoa INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_pessoa'::regclass), |
||
| 20 | dsc_nome VARCHAR(120) NOT NULL, |
||
| 21 | ind_ativo BOOL NOT NULL, |
||
| 22 | CONSTRAINT pk_pessoa PRIMARY KEY (seq_pessoa) |
||
| 23 | ); |
||
| 24 | |||
| 25 | -- set table ownership |
||
| 26 | ALTER TABLE slp_pessoa owner TO sc_slp |
||
| 27 | ; |
||
| 28 | /*==============================================================*/ |
||
| 29 | /* Index: ix_pessoa */ |
||
| 30 | /*==============================================================*/ |
||
| 31 | CREATE UNIQUE INDEX ix_pessoa ON slp_pessoa ( |
||
| 32 | seq_pessoa |
||
| 33 | ); |
||
| 34 | |||
| 35 | CREATE SEQUENCE sq_usuario |
||
| 36 | INCREMENT 1 |
||
| 37 | minvalue 1 |
||
| 38 | maxvalue 99999999 |
||
| 39 | START 1; |
||
| 40 | |||
| 41 | /*==============================================================*/ |
||
| 42 | /* Table: slp_usuario */ |
||
| 43 | /*==============================================================*/ |
||
| 44 | CREATE TABLE slp_usuario ( |
||
| 45 | seq_usuario INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_usuario'::regclass), |
||
| 46 | seq_pessoa INT8 NULL, |
||
| 47 | dsc_login VARCHAR(32) NOT NULL, |
||
| 48 | dsc_nome VARCHAR(120) NULL, |
||
| 49 | dsc_senha VARCHAR(32) NOT NULL, |
||
| 50 | dth_ultimo_acesso TIMESTAMP NULL, |
||
| 51 | ind_ativo BOOL NOT NULL, |
||
| 52 | CONSTRAINT pk_usuario PRIMARY KEY (seq_usuario) |
||
| 53 | ); |
||
| 54 | |||
| 55 | -- set table ownership |
||
| 56 | ALTER TABLE slp_usuario owner TO labse_sc_lse |
||
| 57 | ; |
||
| 58 | /*==============================================================*/ |
||
| 59 | /* Index: ix_usuario */ |
||
| 60 | /*==============================================================*/ |
||
| 61 | CREATE UNIQUE INDEX ix_usuario ON slp_usuario ( |
||
| 62 | seq_usuario |
||
| 63 | ); |
||
| 64 | |||
| 65 | /*==============================================================*/ |
||
| 66 | /* Index: ix_usuario_pessoa */ |
||
| 67 | /*==============================================================*/ |
||
| 68 | CREATE INDEX ix_usuario_pessoa ON slp_usuario ( |
||
| 69 | seq_pessoa |
||
| 70 | ); |
||
| 71 | |||
| 72 | CREATE SEQUENCE sq_ativo |
||
| 73 | INCREMENT 1 |
||
| 74 | minvalue 1 |
||
| 75 | maxvalue 99999999 |
||
| 76 | START 1; |
||
| 77 | |||
| 78 | /*==============================================================*/ |
||
| 79 | /* Table: slp_ativo */ |
||
| 80 | /*==============================================================*/ |
||
| 81 | CREATE TABLE slp_ativo ( |
||
| 82 | seq_ativo INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_ativo'::regclass), |
||
| 83 | dsc_ativo VARCHAR(120) NULL, |
||
| 84 | ind_ativo BOOL NOT NULL, |
||
| 85 | CONSTRAINT pk_ativo PRIMARY KEY (seq_ativo) |
||
| 86 | ); |
||
| 87 | |||
| 88 | -- set table ownership |
||
| 89 | ALTER TABLE slp_ativo owner TO sc_slp |
||
| 90 | ; |
||
| 91 | /*==============================================================*/ |
||
| 92 | /* Index: ix_ativo */ |
||
| 93 | /*==============================================================*/ |
||
| 94 | CREATE UNIQUE INDEX ix_ativo ON slp_ativo ( |
||
| 95 | seq_ativo |
||
| 96 | ); |
||
| 97 | |||
| 98 | CREATE SEQUENCE sq_candle |
||
| 99 | INCREMENT 1 |
||
| 100 | minvalue 1 |
||
| 101 | maxvalue 99999999 |
||
| 102 | START 1; |
||
| 103 | |||
| 104 | /*==============================================================*/ |
||
| 105 | /* Table: slp_candle */ |
||
| 106 | /*==============================================================*/ |
||
| 107 | CREATE TABLE slp_candle ( |
||
| 108 | seq_candle INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_candle'::regclass), |
||
| 109 | seq_ativo INT8 NOT NULL, |
||
| 110 | dth_datahora TIMESTAMP NOT NULL, |
||
| 111 | val_abertura NUMERIC(20,6) NOT NULL, |
||
| 112 | val_maxima NUMERIC(20,6) NOT NULL, |
||
| 113 | val_minima NUMERIC(20,6) NOT NULL, |
||
| 114 | val_fechamento NUMERIC(20,6) NOT NULL, |
||
| 115 | val_volume NUMERIC(20,6) NULL, |
||
| 116 | tip_periodo VARCHAR(2) NOT NULL, |
||
| 117 | CONSTRAINT pk_candle PRIMARY KEY (seq_candle) |
||
| 118 | ); |
||
| 119 | |||
| 120 | -- set table ownership |
||
| 121 | ALTER TABLE slp_candle owner TO sc_slp |
||
| 122 | ; |
||
| 123 | /*==============================================================*/ |
||
| 124 | /* Index: ix_candle */ |
||
| 125 | /*==============================================================*/ |
||
| 126 | CREATE UNIQUE INDEX ix_candle ON slp_candle ( |
||
| 127 | seq_candle |
||
| 128 | ); |
||
| 129 | |||
| 130 | /*==============================================================*/ |
||
| 131 | /* Index: ix_candle_ativo */ |
||
| 132 | /*==============================================================*/ |
||
| 133 | CREATE INDEX ix_candle_ativo ON slp_candle ( |
||
| 134 | seq_ativo |
||
| 135 | ); |
||
| 136 | |||
| 137 | ALTER TABLE slp_candle |
||
| 138 | ADD CONSTRAINT fk_candleativo_candle FOREIGN KEY (seq_ativo) |
||
| 139 | REFERENCES slp_ativo (seq_ativo) |
||
| 140 | ON DELETE RESTRICT ON UPDATE RESTRICT; |
||
| 141 | |||
| 142 | |||
| 143 | SET search_path = public; |
||
| 144 | |||
| 145 | |||
| 146 | -- PERMISSÕES |
||
| 147 | GRANT USAGE ON SCHEMA sc_slp TO sc_slp; |
||
| 148 | |||
| 149 | GRANT SELECT, INSERT, UPDATE, DELETE |
||
| 150 | ON ALL TABLES IN SCHEMA sc_slp |
||
| 151 | TO sc_slp; |
||
| 152 | |||
| 153 | ALTER DEFAULT PRIVILEGES IN SCHEMA sc_slp |
||
| 154 | GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO sc_slp; |