The database schema is simple; and there are only three tables. Index.php shows all the 'active' inventory items and their most recent relocations. This means two things, the active bit must be set to 1 on the inventory item and there must be AT LEAST ONE relocation for that inventory item. The database seed scripts and the add.php automatically create a relocation entry for the item(s) being added.
The database schema is simple; and there are only three tables. Index.php shows all the 'active' inventory items and their most recent relocations. This means two things, the active bit must be set to 1 on the inventory item and there must be AT LEAST ONE relocation for that inventory item. The database seed scripts and the add.php automatically create a relocation entry for the item(s) being added.
demogeardb database schema