Opened 4 years ago

Closed 4 years ago

#2208 closed task (fixed)

document database tables and first cleanup

Reported by: Tsjoek Owned by: Tsjoek
Priority: major Milestone: 2.6
Component: BW Database Keywords:
Cc: shevek

Description (last modified by Tsjoek)

All databaseitems (tables,functions,views,procedures) should have a good use and get a proper comment to explain their use.
We can divide 3 categories:

  • Obsolete: not used by any code anymore. Candidate for removal.
  • Deprecated: still used by old code, but duplicated somewhere else. Or used by code that we don't want to use anymore. New code should not use this, old code should be rewritten or removed, to make the table obsolete in the end.
  • Active: the others (default)

After that we should get rid of the first category and use the comments to mark the second category as such:

Related ticket: #2205

Change History (9)

comment:1 Changed 4 years ago by Tsjoek

  • Cc shevek added
  • Description modified (diff)
  • Milestone changed from unassigned to 2.6
  • Owner set to Tsjoek
  • Priority changed from minor to major
  • Status changed from new to assigned
  • Summary changed from document database tables to document database tables and first cleanup

Increasing scope of this ticket, including a first cleanup of tables,functions and views.

comment:2 Changed 4 years ago by Tsjoek

  • Status changed from assigned to local_testing

https://www.gitorious.org/bewelcome/rox/commit/28c81e29652e461224c6b21dd8a20862a72a06ec/diffs/6303d63559223c9655776b60d01e77672c9cbf07

Migration for dropping obsolete items (tables,views,functions)
Migration for improving the tablecomments
Plus adjustments to make groupshierarchy table officially obsolete (was mentioned in a comment only) and removing the tablecomments from the anonymizer.

comment:3 Changed 4 years ago by crumbking

  • Status changed from local_testing to to_alpha

worked locally for me...

comment:4 Changed 4 years ago by shevek

Deployed to alpha (can't be tested there though).

comment:5 Changed 4 years ago by shevek

  • Status changed from to_alpha to testing

comment:6 Changed 4 years ago by shevek

  • Status changed from testing to to_beta

comment:7 Changed 4 years ago by shevek

  • Status changed from to_beta to testing

comment:8 Changed 4 years ago by crumbking

looks good to me thought no idea how to test on beta.

comment:9 Changed 4 years ago by beatnickgr

  • Resolution set to fixed
  • Status changed from testing to closed

Closed, as crumbking requested. (not tested by me)

Note: See TracTickets for help on using tickets.