Usefull queries for Liferay

queries.sql.md

Shows the ratings on assets

SELECT * FROM RatingStats;

select * from AssetEntry
select * from DDMStructure
select * from DDLRecordSet
select * from DLFolder

SELECT companyId, entryId, tagId
FROM liferay.AssetEntries_AssetTags;

SELECT uuid_, tagId, groupId, companyId, userId, userName, createDate, modifiedDate, name, assetCount, lastPublishDate
FROM liferay.AssetTag;

INSERT INTO FOO_Foo (fooId,field1)
VALUES (1,"value xyz");

drop table FOO_Foo;

/* for cleaning some tables when deploying updated service builder service */
/* THIS WILL DELETE ALL CONTENT !!!! */
delete FROM ServiceComponent where buildNamespace="FOO";
delete FROM Release_ WHERE servletContextName = 'com.acme.foo.sb.service';

-- Find structurekey for specific structure with name 'Job'
select structureKey from ddmstructure where name like "%Job</Name>%"