1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
| CREATE TABLE strategies
(
id_strat integer NOT NULL,
id_serv integer,
id_cata smallint,
module character varying(85),
type_strat character varying(3),
strategie character varying(1),
periode integer,
classes character varying(8192),
id_jeu integer,
id_jeu2 integer,
rejet character varying(8192),
selection character varying(8192),
type_module character varying(40),
compress smallint,
multiplex smallint,
pre_trt character varying(256),
post_trt character varying(256),
reprise smallint,
reprise_t interval,
"interval" integer,
objets integer,
instances integer,
occup_mo integer,
occup_pct integer,
en_service smallint,
existe smallint,
force_periode smallint,
ctrl_absence smallint,
id_user smallint,
volume_mo integer,
moyenne_mo integer,
volume_mo_pre integer,
frequence_pre interval,
objets_pre integer,
vol_disk_mo_pre integer,
occup_mo_pre integer,
periode_pre integer,
periode_ctrl integer,
CONSTRAINT strategies_pkey PRIMARY KEY (id_strat),
CONSTRAINT ifserv FOREIGN KEY (id_serv)
REFERENCES serveurs (id_serv) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH OIDS;
CREATE INDEX strategies_idx
ON strategies
USING btree
(module, type_module, id_cata, id_serv);
CREATE INDEX strategies_idx2
ON strategies
USING btree
(id_serv, id_cata, en_service, existe);
CREATE TABLE sauvegardes
(
id_strat integer,
status smallint,
debut timestamp without time zone,
attente interval,
duree interval,
volume_mo integer,
objets integer,
id_cause smallint,
affichage smallint,
retention smallint,
id_comment integer,
id_svg integer,
alarme timestamp without time zone,
job_id bigint DEFAULT 0,
volres_mo integer DEFAULT 0,
CONSTRAINT ifstrat FOREIGN KEY (id_strat)
REFERENCES strategies (id_strat) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT sauvegardes_id_strat_key UNIQUE (id_strat, debut, job_id)
)
WITH OIDS; |