View Issue Details

IDProjectCategoryView StatusLast Update
0000300WackoWikidatabasepublic2011-05-31 21:24
Reporteradministrator Assigned Toadministrator  
PriorityhighSeveritytweakReproducibilityN/A
Status resolvedResolutionfixed 
Product Version4.2 
Target Version5.0.betaFixed in Version5.0.beta 
Summary0000300: Normalize database
Descriptionafter 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
TagsNo tags attached.

Relationships

parent of 0000302 feedbackTann San add function lastInsertId for last_insert_id() 
parent of 0000368 resolvedadministrator add new table user_setting 
parent of 0000367 resolvedadministrator add new menu table and action 
related to 0000332 resolvedadministrator function load_comments should exit if value is '0' 
Not all the children of this issue are yet resolved or closed.

Activities

administrator

2009-06-27 12:20

administrator   ~0000659

Last edited: 2011-02-06 17:49

View 2 revisions

http://wackowiki.org/Dev/Release/R44/Database

Issue History

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 View Revisions
2009-07-02 23:41 administrator Description Updated View Revisions
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 View Revisions
2011-05-31 21:24 administrator Build => R5.0.beta