AssetBundle.sql

-- tables related to the AssetBundle and PreloadData objects

-- Do not confuse the AssetBundle Unity object (the source of much of this data)
-- with the archives table, which is general to any Unity Archive.

-- The "assets" that an AssetBundle explicitly exposes: each m_Container entry of the AssetBundle
-- object names an object (the addressable/asset name -> object it maps to). Populated only from
-- the AssetBundle object, so this table is empty for Player and ContentDirectory builds.
-- For scene bundles the entry names the scene and points at the synthetic Scene object (see
-- AssetBundleHandler / SerializedFileSQLiteWriter).
CREATE TABLE IF NOT EXISTS assetbundle_assets(
    object INTEGER,
    name TEXT
);

-- object depends on dependency. This table has three sources, only the first of which is truly
-- AssetBundle-specific:
--   * AssetBundleHandler: an asset's slice of the AssetBundle object's m_PreloadTable.
--   * SerializedFileSQLiteWriter: a scene object -> each object in the scene's SerializedFiles.
--   * PreloadDataHandler: the PreloadData object's m_Assets. PreloadData is a *separate* Unity
--     object (not part of the AssetBundle object) and also exists in Player builds (one per scene
--     in its sharedAssetsN.assets, plus one in globalgamemanagers.assets), so this table is NOT
--     empty there. Player builds have no scene object, so those rows hang off the PreloadData
--     object itself; scene bundles hang them off the synthetic Scene object.
CREATE TABLE IF NOT EXISTS preload_dependencies(
    object INTEGER,
    dependency INTEGER
);

CREATE VIEW IF NOT EXISTS assetbundle_asset_view AS
SELECT
    a.name AS asset_name,
    o.*
FROM assetbundle_assets a INNER JOIN object_view o ON o.id = a.object;

CREATE VIEW IF NOT EXISTS preload_dependencies_view AS
SELECT a.id, a.asset_name, a.archive, a.type, od.id dep_id, od.archive dep_archive, od.name dep_name, od.type dep_type
FROM assetbundle_asset_view a
INNER JOIN preload_dependencies d ON a.id = d.object
INNER JOIN object_view od ON od.id = d.dependency;