I've started following the guide on the github wiki and i'm facing an error on mysql while running the main.sql code.
Whenever I run it whole I get:
18:13:28`clan_id`int(11)unsigned NOT NULL AUTO_INCREMENT,`name` varchar(24) NOT NULL DEFAULT '',`master` varchar(24) NOT NULL DEFAULT '',`mapname` varchar(24) NOT NULL DEFAULT '',`max_member` smallint(6)unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`clan_id`)) ENGINE=MyISAM AUTO_INCREMENT=5ErrorCode:1064.You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NUL' at line 10.000 sec
On discord I was told to remove the code from clans and then run it later. While removing the code makes it work when I try to run it afterwards I still get the same error.
Is the code broken? I just cloned it.
Here's the code I'm running:
Spoiler
--
-- Table structure for table `acc_reg_num`
--
CREATE TABLE IF NOT EXISTS `acc_reg_num` (
`account_id` int(11) unsigned NOT NULL default '0',
`key` varchar(32) binary NOT NULL default '',
`index` int(11) unsigned NOT NULL default '0',
`value` bigint(11) NOT NULL default '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `acc_reg_str`
--
CREATE TABLE IF NOT EXISTS `acc_reg_str` (
`account_id` int(11) unsigned NOT NULL default '0',
`key` varchar(32) binary NOT NULL default '',
`index` int(11) unsigned NOT NULL default '0',
`value` varchar(254) NOT NULL default '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `achievement`
--
CREATE TABLE IF NOT EXISTS `achievement` (
`char_id` int(11) unsigned NOT NULL default '0',
`id` bigint(11) unsigned NOT NULL,
`count1` mediumint(8) unsigned NOT NULL default '0',
`count2` mediumint(8) unsigned NOT NULL default '0',
`count3` mediumint(8) unsigned NOT NULL default '0',
`count4` mediumint(8) unsigned NOT NULL default '0',
`count5` mediumint(8) unsigned NOT NULL default '0',
`count6` mediumint(8) unsigned NOT NULL default '0',
`count7` mediumint(8) unsigned NOT NULL default '0',
`count8` mediumint(8) unsigned NOT NULL default '0',
`count9` mediumint(8) unsigned NOT NULL default '0',
`count10` mediumint(8) unsigned NOT NULL default '0',
`completed` datetime,
`rewarded` datetime,
PRIMARY KEY (`char_id`,`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `auction`
--
CREATE TABLE IF NOT EXISTS `auction` (
`auction_id` bigint(20) unsigned NOT NULL auto_increment,
`seller_id` int(11) unsigned NOT NULL default '0',
`seller_name` varchar(30) NOT NULL default '',
`buyer_id` int(11) unsigned NOT NULL default '0',
`buyer_name` varchar(30) NOT NULL default '',
`price` int(11) unsigned NOT NULL default '0',
`buynow` int(11) unsigned NOT NULL default '0',
`hours` smallint(6) NOT NULL default '0',
`timestamp` int(11) unsigned NOT NULL default '0',
`nameid` smallint(5) unsigned NOT NULL default '0',
`item_name` varchar(50) NOT NULL default '',
`type` smallint(6) NOT NULL default '0',
`refine` tinyint(3) unsigned NOT NULL default '0',
`attribute` tinyint(4) unsigned NOT NULL default '0',
`card0` smallint(5) unsigned NOT NULL default '0',
`card1` smallint(5) unsigned NOT NULL default '0',
`card2` smallint(5) unsigned NOT NULL default '0',
`card3` smallint(5) unsigned NOT NULL default '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`auction_id`)
) ENGINE=MyISAM;
--
-- Table structure for `db_roulette`
--
CREATE TABLE IF NOT EXISTS `db_roulette` (
`index` int(11) NOT NULL default '0',
`level` smallint(5) unsigned NOT NULL,
`item_id` smallint(5) unsigned NOT NULL,
`amount` smallint(5) unsigned NOT NULL DEFAULT '1',
`flag` smallint(5) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`index`)
) ENGINE=MyISAM;
--
-- Table structure for table `bonus_script`
--
CREATE TABLE IF NOT EXISTS `bonus_script` (
`char_id` INT(11) UNSIGNED NOT NULL,
`script` TEXT NOT NULL,
`tick` BIGINT(20) NOT NULL DEFAULT '0',
`flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`icon` SMALLINT(3) NOT NULL DEFAULT '-1',
PRIMARY KEY (`char_id`, `type`)
) ENGINE=InnoDB;
--
-- Table structure for table `buyingstore_items`
--
CREATE TABLE IF NOT EXISTS `buyingstore_items` (
`buyingstore_id` int(10) unsigned NOT NULL,
`index` smallint(5) unsigned NOT NULL,
`item_id` int(10) unsigned NOT NULL,
`amount` smallint(5) unsigned NOT NULL,
`price` int(10) unsigned NOT NULL,
PRIMARY KEY (`buyingstore_id`, `index`)
) ENGINE=MyISAM;
--
-- Table structure for table `buyingstores`
--
CREATE TABLE IF NOT EXISTS `buyingstores` (
`id` int(10) unsigned NOT NULL,
`account_id` int(11) unsigned NOT NULL,
`char_id` int(10) unsigned NOT NULL,
`sex` enum('F','M') NOT NULL DEFAULT 'M',
`map` varchar(20) NOT NULL,
`x` smallint(5) unsigned NOT NULL,
`y` smallint(5) unsigned NOT NULL,
`title` varchar(80) NOT NULL,
`limit` int(10) unsigned NOT NULL,
`body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
`head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
`sit` CHAR( 1 ) NOT NULL DEFAULT '1',
`autotrade` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `cart_inventory`
--
CREATE TABLE IF NOT EXISTS `cart_inventory` (
`id` int(11) NOT NULL auto_increment,
`char_id` int(11) NOT NULL default '0',
`nameid` smallint(5) unsigned NOT NULL default '0',
`amount` int(11) NOT NULL default '0',
`equip` int(11) unsigned NOT NULL default '0',
`identify` smallint(6) NOT NULL default '0',
`refine` tinyint(3) unsigned NOT NULL default '0',
`attribute` tinyint(4) NOT NULL default '0',
`card0` smallint(5) unsigned NOT NULL default '0',
`card1` smallint(5) unsigned NOT NULL default '0',
`card2` smallint(5) unsigned NOT NULL default '0',
`card3` smallint(5) unsigned NOT NULL default '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`expire_time` int(11) unsigned NOT NULL default '0',
`bound` tinyint(3) unsigned NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `char`
--
CREATE TABLE IF NOT EXISTS `char` (
`char_id` int(11) unsigned NOT NULL auto_increment,
`account_id` int(11) unsigned NOT NULL default '0',
`char_num` tinyint(1) NOT NULL default '0',
`name` varchar(30) NOT NULL DEFAULT '',
`class` smallint(6) unsigned NOT NULL default '0',
`base_level` smallint(6) unsigned NOT NULL default '1',
`job_level` smallint(6) unsigned NOT NULL default '1',
`base_exp` bigint(20) unsigned NOT NULL default '0',
`job_exp` bigint(20) unsigned NOT NULL default '0',
`zeny` int(11) unsigned NOT NULL default '0',
`str` smallint(4) unsigned NOT NULL default '0',
`agi` smallint(4) unsigned NOT NULL default '0',
`vit` smallint(4) unsigned NOT NULL default '0',
`int` smallint(4) unsigned NOT NULL default '0',
`dex` smallint(4) unsigned NOT NULL default '0',
`luk` smallint(4) unsigned NOT NULL default '0',
`max_hp` int(11) unsigned NOT NULL default '0',
`hp` int(11) unsigned NOT NULL default '0',
`max_sp` int(11) unsigned NOT NULL default '0',
`sp` int(11) unsigned NOT NULL default '0',
`status_point` int(11) unsigned NOT NULL default '0',
`skill_point` int(11) unsigned NOT NULL default '0',
`option` int(11) NOT NULL default '0',
`karma` tinyint(3) NOT NULL default '0',
`manner` smallint(6) NOT NULL default '0',
`party_id` int(11) unsigned NOT NULL default '0',
`guild_id` int(11) unsigned NOT NULL default '0',
`pet_id` int(11) unsigned NOT NULL default '0',
`homun_id` int(11) unsigned NOT NULL default '0',
`elemental_id` int(11) unsigned NOT NULL default '0',
`hair` tinyint(4) unsigned NOT NULL default '0',
`hair_color` smallint(5) unsigned NOT NULL default '0',
`clothes_color` smallint(5) unsigned NOT NULL default '0',
`body` smallint(5) unsigned NOT NULL default '0',
`weapon` smallint(6) unsigned NOT NULL default '0',
`shield` smallint(6) unsigned NOT NULL default '0',
`head_top` smallint(6) unsigned NOT NULL default '0',
`head_mid` smallint(6) unsigned NOT NULL default '0',
`head_bottom` smallint(6) unsigned NOT NULL default '0',
`robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
`last_map` varchar(11) NOT NULL default '',
`last_x` smallint(4) unsigned NOT NULL default '53',
`last_y` smallint(4) unsigned NOT NULL default '111',
`save_map` varchar(11) NOT NULL default '',
`save_x` smallint(4) unsigned NOT NULL default '53',
`save_y` smallint(4) unsigned NOT NULL default '111',
`partner_id` int(11) unsigned NOT NULL default '0',
`online` tinyint(2) NOT NULL default '0',
`father` int(11) unsigned NOT NULL default '0',
`mother` int(11) unsigned NOT NULL default '0',
`child` int(11) unsigned NOT NULL default '0',
`fame` int(11) unsigned NOT NULL default '0',
`rename` SMALLINT(3) unsigned NOT NULL default '0',
`delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`moves` int(11) unsigned NOT NULL DEFAULT '0',
`unban_time` int(11) unsigned NOT NULL default '0',
`font` tinyint(3) unsigned NOT NULL default '0',
`uniqueitem_counter` int(11) unsigned NOT NULL default '0',
`sex` ENUM('M','F','U') NOT NULL default 'U',
`hotkey_rowshift` tinyint(3) unsigned NOT NULL default '0',
`clan_id` int(11) unsigned NOT NULL default '0',
`last_login` datetime DEFAULT NULL,
`title_id` INT(11) unsigned NOT NULL default '0',
`show_equip` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`),
UNIQUE KEY `name_key` (`name`),
KEY `account_id` (`account_id`),
KEY `party_id` (`party_id`),
KEY `guild_id` (`guild_id`),
KEY `online` (`online`)
) ENGINE=MyISAM AUTO_INCREMENT=150000;
--
-- Table structure for table `char_reg_num`
--
CREATE TABLE IF NOT EXISTS `char_reg_num` (
`char_id` int(11) unsigned NOT NULL default '0',
`key` varchar(32) binary NOT NULL default '',
`index` int(11) unsigned NOT NULL default '0',
`value` bigint(11) NOT NULL default '0',
PRIMARY KEY (`char_id`,`key`,`index`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `char_reg_str`
--
CREATE TABLE IF NOT EXISTS `char_reg_str` (
`char_id` int(11) unsigned NOT NULL default '0',
`key` varchar(32) binary NOT NULL default '',
`index` int(11) unsigned NOT NULL default '0',
`value` varchar(254) NOT NULL default '0',
PRIMARY KEY (`char_id`,`key`,`index`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `charlog`
--
CREATE TABLE IF NOT EXISTS `charlog` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`time` datetime NOT NULL,
`char_msg` varchar(255) NOT NULL default 'char select',
`account_id` int(11) NOT NULL default '0',
`char_num` tinyint(4) NOT NULL default '0',
`name` varchar(23) NOT NULL default '',
`str` int(11) unsigned NOT NULL default '0',
`agi` int(11) unsigned NOT NULL default '0',
`vit` int(11) unsigned NOT NULL default '0',
`int` int(11) unsigned NOT NULL default '0',
`dex` int(11) unsigned NOT NULL default '0',
`luk` int(11) unsigned NOT NULL default '0',
`hair` tinyint(4) NOT NULL default '0',
`hair_color` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `clan`
--
CREATE TABLE IF NOT EXISTS `clan` (
`clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(24) NOT NULL DEFAULT '',
`master` varchar(24) NOT NULL DEFAULT '',
`mapname` varchar(24) NOT NULL DEFAULT '',
`max_member` smallint(6) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`clan_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5;
-- ----------------------------
-- Records of clan
-- ----------------------------
INSERT INTO `clan` VALUES ('1', 'Swordman Clan', 'Raffam Oranpere', 'prontera', '500');
INSERT INTO `clan` VALUES ('2', 'Arcwand Clan', 'Devon Aire', 'geffen', '500');
INSERT INTO `clan` VALUES ('3', 'Golden Mace Clan', 'Berman Aire', 'prontera', '500');
INSERT INTO `clan` VALUES ('4', 'Crossbow Clan', 'Shaam Rumi', 'payon', '500');
-- ----------------------------
-- Table structure for `clan_alliance`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `clan_alliance` (
`clan_id` int(11) unsigned NOT NULL DEFAULT '0',
`opposition` int(11) unsigned NOT NULL DEFAULT '0',
`alliance_id` int(11) unsigned NOT NULL DEFAULT '0',
`name` varchar(24) NOT NULL DEFAULT '',
PRIMARY KEY (`clan_id`,`alliance_id`),
KEY `alliance_id` (`alliance_id`)
) ENGINE=MyISAM;
-- ----------------------------
-- Records of clan_alliance
-- ----------------------------
INSERT INTO `clan_alliance` VALUES ('1', '0', '3', 'Golden Mace Clan');
INSERT INTO `clan_alliance` VALUES ('2', '0', '3', 'Golden Mace Clan');
INSERT INTO `clan_alliance` VALUES ('2', '1', '4', 'Crossbow Clan');
INSERT INTO `clan_alliance` VALUES ('3', '0', '1', 'Swordman Clan');
INSERT INTO `clan_alliance` VALUES ('3', '0', '2', 'Arcwand Clan');
INSERT INTO `clan_alliance` VALUES ('3', '0', '4', 'Crossbow Clan');
INSERT INTO `clan_alliance` VALUES ('4', '0', '3', 'Golden Mace Clan');
INSERT INTO `clan_alliance` VALUES ('4', '1', '2', 'Arcwand Clan');
--
-- Table structure for table `elemental`
--
CREATE TABLE IF NOT EXISTS `elemental` (
`ele_id` int(11) unsigned NOT NULL auto_increment,
`char_id` int(11) NOT NULL,
`class` mediumint(9) unsigned NOT NULL default '0',
`mode` int(11) unsigned NOT NULL default '1',
`hp` int(11) unsigned NOT NULL default '0',
`sp` int(11) unsigned NOT NULL default '0',
`max_hp` int(11) unsigned NOT NULL default '0',
`max_sp` int(11) unsigned NOT NULL default '0',
`atk1` MEDIUMINT(6) unsigned NOT NULL default '0',
`atk2` MEDIUMINT(6) unsigned NOT NULL default '0',
`matk` MEDIUMINT(6) unsigned NOT NULL default '0',
`aspd` smallint(4) unsigned NOT NULL default '0',
`def` smallint(4) unsigned NOT NULL default '0',
`mdef` smallint(4) unsigned NOT NULL default '0',
`flee` smallint(4) unsigned NOT NULL default '0',
`hit` smallint(4) unsigned NOT NULL default '0',
`life_time` bigint(20) NOT NULL default '0',
PRIMARY KEY (`ele_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `friends`
--
CREATE TABLE IF NOT EXISTS `friends` (
`char_id` int(11) NOT NULL default '0',
`friend_account` int(11) NOT NULL default '0',
`friend_id` int(11) NOT NULL default '0',
PRIMARY KEY (`char_id`, `friend_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `global_acc_reg_num`
--
CREATE TABLE IF NOT EXISTS `global_acc_reg_num` (
`account_id` int(11) unsigned NOT NULL default '0',
`key` varchar(32) binary NOT NULL default '',
`index` int(11) unsigned NOT NULL default '0',
`value` bigint(11) NOT NULL default '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `global_acc_reg_str`
--
CREATE TABLE IF NOT EXISTS `global_acc_reg_str` (
`account_id` int(11) unsigned NOT NULL default '0',
`key` varchar(32) binary NOT NULL default '',
`index` int(11) unsigned NOT NULL default '0',
`value` varchar(254) NOT NULL default '0',
PRIMARY KEY (`account_id`,`key`,`index`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild`
--
CREATE TABLE IF NOT EXISTS `guild` (
`guild_id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(24) NOT NULL default '',
`char_id` int(11) unsigned NOT NULL default '0',
`master` varchar(24) NOT NULL default '',
`guild_lv` tinyint(6) unsigned NOT NULL default '0',
`connect_member` tinyint(6) unsigned NOT NULL default '0',
`max_member` tinyint(6) unsigned NOT NULL default '0',
`average_lv` smallint(6) unsigned NOT NULL default '1',
`exp` bigint(20) unsigned NOT NULL default '0',
`next_exp` int(11) unsigned NOT NULL default '0',
`skill_point` tinyint(11) unsigned NOT NULL default '0',
`mes1` varchar(60) NOT NULL default '',
`mes2` varchar(120) NOT NULL default '',
`emblem_len` int(11) unsigned NOT NULL default '0',
`emblem_id` int(11) unsigned NOT NULL default '0',
`emblem_data` blob,
`last_master_change` datetime,
PRIMARY KEY (`guild_id`,`char_id`),
UNIQUE KEY `guild_id` (`guild_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_alliance`
--
CREATE TABLE IF NOT EXISTS `guild_alliance` (
`guild_id` int(11) unsigned NOT NULL default '0',
`opposition` int(11) unsigned NOT NULL default '0',
`alliance_id` int(11) unsigned NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
PRIMARY KEY (`guild_id`,`alliance_id`),
KEY `alliance_id` (`alliance_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_castle`
--
CREATE TABLE IF NOT EXISTS `guild_castle` (
`castle_id` int(11) unsigned NOT NULL default '0',
`guild_id` int(11) unsigned NOT NULL default '0',
`economy` int(11) unsigned NOT NULL default '0',
`defense` int(11) unsigned NOT NULL default '0',
`triggerE` int(11) unsigned NOT NULL default '0',
`triggerD` int(11) unsigned NOT NULL default '0',
`nextTime` int(11) unsigned NOT NULL default '0',
`payTime` int(11) unsigned NOT NULL default '0',
`createTime` int(11) unsigned NOT NULL default '0',
`visibleC` int(11) unsigned NOT NULL default '0',
`visibleG0` int(11) unsigned NOT NULL default '0',
`visibleG1` int(11) unsigned NOT NULL default '0',
`visibleG2` int(11) unsigned NOT NULL default '0',
`visibleG3` int(11) unsigned NOT NULL default '0',
`visibleG4` int(11) unsigned NOT NULL default '0',
`visibleG5` int(11) unsigned NOT NULL default '0',
`visibleG6` int(11) unsigned NOT NULL default '0',
`visibleG7` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`castle_id`),
KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_expulsion`
--
CREATE TABLE IF NOT EXISTS `guild_expulsion` (
`guild_id` int(11) unsigned NOT NULL default '0',
`account_id` int(11) unsigned NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
`mes` varchar(40) NOT NULL default '',
PRIMARY KEY (`guild_id`,`name`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_member`
--
CREATE TABLE IF NOT EXISTS `guild_member` (
`guild_id` int(11) unsigned NOT NULL default '0',
`account_id` int(11) unsigned NOT NULL default '0',
`char_id` int(11) unsigned NOT NULL default '0',
`hair` tinyint(6) unsigned NOT NULL default '0',
`hair_color` smallint(6) unsigned NOT NULL default '0',
`gender` tinyint(6) unsigned NOT NULL default '0',
`class` smallint(6) unsigned NOT NULL default '0',
`lv` smallint(6) unsigned NOT NULL default '0',
`exp` bigint(20) unsigned NOT NULL default '0',
`exp_payper` tinyint(11) unsigned NOT NULL default '0',
`online` tinyint(4) unsigned NOT NULL default '0',
`position` tinyint(6) unsigned NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
PRIMARY KEY (`guild_id`,`char_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_position`
--
CREATE TABLE IF NOT EXISTS `guild_position` (
`guild_id` int(9) unsigned NOT NULL default '0',
`position` tinyint(6) unsigned NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
`mode` smallint(11) unsigned NOT NULL default '0',
`exp_mode` tinyint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guild_id`,`position`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_skill`
--
CREATE TABLE IF NOT EXISTS `guild_skill` (
`guild_id` int(11) unsigned NOT NULL default '0',
`id` smallint(11) unsigned NOT NULL default '0',
`lv` tinyint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`guild_id`,`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_storage`
--
CREATE TABLE IF NOT EXISTS `guild_storage` (
`id` int(10) unsigned NOT NULL auto_increment,
`guild_id` int(11) unsigned NOT NULL default '0',
`nameid` smallint(5) unsigned NOT NULL default '0',
`amount` int(11) unsigned NOT NULL default '0',
`equip` int(11) unsigned NOT NULL default '0',
`identify` smallint(6) unsigned NOT NULL default '0',
`refine` tinyint(3) unsigned NOT NULL default '0',
`attribute` tinyint(4) unsigned NOT NULL default '0',
`card0` smallint(5) unsigned NOT NULL default '0',
`card1` smallint(5) unsigned NOT NULL default '0',
`card2` smallint(5) unsigned NOT NULL default '0',
`card3` smallint(5) unsigned NOT NULL default '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`expire_time` int(11) unsigned NOT NULL default '0',
`bound` tinyint(3) unsigned NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `guild_id` (`guild_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `guild_storage_log`
--
CREATE TABLE IF NOT EXISTS `guild_storage_log` (
`id` int(11) NOT NULL auto_increment,
`guild_id` int(11) unsigned NOT NULL default '0',
`time` datetime NOT NULL,
`char_id` int(11) NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
`nameid` smallint(5) unsigned NOT NULL default '0',
`amount` int(11) NOT NULL default '1',
`identify` smallint(6) NOT NULL default '0',
`refine` tinyint(3) unsigned NOT NULL default '0',
`attribute` tinyint(4) unsigned NOT NULL default '0',
`card0` smallint(5) unsigned NOT NULL default '0',
`card1` smallint(5) unsigned NOT NULL default '0',
`card2` smallint(5) unsigned NOT NULL default '0',
`card3` smallint(5) unsigned NOT NULL default '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`expire_time` int(11) unsigned NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL default '0',
`bound` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
INDEX (`guild_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
--
-- Table structure for table `homunculus`
--
CREATE TABLE IF NOT EXISTS `homunculus` (
`homun_id` int(11) NOT NULL auto_increment,
`char_id` int(11) NOT NULL,
`class` mediumint(9) unsigned NOT NULL default '0',
`prev_class` mediumint(9) NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
`level` smallint(4) NOT NULL default '0',
`exp` bigint(20) unsigned NOT NULL default '0',
`intimacy` int(12) NOT NULL default '0',
`hunger` smallint(4) NOT NULL default '0',
`str` smallint(4) unsigned NOT NULL default '0',
`agi` smallint(4) unsigned NOT NULL default '0',
`vit` smallint(4) unsigned NOT NULL default '0',
`int` smallint(4) unsigned NOT NULL default '0',
`dex` smallint(4) unsigned NOT NULL default '0',
`luk` smallint(4) unsigned NOT NULL default '0',
`hp` int(11) unsigned NOT NULL default '0',
`max_hp` int(11) unsigned NOT NULL default '0',
`sp` int(11) NOT NULL default '0',
`max_sp` int(11) NOT NULL default '0',
`skill_point` smallint(4) unsigned NOT NULL default '0',
`alive` tinyint(2) NOT NULL default '1',
`rename_flag` tinyint(2) NOT NULL default '0',
`vaporize` tinyint(2) NOT NULL default '0',
`autofeed` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`homun_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `hotkey`
--
CREATE TABLE IF NOT EXISTS `hotkey` (
`char_id` INT(11) NOT NULL,
`hotkey` TINYINT(2) unsigned NOT NULL,
`type` TINYINT(1) unsigned NOT NULL default '0',
`itemskill_id` INT(11) unsigned NOT NULL default '0',
`skill_lvl` TINYINT(4) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`,`hotkey`)
) ENGINE=MyISAM;
--
-- Table structure for table `interlog`
--
CREATE TABLE IF NOT EXISTS `interlog` (
`id` INT NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`log` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
INDEX `time` (`time`)
) ENGINE=MyISAM;
--
-- Table structure for table `interreg`
--
CREATE TABLE IF NOT EXISTS `interreg` (
`varname` varchar(11) NOT NULL,
`value` varchar(20) NOT NULL,
PRIMARY KEY (`varname`)
) ENGINE=InnoDB;
--
-- Table structure for table `inventory`
--
CREATE TABLE IF NOT EXISTS `inventory` (
`id` int(11) unsigned NOT NULL auto_increment,
`char_id` int(11) unsigned NOT NULL default '0',
`nameid` smallint(5) unsigned NOT NULL default '0',
`amount` int(11) unsigned NOT NULL default '0',
`equip` int(11) unsigned NOT NULL default '0',
`identify` smallint(6) NOT NULL default '0',
`refine` tinyint(3) unsigned NOT NULL default '0',
`attribute` tinyint(4) unsigned NOT NULL default '0',
`card0` smallint(5) unsigned NOT NULL default '0',
`card1` smallint(5) unsigned NOT NULL default '0',
`card2` smallint(5) unsigned NOT NULL default '0',
`card3` smallint(5) unsigned NOT NULL default '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`expire_time` int(11) unsigned NOT NULL default '0',
`favorite` tinyint(3) unsigned NOT NULL default '0',
`bound` tinyint(3) unsigned NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL default '0',
`equip_switch` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `ipbanlist`
--
CREATE TABLE IF NOT EXISTS `ipbanlist` (
`list` varchar(15) NOT NULL default '',
`btime` datetime NOT NULL,
`rtime` datetime NOT NULL,
`reason` varchar(255) NOT NULL default '',
PRIMARY KEY (`list`, `btime`)
) ENGINE=MyISAM;
--
-- Table structure for table `login`
--
CREATE TABLE IF NOT EXISTS `login` (
`account_id` int(11) unsigned NOT NULL auto_increment,
`userid` varchar(23) NOT NULL default '',
`user_pass` varchar(32) NOT NULL default '',
`sex` enum('M','F','S') NOT NULL default 'M',
`email` varchar(39) NOT NULL default '',
`group_id` tinyint(3) NOT NULL default '0',
`state` int(11) unsigned NOT NULL default '0',
`unban_time` int(11) unsigned NOT NULL default '0',
`expiration_time` int(11) unsigned NOT NULL default '0',
`logincount` mediumint(9) unsigned NOT NULL default '0',
`lastlogin` datetime,
`last_ip` varchar(100) NOT NULL default '',
`birthdate` DATE,
`character_slots` tinyint(3) unsigned NOT NULL default '0',
`pincode` varchar(4) NOT NULL DEFAULT '',
`pincode_change` int(11) unsigned NOT NULL DEFAULT '0',
`vip_time` int(11) unsigned NOT NULL default '0',
`old_group` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`account_id`),
KEY `name` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=2000000;
-- added standard accounts for servers, VERY INSECURE!!!
-- inserted into the table called login which is above
INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]');
--
-- Table structure for table `mail`
--
CREATE TABLE IF NOT EXISTS `mail` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`send_name` varchar(30) NOT NULL default '',
`send_id` int(11) unsigned NOT NULL default '0',
`dest_name` varchar(30) NOT NULL default '',
`dest_id` int(11) unsigned NOT NULL default '0',
`title` varchar(45) NOT NULL default '',
`message` varchar(500) NOT NULL default '',
`time` int(11) unsigned NOT NULL default '0',
`status` tinyint(2) NOT NULL default '0',
`zeny` int(11) unsigned NOT NULL default '0',
`type` smallint(5) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
-- ----------------------------
-- Table structure for `mail_attachments`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `mail_attachments` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`index` smallint(5) unsigned NOT NULL DEFAULT '0',
`nameid` smallint(5) unsigned NOT NULL DEFAULT '0',
`amount` int(11) unsigned NOT NULL DEFAULT '0',
`refine` tinyint(3) unsigned NOT NULL DEFAULT '0',
`attribute` tinyint(4) unsigned NOT NULL DEFAULT '0',
`identify` smallint(6) NOT NULL DEFAULT '0',
`card0` smallint(5) unsigned NOT NULL DEFAULT '0',
`card1` smallint(5) unsigned NOT NULL DEFAULT '0',
`card2` smallint(5) unsigned NOT NULL DEFAULT '0',
`card3` smallint(5) unsigned NOT NULL DEFAULT '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`bound` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`index`)
) ENGINE=MyISAM;
--
-- Table structure for table `mapreg`
--
CREATE TABLE IF NOT EXISTS `mapreg` (
`varname` varchar(32) binary NOT NULL,
`index` int(11) unsigned NOT NULL default '0',
`value` varchar(255) NOT NULL,
PRIMARY KEY (`varname`,`index`)
) ENGINE=MyISAM;
--
-- Table `market` for market shop persistency
--
CREATE TABLE IF NOT EXISTS `market` (
`name` varchar(50) NOT NULL DEFAULT '',
`nameid` SMALLINT(5) UNSIGNED NOT NULL,
`price` INT(11) UNSIGNED NOT NULL,
`amount` SMALLINT(5) UNSIGNED NOT NULL,
`flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`name`,`nameid`)
) ENGINE = MyISAM;
--
-- Table structure for table `memo`
--
CREATE TABLE IF NOT EXISTS `memo` (
`memo_id` int(11) unsigned NOT NULL auto_increment,
`char_id` int(11) unsigned NOT NULL default '0',
`map` varchar(11) NOT NULL default '',
`x` smallint(4) unsigned NOT NULL default '0',
`y` smallint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`memo_id`),
KEY `char_id` (`char_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `mercenary`
--
CREATE TABLE IF NOT EXISTS `mercenary` (
`mer_id` int(11) unsigned NOT NULL auto_increment,
`char_id` int(11) NOT NULL,
`class` mediumint(9) unsigned NOT NULL default '0',
`hp` int(11) unsigned NOT NULL default '0',
`sp` int(11) unsigned NOT NULL default '0',
`kill_counter` int(11) NOT NULL,
`life_time` bigint(20) NOT NULL default '0',
PRIMARY KEY (`mer_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `mercenary_owner`
--
CREATE TABLE IF NOT EXISTS `mercenary_owner` (
`char_id` int(11) NOT NULL,
`merc_id` int(11) NOT NULL default '0',
`arch_calls` int(11) NOT NULL default '0',
`arch_faith` int(11) NOT NULL default '0',
`spear_calls` int(11) NOT NULL default '0',
`spear_faith` int(11) NOT NULL default '0',
`sword_calls` int(11) NOT NULL default '0',
`sword_faith` int(11) NOT NULL default '0',
PRIMARY KEY (`char_id`)
) ENGINE=MyISAM;
-- ----------------------------
-- Table structure for `sales`
-- ----------------------------
CREATE TABLE IF NOT EXISTS `sales` (
`nameid` smallint(5) unsigned NOT NULL,
`start` datetime NOT NULL,
`end` datetime NOT NULL,
`amount` int(11) NOT NULL,
PRIMARY KEY (`nameid`)
) ENGINE=MyISAM;
--
-- Table structure for table `sc_data`
--
CREATE TABLE IF NOT EXISTS `sc_data` (
`account_id` int(11) unsigned NOT NULL,
`char_id` int(11) unsigned NOT NULL,
`type` smallint(11) unsigned NOT NULL,
`tick` bigint(20) NOT NULL,
`val1` int(11) NOT NULL default '0',
`val2` int(11) NOT NULL default '0',
`val3` int(11) NOT NULL default '0',
`val4` int(11) NOT NULL default '0',
PRIMARY KEY (`char_id`, `type`)
) ENGINE=MyISAM;
--
-- Table structure for table `skillcooldown`
--
CREATE TABLE IF NOT EXISTS `skillcooldown` (
`account_id` int(11) unsigned NOT NULL,
`char_id` int(11) unsigned NOT NULL,
`skill` smallint(11) unsigned NOT NULL DEFAULT '0',
`tick` bigint(20) NOT NULL,
PRIMARY KEY (`char_id`, `skill`)
) ENGINE=MyISAM;
--
-- Table structure for table `party`
--
CREATE TABLE IF NOT EXISTS `party` (
`party_id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(24) NOT NULL default '',
`exp` tinyint(11) unsigned NOT NULL default '0',
`item` tinyint(11) unsigned NOT NULL default '0',
`leader_id` int(11) unsigned NOT NULL default '0',
`leader_char` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`party_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `pet`
--
CREATE TABLE IF NOT EXISTS `pet` (
`pet_id` int(11) unsigned NOT NULL auto_increment,
`class` mediumint(9) unsigned NOT NULL default '0',
`name` varchar(24) NOT NULL default '',
`account_id` int(11) unsigned NOT NULL default '0',
`char_id` int(11) unsigned NOT NULL default '0',
`level` smallint(4) unsigned NOT NULL default '0',
`egg_id` smallint(5) unsigned NOT NULL default '0',
`equip` mediumint(8) unsigned NOT NULL default '0',
`intimate` smallint(9) unsigned NOT NULL default '0',
`hungry` smallint(9) unsigned NOT NULL default '0',
`rename_flag` tinyint(4) unsigned NOT NULL default '0',
`incubate` int(11) unsigned NOT NULL default '0',
`autofeed` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`pet_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `quest`
--
CREATE TABLE IF NOT EXISTS `quest` (
`char_id` int(11) unsigned NOT NULL default '0',
`quest_id` int(10) unsigned NOT NULL,
`state` enum('0','1','2') NOT NULL default '0',
`time` int(11) unsigned NOT NULL default '0',
`count1` mediumint(8) unsigned NOT NULL default '0',
`count2` mediumint(8) unsigned NOT NULL default '0',
`count3` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`char_id`,`quest_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `skill`
--
CREATE TABLE IF NOT EXISTS `skill` (
`char_id` int(11) unsigned NOT NULL default '0',
`id` smallint(11) unsigned NOT NULL default '0',
`lv` tinyint(4) unsigned NOT NULL default '0',
`flag` TINYINT(1) UNSIGNED NOT NULL default 0,
PRIMARY KEY (`char_id`,`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `skill_homunculus`
--
CREATE TABLE IF NOT EXISTS `skill_homunculus` (
`homun_id` int(11) NOT NULL,
`id` int(11) NOT NULL,
`lv` smallint(6) NOT NULL,
PRIMARY KEY (`homun_id`,`id`)
) ENGINE=MyISAM;
--
-- Table structure for table `storage`
--
CREATE TABLE IF NOT EXISTS `storage` (
`id` int(11) unsigned NOT NULL auto_increment,
`account_id` int(11) unsigned NOT NULL default '0',
`nameid` smallint(5) unsigned NOT NULL default '0',
`amount` smallint(11) unsigned NOT NULL default '0',
`equip` int(11) unsigned NOT NULL default '0',
`identify` smallint(6) unsigned NOT NULL default '0',
`refine` tinyint(3) unsigned NOT NULL default '0',
`attribute` tinyint(4) unsigned NOT NULL default '0',
`card0` smallint(5) unsigned NOT NULL default '0',
`card1` smallint(5) unsigned NOT NULL default '0',
`card2` smallint(5) unsigned NOT NULL default '0',
`card3` smallint(5) unsigned NOT NULL default '0',
`option_id0` smallint(5) NOT NULL default '0',
`option_val0` smallint(5) NOT NULL default '0',
`option_parm0` tinyint(3) NOT NULL default '0',
`option_id1` smallint(5) NOT NULL default '0',
`option_val1` smallint(5) NOT NULL default '0',
`option_parm1` tinyint(3) NOT NULL default '0',
`option_id2` smallint(5) NOT NULL default '0',
`option_val2` smallint(5) NOT NULL default '0',
`option_parm2` tinyint(3) NOT NULL default '0',
`option_id3` smallint(5) NOT NULL default '0',
`option_val3` smallint(5) NOT NULL default '0',
`option_parm3` tinyint(3) NOT NULL default '0',
`option_id4` smallint(5) NOT NULL default '0',
`option_val4` smallint(5) NOT NULL default '0',
`option_parm4` tinyint(3) NOT NULL default '0',
`expire_time` int(11) unsigned NOT NULL default '0',
`bound` tinyint(3) unsigned NOT NULL default '0',
`unique_id` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`)
) ENGINE=MyISAM;
--
-- Table structure for table `vending_items`
--
CREATE TABLE IF NOT EXISTS `vending_items` (
`vending_id` int(10) unsigned NOT NULL,
`index` smallint(5) unsigned NOT NULL,
`cartinventory_id` int(10) unsigned NOT NULL,
`amount` smallint(5) unsigned NOT NULL,
`price` int(10) unsigned NOT NULL,
PRIMARY KEY (`vending_id`, `index`)
) ENGINE=MyISAM;
--
-- Table structure for table `vendings`
--
CREATE TABLE IF NOT EXISTS `vendings` (
`id` int(10) unsigned NOT NULL,
`account_id` int(11) unsigned NOT NULL,
`char_id` int(10) unsigned NOT NULL,
`sex` enum('F','M') NOT NULL DEFAULT 'M',
`map` varchar(20) NOT NULL,
`x` smallint(5) unsigned NOT NULL,
`y` smallint(5) unsigned NOT NULL,
`title` varchar(80) NOT NULL,
`body_direction` CHAR( 1 ) NOT NULL DEFAULT '4',
`head_direction` CHAR( 1 ) NOT NULL DEFAULT '0',
`sit` CHAR( 1 ) NOT NULL DEFAULT '1',
`autotrade` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Question
Waker
Hi everyone,
I've started following the guide on the github wiki and i'm facing an error on mysql while running the main.sql code.
Whenever I run it whole I get:
On discord I was told to remove the code from clans and then run it later. While removing the code makes it work when I try to run it afterwards I still get the same error.
Is the code broken? I just cloned it.
Here's the code I'm running:
-- -- Table structure for table `acc_reg_num` -- CREATE TABLE IF NOT EXISTS `acc_reg_num` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` bigint(11) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `acc_reg_str` -- CREATE TABLE IF NOT EXISTS `acc_reg_str` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` varchar(254) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `achievement` -- CREATE TABLE IF NOT EXISTS `achievement` ( `char_id` int(11) unsigned NOT NULL default '0', `id` bigint(11) unsigned NOT NULL, `count1` mediumint(8) unsigned NOT NULL default '0', `count2` mediumint(8) unsigned NOT NULL default '0', `count3` mediumint(8) unsigned NOT NULL default '0', `count4` mediumint(8) unsigned NOT NULL default '0', `count5` mediumint(8) unsigned NOT NULL default '0', `count6` mediumint(8) unsigned NOT NULL default '0', `count7` mediumint(8) unsigned NOT NULL default '0', `count8` mediumint(8) unsigned NOT NULL default '0', `count9` mediumint(8) unsigned NOT NULL default '0', `count10` mediumint(8) unsigned NOT NULL default '0', `completed` datetime, `rewarded` datetime, PRIMARY KEY (`char_id`,`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `auction` -- CREATE TABLE IF NOT EXISTS `auction` ( `auction_id` bigint(20) unsigned NOT NULL auto_increment, `seller_id` int(11) unsigned NOT NULL default '0', `seller_name` varchar(30) NOT NULL default '', `buyer_id` int(11) unsigned NOT NULL default '0', `buyer_name` varchar(30) NOT NULL default '', `price` int(11) unsigned NOT NULL default '0', `buynow` int(11) unsigned NOT NULL default '0', `hours` smallint(6) NOT NULL default '0', `timestamp` int(11) unsigned NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `item_name` varchar(50) NOT NULL default '', `type` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`auction_id`) ) ENGINE=MyISAM; -- -- Table structure for `db_roulette` -- CREATE TABLE IF NOT EXISTS `db_roulette` ( `index` int(11) NOT NULL default '0', `level` smallint(5) unsigned NOT NULL, `item_id` smallint(5) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL DEFAULT '1', `flag` smallint(5) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`index`) ) ENGINE=MyISAM; -- -- Table structure for table `bonus_script` -- CREATE TABLE IF NOT EXISTS `bonus_script` ( `char_id` INT(11) UNSIGNED NOT NULL, `script` TEXT NOT NULL, `tick` BIGINT(20) NOT NULL DEFAULT '0', `flag` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', `type` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `icon` SMALLINT(3) NOT NULL DEFAULT '-1', PRIMARY KEY (`char_id`, `type`) ) ENGINE=InnoDB; -- -- Table structure for table `buyingstore_items` -- CREATE TABLE IF NOT EXISTS `buyingstore_items` ( `buyingstore_id` int(10) unsigned NOT NULL, `index` smallint(5) unsigned NOT NULL, `item_id` int(10) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL, `price` int(10) unsigned NOT NULL, PRIMARY KEY (`buyingstore_id`, `index`) ) ENGINE=MyISAM; -- -- Table structure for table `buyingstores` -- CREATE TABLE IF NOT EXISTS `buyingstores` ( `id` int(10) unsigned NOT NULL, `account_id` int(11) unsigned NOT NULL, `char_id` int(10) unsigned NOT NULL, `sex` enum('F','M') NOT NULL DEFAULT 'M', `map` varchar(20) NOT NULL, `x` smallint(5) unsigned NOT NULL, `y` smallint(5) unsigned NOT NULL, `title` varchar(80) NOT NULL, `limit` int(10) unsigned NOT NULL, `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4', `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0', `sit` CHAR( 1 ) NOT NULL DEFAULT '1', `autotrade` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- -- Table structure for table `cart_inventory` -- CREATE TABLE IF NOT EXISTS `cart_inventory` ( `id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` int(11) NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `char` -- CREATE TABLE IF NOT EXISTS `char` ( `char_id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `char_num` tinyint(1) NOT NULL default '0', `name` varchar(30) NOT NULL DEFAULT '', `class` smallint(6) unsigned NOT NULL default '0', `base_level` smallint(6) unsigned NOT NULL default '1', `job_level` smallint(6) unsigned NOT NULL default '1', `base_exp` bigint(20) unsigned NOT NULL default '0', `job_exp` bigint(20) unsigned NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `str` smallint(4) unsigned NOT NULL default '0', `agi` smallint(4) unsigned NOT NULL default '0', `vit` smallint(4) unsigned NOT NULL default '0', `int` smallint(4) unsigned NOT NULL default '0', `dex` smallint(4) unsigned NOT NULL default '0', `luk` smallint(4) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `hp` int(11) unsigned NOT NULL default '0', `max_sp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `status_point` int(11) unsigned NOT NULL default '0', `skill_point` int(11) unsigned NOT NULL default '0', `option` int(11) NOT NULL default '0', `karma` tinyint(3) NOT NULL default '0', `manner` smallint(6) NOT NULL default '0', `party_id` int(11) unsigned NOT NULL default '0', `guild_id` int(11) unsigned NOT NULL default '0', `pet_id` int(11) unsigned NOT NULL default '0', `homun_id` int(11) unsigned NOT NULL default '0', `elemental_id` int(11) unsigned NOT NULL default '0', `hair` tinyint(4) unsigned NOT NULL default '0', `hair_color` smallint(5) unsigned NOT NULL default '0', `clothes_color` smallint(5) unsigned NOT NULL default '0', `body` smallint(5) unsigned NOT NULL default '0', `weapon` smallint(6) unsigned NOT NULL default '0', `shield` smallint(6) unsigned NOT NULL default '0', `head_top` smallint(6) unsigned NOT NULL default '0', `head_mid` smallint(6) unsigned NOT NULL default '0', `head_bottom` smallint(6) unsigned NOT NULL default '0', `robe` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', `last_map` varchar(11) NOT NULL default '', `last_x` smallint(4) unsigned NOT NULL default '53', `last_y` smallint(4) unsigned NOT NULL default '111', `save_map` varchar(11) NOT NULL default '', `save_x` smallint(4) unsigned NOT NULL default '53', `save_y` smallint(4) unsigned NOT NULL default '111', `partner_id` int(11) unsigned NOT NULL default '0', `online` tinyint(2) NOT NULL default '0', `father` int(11) unsigned NOT NULL default '0', `mother` int(11) unsigned NOT NULL default '0', `child` int(11) unsigned NOT NULL default '0', `fame` int(11) unsigned NOT NULL default '0', `rename` SMALLINT(3) unsigned NOT NULL default '0', `delete_date` INT(11) UNSIGNED NOT NULL DEFAULT '0', `moves` int(11) unsigned NOT NULL DEFAULT '0', `unban_time` int(11) unsigned NOT NULL default '0', `font` tinyint(3) unsigned NOT NULL default '0', `uniqueitem_counter` int(11) unsigned NOT NULL default '0', `sex` ENUM('M','F','U') NOT NULL default 'U', `hotkey_rowshift` tinyint(3) unsigned NOT NULL default '0', `clan_id` int(11) unsigned NOT NULL default '0', `last_login` datetime DEFAULT NULL, `title_id` INT(11) unsigned NOT NULL default '0', `show_equip` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`), UNIQUE KEY `name_key` (`name`), KEY `account_id` (`account_id`), KEY `party_id` (`party_id`), KEY `guild_id` (`guild_id`), KEY `online` (`online`) ) ENGINE=MyISAM AUTO_INCREMENT=150000; -- -- Table structure for table `char_reg_num` -- CREATE TABLE IF NOT EXISTS `char_reg_num` ( `char_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` bigint(11) NOT NULL default '0', PRIMARY KEY (`char_id`,`key`,`index`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `char_reg_str` -- CREATE TABLE IF NOT EXISTS `char_reg_str` ( `char_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` varchar(254) NOT NULL default '0', PRIMARY KEY (`char_id`,`key`,`index`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `charlog` -- CREATE TABLE IF NOT EXISTS `charlog` ( `id` bigint(20) unsigned NOT NULL auto_increment, `time` datetime NOT NULL, `char_msg` varchar(255) NOT NULL default 'char select', `account_id` int(11) NOT NULL default '0', `char_num` tinyint(4) NOT NULL default '0', `name` varchar(23) NOT NULL default '', `str` int(11) unsigned NOT NULL default '0', `agi` int(11) unsigned NOT NULL default '0', `vit` int(11) unsigned NOT NULL default '0', `int` int(11) unsigned NOT NULL default '0', `dex` int(11) unsigned NOT NULL default '0', `luk` int(11) unsigned NOT NULL default '0', `hair` tinyint(4) NOT NULL default '0', `hair_color` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `clan` -- CREATE TABLE IF NOT EXISTS `clan` ( `clan_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NULL DEFAULT '', `master` varchar(24) NOT NULL DEFAULT '', `mapname` varchar(24) NOT NULL DEFAULT '', `max_member` smallint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`clan_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5; -- ---------------------------- -- Records of clan -- ---------------------------- INSERT INTO `clan` VALUES ('1', 'Swordman Clan', 'Raffam Oranpere', 'prontera', '500'); INSERT INTO `clan` VALUES ('2', 'Arcwand Clan', 'Devon Aire', 'geffen', '500'); INSERT INTO `clan` VALUES ('3', 'Golden Mace Clan', 'Berman Aire', 'prontera', '500'); INSERT INTO `clan` VALUES ('4', 'Crossbow Clan', 'Shaam Rumi', 'payon', '500'); -- ---------------------------- -- Table structure for `clan_alliance` -- ---------------------------- CREATE TABLE IF NOT EXISTS `clan_alliance` ( `clan_id` int(11) unsigned NOT NULL DEFAULT '0', `opposition` int(11) unsigned NOT NULL DEFAULT '0', `alliance_id` int(11) unsigned NOT NULL DEFAULT '0', `name` varchar(24) NOT NULL DEFAULT '', PRIMARY KEY (`clan_id`,`alliance_id`), KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM; -- ---------------------------- -- Records of clan_alliance -- ---------------------------- INSERT INTO `clan_alliance` VALUES ('1', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('2', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('2', '1', '4', 'Crossbow Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '1', 'Swordman Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '2', 'Arcwand Clan'); INSERT INTO `clan_alliance` VALUES ('3', '0', '4', 'Crossbow Clan'); INSERT INTO `clan_alliance` VALUES ('4', '0', '3', 'Golden Mace Clan'); INSERT INTO `clan_alliance` VALUES ('4', '1', '2', 'Arcwand Clan'); -- -- Table structure for table `elemental` -- CREATE TABLE IF NOT EXISTS `elemental` ( `ele_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `mode` int(11) unsigned NOT NULL default '1', `hp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `max_sp` int(11) unsigned NOT NULL default '0', `atk1` MEDIUMINT(6) unsigned NOT NULL default '0', `atk2` MEDIUMINT(6) unsigned NOT NULL default '0', `matk` MEDIUMINT(6) unsigned NOT NULL default '0', `aspd` smallint(4) unsigned NOT NULL default '0', `def` smallint(4) unsigned NOT NULL default '0', `mdef` smallint(4) unsigned NOT NULL default '0', `flee` smallint(4) unsigned NOT NULL default '0', `hit` smallint(4) unsigned NOT NULL default '0', `life_time` bigint(20) NOT NULL default '0', PRIMARY KEY (`ele_id`) ) ENGINE=MyISAM; -- -- Table structure for table `friends` -- CREATE TABLE IF NOT EXISTS `friends` ( `char_id` int(11) NOT NULL default '0', `friend_account` int(11) NOT NULL default '0', `friend_id` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`, `friend_id`) ) ENGINE=MyISAM; -- -- Table structure for table `global_acc_reg_num` -- CREATE TABLE IF NOT EXISTS `global_acc_reg_num` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` bigint(11) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `global_acc_reg_str` -- CREATE TABLE IF NOT EXISTS `global_acc_reg_str` ( `account_id` int(11) unsigned NOT NULL default '0', `key` varchar(32) binary NOT NULL default '', `index` int(11) unsigned NOT NULL default '0', `value` varchar(254) NOT NULL default '0', PRIMARY KEY (`account_id`,`key`,`index`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild` -- CREATE TABLE IF NOT EXISTS `guild` ( `guild_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NULL default '', `char_id` int(11) unsigned NOT NULL default '0', `master` varchar(24) NOT NULL default '', `guild_lv` tinyint(6) unsigned NOT NULL default '0', `connect_member` tinyint(6) unsigned NOT NULL default '0', `max_member` tinyint(6) unsigned NOT NULL default '0', `average_lv` smallint(6) unsigned NOT NULL default '1', `exp` bigint(20) unsigned NOT NULL default '0', `next_exp` int(11) unsigned NOT NULL default '0', `skill_point` tinyint(11) unsigned NOT NULL default '0', `mes1` varchar(60) NOT NULL default '', `mes2` varchar(120) NOT NULL default '', `emblem_len` int(11) unsigned NOT NULL default '0', `emblem_id` int(11) unsigned NOT NULL default '0', `emblem_data` blob, `last_master_change` datetime, PRIMARY KEY (`guild_id`,`char_id`), UNIQUE KEY `guild_id` (`guild_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_alliance` -- CREATE TABLE IF NOT EXISTS `guild_alliance` ( `guild_id` int(11) unsigned NOT NULL default '0', `opposition` int(11) unsigned NOT NULL default '0', `alliance_id` int(11) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', PRIMARY KEY (`guild_id`,`alliance_id`), KEY `alliance_id` (`alliance_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_castle` -- CREATE TABLE IF NOT EXISTS `guild_castle` ( `castle_id` int(11) unsigned NOT NULL default '0', `guild_id` int(11) unsigned NOT NULL default '0', `economy` int(11) unsigned NOT NULL default '0', `defense` int(11) unsigned NOT NULL default '0', `triggerE` int(11) unsigned NOT NULL default '0', `triggerD` int(11) unsigned NOT NULL default '0', `nextTime` int(11) unsigned NOT NULL default '0', `payTime` int(11) unsigned NOT NULL default '0', `createTime` int(11) unsigned NOT NULL default '0', `visibleC` int(11) unsigned NOT NULL default '0', `visibleG0` int(11) unsigned NOT NULL default '0', `visibleG1` int(11) unsigned NOT NULL default '0', `visibleG2` int(11) unsigned NOT NULL default '0', `visibleG3` int(11) unsigned NOT NULL default '0', `visibleG4` int(11) unsigned NOT NULL default '0', `visibleG5` int(11) unsigned NOT NULL default '0', `visibleG6` int(11) unsigned NOT NULL default '0', `visibleG7` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`castle_id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_expulsion` -- CREATE TABLE IF NOT EXISTS `guild_expulsion` ( `guild_id` int(11) unsigned NOT NULL default '0', `account_id` int(11) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', `mes` varchar(40) NOT NULL default '', PRIMARY KEY (`guild_id`,`name`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_member` -- CREATE TABLE IF NOT EXISTS `guild_member` ( `guild_id` int(11) unsigned NOT NULL default '0', `account_id` int(11) unsigned NOT NULL default '0', `char_id` int(11) unsigned NOT NULL default '0', `hair` tinyint(6) unsigned NOT NULL default '0', `hair_color` smallint(6) unsigned NOT NULL default '0', `gender` tinyint(6) unsigned NOT NULL default '0', `class` smallint(6) unsigned NOT NULL default '0', `lv` smallint(6) unsigned NOT NULL default '0', `exp` bigint(20) unsigned NOT NULL default '0', `exp_payper` tinyint(11) unsigned NOT NULL default '0', `online` tinyint(4) unsigned NOT NULL default '0', `position` tinyint(6) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', PRIMARY KEY (`guild_id`,`char_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_position` -- CREATE TABLE IF NOT EXISTS `guild_position` ( `guild_id` int(9) unsigned NOT NULL default '0', `position` tinyint(6) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', `mode` smallint(11) unsigned NOT NULL default '0', `exp_mode` tinyint(11) unsigned NOT NULL default '0', PRIMARY KEY (`guild_id`,`position`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_skill` -- CREATE TABLE IF NOT EXISTS `guild_skill` ( `guild_id` int(11) unsigned NOT NULL default '0', `id` smallint(11) unsigned NOT NULL default '0', `lv` tinyint(11) unsigned NOT NULL default '0', PRIMARY KEY (`guild_id`,`id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_storage` -- CREATE TABLE IF NOT EXISTS `guild_storage` ( `id` int(10) unsigned NOT NULL auto_increment, `guild_id` int(11) unsigned NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` int(11) unsigned NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) unsigned NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; -- -- Table structure for table `guild_storage_log` -- CREATE TABLE IF NOT EXISTS `guild_storage_log` ( `id` int(11) NOT NULL auto_increment, `guild_id` int(11) unsigned NOT NULL default '0', `time` datetime NOT NULL, `char_id` int(11) NOT NULL default '0', `name` varchar(24) NOT NULL default '', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` int(11) NOT NULL default '1', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `bound` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), INDEX (`guild_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1; -- -- Table structure for table `homunculus` -- CREATE TABLE IF NOT EXISTS `homunculus` ( `homun_id` int(11) NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `prev_class` mediumint(9) NOT NULL default '0', `name` varchar(24) NOT NULL default '', `level` smallint(4) NOT NULL default '0', `exp` bigint(20) unsigned NOT NULL default '0', `intimacy` int(12) NOT NULL default '0', `hunger` smallint(4) NOT NULL default '0', `str` smallint(4) unsigned NOT NULL default '0', `agi` smallint(4) unsigned NOT NULL default '0', `vit` smallint(4) unsigned NOT NULL default '0', `int` smallint(4) unsigned NOT NULL default '0', `dex` smallint(4) unsigned NOT NULL default '0', `luk` smallint(4) unsigned NOT NULL default '0', `hp` int(11) unsigned NOT NULL default '0', `max_hp` int(11) unsigned NOT NULL default '0', `sp` int(11) NOT NULL default '0', `max_sp` int(11) NOT NULL default '0', `skill_point` smallint(4) unsigned NOT NULL default '0', `alive` tinyint(2) NOT NULL default '1', `rename_flag` tinyint(2) NOT NULL default '0', `vaporize` tinyint(2) NOT NULL default '0', `autofeed` tinyint(2) NOT NULL default '0', PRIMARY KEY (`homun_id`) ) ENGINE=MyISAM; -- -- Table structure for table `hotkey` -- CREATE TABLE IF NOT EXISTS `hotkey` ( `char_id` INT(11) NOT NULL, `hotkey` TINYINT(2) unsigned NOT NULL, `type` TINYINT(1) unsigned NOT NULL default '0', `itemskill_id` INT(11) unsigned NOT NULL default '0', `skill_lvl` TINYINT(4) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`,`hotkey`) ) ENGINE=MyISAM; -- -- Table structure for table `interlog` -- CREATE TABLE IF NOT EXISTS `interlog` ( `id` INT NOT NULL AUTO_INCREMENT, `time` datetime NOT NULL, `log` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), INDEX `time` (`time`) ) ENGINE=MyISAM; -- -- Table structure for table `interreg` -- CREATE TABLE IF NOT EXISTS `interreg` ( `varname` varchar(11) NOT NULL, `value` varchar(20) NOT NULL, PRIMARY KEY (`varname`) ) ENGINE=InnoDB; -- -- Table structure for table `inventory` -- CREATE TABLE IF NOT EXISTS `inventory` ( `id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) unsigned NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` int(11) unsigned NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `favorite` tinyint(3) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', `equip_switch` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `ipbanlist` -- CREATE TABLE IF NOT EXISTS `ipbanlist` ( `list` varchar(15) NOT NULL default '', `btime` datetime NOT NULL, `rtime` datetime NOT NULL, `reason` varchar(255) NOT NULL default '', PRIMARY KEY (`list`, `btime`) ) ENGINE=MyISAM; -- -- Table structure for table `login` -- CREATE TABLE IF NOT EXISTS `login` ( `account_id` int(11) unsigned NOT NULL auto_increment, `userid` varchar(23) NOT NULL default '', `user_pass` varchar(32) NOT NULL default '', `sex` enum('M','F','S') NOT NULL default 'M', `email` varchar(39) NOT NULL default '', `group_id` tinyint(3) NOT NULL default '0', `state` int(11) unsigned NOT NULL default '0', `unban_time` int(11) unsigned NOT NULL default '0', `expiration_time` int(11) unsigned NOT NULL default '0', `logincount` mediumint(9) unsigned NOT NULL default '0', `lastlogin` datetime, `last_ip` varchar(100) NOT NULL default '', `birthdate` DATE, `character_slots` tinyint(3) unsigned NOT NULL default '0', `pincode` varchar(4) NOT NULL DEFAULT '', `pincode_change` int(11) unsigned NOT NULL DEFAULT '0', `vip_time` int(11) unsigned NOT NULL default '0', `old_group` tinyint(3) NOT NULL default '0', PRIMARY KEY (`account_id`), KEY `name` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=2000000; -- added standard accounts for servers, VERY INSECURE!!! -- inserted into the table called login which is above INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','[email protected]'); -- -- Table structure for table `mail` -- CREATE TABLE IF NOT EXISTS `mail` ( `id` bigint(20) unsigned NOT NULL auto_increment, `send_name` varchar(30) NOT NULL default '', `send_id` int(11) unsigned NOT NULL default '0', `dest_name` varchar(30) NOT NULL default '', `dest_id` int(11) unsigned NOT NULL default '0', `title` varchar(45) NOT NULL default '', `message` varchar(500) NOT NULL default '', `time` int(11) unsigned NOT NULL default '0', `status` tinyint(2) NOT NULL default '0', `zeny` int(11) unsigned NOT NULL default '0', `type` smallint(5) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM; -- ---------------------------- -- Table structure for `mail_attachments` -- ---------------------------- CREATE TABLE IF NOT EXISTS `mail_attachments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `index` smallint(5) unsigned NOT NULL DEFAULT '0', `nameid` smallint(5) unsigned NOT NULL DEFAULT '0', `amount` int(11) unsigned NOT NULL DEFAULT '0', `refine` tinyint(3) unsigned NOT NULL DEFAULT '0', `attribute` tinyint(4) unsigned NOT NULL DEFAULT '0', `identify` smallint(6) NOT NULL DEFAULT '0', `card0` smallint(5) unsigned NOT NULL DEFAULT '0', `card1` smallint(5) unsigned NOT NULL DEFAULT '0', `card2` smallint(5) unsigned NOT NULL DEFAULT '0', `card3` smallint(5) unsigned NOT NULL DEFAULT '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL DEFAULT '0', `bound` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`index`) ) ENGINE=MyISAM; -- -- Table structure for table `mapreg` -- CREATE TABLE IF NOT EXISTS `mapreg` ( `varname` varchar(32) binary NOT NULL, `index` int(11) unsigned NOT NULL default '0', `value` varchar(255) NOT NULL, PRIMARY KEY (`varname`,`index`) ) ENGINE=MyISAM; -- -- Table `market` for market shop persistency -- CREATE TABLE IF NOT EXISTS `market` ( `name` varchar(50) NOT NULL DEFAULT '', `nameid` SMALLINT(5) UNSIGNED NOT NULL, `price` INT(11) UNSIGNED NOT NULL, `amount` SMALLINT(5) UNSIGNED NOT NULL, `flag` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`name`,`nameid`) ) ENGINE = MyISAM; -- -- Table structure for table `memo` -- CREATE TABLE IF NOT EXISTS `memo` ( `memo_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) unsigned NOT NULL default '0', `map` varchar(11) NOT NULL default '', `x` smallint(4) unsigned NOT NULL default '0', `y` smallint(4) unsigned NOT NULL default '0', PRIMARY KEY (`memo_id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; -- -- Table structure for table `mercenary` -- CREATE TABLE IF NOT EXISTS `mercenary` ( `mer_id` int(11) unsigned NOT NULL auto_increment, `char_id` int(11) NOT NULL, `class` mediumint(9) unsigned NOT NULL default '0', `hp` int(11) unsigned NOT NULL default '0', `sp` int(11) unsigned NOT NULL default '0', `kill_counter` int(11) NOT NULL, `life_time` bigint(20) NOT NULL default '0', PRIMARY KEY (`mer_id`) ) ENGINE=MyISAM; -- -- Table structure for table `mercenary_owner` -- CREATE TABLE IF NOT EXISTS `mercenary_owner` ( `char_id` int(11) NOT NULL, `merc_id` int(11) NOT NULL default '0', `arch_calls` int(11) NOT NULL default '0', `arch_faith` int(11) NOT NULL default '0', `spear_calls` int(11) NOT NULL default '0', `spear_faith` int(11) NOT NULL default '0', `sword_calls` int(11) NOT NULL default '0', `sword_faith` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`) ) ENGINE=MyISAM; -- ---------------------------- -- Table structure for `sales` -- ---------------------------- CREATE TABLE IF NOT EXISTS `sales` ( `nameid` smallint(5) unsigned NOT NULL, `start` datetime NOT NULL, `end` datetime NOT NULL, `amount` int(11) NOT NULL, PRIMARY KEY (`nameid`) ) ENGINE=MyISAM; -- -- Table structure for table `sc_data` -- CREATE TABLE IF NOT EXISTS `sc_data` ( `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `type` smallint(11) unsigned NOT NULL, `tick` bigint(20) NOT NULL, `val1` int(11) NOT NULL default '0', `val2` int(11) NOT NULL default '0', `val3` int(11) NOT NULL default '0', `val4` int(11) NOT NULL default '0', PRIMARY KEY (`char_id`, `type`) ) ENGINE=MyISAM; -- -- Table structure for table `skillcooldown` -- CREATE TABLE IF NOT EXISTS `skillcooldown` ( `account_id` int(11) unsigned NOT NULL, `char_id` int(11) unsigned NOT NULL, `skill` smallint(11) unsigned NOT NULL DEFAULT '0', `tick` bigint(20) NOT NULL, PRIMARY KEY (`char_id`, `skill`) ) ENGINE=MyISAM; -- -- Table structure for table `party` -- CREATE TABLE IF NOT EXISTS `party` ( `party_id` int(11) unsigned NOT NULL auto_increment, `name` varchar(24) NOT NULL default '', `exp` tinyint(11) unsigned NOT NULL default '0', `item` tinyint(11) unsigned NOT NULL default '0', `leader_id` int(11) unsigned NOT NULL default '0', `leader_char` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`party_id`) ) ENGINE=MyISAM; -- -- Table structure for table `pet` -- CREATE TABLE IF NOT EXISTS `pet` ( `pet_id` int(11) unsigned NOT NULL auto_increment, `class` mediumint(9) unsigned NOT NULL default '0', `name` varchar(24) NOT NULL default '', `account_id` int(11) unsigned NOT NULL default '0', `char_id` int(11) unsigned NOT NULL default '0', `level` smallint(4) unsigned NOT NULL default '0', `egg_id` smallint(5) unsigned NOT NULL default '0', `equip` mediumint(8) unsigned NOT NULL default '0', `intimate` smallint(9) unsigned NOT NULL default '0', `hungry` smallint(9) unsigned NOT NULL default '0', `rename_flag` tinyint(4) unsigned NOT NULL default '0', `incubate` int(11) unsigned NOT NULL default '0', `autofeed` tinyint(2) NOT NULL default '0', PRIMARY KEY (`pet_id`) ) ENGINE=MyISAM; -- -- Table structure for table `quest` -- CREATE TABLE IF NOT EXISTS `quest` ( `char_id` int(11) unsigned NOT NULL default '0', `quest_id` int(10) unsigned NOT NULL, `state` enum('0','1','2') NOT NULL default '0', `time` int(11) unsigned NOT NULL default '0', `count1` mediumint(8) unsigned NOT NULL default '0', `count2` mediumint(8) unsigned NOT NULL default '0', `count3` mediumint(8) unsigned NOT NULL default '0', PRIMARY KEY (`char_id`,`quest_id`) ) ENGINE=MyISAM; -- -- Table structure for table `skill` -- CREATE TABLE IF NOT EXISTS `skill` ( `char_id` int(11) unsigned NOT NULL default '0', `id` smallint(11) unsigned NOT NULL default '0', `lv` tinyint(4) unsigned NOT NULL default '0', `flag` TINYINT(1) UNSIGNED NOT NULL default 0, PRIMARY KEY (`char_id`,`id`) ) ENGINE=MyISAM; -- -- Table structure for table `skill_homunculus` -- CREATE TABLE IF NOT EXISTS `skill_homunculus` ( `homun_id` int(11) NOT NULL, `id` int(11) NOT NULL, `lv` smallint(6) NOT NULL, PRIMARY KEY (`homun_id`,`id`) ) ENGINE=MyISAM; -- -- Table structure for table `storage` -- CREATE TABLE IF NOT EXISTS `storage` ( `id` int(11) unsigned NOT NULL auto_increment, `account_id` int(11) unsigned NOT NULL default '0', `nameid` smallint(5) unsigned NOT NULL default '0', `amount` smallint(11) unsigned NOT NULL default '0', `equip` int(11) unsigned NOT NULL default '0', `identify` smallint(6) unsigned NOT NULL default '0', `refine` tinyint(3) unsigned NOT NULL default '0', `attribute` tinyint(4) unsigned NOT NULL default '0', `card0` smallint(5) unsigned NOT NULL default '0', `card1` smallint(5) unsigned NOT NULL default '0', `card2` smallint(5) unsigned NOT NULL default '0', `card3` smallint(5) unsigned NOT NULL default '0', `option_id0` smallint(5) NOT NULL default '0', `option_val0` smallint(5) NOT NULL default '0', `option_parm0` tinyint(3) NOT NULL default '0', `option_id1` smallint(5) NOT NULL default '0', `option_val1` smallint(5) NOT NULL default '0', `option_parm1` tinyint(3) NOT NULL default '0', `option_id2` smallint(5) NOT NULL default '0', `option_val2` smallint(5) NOT NULL default '0', `option_parm2` tinyint(3) NOT NULL default '0', `option_id3` smallint(5) NOT NULL default '0', `option_val3` smallint(5) NOT NULL default '0', `option_parm3` tinyint(3) NOT NULL default '0', `option_id4` smallint(5) NOT NULL default '0', `option_val4` smallint(5) NOT NULL default '0', `option_parm4` tinyint(3) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `bound` tinyint(3) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; -- -- Table structure for table `vending_items` -- CREATE TABLE IF NOT EXISTS `vending_items` ( `vending_id` int(10) unsigned NOT NULL, `index` smallint(5) unsigned NOT NULL, `cartinventory_id` int(10) unsigned NOT NULL, `amount` smallint(5) unsigned NOT NULL, `price` int(10) unsigned NOT NULL, PRIMARY KEY (`vending_id`, `index`) ) ENGINE=MyISAM; -- -- Table structure for table `vendings` -- CREATE TABLE IF NOT EXISTS `vendings` ( `id` int(10) unsigned NOT NULL, `account_id` int(11) unsigned NOT NULL, `char_id` int(10) unsigned NOT NULL, `sex` enum('F','M') NOT NULL DEFAULT 'M', `map` varchar(20) NOT NULL, `x` smallint(5) unsigned NOT NULL, `y` smallint(5) unsigned NOT NULL, `title` varchar(80) NOT NULL, `body_direction` CHAR( 1 ) NOT NULL DEFAULT '4', `head_direction` CHAR( 1 ) NOT NULL DEFAULT '0', `sit` CHAR( 1 ) NOT NULL DEFAULT '1', `autotrade` tinyint(4) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.