/*
Navicat MySQL Data Transfer
Source Host     : localhost:3306
Source Database : norwaybox
Target Host     : localhost:3306
Target Database : norwaybox
Date: 1/3/2010 10:49:09 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for pets
-- ----------------------------
DROP TABLE IF EXISTS `pets`;
CREATE TABLE `pets` (
  `id` int(10) NOT NULL,
  `ownerid` int(10) NOT NULL,
  `nest_id` int(10) NOT NULL,
  `name` varchar(15) NOT NULL,
  `type` varchar(4) NOT NULL,
  `colour` varchar(10) NOT NULL,
  `race` int(3) NOT NULL,
  `room_uid` int(5) DEFAULT NULL,
  `roomid` int(10) DEFAULT NULL,
  `x` int(3) DEFAULT NULL,
  `y` int(3) DEFAULT NULL,
  `z` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pets
-- ----------------------------

-- ----------------------------
-- Table structure for pets_texts
-- ----------------------------
DROP TABLE IF EXISTS `pets_texts`;
CREATE TABLE `pets_texts` (
  `text` varchar(30) NOT NULL,
  `animal` varchar(4) NOT NULL,
  `type` varchar(8) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pets_texts
-- ----------------------------
INSERT INTO `pets_texts` VALUES ('Prr...', 'pet1', 'say');
INSERT INTO `pets_texts` VALUES ('voff', 'pet0', 'say');
INSERT INTO `pets_texts` VALUES ('tick', 'pet2', 'say');
INSERT INTO `pets_texts` VALUES ('Prr...', 'pet1', 'shout');
INSERT INTO `pets_texts` VALUES ('voff', 'pet0', 'shout');
INSERT INTO `pets_texts` VALUES ('tick', 'pet2', 'shout');
