/*
Navicat MySQL Data Transfer

Source Server         : core.digitalhill.com
Source Server Version : 50537
Source Host           : core.digitalhill.com:3306
Source Database       : coredigi_db

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

Date: 2014-07-18 08:27:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `templates`
-- ----------------------------
DROP TABLE IF EXISTS `templates`;
CREATE TABLE `templates` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `image` varchar(128) NOT NULL,
  `description` text NOT NULL,
  `layout` text NOT NULL,
  `position` bigint(20) NOT NULL,
  `published` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of templates
-- ----------------------------
INSERT INTO `templates` VALUES ('0', 'Basic Template', 'template0.jpg', 'This is the basic template.', '[[{\"index\":0,\"type\":0,\"clear\":true}]]', '1', '1');
INSERT INTO `templates` VALUES ('1', 'Column Format', 'template1.jpg', 'This template provides a column format for your content.', '[[{\"index\":0,\"type\":0,\"float\":\"left\"},{\"index\":1,\"type\":0,\"clear\":true}]]', '2', '1');
INSERT INTO `templates` VALUES ('2', 'Row Format', 'template2.jpg', 'This template provides a row format for your content.', '[[{\"index\":0,\"type\":0,\"clear\":true}],[{\"index\":1,\"type\":0,\"clear\":true}]]', '3', '1');
INSERT INTO `templates` VALUES ('3', 'Three Widget', 'template3.jpg', 'This template provides three widget areas with a larger widget area above.', '[[{\"index\":0,\"type\":1,\"clear\":true},{\"index\":0,\"type\":1,\"clear\":true}],[{\"index\":1,\"type\":0},{\"index\":2,\"type\":0,\"clear\":true}]]', '4', '1');
INSERT INTO `templates` VALUES ('4', 'Three Widget 2', 'template4.jpg', 'This template provides three widget areas with a larger widget area below.', '[[{\"index\":0,\"type\":1},{\"index\":1,\"type\":2,\"clear\":true}],[{\"index\":2,\"type\":0,\"clear\":true},{\"index\":2,\"type\":0,\"clear\":true}]]', '5', '1');
INSERT INTO `templates` VALUES ('5', 'Column Format 2', 'template5.jpg', 'This template provides a column format for your content with a smaller left column.', '[[{\"index\":0,\"type\":0},{\"index\":1,\"type\":0,\"clear\":true},{\"index\":1,\"type\":0,\"clear\":true}],[{\"index\":0,\"type\":0},{\"index\":1,\"type\":0,\"clear\":true},{\"index\":1,\"type\":0,\"clear\":true}]]', '6', '1');
INSERT INTO `templates` VALUES ('6', 'Column Format 3', 'template6.jpg', 'This template provides a column format for your content with a larger left column.', '[[{\"index\":0,\"type\":0},{\"index\":0,\"type\":0},{\"index\":1,\"type\":0,\"clear\":true}],[{\"index\":0,\"type\":0},{\"index\":0,\"type\":0},{\"index\":1,\"type\":0,\"clear\":true}]]', '7', '1');
INSERT INTO `templates` VALUES ('7', 'Four Widget', 'template7.jpg', 'This template provides four widget areas for your content.', '[[{\"index\":0,\"type\":3},{\"index\":1,\"type\":1,\"clear\":true}],[{\"index\":2,\"type\":0},{\"index\":3,\"type\":0,\"clear\":true}]]', '8', '1');
INSERT INTO `templates` VALUES ('8', 'Template 8', 'template8.jpg', 'Template 8', '[[{\"index\":0,\"type\":0},{\"index\":1,\"type\":0}],[{\"index\":0,\"type\":0},{\"index\":2,\"type\":0,\"float\":\"right\",\"clear\":true}]]', '9', '1');
INSERT INTO `templates` VALUES ('9', 'Template 9', 'template9.jpg', 'Template 9', '[[{\"index\":0,\"type\":0},{\"index\":1,\"type\":0,\"float\":\"right\"}],[{\"index\":2,\"type\":0,\"clear\":true},{\"index\":1,\"type\":0,\"float\":\"right\"}]]', '10', '1');
INSERT INTO `templates` VALUES ('10', 'FOR TESTING PURPOSES', 'template0.jpg', 'FOR TESTING PURPOSES', '[[{\"index\":0,\"type\":0},{\"index\":1,\"type\":1,\"clear\":true}],[{\"index\":2,\"type\":2},{\"index\":3,\"type\":3,\"clear\":true}],[{\"index\":4,\"type\":4},{\"index\":5,\"type\":5,\"clear\":true}]]', '11', '1');
INSERT INTO `templates` VALUES ('11', 'FOR TESTING GALLERY MAP', 'template0.jpg', 'FOR TESTING GALLERY MAP', '[[{\"index\":0,\"type\":4},{\"index\":1,\"type\":5,\"clear\":true}]]', '12', '1');
