· 8 years ago · May 15, 2018, 06:24 PM
1CREATE TABLE IF NOT EXISTS `store_clothing` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `part` varchar(25) NOT NULL,
4 `partid` varchar(35) NOT NULL,
5 `storeid` int(11) NOT NULL,
6 `new` int(11) NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=197 ;
9
10
11--
12-- Dumping data for table `store_clothing`
13--
14
15
16INSERT INTO `store_clothing` (`id`, `part`, `partid`, `storeid`, `new`) VALUES
17(1, 'ha', '1001', 2, 0),
18(2, 'ha', '1002', 2, 0),
19(3, 'ha', '1003', 2, 0),
20(4, 'ha', '1004', 2, 0),
21(5, 'ha', '1005', 2, 0),
22(6, 'ha', '1006', 2, 0),
23(7, 'ha', '1007', 2, 0),
24(8, 'ha', '1008', 2, 0),
25(9, 'ha', '1009', 2, 0),
26(10, 'ha', '1010', 2, 0),
27(11, 'ha', '1011', 2, 0),
28(12, 'ha', '1012', 2, 0),
29(13, 'ha', '1013', 2, 0),
30(14, 'ha', '1014', 2, 0),
31(15, 'ha', '1015', 2, 0),
32(16, 'ha', '1016', 2, 0),
33(17, 'ha', '1017', 2, 0),
34(18, 'ha', '1018', 2, 0),
35(19, 'ha', '1019', 2, 0),
36(20, 'ha', '1020', 2, 0),
37(21, 'ha', '1021', 2, 0),
38(22, 'ha', '1022', 2, 0),
39(23, 'ha', '1023', 2, 0),
40(24, 'ha', '1024', 2, 0),
41(25, 'ha', '1025', 2, 0),
42(26, 'ha', '1026', 2, 0),
43(27, 'ha', '1027', 2, 0),
44(28, 'ch', '210', 2, 0),
45(29, 'ch', '215', 2, 0),
46(30, 'ch', '220', 2, 0),
47(31, 'ch', '225', 2, 0),
48(32, 'ch', '230', 2, 0),
49(33, 'ch', '235', 2, 0),
50(34, 'ch', '240', 2, 0),
51(35, 'ch', '245', 2, 0),
52(36, 'ch', '250', 2, 0),
53(37, 'ch', '255', 2, 0),
54(38, 'ch', '260', 2, 0),
55(39, 'ch', '261', 2, 0),
56(40, 'ch', '262', 2, 0),
57(41, 'ch', '266', 2, 0),
58(42, 'ch', '267', 2, 0),
59(43, 'ch', '630', 2, 0),
60(44, 'ch', '635', 2, 0),
61(45, 'ch', '640', 2, 0),
62(46, 'ch', '650', 2, 0),
63(47, 'ch', '665', 2, 0),
64(48, 'ch', '667', 2, 0),
65(49, 'ch', '669', 2, 0),
66(50, 'ch', '675', 2, 0),
67(51, 'ch', '680', 2, 0),
68(52, 'ch', '685', 2, 0),
69(53, 'ch', '690', 2, 0),
70(54, 'ch', '691', 2, 0),
71(55, 'ch', '803', 2, 0),
72(56, 'ch', '804', 2, 0),
73(57, 'ch', '805', 2, 0),
74(58, 'ch', '806', 2, 0),
75(59, 'ch', '807', 2, 0),
76(60, 'ch', '808', 2, 0),
77(61, 'ch', '809', 2, 0),
78(62, 'ch', '812', 2, 0),
79(63, 'ch', '813', 2, 0),
80(64, 'ch', '814', 2, 0),
81(65, 'ch', '815', 2, 0),
82(66, 'ch', '816', 2, 0),
83(67, 'ch', '817', 2, 0),
84(68, 'ch', '818', 2, 0),
85(69, 'ch', '819', 2, 0),
86(70, 'ch', '820', 2, 0),
87(71, 'ch', '821', 2, 0),
88(72, 'ch', '822', 2, 0),
89(73, 'ch', '823', 2, 0),
90(74, 'ch', '824', 2, 0),
91(75, 'ch', '825', 2, 0),
92(76, 'ch', '826', 2, 0),
93(77, 'ch', '876', 2, 0),
94(78, 'ch', '877', 2, 0),
95(79, 'ch', '878', 2, 0),
96(80, 'ch', '879', 2, 0),
97(81, 'ch', '880', 2, 0),
98(82, 'ch', '881', 2, 0),
99(83, 'ch', '882', 2, 0),
100(84, 'ch', '883', 2, 0),
101(85, 'ch', '884', 2, 0),
102(86, 'ch', '885', 2, 0),
103(87, 'ch', '886', 2, 0),
104(88, 'ch', '887', 2, 0),
105(89, 'ch', '888', 2, 0),
106(90, 'ea', '1401', 2, 0),
107(91, 'ea', '1402', 2, 0),
108(92, 'ea', '1403', 2, 0),
109(93, 'ea', '1404', 2, 0),
110(94, 'ea', '1405', 2, 0),
111(95, 'ea', '1406', 2, 0),
112(96, 'ea', '1407', 2, 0),
113(97, 'ea', '1408', 2, 0),
114(98, 'lg', '695', 2, 0),
115(99, 'lg', '696', 2, 0),
116(100, 'lg', '700', 2, 0),
117(101, 'lg', '705', 2, 0),
118(102, 'lg', '710', 2, 0),
119(103, 'lg', '715', 2, 0),
120(104, 'lg', '716', 2, 0),
121(105, 'lg', '717', 2, 0),
122(106, 'lg', '720', 2, 0),
123(107, 'lg', '721', 2, 0),
124(108, 'lg', '722', 2, 0),
125(109, 'lg', '723', 2, 0),
126(111, 'lg', '727', 2, 0),
127(112, 'sh', '725', 2, 0),
128(113, 'sh', '730', 2, 0),
129(114, 'sh', '735', 2, 0),
130(115, 'sh', '740', 2, 0),
131(116, 'sh', '905', 2, 0),
132(117, 'sh', '906', 2, 0),
133(118, 'sh', '907', 2, 0),
134(119, 'sh', '908', 2, 0),
135(120, 'ca', '1801', 2, 0),
136(121, 'ca', '1802', 2, 0),
137(122, 'ca', '1803', 2, 0),
138(123, 'ca', '1804', 2, 0),
139(124, 'ca', '1805', 2, 0),
140(125, 'ca', '1806', 2, 0),
141(126, 'ca', '1807', 2, 0),
142(127, 'ca', '1808', 2, 0),
143(128, 'ca', '1809', 2, 0),
144(129, 'ca', '1810', 2, 0),
145(130, 'ca', '1811', 2, 0),
146(131, 'ca', '1812', 2, 0),
147(132, 'ca', '1813', 2, 0),
148(133, 'ca', '1814', 2, 0),
149(134, 'ca', '1815', 2, 0),
150(135, 'ca', '1816', 2, 0),
151(136, 'ca', '1817', 2, 0),
152(137, 'ca', '1818', 2, 0),
153(138, 'ca', '1819', 2, 0),
154(139, 'ca', '1820', 2, 0),
155(140, 'ca', '1821', 2, 0),
156(141, 'ca', '1822', 2, 0),
157(142, 'fa', '1201', 2, 0),
158(143, 'fa', '1202', 2, 0),
159(144, 'fa', '1203', 2, 0),
160(145, 'fa', '1204', 2, 0),
161(146, 'fa', '1205', 2, 0),
162(147, 'fa', '1206', 2, 0),
163(148, 'fa', '1207', 2, 0),
164(149, 'fa', '1208', 2, 0),
165(150, 'fa', '1209', 2, 0),
166(151, 'fa', '1210', 2, 0),
167(152, 'fa', '1211', 2, 0),
168(153, 'fa', '1212', 2, 0),
169(154, 'he', '1601', 2, 0),
170(155, 'he', '1602', 2, 0),
171(156, 'he', '1603', 2, 0),
172(157, 'he', '1605', 2, 0),
173(158, 'he', '1606', 2, 0),
174(159, 'he', '1607', 2, 0),
175(160, 'he', '1608', 2, 0),
176(161, 'he', '1609', 2, 0),
177(162, 'he', '1610', 2, 0),
178(163, 'he', '1611', 2, 0),
179(164, 'he', '1612', 2, 0),
180(165, 'he', '1613', 2, 0),
181(166, 'he', '1614', 2, 0),
182(167, 'wa', '2001', 2, 0),
183(168, 'wa', '2002', 2, 0),
184(169, 'wa', '2003', 2, 0),
185(170, 'wa', '2004', 2, 0),
186(171, 'wa', '2005', 2, 0),
187(172, 'wa', '2006', 2, 0),
188(173, 'wa', '2007', 2, 0),
189(174, 'wa', '2008', 2, 0),
190(175, 'wa', '2009', 2, 0),
191(176, 'wa', '2010', 2, 0),
192(177, 'wa', '2011', 2, 0),
193(178, 'wa', '2012', 2, 0),
194(179, 'wa', '2013', 2, 0),
195(180, 'ch', '917', 85, 0),
196(181, 'ch', '919', 85, 0),
197(182, 'ch', '921', 85, 0),
198(183, 'ch', '923', 85, 0),
199(184, 'ch', '924', 85, 0),
200(185, 'ch', '925', 85, 0),
201(186, 'ch', '926', 85, 0),
202(187, 'ch', '930', 85, 0),
203(188, 'ch', '932', 85, 0),
204(189, 'ch', '934', 85, 0),
205(190, 'ch', '936', 85, 0),
206(193, 'ha', '1028', 85, 0),
207(194, 'ha', '1029', 85, 0),
208(195, 'ha', '1030', 85, 0),
209(196, 'ha', '1032', 85, 0);