· 8 years ago · Dec 26, 2017, 12:54 PM
1--
2-- Structura de tabel pentru tabelul `stock`
3--
4
5CREATE TABLE IF NOT EXISTS `stock` (
6 `ID` int(11) NOT NULL AUTO_INCREMENT,
7 `Stock` int(11) NOT NULL,
8 `Price` int(20) NOT NULL,
9 `Car` varchar(50) NOT NULL,
10 `vid` int(11) NOT NULL,
11 `speed` int(11) NOT NULL,
12 PRIMARY KEY (`ID`)
13) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;
14
15--
16-- Salvarea datelor din tabel `stock`
17--
18
19INSERT INTO `stock` (`ID`, `Stock`, `Price`, `Car`, `vid`, `speed`) VALUES
20(0, 100, 250000, 'Bike', 509, 93),
21(1, 0, 500000, 'Faggio', 462, 99),
22(2, 0, 700000, 'BMX', 481, 86),
23(3, 0, 800000, 'Benson', 499, 109),
24(4, 59, 850000, 'Perennial', 404, 118),
25(5, 54, 900000, 'Picador', 600, 134),
26(6, 54, 900000, 'Pony', 413, 98),
27(7, 81, 950000, 'Rumpo', 440, 121),
28(8, 78, 1000000, 'Mountain Bike', 510, 114),
29(9, 72, 1000000, 'Moonbeam', 418, 102),
30(10, 74, 1000000, 'Camper', 483, 109),
31(11, 74, 1100000, 'Sadler', 543, 134),
32(12, 75, 1100000, 'Walton', 478, 104),
33(13, 72, 1200000, 'Regina', 479, 124),
34(14, 71, 1300000, 'Bravura', 401, 130),
35(15, 74, 1400000, 'Oceanic', 467, 125),
36(16, 88, 1400000, 'Glendale', 466, 130),
37(17, 83, 1450000, 'Willard', 529, 132),
38(18, 77, 1500000, 'Hermes', 474, 132),
39(19, 90, 1700000, 'Manana', 410, 115),
40(20, 90, 1700000, 'Quad', 471, 98),
41(21, 71, 1800000, 'Intruder', 546, 132),
42(22, 79, 1900000, 'Berkley''s RC Van', 459, 121),
43(23, 79, 2000000, 'Previon', 436, 132),
44(24, 78, 2000000, 'Primo', 547, 127),
45(25, 81, 2000000, 'Fortune', 526, 140),
46(26, 89, 2100000, 'Virgo', 491, 132),
47(27, 86, 2100000, 'Majestic', 517, 140),
48(28, 89, 2200000, 'Bobcat', 422, 124),
49(29, 90, 2200000, 'Cadrona', 527, 132),
50(30, 88, 2300000, 'Sunrise', 550, 128),
51(31, 86, 2500000, 'Burrito', 482, 139),
52(32, 91, 2500000, 'Solair', 458, 140),
53(33, 83, 2600000, 'Mesa', 500, 125),
54(34, 86, 2700000, 'Journey', 508, 96),
55(35, 93, 2800000, 'Merit', 551, 140),
56(36, 88, 2800000, 'Emperor', 585, 136),
57(37, 97, 3000000, 'Landstalker', 400, 140),
58(38, 90, 3100000, 'Nebula', 516, 140),
59(39, 88, 3300000, 'Esperanto', 419, 132),
60(40, 86, 3400000, 'Stallion', 439, 150),
61(41, 91, 3400000, 'Stafford', 580, 136),
62(42, 88, 3400000, 'Clover', 542, 146),
63(43, 91, 3500000, 'Tampa', 549, 136),
64(44, 83, 4000000, 'Blista Compact', 496, 144),
65(45, 86, 4000000, 'Greenwood', 492, 125),
66(46, 87, 4000000, 'Hotknife', 434, 148),
67(47, 82, 4000000, 'Hustler', 545, 130),
68(48, 78, 4100000, 'Vincent', 540, 132),
69(49, 93, 4200000, 'Stratum', 561, 137),
70(50, 86, 4250000, 'Elegant', 507, 147),
71(51, 86, 4300000, 'Washington', 421, 136),
72(52, 88, 4500000, 'Broadway', 575, 140),
73(53, 91, 4700000, 'Tahoma', 566, 142),
74(54, 94, 4700000, 'Savanna', 567, 153),
75(55, 81, 5000000, 'Tornado', 576, 140),
76(56, 88, 5000000, 'Slamvan', 535, 140),
77(57, 80, 5000000, 'Buccaneer', 518, 146),
78(58, 77, 5200000, 'Yosemite', 554, 128),
79(59, 75, 5300000, 'Windsor', 555, 140),
80(60, 71, 5700000, 'Remington', 534, 150),
81(61, 65, 5900000, 'Wayfarer', 586, 127),
82(62, 80, 6000000, 'Bloodring Banger', 504, 153),
83(63, 71, 6200000, 'Premier', 426, 154),
84(64, 71, 6500000, 'Club', 589, 144),
85(65, 52, 6700000, 'Phoenix', 603, 152),
86(66, 113, 6700000, 'Rancher', 489, 124),
87(67, 47, 6700000, 'Freeway', 463, 130),
88(68, 45, 6700000, 'Sabre', 475, 153),
89(69, 66, 6900000, 'Blade', 536, 153),
90(70, 57, 7000000, 'Sentinel', 405, 145),
91(71, 64, 7000000, 'Feltzer', 533, 148),
92(72, 66, 7000000, 'Euros', 587, 146),
93(73, 43, 7000000, 'Admiral', 445, 145),
94(74, 60, 7500000, 'Voodoo', 412, 150),
95(75, 156, 7700000, 'Sanchez', 468, 128),
96(76, 133, 8000000, 'Alpha', 602, 150),
97(77, 121, 9000000, 'Flash', 565, 146),
98(78, 110, 9000000, 'Uranus', 558, 138),
99(79, 110, 9000000, 'Huntley', 579, 140),
100(80, 110, 12000000, 'Comet', 480, 163),
101(81, 110, 13000000, 'BF-400', 581, 134),
102(82, 110, 14000000, 'Super GT', 506, 159),
103(83, 110, 16000000, 'PCJ-600', 461, 143),
104(84, 110, 18000000, 'FCR-900', 521, 141),
105(85, 110, 19000000, 'ZR-350', 477, 165),
106(86, 110, 20000000, 'Jester', 559, 158),
107(87, 110, 21000000, 'Buffalo', 402, 165),
108(88, 110, 22000000, 'Sandking', 495, 156),
109(89, 110, 23000000, 'Elegy', 562, 158),
110(90, 110, 25000000, 'Cheetah', 415, 171),
111(91, 157, 27000000, 'Banshee', 429, 179),
112(92, 110, 35000000, 'Turismo', 451, 172),
113(93, 110, 40000000, 'Sultan', 560, 150),
114(94, 70, 45000000, 'Bullet', 541, 180),
115(95, 120, 60000000, 'NRG-500', 522, 156),
116(96, 114, 80000000, 'Infernus', 411, 197),
117(97, 62, 100000000, 'Sparrow', 469, 77),
118(98, 10000, 100000000, 'Hotring Racer B', 503, 191),
119(99, 10000, 100000000, 'Hotring Racer A', 502, 191),
120(100, 10000, 100000000, 'Vortex', 539, 88),
121(101, 10000, 100000000, 'Hotring Racer', 494, 191),
122(102, 10000, 200000000, 'Maverick', 487, 150),
123(104, 10000, 200000000, 'Monster', 444, 100);
124
125-- --------------------------------------------------------