TTmNZBNC

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3
4
5/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
6/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
7/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
8/*!40101 SET NAMES utf8 */;
9
10DELIMITER $$
11--
12-- Procedures
13-- Edit arma3 and root to match a user in MySQL
14--
15CREATE PROCEDURE `resetLifeVehicles`()
16BEGIN
17	UPDATE vehicles SET `active`= 0;
18END$$
19
20CREATE PROCEDURE `deleteDeadVehicles`()
21BEGIN
22	DELETE FROM `vehicles` WHERE `alive` = 0;
23END$$
24
25CREATE PROCEDURE `deleteOldHouses`()
26BEGIN
27  DELETE FROM `houses` WHERE `owned` = 0;
28END$$
29
30CREATE PROCEDURE `deleteOldGangs`()
31BEGIN
32  DELETE FROM `gangs` WHERE `active` = 0;
33END$$
34
35DELIMITER ;
36
37-- --------------------------------------------------------
38
39--
40-- Table structure for table `players`
41--
42
43CREATE TABLE IF NOT EXISTS `players` (
44  `uid` int(12) NOT NULL AUTO_INCREMENT,
45  `name` varchar(32) NOT NULL,
46  `playerid` varchar(50) NOT NULL,
47  `cash` int(100) NOT NULL DEFAULT '0',
48  `bankacc` int(100) NOT NULL DEFAULT '0',
49  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
50  `cop_licenses` text,
51  `civ_licenses` text,
52  `med_licenses` text,
53  `cop_gear` text NOT NULL,
54  `med_gear` text NOT NULL,
55  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
56  `arrested` tinyint(1) NOT NULL DEFAULT '0',
57  `aliases` text NOT NULL,
58  `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
59  `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
60  `civ_gear` text NOT NULL,
61  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
62  PRIMARY KEY (`uid`),
63  UNIQUE KEY `playerid` (`playerid`),
64  KEY `name` (`name`),
65  KEY `blacklist` (`blacklist`)
66) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
67
68-- --------------------------------------------------------
69
70--
71-- Table structure for table `vehicles`
72--
73
74CREATE TABLE IF NOT EXISTS `vehicles` (
75  `id` int(12) NOT NULL AUTO_INCREMENT,
76  `side` varchar(15) NOT NULL,
77  `classname` varchar(32) NOT NULL,
78  `type` varchar(12) NOT NULL,
79  `pid` varchar(32) NOT NULL,
80  `alive` tinyint(1) NOT NULL DEFAULT '1',
81  `active` tinyint(1) NOT NULL DEFAULT '0',
82  `plate` int(20) NOT NULL,
83  `color` int(20) NOT NULL,
84  `inventory` varchar(500) NOT NULL,
85  PRIMARY KEY (`id`),
86  KEY `side` (`side`),
87  KEY `pid` (`pid`),
88  KEY `type` (`type`)
89) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
90
91-- --------------------------------------------------------
92
93--
94-- Table structure for table `houses`
95-- Needed for extDB latest update on git
96--
97
98CREATE TABLE IF NOT EXISTS `houses` (
99  `id` int(11) NOT NULL AUTO_INCREMENT,
100  `pid` varchar(32) NOT NULL,
101  `pos` varchar(64) DEFAULT NULL,
102  `inventory` text,
103  `containers` text,
104  `owned` tinyint(4) DEFAULT '0',
105  PRIMARY KEY (`id`,`pid`)
106) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
107
108-- --------------------------------------------------------
109
110--
111-- Table structure for table `gangs`
112-- Needed for extDB latest update on git
113--
114
115CREATE TABLE IF NOT EXISTS `gangs` (
116  `id` int(11) NOT NULL AUTO_INCREMENT,
117  `owner` varchar(32) DEFAULT NULL,
118  `name` varchar(32) DEFAULT NULL,
119  `members` text,
120  `maxmembers` int(2) DEFAULT '8',
121  `bank` int(100) DEFAULT '0',
122  `active` tinyint(4) DEFAULT '1',
123  PRIMARY KEY (`id`),
124  UNIQUE KEY `name_UNIQUE` (`name`)
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126
127/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
129/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;