VZknhFED

1CREATE TABLE IF NOT EXISTS `gang` (
2`id` int(10) NOT NULL,
3  `name` varchar(30) NOT NULL,
4  `color` varchar(6) NOT NULL,
5  `tag` varchar(3) NOT NULL,
6  `score` int(10) NOT NULL DEFAULT '0'
7) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
8 
9-- --------------------------------------------------------
10 
11CREATE TABLE IF NOT EXISTS `member` (
12`id` int(10) NOT NULL,
13  `name` varchar(30) NOT NULL,
14  `status` int(1) NOT NULL DEFAULT '1',
15  `gang` int(10) NOT NULL DEFAULT '-1'
16) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
17 
18-- --------------------------------------------------------
19  
20CREATE TABLE IF NOT EXISTS `zone` (
21`id` int(10) NOT NULL,
22  `minx` varchar(10) NOT NULL,
23  `miny` varchar(10) NOT NULL,
24  `maxx` varchar(10) NOT NULL,
25  `maxy` varchar(10) NOT NULL,
26  `owner` int(10) NOT NULL DEFAULT '-1',
27  `name` varchar(50) NOT NULL DEFAULT 'Undefined Zone'
28) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
29 
30ALTER TABLE `gang`
31 ADD PRIMARY KEY (`id`);
32 
33--
34-- Indexes for table `member`
35--
36ALTER TABLE `member`
37 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`);
38 
39--
40-- Indexes for table `zone`
41--
42ALTER TABLE `zone`
43 ADD PRIMARY KEY (`id`);
44 
45--
46-- AUTO_INCREMENT for dumped tables
47--
48 
49--
50-- AUTO_INCREMENT for table `gang`
51--
52ALTER TABLE `gang`
53MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
54--
55-- AUTO_INCREMENT for table `member`
56--
57ALTER TABLE `member`
58MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
59--
60-- AUTO_INCREMENT for table `zone`
61--
62ALTER TABLE `zone`
63MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
64-- ------------------------------------------------