Datenbank Problehm

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home

extDB3: Version: 1.025

extDB3: Windows Version

Message: All development for extDB3 is done on a Linux Dedicated Server

Message: If you would like to Donate to extDB3 Development

Message: https://www.paypal.com/cgi-bin/webscr…d=2SUEFTGABTAM2

Message: Also leave a message if there is any particular feature you would like to see added.

Message: Thanks for all the people that have donated.

Message: Torndeco: 18/05/15

extDB3: Found extdb3-conf.ini

extDB3: Detected 4 Cores, Setting up 4 Worker Threads

extDB3: ...

extDB3: ...

extDB3: ...

extDB3: ...

[10:31:59:865576 +02:00] [Thread 4032] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2

[10:31:59:865664 +02:00] [Thread 4032] extDB3: SQL: Initialized: NULL = ""

[10:31:59:865686 +02:00] [Thread 4032] extDB3: Locked

[10:31:59:868792 +02:00] [Thread 3944] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist

[10:31:59:868809 +02:00] [Thread 3944] extDB3: SQL: Error MariaDBQueryException: Input: CALL resetLifeVehicles

[10:31:59:868823 +02:00] [Thread 3668] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist

[10:31:59:868835 +02:00] [Thread 3668] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteDeadVehicles

[10:31:59:868891 +02:00] [Thread 1516] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist

[10:31:59:868899 +02:00] [Thread 1516] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldHouses

[10:31:59:868966 +02:00] [Thread 4884] extDB3: SQL: Error MariaDBQueryException: The user specified as a definer ('arma3'@'localhost') does not exist

[10:31:59:868974 +02:00] [Thread 4884] extDB3: SQL: Error MariaDBQueryException: Input: CALL deleteOldGangs

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

--

-- Compatible with newer MySQL versions. (After MySQL-5.5)

-- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.

--

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

--

-- Database: `altislife`

-- Default Schema

--

CREATE DATABASE IF NOT EXISTS `altislife` DEFAULT CHARACTER SET utf8mb4;

USE `altislife`;

--

-- Drop procedures to ensure no conflicts

--

DROP PROCEDURE IF EXISTS `resetLifeVehicles`;

DROP PROCEDURE IF EXISTS `deleteDeadVehicles`;

DROP PROCEDURE IF EXISTS `deleteOldHouses`;

DROP PROCEDURE IF EXISTS `deleteOldGangs`;

DROP PROCEDURE IF EXISTS `deleteOldContainers`;

DROP PROCEDURE IF EXISTS `deleteOldWanted`;

DELIMITER $$

--

-- Procedures

-- Edit testserveradmindb to match a user in MySQL

-- For external databases: Edit localhost to match testserveradmindbserver IP

--

CREATE DEFINER=`testserveradmindb`@`localhost` PROCEDURE `resetLifeVehicles`()

BEGIN

UPDATE `vehicles` SET `active`= 0;

END$$

CREATE DEFINER=`testserveradmindb`@`localhost` PROCEDURE `deleteDeadVehicles`()

BEGIN

DELETE FROM `vehicles` WHERE `alive` = 0;

END$$

CREATE DEFINER=`testserveradmindb`@`localhost` PROCEDURE `deleteOldHouses`()

BEGIN

DELETE FROM `houses` WHERE `owned` = 0;

END$$

CREATE DEFINER=`testserveradmindb`@`localhost` PROCEDURE `deleteOldGangs`()

BEGIN

DELETE FROM `gangs` WHERE `active` = 0;

END$$

CREATE DEFINER=`testserveradmindb`@`localhost` PROCEDURE `deleteOldContainers`()

BEGIN

DELETE FROM `containers` WHERE `owned` = 0;

END$$

CREATE DEFINER=`testserveradmindb`@`localhost` PROCEDURE `deleteOldWanted`()

BEGIN

DELETE FROM `wanted` WHERE `active` = 0;

END$$

DELIMITER ;

-- --------------------------------------------------------

--

-- Table structure for table `players`

--

CREATE TABLE IF NOT EXISTS `players` (

`uid` int(6) NOT NULL AUTO_INCREMENT,

`name` varchar(32) NOT NULL,

`aliases` text NOT NULL,

`pid` varchar(17) NOT NULL,

`cash` int(100) NOT NULL DEFAULT '0',

`bankacc` int(100) NOT NULL DEFAULT '0',

`coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',

`mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',

`civ_licenses` text NOT NULL,

`cop_licenses` text NOT NULL,

`med_licenses` text NOT NULL,

`civ_gear` text NOT NULL,

`cop_gear` text NOT NULL,

`med_gear` text NOT NULL,

`civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',

`cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',

`med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',

`arrested` tinyint(1) NOT NULL DEFAULT '0',

`adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',

`donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',

`blacklist` tinyint(1) NOT NULL DEFAULT '0',

`civ_alive` tinyint(1) NOT NULL DEFAULT '0',

`civ_position` varchar(64) NOT NULL DEFAULT '"[]"',

`playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',

`insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,

`last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`uid`),

UNIQUE KEY `pid` (`pid`),

KEY `name` (`name`),

KEY `blacklist` (`blacklist`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--

-- Table structure for table `vehicles`

--

CREATE TABLE IF NOT EXISTS `vehicles` (

`id` int(6) NOT NULL AUTO_INCREMENT,

`side` varchar(16) NOT NULL,

`classname` varchar(64) NOT NULL,

`type` varchar(16) NOT NULL,

`pid` varchar(17) NOT NULL,

`alive` tinyint(1) NOT NULL DEFAULT '1',

`blacklist` tinyint(1) NOT NULL DEFAULT '0',

`active` tinyint(1) NOT NULL DEFAULT '0',

`plate` int(20) NOT NULL,

`color` int(20) NOT NULL,

`inventory` text NOT NULL,

`gear` text NOT NULL,

`fuel` double NOT NULL DEFAULT '1',

`damage` varchar(256) NOT NULL,

`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

KEY `side` (`side`),

KEY `pid` (`pid`),

KEY `type` (`type`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--

-- Table structure for table `houses`

-- Needed for extDB latest update on git

--

CREATE TABLE IF NOT EXISTS `houses` (

`id` int(6) NOT NULL AUTO_INCREMENT,

`pid` varchar(17) NOT NULL,

`pos` varchar(64) DEFAULT NULL,

`owned` tinyint(1) DEFAULT '0',

`garage` tinyint(1) NOT NULL DEFAULT '0',

`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`,`pid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--

-- Table structure for table `gangs`

-- Needed for extDB latest update on git

--

CREATE TABLE IF NOT EXISTS `gangs` (

`id` int(6) NOT NULL AUTO_INCREMENT,

`owner` varchar(32) DEFAULT NULL,

`name` varchar(32) DEFAULT NULL,

`members` text,

`maxmembers` int(3) DEFAULT '8',

`bank` int(100) DEFAULT '0',

`active` tinyint(1) DEFAULT '1',

`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

UNIQUE KEY `name_UNIQUE` (`name`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--

-- Table structure for table `containers`

-- Needed for extDB latest update on git

--

CREATE TABLE IF NOT EXISTS `containers` (

`id` int(6) NOT NULL AUTO_INCREMENT,

`pid` varchar(17) NOT NULL,

`classname` varchar(32) NOT NULL,

`pos` varchar(64) DEFAULT NULL,

`inventory` text NOT NULL,

`gear` text NOT NULL,

`dir` varchar(128) DEFAULT NULL,

`active` tinyint(1) NOT NULL DEFAULT '0',

`owned` tinyint(1) DEFAULT '0',

`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`,`pid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4;

-- --------------------------------------------------------

--

-- Table structure for table `wanted`

-- Needed for extDB latest update on git

--

CREATE TABLE IF NOT EXISTS `wanted` (

`wantedID` varchar(64) NOT NULL,

`wantedName` varchar(32) NOT NULL,

`wantedCrimes` text NOT NULL,

`wantedBounty` int(100) NOT NULL,

`active` tinyint(1) NOT NULL DEFAULT '0',

`insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`wantedID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;