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
| CREATE TABLE alf_node_properties
(
node_id bigint NOT NULL,
actual_type_n integer NOT NULL,
persisted_type_n integer NOT NULL,
boolean_value boolean,
long_value bigint,
float_value real,
double_value double precision,
string_value character varying(1024),
serializable_value bytea,
qname_id bigint NOT NULL,
list_index integer NOT NULL,
locale_id bigint NOT NULL,
CONSTRAINT alf_node_properties_pkey PRIMARY KEY (node_id, qname_id, list_index, locale_id),
CONSTRAINT fk_alf_nprop_loc FOREIGN KEY (locale_id)
REFERENCES alf_locale (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_alf_nprop_n FOREIGN KEY (node_id)
REFERENCES alf_node (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk_alf_nprop_qn FOREIGN KEY (qname_id)
REFERENCES alf_qname (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (OIDS=FALSE);
ALTER TABLE alf_node_properties OWNER TO alfresco; |
Partager