EMTYUTGv

1SET FOREIGN_KEY_CHECKS=0;
2
3DROP TABLE IF EXISTS `auction`;
4CREATE TABLE `auction` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `type` int(5) NOT NULL DEFAULT '0',
7  `amount` int(5) NOT NULL DEFAULT '0',
8  `item` text NOT NULL,
9  `price` int(100) NOT NULL DEFAULT '0',
10  `seller` varchar(50) NOT NULL,
11  `sellername` varchar(32) NOT NULL,
12  `status` int(5) NOT NULL DEFAULT '0',
13  `time` int(11) NOT NULL DEFAULT '0',
14  PRIMARY KEY (`id`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16
17DROP TABLE IF EXISTS `cellphone`;
18CREATE TABLE `cellphone` (
19  `pid` varchar(64) NOT NULL,
20  `playerName` varchar(32) NOT NULL,
21  `messages` text NOT NULL,
22  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
23  PRIMARY KEY (`pid`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26DROP TABLE IF EXISTS `containers`;
27CREATE TABLE `containers` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `pid` varchar(32) NOT NULL,
30  `classname` varchar(32) NOT NULL,
31  `pos` varchar(64) DEFAULT NULL,
32  `inventory` varchar(500) NOT NULL,
33  `gear` text NOT NULL,
34  `dir` varchar(64) DEFAULT NULL,
35  `active` tinyint(1) NOT NULL DEFAULT '0',
36  `owned` tinyint(4) DEFAULT '0',
37  PRIMARY KEY (`id`,`pid`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39
40DROP TABLE IF EXISTS `gangs`;
41CREATE TABLE `gangs` (
42  `id` int(11) NOT NULL AUTO_INCREMENT,
43  `owner` varchar(32) DEFAULT NULL,
44  `name` varchar(32) DEFAULT NULL,
45  `members` text,
46  `maxmembers` int(2) DEFAULT '8',
47  `bank` int(100) DEFAULT '0',
48  `active` tinyint(4) DEFAULT '1',
49  PRIMARY KEY (`id`),
50  UNIQUE KEY `name_UNIQUE` (`name`)
51) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
52
53DROP TABLE IF EXISTS `houses`;
54CREATE TABLE `houses` (
55  `id` int(11) NOT NULL AUTO_INCREMENT,
56  `pid` varchar(32) NOT NULL,
57  `pos` varchar(64) DEFAULT NULL,
58  `owned` tinyint(4) DEFAULT '0',
59  PRIMARY KEY (`id`,`pid`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61
62DROP TABLE IF EXISTS `players`;
63CREATE TABLE `players` (
64  `uid` int(12) NOT NULL AUTO_INCREMENT,
65  `name` varchar(32) NOT NULL,
66  `playerid` varchar(50) NOT NULL,
67  `cash` int(100) NOT NULL DEFAULT '0',
68  `bankacc` int(100) NOT NULL DEFAULT '0',
69  `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') NOT NULL DEFAULT '0',
70  `cop_licenses` text,
71  `civ_licenses` text,
72  `med_licenses` text,
73  `cop_gear` text NOT NULL,
74  `med_gear` text NOT NULL,
75  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
76  `arrested` tinyint(1) NOT NULL DEFAULT '0',
77  `aliases` text NOT NULL,
78  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
79  `donator` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
80  `civ_gear` text NOT NULL,
81  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
82  `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
83  `playtime` int(11) NOT NULL DEFAULT '0',
84  `level` int(100) NOT NULL DEFAULT '1',
85  `experience` int(100) NOT NULL DEFAULT '0',
86  `duredon` int(1) NOT NULL DEFAULT '0',
87  `timestamp` int(11) DEFAULT NULL,
88  PRIMARY KEY (`uid`,`last_login`),
89  UNIQUE KEY `playerid` (`playerid`),
90  KEY `name` (`name`),
91  KEY `blacklist` (`blacklist`)
92) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;
93
94DROP TABLE IF EXISTS `vehicles`;
95CREATE TABLE `vehicles` (
96  `id` int(12) NOT NULL AUTO_INCREMENT,
97  `side` varchar(15) NOT NULL,
98  `classname` varchar(32) NOT NULL,
99  `type` varchar(12) NOT NULL,
100  `pid` varchar(32) NOT NULL,
101  `alive` tinyint(1) NOT NULL DEFAULT '1',
102  `active` tinyint(1) NOT NULL DEFAULT '0',
103  `plate` int(20) NOT NULL,
104  `color` int(20) NOT NULL,
105  `inventory` text NOT NULL,
106  `gear` text NOT NULL,
107  `fuel` varchar(16) NOT NULL DEFAULT '1',
108  `damages` text NOT NULL,
109  PRIMARY KEY (`id`),
110  KEY `side` (`side`),
111  KEY `pid` (`pid`),
112  KEY `type` (`type`)
113) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=latin1;
114
115DROP TABLE IF EXISTS `wanted`;
116CREATE TABLE `wanted` (
117  `wantedID` varchar(50) NOT NULL,
118  `wantedName` varchar(52) NOT NULL,
119  `wantedCrimes` text NOT NULL,
120  `wantedBounty` int(100) NOT NULL,
121  `active` tinyint(1) NOT NULL DEFAULT '0',
122  PRIMARY KEY (`wantedID`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;
126DELIMITER ;;
127CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
128BEGIN
129        DELETE FROM `vehicles` WHERE `alive` = 0;
130END
131;;
132DELIMITER ;
133
134DROP PROCEDURE IF EXISTS `deleteOldContainers`;
135DELIMITER ;;
136CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
137BEGIN
138  DELETE FROM `containers` WHERE `owned` = 0;
139END
140;;
141DELIMITER ;
142
143DROP PROCEDURE IF EXISTS `deleteOldGangs`;
144DELIMITER ;;
145CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
146BEGIN
147  DELETE FROM `gangs` WHERE `active` = 0;
148END
149;;
150DELIMITER ;
151
152DROP PROCEDURE IF EXISTS `deleteOldHouses`;
153DELIMITER ;;
154CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
155BEGIN
156  DELETE FROM `houses` WHERE `owned` = 0;
157END
158;;
159DELIMITER ;
160
161DROP PROCEDURE IF EXISTS `deleteOldMessages`;
162DELIMITER ;;
163CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldMessages`()
164BEGIN
165	TRUNCATE TABLE `cellphone`;
166END
167;;
168DELIMITER ;
169
170DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
171DELIMITER ;;
172CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
173BEGIN
174        UPDATE `vehicles` SET `active`= 0;
175END
176;;
177DELIMITER ;
178
179DROP EVENT IF EXISTS `4WeeksPlayerDelete`;
180DELIMITER ;;
181CREATE DEFINER=`root`@`localhost` EVENT `4WeeksPlayerDelete` ON SCHEDULE EVERY 1 DAY STARTS '2000-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM players where last_login < DATE_SUB( CURRENT_TIME(), INTERVAL 4 Week)
182;;
183DELIMITER ;