-- Generated by Craft v2.3.2641 on Apr 24, 2015 7:52:13 AM. -- -- Disable foreign key checks and autocommit. -- SET FOREIGN_KEY_CHECKS = 0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; SET NAMES utf8; DROP TABLE IF EXISTS `craft_assetfiles`; -- -- Schema for table `craft_assetfiles` -- CREATE TABLE `craft_assetfiles` ( `id` int(11) NOT NULL, `sourceId` int(11) DEFAULT NULL, `folderId` int(11) NOT NULL, `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `kind` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown', `width` smallint(6) unsigned DEFAULT NULL, `height` smallint(6) unsigned DEFAULT NULL, `size` int(11) unsigned DEFAULT NULL, `dateModified` datetime DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_assetfiles_filename_folderId_unq_idx` (`filename`,`folderId`), KEY `craft_assetfiles_sourceId_fk` (`sourceId`), KEY `craft_assetfiles_folderId_fk` (`folderId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_assetfiles` -- INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('6', '1', '1', 'aranca-banner-resized.jpg', 'image', '800', '300', '44361', '2015-03-13 06:11:17', '2015-03-12 08:52:56', '2015-04-01 07:05:23', '5605ada9-4923-44ae-bd77-8551454a41b1'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('8', '2', '2', 'research.png', 'image', '100', '100', '2192', '2015-03-13 06:40:58', '2015-03-13 06:40:54', '2015-04-01 07:05:22', '4bd625e8-5c01-4814-8c38-ed6293d7140b'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('9', '2', '2', 'development.png', 'image', '100', '100', '1166', '2015-03-13 06:41:47', '2015-03-13 06:41:43', '2015-04-01 07:05:22', '2191f195-2c3e-46b3-9bca-ee8de469ea6d'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('10', '2', '2', 'idea.png', 'image', '100', '100', '1469', '2015-03-13 06:42:40', '2015-03-13 06:42:36', '2015-04-01 07:05:23', 'c97a8e23-e807-4c46-b0de-580bcac6148b'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('11', '2', '2', 'market.png', 'image', '100', '100', '2472', '2015-03-13 06:43:32', '2015-03-13 06:43:28', '2015-04-01 07:05:22', 'b507ae08-850e-4526-8d50-c175be4e9dcf'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('16', '3', '3', 'anil.jpg', 'image', '270', '240', '40954', '2015-03-13 16:30:22', '2015-03-13 16:30:17', '2015-04-01 07:05:21', '2c9eae17-37ff-411a-b349-76ad2daef700'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('21', '4', '4', 'hemendra-aran.jpg', 'image', '128', '128', '27534', '2015-03-16 12:45:58', '2015-03-16 12:47:37', '2015-04-01 07:05:19', '5b4b0479-9842-47a3-9f05-59926bab1989'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('25', '4', '4', 'madhusudan.jpg', 'image', '128', '128', '23121', '2015-03-16 13:05:30', '2015-03-16 13:07:28', '2015-04-01 07:05:20', '38f27cfe-87fe-47c6-a213-b1b5ed96232c'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('29', '4', '4', 'neeraj-bharadwaj.jpg', 'image', '128', '128', '18937', '2015-03-16 13:06:48', '2015-03-16 13:08:48', '2015-04-01 07:05:20', '0745c3b3-4d4f-4cc2-8311-46596abf5b30'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('31', '4', '4', 'christopher.jpg', 'image', '128', '128', '22752', '2015-03-16 13:07:35', '2015-03-16 13:09:36', '2015-04-01 07:05:19', '969570bc-79a3-4c67-b8d3-a0946cb7eaee'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('33', '4', '4', 'kannan-siva.jpg', 'image', '128', '128', '19386', '2015-03-16 13:08:21', '2015-03-16 13:10:22', '2015-04-01 07:05:18', '47953dca-7fc7-48c0-aa87-32c3673bc185'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('35', '4', '4', 'ashish-sethi.jpg', 'image', '128', '128', '31112', '2015-03-16 13:09:04', '2015-03-16 13:11:05', '2015-04-01 07:05:18', 'e3a02456-38c5-4416-9d30-e4b174b07c04'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('42', '4', '4', 'srinivas-macha.jpg', 'image', '128', '128', '21784', '2015-03-16 13:10:21', '2015-03-16 13:12:21', '2015-04-01 07:05:21', 'e6bb1749-4259-4c4c-bcd8-580f6de5b548'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('44', '4', '4', 'mona-bose.jpg', 'image', '128', '128', '20175', '2015-03-16 13:10:55', '2015-03-16 13:12:55', '2015-04-01 07:05:20', 'e5822a49-bf30-42cd-829b-aa2fca78fef3'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('46', '4', '4', 'ritesh-rawal.jpg', 'image', '128', '128', '5771', '2015-03-16 13:11:42', '2015-03-16 13:13:44', '2015-04-01 07:05:20', 'a422410f-52f4-4436-8836-7af24cc0584b'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('99', '5', '5', 'node.png', 'image', '557', '352', '26883', '2015-03-26 13:25:38', '2015-03-26 13:25:38', '2015-04-01 07:05:26', 'cc9254fe-8d50-4d9c-90db-b777a4ecc3f5'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('101', '5', '5', 'hills-Cropped.jpg', 'image', '682', '682', '211570', '2015-03-26 17:27:52', '2015-03-26 17:27:53', '2015-04-01 07:05:26', 'f113d0c5-728a-4675-957f-d2961da99923'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('102', '5', '5', 'hills-Cropped-1.jpg', 'image', '300', '300', '51844', '2015-03-26 17:29:59', '2015-03-26 17:30:00', '2015-04-01 07:05:25', '9b01480e-5b07-4a31-b430-a64a8162bcaa'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('106', '5', '5', 'blog09.jpg', 'image', '1200', '600', '204874', '2015-03-27 14:19:20', '2015-03-27 14:15:10', '2015-04-01 07:05:24', '390a9b0e-b8fc-410a-a14f-272c59bbab92'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('107', '5', '5', 'blog01.jpg', 'image', '1200', '600', '51524', '2015-03-27 14:21:22', '2015-03-27 14:17:11', '2015-04-01 07:05:23', '90193232-88fb-4268-b220-e6715abdba23'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('117', '5', '5', 'p08.jpg', 'image', '1200', '800', '101916', '2015-03-28 17:35:21', '2015-03-28 17:35:21', '2015-04-01 07:05:26', '7f987a75-7f4c-4bf8-8fe5-76ddba76f955'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('118', '5', '5', 'blog10.jpg', 'image', '1200', '600', '172843', '2015-03-28 17:35:47', '2015-03-28 17:35:47', '2015-04-01 07:05:25', '23ca2273-fd2d-4162-903f-fb8213fcbf20'); INSERT INTO `craft_assetfiles` (`id`, `sourceId`, `folderId`, `filename`, `kind`, `width`, `height`, `size`, `dateModified`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('121', '5', '5', 'blog04.jpg', 'image', '1200', '600', '390683', '2015-03-28 08:06:44', '2015-04-01 07:05:25', '2015-04-01 07:05:25', '0285197d-1e9f-469f-94d3-fa8430573cda'); DROP TABLE IF EXISTS `craft_assetfolders`; -- -- Schema for table `craft_assetfolders` -- CREATE TABLE `craft_assetfolders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parentId` int(11) DEFAULT NULL, `sourceId` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_assetfolders_name_parentId_sourceId_unq_idx` (`name`,`parentId`,`sourceId`), KEY `craft_assetfolders_parentId_fk` (`parentId`), KEY `craft_assetfolders_sourceId_fk` (`sourceId`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_assetfolders` -- INSERT INTO `craft_assetfolders` (`id`, `parentId`, `sourceId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', NULL, '1', 'Company Banners', '', '2015-03-11 15:41:36', '2015-03-11 15:41:36', 'c1a0a26f-76b9-490b-8b35-be1a8b8ccfba'); INSERT INTO `craft_assetfolders` (`id`, `parentId`, `sourceId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', NULL, '2', 'Content Icons', '', '2015-03-13 06:25:14', '2015-03-13 06:25:14', '8cc0f997-07d0-4ffd-8a97-e043f221d29a'); INSERT INTO `craft_assetfolders` (`id`, `parentId`, `sourceId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', NULL, '3', 'Media', '', '2015-03-13 16:20:37', '2015-03-13 16:20:37', '90473d87-d427-44c5-bdfe-7b7b9a747170'); INSERT INTO `craft_assetfolders` (`id`, `parentId`, `sourceId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('4', NULL, '4', 'Team Profile', '', '2015-03-16 12:31:55', '2015-03-16 12:31:55', '06ea2d60-65c9-44d5-8310-8556506998f7'); INSERT INTO `craft_assetfolders` (`id`, `parentId`, `sourceId`, `name`, `path`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('5', NULL, '5', 'Page Body', '', '2015-03-26 13:20:18', '2015-03-26 13:21:48', 'c9d174f7-3bb3-4c42-b021-bf29ad3259e1'); DROP TABLE IF EXISTS `craft_assetindexdata`; -- -- Schema for table `craft_assetindexdata` -- CREATE TABLE `craft_assetindexdata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sessionId` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `sourceId` int(10) NOT NULL, `offset` int(10) NOT NULL, `uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `size` int(10) DEFAULT NULL, `recordId` int(10) DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_assetindexdata_sessionId_sourceId_offset_unq_idx` (`sessionId`,`sourceId`,`offset`), KEY `craft_assetindexdata_sourceId_fk` (`sourceId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `craft_assetsources`; -- -- Schema for table `craft_assetsources` -- CREATE TABLE `craft_assetsources` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `settings` text COLLATE utf8_unicode_ci, `sortOrder` tinyint(4) DEFAULT NULL, `fieldLayoutId` int(10) DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_assetsources_name_unq_idx` (`name`), UNIQUE KEY `craft_assetsources_handle_unq_idx` (`handle`), KEY `craft_assetsources_fieldLayoutId_fk` (`fieldLayoutId`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_assetsources` -- INSERT INTO `craft_assetsources` (`id`, `name`, `handle`, `type`, `settings`, `sortOrder`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', 'Company Banners', 'companyBanners', 'Local', '{\"path\":\"{assetsBasePath}\\/banners\\/\",\"url\":\"{assetsBaseUrl}\\/banners\\/\"}', '1', '62', '2015-03-11 15:41:36', '2015-03-19 10:03:09', '5d97c3e5-5e1f-48bc-95d0-5502b7b97480'); INSERT INTO `craft_assetsources` (`id`, `name`, `handle`, `type`, `settings`, `sortOrder`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', 'Content Icons', 'contentIcons', 'Local', '{\"path\":\"{assetsBasePath}\\/icons\\/content\\/\",\"url\":\"{assetsBaseUrl}\\/icons\\/content\\/\"}', '2', '61', '2015-03-13 06:25:14', '2015-03-19 10:02:37', '53cf2fb1-c280-4266-a7f0-759047307da5'); INSERT INTO `craft_assetsources` (`id`, `name`, `handle`, `type`, `settings`, `sortOrder`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', 'Media', 'media', 'Local', '{\"path\":\"{assetsBasePath}\\/media\\/\",\"url\":\"{assetsBaseUrl}\\/media\\/\"}', '3', '60', '2015-03-13 16:20:37', '2015-03-19 10:01:40', 'bb5c35f4-f44d-4ac3-a141-454a73c0a040'); INSERT INTO `craft_assetsources` (`id`, `name`, `handle`, `type`, `settings`, `sortOrder`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('4', 'Team Profile', 'teamProfile', 'Local', '{\"path\":\"{assetsBasePath}\\/profile\\/team\\/\",\"url\":\"{assetsBaseUrl}\\/profile\\/team\\/\"}', '4', '59', '2015-03-16 12:31:55', '2015-03-19 09:59:06', '0d7c20c6-4890-4d1b-9a0a-d4d80bba9b23'); INSERT INTO `craft_assetsources` (`id`, `name`, `handle`, `type`, `settings`, `sortOrder`, `fieldLayoutId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('5', 'Page Body', 'pageBody', 'Local', '{\"path\":\"{assetsBasePath}\\/page-body\\/\",\"url\":\"{assetsBaseUrl}\\/page-body\\/\"}', '5', '96', '2015-03-26 13:20:18', '2015-03-26 13:21:48', '4ed24e16-34f2-41e9-bfab-b616bf4e1bf3'); DROP TABLE IF EXISTS `craft_assettransformindex`; -- -- Schema for table `craft_assettransformindex` -- CREATE TABLE `craft_assettransformindex` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fileId` int(11) NOT NULL, `filename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sourceId` int(11) DEFAULT NULL, `fileExists` tinyint(1) DEFAULT NULL, `inProgress` tinyint(1) DEFAULT NULL, `dateIndexed` datetime DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `craft_assettransformindex_sourceId_fileId_location_idx` (`sourceId`,`fileId`,`location`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `craft_assettransforms`; -- -- Schema for table `craft_assettransforms` -- CREATE TABLE `craft_assettransforms` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `mode` enum('stretch','fit','crop') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'crop', `position` enum('top-left','top-center','top-right','center-left','center-center','center-right','bottom-left','bottom-center','bottom-right') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'center-center', `height` int(10) DEFAULT NULL, `width` int(10) DEFAULT NULL, `format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `quality` int(10) DEFAULT NULL, `dimensionChangeTime` datetime DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_assettransforms_name_unq_idx` (`name`), UNIQUE KEY `craft_assettransforms_handle_unq_idx` (`handle`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_assettransforms` -- INSERT INTO `craft_assettransforms` (`id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', 'Medium', 'medium', 'crop', 'center-center', '424', '700', NULL, NULL, '2015-03-12 08:35:41', '2015-03-12 08:35:41', '2015-03-12 08:35:41', 'b36a8e1a-80c4-48da-b96f-21d6eed88acf'); INSERT INTO `craft_assettransforms` (`id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', 'Small', 'small', 'crop', 'center-center', '339', '400', NULL, NULL, '2015-03-12 08:36:21', '2015-03-12 08:36:21', '2015-03-12 08:36:21', 'c25030e0-c50f-4376-acc7-950539ed5c63'); INSERT INTO `craft_assettransforms` (`id`, `name`, `handle`, `mode`, `position`, `height`, `width`, `format`, `quality`, `dimensionChangeTime`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', 'Thumb', 'thumb', 'crop', 'center-center', '204', '280', NULL, NULL, '2015-03-12 08:36:55', '2015-03-12 08:36:55', '2015-03-12 08:36:55', 'ec34ae82-1190-496a-8ff3-baf075f56c90'); DROP TABLE IF EXISTS `craft_categories`; -- -- Schema for table `craft_categories` -- CREATE TABLE `craft_categories` ( `id` int(11) NOT NULL, `groupId` int(11) NOT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `craft_categories_groupId_fk` (`groupId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_categories` -- INSERT INTO `craft_categories` (`id`, `groupId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('149', '1', '2015-04-21 07:36:58', '2015-04-21 07:36:58', 'b0390a42-6c60-4f03-891d-c20da5f4a4f3'); INSERT INTO `craft_categories` (`id`, `groupId`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('150', '1', '2015-04-21 07:37:25', '2015-04-21 07:37:25', '09b0b4b1-9e22-4e6b-9adf-3e213d931fef'); DROP TABLE IF EXISTS `craft_categorygroups`; -- -- Schema for table `craft_categorygroups` -- CREATE TABLE `craft_categorygroups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `structureId` int(11) NOT NULL, `fieldLayoutId` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `hasUrls` tinyint(1) unsigned NOT NULL DEFAULT '1', `template` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_categorygroups_name_unq_idx` (`name`), UNIQUE KEY `craft_categorygroups_handle_unq_idx` (`handle`), KEY `craft_categorygroups_structureId_fk` (`structureId`), KEY `craft_categorygroups_fieldLayoutId_fk` (`fieldLayoutId`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_categorygroups` -- INSERT INTO `craft_categorygroups` (`id`, `structureId`, `fieldLayoutId`, `name`, `handle`, `hasUrls`, `template`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', '1', '379', 'Services', 'services', '1', 'services/_category', '2015-04-21 07:35:44', '2015-04-21 08:05:13', 'a6a09676-285f-4570-96a0-f25ff61be2c8'); DROP TABLE IF EXISTS `craft_categorygroups_i18n`; -- -- Schema for table `craft_categorygroups_i18n` -- CREATE TABLE `craft_categorygroups_i18n` ( `id` int(11) NOT NULL AUTO_INCREMENT, `groupId` int(11) NOT NULL, `locale` char(12) COLLATE utf8_unicode_ci NOT NULL, `urlFormat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `nestedUrlFormat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_categorygroups_i18n_groupId_locale_unq_idx` (`groupId`,`locale`), KEY `craft_categorygroups_i18n_locale_fk` (`locale`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_categorygroups_i18n` -- INSERT INTO `craft_categorygroups_i18n` (`id`, `groupId`, `locale`, `urlFormat`, `nestedUrlFormat`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', '1', 'en_us', '{slug}', '{parent.uri}/{slug}', '2015-04-21 07:35:44', '2015-04-21 07:54:19', '008193eb-6d31-42c6-b009-775a63783958'); INSERT INTO `craft_categorygroups_i18n` (`id`, `groupId`, `locale`, `urlFormat`, `nestedUrlFormat`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', '1', 'de', '{slug}', '{parent.uri}/{slug}', '2015-04-21 07:35:44', '2015-04-21 07:54:19', '4d005417-9067-4ca2-a81e-7ca2c8aa65ef'); DROP TABLE IF EXISTS `craft_content`; -- -- Schema for table `craft_content` -- CREATE TABLE `craft_content` ( `id` int(11) NOT NULL AUTO_INCREMENT, `elementId` int(11) NOT NULL, `locale` char(12) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `field_body` text COLLATE utf8_unicode_ci, `field_brandColour` char(7) COLLATE utf8_unicode_ci DEFAULT NULL, `field_email` text COLLATE utf8_unicode_ci, `field_yourName` text COLLATE utf8_unicode_ci, `field_gender` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `field_company` text COLLATE utf8_unicode_ci, `field_projectType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `field_projectDescription` text COLLATE utf8_unicode_ci, `field_features` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `field_designation` text COLLATE utf8_unicode_ci, `field_bio` text COLLATE utf8_unicode_ci, `field_testimonial` text COLLATE utf8_unicode_ci, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_content_elementId_locale_unq_idx` (`elementId`,`locale`), KEY `craft_content_title_idx` (`title`), KEY `craft_content_locale_fk` (`locale`) ) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_content` -- INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', '1', 'en_us', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-07 13:53:16', '2015-03-07 13:53:16', '49f2ccd1-adf0-4b9d-9175-3de87614c584'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', '2', 'en_us', 'Homepage', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-07 13:53:17', '2015-04-01 06:33:59', '0e238271-2ace-4fa2-a575-cb101e3421e7'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', '3', 'en_us', 'We just installed Craft!', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-07 13:53:17', '2015-04-01 06:33:59', '303a78ea-dc6b-4337-b6b4-d4d6af278cdd'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('6', '6', 'en_us', 'aranca-banner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-12 08:52:56', '2015-04-01 07:05:23', '095077bf-83eb-4e28-b591-78a7fe1d0744'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('8', '8', 'en_us', 'research', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-13 06:40:54', '2015-04-01 07:05:22', 'fc301e6f-5dbf-465b-b6c6-98760585c76a'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('9', '9', 'en_us', 'development', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-13 06:41:43', '2015-04-01 07:05:22', 'a6a20032-1f1c-4006-9876-eb98006cea53'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('10', '10', 'en_us', 'idea', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-13 06:42:36', '2015-04-01 07:05:23', '33fa29ac-68c8-40b0-830c-e371e5804a36'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('11', '11', 'en_us', 'market', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-13 06:43:28', '2015-04-01 07:05:22', 'a7b86e78-bac0-4b81-a6b3-ef5b291be892'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('12', '16', 'en_us', 'anil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-13 16:30:17', '2015-04-01 07:05:21', '57208763-072b-4854-85b2-f8ece53507f6'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('13', '21', 'en_us', 'hemendra-aran', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 12:47:37', '2015-04-01 07:05:19', '987d6867-a664-4932-9282-54fe2f5740bd'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('16', '25', 'en_us', 'madhusudan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:07:28', '2015-04-01 07:05:19', '8eb793aa-2dee-421a-bd83-64757f043119'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('20', '29', 'en_us', 'neeraj-bharadwaj', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:08:48', '2015-04-01 07:05:20', 'cfff9089-9714-4bac-a09d-2064fcb1a80c'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('22', '31', 'en_us', 'christopher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:09:36', '2015-04-01 07:05:19', '0655c2e6-7c25-4cd7-acdf-e8523867d303'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('24', '33', 'en_us', 'kannan-siva', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:10:22', '2015-04-01 07:05:18', '7c1b69d5-d234-428e-a01f-1bffe2d7f5d5'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('26', '35', 'en_us', 'ashish-sethi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:11:04', '2015-04-01 07:05:18', '954bbf42-345e-413c-add7-b0b6cf695682'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('28', '42', 'en_us', 'srinivas-macha', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:12:21', '2015-04-01 07:05:21', '5e466770-38b6-4409-a7b5-306e744f5ed9'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('30', '44', 'en_us', 'mona-bose', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:12:55', '2015-04-01 07:05:20', '9790df47-9029-4b49-ba28-9a2820ccb8c1'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('32', '46', 'en_us', 'ritesh-rawal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-16 13:13:43', '2015-04-01 07:05:20', '5aeeb476-1642-43dd-8315-0e85a0832784'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('43', '99', 'en_us', 'node', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-26 13:25:38', '2015-04-01 07:05:26', '7fc58759-c629-4a1a-8cec-205b77600512'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('44', '101', 'en_us', 'hills-Cropped', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-26 17:27:52', '2015-04-01 07:05:26', '9d2b4072-4da5-4718-a660-255da9f9e445'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('45', '102', 'en_us', 'hills-Cropped-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-26 17:30:00', '2015-04-01 07:05:25', 'b52a87d2-07f8-4992-9726-69327de9a78c'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('46', '106', 'en_us', 'blog09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-27 14:15:10', '2015-04-01 07:05:24', '0bcb6c89-0d3e-4bad-9b2e-b1e642a6ce97'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('47', '107', 'en_us', 'blog01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-27 14:17:11', '2015-04-01 07:05:23', 'a9a7b701-b493-44f3-9b64-0add54eccdc7'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('49', '115', 'en_us', NULL, NULL, '#8080ff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-28 10:11:43', '2015-04-01 06:34:00', 'cd6b089f-88ab-4297-aeda-d0f6ef93f3d7'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('50', '117', 'en_us', 'p08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-28 17:35:21', '2015-04-01 07:05:26', '351c79e8-5f93-49d2-bd37-930ca0b03814'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('51', '118', 'en_us', 'blog10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-03-28 17:35:47', '2015-04-01 07:05:25', '9046c085-1d1d-4518-81e5-66224742ff11'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('52', '6', 'de', 'aranca-banner', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'd5ff7745-b3b0-4497-b6d0-ba0e1046616a'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('53', '8', 'de', 'research', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '08d6934a-e33f-4b2e-a9e6-0eeb382444ff'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('54', '9', 'de', 'development', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '0e0b27b4-218d-4290-bb26-a9f968481e70'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('55', '10', 'de', 'idea', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'aafdce75-f4c7-4cdf-a7b7-b94827286d42'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('56', '11', 'de', 'market', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'aee303d5-1fb1-450a-b42b-906c1b389631'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('57', '16', 'de', 'anil', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '42147f18-db37-4367-a109-a1eb02589ba8'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('58', '21', 'de', 'hemendra-aran', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '2b76e8bb-bc4c-4f95-91de-666b6dc48527'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('59', '25', 'de', 'madhusudan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'e5bf383e-c5b9-4ab6-aaaf-d8e54b3dc9bf'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('60', '29', 'de', 'neeraj-bharadwaj', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '70239c62-5bfb-49ef-9a9a-52bc095c138e'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('61', '31', 'de', 'christopher', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '85e6317b-0713-4dc7-9e2b-2f5bb17d3fd1'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('62', '33', 'de', 'kannan-siva', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '122124f7-13ea-43bf-a154-0bb0eeac805d'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('63', '35', 'de', 'ashish-sethi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'a139fd3e-e494-4f51-8de3-cc099c8253aa'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('64', '42', 'de', 'srinivas-macha', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '2917655b-6677-4875-b38d-88b171e75742'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('65', '44', 'de', 'mona-bose', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'e7717b62-c270-436f-9698-a34b15ef262f'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('66', '46', 'de', 'ritesh-rawal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '73e3176e-d861-4bf3-85d5-ad0d7f7c40fd'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('67', '99', 'de', 'node', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'ef0bd552-24f2-488b-aa72-641f680cd96d'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('68', '101', 'de', 'hills-Cropped', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '572e4ac8-1052-4002-b085-a9948adb8625'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('69', '102', 'de', 'hills-Cropped-1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '7fb75724-db2c-48eb-859e-0714df7dc98d'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('70', '106', 'de', 'blog09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '44b56a12-1fb0-47ca-9460-4a38827feb47'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('71', '107', 'de', 'blog01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'c8adf7a6-e442-4d87-8361-821af092c36a'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('72', '117', 'de', 'p08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', '059fca95-0944-4733-b7b4-014f080f08bc'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('73', '118', 'de', 'blog10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:33:58', '2015-04-01 06:33:58', 'b6c8a88a-181b-4d35-8100-5deb362af9f2'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('74', '115', 'de', NULL, NULL, '#8080ff', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 06:34:00', '2015-04-01 06:34:00', 'edc2b21d-4b99-42fb-b035-226e8f21daf5'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('78', '121', 'en_us', 'blog04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 07:05:25', '2015-04-01 07:05:25', '73e7f0eb-cc78-436e-8e0d-eca660951798'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('79', '121', 'de', 'blog04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-01 07:05:25', '2015-04-01 07:05:25', 'f3a672d4-b49c-4244-bf07-0bab32b92687'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('82', '126', 'en_us', 'About Us', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-02 09:27:29', '2015-04-08 19:40:26', 'ec945432-fedb-4d9c-9b64-f9a9c4722acf'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('83', '126', 'de', 'About Us', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-02 09:27:29', '2015-04-03 10:52:29', 'f7bd4295-353c-482f-b690-797dd75474f5'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('84', '128', 'en_us', 'Case Studies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-02 09:50:52', '2015-04-02 09:50:52', '2c52b747-a7dc-4829-8bc3-dee34c6357b1'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('85', '128', 'de', 'Case Studies', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'c39a75b6-2d1f-4c5f-b2b7-0d719c5cb34c'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('86', '147', 'en_us', 'Overview', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:34:38', '2015-04-24 04:38:45', '318106c5-f110-4c78-86c4-17dc35dacbe2'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('87', '147', 'de', 'Overview', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:34:39', '2015-04-21 07:34:39', 'a05d771f-4233-41e8-8303-ad117e438dd2'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('88', '149', 'en_us', 'Market Intelligence', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:36:58', '2015-04-21 07:36:58', '5835c35d-8a09-4886-95c5-33d3ea160971'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('89', '149', 'de', 'Market Intelligence', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:36:58', '2015-04-21 07:36:58', 'd4e86bde-0379-410f-b7d7-79a67ff5c055'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('90', '150', 'en_us', 'Research Solutions', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:37:25', '2015-04-21 07:37:25', 'e5b6aa6b-5a7d-490b-980c-99ae40d22f20'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('91', '150', 'de', 'Research Solutions', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:37:25', '2015-04-21 07:37:25', '04356eed-bd59-4a79-99ce-199173be8703'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('92', '151', 'en_us', 'Research Solutions Overview', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:50:11', '2015-04-24 07:16:54', '0bd841aa-7f74-4645-9e4c-cefdc1d0f7a0'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('93', '151', 'de', 'Research Solutions Overview', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', NULL, NULL, NULL, '2015-04-21 07:50:11', '2015-04-21 07:50:11', '25323576-c751-4b22-b112-64d281699800'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('108', '163', 'en_us', 'Hemendra Aran ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'CEO & Founder', 'Hemendra founded Aranca in 2003 with an ambition to provide high quality research and analytics to global clients. Having started his career with Infosys where he worked with global corporations such as Goldman Sachs, Reebok and Thomson Electronics, he garnered extensive experience in outsourcing. He has authored several books on the topics of outsourcing and global financial markets. He is a regular commentator and has appeared in prestigious media channels including The BBC, CNBC and The Economic Times. In addition, Hemendra has also delivered talks at top-tier institutes such as London School of Economics, the IIMs and the IITs. He is passionate about entrepreneurship and aspires to build Aranca into a market leader in research. Hemendra is an alumnus of London Business School (MBA), Haas School of Business, University of California, Berkeley and Indian Institute of Technology (Madras).', NULL, '2015-04-23 08:11:48', '2015-04-23 08:11:48', '7649d832-62d5-4b0f-b6ac-ebb8d80033ef'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('109', '164', 'en_us', 'Madhusudan Rajagopalan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', ' Director, India Operations', 'Madhusudan has been part of Aranca since inception and has overseen the scale up of Aranca\'s operations in India. He manages the delivery of a range of research solutions to global clients. Madhusudan started his career as a management consultant with Accenture where he served large clients across sectors in a range of strategy and business performance improvement assignments. Madhusudan is an alumnus of the Indian Institute of Management, Bangalore and IIT Madras (B.Tech).', NULL, '2015-04-23 08:12:27', '2015-04-23 08:12:27', '2782d4cd-726d-403c-bed0-79975ed9b517'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('110', '165', 'en_us', 'Neeraj Bhardwaj', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Director, Business Development', 'Neeraj is an entrepreneur with over 10 years of experience in financial services, outsourcing and consulting. Neeraj started his career with the Bank of England as a bank analyst working with a leading US financial services firms operating in the UK. He then founded one of the first business process outsourcing companies and subsequently an outsourcing consulting firm. Most recently, he was the CEO of a leading business research provider based in the UK and India. Neeraj brings considerable experience in capability building and business development to Aranca. Neeraj has a Bachelors in Finance from the London School of Economics and an MBA from London Business School.', NULL, '2015-04-23 08:13:05', '2015-04-23 08:13:05', '98cf1038-480e-4675-b277-999429b677dc'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('111', '166', 'en_us', 'Christopher Kingsman', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Non-Executive Director', 'Christopher started his career at Fidelity International, London, where he worked till 2002, before setting up and managing a hedge fund till 2005. He currently works with a private investment partnership in Germany. Christopher graduated from Cambridge University in the UK.', NULL, '2015-04-23 08:13:55', '2015-04-23 08:13:55', '6db8f932-326e-4588-969b-2bee636483fb'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('112', '167', 'en_us', 'Kannan Sivasubramanian ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', ' Executive Vice President', 'Kannan has over 18 years of experience in strategy / performance improvement consulting and managing service delivery in the outsourcing industry. He started his career with Avalon Consulting (Mumbai) where he worked for 11 years and managed over 200 consulting assignments across a diverse range of industries and clients. As the President of Nirvana Business Solutions, a Bangalore based BPO, Kannan was part of the senior management team that grew the company from a fledgling startup to a 400+ man organization in a period of three years. He joined Aranca after a stint in Cable&Wireless, where he was responsible for establishing the company\'s Dedicated Service business and other strategic initiatives. At Aranca, Kannan\'s responsibilities include research delivery, operational effectiveness enhancement, business development and developing strategies for the company\'s growth.', NULL, '2015-04-23 08:14:42', '2015-04-23 08:14:42', '1565bbb1-bb84-468f-9411-d4a17d68f8bf'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('113', '168', 'en_us', 'Ashish Sethi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Global Head of Sales', 'Ashish has over 13 years of experience in sales, spanning consumer products, financial products and financial services. He has built teams and grown businesses in three different organizations and has substantial experience in working with both Indian and global clients, including at firms such as ICICI Lombard and UTI MF. Most recently, he was Director-Business Development with Crisil Research. Ashish has an MBA in Marketing & IT from LBSIM and a certification in Negotiation Strategies from ISB.', NULL, '2015-04-23 08:15:19', '2015-04-23 08:15:19', '3e1ae68f-45da-4a2c-9bb8-830b65baf1f9'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('114', '169', 'en_us', 'Srinivas Macha', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', ' Senior Vice President, Marketing & Corp. Communications', 'Srinivas brings strong experience in diverse professions including business and technology journalism, media and advertising, research, operations management and IT leadership to the table. During his 18-year career, he has led the India edition of an international technology magazine titled MM-The Industry Magazine belonging to Vogel Media Group, Germany as the Executive Editor; managed a medium-sized ad agency; and served as a Senior Analyst with ARC Advisory Group Inc, a Boston-based global manufacturing consulting company. Prior to joining Aranca, Srinivas successfully launched and managed a publishing services BPO for a graphics firm in Mumbai. At Aranca, Srinivas\'s functional responsibilities include Marketing and Corporate Communications, IT and Knowledge Management related activities.', NULL, '2015-04-23 08:16:15', '2015-04-23 08:16:15', 'ddc4c92a-67b8-4d31-9915-0737bfdf2362'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('115', '170', 'en_us', 'Mona Bose', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Vice President (Human Resource Management)', 'Mona has more than 14 years of professional experience in Human Resource Management, and has led teams of young professionals in both multinationals as well as Indian entrepreneurial organizations. She helped build several small and large format organizations from scratch. Prior to Aranca, Mona worked with one of India’s leading business conglomerates, and a premier online travel portal, among others. At Aranca, Mona provides leadership for building a scalable HR infrastructure in order to support the growth and profitability of the business. She has worked extensively in nurturing the performance and accountability culture through an integrated framework comprising talent management, performance management and employee engagement initiatives. She was recently recognized as one of the Top 10 Talented HR Professionals in India, at the 21st World HRD Congress.', NULL, '2015-04-23 08:16:56', '2015-04-23 08:16:56', 'e1762693-3cdf-4abe-8ddb-d87f42d3d85c'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('116', '171', 'en_us', 'Ritesh Rawal ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Head of Finance', 'Ritesh has over 14 years of experience in Finance. Most recently, he was working with Boston Analytics as Vice President, with overall responsibility for Finance / Admin / IT functions of the company. Prior to his stint with Boston Analytics, he was working with Ipsos India, with responsibility for all the support functions of the organization in his capacity as CFO and a member of the Board of Directors for Ipsos India. During this tenure, he was also awarded as the Best CFO in Asia within Ipsos Group. During his career he has handled the entire gamut of finance and accounts related responsibilities, from day-to-day challenges to strategic initiatives such as completion of M&A transactions.', NULL, '2015-04-23 08:17:30', '2015-04-23 08:17:30', 'bfb2235f-65fa-4b32-8eb5-5aaa743942a2'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('117', '172', 'en_us', 'Dr. Anil Chauhan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Director, ABLE India', NULL, '
We at ABLE really appreciate the professional acumen of ARANCA team in both project management and domain knowledge, which resulted a great work on BIO-IT and HEALTHCARE report, which is appreciated among all segment of industry, academia and policy maker and has a fair impact on international market to understand indian landscape of BIO-IT status its potential and role in healthcare in all its aspect.
', '2015-04-23 08:21:51', '2015-04-23 08:21:51', '087ee336-b862-4321-8c17-20796667410d'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('118', '173', 'en_us', 'XYZ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Head of GTS Division in Mashreq', NULL, 'The best report that has come out of Mashreq
', '2015-04-23 08:25:35', '2015-04-23 08:25:35', '1b7cc42e-094e-4796-93e4-b336e8827aa3'); INSERT INTO `craft_content` (`id`, `elementId`, `locale`, `title`, `field_body`, `field_brandColour`, `field_email`, `field_yourName`, `field_gender`, `field_company`, `field_projectType`, `field_projectDescription`, `field_features`, `field_designation`, `field_bio`, `field_testimonial`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('119', '174', 'en_us', 'Abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[]', 'Associate Director, Leading Investment Bank', NULL, 'Working with the Aranca Analyst was a pleasure. His role greatly enhanced our models as well as our client facing research. We would gladly serve as a reference client for anyone looking to hire Aranca
', '2015-04-23 08:26:12', '2015-04-23 08:26:12', 'f8873662-5936-4430-b852-dbccb7227a07'); DROP TABLE IF EXISTS `craft_deprecationerrors`; -- -- Schema for table `craft_deprecationerrors` -- CREATE TABLE `craft_deprecationerrors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `fingerprint` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `lastOccurrence` datetime NOT NULL, `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `line` smallint(6) unsigned NOT NULL, `class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `template` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `templateLine` smallint(6) unsigned DEFAULT NULL, `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `traces` text COLLATE utf8_unicode_ci, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_deprecationerrors_key_fingerprint_unq_idx` (`key`,`fingerprint`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `craft_elements`; -- -- Schema for table `craft_elements` -- CREATE TABLE `craft_elements` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1', `archived` tinyint(1) unsigned NOT NULL DEFAULT '0', `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `craft_elements_type_idx` (`type`), KEY `craft_elements_enabled_idx` (`enabled`), KEY `craft_elements_archived_dateCreated_idx` (`archived`,`dateCreated`) ) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_elements` -- INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', 'User', '1', '0', '2015-03-07 13:53:16', '2015-03-07 13:53:16', '9af90649-aaaa-4295-ac17-405b61af8904'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', 'Entry', '1', '0', '2015-03-07 13:53:17', '2015-04-01 06:33:59', '2c62b085-0d7f-4438-8ce5-8c0d7c3fd457'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', 'Entry', '1', '0', '2015-03-07 13:53:17', '2015-04-01 06:33:59', 'a36bc273-e3c2-46e3-88a8-bcb1df8ba686'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('6', 'Asset', '1', '0', '2015-03-12 08:52:56', '2015-04-01 07:05:23', '915186ba-e4d4-48c6-aaba-ee4368e991b0'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('8', 'Asset', '1', '0', '2015-03-13 06:40:54', '2015-04-01 07:05:22', 'b174eb71-500f-42a0-8016-6459c5a33b0d'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('9', 'Asset', '1', '0', '2015-03-13 06:41:43', '2015-04-01 07:05:22', '6d79dde4-8eb6-49bb-9eb9-b1319ef63a96'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('10', 'Asset', '1', '0', '2015-03-13 06:42:36', '2015-04-01 07:05:23', 'c33713d2-b750-4fcc-aec9-1e3a048eff97'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('11', 'Asset', '1', '0', '2015-03-13 06:43:28', '2015-04-01 07:05:22', '1d36cba4-ad92-42b8-a724-164e5138c04f'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('12', 'MatrixBlock', '1', '0', '2015-03-13 06:43:50', '2015-04-01 06:34:00', 'cd4adccb-bfd5-4535-b1c0-667629a4291c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('13', 'MatrixBlock', '1', '0', '2015-03-13 06:43:50', '2015-04-01 06:34:00', '97b3e6be-6de0-4889-a98b-5dae58198ec3'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('14', 'MatrixBlock', '1', '0', '2015-03-13 06:43:50', '2015-04-01 06:34:00', 'cd7063f2-4b5e-4552-b8fb-c5ee73e8731b'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('15', 'MatrixBlock', '1', '0', '2015-03-13 06:43:50', '2015-04-01 06:34:00', 'd756b9a1-09a1-4bf9-a23b-2c84aa7ffb90'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('16', 'Asset', '1', '0', '2015-03-13 16:30:17', '2015-04-01 07:05:21', '7795bac8-1aa8-4b9e-b5ac-f4e36a99b8e4'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('17', 'MatrixBlock', '1', '0', '2015-03-13 16:30:32', '2015-04-01 06:34:00', 'b4d854cb-62d3-46b2-85ba-67f3fad54054'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('18', 'MatrixBlock', '1', '0', '2015-03-13 16:41:43', '2015-04-01 06:34:00', '9a7a9731-03c3-4604-9456-1d298e9d1fea'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('20', 'MatrixBlock', '1', '0', '2015-03-13 16:42:54', '2015-04-01 06:34:00', 'e184e609-4efa-4986-8737-cb759f6f0e50'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('21', 'Asset', '1', '0', '2015-03-16 12:47:37', '2015-04-01 07:05:19', 'edbfb2f9-eb9d-4ed7-8198-9cdc73c3ec5a'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('25', 'Asset', '1', '0', '2015-03-16 13:07:28', '2015-04-01 07:05:19', '43e31acc-872b-43eb-aa0a-28d91c0a215c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('29', 'Asset', '1', '0', '2015-03-16 13:08:48', '2015-04-01 07:05:20', '9134c7e0-4ff6-45f7-bc49-a16dc40603f3'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('31', 'Asset', '1', '0', '2015-03-16 13:09:36', '2015-04-01 07:05:19', '1e79735f-c317-4f02-a4a9-08f0b235ce3b'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('33', 'Asset', '1', '0', '2015-03-16 13:10:22', '2015-04-01 07:05:18', '615e4866-a922-4d13-906f-ffb4e9dc2a29'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('35', 'Asset', '1', '0', '2015-03-16 13:11:04', '2015-04-01 07:05:18', 'accae4a4-c0a5-449a-acdf-f80f393489d1'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('42', 'Asset', '1', '0', '2015-03-16 13:12:21', '2015-04-01 07:05:21', 'fdc82629-dd6b-42b5-b232-e66176acff11'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('44', 'Asset', '1', '0', '2015-03-16 13:12:55', '2015-04-01 07:05:20', '1964956a-ea66-4b47-a24f-53134a27faca'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('46', 'Asset', '1', '0', '2015-03-16 13:13:43', '2015-04-01 07:05:20', '176e8182-4e6a-460e-b7a6-1c5dcd4c2426'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('99', 'Asset', '1', '0', '2015-03-26 13:25:38', '2015-04-01 07:05:26', '57ae49b5-076d-420a-b11c-41b1e1dd0c70'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('101', 'Asset', '1', '0', '2015-03-26 17:27:52', '2015-04-01 07:05:26', 'e512ccc3-b89d-4918-adee-e4805f9fefde'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('102', 'Asset', '1', '0', '2015-03-26 17:30:00', '2015-04-01 07:05:25', '29176768-c31d-430a-a9f1-f9330cb3023d'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('106', 'Asset', '1', '0', '2015-03-27 14:15:10', '2015-04-01 07:05:24', '323b1cbe-a26e-4362-b0ac-28c52ff01026'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('107', 'Asset', '1', '0', '2015-03-27 14:17:11', '2015-04-01 07:05:23', '78c5c497-b1fc-4f64-a2fe-f2f61a5a4b0e'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('115', 'GlobalSet', '1', '0', '2015-03-28 10:11:43', '2015-04-01 06:34:00', '8c448da7-94d8-42b2-a38a-e8b649ef185d'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('117', 'Asset', '1', '0', '2015-03-28 17:35:21', '2015-04-01 07:05:26', 'f396089b-4e6f-49ab-a868-226b49326ea3'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('118', 'Asset', '1', '0', '2015-03-28 17:35:47', '2015-04-01 07:05:25', '0bf68a50-8178-4d90-88a4-2c0f7a91c5fb'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('121', 'Asset', '1', '0', '2015-04-01 07:05:25', '2015-04-01 07:05:25', '2bc2f6f0-2dba-4367-974a-86a237f54569'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('126', 'Entry', '1', '0', '2015-04-02 09:27:29', '2015-04-08 19:40:26', '5e2e0a5f-38b4-4e20-813e-5c9c8e8c62df'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('127', 'MatrixBlock', '1', '0', '2015-04-02 09:27:29', '2015-04-08 19:40:26', 'd19776f2-796a-4c8b-9702-275fa0229b61'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('128', 'Entry', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'bd06b351-e011-47ab-a47d-947984d8709e'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('129', 'MatrixBlock', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '1ccceffc-620c-4d63-b561-e51bcbce572e'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('130', 'MatrixBlock', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'f32c11cb-523d-4977-b213-142bba28283b'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('131', 'MatrixBlock', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'ef2296de-265b-4be0-8737-a7417e9b520c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('132', 'MatrixBlock', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '52472e6f-ecb0-4954-9429-b4826da66e3b'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('133', 'MatrixBlock', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '97cee697-466f-4da6-9af9-3d4f52b0a2f9'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('134', 'MatrixBlock', '1', '0', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'cc5a3ac4-c2cc-4643-9d9c-3428350f5513'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('135', 'MatrixBlock', '1', '0', '2015-04-02 11:43:59', '2015-04-08 19:40:26', 'b08c3a7d-53ce-4824-89b9-d5298d2ab38e'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('136', 'MatrixBlock', '1', '0', '2015-04-03 05:13:28', '2015-04-08 19:40:26', 'e762906b-4043-4440-ba1d-e62912019fc8'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('137', 'MatrixBlock', '1', '0', '2015-04-03 07:18:40', '2015-04-03 10:52:29', '2bd3c023-3224-4ab3-9803-90cc1e35da8f'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('138', 'MatrixBlock', '1', '0', '2015-04-03 10:18:58', '2015-04-03 10:52:29', '24ced023-b90b-47e9-8150-0d3833fc4758'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('139', 'MatrixBlock', '1', '0', '2015-04-06 13:54:17', '2015-04-08 19:40:26', 'dce2f50a-0cab-4010-847e-42cd1e56ac87'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('141', 'MatrixBlock', '1', '0', '2015-04-07 04:59:09', '2015-04-08 19:40:26', '783c638d-c168-4bd8-a64a-7f84df9f9757'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('143', 'MatrixBlock', '1', '0', '2015-04-08 19:16:37', '2015-04-08 19:40:26', '511c2cfc-9850-4314-a8f0-23dd682c028b'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('144', 'MatrixBlock', '1', '0', '2015-04-08 19:29:33', '2015-04-08 19:40:26', 'ce7b9898-6ab9-41d9-99b8-e9b4b93eae15'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('145', 'MatrixBlock', '1', '0', '2015-04-08 19:35:23', '2015-04-08 19:40:27', '81e38bf5-d57b-4923-a906-4d28cd5f3f4d'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('146', 'MatrixBlock', '1', '0', '2015-04-08 19:40:27', '2015-04-08 19:40:27', 'df364c6b-61b7-437d-ada5-e570f2ff5952'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('147', 'Entry', '1', '0', '2015-04-21 07:34:38', '2015-04-24 04:38:45', 'b4e5c417-16b1-4c9a-92ff-c34d35f74e65'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('148', 'MatrixBlock', '1', '0', '2015-04-21 07:34:39', '2015-04-24 04:38:46', '93b09bd9-657c-47f8-903d-64c9fbf72d72'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('149', 'Category', '1', '0', '2015-04-21 07:36:58', '2015-04-21 07:36:58', '1a36263e-dc06-408e-b845-e0262e26d860'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('150', 'Category', '1', '0', '2015-04-21 07:37:25', '2015-04-21 07:37:25', 'aecdabd3-6987-4f16-aa77-a930a0cd2bbc'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('151', 'Entry', '1', '0', '2015-04-21 07:50:11', '2015-04-24 07:16:54', 'b46c8146-1dd1-4878-94fe-258fabc9c7ee'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('153', 'MatrixBlock', '1', '0', '2015-04-22 06:31:17', '2015-04-24 04:38:46', 'fc5d26cc-2c90-4416-a2d0-16654d82e51e'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('154', 'MatrixBlock', '1', '0', '2015-04-22 08:20:05', '2015-04-24 04:38:46', '438aa78c-13c2-441f-bae4-53f2bfec5e8c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('155', 'MatrixBlock', '1', '0', '2015-04-23 06:16:21', '2015-04-24 04:38:46', 'c7bd354e-5818-4898-9229-215303dccb81'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('163', 'Entry', '1', '0', '2015-04-23 08:11:48', '2015-04-23 08:11:48', '88807e8d-42e7-4dd6-8293-cf7ff046ad4c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('164', 'Entry', '1', '0', '2015-04-23 08:12:27', '2015-04-23 08:12:27', 'e3867962-1b85-437d-a0ad-5e6fe0f90fa1'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('165', 'Entry', '1', '0', '2015-04-23 08:13:05', '2015-04-23 08:13:05', 'dd67f452-d0ff-418b-b66a-248813ad35f8'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('166', 'Entry', '1', '0', '2015-04-23 08:13:55', '2015-04-23 08:13:55', '28a43b43-0687-483a-b0f2-ed925a3f8cbb'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('167', 'Entry', '1', '0', '2015-04-23 08:14:42', '2015-04-23 08:14:42', 'c504a247-6edf-49ec-aa9c-2db5b765ac74'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('168', 'Entry', '1', '0', '2015-04-23 08:15:19', '2015-04-23 08:15:19', 'ea502906-ee13-4124-bfd1-a664f1a2d609'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('169', 'Entry', '1', '0', '2015-04-23 08:16:15', '2015-04-23 08:16:15', 'b2a27ccf-e2dc-4bf4-adc9-2e201a332051'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('170', 'Entry', '1', '0', '2015-04-23 08:16:56', '2015-04-23 08:16:56', 'b07e4571-4101-4073-8ed6-9e823de9a9f4'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('171', 'Entry', '1', '0', '2015-04-23 08:17:30', '2015-04-23 08:17:30', '0dd5ff89-eadf-4b4d-a7d4-ed9794d9c00c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('172', 'Entry', '1', '0', '2015-04-23 08:21:51', '2015-04-23 08:21:51', 'fc6eb699-771c-4a36-8d69-4712cb64e1d0'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('173', 'Entry', '1', '0', '2015-04-23 08:25:35', '2015-04-23 08:25:35', '54184fbb-6e4f-4e2e-b141-fa09d4a04ff6'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('174', 'Entry', '1', '0', '2015-04-23 08:26:12', '2015-04-23 08:26:12', 'b6fadac9-3966-47c6-ac5d-7c7c4709f3f7'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('175', 'MatrixBlock', '1', '0', '2015-04-23 08:47:36', '2015-04-24 04:38:46', 'dd457dd3-65fa-49ec-9268-eb0974516952'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('176', 'MatrixBlock', '1', '0', '2015-04-24 04:38:46', '2015-04-24 04:38:46', 'f19df9fa-5052-4bce-9a23-4597f2827fcd'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('177', 'MatrixBlock', '1', '0', '2015-04-24 05:05:06', '2015-04-24 07:16:54', 'e95050bf-31cc-4c08-ae1b-87bda70e273c'); INSERT INTO `craft_elements` (`id`, `type`, `enabled`, `archived`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('178', 'MatrixBlock', '1', '0', '2015-04-24 06:57:30', '2015-04-24 07:16:54', '0e1ff35d-38a7-41a0-9f8c-889c6ab33b38'); DROP TABLE IF EXISTS `craft_elements_i18n`; -- -- Schema for table `craft_elements_i18n` -- CREATE TABLE `craft_elements_i18n` ( `id` int(11) NOT NULL AUTO_INCREMENT, `elementId` int(11) NOT NULL, `locale` char(12) COLLATE utf8_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `uri` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1', `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_elements_i18n_elementId_locale_unq_idx` (`elementId`,`locale`), UNIQUE KEY `craft_elements_i18n_uri_locale_unq_idx` (`uri`,`locale`), KEY `craft_elements_i18n_slug_locale_idx` (`slug`,`locale`), KEY `craft_elements_i18n_enabled_idx` (`enabled`), KEY `craft_elements_i18n_locale_fk` (`locale`) ) ENGINE=InnoDB AUTO_INCREMENT=214 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_elements_i18n` -- INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', '1', 'en_us', '', NULL, '1', '2015-03-07 13:53:16', '2015-03-07 13:53:16', '645e7f3c-ca58-4f6a-ae9a-7a3070f83628'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', '2', 'en_us', 'homepage', '__home__', '1', '2015-03-07 13:53:17', '2015-04-01 06:33:59', 'ad2a6f5f-ebdf-4048-8ac9-7aae10825a3f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', '3', 'en_us', 'we-just-installed-craft', 'news/2015/we-just-installed-craft', '1', '2015-03-07 13:53:18', '2015-04-01 06:33:59', '303a12a8-4237-4044-9416-07810c0f8617'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('6', '6', 'en_us', 'aranca-banner', NULL, '1', '2015-03-12 08:52:56', '2015-04-01 07:05:23', '1da6d003-5460-4835-a9a7-08bb35ff0d3a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('8', '8', 'en_us', 'research', NULL, '1', '2015-03-13 06:40:54', '2015-04-01 07:05:22', 'dc591cd7-3081-4319-aea8-fb571e2e0f5a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('9', '9', 'en_us', 'development', NULL, '1', '2015-03-13 06:41:43', '2015-04-01 07:05:22', 'd400c79c-ef91-4405-9cd8-5a65e9c40244'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('10', '10', 'en_us', 'idea', NULL, '1', '2015-03-13 06:42:36', '2015-04-01 07:05:23', '38ef2b06-4631-4964-a0e1-bd9e3f64ccb5'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('11', '11', 'en_us', 'market', NULL, '1', '2015-03-13 06:43:28', '2015-04-01 07:05:22', '63f40e87-48e2-433d-afcb-960fd588b054'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('12', '12', 'en_us', '', NULL, '1', '2015-03-13 06:43:50', '2015-04-01 06:34:00', '5d45fcef-c297-4476-90f1-1df7080446a2'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('13', '13', 'en_us', '', NULL, '1', '2015-03-13 06:43:50', '2015-04-01 06:34:00', '08f77b90-46d0-49b1-9bb5-c0108587834f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('14', '14', 'en_us', '', NULL, '1', '2015-03-13 06:43:50', '2015-04-01 06:34:00', '0e5fecc3-371b-41c5-aa3e-6afae9347a34'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('15', '15', 'en_us', '', NULL, '1', '2015-03-13 06:43:50', '2015-04-01 06:34:00', 'fcd990d1-317c-412e-bd0c-6c98c5339d2a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('16', '16', 'en_us', 'anil', NULL, '1', '2015-03-13 16:30:17', '2015-04-01 07:05:21', 'e5f84581-66c1-4e8f-83d0-0103339287d8'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('17', '17', 'en_us', '', NULL, '1', '2015-03-13 16:30:32', '2015-04-01 06:34:00', 'df540968-814d-4c7c-89fe-c5ebcc23c6ae'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('18', '18', 'en_us', '', NULL, '1', '2015-03-13 16:41:43', '2015-04-01 06:34:00', '8989fc10-f6fb-4ef6-b238-fa564c965880'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('20', '20', 'en_us', '', NULL, '1', '2015-03-13 16:42:54', '2015-04-01 06:34:00', '60559331-f819-4675-aeed-501dddfef21f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('21', '21', 'en_us', 'hemendra-aran', NULL, '1', '2015-03-16 12:47:37', '2015-04-01 07:05:19', 'bf229062-b870-4476-8364-81f8a488ec4b'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('25', '25', 'en_us', 'madhusudan', NULL, '1', '2015-03-16 13:07:28', '2015-04-01 07:05:19', 'ddcc5e4d-4504-4b71-b47a-ca20573dc4dc'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('29', '29', 'en_us', 'neeraj-bharadwaj', NULL, '1', '2015-03-16 13:08:48', '2015-04-01 07:05:20', '8f4fca38-f4fa-4d14-9811-c951b6a98294'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('31', '31', 'en_us', 'christopher', NULL, '1', '2015-03-16 13:09:36', '2015-04-01 07:05:19', '4ef80e4f-deec-4cbb-a3c5-5adb9abe6e70'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('33', '33', 'en_us', 'kannan-siva', NULL, '1', '2015-03-16 13:10:22', '2015-04-01 07:05:18', '6b056eac-7cd2-4f04-afd5-c1daa6159931'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('35', '35', 'en_us', 'ashish-sethi', NULL, '1', '2015-03-16 13:11:04', '2015-04-01 07:05:18', '31b751ca-2ef9-42af-953b-3fbca79394a5'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('42', '42', 'en_us', 'srinivas-macha', NULL, '1', '2015-03-16 13:12:21', '2015-04-01 07:05:21', 'f535b363-5a5c-4c82-b418-8bdd26079466'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('44', '44', 'en_us', 'mona-bose', NULL, '1', '2015-03-16 13:12:55', '2015-04-01 07:05:20', 'eecb6b61-2f8b-44ff-92e0-05088650cee4'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('46', '46', 'en_us', 'ritesh-rawal', NULL, '1', '2015-03-16 13:13:44', '2015-04-01 07:05:20', 'd99273d8-cb65-465a-8733-8221886a6e63'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('93', '99', 'en_us', 'node', NULL, '1', '2015-03-26 13:25:38', '2015-04-01 07:05:26', '204d60f6-2fbb-480a-aab0-658252c4c3df'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('95', '101', 'en_us', 'hills-cropped', NULL, '1', '2015-03-26 17:27:52', '2015-04-01 07:05:26', 'aeb3850b-a31d-45e3-9a3a-1be5f9146d52'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('96', '102', 'en_us', 'hills-cropped-1', NULL, '1', '2015-03-26 17:30:00', '2015-04-01 07:05:25', 'c6d9f8fc-4593-472d-9312-e037473105bd'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('100', '106', 'en_us', 'blog09', NULL, '1', '2015-03-27 14:15:10', '2015-04-01 07:05:24', '19d449d8-be5f-48b6-80de-0349138bf6cb'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('101', '107', 'en_us', 'blog01', NULL, '1', '2015-03-27 14:17:11', '2015-04-01 07:05:23', '4dcd6df9-ea54-482d-aead-47a095327628'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('108', '115', 'en_us', '', NULL, '1', '2015-03-28 10:11:43', '2015-04-01 06:34:00', 'aff5a5d5-0bee-42f6-8aec-d93a152ed62a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('110', '117', 'en_us', 'p08', NULL, '1', '2015-03-28 17:35:21', '2015-04-01 07:05:26', '2f7ce49a-784e-4e17-810a-8fc1b4f0a6fd'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('111', '118', 'en_us', 'blog10', NULL, '1', '2015-03-28 17:35:47', '2015-04-01 07:05:25', '8a981dd5-60c8-419c-b252-51e246eb150f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('113', '6', 'de', 'aranca-banner', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:23', 'ef742a98-e765-4865-919f-002a3560bea9'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('114', '8', 'de', 'research', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:22', '47c974b0-af51-4011-8fa9-e8735275a9c1'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('115', '9', 'de', 'development', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:22', 'a96edd0c-b905-4f26-93c5-2d15b0a58cd5'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('116', '10', 'de', 'idea', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:23', '53f2d0a2-95ca-4ced-9671-631246906f80'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('117', '11', 'de', 'market', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:22', 'ee8dc8ba-6f36-4f33-b8ef-7e1657c1f50a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('118', '16', 'de', 'anil', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:21', 'e25d617f-86bc-4d93-af50-1728c00b0b04'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('119', '21', 'de', 'hemendra-aran', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:19', '971f30bb-cff3-4f91-abe9-089355d6e37c'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('120', '25', 'de', 'madhusudan', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:19', 'f3df051e-8108-4959-b840-3d43bf33dc2a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('121', '29', 'de', 'neeraj-bharadwaj', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:20', '6442ab63-e747-4557-b294-aefb81412ebf'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('122', '31', 'de', 'christopher', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:19', 'f399ce0f-88a7-497e-b4ce-3e28226e3d6e'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('123', '33', 'de', 'kannan-siva', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:18', 'b84d39d1-aab8-4f2f-87d8-66e45de45b59'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('124', '35', 'de', 'ashish-sethi', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:18', '7efcb109-275b-49c8-9d1b-493ea553e97b'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('125', '42', 'de', 'srinivas-macha', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:21', '70bd6f8f-880f-4054-a4b3-7af7c372b919'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('126', '44', 'de', 'mona-bose', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:20', 'e8809395-8b34-47f8-82db-14b11027ba12'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('127', '46', 'de', 'ritesh-rawal', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:20', '21b4f89f-3cac-425f-be65-c1f1a85365c8'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('128', '99', 'de', 'node', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:26', 'c13402e2-d0c5-4e2c-bab7-a7319aa2e0c6'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('129', '101', 'de', 'hills-cropped', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:26', '3c076712-d1a1-4fbc-98f6-b3b369391bf7'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('130', '102', 'de', 'hills-cropped-1', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:25', '89343e88-fd30-4d5e-9693-fc06c9e2d1a6'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('131', '106', 'de', 'blog09', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:24', '898456b0-42a2-4bf0-bb18-f42acbf313f7'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('132', '107', 'de', 'blog01', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:23', 'f2e581cf-911e-4f6b-ace5-da211af5ae5b'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('133', '117', 'de', 'p08', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:26', 'ec8cf45d-8d7a-401b-9d8e-91e6e1549391'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('134', '118', 'de', 'blog10', NULL, '1', '2015-04-01 06:33:58', '2015-04-01 07:05:25', '05167f79-45c8-42b5-aa5c-75fb3fdc7f41'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('135', '115', 'de', '', NULL, '1', '2015-04-01 06:34:00', '2015-04-01 06:34:00', 'edec61cf-b0dc-436d-98ba-d61cb0415a9f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('141', '121', 'en_us', 'blog04', NULL, '1', '2015-04-01 07:05:25', '2015-04-01 07:05:25', 'fe0cea25-7628-4424-9920-477f743b4646'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('142', '121', 'de', 'blog04', NULL, '1', '2015-04-01 07:05:25', '2015-04-01 07:05:25', '074c6e66-4f78-4a60-8a62-206989201ee2'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('148', '126', 'en_us', 'about-us', 'about-aranca/about-us', '1', '2015-04-02 09:27:29', '2015-04-08 19:40:26', 'dc5df9af-503c-438d-9d93-74d92b700c9d'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('149', '126', 'de', 'about-us', 'about-aranca/about-us', '1', '2015-04-02 09:27:29', '2015-04-08 19:40:26', '1ae69203-a09f-4a2b-b913-d247e64dbe29'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('150', '127', 'en_us', '', NULL, '1', '2015-04-02 09:27:30', '2015-04-08 19:40:26', 'fbecc5d7-6866-4dd5-86ba-8e9c32228a2c'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('151', '128', 'en_us', 'case-studies', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '04c3e4fe-e447-4d28-8bd0-74ba1773c5df'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('152', '128', 'de', 'case-studies', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'e86c6151-d148-4c9e-978c-22c7a492bf09'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('153', '129', 'en_us', '', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '84476e5f-55c2-4bda-b8ab-3b506b8325c5'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('154', '130', 'en_us', '', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'bce9168b-57ed-4abc-a479-37e81731b9a3'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('155', '131', 'en_us', '', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '434b29b2-121b-440a-82d4-116666736be8'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('156', '132', 'en_us', '', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '324b7e45-fa7d-4bb5-8cfe-e05d7bc765d8'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('157', '133', 'en_us', '', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'f7fe4428-d3df-41c3-9c51-be90630f8fdc'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('158', '134', 'en_us', '', NULL, '1', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '57a316b7-01f1-42e3-b3e9-372d8a56d2ac'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('159', '135', 'en_us', '', NULL, '1', '2015-04-02 11:44:00', '2015-04-08 19:40:26', 'e1d79e84-d2a5-4c74-8430-b91a43c723f7'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('160', '136', 'en_us', '', NULL, '1', '2015-04-03 05:13:28', '2015-04-08 19:40:26', '0caf9703-4157-4f21-9a55-03616f43084d'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('161', '137', 'de', '', NULL, '1', '2015-04-03 07:18:40', '2015-04-03 10:52:29', '7dc205dd-f0f2-4630-a63d-73baad3a4a10'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('162', '138', 'de', '', NULL, '1', '2015-04-03 10:18:58', '2015-04-03 10:52:29', 'cb3ae5f2-3adb-404c-a023-f358f62b7930'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('163', '139', 'en_us', '', NULL, '1', '2015-04-06 13:54:17', '2015-04-08 19:40:26', '4d83f82b-8b4d-48b2-b83f-5a4c228559c3'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('165', '141', 'en_us', '', NULL, '1', '2015-04-07 04:59:09', '2015-04-08 19:40:26', 'ae1357b1-9f32-4a6c-beb6-1d3f29789558'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('167', '143', 'en_us', '', NULL, '1', '2015-04-08 19:16:37', '2015-04-08 19:40:26', 'd561a196-04d1-442a-bfbe-e3fbb6edf7e3'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('168', '144', 'en_us', '', NULL, '1', '2015-04-08 19:29:33', '2015-04-08 19:40:27', 'f5f4b888-dd8f-47db-81f9-f9a5f944fc0c'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('169', '145', 'en_us', '', NULL, '1', '2015-04-08 19:35:24', '2015-04-08 19:40:27', '7a54f0f2-7ea2-4e1f-a234-399d3e4858f0'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('170', '146', 'en_us', '', NULL, '1', '2015-04-08 19:40:27', '2015-04-08 19:40:27', 'fbbd89eb-9d9f-4094-a3f0-a9f625e6a17f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('171', '147', 'en_us', 'overview', 'market-intelligence/overview', '1', '2015-04-21 07:34:39', '2015-04-24 04:38:46', 'c9a20d12-a424-40e4-bb9e-89418ee66771'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('172', '147', 'de', 'overview', '/overview', '1', '2015-04-21 07:34:39', '2015-04-24 04:38:46', 'b6cde988-f4e6-47fc-881d-5aa8fdc748bc'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('173', '148', 'en_us', '', NULL, '1', '2015-04-21 07:34:39', '2015-04-24 04:38:46', '8ac08a87-b938-4fa2-8b7b-957491cad2a0'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('174', '149', 'en_us', 'market-intelligence', 'market-intelligence', '1', '2015-04-21 07:36:58', '2015-04-21 07:54:19', '7cfc900a-49d6-4a75-ad60-120f7806ce82'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('175', '149', 'de', 'market-intelligence', 'market-intelligence', '1', '2015-04-21 07:36:58', '2015-04-21 07:54:20', 'f427877c-e838-4aa5-bfeb-ebf187dd264b'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('176', '150', 'en_us', 'research-solutions', 'market-intelligence/research-solutions', '1', '2015-04-21 07:37:25', '2015-04-21 07:54:20', '677ab1a4-f6b3-46ef-be4b-8fda72538d21'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('177', '150', 'de', 'research-solutions', 'market-intelligence/research-solutions', '1', '2015-04-21 07:37:25', '2015-04-21 07:54:20', 'e98cb8f6-bfda-47e5-b890-a30b98660c26'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('178', '151', 'en_us', 'research-solutions-overview', 'market-intelligence/research-solutions/research-solutions-overview', '1', '2015-04-21 07:50:11', '2015-04-24 07:16:54', 'df845aae-cee0-4139-8b27-3d5e033b8cb9'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('179', '151', 'de', 'research-solutions-overview', '/research-solutions-overview', '1', '2015-04-21 07:50:11', '2015-04-24 07:16:54', 'da9a3f1f-810e-4a07-8f37-5baa8bdb7c2b'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('181', '153', 'en_us', '', NULL, '1', '2015-04-22 06:31:17', '2015-04-24 04:38:46', '45f1bcd2-a7a7-4f5e-837d-849cb0bf1a59'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('182', '154', 'en_us', '', NULL, '1', '2015-04-22 08:20:05', '2015-04-24 04:38:46', '674b876c-e142-400c-84a9-ecb1985668b5'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('183', '155', 'en_us', '', NULL, '1', '2015-04-23 06:16:21', '2015-04-24 04:38:46', 'bed8ccd0-0ab3-40a6-84d4-4970d4f9baa3'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('198', '163', 'en_us', 'hemendra-aran', NULL, '1', '2015-04-23 08:11:49', '2015-04-23 08:11:49', '02c522cb-ee92-4fa3-aa02-0f0a6da60bff'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('199', '164', 'en_us', 'madhusudan-rajagopalan', NULL, '1', '2015-04-23 08:12:27', '2015-04-23 08:12:27', '262c7f75-60b8-4c34-8b20-f9c154e4d675'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('200', '165', 'en_us', 'neeraj-bhardwaj', NULL, '1', '2015-04-23 08:13:05', '2015-04-23 08:13:05', '953ab664-3b2c-48c5-ac80-42a8047898b5'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('201', '166', 'en_us', 'christopher-kingsman', NULL, '1', '2015-04-23 08:13:55', '2015-04-23 08:13:55', 'd6be2815-0c2e-4c41-a2a8-adc5856204e0'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('202', '167', 'en_us', 'kannan-sivasubramanian', NULL, '1', '2015-04-23 08:14:42', '2015-04-23 08:14:42', '70fc8638-9ef0-467f-b2ff-1a860f6c960f'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('203', '168', 'en_us', 'ashish-sethi', NULL, '1', '2015-04-23 08:15:19', '2015-04-23 08:15:19', '7be37520-1e16-4b93-90f7-e4800b4b5b81'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('204', '169', 'en_us', 'srinivas-macha', NULL, '1', '2015-04-23 08:16:15', '2015-04-23 08:16:15', '019538eb-e766-464f-85a7-5be9ae3ce4e6'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('205', '170', 'en_us', 'mona-bose', NULL, '1', '2015-04-23 08:16:56', '2015-04-23 08:16:56', 'ef91328e-81f4-4125-bdbb-24f54ea0d492'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('206', '171', 'en_us', 'ritesh-rawal', NULL, '1', '2015-04-23 08:17:30', '2015-04-23 08:17:30', '0dbd8800-84a5-4ef8-9070-195afebf784a'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('207', '172', 'en_us', 'dr-anil-chauhan', NULL, '1', '2015-04-23 08:21:51', '2015-04-23 08:21:51', '373f941b-d67f-4323-9528-73a030dbe6d4'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('208', '173', 'en_us', 'xyz', NULL, '1', '2015-04-23 08:25:35', '2015-04-23 08:25:35', '5af85c22-7b9b-422c-9fdb-e410da7f4452'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('209', '174', 'en_us', 'abc', NULL, '1', '2015-04-23 08:26:13', '2015-04-23 08:26:13', 'fb94d3b7-5fca-4e35-857b-0a2248481ccf'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('210', '175', 'en_us', '', NULL, '1', '2015-04-23 08:47:36', '2015-04-24 04:38:46', '3ee4b9ff-6fb9-4f8f-8b45-1bdb69fe8bb6'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('211', '176', 'en_us', '', NULL, '1', '2015-04-24 04:38:46', '2015-04-24 04:38:46', '1c363370-283d-4012-9e2c-b8d4c664d831'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('212', '177', 'en_us', '', NULL, '1', '2015-04-24 05:05:06', '2015-04-24 07:16:54', 'f9e87f6a-cc6e-4314-9b7b-408ab9542f10'); INSERT INTO `craft_elements_i18n` (`id`, `elementId`, `locale`, `slug`, `uri`, `enabled`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('213', '178', 'en_us', '', NULL, '1', '2015-04-24 06:57:30', '2015-04-24 07:16:54', '952ef437-aca5-4290-bf5f-b8f91a669f61'); DROP TABLE IF EXISTS `craft_emailmessages`; -- -- Schema for table `craft_emailmessages` -- CREATE TABLE `craft_emailmessages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` char(150) COLLATE utf8_unicode_ci NOT NULL, `locale` char(12) COLLATE utf8_unicode_ci NOT NULL, `subject` varchar(1000) COLLATE utf8_unicode_ci NOT NULL, `body` text COLLATE utf8_unicode_ci NOT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_emailmessages_key_locale_unq_idx` (`key`,`locale`), KEY `craft_emailmessages_locale_fk` (`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `craft_entries`; -- -- Schema for table `craft_entries` -- CREATE TABLE `craft_entries` ( `id` int(11) NOT NULL, `sectionId` int(11) NOT NULL, `typeId` int(11) DEFAULT NULL, `authorId` int(11) DEFAULT NULL, `postDate` datetime DEFAULT NULL, `expiryDate` datetime DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `craft_entries_sectionId_idx` (`sectionId`), KEY `craft_entries_typeId_idx` (`typeId`), KEY `craft_entries_postDate_idx` (`postDate`), KEY `craft_entries_expiryDate_idx` (`expiryDate`), KEY `craft_entries_authorId_fk` (`authorId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_entries` -- INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', '1', '1', NULL, '2015-03-12 07:10:05', NULL, '2015-03-07 13:53:17', '2015-03-13 16:43:01', 'e0760dfb-41f6-4f7d-b1f0-9f22757ae3a0'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', '2', '2', '1', '2015-03-07 13:53:17', NULL, '2015-03-07 13:53:18', '2015-03-07 13:53:18', 'a07cdc53-b717-43a3-8593-b8ad76741df6'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('126', '3', '3', '1', '2015-04-02 09:27:00', NULL, '2015-04-02 09:27:30', '2015-04-08 19:40:27', '7375f4bb-dad1-4eac-81ba-fb18b5d7d98d'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('128', '7', '7', '1', '2015-04-02 09:50:52', NULL, '2015-04-02 09:50:52', '2015-04-02 09:50:52', 'abafef80-d287-4027-9ea2-d38ab4efc0f2'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('147', '8', '8', '1', '2015-04-21 07:34:00', NULL, '2015-04-21 07:34:40', '2015-04-24 04:38:46', 'bdf65f2c-714b-427d-9daa-aeb48159a140'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('151', '8', '8', '1', '2015-04-21 07:50:00', NULL, '2015-04-21 07:50:11', '2015-04-24 07:16:54', 'c02c1f65-0e3a-4988-b854-58299033f2da'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('163', '4', '4', '1', '2015-04-23 08:11:48', NULL, '2015-04-23 08:11:49', '2015-04-23 08:11:49', '31b0d81b-1d4b-4c06-98ee-22905a3fbb67'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('164', '4', '4', '1', '2015-04-23 08:12:27', NULL, '2015-04-23 08:12:27', '2015-04-23 08:12:27', '60615743-f6dd-4e66-bd9e-30a18f2f35f3'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('165', '4', '4', '1', '2015-04-23 08:13:05', NULL, '2015-04-23 08:13:05', '2015-04-23 08:13:05', '090bd89f-92e3-4f0c-8769-5efa10e934ab'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('166', '4', '4', '1', '2015-04-23 08:13:55', NULL, '2015-04-23 08:13:55', '2015-04-23 08:13:55', 'a7076b33-8f21-48af-9348-6320a6949692'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('167', '4', '4', '1', '2015-04-23 08:14:42', NULL, '2015-04-23 08:14:42', '2015-04-23 08:14:42', 'fd9f927c-49c3-4c40-aa76-a8e5e36c35aa'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('168', '4', '4', '1', '2015-04-23 08:15:19', NULL, '2015-04-23 08:15:19', '2015-04-23 08:15:19', 'e9f0348b-c2de-4e64-a5f4-a23195838379'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('169', '4', '4', '1', '2015-04-23 08:16:15', NULL, '2015-04-23 08:16:16', '2015-04-23 08:16:16', '0262e5ba-875d-4ceb-a0d1-0f61544b8660'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('170', '4', '4', '1', '2015-04-23 08:16:56', NULL, '2015-04-23 08:16:56', '2015-04-23 08:16:56', '3aa6c902-efe3-457f-bc2b-d3b0a3b8e9ea'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('171', '4', '4', '1', '2015-04-23 08:17:30', NULL, '2015-04-23 08:17:30', '2015-04-23 08:17:30', '95a77bad-0bdd-42da-988b-d7767325d304'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('172', '5', '5', '1', '2015-04-23 08:21:51', NULL, '2015-04-23 08:21:51', '2015-04-23 08:21:51', '3f2ad7ee-ddf8-4820-a68d-956ac3ab6214'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('173', '5', '5', '1', '2015-04-23 08:25:35', NULL, '2015-04-23 08:25:35', '2015-04-23 08:25:35', '6ba04d40-d90b-446c-8979-9047c9330684'); INSERT INTO `craft_entries` (`id`, `sectionId`, `typeId`, `authorId`, `postDate`, `expiryDate`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('174', '5', '5', '1', '2015-04-23 08:26:12', NULL, '2015-04-23 08:26:13', '2015-04-23 08:26:13', '69535339-b872-4fde-8c42-4c938cda1c83'); DROP TABLE IF EXISTS `craft_entrydrafts`; -- -- Schema for table `craft_entrydrafts` -- CREATE TABLE `craft_entrydrafts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entryId` int(11) NOT NULL, `sectionId` int(11) NOT NULL, `creatorId` int(11) NOT NULL, `locale` char(12) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `notes` tinytext COLLATE utf8_unicode_ci, `data` mediumtext COLLATE utf8_unicode_ci NOT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `craft_entrydrafts_entryId_locale_idx` (`entryId`,`locale`), KEY `craft_entrydrafts_sectionId_fk` (`sectionId`), KEY `craft_entrydrafts_creatorId_fk` (`creatorId`), KEY `craft_entrydrafts_locale_fk` (`locale`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; DROP TABLE IF EXISTS `craft_entrytypes`; -- -- Schema for table `craft_entrytypes` -- CREATE TABLE `craft_entrytypes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sectionId` int(11) NOT NULL, `fieldLayoutId` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `handle` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `hasTitleField` tinyint(1) unsigned NOT NULL DEFAULT '1', `titleLabel` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'Title', `titleFormat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sortOrder` tinyint(4) DEFAULT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `craft_entrytypes_name_sectionId_unq_idx` (`name`,`sectionId`), UNIQUE KEY `craft_entrytypes_handle_sectionId_unq_idx` (`handle`,`sectionId`), KEY `craft_entrytypes_sectionId_fk` (`sectionId`), KEY `craft_entrytypes_fieldLayoutId_fk` (`fieldLayoutId`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_entrytypes` -- INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', '1', '36', 'Homepage', 'homepage', '1', 'Title', NULL, NULL, '2015-03-07 13:53:17', '2015-03-13 16:24:55', 'b47c7bbe-d3a2-42d6-83fd-71615d83769c'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', '2', '5', 'News', 'news', '1', 'Title', NULL, NULL, '2015-03-07 13:53:17', '2015-03-07 13:53:17', 'bcf04656-e5c2-403d-bcac-e0c7236041d7'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', '3', '327', 'About Us', 'aboutUs', '1', 'Title', NULL, NULL, '2015-03-16 07:58:20', '2015-04-07 10:25:52', '68fcc5c1-3375-4669-a287-2adef84040bd'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('4', '4', '454', 'Company', 'company', '1', 'Employee Name', NULL, NULL, '2015-03-20 08:04:18', '2015-04-23 08:09:23', 'ac392312-1af2-475d-b063-0b30fd9165d4'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('5', '5', '453', 'Client', 'client', '1', 'Client Name', NULL, NULL, '2015-03-20 08:09:06', '2015-04-23 08:07:17', 'e3fc1df0-fe7f-4cf8-a95f-665bcf14cac7'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('6', '6', '90', 'Event', 'event', '1', 'Title', NULL, NULL, '2015-03-25 13:30:31', '2015-03-25 13:34:20', '9f419e97-a953-46b5-a819-03a777754744'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('7', '7', '196', 'Case Studies', 'caseStudies', '1', 'Title', NULL, NULL, '2015-04-02 09:43:44', '2015-04-02 09:46:18', 'a231a479-ff65-48b9-8d94-2c1c9ae04572'); INSERT INTO `craft_entrytypes` (`id`, `sectionId`, `fieldLayoutId`, `name`, `handle`, `hasTitleField`, `titleLabel`, `titleFormat`, `sortOrder`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('8', '8', '380', 'Services', 'services', '1', 'Title', NULL, NULL, '2015-04-21 07:33:25', '2015-04-22 06:01:50', 'ba7837e2-491b-4d9d-85f9-69065e733751'); DROP TABLE IF EXISTS `craft_entryversions`; -- -- Schema for table `craft_entryversions` -- CREATE TABLE `craft_entryversions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `entryId` int(11) NOT NULL, `sectionId` int(11) NOT NULL, `creatorId` int(11) DEFAULT NULL, `locale` char(12) COLLATE utf8_unicode_ci NOT NULL, `num` smallint(6) unsigned NOT NULL, `notes` tinytext COLLATE utf8_unicode_ci, `data` mediumtext COLLATE utf8_unicode_ci NOT NULL, `dateCreated` datetime NOT NULL, `dateUpdated` datetime NOT NULL, `uid` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `craft_entryversions_entryId_locale_idx` (`entryId`,`locale`), KEY `craft_entryversions_sectionId_fk` (`sectionId`), KEY `craft_entryversions_creatorId_fk` (`creatorId`), KEY `craft_entryversions_locale_fk` (`locale`) ) ENGINE=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Data for table `craft_entryversions` -- INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('1', '2', '1', '1', 'en_us', '1', '', '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1426144205,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"3\":[\"6\"],\"1\":\"It\'s true, this site doesn\'t have a whole lot of content yet, but don\'t worry. Our web developers have just installed the CMS, and they\'re setting things up for the content editors this very moment. Soon Aranca.craft.dev will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\",\"4\":{\"new1\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"8\"],\"heading\":\"Investment Research\",\"body\":\"Access solutions ranging from equity research outsourcing to economic research outsourcing and analytical support across asset classes, markets and client segments.\"}},\"new2\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"9\"],\"heading\":\"Business Research\",\"body\":\"Get quick, accurate and insightful answers to critical questions on markets, competition, business risk assessment, customers, supply chain, innovation and technology trends\"}},\"new3\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"10\"],\"heading\":\"Valuation & Advisory\",\"body\":\"Access high quality business valuation and advisory services for diverse transaction and reporting needs. From start-ups and growth-stage to well established private companies.\"}},\"new4\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"11\"],\"heading\":\"Intellectual Property Research\",\"body\":\"Quick and accurate research, across all stages of the Patent Lifecycle. Our solution suite covers everything from intellectual property research to analytics and valuation services.\"}}}}}', '2015-03-13 06:43:50', '2015-03-13 06:43:50', '6e67e7fd-d569-40af-964a-863c4716f928'); INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('2', '2', '1', '1', 'en_us', '2', '', '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1426144205,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"3\":[\"6\"],\"1\":\"
It\'s true, this site doesn\'t have a whole lot of content yet, but don\'t worry. Our web developers have just installed the CMS, and they\'re setting things up for the content editors this very moment. Soon Aranca.craft.dev will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\",\"4\":{\"12\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"8\"],\"heading\":\"Investment Research\",\"body\":\"Access solutions ranging from equity research outsourcing to economic research outsourcing and analytical support across asset classes, markets and client segments.\"}},\"13\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"9\"],\"heading\":\"Business Research\",\"body\":\"Get quick, accurate and insightful answers to critical questions on markets, competition, business risk assessment, customers, supply chain, innovation and technology trends\"}},\"14\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"10\"],\"heading\":\"Valuation & Advisory\",\"body\":\"Access high quality business valuation and advisory services for diverse transaction and reporting needs. From start-ups and growth-stage to well established private companies.\"}},\"15\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"11\"],\"heading\":\"Intellectual Property Research\",\"body\":\"Quick and accurate research, across all stages of the Patent Lifecycle. Our solution suite covers everything from intellectual property research to analytics and valuation services.\"}}},\"8\":{\"new1\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":[\"16\"],\"personName\":\"Anil\",\"affiliation\":\"Company X\",\"testimonial\":\"We at ABLE really appreciate the professional acumen of ARANCA team in both project management and domain knowledge, which resulted a great work on BIO-IT and HEALTHCARE report, which is appreciated among all segment of industry, academia and policy maker and has a fair impact on international market to understand indian landscape of BIO-IT status its potential and role in healthcare in all its aspect.\"}}}}}', '2015-03-13 16:30:32', '2015-03-13 16:30:32', '950b1dac-fd07-44c8-a00e-5e821fb2a292'); INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('3', '2', '1', '1', 'en_us', '3', '', '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1426144205,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"3\":[\"6\"],\"1\":\"
It\'s true, this site doesn\'t have a whole lot of content yet, but don\'t worry. Our web developers have just installed the CMS, and they\'re setting things up for the content editors this very moment. Soon Aranca.craft.dev will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\",\"4\":{\"12\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"8\"],\"heading\":\"Investment Research\",\"body\":\"Access solutions ranging from equity research outsourcing to economic research outsourcing and analytical support across asset classes, markets and client segments.\"}},\"13\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"9\"],\"heading\":\"Business Research\",\"body\":\"Get quick, accurate and insightful answers to critical questions on markets, competition, business risk assessment, customers, supply chain, innovation and technology trends\"}},\"14\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"10\"],\"heading\":\"Valuation & Advisory\",\"body\":\"Access high quality business valuation and advisory services for diverse transaction and reporting needs. From start-ups and growth-stage to well established private companies.\"}},\"15\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"11\"],\"heading\":\"Intellectual Property Research\",\"body\":\"Quick and accurate research, across all stages of the Patent Lifecycle. Our solution suite covers everything from intellectual property research to analytics and valuation services.\"}}},\"8\":{\"17\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":[\"16\"],\"personName\":\"Anil\",\"affiliation\":\"Company X\",\"testimonial\":\"We at ABLE really appreciate the professional acumen of ARANCA team in both project management and domain knowledge, which resulted a great work on BIO-IT and HEALTHCARE report, which is appreciated among all segment of industry, academia and policy maker and has a fair impact on international market to understand indian landscape of BIO-IT status its potential and role in healthcare in all its aspect.\"}},\"new1\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mrr. X\",\"affiliation\":\"CFO, Cloud-based platform for bankers and investors\",\"testimonial\":\"\\\"The Aranca team has been vital to our success in our first 18 months as a business. The team\'s dedication to providing high quality, timely and consistent work is absolutely outstanding. Over the past year we have made tremendous operational improvements that are a direct result of the compelling efforts made every day by the team. Everyone here would like to extend their gratitude to each team member for all of their hard work. We are excited for what 2014 will bring and look forward to continuing our partnership. \"}}}}}', '2015-03-13 16:41:43', '2015-03-13 16:41:43', '4df574c0-a9f7-4f30-8d2e-be1aafb5f453'); INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('4', '2', '1', '1', 'en_us', '4', '', '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1426144205,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"3\":[\"6\"],\"1\":\"
It\'s true, this site doesn\'t have a whole lot of content yet, but don\'t worry. Our web developers have just installed the CMS, and they\'re setting things up for the content editors this very moment. Soon Aranca.craft.dev will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\",\"4\":{\"12\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"8\"],\"heading\":\"Investment Research\",\"body\":\"Access solutions ranging from equity research outsourcing to economic research outsourcing and analytical support across asset classes, markets and client segments.\"}},\"13\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"9\"],\"heading\":\"Business Research\",\"body\":\"Get quick, accurate and insightful answers to critical questions on markets, competition, business risk assessment, customers, supply chain, innovation and technology trends\"}},\"14\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"10\"],\"heading\":\"Valuation & Advisory\",\"body\":\"Access high quality business valuation and advisory services for diverse transaction and reporting needs. From start-ups and growth-stage to well established private companies.\"}},\"15\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"11\"],\"heading\":\"Intellectual Property Research\",\"body\":\"Quick and accurate research, across all stages of the Patent Lifecycle. Our solution suite covers everything from intellectual property research to analytics and valuation services.\"}}},\"8\":{\"17\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":[\"16\"],\"personName\":\"Anil\",\"affiliation\":\"Company X\",\"testimonial\":\"We at ABLE really appreciate the professional acumen of ARANCA team in both project management and domain knowledge, which resulted a great work on BIO-IT and HEALTHCARE report, which is appreciated among all segment of industry, academia and policy maker and has a fair impact on international market to understand indian landscape of BIO-IT status its potential and role in healthcare in all its aspect.\"}},\"18\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mr. X\",\"affiliation\":\"CFO, Cloud-based platform for bankers and investors\",\"testimonial\":\"\\\"The Aranca team has been vital to our success in our first 18 months as a business. The team\'s dedication to providing high quality, timely and consistent work is absolutely outstanding. Over the past year we have made tremendous operational improvements that are a direct result of the compelling efforts made every day by the team. Everyone here would like to extend their gratitude to each team member for all of their hard work. We are excited for what 2014 will bring and look forward to continuing our partnership. \"}},\"new1\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mr. Y\",\"affiliation\":\" Senior Vice President, Leading asset management and investment banking firm\",\"testimonial\":\"\\\"The analysts provide great support with regards to drafting of funds materials, conducting market research and financial analysis. We can count on them to deliver assignments on time and as instructed. Their positive attitude and willingness to work late or on weekends if required is a big plus.\\\"\"}}}}}', '2015-03-13 16:42:53', '2015-03-13 16:42:53', '39269de5-1760-4a0f-a6f1-bd9dd9cb0733'); INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('5', '2', '1', '1', 'en_us', '5', '', '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1426144205,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"3\":[\"6\"],\"1\":\"
It\'s true, this site doesn\'t have a whole lot of content yet, but don\'t worry. Our web developers have just installed the CMS, and they\'re setting things up for the content editors this very moment. Soon Aranca.craft.dev will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\",\"4\":{\"12\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"8\"],\"heading\":\"Investment Research\",\"body\":\"Access solutions ranging from equity research outsourcing to economic research outsourcing and analytical support across asset classes, markets and client segments.\"}},\"13\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"9\"],\"heading\":\"Business Research\",\"body\":\"Get quick, accurate and insightful answers to critical questions on markets, competition, business risk assessment, customers, supply chain, innovation and technology trends\"}},\"14\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"10\"],\"heading\":\"Valuation & Advisory\",\"body\":\"Access high quality business valuation and advisory services for diverse transaction and reporting needs. From start-ups and growth-stage to well established private companies.\"}},\"15\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"11\"],\"heading\":\"Intellectual Property Research\",\"body\":\"Quick and accurate research, across all stages of the Patent Lifecycle. Our solution suite covers everything from intellectual property research to analytics and valuation services.\"}}},\"8\":{\"17\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":[\"16\"],\"personName\":\"Anil\",\"affiliation\":\"Company X\",\"testimonial\":\"We at ABLE really appreciate the professional acumen of ARANCA team in both project management and domain knowledge, which resulted a great work on BIO-IT and HEALTHCARE report, which is appreciated among all segment of industry, academia and policy maker and has a fair impact on international market to understand indian landscape of BIO-IT status its potential and role in healthcare in all its aspect.\"}},\"18\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mr. X\",\"affiliation\":\"CFO, Cloud-based platform for bankers and investors\",\"testimonial\":\"\\\"The Aranca team has been vital to our success in our first 18 months as a business. The team\'s dedication to providing high quality, timely and consistent work is absolutely outstanding. Over the past year we have made tremendous operational improvements that are a direct result of the compelling efforts made every day by the team. Everyone here would like to extend their gratitude to each team member for all of their hard work. We are excited for what 2014 will bring and look forward to continuing our partnership. \"}},\"new1\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mr. Y\",\"affiliation\":\" Senior Vice President, Leading asset management and investment banking firm\",\"testimonial\":\"\\\"The analysts provide great support with regards to drafting of funds materials, conducting market research and financial analysis. We can count on them to deliver assignments on time and as instructed. Their positive attitude and willingness to work late or on weekends if required is a big plus.\\\"\"}}}}}', '2015-03-13 16:42:54', '2015-03-13 16:42:54', 'e6722357-94ed-4874-bf68-5f400a0a7da8'); INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('6', '2', '1', '1', 'en_us', '6', '', '{\"typeId\":\"1\",\"authorId\":null,\"title\":\"Homepage\",\"slug\":\"homepage\",\"postDate\":1426144205,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"3\":[\"6\"],\"1\":\"
It\'s true, this site doesn\'t have a whole lot of content yet, but don\'t worry. Our web developers have just installed the CMS, and they\'re setting things up for the content editors this very moment. Soon Aranca.craft.dev will be an oasis of fresh perspectives, sharp analyses, and astute opinions that will keep you coming back again and again.<\\/p>\",\"4\":{\"12\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"8\"],\"heading\":\"Investment Research\",\"body\":\"Access solutions ranging from equity research outsourcing to economic research outsourcing and analytical support across asset classes, markets and client segments.\"}},\"13\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"9\"],\"heading\":\"Business Research\",\"body\":\"Get quick, accurate and insightful answers to critical questions on markets, competition, business risk assessment, customers, supply chain, innovation and technology trends\"}},\"14\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"10\"],\"heading\":\"Valuation & Advisory\",\"body\":\"Access high quality business valuation and advisory services for diverse transaction and reporting needs. From start-ups and growth-stage to well established private companies.\"}},\"15\":{\"type\":\"services\",\"enabled\":\"1\",\"fields\":{\"icon\":[\"11\"],\"heading\":\"Intellectual Property Research\",\"body\":\"Quick and accurate research, across all stages of the Patent Lifecycle. Our solution suite covers everything from intellectual property research to analytics and valuation services.\"}}},\"8\":{\"17\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":[\"16\"],\"personName\":\"Anil\",\"affiliation\":\"Company X\",\"testimonial\":\"We at ABLE really appreciate the professional acumen of ARANCA team in both project management and domain knowledge, which resulted a great work on BIO-IT and HEALTHCARE report, which is appreciated among all segment of industry, academia and policy maker and has a fair impact on international market to understand indian landscape of BIO-IT status its potential and role in healthcare in all its aspect.\"}},\"18\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mr. X\",\"affiliation\":\"CFO, Cloud-based platform for bankers and investors\",\"testimonial\":\"\\\"The Aranca team has been vital to our success in our first 18 months as a business. The team\'s dedication to providing high quality, timely and consistent work is absolutely outstanding. Over the past year we have made tremendous operational improvements that are a direct result of the compelling efforts made every day by the team. Everyone here would like to extend their gratitude to each team member for all of their hard work. We are excited for what 2014 will bring and look forward to continuing our partnership. \"}},\"20\":{\"type\":\"testimonials\",\"enabled\":\"1\",\"fields\":{\"image\":\"\",\"personName\":\"Mr. Y\",\"affiliation\":\" Senior Vice President, Leading asset management and investment banking firm\",\"testimonial\":\"\\\"The analysts provide great support with regards to drafting of funds materials, conducting market research and financial analysis. We can count on them to deliver assignments on time and as instructed. Their positive attitude and willingness to work late or on weekends if required is a big plus.\\\"\"}}}}}', '2015-03-13 16:43:01', '2015-03-13 16:43:01', 'a97489b1-63ce-4ce1-bb35-5b781f7c9679');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('106', '126', '3', '1', 'en_us', '1', '', '{\"typeId\":null,\"authorId\":\"1\",\"title\":\"About Us\",\"slug\":\"about-us\",\"postDate\":1427966849,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"26\":{\"new1\":{\"type\":\"intro\",\"enabled\":\"1\",\"fields\":{\"headline\":\"About Us\",\"lead\":\"Aranca is a leading provider of high quality, customized and cost effective research and analytics to global clients. Founded in UK in 2003, Aranca has a global presence including in the US, Europe and Middle East, and a state-of-the-art delivery center in Mumbai, India.\"}}},\"29\":\"\"}}', '2015-04-02 09:27:30', '2015-04-02 09:27:30', 'c7802b5f-2fc2-42b6-a442-33e3bd5161ce');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('107', '128', '7', '1', 'en_us', '1', '', '{\"typeId\":null,\"authorId\":\"1\",\"title\":\"Case Studies\",\"slug\":\"case-studies\",\"postDate\":1427968252,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"57\":{\"new1\":{\"type\":\"caseStudy\",\"enabled\":\"1\",\"fields\":{\"headline\":\"TAX VALUATION\",\"description\":\"A semiconductor company having a history of profitable operations, looking for an exit in the form of an IPO \\/ M&A, and looking to issue options to its employees.\"}},\"new2\":{\"type\":\"caseStudy\",\"enabled\":\"1\",\"fields\":{\"headline\":\"FINANCIAL REPORTING\",\"description\":\"A Biotech company developing a proprietary technology to economically produce a biological pesticide, in collaboration with a big pesticide company,\"}},\"new3\":{\"type\":\"caseStudy\",\"enabled\":\"1\",\"fields\":{\"headline\":\"PATENT VALUATION\",\"description\":\"A publishing company that had recently acquired two ad network companies and was looking to issue common options to its employees post acquisition.\"}},\"new4\":{\"type\":\"caseStudy\",\"enabled\":\"1\",\"fields\":{\"headline\":\"FUND RAISING\",\"description\":\"A publishing company that had recently acquired two ad network companies and was looking to issue common options to its employees post acquisition.\"}},\"new5\":{\"type\":\"caseStudy\",\"enabled\":\"1\",\"fields\":{\"headline\":\"Invalidation search (sequence analysis) for a specific microbial ORF region\",\"description\":\"A Germany based molecular diagnostics firm was interested in an invalidation study related to a microbial ORF consensus region of four sequences\"}},\"new6\":{\"type\":\"caseStudy\",\"enabled\":\"1\",\"fields\":{\"headline\":\"Landscape analysis for benchmarking client\\u2019s portfolio in wind energy domain\",\"description\":\"A leading wind turbine manufacturer engaged Aranca to benchmark its patents with competitors in the wind energy domain\"}}}}}', '2015-04-02 09:50:52', '2015-04-02 09:50:52', '8407fa08-ea04-4188-b04a-585dd5cb5876');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('108', '126', '3', '1', 'en_us', '2', '', '{\"typeId\":\"3\",\"authorId\":\"1\",\"title\":\"About Us\",\"slug\":\"about-us\",\"postDate\":1427966820,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"26\":{\"127\":{\"type\":\"intro\",\"enabled\":\"1\",\"fields\":{\"headline\":\"About Us\",\"lead\":\"Aranca is a leading provider of high quality, customized and cost effective research and analytics to global clients. Founded in UK in 2003, Aranca has a global presence including in the US, Europe and Middle East, and a state-of-the-art delivery center in Mumbai, India.\"}}},\"29\":{\"new1\":{\"type\":\"contentSlider\",\"enabled\":\"1\",\"fields\":{\"caseStudies\":[\"128\"]}}}}}', '2015-04-02 11:44:00', '2015-04-02 11:44:00', '9e33b439-7dbb-4fff-82ea-ae4592e5fa91');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('109', '126', '3', '1', 'en_us', '3', '', '{\"typeId\":\"3\",\"authorId\":\"1\",\"title\":\"About Us\",\"slug\":\"about-us\",\"postDate\":1427966820,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"26\":{\"127\":{\"type\":\"intro\",\"enabled\":\"1\",\"fields\":{\"headline\":\"About Us\",\"lead\":\"Aranca is a leading provider of high quality, customized and cost effective research and analytics to global clients. Founded in UK in 2003, Aranca has a global presence including in the US, Europe and Middle East, and a state-of-the-art delivery center in Mumbai, India.\"}}},\"29\":{\"135\":{\"type\":\"contentSlider\",\"enabled\":\"1\",\"fields\":{\"caseStudies\":[\"128\"]}},\"new1\":{\"type\":\"gallery\",\"enabled\":\"1\",\"fields\":{\"image\":[\"107\",\"121\",\"106\",\"118\",\"101\",\"102\",\"99\"],\"imageName\":\"\"}}}}}', '2015-04-03 05:13:28', '2015-04-03 05:13:28', '4ddfdad5-2566-474c-a78d-6dce72df7718');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('110', '126', '3', '1', 'de', '1', '', '{\"typeId\":\"3\",\"authorId\":\"1\",\"title\":\"About Us\",\"slug\":\"about-us\",\"postDate\":1427966820,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"26\":\"\",\"29\":{\"new1\":{\"type\":\"contentTabs\",\"enabled\":\"1\",\"fields\":{\"contentTabs\":[{\"col1\":\"Some Header\",\"col2\":\"Stanly!! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ducimus, id, temporibus, sapiente, enim unde molestiae adipisci obcaecati aliquam quisquam impedit et similique quasi ut beatae tenetur assumenda nihil esse facere.\"},{\"col1\":\"Header 2\",\"col2\":\"Lorem\"}]}}}}}', '2015-04-03 07:18:40', '2015-04-03 07:18:40', '40e610ae-c49f-4750-8ab1-589bb5747a64');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('111', '126', '3', '1', 'de', '2', '', '{\"typeId\":\"3\",\"authorId\":\"1\",\"title\":\"About Us\",\"slug\":\"about-us\",\"postDate\":1427966820,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"26\":\"\",\"29\":{\"137\":{\"type\":\"contentTabs\",\"enabled\":\"1\",\"fields\":{\"contentTabs\":[{\"col1\":\"Some Header\",\"col2\":\"Stanly!! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ducimus, id, temporibus, sapiente, enim unde molestiae adipisci obcaecati aliquam quisquam impedit et similique quasi ut beatae tenetur assumenda nihil esse facere.\"},{\"col1\":\"Header 2\",\"col2\":\"Lorem\"}]}}}}}', '2015-04-03 07:18:49', '2015-04-03 07:18:49', '381a5cb6-3591-4632-890e-05c5162aa31a');
INSERT INTO `craft_entryversions` (`id`, `entryId`, `sectionId`, `creatorId`, `locale`, `num`, `notes`, `data`, `dateCreated`, `dateUpdated`, `uid`) VALUES ('112', '126', '3', '1', 'de', '3', '', '{\"typeId\":\"3\",\"authorId\":\"1\",\"title\":\"About Us\",\"slug\":\"about-us\",\"postDate\":1427966820,\"expiryDate\":null,\"enabled\":1,\"fields\":{\"26\":\"\",\"29\":{\"137\":{\"type\":\"contentTabs\",\"enabled\":\"1\",\"fields\":{\"contentTabs\":[{\"col1\":\"Some Header\",\"col2\":\"Stanly!! Lorem ipsum dolor sit amet, consectetur adipisicing elit. Ducimus, id, temporibus, sapiente, enim unde molestiae adipisci obcaecati aliquam quisquam impedit et similique quasi ut beatae tenetur assumenda nihil esse facere.\"},{\"col1\":\"Header 2\",\"col2\":\"Lorem\"}]}},\"new1\":{\"type\":\"featureList\",\"enabled\":\"1\",\"fields\":{\"featuresFourBlock\":\"