viewing paste PVP Ladder | SQL

Posted on the
Copied to clipboard
1 2 3 4 5 6 7 8 9 
CREATE TABLE IF NOT EXISTS `pvpladder` (
`char_id` INT(11) NOT NULL DEFAULT 0,
`name` VARCHAR(30) NOT NULL DEFAULT '',
`streaks` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0,
`kills` SMALLINT(6) UNSIGNED NOT NULL  DEFAULT 0,
`deaths` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0,
`streakte` datetime NULL,
PRIMARY KEY (`char_id`)
)
Viewed 774 times, submitted by Guest.