SQL

===================================================================
--- dist/sql/character_offline_buffshop.sql	(revision 0)
+++ dist/sql/character_offline_buffshop.sql	(working copy)
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS `character_offline_buffshop`;
+CREATE TABLE `character_offline_buffshop` (
+  `charid` int(10) unsigned NOT NULL,
+  `time` bigint(13) unsigned NOT NULL DEFAULT '0',
+  `title` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`charid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Index: dist/sql/characters.sql
===================================================================
--- dist/sql/characters.sql	(revision 3)
+++ dist/sql/characters.sql	(working copy)
@@ -54,6 +54,7 @@
   `clan_join_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   `clan_create_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   `death_penalty_level` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
+  `buffshop_slots` tinyint(3) unsigned NOT NULL DEFAULT '24',
   PRIMARY KEY (obj_Id),
   KEY `clanid` (`clanid`)
 );
===================================================================
--- dist/sql/character_offline_buffshop_skills.sql	(revision 0)
+++ dist/sql/character_offline_buffshop_skills.sql	(working copy)
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS `character_offline_buffshop_skills`;
+CREATE TABLE `character_offline_buffshop_skills` (
+  `charid` int(10) unsigned NOT NULL,
+  `item` int(10) unsigned NOT NULL DEFAULT '0',
+  `price` bigint(20) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`charid`,`item`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;