viewing paste Top Breaker Table SQL | SQL

Posted on the | Last edited on
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
// TABLE SQL FOR Script Top Emperium Breaker (SoulBlaker)
// Fixed BY Envolvents (Wellington Ferraz)
 
CREATE TABLE IF NOT EXISTS topemperium_players(
char_id INT( 11 ) UNSIGNED NOT NULL ,
break INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
STATUS INT( 1 ) NOT NULL DEFAULT '0',
KEY `char_id` (`char_id`)
)ENGINE=MYISAM;
 
CREATE TABLE IF NOT EXISTS topemperium_playerscastles (
char_id INT( 11 ) UNSIGNED NOT NULL ,
castle VARCHAR( 24 ) NOT NULL DEFAULT '',
break INT(11) UNSIGNED NOT NULL DEFAULT '0',
STATUS INT( 1 ) NOT NULL DEFAULT '0',
KEY `char_id` (`char_id`)
) ENGINE=MYISAM;
 
CREATE TABLE IF NOT EXISTS topemperium_guilds (
guild_id INT( 11 ) UNSIGNED NOT NULL ,
break INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
STATUS INT( 1 ) NOT NULL DEFAULT '0',
KEY `char_id` (`char_id`)
) ENGINE=MYISAM;
 
CREATE TABLE IF NOT EXISTS topemperium_guildscastles (
guild_id INT( 11 ) UNSIGNED NOT NULL ,
castle VARCHAR( 24 ) NOT NULL DEFAULT '',
break INT( 11 ) UNSIGNED NOT NULL DEFAULT '0',
STATUS INT( 1 ) NOT NULL DEFAULT '0',
KEY `char_id` (`char_id`)
) ENGINE=MYISAM;
Viewed 719 times, submitted by Envolvents.