Tables
https://secure.gravatar.com/avatar/b28e536690cbbcc42568497fe280b4f4.png?d=wavatar&s=28
Mon Apr 25 12:12 Authored by zegenie

Introduction  

Here is a quick overview of the table structure used for projects and issues in The Bug Genie.

Scoped data  

Keep 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  

This is a list of all tables, in the following format:
Table description
Table name used in database
Table overview

Projects  

<table_prefix>projects

Column nameTypeDescription
namestring (200)The name of the project
keystring (200)The key, used for project and issue URLs
prefixstring (5)An (optional) 5-character prefix for issue numbers
deletedboolean, default falseWhether or not the project is deleted. Deleted projects are not available


In this category

There are no pages in this category

Attachments 0

Comments 0

/unthemed/mono/no-comments.png
Expand, collaborate and share
Post a comment and get things done