Файл: install/db_tables/super_car.sql
Строк: 33
CREATE TABLE IF NOT EXISTS `super_car` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`level` int(11) NOT NULL,
`name` varchar(128) NOT
NULL,
`color` int(3) NOT NULL,
`screen` varchar(128) NOT NULL,
`class` varchar(128) NOT NULL,
`m_speed` int(11) NOT NULL,
`uprav`
int(11) NOT NULL,
`cost` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
INSERT INTO
`super_car` (`id`, `level`, `name`, `color`, `screen`, `class`, `m_speed`,
`uprav`, `cost`) VALUES
(1, 0, 'VAZ 2107', 0, 'vaz2107.png', 'd', 70, 15,
10000),
(2, 0, 'VAZ 2109', 0, 'vaz2109.png', 'd', 100, 30, 18000),
(3, 0,
'VAZ 09 TUNING', 0, 'vaz2109t.png', 'd', 120, 40, 24000),
(4, 1, 'NIVA', 0,
'vazNiva.png', 'd', 130, 60, 30000),
(5, 1, 'VAZ 2112', 0, 'vaz2112.png',
'd', 140, 80, 34000),
(6, 2, 'PRIORA', 0, 'vazPriora.png', 'd', 150, 100,
37000),
(7, 2, 'PRIORA TUNING', 0, 'vazPriorat.png', 'd', 165, 130,
40000),
(8, 2, 'Mercedes W', 0, 'MercedesW123.png', 'd', 180, 160,
47000),
(9, 3, 'Fiat', 0, 'fiat.png', 'd', 200, 180, 49000),
(10, 3,
'Nissan Micra', 0, 'nissanmicra.png', 'd', 210, 200, 60000),
(11, 3,
'Logan', 0, 'logan.png', 'd', 215, 210, 65000),
(12, 4, 'Smart car', 0,
'Smartcar.png', 'd', 220, 230, 80000),
(13, 4, 'KIA', 0, 'paint.png', 'd',
230, 240, 84000),
(14, 4, 'Ferrari', 0, '49774.png', 'd', 270, 280,
100000),
(15, 4, 'Lamborgini', 0, '663243.png', 'd', 300, 300, 110000);