· 10 years ago · Sep 27, 2016, 06:00 PM
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 utf8mb4 */;
9
10DELIMITER $$
11--
12-- Procedures
13-- Edit arma3 to match a user in MySQ
14-- For external databases: Edit localhost to match arma3server IP
15--
16CREATE DEFINER=`db21602`@'%' PROCEDURE `resetLifeVehicles`()
17BEGIN
18 UPDATE `vehicles` SET `active`= 0;
19END$$
20
21CREATE DEFINER=`db21602`@`%` PROCEDURE `deleteDeadVehicles`()
22BEGIN
23 DELETE FROM `vehicles` WHERE `alive` = 0;
24END$$
25
26CREATE DEFINER=`db21602`@`%` PROCEDURE `deleteOldHouses`()
27BEGIN
28 DELETE FROM `houses` WHERE `owned` = 0;
29END$$
30
31CREATE DEFINER=`db21602`@`%` PROCEDURE `deleteOldGangs`()
32BEGIN
33 DELETE FROM `gangs` WHERE `active` = 0;
34END$$
35
36CREATE DEFINER=`db21602`@`%` PROCEDURE `deleteOldContainers`()
37BEGIN
38 DELETE FROM `containers` WHERE `owned` = 0;
39END$$
40
41DELIMITER ;
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `players`
47--
48
49CREATE TABLE IF NOT EXISTS `players` (
50 `uid` int(12) NOT NULL AUTO_INCREMENT,
51 `name` varchar(32) NOT NULL,
52 `aliases` text NOT NULL,
53 `playerid` varchar(64) NOT NULL,
54 `cash` int(100) NOT NULL DEFAULT '0',
55 `bankacc` int(100) NOT NULL DEFAULT '0',
56 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
57 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
58 `civ_licenses` text NOT NULL,
59 `cop_licenses` text NOT NULL,
60 `med_licenses` text NOT NULL,
61 `civ_gear` text NOT NULL,
62 `cop_gear` text NOT NULL,
63 `med_gear` text NOT NULL,
64 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
65 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
66 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
67 `arrested` tinyint(1) NOT NULL DEFAULT '0',
68 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
69 `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
70 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
71 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
72 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
73 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
74 `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
75 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
76 PRIMARY KEY (`uid`),
77 UNIQUE KEY `playerid` (`playerid`),
78 KEY `name` (`name`),
79 KEY `blacklist` (`blacklist`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;
81
82-- --------------------------------------------------------
83
84--
85-- Table structure for table `vehicles`
86--
87
88CREATE TABLE IF NOT EXISTS `vehicles` (
89 `id` int(12) NOT NULL AUTO_INCREMENT,
90 `side` varchar(16) NOT NULL,
91 `classname` varchar(64) NOT NULL,
92 `type` varchar(16) NOT NULL,
93 `pid` varchar(32) NOT NULL,
94 `alive` tinyint(1) NOT NULL DEFAULT '1',
95 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
96 `active` tinyint(1) NOT NULL DEFAULT '0',
97 `plate` int(20) NOT NULL,
98 `color` int(20) NOT NULL,
99 `inventory` text NOT NULL,
100 `gear` text NOT NULL,
101 `fuel` double NOT NULL DEFAULT '1',
102 `damage` varchar(256) NOT NULL,
103 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
104 PRIMARY KEY (`id`),
105 KEY `side` (`side`),
106 KEY `pid` (`pid`),
107 KEY `type` (`type`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `houses`
114-- Needed for extDB latest update on git
115--
116
117CREATE TABLE IF NOT EXISTS `houses` (
118 `id` int(11) NOT NULL AUTO_INCREMENT,
119 `pid` varchar(32) NOT NULL,
120 `pos` varchar(64) DEFAULT NULL,
121 `owned` tinyint(1) DEFAULT '0',
122 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
123 PRIMARY KEY (`id`,`pid`)
124) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;
125
126-- --------------------------------------------------------
127
128--
129-- Table structure for table `gangs`
130-- Needed for extDB latest update on git
131--
132
133CREATE TABLE IF NOT EXISTS `gangs` (
134 `id` int(11) NOT NULL AUTO_INCREMENT,
135 `owner` varchar(32) DEFAULT NULL,
136 `name` varchar(32) DEFAULT NULL,
137 `members` text,
138 `maxmembers` int(3) DEFAULT '8',
139 `bank` int(100) DEFAULT '0',
140 `active` tinyint(1) DEFAULT '1',
141 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
142 PRIMARY KEY (`id`),
143 UNIQUE KEY `name_UNIQUE` (`name`)
144) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
145
146-- --------------------------------------------------------
147
148--
149-- Table structure for table `containers`
150-- Needed for extDB latest update on git
151--
152
153CREATE TABLE IF NOT EXISTS `containers` (
154 `id` int(11) NOT NULL AUTO_INCREMENT,
155 `pid` varchar(32) NOT NULL,
156 `classname` varchar(32) NOT NULL,
157 `pos` varchar(64) DEFAULT NULL,
158 `inventory` text NOT NULL,
159 `gear` text NOT NULL,
160 `dir` varchar(128) DEFAULT NULL,
161 `active` tinyint(1) NOT NULL DEFAULT '0',
162 `owned` tinyint(1) DEFAULT '0',
163 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
164 PRIMARY KEY (`id`,`pid`)
165) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4;
166
167-- --------------------------------------------------------
168
169--
170-- Table structure for table `wanted`
171-- Needed for extDB latest update on git
172--
173
174CREATE TABLE IF NOT EXISTS `wanted` (
175 `wantedID` varchar(64) NOT NULL,
176 `wantedName` varchar(32) NOT NULL,
177 `wantedCrimes` text NOT NULL,
178 `wantedBounty` int(100) NOT NULL,
179 `active` tinyint(1) NOT NULL DEFAULT '0',
180 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
181 PRIMARY KEY (`wantedID`)
182) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
183
184-- --------------------------------------------------------
185
186/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
187/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
188/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;