Ticket #103: default_gms_db.sql

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 27, 2007 at 11:21 AM
-- Server version: 5.0.22
-- PHP Version: 5.1.6
-- 
-- Database: `gbm_developer_db2`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `gbm_registrations`
-- 
-- Creation: Dec 11, 2006 at 08:19 PM
-- Last update: Mar 25, 2007 at 05:53 PM
-- 

CREATE TABLE `gbm_registrations` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `req_username` text,
  `avatar` text,
  `email_addr` text NOT NULL,
  `notes` text,
  `validation_key` varchar(52) default NULL,
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `approved_by` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_categories`
-- 
-- Creation: Feb 18, 2007 at 03:23 PM
-- Last update: Mar 08, 2007 at 11:36 PM
-- 

CREATE TABLE `gms_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `parent` int(11) NOT NULL default '0',
  `owner` text NOT NULL,
  `icon` text NOT NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10005 ;

-- 
-- Dumping data for table `gms_categories`
-- 

INSERT INTO `gms_categories` (`id`, `name`, `parent`, `owner`, `icon`, `description`) VALUES 
(0, 'Top Level', 0, '', 'Ability_Druid_SupriseAttack.png', NULL),
(10, 'Axe', 1, 'Weapons', 'INV_Axe_01.png', NULL),
(8, 'Potions', 4, 'Misc.', 'INV_Potion_01.png', NULL),
(9, 'Containers', 4, 'Misc.', 'INV_Misc_Bag_08.png', NULL),
(6, 'Herbs', 4, 'Misc.', 'INV_Misc_Flower_02.png', NULL),
(5, 'Ammo', 4, 'Weapons', 'INV_Ammo_Arrow_02.png', NULL),
(4, 'Misc.', 0, 'Main', 'INV_Crate_01.png', NULL),
(2, 'Swords', 1, 'Weapons', 'INV_Sword_01.png', NULL),
(3, 'Shields', 30, 'Armor', 'INV_Shield_01.png', NULL),
(1, 'Weapons', 0, 'Main', 'INV_Sword_01.png', NULL),
(11, 'Mace', 1, 'Weapons', 'INV_Mace_01.png', NULL),
(12, 'Staff', 1, 'Weapons', 'INV_Staff_01.png', NULL),
(13, 'Bow', 1, 'Weapons', 'INV_Weapon_Bow_02.png', NULL),
(14, 'Rifle', 1, 'Weapons', 'INV_Weapon_Rifle_01.png', NULL),
(15, 'Crossbow', 1, 'Weapons', 'INV_Weapon_Crossbow_02.png', NULL),
(16, 'Dagger', 1, 'Weapons', 'INV_Sword_04.png', NULL),
(17, 'Trade Skills', 0, 'Main', 'INV_TradeskillItem_01.png', NULL),
(18, 'Alchemy', 17, 'Trade Skills', 'INV_Potion_43.png', NULL),
(19, 'Blacksmithing', 17, 'Trade Skills', 'INV_Stone_GrindingStone_04.png', NULL),
(20, 'Engineering', 17, 'Trade Skills', 'INV_Misc_Spyglass_03.png', NULL),
(21, 'Fishing', 17, 'Trade Skills', 'INV_Fishingpole_02.png', NULL),
(22, 'Herbalism', 17, 'Trade Skills', 'INV_Misc_Leaf_02.png', NULL),
(23, 'Leatherworking', 17, 'Trade Skills', 'INV_Misc_LeatherScrap_07.png', NULL),
(24, 'Mining', 17, 'Trade Skills', 'INV_Ore_Copper_01.png', NULL),
(25, 'Poison', 17, 'Weapons', 'Ability_Poisons.png', NULL),
(26, 'Tailoring', 17, 'Trade Skills', 'INV_Fabric_Linen_02.png', NULL),
(27, 'Enchanting', 17, 'Trade Skills', 'INV_Enchant_EssenceEternalLarge.png', NULL),
(28, 'Food', 4, 'Misc.', 'INV_Misc_Food_12.png', NULL),
(29, 'Scroll', 4, 'Misc.', 'INV_Scroll_01.png', NULL),
(30, 'Armor', 0, 'Main', 'INV_Chest_Plate03.png', NULL),
(31, 'Cloth', 30, 'Armor', 'INV_Chest_Cloth_01.png', NULL),
(32, 'Leather', 30, 'Bloodbank', 'INV_Chest_Leather_07.png', NULL),
(33, 'Mail', 30, 'Bloodbank', 'INV_Chest_Plate09.png', NULL),
(34, 'Plate', 30, 'Bloodbank', 'INV_Chest_Plate01.png', NULL),
(40, 'Wand', 1, 'Bloodbank', 'INV_Wand_12.png', NULL),
(36, 'Off-hand item', 1, 'Bloodbank', 'INV_Wand_01.png', NULL),
(37, 'Jewls & Trinkets', 4, 'Bloodbank', 'INV_Jewelry_Ring_45.png', NULL),
(38, 'For Fun', 4, 'Bloodbank', 'INV_Holiday_Christmas_Present_03.png', NULL),
(39, 'Tomes', 4, 'Bloodbank', 'INV_Misc_Book_10.png', NULL),
(41, 'First Aid', 17, 'Bloodbank', 'INV_Misc_Bandage_18.png', NULL),
(42, 'Cooking', 17, 'Bloodbank', 'INV_Food_ChristmasFruitCake_01.png', NULL),
(43, 'Reagent', 17, 'Bloodbank', 'INV_Misc_Gem_Pearl_02.png', NULL),
(9999, 'Full Catalogue', 0, '', 'Ability_Druid_SupriseAttack.png', NULL),
(10000, 'Polearm', 1, '175', 'INV_Weapon_Halberd_02.png', NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_items`
-- 
-- Creation: Mar 27, 2007 at 10:53 AM
-- Last update: Mar 27, 2007 at 10:56 AM
-- 

CREATE TABLE `gms_items` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `banked` text,
  `owner` int(11) NOT NULL default '0',
  `parent` int(11) NOT NULL default '0',
  `quantity` int(11) NOT NULL default '0',
  `quantitymax` int(11) NOT NULL default '0',
  `itempoints` int(11) NOT NULL default '0',
  `timestamp` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=787 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_news`
-- 
-- Creation: Dec 11, 2006 at 08:19 PM
-- Last update: Mar 26, 2007 at 12:10 AM
-- 

CREATE TABLE `gms_news` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `header` text NOT NULL,
  `date` text NOT NULL,
  `news` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `gms_news`
-- 

INSERT INTO `gms_news` (`id`, `name`, `header`, `date`, `news`) VALUES 
(1, 'Isyldar', 'Welcome to the Guild Bank!', 'Sep 30, 2006', 'If you have any questions about the Guild Bank, comments, concerns, bug reports, etc. DO NOT hesitate to fill out a trouble-ticket on <a href="http://trac.chrisbraybrook.com/wowgbm">http://trac.chrisbraybrook.com/wowgbm</a>.<br />\r\n<br />\r\nWe will respond in as timely a fashion as we possibly can, and otherwise just look forward to working with you in general. Welcome aboard!');

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_request`
-- 
-- Creation: Dec 11, 2006 at 08:19 PM
-- Last update: Dec 11, 2006 at 09:15 PM
-- 

CREATE TABLE `gms_request` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `item` text NOT NULL,
  `qty` varchar(10) NOT NULL default '1',
  `status` varchar(10) NOT NULL default 'waiting',
  `comments` text,
  `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_systemcache`
-- 
-- Creation: Mar 27, 2007 at 10:53 AM
-- Last update: Mar 27, 2007 at 11:08 AM
-- 

CREATE TABLE `gms_systemcache` (
  `item_name` varchar(100) NOT NULL default '',
  `item_link` varchar(100) default NULL,
  `item_color` varchar(20) NOT NULL default '',
  `item_icon` varchar(50) NOT NULL default '',
  `item_html` text NOT NULL,
  UNIQUE KEY `item_name` (`item_name`),
  FULLTEXT KEY `item_html` (`item_html`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_users_configs`
-- 
-- Creation: Dec 11, 2006 at 09:19 PM
-- Last update: Mar 25, 2007 at 05:53 PM
-- 

CREATE TABLE `gms_users_configs` (
  `id` int(11) NOT NULL auto_increment,
  `url` text,
  `email` text,
  `name` text,
  `icon` text,
  `level` int(11) NOT NULL default '0',
  `points` int(11) NOT NULL default '0',
  `memo` text,
  `submitcnt` int(11) NOT NULL default '5',
  `rank` text,
  `image` text,
  `item_view_full` binary(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;

-- 
-- Dumping data for table `gms_users_configs`
-- 

INSERT INTO `gms_users_configs` (`id`, `url`, `email`, `name`, `icon`, `level`, `points`, `memo`, `submitcnt`, `rank`, `image`, `item_view_full`) VALUES 
(1, '', 'admin@guildbank.ca', 'GuildMaster', NULL, 0, 0, '', 1, 'GuildMaster', NULL, 0x30),
(2, '', 'postmaster@somewhere.net', 'Guild PostMaster', '', 0, 0, '', 1, '', 'mem2.png', 0x30),
(3, 'http://trac.chrisbraybrook.com/wowgbm', 'web_projects@chrisbraybrook.com', 'Technical Support', '', 0, 0, '', 1, '', NULL, 0x30),
(4, '', '', 'Former Member', '', 0, 0, 'This member used to be a part of our Guild. They are no more. Look away.', 1, '', '', 0x30);

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_users_info`
-- 
-- Creation: Dec 11, 2006 at 08:19 PM
-- Last update: Mar 27, 2007 at 11:16 AM
-- 

CREATE TABLE `gms_users_info` (
  `id` int(11) NOT NULL auto_increment,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `client_fname` text,
  `client_lname` text,
  `address` text,
  `suite` text,
  `city` text,
  `province` text,
  `postal_code` varchar(6) default NULL,
  `country` text,
  `admin` tinyint(1) NOT NULL default '0',
  `system_user` int(11) NOT NULL default '0',
  `display_as_member` int(11) NOT NULL default '1',
  `user_deletable` tinyint(1) NOT NULL default '1',
  `user_timeout_seconds` int(11) NOT NULL default '900',
  `last_login_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_login_seconds` int(11) NOT NULL default '0',
  `last_logout_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_logout_seconds` int(11) NOT NULL default '0',
  `current_session_id` text,
  `last_action_time` int(11) NOT NULL default '0',
  `user_logged_in` tinyint(1) NOT NULL default '0',
  `account_status` int(11) NOT NULL default '1',
  `valid_email` tinyint(1) NOT NULL default '0',
  `validation_key` varchar(22) default NULL,
  `validation_key_sent` int(11) NOT NULL default '0',
  `email_last_updated` int(11) NOT NULL default '0',
  `email_display_public` binary(1) NOT NULL default '1',
  `admin_comments` text,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;

-- 
-- Dumping data for table `gms_users_info`
-- 

INSERT INTO `gms_users_info` (`id`, `username`, `password`, `client_fname`, `client_lname`, `address`, `suite`, `city`, `province`, `postal_code`, `country`, `admin`, `system_user`, `display_as_member`, `user_deletable`, `user_timeout_seconds`, `last_login_time`, `last_login_seconds`, `last_logout_time`, `last_logout_seconds`, `current_session_id`, `last_action_time`, `user_logged_in`, `account_status`, `valid_email`, `validation_key`, `validation_key_sent`, `email_last_updated`, `email_display_public`, `admin_comments`) VALUES 
(1, 'admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 'Administrator', '', '', '', '', '', NULL, '', 1, 1, 1, 0, 900, '2007-03-27 10:27:31', 1175008171, '2007-03-26 19:26:39', 1174954479, 'iiif3td4jsmfr01du18fmesk61', 1175012218, 1, 1, 0, NULL, 0, 0, 0x31, 'This account is reserved for the GuildMaster / Primary Administrator.'),
(2, 'PostMaster', '', 'Postmaster', '', '', '', '', '', NULL, '', 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, NULL, 0, 0, 0, 1, NULL, 0, 0, 0x30, 'This is your Guild PostMaster, responsible for all of the mail that gets sent out around here. (Well, more of a figurehead actually. You can set the Guild e-mail here, where all of your email comes from.)'),
(3, 'TechSupport', '8e383deeb55c660a8c1563112f0ccd6d444ea2d1', 'Technical', 'Support', '', '', '', '', NULL, '', 1, 1, 0, 0, 900, '2006-11-15 21:15:39', 0, '2006-11-15 21:15:09', 0, ' ', 0, 0, 1, 0, NULL, 0, 0, 0x30, 'Technical Support login. Used when tech support needs access to your Guild Bank to correct problems that have arisen. To disable this account, simply change the Unlock Account bit noted above, or delete the user.\r\n\r\nBE CAREFUL ABOUT DELETING THIS USER, AS IT MAY RESULT IN TERMINATION OF SUPPORT FOR YOUR GUILD BANK.'),
(4, 'formermember', '', 'Former', 'Member', '', '', '', '', '', '', 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, NULL, 0, 0, 0, 1, '', 0, 0, 0x30, '');

-- --------------------------------------------------------

-- 
-- Table structure for table `gms_users_perms`
-- 
-- Creation: Dec 11, 2006 at 08:19 PM
-- Last update: Mar 25, 2007 at 05:53 PM
-- 

CREATE TABLE `gms_users_perms` (
  `id` int(11) NOT NULL auto_increment,
  `users_admin` tinyint(1) NOT NULL default '0',
  `item_admin` int(11) NOT NULL default '0',
  `news_admin` int(11) NOT NULL default '0',
  `delete_multiple_users` tinyint(1) NOT NULL default '0',
  `change_password` int(11) NOT NULL default '1',
  `edit_profile` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=105 ;

-- 
-- Dumping data for table `gms_users_perms`
-- 

INSERT INTO `gms_users_perms` (`id`, `users_admin`, `item_admin`, `news_admin`, `delete_multiple_users`, `change_password`, `edit_profile`) VALUES 
(1, 1, 1, 1, 0, 1, 1),
(2, 0, 0, 0, 0, 0, 0),
(3, 1, 1, 1, 1, 1, 1),
(4, 0, 0, 0, 0, 0, 0);