mantisbt:global_categories_requirements
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| mantisbt:global_categories_requirements [2007/10/02 13:30] – jreese | mantisbt:global_categories_requirements [2008/10/29 04:25] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 39: | Line 39: | ||
| The final main phase will be the introduction of category inheritence between projects. | The final main phase will be the introduction of category inheritence between projects. | ||
| + | |||
| + | |||
| ===== Database Changes ===== | ===== Database Changes ===== | ||
| - | The conversion | + | |
| + | ==== Phase 1 ==== | ||
| + | |||
| + | This will be a multi-step process consisting of the following changes: | ||
| * create '' | * create '' | ||
| Line 52: | Line 57: | ||
| * modify '' | * modify '' | ||
| * add **category_id int(10)** as foreign key to '' | * add **category_id int(10)** as foreign key to '' | ||
| - | * modify '' | ||
| - | * add **inherit_categories tinyint(4)** to denote project will inherit global categories | ||
| - | * modify '' | ||
| - | * add **inherit_categories tinyint(4)** to denote project will inherit categories from parent | ||
| * run custom upgrade function that will find existing categories, and create entries in new format | * run custom upgrade function that will find existing categories, and create entries in new format | ||
| * run custom upgrade function that will convert bugs' **category** value to **category_id** | * run custom upgrade function that will convert bugs' **category** value to **category_id** | ||
| Line 62: | Line 63: | ||
| * delete '' | * delete '' | ||
| + | ==== Phase 2 ==== | ||
| + | * modify '' | ||
| + | * add **inherit_categories tinyint(4)** to denote project will inherit global categories | ||
| + | |||
| + | ==== Phase 3 ==== | ||
| + | * modify '' | ||
| + | * add **inherit_categories tinyint(4)** to denote project will inherit categories from parent | ||
mantisbt/global_categories_requirements.1191346210.txt.gz · Last modified: (external edit)
