Please log in to subscribe to updates for this article
Last updated at Mon Apr 25 12:12, by zegenie
Introduction ⇑ topHere is a quick overview of the table structure used for projects and issues in The Bug Genie.
Scoped data ⇑ topKeep in mind that almost all data in The Bug Genie is scoped, by using a scope column on all tables containing scoped data. This means that if you want to import data into multiple scopes, be aware of the scope id for the scope valid for the desired hostname(s). This scope id must be used to populate the scope column when importing data into any tables.
The default scope (scope id 1) can be used to import data into the default scope valid for all hostnames (default setup).
Tables ⇑ topThis is a list of all tables, in the following format:
Table name used in database
Projects ⇑ top<table_prefix>projects
|name||string (200)||The name of the project|
|key||string (200)||The key, used for project and issue URLs|
|prefix||string (5)||An (optional) 5-character prefix for issue numbers|
|deleted||boolean, default false||Whether or not the project is deleted. Deleted projects are not available|