

We start with our root objects (asĪlso referenced in the dbinfo table): rowid uuid type parent_id ordering Note: DB refers to Dashboard and VERS refers to Version. Sqlite > SELECT rowid, uuid, type, parent_id, ordering. Knowing all these things, let’s now take a look at all groups in the items Items table uses a field called type which specifies what type of object


rowid primary / foreign keys: The items table contains a rowidĪttribute which is its primary key.Before we take a look at items, it’s important that Now, we’re about to look at the items table which ties all of this Looks like a folder, but we still don’t know what the rest are just yet. That groups 1, 3 and 5 are root groups (as shown by the dbinfo table), and 129 OK, so dbinfo, apps and widgets are clear, but the groups not so much. widgets: contains all widgets available for Dashboardįinally, the items table references these 3 tables and contains ordering.downloading_apps: contains all apps currently being downloaded for.apps: contains all apps available for Launchpad.groups: contains all available root objects, pages and folders for both.We then move onto the tables containing data about each type of object in Launchpad: launchpad_version_root: is the root id for Launchpad version metadata.(accessible by clicking the + icon in Dashboard) dashboard_root is the root id for the Dashboard widget pages.launchpad_root is the root id for the main Launchpad apps pages.The dbinfo table provides the root id for each type of Launchpad data. The structure of Launchpad data is as follows: ├── Launchpad (Apps) Root
