mysql> describe Bugs; +----------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----------------+ | Project | bigint(20) | NO | MUL | NULL | | | BugRef | bigint(20) | NO | PRI | NULL | auto_increment | | Datelogged | varchar(10) | NO | | NULL | | | BriefDesc | text | NO | | NULL | | | Bugstatus | varchar(1) | NO | | O | | | Loggedby | varchar(50) | YES | | NULL | | | AssignedTo | varchar(50) | YES | | NULL | | | DeveloperNotes | longtext | YES | | NULL | | +----------------+-------------+------+-----+---------+----------------+ 8 rows in set (0.01 sec) mysql> describe Changelog; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | ChangeRef | int(11) | NO | PRI | NULL | auto_increment | | Project | int(11) | NO | MUL | NULL | | | Date | varchar(20) | NO | | NULL | | | ChangeDesc | varchar(255) | NO | | NULL | | | Userref | varchar(50) | NO | | NULL | | +------------+--------------+------+-----+---------+----------------+ 5 rows in set (0.00 sec) mysql> describe Comments; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | CommentRef | int(11) | NO | PRI | NULL | auto_increment | | BugRef | int(11) | NO | MUL | NULL | | | Comment | mediumtext | NO | | NULL | | | CommentDate | varchar(20) | YES | | NULL | | | DisplayName | varchar(55) | YES | | NULL | | | Hostname | varchar(100) | YES | | NULL | | | Project | int(11) | NO | | NULL | | | Abuse | tinyint(1) | NO | | NULL | | | Username | varchar(50) | NO | | NULL | | +-------------+--------------+------+-----+---------+----------------+ 9 rows in set (0.00 sec) mysql> describe Documents; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | DocumentRef | int(11) | NO | PRI | NULL | auto_increment | | Project | int(11) | YES | | NULL | | | Title | varchar(255) | YES | | NULL | | | Version | varchar(20) | YES | | NULL | | | Description | mediumtext | YES | | NULL | | | Security | varchar(2) | YES | | NULL | | | User | varchar(50) | YES | | NULL | | | RegisteredDate | varchar(255) | YES | | NULL | | | FileSize | bigint(20) | YES | | NULL | | | File | longblob | YES | | NULL | | | FileName | varchar(255) | YES | | NULL | | | MIMEType | varchar(50) | YES | | NULL | | | License | int(11) | YES | | NULL | | +----------------+--------------+------+-----+---------+----------------+ 13 rows in set (0.00 sec) mysql> describe Licenses; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | LicenseRef | int(11) | NO | PRI | NULL | auto_increment | | LicenseName | varchar(50) | NO | | NULL | | | LicenseDesc | varchar(255) | NO | | NULL | | | LicenseText | longtext | YES | | NULL | | +-------------+--------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> describe Projects; +--------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+---------+----------------+ | ProjectRef | bigint(20) | NO | PRI | NULL | auto_increment | | ProjectName | varchar(100) | YES | | NULL | | | StartDate | varchar(100) | YES | | NULL | | | DevelopmentStopped | int(1) | YES | | 0 | | | ProjectDesc | mediumtext | YES | | NULL | | | Maintainer | varchar(50) | YES | | NULL | | | Advertise | int(1) | YES | | NULL | | | Category | int(11) | YES | | NULL | | | Public | tinyint(1) | YES | | 0 | | +--------------------+--------------+------+-----+---------+----------------+ 9 rows in set (0.02 sec) mysql> describe Releases; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | ReleaseRef | int(11) | NO | PRI | NULL | auto_increment | | Project | int(11) | NO | | NULL | | | Patch | int(1) | YES | | NULL | | | Version | varchar(25) | NO | | NULL | | | Security | varchar(1) | YES | | D | | | User | varchar(50) | NO | | admin | | | RegisteredDate | varchar(25) | YES | | NULL | | | License | int(11) | YES | | NULL | | | MD5 | varchar(100) | YES | | NULL | | | FileName | varchar(255) | YES | | NULL | | | MIMEType | varchar(50) | YES | | NULL | | | FileSize | bigint(20) | YES | | NULL | | | File | longblob | YES | | NULL | | | Notes | mediumtext | YES | | NULL | | +----------------+--------------+------+-----+---------+----------------+ 14 rows in set (0.00 sec) mysql> describe Tasks; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | TaskRef | int(11) | NO | PRI | NULL | auto_increment | | Project | int(11) | YES | MUL | NULL | | | Userref | varchar(50) | YES | | NULL | | | Date | varchar(20) | YES | | NULL | | | Task | varchar(255) | YES | | NULL | | | Completed | tinyint(1) | NO | | NULL | | +-----------+--------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec)