CREATE DATABASE `server`

CREATE TABLE `admincommands` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `PlayerName` VARCHAR(32) NOT NULL DEFAULT '0',
    `CommandName` VARCHAR(32) NOT NULL DEFAULT '0',
    `Usage` VARCHAR(128) NOT NULL DEFAULT '0',
    `Date` VARCHAR(10) NOT NULL DEFAULT '0',
    `Time` VARCHAR(20) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;


CREATE TABLE `adminlogs` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `Username` VARCHAR(24) NOT NULL DEFAULT '0',
    `Date` VARCHAR(64) NULL DEFAULT '0',
    `Time` VARCHAR(64) NULL DEFAULT '0',
    `Text` VARCHAR(128) NULL DEFAULT '0',
    `Type` VARCHAR(20) NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;

CREATE TABLE `chatlogs` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `Username` VARCHAR(24) NOT NULL,
    `IP` VARCHAR(16) NOT NULL,
    `Date` VARCHAR(64) NOT NULL,
    `Time` VARCHAR(64) NOT NULL,
    `Text` VARCHAR(256) NOT NULL,
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;


CREATE TABLE `loginlogs` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `Username` VARCHAR(24) NOT NULL,
    `IP` VARCHAR(16) NOT NULL,
    `Date` VARCHAR(64) NOT NULL,
    `Time` VARCHAR(64) NOT NULL,
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;

CREATE TABLE `players` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `Username` VARCHAR(24) NOT NULL DEFAULT '0',
    `Password` VARCHAR(129) NOT NULL DEFAULT '0',
    `IP` VARCHAR(16) NOT NULL DEFAULT '0',
    `Admin` INT(2) NOT NULL DEFAULT '0',
    `VIP` INT(2) NOT NULL DEFAULT '0',
    `Money` INT(2) NOT NULL DEFAULT '0',
    `TimePlayed` INT(20) NOT NULL DEFAULT '0',
    `Nickname` VARCHAR(24) NOT NULL DEFAULT 'None',
    `PlayerColour` VARCHAR(15) NOT NULL DEFAULT 'None',
    `R` INT(3) NULL DEFAULT '255',
    `G` INT(3) NULL DEFAULT '255',
    `B` INT(3) NULL DEFAULT '0',
    `Banned` INT(1) NULL DEFAULT '0',
    `vipset` INT(20) NULL DEFAULT '0',
    `Victories` INT(10) NULL DEFAULT '0',
    `CarColor` INT(4) NULL DEFAULT '2555',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;


CREATE TABLE `private_messages` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `sender` VARCHAR(24) NOT NULL DEFAULT '0',
    `receiver` VARCHAR(24) NOT NULL DEFAULT '0',
    `message` VARCHAR(24) NOT NULL DEFAULT '0',
    `date` VARCHAR(10) NOT NULL DEFAULT '0',
    `time` VARCHAR(10) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;


CREATE TABLE `punishments` (
    `ID` INT(10) NOT NULL AUTO_INCREMENT,
    `PlayerName` VARCHAR(24) NOT NULL DEFAULT '0',
    `AdminName` VARCHAR(24) NOT NULL DEFAULT '0',
    `Reason` VARCHAR(24) NOT NULL DEFAULT '0',
    `Date` VARCHAR(50) NOT NULL DEFAULT '0',
    `Time` VARCHAR(50) NOT NULL DEFAULT '0',
    `Type` VARCHAR(10) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;

CREATE TABLE `radio_stations` (
    `ID` INT(50) NOT NULL AUTO_INCREMENT,
    `url` VARCHAR(64) NOT NULL DEFAULT '0',
    `description` VARCHAR(64) NOT NULL DEFAULT '0',
    `author` VARCHAR(24) NOT NULL DEFAULT '0',
    `genre` VARCHAR(64) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;

CREATE TABLE `reviews` (
    `ID` INT(50) NOT NULL AUTO_INCREMENT,
    `Rating` FLOAT NOT NULL DEFAULT '0',
    `Description` VARCHAR(64) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;


CREATE TABLE `viplogs` (
    `ID` INT(50) NOT NULL AUTO_INCREMENT,
    `PlayerName` VARCHAR(24) NOT NULL,
    `CommandName` VARCHAR(32) NOT NULL,
    `Date` VARCHAR(50) NOT NULL,
    `Time` VARCHAR(50) NOT NULL,
    `VIPLevel` INT(10) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0
;