Chado icon indicating copy to clipboard operation
Chado copied to clipboard

Add keys to "temp" tables.

Open scottcain opened this issue 9 years ago • 0 comments

The tmp_gff_load_cache table is a not-really-temporary table that the GFF3 bulk loader uses to keep track of feature names and IDs. To make database replication easier, it should have a primary key or unique index.

The gff_meta table is also without either a primary key or a unique index. So, for replication of the DB (even though this table may be "disposable"), it too needs either a primary key or a unique index.

This is migrated from the bug tracker at Sourceforge: http://sourceforge.net/p/gmod/bugs/363/

scottcain avatar May 27 '15 14:05 scottcain