blob: 27934aedeaf59d1cbee1d94c0e14bcc60d0765c9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
CREATE TABLE director_datafield_category (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
category_name VARCHAR(255) NOT NULL,
description TEXT DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY category_name (category_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE director_datafield
ADD COLUMN category_id INT(10) UNSIGNED DEFAULT NULL AFTER id,
ADD CONSTRAINT director_datafield_category
FOREIGN KEY category (category_id)
REFERENCES director_datafield_category (id)
ON DELETE RESTRICT
ON UPDATE CASCADE
;
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (168, NOW());
|
