fHYvwTMK

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: `ni558569_1_DB`
12
13DELIMITER $$
14--
15-- Procedures
16--
17CREATE DEFINER=`ni558569_1_DB`@`localhost` PROCEDURE `resetLifeVehicles`()
18BEGIN
19	UPDATE vehicles SET `active`= 0;
20END$$
21
22CREATE DEFINER=`ni558569_1_DB`@`localhost` PROCEDURE `deleteDeadVehicles`()
23BEGIN
24	DELETE FROM `vehicles` WHERE `alive` = 0;
25END$$
26
27CREATE DEFINER=`ni558569_1_DB`@`localhost` PROCEDURE `deleteOldHouses`()
28BEGIN
29  DELETE FROM `houses` WHERE `owned` = 0;
30END$$
31
32CREATE DEFINER=`ni558569_1_DB`@`localhost` PROCEDURE `deleteOldGangs`()
33BEGIN
34  DELETE FROM `gangs` WHERE `active` = 0;
35END$$
36
37DELIMITER ;
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `players`
43--
44
45CREATE TABLE IF NOT EXISTS `players` (
46  `uid` int(12) NOT NULL AUTO_INCREMENT,
47  `name` varchar(32) NOT NULL,
48  `playerid` varchar(50) NOT NULL,
49  `cash` int(100) NOT NULL DEFAULT '0',
50  `bankacc` int(100) NOT NULL DEFAULT '0',
51  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
52  `cop_licenses` text,
53  `civ_licenses` text,
54  `med_licenses` text,
55  `cop_gear` text NOT NULL,
56  `med_gear` text NOT NULL,
57  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
58  `arrested` tinyint(1) NOT NULL DEFAULT '0',
59  `aliases` text NOT NULL,
60  `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
61  `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
62  `civ_gear` text NOT NULL,
63  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
64  PRIMARY KEY (`uid`),
65  UNIQUE KEY `playerid` (`playerid`),
66  KEY `name` (`name`),
67  KEY `blacklist` (`blacklist`)
68) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
69
70-- --------------------------------------------------------
71
72--
73-- Table structure for table `vehicles`
74--
75
76CREATE TABLE IF NOT EXISTS `vehicles` (
77  `id` int(12) NOT NULL AUTO_INCREMENT,
78  `side` varchar(15) NOT NULL,
79  `classname` varchar(32) NOT NULL,
80  `type` varchar(12) NOT NULL,
81  `pid` varchar(32) NOT NULL,
82  `alive` tinyint(1) NOT NULL DEFAULT '1',
83  `active` tinyint(1) NOT NULL DEFAULT '0',
84  `plate` int(20) NOT NULL,
85  `color` int(20) NOT NULL,
86  `inventory` varchar(500) NOT NULL,
87  PRIMARY KEY (`id`),
88  KEY `side` (`side`),
89  KEY `pid` (`pid`),
90  KEY `type` (`type`)
91) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
92
93-- --------------------------------------------------------
94
95--
96-- Table structure for table `houses`
97-- Needed for extDB latest update on git
98--
99
100CREATE TABLE IF NOT EXISTS `houses` (
101  `id` int(11) NOT NULL AUTO_INCREMENT,
102  `pid` varchar(32) NOT NULL,
103  `pos` varchar(64) DEFAULT NULL,
104  `inventory` text,
105  `containers` text,
106  `owned` tinyint(4) DEFAULT '0',
107  PRIMARY KEY (`id`,`pid`)
108) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
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/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
130/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
131/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;