Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- --
- --
- -- 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 arma3 to match a user in MySQL
- -- For external databases: Edit localhost to match arma3server IP
- --
- CREATE DEFINER=`root`@`145.239.108.64 ` PROCEDURE `resetLifeVehicles`()
- BEGIN
- UPDATE `vehicles` SET `active`= 0;
- END$$
- CREATE DEFINER=`root`@`145.239.108.64 ` PROCEDURE `deleteDeadVehicles`()
- BEGIN
- DELETE FROM `vehicles` WHERE `alive` = 0;
- END$$
- CREATE DEFINER=`root`@`145.239.108.64 ` PROCEDURE `deleteOldHouses`()
- BEGIN
- DELETE FROM `houses` WHERE `owned` = 0;
- END$$
- CREATE DEFINER=`root`@`145.239.108.64 ` PROCEDURE `deleteOldGangs`()
- BEGIN
- DELETE FROM `gangs` WHERE `active` = 0;
- END$$
- CREATE DEFINER=`root`@`145.239.108.64 ` PROCEDURE `deleteOldContainers`()
- BEGIN
- DELETE FROM `containers` WHERE `owned` = 0;
- END$$
- CREATE DEFINER=`root`@`145.239.108.64 ` 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement