GNWFRJih

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