main_mysql.sql

JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-

# Jathena++ Full Install SQL-Script(MySQL5.0 version)

# ========================================================
# Create database
# --------------------------------------------------------
create database `ragnarok`;
use ragnarok;


# ========================================================
# Create Table : `cart_inventory`
# --------------------------------------------------------
CREATE TABLE `cart_inventory` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `char_id` int(11) NOT NULL default '0',
  `nameid` int(11) NOT NULL default '0',
  `amount` int(11) NOT NULL default '0',
  `equip` mediumint(8) 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` int(11) NOT NULL default '0',
  `card1` int(11) NOT NULL default '0',
  `card2` int(11) NOT NULL default '0',
  `card3` int(11) NOT NULL default '0',
  `broken` bigint(20) unsigned NOT NULL default '0',
  `lockid` int(11) unsigned NOT NULL default '0',
  `exp` int(11) NOT NULL default '0',
  `endurance` int(11) unsigned NOT NULL default '0',
  `max_endurance` int(11) unsigned NOT NULL default '0',
  `sp_lv` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `char_id` (`char_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `char`
# --------------------------------------------------------
CREATE TABLE `char` (
  `char_id` int(11) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL default '0',
  `char_num` tinyint(4) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `class` int(11) NOT NULL default '0',
  `base_level` tinyint(4) unsigned NOT NULL default '1',
  `job_level` tinyint(4) unsigned NOT NULL default '1',
  `base_exp` bigint(20) NOT NULL default '0',
  `job_exp` bigint(20) NOT NULL default '0',
  `zeny` int(11) NOT NULL default '500',
  `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',
  `max_hp` int(11) NOT NULL default '0',
  `hp` int(11) NOT NULL default '0',
  `max_sp` int(11) NOT NULL default '0',
  `sp` int(11) NOT NULL default '0',
  `status_point` int(11) NOT NULL default '0',
  `skill_point` int(11) NOT NULL default '0',
  `option` int(11) NOT NULL default '0',
  `karma` int(11) NOT NULL default '0',
  `manner` int(11) NOT NULL default '0',
  `party_id` int(11) NOT NULL default '0',
  `guild_id` int(11) NOT NULL default '0',
  `pet_id` int(11) NOT NULL default '0',
  `hair` tinyint(4) NOT NULL default '0',
  `hair_color` int(11) NOT NULL default '0',
  `clothes_color` tinyint(4) NOT NULL default '0',
  `weapon` int(11) NOT NULL default '1',
  `shield` int(11) NOT NULL default '0',
  `head_top` int(11) NOT NULL default '0',
  `head_mid` int(11) NOT NULL default '0',
  `head_bottom` int(11) NOT NULL default '0',
  `last_map` varchar(20) NOT NULL default 'new_1-1.gat',
  `last_x` int(11) NOT NULL default '53',
  `last_y` int(11) NOT NULL default '111',
  `save_map` varchar(20) NOT NULL default 'new_1-1.gat',
  `save_x` int(11) NOT NULL default '53',
  `save_y` int(11) NOT NULL default '111',
  `partner_id` int(11) NOT NULL default '0',
  `parent_id` int(11) NOT NULL default '0',
  `parent_id2` int(11) NOT NULL default '0',
  `baby_id` int(11) NOT NULL default '0',
  `online` tinyint(4) NOT NULL default '0',
  `homun_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`char_id`),
  KEY `account_id` (`account_id`),
  KEY `party_id` (`party_id`),
  KEY `guild_id` (`guild_id`),
  KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=15000;


# ========================================================
# Create Table : `charlog`
# --------------------------------------------------------
CREATE TABLE `charlog` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `log` TEXT NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `friend`
# --------------------------------------------------------
CREATE TABLE `friend` (
  `char_id` int(11) NOT NULL default '0',
  `id1` int(11) NOT NULL default '0',
  `id2` int(11) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  KEY `char_id` (`char_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `global_reg_value`
# --------------------------------------------------------
CREATE TABLE `global_reg_value` (
  `char_id` int(11) NOT NULL default '0',
  `str` varchar(255) NOT NULL default '',
  `value` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '3',
  `account_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`char_id`,`str`,`account_id`),
  KEY `account_id` (`account_id`),
  KEY `char_id` (`char_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild`
# --------------------------------------------------------
CREATE TABLE `guild` (
  `guild_id` int(11) NOT NULL default '10000',
  `name` varchar(24) NOT NULL default '',
  `master` varchar(24) NOT NULL default '',
  `guild_lv` smallint(6) NOT NULL default '0',
  `connect_member` smallint(6) NOT NULL default '0',
  `max_member` smallint(6) NOT NULL default '0',
  `average_lv` smallint(6) NOT NULL default '0',
  `exp` int(11) NOT NULL default '0',
  `next_exp` int(11) NOT NULL default '0',
  `skill_point` int(11) NOT NULL default '0',
  `castle_id` int(11) NOT NULL default '-1',
  `mes1` varchar(60) NOT NULL default '',
  `mes2` varchar(120) NOT NULL default '',
  `emblem_len` int(11) NOT NULL default '0',
  `emblem_id` int(11) NOT NULL default '0',
  `emblem_data` blob NOT NULL,
  PRIMARY KEY  (`guild_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild_alliance`
# --------------------------------------------------------
CREATE TABLE `guild_alliance` (
  `guild_id` int(11) NOT NULL default '0',
  `opposition` int(11) NOT NULL default '0',
  `alliance_id` int(11) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  KEY `guild_id` (`guild_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild_castle`
# --------------------------------------------------------
CREATE TABLE `guild_castle` (
  `castle_id` int(11) NOT NULL default '0',
  `guild_id` int(11) NOT NULL default '0',
  `economy` int(11) NOT NULL default '0',
  `defense` int(11) NOT NULL default '0',
  `triggerE` int(11) NOT NULL default '0',
  `triggerD` int(11) NOT NULL default '0',
  `nextTime` int(11) NOT NULL default '0',
  `payTime` int(11) NOT NULL default '0',
  `createTime` int(11) NOT NULL default '0',
  `visibleC` int(11) NOT NULL default '0',
  `visibleG0` int(11) NOT NULL default '0',
  `visibleG1` int(11) NOT NULL default '0',
  `visibleG2` int(11) NOT NULL default '0',
  `visibleG3` int(11) NOT NULL default '0',
  `visibleG4` int(11) NOT NULL default '0',
  `visibleG5` int(11) NOT NULL default '0',
  `visibleG6` int(11) NOT NULL default '0',
  `visibleG7` int(11) NOT NULL default '0',
  `gHP0` int(11) NOT NULL default '0',
  `gHP1` int(11) NOT NULL default '0',
  `gHP2` int(11) NOT NULL default '0',
  `gHP3` int(11) NOT NULL default '0',
  `gHP4` int(11) NOT NULL default '0',
  `gHP5` int(11) NOT NULL default '0',
  `gHP6` int(11) NOT NULL default '0',
  `gHP7` int(11) NOT NULL default '0',
  PRIMARY KEY  (`castle_id`),
  KEY `guild_id` (`guild_id`)
) TYPE=MyISAM;

INSERT INTO `guild_castle` (`castle_id`) VALUES ('0');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('1');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('2');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('3');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('4');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('5');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('6');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('7');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('8');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('9');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('10');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('11');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('12');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('13');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('14');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('15');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('16');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('17');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('18');
INSERT INTO `guild_castle` (`castle_id`) VALUES ('19');


# ========================================================
# Create Table : `guild_expulsion`
# --------------------------------------------------------
CREATE TABLE `guild_expulsion` (
  `guild_id` int(11) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  `mes` varchar(40) NOT NULL default '',
  `acc` varchar(40) NOT NULL default '',
  `account_id` int(11) NOT NULL default '0',
  `rsv1` int(11) NOT NULL default '0',
  `rsv2` int(11) NOT NULL default '0',
  `rsv3` int(11) NOT NULL default '0',
  KEY `guild_id` (`guild_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild_member`
# --------------------------------------------------------
CREATE TABLE `guild_member` (
  `guild_id` int(11) NOT NULL default '0',
  `account_id` int(11) NOT NULL default '0',
  `char_id` int(11) NOT NULL default '0',
  `hair` smallint(6) NOT NULL default '0',
  `hair_color` smallint(6) NOT NULL default '0',
  `gender` smallint(6) NOT NULL default '0',
  `class` smallint(6) NOT NULL default '0',
  `lv` smallint(6) NOT NULL default '0',
  `exp` bigint(20) NOT NULL default '0',
  `exp_payper` int(11) NOT NULL default '0',
  `online` tinyint(4) NOT NULL default '0',
  `position` smallint(6) NOT NULL default '0',
  `rsv1` int(11) NOT NULL default '0',
  `rsv2` int(11) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  KEY `char_id` (`char_id`),
  KEY `guild_id` (`guild_id`),
  KEY `account_id` (`account_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild_position`
# --------------------------------------------------------
CREATE TABLE `guild_position` (
  `guild_id` int(11) NOT NULL default '0',
  `position` smallint(6) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  `mode` int(11) NOT NULL default '0',
  `exp_mode` int(11) NOT NULL default '0',
  KEY `guild_id` (`guild_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild_skill`
# --------------------------------------------------------
CREATE TABLE `guild_skill` (
  `guild_id` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL default '0',
  `lv` int(11) NOT NULL default '0',
  KEY `guild_id` (`guild_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `guild_storage`
# --------------------------------------------------------
CREATE TABLE `guild_storage` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `guild_id` int(11) NOT NULL default '0',
  `nameid` int(11) NOT NULL default '0',
  `amount` int(11) NOT NULL default '0',
  `equip` mediumint(8) 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` int(11) NOT NULL default '0',
  `card1` int(11) NOT NULL default '0',
  `card2` int(11) NOT NULL default '0',
  `card3` int(11) NOT NULL default '0',
  `broken` bigint(20) unsigned NOT NULL default '0',
  `lockid` int(11) unsigned NOT NULL default '0',
  `exp` int(11) NOT NULL default '0',
  `endurance` int(11) unsigned NOT NULL default '0',
  `max_endurance` int(11) unsigned NOT NULL default '0',
  `sp_lv` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `guild_id` (`guild_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `homunculus`