Closed Bug 769331 Opened 12 years ago Closed 12 years ago

Create a table to store bug data

Categories

(Websites :: Scrumbugs, defect)

Product:
Websites
Component:
Scrumbugs
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
VERIFIED FIXED

People

(Reporter: pmac, Assigned: pmac)

Details

(Whiteboard: u=developer c=cache p=2) 

This will be basically a write-through cache. Whenever bugs are retrieved from Bugzilla, the data is stored in memcached, but it should also go to the DB for relationships, logging, and statistical analysis. This will enable bugs to be directly added to sprints for the new sprint planning features.

It should store the full JSON data from bugzilla, but also split some of the more useful information into columns. New collumns and tables can be split out later and the JSON reprocessed at any time should the need arise.

There should also be a table for logging bug movements into and out of sprints.

| Bug | Sprint | Datestamp | Action |

Where Action is some descriptive word indicating what happened, or perhaps a enum choice field.
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
assuming this is done :)
Status: RESOLVED → VERIFIED
You need to log in before you can comment on or make changes to this bug.