mirror of
https://github.com/Aurorastation/Aurora-Old.git
synced 2026-02-07 22:17:38 +00:00
6ed23da9ea
Updates the separate schema files. May consider merging and nixing these at some point, for easier reconstruction if something ever happens to the server.
101 lines
3.2 KiB
SQL
101 lines
3.2 KiB
SQL
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
|
|
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
|
|
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
|
|
|
|
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
|
|
CREATE SCHEMA IF NOT EXISTS `tgstation` DEFAULT CHARACTER SET latin1 ;
|
|
USE `mydb` ;
|
|
USE `tgstation` ;
|
|
|
|
-- -----------------------------------------------------
|
|
-- Table `tgstation`.`ss13_death`
|
|
-- -----------------------------------------------------
|
|
CREATE TABLE IF NOT EXISTS `tgstation`.`ss13_death` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT ,
|
|
`pod` TEXT NOT NULL COMMENT 'Place of death' ,
|
|
`coord` TEXT NOT NULL COMMENT 'X, Y, Z POD' ,
|
|
`tod` DATETIME NOT NULL COMMENT 'Time of death' ,
|
|
`job` TEXT NOT NULL ,
|
|
`special` TEXT NOT NULL ,
|
|
`name` TEXT NOT NULL ,
|
|
`byondkey` TEXT NOT NULL ,
|
|
`laname` TEXT NOT NULL COMMENT 'Last attacker name' ,
|
|
`lakey` TEXT NOT NULL COMMENT 'Last attacker key' ,
|
|
`gender` TEXT NOT NULL ,
|
|
`bruteloss` INT(11) NOT NULL ,
|
|
`brainloss` INT(11) NOT NULL ,
|
|
`fireloss` INT(11) NOT NULL ,
|
|
`oxyloss` INT(11) NOT NULL ,
|
|
PRIMARY KEY (`id`) )
|
|
ENGINE = MyISAM
|
|
AUTO_INCREMENT = 3409
|
|
DEFAULT CHARACTER SET = latin1;
|
|
|
|
|
|
-- -----------------------------------------------------
|
|
-- Table `tgstation`.`ss13_karma`
|
|
-- -----------------------------------------------------
|
|
CREATE TABLE IF NOT EXISTS `tgstation`.`ss13_karma` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT ,
|
|
`spendername` TEXT NOT NULL ,
|
|
`spenderkey` TEXT NOT NULL ,
|
|
`receivername` TEXT NOT NULL ,
|
|
`receiverkey` TEXT NOT NULL ,
|
|
`receiverrole` TEXT NOT NULL ,
|
|
`receiverspecial` TEXT NOT NULL ,
|
|
`isnegative` TINYINT(1) NOT NULL ,
|
|
`spenderip` TEXT NOT NULL ,
|
|
`time` DATETIME NOT NULL ,
|
|
PRIMARY KEY (`id`) )
|
|
ENGINE = MyISAM
|
|
AUTO_INCREMENT = 943
|
|
DEFAULT CHARACTER SET = latin1;
|
|
|
|
|
|
-- -----------------------------------------------------
|
|
-- Table `tgstation`.`ss13_karmatotals`
|
|
-- -----------------------------------------------------
|
|
CREATE TABLE IF NOT EXISTS `tgstation`.`ss13_karmatotals` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT ,
|
|
`byondkey` TEXT NOT NULL ,
|
|
`karma` INT(11) NOT NULL ,
|
|
PRIMARY KEY (`id`) )
|
|
ENGINE = MyISAM
|
|
AUTO_INCREMENT = 244
|
|
DEFAULT CHARACTER SET = latin1;
|
|
|
|
|
|
-- -----------------------------------------------------
|
|
-- Table `tgstation`.`ss13_library`
|
|
-- -----------------------------------------------------
|
|
CREATE TABLE IF NOT EXISTS `tgstation`.`ss13_library` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT ,
|
|
`author` TEXT NOT NULL ,
|
|
`title` TEXT NOT NULL ,
|
|
`content` TEXT NOT NULL ,
|
|
`category` TEXT NOT NULL ,
|
|
PRIMARY KEY (`id`) )
|
|
ENGINE = MyISAM
|
|
AUTO_INCREMENT = 184
|
|
DEFAULT CHARACTER SET = latin1;
|
|
|
|
|
|
-- -----------------------------------------------------
|
|
-- Table `tgstation`.`ss13_population`
|
|
-- -----------------------------------------------------
|
|
CREATE TABLE IF NOT EXISTS `tgstation`.`ss13_population` (
|
|
`id` INT(11) NOT NULL AUTO_INCREMENT ,
|
|
`playercount` INT(11) NULL DEFAULT NULL ,
|
|
`admincount` INT(11) NULL DEFAULT NULL ,
|
|
`time` DATETIME NOT NULL ,
|
|
PRIMARY KEY (`id`) )
|
|
ENGINE = MyISAM
|
|
AUTO_INCREMENT = 2544
|
|
DEFAULT CHARACTER SET = latin1;
|
|
|
|
|
|
|
|
SET SQL_MODE=@OLD_SQL_MODE;
|
|
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
|
|
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
|