stats-mod sql-tables

CREATE TABLE  `Stats_Woe_Skill` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`char_id` INT( 11 ) UNSIGNED NOT NULL ,
`skillname` VARCHAR( 30 ) NOT NULL ,
`skilltype` INT( 11 ) UNSIGNED NOT NULL ,
`skillcount` INT UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Conso` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`char_id` INT( 11 ) UNSIGNED NOT NULL ,
`consoname` VARCHAR( 30 ) NOT NULL ,
`consocount` INT UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Dammage` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`char_id` INT( 11 ) UNSIGNED NOT NULL ,
`dmgrec` INT ( 11 ) UNSIGNED NULL ,
`dmgrecmax` INT ( 11 ) UNSIGNED NULL ,
`dmgdone` INT ( 11 ) UNSIGNED NULL ,
`dmgdonemax` INT ( 11 ) UNSIGNED NULL ,
`dmgemp` INT ( 11 ) UNSIGNED NULL ,
`dmgbarri` INT ( 11 ) UNSIGNED NULL ,
`dmgstone` INT ( 11 ) UNSIGNED NULL ,
`dmgguardFE` INT ( 11 ) UNSIGNED NULL ,
`dmgguardSE` INT ( 11 ) UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Kill` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`char_id` INT( 11 ) UNSIGNED NOT NULL ,
`death` INT ( 11 ) UNSIGNED NULL ,
`kill` INT ( 11 ) UNSIGNED NULL ,
`emp` INT ( 11 ) UNSIGNED NULL ,
`barri` INT ( 11 ) UNSIGNED NULL ,
`stone` INT ( 11 ) UNSIGNED NULL ,
`guardSE` INT ( 11 ) UNSIGNED NULL ,
`guardFE` INT ( 11 ) UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Heal` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`char_id` INT( 11 ) UNSIGNED NOT NULL ,
`healdone` INT ( 11 ) UNSIGNED NULL ,
`healdonemax` INT ( 11 ) UNSIGNED NULL ,
`healrec` INT ( 11 ) UNSIGNED NULL ,
`healrecmax` INT ( 11 ) UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_GSkill` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`guild_id` INT( 11 ) UNSIGNED NOT NULL ,
`skillname` VARCHAR( 30 ) NOT NULL ,
`skillcount` INT UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_GKill` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`guild_id` INT( 11 ) UNSIGNED NOT NULL ,
`death` INT ( 11 ) UNSIGNED NULL ,
`kill` INT ( 11 ) UNSIGNED NULL ,
`emp` INT ( 11 ) UNSIGNED NULL ,
`barri` INT ( 11 ) UNSIGNED NULL ,
`stone` INT ( 11 ) UNSIGNED NULL ,
`guardSE` INT ( 11 ) UNSIGNED NULL ,
`guardFE` INT ( 11 ) UNSIGNED NULL
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Data` (
`woe_id` INT( 11 ) UNSIGNED NOT NULL auto_increment,
`date` INT ( 11 ) UNSIGNED NOT NULL ,
`castle_id1` INT ( 11 ) UNSIGNED NULL ,
`castle_id2` INT ( 11 ) UNSIGNED NULL ,
`time_debut` INT ( 11 ) UNSIGNED NULL ,
`time_fin` INT ( 11 ) UNSIGNED NULL ,
PRIMARY KEY  (`woe_id`)
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Historique` (
`id` INT( 11 ) UNSIGNED NOT NULL auto_increment,
`woe_id` INT ( 11 ) UNSIGNED NOT NULL ,
`castle_id` INT ( 11 ) UNSIGNED NOT NULL ,
`type` VARCHAR ( 30 ) NULL ,
`time` INT ( 11 ) UNSIGNED NULL ,
`def_guildid` INT ( 11 ) UNSIGNED NULL ,
`player_id` INT ( 11 ) UNSIGNED NULL ,
`player_guildid` INT ( 11 ) UNSIGNED NULL ,
`vitesse` INT ( 30 ) UNSIGNED NULL ,
PRIMARY KEY  (`id`)
) ENGINE = MYISAM;


CREATE TABLE  `Stats_Woe_Event` (
`id` INT( 11 ) UNSIGNED NOT NULL auto_increment,
`woe_id` INT ( 11 ) UNSIGNED NOT NULL ,
`castle_id` INT ( 11 ) UNSIGNED NOT NULL ,
`killed_id` INT ( 11 ) UNSIGNED NOT NULL ,
`killer_id` INT ( 11 ) UNSIGNED NOT NULL ,
`skillname` VARCHAR( 30 ) NOT NULL ,
`time` INT ( 11 ) UNSIGNED NULL ,
PRIMARY KEY  (`id`)
) ENGINE = MYISAM;

CREATE TABLE  `Stats_Woe_Guild_Co` (
`id` INT( 11 ) UNSIGNED NOT NULL auto_increment,
`woe_id` INT( 11 ) UNSIGNED NOT NULL ,
`castle_id` INT ( 11 ) UNSIGNED NOT NULL ,
`time` INT ( 11 ) UNSIGNED NULL ,
`guild_id` INT ( 11 ) UNSIGNED NOT NULL ,
`nb_co` INT ( 11 ) UNSIGNED NOT NULL ,
PRIMARY KEY  (`id`)
) ENGINE = MYISAM;