Comment 11 for bug 1081947

Other places where db structure differs if upgrading from 1.0 vs fresh master (1.9dev) install.

I installed 1.0 with mysql then upgraded it thru each version until master - I then did another mysql install with master and checked what was different.

Table: `artefact_attachment`
missing: KEY `arteatta_art_ix` (`artefact`),

Table: `group`
missing: CONSTRAINT `grou_gro_fk` FOREIGN KEY (`grouptype`) REFERENCES `grouptype` (`name`),

Table: `grouptype_roles`
missing: PRIMARY KEY (`grouptype`,`role`),
               KEY `grourole_gro_ix` (`grouptype`),
               CONSTRAINT `grourole_gro_fk` FOREIGN KEY (`grouptype`)
               REFERENCES `grouptype` (`name`)

Table: `view_autocreate_grouptype`
missing: PRIMARY KEY (`view`,`grouptype`),
               KEY `viewautogrou_vie_ix` (`view`),
               KEY `viewautogrou_gro_ix` (`grouptype`),
               CONSTRAINT `viewautogrou_vie_fk` FOREIGN KEY (`view`)
               REFERENCES `view` (`id`),
               CONSTRAINT `viewautogrou_gro_fk` FOREIGN KEY (`grouptype`)
               REFERENCES `grouptype` (`name`)

Table: `view_rows_columns`
missing column: `id` bigint(10) NOT NULL AUTO_INCREMENT,
missing: PRIMARY KEY (`id`),