dTEFpSsg

1CREATE TABLE IF NOT EXISTS `vehicles` (
2  `ID` mediumint(6) NOT NULL AUTO_INCREMENT,
3  `Owner` varchar(24) NOT NULL,
4  `Model` mediumint(6) NOT NULL,
5  `Price` int(10) NOT NULL,
6  `Locked` tinyint(1) NOT NULL DEFAULT 1,
7  `PaintJob` smallint(3) NOT NULL DEFAULT -1,
8  `Color1` smallint(3) NOT NULL DEFAULT 0,
9  `Color2` smallint(3) NOT NULL DEFAULT 0,
10  `Plate` varchar(12) NOT NULL DEFAULT '*',
11  `Mod1` smallint(5) unsigned NOT NULL DEFAULT 0,
12  `Mod2` smallint(5) unsigned NOT NULL DEFAULT 0,
13  `Mod3` smallint(5) unsigned NOT NULL DEFAULT 0,
14  `Mod4` smallint(5) unsigned NOT NULL DEFAULT 0,
15  `Mod5` smallint(5) unsigned NOT NULL DEFAULT 0,
16  `Mod6` smallint(5) unsigned NOT NULL DEFAULT 0,
17  `Mod7` smallint(5) unsigned NOT NULL DEFAULT 0,
18  `Mod8` smallint(5) unsigned NOT NULL DEFAULT 0,
19  `Mod9` smallint(5) unsigned NOT NULL DEFAULT 0,
20  `Mod10` smallint(5) unsigned NOT NULL DEFAULT 0,
21  `Mod11` smallint(5) unsigned NOT NULL DEFAULT 0,
22  `Mod12` smallint(5) unsigned NOT NULL DEFAULT 0,
23  `Mod13` smallint(5) unsigned NOT NULL DEFAULT 0,
24  `Mod14` smallint(5) unsigned NOT NULL DEFAULT 0,
25  `Mod15` smallint(5) unsigned NOT NULL DEFAULT 0,
26  `Mod16` smallint(5) unsigned NOT NULL DEFAULT 0,
27  `Mod17` smallint(5) unsigned NOT NULL DEFAULT 0,
28  `Model_2` mediumint(6) NOT NULL DEFAULT 0,
29  `Price_2` int(10) NOT NULL DEFAULT 0,
30  `Paintjob_2` smallint(3) NOT NULL DEFAULT -1,
31  `Color1_2` smallint(3) NOT NULL DEFAULT 0,
32  `Color2_2` smallint(3) NOT NULL DEFAULT 0,
33  `Locked2` tinyint(1) NOT NULL DEFAULT 1,
34  `Plate2` varchar(12) NOT NULL DEFAULT '*',
35  `Mod1S2` smallint(5) unsigned NOT NULL DEFAULT 0,
36  `Mod2S2` smallint(5) unsigned NOT NULL DEFAULT 0,
37  `Mod3S2` smallint(5) unsigned NOT NULL DEFAULT 0,
38  `Mod4S2` smallint(5) unsigned NOT NULL DEFAULT 0,
39  `Mod5S2` smallint(5) unsigned NOT NULL DEFAULT 0,
40  `Mod6S2` smallint(5) unsigned NOT NULL DEFAULT 0,
41  `Mod7S2` smallint(5) unsigned NOT NULL DEFAULT 0,
42  `Mod8S2` smallint(5) unsigned NOT NULL DEFAULT 0,
43  `Mod9S2` smallint(5) unsigned NOT NULL DEFAULT 0,
44  `Mod10S2` smallint(5) unsigned NOT NULL DEFAULT 0,
45  `Mod11S2` smallint(5) unsigned NOT NULL DEFAULT 0,
46  `Mod12S2` smallint(5) unsigned NOT NULL DEFAULT 0,
47  `Mod13S2` smallint(5) unsigned NOT NULL DEFAULT 0,
48  `Mod14S2` smallint(5) unsigned NOT NULL DEFAULT 0,
49  `Mod15S2` smallint(5) unsigned NOT NULL DEFAULT 0,
50  `Mod16S2` smallint(5) unsigned NOT NULL DEFAULT 0,
51  `Mod17S2` smallint(5) unsigned NOT NULL DEFAULT 0,
52  `Model_3` mediumint(5) NOT NULL DEFAULT 0,
53  `Price_3` int(10) NOT NULL DEFAULT 0,
54  `Paintjob_3` smallint(3) NOT NULL DEFAULT -1,
55  `Color1_3` smallint(3) NOT NULL DEFAULT 0,
56  `Color2_3` smallint(3) NOT NULL DEFAULT 0,
57  `LockedS3` tinyint(1) NOT NULL DEFAULT 1,
58  `PlateS3` varchar(12) NOT NULL DEFAULT '*',
59  `Mod1S3` smallint(5) unsigned NOT NULL DEFAULT 0,
60  `Mod2S3` smallint(5) unsigned NOT NULL DEFAULT 0,
61  `Mod3S3` smallint(5) unsigned NOT NULL DEFAULT 0,
62  `Mod4S3` smallint(5) unsigned NOT NULL DEFAULT 0,
63  `Mod5S3` smallint(5) unsigned NOT NULL DEFAULT 0,
64  `Mod6S3` smallint(5) unsigned NOT NULL DEFAULT 0,
65  `Mod7S3` smallint(5) unsigned NOT NULL DEFAULT 0,
66  `Mod8S3` smallint(5) unsigned NOT NULL DEFAULT 0,
67  `Mod9S3` smallint(5) unsigned NOT NULL DEFAULT 0,
68  `Mod10S3` smallint(5) unsigned NOT NULL DEFAULT 0,
69  `Mod11S3` smallint(5) unsigned NOT NULL DEFAULT 0,
70  `Mod12S3` smallint(5) unsigned NOT NULL DEFAULT 0,
71  `Mod13S3` smallint(5) unsigned NOT NULL DEFAULT 0,
72  `Mod14S3` smallint(5) unsigned NOT NULL DEFAULT 0,
73  `Mod15S3` smallint(5) unsigned NOT NULL DEFAULT 0,
74  `Mod16S3` smallint(5) unsigned NOT NULL DEFAULT 0,
75  `Mod17S3` smallint(5) unsigned NOT NULL DEFAULT 0,
76  PRIMARY KEY (`ID`)
77) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;