1881-1901.sql

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

# rename field of incuvate to incubate in pet table
ALTER TABLE `pet` CHANGE `incuvate` `incubate` int(11) NOT NULL default '0';

# add homun_id
ALTER TABLE `char` ADD `homun_id` INT( 11 ) NOT NULL DEFAULT '0';

# Database: Ragnarok
# Table: 'homunculus'
# 
CREATE TABLE `homunculus` (
  `homun_id` int(11) NOT NULL auto_increment,
  `class` mediumint(9) NOT NULL default '0',
  `name` varchar(24) NOT NULL default '',
  `account_id` int(11) NOT NULL default '0',
  `char_id` int(11) NOT NULL default '0',
  `base_level` tinyint(4) 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',
  `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',
  `status_point` int(11) NOT NULL default '0',
  `skill_point` int(11) NOT NULL default '0',
  `equip` mediumint(8) unsigned NOT NULL default '0',
  `intimate` mediumint(9) NOT NULL default '0',
  `hungry` mediumint(9) NOT NULL default '0',
  `rename_flag` tinyint(4) NOT NULL default '0',
  `incubate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`homun_id`)
) TYPE=MyISAM;