· 8 years ago · Feb 01, 2018, 02:24 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=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
38BEGIN
39 UPDATE vehicles SET `fuel`= 1 WHERE `active`= 1;
40 UPDATE `vehicles` SET `active`= 0;
41END$$
42
43CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
44BEGIN
45 DELETE FROM `vehicles` WHERE `alive` = 0;
46END$$
47
48CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
49BEGIN
50 DELETE FROM `houses` WHERE `owned` = 0;
51END$$
52
53CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
54BEGIN
55 DELETE FROM `gangs` WHERE `active` = 0;
56END$$
57
58CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
59BEGIN
60 DELETE FROM `containers` WHERE `owned` = 0;
61END$$
62
63CREATE TABLE IF NOT EXISTS `players` (
64 `uid` int(12) NOT NULL AUTO_INCREMENT,
65 `name` varchar(32) NOT NULL,
66 `aliases` text NOT NULL,
67 `playerid` varchar(50) NOT NULL,
68 `cash` int(100) NOT NULL DEFAULT '0',
69 `bankacc` int(100) NOT NULL DEFAULT '0',
70 `coplevel` enum('0','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT '0',
71 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
72 `civ_licenses` text NOT NULL,
73 `cop_licenses` text NOT NULL,
74 `med_licenses` text NOT NULL,
75 `civ_gear` text NOT NULL,
76 `cop_gear` text NOT NULL,
77 `med_gear` text NOT NULL,
78 `civ_stats` varchar(21) NOT NULL DEFAULT '"[100,100,0]"',
79 `cop_stats` varchar(21) NOT NULL DEFAULT '"[100,100,0]"',
80 `med_stats` varchar(21) NOT NULL DEFAULT '"[100,100,0]"',
81 `arrested` tinyint(1) NOT NULL DEFAULT '0',
82 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
83 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
84 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
85 `cop_prof` text,
86 `civ_prof` text,
87 `med_prof` text,
88 `playtime` varchar(25) NOT NULL DEFAULT '"[0,0,0]"',
89 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
90 PRIMARY KEY (`uid`),
91 UNIQUE KEY `playerid` (`playerid`),
92 KEY `name` (`name`),
93 KEY `blacklist` (`blacklist`)
94) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
95
96
97CREATE TABLE IF NOT EXISTS `vehicles` (
98 `id` int(12) NOT NULL AUTO_INCREMENT,
99 `side` varchar(15) NOT NULL,
100 `classname` varchar(32) NOT NULL,
101 `type` varchar(12) NOT NULL,
102 `pid` varchar(32) NOT NULL,
103 `alive` tinyint(1) NOT NULL DEFAULT '1',
104 `active` tinyint(1) NOT NULL DEFAULT '0',
105 `plate` int(20) NOT NULL,
106 `color` int(20) NOT NULL,
107 `texture` text NOT NULL,
108 `inventory` varchar(500) NOT NULL,
109 `gear` text NOT NULL,
110 `fuel` varchar(16) NOT NULL DEFAULT '1',
111 `damage` varchar(150) NOT NULL,
112 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
113 `impounded` int(1) NOT NULL,
114 `alarm` int(1) NOT NULL,
115 `nos` int(1) NOT NULL,
116 `trunkmod` int(5) NOT NULL,
117 PRIMARY KEY (`id`),
118 KEY `side` (`side`),
119 KEY `pid` (`pid`),
120 KEY `type` (`type`)
121) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
122
123
124CREATE TABLE IF NOT EXISTS `houses` (
125 `id` int(11) NOT NULL AUTO_INCREMENT,
126 `pid` varchar(32) NOT NULL,
127 `pos` varchar(64) DEFAULT NULL,
128 `inventory` text,
129 `containers` text,
130 `owned` tinyint(4) DEFAULT '0',
131 PRIMARY KEY (`id`,`pid`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
133
134
135CREATE TABLE IF NOT EXISTS `gangs` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `owner` varchar(32) DEFAULT NULL,
138 `name` varchar(32) DEFAULT NULL,
139 `members` text,
140 `maxmembers` int(2) DEFAULT '8',
141 `bank` int(100) DEFAULT '0',
142 `active` tinyint(4) DEFAULT '1',
143 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
144 `xp` text,
145 `wins` int(5) DEFAULT '0',
146 `sheds` text,
147 `shedsactive` tinyint(4) DEFAULT '0',
148 PRIMARY KEY (`id`),
149 UNIQUE KEY `name_UNIQUE` (`name`)
150) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
151
152CREATE TABLE IF NOT EXISTS `cops` (
153 `id` int(12) NOT NULL AUTO_INCREMENT,
154 `name` varchar(32) NOT NULL,
155 `playerid` varchar(50) NOT NULL,
156 `wings` enum('0','1','2','3') NOT NULL DEFAULT '0',
157 `time` float(7,2) NOT NULL DEFAULT '0.00',
158 `arrests` int(11) NOT NULL DEFAULT '0',
159 `impounds` int(11) NOT NULL DEFAULT '0',
160 PRIMARY KEY (`id`),
161 UNIQUE KEY `playerid` (`playerid`),
162 KEY `name` (`name`)
163) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
164
165CREATE TABLE IF NOT EXISTS `resources` (
166 `resource` varchar(20) NOT NULL,
167 `price` int(5) NOT NULL,
168 `selltimes` int(8) NOT NULL
169) ENGINE=MyISAM DEFAULT CHARSET=latin1;
170
171CREATE TABLE IF NOT EXISTS `tax` (
172 `type` varchar(20) DEFAULT NULL,
173 `amount` int(100) NOT NULL DEFAULT '0'
174) ENGINE=InnoDB DEFAULT CHARSET=latin1;
175
176CREATE TABLE IF NOT EXISTS `stats` (
177 `type` varchar(20) DEFAULT NULL,
178 `status` text
179) ENGINE=InnoDB DEFAULT CHARSET=latin1;
180
181CREATE TABLE IF NOT EXISTS `ah` (
182 `id` int(11) NOT NULL AUTO_INCREMENT,
183 `type` int(5) NOT NULL DEFAULT '0',
184 `amount` int(5) NOT NULL DEFAULT '0',
185 `item` text NOT NULL,
186 `price` int(100) NOT NULL DEFAULT '0',
187 `seller` varchar(50) NOT NULL,
188 `sellername` varchar(32) NOT NULL,
189 `status` int(5) NOT NULL DEFAULT '0',
190 `time` int(11) NOT NULL DEFAULT '0',
191 PRIMARY KEY (`id`)
192) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;