· 9 years ago · Dec 22, 2016, 09:06 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: `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 MySQ
21-- For external databases: Edit localhost to match arma3server IP
22--
23CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
24BEGIN
25 UPDATE `vehicles` SET `active`= 0;
26END$$
27
28CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
29BEGIN
30 DELETE FROM `vehicles` WHERE `alive` = 0;
31END$$
32
33CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
34BEGIN
35 DELETE FROM `houses` WHERE `owned` = 0;
36END$$
37
38CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
39BEGIN
40 DELETE FROM `gangs` WHERE `active` = 0;
41END$$
42
43CREATE DEFINER=`root`@`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(11) NOT NULL DEFAULT '"[100,100]"',
72 `cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
73 `med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
74 `arrested` tinyint(1) NOT NULL DEFAULT '0',
75 `jail_time` int(11) NOT NULL DEFAULT '0',
76 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
77 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
78 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
79 PRIMARY KEY (`uid`),
80 UNIQUE KEY `playerid` (`playerid`),
81 KEY `name` (`name`),
82 KEY `blacklist` (`blacklist`)
83) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
84
85-- --------------------------------------------------------
86
87--
88-- Table structure for table `vehicles`
89--
90
91CREATE TABLE IF NOT EXISTS `vehicles` (
92 `id` int(12) NOT NULL AUTO_INCREMENT,
93 `side` varchar(15) NOT NULL,
94 `classname` varchar(32) NOT NULL,
95 `type` varchar(12) NOT NULL,
96 `pid` varchar(32) NOT NULL,
97 `alive` tinyint(1) NOT NULL DEFAULT '1',
98 `active` tinyint(1) NOT NULL DEFAULT '0',
99 `plate` int(20) NOT NULL,
100 `color` int(20) NOT NULL,
101 `inventory` varchar(500) NOT NULL,
102 `gear` text NOT NULL,
103 `fuel` double NOT NULL DEFAULT '1',
104 PRIMARY KEY (`id`),
105 KEY `side` (`side`),
106 KEY `pid` (`pid`),
107 KEY `type` (`type`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `cellphone`
114-- Only run this if you already have a database made on your server.
115-- Made by GetSomePanda / Panda
116--
117
118CREATE TABLE IF NOT EXISTS `cellphone` (
119 `pid` varchar(64) NOT NULL,
120 `playerName` varchar(32) NOT NULL,
121 `messages` text NOT NULL,
122 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
123 PRIMARY KEY (`pid`)
124) ENGINE=InnoDB DEFAULT CHARSET=utf8;
125
126-- --------------------------------------------------------
127
128
129--
130-- Table structure for table `houses`
131-- Needed for extDB latest update on git
132--
133
134CREATE TABLE IF NOT EXISTS `houses` (
135 `id` int(11) NOT NULL AUTO_INCREMENT,
136 `pid` varchar(32) NOT NULL,
137 `pos` varchar(64) DEFAULT NULL,
138 `owned` tinyint(4) DEFAULT '0',
139 PRIMARY KEY (`id`,`pid`)
140) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
141
142-- --------------------------------------------------------
143
144--
145-- Table structure for table `gangs`
146-- Needed for extDB latest update on git
147--
148
149CREATE TABLE IF NOT EXISTS `gangs` (
150 `id` int(11) NOT NULL AUTO_INCREMENT,
151 `owner` varchar(32) DEFAULT NULL,
152 `name` varchar(32) DEFAULT NULL,
153 `members` text,
154 `maxmembers` int(2) DEFAULT '8',
155 `bank` int(100) DEFAULT '0',
156 `active` tinyint(4) DEFAULT '1',
157 PRIMARY KEY (`id`),
158 UNIQUE KEY `name_UNIQUE` (`name`)
159) ENGINE=InnoDB DEFAULT CHARSET=latin1;
160
161-- --------------------------------------------------------
162
163--
164-- Table structure for table `containers`
165-- Needed for extDB latest update on git
166--
167
168CREATE TABLE IF NOT EXISTS `containers` (
169 `id` int(11) NOT NULL AUTO_INCREMENT,
170 `pid` varchar(32) NOT NULL,
171 `classname` varchar(32) NOT NULL,
172 `pos` varchar(64) DEFAULT NULL,
173 `inventory` varchar(500) NOT NULL,
174 `gear` text NOT NULL,
175 `dir` varchar(64) DEFAULT NULL,
176 `active` tinyint(1) NOT NULL DEFAULT '0',
177 `owned` tinyint(4) DEFAULT '0',
178 PRIMARY KEY (`id`,`pid`)
179) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
180
181-- --------------------------------------------------------
182
183--
184-- Table structure for table `wanted`
185-- Needed for extDB latest update on git
186--
187
188CREATE TABLE `wanted` (
189 `wantedID` varchar(50) NOT NULL,
190 `wantedName` varchar(52) NOT NULL,
191 `wantedCrimes` text NOT NULL,
192 `wantedBounty` int(100) NOT NULL,
193 `active` tinyint(1) NOT NULL DEFAULT '0',
194 PRIMARY KEY (`wantedID`)
195) ENGINE=InnoDB DEFAULT CHARSET=latin1;
196
197-- --------------------------------------------------------
198
199/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
200/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
201/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;