\n Products\n
\n\n Our newest additions to the Titanium Series: ViX-998\n
\n\n I am very excited about this! Administrating the portal with a few clicks is now very easy, you just have to acces the Control Panel in the dock menu (top right) to do any of the following things:\n
\n\n- \n
- \n Manage users, organizations and communities\n \n
- \n Create or assign roles\n \n
- \n Manage the content (Articles, blogs, wikis...)\n \n
- \n Add new plugins\n \n
- \n Update my account\n \n
- \n Change the settings of the portal and the server\n \n
- \n ...\n \n
\n Did I tell you how much I love being the Administrator since I have this amazing Control Panel? ![\"\"](\"/html/js/editor/fckeditor/editor/images/smiley/msn/teeth_smile.gif\")
\n
\n In my previous entry I told you how I could manage the entire portal from the Control Panel.\n
\n\n\n In this entry I wanted to show you how you can configure the preferences of your portal.\n
\n\n\n There is a file called portal.properties with all the parameters you can configure for your portal. Please be advised, you should not modify this file. Instead, create a portal-ext.properties file and you can overwrite these properties there (More information about this here).\n
\n\n\n Have a look at this file to see everything you can do. You will probably find this page very useful:www.liferay.com/web/guest/community/wiki/-/wiki/Main/Portal+Properties+5.1.1\n
','2008-02-01 00:00:00',0,0,'',0,10963,'Bruno Admin','2016-11-22 17:54:23',NULL,NULL,NULL,NULL),('90fb89f6-6a25-4fc3-8469-e746baa2b63b',11278,11037,10202,11035,'John Regular','2016-11-22 17:54:23','2016-11-22 17:54:23','Using the wiki','using-the-wiki','\n Hi Guys,\n
\n\n\n We have a new wiki and it is very easy to use. Anyone can write an article in there.\n
\n\n\n For any issue related to Liferay, please go to: wiki.liferay.com\n
\n\n\n Thank you!\n
','2008-02-01 00:00:00',0,0,'',0,11035,'John Regular','2016-11-22 17:54:23',NULL,NULL,NULL,NULL),('1ee2b6f8-806f-48b7-ad12-1597e4596a1b',11293,11109,10202,11107,'Michelle Writer','2016-11-22 17:54:23','2016-11-22 17:54:23','We have an amazing Chat!','we-have-an-amazing-chat!','\n Hi Guys,\n
\n\n\n We have an amazing chat in the portal!! Just have a look at the bar at the bottom of the page when you are logged in and you will be able to see all your friends online and talk to them!\n
\n\n\n Enjoy!! \n
','2008-02-01 00:00:00',0,0,'',0,11107,'Michelle Writer','2016-11-22 17:54:23',NULL,NULL,NULL,NULL),('b00de431-8ec4-45da-9153-61e5415e9231',11412,10227,10202,10239,'Test Test','2016-11-22 17:55:02','2016-11-22 17:55:02','aaa','aaa','\n aa
','2016-11-22 17:54:00',1,1,'',0,10239,'Test Test','2016-11-22 17:55:02',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `BlogsEntry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `BlogsStatsUser` -- DROP TABLE IF EXISTS `BlogsStatsUser`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BlogsStatsUser` ( `statsUserId` bigint(20) NOT NULL, `groupId` bigint(20) DEFAULT NULL, `companyId` bigint(20) DEFAULT NULL, `userId` bigint(20) DEFAULT NULL, `entryCount` int(11) DEFAULT NULL, `lastPostDate` datetime DEFAULT NULL, `ratingsTotalEntries` int(11) DEFAULT NULL, `ratingsTotalScore` double DEFAULT NULL, `ratingsAverageScore` double DEFAULT NULL, PRIMARY KEY (`statsUserId`), UNIQUE KEY `IX_82254C25` (`groupId`,`userId`), KEY `IX_90CDA39A` (`companyId`,`entryCount`), KEY `IX_43840EEB` (`groupId`), KEY `IX_28C78D5C` (`groupId`,`entryCount`), KEY `IX_BB51F1D9` (`userId`), KEY `IX_507BA031` (`userId`,`lastPostDate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `BlogsStatsUser` -- LOCK TABLES `BlogsStatsUser` WRITE; /*!40000 ALTER TABLE `BlogsStatsUser` DISABLE KEYS */; INSERT INTO `BlogsStatsUser` VALUES (11263,10965,10202,10963,2,'2008-02-01 00:00:00',0,0,0),(11290,11037,10202,11035,1,'2008-02-01 00:00:00',0,0,0),(11307,11109,10202,11107,1,'2008-02-01 00:00:00',0,0,0),(11418,10227,10202,10239,1,'2016-11-22 17:54:00',0,0,0); /*!40000 ALTER TABLE `BlogsStatsUser` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `BookmarksEntry` -- DROP TABLE IF EXISTS `BookmarksEntry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BookmarksEntry` ( `uuid_` varchar(75) DEFAULT NULL, `entryId` bigint(20) NOT NULL, `groupId` bigint(20) DEFAULT NULL, `companyId` bigint(20) DEFAULT NULL, `userId` bigint(20) DEFAULT NULL, `createDate` datetime DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `folderId` bigint(20) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `url` longtext, `visits` int(11) DEFAULT NULL, `priority` int(11) DEFAULT NULL, `userName` varchar(75) DEFAULT NULL, `resourceBlockId` bigint(20) DEFAULT NULL, `description` longtext, `treePath` longtext, `status` int(11) DEFAULT NULL, `statusByUserId` bigint(20) DEFAULT NULL, `statusByUserName` varchar(75) DEFAULT NULL, `statusDate` datetime DEFAULT NULL, PRIMARY KEY (`entryId`), UNIQUE KEY `IX_EAA02A91` (`uuid_`,`groupId`), KEY `IX_5200100C` (`groupId`,`folderId`), KEY `IX_B670BA39` (`uuid_`), KEY `IX_E848278F` (`resourceBlockId`), KEY `IX_1F90CA2D` (`companyId`), KEY `IX_276C8C13` (`companyId`,`status`), KEY `IX_146382F2` (`groupId`,`folderId`,`status`), KEY `IX_416AD7D5` (`groupId`,`status`), KEY `IX_C78B61AC` (`groupId`,`userId`,`folderId`,`status`), KEY `IX_9D9CF70F` (`groupId`,`userId`,`status`), KEY `IX_89BEDC4F` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `BookmarksEntry` -- LOCK TABLES `BookmarksEntry` WRITE; /*!40000 ALTER TABLE `BookmarksEntry` DISABLE KEYS */; /*!40000 ALTER TABLE `BookmarksEntry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `BookmarksFolder` -- DROP TABLE IF EXISTS `BookmarksFolder`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BookmarksFolder` ( `uuid_` varchar(75) DEFAULT NULL, `folderId` bigint(20) NOT NULL, `groupId` bigint(20) DEFAULT NULL, `companyId` bigint(20) DEFAULT NULL, `userId` bigint(20) DEFAULT NULL, `createDate` datetime DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `parentFolderId` bigint(20) DEFAULT NULL, `name` varchar(75) DEFAULT NULL, `description` longtext, `userName` varchar(75) DEFAULT NULL, `resourceBlockId` bigint(20) DEFAULT NULL, `treePath` longtext, `status` int(11) DEFAULT NULL, `statusByUserId` bigint(20) DEFAULT NULL, `statusByUserName` varchar(75) DEFAULT NULL, `statusDate` datetime DEFAULT NULL, PRIMARY KEY (`folderId`), UNIQUE KEY `IX_DC2F8927` (`uuid_`,`groupId`), KEY `IX_2ABA25D7` (`companyId`), KEY `IX_7F703619` (`groupId`), KEY `IX_967799C0` (`groupId`,`parentFolderId`), KEY `IX_451E7AE3` (`uuid_`), KEY `IX_28A49BB9` (`resourceBlockId`), KEY `IX_C27C9DBD` (`companyId`,`status`), KEY `IX_D16018A6` (`groupId`,`parentFolderId`,`status`), KEY `IX_54F0ED65` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `BookmarksFolder` -- LOCK TABLES `BookmarksFolder` WRITE; /*!40000 ALTER TABLE `BookmarksFolder` DISABLE KEYS */; /*!40000 ALTER TABLE `BookmarksFolder` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `BrowserTracker` -- DROP TABLE IF EXISTS `BrowserTracker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `BrowserTracker` ( `browserTrackerId` bigint(20) NOT NULL, `userId` bigint(20) DEFAULT NULL, `browserKey` bigint(20) DEFAULT NULL, PRIMARY KEY (`browserTrackerId`), UNIQUE KEY `IX_E7B95510` (`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `BrowserTracker` -- LOCK TABLES `BrowserTracker` WRITE; /*!40000 ALTER TABLE `BrowserTracker` DISABLE KEYS */; INSERT INTO `BrowserTracker` VALUES (11408,10239,1394494796178); /*!40000 ALTER TABLE `BrowserTracker` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CalEvent` -- DROP TABLE IF EXISTS `CalEvent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CalEvent` ( `uuid_` varchar(75) DEFAULT NULL, `eventId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `title` varchar(75) DEFAULT NULL, `description` longtext, `startDate` datetime DEFAULT NULL, `endDate` datetime DEFAULT NULL, `durationHour` int(11) DEFAULT NULL, `durationMinute` int(11) DEFAULT NULL, `allDay` tinyint(4) DEFAULT NULL, `timeZoneSensitive` tinyint(4) DEFAULT NULL, `type_` varchar(75) DEFAULT NULL, `repeating` tinyint(4) DEFAULT NULL, `recurrence` longtext, `remindBy` int(11) DEFAULT NULL, `firstReminder` int(11) DEFAULT NULL, `secondReminder` int(11) DEFAULT NULL, `location` longtext, PRIMARY KEY (`eventId`), UNIQUE KEY `IX_5CCE79C8` (`uuid_`,`groupId`), KEY `IX_D6FD9496` (`companyId`), KEY `IX_12EE4898` (`groupId`), KEY `IX_4FDDD2BF` (`groupId`,`repeating`), KEY `IX_FCD7C63D` (`groupId`,`type_`), KEY `IX_F6006202` (`remindBy`), KEY `IX_C1AD2122` (`uuid_`), KEY `IX_FD93CBFA` (`groupId`,`type_`,`repeating`), KEY `IX_299639C6` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `CalEvent` -- LOCK TABLES `CalEvent` WRITE; /*!40000 ALTER TABLE `CalEvent` DISABLE KEYS */; /*!40000 ALTER TABLE `CalEvent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Calendar` -- DROP TABLE IF EXISTS `Calendar`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Calendar` ( `uuid_` varchar(75) DEFAULT NULL, `calendarId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `resourceBlockId` bigint(20) DEFAULT NULL, `calendarResourceId` bigint(20) DEFAULT NULL, `name` longtext, `description` longtext, `color` int(11) DEFAULT NULL, `defaultCalendar` tinyint(4) DEFAULT NULL, `enableComments` tinyint(4) DEFAULT NULL, `enableRatings` tinyint(4) DEFAULT NULL, PRIMARY KEY (`calendarId`), UNIQUE KEY `IX_3AE311A` (`uuid_`,`groupId`), KEY `IX_B53EB0E1` (`groupId`,`calendarResourceId`), KEY `IX_97FC174E` (`groupId`,`calendarResourceId`,`defaultCalendar`), KEY `IX_F0FAF226` (`resourceBlockId`), KEY `IX_96C8590` (`uuid_`), KEY `IX_97656498` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Calendar` -- LOCK TABLES `Calendar` WRITE; /*!40000 ALTER TABLE `Calendar` DISABLE KEYS */; /*!40000 ALTER TABLE `Calendar` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CalendarBooking` -- DROP TABLE IF EXISTS `CalendarBooking`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CalendarBooking` ( `uuid_` varchar(75) DEFAULT NULL, `calendarBookingId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `resourceBlockId` bigint(20) DEFAULT NULL, `calendarId` bigint(20) DEFAULT NULL, `calendarResourceId` bigint(20) DEFAULT NULL, `parentCalendarBookingId` bigint(20) DEFAULT NULL, `title` longtext, `description` longtext, `location` longtext, `startTime` bigint(20) DEFAULT NULL, `endTime` bigint(20) DEFAULT NULL, `allDay` tinyint(4) DEFAULT NULL, `recurrence` longtext, `firstReminder` bigint(20) DEFAULT NULL, `firstReminderType` varchar(75) DEFAULT NULL, `secondReminder` bigint(20) DEFAULT NULL, `secondReminderType` varchar(75) DEFAULT NULL, `status` int(11) DEFAULT NULL, `statusByUserId` bigint(20) DEFAULT NULL, `statusByUserName` varchar(75) DEFAULT NULL, `statusDate` datetime DEFAULT NULL, PRIMARY KEY (`calendarBookingId`), UNIQUE KEY `IX_113A264E` (`calendarId`,`parentCalendarBookingId`), UNIQUE KEY `IX_F4C61797` (`uuid_`,`groupId`), KEY `IX_D300DFCE` (`calendarId`), KEY `IX_470170B4` (`calendarId`,`status`), KEY `IX_B198FFC` (`calendarResourceId`), KEY `IX_57EBF55B` (`parentCalendarBookingId`), KEY `IX_F7B8A941` (`parentCalendarBookingId`,`status`), KEY `IX_22DFDB49` (`resourceBlockId`), KEY `IX_F6E8EE73` (`uuid_`), KEY `IX_A21D9FD5` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `CalendarBooking` -- LOCK TABLES `CalendarBooking` WRITE; /*!40000 ALTER TABLE `CalendarBooking` DISABLE KEYS */; /*!40000 ALTER TABLE `CalendarBooking` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CalendarNotificationTemplate` -- DROP TABLE IF EXISTS `CalendarNotificationTemplate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CalendarNotificationTemplate` ( `uuid_` varchar(75) DEFAULT NULL, `calendarNotificationTemplateId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `calendarId` bigint(20) DEFAULT NULL, `notificationType` varchar(75) DEFAULT NULL, `notificationTypeSettings` varchar(75) DEFAULT NULL, `notificationTemplateType` varchar(75) DEFAULT NULL, `subject` varchar(75) DEFAULT NULL, `body` longtext, PRIMARY KEY (`calendarNotificationTemplateId`), UNIQUE KEY `IX_4012E97F` (`uuid_`,`groupId`), KEY `IX_A412E5B6` (`calendarId`), KEY `IX_7727A482` (`calendarId`,`notificationType`,`notificationTemplateType`), KEY `IX_A2D4D78B` (`uuid_`), KEY `IX_4D7D97BD` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `CalendarNotificationTemplate` -- LOCK TABLES `CalendarNotificationTemplate` WRITE; /*!40000 ALTER TABLE `CalendarNotificationTemplate` DISABLE KEYS */; /*!40000 ALTER TABLE `CalendarNotificationTemplate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CalendarResource` -- DROP TABLE IF EXISTS `CalendarResource`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CalendarResource` ( `uuid_` varchar(75) DEFAULT NULL, `calendarResourceId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `resourceBlockId` bigint(20) DEFAULT NULL, `classNameId` bigint(20) DEFAULT NULL, `classPK` bigint(20) DEFAULT NULL, `classUuid` varchar(75) DEFAULT NULL, `code_` varchar(75) DEFAULT NULL, `name` longtext, `description` longtext, `active_` tinyint(4) DEFAULT NULL, PRIMARY KEY (`calendarResourceId`), UNIQUE KEY `IX_16A12327` (`classNameId`,`classPK`), UNIQUE KEY `IX_4ABD2BC8` (`uuid_`,`groupId`), KEY `IX_76DDD0F7` (`active_`), KEY `IX_4470A59D` (`companyId`,`code_`,`active_`), KEY `IX_1243D698` (`groupId`), KEY `IX_40678371` (`groupId`,`active_`), KEY `IX_55C2F8AA` (`groupId`,`code_`), KEY `IX_8BCB4D38` (`resourceBlockId`), KEY `IX_150E2F22` (`uuid_`), KEY `IX_56A06BC6` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `CalendarResource` -- LOCK TABLES `CalendarResource` WRITE; /*!40000 ALTER TABLE `CalendarResource` DISABLE KEYS */; /*!40000 ALTER TABLE `CalendarResource` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Chat_Entry` -- DROP TABLE IF EXISTS `Chat_Entry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Chat_Entry` ( `entryId` bigint(20) NOT NULL, `createDate` bigint(20) DEFAULT NULL, `fromUserId` bigint(20) DEFAULT NULL, `toUserId` bigint(20) DEFAULT NULL, `content` varchar(1000) DEFAULT NULL, `flag` int(11) DEFAULT NULL, PRIMARY KEY (`entryId`), KEY `IX_DAEF230F` (`createDate`), KEY `IX_AD559D93` (`createDate`,`fromUserId`), KEY `IX_D9E49928` (`createDate`,`fromUserId`,`toUserId`), KEY `IX_8BE273A4` (`createDate`,`toUserId`), KEY `IX_F9966D55` (`fromUserId`), KEY `IX_97FE1E6A` (`fromUserId`,`toUserId`), KEY `IX_2A17A23F` (`fromUserId`,`toUserId`,`content`), KEY `IX_16384BE6` (`toUserId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Chat_Entry` -- LOCK TABLES `Chat_Entry` WRITE; /*!40000 ALTER TABLE `Chat_Entry` DISABLE KEYS */; /*!40000 ALTER TABLE `Chat_Entry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Chat_Status` -- DROP TABLE IF EXISTS `Chat_Status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Chat_Status` ( `statusId` bigint(20) NOT NULL, `userId` bigint(20) DEFAULT NULL, `modifiedDate` bigint(20) DEFAULT NULL, `online_` tinyint(4) DEFAULT NULL, `awake` tinyint(4) DEFAULT NULL, `activePanelIds` longtext, `message` longtext, `playSound` tinyint(4) DEFAULT NULL, PRIMARY KEY (`statusId`), UNIQUE KEY `IX_E17EBD79` (`userId`), KEY `IX_15BD544A` (`modifiedDate`), KEY `IX_B723B792` (`modifiedDate`,`online_`), KEY `IX_32531B3D` (`online_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Chat_Status` -- LOCK TABLES `Chat_Status` WRITE; /*!40000 ALTER TABLE `Chat_Status` DISABLE KEYS */; INSERT INTO `Chat_Status` VALUES (11407,10239,1479837986683,1,1,'','',1); /*!40000 ALTER TABLE `Chat_Status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ClassName_` -- DROP TABLE IF EXISTS `ClassName_`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ClassName_` ( `classNameId` bigint(20) NOT NULL, `value` varchar(200) DEFAULT NULL, PRIMARY KEY (`classNameId`), UNIQUE KEY `IX_B27A301F` (`value`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ClassName_` -- LOCK TABLES `ClassName_` WRITE; /*!40000 ALTER TABLE `ClassName_` DISABLE KEYS */; INSERT INTO `ClassName_` VALUES (11988,'com.liferay.calendar.model.Calendar'),(11989,'com.liferay.calendar.model.CalendarBooking'),(11990,'com.liferay.calendar.model.CalendarNotificationTemplate'),(11991,'com.liferay.calendar.model.CalendarResource'),(10331,'com.liferay.chat.model.Entry'),(10332,'com.liferay.chat.model.Status'),(12027,'com.liferay.contacts.model.Entry'),(10001,'com.liferay.counter.model.Counter'),(10461,'com.liferay.mail.model.Account'),(10462,'com.liferay.mail.model.Attachment'),(10463,'com.liferay.mail.model.Folder'),(10464,'com.liferay.mail.model.Message'),(11706,'com.liferay.marketplace.model.App'),(11707,'com.liferay.marketplace.model.Module'),(12001,'com.liferay.microblogs.model.MicroblogsEntry'),(12005,'com.liferay.notifications.model.UserNotificationEvent'),(10468,'com.liferay.opensocial.model.Gadget'),(12009,'com.liferay.opensocial.model.OAuthConsumer'),(12010,'com.liferay.opensocial.model.OAuthToken'),(11978,'com.liferay.portal.kernel.repository.model.FileEntry'),(10002,'com.liferay.portal.kernel.workflow.WorkflowTask'),(10003,'com.liferay.portal.model.Account'),(10004,'com.liferay.portal.model.Address'),(11883,'com.liferay.portal.model.BackgroundTask'),(10005,'com.liferay.portal.model.BrowserTracker'),(10006,'com.liferay.portal.model.ClassName'),(10007,'com.liferay.portal.model.ClusterGroup'),(10008,'com.liferay.portal.model.Company'),(10009,'com.liferay.portal.model.Contact'),(10010,'com.liferay.portal.model.Country'),(10011,'com.liferay.portal.model.EmailAddress'),(10012,'com.liferay.portal.model.Group'),(10013,'com.liferay.portal.model.Image'),(10014,'com.liferay.portal.model.Layout'),(11561,'com.liferay.portal.model.LayoutBranch'),(11884,'com.liferay.portal.model.LayoutFriendlyURL'),(10015,'com.liferay.portal.model.LayoutPrototype'),(11562,'com.liferay.portal.model.LayoutRevision'),(10016,'com.liferay.portal.model.LayoutSet'),(11563,'com.liferay.portal.model.LayoutSetBranch'),(10017,'com.liferay.portal.model.LayoutSetPrototype'),(10018,'com.liferay.portal.model.ListType'),(10019,'com.liferay.portal.model.Lock'),(10020,'com.liferay.portal.model.MembershipRequest'),(10024,'com.liferay.portal.model.Organization'),(10021,'com.liferay.portal.model.OrgGroupPermission'),(10022,'com.liferay.portal.model.OrgGroupRole'),(10023,'com.liferay.portal.model.OrgLabor'),(10025,'com.liferay.portal.model.PasswordPolicy'),(10026,'com.liferay.portal.model.PasswordPolicyRel'),(10027,'com.liferay.portal.model.PasswordTracker'),(10028,'com.liferay.portal.model.Permission'),(10029,'com.liferay.portal.model.Phone'),(10030,'com.liferay.portal.model.PluginSetting'),(11564,'com.liferay.portal.model.PortalPreferences'),(10031,'com.liferay.portal.model.Portlet'),(10032,'com.liferay.portal.model.PortletItem'),(10033,'com.liferay.portal.model.PortletPreferences'),(10034,'com.liferay.portal.model.Region'),(10035,'com.liferay.portal.model.Release'),(11565,'com.liferay.portal.model.Repository'),(11566,'com.liferay.portal.model.RepositoryEntry'),(10036,'com.liferay.portal.model.Resource'),(10037,'com.liferay.portal.model.ResourceAction'),(11567,'com.liferay.portal.model.ResourceBlock'),(11568,'com.liferay.portal.model.ResourceBlockPermission'),(10038,'com.liferay.portal.model.ResourceCode'),(10039,'com.liferay.portal.model.ResourcePermission'),(11569,'com.liferay.portal.model.ResourceTypePermission'),(10040,'com.liferay.portal.model.Role'),(10041,'com.liferay.portal.model.ServiceComponent'),(10042,'com.liferay.portal.model.Shard'),(10043,'com.liferay.portal.model.Subscription'),(11885,'com.liferay.portal.model.SystemEvent'),(10044,'com.liferay.portal.model.Team'),(10045,'com.liferay.portal.model.Ticket'),(10046,'com.liferay.portal.model.User'),(10047,'com.liferay.portal.model.UserGroup'),(10048,'com.liferay.portal.model.UserGroupGroupRole'),(10049,'com.liferay.portal.model.UserGroupRole'),(10050,'com.liferay.portal.model.UserIdMapper'),(11886,'com.liferay.portal.model.UserNotificationDelivery'),(11570,'com.liferay.portal.model.UserNotificationEvent'),(11597,'com.liferay.portal.model.UserPersonalSite'),(10051,'com.liferay.portal.model.UserTracker'),(10052,'com.liferay.portal.model.UserTrackerPath'),(11571,'com.liferay.portal.model.VirtualHost'),(10053,'com.liferay.portal.model.WebDAVProps'),(10054,'com.liferay.portal.model.Website'),(10055,'com.liferay.portal.model.WorkflowDefinitionLink'),(10056,'com.liferay.portal.model.WorkflowInstanceLink'),(10421,'com.liferay.portal.workflow.kaleo.model.KaleoAction'),(11996,'com.liferay.portal.workflow.kaleo.model.KaleoCondition'),(10422,'com.liferay.portal.workflow.kaleo.model.KaleoDefinition'),(10423,'com.liferay.portal.workflow.kaleo.model.KaleoInstance'),(10424,'com.liferay.portal.workflow.kaleo.model.KaleoInstanceToken'),(10425,'com.liferay.portal.workflow.kaleo.model.KaleoLog'),(10426,'com.liferay.portal.workflow.kaleo.model.KaleoNode'),(10427,'com.liferay.portal.workflow.kaleo.model.KaleoNotification'),(10428,'com.liferay.portal.workflow.kaleo.model.KaleoNotificationRecipient'),(10429,'com.liferay.portal.workflow.kaleo.model.KaleoTask'),(10430,'com.liferay.portal.workflow.kaleo.model.KaleoTaskAssignment'),(10431,'com.liferay.portal.workflow.kaleo.model.KaleoTaskAssignmentInstance'),(10432,'com.liferay.portal.workflow.kaleo.model.KaleoTaskInstanceToken'),(11997,'com.liferay.portal.workflow.kaleo.model.KaleoTimer'),(11998,'com.liferay.portal.workflow.kaleo.model.KaleoTimerInstanceToken'),(10433,'com.liferay.portal.workflow.kaleo.model.KaleoTransition'),(10057,'com.liferay.portlet.announcements.model.AnnouncementsDelivery'),(10058,'com.liferay.portlet.announcements.model.AnnouncementsEntry'),(10059,'com.liferay.portlet.announcements.model.AnnouncementsFlag'),(10060,'com.liferay.portlet.asset.model.AssetCategory'),(10061,'com.liferay.portlet.asset.model.AssetCategoryProperty'),(10062,'com.liferay.portlet.asset.model.AssetEntry'),(10063,'com.liferay.portlet.asset.model.AssetLink'),(10064,'com.liferay.portlet.asset.model.AssetTag'),(10065,'com.liferay.portlet.asset.model.AssetTagProperty'),(10066,'com.liferay.portlet.asset.model.AssetTagStats'),(10067,'com.liferay.portlet.asset.model.AssetVocabulary'),(10068,'com.liferay.portlet.blogs.model.BlogsEntry'),(10069,'com.liferay.portlet.blogs.model.BlogsStatsUser'),(10070,'com.liferay.portlet.bookmarks.model.BookmarksEntry'),(10071,'com.liferay.portlet.bookmarks.model.BookmarksFolder'),(10072,'com.liferay.portlet.calendar.model.CalEvent'),(11572,'com.liferay.portlet.documentlibrary.model.DLContent'),(10073,'com.liferay.portlet.documentlibrary.model.DLFileEntry'),(11573,'com.liferay.portlet.documentlibrary.model.DLFileEntryMetadata'),(11574,'com.liferay.portlet.documentlibrary.model.DLFileEntryType'),(10074,'com.liferay.portlet.documentlibrary.model.DLFileRank'),(10075,'com.liferay.portlet.documentlibrary.model.DLFileShortcut'),(10076,'com.liferay.portlet.documentlibrary.model.DLFileVersion'),(10077,'com.liferay.portlet.documentlibrary.model.DLFolder'),(11575,'com.liferay.portlet.documentlibrary.model.DLSync'),(11887,'com.liferay.portlet.documentlibrary.model.DLSyncEvent'),(11907,'com.liferay.portlet.documentlibrary.util.RawMetadataProcessor'),(11576,'com.liferay.portlet.dynamicdatalists.model.DDLRecord'),(11577,'com.liferay.portlet.dynamicdatalists.model.DDLRecordSet'),(11578,'com.liferay.portlet.dynamicdatalists.model.DDLRecordVersion'),(11579,'com.liferay.portlet.dynamicdatamapping.model.DDMContent'),(11580,'com.liferay.portlet.dynamicdatamapping.model.DDMStorageLink'),(11581,'com.liferay.portlet.dynamicdatamapping.model.DDMStructure'),(11582,'com.liferay.portlet.dynamicdatamapping.model.DDMStructureLink'),(11583,'com.liferay.portlet.dynamicdatamapping.model.DDMTemplate'),(10078,'com.liferay.portlet.expando.model.ExpandoColumn'),(10079,'com.liferay.portlet.expando.model.ExpandoRow'),(10080,'com.liferay.portlet.expando.model.ExpandoTable'),(10081,'com.liferay.portlet.expando.model.ExpandoValue'),(10082,'com.liferay.portlet.imagegallery.model.IGFolder'),(10083,'com.liferay.portlet.imagegallery.model.IGImage'),(10084,'com.liferay.portlet.journal.model.JournalArticle'),(10085,'com.liferay.portlet.journal.model.JournalArticleImage'),(10086,'com.liferay.portlet.journal.model.JournalArticleResource'),(10087,'com.liferay.portlet.journal.model.JournalContentSearch'),(10088,'com.liferay.portlet.journal.model.JournalFeed'),(11801,'com.liferay.portlet.journal.model.JournalFolder'),(10089,'com.liferay.portlet.journal.model.JournalStructure'),(10090,'com.liferay.portlet.journal.model.JournalTemplate'),(10091,'com.liferay.portlet.messageboards.model.MBBan'),(10092,'com.liferay.portlet.messageboards.model.MBCategory'),(10093,'com.liferay.portlet.messageboards.model.MBDiscussion'),(10094,'com.liferay.portlet.messageboards.model.MBMailingList'),(10095,'com.liferay.portlet.messageboards.model.MBMessage'),(10096,'com.liferay.portlet.messageboards.model.MBMessageFlag'),(10097,'com.liferay.portlet.messageboards.model.MBStatsUser'),(10098,'com.liferay.portlet.messageboards.model.MBThread'),(11584,'com.liferay.portlet.messageboards.model.MBThreadFlag'),(11585,'com.liferay.portlet.mobiledevicerules.model.MDRAction'),(11586,'com.liferay.portlet.mobiledevicerules.model.MDRRule'),(11587,'com.liferay.portlet.mobiledevicerules.model.MDRRuleGroup'),(11588,'com.liferay.portlet.mobiledevicerules.model.MDRRuleGroupInstance'),(10099,'com.liferay.portlet.polls.model.PollsChoice'),(10100,'com.liferay.portlet.polls.model.PollsQuestion'),(10101,'com.liferay.portlet.polls.model.PollsVote'),(10102,'com.liferay.portlet.ratings.model.RatingsEntry'),(10103,'com.liferay.portlet.ratings.model.RatingsStats'),(10104,'com.liferay.portlet.shopping.model.ShoppingCart'),(10105,'com.liferay.portlet.shopping.model.ShoppingCategory'),(10106,'com.liferay.portlet.shopping.model.ShoppingCoupon'),(10107,'com.liferay.portlet.shopping.model.ShoppingItem'),(10108,'com.liferay.portlet.shopping.model.ShoppingItemField'),(10109,'com.liferay.portlet.shopping.model.ShoppingItemPrice'),(10110,'com.liferay.portlet.shopping.model.ShoppingOrder'),(10111,'com.liferay.portlet.shopping.model.ShoppingOrderItem'),(10112,'com.liferay.portlet.social.model.SocialActivity'),(11589,'com.liferay.portlet.social.model.SocialActivityAchievement'),(11590,'com.liferay.portlet.social.model.SocialActivityCounter'),(11591,'com.liferay.portlet.social.model.SocialActivityLimit'),(11888,'com.liferay.portlet.social.model.SocialActivitySet'),(11592,'com.liferay.portlet.social.model.SocialActivitySetting'),(10113,'com.liferay.portlet.social.model.SocialEquityAssetEntry'),(10114,'com.liferay.portlet.social.model.SocialEquityGroupSetting'),(10115,'com.liferay.portlet.social.model.SocialEquityHistory'),(10116,'com.liferay.portlet.social.model.SocialEquityLog'),(10117,'com.liferay.portlet.social.model.SocialEquitySetting'),(10118,'com.liferay.portlet.social.model.SocialEquityUser'),(10119,'com.liferay.portlet.social.model.SocialRelation'),(10120,'com.liferay.portlet.social.model.SocialRequest'),(10121,'com.liferay.portlet.softwarecatalog.model.SCFrameworkVersion'),(10122,'com.liferay.portlet.softwarecatalog.model.SCLicense'),(10123,'com.liferay.portlet.softwarecatalog.model.SCProductEntry'),(10124,'com.liferay.portlet.softwarecatalog.model.SCProductScreenshot'),(10125,'com.liferay.portlet.softwarecatalog.model.SCProductVersion'),(10126,'com.liferay.portlet.tasks.model.TasksProposal'),(10127,'com.liferay.portlet.tasks.model.TasksReview'),(11889,'com.liferay.portlet.trash.model.TrashEntry'),(11890,'com.liferay.portlet.trash.model.TrashVersion'),(11593,'com.liferay.portlet.usernotifications.model.UserNotificationEvent'),(10128,'com.liferay.portlet.wiki.model.WikiNode'),(10129,'com.liferay.portlet.wiki.model.WikiPage'),(10130,'com.liferay.portlet.wiki.model.WikiPageResource'),(12016,'com.liferay.privatemessaging.model.UserThread'),(12021,'com.liferay.so.model.FavoriteSite'),(12022,'com.liferay.so.model.MemberRequest'),(12023,'com.liferay.so.model.ProjectsEntry'),(10472,'com.liferay.socialnetworking.model.MeetupsEntry'),(10473,'com.liferay.socialnetworking.model.MeetupsRegistration'),(10474,'com.liferay.socialnetworking.model.WallEntry'),(12034,'com.liferay.sync.model.SyncDLFileVersionDiff'),(12035,'com.liferay.sync.model.SyncDLObject'),(12068,'com.liferay.tasks.model.TasksEntry'),(11386,'com.liferay.wsrp.model.WSRPConsumer'),(11387,'com.liferay.wsrp.model.WSRPConsumerPortlet'),(11388,'com.liferay.wsrp.model.WSRPProducer'); /*!40000 ALTER TABLE `ClassName_` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ClusterGroup` -- DROP TABLE IF EXISTS `ClusterGroup`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ClusterGroup` ( `clusterGroupId` bigint(20) NOT NULL, `name` varchar(75) DEFAULT NULL, `clusterNodeIds` varchar(75) DEFAULT NULL, `wholeCluster` tinyint(4) DEFAULT NULL, PRIMARY KEY (`clusterGroupId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ClusterGroup` -- LOCK TABLES `ClusterGroup` WRITE; /*!40000 ALTER TABLE `ClusterGroup` DISABLE KEYS */; /*!40000 ALTER TABLE `ClusterGroup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Company` -- DROP TABLE IF EXISTS `Company`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Company` ( `companyId` bigint(20) NOT NULL, `accountId` bigint(20) DEFAULT NULL, `webId` varchar(75) DEFAULT NULL, `key_` longtext, `mx` varchar(75) DEFAULT NULL, `homeURL` longtext, `logoId` bigint(20) DEFAULT NULL, `system` tinyint(4) DEFAULT NULL, `maxUsers` int(11) DEFAULT NULL, `active_` tinyint(4) DEFAULT NULL, PRIMARY KEY (`companyId`), UNIQUE KEY `IX_EC00543C` (`webId`), KEY `IX_38EFE3FD` (`logoId`), KEY `IX_12566EC2` (`mx`), KEY `IX_35E3E7C6` (`system`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Company` -- LOCK TABLES `Company` WRITE; /*!40000 ALTER TABLE `Company` DISABLE KEYS */; INSERT INTO `Company` VALUES (10202,10204,'liferay.com','rO0ABXNyAB9qYXZheC5jcnlwdG8uc3BlYy5TZWNyZXRLZXlTcGVjW0cLZuIwYU0CAAJMAAlhbGdvcml0aG10ABJMamF2YS9sYW5nL1N0cmluZztbAANrZXl0AAJbQnhwdAADQUVTdXIAAltCrPMX+AYIVOACAAB4cAAAABBlqU2KOT1V6SMenr181pbZ','liferay.com','',0,0,0,1); /*!40000 ALTER TABLE `Company` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Contact_` -- DROP TABLE IF EXISTS `Contact_`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Contact_` ( `contactId` bigint(20) NOT NULL, `companyId` bigint(20) DEFAULT NULL, `userId` bigint(20) DEFAULT NULL, `userName` varchar(75) DEFAULT NULL, `createDate` datetime DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `accountId` bigint(20) DEFAULT NULL, `parentContactId` bigint(20) DEFAULT NULL, `firstName` varchar(75) DEFAULT NULL, `middleName` varchar(75) DEFAULT NULL, `lastName` varchar(75) DEFAULT NULL, `prefixId` int(11) DEFAULT NULL, `suffixId` int(11) DEFAULT NULL, `male` tinyint(4) DEFAULT NULL, `birthday` datetime DEFAULT NULL, `smsSn` varchar(75) DEFAULT NULL, `aimSn` varchar(75) DEFAULT NULL, `facebookSn` varchar(75) DEFAULT NULL, `icqSn` varchar(75) DEFAULT NULL, `jabberSn` varchar(75) DEFAULT NULL, `msnSn` varchar(75) DEFAULT NULL, `mySpaceSn` varchar(75) DEFAULT NULL, `skypeSn` varchar(75) DEFAULT NULL, `twitterSn` varchar(75) DEFAULT NULL, `ymSn` varchar(75) DEFAULT NULL, `employeeStatusId` varchar(75) DEFAULT NULL, `employeeNumber` varchar(75) DEFAULT NULL, `jobTitle` varchar(100) DEFAULT NULL, `jobClass` varchar(75) DEFAULT NULL, `hoursOfOperation` varchar(75) DEFAULT NULL, `classNameId` bigint(20) DEFAULT NULL, `classPK` bigint(20) DEFAULT NULL, `emailAddress` varchar(75) DEFAULT NULL, PRIMARY KEY (`contactId`), KEY `IX_66D496A3` (`companyId`), KEY `IX_B8C28C53` (`accountId`), KEY `IX_791914FA` (`classNameId`,`classPK`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Contact_` -- LOCK TABLES `Contact_` WRITE; /*!40000 ALTER TABLE `Contact_` DISABLE KEYS */; INSERT INTO `Contact_` VALUES (10206,10202,10205,'','2016-11-22 17:54:01','2016-11-22 17:54:01',10204,0,'','','',0,0,1,'2016-11-22 17:54:01','','','','','','','','','','','','','','','',10046,10205,'default@liferay.com'),(10240,10202,10239,'','2016-11-22 17:54:02','2016-11-22 17:54:02',10204,0,'Test','','Test',0,0,1,'1970-01-01 00:00:00','','','','','','','','','','','','','','','',10046,10239,'test@liferay.com'),(10964,10202,10963,'','2016-11-22 17:54:20','2016-11-22 17:54:20',10204,0,'Bruno','','Admin',0,0,1,'1970-01-01 00:00:00','','','','','','','','','','','','','Administrator','','',10046,10963,'bruno@7cogs.com'),(11036,10202,11035,'','2016-11-22 17:54:21','2016-11-22 17:54:21',10204,0,'John','','Regular',0,0,1,'1970-01-01 00:00:00','','','','','','','','','','','','','Employee','','',10046,11035,'john@7cogs.com'),(11108,10202,11107,'','2016-11-22 17:54:22','2016-11-22 17:54:22',10204,0,'Michelle','','Writer',0,0,0,'1970-01-01 00:00:00','','','','','','','','','','','','','Writer','','',10046,11107,'michelle@7cogs.com'),(11180,10202,11179,'','2016-11-22 17:54:22','2016-11-22 17:54:22',10204,0,'Richard','','Editor',0,0,1,'1970-01-01 00:00:00','','','','','','','','','','','','','Publisher','','',10046,11179,'richard@7cogs.com'); /*!40000 ALTER TABLE `Contact_` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Contacts_Entry` -- DROP TABLE IF EXISTS `Contacts_Entry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Contacts_Entry` ( `entryId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `fullName` varchar(75) DEFAULT NULL, `emailAddress` varchar(75) DEFAULT NULL, `comments` longtext, PRIMARY KEY (`entryId`), KEY `IX_BD6B6406` (`userId`), KEY `IX_C257DE32` (`userId`,`emailAddress`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Contacts_Entry` -- LOCK TABLES `Contacts_Entry` WRITE; /*!40000 ALTER TABLE `Contacts_Entry` DISABLE KEYS */; /*!40000 ALTER TABLE `Contacts_Entry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Counter` -- DROP TABLE IF EXISTS `Counter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Counter` ( `name` varchar(75) NOT NULL, `currentId` bigint(20) DEFAULT NULL, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Counter` -- LOCK TABLES `Counter` WRITE; /*!40000 ALTER TABLE `Counter` DISABLE KEYS */; INSERT INTO `Counter` VALUES ('com.liferay.counter.model.Counter',12500),('com.liferay.portal.model.Layout#10219#true',1),('com.liferay.portal.model.Layout#10227#false',1),('com.liferay.portal.model.Layout#10241#false',1),('com.liferay.portal.model.Layout#10241#true',1),('com.liferay.portal.model.Layout#10335#true',1),('com.liferay.portal.model.Layout#10344#true',1),('com.liferay.portal.model.Layout#10353#true',1),('com.liferay.portal.model.Layout#10362#true',4),('com.liferay.portal.model.Layout#10391#true',4),('com.liferay.portal.model.Layout#10587#false',6),('com.liferay.portal.model.Layout#10587#true',2),('com.liferay.portal.model.Layout#10912#false',2),('com.liferay.portal.model.Layout#10965#false',2),('com.liferay.portal.model.Layout#10965#true',3),('com.liferay.portal.model.Layout#11037#false',2),('com.liferay.portal.model.Layout#11037#true',3),('com.liferay.portal.model.Layout#11109#false',2),('com.liferay.portal.model.Layout#11109#true',3),('com.liferay.portal.model.Layout#11181#false',2),('com.liferay.portal.model.Layout#11181#true',3),('com.liferay.portal.model.Layout#11628#true',1),('com.liferay.portal.model.Layout#11637#true',3),('com.liferay.portal.model.Layout#11663#true',4),('com.liferay.portal.model.Layout#11910#true',2),('com.liferay.portal.model.Layout#11936#true',3),('com.liferay.portal.model.Layout#12137#true',7),('com.liferay.portal.model.Layout#12211#true',6),('com.liferay.portal.model.Layout#12269#true',3),('com.liferay.portal.model.Permission',200),('com.liferay.portal.model.Resource',200),('com.liferay.portal.model.ResourceAction',1500),('com.liferay.portal.model.ResourcePermission',2200),('com.liferay.portlet.documentlibrary.model.DLFileEntry',200),('com.liferay.portlet.social.model.SocialActivity',100),('com.liferay.portlet.social.model.SocialRequest',100); /*!40000 ALTER TABLE `Counter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Country` -- DROP TABLE IF EXISTS `Country`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Country` ( `countryId` bigint(20) NOT NULL, `name` varchar(75) DEFAULT NULL, `a2` varchar(75) DEFAULT NULL, `a3` varchar(75) DEFAULT NULL, `number_` varchar(75) DEFAULT NULL, `idd_` varchar(75) DEFAULT NULL, `active_` tinyint(4) DEFAULT NULL, `zipRequired` tinyint(4) DEFAULT NULL, PRIMARY KEY (`countryId`), UNIQUE KEY `IX_717B97E1` (`a2`), UNIQUE KEY `IX_717B9BA2` (`a3`), UNIQUE KEY `IX_19DA007B` (`name`), KEY `IX_25D734CD` (`active_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `Country` -- LOCK TABLES `Country` WRITE; /*!40000 ALTER TABLE `Country` DISABLE KEYS */; INSERT INTO `Country` VALUES (1,'canada','CA','CAN','124','001',1,1),(2,'china','CN','CHN','156','086',1,1),(3,'france','FR','FRA','250','033',1,1),(4,'germany','DE','DEU','276','049',1,1),(5,'hong-kong','HK','HKG','344','852',1,1),(6,'hungary','HU','HUN','348','036',1,1),(7,'israel','IL','ISR','376','972',1,1),(8,'italy','IT','ITA','380','039',1,1),(9,'japan','JP','JPN','392','081',1,1),(10,'south-korea','KR','KOR','410','082',1,1),(11,'netherlands','NL','NLD','528','031',1,1),(12,'portugal','PT','PRT','620','351',1,1),(13,'russia','RU','RUS','643','007',1,1),(14,'singapore','SG','SGP','702','065',1,1),(15,'spain','ES','ESP','724','034',1,1),(16,'turkey','TR','TUR','792','090',1,1),(17,'vietnam','VM','VNM','704','084',1,1),(18,'united-kingdom','GB','GBR','826','044',1,1),(19,'united-states','US','USA','840','001',1,1),(20,'afghanistan','AF','AFG','4','093',1,1),(21,'albania','AL','ALB','8','355',1,1),(22,'algeria','DZ','DZA','12','213',1,1),(23,'american-samoa','AS','ASM','16','684',1,1),(24,'andorra','AD','AND','20','376',1,1),(25,'angola','AO','AGO','24','244',1,0),(26,'anguilla','AI','AIA','660','264',1,1),(27,'antarctica','AQ','ATA','10','672',1,1),(28,'antigua-barbuda','AG','ATG','28','268',1,0),(29,'argentina','AR','ARG','32','054',1,1),(30,'armenia','AM','ARM','51','374',1,1),(31,'aruba','AW','ABW','533','297',1,0),(32,'australia','AU','AUS','36','061',1,1),(33,'austria','AT','AUT','40','043',1,1),(34,'azerbaijan','AZ','AZE','31','994',1,1),(35,'bahamas','BS','BHS','44','242',1,0),(36,'bahrain','BH','BHR','48','973',1,1),(37,'bangladesh','BD','BGD','50','880',1,1),(38,'barbados','BB','BRB','52','246',1,1),(39,'belarus','BY','BLR','112','375',1,1),(40,'belgium','BE','BEL','56','032',1,1),(41,'belize','BZ','BLZ','84','501',1,0),(42,'benin','BJ','BEN','204','229',1,0),(43,'bermuda','BM','BMU','60','441',1,1),(44,'bhutan','BT','BTN','64','975',1,1),(45,'bolivia','BO','BOL','68','591',1,1),(46,'bosnia-herzegovina','BA','BIH','70','387',1,1),(47,'botswana','BW','BWA','72','267',1,0),(48,'brazil','BR','BRA','76','055',1,1),(49,'british-virgin-islands','VG','VGB','92','284',1,1),(50,'brunei','BN','BRN','96','673',1,1),(51,'bulgaria','BG','BGR','100','359',1,1),(52,'burkina-faso','BF','BFA','854','226',1,0),(53,'burma-myanmar','MM','MMR','104','095',1,1),(54,'burundi','BI','BDI','108','257',1,0),(55,'cambodia','KH','KHM','116','855',1,1),(56,'cameroon','CM','CMR','120','237',1,1),(57,'cape-verde-island','CV','CPV','132','238',1,1),(58,'cayman-islands','KY','CYM','136','345',1,1),(59,'central-african-republic','CF','CAF','140','236',1,0),(60,'chad','TD','TCD','148','235',1,1),(61,'chile','CL','CHL','152','056',1,1),(62,'christmas-island','CX','CXR','162','061',1,1),(63,'cocos-islands','CC','CCK','166','061',1,1),(64,'colombia','CO','COL','170','057',1,1),(65,'comoros','KM','COM','174','269',1,0),(66,'republic-of-congo','CD','COD','180','242',1,0),(67,'democratic-republic-of-congo','CG','COG','178','243',1,0),(68,'cook-islands','CK','COK','184','682',1,0),(69,'costa-rica','CR','CRI','188','506',1,1),(70,'croatia','HR','HRV','191','385',1,1),(71,'cuba','CU','CUB','192','053',1,1),(72,'cyprus','CY','CYP','196','357',1,1),(73,'czech-republic','CZ','CZE','203','420',1,1),(74,'denmark','DK','DNK','208','045',1,1),(75,'djibouti','DJ','DJI','262','253',1,0),(76,'dominica','DM','DMA','212','767',1,0),(77,'dominican-republic','DO','DOM','214','809',1,1),(78,'ecuador','EC','ECU','218','593',1,1),(79,'egypt','EG','EGY','818','020',1,1),(80,'el-salvador','SV','SLV','222','503',1,1),(81,'equatorial-guinea','GQ','GNQ','226','240',1,0),(82,'eritrea','ER','ERI','232','291',1,0),(83,'estonia','EE','EST','233','372',1,1),(84,'ethiopia','ET','ETH','231','251',1,1),(85,'faeroe-islands','FO','FRO','234','298',1,1),(86,'falkland-islands','FK','FLK','238','500',1,1),(87,'fiji-islands','FJ','FJI','242','679',1,0),(88,'finland','FI','FIN','246','358',1,1),(89,'french-guiana','GF','GUF','254','594',1,1),(90,'french-polynesia','PF','PYF','258','689',1,1),(91,'gabon','GA','GAB','266','241',1,1),(92,'gambia','GM','GMB','270','220',1,0),(93,'georgia','GE','GEO','268','995',1,1),(94,'ghana','GH','GHA','288','233',1,0),(95,'gibraltar','GI','GIB','292','350',1,1),(96,'greece','GR','GRC','300','030',1,1),(97,'greenland','GL','GRL','304','299',1,1),(98,'grenada','GD','GRD','308','473',1,0),(99,'guadeloupe','GP','GLP','312','590',1,1),(100,'guam','GU','GUM','316','671',1,1),(101,'guatemala','GT','GTM','320','502',1,1),(102,'guinea','GN','GIN','324','224',1,0),(103,'guinea-bissau','GW','GNB','624','245',1,1),(104,'guyana','GY','GUY','328','592',1,0),(105,'haiti','HT','HTI','332','509',1,1),(106,'honduras','HN','HND','340','504',1,1),(107,'iceland','IS','ISL','352','354',1,1),(108,'india','IN','IND','356','091',1,1),(109,'indonesia','ID','IDN','360','062',1,1),(110,'iran','IR','IRN','364','098',1,1),(111,'iraq','IQ','IRQ','368','964',1,1),(112,'ireland','IE','IRL','372','353',1,0),(113,'ivory-coast','CI','CIV','384','225',1,1),(114,'jamaica','JM','JAM','388','876',1,1),(115,'jordan','JO','JOR','400','962',1,1),(116,'kazakhstan','KZ','KAZ','398','007',1,1),(117,'kenya','KE','KEN','404','254',1,1),(118,'kiribati','KI','KIR','408','686',1,0),(119,'kuwait','KW','KWT','414','965',1,1),(120,'north-korea','KP','PRK','408','850',1,0),(121,'kyrgyzstan','KG','KGZ','471','996',1,1),(122,'laos','LA','LAO','418','856',1,1),(123,'latvia','LV','LVA','428','371',1,1),(124,'lebanon','LB','LBN','422','961',1,1),(125,'lesotho','LS','LSO','426','266',1,1),(126,'liberia','LR','LBR','430','231',1,1),(127,'libya','LY','LBY','434','218',1,1),(128,'liechtenstein','LI','LIE','438','423',1,1),(129,'lithuania','LT','LTU','440','370',1,1),(130,'luxembourg','LU','LUX','442','352',1,1),(131,'macau','MO','MAC','446','853',1,0),(132,'macedonia','MK','MKD','807','389',1,1),(133,'madagascar','MG','MDG','450','261',1,1),(134,'malawi','MW','MWI','454','265',1,0),(135,'malaysia','MY','MYS','458','060',1,1),(136,'maldives','MV','MDV','462','960',1,1),(137,'mali','ML','MLI','466','223',1,0),(138,'malta','MT','MLT','470','356',1,1),(139,'marshall-islands','MH','MHL','584','692',1,1),(140,'martinique','MQ','MTQ','474','596',1,1),(141,'mauritania','MR','MRT','478','222',1,0),(142,'mauritius','MU','MUS','480','230',1,0),(143,'mayotte-island','YT','MYT','175','269',1,1),(144,'mexico','MX','MEX','484','052',1,1),(145,'micronesia','FM','FSM','583','691',1,1),(146,'moldova','MD','MDA','498','373',1,1),(147,'monaco','MC','MCO','492','377',1,1),(148,'mongolia','MN','MNG','496','976',1,1),(149,'montenegro','ME','MNE','499','382',1,1),(150,'montserrat','MS','MSR','500','664',1,0),(151,'morocco','MA','MAR','504','212',1,1),(152,'mozambique','MZ','MOZ','508','258',1,1),(153,'namibia','NA','NAM','516','264',1,1),(154,'nauru','NR','NRU','520','674',1,0),(155,'nepal','NP','NPL','524','977',1,1),(156,'netherlands-antilles','AN','ANT','530','599',1,1),(157,'new-caledonia','NC','NCL','540','687',1,1),(158,'new-zealand','NZ','NZL','554','064',1,1),(159,'nicaragua','NI','NIC','558','505',1,1),(160,'niger','NE','NER','562','227',1,1),(161,'nigeria','NG','NGA','566','234',1,1),(162,'niue','NU','NIU','570','683',1,0),(163,'norfolk-island','NF','NFK','574','672',1,1),(164,'norway','NO','NOR','578','047',1,1),(165,'oman','OM','OMN','512','968',1,1),(166,'pakistan','PK','PAK','586','092',1,1),(167,'palau','PW','PLW','585','680',1,1),(168,'palestine','PS','PSE','275','970',1,1),(169,'panama','PA','PAN','591','507',1,1),(170,'papua-new-guinea','PG','PNG','598','675',1,1),(171,'paraguay','PY','PRY','600','595',1,1),(172,'peru','PE','PER','604','051',1,1),(173,'philippines','PH','PHL','608','063',1,1),(174,'poland','PL','POL','616','048',1,1),(175,'puerto-rico','PR','PRI','630','787',1,1),(176,'qatar','QA','QAT','634','974',1,0),(177,'reunion-island','RE','REU','638','262',1,1),(178,'romania','RO','ROU','642','040',1,1),(179,'rwanda','RW','RWA','646','250',1,0),(180,'st-helena','SH','SHN','654','290',1,1),(181,'st-kitts','KN','KNA','659','869',1,0),(182,'st-lucia','LC','LCA','662','758',1,0),(183,'st-pierre-miquelon','PM','SPM','666','508',1,1),(184,'st-vincent','VC','VCT','670','784',1,1),(185,'san-marino','SM','SMR','674','378',1,1),(186,'sao-tome-principe','ST','STP','678','239',1,0),(187,'saudi-arabia','SA','SAU','682','966',1,1),(188,'senegal','SN','SEN','686','221',1,1),(189,'serbia','RS','SRB','688','381',1,1),(190,'seychelles','SC','SYC','690','248',1,0),(191,'sierra-leone','SL','SLE','694','249',1,0),(192,'slovakia','SK','SVK','703','421',1,1),(193,'slovenia','SI','SVN','705','386',1,1),(194,'solomon-islands','SB','SLB','90','677',1,0),(195,'somalia','SO','SOM','706','252',1,0),(196,'south-africa','ZA','ZAF','710','027',1,1),(197,'sri-lanka','LK','LKA','144','094',1,1),(198,'sudan','SD','SDN','736','095',1,1),(199,'suriname','SR','SUR','740','597',1,0),(200,'swaziland','SZ','SWZ','748','268',1,1),(201,'sweden','SE','SWE','752','046',1,1),(202,'switzerland','CH','CHE','756','041',1,1),(203,'syria','SY','SYR','760','963',1,0),(204,'taiwan','TW','TWN','158','886',1,1),(205,'tajikistan','TJ','TJK','762','992',1,1),(206,'tanzania','TZ','TZA','834','255',1,0),(207,'thailand','TH','THA','764','066',1,1),(208,'togo','TG','TGO','768','228',1,1),(209,'tonga','TO','TON','776','676',1,0),(210,'trinidad-tobago','TT','TTO','780','868',1,0),(211,'tunisia','TN','TUN','788','216',1,1),(212,'turkmenistan','TM','TKM','795','993',1,1),(213,'turks-caicos','TC','TCA','796','649',1,1),(214,'tuvalu','TV','TUV','798','688',1,0),(215,'uganda','UG','UGA','800','256',1,0),(216,'ukraine','UA','UKR','804','380',1,1),(217,'united-arab-emirates','AE','ARE','784','971',1,0),(218,'uruguay','UY','URY','858','598',1,1),(219,'uzbekistan','UZ','UZB','860','998',1,1),(220,'vanuatu','VU','VUT','548','678',1,0),(221,'vatican-city','VA','VAT','336','039',1,1),(222,'venezuela','VE','VEN','862','058',1,1),(223,'wallis-futuna','WF','WLF','876','681',1,1),(224,'western-samoa','WS','WSM','882','685',1,1),(225,'yemen','YE','YEM','887','967',1,0),(226,'zambia','ZM','ZMB','894','260',1,1),(227,'zimbabwe','ZW','ZWE','716','263',1,0),(228,'aland-islands','AX','ALA','248','359',1,1),(229,'bonaire-st-eustatius-saba','BQ','BES','535','599',1,1),(230,'bouvet-island','BV','BVT','74','047',1,1),(231,'british-indian-ocean-territory','IO','IOT','86','246',1,1),(232,'curacao','CW','CUW','531','599',1,1),(233,'french-southern-territories','TF','ATF','260','033',1,0),(234,'guernsey','GG','GGY','831','044',1,1),(235,'heard-island-mcdonald-islands','HM','HMD','334','061',1,1),(236,'isle-of-man','IM','IMN','833','044',1,1),(237,'jersey','JE','JEY','832','044',1,1),(238,'northern-mariana-islands','MP','MNP','580','670',1,1),(239,'pitcairn','PN','PCN','612','649',1,1),(240,'south-georgia-south-sandwich-islands','GS','SGS','239','044',1,1),(241,'south-sudan','SS','SSD','728','211',1,1),(242,'sint-maarten','SX','SXM','534','721',1,1),(243,'st-barthelemy','BL','BLM','652','590',1,1),(244,'st-martin','MF','MAF','663','590',1,1),(245,'tokelau','TK','TKL','772','690',1,0),(246,'timor-leste','TL','TLS','626','670',1,1),(247,'united-states-minor-outlying-islands','UM','UMI','581','699',1,1),(248,'united-states-virgin-islands','VI','VIR','850','340',1,1),(249,'western-sahara','EH','ESH','732','212',1,1); /*!40000 ALTER TABLE `Country` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CyrusUser` -- DROP TABLE IF EXISTS `CyrusUser`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CyrusUser` ( `userId` varchar(75) NOT NULL, `password_` varchar(75) NOT NULL, PRIMARY KEY (`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `CyrusUser` -- LOCK TABLES `CyrusUser` WRITE; /*!40000 ALTER TABLE `CyrusUser` DISABLE KEYS */; /*!40000 ALTER TABLE `CyrusUser` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CyrusVirtual` -- DROP TABLE IF EXISTS `CyrusVirtual`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CyrusVirtual` ( `emailAddress` varchar(75) NOT NULL, `userId` varchar(75) NOT NULL, PRIMARY KEY (`emailAddress`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `CyrusVirtual` -- LOCK TABLES `CyrusVirtual` WRITE; /*!40000 ALTER TABLE `CyrusVirtual` DISABLE KEYS */; /*!40000 ALTER TABLE `CyrusVirtual` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DDLRecord` -- DROP TABLE IF EXISTS `DDLRecord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DDLRecord` ( `uuid_` varchar(75) DEFAULT NULL, `recordId` bigint(20) NOT NULL, `groupId` bigint(20) DEFAULT NULL, `companyId` bigint(20) DEFAULT NULL, `userId` bigint(20) DEFAULT NULL, `userName` varchar(75) DEFAULT NULL, `versionUserId` bigint(20) DEFAULT NULL, `versionUserName` varchar(75) DEFAULT NULL, `createDate` datetime DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `DDMStorageId` bigint(20) DEFAULT NULL, `recordSetId` bigint(20) DEFAULT NULL, `version` varchar(75) DEFAULT NULL, `displayIndex` int(11) DEFAULT NULL, PRIMARY KEY (`recordId`), UNIQUE KEY `IX_B4328F39` (`uuid_`,`groupId`), KEY `IX_87A6B599` (`recordSetId`), KEY `IX_AAC564D3` (`recordSetId`,`userId`), KEY `IX_8BC2F891` (`uuid_`), KEY `IX_6A6C1C85` (`companyId`), KEY `IX_384AB6F7` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DDLRecord` -- LOCK TABLES `DDLRecord` WRITE; /*!40000 ALTER TABLE `DDLRecord` DISABLE KEYS */; /*!40000 ALTER TABLE `DDLRecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DDLRecordSet` -- DROP TABLE IF EXISTS `DDLRecordSet`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DDLRecordSet` ( `uuid_` varchar(75) DEFAULT NULL, `recordSetId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `DDMStructureId` bigint(20) DEFAULT NULL, `recordSetKey` varchar(75) DEFAULT NULL, `name` longtext, `description` longtext, `minDisplayRows` int(11) DEFAULT NULL, `scope` int(11) DEFAULT NULL, PRIMARY KEY (`recordSetId`), UNIQUE KEY `IX_56DAB121` (`groupId`,`recordSetKey`), UNIQUE KEY `IX_270BA5E1` (`uuid_`,`groupId`), KEY `IX_4FA5969F` (`groupId`), KEY `IX_561E44E9` (`uuid_`), KEY `IX_5938C39F` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DDLRecordSet` -- LOCK TABLES `DDLRecordSet` WRITE; /*!40000 ALTER TABLE `DDLRecordSet` DISABLE KEYS */; /*!40000 ALTER TABLE `DDLRecordSet` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DDLRecordVersion` -- DROP TABLE IF EXISTS `DDLRecordVersion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DDLRecordVersion` ( `recordVersionId` 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 DEFAULT NULL, `DDMStorageId` bigint(20) DEFAULT NULL, `recordSetId` bigint(20) DEFAULT NULL, `recordId` bigint(20) DEFAULT NULL, `version` varchar(75) DEFAULT NULL, `displayIndex` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `statusByUserId` bigint(20) DEFAULT NULL, `statusByUserName` varchar(75) DEFAULT NULL, `statusDate` datetime DEFAULT NULL, PRIMARY KEY (`recordVersionId`), UNIQUE KEY `IX_C79E347` (`recordId`,`version`), KEY `IX_2F4DDFE1` (`recordId`), KEY `IX_762ADC7` (`recordId`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DDLRecordVersion` -- LOCK TABLES `DDLRecordVersion` WRITE; /*!40000 ALTER TABLE `DDLRecordVersion` DISABLE KEYS */; /*!40000 ALTER TABLE `DDLRecordVersion` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DDMContent` -- DROP TABLE IF EXISTS `DDMContent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DDMContent` ( `uuid_` varchar(75) DEFAULT NULL, `contentId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `name` longtext, `description` longtext, `xml` longtext, PRIMARY KEY (`contentId`), UNIQUE KEY `IX_EB9BDE28` (`uuid_`,`groupId`), KEY `IX_E3BAF436` (`companyId`), KEY `IX_50BF1038` (`groupId`), KEY `IX_AE4B50C2` (`uuid_`), KEY `IX_3A9C0626` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DDMContent` -- LOCK TABLES `DDMContent` WRITE; /*!40000 ALTER TABLE `DDMContent` DISABLE KEYS */; /*!40000 ALTER TABLE `DDMContent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DDMStorageLink` -- DROP TABLE IF EXISTS `DDMStorageLink`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DDMStorageLink` ( `uuid_` varchar(75) DEFAULT NULL, `storageLinkId` bigint(20) NOT NULL, `classNameId` bigint(20) DEFAULT NULL, `classPK` bigint(20) DEFAULT NULL, `structureId` bigint(20) DEFAULT NULL, PRIMARY KEY (`storageLinkId`), UNIQUE KEY `IX_702D1AD5` (`classPK`), KEY `IX_81776090` (`structureId`), KEY `IX_32A18526` (`uuid_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DDMStorageLink` -- LOCK TABLES `DDMStorageLink` WRITE; /*!40000 ALTER TABLE `DDMStorageLink` DISABLE KEYS */; /*!40000 ALTER TABLE `DDMStorageLink` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DDMStructure` -- DROP TABLE IF EXISTS `DDMStructure`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DDMStructure` ( `uuid_` varchar(75) DEFAULT NULL, `structureId` 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 DEFAULT NULL, `modifiedDate` datetime DEFAULT NULL, `classNameId` bigint(20) DEFAULT NULL, `structureKey` varchar(75) DEFAULT NULL, `name` longtext, `description` longtext, `xsd` longtext, `storageType` varchar(75) DEFAULT NULL, `type_` int(11) DEFAULT NULL, `parentStructureId` bigint(20) DEFAULT NULL, PRIMARY KEY (`structureId`), UNIQUE KEY `IX_85C7EBE2` (`uuid_`,`groupId`), UNIQUE KEY `IX_C8785130` (`groupId`,`classNameId`,`structureKey`), KEY `IX_31817A62` (`classNameId`), KEY `IX_4FBAC092` (`companyId`,`classNameId`), KEY `IX_C8419FBE` (`groupId`), KEY `IX_E61809C8` (`uuid_`), KEY `IX_B6ED5E50` (`groupId`,`classNameId`), KEY `IX_43395316` (`groupId`,`parentStructureId`), KEY `IX_657899A8` (`parentStructureId`), KEY `IX_20FDE04C` (`structureKey`), KEY `IX_F9FB8D60` (`uuid_`,`companyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `DDMStructure` -- LOCK TABLES `DDMStructure` WRITE; /*!40000 ALTER TABLE `DDMStructure` DISABLE KEYS */; INSERT INTO `DDMStructure` VALUES ('0e7c0f42-5b76-4428-bd89-0b46e49668bf',11615,10235,10202,10205,'','2016-11-22 18:01:50','2016-11-22 18:01:50',11573,'LEARNING MODULE METADATA','\n #if ($link.getData() != \"\")\n \n #end\n ![\"\"](\"$image.getData()\")
\n #if ($link.getData() != \"\")\n \n #end\n
',1,0,10490,'',11581,'SINGLE-IMAGE'),('08034de0-5008-4a0c-9ec6-e6fe1d6bb808',11805,10587,10202,10205,' ','2016-11-22 17:54:16','2016-11-22 17:54:16',11803,'Single Image','A single image, optional URL','display','create','vm','\n #if ($link.getData() != \"\")\n \n #end\n \n #if ($link.getData() != \"\")\n \n #end\n
',1,0,10601,'',11581,'SINGLE-IMAGE'),('c5dc8199-3357-410d-a90e-90b76df31909',11972,10235,10202,10205,'','2016-11-22 18:05:22','2016-11-22 18:05:22',0,'\n <#assign viewURL = renderResponse.createRenderURL() />\n\n ${viewURL.setParameter(\"struts_action\", \"/blogs/view_entry\")}\n ${viewURL.setParameter(\"redirect\", currentURL)}\n ${viewURL.setParameter(\"urlTitle\", entry.getUrlTitle())}\n\n
\n\n \n',0,0,11973,'',10068,'BLOGS-BASIC-FTL'),('581d9930-f66c-4fb9-b931-a06f1188d8cd',11974,10235,10202,10205,'','2016-11-22 18:05:22','2016-11-22 18:05:22',0,'\n \n
\n\n \n \n\n <#assign summary = entry.getDescription() />\n\n <#if (validator.isNull(summary))>\n <#assign summary = entry.getContent() />\n \n\n ${stringUtil.shorten(htmlUtil.stripHtml(summary), 100)}\n\n <@liferay.language key=\"read-more\" /> <@liferay.language key=\"about\"/>${htmlUtil.escape(entry.getTitle())} »\n
\n\n \n \n \n\n \n
\n\n <@getMetadataField fieldName=\"tags\" />\n\n <@getMetadataField fieldName=\"create-date\" />\n\n <@getMetadataField fieldName=\"view-count\" />\n\n
\n\n\n\n<#macro getDiscussion>\n <#if validator.isNotNull(assetRenderer.getDiscussionPath()) && (enableComments == \"true\")>\n \n ![\"\"](\"${assetRenderer.getIconPath(renderRequest)}\")
${entryTitle}\n
\n\n <@getMetadataField fieldName=\"tags\" />\n\n <@getMetadataField fieldName=\"create-date\" />\n\n <@getMetadataField fieldName=\"view-count\" />\n\n \n <@getSocialBookmarks />\n\n
\n \n <@getMetadataField fieldName=\"author\" />\n\n ${htmlUtil.escape(assetRenderer.getSummary(locale))}\n\n <@liferay.language key=\"read-more\" /><@liferay.language key=\"about\" />${entryTitle} »\n
\n\n <@getRatings />\n\n <@getRelatedAssets />\n\n <@getDiscussion />\n \n\n <#assign discussionURL = renderResponse.createActionURL() />\n\n ${discussionURL.setParameter(\"struts_action\", \"/asset_publisher/\" + assetRenderer.getDiscussionPath())}\n\n <@liferay_ui[\"discussion\"]\n className=entry.getClassName()\n classPK=entry.getClassPK()\n formAction=discussionURL?string\n formName=\"fm\" + entry.getClassPK()\n ratingsEnabled=enableCommentRatings == \"true\"\n redirect=portalUtil.getCurrentURL(request)\n userId=assetRenderer.getUserId()\n />\n \n\n\n<#macro getEditIcon>\n <#if assetRenderer.hasEditPermission(themeDisplay.getPermissionChecker())>\n <#assign redirectURL = renderResponse.createRenderURL() />\n\n ${redirectURL.setParameter(\"struts_action\", \"/asset_publisher/add_asset_redirect\")}\n ${redirectURL.setWindowState(\"pop_up\")}\n\n <#assign editPortletURL = assetRenderer.getURLEdit(renderRequest, renderResponse, windowStateFactory.getWindowState(\"pop_up\"), redirectURL)!\"\" />\n\n <#if validator.isNotNull(editPortletURL)>\n <#assign title = languageUtil.format(locale, \"edit-x\", entryTitle) />\n\n <@liferay_ui[\"icon\"]\n image=\"edit\"\n message=title\n url=\"javascript:Liferay.Util.openWindow({dialog: {width: 960}, id:\'\" + renderResponse.getNamespace() + \"editAsset\', title: \'\" + title + \"\', uri:\'\" + htmlUtil.escapeURL(editPortletURL.toString()) + \"\'});\"\n />\n \n \n\n\n<#macro getFlagsIcon>\n <#if enableFlags == \"true\">\n <@liferay_ui[\"flags\"]\n className=entry.getClassName()\n classPK=entry.getClassPK()\n contentTitle=entry.getTitle(locale)\n label=false\n reportedUserId=entry.getUserId()\n />\n \n\n\n<#macro getMetadataField\n fieldName\n>\n <#if stringUtil.split(metadataFields)?seq_contains(fieldName)>\n \n \n\n\n<#macro getPrintIcon>\n <#if enablePrint == \"true\" >\n <#assign printURL = renderResponse.createRenderURL() />\n\n ${printURL.setParameter(\"struts_action\", \"/asset_publisher/view_content\")}\n ${printURL.setParameter(\"assetEntryId\", entry.getEntryId()?string)}\n ${printURL.setParameter(\"viewMode\", \"print\")}\n ${printURL.setParameter(\"type\", entry.getAssetRendererFactory().getType())}\n\n <#if (validator.isNotNull(assetRenderer.getUrlTitle()))>\n <#if (assetRenderer.getGroupId() != themeDisplay.getScopeGroupId())>\n ${printURL.setParameter(\"groupId\", assetRenderer.getGroupId()?string)}\n \n\n ${printURL.setParameter(\"urlTitle\", assetRenderer.getUrlTitle())}\n \n\n ${printURL.setWindowState(\"pop_up\")}\n\n <@liferay_ui[\"icon\"]\n image=\"print\"\n message=\"print\"\n url=\"javascript:Liferay.Util.openWindow({id:\'\" + renderResponse.getNamespace() + \"printAsset\', title: \'\" + languageUtil.format(locale, \"print-x-x\", [\"hide-accessible\", entryTitle]) + \"\', uri: \'\" + htmlUtil.escapeURL(printURL.toString()) + \"\'});\"\n />\n \n\n\n<#macro getRatings>\n <#if (enableRatings == \"true\")>\n \n \n\n\n<#macro getRelatedAssets>\n <#if enableRelatedAssets == \"true\">\n <@liferay_ui[\"asset-links\"]\n assetEntryId=entry.getEntryId()\n />\n \n\n\n<#macro getSocialBookmarks>\n <#if enableSocialBookmarks == \"true\">\n <@liferay_ui[\"social-bookmarks\"]\n displayStyle=\"${socialBookmarksDisplayStyle}\"\n target=\"_blank\"\n title=entry.getTitle(locale)\n url=viewURL\n />\n \n',0,0,11975,'',10062,'ASSET-PUBLISHER-RICH-SUMMARY-FTL'),('63b4d756-ecf5-4460-b492-32f4b8f9624f',11976,10235,10202,10205,'','2016-11-22 18:05:22','2016-11-22 18:05:22',0,'
\n
\n\n <#assign pages = entry.getChildren()>\n\n <@displayPages pages = pages />\n \n \n \n\n\n<#macro displayPages\n pages\n>\n <#if pages?has_content>\n \n <#assign layoutURL = portalUtil.getLayoutURL(entry, themeDisplay)>\n\n ${entry.getName(locale)}\n
\n- \n <#list pages as page>\n
- \n <#assign pageLayoutURL = portalUtil.getLayoutURL(page, themeDisplay)>\n\n ${page.getName(locale)}\n\n <#assign childPages = page.getChildren()>\n\n <@displayPages pages = childPages />\n \n \n
\n ![](\"${dlUtil.getPreviewURL(entry,)
\n
\n \n \n \n\n <@aui.script use=\"aui-carousel\">\n new A.Carousel(\n {\n contentBox: \'#<@liferay_portlet.namespace />carousel\',\n height: 250,\n intervalTime: 2,\n width: 700\n }\n ).render();\n \n',0,0,11980,'',11978,'DOCUMENTLIBRARY-CAROUSEL-FTL'),('41ab20c7-5320-4a4e-94ec-cf7eddaac901',11981,10235,10202,10205,'','2016-11-22 18:05:22','2016-11-22 18:05:22',0,'\n
\n\n${entry.getTitle()}
\n\n <@getEditIcon />\n\n <@getPageDetailsIcon />\n\n <@getPrintIcon />\n
\n\n\n
\n\n <@getRatings cssClass=\"page-ratings\" entry=entry />\n\n <@getRelatedAssets />\n
\n\n\n ${assetEntry.getViewCount()} <@liferay.language key=\"views\" /> |\n\n <@liferay.language key=\"last-modified\" /> ${dateUtil.getDate(entry.getModifiedDate(), \"dd MMM yyyy - HH:mm:ss\", locale)}\n\n \n
\n\n \n <@liferay_ui[\"social-bookmarks\"]\n displayStyle=\"normal\"\n target=\"_blank\"\n title=entry.getTitle()\n url=viewURL\n />\n\n ${formattedContent}\n
\n\n \n
\n\n \n <@getAddChildPageIcon />\n\n <@getAttatchmentsIcon />\n
\n \n\n <@getRatings cssClass=\"page-ratings\" entry=entry />\n\n <@getRelatedAssets />\n
\n
\n\n<#assign childPages = entry.getChildPages() />\n\n<#if (childPages?has_content)>\n \n <#assign viewCategorizedPagesURL = renderResponse.createRenderURL() />\n\n ${viewCategorizedPagesURL.setParameter(\"struts_action\", \"/wiki/view_categorized_pages\")}\n ${viewCategorizedPagesURL.setParameter(\"nodeId\", entry.getNodeId()?string)}\n\n <@liferay_ui[\"asset-categories-summary\"]\n className=wikiPageClassName\n classPK=entry.getResourcePrimKey()\n portletURL=viewCategorizedPagesURL\n />\n
\n\n \n\n \n
\n
\n\n\n<@getDiscussion />\n\n<#macro getAddChildPageIcon>\n <#if assetRenderer.hasEditPermission(themeDisplay.getPermissionChecker())>\n <#assign addPageURL = renderResponse.createRenderURL() />\n\n ${addPageURL.setParameter(\"struts_action\", \"/wiki/edit_page\")}\n ${addPageURL.setParameter(\"redirect\", currentURL)}\n ${addPageURL.setParameter(\"nodeId\", entry.getNodeId()?string)}\n ${addPageURL.setParameter(\"title\", \"\")}\n ${addPageURL.setParameter(\"editTitle\", \"1\")}\n ${addPageURL.setParameter(\"parentTitle\", entry.getTitle())}\n\n <@liferay_ui[\"icon\"]\n image=\"add_article\"\n label=true\n message=\"add-child-page\"\n url=addPageURL?string\n />\n \n\n\n<#macro getAttatchmentsIcon>\n <#assign viewPageAttachmentsURL = renderResponse.createRenderURL() />\n\n ${viewPageAttachmentsURL.setParameter(\"struts_action\", \"/wiki/view_page_attachments\") }\n\n <@liferay_ui[\"icon\"]\n image=\"clip\"\n label=true\n message=\'${entry.getAttachmentsFileEntriesCount() + languageUtil.get(locale, \"attachments\")}\'\n url=viewPageAttachmentsURL?string\n />\n\n\n<#macro getDiscussion>\n <#if validator.isNotNull(assetRenderer.getDiscussionPath()) && (enableComments == \"true\")>\n <@liferay.language key=\"children-pages\" />
\n\n| \n <@liferay.language key=\"page\" />\n | \n\n <@liferay.language key=\"last-modified\" />\n | \n\n <@liferay.language key=\"ratings\" />\n | \n
|---|---|---|
| \n ${childPage.getTitle()}\n | \n\n ${dateUtil.getDate(childPage.getModifiedDate(),\"dd MMM yyyy - HH:mm:ss\", locale)} <@liferay.language key=\"by\" /> ${htmlUtil.escape(portalUtil.getUserName(childPage.getUserId(), childPage.getUserName()))}\n | \n\n <@getRatings cssClass=\"child-ratings\" entry=childPage />\n | \n
\n\n <#assign discussionURL = renderResponse.createActionURL() />\n\n ${discussionURL.setParameter(\"struts_action\", \"/wiki/\" + assetRenderer.getDiscussionPath())}\n\n <@liferay_ui[\"discussion\"]\n className=wikiPageClassName\n classPK=entry.getResourcePrimKey()\n formAction=discussionURL?string\n formName=\"fm2\"\n ratingsEnabled=enableCommentRatings == \"true\"\n redirect=currentURL\n subject=assetRenderer.getTitle(locale)\n userId=assetRenderer.getUserId()\n />\n \n\n\n<#macro getEditIcon>\n <#if assetRenderer.hasEditPermission(themeDisplay.getPermissionChecker())>\n <#assign editPageURL = renderResponse.createRenderURL() />\n\n ${editPageURL.setParameter(\"struts_action\", \"/wiki/edit_page\")}\n ${editPageURL.setParameter(\"redirect\", currentURL)}\n ${editPageURL.setParameter(\"nodeId\", entry.getNodeId()?string)}\n ${editPageURL.setParameter(\"title\", entry.getTitle())}\n\n <@liferay_ui[\"icon\"]\n image=\"edit\"\n message=entry.getTitle()\n url=editPageURL?string\n />\n \n\n\n<#macro getPageDetailsIcon>\n <#assign viewPageDetailsURL = renderResponse.createRenderURL() />\n\n ${viewPageDetailsURL.setParameter(\"struts_action\", \"/wiki/view_page_details\")}\n ${viewPageDetailsURL.setParameter(\"redirect\", currentURL)}\n\n <@liferay_ui[\"icon\"]\n image=\"history\"\n message=\"details\"\n url=viewPageDetailsURL?string\n />\n\n\n<#macro getPrintIcon>\n <#assign printURL = renderResponse.createRenderURL() />\n\n ${printURL.setParameter(\"viewMode\", \"print\")}\n ${printURL.setWindowState(\"pop_up\")}\n\n <#assign title = languageUtil.format(locale, \"print-x-x\", [\"hide-accessible\", htmlUtil.escape(assetRenderer.getTitle(locale))]) />\n <#assign taglibPrintURL = \"javascript:Liferay.Util.openWindow({dialog: {width: 960}, id:\'\" + renderResponse.getNamespace() + \"printAsset\', title: \'\" + title + \"\', uri: \'\" + htmlUtil.escapeURL(printURL.toString()) + \"\'});\" />\n\n <@liferay_ui[\"icon\"]\n image=\"print\"\n message=\"print\"\n url=taglibPrintURL\n />\n\n\n<#macro getRatings\n cssClass\n entry\n>\n <#if enablePageRatings == \"true\">\n
\n <@liferay_ui[\"ratings\"]\n className=wikiPageClassName\n classPK=entry.getResourcePrimKey()\n />\n
\n \n\n\n<#macro getRelatedAssets>\n <#if assetEntry?? && (enableRelatedAssets == \"true\")>\n <@liferay_ui[\"asset-links\"]\n assetEntryId=assetEntry.getEntryId()\n />\n \n',0,0,11982,'',10129,'WIKI-SOCIAL-FTL'),('b7d47c09-67e1-4a2c-aa61-0fef953dd7ff',11983,10235,10202,10205,'','2016-11-22 18:05:22','2016-11-22 18:05:22',0,'- \n <#assign scopeGroupId = getterUtil.getLong(scopeGroupId, themeDisplay.getScopeGroupId()) />\n <#assign classNameId = getterUtil.getLong(classNameId, 0) />\n\n <#assign maxCount = 1 />\n <#assign minCount = 1 />\n\n <#list entries as entry>\n <#assign maxCount = liferay.max(maxCount, entry.getAssetCount()) />\n <#assign minCount = liferay.min(minCount, entry.getAssetCount()) />\n \n\n <#assign multiplier = 1 />\n\n <#if maxCount != minCount>\n <#assign multiplier = 3 / (maxCount - minCount) />\n \n\n <#list entries as entry>\n \n \n
\n',0,0,11984,'',10064,'ASSET-TAGS-NAVIGATION-COLOR-BY-POPULARITY-FTL'),('e331676e-9cd4-4e00-897f-e0b208a57950',11985,10235,10202,10205,'','2016-11-22 18:05:22','2016-11-22 18:05:22',0,'
\n
\n\n <#assign categories = entry.getCategories()>\n\n <@displayCategories categories=categories />\n \n \n \n\n\n<#macro displayCategories\n categories\n>\n <#if categories?has_content>\n \n ${entry.getName()}\n
\n- \n <#list categories as category>\n
- \n <#assign categoryURL = renderResponse.createRenderURL()>\n\n ${categoryURL.setParameter(\"resetCur\", \"true\")}\n ${categoryURL.setParameter(\"categoryId\", category.getCategoryId()?string)}\n\n ${category.getName()}\n\n <#if serviceLocator??>\n <#assign assetCategoryService = serviceLocator.findService(\"com.liferay.portlet.asset.service.AssetCategoryService\")>\n\n <#assign childCategories = assetCategoryService.getChildCategories(category.getCategoryId())>\n\n <@displayCategories categories=childCategories />\n \n \n \n
\n ![\"Shared](\"/image/image_gallery?uuid=23a1b7d8-a446-4d88-b288-d74eb2f0986f&groupId=10227\")
\n\n ![\"Liferay](\"/image/image_gallery?uuid=fada6a18-d179-4f70-8b15-185b5db60195&groupId=10227\")
\n\n ![\"Liferay](\"/image/image_gallery?uuid=bf41b99a-4f5d-4ed9-aec0-fce2a143a4da&groupId=10227\")
\n\n ![\"Platform](\"/image/image_gallery?uuid=bcde623b-42f5-4871-9ade-44052d10fadd&groupId=10227\")
\n\n
\n\n
\n ]]>\n \n Welcome to Liferay\n
\n\n\n\n \n Liferay is a complete, all-in-one open source enterprise portal solution and web application platform.\n
\n\n\n It has over one hundred thousand deployments worldwide with sites from small businesses to Fortune 500 companies. We\'ve purposed Liferay for everything from a portal, a CMS to a web application platform. We hope you enjoy this preview release of Liferay 6.0. Take a look around, and maybe for starters, click on one of the users on the bottom right hand corner of the screen.\n
\n\n\n Once you\'re done taking a look around, and if you haven\'t decided yet, you might want to ask yourself this question: "what are you going to use Liferay for?"\n
\n\nAs a Portal
\n\n\n Portals are designed to unify information. Liferay was designed with people in mind. We know how important it is to communicate within companies and here\'s some of the ways we try to make it easier for you.\n
\n\nShared Workspaces
\n\n\n Increase productivity by creating workspaces and workflows for documents, content, and more. Create a central meeting place for everyone related to a project; now then, imagine getting everyone on the same \"page,\" no matter where they are.\n
\n\nSocial Communities and Networks
\n\n\n\n \n Remember Eddie, Olivia, and Johnny from accounting? What about Tom, Ryan, Jenn, and Steve from professional services? How do they communicate? E-mail can only go so far and instant messages can get lost or deleted. Now you\'re probably wondering, is there a better way?\n
\n\n\n Communicate, collaborate, and consolidate information...\n\n\n
\n By creating communities for different departments or groups within your company, then leveraging blogs, wikis, message boards, and shared calendars and get them organized and talking. With Liferay 6.0 we\'ve improved this with community templates. When creating a new community, just specify the type of community, we\'ll propagate pages with portlets commonly associated with that community, then just edit and save to your liking.\n
\n\nContent Management System
\n\n\n\n \n Liferay isn\'t just an internal portal, as an external and facing portal, you\'ll have the tools you need to create beautiful, dynamic websites. Create content through an editorial workflow then use and re-use that content ubiquitously through your portal.\n
\n\n\n In this release, we\'ve made many improvements to make finding and publishing your content as global as possible.\n
\n\nAs a Platform
\n\n\n\n \n Liferay is a robust web application platform.It\'s open source so developers can see how things work.\n
\n\nSOA
\n\n\n Speed up development with built-in developer tools, LDAP, web services, and Spring-based architecture. Rapidly produce portlets and applications that cater to your needs.\n
\n\nEnterprise Integration
\n\n\n We meet industry standards which reduces risk and increases re-usability from within Liferay.\n
\n\nMashups
\n\n\n Liferay supports mashup development with support for widgets, Facebook® integration, iGoogle® support, and GoogleMaps®\n
\n\nSome Companies That Use Liferay
\n\n\n Cisco Developer Network, Monster Energy Drink, Teambeachbody.com, EA Mobile, Poken, FCC Reboot, and many corporate intranet sites... for case studies and more, visit Liferay: Stories.\n
\n\n\n\n
Build With Us
\n\n\n What else does Liferay, as a company, do? We provide services.\n
\n\n- \n
- \n We offer Enterprise Support, 24 hours a day, seven days a week.\n \n
- \n Training tailored to fit your organization\'s needs.\n \n
- \n Through our consulting services, our experts are available to help you at every stage of the application\'s lifecycle.\n \n
- \n If you develop for the Liferay application, why not partner with us and help us build.\n \n
\n Visit Liferay.com, for updates, events, and join our community.\n
\n![\"\"](\"/image/image_gallery?uuid=b976fd0b-fe08-426e-933f-bad870fa3df3&groupId=10227\")
\n \n \n ]]>\n ![\"\"](\"/image/image_gallery?uuid=c347888a-470f-404e-b645-5cf1e60af860&groupId=10227\")
\n \n \n ]]>\n ![\"\"](\"/html/js/editor/fckeditor/editor/images/smiley/msn/lightbulb.gif\")
These sample sites highlight features of Liferay 6.0\n \n\n \n The current page is the default page each user first sees when he gets to your portal. By default, unauthenticated users are Guest users, so they are redirected to the guest community: @portal_url@/web/guest/\n
\n\n\n You can create any number of organizations or communities within the portal which will have their own public and private pages. One organization called 7cogs has already been created.\n
\n\n \n\n \n ]]>\n\n ![](\"/image/image_gallery?uuid=4358cb75-aa7a-4a9c-a340-321ebf48c3cd&groupId=10587)\")
\n
\n \n ]]>\n \n \n
\n \n ]]>\n \n
\n \n \n \n
\n \n
\n \n ]]>\n \n
\n \n \n \n
\n \n Visit the Blog!\n
\n\n Read about the latest stuff from the 7Cogs!\n
\n\n
\n \n ]]>\n \n
\n \n \n \n
\n \n To the Forums!\n
\n\n Voice your concerns and discuss with other members.\n
\n\n Leading Innovation in the Cog Industry\n
\n\n Introducing the ViX-998: Social Networking for The Cogs Industry\n
\n \n\n One morning, when Gregor Samsa woke from troubled dreams, he found himself transformed in his bed into a horrible vermin.\n He lay on his armour-like back, and if he lifted his head a little he could see his brown belly, slightly domed and divided by arches into stiff sections.\n The bedding was hardly able to cover it and seemed ready to slide off any moment.\n His many legs, pitifully thin compared with the size of the rest of him, waved about helplessly as he looked.\n \"What\'s happened to me?\" he thought.\n It wasn\'t a dream.\n His room, a proper human room although a little too small, lay peacefully between its four familiar walls.\n A collection of textile samples lay spread out on the table - Samsa was a travelling salesman - and above it there hung a picture that he had recently cut out of an illustrated magazine and housed in a nice, gilded frame.\n It showed a lady fitted out with a fur hat and fur boa who sat upright, raising a heavy fur muff that covered the whole of her lower arm towards the viewer.\n Gregor then turned to look out the window at the dull weather.\n
\n\n Read more about it >\n
\n \n ]]>\nAdvertisement
\n\n\n
\n \n\n \n \n
\n \n 7 Cogs Awesomeness\n
\n- \n
- \n 1st Point of Awesomeness\n \n
- \n 2nd Point of Awesomeness\n \n
\n ![](\"/image/image_gallery?uuid=ce41045e-574c-4a0f-9536-0b0858d78ce6&groupId=10587\")
\n
\n \n ]]>\n \n \n Introducing the ViX-998\n
\n\n Social Networking for the Cogs Industry\n
\n \n\n One morning, when Gregor Samsa woke from troubled dreams, he found himself transformed in his bed into a horrible vermin.\n He lay on his armour-like back, and if he lifted his head a little he could see his brown belly, slightly domed and divided by arches into stiff sections.\n The bedding was hardly able to cover it and seemed ready to slide off any moment.\n His many legs, pitifully thin compared with the size of the rest of him, waved about helplessly as he looked.\n \"What\'s happened to me?\" he thought.\n It wasn\'t a dream.\n His room, a proper human room although a little too small, lay peacefully between its four familiar walls.\n A collection of textile samples lay spread out on the table - Samsa was a travelling salesman - and above it there hung a picture that he had recently cut out of an illustrated magazine and housed in a nice, gilded frame.\n It showed a lady fitted out with a fur hat and fur boa who sat upright, raising a heavy fur muff that covered the whole of her lower arm towards the viewer.\n Gregor then turned to look out the window at the dull weather.\n
\n\n Read more about it >\n
\n \n ]]>\n\n Advertisement\n
\n\n
\n \n ]]>\n \n
\n \n \n \n
\n \n Titanium Series\n
\n\n- \n
- \n ViX-998\n \n
- \n ViX-988\n \n
- \n ViX-876\n \n
\n \n \n
\n \n Adamantium Series\n
\n\n- \n
- \n WvE-X\n \n
- \n WvE-X23\n \n
- \n WpN-X\n \n
\n \n \n
\n \n Vibranium Series\n
\n\n- \n
- \n CpA-1917\n \n
- \n CpA-1945\n \n
- \n WkD-889\n \n
![\"\"](\"/image/image_gallery?uuid=dd0a47ee-2316-4ad2-b7f8-f861d3fb3437&groupId=10587&t=1229384453062\")
\n \n \n To find out more about Liferay, please visit our website www.liferay.com\n
\n These are the private pages of the 7Cogs Organization, which means that only members of this organization can see them and by default, only the Organization Administrator can edit them. To define a more advanced permission system, other Organization Roles can be created in the Control Panel\n \n\n \n In Liferay you can create as many organizations and communities as you want and each will have its own public and private pages. Public pages can be used for a public website as anybody can see them. Private pages can be used for an intranet as only the members belonging to that organization or community can see them.\n
\n ]]>\n Only the members of the 7cogs organization can see the documents and images on this page. By default only the Administrator can upload new files and create folders.\n \n ]]>\n \n We specialize in manufacturing and developing gears, sprockets, cogs, bearings, and everything in between.\n
\n\n\n Full Product Line and Services:\n
\n\n- \n
- \n Cogs, Sprockets, Springs, Bearings...\n \n
- \n Gearbox Assembly\n \n
- \n Custom CNC\n \n
\n Products\n
\n\n\n UiB-612\n
\n\n\n
\n UiB-612 ipsum dolor sit amet, consectetur adipiscing elit. Aliquam viverra pellentesque ante ut tristique. Etiam non elit nibh, id laoreet felis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla sit amet quam risus, eleifend porta massa. Nam suscipit lectus blandit arcu rutrum vitae semper dui porttitor. Curabitur rutrum ultricies mi, at aliquet nisi auctor sit amet. Fusce sed iaculis sapien.\n
![\"\"](\"/image/image_gallery?uuid=219d7ad3-126c-4cdf-8e9f-34fd980b555f&groupId=10912\")
\n ZiB-550\n
\n\n\n
\n ZiB-550 ipsum dolor sit amet, consectetur adipiscing elit. Aliquam viverra pellentesque ante ut tristique. Etiam non elit nibh, id laoreet felis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Nulla sit amet quam risus, eleifend porta massa. Nam suscipit lectus blandit arcu rutrum vitae semper dui porttitor. Curabitur rutrum ultricies mi, at aliquet nisi auctor sit amet. Fusce sed iaculis sapien.\n
![\"\"](\"/image/image_gallery?uuid=22b4f239-6ec9-44ac-9a58-0925ce57643f&groupId=10912\")
Bruno's Public Page\n \n\n \n My name is Bruno Admin. My Role in 7Cogs Inc. is the portal administrator. I have all the priveleges you\'d expext from an Administrator, like:\n
\n\n- \n
- \n The ability to add and delete pages, articles, portlets ect..\n \n
- \n I can assign roles for editors, contributors, staff members and give them the most appropriate privileges\n \n
- \n I\'m also able to configure Liferay to suit the preferences of my company\n \n
\n This is my personal space (My Own Community). I have 2 public pages: "Profile" and "Blog". Everybody can see these pages by going to @portal_url@/web/bruno but only I can modify the content in them.\n
\n\n\n I also have a few private pages that only I can see (my socialSpace, my workSpace and my email). When I\'m logged in, I\'m able to access the pages using the Dockbar then clicking on the "Go to" button, and selecting the → "My Private Pages".\n
\n ]]>\n Bruno's Private Page\n \n\n \n These are my private pages. Only I can see them, edit them and create new ones.\n
\n\n- \n
- \n Social Space - Shows my friends and their activities.\n \n
- \n Work Space - Has my calendar, documents, images...\n \n
- \n Email - I can configure this page to view my emails.\n \n
\n To add more applications just go to the Dockbar and click on the "+ Add" button. It should bring out a menu, from there, you\'ll be able to add a pages and applications.\n
\n\n\n Third Party Widgets:\n
\n\n\n You can also add widgets from any other website. I have already added a widget for facebook which was very easy, by following these steps:\n
\n\n- \n
- \n On the Dockbar, click on the "+ Add" button then the → "More..." selection, from there you can search for the "iframe" portlet\n \n
- \n After adding the application, go to the Configuration menu (Cog shaped of the portlet when borders are hidden, or the wrench icon) and set the Url to the third party widget, in our case, we used: iphone.facebook.com\n \n
- \n Click on "Save," then refresh the page\n \n
\n With this method, you\'ll be able to use almost any page designed for the iPhone as a widget in your Liferay Portal instance.\n
\n ]]>\n These documents and images are on my private pages, so only I can see them or use them.\n \n\n \n In order to share folders, documents or images with the users of an organization or community you should use the private pages of that organization or community. To see an example, access the private pages of the organization 7Cogs and find a page called Shared documents. Only the members of that organization can access the private pages. If you only want some users of the organization to be able to access that page you would define a role for them and define permissions for that role.\n
\n ]]>\n Michelle's Public Page\n \n\n \n My name is John Regular. I\'m a pretty regular guy with a pretty regular role in 7Cogs inc. This is my personal space (My Own Community). I have 2 public pages: "Profile" and "Blog". Everybody can see these pages by going to @portal_url@/web/michelle but only I can modify the content in them.\n
\n\n\n I also have a few private pages that only I can see (my socialSpace, my workSpace and my email). When I\'m logged in, I\'m able to access the pages using the Dockbar then clicking on the "Go to" button, and selecting the → "My Private Pages".\n
\n ]]>\n John's Private Page\n \n\n \n These are my private pages. Only I can see them, edit them and create new ones.\n
\n\n- \n
- \n Social Space - Shows my friends and their activities.\n \n
- \n Work Space - Has my calendar, documents, images...\n \n
- \n Email - I can configure this page to view my emails.\n \n
\n To add more applications just go to the Dockbar and click on the "+ Add" button. It should bring out a menu, from there, you\'ll be able to add a pages and applications.\n
\n\n\n Third Party Widgets:\n
\n\n\n You can also add widgets from any other website. I have already added a widget for facebook which was very easy, by following these steps:\n
\n\n- \n
- \n On the Dockbar, click on the "+ Add" button then the → "More..." selection, from there you can search for the "iframe" portlet\n \n
- \n After adding the application, go to the Configuration menu (Cog shaped of the portlet when borders are hidden, or the wrench icon) and set the Url to the third party widget, in our case, we used: http://iphone.facebook.com\n \n
- \n Click on "Save," then refresh the page\n \n
\n With this method, you\'ll be able to use almost any page designed for the iPhone as a widget in your Liferay Portal instance.\n
\n ]]>\n These documents and images are on my private pages, so only I can see them or use them.\n \n\n \n In order to share folders, documents or images with the users of an organization or community you should use the private pages of that organization or community. To see an example, access the private pages of the organization 7Cogs and find a page called Shared documents. Only the members of that organization can access the private pages. If you only want some users of the organization to be able to access that page you would define a role for them and define permissions for that role.\n
\n ]]>\n Michelle's Public Page\n \n\n \n My name is Michelle Writer. My Role in 7Cogs Inc. is a writer. This is my personal space (My Own Community). I have 2 public pages: "Profile" and "Blog". Everybody can see these pages by going to @portal_url@/web/michelle but only I can modify the content in them.\n
\n\n\n I also have a few private pages that only I can see (my socialSpace, my workSpace and my email). When I\'m logged in, I\'m able to access the pages using the Dockbar then clicking on the "Go to" button, and selecting the → "My Private Pages".\n
\n ]]>\n Michelle's Private Page\n \n\n \n These are my private pages. Only I can see them, edit them and create new ones.\n
\n\n- \n
- \n Social Space - Shows my friends and their activities.\n \n
- \n Work Space - Has my calendar, documents, images...\n \n
- \n Email - I can configure this page to view my emails.\n \n
\n To add more applications just go to the Dockbar and click on the "+ Add" button. It should bring out a menu, from there, you\'ll be able to add a pages and applications.\n
\n\n\n Third Party Widgets:\n
\n\n\n You can also add widgets from any other website. I have already added a widget for facebook which was very easy, by following these steps:\n
\n\n- \n
- \n On the Dockbar, click on the "+ Add" button then the → "More..." selection, from there you can search for the "iframe" portlet\n \n
- \n After adding the application, go to the Configuration menu (Cog shaped of the portlet when borders are hidden, or the wrench icon) and set the Url to the third party widget, in our case, we used: http://m.digg.com/\n \n
- \n Click on "Save," then refresh the page\n \n
\n With this method, you\'ll be able to use almost any page designed for the iPhone as a widget in your Liferay Portal instance.\n
\n ]]>\n These documents and images are on my private pages, so only I can see them or use them.\n \n\n \n In order to share folders, documents or images with the users of an organization or community you should use the private pages of that organization or community. To see an example, access the private pages of the organization 7Cogs and find a page called Shared documents. Only the members of that organization can access the private pages. If you only want some users of the organization to be able to access that page you would define a role for them and define permissions for that role.\n
\n ]]>\n Richard's Public Page\n \n\n \n Hi, my name is Richard, I\'m the publisher here on 7Cogs. I\'ve been authorized by Bruno Admin within this portal to have article submission rights for the content management system.\n
\n\n\n This is my personal space (My Own Community). I have 2 public pages: "Profile" and "Blog". Everybody can see these pages by going to @portal_url@/web/richard but only I can modify the content in them.\n
\n\n\n I also have a few private pages that only I can see (my socialSpace, my workSpace and my email). When I\'m logged in, I\'m able to access the pages using the Dockbar then clicking on the "Go to" button, and selecting the → "My Private Pages".\n
\n ]]>\n Richard's Private Page\n \n\n \n These are my private pages. Only I can see them, edit them and create new ones.\n
\n\n- \n
- \n Social Space - Shows my friends and their activities.\n \n
- \n Work Space - Has my calendar, documents, images...\n \n
- \n Email - I can configure this page to view my emails.\n \n
\n To add more applications just go to the Dockbar and click on the "+ Add" button. It should bring out a menu, from there, you\'ll be able to add a pages and applications.\n
\n\nThird Party Widgets:
\n\n\n You can also add widgets from any other website. I have already added a widget for facebook which was very easy, by following these steps:\n
\n\n- \n
- \n On the Dockbar, click on the "+ Add" button then the → "More..." selection, from there you can search for the "iframe" portlet\n \n
- \n After adding the application, go to the Configuration menu (Cog shaped of the portlet when borders are hidden, or the wrench icon) and set the Url to the third party widget, in our case, we used: http://m.linkedin.com\n \n
- \n Click on "Save," then refresh the page\\\n \n
\n With this method, you\'ll be able to use almost any page designed for the iPhone as a widget in your Liferay Portal instance.\n
\n ]]>\n These documents and images are on my private pages, so only I can see them or use them.\n \n\n \n In order to share folders, documents or images with the users of an organization or community you should use the private pages of that organization or community. To see an example, access the private pages of the organization 7Cogs and find a page called Shared documents. Only the members of that organization can access the private pages. If you only want some users of the organization to be able to access that page you would define a role for them and define permissions for that role.\n
\n ]]>\n