Revision 1080
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 699 | 699 |
|
| 700 | 700 |
CREATE TABLE location ( |
| 701 | 701 |
location_id integer NOT NULL, |
| 702 |
authorlocationcode text, |
|
| 703 | 702 |
parent_id integer, |
| 704 | 703 |
centerlatitude double precision, |
| 705 | 704 |
centerlongitude double precision, |
| ... | ... | |
| 3326 | 3325 |
|
| 3327 | 3326 |
|
| 3328 | 3327 |
-- |
| 3329 |
-- Name: location_keys_subplot_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3330 |
-- |
|
| 3331 |
|
|
| 3332 |
ALTER TABLE ONLY location |
|
| 3333 |
ADD CONSTRAINT location_keys_subplot_code UNIQUE (parent_id, authorlocationcode); |
|
| 3334 |
|
|
| 3335 |
|
|
| 3336 |
-- |
|
| 3337 | 3328 |
-- Name: location_keys_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3338 | 3329 |
-- |
| 3339 | 3330 |
|
Also available in: Unified diff
vegbien.sql: Removed location.authorlocationcode because it's now stored in locationevent as an author-specific setting