Project

General

Profile

« Previous | Next » 

Revision 575

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Made several fields optional, adding defaults where needed

View differences:

vegbien.for_wiki.sql
1 1 
CREATE TABLE location
2 2 
(
3 3 
  location_id serial NOT NULL,
4 
  authorlocationcode character varying(30),
4 
  authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying,
5 5 
  reference_id integer,
6 6 
  parent_id integer,
7 7 
  reallatitude double precision,
8 8 
  reallongitude double precision,
9 9 
  locationaccuracy double precision,
10 
  confidentialitystatus integer NOT NULL,
10 
  confidentialitystatus integer NOT NULL DEFAULT 0,
11 11 
  confidentialityreason character varying(200),
12 12 
  latitude double precision,
13 13 
  longitude double precision,
......
115 115 
  taxondetermination_id serial NOT NULL,
116 116 
  taxonoccurrence_id integer NOT NULL,
117 117 
  plantconcept_id integer NOT NULL,
118 
  party_id integer NOT NULL,
118 
  party_id integer,
119 119 
  role_id integer NOT NULL,
120 120 
  determinationtype character varying(30),
121 121 
  reference_id integer,
122 
  originaldetermination boolean NOT NULL,
123 
  currentdetermination boolean NOT NULL,
122 
  originaldetermination boolean NOT NULL DEFAULT false,
123 
  currentdetermination boolean NOT NULL DEFAULT false,
124 124 
  taxonfit character varying(50),
125 125 
  taxonconfidence character varying(50),
126 126 
  grouptype character varying(20),

Also available in: Unified diff