Z0ujvSsg

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/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8mb4 */;
12
13--
14-- Database: `daf_rpcoop`
15-- Default Schema
16--
17CREATE DATABASE IF NOT EXISTS `da3f_ops` DEFAULT CHARACTER SET utf8mb4;
18USE `da3f_ops`;
19
20--
21-- Drop procedures to ensure no conflicts
22--
23-- DROP PROCEDURE IF EXISTS `resetBTSD_Vehicles`;
24DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
25DROP PROCEDURE IF EXISTS `VictoryDropInfo`;
26-- DROP PROCEDURE IF EXISTS `deleteOldContainers`;
27
28DELIMITER $$
29--
30-- Procedures
31-- Edit arma3 to match a user in MySQL
32-- For external databases: Edit localhost to match arma3server IP
33--
34
35
36CREATE DEFINER=`missionmcf`@`localhost` PROCEDURE `OpsReset_Party`()
37BEGIN
38  UPDATE `players` SET `save_pos`= '"[]"', `inv_unit`= '"[]"', `side`= 'civ', `active`= 0;
39  UPDATE `map_infos` SET `active`= 0;
40  UPDATE `vehicles` SET `active`= 0;
41END$$
42
43CREATE DEFINER=`missionmcf`@`localhost` PROCEDURE `deleteDeadVehicles`()
44BEGIN
45  DELETE FROM `vehicles` WHERE `alive` = 0;
46END$$
47
48CREATE DEFINER=`missionmcf`@`localhost` PROCEDURE `VictoryDropInfo`()
49BEGIN
50  DELETE FROM `map_infos` WHERE `active` = 0;
51  DELETE FROM `vehicles` WHERE `active` = 0;
52END$$
53
54CREATE DEFINER=`missionmcf`@`localhost` PROCEDURE `ClearMyContacts`()
55BEGIN
56  DELETE FROM `contacts` WHERE `deleted` = 1;
57  DELETE FROM `messages` WHERE `deleted` = 1;
58END$$
59
60-- CREATE DEFINER=`missionmcf`@`localhost` PROCEDURE `deleteOldContainers`()
61-- BEGIN
62--   DELETE FROM `containers` WHERE `owned` = 0;
63-- END$$
64
65DELIMITER ;
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `players`
71--
72
73CREATE TABLE IF NOT EXISTS `players` (
74  `id` int(6) NOT NULL AUTO_INCREMENT,
75  `name` varchar(32) NOT NULL,
76  `aliases` text NOT NULL,
77  `uid` varchar(17) NOT NULL,
78  `side` varchar(16) NOT NULL,
79  `cash_army` int(100) NOT NULL DEFAULT '0',
80  `bank_army` int(100) NOT NULL DEFAULT '0',
81  `cash_allied` int(100) NOT NULL DEFAULT '0',
82  `bank_allied` int(100) NOT NULL DEFAULT '0',
83  `cash_guer` int(100) NOT NULL DEFAULT '0',
84  `bank_guer` int(100) NOT NULL DEFAULT '0',
85  `inv_virt_army` text NOT NULL,
86  `inv_unit_army` text NOT NULL,
87  `inv_virt_allied` text NOT NULL,
88  `inv_unit_allied` text NOT NULL,
89  `inv_virt_guer` text NOT NULL,
90  `inv_unit_guer` text NOT NULL,
91  `stats_army` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
92  `exp_army` varchar(32) NOT NULL DEFAULT '"[0,150,0,0]"',
93  `stats_allied` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
94  `exp_allied` varchar(32) NOT NULL DEFAULT '"[0,150,0,0]"',
95  `stats_guer` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
96  `exp_guer` varchar(32) NOT NULL DEFAULT '"[0,150,0,0]"',
97  `save_pos_army` varchar(64) NOT NULL DEFAULT '"[]"',
98  `save_pos_allied` varchar(64) NOT NULL DEFAULT '"[]"',
99  `save_pos_guer` varchar(64) NOT NULL DEFAULT '"[]"',
100  `grade_army` enum('0','1','2','3','4','5','6','7','8','9','10','11') NOT NULL DEFAULT '0',
101  `grade_allied` enum('0','1','2','3','4','5','6','7','8','9','10','11') NOT NULL DEFAULT '0',
102  `grade_guer` enum('0','1','2','3','4','5','6','7','8','9','10','11') NOT NULL DEFAULT '0',
103  `spec_army` text NOT NULL,
104  `spec_allied` text NOT NULL,
105  `spec_guer` text NOT NULL,
106  `adn_army` varchar(12) NOT NULL DEFAULT '"ADN_00"', 
107  `adn_allied` varchar(12) NOT NULL DEFAULT '"ADN_00"', 
108  `adn_guer` varchar(12) NOT NULL DEFAULT '"ADN_00"',
109  `grp_sang_army` varchar(12) NOT NULL DEFAULT '"Grp_S"', 
110  `grp_sang_allied` varchar(12) NOT NULL DEFAULT '"Grp_S"', 
111  `grp_sang_guer` varchar(12) NOT NULL DEFAULT '"Grp_S"',
112  `number_army` varchar(12) NOT NULL DEFAULT '"0700000000"', 
113  `number_allied` varchar(12) NOT NULL DEFAULT '"0700000000"', 
114  `number_guer` varchar(12) NOT NULL DEFAULT '"0700000000"',
115  `banned` tinyint(1) NOT NULL DEFAULT '0',
116  `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
117  `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
118  PRIMARY KEY (`id`),
119  UNIQUE KEY `uid` (`uid`),
120  KEY `name` (`name`),
121  KEY `banned` (`banned`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1;
123
124-- --------------------------------------------------------
125
126CREATE TABLE IF NOT EXISTS `vehicles` (
127  `id` int(6) NOT NULL AUTO_INCREMENT,
128  `uid` varchar(17) NOT NULL,
129  `name` varchar(64) NOT NULL,
130  `last_driver` varchar(64) NOT NULL DEFAULT '""',
131  `plak` varchar(20) NOT NULL,
132  `side` varchar(16) NOT NULL,
133  `sell` varchar(20) NOT NULL,
134  `classname` varchar(64) NOT NULL,
135  `type` varchar(16) NOT NULL,
136  `alive` tinyint(1) NOT NULL DEFAULT '1',
137  `active` tinyint(1) NOT NULL DEFAULT '0',
138  `color` int(20) NOT NULL,
139  `inventory` text NOT NULL,
140  `pos` varchar(64) NOT NULL DEFAULT '"[]"',
141  `dir` int(10) NOT NULL,
142  `gear` text NOT NULL,
143  `fuel` double NOT NULL DEFAULT '1',
144  `damage` varchar(256) NOT NULL,
145  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
146  PRIMARY KEY (`id`),
147  KEY `sell` (`sell`),
148  KEY `uid` (`uid`),
149  KEY `type` (`type`)
150) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;
151
152-- --------------------------------------------------------
153
154CREATE TABLE IF NOT EXISTS `business` (
155  `id` int(6) NOT NULL AUTO_INCREMENT,
156  `uid_Chef` varchar(17) NOT NULL,
157  `name_business` varchar(64) NOT NULL,
158  `units_grp` text NOT NULL,
159  `garage` varchar(64) NOT NULL,
160  `deleted` tinyint(1) NOT NULL DEFAULT '0',
161  `active` tinyint(1) NOT NULL DEFAULT '0',
162  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
163  PRIMARY KEY (`id`)
164) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;
165
166-- --------------------------------------------------------
167
168CREATE TABLE IF NOT EXISTS `contacts` (
169  `id` int(6) NOT NULL AUTO_INCREMENT,
170  `uid` varchar(17) NOT NULL,
171  `name_army` varchar(64) NOT NULL,
172  `name_allied` varchar(64) NOT NULL,
173  `name_guer` varchar(64) NOT NULL,
174  `number` varchar(10) NOT NULL, 
175  `contacts_army` text NOT NULL,
176  `contacts_allied` text NOT NULL,
177  `contacts_guer` text NOT NULL,
178  `deleted` tinyint(1) NOT NULL DEFAULT '0',
179  `active` tinyint(1) NOT NULL DEFAULT '0',
180  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
181  PRIMARY KEY (`id`)
182) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;
183
184-- --------------------------------------------------------
185
186CREATE TABLE IF NOT EXISTS `messages` (
187  `id` int(6) NOT NULL AUTO_INCREMENT,
188  `uid` varchar(17) NOT NULL,
189  `name_army` varchar(64) NOT NULL,
190  `name_allied` varchar(64) NOT NULL,
191  `name_guer` varchar(64) NOT NULL,
192  `number` varchar(12) NOT NULL, 
193  `envoi_army` text NOT NULL,
194  `envoi_allied` text NOT NULL,
195  `envoi_guer` text NOT NULL,
196  `reception_army` text NOT NULL,
197  `reception_guer` text NOT NULL,
198  `deleted` tinyint(1) NOT NULL DEFAULT '0',
199  `active` tinyint(1) NOT NULL DEFAULT '0',
200  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
201  PRIMARY KEY (`id`)
202) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;
203
204-- --------------------------------------------------------
205
206CREATE TABLE IF NOT EXISTS `box_map` (
207  `id` int(6) NOT NULL AUTO_INCREMENT,
208  `uid` varchar(17) NOT NULL,
209  `side` varchar(16) NOT NULL,
210  `classname` varchar(32) NOT NULL,
211  `inventory_army` text NOT NULL,
212  `gear_army` text NOT NULL,
213  `pos_army` varchar(64) NOT NULL DEFAULT '"[]"',
214  `dir_army` varchar(128) DEFAULT NULL,
215  `inventory_allied` text NOT NULL,
216  `gear_allied` text NOT NULL,
217  `pos_allied` varchar(64) NOT NULL DEFAULT '"[]"',
218  `dir_allied` varchar(128) DEFAULT NULL,
219  `inventory_guer` text NOT NULL,
220  `gear_guer` text NOT NULL,
221  `pos_guer` varchar(64) NOT NULL DEFAULT '"[]"',
222  `dir_guer` varchar(128) DEFAULT NULL,
223  `active` tinyint(1) NOT NULL DEFAULT '0',
224  `owned` tinyint(1) DEFAULT '0',
225  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
226  PRIMARY KEY (`id`,`uid`)
227) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4;
228
229-- --------------------------------------------------------
230
231CREATE TABLE IF NOT EXISTS `virtual_box` (
232  `id` int(6) NOT NULL AUTO_INCREMENT,
233  `uid` varchar(17) NOT NULL,
234  `side` varchar(16) NOT NULL,
235  `nbr_box_army` varchar(4) NOT NULL DEFAULT '0',
236  `nbr_box_allied` varchar(4) NOT NULL DEFAULT '0',
237  `nbr_box_guer` varchar(4) NOT NULL DEFAULT '0',
238  `classname` varchar(32) NOT NULL,
239  `inventory_army` text NOT NULL,
240  `inventory_allied` text NOT NULL,
241  `inventory_guer` text NOT NULL,
242  `gear_army` text NOT NULL,
243  `gear_allied` text NOT NULL,
244  `gear_guer` text NOT NULL,
245  `active` tinyint(1) NOT NULL DEFAULT '0',
246  `owned` tinyint(1) DEFAULT '0',
247  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
248  PRIMARY KEY (`id`,`uid`)
249) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4;
250
251-- --------------------------------------------------------
252
253CREATE TABLE IF NOT EXISTS `map_infos` (
254  `id` int(6) NOT NULL AUTO_INCREMENT,
255  `worldName` varchar(128) DEFAULT NULL,
256  `flags` text NOT NULL,
257  `ressources` text NOT NULL,
258  `pos_qg` text NOT NULL,
259  `active` tinyint(1) NOT NULL DEFAULT '0',
260  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
261  PRIMARY KEY (`id`)
262) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;
263
264-- --------------------------------------------------------
265
266CREATE TABLE IF NOT EXISTS `map_build` (
267  `id` int(6) NOT NULL AUTO_INCREMENT,
268  `worldName` varchar(128) DEFAULT NULL,
269  `build_army` text NOT NULL,
270  `build_guerr` text NOT NULL,
271  `active` tinyint(1) NOT NULL DEFAULT '0',
272  PRIMARY KEY (`id`)
273) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;
274
275-- --------------------------------------------------------
276/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
277/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
278/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;