summaryrefslogtreecommitdiffstats
path: root/schema/pgsql-legacy-changes/upgrade_21.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--schema/pgsql-legacy-changes/upgrade_21.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/schema/pgsql-legacy-changes/upgrade_21.sql b/schema/pgsql-legacy-changes/upgrade_21.sql
new file mode 100644
index 0000000..1a4fc5a
--- /dev/null
+++ b/schema/pgsql-legacy-changes/upgrade_21.sql
@@ -0,0 +1,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);
+