Project

General

Profile

« Previous | Next » 

Revision 580

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Renamed location.latitude and longitude to publiclatitude, publiclongitude to reflect that they are not the actual lat/long. Switched to requiring reallatitude/reallongitude.

View differences:

schemas/vegbien.for_ERD.my.sql
114 114 
  authorlocationcode character varying(30) NOT NULL DEFAULT '',
115 115 
  reference_id int(11),
116 116 
  parent_id int(11),
117 
  reallatitude double precision,
118 
  reallongitude double precision,
117 
  reallatitude double precision NOT NULL DEFAULT 'NaN',
118 
  reallongitude double precision NOT NULL DEFAULT 'NaN',
119 119 
  locationaccuracy double precision,
120 120 
  confidentialitystatus int(11) NOT NULL DEFAULT 0,
121 121 
  confidentialityreason character varying(200),
122 
  latitude double precision,
123 
  longitude double precision,
122 
  publiclatitude double precision,
123 
  publiclongitude double precision,
124 124 
  `... (truncated) ...` int(11),
125 125 
  accessioncode character varying(255),
126 126 
  sublocationxposition double precision,
schemas/vegbien.for_wiki.sql
4 4 
  authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying,
5 5 
  reference_id integer,
6 6 
  parent_id integer,
7 
  reallatitude double precision,
8 
  reallongitude double precision,
7 
  reallatitude double precision NOT NULL DEFAULT 'NaN'::double precision,
8 
  reallongitude double precision NOT NULL DEFAULT 'NaN'::double precision,
9 9 
  locationaccuracy double precision,
10 10 
  confidentialitystatus integer NOT NULL DEFAULT 0,
11 11 
  confidentialityreason character varying(200),
12 
  latitude double precision,
13 
  longitude double precision,
12 
  publiclatitude double precision,
13 
  publiclongitude double precision,
14 14 
  "... (truncated) ..." integer,
15 15 
  accessioncode character varying(255),
16 16 
  sublocationxposition double precision,
schemas/vegbien.for_ERD.sql
114 114 
  authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying,
115 115 
  reference_id integer,
116 116 
  parent_id integer,
117 
  reallatitude double precision,
118 
  reallongitude double precision,
117 
  reallatitude double precision NOT NULL DEFAULT 'NaN'::double precision,
118 
  reallongitude double precision NOT NULL DEFAULT 'NaN'::double precision,
119 119 
  locationaccuracy double precision,
120 120 
  confidentialitystatus integer NOT NULL DEFAULT 0,
121 121 
  confidentialityreason character varying(200),
122 
  latitude double precision,
123 
  longitude double precision,
122 
  publiclatitude double precision,
123 
  publiclongitude double precision,
124 124 
  "... (truncated) ..." integer,
125 125 
  accessioncode character varying(255),
126 126 
  sublocationxposition double precision,
schemas/vegbien.sql
1127 1127 
    authorlocationcode character varying(30) DEFAULT ''::character varying NOT NULL,
1128 1128 
    reference_id integer,
1129 1129 
    parent_id integer,
1130 
    reallatitude double precision,
1131 
    reallongitude double precision,
1130 
    reallatitude double precision DEFAULT 'NaN'::double precision NOT NULL,
1131 
    reallongitude double precision DEFAULT 'NaN'::double precision NOT NULL,
1132 1132 
    locationaccuracy double precision,
1133 1133 
    confidentialitystatus integer DEFAULT 0 NOT NULL,
1134 1134 
    confidentialityreason character varying(200),
1135 
    latitude double precision DEFAULT 'NaN'::double precision NOT NULL,
1136 
    longitude double precision DEFAULT 'NaN'::double precision NOT NULL,
1135 
    publiclatitude double precision,
1136 
    publiclongitude double precision,
1137 1137 
    authore character varying(20),
1138 1138 
    authorn character varying(20),
1139 1139 
    authorzone character varying(20),

Also available in: Unified diff