summaryrefslogtreecommitdiff
path: root/sql-files/main-new.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/main-new.sql')
-rw-r--r--sql-files/main-new.sql559
1 files changed, 559 insertions, 0 deletions
diff --git a/sql-files/main-new.sql b/sql-files/main-new.sql
new file mode 100644
index 000000000..5f8c2a145
--- /dev/null
+++ b/sql-files/main-new.sql
@@ -0,0 +1,559 @@
+#-------------------------
+#
+# LOGIN SERVER DATABASE
+#
+#-------------------------
+
+# Database: Ragnarok
+# Table: 'login'
+#
+
+CREATE TABLE `login` (
+ `account_id` mediumint(7) UNSIGNED NOT NULL AUTO_INCREMENT,
+ `userid` varchar(32) NOT NULL default '',
+ `user_pass` varchar(32) NOT NULL default '',
+ `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
+ `logincount` smallint(4) UNSIGNED NOT NULL default '0',
+ `sex` CHAR NOT NULL default 'M',
+ `email` varchar(60) NOT NULL default '',
+ `level` tinyint(2) UNSIGNED NOT NULL default '0',
+ `connect_until` int(11) UNSIGNED NOT NULL default '0',
+ `last_ip` varchar(15) NOT NULL default '',
+ `ban_until` int(11) UNSIGNED NOT NULL default '0',
+ `state` tinyint(2) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`account_id`),
+ INDEX (`account_id`,`userid`),
+) TYPE=INNODB 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','athena@athena.com');
+INSERT INTO `login` (`account_id`, `userid`, `user_pass`, `sex`, `email`) VALUES ('2', 's2', 'p2', 'S','athena@athena.com');
+
+# Database: Ragnarok
+# Table: 'login_error'
+#
+CREATE TABLE `login_error` (
+ `err_id` tinyint(2) UNSIGNED NOT NULL default '0',
+ `reason` varchar(100) NOT NULL default 'Unknown',
+ PRIMARY KEY (`err_id`),
+ INDEX (`err_id`)
+) TYPE=MyISAM;
+
+# Database: Ragnarok
+# Table: 'loginlog'
+#
+CREATE TABLE `loginlog` (
+ `time` datetime NOT NULL default '0000-00-00 00:00:00',
+ `ip` varchar(15) NOT NULL default '',
+ `user` varchar(32) NOT NULL default '',
+ `rcode` tinyint(4) NOT NULL default '0',
+ `log` varchar(255) NOT NULL default ''
+) TYPE=MyISAM;
+
+
+# Database: Ragnarok
+# Table: 'ragsrvinfo'
+#
+CREATE TABLE `ragsrvinfo` (
+ `index` tinyint(2) UNSIGNED NOT NULL default '0',
+ `name` varchar(16) NOT NULL default '',
+ `exp` smallint(4) UNSIGNED NOT NULL default '0',
+ `jexp` smallint(4) UNSIGNED NOT NULL default '0',
+ `drop` tinyint(2) UNSIGNED NOT NULL default '0',
+ `motd` varchar(255) NOT NULL default ''
+) TYPE=MyISAM;
+
+# Database: Ragnarok
+# Table: 'sstatus'
+#
+CREATE TABLE `sstatus` (
+ `index` tinyint(4) NOT NULL default '0',
+ `name` varchar(255) NOT NULL default '',
+ `user` smallint(3) UNSIGNED NOT NULL default '0'
+) TYPE=MyISAM;
+
+# Database: Ragnarok
+# Table: 'interlog'
+#
+CREATE TABLE `interlog` (
+ `time` datetime NOT NULL default '0000-00-00 00:00:00',
+ `log` varchar(255) NOT NULL default ''
+) TYPE=MyISAM;
+
+# Database: Ragnarok
+# 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;
+
+
+# Database: Rangarok
+# Table: 'errors'
+#
+CREATE TABLE `errors` (
+ `result` tinyint(3) UNSIGNED NOT NULL,
+ `error` varchar(20) NOT NULL,
+ INDEX (`result`)
+) TYPE=MyISAM;
+
+INSERT INTO `errors` (`result`,`error`) VALUES
+('1','Unregistered ID'),
+('2','Incorrect Password'),
+('3','Account Expired'),
+('4','Rejected from Server'),
+('5','Blocked by GM'),
+('6','Not latest game EXE'),
+('7','Banned'),
+('8','Server OverPopulated'),
+('9',''),
+('100','Account Gone');
+
+##########################
+#
+# Inter server / Char server databases
+# By CLOWNISIUS aka Anthony
+#
+##########################
+
+# Database: Ragnarok
+# Table: 'party'
+#
+CREATE TABLE `party` (
+ `party_id` smallint(3) UNSIGNED NOT NULL default '100',
+ `name` varchar(100) NOT NULL default '',
+ `exp` int(11) UNSIGNED NOT NULL default '0',
+ `item` int(11) UNSIGNED NOT NULL default '0',
+ `leader_id` smallint(4) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`party_id`),
+ INDEX (`party_id`,`leader_id`)
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'char'
+#
+CREATE TABLE `char` (
+ `char_id` mediumint(6) UNSIGNED NOT NULL auto_increment,
+ `account_id` mediumint(7) UNSIGNED NOT NULL default '0',
+ `char_num` tinyint(1) UNSIGNED NOT NULL default '0',
+ `name` varchar(32) NOT NULL default '',
+ `class` smallint(4) UNSIGNED NOT NULL default '0',
+ `base_level` tinyint(3) UNSIGNED NOT NULL default '1',
+ `job_level` tinyint(3) UNSIGNED NOT NULL default '1',
+ `base_exp` int(9) UNSIGNED NOT NULL default '0',
+ `job_exp` int(9) UNSIGNED NOT NULL default '0',
+ `zeny` int(11) UNSIGNED NOT NULL default '500',
+ `str` tinyint(3) UNSIGNED NOT NULL default '0',
+ `agi` tinyint(3) UNSIGNED NOT NULL default '0',
+ `vit` tinyint(3) UNSIGNED NOT NULL default '0',
+ `int` tinyint(3) UNSIGNED NOT NULL default '0',
+ `dex` tinyint(3) UNSIGNED NOT NULL default '0',
+ `luk` tinyint(3) UNSIGNED NOT NULL default '0',
+ `max_hp` smallint(5) UNSIGNED NOT NULL default '0',
+ `hp` smallint(5) UNSIGNED NOT NULL default '0',
+ `max_sp` smallint(5) UNSIGNED NOT NULL default '0',
+ `sp` smallint(5) UNSIGNED NOT NULL default '0',
+ `status_point` smallint(4) UNSIGNED NOT NULL default '0',
+ `skill_point` smallint(4) UNSIGNED NOT NULL default '0',
+ `option` smallint(5) UNSIGNED NOT NULL default '0',
+ `karma` tinyint(3) UNSIGNED NOT NULL default '0',
+ `manner` tinyint(3) UNSIGNED NOT NULL default '0',
+ `party_id` smallint(3) UNSIGNED NULL,
+ `guild_id` smallint(5) UNSIGNED NULL,
+ `pet_id` smallint(4) UNSIGNED NOT NULL default '0',
+ `hair` tinyint(3) UNSIGNED NOT NULL default '0',
+ `hair_color` tinyint(3) UNSIGNED NOT NULL default '0',
+ `clothes_color` tinyint(3) UNSIGNED NOT NULL default '0',
+ `weapon` tinyint(3) UNSIGNED NOT NULL default '1',
+ `shield` tinyint(3) UNSIGNED NOT NULL default '0',
+ `head_top` tinyint(3) UNSIGNED NOT NULL default '0',
+ `head_mid` tinyint(3) UNSIGNED NOT NULL default '0',
+ `head_bottom` tinyint(3) UNSIGNED NOT NULL default '0',
+ `last_map` varchar(20) NOT NULL default 'new_5-1.gat',
+ `last_x` smallint(3) UNSIGNED NOT NULL default '53',
+ `last_y` smallint(3) UNSIGNED NOT NULL default '111',
+ `save_map` varchar(20) NOT NULL default 'new_5-1.gat',
+ `save_x` smallint(3) UNSIGNED NOT NULL default '53',
+ `save_y` smallint(3) UNSIGNED NOT NULL default '111',
+ `partner_id` mediumint(6) UNSIGNED NULL,
+ `online` tinyint(1) NOT NULL default '0',
+ PRIMARY KEY (`char_id`,`account_id`),
+ INDEX (`account_id`,`char_id`,`name`),
+ KEY (`partner_id`),
+ KEY (`party_id`),
+ KEY (`guild_id`),
+ FOREIGN KEY (`account_id`) REFERENCES `login` (`account_id`) ON DELETE CASCADE ON UPDATE CASCADE,
+ FOREIGN KEY (`partner_id`) REFERENCES `char` (`char_id`) ON DELETE SET NULL
+) TYPE=INNODB AUTO_INCREMENT=150001;
+
+CREATE TABLE `friend` (
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `position` tinyint(1) UNSIGNED NOT NULL default '0',
+ `friend_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `friend_name` varchar(32) NOT NULL default '',
+ PRIMARY KEY (`char_id`,`friend_id`),
+ INDEX (`char_id`),
+ INDEX (`friend_id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE,
+ FOREIGN KEY (`friend_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=InnoDB;
+
+# Database: Ragnarok
+# Table: 'global_reg_value'
+#
+CREATE TABLE `global_reg_value` (
+ `char_id` mediumint(6) UNSIGNED,
+ `str` varchar(255) NOT NULL default '',
+ `value` varchar(255) NOT NULL default '0',
+ `type` tinyint(3) UNSIGNED NOT NULL default '3',
+ `account_id` mediumint(7) UNSIGNED,
+ PRIMARY KEY (`char_id`,`str`,`account_id`),
+ INDEX (`account_id`),
+ INDEX (`char_id`),
+ FOREIGN KEY (`account_id`) REFERENCES `login`(`account_id`) ON DELETE CASCADE,
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+## Cannot use due to char and account load from same database, saving will be done to diferent DBs soon.
+## so that dependencies can be placed in.
+
+# Login register value.
+#
+
+CREATE TABLE `account_reg_value` (
+ `account_id` mediumint(7) UNSIGNED,
+ `str` varchar(255) NOT NULL default '',
+ `value` varchar(255) NOT NULL default '0',
+ KEY (`account_id`, `str`),
+ FOREIGN KEY (`account_id`) REFERENCES `login`(`account_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Character register value.
+#
+
+CREATE TABLE `char_reg_value` (
+ `char_id` mediumint(6) UNSIGNED,
+ `str` varchar(255) NOT NULL default '',
+ `value` varchar(255) NOT NULL default '0',
+ PRIMARY KEY (`char_id`, `str`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+
+# Database: Ragnarok
+# Table: 'inventory'
+#
+CREATE TABLE `inventory` (
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `id` smallint(4) UNSIGNED NOT NULL auto_increment,
+ `nameid` smallint(4) UNSIGNED NOT NULL default '0',
+ `amount` tinyint(3) UNSIGNED NOT NULL default '0',
+ `equip` smallint(5) UNSIGNED NOT NULL default '0',
+ `identify` tinyint(1) UNSIGNED NOT NULL default '0',
+ `refine` tinyint(1) UNSIGNED NOT NULL default '0',
+ `attribute` tinyint(3) UNSIGNED NOT NULL default '0',
+ `card0` smallint(4) UNSIGNED NOT NULL default '0',
+ `card1` smallint(4) UNSIGNED NOT NULL default '0',
+ `card2` smallint(4) UNSIGNED NOT NULL default '0',
+ `card3` smallint(4) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`id`,`char_id`),
+ INDEX(`char_id`,`id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'memo'
+#
+CREATE TABLE `memo` (
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `memo_id` smallint(4) UNSIGNED NOT NULL default '0',
+ `map` varchar(20) NOT NULL default '',
+ `x` smallint(3) UNSIGNED NOT NULL default '0',
+ `y` smallint(3) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`char_id`,`memo_id`),
+ INDEX (`char_id`,`memo_id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'pet'
+#
+CREATE TABLE `pet` (
+ `pet_id` smallint(4) UNSIGNED NOT NULL default '0',
+ `class` smallint(4) UNSIGNED NOT NULL default '0',
+ `name` varchar(24) NOT NULL default '',
+ `account_id` mediumint(7) UNSIGNED NOT NULL default '0',
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `level` tinyint(3) UNSIGNED NOT NULL default '0',
+ `egg_id` smallint(4) UNSIGNED NOT NULL default '0',
+ `equip` smallint(5) UNSIGNED NOT NULL default '0',
+ `intimate` smallint(4) UNSIGNED NOT NULL default '0',
+ `hungry` tinyint(3) UNSIGNED NOT NULL default '0',
+ `rename_flag` tinyint(1) UNSIGNED NOT NULL default '0',
+ `incuvate` tinyint(1) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`char_id`,`pet_id`),
+ INDEX (`char_id`,`pet_id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'skill'
+#
+CREATE TABLE `skill` (
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `id` smallint(3) UNSIGNED NOT NULL default '0',
+ `lv` tinyint(3) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`char_id`,`id`),
+ INDEX (`char_id`,`id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'cart_inventory'
+#
+CREATE TABLE `cart_inventory` (
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `id` smallint(4) UNSIGNED NOT NULL auto_increment,
+ `nameid` smallint(4) UNSIGNED NOT NULL default '0',
+ `amount` tinyint(3) UNSIGNED NOT NULL default '0',
+ `equip` smallint(5) UNSIGNED NOT NULL default '0',
+ `identify` tinyint(1) UNSIGNED NOT NULL default '0',
+ `refine` tinyint(1) UNSIGNED NOT NULL default '0',
+ `attribute` tinyint(4) UNSIGNED NOT NULL default '0',
+ `card0` smallint(4) UNSIGNED NOT NULL default '0',
+ `card1` smallint(4) UNSIGNED NOT NULL default '0',
+ `card2` smallint(4) UNSIGNED NOT NULL default '0',
+ `card3` smallint(4) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`id`,`char_id`),
+ INDEX (`char_id`,`id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char`(`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'storage'
+#
+CREATE TABLE `storage` (
+ `account_id` mediumint(7) UNSIGNED NOT NULL default '0',
+ `id` smallint(4) UNSIGNED NOT NULL default '0',
+ `nameid` smallint(4) UNSIGNED NOT NULL default '0',
+ `amount` tinyint(3) UNSIGNED NOT NULL default '0',
+ `equip` smallint(5) UNSIGNED NOT NULL default '0',
+ `identify` tinyint(1) UNSIGNED NOT NULL default '0',
+ `refine` tinyint(1) UNSIGNED NOT NULL default '0',
+ `attribute` tinyint(4) UNSIGNED NOT NULL default '0',
+ `card0` smallint(4) UNSIGNED NOT NULL default '0',
+ `card1` smallint(4) UNSIGNED NOT NULL default '0',
+ `card2` smallint(4) UNSIGNED NOT NULL default '0',
+ `card3` smallint(4) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`account_id`,`id`),
+ INDEX (`account_id`,`id`),
+ FOREIGN KEY (`account_id`) REFERENCES `login` (`account_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+##########################
+#
+# Inter server / Guild server databases
+# By CLOWNISIUS aka Anthony
+#
+##########################
+
+
+# Database: Ragnarok
+# Table: 'guild'
+#
+CREATE TABLE `guild` (
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '10000',
+ `name` varchar(24) NOT NULL default '',
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '10000',
+ `master` varchar(24) NOT NULL default '',
+ `guild_lv` tinyint(3) UNSIGNED NOT NULL default '0',
+ `connect_member` tinyint(3) UNSIGNED NOT NULL default '0',
+ `max_member` tinyint(3) UNSIGNED NOT NULL default '0',
+ `average_lv` tinyint(3) UNSIGNED NOT NULL default '0',
+ `exp` int(9) UNSIGNED NOT NULL default '0',
+ `next_exp` int(9) UNSIGNED NOT NULL default '0',
+ `skill_point` smallint(4) UNSIGNED NOT NULL default '0',
+ `castle_id` smallint(5) UNSIGNED NOT NULL default '-1',
+ `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 NOT NULL,
+ PRIMARY KEY (`guild_id`,`char_id`),
+ INDEX (`char_id`,`guild_id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char`(`char_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+
+CREATE TABLE `guild_alliance` (
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `opposition` smallint(5) UNSIGNED NOT NULL default '0',
+ `alliance_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `name` varchar(24) NOT NULL default '',
+ PRIMARY KEY (`guild_id`,`alliance_id`),
+ INDEX (`guild_id`),
+ INDEX (`alliance_id`),
+ FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE,
+ FOREIGN KEY (`alliance_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'guild_castle'
+#
+CREATE TABLE `guild_castle` (
+ `castle_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `guild_id` smallint(5) UNSIGNED 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` smallint(5) UNSIGNED NOT NULL default '0',
+ `ghP1` smallint(5) UNSIGNED NOT NULL default '0',
+ `gHP2` smallint(5) UNSIGNED NOT NULL default '0',
+ `gHP3` smallint(5) UNSIGNED NOT NULL default '0',
+ `gHP4` smallint(5) UNSIGNED NOT NULL default '0',
+ `gHP5` smallint(5) UNSIGNED NOT NULL default '0',
+ `gHP6` smallint(5) UNSIGNED NOT NULL default '0',
+ `gHP7` smallint(5) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`castle_id`),
+ INDEX (`guild_id`,`castle_id`),
+ FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'guild_expulsion'
+#
+CREATE TABLE `guild_expulsion` (
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `name` varchar(24) NOT NULL default '',
+ `mes` varchar(40) NOT NULL default '',
+ `acc` varchar(40) NOT NULL default '',
+ `account_id` mediumint(7) UNSIGNED 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',
+ PRIMARY KEY (`guild_id`,`name`),
+ INDEX (`guild_id`,`name`),
+ FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+
+##########################
+#
+# Linked Database to the CHAR section and LOGIN
+#
+##########################
+
+# Database: Ragnarok
+# Table: 'guild_member'
+#
+
+CREATE TABLE `guild_member` (
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `account_id` mediumint(7) UNSIGNED NOT NULL default '0',
+ `char_id` mediumint(6) UNSIGNED NOT NULL default '0',
+ `hair` tinyint(3) UNSIGNED NOT NULL default '0',
+ `hair_color` tinyint(3) UNSIGNED NOT NULL default '0',
+ `gender` tinyint(3) UNSIGNED NOT NULL default '0',
+ `class` smallint(4) UNSIGNED NOT NULL default '0',
+ `lv` tinyint(3) UNSIGNED NOT NULL default '0',
+ `exp` int(9) UNSIGNED NOT NULL default '0',
+ `exp_payper` int(9) UNSIGNED NOT NULL default '0',
+ `online` tinyint(1) UNSIGNED NOT NULL default '0',
+ `position` smallint(6) UNSIGNED NOT NULL default '0',
+ `rsv1` int(11) UNSIGNED NOT NULL default '0',
+ `rsv2` int(11) UNSIGNED NOT NULL default '0',
+ `name` varchar(24) NOT NULL default '',
+ PRIMARY KEY (`guild_id`,`char_id`),
+ INDEX (`guild_id`),
+ INDEX (`char_id`),
+ FOREIGN KEY (`char_id`) REFERENCES `char` (`char_id`) ON DELETE CASCADE,
+ FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'guild_position'
+#
+CREATE TABLE `guild_position` (
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `position` smallint(5) UNSIGNED NOT NULL default '0',
+ `name` varchar(24) NOT NULL default '',
+ `mode` int(11) UNSIGNED NOT NULL default '0',
+ `exp_mode` int(11) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`guild_id`),
+ INDEX (`guild_id`),
+ FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'guild_skill'
+#
+CREATE TABLE `guild_skill` (
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `id` smallint(4) UNSIGNED NOT NULL default '0',
+ `lv` tinyint(3) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`guild_id`,`id`),
+ INDEX (`guild_id`,`id`),
+ FOREIGN KEY (`guild_id`) REFERENCES `guild`(`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+# Database: Ragnarok
+# Table: 'guild_storage'
+#
+CREATE TABLE `guild_storage` (
+ `id` mediumint(5) UNSIGNED NOT NULL auto_increment,
+ `guild_id` smallint(5) UNSIGNED NOT NULL default '0',
+ `nameid` smallint(4) UNSIGNED NOT NULL default '0',
+ `amount` tinyint(3) UNSIGNED NOT NULL default '0',
+ `equip` smallint(5) UNSIGNED NOT NULL default '0',
+ `identify` tinyint(1) UNSIGNED NOT NULL default '0',
+ `refine` tinyint(1) UNSIGNED NOT NULL default '0',
+ `attribute` tinyint(4) UNSIGNED NOT NULL default '0',
+ `card0` smallint(4) UNSIGNED NOT NULL default '0',
+ `card1` smallint(4) UNSIGNED NOT NULL default '0',
+ `card2` smallint(4) UNSIGNED NOT NULL default '0',
+ `card3` smallint(4) UNSIGNED NOT NULL default '0',
+ PRIMARY KEY (`guild_id`,`id`),
+ INDEX (`id`,`guild_id`),
+ FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE CASCADE
+) TYPE=INNODB;
+
+
+# Database: Ragnarok
+# Table: 'charlog'
+#
+CREATE TABLE `charlog` (
+ `time` datetime NOT NULL default '0000-00-00 00:00:00',
+ `char_msg` varchar(255) NOT NULL default 'char select',
+ `account_id` mediumint(7) UNSIGNED NOT NULL default '0',
+ `char_num` tinyint(1) UNSIGNED NOT NULL default '0',
+ `name` varchar(255) NOT NULL default '',
+ `str` tinyint(3) UNSIGNED NOT NULL default '0',
+ `agi` tinyint(3) UNSIGNED NOT NULL default '0',
+ `vit` tinyint(3) UNSIGNED NOT NULL default '0',
+ `int` tinyint(3) UNSIGNED NOT NULL default '0',
+ `dex` tinyint(3) UNSIGNED NOT NULL default '0',
+ `luk` tinyint(3) UNSIGNED NOT NULL default '0',
+ `hair` tinyint(3) UNSIGNED NOT NULL default '0',
+ `hair_color` tinyint(3) UNSIGNED NOT NULL default '0'
+) TYPE=MyISAM;
+
+ALTER TABLE `char` ADD FOREIGN KEY (`party_id`) REFERENCES `party` (`party_id`) ON DELETE SET NULL ON UPDATE SET NULL;
+ALTER TABLE `char` ADD FOREIGN KEY (`guild_id`) REFERENCES `guild` (`guild_id`) ON DELETE SET NULL ON UPDATE SET NULL; \ No newline at end of file
generated by cgit v1.2.3-70-g09d2 (git 2.46.0) at 2025-04-30 00:55:37 +0000