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