Optimize database tables

Description

The website uses some mysql database tables that are inefficiently designed. As those tables have grown considerably, the design should be updated.

Environment

None

Activity

Show:
Guus der Kinderen
May 18, 2016, 7:48 PM

Migration for checkUpdateInfo:

Guus der Kinderen
May 18, 2016, 11:18 PM

One down, two to go.

Guus der Kinderen
May 19, 2016, 10:59 AM

I modified all three tables. Not only do they have more applicable data types, their field names and definitions are made more similar. For the record, this was the migration scripts that I used (almost - what's here is the combination of things I did):

Guus der Kinderen
May 19, 2016, 11:00 AM

For the time being, I'll leave the original tables in place (their names now end with 'Old'). Those can be deleted when we've verified that everything is ok.

Fixed

Assignee

Guus der Kinderen

Reporter

Guus der Kinderen

Labels

None

Expected Effort

None

Ignite Forum URL

None

Priority

Minor