CREATE TABLE IF NOT EXISTS `roster_guildvault_addonconfig` ( `config_id` int(5) NOT NULL auto_increment, `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', `config_form_type` mediumtext NOT NULL, PRIMARY KEY (`config_id`), KEY `config_name` (`config_name`) ) ENGINE=MyISAM; INSERT INTO `roster_guildvault_addonconfig` (`config_id`, `config_name`, `config_value`, `config_form_type`) VALUES (1, 'updateguildvault', '1', 'radio{on^1|off^0'), (2, 'debug', '0', 'radio{on^1|off^0'), (3, 'show_like_ingame', '1', 'radio{on^1|off^0'), (4, 'stack_items', '0', 'radio{on^1|off^0'), (5, 'show_tabs', '1', 'radio{Single^1|Multi^0'), (6, 'use_javascript', '1', 'radio{on^1|off^0'), (7, 'public_log', '0', 'radio{public^1|password required^0'), (8, 'public_order', '0', 'radio{public^1|password required^0'), (9, 'enable_order_system', '1', 'radio{on^1|off^0'), (10, 'background_images_path', './addons/guildvault/images/', 'text{255|255'), (11, 'icons_image_path', '', 'text{255|255'), (12, 'password', 'f9ed9eba4873da02a0bbd3176fb57549', 'text{255|255'), (13, 'use_allakhazam', '0', 'radio{on^1|off^0'), (14, 'use_thottbot', '0', 'radio{on^1|off^0'), (15, 'use_buffed', '0', 'radio{on^1|off^0'), (16, 'use_speedydragon', '0', 'radio{on^1|off^0'), (17, 'show_prices', '1', 'radio{on^1|off^0'); CREATE TABLE IF NOT EXISTS `roster_guildvault_config` ( `tab` varchar(100) NOT NULL default '', `name` varchar(255) NOT NULL default '', `icon` varchar(255) NOT NULL default '', KEY `tab` (`tab`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `roster_guildvault_contents` ( `tab` varchar(100) NOT NULL default '', `item_num` int(3) NOT NULL default '0', `item_name` varchar(255) NOT NULL default '', `item_color` varchar(255) NOT NULL default '', `item_tooltip` text NOT NULL, `item_icon` varchar(255) NOT NULL default '', `item_id` varchar(255) NOT NULL default '', `item_quantity` int(3) NOT NULL default '0', KEY `tab` (`tab`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `roster_guildvault_logs` ( `tab` varchar(100) NOT NULL default '', `log_num` int(3) NOT NULL default '0', `log_type` varchar(255) NOT NULL default '', `log_name` varchar(255) NOT NULL default '', `log_item` varchar(255) NOT NULL default '', `log_count` int(3) NOT NULL default '0', `log_time` varchar(255) NOT NULL default '', KEY `tab` (`tab`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `roster_guildvault_money` ( `copper` tinyint(2) NOT NULL default '0', `silver` tinyint(2) NOT NULL default '0', `gold` int(9) NOT NULL default '0', `guild` varchar(255) NOT NULL default '', KEY `copper` (`copper`,`silver`,`gold`) ) ENGINE=MyISAM; CREATE TABLE IF NOT EXISTS `roster_guildvault_orders` ( `order_num` int(4) NOT NULL auto_increment COMMENT 'Auto Order ID', `member_id` int(11) NOT NULL default '0' COMMENT 'ID from member who ordered', `tab` varchar(50) NOT NULL default '' COMMENT 'tab where the item is in guildvault', `item_nr` tinyint(2) NOT NULL default '0' COMMENT 'num of the place where the item is located in guildvault', `num_items` tinyint(3) NOT NULL default '0' COMMENT 'how many items ordered', `order_status` tinyint(1) NOT NULL default '0' COMMENT 'status of order 0=open 1=done', PRIMARY KEY (`order_num`), KEY `member_id` (`member_id`) ) ENGINE=MyISAM COMMENT='Orders from members '; CREATE TABLE IF NOT EXISTS `roster_guildvault_pricecache` ( `itemid` varchar(255) NOT NULL default '' COMMENT 'ID of the Item', `buy` int(10) NOT NULL default '0' COMMENT 'Buyprice (Merchant)', `sell` int(10) NOT NULL default '0' COMMENT 'Sellprice (Merchant)', `auc` int(10) NOT NULL default '0' COMMENT 'Median AH Price', PRIMARY KEY (`itemid`) ) ENGINE=MyISAM COMMENT='Cached Prices from Allakhazam';