8zPi2xwa

1-- phpMyAdmin SQL Dump
2-- version 4.6.6deb4
3-- https://www.phpmyadmin.net/
4--
5-- Host: db644870263.db.1and1.com
6-- Generation Time: Nov 14, 2018 at 10:15 AM
7-- Server version: 5.5.60-0+deb7u1-log
8-- PHP Version: 7.0.30-0+deb9u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `db644870263`
21--
22DROP DATABASE IF EXISTS `db644870263`;
23CREATE DATABASE IF NOT EXISTS `db644870263` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci;
24USE `db644870263`;
25
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `components`
30--
31
32CREATE TABLE `components` (
33  `type` set('audio','connector','hdmi','misc','optical','power','rj45','switches','usb') NOT NULL,
34  `img_1` varchar(30) NOT NULL,
35  `img_2` varchar(20) NOT NULL,
36  `id` int(6) NOT NULL,
37  `title` varchar(50) NOT NULL,
38  `text` varchar(1000) NOT NULL
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41--
42-- Dumping data for table `components`
43--
44
45INSERT INTO `components` (`type`, `img_1`, `img_2`, `id`, `title`, `text`) VALUES
46('audio', '2SJ-0960-D11.png', '', 1, '2SJ-0960-D11', 'Audio socket'),
47('audio', '2sj-t351-002.jpg', '', 3, '2sj-t351-002', 'Audio socket'),
48('audio', '2SJ-S351-S02.png', '', 4, '2SJ-S351-S02', 'Audio socket'),
49('connector', 'ipad-34-conn-logi.jpg', '', 5, 'ipad-34-conn-logi', 'Connector with gate'),
50('connector', 'ipad234-conn-digi.jpg', '', 6, 'ipad234-conn-digi', 'Connector with gate'),
51('audio', '2SJ1012-025111.png', '', 7, '2SJ1012-025111', 'Audio socket'),
52('audio', '2SJ1558-011111.png', '', 8, '2SJ1558-011111', 'Audio socket'),
53('audio', '2SJ2335-001111F.png', '', 9, '2SJ2335-001111F', 'Audio socket'),
54('audio', '3722-002544.jpg', '', 10, '3722-002544', 'Audio socket'),
55('audio', '3722-002545.png', '', 11, '3722-002545', 'Audio socket'),
56('audio', '3722-002548.png', '', 12, '3722-002548', 'Audio socket'),
57('audio', '3722-002588.png', '', 13, '3722-002588', 'Audio socket'),
58('audio', '3722-002878.png', '', 14, '3722-002878', 'Audio socket'),
59('audio', '3722-002903.png', '', 15, '3722-002903', 'Audio socket'),
60('audio', '3722-003324.png', '', 16, '3722-003324', 'Audio socket'),
61('audio', '3722-003339.png', '', 17, '3722-003339', 'Audio socket'),
62('audio', '3722-003341.png', '', 18, '3722-003341', 'Audio socket'),
63('audio', '3722-003371.png', '', 19, '3722-003371', 'Audio socket'),
64('audio', '3722-003474.jpg', '', 20, '3722-003474', 'Audio socket'),
65('audio', 'AUDIO-E1-572P.jpg', '', 21, 'AUDIO-E1-572P', 'Audio socket'),
66('audio', 'AUDIO683029-501.jpg', '', 22, 'AUDIO683029-501', 'Audio socket'),
67('audio', 'audiosocket-hp-15-e.jpg', '', 27, 'audiosocket-hp-15-e', 'Audio socket'),
68('audio', 'AUDIOSOCKETDT2304 .png', '', 28, 'AUDIOSOCKETDT2304 ', 'Audio socket'),
69('audio', 'eag61030001.jpg', '', 29, 'eag61030001', 'Audio socket'),
70('connector', 'ipadmini-conn-logi.jpg', '', 31, 'ipadmini-conn-logi', 'Connetcor'),
71('connector', 'OOW080-0780-000.png', '', 32, 'OOW080-0780-000', 'Connector'),
72('connector', 'OOW080-0908-000.png', '', 33, 'OOW080-0908-000', 'Connector with gate'),
73('hdmi', '3701-001591.jpg', '', 34, '3701-001591', 'HDMI socket'),
74('hdmi', '3701-001693.jpg', '', 35, '3701-001693', 'HDMI socket'),
75('hdmi', '3701-001782.jpg', '', 36, '3701-001782', 'HDMI socket'),
76('hdmi', '3701-001784.jpg', '', 37, '3701-001784', 'HDMI socket'),
77('hdmi', '2070567.jpg', '', 38, '2070567', 'HDMI socket'),
78('hdmi', 'AV19889.png', '', 39, 'AV19889', 'HDMI socket'),
79('hdmi', 'AV19892.png', '', 40, 'AV19892', 'HDMI socket'),
80('hdmi', 'BBPMICROHDMI.png', '', 41, 'BBPMICROHDMI', 'HDMI socket'),
81('hdmi', 'ME301T-HDMI.jpg', '', 42, 'ME301T-HDMI', 'HDMI socket'),
82('hdmi', 'OOW080-0848-000.png', '', 43, 'OOW080-0848-000', 'HDMI socket'),
83('optical', '3707-001095.png', '', 44, '3707-001095', 'Optical socket'),
84('optical', '3707-001104.jpg', '', 45, '3707-001104', 'Optical socket'),
85('optical', '03707-001106.jpg', '', 46, '03707-001106', 'Optical socket'),
86('optical', 'eag37842001.jpg', '', 47, 'eag37842001', 'Optical socket'),
87('optical', 'K7AAAY000014.png', '', 48, 'K7AAAY000014', 'Optical socket'),
88('optical', 'OOWEAG37842007.png', '', 49, 'OOWEAG37842007', 'Optical socket'),
89('power', '3710-003319.png', '', 50, '3710-003319', 'Power socket'),
90('power', '3722-002132.png', '', 51, '3722-002132', 'Power socket'),
91('power', '3722-002997.png', '', 52, '3722-002997', 'Power socket'),
92('power', '3722-003163.png', '', 53, '3722-003163', 'Power socket'),
93('power', '3722-003236.png', '', 54, '3722-003236', 'Power socket'),
94('power', '3722-003305.png', '', 55, '3722-003305', 'Power socket'),
95('power', '3722-003340.png', '', 56, '3722-003340', 'Power socket'),
96('power', '08301-00522000.jpg', '', 57, '08301-00522000', 'Power socket'),
97('power', 'a126001.jpg', '', 58, 'a126001', 'Power socket'),
98('power', 'ba39-01257a.jpg', '', 59, 'ba39-01257a', 'Power socket'),
99('power', 'dc-s500ca.jpg', '', 60, 'dc-s500ca', 'Power socket'),
100('power', 'DC1N.png', '', 61, 'DC1N', 'Power socket'),
101('power', 'DC2A.png', '', 62, 'DC2A', 'Power socket'),
102('power', 'DC22.png', '', 63, 'DC22', 'Power socket'),
103('power', 'DC34.png', '', 64, 'DC34', 'Power socket'),
104('power', 'DC44.png', '', 65, 'DC44', 'Power socket'),
105('power', 'DC56.png', '', 66, 'DC56', 'Power socket'),
106('power', 'DC80.png', '', 67, 'DC80', 'Power socket'),
107('power', 'DC90.png', '', 68, 'DC90', 'Power socket'),
108('power', 'DCX101.png', '', 69, 'DCX101', 'Power socket'),
109('power', 'kzdc007.jpg', '', 70, 'kzdc007', 'Power socket'),
110('power', 'kzdc019a.jpg', '', 71, 'kzdc019a', 'Power socket'),
111('power', 'PJ03.png', '', 72, 'PJ03', 'Power socket'),
112('power', 'PJ03A.png', '', 73, 'PJ03A', 'Power socket'),
113('power', 'PJ09.png', '', 74, 'PJ09', 'Power socket'),
114('power', 'PJ10.png', '', 75, 'PJ10', 'Power socket'),
115('power', 'PJ11.png', '', 76, 'PJ11', 'Power socket'),
116('power', 'PJ14.png', '', 77, 'PJ14', 'Power socket'),
117('power', 'PJ16.png', '', 78, 'PJ16', 'Power socket'),
118('power', 'PJ17.png', '', 79, 'PJ17', 'Power socket'),
119('power', 'PJ30.png', '', 80, 'PJ30', 'Power socket'),
120('power', 'PJ33.png', '', 81, 'PJ33', 'Power socket'),
121('power', 'PJ58.png', '', 82, 'PJ58', 'Power socket'),
122('power', 'PJ061.png', '', 83, 'PJ061', 'Power socket'),
123('power', 'PJ078.png', '', 84, 'PJ078', 'Power socket'),
124('power', 'PJ103A.png', '', 85, 'PJ103A', 'Power socket'),
125('power', 'pj112.jpg', '', 86, 'pj112', 'Power socket'),
126('power', 'pj201.png', '', 87, 'pj201', 'Power socket'),
127('power', 'ux31e-1a.jpg', '', 88, 'ux31e-1a', 'Power socket'),
128('power', 'UX31E-DC.png', '', 89, 'UX31E-DC', 'Power socket'),
129('power', 'ux301dcsock.jpg', '', 90, 'ux301dcsock', 'Power socket'),
130('power', 'ux305dcsock.jpg', '', 91, 'ux305dcsock', 'Power socket'),
131('power', 'versusdcsocket.png', '', 92, 'versusdcsocket', 'Power socket'),
132('rj45', '3722-002914.png', '', 93, '3722-002914', 'RJ45 socket'),
133('rj45', '3722-003036.png', '', 94, '3722-003036', 'RJ45 socket'),
134('rj45', '3722-003085.png', '', 95, '3722-003085', 'RJ45 socket'),
135('rj45', '3722-003354.png', '', 96, '3722-003354', 'RJ45 socket'),
136('rj45', 'XRJ45001.png', '', 97, 'XRJ45001', 'RJ45 socket'),
137('usb', '151-1082-ND.png', '', 98, '151-1082-ND', 'USB socket'),
138('usb', '798-zx62r-b-5p.jpg', '', 99, '798-zx62r-b-5p', 'USB socket'),
139('usb', '3722-001524.png', '', 100, '3722-001524', 'USB socket'),
140('usb', '3722-002002.jpg', '', 101, '3722-002002', 'USB socket'),
141('usb', '3722-002002.png', '', 102, '3722-002002', 'USB socket'),
142('usb', '3722-002382.png', '', 103, '3722-002382', 'USB socket'),
143('usb', '3722-002546.jpg', '', 104, '3722-002546', 'USB socket'),
144('usb', '3722-002601.jpg', '', 105, '3722-002601', 'USB socket'),
145('usb', '3722-002767.png', '', 106, '3722-002767', 'USB socket'),
146('usb', '3722-002808.png', '', 107, '3722-002808', 'USB socket'),
147('usb', '3722-002925.png', '', 108, '3722-002925', 'USB socket'),
148('usb', '3722-003037.png', '', 109, '3722-003037', 'USB socket'),
149('usb', '3722-003044.jpg', '', 110, '3722-003044', 'USB socket'),
150('usb', '3722-003225.jpg', '', 111, '3722-003225', 'USB socket'),
151('usb', '3722-003270.png', '', 112, '3722-003270', 'USB socket'),
152('usb', '3722-003302.png', '', 113, '3722-003302', 'USB socket'),
153('usb', '3722-003317.png', '', 114, '3722-003317', 'USB socket'),
154('usb', '3722-003330.jpg', '', 115, '3722-003330', 'USB socket'),
155('usb', '3722-003457.jpg', '', 116, '3722-003457', 'USB socket'),
156('usb', '3722-003512.jpg', '', 117, '3722-003512', 'USB socket'),
157('usb', '3722-003767.png', '', 118, '3722-003767', 'USB socket'),
158('usb', '4010.png', '', 119, '4010', 'USB socket'),
159('usb', '4011.png', '', 120, '4011', 'USB socket'),
160('usb', '4015.png', '', 121, '4015', 'USB socket'),
161('usb', '47491-0001.png', '', 122, '47491-0001', 'USB socket'),
162('usb', '282336-1-ND.png', '', 123, '282336-1-ND', 'USB socket'),
163('usb', '1137985.png', '', 124, '1137985', 'USB socket'),
164('usb', '2293836.png', '', 125, '2293836', 'USB socket'),
165('usb', '3722-003840.jpg', '', 126, '3722-003840', 'USB socket'),
166('usb', 'bbpusb.jpg', '', 127, 'bbpusb', 'USB socket'),
167('usb', 'G6-2USB3.jpg', '', 128, 'G6-2USB3', 'USB Socket'),
168('usb', 'H000053410.jpg', '', 129, 'H000053410', 'USB Socket'),
169('usb', 'kindlefireusb.jpg', '', 130, 'kindlefireusb', 'USB Socket'),
170('usb', 'kzua002.jpg', '', 131, 'kzua002', 'USB Socket'),
171('usb', 'LENO-MICRO-USB.png', '', 132, 'LENO-MICRO-USB', 'USB Socket'),
172('usb', 'lenovo-miix-10-usb.png', '', 133, 'lenovo-miix-10-usb', 'USB Socket'),
173('usb', 'me301t-usb-socket.jpg', '', 134, 'me301t-usb-socket', 'USB Socket'),
174('usb', 'MINIUSB.png', '', 135, 'MINIUSB', 'USB Socket'),
175('usb', 'musb015.jpg', '', 136, 'musb015', 'USB Socket'),
176('usb', 'NEXUS7USB.png', '', 137, 'NEXUS7USB', 'USB Socket'),
177('usb', 'OOW080-0847-000.png', '', 138, 'OOW080-0847-000', 'USB Socket'),
178('usb', 'UN15111-N12A41-7H.png', '', 139, 'UN15111-N12A41-7H', 'USB Socket'),
179('usb', 'usb-acer-flush.jpg', '', 140, 'usb-acer-flush', 'USB Socket'),
180('usb', 'usb-t100t.jpg', '', 141, 'usb-t100t', 'USB Socket'),
181('usb', 'USB1S.png', '', 142, 'USB1S', 'USB Socket'),
182('usb', 'usb3-001.jpg', '', 143, 'usb3-001', 'USB Socket'),
183('usb', 'usb3-002.jpg', '', 144, 'usb3-002', 'USB Socket'),
184('usb', 'usb3-003.jpg', '', 145, 'usb3-003', 'USB Socket'),
185('usb', 'USB12S.png', '', 146, 'USB12S', 'USB Socket'),
186('usb', 'USB26SR.png', '', 147, 'USB26SR', 'USB Socket'),
187('usb', 'usb30.jpg', '', 148, 'usb30', 'USB Socket'),
188('usb', 'usb31.jpg', '', 149, 'usb31', 'USB Socket'),
189('usb', 'usb32.jpg', '', 150, 'usb32', 'USB Socket'),
190('usb', 'usb33 usb-acer-mid.jpg', '', 151, 'usb33 usb-acer-mid', 'USB Socket'),
191('usb', 'usb999.jpg', '', 152, 'usb999', 'USB Socket'),
192('usb', 'usbv001.jpg', '', 153, 'usbv001', 'USB Socket'),
193('switches', '78-1130.png', '', 154, '78-1130', 'Switch'),
194('switches', '165-6435.png', '', 155, '165-6435', 'Switch'),
195('switches', '171-2963.png', '', 156, '171-2963', 'Switch'),
196('switches', '1712997.png', '', 157, '1712997', 'Switch'),
197('switches', 'MA12RTR.png', '', 158, 'MA12RTR', 'Switch'),
198('switches', 'SW03035.png', '', 159, 'SW03035', 'Switch'),
199('switches', '1217764.png', '', 160, '1217764', 'Switch'),
200('switches', '3409-001150.png', '', 161, '3409-001150', 'Switch'),
201('switches', '1867985.png', '', 162, '1867985', 'Switch'),
202('switches', 'OOW280-0096-000.png', '', 163, 'OOW280-0096-000', 'Switch'),
203('switches', 'SW02884.png', '', 164, 'SW02884', 'Switch'),
204('switches', 'TS4408.jpg', '', 165, 'TS4408', 'Switch'),
205('usb', 'Z300C.png', 'Z300C.png', 168, 'Z300C', 'Z300C USB'),
206('switches', 'me102atopsw.png', 'me102atopsw.png', 169, 'ME102ATOPSW', 'ME102ATOPSW Side mount switch.'),
207('switches', 'ME102ASIDESW.png', 'ME102ASIDESW.png', 170, 'ME102ASIDESW', 'ME102ASIDESW Side mount switch.'),
208('audio', 'ME102AAUDIO.png', 'ME102AAUDIO.png', 171, 'ME102AAUDIO', 'ME102AAUDIO Audio socket.'),
209('usb', 'KZMU019.png', 'KZMU019.png', 172, 'KZMU019', 'USB socket'),
210('audio', '792785-501.png', '', 173, '792785-501', 'Audio socket'),
211('usb', '3722-003531.jpg', '', 174, '3722-003531', 'USB socket'),
212('usb', '3722-003700.jpg', '', 175, '3722-003700', 'USB socket'),
213('usb', '3722-003708.jpg', '', 178, '3722-003708', 'USB socket'),
214('usb', '3722-003954.jpg', '', 179, '3722-003954', 'USB socket'),
215('switches', '3404-001547.jpg', '', 182, '3404-001547', 'Switch'),
216('usb', 'hp-x2-usb-c-port.jpg', '', 202, 'hp-x2-usb-c-port', 'hp-x2-usb-c-port '),
217('usb', 'HP-X2-USB3PORT.jpg', '', 208, 'HP-X2-USB3PORT', 'HP-X2-USB3PORT.jpg usb socket'),
218('audio', '15-NAUDIO.jpg', '', 209, '15-NAUDIO', 'Audio socket'),
219('audio', 'AUDIO-ES1.jpg', '', 210, 'AUDIO-ES1', 'Audio socket'),
220('audio', 'HP-15-AUDIOSOC.jpg', '', 211, 'HP-15-AUDIOSOC', 'Audio socket'),
221('audio', '141011.jpg', '', 212, '141011', 'Audio socket'),
222('audio', 'L50BAUDIO.jpg', '', 213, 'L50BAUDIO', 'Audio socket'),
223('audio', 'AUDIO-CQ62.jpg', '', 219, 'AUDIO-CQ62 ', 'Audio socket'),
224('audio', '2SJ-E960-OO1F.jpg', '', 220, '2SJ-E960-OO1F', 'Audio socket'),
225('audio', 'CQ58AUDIO.jpg', '', 221, 'CQ58AUDIO', 'Audio socket'),
226('power', 'X540SA-DC.jpg', '', 225, 'X540SA-DC', 'DC socket'),
227('power', 'DC-V3-112P.jpg', '', 226, 'DC-V3-112P', 'DC socket'),
228('power', 'ASUS-DCSOCKET-7.jpg', '', 227, 'ASUS-DCSOCKET-7', 'DC socket'),
229('usb', 'USB2-V3-112P.jpg', '', 231, 'USB2-V3-112P', 'USB Socket'),
230('usb', 'LENOVO-G50-USB2.jpg', '', 232, 'LENOVO-G50-USB2', 'USB Socket'),
231('usb', 'C50B-USB2.jpg', '', 233, 'C50B-USB2', 'USB Socket'),
232('usb', 'USB3-V3-112P.jpg', '', 234, 'USB3-V3-112P', 'USB Socket'),
233('switches', 'wi-fi-switch.png', '', 239, 'wi-fi-switch', 'Switch'),
234('audio', 'ACER-F5-571-AUDIO.jpg', '', 240, 'ACER-F5-571-AUDIO', 'Audio socket'),
235('power', 'DC-35042322.jpg', '', 241, 'DC-35042322', 'DC Socket'),
236('power', 'DC5B20L71657.jpg', '', 242, 'DC5B20L71657', 'DC Socket'),
237('usb', 'E5-USB3.jpg', '', 243, 'E5-USB3', 'USB Socket'),
238('usb', 'E403SA-USBC.jpg', '', 244, 'E403SA-USBC', 'USB Socket'),
239('rj45', 'G5080-ETHERNET.jpg', '', 245, 'G5080-ETHERNET', 'Ethernet socket'),
240('power', 'DC5B20L71657.jpg', '', 252, 'DC5B20L71657', 'DC Socket'),
241('usb', 'G5080-USB3.jpg', '', 256, 'G5080-USB3', 'USB Socket'),
242('hdmi', 'HP-15-G-HDMI.jpg', '', 257, 'HP-15-G-HDMI', 'HDMI Socket'),
243('rj45', 'HP-15-G-RJ45-SOCKET.jpg', '', 258, 'HP-15-G-RJ45-SOCKET', 'Ethernet Socket'),
244('usb', 'HP-15-G-USB-3-SOCKET.jpg', '', 259, 'HP-15-G-USB-3-SOCKET', 'USB Socket'),
245('hdmi', 'IP500-HDMI.jpg', '', 260, 'IP500-HDMI', 'HDMI Socket'),
246('hdmi', 'MS16J41-HDMI.jpg', '', 261, 'MS16J41-HDMI', 'HDMI Socket'),
247('power', 'OOW3722-003322.jpg', '', 262, 'OOW3722-003322', 'DC socket'),
248('usb', 'USB3-OOW773370-501.jpg', '', 263, 'USB3-OOW773370-501', 'USB Socket'),
249('rj45', 'VN7-ETHERNET.jpg', '', 264, 'VN7-ETHERNET', 'Ethernet Socket'),
250('usb', 'VN7-USBC.jpg', '', 265, 'VN7-USBC', 'USB Socket'),
251('power', 'X555L-DC.jpg', '', 266, 'X555L-DC', 'DC Socket'),
252('hdmi', 'YOGA3-HDMI.jpg', '', 267, 'YOGA3-HDMI', 'HDMI Socket'),
253('hdmi', 'YOGA311-HDMI.jpg', '', 268, 'YOGA311-HDMI', 'HDMI Socket'),
254('hdmi', 'IP500-HDMI.jpg', '', 270, 'IP500-HDMI', 'HDMI Socket'),
255('usb', 'YOGA311-USB3.jpg', '', 279, 'YOGA311-USB3', 'USB Socket'),
256('power', '3B3DC.jpg', '', 280, '3B3DC', 'DC Socket'),
257('hdmi', '3701-001762.jpg', '', 281, '3701-001762', '3701-001762 HDMI Socket'),
258('hdmi', 'EAG62611204.jpg', '', 282, 'EAG62611204', 'EAG62611204 HDMI Socket');
259
260-- --------------------------------------------------------
261
262--
263-- Table structure for table `submitted_p97`
264--
265
266CREATE TABLE `submitted_p97` (
267  `id` int(6) NOT NULL,
268  `partNumber` varchar(50) NOT NULL,
269  `img_1` varchar(50) NOT NULL,
270  `Img_2` varchar(50) NOT NULL,
271  `img_3` varchar(50) DEFAULT NULL,
272  `img_4` varchar(50) DEFAULT NULL,
273  `img_5` varchar(50) DEFAULT NULL,
274  `ext` varchar(200) NOT NULL,
275  `validated` int(1) NOT NULL DEFAULT '0'
276) ENGINE=InnoDB DEFAULT CHARSET=latin1;
277
278--
279-- Dumping data for table `submitted_p97`
280--
281
282INSERT INTO `submitted_p97` (`id`, `partNumber`, `img_1`, `Img_2`, `img_3`, `img_4`, `img_5`, `ext`, `validated`) VALUES
283(7, 'test1 part no', 'qra84okxozwohyxgkfb9.png', '', '', '', '', 'test', 0),
284(8, 'test1 part no', '9jyn8gb94c6idvoek9t9.png', 'nb979rp5mfjlo8zme0m8.png', '', '3jh64wbfvve9xe7wvns7.png', '', 'testing', 0),
285(9, 'test1 part no', '5ebsyue7c9d5vi4eb7nu.png', '', '', '', '', 'testing testing', 0),
286(10, 'test1 part no', '3ious5n98863u44cykd5.png', '', '', '', '', 'tsttestestsetsetset', 0),
287(11, 'test1 part no', '5ayflsaehled63nvp4zp.png', '', '', '', '', 'mandd', 0),
288(12, 'test1 part no', 'ckbtjdg48hrso0od0cjk.png', '', '', '', '', 'testing', 0),
289(13, 'test1 part no2222', 'nlq8ef95pwkuvg4yjezs.png', '', '', '', '', 'testing', 0),
290(14, 'test1 part no333', 'uuhv40xuufzvq9c1k0je.png', '', '', '', '', 'afegrhtjryktubn', 0),
291(15, 'test1 part no', 'fcluyz3pxh784mgqnnmv.png', '', '', '', '', 'testing', 0),
292(16, 'test1 part no', '7pik7wsguyd0mzbprthf.png', '', '', '', '', 'regsdgjkhjfhswe', 0);
293
294-- --------------------------------------------------------
295
296--
297-- Table structure for table `validated_p97`
298--
299
300CREATE TABLE `validated_p97` (
301  `id` int(6) NOT NULL,
302  `partNumber` varchar(50) NOT NULL,
303  `img_1` varchar(50) NOT NULL,
304  `Img_2` varchar(50) NOT NULL,
305  `img_3` varchar(50) DEFAULT NULL,
306  `img_4` varchar(50) DEFAULT NULL,
307  `img_5` varchar(50) DEFAULT NULL,
308  `ext` varchar(200) NOT NULL
309) ENGINE=InnoDB DEFAULT CHARSET=latin1;
310
311--
312-- Indexes for dumped tables
313--
314
315--
316-- Indexes for table `components`
317--
318ALTER TABLE `components`
319  ADD PRIMARY KEY (`id`);
320
321--
322-- Indexes for table `submitted_p97`
323--
324ALTER TABLE `submitted_p97`
325  ADD PRIMARY KEY (`id`);
326
327--
328-- Indexes for table `validated_p97`
329--
330ALTER TABLE `validated_p97`
331  ADD PRIMARY KEY (`id`);
332
333--
334-- AUTO_INCREMENT for dumped tables
335--
336
337--
338-- AUTO_INCREMENT for table `components`
339--
340ALTER TABLE `components`
341  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=287;
342--
343-- AUTO_INCREMENT for table `submitted_p97`
344--
345ALTER TABLE `submitted_p97`
346  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
347--
348-- AUTO_INCREMENT for table `validated_p97`
349--
350ALTER TABLE `validated_p97`
351  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;
352/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
353/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
354/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;