/*
Navicat MySQL Data Transfer

Source Server         : Home Web Server DB
Source Server Version : 50621
Source Host           : 127.0.0.1:3306
Source Database       : phx

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

Date: 2015-05-27 20:48:10
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `homes`
-- ----------------------------
DROP TABLE IF EXISTS `homes`;
CREATE TABLE `homes` (
  `home_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `link_type` enum('user','group') NOT NULL DEFAULT 'user',
  `link_id` INT(10) UNSIGNED NOT NULL,
  `allow_display` enum('0','1') NOT NULL DEFAULT '1',
  `bgimage` VARCHAR(120) NOT NULL DEFAULT 'b_bg_colour_01',
  PRIMARY KEY (`home_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of homes
-- ----------------------------

-- ----------------------------
-- Table structure for `homes_items`
-- ----------------------------
DROP TABLE IF EXISTS `homes_items`;
CREATE TABLE `homes_items` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `home_id` INT(10) UNSIGNED NOT NULL,
  `type` enum('sticker','widget','stickie') NOT NULL DEFAULT 'sticker',
  `x` INT(11) NOT NULL DEFAULT '0',
  `y` INT(11) NOT NULL DEFAULT '0',
  `z` INT(11) NOT NULL DEFAULT '0',
  `data` VARCHAR(500) NOT NULL,
  `skin` text NOT NULL,
  `owner_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `link` INT(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `home_id` (`home_id`),
  KEY `type` (`type`),
  KEY `data` (`data`),
  KEY `owner_id` (`owner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of homes_items
-- ----------------------------