Forum - DDraceNetwork

Code: Select all

,\N

Code: Select all

,"2000-01-01 00:00:00"

Code: Select all

# db

CREATE SCHEMA `ddnet` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;


# maps

CREATE TABLE IF NOT EXISTS maps (
    Map VARCHAR(128) BINARY NOT NULL, 
    Server VARCHAR(32) BINARY NOT NULL, 
    Points INT DEFAULT 0, 
    Stars INT DEFAULT 0, 
    Mapper VARCHAR(128) BINARY NOT NULL, 
    Released TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    KEY Map (Map)) 
CHARACTER SET utf8 ;

LOAD DATA INFILE '%path%/maps' 
INTO TABLE maps 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n' ;


# race

CREATE TABLE IF NOT EXISTS race (
    Map VARCHAR(128) BINARY NOT NULL, 
    Name VARCHAR(16) BINARY NOT NULL,
    Time FLOAT DEFAULT 0,
    Timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    KEY Name (Name))
CHARACTER SET utf8 ;

LOAD DATA INFILE '%path%/race' 
INTO TABLE race 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n' ;


# teamrace

CREATE TABLE IF NOT EXISTS teamrace (
    Map VARCHAR(128) BINARY NOT NULL, 
    Name VARCHAR(16) BINARY NOT NULL,
    Time FLOAT DEFAULT 0,
    ID VARBINARY(16) NOT NULL,
    Timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    KEY Name (Name))
CHARACTER SET utf8 ;

LOAD DATA INFILE '%path%/teamrace' 
INTO TABLE teamrace 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n' ;