groupingfilter.data

来自「java编写的OCR软件」· DATA 代码 · 共 50 行

#DB-Script for WmTipp 
#$Id: db.sql,v 1.2 2004/02/10 22:09:19 pcs Exp $

CREATE TABLE wmmatch (
    id int PRIMARY KEY AUTO_INCREMENT,
    matchdate DATETIME NOT NULL,
    hometeam VARCHAR(50) NOT NULL,
    awayteam VARCHAR(50) NOT NULL,
    homescore TINYINT DEFAULT '-1',
    awayscore TINYINT DEFAULT '-1',
    category VARCHAR(40) NOT NULL,
    INDEX categoryidx (category),
    INDEX matchdateidx (matchdate),
    UNIQUE (matchdate, hometeam, awayteam)
);

CREATE TABLE tipp (
    id int PRIMARY KEY AUTO_INCREMENT,
    wmmatch int NOT NULL,
    player int NOT NULL,
    homescore TINYINT UNSIGNED,
    awayscore TINYINT UNSIGNED,
    points  INT UNSIGNED,
    INDEX matchidx (wmmatch),
    INDEX playeridx (player),
    UNIQUE (wmmatch, player)
);

CREATE TABLE player (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    fullname VARCHAR(50) NOT NULL,
    email VARCHAR(255) NOT NULL,
    password VARCHAR(50) NOT NULL,
    category VARCHAR(30),
    admin TINYINT(1) DEFAULT 0,
    approved TINYINT(1) DEFAULT 0,
    correcttipps TINYINT UNSIGNED DEFAULT 0,
    correcttototipps TINYINT UNSIGNED DEFAULT 0,
    wrongtipps TINYINT UNSIGNED DEFAULT 0,
    score INT UNSIGNED DEFAULT 0,
    INDEX categoryidx (category),
    INDEX nameidx (name),
    INDEX approvedidx (approved),
    INDEX scoreidx (score),
    UNIQUE (name),
    UNIQUE (fullname),
    UNIQUE (email)
);