Project

General

Profile

« Previous | Next » 

Revision 578

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.ERD.mwb: Deal with MySQL assuming that a timestamp field is NOT NULL

View differences:

schemas/vegbien.for_ERD.my.sql
97 97 
  project_id int(11) NOT NULL AUTO_INCREMENT,
98 98 
  projectname character varying(150) NOT NULL,
99 99 
  projectdescription text,
100 
  startdate timestamp,
101 
  stopdate timestamp,
100 
  startdate timestamp NULL,
101 
  stopdate timestamp NULL,
102 102 
  d_obscount int(11),
103 
  d_lastlocationaddeddate timestamp,
103 
  d_lastlocationaddeddate timestamp NULL,
104 104 
  accessioncode character varying(255),
105 105 
  CONSTRAINT project_pkey PRIMARY KEY (project_id ),
106 106 
  CONSTRAINT project_keys UNIQUE (projectname , startdate , stopdate )
......
247 247 
  reference_id int(11) NOT NULL,
248 248 
  collectioncode_dwc character varying(255),
249 249 
  catalognumber_dwc character varying(255),
250 
  collectiondate timestamp,
250 
  collectiondate timestamp NULL,
251 251 
  collector_id int(11),
252 252 
  museum_id int(11),
253 253 
  sourceaccessionnumber character varying(100),

Also available in: Unified diff