Updated md5sum for species and gene
Updated genes table to use text species, and the code to utilise the update. Only the crisprs table uses the numerical_id now.
Merged Saj's design changes into my branch
Updated test db layout to match live
Renamed inherited crispr primary keys in ddl
Ddl sql is now straight from a pg_dump. Schema updated accordingly, adding primary keys to child tables
Added paired crispr table and crispr off target resultset
Merge branch 'devel' into new_db
Added crispr pair table and renamed off_targets to off_target_ids
Updated test data to work with new column names
Crispr pair table now has a child per species. The CrisprPair resultset can now generate and insert paired data given two crispr ids and a species
Added method to view all off targets for a given pair, and changed CrisprOffTargets to work with any number of crisprs
Removed extra ] in bind query
Added script to find crisprs in the db, changed paired crispr table to have an easily searchable composite key, added off target finding button and probably loads of other stuff
Updated pair insert trigger to create pair_id automatically
merged latest db schema changes and resolved conflicts