Файл: www/sgonki/gonk.sql
Строк: 74
CREATE TABLE IF NOT EXISTS `supergonki` (
`id` int(11) NOT NULL
auto_increment,
`id_u` int(11) NOT NULL,
`car` int(5) NOT NULL
default '1',
`speed` int(11) NOT NULL default '100',
`uprav` int(11)
NOT NULL default '25',
`color` int(3) NOT NULL,
`win` int(11) NOT
NULL,
`race_last` int(11) NOT NULL,
`race_kol` int(4) NOT NULL,
`racer` int(11) NOT NULL,
`shina` int(11) NOT NULL default '1',
`za`
int(11) NOT NULL default '1',
`cz` int(11) NOT NULL default '1',
`zak` int(11) NOT NULL default '1',
`podv` int(11) NOT NULL default
'1',
`vpusk` int(11) NOT NULL default '1',
`lose` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`money` int(11) NOT NULL default '1000',
`level` int(11) NOT NULL,
`resp` int(11) NOT NULL,
`samoobl` int(11)
NOT NULL,
`reak` int(11) NOT NULL,
`nextlevel` int(11) NOT NULL
default '6',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=258 ;
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);
CREATE TABLE IF NOT EXISTS
`super_race` (
`id` int(11) NOT NULL auto_increment,
`id_1` int(11)
NOT NULL,
`id_2` int(11) NOT NULL,
`who_win` int(8) NOT NULL,
`act` enum('0','1') default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=392 ;