Marine Strandings DB Compare
Produced: 31/01/2012 22:57:34
   
Mode:  All, Ignoring Unimportant  
Left file: D:\Inetpub\Numeriq\sac\strandings_dev\marinestrandings_dev31JanDevStructure.sql  
Right file: D:\Inetpub\Numeriq\sac\strandings_dev\marinestrandings_test31JanTestStructure.sql  
-- phpMyAdmin SQL Dump = -- phpMyAdmin SQL Dump
-- version 2.10.1   -- version 2.10.1
-- http://www.phpmyadmin.net   -- http://www.phpmyadmin.net
--   --
-- Host: localhost   -- Host: localhost
-- Generation Time: Jan 31, 2012 at 10:13 PM   -- Generation Time: Jan 31, 2012 at 10:57 PM
-- Server version: 4.1.22   -- Server version: 4.0.25
-- PHP Version: 5.2.17   -- PHP Version: 4.4.0
     
  -+ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  =  
--   --
-- Database: 'marinestrandings_dev'   -- Database: 'marinestrandings_test'
--   --
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'agegroup'   -- Table structure for table 'agegroup'
--   --
     
CREATE TABLE agegroup (   CREATE TABLE agegroup (
  agegroupid int(15) NOT NULL default '0',     agegroupid int(15) NOT NULL default '0',
  agegroup varchar(100) default NULL,     agegroup varchar(100) default NULL,
  forSort tinyint(1) default NULL,     forSort tinyint(1) default NULL,
  isCurrent tinyint(1) NOT NULL default '0',     isCurrent tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (agegroupid)     PRIMARY KEY  (agegroupid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'animalclass'   -- Table structure for table 'animalclass'
--   --
     
CREATE TABLE animalclass (   CREATE TABLE animalclass (
  classid int(15) NOT NULL default '0',     classid int(15) NOT NULL default '0',
  class varchar(100) default NULL,     class varchar(100) default NULL,
  abbreviation varchar(15) default NULL,     abbreviation varchar(15) default NULL,
  defaultAnimalCode int(15) default NULL,     defaultAnimalCode int(15) default NULL,
  forsort int(15) default NULL,     forsort int(15) default NULL,
  classiscurrent tinyint(1) NOT NULL default '0',     classiscurrent tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (classid)     PRIMARY KEY  (classid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'animalname'   -- Table structure for table 'animalname'
--   --
     
CREATE TABLE animalname (   CREATE TABLE animalname (
  animalcode int(15) NOT NULL default '0',     animalcode int(15) NOT NULL default '0',
  animalType varchar(30) default NULL,     animalType varchar(30) default NULL,
  commonName varchar(200) default NULL,     commonName varchar(200) default NULL,
  binomial varchar(60) default NULL,     binomial varchar(60) default NULL,
  family varchar(40) default NULL,     family varchar(40) default NULL,
  familycommonName varchar(40) default NULL,     familycommonName varchar(40) default NULL,
  nameiscurrent tinyint(1) NOT NULL default '0',     nameiscurrent tinyint(1) NOT NULL default '0',
  classid int(15) NOT NULL default '0',     classid int(15) NOT NULL default '0',
  PRIMARY KEY  (animalcode)     PRIMARY KEY  (animalcode)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'annotation'   -- Table structure for table 'annotation'
--   --
     
CREATE TABLE annotation (   CREATE TABLE annotation (
  noteid int(15) NOT NULL default '0',     noteid int(15) NOT NULL default '0',
  animalid int(15) NOT NULL default '0',     animalid int(15) NOT NULL default '0',
  noteText text NOT NULL,     noteText text NOT NULL,
  noteType varchar(50) NOT NULL default '',     noteType varchar(50) NOT NULL default '',
  dateEntered datetime NOT NULL default '0000-00-00 00:00:00',     dateEntered datetime NOT NULL default '0000-00-00 00:00:00',
  enteredby varchar(160) NOT NULL default '',     enteredby varchar(160) NOT NULL default '',
  PRIMARY KEY  (noteid)     PRIMARY KEY  (noteid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'bacteria'   -- Table structure for table 'bacteria'
--   --
     
CREATE TABLE bacteria (   CREATE TABLE bacteria (
  id int(11) NOT NULL auto_increment,     id int(11) NOT NULL auto_increment,
  organism varchar(200) default NULL,     organism varchar(200) default NULL,
  forsort int(5) NOT NULL default '0',     forsort int(5) NOT NULL default '0',
  iscurrent int(2) NOT NULL default '0',     iscurrent int(2) NOT NULL default '0',
  PRIMARY KEY  (id)     PRIMARY KEY  (id)
) TYPE=MyISAM ;   ) TYPE=MyISAM;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'bacteriology'   -- Table structure for table 'bacteriology'
--   --
     
CREATE TABLE bacteriology (   CREATE TABLE bacteriology (
  id int(15) NOT NULL auto_increment,     id int(15) NOT NULL auto_increment,
  postmortemid int(15) NOT NULL default '0',     postmortemid int(15) NOT NULL default '0',
  BacteriologyOrganID int(1) default '0', <>   heart int(1) NOT NULL default '0',
  BacteriaID int(15) default '0',     hbact int(15) default '0',
  OtherBacteria varchar(255) NOT NULL default '',    
  Growth varchar(3) default NULL,     hbcomm varchar(255) default NULL,
  Comments text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,     kidney int(1) NOT NULL default '0',
  dateupdated datetime default NULL,     kbact int(15) default NULL,
  updatedby varchar(150) default NULL,     kbcomm varchar(250) default NULL,
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'bacteriologycomments'    
--    
     
CREATE TABLE bacteriologycomments ( <>  
  id int(15) NOT NULL auto_increment,    
  postmortemid int(15) NOT NULL default '0',     liver int(1) NOT NULL default '0',
  observations text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,     lbact int(15) default NULL,
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,     lbcomm varchar(250) default NULL,
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'bacteriologycomments_audit'    
--    
     
CREATE TABLE bacteriologycomments_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,     lung int(1) default NULL,
  id int(15) NOT NULL default '0',     lubact int(15) default NULL,
      lucomm varchar(250) default NULL,
  postmortemid int(15) NOT NULL default '0',     spleen int(1) NOT NULL default '0',
  observations text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,     spbact int(15) default NULL,
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,     spcomm varchar(250) default NULL,
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'bacteriologyorgans'    
--    
     
CREATE TABLE bacteriologyorgans ( <>  
  BacteriologyOrganID int(10) NOT NULL auto_increment,    
  BacteriologyOrganName varchar(100) NOT NULL default '',    
  BacteriologyOrganIsCurrent tinyint(1) NOT NULL default '0',    
  SortOrder int(15) NOT NULL default '0',     mlnode int(1) NOT NULL default '0',
  PRIMARY KEY  (BacteriologyOrganID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'bacteriology_audit'    
--    
     
CREATE TABLE bacteriology_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,     mnbact mediumint(15) default NULL,
  id int(15) NOT NULL default '0',     mncomm varchar(250) default NULL,
  postmortemid int(15) NOT NULL default '0',     smint int(1) NOT NULL default '0',
  BacteriologyOrganID int(1) default '0',    
  BacteriaID int(15) default '0',     sibact int(15) default NULL,
  OtherBacteria varchar(255) NOT NULL default '',    
  Growth varchar(3) default NULL,     sicomm varchar(250) default NULL,
  Comments text,     observations blob,
  dateentered datetime default NULL, =   dateentered datetime default NULL,
  enteredby varchar(150) default NULL,     enteredby varchar(150) default NULL,
  dateupdated datetime default NULL,     dateupdated datetime default NULL,
  updatedby varchar(150) default NULL,     updatedby varchar(150) default NULL,
  `action` varchar(30) NOT NULL default '', <>  
  PRIMARY KEY  (audit_id)     PRIMARY KEY  (id)
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'bodycondition'    
--    
     
CREATE TABLE bodycondition ( +-  
  bodyconditionid int(15) NOT NULL auto_increment,    
  bodycondition varchar(100) default NULL,    
  `comment` text,    
  forSort int(15) default NULL,    
  PRIMARY KEY  (bodyconditionid)    
) TYPE=InnoDB; = ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'causeofdeath'   -- Table structure for table 'causeofdeath'
--   --
     
CREATE TABLE causeofdeath (   CREATE TABLE causeofdeath (
  causeofdeathid int(15) NOT NULL default '0',     causeofdeathid int(15) NOT NULL default '0',
  causeofDeath varchar(100) default NULL,     causeofDeath varchar(100) default NULL,
  note varchar(160) default NULL,     note varchar(160) default NULL,
  causeiscurrent tinyint(1) NOT NULL default '0',     causeiscurrent tinyint(1) NOT NULL default '0',
  forSort int(15) default NULL,     forSort int(15) default NULL,
  CauseOfDeathClassID int(15) default NULL     CauseOfDeathClassID int(15) default NULL
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'causeofdeathcategory'   -- Table structure for table 'causeofdeathcategory'
--   --
     
CREATE TABLE causeofdeathcategory (   CREATE TABLE causeofdeathcategory (
  CauseOfDeathCategoryID int(10) NOT NULL auto_increment, <>  
  CauseOfDeathClassID int(11) NOT NULL default '0',     CauseOfDeathCategoryID int(10) NOT NULL default '0',
  CauseOfDeathCategory varchar(100) NOT NULL default '', =   CauseOfDeathCategory varchar(100) NOT NULL default '',
  CauseOfDeathCategoryIsCurrent tinyint(1) NOT NULL default '0', <>   CauseOfDeathClassIsCurrent tinyint(1) NOT NULL default '0',
  SortOrder int(15) NOT NULL default '0',     SortOrder int(15) NOT NULL default '0'
  PRIMARY KEY  (CauseOfDeathCategoryID),    
  KEY CauseOfDeathClassID (CauseOfDeathClassID)    
) TYPE=InnoDB; = ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'causeofdeathclass'   -- Table structure for table 'causeofdeathclass'
--   --
     
CREATE TABLE causeofdeathclass (   CREATE TABLE causeofdeathclass (
  CauseOfDeathClassID int(10) NOT NULL auto_increment, <>   CauseOfDeathClassID int(10) NOT NULL default '0',
  CauseOfDeathClass varchar(100) NOT NULL default '', =   CauseOfDeathClass varchar(100) NOT NULL default '',
  CauseOfDeathClassIsCurrent tinyint(1) NOT NULL default '0',     CauseOfDeathClassIsCurrent tinyint(1) NOT NULL default '0',
  SortOrder int(15) NOT NULL default '0', <>   SortOrder int(15) NOT NULL default '0'
  PRIMARY KEY  (CauseOfDeathClassID)    
) TYPE=InnoDB; = ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'certaintyident'   -- Table structure for table 'certaintyident'
--   --
     
CREATE TABLE certaintyident (   CREATE TABLE certaintyident (
  certaintyIdentid int(15) NOT NULL default '0',     certaintyIdentid int(15) NOT NULL default '0',
  identification varchar(100) default NULL,     identification varchar(100) default NULL,
  forSort int(15) default NULL,     forSort int(15) default NULL,
  in2007 varchar(10) default NULL,     in2007 varchar(10) default NULL,
  iscurrent tinyint(1) NOT NULL default '0',     iscurrent tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (certaintyIdentid)     PRIMARY KEY  (certaintyIdentid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'condition'   -- Table structure for table 'condition'
--   --
     
CREATE TABLE condition (   CREATE TABLE condition (
  conditionid int(15) NOT NULL default '0',     conditionid int(15) NOT NULL default '0',
  condition varchar(100) default NULL,     condition varchar(100) default NULL,
  `comment` text, <>   comment text,
  NHM2000 varchar(100) default NULL, =   NHM2000 varchar(100) default NULL,
  welsh2008 varchar(100) default NULL,     welsh2008 varchar(100) default NULL,
  forSort int(15) default NULL,     forSort int(15) default NULL,
  conditionfound tinyint(1) NOT NULL default '0',     conditionfound tinyint(1) NOT NULL default '0',
  conditionPM tinyint(1) NOT NULL default '0',     conditionPM tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (conditionid)     PRIMARY KEY  (conditionid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'coordinatesystem'   -- Table structure for table 'coordinatesystem'
--   --
     
CREATE TABLE coordinatesystem (   CREATE TABLE coordinatesystem (
  CoordinateSystemID varchar(15) NOT NULL default '',     CoordinateSystemID varchar(15) NOT NULL default '',
  SystemName varchar(40) NOT NULL default '',     SystemName varchar(40) NOT NULL default '',
  PRIMARY KEY  (CoordinateSystemID)     PRIMARY KEY  (CoordinateSystemID)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'country'   -- Table structure for table 'country'
--   --
     
CREATE TABLE country (   CREATE TABLE country (
  CountryID int(15) NOT NULL default '0',     CountryID int(15) NOT NULL default '0',
  Country varchar(100) NOT NULL default '',     Country varchar(100) NOT NULL default '',
  forsort int(2) NOT NULL default '0', <>   forsort int(1) default NULL,
  PRIMARY KEY  (CountryID) =   PRIMARY KEY  (CountryID)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'county'   -- Table structure for table 'county'
--   --
     
CREATE TABLE county (   CREATE TABLE county (
  countyid int(15) NOT NULL default '0',     countyid int(15) NOT NULL default '0',
  county varchar(200) NOT NULL default '',     county varchar(200) NOT NULL default '',
  countyisCurrent tinyint(1) NOT NULL default '0',     countyisCurrent tinyint(1) NOT NULL default '0',
  RegionID int(15) NOT NULL default '0',     RegionID int(15) NOT NULL default '0',
  CountryID int(15) default NULL,     CountryID int(15) default NULL,
  PRIMARY KEY  (countyid)     PRIMARY KEY  (countyid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'datecertainty'   -- Table structure for table 'datecertainty'
--   --
     
CREATE TABLE datecertainty (   CREATE TABLE datecertainty (
  DateCertaintyID int(15) NOT NULL default '0',     DateCertaintyID int(15) NOT NULL default '0',
  DateCertainty varchar(100) NOT NULL default '',     DateCertainty varchar(100) NOT NULL default '',
  forsort int(15) NOT NULL default '0',     forsort int(15) NOT NULL default '0',
  iscurrent tinyint(1) NOT NULL default '0',     iscurrent tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (DateCertaintyID)     PRIMARY KEY  (DateCertaintyID)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'freezerarchive'    
--    
     
CREATE TABLE freezerarchive ( +-  
  id int(15) NOT NULL auto_increment,    
  postmortemid int(15) NOT NULL default '0',    
  FreezerArchiveOrganID int(11) default NULL,    
  Location varchar(10) default NULL,    
  Copies int(11) default NULL,    
  ConditionID int(11) default NULL,    
  TrayCondition varchar(10) default NULL,    
  Comments text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'freezerarchivecondition'    
--    
     
CREATE TABLE freezerarchivecondition ( +-  
  FreezerArchiveConditionID int(10) NOT NULL auto_increment,    
  FreezerArchiveCondition varchar(100) NOT NULL default '',    
  FreezerArchiveConditionIsCurrent tinyint(1) NOT NULL default '0',    
  SortOrder int(15) NOT NULL default '0',    
  PRIMARY KEY  (FreezerArchiveConditionID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'freezerarchiveorgans'    
--    
     
CREATE TABLE freezerarchiveorgans ( +-  
  FreezerArchiveOrganID int(10) NOT NULL auto_increment,    
  FreezerArchiveOrganName varchar(100) NOT NULL default '',    
  FreezerArchiveOrganIsCurrent tinyint(1) NOT NULL default '0',    
  SortOrder int(15) NOT NULL default '0',    
  PRIMARY KEY  (FreezerArchiveOrganID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'freezerarchive_audit'    
--    
     
CREATE TABLE freezerarchive_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  id int(15) NOT NULL default '0',    
  postmortemid int(15) NOT NULL default '0',    
  FreezerArchiveOrganID int(11) default NULL,    
  Location varchar(10) default NULL,    
  Copies int(11) default NULL,    
  ConditionID int(11) default NULL,    
  TrayCondition varchar(10) default NULL,    
  Comments text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  `action` varchar(30) NOT NULL default '',    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'histology'    
--    
     
CREATE TABLE histology ( +-  
  id int(11) NOT NULL auto_increment,    
  postmortemid int(11) default NULL,    
  agland_hist int(2) default NULL,    
  bladder_hist int(2) default NULL,    
  brain_hist int(2) default NULL,    
  eyes_hist int(2) default NULL,    
  heart_hist int(2) default NULL,    
  kidney_hist int(2) default NULL,    
  liver_hist int(2) default NULL,    
  lung_hist int(2) default NULL,    
  mgland_hist int(2) default NULL,    
  mesen_hist int(2) default NULL,    
  ovaries_hist int(2) default NULL,    
  panc_hist int(2) default NULL,    
  pit_hist int(2) default NULL,    
  pai_hist int(2) default NULL,    
  spleen_hist int(2) default NULL,    
  test_hist int(2) default NULL,    
  thymus_hist int(2) default NULL,    
  thyroid_hist int(2) default NULL,    
  tbc_hist int(2) default NULL,    
  uterus_hist int(2) default NULL,    
  other_hist int(2) default NULL,    
  comment_hist text,    
  observation text,    
  conclusion text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id),    
  KEY postmortemid (postmortemid)    
) TYPE=MyISAM ;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'histology_audit'    
--    
     
CREATE TABLE histology_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  id int(11) NOT NULL default '0',    
  postmortemid int(11) default NULL,    
  agland_hist int(2) default NULL,    
  bladder_hist int(2) default NULL,    
  brain_hist int(2) default NULL,    
  eyes_hist int(2) default NULL,    
  heart_hist int(2) default NULL,    
  kidney_hist int(2) default NULL,    
  liver_hist int(2) default NULL,    
  lung_hist int(2) default NULL,    
  mgland_hist int(2) default NULL,    
  mesen_hist int(2) default NULL,    
  ovaries_hist int(2) default NULL,    
  panc_hist int(2) default NULL,    
  pit_hist int(2) default NULL,    
  pai_hist int(2) default NULL,    
  spleen_hist int(2) default NULL,    
  test_hist int(2) default NULL,    
  thymus_hist int(2) default NULL,    
  thyroid_hist int(2) default NULL,    
  tbc_hist int(2) default NULL,    
  uterus_hist int(2) default NULL,    
  other_hist int(2) default NULL,    
  comment_hist text,    
  observation text NOT NULL,    
  conclusion text NOT NULL,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id),    
  KEY postmortemid (postmortemid)    
) TYPE=MyISAM ;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'marine_data'   -- Table structure for table 'marine_data'
--   --
     
CREATE TABLE marine_data (   CREATE TABLE marine_data (
  id int(11) NOT NULL auto_increment,     id int(11) NOT NULL auto_increment,
  Class varchar(40) default NULL,     Class varchar(40) default NULL,
  SubClass varchar(30) default NULL,     SubClass varchar(30) default NULL,
  Event varchar(15) default NULL,     Event varchar(15) default NULL,
  National_Reference varchar(20) default NULL,     National_Reference varchar(20) default NULL,
  Species_scientific varchar(40) default NULL,     Species_scientific varchar(40) default NULL,
  Species_common varchar(100) default NULL,     Species_common varchar(100) default NULL,
  Species_Uncertain varchar(8) default NULL,     Species_Uncertain varchar(8) default NULL,
  Date_Found varchar(12) default NULL,     Date_Found varchar(12) default NULL,
  Date_Certainty varchar(15) default NULL,     Date_Certainty varchar(15) default NULL,
  `Year` int(11) default NULL, <>   Year int(11) default NULL,
  Location varchar(50) default NULL, =   Location varchar(50) default NULL,
  Local_Authority varchar(30) default NULL,     Local_Authority varchar(30) default NULL,
  Region varchar(30) default NULL,     Region varchar(30) default NULL,
  Country varchar(20) default NULL,     Country varchar(20) default NULL,
  Grid_Ref varchar(15) default NULL,     Grid_Ref varchar(15) default NULL,
  Easting int(11) default NULL,     Easting int(11) default NULL,
  Northing int(11) default NULL,     Northing int(11) default NULL,
  Latitude double default NULL,     Latitude double default NULL,
  Longitude double default NULL,     Longitude double default NULL,
  Sex varchar(3) default NULL, <>   Sex char(3) default NULL,
  Length int(11) default NULL, =   Length int(11) default NULL,
  Length_Uncertain varchar(8) default NULL,     Length_Uncertain varchar(8) default NULL,
  Euthanased varchar(8) default NULL,     Euthanased varchar(8) default NULL,
  Stranding_Type varchar(20) default NULL,     Stranding_Type varchar(20) default NULL,
  Condition_Found text,     Condition_Found text,
  Stranding_data_Stage varchar(15) default NULL,     Stranding_data_Stage varchar(15) default NULL,
  Sent_for_PM varchar(8) default NULL,     Sent_for_PM varchar(8) default NULL,
  Project varchar(10) default NULL,     Project varchar(10) default NULL,
  PM_Number varchar(15) default NULL,     PM_Number varchar(15) default NULL,
  Histology_Number varchar(20) default NULL,     Histology_Number varchar(20) default NULL,
  Age_Group varchar(20) default NULL,     Age_Group varchar(20) default NULL,
  PM_Date varchar(12) default NULL,     PM_Date varchar(12) default NULL,
  Condition_at_PM varchar(50) default NULL,     Condition_at_PM varchar(50) default NULL,
  Frozen varchar(8) default NULL,     Frozen varchar(8) default NULL,
  Pathologist varchar(35) default NULL,     Pathologist varchar(35) default NULL,
  Cause_of_Death text,     Cause_of_Death text,
  Cause_of_Death_Category varchar(60) default NULL,     Cause_of_Death_Category varchar(60) default NULL,
  Cause_of_Death_Class varchar(35) default NULL,     Cause_of_Death_Class varchar(35) default NULL,
  Live_Stranding_diagnosed varchar(8) default NULL,     Live_Stranding_diagnosed varchar(8) default NULL,
  PM_Summary text,     PM_Summary text,
  Age int(11) default NULL,     Age int(11) default NULL,
  Body_Weight int(11) default NULL,     Body_Weight int(11) default NULL,
  Length_PM int(11) default NULL,     Length_PM int(11) default NULL,
  Girth int(11) default NULL,     Girth int(11) default NULL,
  Dorsal_Blubber int(11) default NULL,     Dorsal_Blubber int(11) default NULL,
  Lateral_Blubber int(11) default NULL,     Lateral_Blubber int(11) default NULL,
  Ventral_Blubber int(11) default NULL,     Ventral_Blubber int(11) default NULL,
  Heart_Weight int(11) default NULL,     Heart_Weight int(11) default NULL,
  L_Testis int(11) default NULL,     L_Testis int(11) default NULL,
  R_Testis int(11) default NULL,     R_Testis int(11) default NULL,
  NMS_No varchar(50) default NULL,     NMS_No varchar(50) default NULL,
  M_Ref varchar(15) default NULL,     M_Ref varchar(15) default NULL,
  PRIMARY KEY  (id)     PRIMARY KEY  (id)
) TYPE=MyISAM ;   ) TYPE=MyISAM;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'marine_data_audit'    
--    
     
CREATE TABLE marine_data_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  id int(11) NOT NULL default '0',    
  Class varchar(40) default NULL,    
  SubClass varchar(30) default NULL,    
  Event varchar(15) default NULL,    
  National_Reference varchar(20) default NULL,    
  Species_scientific varchar(40) default NULL,    
  Species_common varchar(100) default NULL,    
  Species_Uncertain varchar(8) default NULL,    
  Date_Found varchar(12) default NULL,    
  Date_Certainty varchar(15) default NULL,    
  `Year` int(11) default NULL,    
  Location varchar(50) default NULL,    
  Local_Authority varchar(30) default NULL,    
  Region varchar(30) default NULL,    
  Country varchar(20) default NULL,    
  Grid_Ref varchar(15) default NULL,    
  Easting int(11) default NULL,    
  Northing int(11) default NULL,    
  Latitude double default NULL,    
  Longitude double default NULL,    
  Sex varchar(3) default NULL,    
  Length int(11) default NULL,    
  Length_Uncertain varchar(8) default NULL,    
  Euthanased varchar(8) default NULL,    
  Stranding_Type varchar(20) default NULL,    
  Condition_Found text,    
  Stranding_data_Stage varchar(15) default NULL,    
  Sent_for_PM varchar(8) default NULL,    
  Project varchar(10) default NULL,    
  PM_Number varchar(15) default NULL,    
  Histology_Number varchar(20) default NULL,    
  Age_Group varchar(20) default NULL,    
  PM_Date varchar(12) default NULL,    
  Condition_at_PM varchar(50) default NULL,    
  Frozen varchar(8) default NULL,    
  Pathologist varchar(35) default NULL,    
  Cause_of_Death text,    
  Cause_of_Death_Category varchar(60) default NULL,    
  Cause_of_Death_Class varchar(35) default NULL,    
  Live_Stranding_diagnosed varchar(8) default NULL,    
  PM_Summary text,    
  Age int(11) default NULL,    
  Body_Weight int(11) default NULL,    
  Length_PM int(11) default NULL,    
  Girth int(11) default NULL,    
  Dorsal_Blubber int(11) default NULL,    
  Lateral_Blubber int(11) default NULL,    
  Ventral_Blubber int(11) default NULL,    
  Heart_Weight int(11) default NULL,    
  L_Testis int(11) default NULL,    
  R_Testis int(11) default NULL,    
  NMS_No varchar(50) default NULL,    
  M_Ref varchar(15) default NULL,    
  PRIMARY KEY  (audit_id)    
) TYPE=MyISAM;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'nmsdata'    
--    
     
CREATE TABLE nmsdata ( +-  
  id int(15) NOT NULL auto_increment,    
  postmortemid int(15) NOT NULL default '0',    
  NMSNumber varchar(40) NOT NULL default '',    
  NMSConfirmedSpecies varchar(255) NOT NULL default '',    
  comments text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'nmsdata_audit'    
--    
     
CREATE TABLE nmsdata_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  id int(15) NOT NULL default '0',    
  postmortemid int(15) NOT NULL default '0',    
  NMSNumber varchar(40) NOT NULL default '',    
  NMSConfirmedSpecies varchar(255) NOT NULL default '',    
  comments text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'nmssampletype'    
--    
     
CREATE TABLE nmssampletype ( +-  
  NMSSampleTypeID int(11) NOT NULL auto_increment,    
  postmortemID int(11) NOT NULL default '0',    
  NMSSampleTypeOptionID int(11) NOT NULL default '0',    
  dateupdated datetime NOT NULL default '0000-00-00 00:00:00',    
  updatedby varchar(150) NOT NULL default '',    
  PRIMARY KEY  (NMSSampleTypeID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'nmssampletypeold'    
--    
     
CREATE TABLE nmssampletypeold ( +-  
  nmssampletypeID int(11) NOT NULL auto_increment,    
  Animalid int(11) NOT NULL default '0',    
  nmssampletypeoptionID int(11) NOT NULL default '0',    
  otherTitle varchar(50) NOT NULL default '',    
  PRIMARY KEY  (nmssampletypeID),    
  KEY nmssampletypeoptionID (nmssampletypeoptionID),    
  KEY Animalid (Animalid)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'nmssampletypeoptions'    
--    
     
CREATE TABLE nmssampletypeoptions ( +-  
  NMSSampleTypeOptionID int(11) NOT NULL auto_increment,    
  NMSSampleTypeTitle varchar(50) NOT NULL default '',    
  NMSSampleTypeSpecify tinyint(1) NOT NULL default '0',    
  NMSSampleTypeIsCurrent tinyint(1) NOT NULL default '0',    
  SortOrder int(11) NOT NULL default '0',    
  PRIMARY KEY  (NMSSampleTypeOptionID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'nmssampletype_audit'    
--    
     
CREATE TABLE nmssampletype_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  NMSSampleTypeID int(11) NOT NULL default '0',    
  postmortemID int(11) NOT NULL default '0',    
  NMSSampleTypeOptionID int(11) NOT NULL default '0',    
  dateupdated datetime NOT NULL default '0000-00-00 00:00:00',    
  updatedby varchar(150) NOT NULL default '',    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'pmfindings_comments'   -- Table structure for table 'pmfindings_comments'
--   --
     
CREATE TABLE pmfindings_comments (   CREATE TABLE pmfindings_comments (
  id int(11) NOT NULL auto_increment,     id int(11) NOT NULL auto_increment,
  postmortemid int(15) NOT NULL default '0',     postmortemid int(15) NOT NULL default '0',
  body_orifices text,     body_orifices text,
  ectoparasites text,     ectoparasites text,
  fins_flukes text,     fins_flukes text,
  epidermis text,     epidermis text,
  entldesc text, +-  
  blubber text, =   blubber text,
  sc_tissue text,     sc_tissue text,
  skull text,     skull text,
  other_bones text,     other_bones text,
  bk_muscle text,     bk_muscle text,
  other_muscle text,     other_muscle text,
  ribfracture varchar(150) default NULL, <>   ribfracture text,
  brain text, =   brain text,
  sp_cord text,     sp_cord text,
  per_nerves text,     per_nerves text,
  peri_sac text,     peri_sac text,
  myocardium text,     myocardium text,
  valves text,     valves text,
  artveins text,     artveins text,
  nasal_cav text,     nasal_cav text,
  sinuses text,     sinuses text,
  trachea text,     trachea text,
  foam varchar(150) default NULL,     foam varchar(150) default NULL,
  lungs text,     lungs text,
  pleura text,     pleura text,
  mouth text,     mouth text,
  oesophagus text,     oesophagus text,
  st_contents text,     st_contents text,
  pl_ingesta text,     pl_ingesta text,
  fundic text,     fundic text,
  pyloric text,     pyloric text,
  duodenum text,     duodenum text,
  l_intestine text,     l_intestine text,
  anus text,     anus text,
  liver text,     liver text,
  pancreas text,     pancreas text,
  peritoneum text,     peritoneum text,
  ovary text,     ovary text,
  uterus text,     uterus text,
  pox text,     pox text,
  kidney text,     kidney text,
  ureters text,     ureters text,
  ubladder text,     ubladder text,
  urethra text,     urethra text,
  adrenal text,     adrenal text,
  thyroid text,     thyroid text,
  thymus text,     thymus text,
  spleen text,     spleen text,
  lymph text,     lymph text,
  dateentered datetime default NULL,     dateentered datetime default NULL,
  enteredby varchar(150) default NULL,     enteredby varchar(150) default NULL,
  dateupdated datetime default NULL,     dateupdated datetime default NULL,
  updatedby varchar(150) default NULL,     updatedby varchar(150) default NULL,
  PRIMARY KEY  (id)     PRIMARY KEY  (id)
) TYPE=MyISAM ;   ) TYPE=MyISAM;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'pmfindings_comments_audit'    
--    
     
CREATE TABLE pmfindings_comments_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  id int(11) NOT NULL default '0',    
  postmortemid int(15) NOT NULL default '0',    
  body_orifices text,    
  ectoparasites text,    
  fins_flukes text,    
  epidermis text,    
  entldesc text NOT NULL,    
  blubber text,    
  sc_tissue text,    
  skull text,    
  other_bones text,    
  bk_muscle text,    
  other_muscle text,    
  ribfracture varchar(150) default NULL,    
  brain text,    
  sp_cord text,    
  per_nerves text,    
  peri_sac text,    
  myocardium text,    
  valves text,    
  artveins text,    
  nasal_cav text,    
  sinuses text,    
  trachea text,    
  foam varchar(150) default NULL,    
  lungs text,    
  pleura text,    
  mouth text,    
  oesophagus text,    
  st_contents text,    
  pl_ingesta text,    
  fundic text,    
  pyloric text,    
  duodenum text,    
  l_intestine text,    
  anus text,    
  liver text,    
  pancreas text,    
  peritoneum text,    
  ovary text,    
  uterus text,    
  pox text,    
  kidney text,    
  ureters text,    
  ubladder text,    
  urethra text,    
  adrenal text,    
  thyroid text,    
  thymus text,    
  spleen text,    
  lymph text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id)    
) TYPE=MyISAM ;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'pm_findings'   -- Table structure for table 'pm_findings'
--   --
     
CREATE TABLE pm_findings (   CREATE TABLE pm_findings (
  id int(11) NOT NULL auto_increment,     id int(11) NOT NULL auto_increment,
  postmortemid int(11) NOT NULL default '0',     postmortemid int(11) NOT NULL default '0',
  body_orifices varchar(15) default NULL,     body_orifices varchar(15) default NULL,
  ectoparasites varchar(15) default NULL,     ectoparasites varchar(15) default NULL,
  ectoType mediumtext,     ectoType mediumtext,
  finsFlukes varchar(15) default NULL,     finsFlukes varchar(15) default NULL,
  epidermis varchar(15) default NULL,     epidermis varchar(15) default NULL,
  bndAttack int(2) default '0',     bndAttack int(2) default '0',
  entanglement int(2) default '0',     entanglement int(2) default '0',
  blubber varchar(15) default NULL,     blubber varchar(15) default NULL,
  subcutTissue varchar(15) default NULL,     subcutTissue varchar(15) default NULL,
  bruising int(2) default '0',     bruising int(2) default '0',
  skull varchar(15) default NULL,     skull varchar(15) default NULL,
  otherBones varchar(15) default NULL,     otherBones varchar(15) default NULL,
  ribFractures int(2) default '0',     ribFractures int(2) default '0',
  shot int(1) default NULL, <>   shot int(11) default NULL,
  cvdestroyed int(1) default NULL,     cvdestroyed int(11) default NULL,
  bkMuscle varchar(15) default NULL, =   bkMuscle varchar(15) default NULL,
  otherMuscles varchar(15) default NULL,     otherMuscles varchar(15) default NULL,
  brain varchar(15) default NULL,     brain varchar(15) default NULL,
  spinalCord varchar(15) default NULL,     spinalCord varchar(15) default NULL,
  peripeheralNerves varchar(15) default NULL,     peripeheralNerves varchar(15) default NULL,
  pericardialSac varchar(15) default NULL,     pericardialSac varchar(15) default NULL,
  myocardium varchar(15) default NULL,     myocardium varchar(15) default NULL,
  mcHaermorrhage int(2) default '0',     mcHaermorrhage int(2) default '0',
  valves varchar(15) default NULL,     valves varchar(15) default NULL,
  artVeins varchar(15) default NULL,     artVeins varchar(15) default NULL,
  nasalCavity varchar(15) default NULL,     nasalCavity varchar(15) default NULL,
  ncNematode varchar(15) default NULL,     ncNematode varchar(15) default NULL,
  sinuses varchar(15) default NULL,     sinuses varchar(15) default NULL,
  sinNematode varchar(15) default NULL,     sinNematode varchar(15) default NULL,
  trachea varchar(15) default NULL,     trachea varchar(15) default NULL,
  foam int(2) default '0',     foam int(2) default '0',
  lungs varchar(15) default NULL,     lungs varchar(15) default NULL,
  lnNematode varchar(15) default NULL,     lnNematode varchar(15) default NULL,
  congestion int(2) NOT NULL default '0',     congestion int(2) NOT NULL default '0',
  pleura varchar(15) default NULL,     pleura varchar(15) default NULL,
  mouth varchar(15) default NULL,     mouth varchar(15) default NULL,
  oesophagus varchar(15) default NULL,     oesophagus varchar(15) default NULL,
  stomachContents varchar(15) default '0',     stomachContents varchar(15) default '0',
  scWeight varchar(15) default NULL,     scWeight varchar(15) default NULL,
  ingesta int(2) default '0',     ingesta int(2) default '0',
  cardiacStomach text,     cardiacStomach text,
  lesions int(2) default '0',     lesions int(2) default '0',
  fundic varchar(15) default NULL,     fundic varchar(15) default NULL,
  pyloric varchar(15) default NULL,     pyloric varchar(15) default NULL,
  duodenum varchar(15) default NULL,     duodenum varchar(15) default NULL,
  lintestine varchar(15) default NULL,     lintestine varchar(15) default NULL,
  anus varchar(15) default NULL,     anus varchar(15) default NULL,
  liver varchar(15) default NULL,     liver varchar(15) default NULL,
  liverComment text,     liverComment text,
  liverFat int(2) default '0',     liverFat int(2) default '0',
  liverFluke int(2) default '0',     liverFluke int(2) default '0',
  pancreas varchar(15) default NULL,     pancreas varchar(15) default NULL,
  peritoneum varchar(15) default NULL,     peritoneum varchar(15) default NULL,
  periFluid varchar(150) default NULL,     periFluid varchar(150) default NULL,
  pfType varchar(100) default NULL,     pfType varchar(100) default NULL,
  tetraphyllideancysts int(2) default NULL, +-  
  ovaria int(2) NOT NULL default '0', =   ovaria int(2) NOT NULL default '0',
  ov_size varchar(15) default NULL,     ov_size varchar(15) default NULL,
  ov_scars text,     ov_scars text,
  uterus varchar(15) default NULL,     uterus varchar(15) default NULL,
  vagina int(2) default '0',     vagina int(2) default '0',
  pox int(2) default '0',     pox int(2) default '0',
  kidneys varchar(15) default NULL,     kidneys varchar(15) default NULL,
  ureters varchar(15) default NULL,     ureters varchar(15) default NULL,
  urBladder varchar(15) default NULL,     urBladder varchar(15) default NULL,
  urine int(2) default '0',     urine int(2) default '0',
  urinecolour varchar(15) NOT NULL default '', +-  
  urethra varchar(15) default NULL, =   urethra varchar(15) default NULL,
  adrenals varchar(15) default NULL,     adrenals varchar(15) default NULL,
  thyroid varchar(15) default NULL,     thyroid varchar(15) default NULL,
  spleen varchar(15) default NULL,     spleen varchar(15) default NULL,
  thymus varchar(15) default NULL,     thymus varchar(15) default NULL,
  lymphNodes varchar(15) default NULL,     lymphNodes varchar(15) default NULL,
  mesenteric int(2) default '0',     mesenteric int(2) default '0',
  msLymph varchar(15) default NULL,     msLymph varchar(15) default NULL,
  bronchial int(2) default '0',     bronchial int(2) default '0',
  brLymph varchar(15) default NULL,     brLymph varchar(15) default NULL,
  other int(2) default '0',     other int(2) default '0',
  otherLymph varchar(15) default NULL,     otherLymph varchar(15) default NULL,
  comments_id int(11) default NULL,     comments_id int(11) default NULL,
  dateentered datetime default NULL,     dateentered datetime default NULL,
  enteredby varchar(150) default NULL,     enteredby varchar(150) default NULL,
  dateupdated datetime default NULL,     dateupdated datetime default NULL,
  updatedby varchar(150) default NULL,     updatedby varchar(150) default NULL,
  PRIMARY KEY  (id)     PRIMARY KEY  (id)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'pm_findings_audit'    
--    
     
CREATE TABLE pm_findings_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  id int(11) NOT NULL default '0',    
  postmortemid int(11) NOT NULL default '0',    
  body_orifices varchar(15) default NULL,    
  ectoparasites varchar(15) default NULL,    
  ectoType mediumtext,    
  finsFlukes varchar(15) default NULL,    
  epidermis varchar(15) default NULL,    
  bndAttack int(2) default '0',    
  entanglement int(2) default '0',    
  blubber varchar(15) default NULL,    
  subcutTissue varchar(15) default NULL,    
  bruising int(2) default '0',    
  skull varchar(15) default NULL,    
  otherBones varchar(15) default NULL,    
  ribFractures int(2) default '0',    
  shot int(1) default NULL,    
  cvdestroyed int(1) default NULL,    
  bkMuscle varchar(15) default NULL,    
  otherMuscles varchar(15) default NULL,    
  brain varchar(15) default NULL,    
  spinalCord varchar(15) default NULL,    
  peripeheralNerves varchar(15) default NULL,    
  pericardialSac varchar(15) default NULL,    
  myocardium varchar(15) default NULL,    
  mcHaermorrhage int(2) default '0',    
  valves varchar(15) default NULL,    
  artVeins varchar(15) default NULL,    
  nasalCavity varchar(15) default NULL,    
  ncNematode varchar(15) default NULL,    
  sinuses varchar(15) default NULL,    
  sinNematode varchar(15) default NULL,    
  trachea varchar(15) default NULL,    
  foam int(2) default '0',    
  lungs varchar(15) default NULL,    
  lnNematode varchar(15) default NULL,    
  congestion int(2) NOT NULL default '0',    
  pleura varchar(15) default NULL,    
  mouth varchar(15) default NULL,    
  oesophagus varchar(15) default NULL,    
  stomachContents varchar(15) default '0',    
  scWeight varchar(15) default NULL,    
  ingesta int(2) default '0',    
  cardiacStomach text,    
  lesions int(2) default '0',    
  fundic varchar(15) default NULL,    
  pyloric varchar(15) default NULL,    
  duodenum varchar(15) default NULL,    
  lintestine varchar(15) default NULL,    
  anus varchar(15) default NULL,    
  liver varchar(15) default NULL,    
  liverComment text,    
  liverFat int(2) default '0',    
  liverFluke int(2) default '0',    
  pancreas varchar(15) default NULL,    
  peritoneum varchar(15) default NULL,    
  periFluid varchar(150) default NULL,    
  pfType varchar(100) default NULL,    
  tetraphyllideancysts int(2) NOT NULL default '0',    
  ovaria int(2) NOT NULL default '0',    
  ov_size varchar(15) default NULL,    
  ov_scars text,    
  uterus varchar(15) default NULL,    
  vagina int(2) default '0',    
  pox int(2) default '0',    
  kidneys varchar(15) default NULL,    
  ureters varchar(15) default NULL,    
  urBladder varchar(15) default NULL,    
  urine int(2) default '0',    
  urinecolour varchar(15) NOT NULL default '',    
  urethra varchar(15) default NULL,    
  adrenals varchar(15) default NULL,    
  thyroid varchar(15) default NULL,    
  spleen varchar(15) default NULL,    
  thymus varchar(15) default NULL,    
  lymphNodes varchar(15) default NULL,    
  mesenteric int(2) default '0',    
  msLymph varchar(15) default NULL,    
  bronchial int(2) default '0',    
  brLymph varchar(15) default NULL,    
  other int(2) default '0',    
  otherLymph varchar(15) default NULL,    
  comments_id int(11) default NULL,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'postmortem'   -- Table structure for table 'postmortem'
--   --
     
CREATE TABLE postmortem (   CREATE TABLE postmortem (
  postmortemid int(15) NOT NULL auto_increment, +-  
  PMNumber varchar(40) NOT NULL default '',    
  animalid int(15) default NULL,    
  histologyno varchar(20) default NULL,    
  PMdate datetime default NULL,    
  pathologist varchar(160) default NULL,    
  conditionid int(15) default NULL,    
  bodyconditionid int(11) NOT NULL default '0',    
  frozen tinyint(1) NOT NULL default '0',    
  livestranding tinyint(1) default '0',    
  project varchar(20) default NULL,    
  agegroupid int(15) default '0',    
  weight int(11) default NULL,    
  length int(15) default NULL,    
  girth int(15) default NULL,    
  dorsalFinBlubber int(15) default NULL,    
  dorsalMidBlubber int(15) default NULL,    
  ventralMidBlubber int(15) default NULL,    
  lengthHindFlipper int(11) default NULL,    
  sternalMidBlubber int(11) default NULL,    
  heartWeight int(15) default NULL,    
  LTestis float default NULL,    
  RTestis float default NULL,    
  causeofdeathid int(15) default '0',    
  ProxCauseOfDeathClassID int(11) default NULL,    
  ProxCauseOfDeathCategoryID int(11) default NULL,    
  ProxCauseOfDeathCertainty tinyint(4) default NULL,    
  ProxCauseOfDeathPending tinyint(4) default NULL,    
  ProxCauseOfDeathText text,    
  UltiCauseOfDeathClassID int(11) default NULL,    
  UltiCauseOfDeathCategoryID int(11) default NULL,    
  UltiCauseOfDeathCertainty tinyint(4) default NULL,    
  UltiCauseOfDeathPending tinyint(4) default NULL,    
  UltiCauseOfDeathText text,    
  freezeThawDamage varchar(15) default NULL,    
  predatorDamage varchar(15) default NULL,    
  degreePredatorDamage varchar(15) default NULL,    
  predator varchar(15) default NULL,    
  histopathology longblob,    
  findings_id int(15) default NULL,    
  notes text,    
  summary blob,    
  dateentered datetime default '0000-00-00 00:00:00',    
  enteredby varchar(160) default NULL,    
  dateupdated datetime default '0000-00-00 00:00:00',    
  updatedby varchar(160) default NULL,    
  PRIMARY KEY  (postmortemid),    
  KEY animalid (animalid),    
  KEY pathologist (pathologist)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'postmortembak'    
--    
     
CREATE TABLE postmortembak ( +-  
  postmortemid int(15) NOT NULL auto_increment, =   postmortemid int(15) NOT NULL auto_increment,
  PMNumber varchar(40) NOT NULL default '',     PMNumber varchar(40) NOT NULL default '',
  animalid int(15) default NULL,     animalid int(15) default NULL,
  histologyno varchar(20) default NULL,     histologyno varchar(20) default NULL,
  PMdate datetime default NULL,     PMdate datetime default NULL,
  pathologist varchar(160) default NULL,     pathologist varchar(160) default NULL,
  conditionid int(15) default NULL,     conditionid int(15) default NULL,
  frozen tinyint(1) NOT NULL default '0',     frozen tinyint(1) NOT NULL default '0',
  livestranding tinyint(1) default '0',     livestranding tinyint(1) default '0',
  project varchar(20) default NULL,     project varchar(20) default NULL,
  agegroupid int(15) default '0',     agegroupid int(15) default '0',
  weight int(11) default NULL,     weight int(11) default NULL,
  length int(15) default NULL,     length int(15) default NULL,
  girth int(15) default NULL,     girth int(15) default NULL,
  dorsalFinBlubber int(15) default NULL,     dorsalFinBlubber int(15) default NULL,
  dorsalMidBlubber int(15) default NULL,     dorsalMidBlubber int(15) default NULL,
  ventralMidBlubber int(15) default NULL,     ventralMidBlubber int(15) default NULL,
  lengthHindFlipper int(11) default NULL,     lengthHindFlipper int(11) default NULL,
  sternalMidBlubber int(11) default NULL,     sternalMidBlubber int(11) default NULL,
  heartWeight int(15) default NULL,     heartWeight int(15) default NULL,
  LTestis float default NULL,     LTestis float default NULL,
  RTestis float default NULL,     RTestis float default NULL,
  causeofdeathtext text,     causeofdeathtext text,
  causeofdeathid int(15) default '0',     causeofdeathid int(15) default '0',
  freezeThawDamage varchar(15) default NULL,     freezeThawDamage varchar(15) default NULL,
  predatorDamage varchar(15) default NULL,     predatorDamage varchar(15) default NULL,
  degreePredatorDamage varchar(15) default NULL,     degreePredatorDamage varchar(15) default NULL,
  predator varchar(15) default NULL,     predator varchar(15) default NULL,
  histopathology longblob,     histopathology longblob,
  findings_id int(15) default NULL,     findings_id int(15) default NULL,
  notes text,     notes text,
  summary blob,     summary blob,
  dateentered datetime default '0000-00-00 00:00:00',     dateentered datetime default '0000-00-00 00:00:00',
  enteredby varchar(160) default NULL,     enteredby varchar(160) default NULL,
  dateupdated datetime default '0000-00-00 00:00:00',     dateupdated datetime default '0000-00-00 00:00:00',
  updatedby varchar(160) default NULL,     updatedby varchar(160) default NULL,
  PRIMARY KEY  (postmortemid),     PRIMARY KEY  (postmortemid),
  KEY animalid (animalid),     KEY animalid (animalid),
  KEY pathologist (pathologist) <>   KEY pathologist (pathologist),
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'postmortem_audit'    
--    
     
CREATE TABLE postmortem_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,    
  postmortemid int(15) NOT NULL default '0',     KEY postmortemid (postmortemid),
  PMNumber varchar(40) NOT NULL default '',    
  animalid int(15) default NULL,    
  histologyno varchar(20) default NULL,    
  PMdate datetime default NULL,    
  pathologist varchar(160) default NULL,    
  conditionid int(15) default NULL,    
  bodyconditionid int(11) NOT NULL default '0',    
  frozen tinyint(1) NOT NULL default '0',    
  livestranding tinyint(1) default '0',    
  project varchar(20) default NULL,    
  agegroupid int(15) default '0',    
  weight int(11) default NULL,    
  length int(15) default NULL,    
  girth int(15) default NULL,    
  dorsalFinBlubber int(15) default NULL,    
  dorsalMidBlubber int(15) default NULL,    
  ventralMidBlubber int(15) default NULL,    
  lengthHindFlipper int(11) default NULL,    
  sternalMidBlubber int(11) default NULL,    
  heartWeight int(15) default NULL,    
  LTestis float default NULL,    
  RTestis float default NULL,    
  causeofdeathid int(15) default '0',    
  ProxCauseOfDeathClassID int(11) default NULL,    
  ProxCauseOfDeathCategoryID int(11) default NULL,    
  ProxCauseOfDeathCertainty tinyint(4) default NULL,    
  ProxCauseOfDeathPending tinyint(4) default NULL,    
  ProxCauseOfDeathText text,    
  UltiCauseOfDeathClassID int(11) default NULL,    
  UltiCauseOfDeathCategoryID int(11) default NULL,    
  UltiCauseOfDeathCertainty tinyint(4) default NULL,    
  UltiCauseOfDeathPending tinyint(4) default NULL,    
  UltiCauseOfDeathText text,    
  freezeThawDamage varchar(15) default NULL,    
  predatorDamage varchar(15) default NULL,    
  degreePredatorDamage varchar(15) default NULL,    
  predator varchar(15) default NULL,    
  histopathology longblob,    
  findings_id int(15) default NULL,    
  notes text,    
  summary blob,    
  dateentered datetime default '0000-00-00 00:00:00',    
  enteredby varchar(160) default NULL,    
  dateupdated datetime default '0000-00-00 00:00:00',    
  updatedby varchar(160) default NULL,    
  PRIMARY KEY  (audit_id),    
  KEY animalid (animalid),     KEY animalid_2 (animalid),
  KEY pathologist (pathologist)     KEY pathologist_2 (pathologist)
) TYPE=InnoDB; = ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'region'   -- Table structure for table 'region'
--   --
     
CREATE TABLE region (   CREATE TABLE region (
  RegionID int(15) NOT NULL default '0',     RegionID int(15) NOT NULL default '0',
  CountryID int(15) NOT NULL default '0',     CountryID int(15) NOT NULL default '0',
  Region varchar(100) NOT NULL default '',     Region varchar(100) NOT NULL default '',
  PRIMARY KEY  (RegionID)     PRIMARY KEY  (RegionID)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'samples'   -- Table structure for table 'samples'
--   --
     
CREATE TABLE samples (   CREATE TABLE samples (
  id int(11) NOT NULL auto_increment, <>   id int(11) NOT NULL default '0',
  postmortemid int(11) default NULL, =   postmortemid int(11) default NULL,
  -+   wt_taken int(2) default NULL,
      liver_wt float default NULL,
      kidney_wt float default NULL,
      spleen_wt float default NULL,
      heart_wt float default NULL,
      thymus_wt float default NULL,
      comments_wt text,
  par_liver_loc text, =   par_liver_loc text,
  par_liver_pot varchar(20) default NULL,     par_liver_pot varchar(20) default NULL,
  par_lung_loc text,     par_lung_loc text,
  par_lung_pot varchar(20) default NULL,     par_lung_pot varchar(20) default NULL,
  par_stch_loc text,     par_stch_loc text,
  par_stch_pot varchar(20) default NULL,     par_stch_pot varchar(20) default NULL,
  par_int_loc text,     par_int_loc text,
  par_int_pot varchar(20) default NULL,     par_int_pot varchar(20) default NULL,
  par_sinus_loc text,     par_sinus_loc text,
  par_sinus_pot varchar(20) default NULL,     par_sinus_pot varchar(20) default NULL,
  par_oth_loc text,     par_oth_loc text,
  par_oth_pot varchar(20) default NULL,     par_oth_pot varchar(20) default NULL,
  comments_par text,     comments_par text,
  brain_vir int(2) default NULL, <>   blubber_samp int(2) default NULL,
  kidney_vir int(2) default NULL,     epidermis_samp int(2) default NULL,
  lung_vir int(2) default NULL,     kidney_samp int(2) default NULL,
  lung_pcr_vir int(2) default NULL,     liver_samp int(2) default NULL,
  comments_vir varchar(150) default NULL,     muscle_samp int(2) default NULL,
  comments_os text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id),    
  KEY postmortemid (postmortemid)    
) TYPE=MyISAM ;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesfreshtissue'    
--    
     
CREATE TABLE samplesfreshtissue ( <>  
  id int(15) NOT NULL auto_increment,    
  postmortemid int(15) NOT NULL default '0',     serum_samp int(2) default NULL,
  SamplesFreshTissueOptionID int(1) default '0',    
  Comments text,    
  dateentered datetime default NULL,     teeth_samp int(2) default NULL,
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesfreshtissuecomments'    
--    
     
CREATE TABLE samplesfreshtissuecomments ( <>  
  id int(15) NOT NULL auto_increment,    
  postmortemid int(15) NOT NULL default '0',     rib_samp int(2) default NULL,
  observations text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,     scap_samp int(2) default NULL,
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesfreshtissuecomments_audit'    
--    
     
CREATE TABLE samplesfreshtissuecomments_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,    
  id int(15) NOT NULL default '0',     skull_samp int(2) default NULL,
  postmortemid int(15) NOT NULL default '0',     milk_samp int(2) default NULL,
  observations text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesfreshtissueoptions'    
--    
     
CREATE TABLE samplesfreshtissueoptions ( +-  
  SamplesFreshTissueOptionID int(10) NOT NULL auto_increment,    
  SamplesFreshTissueOptionName varchar(100) NOT NULL default '',    
  SamplesFreshTissueOptionIsCurrent tinyint(1) NOT NULL default '0',    
  SortOrder int(15) NOT NULL default '0',    
  PRIMARY KEY  (SamplesFreshTissueOptionID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesfreshtissue_audit'    
--    
     
CREATE TABLE samplesfreshtissue_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,    
  id int(15) NOT NULL default '0',    
  postmortemid int(15) NOT NULL default '0',     foetus_samp int(2) default NULL,
  SamplesFreshTissueOptionID int(1) default '0',    
  Comments text,     comments_samp text,
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,     agland_hist int(2) default NULL,
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,     bladder_hist int(2) default NULL,
  `action` varchar(30) NOT NULL default '',    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesweights'    
--    
     
CREATE TABLE samplesweights ( <>  
  id int(15) NOT NULL auto_increment,     brain_hist int(2) default NULL,
  postmortemid int(15) NOT NULL default '0',     eyes_hist int(2) default NULL,
  SamplesWeightsOrganID int(1) default '0',    
  Weight varchar(15) default '0',    
  Comments text,    
  dateentered datetime default NULL,     heart_hist int(2) default NULL,
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesweightscomments'    
--    
     
CREATE TABLE samplesweightscomments ( <>  
  id int(15) NOT NULL auto_increment,     kidney_hist int(2) default NULL,
  postmortemid int(15) NOT NULL default '0',     liver_hist int(2) default NULL,
  observations text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesweightscomments_audit'    
--    
     
CREATE TABLE samplesweightscomments_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,    
  id int(15) NOT NULL default '0',     lung_hist int(2) default NULL,
  postmortemid int(15) NOT NULL default '0',     mgland_hist int(2) default NULL,
  observations text,    
  dateentered datetime default NULL,     mesen_hist int(2) default NULL,
  enteredby varchar(150) default NULL,     ovaries_hist int(2) default NULL,
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesweightsorgans'    
--    
     
CREATE TABLE samplesweightsorgans ( +-  
  SamplesWeightsOrganID int(10) NOT NULL auto_increment,    
  SamplesWeightsOrganName varchar(100) NOT NULL default '',    
  SamplesWeightsOrganIsCurrent tinyint(1) NOT NULL default '0',    
  SortOrder int(15) NOT NULL default '0',    
  PRIMARY KEY  (SamplesWeightsOrganID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samplesweights_audit'    
--    
     
CREATE TABLE samplesweights_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,     panc_hist int(2) default NULL,
  id int(15) NOT NULL default '0',     pit_hist int(2) default NULL,
  postmortemid int(15) NOT NULL default '0',     pai_hist int(2) default NULL,
  SamplesWeightsOrganID int(1) default '0',     spleen_hist int(2) default NULL,
  Weight varchar(15) default '0',    
  Comments text,    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  `action` varchar(30) NOT NULL default '',    
  PRIMARY KEY  (audit_id)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'samples_audit'    
--    
     
CREATE TABLE samples_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,    
  id int(11) NOT NULL default '0',     test_hist int(2) default NULL,
  postmortemid int(11) default NULL,     thymus_hist int(2) default NULL,
  par_liver_loc text,    
  par_liver_pot varchar(20) default NULL,    
  par_lung_loc text,    
  par_lung_pot varchar(20) default NULL,    
  par_stch_loc text,    
  par_stch_pot varchar(20) default NULL,     thyroid_hist int(2) default NULL,
  par_int_loc text,    
  par_int_pot varchar(20) default NULL,     tbc_hist int(2) default NULL,
  par_sinus_loc text,    
  par_sinus_pot varchar(20) default NULL,     uterus_hist int(2) default NULL,
  par_oth_loc text,    
  par_oth_pot varchar(20) default NULL,    
  comments_par text,     comment_hist text,
  brain_vir int(2) default NULL, =   brain_vir int(2) default NULL,
  kidney_vir int(2) default NULL,     kidney_vir int(2) default NULL,
  lung_vir int(2) default NULL,     lung_vir int(2) default NULL,
  lung_pcr_vir int(2) default NULL,     lung_pcr_vir int(2) default NULL,
  comments_vir varchar(150) default NULL, <>   comments_vir text,
  comments_os text, =   comments_os text,
  dateentered datetime default NULL,     dateentered datetime default NULL,
  enteredby varchar(150) default NULL,     enteredby varchar(150) default NULL,
  dateupdated datetime default NULL,     dateupdated datetime default NULL,
  updatedby varchar(150) default NULL,     updatedby varchar(150) default NULL,
  PRIMARY KEY  (audit_id), <>   PRIMARY KEY  (id),
  KEY postmortemid (postmortemid) =   KEY postmortemid (postmortemid)
) TYPE=MyISAM ;   ) TYPE=MyISAM;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'stage'   -- Table structure for table 'stage'
--   --
     
CREATE TABLE stage (   CREATE TABLE stage (
  stageid int(15) NOT NULL default '0',     stageid int(15) NOT NULL default '0',
  stage varchar(100) default NULL,     stage varchar(100) default NULL,
  forSort int(15) default NULL,     forSort int(15) default NULL,
  stageiscurrent tinyint(1) NOT NULL default '0',     stageiscurrent tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (stageid)     PRIMARY KEY  (stageid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'stomachcontents'    
--    
     
CREATE TABLE stomachcontents ( +-  
  StomachContentsID int(11) NOT NULL auto_increment,    
  postmortemID int(11) NOT NULL default '0',    
  StomachContentsOptionID int(11) NOT NULL default '0',    
  dateupdated datetime NOT NULL default '0000-00-00 00:00:00',    
  updatedby varchar(150) NOT NULL default '',    
  PRIMARY KEY  (StomachContentsID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'stomachcontentsoptions'    
--    
     
CREATE TABLE stomachcontentsoptions ( +-  
  StomachContentsOptionID int(10) NOT NULL auto_increment,    
  StomachContents varchar(100) NOT NULL default '',    
  StomachContentsSpecify tinyint(1) NOT NULL default '0',    
  StomachContentsIsCurrent tinyint(4) NOT NULL default '0',    
  SortOrder int(15) NOT NULL default '0',    
  PRIMARY KEY  (StomachContentsOptionID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'stomachcontents_audit'    
--    
     
CREATE TABLE stomachcontents_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  StomachContentsID int(11) NOT NULL default '0',    
  postmortemID int(11) NOT NULL default '0',    
  StomachContentsOptionID int(11) NOT NULL default '0',    
  dateupdated datetime NOT NULL default '0000-00-00 00:00:00',    
  updatedby varchar(150) NOT NULL default '',    
  PRIMARY KEY  (audit_id),    
  KEY nmssampletypeoptionID (StomachContentsOptionID),    
  KEY Animalid (postmortemID)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'strandedanimal'   -- Table structure for table 'strandedanimal'
--   --
     
CREATE TABLE strandedanimal (   CREATE TABLE strandedanimal (
  Animalid int(15) NOT NULL default '0',     Animalid int(15) NOT NULL default '0',
  NationalReference varchar(40) default NULL,     NationalReference varchar(40) default NULL,
  SACNumber varchar(40) NOT NULL default '', +-  
  MassSingleNumberOLD int(15) default NULL, =   MassSingleNumberOLD int(15) default NULL,
  strandingid int(15) NOT NULL default '0',     strandingid int(15) NOT NULL default '0',
  m_ref varchar(15) default NULL,     m_ref varchar(15) default NULL,
  animalCode int(15) NOT NULL default '0',     animalCode int(15) NOT NULL default '0',
  certaintyidentid int(15) NOT NULL default '0',     certaintyidentid int(15) NOT NULL default '0',
  datefound datetime NOT NULL default '0000-00-00 00:00:00',     datefound datetime NOT NULL default '0000-00-00 00:00:00',
  sentForPM tinyint(1) default NULL,     sentForPM tinyint(1) default NULL,
  location text,     location text,
  CoordinateSystemID int(15) NOT NULL default '0',     CoordinateSystemID int(15) NOT NULL default '0',
  LatitudeText varchar(40) default NULL,     LatitudeText varchar(40) default NULL,
  LongitudeText varchar(40) default NULL,     LongitudeText varchar(40) default NULL,
  GridRefText varchar(40) default NULL,     GridRefText varchar(40) default NULL,
  easting int(15) default NULL,     easting int(15) default NULL,
  northing int(15) default NULL,     northing int(15) default NULL,
  latitude float default NULL,     latitude float default NULL,
  longitude float default NULL,     longitude float default NULL,
  gridref varchar(40) default NULL,     gridref varchar(40) default NULL,
  locationCertainty varchar(30) default NULL,     locationCertainty varchar(30) default NULL,
  sex varchar(15) default NULL,     sex varchar(15) default NULL,
  lengthtext varchar(60) default NULL,     lengthtext varchar(60) default NULL,
  length int(15) default NULL,     length int(15) default NULL,
  strandingtypeid int(15) default '0',     strandingtypeid int(15) default '0',
  conditionid int(15) default '0',     conditionid int(15) default '0',
  photos varchar(250) default NULL, <>   photos tinyint(1) default '0',
  SpeciesUncertain tinyint(1) default '0', =   SpeciesUncertain tinyint(1) default '0',
  datecertaintyid int(15) default '0',     datecertaintyid int(15) default '0',
  LengthUncertain tinyint(1) default '0',     LengthUncertain tinyint(1) default '0',
  samples tinyint(1) default '0',     samples tinyint(1) default '0',
  euthanased tinyint(1) default '0',     euthanased tinyint(1) default '0',
  dateentered datetime default NULL, <>   dateentered datetime default '0000-00-00 00:00:00',
  enteredby varchar(150) default NULL, =   enteredby varchar(150) default NULL,
  dateupdated datetime default NULL,     dateupdated datetime default NULL,
  updatedby varchar(150) default NULL,     updatedby varchar(150) default NULL,
  PRIMARY KEY  (Animalid),     PRIMARY KEY  (Animalid),
  KEY datefound (datefound),     KEY datefound (datefound),
  KEY animalCode (animalCode),     KEY animalCode (animalCode),
  -+   KEY NationalReference (NationalReference),
  KEY strandingid (strandingid), =   KEY strandingid (strandingid),
  KEY SACNumber (SACNumber) +-  
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'strandedanimal_audit'    
--    
     
CREATE TABLE strandedanimal_audit ( <>  
  audit_id int(11) NOT NULL auto_increment,    
  Animalid int(15) NOT NULL default '0',    
  NationalReference varchar(40) default NULL,    
  SACNumber varchar(40) NOT NULL default '',    
  NMSNumber varchar(40) NOT NULL default '',    
  NMSConfirmedSpecies varchar(255) NOT NULL default '',    
  MassSingleNumberOLD int(15) default NULL,    
  strandingid int(15) NOT NULL default '0',    
  m_ref varchar(15) default NULL,    
  animalCode int(15) NOT NULL default '0',    
  certaintyidentid int(15) NOT NULL default '0',    
  datefound datetime NOT NULL default '0000-00-00 00:00:00',    
  sentForPM tinyint(1) default NULL,    
  location text,    
  CoordinateSystemID int(15) NOT NULL default '0',    
  LatitudeText varchar(40) default NULL,    
  LongitudeText varchar(40) default NULL,    
  GridRefText varchar(40) default NULL,    
  easting int(15) default NULL,    
  northing int(15) default NULL,    
  latitude float default NULL,    
  longitude float default NULL,    
  gridref varchar(40) default NULL,    
  locationCertainty varchar(30) default NULL,    
  sex varchar(15) default NULL,    
  lengthtext varchar(60) default NULL,    
  length int(15) default NULL,    
  strandingtypeid int(15) default '0',    
  conditionid int(15) default '0',    
  photos varchar(250) default NULL,    
  SpeciesUncertain tinyint(1) default '0',    
  datecertaintyid int(15) default '0',    
  LengthUncertain tinyint(1) default '0',    
  samples tinyint(1) default '0',    
  euthanased tinyint(1) default '0',    
  dateentered datetime default NULL,    
  enteredby varchar(150) default NULL,    
  dateupdated datetime default NULL,    
  updatedby varchar(150) default NULL,    
  PRIMARY KEY  (audit_id),    
  KEY datefound (datefound),    
  KEY animalCode (animalCode),     KEY animalCode_2 (animalCode)
  KEY strandingid (strandingid),    
  KEY SACNumber (SACNumber)    
) TYPE=InnoDB; = ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'stranding'   -- Table structure for table 'stranding'
--   --
     
CREATE TABLE stranding (   CREATE TABLE stranding (
  strandingid int(15) NOT NULL default '0',     strandingid int(15) NOT NULL default '0',
  NationalReferenceRootOLD varchar(150) default NULL,     NationalReferenceRootOLD varchar(150) default NULL,
  singlemassOLD varchar(150) default NULL,     singlemassOLD varchar(150) default NULL,
  animalClassid int(15) NOT NULL default '0',     animalClassid int(15) NOT NULL default '0',
  countyid int(15) NOT NULL default '0',     countyid int(15) NOT NULL default '0',
  dateOfStranding datetime default NULL,     dateOfStranding datetime default NULL,
  dateReported datetime default NULL,     dateReported datetime default NULL,
  Event int(1) default NULL,     Event int(1) default NULL,
  NameReporter varchar(160) default NULL,     NameReporter varchar(160) default NULL,
  emailReporter varchar(160) default NULL,     emailReporter varchar(160) default NULL,
  phoneReporter varchar(100) default NULL,     phoneReporter varchar(100) default NULL,
  addrReporter text,     addrReporter text,
  ReportSummary text,     ReportSummary text,
  reportRequested int(1) default '0',     reportRequested int(1) default '0',
  reportSent int(1) default '0', <>   reportSent int(1) default NULL,
  StageID int(15) default '0', =   StageID int(15) default '0',
  dateentered datetime default '0000-00-00 00:00:00',     dateentered datetime default '0000-00-00 00:00:00',
  enteredby varchar(160) default NULL,     enteredby varchar(160) default NULL,
  dateupdated datetime default '0000-00-00 00:00:00',     dateupdated datetime default '0000-00-00 00:00:00',
  updatedby varchar(160) default NULL,     updatedby varchar(160) default NULL,
  PRIMARY KEY  (strandingid),     PRIMARY KEY  (strandingid),
  KEY animalClassid (animalClassid) <>   KEY animalClassid (animalClassid),
      KEY countyid (countyid),
      KEY animalClassid_2 (animalClassid),
      KEY strandingid (strandingid)
) TYPE=InnoDB; = ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'strandingtype'   -- Table structure for table 'strandingtype'
--   --
     
CREATE TABLE strandingtype (   CREATE TABLE strandingtype (
  strandingTypeid int(15) NOT NULL default '0',     strandingTypeid int(15) NOT NULL default '0',
  strandingtype varchar(100) default NULL,     strandingtype varchar(100) default NULL,
  typeisCurrent tinyint(1) NOT NULL default '0',     typeisCurrent tinyint(1) NOT NULL default '0',
  forSort int(15) default NULL,     forSort int(15) default NULL,
  PRIMARY KEY  (strandingTypeid)     PRIMARY KEY  (strandingTypeid)
) TYPE=InnoDB;   ) TYPE=InnoDB;
     
-- --------------------------------------------------------   -- --------------------------------------------------------
     
--   --
-- Table structure for table 'stranding_audit'    
--    
     
CREATE TABLE stranding_audit ( +-  
  audit_id int(11) NOT NULL auto_increment,    
  strandingid int(15) NOT NULL default '0',    
  NationalReferenceRootOLD varchar(150) default NULL,    
  singlemassOLD varchar(150) default NULL,    
  animalClassid int(15) NOT NULL default '0',    
  countyid int(15) NOT NULL default '0',    
  dateOfStranding datetime default NULL,    
  dateReported datetime default NULL,    
  Event int(1) default NULL,    
  NameReporter varchar(160) default NULL,    
  emailReporter varchar(160) default NULL,    
  phoneReporter varchar(100) default NULL,    
  addrReporter text,    
  ReportSummary text,    
  reportRequested int(1) default '0',    
  reportSent int(1) default '0',    
  StageID int(15) default '0',    
  dateentered datetime default '0000-00-00 00:00:00',    
  enteredby varchar(160) default NULL,    
  dateupdated datetime default '0000-00-00 00:00:00',    
  updatedby varchar(160) default NULL,    
  PRIMARY KEY  (audit_id),    
  KEY animalClassid (animalClassid)    
) TYPE=InnoDB;    
  =  
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'user'   -- Table structure for table 'user'
--   --
     
CREATE TABLE `user` ( <> CREATE TABLE user (
  userID int(15) NOT NULL auto_increment,     userID int(15) NOT NULL default '0',
  username varchar(30) NOT NULL default '', =   username varchar(30) NOT NULL default '',
  `password` varchar(75) default NULL, <>   password varchar(75) default NULL,
  firstname varchar(75) default NULL, =   firstname varchar(75) default NULL,
  lastname varchar(75) default NULL,     lastname varchar(75) default NULL,
  access int(2) NOT NULL default '0',     access int(2) NOT NULL default '0',
  permissionID int(11) NOT NULL default '0', +-  
  email text, =   email text,
  sessionid varchar(250) default NULL,     sessionid varchar(250) default NULL,
  lastlogin datetime NOT NULL default '0000-00-00 00:00:00',     lastlogin datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (userID)     PRIMARY KEY  (userID)
) TYPE=MyISAM ;   ) TYPE=MyISAM;
     
-- --------------------------------------------------------    
     
--    
-- Table structure for table 'user_permission'    
--    
     
CREATE TABLE user_permission ( +-  
  permissionID int(11) NOT NULL auto_increment,    
  permissionTitle varchar(255) NOT NULL default '0',    
  editBasics tinyint(4) NOT NULL default '0',    
  editMorphometric tinyint(4) NOT NULL default '0',    
  editNecropsy tinyint(4) NOT NULL default '0',    
  editBacteriology tinyint(4) NOT NULL default '0',    
  editSamples tinyint(4) NOT NULL default '0',    
  editSamplesWeights tinyint(4) NOT NULL default '0',    
  editSamplesFreshTissue tinyint(4) NOT NULL default '0',    
  editSamplesParasitesVirology tinyint(4) NOT NULL default '0',    
  editFreezer tinyint(4) NOT NULL default '0',    
  editNMSData tinyint(4) NOT NULL default '0',    
  editHistology tinyint(4) NOT NULL default '0',    
  viewBasics tinyint(4) NOT NULL default '0',    
  viewMorphometric tinyint(4) NOT NULL default '0',    
  viewNecropsy tinyint(4) NOT NULL default '0',    
  viewBacteriology tinyint(4) NOT NULL default '0',    
  viewSamples tinyint(4) NOT NULL default '0',    
  viewSamplesWeights tinyint(4) NOT NULL default '0',    
  viewSamplesFreshTissue tinyint(4) NOT NULL default '0',    
  viewSamplesParasitesVirology tinyint(4) NOT NULL default '0',    
  viewFreezer tinyint(4) NOT NULL default '0',    
  viewNMSData tinyint(4) NOT NULL default '0',    
  viewHistology tinyint(4) NOT NULL default '0',    
  PRIMARY KEY  (permissionID)    
) TYPE=InnoDB;