blob: 1a4fc5a64a9e5fb6add97e4bc433db10c99cc2f6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
DROP TABLE director_datalist_value;
CREATE TABLE director_datalist_entry (
list_id integer NOT NULL,
entry_name character varying(255) DEFAULT NULL,
entry_value text DEFAULT NULL,
format enum_property_format,
PRIMARY KEY (list_id, entry_name),
CONSTRAINT director_datalist_entry_datalist
FOREIGN KEY (list_id)
REFERENCES director_datalist (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
CREATE INDEX datalist_entry_datalist ON director_datalist_entry (list_id);
|
