Ticket #71 (assigned task)

Opened 1 year ago

Last modified 1 month ago

Clean database

Reported by: milosh Assigned to: milosh (accepted)
Priority: high Component: Other
Version: Latest version from repository Severity: major
Keywords: database Cc:

Description (Last modified by milosh)

Revamping the database cleaning project. Current tasks:

  • Compile a list of all tables used by the bots and which respective database they use.
  • Compile a list of all tables used by the website and which respective database they use.
  • Clear off unused or unneeded tables from both databases.
  • Move remaining tables on Queen to King(change source files that reference said tables)
  • Depending on the size of the database at this point divide it into separate databases with descriptive names.
  • Create a instructive pattern on how to add/name tables in the future.

Old ticket information: 

Via lnx I got the request from Priitk to clean up the database of TWCore.[[BR]]

Since it's such a mess I'm going to work on an entirely new clean database with the tables needed for all of the bots. The gathered information will be written down per bot and linked to from the [wiki:Bots Bots] page. I will probably also provide sql scripts per bot.

Attachments

Change History

06/08/07 13:19:34 changed by Maverick

  • status changed from new to assigned.

06/08/07 13:19:56 changed by Maverick

  • type changed from defect to task.

11/14/07 02:49:44 changed by Maverick

  • priority changed from high to normal.

Still needs to be done but requires lots of time.

As I haven't received word from either Priitk or lnx about this (or anything else for that matter) I'm making it less priority.

04/16/08 13:42:33 changed by milosh

  • status changed from assigned to new.
  • description changed.
  • reporter changed from Maverick to milosh.
  • priority changed from normal to high.
  • owner changed from Maverick to milosh.
  • keywords set to database.
  • severity changed from critical to major.

04/16/08 13:43:49 changed by milosh

  • status changed from new to assigned.
  • description changed.

04/16/08 18:52:51 changed by milosh

Related Changeset: 2529

04/17/08 01:40:46 changed by Maverick

Good job. When you restart RoboKing keep in mind to disable the crontasks first ;)

04/17/08 01:42:14 changed by Maverick

yea, stating the obvious :P

04/18/08 13:11:58 changed by milosh

  • description changed.

See this thread for the list of tables used by the bots.

04/18/08 14:01:08 changed by milosh

Related Changeset: 2535

05/06/08 15:05:05 changed by milosh

  • description changed.

See this thread for the list of tables used by the website.

05/15/08 19:30:09 changed by milosh

  • description changed.

Excess tables cleared.

07/19/08 18:23:30 changed by milosh

I would be happy to complete the rest of this ticket; however, it will remain postponed until the new TWL season is running smoothly. Hopefully, RiiStar, others, and I will be able to cooperate on this task after this years TWL season to try and be as organized as possible. New information received from PriitK in the future could also affect the outline of this operation.

Add/Change #71 (Clean database)




Change Properties
Action