RUS2bp6a

1CREATE TABLE IF NOT EXISTS skuConfig (
2   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
3   configId BIGINT UNSIGNED NOT NULL,
4   PRIMARY KEY ( id )
5) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_bin;
6
7CREATE TABLE IF NOT EXISTS config (
8   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
9   skuFamily VARCHAR( 255 ) NOT NULL,
10   PRIMARY KEY ( id )
11) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_bin;
12
13CREATE TABLE IF NOT EXISTS configProperty (
14   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
15   configId BIGINT UNSIGNED NOT NULL,
16   propName VARCHAR( 255 ) NOT NULL,
17   propValue VARCHAR( 255 ) NOT NULL,
18   PRIMARY KEY ( id )
19) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_bin;
20	
21CREATE TABLE IF NOT EXISTS skuConfig (
22   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
23   configId BIGINT UNSIGNED NOT NULL,
24   skuFamily VARCHAR( 255 ) NOT NULL,
25   PRIMARY KEY ( id )
26) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_bin;
27
28CREATE TABLE IF NOT EXISTS skuFamilyXConfig (
29   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
30   a VARCHAR( 255 ) NOT NULL,
31   b VARCHAR( 255 ) NOT NULL,
32   c VARCHAR( 255 ) NOT NULL,
33   PRIMARY KEY ( id )
34) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_bin;
35
36CREATE TABLE IF NOT EXISTS skuFamilyYConfig (
37   id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
38   d VARCHAR( 255 ) NOT NULL,
39   e VARCHAR( 255 ) NOT NULL,
40   PRIMARY KEY ( id )
41) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_bin;