gistfile1.txt

+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| id               | int(11)      | NO   | PRI | NULL    | auto_increment | 
| tracker_id       | int(11)      | NO   | MUL | 0       |                | 
| project_id       | int(11)      | NO   | MUL | 0       |                | 
| subject          | varchar(255) | NO   |     |         |                | 
| description      | text         | YES  |     | NULL    |                | 
| due_date         | date         | YES  |     | NULL    |                | 
| category_id      | int(11)      | YES  | MUL | NULL    |                | 
| status_id        | int(11)      | NO   | MUL | 0       |                | 
| assigned_to_id   | int(11)      | YES  | MUL | NULL    |                | 
| priority_id      | int(11)      | NO   | MUL | 0       |                | 
| fixed_version_id | int(11)      | YES  | MUL | NULL    |                | 
| author_id        | int(11)      | NO   | MUL | 0       |                | 
| lock_version     | int(11)      | NO   |     | 0       |                | 
| created_on       | datetime     | YES  | MUL | NULL    |                | 
| updated_on       | datetime     | YES  |     | NULL    |                | 
| start_date       | date         | YES  |     | NULL    |                | 
| done_ratio       | int(11)      | NO   |     | 0       |                | 
| estimated_hours  | float        | YES  |     | NULL    |                | 
| deliverable_id   | int(11)      | YES  |     | NULL    |                | 
| parent_id        | int(11)      | YES  |     | NULL    |                | 
| root_id          | int(11)      | YES  | MUL | NULL    |                | 
| lft              | int(11)      | YES  |     | NULL    |                | 
| rgt              | int(11)      | YES  |     | NULL    |                | 
| position         | int(11)      | YES  |     | NULL    |                | 
| story_points     | int(11)      | YES  |     | NULL    |                | 
| remaining_hours  | float        | YES  |     | NULL    |                | 
+------------------+--------------+------+-----+---------+----------------+