viewing paste stats-mod sql-tables | SQL

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113
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;
Viewed 1259 times, submitted by lighta.