Blox
Copyright © 2009-2011 Wei Yeh - weicool@gmail.com
Developed on Mac OS X Snow Leopard

#####################
# Leaderboard
#####################

CREATE TABLE blox_leaderboard (
    id INT UNSIGNED AUTO_INCREMENT,
    name VARCHAR(16) NOT NULL,
    score INT UNSIGNED NOT NULL,
    level SMALLINT UNSIGNED NOT NULL,
    date DATETIME NOT NULL,
    ip VARCHAR(16) NOT NULL,
    PRIMARY KEY (id),
    INDEX (score, level),
    INDEX (ip)
);

CREATE TABLE blox_certs (
    id INT UNSIGNED AUTO_INCREMENT,
    cert VARCHAR(32) NOT NULL,
    date DATETIME NOT NULL,
    ip VARCHAR(16) NOT NULL,
    PRIMARY KEY (id),
    INDEX (ip),
    INDEX (date)
);

DELETE FROM blox_certs WHERE TIME_TO_SEC(TIMEDIFF(NOW(), `date`)) >= 60 * 60 * 24;