Zm3Jh4UM

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4CREATE TABLE IF NOT EXISTS `characters` (
5`charid` int(4) NOT NULL,
6  `first` varchar(50) NOT NULL,
7  `last` varchar(50) NOT NULL,
8  `birthdate` date NOT NULL,
9  `birthplace` varchar(50) NOT NULL DEFAULT 'Los Santos',
10  `street` varchar(50) DEFAULT 'Homeless',
11  `unit` varchar(10) DEFAULT '0'
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;
13
14CREATE TABLE IF NOT EXISTS `login` (
15`userid` int(4) NOT NULL,
16  `Username` varchar(18) NOT NULL,
17  `Password` varchar(18) NOT NULL
18) ENGINE=InnoDB DEFAULT CHARSET=latin1;
19
20CREATE TABLE IF NOT EXISTS `ranks` (
21`userid` int(4) NOT NULL,
22  `rankid` int(2) DEFAULT NULL
23) ENGINE=InnoDB DEFAULT CHARSET=latin1;
24
25CREATE TABLE IF NOT EXISTS `vehicles` (
26`charid` int(4) NOT NULL,
27  `plate` varchar(50) NOT NULL,
28  `stolen` tinyint(1) NOT NULL DEFAULT 0,
29  `insurance` tinyint(1) NOT NULL DEFAULT 1,
30  `model` text DEFAULT NULL,
31  `comments` text DEFAULT NULL,
32  `color` varchar(20) DEFAULT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35ALTER TABLE `characters`
36 ADD PRIMARY KEY (`charid`);
37
38ALTER TABLE `login`
39 ADD PRIMARY KEY (`userid`), ADD UNIQUE KEY `Username` (`Username`);
40
41ALTER TABLE `ranks`
42 ADD PRIMARY KEY (`userid`);
43
44ALTER TABLE `vehicles`
45 ADD PRIMARY KEY (`charid`), ADD UNIQUE KEY `plate` (`plate`), ADD KEY `stolen` (`stolen`,`insurance`);
46
47ALTER TABLE `characters`
48MODIFY `charid` int(4) NOT NULL AUTO_INCREMENT;
49
50ALTER TABLE `login`
51MODIFY `userid` int(4) NOT NULL AUTO_INCREMENT;
52
53ALTER TABLE `ranks`
54MODIFY `userid` int(4) NOT NULL AUTO_INCREMENT;
55
56ALTER TABLE `vehicles`
57MODIFY `charid` int(4) NOT NULL AUTO_INCREMENT;
58
59/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
60/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
61/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;