Revision 1080
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 588 | 588 |
|
| 589 | 589 |
CREATE TABLE location ( |
| 590 | 590 |
location_id int(11) NOT NULL, |
| 591 |
authorlocationcode text, |
|
| 592 | 591 |
parent_id int(11), |
| 593 | 592 |
centerlatitude double precision, |
| 594 | 593 |
centerlongitude double precision, |
| ... | ... | |
| 2965 | 2964 |
|
| 2966 | 2965 |
|
| 2967 | 2966 |
-- |
| 2968 |
-- Name: location_keys_subplot_code; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 2969 |
-- |
|
| 2970 |
|
|
| 2971 |
ALTER TABLE location |
|
| 2972 |
ADD CONSTRAINT location_keys_subplot_code UNIQUE (parent_id, authorlocationcode); |
|
| 2973 |
|
|
| 2974 |
|
|
| 2975 |
-- |
|
| 2976 | 2967 |
-- Name: location_keys_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 2977 | 2968 |
-- |
| 2978 | 2969 |
|
Also available in: Unified diff
vegbien.sql: Removed location.authorlocationcode because it's now stored in locationevent as an author-specific setting