Move account expiry from institution to site options; add theme, membership period to institution settings

Added an upgrade path to move the images stored on the filesysetm into a new directory structure, and set config variables regarding image height and width.

Also removed a newline at the end of the file that was triggering header output.

There are lots of TODOs and none of the blocks get created.
It just moves stuff around according to the templates.

NOT TESTED.

removed all upgrades previous to the last minupgradefrom... this means we can get rid of the previous view template upgrades

First pass at a mysql upgrade for the usability work. Has to pull some shennigans with the paperwork^Wforeign keys

Implemented postgres upgrade to rename the community stuff to group. Will do the MySQL one at the end

Now, table names (and other identifiers that could be confused with SQL kewords), should be put into SQL like this:

SELECT * FROM {artefact}

The braces are matched and expanded by DML now to include the prefix and be properly quoted, which means that tables like 'view' and 'group' don't need renaming (and nor should they, there's little reason why we should rename tables to get around such constraints).

This has removed a whole bunch of $prefix = ... and get_config('dbprefix') stuff, which makes things a little simpler yet again.

Upgrade to remove group tables from Mahara. They'll be back, as renamed community tables, but for now, farewell! *plays taps*

More database consistency fixes. Made sure many NOT NULL columns didn't unnecessariliy have a DEFAULT '' on them. Made sure the MySQL default isn't to make them DEFAULT '' either

REALLY corrected the name of the index PROPERLY. Geez I'm having a good day. You there, reading the commit message, how are you?

Revert "Upgrade to remove group tables from Mahara. They'll be back, as renamed community tables, but for now, farewell! *plays taps*"

Back they come... stupid wrong branch...

This reverts commit 035ebd5d.

Upgrade to remove group tables from Mahara. They'll be back, as renamed community tables, but for now, farewell! *plays taps*

Fix issue found when attempting to upgrade a dupe of myportfolio.ac.nz - lang setting might already be fixed in the database, causing a foreign key violation

Moved setting of a foreign key into the internal auth plugin in an attempt to allow the upgrade to 0.8 work

username/authinstance