Revision 7159
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 437 | 437 |
|
| 438 | 438 |
|
| 439 | 439 |
-- |
| 440 |
-- Name: taxondetermination_set_iscurrent(); Type: FUNCTION; Schema: public; Owner: - |
|
| 440 |
-- Name: taxondetermination_set_iscurrent(integer); Type: FUNCTION; Schema: public; Owner: -
|
|
| 441 | 441 |
-- |
| 442 | 442 |
|
| 443 | 443 |
|
| 444 | 444 |
|
| 445 | 445 |
|
| 446 | 446 |
-- |
| 447 |
-- Name: taxondetermination_set_iscurrent_on_delete(); Type: FUNCTION; Schema: public; Owner: - |
|
| 448 |
-- |
|
| 449 |
|
|
| 450 |
|
|
| 451 |
|
|
| 452 |
|
|
| 453 |
-- |
|
| 454 |
-- Name: taxondetermination_set_iscurrent_on_insert(); Type: FUNCTION; Schema: public; Owner: - |
|
| 455 |
-- |
|
| 456 |
|
|
| 457 |
|
|
| 458 |
|
|
| 459 |
|
|
| 460 |
-- |
|
| 447 | 461 |
-- Name: taxonlabel_0_matched_label_id_self_ref(); Type: FUNCTION; Schema: public; Owner: - |
| 448 | 462 |
-- |
| 449 | 463 |
|
| ... | ... | |
| 6227 | 6241 |
|
| 6228 | 6242 |
|
| 6229 | 6243 |
-- |
| 6230 |
-- Name: taxondetermination_set_iscurrent; Type: TRIGGER; Schema: public; Owner: - |
|
| 6244 |
-- Name: taxondetermination_set_iscurrent_on_delete; Type: TRIGGER; Schema: public; Owner: -
|
|
| 6231 | 6245 |
-- |
| 6232 | 6246 |
|
| 6233 | 6247 |
|
| 6234 | 6248 |
|
| 6235 | 6249 |
|
| 6236 | 6250 |
-- |
| 6251 |
-- Name: taxondetermination_set_iscurrent_on_insert; Type: TRIGGER; Schema: public; Owner: - |
|
| 6252 |
-- |
|
| 6253 |
|
|
| 6254 |
|
|
| 6255 |
|
|
| 6256 |
|
|
| 6257 |
-- |
|
| 6237 | 6258 |
-- Name: taxonlabel_0_matched_label_id_self_ref; Type: TRIGGER; Schema: public; Owner: - |
| 6238 | 6259 |
-- |
| 6239 | 6260 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: taxondetermination_set_iscurrent() trigger: Also run on delete, to mark another taxondetermination as the current one when a current taxondetermination is deleted