Code Excursion

Database Changes After Adding Liferay Container Fragment

What data changes occur when adding a Container Fragment to a Page in Liferay. Pages in liferay are correllated to layouts in the database. This information was added by administrator user Test Test with email test@test.com. Keep in mind that Liferay doesn’t enforce referential integrity in the database. Instead it is “enforced” in the code.

Tables that were changed after adding the Container Fragment to Page “Types of Rocks”. This page was added to the “All About Rocks” site with GroupId 32925.

• Layout
  • Table to page data. Layouts are effectively web pages in Liferay.
  • Primary key is plId and ctCollectionId.
  • Plids had values 25 and 26.
  • MvccVersions were updated from 14 and 21 to 16 and 24. Purpose of this column is unknown.
• LayoutPageTemplateStructure
  • Primary key is layoutPageTemplateStructureId and ctCollectionId.
  • LayoutPageTemplateStructureIds had values 33070 and 33076.
  • MvccVersions were updated from 5 and 16 to 6 and 18. Purpose of this column is unknown.
• LayoutPageTemplateStructureRel
  • Primary key is lPageTemplateStructureRelId and ctCollectionId.
  • LPageTemplateStructureRelId had values 33071 and 33077.
  • MvccVersions were updated from 5 and 16 to 6 and 18. Purpose of this column is unknown.
  • Data_ column was updated to have a container object. Code shown below.

JSON from Data_ column

{
    "deletedItems": [],
    "pageRules": [],
    "rootItems": {
        "dropZone": "",
        "main": "39cce44e-3191-0b20-48bc-a61e89aace06"
    },
    "items": {
        "fd47294e-736c-5972-4509-105b8cc0395e": {
            "itemId": "fd47294e-736c-5972-4509-105b8cc0395e",
            "children": [],
            "type": "container",
            "config": {
                "tablet": {
                    "styles": {}
                },
                "cssClasses": [],
                "landscapeMobile": {
                    "styles": {}
                },
                "portraitMobile": {
                    "styles": {}
                },
                "styles": {}
            },
            "parentId": "39cce44e-3191-0b20-48bc-a61e89aace06"
        },
        "39cce44e-3191-0b20-48bc-a61e89aace06": {
            "itemId": "39cce44e-3191-0b20-48bc-a61e89aace06",
            "children": [
                "fd47294e-736c-5972-4509-105b8cc0395e"
            ],
            "type": "root",
            "config": {},
            "parentId": ""
        }
    },
    "version": 1.1
}

Resources

• Before Database Dump
• After Database Dump