File indexing completed on 2024-05-26 04:29:37

 CREATE TABLE IF NOT EXISTS resources (
     id INTEGER PRIMARY KEY   /* within this database, a unique and stable id for this resource */
 ,   resource_type_id INTEGER /* points to the type of this resource */
 ,   storage_id INTEGER       /* points to the storage object that contains the actual resource */
 ,   name TEXT NOT NULL       /* the untranslatable name of the resource */
 ,   filename TEXT NOT NULL   /* the filename of the resource RELATIVE to the storage path and resource type */
 ,   tooltip TEXT             /* a translated text that can be shown in the UI */
 ,   thumbnail BLOB           /* the image representing the resource visually*/
 ,   status INTEGER           /* active resources are visible in the UI, inactive resources are considered "deleted" */
 ,   temporary INTEGER        /* temporary resources are removed from the database on startup */
 ,   md5sum TEXT              /* the original md5sum of the first version of this resource */
 ,   FOREIGN KEY(resource_type_id) REFERENCES resource_types(id)
 ,   UNIQUE(storage_id, resource_type_id, filename)
 ,   UNIQUE(storage_id, resource_type_id, md5sum, filename)
 );