7MvQwqpT

1[SQL] Query CGServerDatabaseModified start
2[ERR] 1304 - PROCEDURE deleteDeadVehicles already exists
3[ERR] -- --------------------------------------------------------
4-- Host:                         127.0.0.1
5-- Server version:               5.6.25 - MySQL Community Server (GPL)
6-- Server OS:                    Win32
7-- HeidiSQL Version:             9.1.0.4867
8-- --------------------------------------------------------
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET NAMES utf8mb4 */;
12/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15-- Dumping database structure for life
16CREATE DATABASE IF NOT EXISTS `life` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `life`;
18
19
20-- Dumping structure for table life.bans
21CREATE TABLE IF NOT EXISTS `bans` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `banuid` varchar(50) NOT NULL DEFAULT '',
24  `adminuid` varchar(50) NOT NULL DEFAULT '',
25  `isperm` int(11) NOT NULL DEFAULT '0',
26  `added` varchar(50) NOT NULL DEFAULT '0',
27  `time` int(11) NOT NULL DEFAULT '0',
28  `reason` varchar(500) NOT NULL DEFAULT '',
29  UNIQUE KEY `id` (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
31BEGIN
32	DELETE FROM `vehicles` WHERE `alive` = 0;
33END;CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
34BEGIN
35  DELETE FROM `houses` WHERE `owned` = 0;
36END;
37
38-- Dumping structure for table life.gangs
39CREATE TABLE IF NOT EXISTS `gangs` (
40  `id` int(11) NOT NULL AUTO_INCREMENT,
41  `owner` varchar(32) DEFAULT NULL,
42  `name` varchar(32) DEFAULT NULL,
43  `members` text,
44  `maxmembers` int(2) DEFAULT '8',
45  `bank` int(100) DEFAULT '0',
46  `active` tinyint(4) DEFAULT '1',
47  PRIMARY KEY (`id`),
48  UNIQUE KEY `name_UNIQUE` (`name`)
49) ENGINE=InnoDB DEFAULT CHARSET=latin1;
50
51-- Data exporting was unselected.
52
53
54-- Dumping structure for table life.houses
55CREATE TABLE IF NOT EXISTS `houses` (
56  `id` int(11) NOT NULL AUTO_INCREMENT,
57  `pid` varchar(32) NOT NULL,
58  `pos` varchar(64) DEFAULT NULL,
59  `inventory` text,
60  `containers` text,
61  `owned` tinyint(4) DEFAULT '0',
62  `shared1` text,
63  `shared2` text,
64  `shared3` text,
65  `shared4` text,
66  `shared5` text,
67  PRIMARY KEY (`id`,`pid`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69
70-- Data exporting was unselected.
71
72
73-- Dumping structure for table life.launcher
74CREATE TABLE IF NOT EXISTS `launcher` (
75  `server_ip` varchar(15) DEFAULT NULL,
76  `launcher_path` varchar(255) DEFAULT NULL,
77  `ts3_plugin_path` varchar(255) DEFAULT NULL,
78  `mod_path` varchar(255) DEFAULT NULL,
79  `ftp_userid` varchar(255) DEFAULT NULL,
80  `ftp_pass` varchar(255) DEFAULT NULL,
81  `hashes_path` varchar(255) DEFAULT NULL,
82  `servers_path` varchar(255) DEFAULT NULL
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85-- Data exporting was unselected.
86
87
88-- Dumping structure for table life.panellog
89CREATE TABLE IF NOT EXISTS `panellog` (
90  `uid` int(12) NOT NULL AUTO_INCREMENT,
91  `date` varchar(32) NOT NULL,
92  `author` varchar(32) NOT NULL,
93  `pname` varchar(32) NOT NULL,
94  `pid` varchar(50) NOT NULL,
95  `bankacc` int(100) NOT NULL DEFAULT '0',
96  `cash` int(100) NOT NULL DEFAULT '0',
97  `obankacc` int(100) NOT NULL DEFAULT '0',
98  `ocash` int(100) NOT NULL DEFAULT '0',
99  `coplevel` enum('0','1','2','3','4','5','6','7') DEFAULT '0',
100  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
101  PRIMARY KEY (`uid`),
102  KEY `pname` (`pname`),
103  KEY `author` (`author`)
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106-- Data exporting was unselected.
107
108
109-- Dumping structure for table life.players
110CREATE TABLE IF NOT EXISTS `players` (
111  `uid` int(12) NOT NULL AUTO_INCREMENT,
112  `name` varchar(32) NOT NULL,
113  `playerid` varchar(50) NOT NULL,
114  `cash` int(100) NOT NULL DEFAULT '0',
115  `bankacc` int(100) NOT NULL DEFAULT '0',
116  `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15') DEFAULT '0',
117  `cop_licenses` text,
118  `civ_licenses` text,
119  `med_licenses` text,
120  `cop_gear` text NOT NULL,
121  `mediclevel` enu
122[SQL] Finished with err