1
 2CREATE TABLE `bookmarksfolder` (
 3[size=6] [b]`uuid_` varchar(75) collate utf8_unicode_ci default NULL,[/b][/size]
 4  `folderId` bigint(20) NOT NULL,
 5  `groupId` bigint(20) default NULL,
 6  `companyId` bigint(20) default NULL,
 7  `userId` bigint(20) default NULL,
 8  `userName` varchar(75) collate utf8_unicode_ci default NULL,
 9  `createDate` datetime default NULL,
10  `modifiedDate` datetime default NULL,
11  `resourceBlockId` bigint(20) default NULL,
12  `parentFolderId` bigint(20) default NULL,
13  `name` varchar(75) collate utf8_unicode_ci default NULL,
14  `description` longtext collate utf8_unicode_ci,
15  PRIMARY KEY  (`folderId`),
16  UNIQUE KEY `IX_DC2F8927` (`uuid_`,`groupId`),
17  KEY `IX_2ABA25D7` (`companyId`),
18  KEY `IX_7F703619` (`groupId`),
19  KEY `IX_967799C0` (`groupId`,`parentFolderId`),
20  KEY `IX_28A49BB9` (`resourceBlockId`),
21  KEY `IX_451E7AE3` (`uuid_`)
22) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;