/*
Navicat MySQL Data Transfer

Source Server         : 192.168.1.10_3306
Source Server Version : 50149
Source Host           : 192.168.1.10:3306
Source Database       : woodpecker

Target Server Type    : MYSQL
Target Server Version : 50149
File Encoding         : 65001

Date: 2011-06-28 13:12:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bots_responses`
-- ----------------------------
DROP TABLE IF EXISTS `bots_responses`;
CREATE TABLE `bots_responses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `bot_id` int(10) unsigned NOT NULL,
  `keywords` text NOT NULL,
  `response_text` varchar(200) NOT NULL,
  `mode` enum('say','shout','whisper') NOT NULL DEFAULT 'say',
  `serve_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `bot_id` (`bot_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of bots_responses
-- ----------------------------
INSERT INTO `bots_responses` VALUES ('1', '8', 'hey;hello;hallo;hai;hoi;howdy;hi', 'Hello!', 'say', '0');
INSERT INTO `bots_responses` VALUES ('2', '8', 'cola;coke;drink;soda', 'I hope this soda is cold enough, our fridge is on the fritz again!', 'say', '21');
INSERT INTO `bots_responses` VALUES ('3', '8', 'coffee;mocha;latte', 'I\'m no barista, but I tried my best! Enjoy.', 'say', '11');
INSERT INTO `bots_responses` VALUES ('5', '8', 'love', 'Love is a strange thing..', 'say', '0');
INSERT INTO `bots_responses` VALUES ('6', '8', 'dust;dusty;dirty;filthy;disgusting;eww', 'Are you calling my lobby dirty!??!', 'shout', '0');
INSERT INTO `bots_responses` VALUES ('7', '8', 'whisper to me harry', 'Do you like being whispered to...?', 'whisper', '0');
INSERT INTO `bots_responses` VALUES ('8', '8', 'yes;yep;definitely;yeah;uh-huh;no;nope;never;nay', 'Oh, well, if you say so...', 'say', '0');

-- ----------------------------
-- Table structure for `rooms_bots`
-- ----------------------------
DROP TABLE IF EXISTS `rooms_bots`;
CREATE TABLE `rooms_bots` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `name` varchar(10) NOT NULL,
  `figure` varchar(200) NOT NULL,
  `min_x` int(2) NOT NULL DEFAULT '0',
  `min_y` int(2) NOT NULL DEFAULT '0',
  `max_x` int(2) NOT NULL DEFAULT '0',
  `max_y` int(2) NOT NULL DEFAULT '0',
  `start_x` int(2) NOT NULL DEFAULT '0',
  `start_y` int(2) NOT NULL DEFAULT '0',
  `rot` int(2) NOT NULL,
  `random_speech` varchar(200) NOT NULL DEFAULT '|',
  `trigger_response` varchar(200) NOT NULL DEFAULT '|',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of rooms_bots
-- ----------------------------
INSERT INTO `rooms_bots` VALUES ('1', '1', 'Frank', 'sd=001&sh=003/41,41,41&lg=006/51,51,51&ch=202/139,24,32&lh=001/255,210,179&rh=001/255,210,179&hd=001/255,204,153&ey=001&fc=001/255,204,153&hr=203/103,78,59&rs=001/255,255,255&ls=001/255,255,255&bd=001', '8', '16', '9', '24', '8', '20', '2', '|', '|');
INSERT INTO `rooms_bots` VALUES ('2', '73', 'Jess', 'sd=001&sh=001/2,3,4&lg=001/200,0,0&ch=006/40,138,179&lh=001/255,203,152&rh=001/255,203,152&hd=001/255,203,152&ey=001&fc=001/255,203,152&hr=003/250,50,2&hrb=3/2,3,4&rs=002/40,138,179&ls=002/40,138,179&', '1', '20', '1', '24', '1', '23', '2', '|', '|');
INSERT INTO `rooms_bots` VALUES ('3', '75', 'Gate', 'sd=001&sh=001/2,3,4&lg=200/36,137,84&ch=204/36,137,84&lh=001/215,175,125&rh=001/215,175,125&hd=001/215,175,125&ey=001&fc=001/215,175,125&ha=9/255,255,255&rs=002/36,137,84&ls=002/36,137,84&bd=001/255,2', '14', '17', '18', '17', '14', '17', '2', '|', '|');
INSERT INTO `rooms_bots` VALUES ('4', '69', 'Lyle', 'sd=001&sh=002/79,135,192&lg=005/79,135,192&ch=911/255,255,255&lh=001/238,194,181&rh=001/238,194,181&hd=001/238,194,181&ey=001&fc=001/238,194,181&hr=023/255,230,115&hrb=23/2,3,4&rs=002/79,135,192&ls=00', '18', '16', '18', '18', '18', '18', '2', '|', '|');
INSERT INTO `rooms_bots` VALUES ('5', '78', 'Ken', 'sd=001&sh=001/17,17,17&lg=001/17,17,17&ch=800&lh=001/240,213,179&rh=001/240,213,179&hd=001/240,213,179&ey=001/254,202,150&fc=001/240,213,179&hr=201/17,17,17&hrb=201/2,3,4&rs=800&ls=800&bd=001/240,213,', '99', '99', '99', '99', '3', '3', '4', '|', '|');
INSERT INTO `rooms_bots` VALUES ('6', '62', 'Dave', 'sd=001&sh=003/41,41,41&lg=006/51,51,51&ch=202/139,24,32&lh=001/255,210,179&rh=001/255,210,179&hd=001/255,204,153&ey=001&fc=001/255,204,153&hr=203/103,78,59&rs=001/255,255,255&ls=001/255,255,255&bd=001', '11', '8', '11', '10', '11', '8', '4', '|', '|');
INSERT INTO `rooms_bots` VALUES ('7', '63', 'Stuart', 'sd=001&sh=003/154,154,154&lg=001/98,90,32&ch=202/255,210,179&lh=001/255,210,179&rh=001/255,210,179&hd=001/255,204,153&ey=001&fc=001/255,204,153&hr=203/98,98,98&hrb=203/2,3,4&rs=001/255,210,179&ls=001/', '11', '14', '11', '16', '11', '15', '2', '|', '|');
INSERT INTO `rooms_bots` VALUES ('8', '80', 'Skye', 'sd=001&sh=002/204,0,0&lg=001/215,175,125&ch=002/204,0,0&lh=001/215,175,125&rh=001/215,175,125&hd=001/215,175,125&ey=001&fc=001/215,175,125&hr=503/235,240,163&rs=002/204,0,0&ls=002/204,0,0&bd=001/215,1', '2', '0', '2', '0', '2', '0', '4', '|', 'coffee~11}I\'m no barista, but I tried my best! Enjoy. =D|soda~19}Enjoy! Nice and bubbly...|');
