WebSVN - Integrator Subversion - Blame - Rev 766 - /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,
		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,
766	blopes	110	val_contador INT8 NULL,
760	blopes	111	dth_datahora TIMESTAMP NOT NULL,
		112	val_abertura NUMERIC(20,6) NOT NULL,
		113	val_maxima NUMERIC(20,6) NOT NULL,
		114	val_minima NUMERIC(20,6) NOT NULL,
		115	val_fechamento NUMERIC(20,6) NOT NULL,
		116	val_volume NUMERIC(20,6) NULL,
		117	tip_periodo VARCHAR(2) NOT NULL,
766	blopes	118	ind_analisado BOOL NOT NULL,
760	blopes	119	CONSTRAINT pk_candle PRIMARY KEY (seq_candle)
		120	);
		121
		122	-- set table ownership
		123	ALTER TABLE slp_candle owner TO sc_slp
		124	;
		125	/==============================================================/
		126	/* Index: ix_candle */
		127	/==============================================================/
		128	CREATE UNIQUE INDEX ix_candle ON slp_candle (
		129	seq_candle
		130	);
		131
		132	/==============================================================/
		133	/* Index: ix_candle_ativo */
		134	/==============================================================/
		135	CREATE INDEX ix_candle_ativo ON slp_candle (
		136	seq_ativo
		137	);
		138
		139	ALTER TABLE slp_candle
		140	ADD CONSTRAINT fk_candleativo_candle FOREIGN KEY (seq_ativo)
		141	REFERENCES slp_ativo (seq_ativo)
		142	ON DELETE RESTRICT ON UPDATE RESTRICT;
		143
		144
		145	SET search_path = public;
		146
		147
		148	-- PERMISSÕES
		149	GRANT USAGE ON SCHEMA sc_slp TO sc_slp;
		150
		151	GRANT SELECT, INSERT, UPDATE, DELETE
		152	ON ALL TABLES IN SCHEMA sc_slp
		153	TO sc_slp;
		154
		155	ALTER DEFAULT PRIVILEGES IN SCHEMA sc_slp
		156	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 766