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