· 8 years ago · Jul 03, 2018, 04:54 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: `SunnyBeach`
12-- Default Schema
13--
14
15
16DELIMITER $$
17--
18-- Procedures
19-- Edit arma3 to match a user in MySQ
20-- For external databases: Edit localhost to match arma3server IP
21--
22CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
23BEGIN
24 UPDATE `vehicles` SET `active`= 0;
25END$$
26
27CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteDeadVehicles`()
28BEGIN
29 DELETE FROM `vehicles` WHERE `alive` = 0;
30END$$
31
32CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldHouses`()
33BEGIN
34 DELETE FROM `houses` WHERE `owned` = 0;
35END$$
36
37CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldGangs`()
38BEGIN
39 DELETE FROM `gangs` WHERE `active` = 0;
40END$$
41
42CREATE DEFINER=`arma3`@`localhost` PROCEDURE `deleteOldContainers`()
43BEGIN
44 DELETE FROM `containers` WHERE `owned` = 0;
45END$$
46
47DELIMITER ;
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `players`
53--
54
55CREATE TABLE IF NOT EXISTS `players` (
56 `uid` int(12) NOT NULL AUTO_INCREMENT,
57 `name` varchar(32) NOT NULL,
58 `aliases` text NOT NULL,
59 `playerid` varchar(50) NOT NULL,
60 `cash` int(100) NOT NULL DEFAULT '0',
61 `bankacc` int(100) NOT NULL DEFAULT '0',
62 `civ_licenses` text NOT NULL,
63 `bluefor_licenses` text NOT NULL,
64 `opfor_licenses` text NOT NULL,
65 `insur_licenses` text NOT NULL,
66 `civ_gear` text NOT NULL,
67 `bluefor_gear` text NOT NULL,
68 `opfor_gear` text NOT NULL,
69 `insur_gear` text NOT NULL,
70 `civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
71 `bluefor_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
72 `opfor_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
73 `insur_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
74 `arrested` tinyint(1) NOT NULL DEFAULT '0',
75 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
76 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
77 PRIMARY KEY (`uid`),
78 UNIQUE KEY `playerid` (`playerid`),
79 KEY `name` (`name`),
80 KEY `blacklist` (`blacklist`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
82
83-- --------------------------------------------------------
84
85--
86-- Table structure for table `vehicles`
87--
88
89CREATE TABLE IF NOT EXISTS `vehicles` (
90 `id` int(12) NOT NULL AUTO_INCREMENT,
91 `side` varchar(15) NOT NULL,
92 `classname` varchar(32) NOT NULL,
93 `type` varchar(12) NOT NULL,
94 `pid` varchar(32) NOT NULL,
95 `alive` tinyint(1) NOT NULL DEFAULT '1',
96 `active` tinyint(1) NOT NULL DEFAULT '0',
97 `plate` int(20) NOT NULL,
98 `color` int(20) NOT NULL,
99 `inventory` varchar(500) NOT NULL,
100 `gear` text NOT NULL,
101 `fuel` double NOT NULL DEFAULT '1',
102 PRIMARY KEY (`id`),
103 KEY `side` (`side`),
104 KEY `pid` (`pid`),
105 KEY `type` (`type`)
106) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
107
108
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `gangs`
114-- Needed for extDB latest update on git
115--
116
117CREATE TABLE IF NOT EXISTS `gangs` (
118 `id` int(11) NOT NULL AUTO_INCREMENT,
119 `owner` varchar(32) DEFAULT NULL,
120 `name` varchar(32) DEFAULT NULL,
121 `members` text,
122 `maxmembers` int(2) DEFAULT '8',
123 `bank` int(100) DEFAULT '0',
124 `active` tinyint(4) DEFAULT '1',
125 PRIMARY KEY (`id`),
126 UNIQUE KEY `name_UNIQUE` (`name`)
127) ENGINE=InnoDB DEFAULT CHARSET=latin1;
128
129-- --------------------------------------------------------
130
131--
132-- Table structure for table `wanted`
133-- Needed for extDB latest update on git
134--
135
136CREATE TABLE `wanted` (
137 `wantedID` varchar(50) NOT NULL,
138 `wantedName` varchar(52) NOT NULL,
139 `wantedCrimes` text NOT NULL,
140 `wantedBounty` int(100) NOT NULL,
141 `active` tinyint(1) NOT NULL DEFAULT '0',
142 PRIMARY KEY (`wantedID`)
143) ENGINE=InnoDB DEFAULT CHARSET=latin1;
144
145-- --------------------------------------------------------
146
147/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
148/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
149/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;