Revision 13930
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 6760 | 6760 |
|
| 6761 | 6761 |
|
| 6762 | 6762 |
-- |
| 6763 |
-- Name: VIEW iucn_red_list_view; Type: COMMENT; Schema: public; Owner: - |
|
| 6764 |
-- |
|
| 6765 |
|
|
| 6766 |
|
|
| 6767 |
|
|
| 6768 |
|
|
| 6769 |
-- |
|
| 6763 | 6770 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 6764 | 6771 |
-- |
| 6765 | 6772 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9631 | 9631 |
|
| 9632 | 9632 |
|
| 9633 | 9633 |
-- |
| 9634 |
-- Name: VIEW iucn_red_list_view; Type: COMMENT; Schema: public; Owner: - |
|
| 9635 |
-- |
|
| 9636 |
|
|
| 9637 |
COMMENT ON VIEW iucn_red_list_view IS ' |
|
| 9638 |
after updating this: |
|
| 9639 |
SELECT util.rematerialize_view(''iucn_red_list'', ''iucn_red_list_view'');
|
|
| 9640 |
ALTER TABLE iucn_red_list ADD PRIMARY KEY(accepted_family, accepted_species_binomial); |
|
| 9641 |
'; |
|
| 9642 |
|
|
| 9643 |
|
|
| 9644 |
-- |
|
| 9634 | 9645 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 9635 | 9646 |
-- |
| 9636 | 9647 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9631 | 9631 |
|
| 9632 | 9632 |
|
| 9633 | 9633 |
-- |
| 9634 |
-- Name: VIEW iucn_red_list_view; Type: COMMENT; Schema: public; Owner: - |
|
| 9635 |
-- |
|
| 9636 |
|
|
| 9637 |
COMMENT ON VIEW iucn_red_list_view IS ' |
|
| 9638 |
after updating this: |
|
| 9639 |
SELECT util.rematerialize_view(''iucn_red_list'', ''iucn_red_list_view'');
|
|
| 9640 |
ALTER TABLE iucn_red_list ADD PRIMARY KEY(accepted_family, accepted_species_binomial); |
|
| 9641 |
'; |
|
| 9642 |
|
|
| 9643 |
|
|
| 9644 |
-- |
|
| 9634 | 9645 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 9635 | 9646 |
-- |
| 9636 | 9647 |
|
Also available in: Unified diff
schemas/public_.sql: iucn_red_list_view: documented how to regenerate iucn_red_list from this