· 8 years ago · May 31, 2018, 09:36 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: `arma3life`
12-- Default Schema
13--
14CREATE DATABASE IF NOT EXISTS `arma3life` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
15USE `arma3life`;
16
17DELIMITER $$
18--
19-- Procedures
20-- Edit arma3 and root to match a user in MySQL
21--
22CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
23BEGIN
24 UPDATE `vehicles` SET `active`= 0;
25END$$
26
27CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29 DELETE FROM `vehicles` WHERE `alive` = 0;
30END$$
31
32CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
33BEGIN
34 DELETE FROM `houses` WHERE `owned` = 0;
35END$$
36
37CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
38BEGIN
39 DELETE FROM `gangs` WHERE `active` = 0;
40END$$
41
42DELIMITER ;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `players`
48--
49
50CREATE TABLE IF NOT EXISTS `players` (
51 `uid` int(12) NOT NULL AUTO_INCREMENT,
52 `name` varchar(32) NOT NULL,
53 `playerid` varchar(50) NOT NULL,
54 `cash` int(100) NOT NULL DEFAULT '0',
55 `bankacc` int(100) NOT NULL DEFAULT '0',
56 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
57 `cop_licenses` text,
58 `civ_licenses` text,
59 `med_licenses` text,
60 `cop_gear` text NOT NULL,
61 `med_gear` text NOT NULL,
62 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
63 `arrested` tinyint(1) NOT NULL DEFAULT '0',
64 `aliases` text NOT NULL,
65 `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
66 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
67 `civ_gear` text NOT NULL,
68 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
69 PRIMARY KEY (`uid`),
70 UNIQUE KEY `playerid` (`playerid`),
71 KEY `name` (`name`),
72 KEY `blacklist` (`blacklist`)
73) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
74
75-- --------------------------------------------------------
76
77--
78-- Table structure for table `vehicles`
79--
80
81CREATE TABLE IF NOT EXISTS `vehicles` (
82 `id` int(12) NOT NULL AUTO_INCREMENT,
83 `side` varchar(15) NOT NULL,
84 `classname` varchar(32) NOT NULL,
85 `type` varchar(12) NOT NULL,
86 `pid` varchar(32) NOT NULL,
87 `alive` tinyint(1) NOT NULL DEFAULT '1',
88 `active` tinyint(1) NOT NULL DEFAULT '0',
89 `plate` int(20) NOT NULL,
90 `color` int(20) NOT NULL,
91 `inventory` varchar(500) NOT NULL,
92 PRIMARY KEY (`id`),
93 KEY `side` (`side`),
94 KEY `pid` (`pid`),
95 KEY `type` (`type`)
96) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `houses`
102-- Needed for extDB latest update on git
103--
104
105CREATE TABLE IF NOT EXISTS `houses` (
106 `id` int(11) NOT NULL AUTO_INCREMENT,
107 `pid` varchar(32) NOT NULL,
108 `pos` varchar(64) DEFAULT NULL,
109 `inventory` text,
110 `containers` text,
111 `owned` tinyint(4) DEFAULT '0',
112 PRIMARY KEY (`id`,`pid`)
113) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
114
115-- --------------------------------------------------------
116
117--
118-- Table structure for table `gangs`
119-- Needed for extDB latest update on git
120--
121
122CREATE TABLE IF NOT EXISTS `gangs` (
123 `id` int(11) NOT NULL AUTO_INCREMENT,
124 `owner` varchar(32) DEFAULT NULL,
125 `name` varchar(32) DEFAULT NULL,
126 `members` text,
127 `maxmembers` int(2) DEFAULT '8',
128 `bank` int(100) DEFAULT '0',
129 `active` tinyint(4) DEFAULT '1',
130 PRIMARY KEY (`id`),
131 UNIQUE KEY `name_UNIQUE` (`name`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133
134/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
135/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
136/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;