diff options
Diffstat (limited to '')
| -rw-r--r-- | schema/mysql-legacy-changes/upgrade_21.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/schema/mysql-legacy-changes/upgrade_21.sql b/schema/mysql-legacy-changes/upgrade_21.sql new file mode 100644 index 0000000..7c72b86 --- /dev/null +++ b/schema/mysql-legacy-changes/upgrade_21.sql @@ -0,0 +1,15 @@ +DROP TABLE director_datalist_value; + +CREATE TABLE director_datalist_entry ( + list_id INT(10) UNSIGNED NOT NULL, + entry_name VARCHAR(255) DEFAULT NULL, + entry_value TEXT DEFAULT NULL, + format enum ('string', 'expression', 'json'), + PRIMARY KEY (list_id, entry_name), + CONSTRAINT director_datalist_value_datalist + FOREIGN KEY datalist (list_id) + REFERENCES director_datalist (id) + ON DELETE CASCADE + ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + |