WebSVN - Integrator Subversion - Diff - Rev 760 and 766 - /projeto-trade/BANCO DE DADOS/slp_fis_v_0



/* Table: slp_candle                                            */
/*==============================================================*/
CREATE TABLE slp_candle (
   seq_candle           INT8                 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_candle'::regclass),
   seq_ativo            INT8                 NOT NULL,
   val_contador         INT8                 NULL,
   dth_datahora         TIMESTAMP            NOT NULL,
   val_abertura         NUMERIC(20,6)        NOT NULL,
   val_maxima           NUMERIC(20,6)        NOT NULL,
   val_minima           NUMERIC(20,6)        NOT NULL,
   val_fechamento       NUMERIC(20,6)        NOT NULL,
   val_volume           NUMERIC(20,6)        NULL,
   tip_periodo          VARCHAR(2)           NOT NULL,
   ind_analisado        BOOL                 NOT NULL,
   CONSTRAINT pk_candle PRIMARY KEY (seq_candle)
);

-- set table ownership
ALTER TABLE slp_candle owner TO sc_slp

Subversion Repositories Integrator Subversion

(root)/projeto-trade/BANCO DE DADOS/slp_fis_v_0_1.sql - Rev 760 → 766

Rev 760		Rev 766
Line 105...		Line 105...
105	/* Table: slp_candle */	105	/* Table: slp_candle */
106	/==============================================================/	106	/==============================================================/
107	CREATE TABLE slp_candle (	107	CREATE TABLE slp_candle (
108	seq_candle INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_candle'::regclass),	108	seq_candle INT8 NOT NULL DEFAULT NEXTVAL('sc_slp.sq_candle'::regclass),
109	seq_ativo INT8 NOT NULL,	109	seq_ativo INT8 NOT NULL,
-		110	val_contador INT8 NULL,
110	dth_datahora TIMESTAMP NOT NULL,	111	dth_datahora TIMESTAMP NOT NULL,
111	val_abertura NUMERIC(20,6) NOT NULL,	112	val_abertura NUMERIC(20,6) NOT NULL,
112	val_maxima NUMERIC(20,6) NOT NULL,	113	val_maxima NUMERIC(20,6) NOT NULL,
113	val_minima NUMERIC(20,6) NOT NULL,	114	val_minima NUMERIC(20,6) NOT NULL,
114	val_fechamento NUMERIC(20,6) NOT NULL,	115	val_fechamento NUMERIC(20,6) NOT NULL,
115	val_volume NUMERIC(20,6) NULL,	116	val_volume NUMERIC(20,6) NULL,
116	tip_periodo VARCHAR(2) NOT NULL,	117	tip_periodo VARCHAR(2) NOT NULL,
-		118	ind_analisado BOOL NOT NULL,
117	CONSTRAINT pk_candle PRIMARY KEY (seq_candle)	119	CONSTRAINT pk_candle PRIMARY KEY (seq_candle)
118	);	120	);
119		121
120	-- set table ownership	122	-- set table ownership
121	ALTER TABLE slp_candle owner TO sc_slp	123	ALTER TABLE slp_candle owner TO sc_slp