WebSVN - Integrator Subversion - Blame - Rev 777 - /projeto-trade/BANCO DE DADOS/slp_fis_v_0

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,
777	blopes	84	tip_tendencia CHAR(1) NOT NULL
		85	CONSTRAINT ck_tendencia_ativo CHECK (tip_tendencia IN ('A','B','N')),
760	blopes	86	ind_ativo BOOL NOT NULL,
		87	CONSTRAINT pk_ativo PRIMARY KEY (seq_ativo)
		88	);
		89
777	blopes	90	comment ON COLUMN slp_ativo.tip_tendencia IS
		91	'Valores possíveis:
		92	A - Alta
		93	B - Baixa
		94	N - Não Definida';
		95
760	blopes	96	-- set table ownership
		97	ALTER TABLE slp_ativo owner TO sc_slp
		98	;
		99	/==============================================================/
		100	/* Index: ix_ativo */
		101	/==============================================================/
		102	CREATE UNIQUE INDEX ix_ativo ON slp_ativo (
		103	seq_ativo
		104	);
		105
		106	CREATE SEQUENCE sq_candle
		107	INCREMENT 1
		108	minvalue 1
		109	maxvalue 99999999
		110	START 1;
		111
		112	/==============================================================/
		113	/* Table: slp_candle */
		114	/==============================================================/
		115	CREATE TABLE slp_candle (
		116	seq_candle INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_candle'::regclass),
		117	seq_ativo INT8 NOT NULL,
766	blopes	118	val_contador INT8 NULL,
760	blopes	119	dth_datahora TIMESTAMP NOT NULL,
		120	val_abertura NUMERIC(20,6) NOT NULL,
		121	val_maxima NUMERIC(20,6) NOT NULL,
		122	val_minima NUMERIC(20,6) NOT NULL,
		123	val_fechamento NUMERIC(20,6) NOT NULL,
		124	val_volume NUMERIC(20,6) NULL,
		125	tip_periodo VARCHAR(2) NOT NULL,
766	blopes	126	ind_analisado BOOL NOT NULL,
760	blopes	127	CONSTRAINT pk_candle PRIMARY KEY (seq_candle)
		128	);
		129
		130	-- set table ownership
		131	ALTER TABLE slp_candle owner TO sc_slp
		132	;
		133	/==============================================================/
		134	/* Index: ix_candle */
		135	/==============================================================/
		136	CREATE UNIQUE INDEX ix_candle ON slp_candle (
		137	seq_candle
		138	);
		139
		140	/==============================================================/
		141	/* Index: ix_candle_ativo */
		142	/==============================================================/
		143	CREATE INDEX ix_candle_ativo ON slp_candle (
		144	seq_ativo
		145	);
		146
		147	ALTER TABLE slp_candle
		148	ADD CONSTRAINT fk_candleativo_candle FOREIGN KEY (seq_ativo)
		149	REFERENCES slp_ativo (seq_ativo)
		150	ON DELETE RESTRICT ON UPDATE RESTRICT;
		151
		152
		153	SET search_path = public;
		154
		155
		156	-- PERMISSÕES
		157	GRANT USAGE ON SCHEMA sc_slp TO sc_slp;
		158
		159	GRANT SELECT, INSERT, UPDATE, DELETE
		160	ON ALL TABLES IN SCHEMA sc_slp
		161	TO sc_slp;
		162
		163	ALTER DEFAULT PRIVILEGES IN SCHEMA sc_slp
		164	GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO sc_slp;

Subversion Repositories Integrator Subversion

(root)/projeto-trade/BANCO DE DADOS/slp_fis_v_0_1.sql - Rev 777