Fixed up foreign key creation. Removed revisions tables, added in single-revision table. Will be tweaked a little more. But should be a fairly 'dumb' table. Searching needn't happen on it, only what it relates to.