Remove the title on filedownload blocks with more than one file in them. Correctly set the profile icon for profileinfo blocks. The general template now mostly migrates.

Make sure that when images are placed in views in 'listself' mode, they get put in filedownload blocks, which is more consistent for the upgrade. This makes the 'filelist' template migrate nicely.

The template itself is reasonably simple, the problems lie around the translation of certain template blocks to blocktypes - but these problems affect all templates.

It gets converted to a five column view (regardless of how many columns are actually used). The images are shown without their titles. All in all, this one migrates quite nicely, with the exception of images that are tall - the grid like effect is somewhat lost.

Anyway, it now migrates reasonably well. The labels are only output if there's artefacts associated with them.

Also changed a couple of columns in view_artefact to be nullable while the migration is running. Tried this with XMLDB, it ate my face.

Penny started this work but I'm taking up the rest of it, so there's some changes to how certain things work that I made while trying to understand the way the migration works.

Also commented everything.

Next work - test the PPAE migration, then on to the other templates.

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.

- Fixed a bug in the view_layout install.xml definition
- Added view layouts to core_data

removed view_artefact.ctime - not necessary and I want to delete and add rather than update, which would break it anyway

moved all the STATEMENTs out of install.xml into postinst, split postinst into two - right after core data & right at the end

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

Removed the unneeded watchlist tables. Renamed the community tables to group. I can't work out why this hasn't been committed before...

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*

Removed defaults from some fields that don't need them. Corrected whitespace at the end of the field declarations.

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