· 9 years ago · Oct 02, 2016, 06:46 PM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3--
4-- Compatible with newer MySQL versions. (After MySQL-5.5)
5-- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.
6--
7
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8mb4 */;
13
14--
15-- Database: `altislife`
16-- Default Schema
17--
18CREATE DATABASE IF NOT EXISTS `altislife` DEFAULT CHARACTER SET utf8mb4;
19USE `altislife`;
20
21--
22-- Drop procedures to ensure no conflicts
23--
24DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
25DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
26DROP PROCEDURE IF EXISTS `deleteOldHouses`;
27DROP PROCEDURE IF EXISTS `deleteOldGangs`;
28DROP PROCEDURE IF EXISTS `deleteOldContainers`;
29
30DELIMITER $$
31--
32-- Procedures
33-- Edit arma3 to match a user in MySQL
34-- For external databases: Edit localhost to match arma3server IP
35--
36
37CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
38BEGIN
39
40 DELETE FROM `vehicles` WHERE `alive` = 0;
41
42END$$
43
44CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
45BEGIN
46
47 DELETE FROM `gangs` WHERE `active` = 0;
48
49END$$
50
51CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
52BEGIN
53
54 DELETE FROM `houses` WHERE `owned` = 0;
55
56END$$
57
58CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
59BEGIN
60
61 UPDATE vehicles SET `active`= 0;
62
63END$$
64
65DELIMITER ;
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `gangs`
71--
72
73CREATE TABLE IF NOT EXISTS `gangs` (
74`id` int(11) NOT NULL,
75 `owner` varchar(32) DEFAULT NULL,
76 `name` varchar(32) DEFAULT NULL,
77 `members` text,
78 `maxmembers` int(2) DEFAULT '8',
79 `bank` int(100) DEFAULT '0',
80 `active` tinyint(4) DEFAULT '1'
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `houses`
87--
88
89CREATE TABLE IF NOT EXISTS `houses` (
90`id` int(11) NOT NULL,
91 `pid` varchar(32) NOT NULL,
92 `pos` varchar(64) DEFAULT NULL,
93 `inventory` text,
94 `containers` text,
95 `owned` tinyint(4) DEFAULT '0',
96 `security` text NOT NULL
97) ENGINE=InnoDB DEFAULT CHARSET=latin1;
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `players`
103--
104
105CREATE TABLE IF NOT EXISTS `players` (
106`uid` int(12) NOT NULL,
107 `name` varchar(32) NOT NULL,
108 `playerid` varchar(50) NOT NULL,
109 `cash` int(100) NOT NULL DEFAULT '0',
110 `bankacc` int(100) NOT NULL DEFAULT '0',
111 `coplevel` enum('0','1','2','3','4','5','6','7','8') NOT NULL DEFAULT '0',
112 `cop_licenses` text,
113 `civ_licenses` text,
114 `med_licenses` text,
115 `cop_gear` text NOT NULL,
116 `med_gear` text NOT NULL,
117 `mediclevel` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
118 `arrested` tinyint(1) NOT NULL DEFAULT '0',
119 `aliases` text NOT NULL,
120 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
121 `donatorlvl` enum('0','1') NOT NULL DEFAULT '0',
122 `civ_gear` text NOT NULL,
123 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
124 `ASF_licenses` text NOT NULL,
125 `ASF_gear` text NOT NULL,
126 `ASFlevel` enum('0','1','2','3','4','5','6') NOT NULL,
127 `bounties` text,
128 `jail_time` int(11) NOT NULL DEFAULT '0'
129) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;
130
131--
132-- Dumping data for table `players`
133--
134
135-- --------------------------------------------------------
136
137--
138-- Table structure for table `vehicles`
139--
140
141CREATE TABLE IF NOT EXISTS `vehicles` (
142`id` int(12) NOT NULL,
143 `side` varchar(15) NOT NULL,
144 `classname` varchar(32) NOT NULL,
145 `type` varchar(12) NOT NULL,
146 `pid` varchar(32) NOT NULL,
147 `alive` tinyint(1) NOT NULL DEFAULT '1',
148 `active` tinyint(1) NOT NULL DEFAULT '0',
149 `plate` int(20) NOT NULL,
150 `color` int(20) NOT NULL,
151 `inventory` varchar(500) NOT NULL
152) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
153
154--
155-- Dumping data for table `vehicles`
156--
157
158--
159-- Indexes for dumped tables
160--
161
162
163--
164-- Indexes for table `gangs`
165--
166ALTER TABLE `gangs`
167 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name_UNIQUE` (`name`);
168
169--
170-- Indexes for table `houses`
171--
172ALTER TABLE `houses`
173 ADD PRIMARY KEY (`id`,`pid`);
174
175--
176-- Indexes for table `players`
177--
178ALTER TABLE `players`
179 ADD PRIMARY KEY (`uid`), ADD UNIQUE KEY `playerid` (`playerid`), ADD KEY `name` (`name`), ADD KEY `blacklist` (`blacklist`);
180
181--
182-- Indexes for table `vehicles`
183--
184ALTER TABLE `vehicles`
185 ADD PRIMARY KEY (`id`), ADD KEY `side` (`side`), ADD KEY `pid` (`pid`), ADD KEY `type` (`type`);
186
187--
188-- AUTO_INCREMENT for dumped tables
189--
190
191--
192-- AUTO_INCREMENT for table `gangs`
193--
194ALTER TABLE `gangs`
195MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
196--
197-- AUTO_INCREMENT for table `houses`
198--
199ALTER TABLE `houses`
200MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
201--
202-- AUTO_INCREMENT for table `players`
203--
204ALTER TABLE `players`
205MODIFY `uid` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=41;
206--
207-- AUTO_INCREMENT for table `vehicles`
208--
209ALTER TABLE `vehicles`
210MODIFY `id` int(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=34;
211/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
212/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
213/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;