Scott Cain's website

Bioinformatics, Perl, Cool Stuff
Powered by Drupal, an open source content management system


Lots of work on private schema template

The past few days I've done lots of work on creating a template for a private chado schema.

  • Had the private primary key table use the public key's sequence so their would be no problem moving the data from private to public
  • Created indexes that mirror all of the normal indexes in the public schema
  • Added unique, foreign key and not null constraints that mirror the public schema as well
  • Added default values that mirror the public schema; there is currently a problem with this that, when the default value is zero and the field is the last in the list, it doesn't get created properly. I'm continuing to work on that.

Work done yesterday and today: 9 hours.