View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000300 | WackoWiki | database | public | 2009-06-18 13:02 | 2011-05-31 21:24 |
| Reporter | administrator | Assigned To | administrator | ||
| Priority | high | Severity | tweak | Reproducibility | N/A |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.2 | ||||
| Target Version | 5.0.beta | Fixed in Version | 5.0.beta | ||
| Summary | 0000300: Normalize database | ||||
| Description | after long hesitation I started normalizing the db after realizing either way the whole thing sucks now less than later - it might be tricky to change all the SELECT, INSERT, UPDATE ans DELETE queries but at the end the only thing that will change is that we do a trivial table look (e.g. page_id -> tag / supertag) up where necessary. the installer already contains the table changes except the DROPs - my intention is to keep the old columns as long as all related queries were fixed page_tag -> page_id user -> user_id all later changes depends on this like user groups -> add column 'id' to users table -> installer: add new field, SET / replace values as ID -> queries: adapt all SQL queries accordingly [INSERT | SELECT | UPDATE | DELETE] -> add function lastInsertId for externer Linklast_insert_id() – Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column. -> drop obsolete fields | ||||
| Tags | No tags attached. | ||||
| parent of | 0000302 | feedback | Tann San | add function lastInsertId for last_insert_id() |
| parent of | 0000368 | resolved | administrator | add new table user_setting |
| parent of | 0000367 | resolved | administrator | add new menu table and action |
| related to | 0000332 | resolved | administrator | function load_comments should exit if value is '0' |
| Not all the children of this issue are yet resolved or closed. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2009-06-18 13:02 | administrator | New Issue | |
| 2009-06-18 13:02 | administrator | Status | new => assigned |
| 2009-06-18 13:02 | administrator | Assigned To | => administrator |
| 2009-06-18 13:24 | administrator | Description Updated | |
| 2009-06-18 13:34 | administrator | Relationship added | parent of 0000302 |
| 2009-06-27 12:20 | administrator | Note Added: 0000659 | |
| 2009-07-02 23:40 | administrator | Description Updated | |
| 2009-07-02 23:41 | administrator | Description Updated | |
| 2009-10-09 13:46 | administrator | Relationship added | child of 0000332 |
| 2009-10-13 15:58 | administrator | Target Version | 5.0.0 => 5.0.beta |
| 2010-01-21 22:13 | administrator | Status | assigned => resolved |
| 2010-01-21 22:13 | administrator | Resolution | open => fixed |
| 2010-01-21 22:13 | administrator | Fixed in Version | => 5.0.beta |
| 2010-01-22 00:24 | administrator | Priority | normal => high |
| 2010-03-08 10:11 | administrator | Category | Database => database |
| 2010-06-17 12:58 | administrator | Relationship added | parent of 0000368 |
| 2010-06-17 13:00 | administrator | Relationship deleted | child of 0000332 |
| 2010-06-17 13:00 | administrator | Relationship added | related to 0000332 |
| 2010-06-17 13:01 | administrator | Relationship added | parent of 0000367 |
| 2011-02-06 17:49 | administrator | Note Edited: 0000659 | |
| 2011-05-31 21:24 | administrator | Build | => R5.0.beta |
