Opened 5 years ago

Closed 5 years ago

#2107 closed bug (fixed)

Remove inconsistencies from words table

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

Description

The words table is full of inconsistencies: Wordcodes that have no English text, wordcodes that have 2 or 3 records in the same language etc.

In my opinion the indices aren't optimal either. Not only allow they for the inconsistencies, they're also not optimised for the most widely used queries.

Attachments (1)

2107_words_adjust.sql (5.3 KB) - added by Tsjoek 5 years ago.
My suggestion to solve the issues

Download all attachments as: .zip

Change History (8)

comment:1 Changed 5 years ago by Tsjoek

Update of the sql file. For convenience, it also includes the necessary changes to the db, for the current AdminWord update as whole.

comment:2 Changed 5 years ago by Tsjoek

(wow: if you replace an attachment, Trac rewrites history ... :-o )

Changed 5 years ago by Tsjoek

My suggestion to solve the issues

comment:3 Changed 5 years ago by Tsjoek

Another update of the sql:

  • removes trailing space also from language codes in languages table
  • includes all faq wordcodes in first batch of invalidation

comment:4 Changed 5 years ago by Tsjoek

  • Cc shevek added
  • Milestone changed from unassigned to 2.3
  • Status changed from new to to_alpha

comment:5 Changed 5 years ago by Tsjoek

  • Status changed from to_alpha to testing

comment:6 Changed 5 years ago by crumbking

okay, done.

comment:7 Changed 5 years ago by crumbking

  • Resolution set to fixed
  • Status changed from testing to closed
Note: See TracTickets for help on using tickets.