Revision 12521
Added by Aaron Marcuse-Kubitza almost 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 436 | 436 |
|
| 437 | 437 |
|
| 438 | 438 |
-- |
| 439 |
-- Name: location_set_top_plot(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 439 |
-- Name: location_set_plot_location_id(); Type: FUNCTION; Schema: public; Owner: -
|
|
| 440 | 440 |
-- |
| 441 | 441 |
|
| 442 | 442 |
|
| 443 | 443 |
|
| 444 | 444 |
|
| 445 | 445 |
-- |
| 446 |
-- Name: FUNCTION location_set_top_plot(); Type: COMMENT; Schema: public; Owner: -
|
|
| 446 |
-- Name: FUNCTION location_set_plot_location_id(); Type: COMMENT; Schema: public; Owner: -
|
|
| 447 | 447 |
-- |
| 448 | 448 |
|
| 449 | 449 |
|
| ... | ... | |
| 1374 | 1374 |
location_id int(11) NOT NULL, |
| 1375 | 1375 |
source_id int(11) NOT NULL, |
| 1376 | 1376 |
sourceaccessioncode varchar(255), |
| 1377 |
top_plot int(11) NOT NULL,
|
|
| 1377 |
plot_location_id int(11) NOT NULL,
|
|
| 1378 | 1378 |
parent_id int(11), |
| 1379 | 1379 |
authorlocationcode varchar(255), |
| 1380 | 1380 |
place_id int(11), |
| ... | ... | |
| 1427 | 1427 |
|
| 1428 | 1428 |
|
| 1429 | 1429 |
-- |
| 1430 |
-- Name: COLUMN location.top_plot; Type: COMMENT; Schema: public; Owner: -
|
|
| 1430 |
-- Name: COLUMN location.plot_location_id; Type: COMMENT; Schema: public; Owner: -
|
|
| 1431 | 1431 |
-- |
| 1432 | 1432 |
|
| 1433 | 1433 |
|
| ... | ... | |
| 7931 | 7931 |
|
| 7932 | 7932 |
|
| 7933 | 7933 |
-- |
| 7934 |
-- Name: location_top_plot; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 7934 |
-- Name: location_plot_location_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 7935 | 7935 |
-- |
| 7936 | 7936 |
|
| 7937 |
CREATE INDEX location_top_plot ON location (top_plot);
|
|
| 7937 |
CREATE INDEX location_plot_location_id ON location (plot_location_id);
|
|
| 7938 | 7938 |
|
| 7939 | 7939 |
|
| 7940 | 7940 |
-- |
| ... | ... | |
| 8750 | 8750 |
|
| 8751 | 8751 |
|
| 8752 | 8752 |
-- |
| 8753 |
-- Name: location_set_top_plot; Type: TRIGGER; Schema: public; Owner: -
|
|
| 8753 |
-- Name: location_set_plot_location_id; Type: TRIGGER; Schema: public; Owner: -
|
|
| 8754 | 8754 |
-- |
| 8755 | 8755 |
|
| 8756 | 8756 |
|
Also available in: Unified diff
schemas/vegbien.sql: location.top_plot: renamed to plot_location_id, as requested by Brad (wiki.vegpath.org/2014-02-27_conference_call#schema-changes)