#18 Version upgrade system needed

[Craig Vincent]

Version upgrade system.

Since the project is still in early development there will
be major changes to the MySQL structure as time goes
on. A method needs to be developed to allow users to
upgrade from an older version of the project to a newer
one with the new MySQL schema while preserving data
currently in the database

[Craig Vincent]

Logged In: YES
user_id=532208

I implemented a preliminary setup for this ... it works but only
in premiums situations and there are a few glitches

see admin/admin_display.php
see admin/admin_database_update.php

Known bugs:
Currently the data repopulation is done through system calls, I
have not wrapped them in such a way to determine if the call
was successful or not (not just executing on system but
actually completing it's task)

In order for this to work...it must use the upgrade version of
the raidorganizer schema (setup/raidorganizer.sql) ... this is
because it retains it's original information but updates the
tables. If the install version of the .sql is used, the data will
be overwritten.

Trap:

Currently with this setup you cannot change field names or
drop fields from a table, well you can however the data
repopulation will be unsuccessful since the INSERTs are
invalid (they try to place information into columns that no
longer exist). We need to come up with a way to get around
this