Revision 2231
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 89 | 89 |
|
| 90 | 90 |
|
| 91 | 91 |
-- |
| 92 |
-- Name: _toTaxonrank(); Type: FUNCTION; Schema: public; Owner: - |
|
| 93 |
-- |
|
| 94 |
|
|
| 95 |
|
|
| 96 |
|
|
| 97 |
|
|
| 98 |
-- |
|
| 92 | 99 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 93 | 100 |
-- |
| 94 | 101 |
|
| ... | ... | |
| 130 | 137 |
); |
| 131 | 138 |
|
| 132 | 139 |
|
| 140 |
-- |
|
| 141 |
-- Name: _toTaxonrank; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 142 |
-- |
|
| 133 | 143 |
|
| 144 |
CREATE TABLE `_toTaxonrank` ( |
|
| 145 |
result text, |
|
| 146 |
value text |
|
| 147 |
); |
|
| 134 | 148 |
|
| 149 |
|
|
| 150 |
|
|
| 151 |
|
|
| 135 | 152 |
-- |
| 136 | 153 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 137 | 154 |
-- |
| ... | ... | |
| 3665 | 3682 |
|
| 3666 | 3683 |
|
| 3667 | 3684 |
-- |
| 3685 |
-- Name: _toTaxonrank_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3686 |
-- |
|
| 3687 |
|
|
| 3688 |
|
|
| 3689 |
|
|
| 3690 |
|
|
| 3691 |
-- |
|
| 3668 | 3692 |
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3669 | 3693 |
-- |
| 3670 | 3694 |
|
| ... | ... | |
| 4785 | 4809 |
|
| 4786 | 4810 |
|
| 4787 | 4811 |
-- |
| 4812 |
-- Name: _toTaxonrank; Type: TRIGGER; Schema: public; Owner: - |
|
| 4813 |
-- |
|
| 4814 |
|
|
| 4815 |
|
|
| 4816 |
|
|
| 4817 |
|
|
| 4818 |
-- |
|
| 4788 | 4819 |
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - |
| 4789 | 4820 |
-- |
| 4790 | 4821 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 192 | 192 |
|
| 193 | 193 |
|
| 194 | 194 |
-- |
| 195 |
-- Name: _toTaxonrank(); Type: FUNCTION; Schema: public; Owner: - |
|
| 196 |
-- |
|
| 197 |
|
|
| 198 |
CREATE FUNCTION "_toTaxonrank"() RETURNS trigger |
|
| 199 |
LANGUAGE plpgsql IMMUTABLE |
|
| 200 |
AS $$ |
|
| 201 |
BEGIN |
|
| 202 |
new.result := CAST(new.value AS taxonrank); |
|
| 203 |
RETURN new; |
|
| 204 |
END; |
|
| 205 |
$$; |
|
| 206 |
|
|
| 207 |
|
|
| 208 |
-- |
|
| 195 | 209 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 196 | 210 |
-- |
| 197 | 211 |
|
| ... | ... | |
| 332 | 346 |
); |
| 333 | 347 |
|
| 334 | 348 |
|
| 349 |
-- |
|
| 350 |
-- Name: _toTaxonrank; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 351 |
-- |
|
| 352 |
|
|
| 353 |
CREATE TABLE "_toTaxonrank" ( |
|
| 354 |
result taxonrank, |
|
| 355 |
value text |
|
| 356 |
); |
|
| 357 |
|
|
| 358 |
|
|
| 335 | 359 |
SET default_with_oids = true; |
| 336 | 360 |
|
| 337 | 361 |
-- |
| ... | ... | |
| 4199 | 4223 |
|
| 4200 | 4224 |
|
| 4201 | 4225 |
-- |
| 4226 |
-- Name: _toTaxonrank_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4227 |
-- |
|
| 4228 |
|
|
| 4229 |
CREATE UNIQUE INDEX "_toTaxonrank_unique" ON "_toTaxonrank" USING btree ((COALESCE(value, '\\N'::text))); |
|
| 4230 |
|
|
| 4231 |
|
|
| 4232 |
-- |
|
| 4202 | 4233 |
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4203 | 4234 |
-- |
| 4204 | 4235 |
|
| ... | ... | |
| 5319 | 5350 |
|
| 5320 | 5351 |
|
| 5321 | 5352 |
-- |
| 5353 |
-- Name: _toTaxonrank; Type: TRIGGER; Schema: public; Owner: - |
|
| 5354 |
-- |
|
| 5355 |
|
|
| 5356 |
CREATE TRIGGER "_toTaxonrank" BEFORE INSERT OR UPDATE ON "_toTaxonrank" FOR EACH ROW EXECUTE PROCEDURE "_toTaxonrank"(); |
|
| 5357 |
|
|
| 5358 |
|
|
| 5359 |
-- |
|
| 5322 | 5360 |
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - |
| 5323 | 5361 |
-- |
| 5324 | 5362 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added _toTaxonrank