Project

General

Profile

« Previous | Next » 

Revision 8527

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: removed redundant "DEFAULT NULL" clauses on nullable fields

View differences:

schemas/VegCore/VegCore.my.sql
8 8 
-- -----------------------------------------------------
9 9 
CREATE  TABLE IF NOT EXISTS `source` (
10 10 
  `id` TEXT NOT NULL ,
11 
  `parent` TEXT NULL DEFAULT NULL ,
11 
  `parent` TEXT NULL ,
12 12 
  PRIMARY KEY (`id`) ,
13 13 
  INDEX `fk_source1` (`parent` ASC) ,
14 14 
  CONSTRAINT `fk_source1`
......
74 74 
-- -----------------------------------------------------
75 75 
CREATE  TABLE IF NOT EXISTS `taxon` (
76 76 
  `id` TEXT NOT NULL ,
77 
  `parent` TEXT NULL DEFAULT NULL ,
77 
  `parent` TEXT NULL ,
78 78 
  PRIMARY KEY (`id`) ,
79 79 
  INDEX `fk_taxon_taxon1` (`parent` ASC) ,
80 80 
  CONSTRAINT `fk_taxon_record1`
......
182 182 
-- -----------------------------------------------------
183 183 
CREATE  TABLE IF NOT EXISTS `location` (
184 184 
  `id` TEXT NOT NULL ,
185 
  `parent` TEXT NULL DEFAULT NULL ,
186 
  `named_place` TEXT NULL DEFAULT NULL ,
187 
  `coordinates` TEXT NULL DEFAULT NULL ,
185 
  `parent` TEXT NULL ,
186 
  `named_place` TEXT NULL ,
187 
  `coordinates` TEXT NULL ,
188 188 
  PRIMARY KEY (`id`) ,
189 189 
  INDEX `fk_location_coordinates1` (`coordinates` ASC) ,
190 190 
  INDEX `fk_location_placename1` (`named_place` ASC) ,
......
235 235 
-- -----------------------------------------------------
236 236 
CREATE  TABLE IF NOT EXISTS `event` (
237 237 
  `id` TEXT NOT NULL ,
238 
  `parent` TEXT NULL DEFAULT NULL ,
239 
  `location` TEXT NULL DEFAULT NULL ,
240 
  `method` TEXT NULL DEFAULT NULL ,
238 
  `parent` TEXT NULL ,
239 
  `location` TEXT NULL ,
240 
  `method` TEXT NULL ,
241 241 
  PRIMARY KEY (`id`) ,
242 242 
  INDEX `fk_event_location1` (`location` ASC) ,
243 243 
  INDEX `fk_event1` (`parent` ASC) ,
......
272 272 
-- -----------------------------------------------------
273 273 
CREATE  TABLE IF NOT EXISTS `taxon_occurrence` (
274 274 
  `id` TEXT NOT NULL ,
275 
  `current_determination` TEXT NULL DEFAULT NULL ,
276 
  `original_determination` TEXT NULL DEFAULT NULL ,
275 
  `current_determination` TEXT NULL ,
276 
  `original_determination` TEXT NULL ,
277 277 
  PRIMARY KEY (`id`) ,
278 278 
  INDEX `fk_taxon_occurrence_taxon_determination1` (`original_determination` ASC) ,
279 279 
  INDEX `fk_taxon_occurrence_taxon_determination2` (`current_determination` ASC) ,
......
613 613 
CREATE  TABLE IF NOT EXISTS `location_observation` (
614 614 
  `id` TEXT NOT NULL ,
615 615 
  `location` TEXT NOT NULL ,
616 
  `geological_context` TEXT NULL DEFAULT NULL ,
617 
  `community` TEXT NULL DEFAULT NULL ,
616 
  `geological_context` TEXT NULL ,
617 
  `community` TEXT NULL ,
618 618 
  INDEX `fk_location_observation_location1` (`location` ASC) ,
619 619 
  INDEX `fk_location_observation_geological_context1` (`geological_context` ASC) ,
620 620 
  INDEX `fk_location_observation_community1` (`community` ASC) ,

Also available in: Unified diff