· 9 years ago · Jan 23, 2017, 04:44 PM
1--
2-- Structure de la table `containers`
3--
4
5--
6-- Drop procedures to ensure no conflicts
7--
8DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
9DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
10DROP PROCEDURE IF EXISTS `deleteOldHouses`;
11DROP PROCEDURE IF EXISTS `deleteOldGangs`;
12DROP PROCEDURE IF EXISTS `deleteOldContainers`;
13
14DELIMITER $$
15--
16-- Procedures
17-- Edit root to match a user in MySQL
18-- For external databases: Edit localhost to match arma3server IP
19--
20
21CREATE DEFINER=`z2abn2xwu1`@`localhost` PROCEDURE `resetLifeVehicles`()
22BEGIN
23 UPDATE `vehicles` SET `active`= 0;
24END$$
25
26CREATE DEFINER=`z2abn2xwu1`@`localhost` PROCEDURE `deleteDeadVehicles`()
27BEGIN
28 DELETE FROM `vehicles` WHERE `alive` = 0;
29END$$
30
31CREATE DEFINER=`z2abn2xwu1`@`localhost` PROCEDURE `deleteOldHouses`()
32BEGIN
33 DELETE FROM `houses` WHERE `owned` = 0;
34END$$
35
36CREATE DEFINER=`z2abn2xwu1`@`localhost` PROCEDURE `deleteOldGangs`()
37BEGIN
38 DELETE FROM `gangs` WHERE `active` = 0;
39END$$
40
41CREATE DEFINER=`z2abn2xwu1`@`localhost` PROCEDURE `deleteOldContainers`()
42BEGIN
43 DELETE FROM `containers` WHERE `owned` = 0;
44END$$
45
46DELIMITER ;
47
48
49CREATE TABLE IF NOT EXISTS `containers` (
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `pid` varchar(32) NOT NULL,
52 `classname` varchar(32) NOT NULL,
53 `pos` varchar(64) DEFAULT NULL,
54 `inventory` varchar(500) NOT NULL,
55 `gear` text NOT NULL,
56 `dir` varchar(64) DEFAULT NULL,
57 `active` tinyint(1) NOT NULL DEFAULT '0',
58 `owned` tinyint(4) DEFAULT '0',
59 PRIMARY KEY (`id`,`pid`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
61
62-- --------------------------------------------------------
63
64--
65-- Structure de la table `gangs`
66--
67
68CREATE TABLE IF NOT EXISTS `gangs` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `owner` varchar(32) DEFAULT NULL,
71 `name` varchar(32) DEFAULT NULL,
72 `members` text,
73 `maxmembers` int(2) DEFAULT '8',
74 `bank` int(100) DEFAULT '0',
75 `active` tinyint(4) DEFAULT '1',
76 PRIMARY KEY (`id`),
77 UNIQUE KEY `name_UNIQUE` (`name`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
79
80-- --------------------------------------------------------
81
82--
83-- Structure de la table `houses`
84--
85
86CREATE TABLE IF NOT EXISTS `houses` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `pid` varchar(32) NOT NULL,
89 `pos` varchar(64) DEFAULT NULL,
90 `owned` tinyint(4) DEFAULT '0',
91 PRIMARY KEY (`id`,`pid`)
92) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
93
94-- --------------------------------------------------------
95
96--
97-- Structure de la table `players`
98--
99
100CREATE TABLE IF NOT EXISTS `players` (
101 `uid` int(12) NOT NULL AUTO_INCREMENT,
102 `name` varchar(32) NOT NULL,
103 `aliases` text NOT NULL,
104 `playerid` varchar(50) NOT NULL,
105 `cash` int(100) NOT NULL DEFAULT '0',
106 `bankacc` int(100) NOT NULL DEFAULT '0',
107 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
108 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
109 `civ_licenses` text NOT NULL,
110 `cop_licenses` text NOT NULL,
111 `med_licenses` text NOT NULL,
112 `civ_gear` text NOT NULL,
113 `cop_gear` text NOT NULL,
114 `med_gear` text NOT NULL,
115 `civ_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
116 `cop_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
117 `med_stats` varchar(11) NOT NULL DEFAULT '"[100,100]"',
118 `arrested` tinyint(1) NOT NULL DEFAULT '0',
119 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
120 `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
121 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
122 PRIMARY KEY (`uid`),
123 UNIQUE KEY `playerid` (`playerid`),
124 KEY `name` (`name`),
125 KEY `blacklist` (`blacklist`)
126) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
127
128-- --------------------------------------------------------
129
130--
131-- Structure de la table `vehicles`
132--
133
134CREATE TABLE IF NOT EXISTS `vehicles` (
135 `id` int(12) NOT NULL AUTO_INCREMENT,
136 `side` varchar(15) NOT NULL,
137 `classname` varchar(32) NOT NULL,
138 `type` varchar(12) NOT NULL,
139 `pid` varchar(32) NOT NULL,
140 `alive` tinyint(1) NOT NULL DEFAULT '1',
141 `active` tinyint(1) NOT NULL DEFAULT '0',
142 `plate` int(20) NOT NULL,
143 `color` int(20) NOT NULL,
144 `inventory` varchar(500) NOT NULL,
145 `gear` text NOT NULL,
146 `fuel` double NOT NULL DEFAULT '1',
147 PRIMARY KEY (`id`),
148 KEY `side` (`side`),
149 KEY `pid` (`pid`),
150 KEY `type` (`type`)
151) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
152
153-- --------------------------------------------------------
154
155--
156-- Structure de la table `wanted`
157--
158
159CREATE TABLE IF NOT EXISTS `wanted` (
160 `wantedID` varchar(50) NOT NULL,
161 `wantedName` varchar(52) NOT NULL,
162 `wantedCrimes` text NOT NULL,
163 `wantedBounty` int(100) NOT NULL,
164 `active` tinyint(1) NOT NULL DEFAULT '0',
165 PRIMARY KEY (`wantedID`)
166) ENGINE=InnoDB DEFAULT CHARSET=latin1;