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