L4UWDtTg

1
2// create tables if not exists
3CREATE TABLE IF NOT EXISTS `solytron_import_module` (
4	  `module_id` int(11) NOT NULL AUTO_INCREMENT,
5	  `code` varchar(255) NOT NULL,
6	  `priority` int(5) NOT NULL DEFAULT '0',
7	  PRIMARY KEY (`module_id`),
8	   UNIQUE INDEX (`code`)
9	) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=1;
10			
11CREATE TABLE IF NOT EXISTS `solytron_import_module_description` (
12	  `module_id` int(11) NOT NULL,
13	  `language_id` int(11) NOT NULL,
14	  `name` varchar(255) NOT NULL,
15	  PRIMARY KEY (`module_id`,`language_id`)
16	) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
17	
18CREATE TABLE IF NOT EXISTS `solytron_import_product_property_to_attribute` (
19	  `property` varchar(255) NOT NULL,
20	  `attribute_id` int(11) NOT NULL,
21	  `action_id` int(11) NOT NULL DEFAULT '0',
22	  `module_id` int(11) NOT NULL,
23	  `relation_id` int(11) NOT NULL,
24	  UNIQUE INDEX (`property`, `module_id`, `relation_id`)
25	) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
26	
27CREATE TABLE IF NOT EXISTS `solytron_import_product_property_value` (
28	  `value` varchar(255) NOT NULL,
29	  `replaced` varchar(255) NOT NULL,
30	  `module_id` int(11) NOT NULL,
31	  `relation_id` int(11) NOT NULL
32	) ENGINE=MyISAM DEFAULT CHARSET=utf8;	
33
34CREATE TABLE IF NOT EXISTS `solytron_import_product_vendor_to_manufacturer` (
35	  `manufacturer_id` int(11) NOT NULL,
36	  `name` varchar(255) NOT NULL,
37	  PRIMARY KEY (`manufacturer_id`),
38	  UNIQUE INDEX (`name`)
39	) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;