1266WzSC

1CREATE TABLE IF NOT EXISTS b2c_constants (
2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3    name VARCHAR(64) NOT NULL,
4    is_deleted BOOL DEFAULT FALSE,
5    UNIQUE (name)
6) ENGINE InnoDB CHARSET utf8 COLLATE utf8_unicode_ci
7
8CREATE TABLE IF NOT EXISTS b2c_constant_bindings (
9    constant_id INT UNSIGNED NOT NULL,
10    company_id INT UNSIGNED NOT NULL,
11    object_id INT UNSIGNED DEFAULT NULL,
12    property_id INT UNSIGNED DEFAULT NULL,
13    value VARCHAR(255) NOT NULL,
14    UNIQUE (constant_id, company_id, object_id, property_id),
15    FOREIGN KEY (constant_id) REFERENCES b2c_constants (id) ON UPDATE RESTRICT ON DELETE CASCADE,
16    FOREIGN KEY (company_id) REFERENCES companies (id) ON UPDATE RESTRICT ON DELETE CASCADE,
17    FOREIGN KEY (object_id) REFERENCES b2b_objects (id) ON UPDATE RESTRICT ON DELETE CASCADE,
18    FOREIGN KEY (property_id) REFERENCES b2b_properties (id) ON UPDATE RESTRICT ON DELETE CASCADE
19) ENGINE InnoDB CHARSET utf8 COLLATE utf8_unicode_ci
20	
21constant_id   company_id   object_id   property_id   value
221             1            null        null          foo
231             1            1           null          bar
241             1            1           1             baz