📄 main_mysql.sql

📁 JA++的最新...很多ROSF都用这个 ] 是个不错的东西-3-
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
# --------------------------------------------------------
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',
  `base_exp` bigint(20) 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;


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


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


# ========================================================
# Create Table : `inventory`
# --------------------------------------------------------
CREATE TABLE `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`,`nameid`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `ipbanlist`
# --------------------------------------------------------
CREATE TABLE `ipbanlist` (
  `list` varchar(255) NOT NULL default '',
  `btime` datetime NOT NULL default '0000-00-00 00:00:00',
  `rtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `reason` varchar(255) NOT NULL default ''
) TYPE=MyISAM;


# ========================================================
# Create Table : `login`
# --------------------------------------------------------
CREATE TABLE `login` (
  `account_id` int(11) NOT NULL auto_increment,
  `userid` varchar(255) NOT NULL default '',
  `user_pass` varchar(32) NOT NULL default '',
  `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `sex` char(1) NOT NULL default 'M',
  `logincount` mediumint(9) NOT NULL default '0',
  `email` varchar(60) NOT NULL default '',
  `level` smallint(3) NOT NULL default '0',
  `error_message` int(11) NOT NULL default '0',
  `connect_until` int(11) NOT NULL default '0',
  `last_ip` varchar(100) NOT NULL default '',
  `memo` int(11) NOT NULL default '0',
  `ban_until` int(11) NOT NULL default '0',
  `state` int(11) NOT NULL default '0',
  `reg_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `ask` varchar(255) default NULL,
  `answer` varchar(255) default NULL,
  PRIMARY KEY  (`account_id`),
  KEY `userid` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=2000001;

INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('1', 's1', 'p1', 'S','athena@athena.com');


# ========================================================
# Create Table : `login_error`
# --------------------------------------------------------
CREATE TABLE `login_error` (
  `err_id` int(11) NOT NULL default '0',
  `reason` varchar(100) NOT NULL default 'Unknown',
  PRIMARY KEY  (`err_id`)
) TYPE=MyISAM;


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


# ========================================================
# Create Table : `memo`
# --------------------------------------------------------
CREATE TABLE `memo` (
  `memo_id` bigint(20) NOT NULL auto_increment,
  `char_id` int(11) NOT NULL default '0',
  `type` char(1) NOT NULL default '',
  `map` varchar(255) NOT NULL default '',
  `x` mediumint(9) NOT NULL default '-1',
  `y` mediumint(9) NOT NULL default '-1',
  PRIMARY KEY  (`memo_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `party`
# --------------------------------------------------------
CREATE TABLE `party` (
  `party_id` int(11) NOT NULL default '100',
  `name` varchar(100) NOT NULL default '',
  `exp` int(11) NOT NULL default '0',
  `item` int(11) NOT NULL default '0',
  `leader_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`party_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `pet`
# --------------------------------------------------------
CREATE TABLE `pet` (
  `pet_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',
  `level` tinyint(4) NOT NULL default '0',
  `egg_id` 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  (`pet_id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `ragsrvinfo`
# --------------------------------------------------------
CREATE TABLE `ragsrvinfo` (
  `index` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `exp` int(11) NOT NULL default '0',
  `jexp` int(11) NOT NULL default '0',
  `drop` int(11) NOT NULL default '0',
  `motd` varchar(255) NOT NULL default ''
) TYPE=MyISAM;


# ========================================================
# Create Table : `skill`
# --------------------------------------------------------
CREATE TABLE `skill` (
  `char_id` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL default '0',
  `lv` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`char_id`,`id`),
  KEY `char_id` (`char_id`),
  KEY `id` (`id`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `sstatus`
# --------------------------------------------------------
CREATE TABLE `sstatus` (
  `index` tinyint(4) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`index`)
) TYPE=MyISAM;


# ========================================================
# Create Table : `storage`
# --------------------------------------------------------
CREATE TABLE `storage` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `account_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 `account_id` (`account_id`)
) TYPE=MyISAM;

# ========================================================
# Create Table : `status_change`
# --------------------------------------------------------
CREATE TABLE `status_change` (
  `char_id` int(11) NOT NULL default '0',
  `account_id` int(11) NOT NULL default '0',
  `type` mediumint(9) NOT NULL default '0',
  `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',
  `tick` int(11) NOT NULL default '0',
  KEY `char_id` (`char_id`)
) TYPE=MyISAM;

# ========================================================
# Create Table : `hotkey`
# --------------------------------------------------------
CREATE TABLE `hotkey` (
  `char_id` int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  `hotkey` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL default '0',
  `skill_lv` int(11) NOT NULL default '0',
  KEY `char_id` (`char_id`)
) TYPE=MyISAM;

# ========================================================
# Create Table : `mail`
# --------------------------------------------------------
CREATE TABLE `mail` (
  `char_id` int(11) NOT NULL default '0',
  `account_id` int(11) NOT NULL default '0',
  `rates` int(11) NOT NULL default '0',
  `store` int(11) NOT NULL default '0',
  PRIMARY KEY  (`char_id`,`account_id`)
) TYPE=MyISAM;

# ========================================================
# Create Table : `mail_data`
# --------------------------------------------------------
CREATE TABLE `mail_data` (
  `char_id` int(11) NOT NULL default '0',
  `mail_num` int(11) NOT NULL default '0',
  `read` int(11) NOT NULL default '0',
  `char_name` varchar(24) NOT NULL default '',
  `receive_name` varchar(24) NOT NULL default '',
  `title` varchar(40) NOT NULL default '',
  `zeny` 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',
  `times` int(11) unsigned NOT NULL default '0',
  `body_size` int(11) unsigned NOT NULL default '0',
  `body` varchar(1024) NOT NULL default ''
) TYPE=MyISAM;
上一页 12
💿 文件大小 7557 K
👤 上传用户 johni
📂 所属分类文章/文档
🏷️ 相关标签

#ROSF #JA
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -