CREATE TABLE `LayoutPrototype` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `layoutPrototypeId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `settings_` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`layoutPrototypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `LayoutPrototype`
--

INSERT INTO `LayoutPrototype` VALUES (0,'59c1606d-cfa8-27f6-af68-050fa8ab182f',30491,20115,20119,NULL,'2021-11-18 19:50:05.329000','2021-11-18 19:50:05.329000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Name language-id=\"es_ES\">Seleccione una página de visualización</Name><Name language-id=\"ar_SA\">اختيار صفحة عرض</Name><Name language-id=\"fr_FR\">Choisir une page d\'affichage</Name><Name language-id=\"en_US\">Content Display Page</Name><Name language-id=\"de_DE\">Anzeigeseite auswählen</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Description language-id=\"es_ES\">Cree, edite y explore contenidos web de esta página. Busque contenido adicional, explore contenido relacionado con etiquetas y hojee las categorías del contenido.</Description><Description language-id=\"ar_SA\">إنشاء، تحرير، واستكشاف محتوى ويب من هذه الصفحة. البحث عن المحتوى المتوفر، واستكشاف محتوى ذا صلة مع العلامات، واستعراض فئات المحتوى. (Automatic Translation)</Description><Description language-id=\"fr_FR\">Créer, éditer et explorer le contenu web de cette page. Rechercher un contenu disponible, explorer le contenu à l\'aide des tags et parcourir les catégories du contenu.</Description><Description language-id=\"en_US\">Create, edit, and explore web content from this page. Search available content, explore related content with tags, and browse content categories.</Description><Description language-id=\"de_DE\">Erstellen, bearbeiten und finden von Webcontent dieser Seite. Durchsuchen Sie verfügbare Inhalte, erkunden Sie ähnliche Inhalte über Schlagwörter und durchsuchen Sie Kategorien.</Description></root>',NULL,1),(0,'a930596b-1c50-861e-28ed-0923ede7653d',30570,20115,20119,NULL,'2021-11-18 19:51:25.061000','2021-11-18 19:51:25.061000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Name language-id=\"es_ES\">Wiki</Name><Name language-id=\"ar_SA\">Wiki (Automatic Copy)</Name><Name language-id=\"fr_FR\">Wiki</Name><Name language-id=\"en_US\">Wiki</Name><Name language-id=\"de_DE\">Wiki</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Description language-id=\"es_ES\">Colabora con los miembros a través de la wiki en esta página. Descubre el contenido relacionado a través de etiquetas y navega rápida y fácilmente por las categorías.</Description><Description language-id=\"ar_SA\">Collaborate with members through the wiki on this page. Discover related content through tags, and navigate quickly and easily with categories. (Automatic Copy)</Description><Description language-id=\"fr_FR\">Collaborez avec les membres par le bias de wiki sur cette page. Découvrez le contenu lié par le biais des tags et naviguez rapidement et facilement avec les catégories.</Description><Description language-id=\"en_US\">Collaborate with members through the wiki on this page. Discover related content through tags, and navigate quickly and easily with categories.</Description><Description language-id=\"de_DE\">Arbeiten Sie mit Hilfe des Wikis dieser Seite mit anderen Mitgliedern zusammen. Entdecken Sie in Verbindung stehende Inhalte über Tags und navigieren Sie schnell und einfach mit Kategorien.</Description></root>',NULL,1),(0,'c5167a78-5942-5109-897b-dc880a730466',30581,20115,20119,NULL,'2021-11-18 19:51:31.270000','2021-11-18 19:51:31.270000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Name language-id=\"es_ES\">Blog</Name><Name language-id=\"ar_SA\">المدوّنات</Name><Name language-id=\"fr_FR\">Blogue</Name><Name language-id=\"en_US\">Blog</Name><Name language-id=\"de_DE\">Blog</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Description language-id=\"es_ES\">Cree, edite y vea blogs desde esta página. Explore los temas usando etiquetas y conecte con otros miembros del blog.</Description><Description language-id=\"ar_SA\">Create, edit, and view blogs from this page. Explore topics using tags, and connect with other members that blog. (Automatic Copy)</Description><Description language-id=\"fr_FR\">Créer, éditer et visualiser les blogs de cette page. Explorer les sujets en utilisant des tags et se connecter à d\'autres membres de ce blog.</Description><Description language-id=\"en_US\">Create, edit, and view blogs from this page. Explore topics using tags, and connect with other members that blog.</Description><Description language-id=\"de_DE\">Erstellen, bearbeiten und ansehen von Blogs dieser Seite. Erkunden Sie Themen mit Hilfe von Tags und verbinden Sie sich mit anderen Mitgliedern, die bloggen.</Description></root>',NULL,1);

--
-- Table structure for table `LayoutRevision`
--

CREATE TABLE `LayoutRevision` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `layoutRevisionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `layoutSetBranchId` bigint(20) DEFAULT NULL,
  `layoutBranchId` bigint(20) DEFAULT NULL,
  `parentLayoutRevisionId` bigint(20) DEFAULT NULL,
  `head` tinyint(4) DEFAULT NULL,
  `major` tinyint(4) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  `privateLayout` tinyint(4) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `keywords` longtext DEFAULT NULL,
  `robots` longtext DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  `iconImageId` bigint(20) DEFAULT NULL,
  `themeId` varchar(75) DEFAULT NULL,
  `colorSchemeId` varchar(75) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`layoutRevisionId`),
  KEY `IX_43E8286A` (`head`,`plid`),
  KEY `IX_E10AC39` (`layoutSetBranchId`,`head`,`plid`),
  KEY `IX_38C5DF14` (`layoutSetBranchId`,`layoutBranchId`,`head`,`plid`),
  KEY `IX_13984800` (`layoutSetBranchId`,`layoutBranchId`,`plid`),
  KEY `IX_4A84AF43` (`layoutSetBranchId`,`parentLayoutRevisionId`,`plid`),
  KEY `IX_70DA9ECB` (`layoutSetBranchId`,`plid`,`status`),
  KEY `IX_7FFAE700` (`layoutSetBranchId`,`status`),
  KEY `IX_8EC3D2BC` (`plid`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `LayoutRevision`
--


--
-- Table structure for table `LayoutSet`
--

CREATE TABLE `LayoutSet` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `layoutSetId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `privateLayout` tinyint(4) DEFAULT NULL,
  `logoId` bigint(20) DEFAULT NULL,
  `themeId` varchar(75) DEFAULT NULL,
  `colorSchemeId` varchar(75) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `pageCount` int(11) DEFAULT NULL,
  `settings_` longtext DEFAULT NULL,
  `layoutSetPrototypeUuid` varchar(75) DEFAULT NULL,
  `layoutSetPrototypeLinkEnabled` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`layoutSetId`),
  UNIQUE KEY `IX_48550691` (`groupId`,`privateLayout`),
  KEY `IX_72BBA8B7` (`layoutSetPrototypeUuid`),
  KEY `IX_1B698D9` (`privateLayout`,`logoId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `LayoutSet`
--

INSERT INTO `LayoutSet` VALUES (1,20133,20132,20115,'2021-11-18 19:43:41.788000','2021-11-18 19:43:42.794000',1,0,'classic_WAR_classictheme','01','',1,'',NULL,0),(0,20135,20132,20115,'2021-11-18 19:43:41.862000','2021-11-18 19:43:41.862000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(0,20140,20139,20115,'2021-11-18 19:43:43.089000','2021-11-18 19:43:43.089000',1,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(1,20141,20139,20115,'2021-11-18 19:43:43.119000','2021-11-18 19:49:08.541000',0,0,'classic_WAR_classictheme','01','',1,'',NULL,0),(6,20143,20142,20115,'2021-11-18 19:43:43.529000','2021-12-03 21:33:11.027000',1,0,'classic_WAR_classictheme','01','',1,'lfr-theme:regular:show-header-search=false\n',NULL,0),(27,20144,20142,20115,'2021-11-18 19:43:43.557000','2023-07-10 19:47:12.674000',0,0,'wcktheme_WAR_wcktheme','01','',11,'lfr-theme:regular:show-header-search=false\n',NULL,0),(0,20149,20148,20115,'2021-11-18 19:43:44.682000','2021-11-18 19:43:44.682000',1,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(0,20150,20148,20115,'2021-11-18 19:43:44.711000','2021-11-18 19:43:44.711000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(0,20152,20151,20115,'2021-11-18 19:43:45.251000','2021-11-18 19:43:45.251000',1,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(0,20153,20151,20115,'2021-11-18 19:43:45.280000','2021-11-18 19:43:45.280000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(2,20159,20158,20115,'2021-11-18 19:43:46.192000','2021-11-18 19:55:11.603000',1,0,'userdashboard_WAR_userdashboardtheme','01','',1,'',NULL,0),(0,20160,20158,20115,'2021-11-18 19:43:46.220000','2021-11-18 19:43:46.220000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(1,30493,30492,20115,'2021-11-18 19:50:05.541000','2021-11-18 19:50:06.512000',1,0,'classic_WAR_classictheme','01','',1,'',NULL,0),(0,30494,30492,20115,'2021-11-18 19:50:05.569000','2021-11-18 19:50:05.569000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(16,30555,30554,20115,'2021-11-18 19:51:16.023000','2021-11-18 19:51:24.715000',1,0,'classic_WAR_classictheme','01','',2,'',NULL,0),(0,30556,30554,20115,'2021-11-18 19:51:16.055000','2021-11-18 19:51:16.055000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(1,30572,30571,20115,'2021-11-18 19:51:25.432000','2021-11-18 19:51:26.314000',1,0,'classic_WAR_classictheme','01','',1,'',NULL,0),(0,30573,30571,20115,'2021-11-18 19:51:25.461000','2021-11-18 19:51:25.461000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(1,30583,30582,20115,'2021-11-18 19:51:31.446000','2021-11-18 19:51:32.322000',1,0,'classic_WAR_classictheme','01','',1,'',NULL,0),(0,30584,30582,20115,'2021-11-18 19:51:31.474000','2021-11-18 19:51:31.474000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(20,30604,30603,20115,'2021-11-18 19:51:58.254000','2021-11-18 19:52:08.595000',1,0,'classic_WAR_classictheme','01','',3,'',NULL,0),(0,30605,30603,20115,'2021-11-18 19:51:58.282000','2021-11-18 19:51:58.282000',0,0,'classic_WAR_classictheme','01','',0,'',NULL,0),(28,33405,33404,20115,'2021-11-23 21:32:02.137000','2021-11-30 14:14:52.960000',1,0,'userdashboard_WAR_userdashboardtheme','01','',0,'last-merge-time=1638198257271\n','175dd257-9eb1-88d7-c628-ceaccb3abf51',0),(3,33406,33404,20115,'2021-11-23 21:32:02.142000','2021-11-29 14:39:36.363000',0,0,'wcktheme_WAR_wcktheme','01','',0,'lfr-theme:regular:show-header-search=false\n',NULL,0);

--
-- Table structure for table `LayoutSetBranch`
--

CREATE TABLE `LayoutSetBranch` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `layoutSetBranchId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `privateLayout` tinyint(4) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `master` tinyint(4) DEFAULT NULL,
  `logoId` bigint(20) DEFAULT NULL,
  `themeId` varchar(75) DEFAULT NULL,
  `colorSchemeId` varchar(75) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `settings_` longtext DEFAULT NULL,
  `layoutSetPrototypeUuid` varchar(75) DEFAULT NULL,
  `layoutSetPrototypeLinkEnabled` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`layoutSetBranchId`),
  UNIQUE KEY `IX_5FF18552` (`groupId`,`privateLayout`,`name`),
  KEY `IX_CCF0DA29` (`groupId`,`privateLayout`,`master`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `LayoutSetBranch`
--


--
-- Table structure for table `LayoutSetPrototype`
--

CREATE TABLE `LayoutSetPrototype` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `layoutSetPrototypeId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `settings_` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`layoutSetPrototypeId`),
  KEY `IX_9178FC71` (`companyId`,`active_`),
  KEY `IX_D9FFCA84` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `LayoutSetPrototype`
--

INSERT INTO `LayoutSetPrototype` VALUES (19,'175dd257-9eb1-88d7-c628-ceaccb3abf51',30553,20115,20119,NULL,'2021-11-18 19:51:15.807000','2022-10-19 15:32:41.925000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Name language-id=\"es_ES\">Sitio de la Comunidad</Name><Name language-id=\"ar_SA\">Community Site</Name><Name language-id=\"fr_FR\">Site de communauté</Name><Name language-id=\"en_US\">Community Site</Name><Name language-id=\"de_DE\">Community-Site</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Description language-id=\"es_ES\">Sitio con foro y wiki</Description><Description language-id=\"ar_SA\">Site with Forums and Wiki</Description><Description language-id=\"fr_FR\">Site avec forums et wiki</Description><Description language-id=\"en_US\">Site with Forums and Wiki</Description><Description language-id=\"de_DE\">Site mit Forum und Wiki</Description></root>','layoutsUpdateable=true\n',1),(23,'80519f03-f82d-31a9-a0a6-43465808398a',30602,20115,20119,NULL,'2021-11-18 19:51:58.074000','2022-10-19 15:32:41.925000','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Name language-id=\"es_ES\">Sitio de intranet</Name><Name language-id=\"ar_SA\">Intranet Site</Name><Name language-id=\"fr_FR\">Site intranet</Name><Name language-id=\"en_US\">Intranet Site</Name><Name language-id=\"de_DE\">Intranet-Site</Name></root>','<?xml version=\'1.0\' encoding=\'UTF-8\'?><root available-locales=\"en_US,es_ES,ar_SA,fr_FR,de_DE,\" default-locale=\"en_US\"><Description language-id=\"es_ES\">Sitio con documentos y noticias</Description><Description language-id=\"ar_SA\">Site with Documents and News</Description><Description language-id=\"fr_FR\">Site avec documents et actualités</Description><Description language-id=\"en_US\">Site with Documents and News</Description><Description language-id=\"de_DE\">Site mit Dokumenten und Nachrichten</Description></root>','layoutsUpdateable=true\n',1);

--
-- Table structure for table `ListType`
--

CREATE TABLE `ListType` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `listTypeId` bigint(20) NOT NULL,
  `name` varchar(75) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`listTypeId`),
  KEY `IX_77729718` (`name`,`type_`),
  KEY `IX_2932DD37` (`type_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ListType`
--

INSERT INTO `ListType` VALUES (0,1,NULL,'com.liferay.portal.kernel.model.Contact.prefix'),(0,2,NULL,'com.liferay.portal.kernel.model.Contact.suffix'),(0,10000,'billing','com.liferay.portal.kernel.model.Account.address'),(0,10001,'other','com.liferay.portal.kernel.model.Account.address'),(0,10002,'p-o-box','com.liferay.portal.kernel.model.Account.address'),(0,10003,'shipping','com.liferay.portal.kernel.model.Account.address'),(0,10004,'email-address','com.liferay.portal.kernel.model.Account.emailAddress'),(0,10005,'email-address-2','com.liferay.portal.kernel.model.Account.emailAddress'),(0,10006,'email-address-3','com.liferay.portal.kernel.model.Account.emailAddress'),(0,10007,'fax','com.liferay.portal.kernel.model.Account.phone'),(0,10008,'local','com.liferay.portal.kernel.model.Account.phone'),(0,10009,'other','com.liferay.portal.kernel.model.Account.phone'),(0,10010,'toll-free','com.liferay.portal.kernel.model.Account.phone'),(0,10011,'tty','com.liferay.portal.kernel.model.Account.phone'),(0,10012,'intranet','com.liferay.portal.kernel.model.Account.website'),(0,10013,'public','com.liferay.portal.kernel.model.Account.website'),(0,11000,'business','com.liferay.portal.kernel.model.Contact.address'),(0,11001,'other','com.liferay.portal.kernel.model.Contact.address'),(0,11002,'personal','com.liferay.portal.kernel.model.Contact.address'),(0,11003,'email-address','com.liferay.portal.kernel.model.Contact.emailAddress'),(0,11004,'email-address-2','com.liferay.portal.kernel.model.Contact.emailAddress'),(0,11005,'email-address-3','com.liferay.portal.kernel.model.Contact.emailAddress'),(0,11006,'business','com.liferay.portal.kernel.model.Contact.phone'),(0,11007,'business-fax','com.liferay.portal.kernel.model.Contact.phone'),(0,11008,'mobile-phone','com.liferay.portal.kernel.model.Contact.phone'),(0,11009,'other','com.liferay.portal.kernel.model.Contact.phone'),(0,11010,'pager','com.liferay.portal.kernel.model.Contact.phone'),(0,11011,'personal','com.liferay.portal.kernel.model.Contact.phone'),(0,11012,'personal-fax','com.liferay.portal.kernel.model.Contact.phone'),(0,11013,'tty','com.liferay.portal.kernel.model.Contact.phone'),(0,11014,'dr','com.liferay.portal.kernel.model.Contact.prefix'),(0,11015,'mr','com.liferay.portal.kernel.model.Contact.prefix'),(0,11016,'mrs','com.liferay.portal.kernel.model.Contact.prefix'),(0,11017,'ms','com.liferay.portal.kernel.model.Contact.prefix'),(0,11020,'ii','com.liferay.portal.kernel.model.Contact.suffix'),(0,11021,'iii','com.liferay.portal.kernel.model.Contact.suffix'),(0,11022,'iv','com.liferay.portal.kernel.model.Contact.suffix'),(0,11023,'jr','com.liferay.portal.kernel.model.Contact.suffix'),(0,11024,'phd','com.liferay.portal.kernel.model.Contact.suffix'),(0,11025,'sr','com.liferay.portal.kernel.model.Contact.suffix'),(0,11026,'blog','com.liferay.portal.kernel.model.Contact.website'),(0,11027,'business','com.liferay.portal.kernel.model.Contact.website'),(0,11028,'other','com.liferay.portal.kernel.model.Contact.website'),(0,11029,'personal','com.liferay.portal.kernel.model.Contact.website'),(0,12000,'billing','com.liferay.portal.kernel.model.Organization.address'),(0,12001,'other','com.liferay.portal.kernel.model.Organization.address'),(0,12002,'p-o-box','com.liferay.portal.kernel.model.Organization.address'),(0,12003,'shipping','com.liferay.portal.kernel.model.Organization.address'),(0,12004,'email-address','com.liferay.portal.kernel.model.Organization.emailAddress'),(0,12005,'email-address-2','com.liferay.portal.kernel.model.Organization.emailAddress'),(0,12006,'email-address-3','com.liferay.portal.kernel.model.Organization.emailAddress'),(0,12007,'fax','com.liferay.portal.kernel.model.Organization.phone'),(0,12008,'local','com.liferay.portal.kernel.model.Organization.phone'),(0,12009,'other','com.liferay.portal.kernel.model.Organization.phone'),(0,12010,'toll-free','com.liferay.portal.kernel.model.Organization.phone'),(0,12011,'tty','com.liferay.portal.kernel.model.Organization.phone'),(0,12012,'administrative','com.liferay.portal.kernel.model.Organization.service'),(0,12013,'contracts','com.liferay.portal.kernel.model.Organization.service'),(0,12014,'donation','com.liferay.portal.kernel.model.Organization.service'),(0,12015,'retail','com.liferay.portal.kernel.model.Organization.service'),(0,12016,'training','com.liferay.portal.kernel.model.Organization.service'),(0,12017,'full-member','com.liferay.portal.kernel.model.Organization.status'),(0,12018,'provisional-member','com.liferay.portal.kernel.model.Organization.status'),(0,12019,'intranet','com.liferay.portal.kernel.model.Organization.website'),(0,12020,'public','com.liferay.portal.kernel.model.Organization.website');

--
-- Table structure for table `Lock_`
--

CREATE TABLE `Lock_` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `lockId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `className` varchar(75) DEFAULT NULL,
  `key_` varchar(200) DEFAULT NULL,
  `owner` varchar(1024) DEFAULT NULL,
  `inheritable` tinyint(4) DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`lockId`),
  UNIQUE KEY `IX_228562AD` (`className`,`key_`),
  KEY `IX_E3F1286B` (`expirationDate`),
  KEY `IX_2C418EAE` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Lock_`
--


--
-- Table structure for table `MBBan`
--

CREATE TABLE `MBBan` (
  `uuid_` varchar(75) DEFAULT NULL,
  `banId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `banUserId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`banId`),
  UNIQUE KEY `IX_8ABC4E3B` (`groupId`,`banUserId`),
  UNIQUE KEY `IX_2A3B68F6` (`uuid_`,`groupId`),
  KEY `IX_69951A25` (`banUserId`),
  KEY `IX_48814BBA` (`userId`),
  KEY `IX_4F841574` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBBan`
--


--
-- Table structure for table `MBCategory`
--

CREATE TABLE `MBCategory` (
  `uuid_` varchar(75) DEFAULT NULL,
  `categoryId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `parentCategoryId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `displayStyle` varchar(75) DEFAULT NULL,
  `threadCount` int(11) DEFAULT NULL,
  `messageCount` int(11) DEFAULT NULL,
  `lastPostDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`categoryId`),
  UNIQUE KEY `IX_F7D28C2F` (`uuid_`,`groupId`),
  KEY `IX_D1642361` (`categoryId`,`groupId`,`parentCategoryId`,`status`),
  KEY `IX_E15A5DB5` (`companyId`,`status`),
  KEY `IX_C295DBEE` (`groupId`,`parentCategoryId`,`status`),
  KEY `IX_DA84A9F7` (`groupId`,`status`),
  KEY `IX_13DF4E6D` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBCategory`
--


--
-- Table structure for table `MBDiscussion`
--

CREATE TABLE `MBDiscussion` (
  `uuid_` varchar(75) DEFAULT NULL,
  `discussionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `threadId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`discussionId`),
  UNIQUE KEY `IX_33A4DE38` (`classNameId`,`classPK`),
  UNIQUE KEY `IX_B5CA2DC` (`threadId`),
  UNIQUE KEY `IX_F7AAC799` (`uuid_`,`groupId`),
  KEY `IX_7E965757` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBDiscussion`
--

INSERT INTO `MBDiscussion` VALUES ('a173954d-d419-2f28-9717-f5aa65249375',46877,20142,0,20155,'Test Test','2022-06-13 18:44:56.461000','2022-06-13 18:44:56.461000',20015,46862,46875,NULL),('f3fb0496-ff14-8fd6-a060-9d9b9803758c',47004,20142,0,20155,'Test Test','2022-06-17 16:10:48.383000','2022-06-17 16:10:48.383000',20015,46887,47002,NULL),('a4cd2e5e-198d-684f-76ef-e0feef54e9d6',57229,20142,0,20155,'Test Test','2023-01-31 14:40:33.762000','2023-01-31 14:40:33.762000',20015,57214,57227,NULL),('f48627ec-47f6-81b0-16f2-dedffa856c00',57281,20142,0,20155,'Test Test','2023-01-31 14:51:59.857000','2023-01-31 14:51:59.857000',20015,57262,57279,NULL),('92d04c15-3e2f-5cd4-275d-63983b335d4d',57307,20142,0,20155,'Test Test','2023-01-31 17:14:21.985000','2023-01-31 17:14:21.985000',20015,57291,57305,NULL);

--
-- Table structure for table `MBMailingList`
--

CREATE TABLE `MBMailingList` (
  `uuid_` varchar(75) DEFAULT NULL,
  `mailingListId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `categoryId` bigint(20) DEFAULT NULL,
  `emailAddress` varchar(254) DEFAULT NULL,
  `inProtocol` varchar(75) DEFAULT NULL,
  `inServerName` varchar(75) DEFAULT NULL,
  `inServerPort` int(11) DEFAULT NULL,
  `inUseSSL` tinyint(4) DEFAULT NULL,
  `inUserName` varchar(75) DEFAULT NULL,
  `inPassword` varchar(75) DEFAULT NULL,
  `inReadInterval` int(11) DEFAULT NULL,
  `outEmailAddress` varchar(254) DEFAULT NULL,
  `outCustom` tinyint(4) DEFAULT NULL,
  `outServerName` varchar(75) DEFAULT NULL,
  `outServerPort` int(11) DEFAULT NULL,
  `outUseSSL` tinyint(4) DEFAULT NULL,
  `outUserName` varchar(75) DEFAULT NULL,
  `outPassword` varchar(75) DEFAULT NULL,
  `allowAnonymous` tinyint(4) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`mailingListId`),
  UNIQUE KEY `IX_76CE9CDD` (`groupId`,`categoryId`),
  UNIQUE KEY `IX_E858F170` (`uuid_`,`groupId`),
  KEY `IX_BFEB984F` (`active_`),
  KEY `IX_FC61676E` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBMailingList`
--


--
-- Table structure for table `MBMessage`
--

CREATE TABLE `MBMessage` (
  `uuid_` varchar(75) DEFAULT NULL,
  `messageId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `categoryId` bigint(20) DEFAULT NULL,
  `threadId` bigint(20) DEFAULT NULL,
  `rootMessageId` bigint(20) DEFAULT NULL,
  `parentMessageId` bigint(20) DEFAULT NULL,
  `subject` varchar(75) DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `format` varchar(75) DEFAULT NULL,
  `anonymous` tinyint(4) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `allowPingbacks` tinyint(4) DEFAULT NULL,
  `answer` tinyint(4) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`messageId`),
  UNIQUE KEY `IX_8D12316E` (`uuid_`,`groupId`),
  KEY `IX_F6687633` (`classNameId`,`classPK`,`status`),
  KEY `IX_1AD93C16` (`companyId`,`status`),
  KEY `IX_4257DB85` (`groupId`,`categoryId`,`status`),
  KEY `IX_CBFDBF0A` (`groupId`,`categoryId`,`threadId`,`answer`),
  KEY `IX_385E123E` (`groupId`,`categoryId`,`threadId`,`status`),
  KEY `IX_ED39AC98` (`groupId`,`status`),
  KEY `IX_377858D2` (`groupId`,`userId`,`status`),
  KEY `IX_9D7C3B23` (`threadId`,`answer`),
  KEY `IX_A7038CD7` (`threadId`,`parentMessageId`),
  KEY `IX_9DC8E57` (`threadId`,`status`),
  KEY `IX_4A4BB4ED` (`userId`,`classNameId`,`classPK`,`status`),
  KEY `IX_3321F142` (`userId`,`classNameId`,`status`),
  KEY `IX_57CA9FEC` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBMessage`
--

INSERT INTO `MBMessage` VALUES ('705e2fde-e4d5-3e6b-87fc-455a8c9a14b7',46874,20142,20115,20155,'Test Test','2022-06-13 18:44:56.461000','2022-06-13 18:44:56.461000',20015,46862,-1,46875,46874,0,'46862','46862','html',0,0,0,0,NULL,0,20155,'Test Test','2022-06-13 18:44:56.461000'),('c9a16009-7b4c-58ae-bc11-f1100c33911e',47001,20142,20115,20155,'Test Test','2022-06-17 16:10:48.383000','2022-06-17 16:10:48.383000',20015,46887,-1,47002,47001,0,'46887','46887','html',0,0,0,0,NULL,0,20155,'Test Test','2022-06-17 16:10:48.383000'),('62d06654-8faa-1f97-0c53-9e7ca75a1329',57226,20142,20115,20155,'Test Test','2023-01-31 14:40:33.762000','2023-01-31 14:40:33.762000',20015,57214,-1,57227,57226,0,'57214','57214','html',0,0,0,0,NULL,0,20155,'Test Test','2023-01-31 14:40:33.762000'),('a6bc12d6-7940-d1f9-0bd0-2cf19113b2ee',57278,20142,20115,20155,'Test Test','2023-01-31 14:51:59.857000','2023-01-31 14:51:59.857000',20015,57262,-1,57279,57278,0,'57262','57262','html',0,0,0,0,NULL,0,20155,'Test Test','2023-01-31 14:51:59.857000'),('9aa17067-ad15-6b76-ec0c-5b941be517ac',57304,20142,20115,20155,'Test Test','2023-01-31 17:14:21.985000','2023-01-31 17:14:21.985000',20015,57291,-1,57305,57304,0,'57291','57291','html',0,0,0,0,NULL,0,20155,'Test Test','2023-01-31 17:14:21.985000');

--
-- Table structure for table `MBStatsUser`
--

CREATE TABLE `MBStatsUser` (
  `statsUserId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `messageCount` int(11) DEFAULT NULL,
  `lastPostDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`statsUserId`),
  UNIQUE KEY `IX_9168E2C9` (`groupId`,`userId`),
  KEY `IX_847F92B5` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBStatsUser`
--


--
-- Table structure for table `MBThread`
--

CREATE TABLE `MBThread` (
  `uuid_` varchar(75) DEFAULT NULL,
  `threadId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `categoryId` bigint(20) DEFAULT NULL,
  `rootMessageId` bigint(20) DEFAULT NULL,
  `rootMessageUserId` bigint(20) DEFAULT NULL,
  `messageCount` int(11) DEFAULT NULL,
  `viewCount` int(11) DEFAULT NULL,
  `lastPostByUserId` bigint(20) DEFAULT NULL,
  `lastPostDate` datetime(6) DEFAULT NULL,
  `priority` double DEFAULT NULL,
  `question` tinyint(4) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `statusByUserId` bigint(20) DEFAULT NULL,
  `statusByUserName` varchar(75) DEFAULT NULL,
  `statusDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`threadId`),
  UNIQUE KEY `IX_3A200B7B` (`uuid_`,`groupId`),
  KEY `IX_41F6DC8A` (`categoryId`,`priority`),
  KEY `IX_50F1904A` (`groupId`,`categoryId`,`lastPostDate`),
  KEY `IX_485F7E98` (`groupId`,`categoryId`,`status`),
  KEY `IX_E1E7142B` (`groupId`,`status`),
  KEY `IX_AEDD9CB5` (`lastPostDate`,`priority`),
  KEY `IX_CC993ECB` (`rootMessageId`),
  KEY `IX_F8CA2AB9` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBThread`
--

INSERT INTO `MBThread` VALUES ('8757f196-34c4-7ecd-8d0e-c0d832a4dc0c',46875,20142,20115,20155,'Test Test','2022-06-13 18:44:56.461000','2022-06-13 18:44:56.461000',-1,46874,20155,1,0,20155,'2022-06-13 18:44:56.461000',0,0,NULL,0,20155,'Test Test','2022-06-13 18:44:56.461000'),('8560c9e9-5942-bc00-7031-a225328af821',47002,20142,20115,20155,'Test Test','2022-06-17 16:10:48.383000','2022-06-17 16:10:48.383000',-1,47001,20155,1,0,20155,'2022-06-17 16:10:48.383000',0,0,NULL,0,20155,'Test Test','2022-06-17 16:10:48.383000'),('a218d5d2-c3b0-a117-5c36-9084bca298dd',57227,20142,20115,20155,'Test Test','2023-01-31 14:40:33.762000','2023-01-31 14:40:33.762000',-1,57226,20155,1,0,20155,'2023-01-31 14:40:33.762000',0,0,NULL,0,20155,'Test Test','2023-01-31 14:40:33.762000'),('36e04080-e8da-9b67-5832-952c520f377a',57279,20142,20115,20155,'Test Test','2023-01-31 14:51:59.857000','2023-01-31 14:51:59.857000',-1,57278,20155,1,0,20155,'2023-01-31 14:51:59.857000',0,0,NULL,0,20155,'Test Test','2023-01-31 14:51:59.857000'),('bfac878a-829b-10db-1345-c53cc28605c3',57305,20142,20115,20155,'Test Test','2023-01-31 17:14:21.985000','2023-01-31 17:14:21.985000',-1,57304,20155,1,0,20155,'2023-01-31 17:14:21.985000',0,0,NULL,0,20155,'Test Test','2023-01-31 17:14:21.985000');

--
-- Table structure for table `MBThreadFlag`
--

CREATE TABLE `MBThreadFlag` (
  `uuid_` varchar(75) DEFAULT NULL,
  `threadFlagId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `threadId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`threadFlagId`),
  UNIQUE KEY `IX_33781904` (`userId`,`threadId`),
  UNIQUE KEY `IX_FEB0FC87` (`uuid_`,`groupId`),
  KEY `IX_8CB0A24A` (`threadId`),
  KEY `IX_DCE308C5` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MBThreadFlag`
--


--
-- Table structure for table `MDRAction`
--

CREATE TABLE `MDRAction` (
  `uuid_` varchar(75) DEFAULT NULL,
  `actionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `ruleGroupInstanceId` bigint(20) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `type_` varchar(255) DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`actionId`),
  UNIQUE KEY `IX_75BE36AD` (`uuid_`,`groupId`),
  KEY `IX_FD90786C` (`ruleGroupInstanceId`),
  KEY `IX_C58A516B` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MDRAction`
--


--
-- Table structure for table `MDRRule`
--

CREATE TABLE `MDRRule` (
  `uuid_` varchar(75) DEFAULT NULL,
  `ruleId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `ruleGroupId` bigint(20) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `type_` varchar(255) DEFAULT NULL,
  `typeSettings` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`ruleId`),
  UNIQUE KEY `IX_F3EFDCB3` (`uuid_`,`groupId`),
  KEY `IX_4F4293F1` (`ruleGroupId`),
  KEY `IX_7DEA8DF1` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MDRRule`
--


--
-- Table structure for table `MDRRuleGroup`
--

CREATE TABLE `MDRRuleGroup` (
  `uuid_` varchar(75) DEFAULT NULL,
  `ruleGroupId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`ruleGroupId`),
  UNIQUE KEY `IX_46665CC4` (`uuid_`,`groupId`),
  KEY `IX_5849891C` (`groupId`),
  KEY `IX_CC14DC2` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MDRRuleGroup`
--


--
-- Table structure for table `MDRRuleGroupInstance`
--

CREATE TABLE `MDRRuleGroupInstance` (
  `uuid_` varchar(75) DEFAULT NULL,
  `ruleGroupInstanceId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `ruleGroupId` bigint(20) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`ruleGroupInstanceId`),
  UNIQUE KEY `IX_808A0036` (`classNameId`,`classPK`,`ruleGroupId`),
  UNIQUE KEY `IX_9CBC6A39` (`uuid_`,`groupId`),
  KEY `IX_22DAB85C` (`groupId`,`classNameId`,`classPK`),
  KEY `IX_BF3E642B` (`ruleGroupId`),
  KEY `IX_25C9D1F7` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MDRRuleGroupInstance`
--


--
-- Table structure for table `Marketplace_App`
--

CREATE TABLE `Marketplace_App` (
  `uuid_` varchar(75) DEFAULT NULL,
  `appId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `remoteAppId` bigint(20) DEFAULT NULL,
  `title` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `category` varchar(75) DEFAULT NULL,
  `iconURL` longtext DEFAULT NULL,
  `version` varchar(75) DEFAULT NULL,
  `required` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`appId`),
  KEY `IX_94A7EF25` (`category`),
  KEY `IX_865B7BD5` (`companyId`),
  KEY `IX_20F14D93` (`remoteAppId`),
  KEY `IX_A7807DA7` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Marketplace_App`
--

INSERT INTO `Marketplace_App` VALUES ('c922a58b-8317-94fb-b9b9-83e8cd766b66',29204,20115,0,NULL,'2023-09-18 13:42:37.010000','2023-09-18 13:42:37.010000',25019275,'Liferay Marketplace','Liferay Marketplace is an integral part of the Liferay platform experience for all users. Enterprise subscribers also have exclusive access to Liferay Subscription Apps through the Liferay Marketplace. Log in with your Liferay account to browse hundreds of apps to help you build your business or technical solution.','Utility','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/90760637','9',1),('e5c058e5-1384-9792-d2dc-f3d7e63280e8',29210,20115,0,NULL,'2023-09-18 13:42:37.199000','2023-09-18 13:42:37.199000',74878779,'Liferay CE Static','The Static app contains an important group of extenders and utilities that Liferay statically installs before installing any dynamic OSGi modules. The app\'s functionality includes a log4j extender, an OSGi WAB extender, configuration utilities, OSGi deployment utilities, target platform indexing, and more.This suite is available in the Liferay CE bundle.','Utility','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/105345616','7.0.12',1),('0e760129-1231-914a-4239-e59b79801c50',29252,20115,0,NULL,'2023-09-18 13:42:36.747000','2023-09-18 13:42:36.747000',71924329,'Liferay CE Forms and Workflow','Apps and Features: Calendar, Dynamic Data Lists, Dynamic Data Mapping, Forms, Polls, WorkflowAn increase in productivity means you\'re saving time and effort; youâre becoming more efficient. The Forms and Workflow apps help you do that by giving you built-in calendars and the ability to create your own forms and list applications. These are powerful, flexible apps that can be quickly leveraged for basic tasks, or carefully configured and mastered to perfect business processes.Need a quick survey or complex Sign Up form? Use the Liferay Forms app and make any forms you want. If there\'s a forms feature you need, this app probably has it.Maybe you need an entire list application, and you need it today. Dynamic Data Lists lets you do it without any developer expertise.Do you need personal calendars for your users, and/or site calendars? Do you need the calendar to be highly configurable? Use the Calendar app.Would you like to initiate a review process when new content, or any new asset, is created? The Kaleo Workflow Engine lets you send any asset through review before it gets published.Want to quickly get the opinion of your users on something? The Polls app is extremely easy to use.This suite may contain modules that depend on Foundation suite modules. This suite is available in the Liferay CE bundle.','Productivity','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/105345925','7.0.9',1),('b3888e92-82a6-68e3-3763-9c34457ce0a8',29308,20115,0,NULL,'2023-09-18 13:42:37.190000','2023-09-18 13:42:37.190000',15197657,'Liferay CE IP Geocoder','The IP Geocoder app uses Max Mind\'s GeoIP City Database to locate your geological position, often in conjunction with other apps like the Google Maps app. IP geolocation can be performed by associating a geographic location with the user\'s Internet Protocol (IP) address. Geolocation usually works by automatically looking up an IP address on a WHOIS service and retrieving the registrant\'s geographic location.This app will appear in your Applications menu once installed.','Utility','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/92609668','3.0.1',0),('d5852c95-780a-1957-d4b3-604197f2be3c',29313,20115,0,NULL,'2023-09-18 13:42:37.263000','2023-09-18 13:42:37.263000',71924489,'Liferay CE Foundation','Apps and Features: System Settings, Web Content Editors, Web Content Template Languages, Theme Tools, Mobile Device Rules, Facebook Authentication, LDAP Authentication, NTLM Authentication, OpenID Authentication, OpenSSO Authentication, Remote Authentication (AuthVerifiers), SSO-based Authentication, Token-based Authentication, Portal Scripting, Elasticsearch Support, Solr Support, Documents and Media Store Implementations, and more.The Foundation suite provides applications and features that extend the functionality provided by Liferay\'s core. Much of the functionality that belonged to Liferay\'s core prior to Liferay 7 has been extracted into the modules of the Foundation suite. The authentication modules provide a variety of mechanisms for allowing users and remote applications to authenticate to Liferay. The LDAP Authentication module allows administrators to establish connections to one or more LDAP directories from which users can be imported or exported. The SSO modules allow users to authenticate to Liferay using a variety of single-sign on solutions. The Token-based Authentication module allows users or remote applications to authenticate to Liferay without a password. The Scripting modules allow scripts to be written to invoke Liferay\'s API in several languages including Groovy, Beanshell, Python, Ruby, and JavaScript.This suite is available in the Liferay CE bundle.','Utility','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/105346128','7.0.10',1),('be3dd0c7-59a2-7a63-fd2b-013f809f3ac7',29521,20115,0,NULL,'2023-09-18 13:42:37.576000','2023-09-18 13:42:37.576000',31071510,'Liferay CE Sync Connector','The Sync Connector app lets users connect to their portals from the Liferay Sync desktop and mobile clients. It also lets administrators control how these clients interact with their portal. Once installed, the Sync Connector app provides the portal services required by the clients. No additional portal configuration is required. However, portal administrators can use the Sync Admin portlet installed with this app to control what sites are available for Sync. They can also use this portlet to disable Sync across the portal.After installing, the Sync Admin portlet is available in the Control Panelâs Configuration section.Please visit http://www.liferay.com/products/liferay-sync/features for more information on downloading the Liferay Sync desktop and mobile clients. Liferay Sync is compatible with Windows, Mac OS, iOS, and Android. The Sync Connector app requires version 3.0+ of the Sync desktop or mobile client and the IP Geocoder app.','Productivity','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/91377172','4.1.1',0),('53963c0d-cb6c-ec05-6d79-a65292d67192',29526,20115,0,NULL,'2023-09-18 13:42:37.586000','2023-09-18 13:42:37.586000',71924854,'Liferay CE Web Experience','Apps and Features: Application Display Templates, Asset Publisher, Breadcrumb, Categories, Google Analytics, IFrame, Language, Navigation, Recycle Bin, Related Content, RSS, Search, Site and Page Templates, Sitemap, Sites Directory, Tags, Web Content, XSL ContentThe Web Experience suite provides features that help create, manage, and track content. The Web Content app lets you express your ideas and plans by creating dynamic content that can be structured to fit a specific design. You can also use templates to design web content for an appealing look and feel. Templates can be used in other realms of Liferay besides web content too. Site and Page Templates let you reproduce sites and pages that have been organized to address specific needs. Application Display Templates are another type of Liferay template that lets you develop the look and feel of applications. The IFrame and XSL Content apps let you create other forms of content by embedding HTML and XSL content on a site page.As administrators create content, organization is critical to keeping things tidy in your site. The suite\'s Tags and Categories apps lets you organize your web content to follow an organizational hierarchy. These organizational apps also aid with Liferay\'s Search app, which you can utilize to dynamically search content you\'ve created. The suite\'s Navigation, Breadcrumb, Sitemap, and Sites Directory apps aid in Liferay\'s organizational structure, providing a top level view of sites and their pages that have been created. To promote content in an organized way, the Asset Publisher and Related Assets apps broadcast assets and their related information. Inevitably, some content you create becomes stale and requires removal; the Recycle Bin app lets you delete content, with the option to restore that content.As a site accumulates content, administrators should have a way to easily track their content. The Google Analytics app allows the use of Google\'s tool set for analyzing site traffic data. The suite\'s RSS app provides a web feed used to publish updated works such as blog entries and news articles. The suite\'s Language app provides a way to change Liferay\'s language to cater to your site\'s international audience. This suite\'s content creation and organization focus lets site administrators develop dynamic content, organize content for easy managing, and track content for ideas to better improve the content creation process in the future.This suite may contain modules that depend on Foundation suite modules. This suite is available in the Liferay CE bundle.','Productivity','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/105346253','7.0.9',1),('c32703a6-8fdc-d23a-659e-9b3e7143cfa3',29648,20115,0,NULL,'2023-09-18 13:42:37.022000','2023-09-18 13:42:37.022000',71921962,'Liferay CE Collaboration','The Liferay Collaboration suite provides applications and features that help users share ideas, implement them, and produce terrific results. Its apps such as Message Boards and Blogs help users start discussions, ask questions, share ideas, and connect with other users. Wiki allows users to share in-depth information. And Alerts and Announcements facilitate broadcasting information and notifications.As users collaborate, they\'re sure to produce important files. The suite\'s Documents and Media Library allows users to store files, share them, and publish them. It not only works with Liferay\'s built-in repository but also allows you to integrate with external repositories, such CMIS repositories. Users can add and share all kinds of files, including documents, presentations, images, and videos. And the suite\'s Documents and Media app and Media Gallery help users display files the way they like them.As users engage in site activities, you\'ll want to recognize them and connect them with other users. The suite\'s social networking apps and features enable you to attribute social equity to active users automatically by increasing their rank on the site. You can even highlight user activities to show your site\'s liveliness. The Mentions feature facilitates notifying specific users in the context of site content, discussions, and comments. The social apps also help users share their thoughts on the your sites and other social sites, such as Facebook and Twitter. Combined with the suite\'s collaboration and document management features, the Collaboration suiteâs social features help develop awesome communities, foster high morale, and make work interesting.Apps and Features: Activities, Alerts, Announcements, Blogs, Bookmarks, Comments, Friends/My Sites/Portal/Site Members Directory, Documents and Media, Friend Requests, Image Uploader, Invite Members, Media Gallery, Message Boards, Mentions, Microblogs, Page Flags/Comments/Ratings, Quick Note, Requests, Social Activity, User/Group Statistics, Wiki.This suite may contain modules that depend on Foundation suite modules. This suite is available in the Liferay CE bundle.','Communication','https://web.liferay.com/web/guest/marketplace/-/mp/asset/icon/105345786','7.0.8',1);

--
-- Table structure for table `Marketplace_Module`
--

CREATE TABLE `Marketplace_Module` (
  `uuid_` varchar(75) DEFAULT NULL,
  `moduleId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `appId` bigint(20) DEFAULT NULL,
  `bundleSymbolicName` varchar(500) DEFAULT NULL,
  `bundleVersion` varchar(75) DEFAULT NULL,
  `contextName` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`moduleId`),
  KEY `IX_5848F52D` (`appId`,`bundleSymbolicName`(255),`bundleVersion`),
  KEY `IX_C6938724` (`appId`,`contextName`),
  KEY `IX_DD03D499` (`bundleSymbolicName`(255)),
  KEY `IX_F2F1E964` (`contextName`),
  KEY `IX_896A375A` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Marketplace_Module`
--

INSERT INTO `Marketplace_Module` VALUES ('b9e650ae-ed0a-e54f-a9db-a1e31cdfea7b',63301,20115,29252,'com.liferay.calendar.api','2.3.1',NULL),('d6d85369-822a-12af-515c-432b19e94562',63302,20115,29252,'com.liferay.calendar.service','2.7.0',NULL),('b7163d00-e309-4bef-ab3b-593edf11a5fe',63303,20115,29252,'com.liferay.calendar.web','1.0.51','calendar-web'),('0ee09b9f-e9f3-9ad6-325f-2fb0373e32d6',63304,20115,29252,'com.liferay.dynamic.data.lists.api','2.1.8',NULL),('d17b5361-d4fa-5e33-9222-bdfa82ef34e9',63305,20115,29252,'com.liferay.dynamic.data.lists.form.web','2.0.11','dynamic-data-lists-form-web'),('cb2cb7b2-634d-922f-08ce-7cd63e4c4c34',63306,20115,29252,'com.liferay.dynamic.data.lists.service','1.1.46',NULL),('b0d2299f-8229-64c5-0061-af174c01bf5d',63307,20115,29252,'com.liferay.dynamic.data.lists.web','2.0.8','dynamic-data-lists-web'),('f5fd9883-fa9c-576c-82ef-c974ef8d7f0a',63308,20115,29252,'com.liferay.dynamic.data.mapping.api','3.8.0',NULL),('c650f237-ca66-75ab-ed22-453815c6883f',63309,20115,29252,'com.liferay.dynamic.data.mapping.data.provider','2.0.3',NULL),('d4dc15a3-fce2-a24f-5bb6-4658c32ffbcf',63310,20115,29252,'com.liferay.dynamic.data.mapping.data.provider.impl','1.0.6',NULL),('bdb7fbc8-354f-d91f-6b6a-ddae030b07e9',63311,20115,29252,'com.liferay.dynamic.data.mapping.data.provider.web','1.0.13','dynamic-data-mapping-data-provider-web'),('6ad32da4-f61c-8817-2311-ed423a99be6f',63312,20115,29252,'com.liferay.dynamic.data.mapping.expression','2.0.8',NULL),('43bb0990-c571-baa1-72ee-eb21669f8bc4',63313,20115,29252,'com.liferay.dynamic.data.mapping.form.evaluator','2.0.4',NULL),('cd216324-120f-857c-55ae-0eb53d6175d7',63314,20115,29252,'com.liferay.dynamic.data.mapping.form.field.type','2.0.10',NULL),('f7c50e67-44a7-2c1b-be98-e9dac0c08334',63315,20115,29252,'com.liferay.dynamic.data.mapping.form.renderer','2.1.15','dynamic-data-mapping-form-renderer'),('f8d17a99-79d7-3edb-4859-0e76848d0bd7',63316,20115,29252,'com.liferay.dynamic.data.mapping.form.values.factory','2.0.9',NULL),('392735e4-d44b-1be4-378a-df54521a4792',63317,20115,29252,'com.liferay.dynamic.data.mapping.form.values.query','2.0.12',NULL),('361b6cb3-3f16-09ae-af11-c8bb262e3868',63318,20115,29252,'com.liferay.dynamic.data.mapping.io','2.0.14',NULL),('d621eff9-1572-6404-354b-4b05448e8a73',63319,20115,29252,'com.liferay.dynamic.data.mapping.lang','2.0.7',NULL),('a9062bb0-89a0-a285-3c4f-e005e2ee9fd5',63320,20115,29252,'com.liferay.dynamic.data.mapping.service','2.5.0',NULL),('f33dcc09-e595-6414-21a4-9f72cf5ec700',63321,20115,29252,'com.liferay.dynamic.data.mapping.taglib','2.1.10','dynamic-data-mapping-taglib'),('f524bd73-a5cc-02a8-1700-bd48b36bc628',63322,20115,29252,'com.liferay.dynamic.data.mapping.type.captcha','2.0.7','dynamic-data-mapping-type-captcha'),('fbf65bae-7442-409d-cd3e-7695b5b6e753',63323,20115,29252,'com.liferay.dynamic.data.mapping.type.checkbox','2.0.13','dynamic-data-mapping-type-checkbox'),('316279ad-3af9-61ac-7a04-b997855be5a3',63324,20115,29252,'com.liferay.dynamic.data.mapping.type.checkbox.multiple','1.0.6','dynamic-data-mapping-type-checkbox-multiple'),('a154adbd-fb45-8968-7a58-14de51f24d12',63325,20115,29252,'com.liferay.dynamic.data.mapping.type.date','2.0.10','dynamic-data-mapping-type-date'),('38c97458-0c99-4a65-e011-328c851f2523',63326,20115,29252,'com.liferay.dynamic.data.mapping.type.editor','2.0.8','dynamic-data-mapping-type-editor'),('b3751c60-7dfd-04e7-55fe-6e36dccfdc4e',63327,20115,29252,'com.liferay.dynamic.data.mapping.type.key.value','2.0.5','dynamic-data-mapping-type-key-value'),('0c3bea8c-8e3e-3621-96e4-f41ae1fa7b43',63328,20115,29252,'com.liferay.dynamic.data.mapping.type.options','2.0.11','dynamic-data-mapping-type-options'),('d9b33b51-61cf-2422-6b06-e20bf64be11d',63329,20115,29252,'com.liferay.dynamic.data.mapping.type.paragraph','2.0.10','dynamic-data-mapping-type-paragraph'),('0fae2d41-cb08-52ef-37bf-d4a27798e119',63330,20115,29252,'com.liferay.dynamic.data.mapping.type.password','1.0.3','dynamic-data-mapping-type-password'),('d42ec7de-51a3-ac6f-400e-dd9f5e4fcfe1',63331,20115,29252,'com.liferay.dynamic.data.mapping.type.radio','2.0.16','dynamic-data-mapping-type-radio'),('4d6b8d3f-8d0a-1ca0-b4e2-524ee70cd70d',63332,20115,29252,'com.liferay.dynamic.data.mapping.type.select','2.0.15','dynamic-data-mapping-type-select'),('0db964e7-0ef0-1691-155f-a6598e077cb7',63333,20115,29252,'com.liferay.dynamic.data.mapping.type.text','2.0.11','dynamic-data-mapping-type-text'),('48f1d9b5-38fe-7fd2-815c-a5d34498267e',63334,20115,29252,'com.liferay.dynamic.data.mapping.type.validation','2.0.7','dynamic-data-mapping-type-validation'),('85ff68e0-a19a-abc1-2f4a-8b26d7ad6e91',63335,20115,29252,'com.liferay.dynamic.data.mapping.validator','2.1.7',NULL),('a13afa82-80c3-e3ac-f2df-748ea9524023',63336,20115,29252,'com.liferay.dynamic.data.mapping.web','1.0.56','dynamic-data-mapping-web'),('cd6b360d-384a-7f96-5a87-79338aff7fbb',63337,20115,29252,'com.liferay.polls.api','4.0.2',NULL),('95bd2fee-0c36-9431-4a3c-5732b649f492',63338,20115,29252,'com.liferay.polls.service','3.0.24',NULL),('7e84e853-21d0-cede-4eec-24a99f30cb70',63339,20115,29252,'com.liferay.polls.web','2.0.22','polls-web'),('e0bdb589-ae45-0a7c-700b-ff076e220d70',63340,20115,29252,'com.liferay.portal.reports.engine.api','3.0.1',NULL),('f7c67b08-abc8-a09e-2acb-bb5318c45f45',63341,20115,29252,'com.liferay.portal.rules.engine.api','2.0.5',NULL),('307e4a1c-62d2-131d-c50d-9a01bf11070c',63342,20115,29252,'com.liferay.portal.rules.engine.wiring','2.0.3',NULL),('d52e0976-2001-7c5e-a461-9ffe41571057',63343,20115,29252,'com.liferay.portal.workflow.definition.link.web','1.0.9',NULL),('ea70f4fa-b6b8-1320-af9b-6e01dd05aa38',63344,20115,29252,'com.liferay.portal.workflow.definition.web','1.0.11','portal-workflow-definition-web'),('baf66d74-049f-0222-1769-aa15fb407a78',63345,20115,29252,'com.liferay.portal.workflow.instance.web','1.0.10',NULL),('53aa2e74-a451-1d26-be34-c20297594816',63346,20115,29252,'com.liferay.portal.workflow.kaleo.api','2.2.1',NULL),('938836e8-0dc7-1f41-02e0-d5693d06bb8a',63347,20115,29252,'com.liferay.portal.workflow.kaleo.definition.api','2.1.0',NULL),('04c9f736-7c67-a53d-6bc8-543dbbe5d449',63348,20115,29252,'com.liferay.portal.workflow.kaleo.definition.impl','2.0.11',NULL),('4fb866d3-6a50-299c-0f6b-46884e1509e0',63349,20115,29252,'com.liferay.portal.workflow.kaleo.runtime.api','2.2.3',NULL),('c0e772c4-6903-b7c7-e194-17e0c571bff5',63350,20115,29252,'com.liferay.portal.workflow.kaleo.runtime.impl','2.0.20',NULL),('abb66fcd-ccc7-7d87-6301-d65f9ea2ee5b',63351,20115,29252,'com.liferay.portal.workflow.kaleo.runtime.integration.impl','1.0.14',NULL),('25ce4fec-469d-e0cd-7734-dc9b6cdb4c85',63352,20115,29252,'com.liferay.portal.workflow.kaleo.runtime.scripting.impl','1.0.5',NULL),('3156de19-84cb-88cc-6c56-739cc1e206a5',63353,20115,29252,'com.liferay.portal.workflow.kaleo.service','2.0.34',NULL),('939bf629-e9f9-4e40-640a-58fd6163118e',63354,20115,29252,'com.liferay.portal.workflow.lang','2.0.7',NULL),('fa3a7ffc-5280-ed09-e84a-a4a7321b536c',63355,20115,29252,'com.liferay.portal.workflow.task.web','1.0.29','portal-workflow-task-web'),('143da9a9-94a0-1bc4-e6dd-3f75859d9ca1',63356,20115,29204,'com.liferay.marketplace.api','4.2.0',NULL),('73247284-c79f-4ba6-b425-8c1804288353',63357,20115,29204,'com.liferay.marketplace.app.manager.web','1.0.17','marketplace-app-manager-web'),('d7fbb824-c9e5-1324-3fdd-eba0ce215c66',63358,20115,29204,'com.liferay.marketplace.deployer','2.0.9',NULL),('0b8fe018-39cb-1268-f731-b71fb5b57ea9',63359,20115,29204,'com.liferay.marketplace.service','2.1.28',NULL),('76337562-2fcf-92ba-f364-01d054a9ae49',63360,20115,29204,'com.liferay.marketplace.store.web','2.0.11','marketplace-store-web'),('97b4a815-b0c4-20b4-adec-c024fc88180b',63361,20115,29648,'com.liferay.announcements.api','1.0.1',NULL),('142f6aae-9fc8-e618-5f0f-ab94c73b8518',63362,20115,29648,'com.liferay.announcements.web','2.0.7','announcements-web'),('10a66595-12e0-42f6-35c5-813f6007b489',63363,20115,29648,'com.liferay.blogs.api','3.1.0',NULL),('91cdf33b-8b4c-358d-7b8e-188f60fb1e30',63364,20115,29648,'com.liferay.blogs.editor.configuration','1.0.10',NULL),('f820e31b-1e03-ed42-f66b-b6fbeb1a2e7a',63365,20115,29648,'com.liferay.blogs.item.selector.api','1.1.0',NULL),('48876339-835d-4b9a-9ca6-25b562482f52',63366,20115,29648,'com.liferay.blogs.item.selector.web','2.0.0','blogs-item-selector-web'),('9aa1c709-b3df-e4ba-8d73-aa8c142b153a',63367,20115,29648,'com.liferay.blogs.layout.prototype','2.0.13',NULL),('f7b2438c-6121-c271-12ef-044a618b0bc3',63368,20115,29648,'com.liferay.blogs.recent.bloggers.api','1.0.1',NULL),('f2023d55-a000-ced8-73af-0402fe02d240',63369,20115,29648,'com.liferay.blogs.recent.bloggers.web','2.0.0','blogs-recent-bloggers-web'),('2d995145-18a5-652b-3631-c68d84d3202f',63370,20115,29648,'com.liferay.blogs.service','1.1.11',NULL),('de13dd75-79b7-73bf-6c70-664ff1bee6ee',63371,20115,29648,'com.liferay.blogs.web','2.0.3','blogs-web'),('08dffb94-df15-7622-cdcb-026ab955f455',63372,20115,29648,'com.liferay.bookmarks.api','2.0.11',NULL),('c9ba7f05-e9e7-f009-4fe1-569ae6d0764d',63373,20115,29648,'com.liferay.bookmarks.service','1.1.24',NULL),('716698a9-7bf1-27c0-cfcb-895718c25a08',63374,20115,29648,'com.liferay.bookmarks.web','1.0.34','bookmarks-web'),('3895133f-4e08-c62b-088b-5799dddc8a44',63375,20115,29648,'com.liferay.comment.api','2.0.1',NULL),('6809ec97-adda-3ee3-f9df-52c4b9e6f380',63376,20115,29648,'com.liferay.comment.editor.configuration','1.0.2',NULL),('2068b6a4-ab80-419a-9f64-8e44c31b5a57',63377,20115,29648,'com.liferay.comment.page.comments.web','1.0.11',NULL),('5ac0e91b-c70b-4cf2-5d25-d6f899934167',63378,20115,29648,'com.liferay.comment.ratings.definition','2.0.2',NULL),('4f80280f-0d9b-f366-1e8a-3e37f88a36b5',63379,20115,29648,'com.liferay.comment.sanitizer','2.0.5',NULL),('f03dbe8a-a096-4d62-e0db-4fe032fc5085',63380,20115,29648,'com.liferay.comment.web','2.0.4','comment-web'),('1a3126f3-8ef9-de6c-33be-82e4a4fa298d',63381,20115,29648,'com.liferay.directory.web','1.0.21',NULL),('98c990ea-34e7-f9f4-2ceb-71ed671fb336',63382,20115,29648,'com.liferay.document.library.api','3.4.0',NULL),('5116587c-33cf-069e-5b47-619d0535d83f',63383,20115,29648,'com.liferay.document.library.item.selector.web','1.0.9','document-library-item-selector-web'),('9bb69c12-de3a-ed7e-b4d0-d3eb9a951198',63384,20115,29648,'com.liferay.document.library.layout.set.prototype','2.0.13',NULL),('56a9a030-c3e3-20f1-4f8d-7e799262584c',63385,20115,29648,'com.liferay.document.library.repository.authorization.api','1.0.2',NULL),('67615f1b-89eb-f327-0318-7adf15cd27df',63386,20115,29648,'com.liferay.document.library.repository.cmis.api','1.1.11',NULL),('f950b22a-2374-18e2-6672-8f58ee9f9bde',63387,20115,29648,'com.liferay.document.library.repository.cmis.impl','2.0.27',NULL),('29a30e8d-a00d-f12c-d88c-6f0316f50ed9',63388,20115,29648,'com.liferay.document.library.repository.external.api','1.0.2',NULL),('e4624fe0-c2df-a740-d97e-449653893b4b',63389,20115,29648,'com.liferay.document.library.repository.search','3.0.2',NULL),('3a6adc90-ec29-7d9d-1bc6-6be96b80438d',63390,20115,29648,'com.liferay.document.library.service','2.0.6',NULL),('ea6140dc-0117-7549-fecd-dc62a6a26729',63391,20115,29648,'com.liferay.document.library.web','2.0.5','document-library-web'),('935bfd3c-9e77-feae-d51e-6e4c6c307abf',63392,20115,29648,'com.liferay.flags.api','2.0.9',NULL),('e80a9100-c5e7-1318-24b6-ba07483d6319',63393,20115,29648,'com.liferay.flags.service','2.0.12',NULL),('f49a7acf-fb3e-0052-3813-2b4968d71596',63394,20115,29648,'com.liferay.flags.taglib','2.0.10','flags-taglib'),('e02c1620-df09-9f43-e641-4b2920ae488f',63395,20115,29648,'com.liferay.flags.web','2.0.13','flags-web'),('b8ecca54-d1af-dc54-dd8f-aa30bc21cf7a',63396,20115,29648,'com.liferay.image.uploader.web','1.0.17',NULL),('df387834-1d65-df4d-8580-3679e6ecac96',63397,20115,29648,'com.liferay.invitation.invite.members.api','2.1.3',NULL),('f33ba96c-5862-8c41-55c9-f6394c3fa537',63398,20115,29648,'com.liferay.invitation.invite.members.service','3.0.4',NULL),('2948e5cd-d3f5-a9ec-3903-f4b72fc43e98',63399,20115,29648,'com.liferay.invitation.invite.members.web','1.0.28','invitation-invite-members-web'),('a3def470-2b19-e362-7951-feda63751633',63400,20115,29648,'com.liferay.item.selector.api','2.4.2',NULL),('666ab828-40a5-19da-24e0-76993e4354a7',63401,20115,29648,'com.liferay.item.selector.criteria.api','2.1.1',NULL),('e32fc3ac-9c62-c754-0cec-5e19644de4a4',63402,20115,29648,'com.liferay.item.selector.editor.configuration','2.0.4',NULL),('148db475-6f82-be27-0655-345cf4edf46b',63403,20115,29648,'com.liferay.item.selector.taglib','1.1.15','item-selector-taglib'),('8e1f2807-addb-17ac-92c1-201c5a7fa8b7',63404,20115,29648,'com.liferay.item.selector.upload.web','2.0.8','item-selector-upload-web'),('dee805b1-ad78-481b-0ff8-71892f540f22',63405,20115,29648,'com.liferay.item.selector.url.web','2.0.8','item-selector-url-web'),('9e9fe358-dfc4-7277-e8e8-91d4160fa661',63406,20115,29648,'com.liferay.item.selector.web','3.0.6',NULL),('bf505cbb-0522-9a51-dc7d-a5adfbe376ee',63407,20115,29648,'com.liferay.mentions.api','2.2.1',NULL),('de5a949b-5dd7-3d0d-6d03-e87b661a31b3',63408,20115,29648,'com.liferay.mentions.service','2.0.16',NULL),('c6d36d7b-604d-72a2-7cb4-8f3cd3b8fcc0',63409,20115,29648,'com.liferay.mentions.web','2.0.3','mentions-web'),('85595718-3462-1419-f587-c3447c44d163',63410,20115,29648,'com.liferay.message.boards.api','3.1.7',NULL),('b3e4db00-0732-3067-443f-2a9fec31860a',63411,20115,29648,'com.liferay.message.boards.comment','2.0.18',NULL),('c497320c-7196-6f0d-7145-e549df7237ac',63412,20115,29648,'com.liferay.message.boards.editor.configuration','1.0.2',NULL),('9874ba72-168b-dfbb-acc4-bf3bf8509a87',63413,20115,29648,'com.liferay.message.boards.layout.set.prototype','1.0.14',NULL),('7c875afa-a6f7-45f2-4e0a-fd19f5a1e703',63414,20115,29648,'com.liferay.message.boards.parser.bbcode','2.0.12',NULL),('d275dcc8-ef73-a36b-9c7f-24bbb0720edc',63415,20115,29648,'com.liferay.message.boards.service','1.0.16',NULL),('e1de8d1b-cae7-b758-1789-f49419bff6ae',63416,20115,29648,'com.liferay.message.boards.web','1.2.39','message-boards-web'),('b35130c2-13db-252a-956f-5e8f8863d736',63417,20115,29648,'com.liferay.microblogs.api','2.1.3',NULL),('21564293-fd14-76ea-18a6-0ada42a92dc8',63418,20115,29648,'com.liferay.microblogs.service','2.1.15',NULL),('59184563-03d7-9771-d660-dfd68e40debf',63419,20115,29648,'com.liferay.microblogs.web','2.0.25','microblogs-web'),('97ffb2c6-1a2f-e92e-c7c9-efc54663d31e',63420,20115,29648,'com.liferay.notifications.web','1.0.30','notifications-web'),('ff1d74f7-5bae-aee5-1674-9073b44d48f4',63421,20115,29648,'com.liferay.quick.note.web','2.0.5',NULL),('7179cf25-aa93-b9f7-3850-64ee1596ac01',63422,20115,29648,'com.liferay.ratings.api','2.0.1',NULL),('05d2a565-c64d-d617-38ea-b759d37f1e13',63423,20115,29648,'com.liferay.ratings.page.ratings.web','2.0.9',NULL),('4da0a61b-0fab-877b-5572-91e67b97050c',63424,20115,29648,'com.liferay.ratings.service','1.0.10',NULL),('7786079d-b4be-19dc-0d35-8eb2d3ef9267',63425,20115,29648,'com.liferay.recent.documents.web','2.0.15',NULL),('9af38e6f-e895-efef-7ded-667115a5fb58',63426,20115,29648,'com.liferay.social.activities.api','1.0.1',NULL),('8748d2b6-9fc6-f3a5-5a22-b82d2df438cc',63427,20115,29648,'com.liferay.social.activities.web','2.0.7','social-activities-web'),('f41e88c2-4ee3-67d1-74fa-ae5428e1eed0',63428,20115,29648,'com.liferay.social.activity.api','1.0.6',NULL),('553c3cf3-930b-c899-4185-bff8fc146fab',63429,20115,29648,'com.liferay.social.activity.web','2.0.11','social-activity-web'),('f4bbaad7-e11c-05b3-86a5-a44cf3304f5f',63430,20115,29648,'com.liferay.social.group.statistics.web','2.0.13','social-group-statistics-web'),('bd34b7a5-b6b6-b8ea-4126-1d0fc3d2423b',63431,20115,29648,'com.liferay.social.requests.web','1.0.7',NULL),('35446bc9-9612-d9ba-f64a-98170d7636ae',63432,20115,29648,'com.liferay.social.user.statistics.api','1.0.1',NULL),('1e7b706c-abc2-e4ef-0335-683e2e14de31',63433,20115,29648,'com.liferay.social.user.statistics.web','3.0.3','social-user-statistics-web'),('53f5a48c-27c7-88b9-e5e4-d827a7b35f62',63434,20115,29648,'com.liferay.upload.api','1.0.1',NULL),('5628e386-094d-ca03-222d-9ae73321eac7',63435,20115,29648,'com.liferay.upload.web','1.0.6',NULL),('a1fff7b3-0956-259f-043f-ec8b1413eb27',63436,20115,29648,'com.liferay.wiki.api','2.5.3',NULL),('d0cdac4f-8c93-8e7d-5614-d2587eeaace4',63437,20115,29648,'com.liferay.wiki.editor.configuration','1.0.9',NULL),('c1502f9f-1808-a84f-f650-a4c9079747ec',63438,20115,29648,'com.liferay.wiki.engine.creole','2.0.16','wiki-engine-creole'),('7fd3bd33-52ff-33f0-565f-aac1ae1e6b36',63439,20115,29648,'com.liferay.wiki.engine.html','2.0.6','wiki-engine-html'),('172e2140-3f62-f985-c811-d64f1a344c12',63440,20115,29648,'com.liferay.wiki.engine.input.editor.common','3.0.1','wiki-engine-input-editor-common'),('bbcae375-4cbe-af81-8416-b7f5978b80e4',63441,20115,29648,'com.liferay.wiki.engine.lang','1.0.4',NULL),('cd5cf078-6fa1-1919-2519-8e50addbe602',63442,20115,29648,'com.liferay.wiki.engine.text','2.0.6','wiki-engine-text'),('4f4a12ff-e2bd-2bbd-cf8c-4e27323d9e82',63443,20115,29648,'com.liferay.wiki.layout.prototype','1.0.16',NULL),('dd6c6478-9da4-47a8-3e4a-a8fe9902d877',63444,20115,29648,'com.liferay.wiki.navigation.web','2.0.13','wiki-navigation-web'),('c280b0eb-503a-3330-f28d-fdc05c58d719',63445,20115,29648,'com.liferay.wiki.service','1.6.21',NULL),('a4d1b96d-4ee8-d385-339b-10c22e65d9fb',63446,20115,29648,'com.liferay.wiki.web','3.0.10','wiki-web'),('66c7860a-dc54-5ffa-9453-f9b19614cbb4',63447,20115,29308,'com.liferay.ip.geocoder','2.0.9',NULL),('d2e30a31-9a33-756b-172d-15d4e37984f4',63448,20115,29308,'com.liferay.ip.geocoder.sample.web','2.0.5','ip-geocoder-sample-web'),('446a2ce7-4702-fe97-1960-48549185f14f',63449,20115,29308,'com.maxmind.geoip.api','1.2.14',NULL),('810fd991-786b-5d3a-7a78-cb645bc01d8c',63450,20115,29308,'org.tukaani.xz','1.5.0',NULL),('5faa1976-a62f-27b1-27d1-956a87411d08',63451,20115,29210,'com.liferay.modules.compat','2.0.7',NULL),('4106d7b8-2aa9-cf47-0a01-609fea0998a0',63452,20115,29210,'com.liferay.osgi.felix.file.install.configuration.cleaner','1.0.3',NULL),('99a45ecc-75c6-73a2-9c2e-bed4ebb12f38',63453,20115,29210,'com.liferay.osgi.util','3.2.0',NULL),('69e8579d-48aa-3874-c77d-6dc1c4f88272',63454,20115,29210,'com.liferay.portal.bundle.blacklist','1.1.4',NULL),('dca9927e-ab2e-5ebc-6596-7bc3811e6018',63455,20115,29210,'com.liferay.portal.classloader.tracker','1.0.2',NULL),('22b1a7a8-b6bf-87c6-9abe-9bbd6c907754',63456,20115,29210,'com.liferay.portal.component.blacklist.api','1.0.1',NULL),('54606935-2912-9096-15bb-5fd53898892e',63457,20115,29210,'com.liferay.portal.component.blacklist.impl','1.0.2',NULL),('bf043919-73a9-adfd-8fab-e979f9681532',63458,20115,29210,'com.liferay.portal.configuration.metatype','2.0.11',NULL),('0ffc2c33-b12b-6087-e6f8-db0aa46f69e0',63459,20115,29210,'com.liferay.portal.configuration.persistence','2.1.1',NULL),('116f456a-767d-952a-3275-02c84cd2e745',63460,20115,29210,'com.liferay.portal.log4j.extender','2.0.5',NULL),('1af1bafd-53c0-c7ed-aed0-bd73ec078f6a',63461,20115,29210,'com.liferay.portal.lpkg.deployer','2.1.6',NULL),('39ac4063-bbdf-6740-aa33-f2695f8f9e77',63462,20115,29210,'com.liferay.portal.osgi.web.portlet.tracker','2.0.13',NULL),('f45f0574-7e79-bc3e-7a49-359839a61688',63463,20115,29210,'com.liferay.portal.osgi.web.servlet.context.helper','2.1.15',NULL),('766bffc9-4bba-3d41-d072-3ebd91cb0f2b',63464,20115,29210,'com.liferay.portal.osgi.web.servlet.jsp.compiler','2.0.28',NULL),('81d004b3-2d74-d2c2-bf9d-841e75cfc9cb',63465,20115,29210,'com.liferay.portal.osgi.web.wab.extender','2.0.27',NULL),('31179551-8d0a-f312-7e26-9ceb96384c49',63466,20115,29210,'com.liferay.portal.osgi.web.wab.generator','2.1.43',NULL),('5662d3d3-5b43-4388-bd53-d06c57ff4728',63467,20115,29210,'com.liferay.portal.osgi.web.wab.reference.support','1.0.7',NULL),('6664c791-e315-e88d-12bd-9d3095b7b4be',63468,20115,29210,'com.liferay.portal.profile.api','1.0.1',NULL),('b89e6ba0-0a1e-d77d-abb1-1e723d604dcf',63469,20115,29210,'com.liferay.portal.profile.impl','1.0.2',NULL),('ea3fde0e-250e-7da9-1f99-ddf1ca7bb5f7',63470,20115,29210,'com.liferay.portal.target.platform.indexer','4.0.5',NULL),('666c42b8-6501-8709-e81a-e56d1d2939da',63471,20115,29210,'com.sun.el.javax.el','3.0.0',NULL),('bcdd3813-5c81-b296-fbdd-fd8fa2b56fac',63472,20115,29210,'javax.servlet.jsp-api','2.3.2.b01',NULL),('7e2b653b-0a73-3735-7399-b5b1c5da5b20',63473,20115,29210,'javax.servlet.jsp.jstl','1.2.3.LIFERAY-PATCHED-2',NULL),('eba7955c-b0b6-0f41-4529-7812ca460861',63474,20115,29210,'javax.servlet.jsp.jstl-api','1.2.1',NULL),('a3106ec0-5478-f357-3441-3a7ddf005389',63475,20115,29210,'org.apache.commons.fileupload','1.3.2',NULL),('38f2af13-e103-fe2e-b7b2-dd252806aa0f',63476,20115,29210,'org.apache.commons.io','2.2.0',NULL),('33a770ee-8b43-068d-13d1-7651ae640fb2',63477,20115,29210,'org.apache.felix.bundlerepository','2.0.2.LIFERAY-PATCHED-1',NULL),('3c6eaf55-9535-5380-eae1-50ecaa271ba9',63478,20115,29210,'org.apache.felix.configadmin','1.8.8',NULL),('1752eb60-2672-5d26-213f-eb9c43417edf',63479,20115,29210,'org.apache.felix.dependencymanager','3.2.0',NULL),('5d7ecf29-b129-cd14-c15e-b5da74d2934d',63480,20115,29210,'org.apache.felix.dependencymanager.shell','3.2.0',NULL),('7e54dcbd-83ad-e9da-acd2-5a55e04384f4',63481,20115,29210,'org.apache.felix.eventadmin','1.4.6',NULL),('429ccc2a-1b02-5ed8-abf8-32ad0408a492',63482,20115,29210,'org.apache.felix.fileinstall','3.5.4.LIFERAY-PATCHED-2',NULL),('e2304e34-edf1-3c5c-29c2-4dfb28795d3d',63483,20115,29210,'org.apache.felix.gogo.command','0.12.0',NULL),('31903772-62bd-8fa1-77bb-70ae05404746',63484,20115,29210,'org.apache.felix.gogo.runtime','0.10.0',NULL),('2ff453bd-aecd-829e-0ce2-25ee3c02fe03',63485,20115,29210,'org.apache.felix.gogo.shell','0.10.0',NULL),('94c60e54-5158-c3f4-34b5-c19233507236',63486,20115,29210,'org.apache.felix.scr','2.0.6',NULL),('49a40d8b-d4bb-8b76-ea96-2d8bbabda204',63487,20115,29210,'org.eclipse.equinox.console','1.1.100.v20141023-1406',NULL),('fc184a05-3031-1eb6-8cbe-52278778831d',63488,20115,29210,'org.eclipse.equinox.http.servlet','1.2.2.v20180117-2202',NULL),('6daaa6bd-09b4-5c76-8ac4-40bddf438920',63489,20115,29210,'org.eclipse.equinox.metatype','1.4.200.v20150715-1528',NULL),('a703702a-2b38-8826-2898-3e90df0ef7e4',63490,20115,29210,'org.osgi.service.http','3.5.0.LIFERAY-PATCHED-2',NULL),('a8689597-25ea-fe96-6d69-fa3608f7e4a3',63491,20115,29210,'org.osgi.service.metatype','1.3.0.201505202024',NULL),('e784186e-bfe8-b9b9-4428-ccfef582edd2',63492,20115,29313,'woodstox-core-asl','4.4.1',NULL),('61a73c3f-b0bd-7a7f-7d9d-4b3f828d8a1b',63493,20115,29313,'com.liferay.alloy.mvc','2.3.1',NULL),('e4221b50-16e3-bae5-2c23-89b73f4def10',63494,20115,29313,'com.liferay.captcha.api','1.1.2',NULL),('fbf3bcfe-12f4-3ab2-fbf4-54b850309bdf',63495,20115,29313,'com.liferay.configuration.admin.web','1.0.42',NULL),('093ecbc9-521b-6ec9-243d-6fe1659e22a9',63496,20115,29313,'com.liferay.contacts.api','2.0.8',NULL),('4f587761-08c8-d9b2-04e4-1a9b254336ff',63497,20115,29313,'com.liferay.contacts.service','2.0.18',NULL),('20a54a1c-e189-48e8-607b-614b22babfaf',63498,20115,29313,'com.liferay.contacts.web','1.0.33',NULL),('16d91f94-67e0-1246-0eef-ed8de03b22ca',63499,20115,29313,'com.liferay.expando.web','1.0.12',NULL),('65764910-6eec-25c8-7f64-3bad8337cca0',63500,20115,29313,'com.liferay.frontend.compatibility.ie','1.0.1',NULL),('4d877cef-1b38-205a-308a-b45b6aab5ec5',63501,20115,29313,'com.liferay.frontend.css.common','2.0.4',NULL),('0691b196-a367-a99b-ae8e-1ef0c724c976',63502,20115,29313,'com.liferay.frontend.css.rtl.servlet','1.0.8',NULL),('c3b09c39-f81e-8e85-72b6-63743010e659',63503,20115,29313,'com.liferay.frontend.editor.lang','2.0.0',NULL),('c63aacab-b357-ea53-01a2-f08ebb3d8933',63504,20115,29313,'com.liferay.frontend.image.editor.api','1.0.4',NULL),('85b94b61-16a6-3ffd-30ed-46eaded9263b',63505,20115,29313,'com.liferay.frontend.js.aui.web','1.0.20',NULL),('81abe20e-59b6-1921-0d06-00850a2724ee',63506,20115,29313,'com.liferay.frontend.js.bundle.config.extender','1.0.11',NULL),('2c932d2a-0d47-75f2-355b-0e9cbae40548',63507,20115,29313,'com.liferay.frontend.js.loader.modules.extender','2.0.0',NULL),('b246020e-1e6e-cbdb-e077-5a4520ff78df',63508,20115,29313,'com.liferay.frontend.js.loader.modules.extender.api','1.0.1',NULL),('2c78b727-e300-17ce-24fa-805faaaa3f6b',63509,20115,29313,'com.liferay.frontend.taglib.form.navigator','1.0.9',NULL),('eab90555-126d-7d2f-cced-d0b411616945',63510,20115,29313,'com.liferay.frontend.taglib.util.freemarker.contributor','1.0.3',NULL),('800928cd-3776-0137-a738-3050ac15d1fe',63511,20115,29313,'com.liferay.frontend.theme.contributor.extender','2.0.2',NULL),('4ce200d2-d635-4add-e6a5-3bcfceca034a',63512,20115,29313,'com.liferay.frontend.theme.styled','2.1.3',NULL),('8b073b6a-f960-9651-b583-6260e2fe1bdd',63513,20115,29313,'com.liferay.hello.velocity.web','2.0.7',NULL),('44301f3f-4818-1542-4c8b-ddca75a05161',63514,20115,29313,'com.liferay.hello.world.web','2.0.6',NULL),('d3bf6567-05f9-b7ba-4390-7481effad4ed',63515,20115,29313,'com.liferay.imageio.plugins','1.0.1',NULL),('877617a7-b3a5-d003-f0b5-c3df234b5f30',63516,20115,29313,'com.liferay.license.manager.web','2.0.7',NULL),('f00cf68a-5f77-0b05-fac0-1d97c74ea468',63517,20115,29313,'com.liferay.login.web','2.0.4',NULL),('5fc4be9e-e2d1-8a6c-70a7-a81cb71f2267',63518,20115,29313,'com.liferay.map.api','2.1.0',NULL),('6252b8f4-9d62-3ac0-23a8-6fd51f8f09c4',63519,20115,29313,'com.liferay.microsoft.translator','1.0.6',NULL),('b2abe429-25a1-9693-daa5-b2caacfd30d9',63520,20115,29313,'com.liferay.mobile.device.rules.api','2.1.2',NULL),('8c3925c9-2b7c-8b36-0ef9-c24e9dd5b03b',63521,20115,29313,'com.liferay.mobile.device.rules.service','1.2.25',NULL),('84cd2a1b-5d81-627f-fcb8-57bca949d7dd',63522,20115,29313,'com.liferay.my.account.web','1.0.12',NULL),('2fd3ca78-d04e-8c52-09a4-0dc489e3f623',63523,20115,29313,'com.liferay.password.policies.admin.api','2.0.1',NULL),('30490bd0-43fd-7200-fcde-f9afc069e39a',63524,20115,29313,'com.liferay.password.policies.admin.impl','1.0.6',NULL),('0bd1d7f7-fda9-cbc2-36f6-d680424a6aef',63525,20115,29313,'com.liferay.password.policies.admin.web','1.0.24',NULL),('3ef913b3-0576-96ed-f880-6529d229867e',63526,20115,29313,'com.liferay.petra.doulos','3.5.2',NULL),('38e10d2a-0623-d11c-7cc3-f34012144362',63527,20115,29313,'com.liferay.petra.io.delta','1.1.2',NULL),('50f6a413-068e-948a-e8e5-6139e83ca0ec',63528,20115,29313,'com.liferay.petra.model.adapter','1.0.3',NULL),('e2249f05-9484-17be-12c6-87d1940c1006',63529,20115,29313,'com.liferay.plugins.admin.web','1.0.16',NULL),('9a91334d-190e-243a-e561-51db49647f2c',63530,20115,29313,'com.liferay.portal.background.task.api','2.1.2',NULL),('91be85e3-2cf5-ae24-5dd7-0b63cf784ef0',63531,20115,29313,'com.liferay.portal.background.task.service','3.0.7',NULL),('fcd9b531-4d0d-d4aa-9cfd-420ca54368a5',63532,20115,29313,'com.liferay.portal.background.task.web','2.0.3',NULL),('69dcf0a9-76db-3f7f-e04d-ef15ef6a30a2',63533,20115,29313,'com.liferay.portal.cache','2.4.10',NULL),('c7ae66d2-8e30-ea1a-dc59-617609334902',63534,20115,29313,'com.liferay.portal.cache.ehcache','2.1.16',NULL),('a1044c61-73fc-89dc-66e7-21babe517543',63535,20115,29313,'com.liferay.portal.cache.ehcache.provider','2.0.6',NULL),('b0a864a5-140f-fab3-3333-1bd28ff22c75',63536,20115,29313,'com.liferay.portal.cache.single','2.0.3',NULL),('13291542-54c1-df25-691d-09b35ff484c1',63537,20115,29313,'com.liferay.portal.cluster.single','2.0.3',NULL),('d7dfa871-1422-2c52-0e9c-f433fc235b66',63538,20115,29313,'com.liferay.portal.compound.session.id','2.0.1',NULL),('ad5a3d6a-d8ce-7baa-b28f-8f9b46bb1da0',63539,20115,29313,'com.liferay.portal.configuration.cluster','3.0.0',NULL),('ce75a697-8f67-6897-a924-4333ceee4a26',63540,20115,29313,'com.liferay.portal.configuration.extender','3.0.1',NULL),('1159e3c0-f6be-8d2b-dd64-9b28c6c586c0',63541,20115,29313,'com.liferay.portal.configuration.metatype.definitions.annotations','2.0.3',NULL),('e077de59-de76-d0fd-7726-241eeb5e33dd',63542,20115,29313,'com.liferay.portal.configuration.metatype.definitions.equinox','2.0.5',NULL),('d00435c2-6667-5ad4-4bfc-949f8043cac1',63543,20115,29313,'com.liferay.portal.configuration.module.configuration','2.0.11',NULL),('60b2b3a7-dd29-b74d-b7cb-2c96d2b87768',63544,20115,29313,'com.liferay.portal.configuration.settings','2.0.15',NULL),('18c0c08e-b9f4-cbff-7195-19faff923336',63545,20115,29313,'com.liferay.portal.custom.jsp.bag.api','1.0.1',NULL),('254c41d5-43ce-50ab-625e-b978c1684b2c',63546,20115,29313,'com.liferay.portal.dao.orm.custom.sql','1.0.13',NULL),('e10e3eab-af1f-d910-8998-47a4e4dbc487',63547,20115,29313,'com.liferay.portal.executor','2.0.3',NULL),('e3302841-9c90-200f-d932-057da32ccbb0',63548,20115,29313,'com.liferay.portal.init.servlet.filter','2.0.5',NULL),('fca3d2d5-ed9e-ea0d-7b1c-8b54bd3c13b5',63549,20115,29313,'com.liferay.portal.instance.lifecycle','3.1.0',NULL),('70ea6635-cdb8-9770-092d-8e1c958f0cd1',63550,20115,29313,'com.liferay.portal.instances.api','1.0.2',NULL),('a4f3bacc-7106-5f2c-7781-195b0696ac52',63551,20115,29313,'com.liferay.portal.instances.service','1.0.6',NULL),('3d810c6f-6cba-4013-35af-c679dedd9b3d',63552,20115,29313,'com.liferay.portal.instances.web','1.0.12',NULL),('94b2e960-48be-1af5-4de9-e2dfb15392ed',63553,20115,29313,'com.liferay.portal.jmx','4.0.0',NULL),('0ca24dd4-2438-d707-04ee-137d5823ba4f',63554,20115,29313,'com.liferay.portal.jmx.api','1.0.1',NULL),('a430fcdd-295c-06aa-e8c4-65dc9271cf9d',63555,20115,29313,'com.liferay.portal.language.extender','2.0.8',NULL),('dcd5ec9d-1725-66bd-e0a6-b31951ebef96',63556,20115,29313,'com.liferay.portal.language.servlet.filter','2.0.7',NULL),('af84fa87-e117-4b9b-1d23-5587dde388fd',63557,20115,29313,'com.liferay.portal.license.deployer','1.0.6',NULL),('4eb37ada-6a8f-2da4-7a5a-19b4d2e7695f',63558,20115,29313,'com.liferay.portal.lock.api','2.1.2',NULL),('ac3a770c-9342-9cb3-553a-c47bc9adc656',63559,20115,29313,'com.liferay.portal.lock.service','2.0.16',NULL),('c21a8747-6684-d0f8-6f2f-baba2d723f6a',63560,20115,29313,'com.liferay.portal.messaging','4.0.6',NULL),('68da9f55-176f-a00e-8165-c8d9ebb54a37',63561,20115,29313,'com.liferay.portal.mobile.device.recognition.api','1.0.3',NULL),('3cf6e238-15df-74a8-dc5c-415a537abf2c',63562,20115,29313,'com.liferay.portal.monitoring','5.0.2',NULL),('741c1c19-f9c1-7ced-aca7-eeacefee485b',63563,20115,29313,'com.liferay.portal.osgi.debug.declarative.service','1.0.4',NULL),('35962d0a-cca3-8388-4bb7-515bd313dd40',63564,20115,29313,'com.liferay.portal.osgi.debug.spring.extender','1.0.7',NULL),('ca6520fe-bdd9-ebf2-762b-d68ec2c7e719',63565,20115,29313,'com.liferay.portal.output.stream.container','3.0.0',NULL),('d76c7d50-bdc4-d4a1-18c8-3b18e4d63984',63566,20115,29313,'com.liferay.portal.output.stream.container.api','1.0.1',NULL),('6e5b8dd8-57f7-03be-6212-d8e7d691dc8a',63567,20115,29313,'com.liferay.portal.pop.notifications','2.0.5',NULL),('9964fe17-3f76-cce3-dfd4-fe9aea336197',63568,20115,29313,'com.liferay.portal.remote.axis.extender','1.0.11',NULL),('ec13e250-cd6d-3662-2e91-bb82eac01637',63569,20115,29313,'com.liferay.portal.remote.cxf.common','3.0.8',NULL),('c646b1e6-7b88-9427-5f4f-c5f45a302341',63570,20115,29313,'com.liferay.portal.remote.cxf.jaxrs.common','3.1.2',NULL),('c3810d34-08d3-4996-b64e-cafacc842d97',63571,20115,29313,'com.liferay.portal.remote.http.tunnel.extender','2.0.11',NULL),('15f5bf1b-d274-f124-c260-7485b26e83b7',63572,20115,29313,'com.liferay.portal.remote.json.web.service.extender','2.0.5',NULL),('5e2be0a1-91e2-0788-ca70-dcaa48b726db',63573,20115,29313,'com.liferay.portal.remote.rest.extender','2.0.14',NULL),('4be5264e-3d45-6894-ac25-9581df415b67',63574,20115,29313,'com.liferay.portal.remote.soap.extender.api','1.0.1',NULL),('202491b8-88be-c0aa-cfba-743f432a6cfe',63575,20115,29313,'com.liferay.portal.remote.soap.extender.impl','1.0.3',NULL),('bb33fbf8-168d-d12a-cbb9-00d49f4bb8b0',63576,20115,29313,'com.liferay.portal.scheduler','4.0.6',NULL),('ac12e39e-86e1-4a87-5a5f-d2649069036a',63577,20115,29313,'com.liferay.portal.scheduler.quartz','3.0.2',NULL),('2c9e4baa-ad4d-b359-17af-e65f8b0e04a8',63578,20115,29313,'com.liferay.portal.scheduler.single','2.0.7',NULL),('88868881-7d34-a9a7-3ce1-0fc2f9485b7c',63579,20115,29313,'com.liferay.portal.scripting.api','1.1.1',NULL),('85fcf05d-b12a-9987-4cda-1be36bf0ea0b',63580,20115,29313,'com.liferay.portal.scripting.executor','3.0.2',NULL),('ce472568-8485-b656-65b6-39c2699d967c',63581,20115,29313,'com.liferay.portal.scripting.groovy','2.0.4',NULL),('ab8c13ef-2b64-e121-f9e9-727780c17d32',63582,20115,29313,'com.liferay.portal.search','4.0.5',NULL),('39865758-25f6-7862-2a5b-5adb933adbd9',63583,20115,29313,'com.liferay.portal.search.api','1.0.2',NULL),('7898ac68-7ff1-9797-3f57-811eec63ff08',63584,20115,29313,'com.liferay.portal.search.elasticsearch','2.1.25',NULL),('3125e693-9391-a297-6e14-38c5cf7adbd5',63585,20115,29313,'com.liferay.portal.search.facet','2.0.10',NULL),('0ad883ad-f66f-4db7-80db-3f29138ede99',63586,20115,29313,'com.liferay.portal.search.web.api','1.0.1',NULL),('c35629ba-3cb4-9954-b47f-e9bebc7ad31f',63587,20115,29313,'com.liferay.portal.security.antisamy','2.0.18',NULL),('351d78e4-8d95-7683-2c41-9c5690bfe1a2',63588,20115,29313,'com.liferay.portal.security.audit.api','2.0.6',NULL),('6433c3af-7dc4-b068-81ce-a4113d232662',63589,20115,29313,'com.liferay.portal.security.audit.wiring','2.0.6',NULL),('5ae428b2-e38a-46c5-0ff9-e4ce628c2449',63590,20115,29313,'com.liferay.portal.security.auth.verifier','2.1.7',NULL),('d0e3aa3c-af6e-26af-cd72-ca4048021008',63591,20115,29313,'com.liferay.portal.security.auto.login','2.1.7',NULL),('a3bd862c-60a1-b7ee-1782-a35e57f95a33',63592,20115,29313,'com.liferay.portal.security.exportimport.api','2.0.1',NULL),('ca62eeae-180b-cb3c-e8b4-7161c4382688',63593,20115,29313,'com.liferay.portal.security.ldap','2.2.20',NULL),('1fd37458-28a2-8816-54ed-b08e19979bce',63594,20115,29313,'com.liferay.portal.security.service.access.policy.api','2.0.11',NULL),('fe94a913-c11e-b03d-db57-4ce64881f3db',63595,20115,29313,'com.liferay.portal.security.service.access.policy.service','2.1.4',NULL),('540b7d3c-255f-c549-0afb-fe0017ed2d90',63596,20115,29313,'com.liferay.portal.security.service.access.policy.web','1.0.15',NULL),('c7093275-57c7-6767-1209-9d6f61499d11',63597,20115,29313,'com.liferay.portal.security.sso.cas','4.0.1',NULL),('70272f94-af75-c70a-5b62-87048134eda6',63598,20115,29313,'com.liferay.portal.security.sso.cas.api','1.0.1',NULL),('8df47223-da75-4604-ca9f-2a2ea389faf3',63599,20115,29313,'com.liferay.portal.security.sso.facebook.connect','4.0.0',NULL),('b882d7e2-0aa3-5b09-74d2-00a0737346a2',63600,20115,29313,'com.liferay.portal.security.sso.facebook.connect.api','1.0.1',NULL),('5fe3bd41-e15f-4f86-0dac-d24a02fc5e00',63601,20115,29313,'com.liferay.portal.security.sso.google','3.0.0',NULL),('d5b0af40-959d-3b86-83dc-2dcd77e333b5',63602,20115,29313,'com.liferay.portal.security.sso.google.api','1.0.0',NULL),('0fdb609a-a2d3-0d9b-728a-0b251637267f',63603,20115,29313,'com.liferay.portal.security.sso.ntlm','4.0.1',NULL),('87308fe1-f277-c89c-02f9-f18beb0d4514',63604,20115,29313,'com.liferay.portal.security.sso.ntlm.api','1.0.2',NULL),('91b49941-08d0-e843-ce61-b0f8c4e2ae6b',63605,20115,29313,'com.liferay.portal.security.sso.openid','4.0.0',NULL),('9f3fe68e-4fa3-b5d0-4cca-daf3d73ab3e0',63606,20115,29313,'com.liferay.portal.security.sso.openid.api','1.0.2',NULL),('66796277-be7f-cae5-6664-1442a1841187',63607,20115,29313,'com.liferay.portal.security.sso.opensso','4.0.0',NULL),('6ab457ae-3f7c-dd35-e716-efebdb72c42e',63608,20115,29313,'com.liferay.portal.security.sso.opensso.api','1.0.1',NULL),('16ca5709-7901-116c-c1eb-2774f45b197d',63609,20115,29313,'com.liferay.portal.security.sso.token.api','1.0.1',NULL),('3207ca2e-aa29-21ed-0308-18c7d4935a1e',63610,20115,29313,'com.liferay.portal.security.sso.token.impl','1.0.2',NULL),('2691bb36-1ea3-7144-f495-9863618f022b',63611,20115,29313,'com.liferay.portal.settings.api','2.0.4',NULL),('9ac0652b-67cc-7a4a-6dc5-0730e1219fe2',63612,20115,29313,'com.liferay.portal.settings.lang','1.0.9',NULL),('c523c832-c7fc-6eed-dfaf-46a92ee5e2db',63613,20115,29313,'com.liferay.portal.spring.extender','2.1.6',NULL),('73dd3029-84f8-9fd7-29c4-3b372364b924',63614,20115,29313,'com.liferay.portal.store.cmis','2.0.17',NULL),('f601cb88-31d1-3e1f-0609-1280b456482f',63615,20115,29313,'com.liferay.portal.store.db','2.0.3',NULL),('4c7b9505-33a9-c5c3-d492-78a6c1e696e5',63616,20115,29313,'com.liferay.portal.store.file.system','2.0.12',NULL),('a608e21c-1f0b-2f0f-0442-ddbe5cc2430a',63617,20115,29313,'com.liferay.portal.store.ignore.duplicates.wrapper','1.0.2',NULL),('a6d52c9e-da44-cab0-536f-523ba3ac99fe',63618,20115,29313,'com.liferay.portal.store.jcr','2.0.17',NULL),('ce4e8c77-5b20-9a15-de29-5aa0e51352d7',63619,20115,29313,'com.liferay.portal.store.s3','2.0.18',NULL),('c93a652f-87a6-fcc0-839d-5f5d902ff541',63620,20115,29313,'com.liferay.portal.store.safe.file.name.wrapper','1.0.3',NULL),('0218dae8-2417-cceb-67c8-211287aa9141',63621,20115,29313,'com.liferay.portal.template.freemarker','3.0.8',NULL),('669bb765-e757-70bf-866f-172baf21be05',63622,20115,29313,'com.liferay.portal.template.soy','2.4.13',NULL),('7608051c-4074-5bc7-bf55-dc32c0163ca9',63623,20115,29313,'com.liferay.portal.template.soy.context.contributor','1.0.1',NULL),('25a2fce5-4c29-7cf3-2771-51af477335dd',63624,20115,29313,'com.liferay.portal.template.velocity','2.0.27',NULL),('1d5d69f0-8f62-90cf-9867-ec1a428f651a',63625,20115,29313,'com.liferay.portal.template.xsl','2.0.9',NULL),('c2e84013-4b98-4b92-0592-c80a13095c8a',63626,20115,29313,'com.liferay.portal.upgrade.api','1.0.1',NULL),('2ae16929-b427-3e1b-724f-be87a4e5eda6',63627,20115,29313,'com.liferay.portal.upgrade.impl','1.0.1',NULL),('86a4a42b-ed3e-44ac-775a-2180353d9b5c',63628,20115,29313,'com.liferay.portal.verify.extender','3.0.0',NULL),('66a30b20-9382-05af-01a0-6af4cf11e437',63629,20115,29313,'com.liferay.portal.weblogic.support','2.0.3',NULL),('712c7644-666a-ad36-19a4-ac653890bba4',63630,20115,29313,'com.liferay.roles.admin.api','2.0.1',NULL),('67908a50-eaa4-32d0-14c3-4a70d83f1c0d',63631,20115,29313,'com.liferay.roles.admin.impl','1.0.9',NULL),('7fa54f1f-864b-5de7-3ea3-9065a90c24c6',63632,20115,29313,'com.liferay.roles.admin.web','1.0.40',NULL),('8a39781d-8062-4dba-7784-087d3599b666',63633,20115,29313,'com.liferay.roles.selector.web','1.0.11',NULL),('a381eca6-7e97-b71f-7512-28cc08cf8129',63634,20115,29313,'com.liferay.server.admin.web','1.0.30',NULL),('9a084a67-7b69-0e84-5eee-9f86ed0512ca',63635,20115,29313,'com.liferay.user.groups.admin.api','2.0.1',NULL),('650f67aa-3092-8fed-a861-c94b7dcf6ba0',63636,20115,29313,'com.liferay.user.groups.admin.impl','1.0.8',NULL),('15fe0423-bd6e-618b-2978-82f26461dc82',63637,20115,29313,'com.liferay.user.groups.admin.web','1.0.18',NULL),('c24760b7-ec13-8f9f-9b94-92e1777946a5',63638,20115,29313,'com.liferay.users.admin.api','2.0.1',NULL),('dbc80c2a-1e38-c604-fd08-09ea6e00eebd',63639,20115,29313,'com.liferay.users.admin.impl','1.0.15',NULL),('f0be7a1e-6f70-4639-03b6-8b0163bfa4c7',63640,20115,29313,'com.liferay.websocket.whiteboard','1.0.2',NULL),('ae341636-23f9-3cf9-ba13-29e63043ace0',63641,20115,29313,'com.liferay.xstream.configurator.api','2.1.1',NULL),('091763be-fc2d-0dba-fad7-6b551f8d3dab',63642,20115,29313,'javax.validation.api','1.1.0.Final',NULL),('b37ded12-2ad8-4dba-0121-f89c819f5da6',63643,20115,29313,'stax2-api','3.1.4',NULL),('ad473639-255f-c3ac-1fa6-652b48794e40',63644,20115,29313,'com.liferay.captcha.taglib','1.0.5','captcha-taglib'),('906dedf9-6be1-daff-a54d-3db8a7f082b2',63645,20115,29313,'com.liferay.expando.taglib','1.0.8','expando-taglib'),('abad700f-93af-d23a-d324-72eb11dd3a51',63646,20115,29313,'com.liferay.frontend.css.web','1.0.37','frontend-css-web'),('caff7e59-b322-5413-6bdd-ca9b21b80ee1',63647,20115,29313,'com.liferay.frontend.editor.alloyeditor.accessibility.web','1.0.5','frontend-editor-alloyeditor-accessibility-web'),('14b1716c-28a7-b3bd-ae25-c0789e311285',63648,20115,29313,'com.liferay.frontend.editor.alloyeditor.link.browse.web','1.0.6','frontend-editor-alloyeditor-link-browse-web'),('aa832a1e-0312-b17b-7b7e-af97716a23e9',63649,20115,29313,'com.liferay.frontend.editor.alloyeditor.web','1.0.35','frontend-editor-alloyeditor-web'),('c889597c-e4eb-c8dd-6b73-417ce2c1443e',63650,20115,29313,'com.liferay.frontend.editor.ckeditor.web','1.0.42','frontend-editor-ckeditor-web'),('24d562de-6080-4f79-3d4f-b27c3fc45342',63651,20115,29313,'com.liferay.frontend.editor.simple.web','1.0.9','frontend-editor-simple-web'),('594456b5-8861-ddda-ba31-816f04a9e67b',63652,20115,29313,'com.liferay.frontend.editor.tinymce.web','1.0.21','frontend-editor-tinymce-web'),('20b6c606-fb48-124e-d590-0a8562f9c42a',63653,20115,29313,'com.liferay.frontend.image.editor.capability.brightness','1.0.14','frontend-image-editor-capability-brightness'),('532bff0a-90a9-98c1-ebac-91800338e864',63654,20115,29313,'com.liferay.frontend.image.editor.capability.contrast','1.0.14','frontend-image-editor-capability-contrast'),('9569fd96-186f-3241-df65-99db094bd9c5',63655,20115,29313,'com.liferay.frontend.image.editor.capability.crop','1.0.14','frontend-image-editor-capability-crop'),('b0e5bd6b-bc99-e914-e493-da4152a66ef3',63656,20115,29313,'com.liferay.frontend.image.editor.capability.effects','1.0.15','frontend-image-editor-capability-effects'),('c987b36d-b9de-5193-474e-bbf911016856',63657,20115,29313,'com.liferay.frontend.image.editor.capability.resize','1.0.14','frontend-image-editor-capability-resize'),('deb4b34b-aab6-a5fa-1d59-0745ea226f35',63658,20115,29313,'com.liferay.frontend.image.editor.capability.rotate','1.0.14','frontend-image-editor-capability-rotate'),('05f5f3c8-a077-8825-051b-02e5cca46e1b',63659,20115,29313,'com.liferay.frontend.image.editor.capability.saturation','1.0.14','frontend-image-editor-capability-saturation'),('0d6d977d-cdc8-9b7c-ac4e-8173ee7aa3c0',63660,20115,29313,'com.liferay.frontend.image.editor.integration.document.library','1.0.17','frontend-image-editor-integration-document-library'),('8ad420e8-4278-b3df-acc5-c5e2999d3e0e',63661,20115,29313,'com.liferay.frontend.image.editor.web','1.0.21','frontend-image-editor-web'),('2391b080-af67-9357-43c1-8719b5e11828',63662,20115,29313,'com.liferay.frontend.js.metal.web','1.0.19','frontend-js-metal-web'),('b7fac684-09cd-057d-aa3b-0e54a24b6d28',63663,20115,29313,'com.liferay.frontend.js.node.shims','1.0.2','frontend-js-node-shims'),('37551e28-1e4b-cd8a-922d-c4a7bf9b856e',63664,20115,29313,'com.liferay.frontend.js.polyfill.babel.web','1.0.4','frontend-js-polyfill-babel-web'),('eca972e7-758e-57af-a0eb-75ffc9c95311',63665,20115,29313,'com.liferay.frontend.js.soyutils.web','1.0.4','frontend-js-soyutils-web'),('23b2908d-5e5b-5523-da6f-0a46c1374f79',63666,20115,29313,'com.liferay.frontend.js.spa.web','1.0.47','frontend-js-spa-web'),('e889e140-acef-e3fa-9265-5b50f0a0b8c0',63667,20115,29313,'com.liferay.frontend.js.web','1.0.69','frontend-js-web'),('2ab29ac4-0ea8-1f63-adda-cd8a30484fe8',63668,20115,29313,'com.liferay.frontend.taglib','2.2.12','frontend-taglib'),('6135952f-a5dc-1524-83cf-1cebf2abd002',63669,20115,29313,'com.liferay.frontend.taglib.soy','1.0.9','frontend-taglib-soy'),('05d0aa8f-e096-bd87-aee2-c04429a19f85',63670,20115,29313,'com.liferay.frontend.theme.favicon.servlet','1.0.1','frontend-theme'),('ad722943-fb9e-2568-384f-bbc40d37df17',63671,20115,29313,'com.liferay.frontend.theme.unstyled','2.2.9','frontend-theme'),('13381561-3f53-78b0-37dd-da1125709c8e',63672,20115,29313,'com.liferay.hello.soy.navigation.web','1.0.2','hello-soy-navigation-web'),('2a1cf005-0ccb-fb94-ad30-c236ef8663e1',63673,20115,29313,'com.liferay.hello.soy.web','1.0.14','hello-soy-web'),('18edb436-5c5c-cb50-bbb2-5db432712c1e',63674,20115,29313,'com.liferay.login.authentication.facebook.connect.web','2.0.10','login-authentication-facebook-connect-web'),('68baacab-ddbe-b0ac-28fc-6b88a30ec09f',63675,20115,29313,'com.liferay.login.authentication.google.web','2.0.10','login-authentication-google-web'),('8eed361a-1659-e9e6-91fb-962dde2465dc',63676,20115,29313,'com.liferay.login.authentication.openid.web','2.0.7','login-authentication-openid-web'),('015ce9f8-e94b-7bfa-c886-0affdfd0f05f',63677,20115,29313,'com.liferay.map.common','2.0.1','map-common'),('0f3c5043-11bf-1696-5fcd-9dfb94a5081e',63678,20115,29313,'com.liferay.map.google.maps','1.0.15','map-google-maps'),('470e90f4-4613-8f89-864c-7e2382bd26f7',63679,20115,29313,'com.liferay.map.openstreetmap','2.0.13','map-openstreetmap'),('faa79e3e-f217-249e-42db-2484578c8853',63680,20115,29313,'com.liferay.map.taglib','1.1.8','map-taglib'),('4426b6e3-be45-9fc9-fe72-5cf3e85d243e',63681,20115,29313,'com.liferay.mobile.device.rules.web','1.0.22','mobile-device-rules-web'),('0fad909c-6212-4837-a764-828048ad4981',63682,20115,29313,'com.liferay.monitoring.web','1.0.13','monitoring-web'),('2026858e-45a5-9cca-ba42-324df033c1e6',63683,20115,29313,'com.liferay.portal.portlet.bridge.soy','3.1.6','portal-portlet'),('2d9fbb24-3f57-ebff-b2e7-ac0a2767d245',63684,20115,29313,'com.liferay.portal.search.web','2.0.0','portal-search-web'),('c2532493-0d8c-7ff5-ef75-b0912ebb56e8',63685,20115,29313,'com.liferay.portal.settings.authentication.cas.web','1.0.8','portal-settings-authentication-cas-web'),('c2f3b6cc-b04d-035a-e747-4b65a0222505',63686,20115,29313,'com.liferay.portal.settings.authentication.facebook.connect.web','1.0.7','portal-settings-authentication-facebook-connect-web'),('13f2731b-ae72-0415-0c3e-874ff8d252d1',63687,20115,29313,'com.liferay.portal.settings.authentication.google.web','1.0.6','portal-settings-authentication-google-web'),('efb85c85-bd97-beb7-49a2-3a4f0b59e114',63688,20115,29313,'com.liferay.portal.settings.authentication.ldap.web','1.0.20','portal-settings-authentication-ldap-web'),('cbfd9538-ddb7-2782-28ae-376cee3235f8',63689,20115,29313,'com.liferay.portal.settings.authentication.ntlm.web','1.0.7','portal-settings-authentication-ntlm-web'),('1ab0e188-67d4-8625-a440-1991f26a083f',63690,20115,29313,'com.liferay.portal.settings.authentication.openid.web','1.0.7','portal-settings-authentication-openid-web'),('1acd2078-efbf-5028-d2d7-67f808342bef',63691,20115,29313,'com.liferay.portal.settings.authentication.opensso.web','1.0.9','portal-settings-authentication-opensso-web'),('58814225-fc37-492f-cfa4-e34b83ece985',63692,20115,29313,'com.liferay.portal.settings.web','1.2.3','portal-settings-web'),('f78ed710-cb0f-f6d9-c9b9-7cc69a91da6a',63693,20115,29313,'com.liferay.users.admin.web','2.4.6','users-admin-web'),('5303c39b-6af0-bf4a-aff2-be4c06018060',63694,20115,29313,'com.liferay.web.proxy.web','1.0.14','web-proxy-web'),('c757586c-29f4-79c2-d9f5-358cc6438627',63695,20115,29313,'Liferay CE Foundation-admin-theme-wrapper','1.0.39',NULL),('b08b4ee0-55d2-aa43-05ad-29c8192589f1',63696,20115,29313,'Liferay CE Foundation-classic-theme-wrapper','1.0.42',NULL),('fa1beb23-89c0-5b8d-e2b8-7625905de00a',63697,20115,29313,'Liferay CE Foundation-user-dashboard-theme-wrapper','1.0.40',NULL),('bb9f056b-ece7-235b-f9ab-1fac0263463a',63698,20115,29313,'Liferay CE Foundation-user-profile-theme-wrapper','1.0.40',NULL),('9ed722e3-ecdf-7200-b602-b4cbf431d813',63699,20115,29521,'com.liferay.sync.api','3.0.0',NULL),('dab22270-c13d-e680-3a86-49df0dbf9a37',63700,20115,29521,'com.liferay.sync.security','2.0.7',NULL),('3666257c-8fda-f239-9f4b-fc1beb3644bd',63701,20115,29521,'com.liferay.sync.service','1.5.2',NULL),('78f3111d-be01-6863-b342-6f3c94e79620',63702,20115,29521,'com.liferay.sync.web','1.0.10',NULL),('a87f4bfc-ce8a-a2d8-72a6-71c824c327e1',63703,20115,29526,'com.liferay.application.list.api','2.2.4',NULL),('46352308-674d-84f9-1276-cfe3f4a30e2e',63704,20115,29526,'com.liferay.application.list.taglib','2.0.11','application-list-taglib'),('ec09f6c5-79c5-0f3e-3c6b-5ce80c1945ce',63705,20115,29526,'com.liferay.application.list.user.personal.site.permissions','2.0.6',NULL),('a2224d19-8c2e-3871-fe88-fceec7ba11b0',63706,20115,29526,'com.liferay.asset.browser.web','1.0.23',NULL),('9f74ee0d-ca7f-432e-dc42-fa13f41f39c3',63707,20115,29526,'com.liferay.asset.categories.admin.web','1.1.13',NULL),('ef78f8d4-e03e-f2c0-3ef4-ffefd537ad77',63708,20115,29526,'com.liferay.asset.categories.navigation.api','1.0.1',NULL),('5feb706f-8635-a442-a33d-244c8e11edd7',63709,20115,29526,'com.liferay.asset.categories.navigation.web','2.0.5','asset-categories-navigation-web'),('afccf4ea-ef52-6e43-ef27-9d539cdc222c',63710,20115,29526,'com.liferay.asset.categories.service','1.0.11',NULL),('026e47c9-e29f-fc32-9187-2a30e21d33db',63711,20115,29526,'com.liferay.asset.display.web','1.0.8',NULL),('448b0cb9-c998-658f-94c4-7a93b7e7695e',63712,20115,29526,'com.liferay.asset.entry.query.processor.custom.user.attributes','2.0.8','asset-entry-query-processor-custom-user-attributes'),('24e0e496-3e73-2557-c2aa-9b97ac23cd87',63713,20115,29526,'com.liferay.asset.publisher.layout.prototype','1.0.14',NULL),('565d74b3-079d-3d5a-a372-7156694152b2',63714,20115,29526,'com.liferay.asset.publisher.web','1.8.8','asset-publisher-web'),('c77e6af3-09a5-cd5a-3004-70d4fa483f78',63715,20115,29526,'com.liferay.asset.service','1.1.3',NULL),('589b0df3-ce4b-1b92-f341-89228e872f8e',63716,20115,29526,'com.liferay.asset.taglib','2.0.9','asset-taglib'),('b18ea0b1-3653-3718-9891-ddaf0f3fccdc',63717,20115,29526,'com.liferay.asset.tags.admin.web','1.0.13',NULL),('e0fefc02-726f-d8b2-4991-029db2209e11',63718,20115,29526,'com.liferay.asset.tags.api','1.0.2',NULL),('f6050a36-0f90-7dad-b6e7-35a697791185',63719,20115,29526,'com.liferay.asset.tags.compiler.web','2.0.6',NULL),('e23dec6e-3f72-b759-9432-3323e57ba19b',63720,20115,29526,'com.liferay.asset.tags.navigation.api','1.0.1',NULL),('faed0dc4-3c9a-cd5b-6307-85e87c3b54c7',63721,20115,29526,'com.liferay.asset.tags.navigation.web','3.0.6','asset-tags-navigation-web'),('f97da5c4-aa48-76fa-3ab1-682ad644156e',63722,20115,29526,'com.liferay.asset.tags.service','2.0.3',NULL),('80a95ea2-2ed1-06d1-a409-26a94baa8ab5',63723,20115,29526,'com.liferay.asset.web','2.0.5',NULL),('699ba375-b990-4f68-51ea-0a1e6e57ffa6',63724,20115,29526,'com.liferay.exportimport.api','2.2.1',NULL),('6ee14c03-61c2-a5f4-ebee-34f19abfaa6b',63725,20115,29526,'com.liferay.exportimport.resources.importer','2.0.1',NULL),('e99a1fba-55f6-6b54-adc4-53cc418f1823',63726,20115,29526,'com.liferay.exportimport.service','4.0.6',NULL),('dafbcabe-3c0c-dbf5-2e6f-4fc0ea8ebe1d',63727,20115,29526,'com.liferay.exportimport.web','1.0.36','exportimport-web'),('5bc61a46-dd9c-be38-3a94-492212954730',63728,20115,29526,'com.liferay.iframe.web','1.0.15','iframe-web'),('0c680edb-31ac-eb87-22c6-d69a03d5d815',63729,20115,29526,'com.liferay.journal.api','2.12.6',NULL),('0099bb95-a00a-8c61-b21c-89a885b6799f',63730,20115,29526,'com.liferay.journal.content.asset.addon.entry.comments','1.0.9','journal-content-asset-addon-entry-comments'),('60b648b9-112a-df0b-369b-96860852a93f',63731,20115,29526,'com.liferay.journal.content.asset.addon.entry.common','2.0.3',NULL),('a379207e-218a-3a85-3e41-cac0480dfd88',63732,20115,29526,'com.liferay.journal.content.asset.addon.entry.conversions','2.0.8','journal-content-asset-addon-entry-conversions'),('5547ed7f-4418-c0e6-535f-46ef220a1c7d',63733,20115,29526,'com.liferay.journal.content.asset.addon.entry.locales','1.0.6','journal-content-asset-addon-entry-locales'),('1c4b5aee-2918-22ca-bfc4-a8f2983261c1',63734,20115,29526,'com.liferay.journal.content.asset.addon.entry.print','2.0.4','journal-content-asset-addon-entry-print'),('24e5a159-a48e-ead4-6b17-44add0307c77',63735,20115,29526,'com.liferay.journal.content.asset.addon.entry.ratings','2.0.4','journal-content-asset-addon-entry-ratings'),('db946e4a-cfbc-aef0-7363-57610888c6aa',63736,20115,29526,'com.liferay.journal.content.asset.addon.entry.related.assets','2.0.4','journal-content-asset-addon-entry-related-assets'),('3a9c3938-a254-298e-16c6-f32d0bd4e7f9',63737,20115,29526,'com.liferay.journal.content.search.web','1.0.14','journal-content-search-web'),('21f1a335-c3ba-1e2c-4d12-a6bf2e3c5126',63738,20115,29526,'com.liferay.journal.content.web','2.0.6','journal-content-web'),('65592455-26d6-6096-3b48-dc0700aae7ad',63739,20115,29526,'com.liferay.journal.editor.configuration','1.0.2',NULL),('f684364a-1092-46df-7ca3-4187f8a8aa67',63740,20115,29526,'com.liferay.journal.item.selector.api','1.0.2',NULL),('01532b0e-a869-0e20-db20-9b03982b367c',63741,20115,29526,'com.liferay.journal.item.selector.web','1.0.4','journal-item-selector-web'),('b72cf1cc-2319-28bb-2c63-8179fc35b165',63742,20115,29526,'com.liferay.journal.lang','2.0.14',NULL),('fc142902-d254-0e39-c6cc-65f7ea4f23fa',63743,20115,29526,'com.liferay.journal.ratings.definition','2.0.2',NULL),('1af49744-ebea-ad9f-03b5-cb4ba1ccfbb8',63744,20115,29526,'com.liferay.journal.service','3.24.4',NULL),('0a92436a-69be-e2de-ed70-4a251a411d19',63745,20115,29526,'com.liferay.journal.taglib','1.0.6','journal-taglib'),('5b4a14f0-dc98-002b-2cc1-4d663e6330ad',63746,20115,29526,'com.liferay.journal.terms.of.use','2.0.25','journal-terms-of-use'),('00539e4d-dcc2-f9f2-19a8-de9a6aa2e53c',63747,20115,29526,'com.liferay.journal.web','1.10.14','journal-web'),('fc24dc01-714b-2eef-d290-fb3ef0b8ffe0',63748,20115,29526,'com.liferay.layout.admin.web','1.0.62','layout-admin-web'),('15820a05-b557-a373-b905-60f9cb38a9d2',63749,20115,29526,'com.liferay.layout.impl','2.0.4',NULL),('e0fdc203-f8f5-b68f-2df8-6dbd26624211',63750,20115,29526,'com.liferay.layout.item.selector.api','1.0.3',NULL),('aa854e15-1c6a-8c21-42a6-db6a51a3c95e',63751,20115,29526,'com.liferay.layout.item.selector.web','1.1.9','layout-item-selector-web'),('97a1fac9-5759-42f2-7c01-5869cc7553e7',63752,20115,29526,'com.liferay.layout.prototype.api','1.0.1',NULL),('e08341c5-54bd-ce09-601c-0a87687ec726',63753,20115,29526,'com.liferay.layout.prototype.impl','1.0.5',NULL),('c11d874a-2aa6-dfd6-3024-75ff8816ad70',63754,20115,29526,'com.liferay.layout.prototype.web','1.0.13',NULL),('57051f83-c850-5ef9-1e32-7c272e48883b',63755,20115,29526,'com.liferay.layout.set.prototype.api','1.0.2',NULL),('a897dc59-7a29-eade-3f52-a574ed912db3',63756,20115,29526,'com.liferay.layout.set.prototype.impl','2.0.1',NULL),('7fd320e7-79f2-36e5-65b8-7f418bd6e034',63757,20115,29526,'com.liferay.layout.set.prototype.web','1.0.14',NULL),('b69628cb-5be4-d0d7-96a2-746ce41e6070',63758,20115,29526,'com.liferay.layout.taglib','2.1.6','layout-taglib'),('1a0096ad-ff83-e3a2-cfb8-c09595c3d516',63759,20115,29526,'com.liferay.layout.type.controller.control.panel','2.0.3','layout-type-controller-control-panel'),('cb565f3a-9012-11d0-7bbc-d2b1c9edd182',63760,20115,29526,'com.liferay.layout.type.controller.full.page.application','2.0.8','layout-type-controller-full-page-application'),('f2d8f30d-fed1-140e-d8a0-dc46aa8f6e4c',63761,20115,29526,'com.liferay.layout.type.controller.node','2.0.6','layout-type-controller-node'),('2b62628f-18b0-a840-021a-2c770b497691',63762,20115,29526,'com.liferay.layout.type.controller.shared.portlet','2.0.5','layout-type-controller-shared-portlet'),('4677a3b4-9861-3e5b-c250-a526e1ddff8a',63763,20115,29526,'com.liferay.nested.portlets.web','2.0.16','nested-portlet'),('8eb54614-421a-3fee-c76a-debe328e55d4',63764,20115,29526,'com.liferay.portlet.configuration.css.web','2.0.18','portlet-configuration-css-web'),('58dbba3b-8c98-b627-c94b-88badad1d67b',63765,20115,29526,'com.liferay.portlet.configuration.icon.close','2.0.2',NULL),('2f772688-40da-cf21-eea0-0a10ef2e2c30',63766,20115,29526,'com.liferay.portlet.configuration.icon.edit','2.0.2',NULL),('a31e0b51-49e1-2438-c242-6e49cf70eef8',63767,20115,29526,'com.liferay.portlet.configuration.icon.edit.defaults','2.0.2',NULL),('16725e40-f61f-779f-d101-1887aaca06c8',63768,20115,29526,'com.liferay.portlet.configuration.icon.edit.guest','2.0.2',NULL),('e4fc5b2c-580b-7bb3-a9a4-e11d68bb03be',63769,20115,29526,'com.liferay.portlet.configuration.icon.help','2.0.2',NULL),('3adf9bd7-9cc8-9e1b-b01d-6cfefe95feec',63770,20115,29526,'com.liferay.portlet.configuration.icon.locator.api','2.0.3',NULL),('e3d838d5-e165-e85d-573c-6b00376b8360',63771,20115,29526,'com.liferay.portlet.configuration.icon.maximize','2.0.2',NULL),('c0ef86ea-6879-61ea-ff56-bec84a390171',63772,20115,29526,'com.liferay.portlet.configuration.icon.minimize','2.0.2',NULL),('5dae960f-c1cf-d230-5a3f-f0aeb6a05815',63773,20115,29526,'com.liferay.portlet.configuration.icon.print','2.0.2',NULL),('c0cb50a2-d671-bd1d-565f-7ce752b575d9',63774,20115,29526,'com.liferay.portlet.configuration.icon.refresh','2.0.2',NULL),('05c3bdb2-7ed9-4b39-90d7-74828cd8a592',63775,20115,29526,'com.liferay.portlet.configuration.sharing.web','2.0.10',NULL),('c773df58-c5fa-bcca-2e99-86b283a2bd9f',63776,20115,29526,'com.liferay.portlet.configuration.toolbar.contributor.locator.api','2.0.2',NULL),('0365ddc2-b0f8-d533-7505-3689233f5374',63777,20115,29526,'com.liferay.portlet.configuration.web','1.0.26',NULL),('106d1c74-f6db-8ccb-7ad1-ce84a9370baf',63778,20115,29526,'com.liferay.portlet.display.template','2.2.2',NULL),('2cc63b5b-b043-781e-8f92-f06ff0cf60f6',63779,20115,29526,'com.liferay.portlet.display.template.web','2.0.7',NULL),('1a5ac3ce-eaf3-aaef-059d-34025f053e9b',63780,20115,29526,'com.liferay.product.navigation.control.menu.api','3.0.0',NULL),('1990ed5c-b309-bf64-c8cc-34892606a406',63781,20115,29526,'com.liferay.product.navigation.control.menu.theme.contributor','2.0.12','product-navigation-control-menu-theme'),('07e6b44c-ced3-7935-012f-9fda3c7339b5',63782,20115,29526,'com.liferay.product.navigation.control.menu.web','2.0.16','product-navigation-control-menu-web'),('df74318f-0cd5-3773-dbac-95adb66979c8',63783,20115,29526,'com.liferay.product.navigation.control.panel','2.0.2',NULL),('62a27e49-29ca-4a46-4b24-4486c3c21774',63784,20115,29526,'com.liferay.product.navigation.product.menu.theme.contributor','2.0.7','product-navigation-product-menu-theme'),('d0381431-4f92-a40b-07f3-f62d2a801456',63785,20115,29526,'com.liferay.product.navigation.product.menu.web','2.0.22','product-navigation-product-menu-web'),('da4b3c68-07bf-6206-6a5a-098969306f8e',63786,20115,29526,'com.liferay.product.navigation.simulation.api','1.1.0',NULL),('445c8a4c-7c46-5e86-6257-4d3ea31300b5',63787,20115,29526,'com.liferay.product.navigation.simulation.device','2.0.12','product-navigation-simulation-device'),('fae8b25e-0ac5-553b-f534-32c0e7a9c0e4',63788,20115,29526,'com.liferay.product.navigation.simulation.theme.contributor','2.0.4','product-navigation-simulation-theme'),('e3ba2985-42e5-cc06-0760-390d1640d01c',63789,20115,29526,'com.liferay.product.navigation.simulation.web','3.0.1','product-navigation-simulation-web'),('bc0a0e11-ae30-7909-f67f-58145ff66684',63790,20115,29526,'com.liferay.product.navigation.site.administration','2.0.12','product-navigation-site-administration'),('12c520dc-74fe-cff5-dbfc-570886861723',63791,20115,29526,'com.liferay.product.navigation.taglib','2.0.13','product-navigation-taglib'),('9d8417e4-8a36-6f55-e1b1-f75326912868',63792,20115,29526,'com.liferay.product.navigation.user','2.0.5','product-navigation-user'),('9d929aad-0ea4-8f25-2df6-8f4e5f5e7975',63793,20115,29526,'com.liferay.product.navigation.user.personal.bar.web','2.0.9',NULL),('4924f3f5-d29c-afa7-ec83-8a172c025183',63794,20115,29526,'com.liferay.rss.api','1.0.1',NULL),('efd1a4d3-60c6-4d95-9853-43b332912094',63795,20115,29526,'com.liferay.rss.util','1.0.11',NULL),('276c3b8d-d437-f0c1-0473-899da74c3db9',63796,20115,29526,'com.liferay.rss.web','3.0.0','rss-web'),('c0fac32a-b8da-559e-352a-6525d89123bb',63797,20115,29526,'com.liferay.site.admin.web','1.0.37','site-admin-web'),('27aeb436-635d-2afd-0646-234b25e021a5',63798,20115,29526,'com.liferay.site.api','2.1.8',NULL),('6aa0527e-54b3-7a8c-864d-5fc0ba5b8df4',63799,20115,29526,'com.liferay.site.browser.web','2.0.16',NULL),('7328d7f4-710d-65ff-36be-5d44b19130fa',63800,20115,29526,'com.liferay.site.item.selector.api','1.0.3',NULL),('9e05a562-31a6-5d2d-e735-651803e8c154',63801,20115,29526,'com.liferay.site.item.selector.web','2.0.19','site-item-selector-web'),('1f9687fa-dd39-16e6-7f0e-02e0ae7c342c',63802,20115,29526,'com.liferay.site.memberships.web','1.0.26',NULL),('171b47ea-fc97-c8b4-9faf-be9b43ce0869',63803,20115,29526,'com.liferay.site.my.sites.web','2.0.4',NULL),('b64ff8f8-b280-3180-9b27-5131a543940c',63804,20115,29526,'com.liferay.site.navigation.breadcrumb.web','3.0.3','site-navigation-breadcrumb-web'),('cf9ddb09-989f-0ae9-59e4-6ccc16aa8ddf',63805,20115,29526,'com.liferay.site.navigation.directory.web','2.0.9','site-navigation-directory-web'),('7f9c7fd6-e717-18d9-09b7-f77ff3c7ad59',63806,20115,29526,'com.liferay.site.navigation.language.api','1.0.1',NULL),('b6634aea-eca8-a873-a242-ded60dfa6563',63807,20115,29526,'com.liferay.site.navigation.language.web','3.0.4','site-navigation-language-web'),('714a9e26-e4cc-9d1a-44bc-0679105fbeb7',63808,20115,29526,'com.liferay.site.navigation.menu.web','2.0.20','site-navigation-menu-web'),('2e15165b-5da8-3d28-deef-e24018c32e8e',63809,20115,29526,'com.liferay.site.navigation.site.map.web','2.0.16','site-navigation-site-map-web'),('0a13bae4-7c03-8336-7b23-8520c8c35b2a',63810,20115,29526,'com.liferay.site.navigation.taglib','2.1.8','site-navigation-taglib'),('2d413345-a551-bbf8-9425-d995239b2f48',63811,20115,29526,'com.liferay.site.teams.web','1.0.16',NULL),('f39fa4b9-dcae-a34d-3adf-10b01affb634',63812,20115,29526,'com.liferay.staging.api','2.1.0',NULL),('d84abfc2-176c-34ba-b11c-4d8c5613ece2',63813,20115,29526,'com.liferay.staging.bar.web','1.0.20','staging-bar-web'),('74c6b853-9ba8-1f51-6507-cb6f263a5564',63814,20115,29526,'com.liferay.staging.configuration.web','1.0.19',NULL),('18daeb32-19f9-bd58-0239-fac84c5c93db',63815,20115,29526,'com.liferay.staging.lang','2.0.16',NULL),('b87dbad3-fc4d-6b4a-eaee-9824236a9a6f',63816,20115,29526,'com.liferay.staging.portlet.data.handler','3.0.0',NULL),('23222dd8-3ecd-2c16-1ffa-fa37c891ed4c',63817,20115,29526,'com.liferay.staging.processes.web','1.0.25','staging-processes-web'),('51d04352-333c-87b5-bcfa-3107c5865bf5',63818,20115,29526,'com.liferay.staging.security','2.0.28',NULL),('95f0d061-4fb0-0ca5-8b0c-1b3dccf2bf23',63819,20115,29526,'com.liferay.staging.taglib','3.1.18','staging-taglib'),('cc87b52e-1b1b-8a5a-b12f-6743453f7270',63820,20115,29526,'com.liferay.trash.service','1.0.2',NULL),('289629a9-c438-33e4-743f-86594093cdf8',63821,20115,29526,'com.liferay.trash.taglib','2.0.8','trash-taglib'),('d7281a6d-00b7-12f5-fb47-5769b9659a13',63822,20115,29526,'com.liferay.trash.web','1.0.24','trash-web'),('01761f21-6b67-b0b6-bed5-264d747faa4d',63823,20115,29526,'com.liferay.xsl.content.web','2.0.10','xsl-content-web');

--
-- Table structure for table `MembershipRequest`
--

CREATE TABLE `MembershipRequest` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `membershipRequestId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `comments` longtext DEFAULT NULL,
  `replyComments` longtext DEFAULT NULL,
  `replyDate` datetime(6) DEFAULT NULL,
  `replierUserId` bigint(20) DEFAULT NULL,
  `statusId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`membershipRequestId`),
  KEY `IX_C28C72EC` (`groupId`,`statusId`),
  KEY `IX_35AA8FA6` (`groupId`,`userId`,`statusId`),
  KEY `IX_66D70879` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MembershipRequest`
--


--
-- Table structure for table `MicroblogsEntry`
--

CREATE TABLE `MicroblogsEntry` (
  `microblogsEntryId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `creatorClassNameId` bigint(20) DEFAULT NULL,
  `creatorClassPK` bigint(20) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `type_` int(11) DEFAULT NULL,
  `parentMicroblogsEntryId` bigint(20) DEFAULT NULL,
  `socialRelationType` int(11) DEFAULT NULL,
  PRIMARY KEY (`microblogsEntryId`),
  KEY `IX_1D8CE137` (`companyId`,`creatorClassNameId`,`creatorClassPK`,`type_`),
  KEY `IX_CA299EF2` (`companyId`,`creatorClassNameId`,`type_`),
  KEY `IX_14ACFA9` (`creatorClassNameId`,`creatorClassPK`,`type_`),
  KEY `IX_6AA6B164` (`creatorClassNameId`,`type_`),
  KEY `IX_6BD29B9C` (`type_`,`parentMicroblogsEntryId`),
  KEY `IX_8F04FC09` (`userId`,`createDate`,`type_`,`socialRelationType`),
  KEY `IX_92BA6F0` (`userId`,`type_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `MicroblogsEntry`
--


--
-- Table structure for table `OrgGroupRole`
--

CREATE TABLE `OrgGroupRole` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `organizationId` bigint(20) NOT NULL,
  `groupId` bigint(20) NOT NULL,
  `roleId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`organizationId`,`groupId`,`roleId`),
  KEY `IX_4A527DD3` (`groupId`),
  KEY `IX_AB044D1C` (`roleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `OrgGroupRole`
--


--
-- Table structure for table `OrgLabor`
--

CREATE TABLE `OrgLabor` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `orgLaborId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `organizationId` bigint(20) DEFAULT NULL,
  `typeId` bigint(20) DEFAULT NULL,
  `sunOpen` int(11) DEFAULT NULL,
  `sunClose` int(11) DEFAULT NULL,
  `monOpen` int(11) DEFAULT NULL,
  `monClose` int(11) DEFAULT NULL,
  `tueOpen` int(11) DEFAULT NULL,
  `tueClose` int(11) DEFAULT NULL,
  `wedOpen` int(11) DEFAULT NULL,
  `wedClose` int(11) DEFAULT NULL,
  `thuOpen` int(11) DEFAULT NULL,
  `thuClose` int(11) DEFAULT NULL,
  `friOpen` int(11) DEFAULT NULL,
  `friClose` int(11) DEFAULT NULL,
  `satOpen` int(11) DEFAULT NULL,
  `satClose` int(11) DEFAULT NULL,
  PRIMARY KEY (`orgLaborId`),
  KEY `IX_6AF0D434` (`organizationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `OrgLabor`
--


--
-- Table structure for table `Organization_`
--

CREATE TABLE `Organization_` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `organizationId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `parentOrganizationId` bigint(20) DEFAULT NULL,
  `treePath` longtext DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `type_` varchar(75) DEFAULT NULL,
  `recursable` tinyint(4) DEFAULT NULL,
  `regionId` bigint(20) DEFAULT NULL,
  `countryId` bigint(20) DEFAULT NULL,
  `statusId` bigint(20) DEFAULT NULL,
  `comments` longtext DEFAULT NULL,
  `logoId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`organizationId`),
  UNIQUE KEY `IX_E301BDF5` (`companyId`,`name`),
  KEY `IX_418E4522` (`companyId`,`parentOrganizationId`),
  KEY `IX_A9D85BA6` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Organization_`
--


--
-- Table structure for table `PasswordPolicy`
--

CREATE TABLE `PasswordPolicy` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `passwordPolicyId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `defaultPolicy` tinyint(4) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `changeable` tinyint(4) DEFAULT NULL,
  `changeRequired` tinyint(4) DEFAULT NULL,
  `minAge` bigint(20) DEFAULT NULL,
  `checkSyntax` tinyint(4) DEFAULT NULL,
  `allowDictionaryWords` tinyint(4) DEFAULT NULL,
  `minAlphanumeric` int(11) DEFAULT NULL,
  `minLength` int(11) DEFAULT NULL,
  `minLowerCase` int(11) DEFAULT NULL,
  `minNumbers` int(11) DEFAULT NULL,
  `minSymbols` int(11) DEFAULT NULL,
  `minUpperCase` int(11) DEFAULT NULL,
  `regex` varchar(75) DEFAULT NULL,
  `history` tinyint(4) DEFAULT NULL,
  `historyCount` int(11) DEFAULT NULL,
  `expireable` tinyint(4) DEFAULT NULL,
  `maxAge` bigint(20) DEFAULT NULL,
  `warningTime` bigint(20) DEFAULT NULL,
  `graceLimit` int(11) DEFAULT NULL,
  `lockout` tinyint(4) DEFAULT NULL,
  `maxFailure` int(11) DEFAULT NULL,
  `lockoutDuration` bigint(20) DEFAULT NULL,
  `requireUnlock` tinyint(4) DEFAULT NULL,
  `resetFailureCount` bigint(20) DEFAULT NULL,
  `resetTicketMaxAge` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`passwordPolicyId`),
  UNIQUE KEY `IX_3FBFA9F4` (`companyId`,`name`),
  KEY `IX_2C1142E` (`companyId`,`defaultPolicy`),
  KEY `IX_E4D7EF87` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PasswordPolicy`
--

INSERT INTO `PasswordPolicy` VALUES (0,'41d4e435-a837-e21d-9c73-938270da1cf4',20154,20115,20119,NULL,'2021-11-18 19:43:45.483000','2021-11-18 19:43:45.483000',1,'Default Password Policy','Default Password Policy',1,1,0,0,1,0,6,0,1,0,1,'(?=.{4})(?:[a-zA-Z0-9]*)',0,6,0,8640000,86400,0,0,3,0,1,600,86400);

--
-- Table structure for table `PasswordPolicyRel`
--

CREATE TABLE `PasswordPolicyRel` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `passwordPolicyRelId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `passwordPolicyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`passwordPolicyRelId`),
  UNIQUE KEY `IX_C3A17327` (`classNameId`,`classPK`),
  KEY `IX_CD25266E` (`passwordPolicyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PasswordPolicyRel`
--


--
-- Table structure for table `PasswordTracker`
--

CREATE TABLE `PasswordTracker` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `passwordTrackerId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `password_` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`passwordTrackerId`),
  KEY `IX_326F75BD` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PasswordTracker`
--


--
-- Table structure for table `Phone`
--

CREATE TABLE `Phone` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `uuid_` varchar(75) DEFAULT NULL,
  `phoneId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `number_` varchar(75) DEFAULT NULL,
  `extension` varchar(75) DEFAULT NULL,
  `typeId` bigint(20) DEFAULT NULL,
  `primary_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`phoneId`),
  KEY `IX_812CE07A` (`companyId`,`classNameId`,`classPK`,`primary_`),
  KEY `IX_F202B9CE` (`userId`),
  KEY `IX_B271FA88` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Phone`
--


--
-- Table structure for table `PluginSetting`
--

CREATE TABLE `PluginSetting` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `pluginSettingId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `pluginId` varchar(75) DEFAULT NULL,
  `pluginType` varchar(75) DEFAULT NULL,
  `roles` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`pluginSettingId`),
  UNIQUE KEY `IX_7171B2E8` (`companyId`,`pluginId`,`pluginType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PluginSetting`
--


--
-- Table structure for table `PollsChoice`
--

CREATE TABLE `PollsChoice` (
  `uuid_` varchar(75) DEFAULT NULL,
  `choiceId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `questionId` bigint(20) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`choiceId`),
  UNIQUE KEY `IX_D76DD2CF` (`questionId`,`name`),
  UNIQUE KEY `IX_C222BD31` (`uuid_`,`groupId`),
  KEY `IX_8AE746EF` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PollsChoice`
--


--
-- Table structure for table `PollsQuestion`
--

CREATE TABLE `PollsQuestion` (
  `uuid_` varchar(75) DEFAULT NULL,
  `questionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `title` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `expirationDate` datetime(6) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `lastVoteDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`questionId`),
  UNIQUE KEY `IX_F3C9F36` (`uuid_`,`groupId`),
  KEY `IX_9FF342EA` (`groupId`),
  KEY `IX_F910BBB4` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PollsQuestion`
--


--
-- Table structure for table `PollsVote`
--

CREATE TABLE `PollsVote` (
  `uuid_` varchar(75) DEFAULT NULL,
  `voteId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `questionId` bigint(20) DEFAULT NULL,
  `choiceId` bigint(20) DEFAULT NULL,
  `lastPublishDate` datetime(6) DEFAULT NULL,
  `voteDate` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`voteId`),
  UNIQUE KEY `IX_A88C673A` (`uuid_`,`groupId`),
  KEY `IX_D5DF7B54` (`choiceId`),
  KEY `IX_1BBFD4D3` (`questionId`,`userId`),
  KEY `IX_7D8E92B8` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PollsVote`
--


--
-- Table structure for table `PortalPreferences`
--

CREATE TABLE `PortalPreferences` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `portalPreferencesId` bigint(20) NOT NULL,
  `ownerId` bigint(20) DEFAULT NULL,
  `ownerType` int(11) DEFAULT NULL,
  `preferences` longtext DEFAULT NULL,
  PRIMARY KEY (`portalPreferencesId`),
  KEY `IX_D1F795F1` (`ownerId`,`ownerType`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PortalPreferences`
--

INSERT INTO `PortalPreferences` VALUES (5,20116,20115,1,'<portlet-preferences><preference><name>adminEmailPasswordSentSubject_ar_SA</name><value>[$PORTAL_URL$]: Your New Password</value></preference><preference><name>adminEmailPasswordResetSubject_ar_SA</name><value>[$PORTAL_URL$]: Reset Your Password</value></preference><preference><name>mentionsEnabled</name><value>true</value></preference><preference><name>adminEmailPasswordResetBody_ar_SA</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]You can reset your password for [$PORTAL_URL$] at [$PASSWORD_RESET_URL$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]The request for a new password was made from [$REMOTE_ADDRESS$] / [$REMOTE_HOST$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailVerificationBody_ar_SA</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Please verify your email address for [$PORTAL_URL$] at [$EMAIL_VERIFICATION_URL$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Your verification code is [$EMAIL_VERIFICATION_CODE$] Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailVerificationBody_en_US</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Please verify your email address for [$PORTAL_URL$] at [$EMAIL_VERIFICATION_URL$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Your verification code is [$EMAIL_VERIFICATION_CODE$] Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailPasswordResetBody_en_US</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]You can reset your password for [$PORTAL_URL$] at [$PASSWORD_RESET_URL$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]The request for a new password was made from [$REMOTE_ADDRESS$] / [$REMOTE_HOST$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailPasswordSentBody_ar_SA</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Your new password for [$PORTAL_URL$] is [$USER_PASSWORD$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]The request for a new password was made from [$REMOTE_ADDRESS$] / [$REMOTE_HOST$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>sync.lan.key</name><value>MIICeAIBADANBgkqhkiG9w0BAQEFAASCAmIwggJeAgEAAoGBALSlV1feiwARPkNOPcGM7ENYuV0lR9Xoxs0qhzD/VhPiSK3jj3udkx9RUwRaDY3FXzBieDjgyjrBZW6WsEYK7FDFvAC2GpCHnM9TdancjfyKgtVcMC7F4AKYvd1htVXYQm9TiYWT78kIs8u1600hbISnHloglN/3PgzRlh6TULDlAgMBAAECgYEAhzLLyPbEv1soZ0UykR5AYTMRIDZbqivaRgkTP0eKi70qugH7DABl8OVzpWkkhbt3P4YjBiavFARUPs1GxlU8gQCWplstmFWZEDpbL/URThLwY2TMZ5LYBHFdCyIf9ExfU/FtU8ClSaqBUEehKeRx32NE9thipBerA6JrM7O9oQ0CQQDm59hrnmcsbeyInzhSpGNXWTx3cgU/QdwMGgBuOtYiSsA+U96L2zfztweejBMlzcIBa7aFhQU5sDoR40LDvN63AkEAyEcwveomV/n3+E5IE1RM6z+8U4CD9Xd+w3Se8f2Vd97erxJ/7yR33RF2JaJJQwFeb7/lOyJpZFXRooYXomnRQwJAMWoCRZ2jhL2Ndftk6UKmw8WkDAfJmaz1c12JJA3RT4thsrTuFk32nmBX8BUX7+olj3pGmDJMWPkepD9XRV5A5wJBAKnzZ1QxZxpOv3LREu58Ic2bRzdgnhnlrgc0ZlCZTIXs9PCBdVi8jI5m6+ghn6OhfL69i0sz91UyUfNlcJbczrsCQQDRbomtRTZzVv1fpBSsqI14QveT9HLdZIX9HzoEqlaTaTKBH7oetkJ3uV0aIA5p7X3zyaS1IGdqIWGrPXx6ru7b</value></preference><preference><name>adminEmailPasswordResetSubject_en_US</name><value>[$PORTAL_URL$]: Reset Your Password</value></preference><preference><name>socialInteractionsFriendsEnabledcom_liferay_mentions_web_portlet_MentionsPortlet</name><value>true</value></preference><preference><name>com.liferay.message.boards.kernel.model.MBDiscussion_RatingsType</name><value>thumbs</value></preference><preference><name>com.liferay.message.boards.kernel.model.MBMessage_RatingsType</name><value>thumbs</value></preference><preference><name>company.security.site.logo</name><value>false</value></preference><preference><name>adminEmailPasswordSentBody_en_US</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Your new password for [$PORTAL_URL$] is [$USER_PASSWORD$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]The request for a new password was made from [$REMOTE_ADDRESS$] / [$REMOTE_HOST$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>googleMapsAPIKey</name><value></value></preference><preference><name>default.regular.theme.id</name><value>wcktheme_WAR_wcktheme</value></preference><preference><name>socialInteractionsSitesEnabledcom_liferay_mentions_web_portlet_MentionsPortlet</name><value>true</value></preference><preference><name>adminEmailUserAddedBody_en_US</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Welcome! You recently created an account at [$PORTAL_URL$]. Your password is [$USER_PASSWORD$]. Enjoy!&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailUserAddedNoPasswordBody_en_US</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Welcome! You recently created an account at [$PORTAL_URL$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailUserAddedNoPasswordBody_ar_SA</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Welcome! You recently created an account at [$PORTAL_URL$].&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>adminEmailPasswordSentSubject_en_US</name><value>[$PORTAL_URL$]: Your New Password</value></preference><preference><name>com.liferay.journal.model.JournalArticle_RatingsType</name><value>stars</value></preference><preference><name>com.liferay.blogs.kernel.model.BlogsEntry_RatingsType</name><value>thumbs</value></preference><preference><name>sync.lan.server.uuid</name><value>80e36e59-43fe-d4a2-70e8-a845a1def2e8</value></preference><preference><name>com.liferay.bookmarks.model.BookmarksEntry_RatingsType</name><value>stars</value></preference><preference><name>adminEmailUserAddedBody_ar_SA</name><value>Dear [$TO_NAME$],&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Welcome! You recently created an account at [$PORTAL_URL$]. Your password is [$USER_PASSWORD$]. Enjoy!&lt;br /&gt;[$NEW_LINE$]&lt;br /&gt;[$NEW_LINE$]Sincerely,&lt;br /&gt;[$NEW_LINE$][$FROM_NAME$]&lt;br /&gt;[$NEW_LINE$][$FROM_ADDRESS$]&lt;br /&gt;[$NEW_LINE$][$PORTAL_URL$]</value></preference><preference><name>socialInteractionsTypecom_liferay_mentions_web_portlet_MentionsPortlet</name><value>all_users</value></preference><preference><name>terms.of.use.journal.article.group.id</name><value>0</value></preference><preference><name>adminEmailUserAddedSubject_ar_SA</name><value>[$PORTAL_URL$]: Your New Account</value></preference><preference><name>terms.of.use.journal.article.id</name><value></value></preference><preference><name>sync.lan.certificate</name><value>MIIB2zCCAUSgAwIBAgIILQjGzS+kP1wwDQYJKoZIhvcNAQELBQAwLzEtMCsGA1UEAwwkODBlMzZlNTktNDNmZS1kNGEyLTcwZTgtYTg0NWExZGVmMmU4MCAXDTIwMTExODE5NDg1MloYDzMwMjEwMzIxMTk0ODUyWjAvMS0wKwYDVQQDDCQ4MGUzNmU1OS00M2ZlLWQ0YTItNzBlOC1hODQ1YTFkZWYyZTgwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBALSlV1feiwARPkNOPcGM7ENYuV0lR9Xoxs0qhzD/VhPiSK3jj3udkx9RUwRaDY3FXzBieDjgyjrBZW6WsEYK7FDFvAC2GpCHnM9TdancjfyKgtVcMC7F4AKYvd1htVXYQm9TiYWT78kIs8u1600hbISnHloglN/3PgzRlh6TULDlAgMBAAEwDQYJKoZIhvcNAQELBQADgYEAbH0a7i20GW4q5jOy48IInhx8fPNxiUSznzAbI3MbRJzWFCx8nqS5aPeNnzncwc+JkeFZBmY7mySiuK5z0tFM+6293Ddvf5rWlhLCfI+FAAlGgxf/0p6zB4nRsV9OMulSjanHllp2wbATDorW/k7PgNIRmj9MnE3FDIyllmDyyvM=</value></preference><preference><name>com.liferay.document.library.kernel.model.DLFileEntry_RatingsType</name><value>stars</value></preference><preference><name>locales</name><value>es_ES,ar_SA,fr_FR,en_US,de_DE,ar_BH</value></preference><preference><name>adminEmailVerificationSubject_en_US</name><value>[$PORTAL_URL$]: Email Address Verification</value></preference><preference><name>com.liferay.wiki.model.WikiPage_RatingsType</name><value>stars</value></preference><preference><name>adminEmailVerificationSubject_ar_SA</name><value>[$PORTAL_URL$]: Email Address Verification</value></preference><preference><name>adminEmailUserAddedSubject_en_US</name><value>[$PORTAL_URL$]: Your New Account</value></preference></portlet-preferences>'),(0,20156,0,1,'<portlet-preferences />'),(576,30648,20155,4,'<portlet-preferences><preference><name>com.liferay.portal.kernel.util.SessionClicks#roles</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.info.panel__com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_a8f1QTBrE8j2_infoPanelId</name><value>open</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#dlFileEntryCategorizationPanel</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#sitemap</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#seo</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_layout_admin_web_portlet_GroupPagesPortlet_layout.form</name><value>advanced</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.product.navigation.product.menu.web_productMenuState</name><value>open</value></preference><preference><name>com_liferay_users_admin_web_portlet_UsersAdminPortlet#users-order-by-col</name><value>last-name</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#displaySettings</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#users</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#siteUrl</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_users_admin_web_portlet_UsersAdminPortlet_users.form</name><value>user-information</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#smallImage</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#templateDetailsSectionPanel</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#pages</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#termsOfUse</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#analytics</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.site.util_recentGroups</name><value>20142,20158,33404</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet_show-metadata</name><value>0</value></preference><preference><name>com_liferay_document_library_web_portlet_DLPortlet#display-style</name><value>descriptive</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#organizations</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.application.list.PanelCategorypanel-manage-site_administration_navigation</name><value>closed</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#sites</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#displayPage</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet_languages</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet_filter-action-</name><value>1</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#categorization</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#advanced</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_IBdsI9YvtwwL_categorization</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_uSI4Em7EBa1b_categorization</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_site_admin_web_portlet_SiteAdminPortlet_sites.form</name><value>advanced</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#ewlw</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#documentsAndMedia</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet_model-resource-com-liferay-asset</name><value>0</value></preference><preference><name>com_liferay_users_admin_web_portlet_UsersAdminPortlet#users-order-by-type</name><value>asc</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#contentSharing</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#metadata</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#maps</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#password</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_a8f1QTBrE8j2_categorization</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#assetPublisherSourcePanel</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet_scope</name><value>0</value></preference><preference><name>com.liferay.taglib.ui.util.SessionTreeJSClicks#layoutsTree</name><value>15,11,</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_layout_admin_web_portlet_GroupPagesPortlet_layout.set.form</name><value>look-and-feel</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#customizationSettings</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#personalSiteTemplate</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#structureAndTemplate</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.info.panel__com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_uSI4Em7EBa1b_infoPanelId</name><value>open</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#authentication</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#mobileDeviceRules</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#userGroups</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.product.navigation.control.menu.web_addPanelTab</name><value></value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#emailNotifications</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_portal_settings_web_portlet_PortalSettingsPortlet_company.settings.form</name><value>miscellaneous</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_site_admin_web_portlet_SiteSettingsPortlet_sites.form</name><value>advanced</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_IBdsI9YvtwwL_permissions</name><value>1</value></preference></portlet-preferences>'),(0,30701,20119,4,'<portlet-preferences />'),(32,33412,33402,4,'<portlet-preferences><preference><name>com.liferay.portal.kernel.util.SessionClicks#roles</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#organizations</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#comments</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#_com_liferay_my_account_web_portlet_MyAccountPortlet_users.form</name><value>user-information</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#sites</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.product.navigation.product.menu.web_productMenuState</name><value>open</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#com.liferay.site.util_recentGroups</name><value>20142,33404</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#sms</name><value>0</value></preference><preference><name>com.liferay.portal.kernel.util.SessionClicks#displaySettings</name><value>0</value></preference></portlet-preferences>');

--
-- Table structure for table `Portlet`
--

CREATE TABLE `Portlet` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `id_` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `portletId` varchar(200) DEFAULT NULL,
  `roles` longtext DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id_`),
  UNIQUE KEY `IX_12B5E51D` (`companyId`,`portletId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Portlet`
--

INSERT INTO `Portlet` VALUES (0,30458,20115,'com_liferay_configuration_admin_web_portlet_SystemSettingsPortlet',NULL,1),(0,30459,20115,'com_liferay_hello_world_web_portlet_HelloWorldPortlet',NULL,1),(0,30460,20115,'com_liferay_license_manager_web_portlet_LicenseManagerPortlet',NULL,1),(0,30461,20115,'com_liferay_login_web_portlet_FastLoginPortlet',NULL,1),(0,30462,20115,'com_liferay_login_web_portlet_LoginPortlet',NULL,1),(0,30463,20115,'com_liferay_portal_instances_web_portlet_PortalInstancesPortlet',NULL,1),(0,30464,20115,'com_liferay_server_admin_web_portlet_ServerAdminPortlet',NULL,1),(0,30465,20115,'com_liferay_image_editor_web_portlet_ImageEditorPortlet',NULL,1),(0,30466,20115,'hello_soy_portlet',NULL,1),(0,30467,20115,'com_liferay_monitoring_web_portlet_MonitoringPortlet',NULL,1),(0,30468,20115,'com_liferay_portal_settings_web_portlet_PortalSettingsPortlet',NULL,1),(0,30469,20115,'com_liferay_users_admin_web_portlet_MyOrganizationsPortlet',NULL,1),(0,30471,20115,'com_liferay_users_admin_web_portlet_UsersAdminPortlet',NULL,1),(0,30472,20115,'com_liferay_asset_categories_navigation_web_portlet_AssetCategoriesNavigationPortlet',NULL,1),(0,30473,20115,'com_liferay_asset_tags_navigation_web_portlet_AssetTagsCloudPortlet',NULL,1),(0,30474,20115,'com_liferay_asset_tags_navigation_web_portlet_AssetTagsNavigationPortlet',NULL,1),(0,30475,20115,'com_liferay_iframe_web_portlet_IFramePortlet',NULL,1),(0,30476,20115,'com_liferay_rss_web_portlet_RSSPortlet',NULL,1),(0,30477,20115,'com_liferay_site_navigation_directory_web_portlet_SitesDirectoryPortlet',NULL,1),(0,30478,20115,'com_liferay_site_navigation_site_map_web_portlet_SiteNavigationSiteMapPortlet',NULL,1),(0,30479,20115,'com_liferay_xsl_content_web_portlet_XSLContentPortlet',NULL,1),(0,30480,20115,'com_liferay_polls_web_portlet_PollsDisplayPortlet',NULL,1),(0,30481,20115,'com_liferay_polls_web_portlet_PollsPortlet',NULL,1),(0,30482,20115,'com_liferay_portal_workflow_definition_web_portlet_WorkflowDefinitionPortlet',NULL,1),(0,30483,20115,'com_liferay_portal_workflow_instance_web_portlet_MyWorkflowInstancePortlet',NULL,1),(0,30485,20115,'com_liferay_portal_workflow_instance_web_portlet_WorkflowInstancePortlet',NULL,1),(0,30486,20115,'com_liferay_portal_workflow_task_web_portlet_MyWorkflowTaskPortlet',NULL,1),(0,30488,20115,'com_liferay_comment_web_portlet_CommentPortlet',NULL,1),(0,30489,20115,'com_liferay_ip_geocoder_sample_web_portlet_IPGeocoderSamplePortlet',NULL,1),(0,30490,20115,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet',NULL,1),(0,30499,20115,'com_liferay_asset_publisher_web_portlet_HighestRatedAssetsPortlet',NULL,1),(0,30500,20115,'com_liferay_asset_publisher_web_portlet_MostViewedAssetsPortlet',NULL,1),(0,30501,20115,'com_liferay_asset_publisher_web_portlet_RecentContentPortlet',NULL,1),(0,30502,20115,'com_liferay_asset_publisher_web_portlet_RelatedAssetsPortlet',NULL,1),(0,30503,20115,'com_liferay_asset_tags_admin_web_portlet_AssetTagsAdminPortlet',NULL,1),(0,30504,20115,'com_liferay_asset_categories_admin_web_portlet_AssetCategoriesAdminPortlet',NULL,1),(0,30505,20115,'com_liferay_portal_search_web_portlet_SearchPortlet',NULL,1),(0,30506,20115,'com_liferay_layout_prototype_web_portlet_LayoutPrototypePortlet',NULL,1),(0,30507,20115,'com_liferay_nested_portlets_web_portlet_NestedPortletsPortlet',NULL,1),(0,30508,20115,'com_liferay_mentions_web_portlet_MentionsPortlet',NULL,1),(0,30509,20115,'com_liferay_password_policies_admin_web_portlet_PasswordPoliciesAdminPortlet',NULL,1),(0,30510,20115,'com_liferay_user_groups_admin_web_portlet_UserGroupsAdminPortlet',NULL,1),(0,30511,20115,'com_liferay_portal_workflow_definition_link_web_portlet_WorkflowDefinitionLinkControlPanelPortlet',NULL,1),(0,30512,20115,'com_liferay_portal_workflow_definition_link_web_portlet_WorkflowDefinitionLinkPortlet',NULL,1),(0,30513,20115,'com_liferay_trash_web_portlet_TrashPortlet',NULL,1),(0,30514,20115,'com_liferay_layout_set_prototype_web_portlet_LayoutSetPrototypePortlet',NULL,1),(0,30515,20115,'com_liferay_roles_admin_web_portlet_RolesAdminPortlet',NULL,1),(0,30516,20115,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet',NULL,1),(0,30517,20115,'com_liferay_hello_velocity_web_portlet_HelloVelocityPortlet',NULL,1),(0,30519,20115,'com_liferay_plugins_admin_web_portlet_PluginsAdminPortlet',NULL,1),(0,30520,20115,'com_liferay_mobile_device_rules_web_portlet_MDRPortlet',NULL,1),(0,30521,20115,'com_liferay_web_proxy_web_portlet_WebProxyPortlet',NULL,1),(0,30522,20115,'com_liferay_site_my_sites_web_portlet_MySitesPortlet',NULL,1),(0,30523,20115,'com_liferay_announcements_web_portlet_AlertsPortlet',NULL,1),(0,30524,20115,'com_liferay_announcements_web_portlet_AnnouncementsAdminPortlet',NULL,1),(0,30525,20115,'com_liferay_announcements_web_portlet_AnnouncementsPortlet',NULL,1),(0,30526,20115,'com_liferay_blogs_recent_bloggers_web_portlet_RecentBloggersPortlet',NULL,1),(0,30527,20115,'com_liferay_bookmarks_web_portlet_BookmarksAdminPortlet',NULL,1),(0,30528,20115,'com_liferay_bookmarks_web_portlet_BookmarksPortlet',NULL,1),(0,30529,20115,'com_liferay_comment_page_comments_web_portlet_PageCommentsPortlet',NULL,1),(0,30530,20115,'com_liferay_directory_web_portlet_FriendsDirectoryPortlet',NULL,1),(0,30531,20115,'com_liferay_directory_web_portlet_MySitesDirectoryPortlet',NULL,1),(0,30532,20115,'com_liferay_directory_web_portlet_DirectoryPortlet',NULL,1),(0,30533,20115,'com_liferay_directory_web_portlet_SiteMembersDirectoryPortlet',NULL,1),(0,30534,20115,'com_liferay_flags_web_portlet_FlagsPortlet',NULL,1),(0,30535,20115,'com_liferay_flags_web_portlet_PageFlagsPortlet',NULL,1),(0,30536,20115,'com_liferay_image_uploader_web_portlet_ImageUploaderPortlet',NULL,1),(0,30537,20115,'com_liferay_quick_note_web_portlet_QuickNotePortlet',NULL,1),(0,30538,20115,'com_liferay_ratings_page_ratings_web_portlet_PageRatingsPortlet',NULL,1),(0,30539,20115,'com_liferay_recent_documents_web_portlet_RecentDocumentsPortlet',NULL,1),(0,30540,20115,'com_liferay_social_activities_web_portlet_SocialActivitiesPortlet',NULL,1),(0,30541,20115,'com_liferay_social_activity_web_portlet_SocialActivityPortlet',NULL,1),(0,30542,20115,'com_liferay_social_group_statistics_web_portlet_SocialGroupStatisticsPortlet',NULL,1),(0,30543,20115,'com_liferay_social_requests_web_portlet_SocialRequestsPortlet',NULL,1),(0,30544,20115,'com_liferay_social_user_statistics_web_portlet_SocialUserStatisticsPortlet',NULL,1),(0,30545,20115,'com_liferay_document_library_web_portlet_DLAdminPortlet',NULL,1),(0,30546,20115,'com_liferay_document_library_web_portlet_DLPortlet',NULL,1),(0,30547,20115,'com_liferay_document_library_web_portlet_IGDisplayPortlet',NULL,1),(0,30548,20115,'com_liferay_message_boards_web_portlet_MBAdminPortlet',NULL,1),(0,30549,20115,'com_liferay_message_boards_web_portlet_MBPortlet',NULL,1),(0,30550,20115,'com_liferay_wiki_web_portlet_WikiAdminPortlet',NULL,1),(0,30551,20115,'com_liferay_wiki_web_portlet_WikiDisplayPortlet',NULL,1),(0,30552,20115,'com_liferay_wiki_web_portlet_WikiPortlet',NULL,1),(0,30578,20115,'com_liferay_blogs_web_portlet_BlogsAdminPortlet',NULL,1),(0,30579,20115,'com_liferay_blogs_web_portlet_BlogsAgreggatorPortlet',NULL,1),(0,30580,20115,'com_liferay_blogs_web_portlet_BlogsPortlet',NULL,1),(0,30589,20115,'com_liferay_contacts_web_portlet_ContactsCenterPortlet',NULL,1),(0,30590,20115,'com_liferay_contacts_web_portlet_MembersPortlet',NULL,1),(0,30591,20115,'com_liferay_contacts_web_portlet_MyContactsPortlet',NULL,1),(0,30592,20115,'com_liferay_contacts_web_portlet_ProfilePortlet',NULL,1),(0,30593,20115,'com_liferay_portal_security_service_access_policy_web_portlet_SAPPortlet',NULL,1),(0,30594,20115,'com_liferay_calendar_web_portlet_CalendarPortlet',NULL,1),(0,30595,20115,'com_liferay_dynamic_data_mapping_data_provider_web_portlet_DDMDataProviderPortlet',NULL,1),(0,30596,20115,'com_liferay_dynamic_data_mapping_web_portlet_DDMPortlet',NULL,1),(0,30597,20115,'com_liferay_dynamic_data_mapping_web_portlet_PortletDisplayTemplatePortlet',NULL,1),(0,30598,20115,'com_liferay_dynamic_data_lists_web_portlet_DDLDisplayPortlet',NULL,1),(0,30599,20115,'com_liferay_dynamic_data_lists_web_portlet_DDLPortlet',NULL,1),(0,30600,20115,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet',NULL,1),(0,30601,20115,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet',NULL,1),(0,30625,20115,'com_liferay_site_navigation_breadcrumb_web_portlet_SiteNavigationBreadcrumbPortlet',NULL,1),(0,30626,20115,'com_liferay_journal_content_web_portlet_JournalContentPortlet',NULL,1),(0,30627,20115,'com_liferay_journal_content_search_web_portlet_JournalContentSearchPortlet',NULL,1),(0,30628,20115,'com_liferay_journal_web_portlet_JournalPortlet',NULL,1),(0,30629,20115,'com_liferay_marketplace_app_manager_web_portlet_MarketplaceAppManagerPortlet',NULL,1),(0,30630,20115,'com_liferay_marketplace_store_web_portlet_MarketplacePurchasedPortlet',NULL,1),(0,30631,20115,'com_liferay_marketplace_store_web_portlet_MarketplaceStorePortlet',NULL,1),(0,30632,20115,'com_liferay_invitation_invite_members_web_portlet_InviteMembersPortlet',NULL,1),(0,30633,20115,'com_liferay_microblogs_web_portlet_MicroblogsPortlet',NULL,1),(0,30634,20115,'com_liferay_microblogs_web_portlet_MicroblogsStatusUpdatePortlet',NULL,1),(0,30635,20115,'com_liferay_sync_web_portlet_SyncDevicesPortlet',NULL,1),(0,30637,20115,'com_liferay_sync_web_portlet_SyncAdminPortlet',NULL,1),(0,30638,20115,'com_liferay_wiki_navigation_web_portlet_WikiNavigationPageMenuPortlet',NULL,1),(0,30639,20115,'com_liferay_wiki_navigation_web_portlet_WikiNavigationTreeMenuPortlet',NULL,1),(0,30640,20115,'com_liferay_dynamic_data_lists_form_web_portlet_DDLFormAdminPortlet',NULL,1),(0,30641,20115,'com_liferay_dynamic_data_lists_form_web_portlet_DDLFormPortlet',NULL,1),(0,30642,20115,'com_liferay_notifications_web_portlet_NotificationsPortlet',NULL,1),(0,30644,20115,'com_liferay_site_admin_web_portlet_SiteAdminPortlet',NULL,1),(0,36601,20115,'bladespringmvc_WAR_springmvcportlet',NULL,1),(0,36701,20115,'commonfieldsselectorportlet_WAR_commonfieldsselectorportlet',NULL,1),(0,37101,20115,'mapperportlet_WAR_mapperportlet',NULL,1),(0,37726,20115,'monthlytimeseriesforcountryportlet_WAR_graphingtoolportlet',NULL,1),(0,37727,20115,'monthlytimeseriesforpointportlet_WAR_graphingtoolportlet',NULL,1),(0,37728,20115,'yearlytimeseriesforcountryportlet_WAR_graphingtoolportlet',NULL,1),(0,41101,20115,'mappergraphingportlet_WAR_mappergraphingportlet',NULL,1),(0,46701,20115,'scenarioexplorerportlet_WAR_scenarioexplorerportlet',NULL,1),(0,62861,20115,'coastalvulnerabilityportlet_WAR_coastalvulnerabilityportlet',NULL,1);

--
-- Table structure for table `PortletItem`
--

CREATE TABLE `PortletItem` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `portletItemId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `portletId` varchar(200) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`portletItemId`),
  KEY `IX_96BDD537` (`groupId`,`classNameId`),
  KEY `IX_D699243F` (`groupId`,`name`,`portletId`,`classNameId`),
  KEY `IX_E922D6C0` (`groupId`,`portletId`,`classNameId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PortletItem`
--


--
-- Table structure for table `PortletPreferences`
--

CREATE TABLE `PortletPreferences` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `portletPreferencesId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `ownerId` bigint(20) DEFAULT NULL,
  `ownerType` int(11) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  `portletId` varchar(200) DEFAULT NULL,
  `preferences` longtext DEFAULT NULL,
  PRIMARY KEY (`portletPreferencesId`),
  UNIQUE KEY `IX_C7057FF7` (`ownerId`,`ownerType`,`plid`,`portletId`),
  KEY `IX_60C49142` (`companyId`,`ownerId`,`ownerType`,`portletId`),
  KEY `IX_C9A3FCE2` (`ownerId`,`ownerType`,`portletId`),
  KEY `IX_D5EDA3A1` (`ownerType`,`plid`,`portletId`),
  KEY `IX_A3B2A80C` (`ownerType`,`portletId`),
  KEY `IX_D340DB76` (`plid`,`portletId`),
  KEY `IX_8E6DA3A1` (`portletId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `PortletPreferences`
--

INSERT INTO `PortletPreferences` VALUES (1,30470,20115,20115,1,0,'com_liferay_users_admin_web_portlet_MyOrganizationsPortlet','<portlet-preferences><preference><name>myAccountAccessInControlPanelPermissionsInitialized</name><value>true</value></preference></portlet-preferences>'),(1,30484,20115,20115,1,0,'com_liferay_portal_workflow_instance_web_portlet_MyWorkflowInstancePortlet','<portlet-preferences><preference><name>myAccountAccessInControlPanelPermissionsInitialized</name><value>true</value></preference></portlet-preferences>'),(1,30487,20115,20115,1,0,'com_liferay_portal_workflow_task_web_portlet_MyWorkflowTaskPortlet','<portlet-preferences><preference><name>myAccountAccessInControlPanelPermissionsInitialized</name><value>true</value></preference></portlet-preferences>'),(1,30498,20115,0,3,30495,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_AGNS6Bio4EfL','<portlet-preferences><preference><name>showOnlyLayoutAssets</name><value>true</value></preference></portlet-preferences>'),(1,30518,20115,20115,1,0,'com_liferay_my_account_web_portlet_MyAccountPortlet','<portlet-preferences><preference><name>myAccountAccessInControlPanelPermissionsInitialized</name><value>true</value></preference></portlet-preferences>'),(1,30566,20115,0,3,30563,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_9jKBsHurlbCh','<portlet-preferences><preference><name>portletSetupUseCustomTitle</name><value>true</value></preference><preference><name>portletSetupTitle_en_US</name><value>Recent Content</value></preference><preference><name>anyAssetType</name><value>false</value></preference></portlet-preferences>'),(1,30577,20115,0,3,30574,'com_liferay_asset_tags_navigation_web_portlet_AssetTagsNavigationPortlet_INSTANCE_5uMHYUWWsGOs','<portlet-preferences><preference><name>showAssetCount</name><value>true</value></preference><preference><name>classNameId</name><value>30202</value></preference></portlet-preferences>'),(1,30588,20115,0,3,30585,'com_liferay_asset_tags_navigation_web_portlet_AssetTagsCloudPortlet_INSTANCE_Erqk6xUFRvQb','<portlet-preferences><preference><name>displayStyle</name><value>cloud</value></preference><preference><name>showAssetCount</name><value>true</value></preference><preference><name>maxAssetTags</name><value>10</value></preference><preference><name>showZeroAssetCount</name><value>false</value></preference><preference><name>classNameId</name><value>20011</value></preference></portlet-preferences>'),(1,30615,20115,0,3,30612,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_CXyGCcLFiY16','<portlet-preferences><preference><name>portletSetupUseCustomTitle</name><value>true</value></preference><preference><name>portletSetupTitle_en_US</name><value>Recent Content</value></preference></portlet-preferences>'),(1,30619,20115,0,3,30616,'com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_4BBx7nxkBMkh','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>borderless</value></preference></portlet-preferences>'),(1,30623,20115,0,3,30620,'com_liferay_rss_web_portlet_RSSPortlet_INSTANCE_YbfUpFRwsARs','<portlet-preferences><preference><name>portletSetupUseCustomTitle</name><value>true</value></preference><preference><name>urls</name><value>http://www.nytimes.com/services/xml/rss/userland/Technology.xml</value></preference><preference><name>portletSetupTitle_en_US</name><value>Technology news</value></preference><preference><name>expandedEntriesPerFeed</name><value>3</value></preference></portlet-preferences>'),(1,30624,20115,0,3,30620,'com_liferay_rss_web_portlet_RSSPortlet_INSTANCE_Wdt6E9YkCeC9','<portlet-preferences><preference><name>portletSetupUseCustomTitle</name><value>true</value></preference><preference><name>urls</name><value>https://www.liferay.com/about-us/newsroom/press-releases/-/asset_publisher/2oZC/rss</value></preference><preference><name>portletSetupTitle_en_US</name><value>Liferay news</value></preference><preference><name>expandedEntriesPerFeed</name><value>0</value></preference><preference><name>titles</name><value>Liferay Press Releases</value></preference></portlet-preferences>'),(1,30636,20115,20115,1,0,'com_liferay_sync_web_portlet_SyncDevicesPortlet','<portlet-preferences><preference><name>myAccountAccessInControlPanelPermissionsInitialized</name><value>true</value></preference></portlet-preferences>'),(1,30643,20115,20115,1,0,'com_liferay_notifications_web_portlet_NotificationsPortlet','<portlet-preferences><preference><name>myAccountAccessInControlPanelPermissionsInitialized</name><value>true</value></preference></portlet-preferences>'),(0,30649,20115,20142,3,0,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,30651,20115,20142,3,0,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,30653,20115,20142,3,0,'com_liferay_portal_search_web_portlet_SearchPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,30655,20115,20142,3,0,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,30657,20115,0,3,20136,'com_liferay_portal_instances_web_portlet_PortalInstancesPortlet','<portlet-preferences />'),(0,30658,20115,20132,3,0,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,30659,20115,0,3,20136,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,30660,20115,0,3,20136,'com_liferay_portal_settings_web_portlet_PortalSettingsPortlet','<portlet-preferences />'),(0,30661,20115,20115,1,0,'com.liferay.portal.security.sso.opensso','<portlet-preferences><preference><name>logoutOnSessionExpiration</name><value></value></preference></portlet-preferences>'),(0,30662,20115,20115,1,0,'com.liferay.portal.security.sso.cas','<portlet-preferences><preference><name>serviceURL</name><value></value></preference></portlet-preferences>'),(0,30663,20115,20115,1,0,'com.liferay.portal.security.sso.ntlm','<portlet-preferences />'),(0,30664,20115,20115,1,0,'com.liferay.portal.security.sso.openid','<portlet-preferences />'),(0,30665,20115,20115,1,0,'com.liferay.portal.security.sso.facebook.connect','<portlet-preferences><preference><name>appId</name><value></value></preference><preference><name>appSecret</name><value></value></preference></portlet-preferences>'),(0,30666,20115,20115,1,0,'com.liferay.portal.security.sso.google.authorization','<portlet-preferences><preference><name>clientId</name><value></value></preference><preference><name>clientSecret</name><value></value></preference></portlet-preferences>'),(0,30667,20115,0,3,20136,'com_liferay_image_uploader_web_portlet_ImageUploaderPortlet','<portlet-preferences />'),(0,30901,20115,0,3,20136,'com_liferay_marketplace_store_web_portlet_MarketplaceStorePortlet','<portlet-preferences />'),(0,30902,20115,20155,4,20136,'com_liferay_marketplace_store_web_portlet_MarketplaceStorePortlet','<portlet-preferences />'),(0,30903,20115,0,3,20136,'com_liferay_marketplace_app_manager_web_portlet_MarketplaceAppManagerPortlet','<portlet-preferences />'),(0,30904,20115,20155,4,20136,'com_liferay_marketplace_app_manager_web_portlet_MarketplaceAppManagerPortlet','<portlet-preferences />'),(0,33401,20115,0,3,20136,'com_liferay_users_admin_web_portlet_UsersAdminPortlet','<portlet-preferences />'),(0,33413,20115,0,3,20136,'com_liferay_my_account_web_portlet_MyAccountPortlet','<portlet-preferences />'),(0,33414,20115,0,3,20136,'com_liferay_notifications_web_portlet_NotificationsPortlet','<portlet-preferences />'),(0,33415,20115,20158,3,0,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,33416,20115,0,3,30645,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,33417,20115,20158,3,0,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,33418,20115,0,3,30645,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,33419,20115,20158,3,0,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,33420,20115,0,3,30645,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,34024,20115,33404,3,0,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,34029,20115,33404,3,0,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,34031,20115,33404,3,0,'com_liferay_portal_search_web_portlet_SearchPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,34033,20115,33404,3,0,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,34051,20115,0,3,20136,'com_liferay_site_browser_web_portlet_SiteBrowserPortlet','<portlet-preferences />'),(0,34052,20115,0,3,20136,'com_liferay_users_admin_web_portlet_MyOrganizationsPortlet','<portlet-preferences />'),(0,34070,20115,0,3,20136,'com_liferay_roles_admin_web_portlet_RolesAdminPortlet','<portlet-preferences />'),(0,34072,20115,20158,3,0,'com_liferay_portal_search_web_portlet_SearchPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,34073,20115,0,3,30645,'com_liferay_portal_search_web_portlet_SearchPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,34084,20115,0,3,20136,'com_liferay_portlet_configuration_web_portlet_PortletConfigurationPortlet','<portlet-preferences />'),(1,34097,20115,0,3,0,'com_liferay_site_teams_web_portlet_SiteTeamsPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_site_teams_web_portlet_SiteTeamsPortlet\"/>'),(1,34098,20115,0,3,0,'com_liferay_document_library_web_portlet_DLPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_document_library_web_portlet_DLPortlet\"/>'),(1,34099,20115,0,3,0,'com_liferay_document_library_web_portlet_DLAdminPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_document_library_web_portlet_DLAdminPortlet\"/>'),(1,34100,20115,0,3,0,'com_liferay_dynamic_data_lists_web_portlet_DDLPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_dynamic_data_lists_web_portlet_DDLPortlet\"/>'),(1,34101,20115,0,3,0,'com_liferay_journal_web_portlet_JournalPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_journal_web_portlet_JournalPortlet\"/>'),(1,34102,20115,0,3,0,'com_liferay_dynamic_data_lists_form_web_portlet_DDLFormAdminPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_dynamic_data_lists_form_web_portlet_DDLFormAdminPortlet\"/>'),(1,34103,20115,0,3,0,'com_liferay_calendar_web_portlet_CalendarPortlet','<?xml version=\"1.0\"?>\n\n<portlet-preferences owner-id=\"0\" owner-type=\"3\" default-user=\"false\" plid=\"0\" portlet-id=\"com_liferay_calendar_web_portlet_CalendarPortlet\"/>'),(0,34146,20115,0,3,34143,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,34147,20115,0,3,34143,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,34148,20115,0,3,34143,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,37006,20115,0,3,20136,'com_liferay_site_admin_web_portlet_SiteAdminPortlet','<portlet-preferences />'),(0,42504,20115,0,3,42501,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,42505,20115,0,3,42501,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,42506,20115,0,3,42501,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(7,42601,20115,0,3,42501,'mappergraphingportlet_WAR_mappergraphingportlet','<portlet-preferences><preference><name>groups</name><value>Other Supply</value><value>Catchment</value><value>Groundwater</value><value>Demand Site</value><value>Wastewater Treatment Plant</value></preference><preference><name>sites</name><value>Catchment Inflow Node</value><value>Ag Farms Northern Runoff</value><value>Ag Farm Muharraq Runoff</value><value>Ag Farms Capitol Runoff</value><value>Ag Farms Southern Runoff</value><value>Ag Farms Northern Runoff</value><value>Ag Farm Muharraq Runoff</value><value>Ag Farms Capitol Runoff</value><value>Ag Farms Southern Runoff</value><value>Ag Farms Northern Runoff</value><value>Ag Farm Muharraq Runoff</value><value>Ag Farms Capitol Runoff</value><value>Ag Farms Southern Runoff</value><value>Demand Site</value><value>Indoor water use northern</value><value>Indoor Water Use Southern</value><value>Indoor Water Use Capital</value><value>Indoor water use Muharraq</value><value>Industrial RUS UER South</value><value>Industrial RUS UER North</value><value>Industrial RUS UER Capital</value><value>Industrial RUS UER Muharraq</value><value>Indoor water use northern</value><value>Indoor Water Use Southern</value><value>Indoor Water Use Capital</value><value>Indoor water use Muharraq</value><value>Industrial RUS UER South</value><value>Industrial RUS UER North</value><value>Industrial RUS UER Capital</value><value>Industrial RUS UER Muharraq</value><value>Indoor water use northern</value><value>Indoor Water Use Southern</value><value>Indoor Water Use Capital</value><value>Indoor water use Muharraq</value><value>Industrial RUS UER South</value><value>Industrial RUS UER North</value><value>Industrial RUS UER Capital</value><value>Industrial RUS UER Muharraq</value></preference></portlet-preferences>'),(3,42702,20115,0,3,42501,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20151</value></preference></portlet-preferences>'),(0,46504,20115,0,3,46501,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,46505,20115,0,3,46501,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,46506,20115,0,3,46501,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,46507,20115,0,3,46501,'commonfieldsselectorportlet_WAR_commonfieldsselectorportlet','<portlet-preferences />'),(8,46508,20115,0,3,46501,'mapperportlet_WAR_mapperportlet','<portlet-preferences><preference><name>selectedRatio</name><value>2:1</value></preference><preference><name>Temperature</name><value>tas</value><value>tasmin</value><value>tasmax</value><value>dtr</value><value>sd</value><value>tr</value><value>tr26</value><value>txx</value><value>tnn</value><value>wsdi</value><value>csdi</value><value>gsl</value><value>hd30</value><value>hd35</value><value>hd38</value><value>hd40</value><value>hd42</value><value>hd45</value><value>hi35</value><value>hi37</value><value>hi39</value><value>cdd65</value><value>hdd65</value><value>spei12</value><value>heatwavedays95pbcdp</value></preference><preference><name>defaultVariableValue</name><value></value></preference><preference><name>Heat</name><value>tasmax</value><value>sd</value><value>tr</value><value>tr26</value><value>txx</value><value>wsdi</value><value>hd30</value><value>hd35</value><value>hd38</value><value>hd40</value><value>hd42</value><value>hd45</value><value>hi35</value><value>hi37</value><value>hi39</value><value>cdd65</value><value>cdd</value><value>heatwavedays95pbcdp</value><value>windspeedlow</value></preference><preference><name>Precipitation</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>selectedVariables</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>selectedNarrative</name><value>None</value></preference></portlet-preferences>'),(3,46509,20115,0,3,46501,'monthlytimeseriesforcountryportlet_WAR_graphingtoolportlet_INSTANCE_GG0aQPPhgMzq','<portlet-preferences><preference><name>Temperature</name><value>tas</value><value>tasmin</value><value>tasmax</value><value>dtr</value><value>fd</value><value>sd</value><value>id</value><value>tr</value><value>tr26</value><value>txx</value><value>tnn</value><value>wsdi</value><value>csdi</value><value>gsl</value><value>hd30</value><value>hd35</value><value>hd38</value><value>hd40</value><value>hd42</value><value>hd45</value><value>hi35</value><value>hi37</value><value>hi39</value><value>cdd65</value><value>hdd65</value><value>spei12</value><value>heatwavedays95pbcdp</value><value>coldwavedays5pbcdp</value><value>spei12severedroughtbcap</value><value>bioclim01</value></preference><preference><name>Precipitation</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>selectedVariables</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>defaultVariableValue</name><value></value></preference><preference><name>Flooding</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cwd</value></preference><preference><name>selectedNarrative</name><value>None</value></preference></portlet-preferences>'),(2,46510,20115,0,3,46501,'boxplotforcountryportlet_WAR_graphingtoolportlet_INSTANCE_ZVoyv1v50fzL','<portlet-preferences><preference><name>Temperature</name><value>tas</value><value>tasmin</value><value>tasmax</value><value>dtr</value><value>fd</value><value>sd</value><value>id</value><value>tr</value><value>tr26</value><value>txx</value><value>tnn</value><value>wsdi</value><value>csdi</value><value>gsl</value><value>hd30</value><value>hd35</value><value>hd38</value><value>hd40</value><value>hd42</value><value>hd45</value><value>hi35</value><value>hi37</value><value>hi39</value><value>cdd65</value><value>hdd65</value><value>spei12</value><value>heatwavedays95pbcdp</value><value>coldwavedays5pbcdp</value><value>spei12severedroughtbcap</value><value>bioclim01</value></preference><preference><name>Precipitation</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>selectedVariables</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>defaultVariableValue</name><value></value></preference><preference><name>selectedNarrative</name><value>None</value></preference></portlet-preferences>'),(2,46511,20115,0,3,46501,'yearlytimeseriesforcountryportlet_WAR_graphingtoolportlet_INSTANCE_OdxUdeTR80FO','<portlet-preferences><preference><name>Temperature</name><value>tas</value><value>tasmin</value><value>tasmax</value><value>dtr</value><value>fd</value><value>sd</value><value>id</value><value>tr</value><value>tr26</value><value>txx</value><value>tnn</value><value>wsdi</value><value>csdi</value><value>gsl</value><value>hd30</value><value>hd35</value><value>hd38</value><value>hd40</value><value>hd42</value><value>hd45</value><value>hi35</value><value>hi37</value><value>hi39</value><value>cdd65</value><value>hdd65</value><value>spei12</value><value>heatwavedays95pbcdp</value><value>coldwavedays5pbcdp</value><value>spei12severedroughtbcap</value><value>bioclim01</value></preference><preference><name>Precipitation</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>selectedVariables</name><value>pr</value><value>rx1day</value><value>rx5day</value><value>spei12</value><value>rx1dayreturnlevel10</value><value>rx1dayreturnlevel25</value><value>rx5dayreturnlevel10</value><value>rx5dayreturnlevel25</value><value>rxmonthreturnlevel10</value><value>rxmonthreturnlevel25</value><value>r1mm</value><value>r10mm</value><value>r20mm</value><value>r50mm</value><value>sdii</value><value>r95ptot</value><value>r99ptot</value><value>prcptot</value><value>cdd</value><value>cwd</value><value>spei12severedroughtbcap</value></preference><preference><name>defaultVariableValue</name><value></value></preference><preference><name>selectedNarrative</name><value>None</value></preference></portlet-preferences>'),(0,46604,20115,0,3,46601,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,46605,20115,0,3,46601,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,46606,20115,0,3,46601,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(3,46702,20115,0,3,46501,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20151</value></preference></portlet-preferences>'),(2,46811,20115,0,3,30645,'com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_IBdsI9YvtwwL','<portlet-preferences><preference><name>portletSetupUseCustomTitle</name><value>true</value></preference><preference><name>showActions</name><value>true</value></preference><preference><name>lfrScopeType</name><value>company</value></preference><preference><name>lfrScopeLayoutUuid</name><value></value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>rootFolderId</name><value>0</value></preference><preference><name>fileEntryColumns</name></preference><preference><name>displayViews</name><value>icon</value><value>descriptive</value><value>list</value></preference><preference><name>folderColumns</name></preference><preference><name>mimeTypes</name></preference><preference><name>portletSetupTitle_en_US</name><value>Documents and Media (Global)</value></preference><preference><name>entryColumns</name><value>name</value><value>size</value><value>status</value><value>modified-date</value><value>create-date</value><value>action</value><value>action</value></preference><preference><name>showTabs</name><value>true</value></preference></portlet-preferences>'),(1,46841,20115,0,3,34143,'com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_uSI4Em7EBa1b','<portlet-preferences><preference><name>mimeTypes</name></preference><preference><name>showActions</name><value>true</value></preference><preference><name>entryColumns</name><value>name</value><value>size</value><value>status</value><value>modified-date</value><value>create-date</value><value>action</value><value>action</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>rootFolderId</name><value>0</value></preference><preference><name>fileEntryColumns</name></preference><preference><name>displayViews</name><value>icon</value><value>descriptive</value><value>list</value></preference><preference><name>folderColumns</name></preference></portlet-preferences>'),(0,46882,20115,0,3,46879,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,46883,20115,0,3,46879,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,46884,20115,0,3,46879,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(3,46886,20115,0,3,46879,'com_liferay_document_library_web_portlet_DLPortlet_INSTANCE_a8f1QTBrE8j2','<portlet-preferences><preference><name>showActions</name><value>true</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>rootFolderId</name><value>0</value></preference><preference><name>fileEntryColumns</name></preference><preference><name>displayViews</name><value>icon</value><value>descriptive</value><value>list</value></preference><preference><name>folderColumns</name></preference><preference><name>mimeTypes</name></preference><preference><name>showFoldersSearch</name><value>true</value></preference><preference><name>entryColumns</name><value>name</value><value>size</value><value>status</value><value>modified-date</value><value>create-date</value><value>action</value><value>action</value></preference></portlet-preferences>'),(0,47101,20115,0,3,20136,'com_liferay_sync_web_portlet_SyncDevicesPortlet','<portlet-preferences />'),(0,47102,20115,20158,2,0,'com_liferay_document_library_web_portlet_DLAdminPortlet','<portlet-preferences />'),(3,49207,20115,0,3,46879,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>ar_BH,en_US</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20151</value></preference></portlet-preferences>'),(3,50101,20115,0,3,46601,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20151</value></preference></portlet-preferences>'),(398,55102,20115,0,3,46601,'scenarioexplorerportlet_WAR_scenarioexplorerportlet','<portlet-preferences><preference><name>s2_wateruse_bah</name><value>10</value></preference><preference><name>s1_wateruse_start</name><value>2025</value></preference><preference><name>s1_wateruse_non_bah</name><value>0</value></preference><preference><name>s2_ar_ir</name><value>0</value></preference><preference><name>s4_com_ind</name><value>0</value></preference><preference><name>s4_pop_proj</name><value>;Median_Pop_Projection</value></preference><preference><name>s1</name><value>S1</value></preference><preference><name>s1_cap_add</name><value>0</value></preference><preference><name>s2</name><value>S2</value></preference><preference><name>s3</name><value>S3</value></preference><preference><name>s3_wateruse_non_bah</name><value>0</value></preference><preference><name>s4</name><value>S4</value></preference><preference><name>s4_wateruse_start</name><value>2025</value></preference><preference><name>s2_wateruse_end</name><value>2030</value></preference><preference><name>s4_year_exp</name><value>2025</value></preference><preference><name>s1_wateruse_end</name><value>2030</value></preference><preference><name>s1_cl_proj</name><value>;Historic.csv</value></preference><preference><name>s3_wateruse_bah</name><value>0</value></preference><preference><name>s1_wateruse_bah</name><value>0</value></preference><preference><name>s2_cap_add</name><value>0</value></preference><preference><name>s1_com_ind</name><value>0</value></preference><preference><name>s4_wtr_loss</name><value>28</value></preference><preference><name>s3_pop_proj</name><value>;Median_Pop_Projection</value></preference><preference><name>s4_cl_proj</name><value>;Historic.csv</value></preference><preference><name>s2_wtr_loss</name><value>28</value></preference><preference><name>s1_year_exp</name><value>2025</value></preference><preference><name>s1_ar_ir</name><value>0</value></preference><preference><name>fav_res_10</name><value>Annual Dammam withdrawals (Million m3)</value></preference><preference><name>s2_wateruse_non_bah</name><value>0</value></preference><preference><name>fav_res_7</name><value>Per Capita Freshwater Demand (LPCD)</value></preference><preference><name>fav_res_9</name><value>Rus UER reserves (Billion m3)</value></preference><preference><name>s3_cap_add</name><value>0</value></preference><preference><name>s4_wateruse_bah</name><value>0</value></preference><preference><name>s2_com_ind</name><value>0</value></preference><preference><name>s2_year_exp</name><value>2025</value></preference><preference><name>s3_wateruse_start</name><value>2025</value></preference><preference><name>s1_pop_proj</name><value>;Upper_80_Pop_Projection</value></preference><preference><name>s3_wtr_loss</name><value>28</value></preference><preference><name>s3_year_exp</name><value>2025</value></preference><preference><name>s3_cl_proj</name><value>;Historic.csv</value></preference><preference><name>s3_wateruse_end</name><value>2030</value></preference><preference><name>s4_wateruse_end</name><value>2030</value></preference><preference><name>s3_ar_ir</name><value>1</value></preference><preference><name>s1_wtr_loss</name><value>28</value></preference><preference><name>s4_ar_ir</name><value>0</value></preference><preference><name>s3_com_ind</name><value>0</value></preference><preference><name>s4_cap_add</name><value>0</value></preference><preference><name>s2_wateruse_start</name><value>2025</value></preference><preference><name>s4_wateruse_non_bah</name><value>0</value></preference><preference><name>s2_pop_proj</name><value>;Upper_95_Pop_Projection</value></preference><preference><name>s2_cl_proj</name><value>;Historic.csv</value></preference><preference><name>end_year</name><value>2050</value></preference></portlet-preferences>'),(0,57407,20115,20142,2,0,'com_liferay_document_library_web_portlet_DLAdminPortlet','<portlet-preferences />'),(0,61209,20115,0,3,61206,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61210,20115,0,3,61206,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,61211,20115,0,3,61206,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,61215,20115,0,3,61212,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61216,20115,0,3,61212,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(3,61217,20115,0,3,61212,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupUseCustomTitle</name><value>false</value></preference><preference><name>portletSetupLinkToLayoutUuid</name><value>35e11d22-bd4c-8588-116e-2adeda6433e3</value></preference><preference><name>portletSetupCss</name><value>{&#34;textData&#34;:{&#34;fontFamily&#34;:&#34;&#34;,&#34;color&#34;:&#34;&#34;,&#34;textAlign&#34;:&#34;&#34;,&#34;wordSpacing&#34;:&#34;&#34;,&#34;letterSpacing&#34;:&#34;&#34;,&#34;fontSize&#34;:&#34;&#34;,&#34;lineHeight&#34;:&#34;&#34;,&#34;textDecoration&#34;:&#34;&#34;,&#34;fontStyle&#34;:&#34;&#34;,&#34;fontWeight&#34;:&#34;&#34;},&#34;spacingData&#34;:{&#34;padding&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;bottom&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;right&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;sameForAll&#34;:true},&#34;margin&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;bottom&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;right&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;sameForAll&#34;:true}},&#34;borderData&#34;:{&#34;borderColor&#34;:{&#34;top&#34;:&#34;&#34;,&#34;left&#34;:&#34;&#34;,&#34;bottom&#34;:&#34;&#34;,&#34;right&#34;:&#34;&#34;,&#34;sameForAll&#34;:true},&#34;borderWidth&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;bottom&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;right&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;sameForAll&#34;:true},&#34;borderStyle&#34;:{&#34;top&#34;:&#34;&#34;,&#34;left&#34;:&#34;&#34;,&#34;bottom&#34;:&#34;&#34;,&#34;right&#34;:&#34;&#34;,&#34;sameForAll&#34;:true}},&#34;bgData&#34;:{&#34;backgroundColor&#34;:&#34;&#34;,&#34;useBgImage&#34;:false,&#34;backgroundImage&#34;:&#34;&#34;,&#34;backgroundPosition&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;}},&#34;backgroundRepeat&#34;:&#34;&#34;},&#34;defaultPortletTitles&#34;:{&#34;ar_SA&#34;:&#34;Navigation Menu&#34;,&#34;en_US&#34;:&#34;Navigation Menu&#34;,&#34;ar_BH&#34;:&#34;Navigation Menu&#34;,&#34;es_ES&#34;:&#34;Menú de navegación&#34;,&#34;fr_FR&#34;:&#34;Menu de navigation&#34;,&#34;de_DE&#34;:&#34;Navigationsmenü&#34;},&#34;advancedData&#34;:{&#34;customCSSClassName&#34;:&#34;&#34;,&#34;customCSS&#34;:&#34;&#34;}}</value></preference><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,61221,20115,0,3,61218,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61222,20115,0,3,61218,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,61223,20115,0,3,61218,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,61227,20115,0,3,61224,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61228,20115,0,3,61224,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,61229,20115,0,3,61224,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,61233,20115,0,3,61230,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61234,20115,0,3,61230,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,61235,20115,0,3,61230,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,61239,20115,0,3,61236,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61240,20115,0,3,61236,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,61241,20115,0,3,61236,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(0,61904,20115,0,3,61901,'com_liferay_product_navigation_product_menu_web_portlet_ProductMenuPortlet','<portlet-preferences />'),(0,61905,20115,0,3,61901,'com_liferay_product_navigation_user_personal_bar_web_portlet_ProductNavigationUserPersonalBarPortlet','<portlet-preferences />'),(0,61906,20115,0,3,61901,'com_liferay_site_navigation_menu_web_portlet_SiteNavigationMenuPortlet','<portlet-preferences><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference></portlet-preferences>'),(8,62849,20115,0,3,61901,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_wNYnYdfAW97Y','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>classTypeIdsJournalArticleAssetRendererFactory</name><value>30416</value></preference><preference><name>queryName0</name><value>assetTags</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>orderByColumn2</name><value>title</value></preference><preference><name>orderByColumn1</name><value>modifiedDate</value></preference><preference><name>extensions</name></preference><preference><name>subtypeFieldsFilterEnabledDLFileEntryAssetRendererFactory</name><value>false</value></preference><preference><name>ddmStructureFieldName</name><value></value></preference><preference><name>showOnlyLayoutAssets</name><value>false</value></preference><preference><name>queryContains0</name><value>true</value></preference><preference><name>classNameIds</name></preference><preference><name>queryAndOperator0</name><value>false</value></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>customUserAttributes</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;3dd0c64d-d927-2fd6-71e3-b4e0f6f7fb22&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>orderByType1</name><value>DESC</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>orderByType2</name><value>ASC</value></preference><preference><name>paginationType</name><value>none</value></preference><preference><name>assetVocabularyId</name><value></value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>portletSetupCss</name><value>{&#34;textData&#34;:{&#34;fontFamily&#34;:&#34;&#34;,&#34;color&#34;:&#34;&#34;,&#34;textAlign&#34;:&#34;&#34;,&#34;wordSpacing&#34;:&#34;&#34;,&#34;letterSpacing&#34;:&#34;&#34;,&#34;fontSize&#34;:&#34;&#34;,&#34;lineHeight&#34;:&#34;&#34;,&#34;textDecoration&#34;:&#34;&#34;,&#34;fontStyle&#34;:&#34;&#34;,&#34;fontWeight&#34;:&#34;&#34;},&#34;spacingData&#34;:{&#34;padding&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;bottom&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;right&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;sameForAll&#34;:true},&#34;margin&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;bottom&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;right&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;sameForAll&#34;:true}},&#34;borderData&#34;:{&#34;borderColor&#34;:{&#34;top&#34;:&#34;&#34;,&#34;left&#34;:&#34;&#34;,&#34;bottom&#34;:&#34;&#34;,&#34;right&#34;:&#34;&#34;,&#34;sameForAll&#34;:true},&#34;borderWidth&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;bottom&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;right&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;sameForAll&#34;:true},&#34;borderStyle&#34;:{&#34;top&#34;:&#34;&#34;,&#34;left&#34;:&#34;&#34;,&#34;bottom&#34;:&#34;&#34;,&#34;right&#34;:&#34;&#34;,&#34;sameForAll&#34;:true}},&#34;bgData&#34;:{&#34;backgroundColor&#34;:&#34;&#34;,&#34;useBgImage&#34;:false,&#34;backgroundImage&#34;:&#34;&#34;,&#34;backgroundPosition&#34;:{&#34;top&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;},&#34;left&#34;:{&#34;unit&#34;:&#34;px&#34;,&#34;value&#34;:&#34;&#34;}},&#34;backgroundRepeat&#34;:&#34;&#34;},&#34;defaultPortletTitles&#34;:{&#34;ar_SA&#34;:&#34;ناشر الأصول&#34;,&#34;en_US&#34;:&#34;Asset Publisher&#34;,&#34;ar_BH&#34;:&#34;ناشر الأصول&#34;,&#34;es_ES&#34;:&#34;Publicador de contenidos&#34;,&#34;fr_FR&#34;:&#34;Agrégateur de contenus&#34;,&#34;de_DE&#34;:&#34;Asset Publisher&#34;},&#34;advancedData&#34;:{&#34;customCSSClassName&#34;:&#34;&#34;,&#34;customCSS&#34;:&#34;&#34;}}</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>anyAssetType</name><value>28706</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabledJournalArticleAssetRendererFactory</name><value>false</value></preference><preference><name>portletSetupPortletDecoratorId</name><value>barebone</value></preference><preference><name>queryValues0</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showMetadataDescriptions</name><value>true</value></preference><preference><name>showAddContentButton</name><value>false</value></preference><preference><name>classTypeIds</name><value>NULL_VALUE</value></preference><preference><name>portletSetupUseCustomTitle</name><value>false</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>mergeUrlTags</name><value>true</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classTypeIdsDLFileEntryAssetRendererFactory</name><value>0,30431,30436,30442,30448</value></preference><preference><name>anyClassTypeJournalArticleAssetRendererFactory</name><value>30416</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>anyClassTypeDLFileEntryAssetRendererFactory</name><value>true</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>ddmStructureFieldValue</name><value></value></preference><preference><name>ddmStructureDisplayFieldValue</name><value></value></preference></portlet-preferences>'),(1,62850,20115,0,3,61901,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference></portlet-preferences>'),(4,62851,20115,0,3,61230,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_DHKSPfC5NPM4','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>true</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;3e09782c-8c5d-de3f-fdfd-84686a5fcbe3&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>paginationType</name><value>none</value></preference></portlet-preferences>'),(1,62852,20115,0,3,61230,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference></portlet-preferences>'),(1,62853,20115,0,3,61218,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference></portlet-preferences>'),(4,62854,20115,0,3,61218,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_goNyFMAV35Ca','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>true</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;3452b82e-9288-8fbf-84c7-405fb6aefc21&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>paginationType</name><value>none</value></preference></portlet-preferences>'),(1,62855,20115,0,3,61224,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference></portlet-preferences>'),(3,62856,20115,0,3,61224,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_7jYkm53QVNcy','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;38e390a2-ab0c-3863-69b2-b002df5c241a&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>paginationType</name><value>none</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>false</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference></portlet-preferences>'),(3,62859,20115,0,3,46601,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_L1gGTEdFdwEF','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;49bd3f31-f726-b17b-9070-ce74104b36f7&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>paginationType</name><value>none</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>false</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference></portlet-preferences>'),(5,62860,20115,0,3,42501,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_0KqjwMcGQnYl','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>false</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;40e3562c-fc4d-192c-42cf-29a69a658fd8&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>paginationType</name><value>none</value></preference></portlet-preferences>'),(1,62862,20115,0,3,61236,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference></portlet-preferences>'),(0,62863,20115,0,3,61236,'coastalvulnerabilityportlet_WAR_coastalvulnerabilityportlet','<portlet-preferences />'),(3,62917,20115,0,3,61236,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_QNrhdq9ZKqeO','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;95a8bd99-2d93-c208-4453-1498199bcb49&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>paginationType</name><value>none</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>true</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference></portlet-preferences>'),(0,63001,20115,0,3,20136,'com_liferay_layout_admin_web_portlet_GroupPagesPortlet','<portlet-preferences />'),(3,63101,20115,0,3,61212,'com_liferay_asset_publisher_web_portlet_AssetPublisherPortlet_INSTANCE_5jLHYOsaEKIg','<portlet-preferences><preference><name>enableComments</name><value>false</value></preference><preference><name>enableRelatedAssets</name><value>false</value></preference><preference><name>subtypeFieldsFilterEnabled</name><value>false</value></preference><preference><name>enableViewCountIncrement</name><value>true</value></preference><preference><name>delta</name><value>20</value></preference><preference><name>showExtraInfo</name><value>false</value></preference><preference><name>showAvailableLocales</name><value>false</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference><preference><name>assetLinkBehavior</name><value>showFullContent</value></preference><preference><name>selectionStyle</name><value>manual</value></preference><preference><name>displayStyle</name><value>full-content</value></preference><preference><name>enableSocialBookmarks</name><value>false</value></preference><preference><name>enablePermissions</name><value>true</value></preference><preference><name>enableRss</name><value>false</value></preference><preference><name>socialBookmarksDisplayStyle</name><value>menu</value></preference><preference><name>classNameIds</name></preference><preference><name>emailAssetEntryAddedEnabled</name><value>false</value></preference><preference><name>enableTagBasedNavigation</name><value>false</value></preference><preference><name>metadataFields</name><value></value></preference><preference><name>showContextLink</name><value>false</value></preference><preference><name>showQueryLogic</name><value>false</value></preference><preference><name>enableCommentRatings</name><value>false</value></preference><preference><name>emailFromAddress</name><value>tatiana@ucar.edu</value></preference><preference><name>enableRatings</name><value>false</value></preference><preference><name>enablePrint</name><value>false</value></preference><preference><name>assetEntryXml</name><value>&lt;?xml version=&#34;1.0&#34;?&gt;[$NEW_LINE$][$NEW_LINE$]&lt;asset-entry&gt;[$NEW_LINE$]	&lt;asset-entry-type&gt;com.liferay.journal.model.JournalArticle&lt;/asset-entry-type&gt;[$NEW_LINE$]	&lt;asset-entry-uuid&gt;f447807f-1a72-4fe0-c65f-2b3e309d710d&lt;/asset-entry-uuid&gt;[$NEW_LINE$]&lt;/asset-entry&gt;</value></preference><preference><name>socialBookmarksDisplayPosition</name><value>bottom</value></preference><preference><name>showAssetTitle</name><value>false</value></preference><preference><name>extensions</name></preference><preference><name>emailFromName</name><value>Tatiana Burek</value></preference><preference><name>paginationType</name><value>none</value></preference><preference><name>abstractLength</name><value>200</value></preference><preference><name>showMetadataDescriptions</name><value>true</value></preference><preference><name>enableFlags</name><value>false</value></preference><preference><name>showAddContentButton</name><value>false</value></preference></portlet-preferences>'),(1,63102,20115,0,3,61212,'com_liferay_site_navigation_language_web_portlet_SiteNavigationLanguagePortlet','<portlet-preferences><preference><name>displayStyle</name><value>ddmTemplate_LANGUAGE-ICON-FTL</value></preference><preference><name>languageIds</name><value>en_US,ar_BH</value></preference><preference><name>displayCurrentLocale</name><value>true</value></preference><preference><name>displayStyleGroupId</name><value>20142</value></preference></portlet-preferences>'),(0,63201,20115,0,3,20136,'com_liferay_monitoring_web_portlet_MonitoringPortlet','<portlet-preferences />'),(0,63202,20115,20142,3,0,'com_liferay_staging_configuration_web_portlet_StagingConfigurationPortlet','<portlet-preferences />'),(0,63203,20115,0,3,20136,'com_liferay_staging_configuration_web_portlet_StagingConfigurationPortlet','<portlet-preferences />'),(0,63205,20115,0,3,20136,'com_liferay_configuration_admin_web_portlet_SystemSettingsPortlet','<portlet-preferences />'),(0,63206,20115,0,3,20136,'com_liferay_plugins_admin_web_portlet_PluginsAdminPortlet','<portlet-preferences />'),(0,63207,20115,0,3,20136,'com_liferay_server_admin_web_portlet_ServerAdminPortlet','<portlet-preferences />');

--
-- Table structure for table `RatingsEntry`
--

CREATE TABLE `RatingsEntry` (
  `uuid_` varchar(75) DEFAULT NULL,
  `entryId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `userName` varchar(75) DEFAULT NULL,
  `createDate` datetime(6) DEFAULT NULL,
  `modifiedDate` datetime(6) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `score` double DEFAULT NULL,
  PRIMARY KEY (`entryId`),
  UNIQUE KEY `IX_B47E3C11` (`userId`,`classNameId`,`classPK`),
  KEY `IX_A1A8CB8B` (`classNameId`,`classPK`,`score`),
  KEY `IX_9F242DF6` (`uuid_`,`companyId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `RatingsEntry`
--


--
-- Table structure for table `RatingsStats`
--

CREATE TABLE `RatingsStats` (
  `statsId` bigint(20) NOT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `classNameId` bigint(20) DEFAULT NULL,
  `classPK` bigint(20) DEFAULT NULL,
  `totalEntries` int(11) DEFAULT NULL,
  `totalScore` double DEFAULT NULL,
  `averageScore` double DEFAULT NULL,
  PRIMARY KEY (`statsId`),
  UNIQUE KEY `IX_A6E99284` (`classNameId`,`classPK`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `RatingsStats`
--


--
-- Table structure for table `RecentLayoutBranch`
--

CREATE TABLE `RecentLayoutBranch` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `recentLayoutBranchId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `layoutBranchId` bigint(20) DEFAULT NULL,
  `layoutSetBranchId` bigint(20) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`recentLayoutBranchId`),
  UNIQUE KEY `IX_C27D6369` (`userId`,`layoutSetBranchId`,`plid`),
  KEY `IX_B91F79BD` (`groupId`),
  KEY `IX_351E86E8` (`layoutBranchId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `RecentLayoutBranch`
--


--
-- Table structure for table `RecentLayoutRevision`
--

CREATE TABLE `RecentLayoutRevision` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `recentLayoutRevisionId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `layoutRevisionId` bigint(20) DEFAULT NULL,
  `layoutSetBranchId` bigint(20) DEFAULT NULL,
  `plid` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`recentLayoutRevisionId`),
  UNIQUE KEY `IX_4C600BD0` (`userId`,`layoutSetBranchId`,`plid`),
  KEY `IX_8D8A2724` (`groupId`),
  KEY `IX_DA0788DA` (`layoutRevisionId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `RecentLayoutRevision`
--


--
-- Table structure for table `RecentLayoutSetBranch`
--

CREATE TABLE `RecentLayoutSetBranch` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `recentLayoutSetBranchId` bigint(20) NOT NULL,
  `groupId` bigint(20) DEFAULT NULL,
  `companyId` bigint(20) DEFAULT NULL,
  `userId` bigint(20) DEFAULT NULL,
  `layoutSetBranchId` bigint(20) DEFAULT NULL,
  `layoutSetId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`recentLayoutSetBranchId`),
  UNIQUE KEY `IX_4654D204` (`userId`,`layoutSetId`),
  KEY `IX_711995A5` (`groupId`),
  KEY `IX_23FF0700` (`layoutSetBranchId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `RecentLayoutSetBranch`
--


--
-- Table structure for table `Region`
--

CREATE TABLE `Region` (
  `mvccVersion` bigint(20) NOT NULL DEFAULT 0,
  `regionId` bigint(20) NOT NULL,
  `countryId` bigint(20) DEFAULT NULL,
  `regionCode` varchar(75) DEFAULT NULL,
  `name` varchar(75) DEFAULT NULL,
  `active_` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`regionId`),
  UNIQUE KEY `IX_A2635F5C` (`countryId`,`regionCode`),
  KEY `IX_2D9A426F` (`active_`),
  KEY `IX_11FB3E42` (`countryId`,`active_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `Region`
--

INSERT INTO `Region` VALUES (0,1001,1,'AB','Alberta',1),(0,1002,1,'BC','British Columbia',1),(0,1003,1,'MB','Manitoba',1),(0,1004,1,'NB','New Brunswick',1),(0,1005,1,'NL','Newfoundland and Labrador',1),(0,1006,1,'NT','Northwest Territories',1),(0,1007,1,'NS','Nova Scotia',1),(0,1008,1,'NU','Nunavut',1),(0,1009,1,'ON','Ontario',1),(0,1010,1,'PE','Prince Edward Island',1),(0,1011,1,'QC','Quebec',1),(0,1012,1,'SK','Saskatchewan',1),(0,1013,1,'YT','Yukon',1),(0,2001,2,'CN-34','Anhui',1),(0,2002,2,'CN-92','Aomen',1),(0,2003,2,'CN-11','Beijing',1),(0,2004,2,'CN-50','Chongqing',1),(0,2005,2,'CN-35','Fujian',1),(0,2006,2,'CN-62','Gansu',1),(0,2007,2,'CN-44','Guangdong',1),(0,2008,2,'CN-45','Guangxi',1),(0,2009,2,'CN-52','Guizhou',1),(0,2010,2,'CN-46','Hainan',1),(0,2011,2,'CN-13','Hebei',1),(0,2012,2,'CN-23','Heilongjiang',1),(0,2013,2,'CN-41','Henan',1),(0,2014,2,'CN-42','Hubei',1),(0,2015,2,'CN-43','Hunan',1),(0,2016,2,'CN-32','Jiangsu',1),(0,2017,2,'CN-36','Jiangxi',1),(0,2018,2,'CN-22','Jilin',1),(0,2019,2,'CN-21','Liaoning',1),(0,2020,2,'CN-15','Nei Mongol',1),(0,2021,2,'CN-64','Ningxia',1),(0,2022,2,'CN-63','Qinghai',1),(0,2023,2,'CN-61','Shaanxi',1),(0,2024,2,'CN-37','Shandong',1),(0,2025,2,'CN-31','Shanghai',1),(0,2026,2,'CN-14','Shanxi',1),(0,2027,2,'CN-51','Sichuan',1),(0,2028,2,'CN-71','Taiwan',1),(0,2029,2,'CN-12','Tianjin',1),(0,2030,2,'CN-91','Xianggang',1),(0,2031,2,'CN-65','Xinjiang',1),(0,2032,2,'CN-54','Xizang',1),(0,2033,2,'CN-53','Yunnan',1),(0,2034,2,'CN-33','Zhejiang',1),(0,3001,3,'A','Alsace',1),(0,3002,3,'B','Aquitaine',1),(0,3003,3,'C','Auvergne',1),(0,3004,3,'P','Basse-Normandie',1),(0,3005,3,'D','Bourgogne',1),(0,3006,3,'E','Bretagne',1),(0,3007,3,'F','Centre',1),(0,3008,3,'G','Champagne-Ardenne',1),(0,3009,3,'H','Corse',1),(0,3010,3,'GF','Guyane',1),(0,3011,3,'I','Franche Comté',1),(0,3012,3,'GP','Guadeloupe',1),(0,3013,3,'Q','Haute-Normandie',1),(0,3014,3,'J','Île-de-France',1),(0,3015,3,'K','Languedoc-Roussillon',1),(0,3016,3,'L','Limousin',1),(0,3017,3,'M','Lorraine',1),(0,3018,3,'MQ','Martinique',1),(0,3019,3,'N','Midi-Pyrénées',1),(0,3020,3,'O','Nord Pas de Calais',1),(0,3021,3,'R','Pays de la Loire',1),(0,3022,3,'S','Picardie',1),(0,3023,3,'T','Poitou-Charentes',1),(0,3024,3,'U','Provence-Alpes-Côte-d\'Azur',1),(0,3025,3,'RE','Réunion',1),(0,3026,3,'V','Rhône-Alpes',1),(0,4001,4,'BW','Baden-Württemberg',1),(0,4002,4,'BY','Bayern',1),(0,4003,4,'BE','Berlin',1),(0,4004,4,'BB','Brandenburg',1),(0,4005,4,'HB','Bremen',1),(0,4006,4,'HH','Hamburg',1),(0,4007,4,'HE','Hessen',1),(0,4008,4,'MV','Mecklenburg-Vorpommern',1),(0,4009,4,'NI','Niedersachsen',1),(0,4010,4,'NW','Nordrhein-Westfalen',1),(0,4011,4,'RP','Rheinland-Pfalz',1),(0,4012,4,'SL','Saarland',1),(0,4013,4,'SN','Sachsen',1),(0,4014,4,'ST','Sachsen-Anhalt',1),(0,4015,4,'SH','Schleswig-Holstein',1),(0,4016,4,'TH','Thüringen',1),(0,8001,8,'AG','Agrigento',1),(0,8002,8,'AL','Alessandria',1),(0,8003,8,'AN','Ancona',1),(0,8004,8,'AO','Aosta',1),(0,8005,8,'AR','Arezzo',1),(0,8006,8,'AP','Ascoli Piceno',1),(0,8007,8,'AT','Asti',1),(0,8008,8,'AV','Avellino',1),(0,8009,8,'BA','Bari',1),(0,8010,8,'BT','Barletta-Andria-Trani',1),(0,8011,8,'BL','Belluno',1),(0,8012,8,'BN','Benevento',1),(0,8013,8,'BG','Bergamo',1),(0,8014,8,'BI','Biella',1),(0,8015,8,'BO','Bologna',1),(0,8016,8,'BZ','Bolzano',1),(0,8017,8,'BS','Brescia',1),(0,8018,8,'BR','Brindisi',1),(0,8019,8,'CA','Cagliari',1),(0,8020,8,'CL','Caltanissetta',1),(0,8021,8,'CB','Campobasso',1),(0,8022,8,'CI','Carbonia-Iglesias',1),(0,8023,8,'CE','Caserta',1),(0,8024,8,'CT','Catania',1),(0,8025,8,'CZ','Catanzaro',1),(0,8026,8,'CH','Chieti',1),(0,8027,8,'CO','Como',1),(0,8028,8,'CS','Cosenza',1),(0,8029,8,'CR','Cremona',1),(0,8030,8,'KR','Crotone',1),(0,8031,8,'CN','Cuneo',1),(0,8032,8,'EN','Enna',1),(0,8033,8,'FM','Fermo',1),(0,8034,8,'FE','Ferrara',1),(0,8035,8,'FI','Firenze',1),(0,8036,8,'FG','Foggia',1),(0,8037,8,'FC','Forli-Cesena',1),(0,8038,8,'FR','Frosinone',1),(0,8039,8,'GE','Genova',1),(0,8040,8,'GO','Gorizia',1),(0,8041,8,'GR','Grosseto',1),(0,8042,8,'IM','Imperia',1),(0,8043,8,'IS','Isernia',1),(0,8044,8,'AQ','L\'Aquila',1),(0,8045,8,'SP','La Spezia',1),(0,8046,8,'LT','Latina',1),(0,8047,8,'LE','Lecce',1),(0,8048,8,'LC','Lecco',1),(0,8049,8,'LI','Livorno',1),(0,8050,8,'LO','Lodi',1),(0,8051,8,'LU','Lucca',1),(0,8052,8,'MC','Macerata',1),(0,8053,8,'MN','Mantova',1),(0,8054,8,'MS','Massa-Carrara',1),(0,8055,8,'MT','Matera',1),(0,8056,8,'MA','Medio Campidano',1),(0,8057,8,'ME','Messina',1),(0,8058,8,'MI','Milano',1),(0,8059,8,'MO','Modena',1),(0,8060,8,'MB','Monza e Brianza',1),(0,8061,8,'NA','Napoli',1),(0,8062,8,'NO','Novara',1),(0,8063,8,'NU','Nuoro',1),(0,8064,8,'OG','Ogliastra',1),(0,8065,8,'OT','Olbia-Tempio',1),(0,8066,8,'OR','Oristano',1),(0,8067,8,'PD','Padova',1),(0,8068,8,'PA','Palermo',1),(0,8069,8,'PR','Parma',1),(0,8070,8,'PV','Pavia',1),(0,8071,8,'PG','Perugia',1),(0,8072,8,'PU','Pesaro e Urbino',1),(0,8073,8,'PE','Pescara',1),(0,8074,8,'PC','Piacenza',1),(0,8075,8,'PI','Pisa',1),(0,8076,8,'PT','Pistoia',1),(0,8077,8,'PN','Pordenone',1),(0,8078,8,'PZ','Potenza',1),(0,8079,8,'PO','Prato',1),(0,8080,8,'RG','Ragusa',1),(0,8081,8,'RA','Ravenna',1),(0,8082,8,'RC','Reggio Calabria',1),(0,8083,8,'RE','Reggio Emilia',1),(0,8084,8,'RI','Rieti',1),(0,8085,8,'RN','Rimini',1),(0,8086,8,'RM','Roma',1),(0,8087,8,'RO','Rovigo',1),(0,8088,8,'SA','Salerno',1),(0,8089,8,'SS','Sassari',1),(0,8090,8,'SV','Savona',1),(0,8091,8,'SI','Siena',1),(0,8092,8,'SR','Siracusa',1),(0,8093,8,'SO','Sondrio',1),(0,8094,8,'TA','Taranto',1),(0,8095,8,'TE','Teramo',1),(0,8096,8,'TR','Terni',1),(0,8097,8,'TO','Torino',1),(0,8098,8,'TP','Trapani',1),(0,8099,8,'TN','Trento',1),(0,8100,8,'TV','Treviso',1),(0,8101,8,'TS','Trieste',1),(0,8102,8,'UD','Udine',1),(0,8103,8,'VA','Varese',1),(0,8104,8,'VE','Venezia',1),(0,8105,8,'VB','Verbano-Cusio-Ossola',1),(0,8106,8,'VC','Vercelli',1),(0,8107,8,'VR','Verona',1),(0,8108,8,'VV','Vibo Valentia',1),(0,8109,8,'VI','Vicenza',1),(0,8110,8,'VT','Viterbo',1),(0,11001,11,'DR','Drenthe',1),(0,11002,11,'FL','Flevoland',1),(0,11003,11,'FR','Friesland',1),(0,11004,11,'GE','Gelderland',1),(0,11005,11,'GR','Groningen',1),(0,11006,11,'LI','Limburg',1),(0,11007,11,'NB','Noord-Brabant',1),(0,11008,11,'NH','Noord-Holland',1),(0,11009,11,'OV','Overijssel',1),(0,11010,11,'UT','Utrecht',1),(0,11011,11,'ZE','Zeeland',1),(0,11012,11,'ZH','Zuid-Holland',1),(0,15001,15,'AN','Andalusia',1),(0,15002,15,'AR','Aragon',1),(0,15003,15,'AS','Asturias',1),(0,15004,15,'IB','Balearic Islands',1),(0,15005,15,'PV','Basque Country',1),(0,15006,15,'CN','Canary Islands',1),(0,15007,15,'CB','Cantabria',1),(0,15008,15,'CL','Castile and Leon',1),(0,15009,15,'CM','Castile-La Mancha',1),(0,15010,15,'CT','Catalonia',1),(0,15011,15,'CE','Ceuta',1),(0,15012,15,'EX','Extremadura',1),(0,15013,15,'GA','Galicia',1),(0,15014,15,'LO','La Rioja',1),(0,15015,15,'M','Madrid',1),(0,15016,15,'ML','Melilla',1),(0,15017,15,'MU','Murcia',1),(0,15018,15,'NA','Navarra',1),(0,15019,15,'VC','Valencia',1),(0,19001,19,'AL','Alabama',1),(0,19002,19,'AK','Alaska',1),(0,19003,19,'AZ','Arizona',1),(0,19004,19,'AR','Arkansas',1),(0,19005,19,'CA','California',1),(0,19006,19,'CO','Colorado',1),(0,19007,19,'CT','Connecticut',1),(0,19008,19,'DC','District of Columbia',1),(0,19009,19,'DE','Delaware',1),(0,19010,19,'FL','Florida',1),(0,19011,19,'GA','Georgia',1),(0,19012,19,'HI','Hawaii',1),(0,19013,19,'ID','Idaho',1),(0,19014,19,'IL','Illinois',1),(0,19015,19,'IN','Indiana',1),(0,19016,19,'IA','Iowa',1),(0,19017,19,'KS','Kansas',1),(0,19018,19,'KY','Kentucky ',1),(0,19019,19,'LA','Louisiana ',1),(0,19020,19,'ME','Maine',1),(0,19021,19,'MD','Maryland',1),(0,19022,19,'MA','Massachusetts',1),(0,19023,19,'MI','Michigan',1),(0,19024,19,'MN','Minnesota',1),(0,19025,19,'MS','Mississippi',1),(0,19026,19,'MO','Missouri',1),(0,19027,19,'MT','Montana',1),(0,19028,19,'NE','Nebraska',1),(0,19029,19,'NV','Nevada',1),(0,19030,19,'NH','New Hampshire',1),(0,19031,19,'NJ','New Jersey',1),(0,19032,19,'NM','New Mexico',1),(0,19033,19,'NY','New York',1),(0,19034,19,'NC','North Carolina',1),(0,19035,19,'ND','North Dakota',1),(0,19036,19,'OH','Ohio',1),(0,19037,19,'OK','Oklahoma ',1),(0,19038,19,'OR','Oregon',1),(0,19039,19,'PA','Pennsylvania',1),(0,19040,19,'PR','Puerto Rico',1),(0,19041,19,'RI','Rhode Island',1),(0,19042,19,'SC','South Carolina',1),(0,19043,19,'SD','South Dakota',1),(0,19044,19,'TN','Tennessee',1),(0,19045,19,'TX','Texas',1),(0,19046,19,'UT','Utah',1),(0,19047,19,'VT','Vermont',1),(0,19048,19,'VA','Virginia',1),(0,19049,19,'WA','Washington',1),(0,19050,19,'WV','West Virginia',1),(0,19051,19,'WI','Wisconsin',1),(0,19052,19,'WY','Wyoming',1),(0,32001,32,'ACT','Australian Capital Territory',1),(0,32002,32,'NSW','New South Wales',1),(0,32003,32,'NT','Northern Territory',1),(0,32004,32,'QLD','Queensland',1),(0,32005,32,'SA','South Australia',1),(0,32006,32,'TAS','Tasmania',1),(0,32007,32,'VIC','Victoria',1),(0,32008,32,'WA','Western Australia',1),(0,33001,33,'AT-1','Burgenland',1),(0,33002,33,'AT-2','Kärnten',1),(0,33003,33,'AT-3','Niederösterreich',1),(0,33004,33,'AT-4','Oberösterreich',1),(0,33005,33,'AT-5','Salzburg',1),(0,33006,33,'AT-6','Steiermark',1),(0,33007,33,'AT-7','Tirol',1),(0,33008,33,'AT-8','Vorarlberg',1),(0,33009,33,'AT-9','Vienna',1),(0,144001,144,'MX-AGS','Aguascalientes',1),(0,144002,144,'MX-BCN','Baja California',1),(0,144003,144,'MX-BCS','Baja California Sur',1),(0,144004,144,'MX-CAM','Campeche',1),(0,144005,144,'MX-CHP','Chiapas',1),(0,144006,144,'MX-CHI','Chihuahua',1),(0,144007,144,'MX-COA','Coahuila',1),(0,144008,144,'MX-COL','Colima',1),(0,144009,144,'MX-DUR','Durango',1),(0,144010,144,'MX-GTO','Guanajuato',1),(0,144011,144,'MX-GRO','Guerrero',1),(0,144012,144,'MX-HGO','Hidalgo',1),(0,144013,144,'MX-JAL','Jalisco',1),(0,144014,144,'MX-MEX','Mexico',1),(0,144015,144,'MX-MIC','Michoacan',1),(0,144016,144,'MX-MOR','Morelos',1),(0,144017,144,'MX-NAY','Nayarit',1),(0,144018,144,'MX-NLE','Nuevo Leon',1),(0,144019,144,'MX-OAX','Oaxaca',1),(0,144020,144,'MX-PUE','Puebla',1),(0,144021,144,'MX-QRO','Queretaro',1),(0,144023,144,'MX-ROO','Quintana Roo',1),(0,144024,144,'MX-SLP','San Luis Potosí',1),(0,144025,144,'MX-SIN','Sinaloa',1),(0,144026,144,'MX-SON','Sonora',1),(0,144027,144,'MX-TAB','Tabasco',1),(0,144028,144,'MX-TAM','Tamaulipas',1),(0,144029,144,'MX-TLX','Tlaxcala',1),(0,144030,144,'MX-VER','Veracruz',1),(0,144031,144,'MX-YUC','Yucatan',1),(0,144032,144,'MX-ZAC','Zacatecas',1),(0,164001,164,'01','Østfold',1),(0,164002,164,'02','Akershus',1),(0,164003,164,'03','Oslo',1),(0,164004,164,'04','Hedmark',1),(0,164005,164,'05','Oppland',1),(0,164006,164,'06','Buskerud',1),(0,164007,164,'07','Vestfold',1),(0,164008,164,'08','Telemark',1),(0,164009,164,'09','Aust-Agder',1),(0,164010,164,'10','Vest-Agder',1),(0,164011,164,'11','Rogaland',1),(0,164012,164,'12','Hordaland',1),(0,164013,164,'14','Sogn og Fjordane',1),(0,164014,164,'15','Møre of Romsdal',1),(0,164015,164,'16','Sør-Trøndelag',1),(0,164016,164,'17','Nord-Trøndelag',1),(0,164017,164,'18','Nordland',1),(0,164018,164,'19','Troms',1),(0,164019,164,'20','Finnmark',1),(0,202001,202,'AG','Aargau',1),(0,202002,202,'AR','Appenzell Ausserrhoden',1),(0,202003,202,'AI','Appenzell Innerrhoden',1),(0,202004,202,'BL','Basel-Landschaft',1),(0,202005,202,'BS','Basel-Stadt',1),(0,202006,202,'BE','Bern',1),(0,202007,202,'FR','Fribourg',1),(0,202008,202,'GE','Geneva',1),(0,202009,202,'GL','Glarus',1),(0,202010,202,'GR','Graubünden',1),(0,202011,202,'JU','Jura',1),(0,202012,202,'LU','Lucerne',1),(0,202013,202,'NE','Neuchâtel',1),(0,202014,202,'NW','Nidwalden',1),(0,202015,202,'OW','Obwalden',1),(0,202016,202,'SH','Schaffhausen',1),(0,202017,202,'SZ','Schwyz',1),(0,202018,202,'SO','Solothurn',1),(0,202019,202,'SG','St. Gallen',1),(0,202020,202,'TG','Thurgau',1),(0,202021,202,'TI','Ticino',1),(0,202022,202,'UR','Uri',1),(0,202023,202,'VS','Valais',1),(0,202024,202,'VD','Vaud',1),(0,202025,202,'ZG','Zug',1),(0,202026,202,'ZH','Zürich',1);

--
