--
-- 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=161 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),(39,'headline','Alchemy::EssenceText',4,19,1,'2015-08-12 08:58:41','2015-08-12 08:58:41',3,3),(40,'picture','Alchemy::EssencePicture',18,19,1,'2015-08-12 08:58:41','2015-08-12 08:58:41',3,3),(41,'text','Alchemy::EssenceRichtext',19,19,1,'2015-08-12 08:58:41','2015-08-12 08:58:41',3,3),(42,'bigbanner_image','Alchemy::EssencePicture',19,20,1,'2015-08-12 08:58:41','2015-08-12 08:58:41',3,3),(43,'bigbanner_caption','Alchemy::EssenceRichtext',20,20,1,'2015-08-12 08:58:41','2015-08-12 08:58:41',3,3),(44,'quote_text','Alchemy::EssenceRichtext',21,21,1,'2015-08-12 08:58:42','2015-08-12 08:58:42',3,3),(45,'bigbanner_image','Alchemy::EssencePicture',20,22,1,'2015-08-12 09:04:38','2015-08-12 09:06:59',3,3),(46,'bigbanner_caption','Alchemy::EssenceRichtext',22,22,1,'2015-08-12 09:04:38','2015-08-12 09:06:59',3,3),(47,'property','Alchemy::EssenceProperty',1,4,1,'2015-08-12 15:34:28','2015-08-12 15:39:03',3,3),(48,'property','Alchemy::EssenceProperty',2,4,2,'2015-08-12 15:34:46','2015-08-12 15:39:03',3,3),(49,'property','Alchemy::EssenceProperty',3,4,3,'2015-08-12 15:37:26','2015-08-12 15:39:03',3,3),(50,'property','Alchemy::EssenceProperty',4,4,4,'2015-08-12 15:38:14','2015-08-12 15:39:03',3,3),(51,'mediumbanner_image','Alchemy::EssencePicture',21,23,1,'2015-08-12 15:41:51','2015-08-12 15:42:04',3,3),(52,'mediumbanner_caption','Alchemy::EssenceRichtext',23,23,1,'2015-08-12 15:41:51','2015-08-12 15:42:04',3,3),(53,'common_head','Alchemy::EssenceRichtext',24,24,1,'2015-08-12 15:42:22','2015-08-12 15:42:29',3,3),(54,'mediumbanner_image','Alchemy::EssencePicture',22,25,1,'2015-08-12 15:42:50','2015-08-12 15:42:56',3,3),(55,'mediumbanner_caption','Alchemy::EssenceRichtext',25,25,1,'2015-08-12 15:42:50','2015-08-12 15:42:56',3,3),(56,'first_column','Alchemy::EssenceRichtext',26,26,1,'2015-08-12 15:43:11','2015-08-12 15:43:19',3,3),(57,'second_column','Alchemy::EssenceRichtext',27,26,2,'2015-08-12 15:43:11','2015-08-12 15:43:19',3,3),(58,'mediumbanner_image','Alchemy::EssencePicture',23,27,1,'2015-08-12 15:43:58','2015-08-12 15:44:03',3,3),(59,'mediumbanner_caption','Alchemy::EssenceRichtext',28,27,1,'2015-08-12 15:43:58','2015-08-12 15:44:03',3,3),(60,'common_head','Alchemy::EssenceRichtext',29,28,1,'2015-08-12 15:44:16','2015-08-12 15:44:18',3,3),(61,'its_image','Alchemy::EssencePicture',24,29,1,'2015-08-12 15:44:32','2015-08-12 15:45:27',3,3),(62,'its_description','Alchemy::EssenceRichtext',30,29,1,'2015-08-12 15:44:32','2015-08-12 15:45:27',3,3),(63,'its_image','Alchemy::EssencePicture',25,30,1,'2015-08-12 15:45:38','2015-08-12 15:45:58',3,3),(64,'its_description','Alchemy::EssenceRichtext',31,30,1,'2015-08-12 15:45:38','2015-08-12 15:45:58',3,3),(65,'property','Alchemy::EssenceProperty',5,31,1,'2015-08-12 15:48:06','2015-08-12 15:56:12',3,3),(66,'property','Alchemy::EssenceProperty',6,31,2,'2015-08-12 15:48:41','2015-08-12 15:56:12',3,3),(67,'property','Alchemy::EssenceProperty',7,31,3,'2015-08-12 15:49:29','2015-08-12 15:56:12',3,3),(68,'property','Alchemy::EssenceProperty',8,31,4,'2015-08-12 15:50:56','2015-08-12 15:56:12',3,3),(69,'property','Alchemy::EssenceProperty',9,31,5,'2015-08-12 15:51:35','2015-08-12 15:56:12',3,3),(70,'property','Alchemy::EssenceProperty',10,31,6,'2015-08-12 15:52:25','2015-08-12 15:56:12',3,3),(71,'property','Alchemy::EssenceProperty',11,31,7,'2015-08-12 15:53:10','2015-08-12 15:56:12',3,3),(72,'property','Alchemy::EssenceProperty',12,31,8,'2015-08-12 15:53:36','2015-08-12 15:56:12',3,3),(73,'common_head','Alchemy::EssenceRichtext',32,32,1,'2015-08-12 16:03:41','2015-08-12 16:03:46',3,3),(74,'common_head','Alchemy::EssenceRichtext',33,33,1,'2015-08-12 16:04:26','2015-08-12 16:04:29',3,3),(75,'logo_image','Alchemy::EssencePicture',26,34,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(76,'headline','Alchemy::EssenceText',5,35,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(77,'picture','Alchemy::EssencePicture',27,35,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(78,'text','Alchemy::EssenceRichtext',34,35,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(79,'bigbanner_image','Alchemy::EssencePicture',28,36,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(80,'bigbanner_caption','Alchemy::EssenceRichtext',35,36,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(81,'quote_text','Alchemy::EssenceRichtext',36,37,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(82,'copyright_text','Alchemy::EssenceRichtext',37,38,1,'2015-08-13 16:32:15','2015-08-13 16:32:15',4,4),(83,'bigbanner_image','Alchemy::EssencePicture',29,39,1,'2015-08-13 16:33:41','2015-08-13 16:34:17',4,4),(84,'bigbanner_caption','Alchemy::EssenceRichtext',38,39,1,'2015-08-13 16:33:41','2015-08-13 16:34:17',4,4),(85,'property_img','Alchemy::EssencePicture',30,40,1,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4),(86,'property_captions','Alchemy::EssenceRichtext',39,40,1,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4),(87,'property','Alchemy::EssenceProperty',13,40,1,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4),(88,'property','Alchemy::EssenceProperty',14,40,2,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4),(89,'property','Alchemy::EssenceProperty',15,40,3,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4),(90,'property','Alchemy::EssenceProperty',16,40,4,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4),(91,'common_head','Alchemy::EssenceRichtext',40,41,1,'2015-08-13 16:34:01','2015-08-13 16:34:02',4,4),(92,'logo_image','Alchemy::EssencePicture',31,42,1,'2015-08-13 16:38:37','2015-08-13 17:39:00',4,4),(93,'copyright_text','Alchemy::EssenceRichtext',41,43,1,'2015-08-13 16:39:52','2015-08-13 16:43:01',4,4),(94,'menu_links','Alchemy::EssenceText',6,43,1,'2015-08-13 16:40:39','2015-08-13 16:43:01',4,4),(95,'menu_links','Alchemy::EssenceText',7,43,2,'2015-08-13 16:40:42','2015-08-13 16:43:01',4,4),(96,'menu_links','Alchemy::EssenceText',8,43,3,'2015-08-13 16:40:44','2015-08-13 16:43:01',4,4),(97,'menu_links','Alchemy::EssenceText',9,43,4,'2015-08-13 16:40:46','2015-08-13 16:43:01',4,4),(98,'menu_links','Alchemy::EssenceText',10,43,5,'2015-08-13 16:40:49','2015-08-13 16:43:01',4,4),(99,'menu_links','Alchemy::EssenceText',11,43,6,'2015-08-13 16:40:53','2015-08-13 16:43:01',4,4),(100,'logo_image','Alchemy::EssencePicture',32,44,1,'2015-08-13 16:43:53','2015-08-13 17:39:20',4,4),(101,'logo_image','Alchemy::EssencePicture',33,45,1,'2015-08-13 16:45:26','2015-08-13 17:39:13',4,4),(102,'copyright_text','Alchemy::EssenceRichtext',42,46,1,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(103,'menu_links','Alchemy::EssenceText',12,46,1,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(104,'menu_links','Alchemy::EssenceText',13,46,2,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(105,'menu_links','Alchemy::EssenceText',14,46,3,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(106,'menu_links','Alchemy::EssenceText',15,46,4,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(107,'menu_links','Alchemy::EssenceText',16,46,5,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(108,'menu_links','Alchemy::EssenceText',17,46,6,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4),(109,'logo_image','Alchemy::EssencePicture',34,47,1,'2015-08-13 16:46:46','2015-08-13 17:35:59',4,4),(110,'copyright_text','Alchemy::EssenceRichtext',43,48,1,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(111,'menu_links','Alchemy::EssenceText',18,48,1,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(112,'menu_links','Alchemy::EssenceText',19,48,2,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(113,'menu_links','Alchemy::EssenceText',20,48,3,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(114,'menu_links','Alchemy::EssenceText',21,48,4,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(115,'menu_links','Alchemy::EssenceText',22,48,5,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(116,'menu_links','Alchemy::EssenceText',23,48,6,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4),(117,'headline','Alchemy::EssenceText',24,49,1,'2015-08-13 16:47:37','2015-08-13 16:47:37',4,4),(118,'picture','Alchemy::EssencePicture',35,49,1,'2015-08-13 16:47:37','2015-08-13 16:47:37',4,4),(119,'text','Alchemy::EssenceRichtext',44,49,1,'2015-08-13 16:47:37','2015-08-13 16:47:37',4,4),(120,'copyright_text','Alchemy::EssenceRichtext',45,50,1,'2015-08-13 16:47:37','2015-08-13 16:47:37',4,4),(121,'copyright_text','Alchemy::EssenceRichtext',46,51,1,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(122,'menu_links','Alchemy::EssenceText',25,51,1,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(123,'menu_links','Alchemy::EssenceText',26,51,2,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(124,'menu_links','Alchemy::EssenceText',27,51,3,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(125,'menu_links','Alchemy::EssenceText',28,51,4,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(126,'menu_links','Alchemy::EssenceText',29,51,5,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(127,'menu_links','Alchemy::EssenceText',30,51,6,'2015-08-13 16:48:07','2015-08-13 16:48:07',4,4),(128,'logo_image','Alchemy::EssencePicture',36,52,1,'2015-08-13 16:49:47','2015-08-13 17:39:35',4,4),(129,'banner','Alchemy::EssencePicture',37,53,1,'2015-08-13 16:49:47','2015-08-13 17:39:31',4,4),(130,'title','Alchemy::EssenceText',31,53,1,'2015-08-13 16:49:47','2015-08-13 17:39:31',4,4),(131,'title','Alchemy::EssenceText',32,54,1,'2015-08-13 16:49:47','2015-08-13 17:05:56',4,4),(132,'description','Alchemy::EssenceRichtext',47,54,1,'2015-08-13 16:49:47','2015-08-13 17:05:56',4,4),(133,'title','Alchemy::EssenceText',33,55,1,'2015-08-13 16:49:47','2015-08-13 17:08:12',4,4),(134,'description','Alchemy::EssenceRichtext',48,55,1,'2015-08-13 16:49:47','2015-08-13 17:08:12',4,4),(135,'copyright_text','Alchemy::EssenceRichtext',49,56,1,'2015-08-13 16:49:47','2015-08-13 16:49:47',4,4),(136,'copyright_text','Alchemy::EssenceRichtext',50,57,1,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(137,'menu_links','Alchemy::EssenceText',34,57,1,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(138,'menu_links','Alchemy::EssenceText',35,57,2,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(139,'menu_links','Alchemy::EssenceText',36,57,3,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(140,'menu_links','Alchemy::EssenceText',37,57,4,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(141,'menu_links','Alchemy::EssenceText',38,57,5,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(142,'menu_links','Alchemy::EssenceText',39,57,6,'2015-08-13 17:10:00','2015-08-13 17:10:00',4,4),(143,'essence_picture_1','Alchemy::EssencePicture',38,58,1,'2015-08-13 17:11:03','2015-08-13 17:12:38',4,4),(144,'essence_picture_2','Alchemy::EssencePicture',39,58,2,'2015-08-13 17:11:08','2015-08-13 17:12:38',4,4),(145,'essence_picture_3','Alchemy::EssencePicture',40,58,3,'2015-08-13 17:11:13','2015-08-13 17:12:38',4,4),(146,'essence_picture_4','Alchemy::EssencePicture',41,58,4,'2015-08-13 17:11:17','2015-08-13 17:12:38',4,4),(147,'essence_picture_1','Alchemy::EssencePicture',42,59,1,'2015-08-13 17:11:45','2015-08-13 17:12:40',4,4),(148,'essence_picture_2','Alchemy::EssencePicture',43,59,2,'2015-08-13 17:11:49','2015-08-13 17:12:40',4,4),(149,'essence_picture_3','Alchemy::EssencePicture',44,59,3,'2015-08-13 17:11:52','2015-08-13 17:12:40',4,4),(150,'essence_picture_4','Alchemy::EssencePicture',45,59,4,'2015-08-13 17:11:54','2015-08-13 17:12:40',4,4),(151,'map','Alchemy::EssenceHtml',1,60,1,'2015-08-13 17:12:46','2015-08-13 17:22:23',4,4),(152,'street_view','Alchemy::EssenceHtml',2,61,1,'2015-08-13 17:13:04','2015-08-13 17:22:21',4,4);

--
-- 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=67 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-13 16:32:48',3,4,NULL,NULL),(4,'propertylist',3,2,1,0,0,'2015-08-11 12:36:45','2015-08-12 15:39:03',3,3,NULL,''),(5,'propertylist',NULL,2,0,1,0,'2015-08-11 12:37:24','2015-08-12 15:34:26',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',2,4,1,1,0,'2015-08-11 15:41:35','2015-08-11 15:49:48',3,3,NULL,NULL),(9,'slider',7,4,1,1,1,'2015-08-11 15:41:35','2015-08-12 15:47:22',3,3,NULL,NULL),(10,'common_heading',3,4,1,1,0,'2015-08-11 15:50:05','2015-08-11 15:50:10',3,3,NULL,NULL),(11,'common_heading',4,4,1,1,0,'2015-08-11 15:50:20','2015-08-11 15:50:34',3,3,NULL,NULL),(12,'propertylist',NULL,4,0,1,0,'2015-08-11 15:50:52','2015-08-12 15:46:49',3,3,NULL,''),(13,'propertylist',NULL,4,0,1,0,'2015-08-11 15:51:54','2015-08-12 15:47:37',3,3,NULL,''),(14,'propertylist',NULL,4,0,1,0,'2015-08-11 15:52:14','2015-08-12 15:46:57',3,3,NULL,''),(15,'propertylist',NULL,4,0,1,0,'2015-08-11 15:52:41','2015-08-12 15:47:02',3,3,NULL,''),(16,'propertylist',NULL,4,0,1,0,'2015-08-11 15:53:11','2015-08-12 15:47:05',3,3,NULL,''),(17,'propertylist',NULL,4,0,1,0,'2015-08-11 15:53:38','2015-08-12 15:47:10',3,3,NULL,''),(18,'common_heading',6,4,1,1,0,'2015-08-11 15:54:17','2015-08-11 15:54:27',3,3,NULL,NULL),(19,'article',NULL,5,0,1,1,'2015-08-12 08:58:41','2015-08-12 08:58:58',3,3,NULL,NULL),(20,'bigbanner',NULL,5,0,1,0,'2015-08-12 08:58:41','2015-08-12 08:58:48',3,3,NULL,NULL),(21,'slider',NULL,5,0,1,1,'2015-08-12 08:58:42','2015-08-12 08:58:52',3,3,NULL,NULL),(22,'bigbanner',NULL,5,0,1,0,'2015-08-12 09:04:38','2015-08-12 09:15:16',3,3,NULL,NULL),(23,'mediumbanner',1,5,1,1,0,'2015-08-12 15:41:51','2015-08-13 17:35:36',3,4,NULL,NULL),(24,'common_heading',2,5,1,1,0,'2015-08-12 15:42:22','2015-08-12 15:42:47',3,3,NULL,NULL),(25,'mediumbanner',3,5,1,1,0,'2015-08-12 15:42:50','2015-08-12 15:42:58',3,3,NULL,NULL),(26,'two_column_text',4,5,1,1,0,'2015-08-12 15:43:11','2015-08-13 16:45:17',3,4,NULL,NULL),(27,'mediumbanner',5,5,1,1,0,'2015-08-12 15:43:58','2015-08-12 15:44:12',3,3,NULL,NULL),(28,'common_heading',6,5,1,1,0,'2015-08-12 15:44:16','2015-08-12 15:44:20',3,3,NULL,NULL),(29,'chairperson',7,5,1,1,0,'2015-08-12 15:44:32','2015-08-13 16:45:19',3,4,NULL,NULL),(30,'chairperson',8,5,1,1,0,'2015-08-12 15:45:38','2015-08-13 16:45:21',3,4,NULL,NULL),(31,'propertylist',5,4,1,1,0,'2015-08-12 15:47:16','2015-08-13 16:44:52',3,4,NULL,''),(32,'common_heading',1,6,1,1,0,'2015-08-12 16:03:41','2015-08-13 16:46:40',3,4,NULL,NULL),(33,'common_heading',2,6,1,1,0,'2015-08-12 16:04:26','2015-08-13 16:46:42',3,4,NULL,NULL),(34,'horizontal_header_bar',NULL,7,0,1,1,'2015-08-13 16:32:15','2015-08-13 16:32:33',4,4,NULL,NULL),(35,'article',NULL,7,0,1,1,'2015-08-13 16:32:15','2015-08-13 16:32:30',4,4,NULL,NULL),(36,'bigbanner',NULL,7,0,1,0,'2015-08-13 16:32:15','2015-08-13 16:32:28',4,4,NULL,NULL),(37,'slider',NULL,7,0,1,1,'2015-08-13 16:32:15','2015-08-13 16:32:26',4,4,NULL,NULL),(38,'horizontal_footer_bar',NULL,7,0,1,1,'2015-08-13 16:32:15','2015-08-13 16:32:24',4,4,NULL,NULL),(39,'bigbanner',2,7,1,0,0,'2015-08-13 16:33:41','2015-08-13 16:34:17',4,4,NULL,NULL),(40,'propertylist',3,7,1,0,0,'2015-08-13 16:33:55','2015-08-13 16:33:55',4,4,NULL,NULL),(41,'common_heading',4,7,1,0,0,'2015-08-13 16:34:01','2015-08-13 16:34:02',4,4,NULL,NULL),(42,'horizontal_header_bar',1,7,1,0,1,'2015-08-13 16:38:37','2015-08-13 17:39:00',4,4,NULL,NULL),(43,'horizontal_footer_bar',5,7,1,0,1,'2015-08-13 16:39:52','2015-08-13 16:43:01',4,4,NULL,NULL),(44,'horizontal_header_bar',1,4,1,0,1,'2015-08-13 16:43:53','2015-08-13 17:39:20',4,4,NULL,NULL),(45,'horizontal_header_bar',9,5,1,0,1,'2015-08-13 16:45:26','2015-08-13 17:39:13',4,4,NULL,NULL),(46,'horizontal_footer_bar',10,5,1,0,1,'2015-08-13 16:45:37','2015-08-13 16:45:37',4,4,NULL,NULL),(47,'horizontal_header_bar',3,6,1,0,1,'2015-08-13 16:46:46','2015-08-13 17:35:59',4,4,NULL,NULL),(48,'horizontal_footer_bar',4,6,1,0,1,'2015-08-13 16:46:52','2015-08-13 16:46:52',4,4,NULL,NULL),(49,'article',NULL,4,0,1,1,'2015-08-13 16:47:37','2015-08-13 16:49:09',4,4,NULL,NULL),(50,'horizontal_footer_bar',NULL,4,0,1,1,'2015-08-13 16:47:37','2015-08-13 16:48:04',4,4,NULL,NULL),(51,'horizontal_footer_bar',8,4,1,1,1,'2015-08-13 16:48:07','2015-08-13 16:49:06',4,4,NULL,NULL),(52,'horizontal_header_bar',1,8,1,0,1,'2015-08-13 16:49:47','2015-08-13 17:39:35',4,4,NULL,NULL),(53,'property_banner',2,8,1,0,1,'2015-08-13 16:49:47','2015-08-13 17:39:31',4,4,NULL,NULL),(54,'property_description',3,8,1,1,1,'2015-08-13 16:49:47','2015-08-13 17:10:13',4,4,NULL,NULL),(55,'property_features',4,8,1,1,1,'2015-08-13 16:49:47','2015-08-13 17:10:42',4,4,NULL,NULL),(56,'horizontal_footer_bar',NULL,8,0,1,1,'2015-08-13 16:49:47','2015-08-13 17:09:56',4,4,NULL,NULL),(57,'horizontal_footer_bar',5,8,1,1,1,'2015-08-13 17:10:00','2015-08-13 17:10:04',4,4,NULL,NULL),(58,'property_media',6,8,1,0,1,'2015-08-13 17:10:50','2015-08-13 17:12:38',4,4,NULL,NULL),(59,'property_floor_plan',7,8,1,0,1,'2015-08-13 17:11:35','2015-08-13 17:12:40',4,4,NULL,NULL),(60,'property_map',8,8,1,0,1,'2015-08-13 17:12:46','2015-08-13 17:22:23',4,4,NULL,NULL),(61,'property_street_view',9,8,1,0,1,'2015-08-13 17:13:04','2015-08-13 17:22:21',4,4,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),(19,5),(20,5),(21,5),(22,5),(23,5),(24,5),(25,5),(26,5),(27,5),(28,5),(29,5),(30,5),(31,4),(32,6),(33,6),(34,7),(35,7),(36,7),(37,7),(38,7),(39,7),(40,7),(41,7),(42,7),(43,7),(44,4),(45,5),(46,5),(47,6),(48,6),(49,4),(50,4),(51,4),(52,8),(53,8),(54,8),(55,8),(56,8),(57,8),(58,8),(59,8),(60,8),(61,8);

--
-- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

INSERT INTO `alchemy_essence_htmls` VALUES (1,'<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d6047.908127619884!2d-73.9303239486497!3d40.74027523138948!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x89c25ed246e2917f%3A0x27a2020f7a81740d!2s47+34th+St%2C+Long+Island+City%2C+NY+11101%2C+USA!5e0!3m2!1sen!2sin!4v1439486139518\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0\" allowfullscreen></iframe>',4,4,'2015-08-13 17:12:46','2015-08-13 17:18:15'),(2,'<iframe src=\"https://www.google.com/maps/embed?pb=!1m0!3m2!1sen!2sin!4v1439486384598!6m8!1m7!1sAu3Ie3jbfcaz8gym86eM-A!2m2!1d40.74000583888255!2d-73.93168215595169!3f358.48130326367857!4f0.01651113573777252!5f0.7820865974627469\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0\" allowfullscreen></iframe>',4,4,'2015-08-13 17:13:04','2015-08-13 17:22:21');

--
-- 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=49 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),(18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,3,'2015-08-12 08:58:41','2015-08-12 08:58:41','','',NULL),(19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3,3,'2015-08-12 08:58:41','2015-08-12 08:58:41','','',NULL),(20,35,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-12 09:04:38','2015-08-12 09:06:59','','',NULL),(21,35,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-12 15:41:51','2015-08-12 15:42:04','','',NULL),(22,33,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-12 15:42:50','2015-08-12 15:42:56','','',NULL),(23,32,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-12 15:43:58','2015-08-12 15:44:03','','',NULL),(24,38,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-12 15:44:32','2015-08-12 15:45:27','','',NULL),(25,39,NULL,NULL,NULL,'','','',NULL,'',3,3,'2015-08-12 15:45:38','2015-08-12 15:45:58','','',NULL),(26,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15','','',NULL),(27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15','','',NULL),(28,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15','','',NULL),(29,11,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:33:41','2015-08-13 16:33:41','','',NULL),(30,9,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:33:55','2015-08-13 16:33:55','','',NULL),(31,8,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:38:37','2015-08-13 16:39:21','','',NULL),(32,8,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:43:53','2015-08-13 16:43:53','','',NULL),(33,8,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:45:26','2015-08-13 16:45:26','','',NULL),(34,8,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:46:46','2015-08-13 16:46:46','','',NULL),(35,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,4,'2015-08-13 16:47:37','2015-08-13 16:47:37','','',NULL),(36,8,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:49:47','2015-08-13 16:50:03','','',NULL),(37,40,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 16:49:47','2015-08-13 16:51:24','','',NULL),(38,21,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:03','2015-08-13 17:11:24','','',NULL),(39,37,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:08','2015-08-13 17:12:38','','',NULL),(40,20,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:13','2015-08-13 17:12:38','','',NULL),(41,21,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:17','2015-08-13 17:11:24','','',NULL),(42,37,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:45','2015-08-13 17:12:20','','',NULL),(43,40,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:49','2015-08-13 17:12:20','','',NULL),(44,20,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:52','2015-08-13 17:12:20','','',NULL),(45,9,NULL,NULL,NULL,'','','',NULL,'',4,4,'2015-08-13 17:11:54','2015-08-13 17:12:20','','',NULL);

--
-- Table structure for table `alchemy_essence_properties`
--

CREATE TABLE `alchemy_essence_properties` (
  `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,
  `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,
  `body` text COLLATE utf8_unicode_ci,
  `stripped_body` text COLLATE utf8_unicode_ci,
  `public` tinyint(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `alchemy_essence_properties`
--

INSERT INTO `alchemy_essence_properties` VALUES (1,25,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2>The Vista</h2>\r\n<p>44-15 Purves Street, Long Island City</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','The Vista\r\n44-15 Purves Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-12 15:34:28','2015-08-12 15:34:41'),(2,37,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2>Lexington Avenue</h2>\r\n<p>229 lexington Avenue, Manhattan</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Lexington Avenue\r\n229 lexington Avenue, Manhattan\r\nCall\r\n ',NULL,'2015-08-12 15:34:46','2015-08-12 15:38:13'),(3,20,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2>Bindery</h2>\r\n<p>47-34 11th Street, Long Island City</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Bindery\r\n47-34 11th Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-12 15:37:26','2015-08-12 15:38:13'),(4,24,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2>Rego Modern</h2>\r\n<p>99-39 60th Ave, Rego Park</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Rego Modern\r\n99-39 60th Ave, Rego Park\r\nCall\r\n ',NULL,'2015-08-12 15:38:14','2015-08-12 15:39:03'),(5,25,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">The Vista</h2>\r\n<p style=\"text-align: left;\">44-15 Purves Street, Long Island City</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','The Vista\r\n44-15 Purves Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-12 15:48:06','2015-08-12 15:55:21'),(6,22,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">10-50 Jackson</h2>\r\n<p style=\"text-align: left;\">10-50 Jackson Avenue, Long Island City</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','10-50 Jackson\r\n10-50 Jackson Avenue, Long Island City\r\nCall\r\n ',NULL,'2015-08-12 15:48:41','2015-08-12 15:55:21'),(7,23,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">44-27 Purves</h2>\r\n<p style=\"text-align: left;\">44-27 Purves Street, Long Island City</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','44-27 Purves\r\n44-27 Purves Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-12 15:49:29','2015-08-12 15:55:21'),(8,24,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">Rego Modern</h2>\r\n<p style=\"text-align: left;\">99-39 66th Ave, Rego Park</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','Rego Modern\r\n99-39 66th Ave, Rego Park\r\nCall\r\n ',NULL,'2015-08-12 15:50:56','2015-08-12 15:55:21'),(9,21,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">Pershing</h2>\r\n<p style=\"text-align: left;\">141-39 Pershing Crescent, Queens</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','Pershing\r\n141-39 Pershing Crescent, Queens\r\nCall\r\n ',NULL,'2015-08-12 15:51:35','2015-08-12 15:55:21'),(10,20,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">Briar Manor</h2>\r\n<p style=\"text-align: left;\">143-20 Hoover Avenue, Briar Wood</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','Briar Manor\r\n143-20 Hoover Avenue, Briar Wood\r\nCall\r\n ',NULL,'2015-08-12 15:52:25','2015-08-12 15:55:21'),(11,19,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">The Bindery</h2>\r\n<p style=\"text-align: left;\">47-34 11th Street, Long Island City</p>\r\n<p style=\"text-align: left;\"><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p style=\"text-align: left;\"> </p>','The Bindery\r\n47-34 11th Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-12 15:53:10','2015-08-12 15:55:21'),(12,18,NULL,NULL,NULL,'','','',NULL,'',3,3,'','',NULL,'<h2 style=\"text-align: left;\">Mulbery Street</h2>\r\n<p>143 Mulbery Street, New York</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Mulbery Street\r\n143 Mulbery Street, New York\r\nCall\r\n ',NULL,'2015-08-12 15:53:36','2015-08-12 15:56:12'),(13,25,NULL,NULL,NULL,'','','',NULL,'',4,4,'','',NULL,'<h2>The Vista</h2>\r\n<p>44-15 Purves Street, Long Island City</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','The Vista\r\n44-15 Purves Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-13 16:33:55','2015-08-13 16:33:55'),(14,37,NULL,NULL,NULL,'','','',NULL,'',4,4,'','',NULL,'<h2>Lexington Avenue</h2>\r\n<p>229 lexington Avenue, Manhattan</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Lexington Avenue\r\n229 lexington Avenue, Manhattan\r\nCall\r\n ',NULL,'2015-08-13 16:33:55','2015-08-13 16:33:55'),(15,20,NULL,NULL,NULL,'','','',NULL,'',4,4,'','',NULL,'<h2>Bindery</h2>\r\n<p>47-34 11th Street, Long Island City</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Bindery\r\n47-34 11th Street, Long Island City\r\nCall\r\n ',NULL,'2015-08-13 16:33:55','2015-08-13 16:33:55'),(16,24,NULL,NULL,NULL,'','','',NULL,'',4,4,'','',NULL,'<h2>Rego Modern</h2>\r\n<p>99-39 60th Ave, Rego Park</p>\r\n<p><a title=\"Call\" href=\"#\">Call</a></p>\r\n<p> </p>','Rego Modern\r\n99-39 60th Ave, Rego Park\r\nCall\r\n ',NULL,'2015-08-13 16:33:55','2015-08-13 16:33:55');

--
-- 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=55 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'),(19,'<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-12 08:58:41','2015-08-12 08:58:41'),(20,NULL,NULL,NULL,3,3,'2015-08-12 08:58:41','2015-08-12 08:58:41'),(21,NULL,NULL,NULL,3,3,'2015-08-12 08:58:42','2015-08-12 08:58:42'),(22,'<h1 style=\"text-align: center;\"><strong>MORE THAN 25 YEARS</strong></h1>\r\n<h1 style=\"text-align: center;\"><strong>IN THE REAL ESTATE</strong></h1>\r\n<h1 style=\"text-align: center;\"><strong>BUSINESS</strong></h1>','MORE THAN 25 YEARS\r\nIN THE REAL ESTATE\r\nBUSINESS',NULL,3,3,'2015-08-12 09:04:38','2015-08-12 09:06:59'),(23,'<h2 style=\"text-align: center;\"><strong>MORE THAN 25 YEARS </strong></h2>\r\n<h2 style=\"text-align: center;\"><strong>IN THE REAL ESTATE</strong></h2>\r\n<h2 style=\"text-align: center;\"><strong>BUSINESS</strong></h2>','MORE THAN 25 YEARS \r\nIN THE REAL ESTATE\r\nBUSINESS',NULL,3,3,'2015-08-12 15:41:51','2015-08-12 15:42:04'),(24,'<h2 style=\"text-align: center;\">We take pride in what we do</h2>\r\n<p style=\"text-align: center;\"> </p>\r\n<h3 style=\"text-align: center;\"><em>Lions Group 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>NewYork Real Estate Market</em></h3>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">Lions Group NYC: The visionaries behind the aggressive New York Real Estate market. Deriving excelled projects constitutes our main objective. With over three decades of experience and knowledge in residential and commercial Real Estate development, Lions Group NYC has risen as one of the most premier developers serving New York with a portfolio valued over $150 Million. </p>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">Family-owned and managed, the Lions Group NYC focuses on acquisition, development, construction and management of residential, commercial and retail properties; currently holding and operating over 500,000 square feet of luxury condominiums, quality rental buildings and commercial spaces throughout the Metropolitan area as well as custom luxury residences in the north shore of Long Island also known as the Gold Coast.</p>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">The firm is committed to every project, big or small, insuring super results in design and construction, maximizing returns and profitability to its investors. Its consistence and careful planning, along with a team of dedicated professionals, has transformed Lions Group NYC into the business-passionate and growing company which is today, and which continues to strive for absolute excellence.</p>','We take pride in what we do\r\n \r\nLions Group NYC\r\nThe visionaries behind the aggressive\r\nNewYork Real Estate Market\r\n \r\nLions Group NYC: The visionaries behind the aggressive New York Real Estate market. Deriving excelled projects constitutes our main objective. With over three decades of experience and knowledge in residential and commercial Real Estate development, Lions Group NYC has risen as one of the most premier developers serving New York with a portfolio valued over $150 Million. \r\n \r\nFamily-owned and managed, the Lions Group NYC focuses on acquisition, development, construction and management of residential, commercial and retail properties; currently holding and operating over 500,000 square feet of luxury condominiums, quality rental buildings and commercial spaces throughout the Metropolitan area as well as custom luxury residences in the north shore of Long Island also known as the Gold Coast.\r\n \r\nThe firm is committed to every project, big or small, insuring super results in design and construction, maximizing returns and profitability to its investors. Its consistence and careful planning, along with a team of dedicated professionals, has transformed Lions Group NYC into the business-passionate and growing company which is today, and which continues to strive for absolute excellence.',NULL,3,3,'2015-08-12 15:42:22','2015-08-12 15:42:29'),(25,'<h2 style=\"text-align: center;\"><strong>THIS IS HOW</strong></h2>\r\n<h2 style=\"text-align: center;\"><strong>IT ALL BEGAN</strong></h2>','THIS IS HOW\r\nIT ALL BEGAN',NULL,3,3,'2015-08-12 15:42:50','2015-08-12 15:42:56'),(26,'<p style=\"text-align: justify;\">Lions Group NYC: The visionaries behind the aggressive New York Real Estate market. Deriving excelled projects constitutes our main objective. With over three decades of experience and knowledge in residential and commercial Real Estate development, Lions Group NYC has risen as one of the most premier developers serving New York with a portfolio valued over $150 Million. </p>\r\n<p style=\"text-align: justify;\">Family-owned and managed, the Lions Group NYC focuses on acquisition, development, construction and management of residential, commercial and retail properties; currently holding and operating over 500,000 square feet of luxury condominiums, quality rental buildings and commercial spaces throughout the Metropolitan area as well as custom luxury residences in the north shore of Long Island also known as the Gold Coast.</p>','Lions Group NYC: The visionaries behind the aggressive New York Real Estate market. Deriving excelled projects constitutes our main objective. With over three decades of experience and knowledge in residential and commercial Real Estate development, Lions Group NYC has risen as one of the most premier developers serving New York with a portfolio valued over $150 Million. \r\nFamily-owned and managed, the Lions Group NYC focuses on acquisition, development, construction and management of residential, commercial and retail properties; currently holding and operating over 500,000 square feet of luxury condominiums, quality rental buildings and commercial spaces throughout the Metropolitan area as well as custom luxury residences in the north shore of Long Island also known as the Gold Coast.',NULL,3,3,'2015-08-12 15:43:11','2015-08-12 15:43:19'),(27,'<p style=\"text-align: justify;\">We recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification. While some in our industry may not share our passion for quality, our experience has taught us that such real estate developers never do well. It is our philosophy at Lions Group NYC that the path to prosperity is by making our city a better place to live.</p>\r\n<p style=\"text-align: justify;\">Our mission is to aid our city\'s continuous transformation into one that all New Yorkers can be proud of: a city of luxury, comfort and beauty. By closely listening to the wishes of our consumers, we can be keen to the needs of our communities and develop land into precisely what it needs to be for its inhabitants. Our mission is to give the people of New York the city they envision for themselves.</p>\r\n<p style=\"text-align: justify;\"> </p>','We recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification. While some in our industry may not share our passion for quality, our experience has taught us that such real estate developers never do well. It is our philosophy at Lions Group NYC that the path to prosperity is by making our city a better place to live.\r\nOur mission is to aid our city\'s continuous transformation into one that all New Yorkers can be proud of: a city of luxury, comfort and beauty. By closely listening to the wishes of our consumers, we can be keen to the needs of our communities and develop land into precisely what it needs to be for its inhabitants. Our mission is to give the people of New York the city they envision for themselves.\r\n ',NULL,3,3,'2015-08-12 15:43:11','2015-08-12 15:43:19'),(28,'<h2 style=\"text-align: center;\"><strong>OUR MISSION AND</strong></h2>\r\n<h2 style=\"text-align: center;\"><strong>PHILOSOPHY</strong></h2>','OUR MISSION AND\r\nPHILOSOPHY',NULL,3,3,'2015-08-12 15:43:58','2015-08-12 15:44:03'),(29,'<h3 style=\"text-align: center;\"><em>Our Mission</em></h3>\r\n<p style=\"text-align: center;\"> Our mission is to aid our city\'s continuous transformation into one that all New Yorkers can be proud of: a city of luxury, comfort and beauty.</p>\r\n<p style=\"text-align: center;\"> By closely listening to the wishes of our consumers, we can be keen to the needs of our communities and develop land into precisely what it needs to be for its inhabitants.</p>\r\n<p style=\"text-align: center;\">Our mission is to give the people of New York the city they envision for themselves.</p>\r\n<p> </p>\r\n<h3 style=\"text-align: center;\"><em>Our Philosophy</em></h3>\r\n<p style=\"text-align: center;\"> We recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification.</p>\r\n<p style=\"text-align: center;\"> While some in our industry may not share our passion for quality, our experience has taught us that such real estate developers never do well. It is our philosophy at Lions Group NYC that the path to prosperity is by making our city a better place to live.</p>','Our Mission\r\n Our mission is to aid our city\'s continuous transformation into one that all New Yorkers can be proud of: a city of luxury, comfort and beauty.\r\n By closely listening to the wishes of our consumers, we can be keen to the needs of our communities and develop land into precisely what it needs to be for its inhabitants.\r\nOur mission is to give the people of New York the city they envision for themselves.\r\n \r\nOur Philosophy\r\n We recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification.\r\n While some in our industry may not share our passion for quality, our experience has taught us that such real estate developers never do well. It is our philosophy at Lions Group NYC that the path to prosperity is by making our city a better place to live.',NULL,3,3,'2015-08-12 15:44:16','2015-08-12 15:44:18'),(30,'<h3 style=\"text-align: center;\"><strong>Alexander D. Harrington</strong></h3>\r\n<p style=\"text-align: center;\"><em>Chairman, Lions Group Inc</em></p>\r\n<p style=\"text-align: center;\">We recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification. </p>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\"><strong><a title=\"view-more\" href=\"#\">View More</a></strong></p>','Alexander D. Harrington\r\nChairman, Lions Group Inc\r\nWe recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification. \r\n \r\nView More',NULL,3,3,'2015-08-12 15:44:32','2015-08-12 15:45:27'),(31,'<h3 style=\"text-align: center;\"><strong>Andrew D. Harrington</strong></h3>\r\n<p style=\"text-align: center;\"><em>Chairman, Lions Group Inc</em></p>\r\n<p style=\"text-align: center;\">We recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification. </p>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\"><strong><a title=\"view-more\" href=\"#\">View More</a></strong></p>','Andrew D. Harrington\r\nChairman, Lions Group Inc\r\nWe recognize New York as the pinnacle of a higher standard of living. Over more than three decades, we have seen that those who succeed in our line of work are those who can contribute to that standard of living and its perpetual amplification. \r\n \r\nView More',NULL,3,3,'2015-08-12 15:45:38','2015-08-12 15:45:58'),(32,'<p style=\"text-align: center;\"><em>Lions Group NYC</em></p>\r\n<p style=\"text-align: center;\"><em>425 Northern BLVD, Suite #6</em></p>\r\n<p style=\"text-align: center;\"><em>Great Neck, NY11021</em></p>\r\n<p> </p>\r\n<div style=\"text-align: center;\"><a title=\"Contact\" href=\"#\">+1 516 829 58 83</a> <a title=\"Fax\" href=\"#\">+1 516 829 58 84</a> <a title=\"Email\" href=\"mailto:\'info@lionsgroupnyc.com\'\">info@lionsgroupnyc.com</a></div>','Lions Group NYC\r\n425 Northern BLVD, Suite #6\r\nGreat Neck, NY11021\r\n \r\n+1 516 829 58 83 +1 516 829 58 84 info@lionsgroupnyc.com',NULL,3,3,'2015-08-12 16:03:41','2015-08-12 16:03:46'),(33,'<h2 style=\"text-align: center;\">Send us a Message</h2>\r\n<p style=\"text-align: center;\"><em>For questions related apartments or buildings or any other requests,</em></p>\r\n<p style=\"text-align: center;\"><em>please use the contact form below:</em></p>','Send us a Message\r\nFor questions related apartments or buildings or any other requests,\r\nplease use the contact form below:',NULL,3,3,'2015-08-12 16:04:26','2015-08-12 16:04:29'),(34,'<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,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15'),(35,NULL,NULL,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15'),(36,NULL,NULL,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15'),(37,NULL,NULL,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15'),(38,'<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,4,4,'2015-08-13 16:33:41','2015-08-13 16:33:41'),(39,'<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,4,4,'2015-08-13 16:33:55','2015-08-13 16:33:55'),(40,'<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,4,4,'2015-08-13 16:34:02','2015-08-13 16:34:02'),(41,'<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">COPYRIGHT 2015, LionsGroup INC,</p>\r\n<p style=\"text-align: center;\">All rights reserved</p>',' \r\nCOPYRIGHT 2015, LionsGroup INC,\r\nAll rights reserved',NULL,4,4,'2015-08-13 16:39:52','2015-08-13 16:43:01'),(42,'<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">COPYRIGHT 2015, LionsGroup INC,</p>\r\n<p style=\"text-align: center;\">All rights reserved</p>',' \r\nCOPYRIGHT 2015, LionsGroup INC,\r\nAll rights reserved',NULL,4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(43,'<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">COPYRIGHT 2015, LionsGroup INC,</p>\r\n<p style=\"text-align: center;\">All rights reserved</p>',' \r\nCOPYRIGHT 2015, LionsGroup INC,\r\nAll rights reserved',NULL,4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(44,'<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,4,4,'2015-08-13 16:47:37','2015-08-13 16:47:37'),(45,NULL,NULL,NULL,4,4,'2015-08-13 16:47:37','2015-08-13 16:47:37'),(46,'<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">COPYRIGHT 2015, LionsGroup INC,</p>\r\n<p style=\"text-align: center;\">All rights reserved</p>',' \r\nCOPYRIGHT 2015, LionsGroup INC,\r\nAll rights reserved',NULL,4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(47,'<p style=\"text-align: center;\"><em style=\"box-sizing: border-box; color: rgba(0, 2, 47, 0.498039); font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 18px; letter-spacing: 0.360000014305115px; line-height: 25.7142868041992px; text-align: center;\">Spacious Penthouse Duplex w/ Closed Kitchen, W/D, Private Roof Terrace, and S/W Views of Manhattan. Available Immediately.</em></p>\r\n<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">4720 Center Boulevard offers impressive rentals overlooking the esplanade, Gantry Plaza State Park, piers, and the captivating Manhattan skyline. This 32-story tower was designed to maximize the panoramic views by the award-winning architecture firm Arquitectonica, with lobby design by the Rockwell Group.</p>\r\n<p style=\"text-align: center;\">The studio, one-, two-, and three-bedroom residences at 4720 provide modern luxury and comfort. Hardwood strip floors, granite countertops, stainless steel appliances, marble-accented bathrooms, floor-to-ceiling windows and spacious layouts enable room to play and space to make truly yours. Some special penthouse duplexes are available, while some units have private balconies, extra-high ceilings, and private washer/dryers. Amenities include a modern fitness center, landscaped terrace, resident lounge, impressive lobby, children’s playroom, and a landscaped private garden.</p>\r\n<p style=\"text-align: center;\">The dynamic, multi-purpose waterfront surrounding 4720 provides more than an iconic view: it’s a daily source of inspiration. With 12 acres of green parks, a beautiful esplanade, an outdoor sports park, and a brand new K-8 school around the corner, 4720′s waterfront is alive with activity, every day. 4720 is a convenient four-minute subway ride away from Midtown Manhattan on the 7 train, and accessible by the G, E and M trains, East River Ferry and the Pulaski Bridge.</p>','Spacious Penthouse Duplex w/ Closed Kitchen, W/D, Private Roof Terrace, and S/W Views of Manhattan. Available Immediately.\r\n \r\n4720 Center Boulevard offers impressive rentals overlooking the esplanade, Gantry Plaza State Park, piers, and the captivating Manhattan skyline. This 32-story tower was designed to maximize the panoramic views by the award-winning architecture firm Arquitectonica, with lobby design by the Rockwell Group.\r\nThe studio, one-, two-, and three-bedroom residences at 4720 provide modern luxury and comfort. Hardwood strip floors, granite countertops, stainless steel appliances, marble-accented bathrooms, floor-to-ceiling windows and spacious layouts enable room to play and space to make truly yours. Some special penthouse duplexes are available, while some units have private balconies, extra-high ceilings, and private washer/dryers. Amenities include a modern fitness center, landscaped terrace, resident lounge, impressive lobby, children’s playroom, and a landscaped private garden.\r\nThe dynamic, multi-purpose waterfront surrounding 4720 provides more than an iconic view: it’s a daily source of inspiration. With 12 acres of green parks, a beautiful esplanade, an outdoor sports park, and a brand new K-8 school around the corner, 4720′s waterfront is alive with activity, every day. 4720 is a convenient four-minute subway ride away from Midtown Manhattan on the 7 train, and accessible by the G, E and M trains, East River Ferry and the Pulaski Bridge.',NULL,4,4,'2015-08-13 16:49:47','2015-08-13 17:05:56'),(48,'<p style=\"text-align: center;\"><span style=\"color: rgba(0, 2, 47, 0.498039); font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif;\"><span style=\"font-size: 18px; letter-spacing: 0.360000014305115px; line-height: 25.7142868041992px;\"><em>You are welcome to check out our house gallery to make sure that this home</em></span></span></p>\r\n<p style=\"text-align: center;\"><span style=\"color: rgba(0, 2, 47, 0.498039); font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif;\"><span style=\"font-size: 18px; letter-spacing: 0.360000014305115px; line-height: 25.7142868041992px;\"><em>is in prime condition which makes it a perfect living space.</em></span></span></p>','You 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,4,4,'2015-08-13 16:49:47','2015-08-13 17:08:12'),(49,NULL,NULL,NULL,4,4,'2015-08-13 16:49:47','2015-08-13 16:49:47'),(50,'<p style=\"text-align: center;\"> </p>\r\n<p style=\"text-align: center;\">COPYRIGHT 2015, LionsGroup INC,</p>\r\n<p style=\"text-align: center;\">All rights reserved</p>',' \r\nCOPYRIGHT 2015, LionsGroup INC,\r\nAll rights reserved',NULL,4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00');

--
-- 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=41 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'),(4,'Welcome to your first Alchemy CMS page',NULL,NULL,NULL,0,NULL,3,3,'2015-08-12 08:58:41','2015-08-12 08:58:41'),(5,'Welcome to your first Alchemy CMS page',NULL,NULL,NULL,0,NULL,4,4,'2015-08-13 16:32:15','2015-08-13 16:32:15'),(6,'Contact Us','/contact','','internal',0,'',4,4,'2015-08-13 16:40:39','2015-08-13 16:43:01'),(7,'About Us','/about','','internal',0,'',4,4,'2015-08-13 16:40:42','2015-08-13 16:43:01'),(8,'Portfolio','/portfolio','','internal',0,'',4,4,'2015-08-13 16:40:44','2015-08-13 16:43:01'),(9,'Availability','/#','','external',0,'',4,4,'2015-08-13 16:40:46','2015-08-13 16:43:01'),(10,'Terms and Conditions','/#','','external',0,'',4,4,'2015-08-13 16:40:49','2015-08-13 16:43:01'),(11,'Go Home','/home','','internal',0,'',4,4,'2015-08-13 16:40:53','2015-08-13 16:43:01'),(12,'Contact Us','/contact','','internal',0,'',4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(13,'About Us','/about','','internal',0,'',4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(14,'Portfolio','/portfolio','','internal',0,'',4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(15,'Availability','/#','','external',0,'',4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(16,'Terms and Conditions','/#','','external',0,'',4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(17,'Go Home','/home','','internal',0,'',4,4,'2015-08-13 16:45:37','2015-08-13 16:45:37'),(18,'Contact Us','/contact','','internal',0,'',4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(19,'About Us','/about','','internal',0,'',4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(20,'Portfolio','/portfolio','','internal',0,'',4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(21,'Availability','/#','','external',0,'',4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(22,'Terms and Conditions','/#','','external',0,'',4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(23,'Go Home','/home','','internal',0,'',4,4,'2015-08-13 16:46:52','2015-08-13 16:46:52'),(24,'Welcome to your first Alchemy CMS page',NULL,NULL,NULL,0,NULL,4,4,'2015-08-13 16:47:37','2015-08-13 16:47:37'),(25,'Contact Us','/contact','','internal',0,'',4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(26,'About Us','/about','','internal',0,'',4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(27,'Portfolio','/portfolio','','internal',0,'',4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(28,'Availability','/#','','external',0,'',4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(29,'Terms and Conditions','/#','','external',0,'',4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(30,'Go Home','/home','','internal',0,'',4,4,'2015-08-13 16:48:07','2015-08-13 16:48:07'),(31,'The Bindery 47 34th street, Long Island City',NULL,NULL,NULL,0,NULL,4,4,'2015-08-13 16:49:47','2015-08-13 17:23:29'),(32,'Short Property Description',NULL,NULL,NULL,0,NULL,4,4,'2015-08-13 16:49:47','2015-08-13 16:49:47'),(33,'Media Gallery and Property Features',NULL,NULL,NULL,0,NULL,4,4,'2015-08-13 16:49:47','2015-08-13 16:49:47'),(34,'Contact Us','/contact','','internal',0,'',4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00'),(35,'About Us','/about','','internal',0,'',4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00'),(36,'Portfolio','/portfolio','','internal',0,'',4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00'),(37,'Availability','/#','','external',0,'',4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00'),(38,'Terms and Conditions','/#','','external',0,'',4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00'),(39,'Go Home','/home','','internal',0,'',4,4,'2015-08-13 17:10:00','2015-08-13 17:10:00');

--
-- 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=4 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'),(2,'/contact',6,'2015-08-12 16:02:52','2015-08-12 16:02:52'),(3,'/',7,'2015-08-13 16:37:49','2015-08-13 16:37:49');

--
-- 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=10 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,16,NULL,0,0,0,0,NULL,0,1,1,1,0,'2015-07-24 13:18:42','2015-08-13 17:30:56',NULL,NULL,NULL,NULL,NULL),(2,'Index','index','Index','en',1,'index','','',2,13,1,1,0,0,1,4,0,1,1,0,0,'2015-07-24 13:25:19','2015-08-13 17:30:56',1,4,1,NULL,'2015-08-11 15:59:50'),(3,'Layoutroot for English','',NULL,NULL,NULL,NULL,NULL,NULL,14,15,1,1,0,0,0,NULL,0,1,1,1,1,'2015-07-24 13:25:56','2015-08-13 17:30:56',1,1,1,NULL,NULL),(4,'Portfolio','portfolio','portfolio','en',NULL,'innerpage','','',7,8,2,2,1,1,1,4,0,1,1,1,0,'2015-08-11 15:41:35','2015-08-13 17:39:20',3,4,1,NULL,'2015-08-13 17:39:23'),(5,'About','about','about','en',NULL,'innerpage','','',5,6,2,2,1,1,1,4,0,1,1,1,0,'2015-08-12 08:58:41','2015-08-13 17:39:13',3,4,1,NULL,'2015-08-13 17:39:16'),(6,'Contact','contact','contact','en',NULL,'contactpage','','',11,12,2,2,1,1,1,4,0,1,1,1,0,'2015-08-12 16:02:39','2015-08-13 17:37:33',3,4,1,NULL,'2015-08-13 17:38:02'),(7,'Home','home','home','en',NULL,'innerpage','','',3,4,2,2,1,1,1,4,0,1,1,1,0,'2015-08-13 16:32:15','2015-08-13 17:39:00',4,4,1,NULL,'2015-08-13 17:39:02'),(8,'Availability','bindery','bindery','en',NULL,'property','','',9,10,2,2,1,1,1,4,0,1,1,1,0,'2015-08-13 16:49:47','2015-08-13 17:39:35',4,4,1,NULL,'2015-08-13 17:39:36');

--
-- 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=41 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),(37,'bindery master bed 701','bindery master bed 701.jpg',1296,864,'2015-08-12 15:36:32','2015-08-12 15:36:32',3,3,'555910380800678900',NULL,'2015/08/12/2nm43zluk2_bindery_master_bed_701.jpg',831789),(38,'chairman1','chairman1.jpg',570,321,'2015-08-12 15:45:21','2015-08-12 15:45:21',3,3,'1051922133700174500',NULL,'2015/08/12/7lexipxi6q_chairman1.jpg',27896),(39,'chairman2','chairman2.jpg',570,321,'2015-08-12 15:45:21','2015-08-12 15:45:21',3,3,'1051922133700174500',NULL,'2015/08/12/1ql4t5uas6_chairman2.jpg',27843),(40,'bindery living looking into terrace 701','bindery living looking into terrace 701.jpg',1296,864,'2015-08-13 16:51:00','2015-08-13 16:51:00',4,4,'-1468844793368983600',NULL,'2015/08/13/2000aemscw_bindery_living_looking_into_terrace_701.jpg',735964);

--
-- 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,'*','Lions Group NYC','2015-07-24 13:18:42','2015-08-13 06:24:51',0,'',0);

--
-- 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'),('20150812113618');

--
-- 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`
--



