--
-- Host: localhost    Database: lionsgroup_production
-- ------------------------------------------------------


--
-- Table structure for table `alchemy_attachments`
--

CREATE TABLE `alchemy_attachments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_mime_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `cached_tag_list` text COLLATE utf8_unicode_ci,
  `file_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_alchemy_attachments_on_file_uid` (`file_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_attachments`
--


--
-- Table structure for table `alchemy_cells`
--

CREATE TABLE `alchemy_cells` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_cells`
--


--
-- Table structure for table `alchemy_contents`
--

CREATE TABLE `alchemy_contents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `essence_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `essence_id` int(11) DEFAULT NULL,
  `element_id` int(11) DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_contents_on_element_id_and_position` (`element_id`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_contents`
--

INSERT INTO `alchemy_contents` VALUES (1,'headline','Alchemy::EssenceText',1,1,1,'2015-07-24 13:25:19','2015-07-24 13:28:06',1,1),(2,'picture','Alchemy::EssencePicture',1,1,1,'2015-07-24 13:25:19','2015-07-24 13:28:06',1,1),(3,'text','Alchemy::EssenceRichtext',1,1,1,'2015-07-24 13:25:19','2015-07-24 13:28:06',1,1),(4,'headline','Alchemy::EssenceText',2,2,1,'2015-08-03 13:42:46','2015-08-11 12:18:55',3,3),(5,'picture','Alchemy::EssencePicture',2,2,1,'2015-08-03 13:42:46','2015-08-11 12:18:55',3,3),(6,'text','Alchemy::EssenceRichtext',2,2,1,'2015-08-03 13:42:46','2015-08-11 12:18:55',3,3),(7,'bigbanner_image','Alchemy::EssencePicture',3,3,1,'2015-08-11 12:34:41','2015-08-11 15:59:34',3,3),(8,'bigbanner_caption','Alchemy::EssenceRichtext',3,3,1,'2015-08-11 12:34:41','2015-08-11 15:59:34',3,3),(9,'property_img','Alchemy::EssencePicture',4,4,1,'2015-08-11 12:36:45','2015-08-11 12:37:18',3,3),(10,'property_captions','Alchemy::EssenceRichtext',4,4,1,'2015-08-11 12:36:45','2015-08-11 12:37:18',3,3),(11,'property_img','Alchemy::EssencePicture',5,5,1,'2015-08-11 12:37:24','2015-08-11 12:37:48',3,3),(12,'property_captions','Alchemy::EssenceRichtext',5,5,1,'2015-08-11 12:37:24','2015-08-11 12:37:48',3,3),(13,'common_head','Alchemy::EssenceRichtext',6,6,1,'2015-08-11 12:38:04','2015-08-11 12:38:16',3,3),(14,'headline','Alchemy::EssenceText',3,7,1,'2015-08-11 15:41:35','2015-08-11 15:41:35',3,3),(15,'picture','Alchemy::EssencePicture',6,7,1,'2015-08-11 15:41:35','2015-08-11 15:41:35',3,3),(16,'text','Alchemy::EssenceRichtext',7,7,1,'2015-08-11 15:41:35','2015-08-11 15:41:35',3,3),(17,'bigbanner_image','Alchemy::EssencePicture',7,8,1,'2015-08-11 15:41:35','2015-08-11 15:49:38',3,3),(18,'bigbanner_caption','Alchemy::EssenceRichtext',8,8,1,'2015-08-11 15:41:35','2015-08-11 15:49:38',3,3),(19,'quote_text','Alchemy::EssenceRichtext',9,9,1,'2015-08-11 15:41:35','2015-08-11 15:55:36',3,3),(20,'common_head','Alchemy::EssenceRichtext',10,10,1,'2015-08-11 15:50:05','2015-08-11 15:50:08',3,3),(21,'common_head','Alchemy::EssenceRichtext',11,11,1,'2015-08-11 15:50:20','2015-08-11 15:50:33',3,3),(22,'property_img','Alchemy::EssencePicture',8,12,1,'2015-08-11 15:50:52','2015-08-11 15:51:17',3,3),(23,'property_captions','Alchemy::EssenceRichtext',12,12,1,'2015-08-11 15:50:52','2015-08-11 15:51:17',3,3),(24,'property_img','Alchemy::EssencePicture',9,13,1,'2015-08-11 15:51:54','2015-08-11 15:52:06',3,3),(25,'property_captions','Alchemy::EssenceRichtext',13,13,1,'2015-08-11 15:51:54','2015-08-11 15:52:06',3,3),(26,'property_img','Alchemy::EssencePicture',10,14,1,'2015-08-11 15:52:14','2015-08-11 15:52:34',3,3),(27,'property_captions','Alchemy::EssenceRichtext',14,14,1,'2015-08-11 15:52:14','2015-08-11 15:52:34',3,3),(28,'property_img','Alchemy::EssencePicture',11,15,1,'2015-08-11 15:52:41','2015-08-11 15:53:01',3,3),(29,'property_captions','Alchemy::EssenceRichtext',15,15,1,'2015-08-11 15:52:41','2015-08-11 15:53:02',3,3),(30,'property_img','Alchemy::EssencePicture',12,16,1,'2015-08-11 15:53:11','2015-08-11 15:53:27',3,3),(31,'property_captions','Alchemy::EssenceRichtext',16,16,1,'2015-08-11 15:53:11','2015-08-11 15:53:27',3,3),(32,'property_img','Alchemy::EssencePicture',13,17,1,'2015-08-11 15:53:38','2015-08-11 15:54:00',3,3),(33,'property_captions','Alchemy::EssenceRichtext',17,17,1,'2015-08-11 15:53:38','2015-08-11 15:54:00',3,3),(34,'common_head','Alchemy::EssenceRichtext',18,18,1,'2015-08-11 15:54:17','2015-08-11 15:54:26',3,3),(35,'essence_picture_1','Alchemy::EssencePicture',14,9,1,'2015-08-11 15:55:19','2015-08-11 15:55:36',3,3),(36,'essence_picture_2','Alchemy::EssencePicture',15,9,2,'2015-08-11 15:55:24','2015-08-11 15:55:36',3,3),(37,'essence_picture_3','Alchemy::EssencePicture',16,9,3,'2015-08-11 15:55:28','2015-08-11 15:55:36',3,3),(38,'essence_picture_4','Alchemy::EssencePicture',17,9,4,'2015-08-11 15:55:33','2015-08-11 15:55:36',3,3);

--
-- Table structure for table `alchemy_elements`
--

CREATE TABLE `alchemy_elements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL,
  `public` tinyint(1) DEFAULT '1',
  `folded` tinyint(1) DEFAULT '0',
  `unique` tinyint(1) DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `cell_id` int(11) DEFAULT NULL,
  `cached_tag_list` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `index_elements_on_page_id_and_position` (`page_id`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_elements`
--

INSERT INTO `alchemy_elements` VALUES (1,'article',NULL,2,0,1,1,'2015-07-24 13:25:19','2015-08-03 13:42:31',1,3,NULL,NULL),(2,'article',NULL,2,0,1,1,'2015-08-03 13:42:46','2015-08-11 12:35:21',3,3,NULL,NULL),(3,'bigbanner',1,2,1,0,0,'2015-08-11 12:34:41','2015-08-11 15:59:34',3,3,NULL,NULL),(4,'propertylist',3,2,1,0,0,'2015-08-11 12:36:45','2015-08-11 14:45:11',3,3,NULL,''),(5,'propertylist',4,2,1,1,0,'2015-08-11 12:37:24','2015-08-11 12:37:56',3,3,NULL,''),(6,'common_heading',2,2,1,0,0,'2015-08-11 12:38:04','2015-08-11 14:41:59',3,3,NULL,NULL),(7,'article',NULL,4,0,1,1,'2015-08-11 15:41:35','2015-08-11 15:48:44',3,3,NULL,NULL),(8,'bigbanner',1,4,1,1,0,'2015-08-11 15:41:35','2015-08-11 15:49:48',3,3,NULL,NULL),(9,'slider',11,4,1,0,1,'2015-08-11 15:41:35','2015-08-11 15:55:36',3,3,NULL,NULL),(10,'common_heading',2,4,1,1,0,'2015-08-11 15:50:05','2015-08-11 15:50:10',3,3,NULL,NULL),(11,'common_heading',3,4,1,1,0,'2015-08-11 15:50:20','2015-08-11 15:50:34',3,3,NULL,NULL),(12,'propertylist',4,4,1,1,0,'2015-08-11 15:50:52','2015-08-11 15:51:38',3,3,NULL,''),(13,'propertylist',5,4,1,1,0,'2015-08-11 15:51:54','2015-08-11 15:52:09',3,3,NULL,''),(14,'propertylist',6,4,1,1,0,'2015-08-11 15:52:14','2015-08-11 15:52:37',3,3,NULL,''),(15,'propertylist',7,4,1,1,0,'2015-08-11 15:52:41','2015-08-11 15:53:04',3,3,NULL,''),(16,'propertylist',8,4,1,1,0,'2015-08-11 15:53:11','2015-08-11 15:53:34',3,3,NULL,''),(17,'propertylist',9,4,1,1,0,'2015-08-11 15:53:38','2015-08-11 15:54:01',3,3,NULL,''),(18,'common_heading',10,4,1,1,0,'2015-08-11 15:54:17','2015-08-11 15:54:27',3,3,NULL,NULL);

--
-- Table structure for table `alchemy_elements_alchemy_pages`
--

CREATE TABLE `alchemy_elements_alchemy_pages` (
  `element_id` int(11) DEFAULT NULL,
  `page_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_elements_alchemy_pages`
--

INSERT INTO `alchemy_elements_alchemy_pages` VALUES (1,2),(3,2),(4,2),(5,2),(6,2),(7,4),(8,4),(9,4),(10,4),(11,4),(12,4),(13,4),(14,4),(15,4),(16,4),(17,4),(18,4);

--
-- Table structure for table `alchemy_essence_booleans`
--

CREATE TABLE `alchemy_essence_booleans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` tinyint(1) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_alchemy_essence_booleans_on_value` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_booleans`
--


--
-- Table structure for table `alchemy_essence_dates`
--

CREATE TABLE `alchemy_essence_dates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_dates`
--


--
-- Table structure for table `alchemy_essence_files`
--

CREATE TABLE `alchemy_essence_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attachment_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `css_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_files`
--


--
-- Table structure for table `alchemy_essence_htmls`
--

CREATE TABLE `alchemy_essence_htmls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` text COLLATE utf8_unicode_ci,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_htmls`
--


--
-- Table structure for table `alchemy_essence_links`
--

CREATE TABLE `alchemy_essence_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_target` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_class_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_links`
--


--
-- Table structure for table `alchemy_essence_pictures`
--

CREATE TABLE `alchemy_essence_pictures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `picture_id` int(11) DEFAULT NULL,
  `caption` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alt_tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_class_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `css_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_target` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `crop_from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `crop_size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `render_size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_pictures`
--

INSERT INTO `alchemy_essence_pictures` VALUES (1,1,NULL,NULL,NULL,'','','',NULL,'',1,1,'2015-07-24 13:25:19','2015-07-24 13:27:27','','',NULL),(2,8,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-03 13:42:46','2015-08-11 12:18:55','','',NULL),(3,11,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 12:34:41','2015-08-11 12:35:08','','',NULL),(4,9,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 12:36:45','2015-08-11 12:37:18','','',NULL),(5,10,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 12:37:24','2015-08-11 12:37:48','','',NULL),(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,3,'2015-08-11 15:41:35','2015-08-11 15:41:35','','',NULL),(7,36,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:41:35','2015-08-11 15:49:38','','',NULL),(8,25,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:50:52','2015-08-11 15:51:06','','',NULL),(9,22,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:51:54','2015-08-11 15:52:06','','',NULL),(10,21,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:52:14','2015-08-11 15:52:34','','',NULL),(11,20,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:52:41','2015-08-11 15:53:01','','',NULL),(12,19,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:53:11','2015-08-11 15:53:27','','',NULL),(13,18,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:53:38','2015-08-11 15:54:00','','',NULL),(14,29,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:55:19','2015-08-11 15:55:36','','',NULL),(15,30,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:55:24','2015-08-11 15:55:36','','',NULL),(16,26,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:55:28','2015-08-11 15:55:36','','',NULL),(17,29,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-11 15:55:33','2015-08-11 15:55:36','','',NULL);

--
-- Table structure for table `alchemy_essence_richtexts`
--

CREATE TABLE `alchemy_essence_richtexts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `body` text COLLATE utf8_unicode_ci,
  `stripped_body` text COLLATE utf8_unicode_ci,
  `public` tinyint(1) DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_richtexts`
--

INSERT INTO `alchemy_essence_richtexts` VALUES (1,'<p><strong>How to get started.</strong></p>\r\n<p>First of all you should read about Alchemy and its architecture in the <a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/alchemy_approach.html\" target=\"_blank\" data-link-target=\"blank\">guidelines</a>.</p>\r\n<p>The most important things to know about Alchemy are elements and page layouts.</p>\r\n<p><span style=\"text-decoration: underline;\"><strong>Elements:</strong></span></p>\r\n<p>With Alchemy you can split pages into content parts, elements. These elements can be defined out of several base content types: essences. The basic essences are:</p>\r\n<ul>\r\n<li>EssenceText - <em>A single line of text</em></li>\r\n<li>EssenceRichtext - <em>A TinyMCE powered formatted text block</em></li>\r\n<li>EssencePicture - <em>A reference to an image</em></li>\r\n<li>EssenceHtml - <em>HTML embed code</em></li>\r\n<li>EssenceSelect - <em>A selection of values</em></li>\r\n<li>EssenceBoolean - <em>A checkbox</em></li>\r\n</ul>\r\n<p>Elements get defined in a YAML file <strong>config/alchemy/elements.yml</strong></p>\r\n<p><a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/elements.html\" target=\"_blank\" data-link-target=\"blank\">Read more about elements and how to define them in the guidelines.</a></p>\r\n<p><span style=\"text-decoration: underline;\"><strong>Page types:</strong></span></p>\r\n<p>You can define several types of pages, called page layouts. You can assign elements to page layouts and control how elements and the page of a certain layout behave.</p>\r\n<p>Page layouts get defined in a YAML file <strong>config/alchemy/page_layouts.yml</strong></p>\r\n<p><a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/page_layouts.html\" target=\"_blank\" data-link-target=\"blank\">Read more about defining page layouts in the guidelines.</a></p>','How to get started.\r\nFirst of all you should read about Alchemy and its architecture in the guidelines.\r\nThe most important things to know about Alchemy are elements and page layouts.\r\nElements:\r\nWith Alchemy you can split pages into content parts, elements. These elements can be defined out of several base content types: essences. The basic essences are:\r\n\r\nEssenceText - A single line of text\r\nEssenceRichtext - A TinyMCE powered formatted text block\r\nEssencePicture - A reference to an image\r\nEssenceHtml - HTML embed code\r\nEssenceSelect - A selection of values\r\nEssenceBoolean - A checkbox\r\n\r\nElements get defined in a YAML file config/alchemy/elements.yml\r\nRead more about elements and how to define them in the guidelines.\r\nPage types:\r\nYou can define several types of pages, called page layouts. You can assign elements to page layouts and control how elements and the page of a certain layout behave.\r\nPage layouts get defined in a YAML file config/alchemy/page_layouts.yml\r\nRead more about defining page layouts in the guidelines.',NULL,1,1,'2015-07-24 13:25:19','2015-07-24 13:25:31'),(2,'<p><strong>How to get started.</strong></p>\r\n<p>First of all you should read about Alchemy and its architecture in the <a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/alchemy_approach.html\" target=\"_blank\" data-link-target=\"blank\">guidelines</a>.</p>\r\n<p>The most important things to know about Alchemy are elements and page layouts.</p>\r\n<p><span style=\"text-decoration: underline;\"><strong>Elements:</strong></span></p>\r\n<p>With Alchemy you can split pages into content parts, elements. These elements can be defined out of several base content types: essences. The basic essences are:</p>\r\n<ul>\r\n<li>EssenceText - <em>A single line of text</em></li>\r\n<li>EssenceRichtext - <em>A TinyMCE powered formatted text block</em></li>\r\n<li>EssencePicture - <em>A reference to an image</em></li>\r\n<li>EssenceHtml - <em>HTML embed code</em></li>\r\n<li>EssenceSelect - <em>A selection of values</em></li>\r\n<li>EssenceBoolean - <em>A checkbox</em></li>\r\n</ul>\r\n<p>Elements get defined in a YAML file <strong>config/alchemy/elements.yml</strong></p>\r\n<p><a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/elements.html\" target=\"_blank\" data-link-target=\"blank\">Read more about elements and how to define them in the guidelines.</a></p>\r\n<p><span style=\"text-decoration: underline;\"><strong>Page types:</strong></span></p>\r\n<p>You can define several types of pages, called page layouts. You can assign elements to page layouts and control how elements and the page of a certain layout behave.</p>\r\n<p>Page layouts get defined in a YAML file <strong>config/alchemy/page_layouts.yml</strong></p>\r\n<p><a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/page_layouts.html\" target=\"_blank\" data-link-target=\"blank\">Read more about defining page layouts in the guidelines.</a></p>','How to get started.\r\nFirst of all you should read about Alchemy and its architecture in the guidelines.\r\nThe most important things to know about Alchemy are elements and page layouts.\r\nElements:\r\nWith Alchemy you can split pages into content parts, elements. These elements can be defined out of several base content types: essences. The basic essences are:\r\n\r\nEssenceText - A single line of text\r\nEssenceRichtext - A TinyMCE powered formatted text block\r\nEssencePicture - A reference to an image\r\nEssenceHtml - HTML embed code\r\nEssenceSelect - A selection of values\r\nEssenceBoolean - A checkbox\r\n\r\nElements get defined in a YAML file config/alchemy/elements.yml\r\nRead more about elements and how to define them in the guidelines.\r\nPage types:\r\nYou can define several types of pages, called page layouts. You can assign elements to page layouts and control how elements and the page of a certain layout behave.\r\nPage layouts get defined in a YAML file config/alchemy/page_layouts.yml\r\nRead more about defining page layouts in the guidelines.',NULL,3,3,'2015-08-03 13:42:46','2015-08-03 13:42:46'),(3,'<h1 style=\"text-align: center;\"><strong>WE ARE THE VISIONARIES</strong></h1>\r\n<h1 style=\"text-align: center;\"><strong>BEHIND THE AGGRESSIVE</strong></h1>\r\n<h1 style=\"text-align: center;\"><strong>NEW YORK REAL ESTATE MARKET</strong></h1>\r\n<p style=\"font-size: 12px; font-weight: normal; text-align: start;\"> </p>\r\n<h4 style=\"text-align: center;\"><strong>With over three decades of experience and knowledge in Residential and Commercial Real Estate Development,</strong></h4>\r\n<h4 style=\"text-align: center;\"><strong>Lions Group NYC has risen as one of the most premier developers serving</strong></h4>\r\n<h4 style=\"text-align: center;\"><strong>New York with a portfolio valued over $150 Million.</strong></h4>\r\n<p style=\"font-size: 12px; font-weight: normal; text-align: start;\"> </p>\r\n<p style=\"text-align: center;\"><a title=\"learn-more\" href=\"#\">LEARN MORE</a> <a title=\"portfolio\" href=\"/portfolio\">PORTFOLIO</a></p>\r\n<h1 style=\"text-align: center;\"> </h1>','WE ARE THE VISIONARIES\r\nBEHIND THE AGGRESSIVE\r\nNEW YORK REAL ESTATE MARKET\r\n \r\nWith over three decades of experience and knowledge in Residential and Commercial Real Estate Development,\r\nLions Group NYC has risen as one of the most premier developers serving\r\nNew York with a portfolio valued over $150 Million.\r\n \r\nLEARN MORE PORTFOLIO\r\n ',NULL,3,3,'2015-08-11 12:34:41','2015-08-11 15:59:34'),(4,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>The Vista</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>44-15 Purves Street, Long Island City</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','The Vista\r\n44-15 Purves Street, Long Island City\r\ncall',NULL,3,3,'2015-08-11 12:36:45','2015-08-11 12:37:18'),(5,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>Lexington Avenue</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>229 Lexington Avenue, Manhattan</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','Lexington Avenue\r\n229 Lexington Avenue, Manhattan\r\ncall',NULL,3,3,'2015-08-11 12:37:24','2015-08-11 12:37:48'),(6,'<h2 style=\"text-align: center;\">Finest Property Selection</h2>\r\n<p style=\"text-align: center;\"><em>You are welcome to check out our house gallery to make sure that this home</em></p>\r\n<p style=\"text-align: center;\"><em>is in prime condition which makes it a perfect living space.</em></p>','Finest Property Selection\r\nYou are welcome to check out our house gallery to make sure that this home\r\nis in prime condition which makes it a perfect living space.',NULL,3,3,'2015-08-11 12:38:04','2015-08-11 12:38:16'),(7,'<p><strong>How to get started.</strong></p><p>First of all you should read about Alchemy and its architecture in the <a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/alchemy_approach.html\" target=\"_blank\" data-link-target=\"blank\">guidelines</a>.</p><p>The most important things to know about Alchemy are elements and page layouts.</p><p><span style=\"text-decoration: underline;\"><strong>Elements:</strong></span></p><p>With Alchemy you can split pages into content parts, elements. These elements can be defined out of several base content types: essences. The basic essences are:</p><ul><li>EssenceText - <em>A single line of text</em></li><li>EssenceRichtext - <em>A TinyMCE powered formatted text block</em></li><li>EssencePicture - <em>A reference to an image</em></li><li>EssenceHtml - <em>HTML embed code</em></li><li>EssenceSelect - <em>A selection of values</em></li><li>EssenceBoolean - <em>A checkbox</em></li></ul><p>Elements get defined in a YAML file <strong>config/alchemy/elements.yml</strong></p><p><a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/elements.html\" target=\"_blank\" data-link-target=\"blank\">Read more about elements and how to define them in the guidelines.</a></p><p><span style=\"text-decoration: underline;\"><strong>Page types:</strong></span></p><p>You can define several types of pages, called page layouts. You can assign elements to page layouts and control how elements and the page of a certain layout behave.</p><p>Page layouts get defined in a YAML file <strong>config/alchemy/page_layouts.yml</strong></p><p><a class=\"external\" href=\"http://guides.alchemy-cms.com/edge/page_layouts.html\" target=\"_blank\" data-link-target=\"blank\">Read more about defining page layouts in the guidelines.</a></p>','How to get started.First of all you should read about Alchemy and its architecture in the guidelines.The most important things to know about Alchemy are elements and page layouts.Elements:With Alchemy you can split pages into content parts, elements. These elements can be defined out of several base content types: essences. The basic essences are:EssenceText - A single line of textEssenceRichtext - A TinyMCE powered formatted text blockEssencePicture - A reference to an imageEssenceHtml - HTML embed codeEssenceSelect - A selection of valuesEssenceBoolean - A checkboxElements get defined in a YAML file config/alchemy/elements.ymlRead more about elements and how to define them in the guidelines.Page types:You can define several types of pages, called page layouts. You can assign elements to page layouts and control how elements and the page of a certain layout behave.Page layouts get defined in a YAML file config/alchemy/page_layouts.ymlRead more about defining page layouts in the guidelines.',NULL,3,3,'2015-08-11 15:41:35','2015-08-11 15:41:35'),(8,'<h1 style=\"text-align: center;\"><strong>THE VISTA</strong></h1>\r\n<h1 style=\"text-align: center;\"><strong>44-15 PURVES STREET</strong></h1>\r\n<h1 style=\"text-align: center;\"><strong>LONG ISLAND CITY</strong></h1>\r\n<p> </p>\r\n<h4 style=\"text-align: center;\">Check out this. Some of our new work in the Vista Property.</h4>\r\n<h4 style=\"text-align: center;\">All featured apartments are available.</h4>\r\n<p> </p>\r\n<p style=\"text-align: center;\"><a title=\"learn-more\" href=\"#\">LEARN MORE</a></p>\r\n<h1 style=\"text-align: center;\"> </h1>','THE VISTA\r\n44-15 PURVES STREET\r\nLONG ISLAND CITY\r\n \r\nCheck out this. Some of our new work in the Vista Property.\r\nAll featured apartments are available.\r\n \r\nLEARN MORE\r\n ',NULL,3,3,'2015-08-11 15:41:35','2015-08-11 15:49:38'),(9,'','',NULL,3,3,'2015-08-11 15:41:35','2015-08-11 15:55:36'),(10,'<h3 style=\"text-align: center;\"><em>Lions Goup NYC</em></h3>\r\n<h3 style=\"text-align: center;\"><em>The visionaries behind the aggressive</em></h3>\r\n<h3 style=\"text-align: center;\"><em>New York Real Estate Market</em></h3>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">Lions Goup NYC: The visionaries behind the aggressive New York Real Estate Market.</p>\r\n<p style=\"text-align: center;\">Deriving excelled projects constitutes our main objective. WIth over three decades of</p>\r\n<p style=\"text-align: center;\">experience and knowledge in residential and commercial Real Estate Development.</p>','Lions Goup NYC\r\nThe visionaries behind the aggressive\r\nNew York Real Estate Market\r\n \r\n \r\nLions Goup NYC: The visionaries behind the aggressive New York Real Estate Market.\r\nDeriving excelled projects constitutes our main objective. WIth over three decades of\r\nexperience and knowledge in residential and commercial Real Estate Development.',NULL,3,3,'2015-08-11 15:50:05','2015-08-11 15:50:08'),(11,'<h2 style=\"text-align: center;\">Finest Property Selection</h2>\r\n<p style=\"text-align: center;\"><em>You are welcome to check out our house gallery to make sure that this home</em></p>\r\n<p style=\"text-align: center;\"><em>is in prime condition which makes it a perfect living space.</em></p>','Finest Property Selection\r\nYou are welcome to check out our house gallery to make sure that this home\r\nis in prime condition which makes it a perfect living space.',NULL,3,3,'2015-08-11 15:50:20','2015-08-11 15:50:28'),(12,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>The Vista</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>44-15 Purves Street, Long Island City</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','The Vista\r\n44-15 Purves Street, Long Island City\r\ncall',NULL,3,3,'2015-08-11 15:50:52','2015-08-11 15:51:06'),(13,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>10-15 Jackson</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>10-15 Jackson Ave, Long Island City</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','10-15 Jackson\r\n10-15 Jackson Ave, Long Island City\r\ncall',NULL,3,3,'2015-08-11 15:51:54','2015-08-11 15:52:06'),(14,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>Pershing</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>141-39 Pershing Crescent, Queens</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','Pershing\r\n141-39 Pershing Crescent, Queens\r\ncall',NULL,3,3,'2015-08-11 15:52:14','2015-08-11 15:52:34'),(15,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>Briar Manor</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>143-20 Hoover Avenue, Briar Wood</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','Briar Manor\r\n143-20 Hoover Avenue, Briar Wood\r\ncall',NULL,3,3,'2015-08-11 15:52:41','2015-08-11 15:53:02'),(16,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>The Bindery</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>47-34 11th Street, Long Island City</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','The Bindery\r\n47-34 11th Street, Long Island City\r\ncall',NULL,3,3,'2015-08-11 15:53:11','2015-08-11 15:53:27'),(17,'<h2 style=\"text-align: left; padding-left: 30px;\"><strong>Mulbery Street</strong></h2>\r\n<p style=\"text-align: left; padding-left: 30px;\"><em>143- MulberyStreet, New York</em></p>\r\n<p><a title=\"Call\" href=\"#\">call</a></p>','Mulbery Street\r\n143- MulberyStreet, New York\r\ncall',NULL,3,3,'2015-08-11 15:53:38','2015-08-11 15:54:00'),(18,'<h2 style=\"text-align: center;\">Coming Soon</h2>\r\n<p style=\"text-align: center;\"><em>You are welcome to check out our house gallery to make sure that this home</em></p>\r\n<p style=\"text-align: center;\"><em>is in prime condition which makes it a perfect living space.</em></p>','Coming Soon\r\nYou are welcome to check out our house gallery to make sure that this home\r\nis in prime condition which makes it a perfect living space.',NULL,3,3,'2015-08-11 15:54:17','2015-08-11 15:54:26');

--
-- Table structure for table `alchemy_essence_selects`
--

CREATE TABLE `alchemy_essence_selects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_alchemy_essence_selects_on_value` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_selects`
--


--
-- Table structure for table `alchemy_essence_texts`
--

CREATE TABLE `alchemy_essence_texts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `body` text COLLATE utf8_unicode_ci,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link_class_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public` tinyint(1) DEFAULT '0',
  `link_target` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_texts`
--

INSERT INTO `alchemy_essence_texts` VALUES (1,'Welcome to Lions Group LLC.',NULL,NULL,NULL,0,NULL,1,1,'2015-07-24 13:25:19','2015-07-24 13:28:06'),(2,'Welcome to Lions Group LLC.',NULL,NULL,NULL,0,NULL,3,3,'2015-08-03 13:42:46','2015-08-03 13:42:46'),(3,'Welcome to your first Alchemy CMS page',NULL,NULL,NULL,0,NULL,3,3,'2015-08-11 15:41:35','2015-08-11 15:41:35');

--
-- Table structure for table `alchemy_folded_pages`
--

CREATE TABLE `alchemy_folded_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `folded` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_folded_pages`
--


--
-- Table structure for table `alchemy_languages`
--

CREATE TABLE `alchemy_languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `frontpage_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `page_layout` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'intro',
  `public` tinyint(1) DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `default` tinyint(1) DEFAULT '0',
  `country_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `site_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_alchemy_languages_on_language_code_and_country_code` (`language_code`,`country_code`),
  KEY `index_alchemy_languages_on_language_code` (`language_code`),
  KEY `index_alchemy_languages_on_site_id` (`site_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_languages`
--

INSERT INTO `alchemy_languages` VALUES (1,'English','en','Index','index',1,'2015-07-24 13:18:42','2015-07-24 13:18:42',NULL,NULL,1,'',1);

--
-- Table structure for table `alchemy_legacy_page_urls`
--

CREATE TABLE `alchemy_legacy_page_urls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `urlname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `page_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index_alchemy_legacy_page_urls_on_urlname` (`urlname`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_legacy_page_urls`
--

INSERT INTO `alchemy_legacy_page_urls` VALUES (1,'/portfolio',4,'2015-08-11 15:55:47','2015-08-11 15:55:47');

--
-- Table structure for table `alchemy_pages`
--

CREATE TABLE `alchemy_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `urlname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language_root` tinyint(1) DEFAULT NULL,
  `page_layout` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_keywords` text COLLATE utf8_unicode_ci,
  `meta_description` text COLLATE utf8_unicode_ci,
  `lft` int(11) DEFAULT NULL,
  `rgt` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `depth` int(11) DEFAULT NULL,
  `visible` tinyint(1) DEFAULT '0',
  `public` tinyint(1) DEFAULT '0',
  `locked` tinyint(1) DEFAULT '0',
  `locked_by` int(11) DEFAULT NULL,
  `restricted` tinyint(1) DEFAULT '0',
  `robot_index` tinyint(1) DEFAULT '1',
  `robot_follow` tinyint(1) DEFAULT '1',
  `sitemap` tinyint(1) DEFAULT '1',
  `layoutpage` tinyint(1) DEFAULT '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `language_id` int(11) DEFAULT NULL,
  `cached_tag_list` text COLLATE utf8_unicode_ci,
  `published_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_pages_on_language_id` (`language_id`),
  KEY `index_pages_on_parent_id_and_lft` (`parent_id`,`lft`),
  KEY `index_pages_on_urlname` (`urlname`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_pages`
--

INSERT INTO `alchemy_pages` VALUES (1,'Root',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,8,NULL,0,0,0,0,NULL,0,1,1,1,0,'2015-07-24 13:18:42','2015-08-11 15:41:35',NULL,NULL,NULL,NULL,NULL),(2,'Index','index','Index','en',1,'index',NULL,NULL,2,5,1,1,0,1,1,4,0,1,1,1,0,'2015-07-24 13:25:19','2015-08-11 15:59:34',1,3,1,NULL,'2015-08-11 15:59:50'),(3,'Layoutroot for English','',NULL,NULL,NULL,NULL,NULL,NULL,6,7,1,1,0,0,0,NULL,0,1,1,1,1,'2015-07-24 13:25:56','2015-08-11 15:41:35',1,1,1,NULL,NULL),(4,'portfolio','portfolio','portfolio','en',NULL,'portfolio',NULL,NULL,3,4,2,2,0,1,1,4,0,1,1,1,0,'2015-08-11 15:41:35','2015-08-11 15:55:36',3,3,1,NULL,'2015-08-11 15:55:50');

--
-- Table structure for table `alchemy_pictures`
--

CREATE TABLE `alchemy_pictures` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_file_width` int(11) DEFAULT NULL,
  `image_file_height` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `creator_id` int(11) DEFAULT NULL,
  `updater_id` int(11) DEFAULT NULL,
  `upload_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cached_tag_list` text COLLATE utf8_unicode_ci,
  `image_file_uid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image_file_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_pictures`
--

INSERT INTO `alchemy_pictures` VALUES (1,'GottiLogo','GottiLogo.jpg',800,703,'2015-07-24 13:27:15','2015-07-24 13:27:15',1,1,'-1060213156851431800',NULL,'2015/07/24/4v05rlucf4_GottiLogo.jpg',33272),(2,'bx loader','bx_loader.gif',32,32,'2015-08-11 12:18:32','2015-08-11 12:18:32',3,3,'-1536832194931206400',NULL,'2015/08/11/2dq04ze7jp_bx_loader.gif',8581),(3,'featured1','featured1.png',210,80,'2015-08-11 12:18:32','2015-08-11 12:18:32',3,3,'-1536832194931206400',NULL,'2015/08/11/mbnnmdvut_featured1.png',3643),(4,'featured2','featured2.png',210,80,'2015-08-11 12:18:32','2015-08-11 12:18:32',3,3,'-1536832194931206400',NULL,'2015/08/11/yym2gnxz8_featured2.png',3508),(5,'featured3','featured3.png',210,80,'2015-08-11 12:18:32','2015-08-11 12:18:32',3,3,'-1536832194931206400',NULL,'2015/08/11/4kilsab5lq_featured3.png',4991),(6,'featured4','featured4.png',210,80,'2015-08-11 12:18:32','2015-08-11 12:18:32',3,3,'-1536832194931206400',NULL,'2015/08/11/9od0p1qkwx_featured4.png',4788),(7,'icons','icons.png',256,126,'2015-08-11 12:18:32','2015-08-11 12:18:32',3,3,'-1536832194931206400',NULL,'2015/08/11/8bkiwgwyrg_icons.png',7916),(8,'logo','logo.png',181,100,'2015-08-11 12:18:33','2015-08-11 12:18:33',3,3,'-1536832194931206400',NULL,'2015/08/11/674huc19s_logo.png',5590),(9,'property-1','property-1.jpg',571,402,'2015-08-11 12:18:33','2015-08-11 12:18:33',3,3,'-1536832194931206400',NULL,'2015/08/11/6euquj25sf_property_1.jpg',56669),(10,'property-2','property-2.jpg',571,402,'2015-08-11 12:18:33','2015-08-11 12:18:33',3,3,'-1536832194931206400',NULL,'2015/08/11/3uvtg599l_property_2.jpg',53157),(11,'home-banner','home-banner.jpg',1852,842,'2015-08-11 12:18:35','2015-08-11 12:18:35',3,3,'-1536832194931206400',NULL,'2015/08/11/2iokijnxp4_home_banner.jpg',306999),(12,'quote','quote.png',80,56,'2015-08-11 15:49:10','2015-08-11 15:49:10',3,3,'2435039023884051000',NULL,'2015/08/11/938u1bcjfp_quote.png',1632),(13,'years-expertise-icon','years-expertise-icon.png',136,282,'2015-08-11 15:49:10','2015-08-11 15:49:10',3,3,'2435039023884051000',NULL,'2015/08/11/6si5n7c8c_years_expertise_icon.png',10586),(14,'happy-clients-icon','happy-clients-icon.png',136,282,'2015-08-11 15:49:10','2015-08-11 15:49:10',3,3,'2435039023884051000',NULL,'2015/08/11/7egvc4g3n3_happy_clients_icon.png',9656),(15,'square-feet-icon','square-feet-icon.png',136,282,'2015-08-11 15:49:10','2015-08-11 15:49:10',3,3,'2435039023884051000',NULL,'2015/08/11/56h8fmfgdw_square_feet_icon.png',8558),(16,'locations-icon','locations-icon.png',136,282,'2015-08-11 15:49:11','2015-08-11 15:49:11',3,3,'2435039023884051000',NULL,'2015/08/11/52giiz8tsm_locations_icon.png',10151),(17,'listing-icon','listing-icon.png',136,282,'2015-08-11 15:49:11','2015-08-11 15:49:11',3,3,'2435039023884051000',NULL,'2015/08/11/3fpvjbe5nb_listing_icon.png',9734),(18,'mulbery','mulbery.jpg',571,402,'2015-08-11 15:49:11','2015-08-11 15:49:11',3,3,'2435039023884051000',NULL,'2015/08/11/5vww4l7ip6_mulbery.jpg',68169),(19,'bindery','bindery.jpg',571,402,'2015-08-11 15:49:11','2015-08-11 15:49:11',3,3,'2435039023884051000',NULL,'2015/08/11/8rtyfefhm0_bindery.jpg',89838),(20,'briar','briar.jpg',571,402,'2015-08-11 15:49:11','2015-08-11 15:49:11',3,3,'2435039023884051000',NULL,'2015/08/11/1pxymwmo84_briar.jpg',71153),(21,'pershing','pershing.jpg',571,402,'2015-08-11 15:49:12','2015-08-11 15:49:12',3,3,'2435039023884051000',NULL,'2015/08/11/5fm7r0tzrk_pershing.jpg',84327),(22,'jackson','jackson.jpg',571,402,'2015-08-11 15:49:12','2015-08-11 15:49:12',3,3,'2435039023884051000',NULL,'2015/08/11/6rt8zxi4sq_jackson.jpg',73056),(23,'purves','purves.jpg',571,402,'2015-08-11 15:49:12','2015-08-11 15:49:12',3,3,'2435039023884051000',NULL,'2015/08/11/7gipnwcfqn_purves.jpg',86753),(24,'rego','rego.jpg',571,402,'2015-08-11 15:49:13','2015-08-11 15:49:13',3,3,'2435039023884051000',NULL,'2015/08/11/yljrvuk2c_rego.jpg',89625),(25,'vista','vista.jpg',571,402,'2015-08-11 15:49:13','2015-08-11 15:49:13',3,3,'2435039023884051000',NULL,'2015/08/11/39i948c19i_vista.jpg',87114),(26,'prop3','prop3.jpg',462,409,'2015-08-11 15:49:13','2015-08-11 15:49:13',3,3,'2435039023884051000',NULL,'2015/08/11/163f92knlf_prop3.jpg',140193),(27,'bullet-dark','bullet-dark.png',50,50,'2015-08-11 15:49:13','2015-08-11 15:49:13',3,3,'2435039023884051000',NULL,'2015/08/11/4yc26knz9f_bullet_dark.png',1692),(28,'bullet-light','bullet-light.png',50,50,'2015-08-11 15:49:13','2015-08-11 15:49:13',3,3,'2435039023884051000',NULL,'2015/08/11/8meajg6nk8_bullet_light.png',1744),(29,'prop1','prop1.jpg',463,409,'2015-08-11 15:49:14','2015-08-11 15:49:14',3,3,'2435039023884051000',NULL,'2015/08/11/7cqe50g17x_prop1.jpg',112903),(30,'prop2','prop2.jpg',463,409,'2015-08-11 15:49:14','2015-08-11 15:49:14',3,3,'2435039023884051000',NULL,'2015/08/11/3gxbhls1ii_prop2.jpg',155374),(31,'property-banner','property-banner.jpg',1852,448,'2015-08-11 15:49:14','2015-08-11 15:49:14',3,3,'2435039023884051000',NULL,'2015/08/11/1pdmyw7i45_property_banner.jpg',130711),(32,'about-banner3','about-banner3.jpg',1852,493,'2015-08-11 15:49:14','2015-08-11 15:49:14',3,3,'2435039023884051000',NULL,'2015/08/11/8rfr3ljt4w_about_banner3.jpg',92640),(33,'about-banner2','about-banner2.jpg',1852,493,'2015-08-11 15:49:15','2015-08-11 15:49:15',3,3,'2435039023884051000',NULL,'2015/08/11/8kodv1larg_about_banner2.jpg',135949),(34,'contact-map','contact-map.jpg',1852,842,'2015-08-11 15:49:15','2015-08-11 15:49:15',3,3,'2435039023884051000',NULL,'2015/08/11/5v7t10hsiq_contact_map.jpg',166002),(35,'about-banner1','about-banner1.jpg',1852,448,'2015-08-11 15:49:15','2015-08-11 15:49:15',3,3,'2435039023884051000',NULL,'2015/08/11/2q9s0mpfut_about_banner1.jpg',111788),(36,'portfolio-banner','portfolio-banner.jpg',1852,842,'2015-08-11 15:49:16','2015-08-11 15:49:16',3,3,'2435039023884051000',NULL,'2015/08/11/6u6mrvpczg_portfolio_banner.jpg',208239);

--
-- Table structure for table `alchemy_sites`
--

CREATE TABLE `alchemy_sites` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `host` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `public` tinyint(1) DEFAULT '0',
  `aliases` text COLLATE utf8_unicode_ci,
  `redirect_to_primary_host` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `alchemy_sites_public_hosts_idx` (`host`,`public`),
  KEY `index_alchemy_sites_on_host` (`host`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_sites`
--

INSERT INTO `alchemy_sites` VALUES (1,'*','Default Site','2015-07-24 13:18:42','2015-07-24 13:18:42',0,NULL,NULL);

--
-- Table structure for table `schema_migrations`
--

CREATE TABLE `schema_migrations` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `schema_migrations`
--

INSERT INTO `schema_migrations` VALUES ('20150717105319'),('20150717105320'),('20150717105321'),('20150717105322'),('20150717105323'),('20150717105324'),('20150717105325'),('20150717105332'),('20150717105333'),('20150717105334');

--
-- Table structure for table `taggings`
--

CREATE TABLE `taggings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `taggable_id` int(11) DEFAULT NULL,
  `taggable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tagger_id` int(11) DEFAULT NULL,
  `tagger_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `taggings_idx` (`tag_id`,`taggable_id`,`taggable_type`,`context`,`tagger_id`,`tagger_type`),
  KEY `index_taggings_on_taggable_id_and_taggable_type_and_context` (`taggable_id`,`taggable_type`,`context`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `taggings`
--


--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `taggings_count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_tags_on_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tags`
--



