10 lines
486 B
SQL
10 lines
486 B
SQL
CREATE TABLE IF NOT EXISTS `olympiad_nobles_eom` (
|
|
`charId` INT UNSIGNED NOT NULL default 0,
|
|
`class_id` decimal(3,0) NOT NULL default 0,
|
|
`olympiad_points` decimal(10,0) NOT NULL default 0,
|
|
`competitions_done` decimal(3,0) NOT NULL default 0,
|
|
`competitions_won` decimal(3,0) NOT NULL default 0,
|
|
`competitions_lost` decimal(3,0) NOT NULL default 0,
|
|
`competitions_drawn` decimal(3,0) NOT NULL default 0,
|
|
PRIMARY KEY (`charId`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |