260hidxA

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) ENGINE InnoDB CHARSET utf8 COLLATE utf8_unicode_ci
6
7CREATE TABLE IF NOT EXISTS b2c_constant_bindings (
8    constant_id INT UNSIGNED NOT NULL,
9    company_id INT UNSIGNED NOT NULL,
10    object_id INT UNSIGNED DEFAULT NULL,
11    property_id INT UNSIGNED DEFAULT NULL,
12    value VARCHAR(255) NOT NULL,
13    UNIQUE (constant_id, company_id, object_id, property_id),
14    FOREIGN KEY (constant_id) REFERENCES b2c_constants (id) ON UPDATE RESTRICT ON DELETE CASCADE,
15    FOREIGN KEY (company_id) REFERENCES companies (id) ON UPDATE RESTRICT ON DELETE CASCADE,
16    FOREIGN KEY (object_id) REFERENCES b2b_objects (id) ON UPDATE RESTRICT ON DELETE CASCADE,
17    FOREIGN KEY (property_id) REFERENCES b2b_properties (id) ON UPDATE RESTRICT ON DELETE CASCADE
18) ENGINE InnoDB CHARSET utf8 COLLATE utf8_unicode_ci
19	
20constant_id   company_id   object_id   property_id   value
211             1            null        null          foo
221             1            1           null          bar
231             1            1           1             baz