Revision 2530
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 82 | 82 |
|
| 83 | 83 |
|
| 84 | 84 |
-- |
| 85 |
-- Name: _toGrowthform(); Type: FUNCTION; Schema: public; Owner: - |
|
| 86 |
-- |
|
| 87 |
|
|
| 88 |
|
|
| 89 |
|
|
| 90 |
|
|
| 91 |
-- |
|
| 92 |
-- Name: _toPlacerank(); Type: FUNCTION; Schema: public; Owner: - |
|
| 93 |
-- |
|
| 94 |
|
|
| 95 |
|
|
| 96 |
|
|
| 97 |
|
|
| 98 |
-- |
|
| 99 |
-- Name: _toTaxonrank(); Type: FUNCTION; Schema: public; Owner: - |
|
| 100 |
-- |
|
| 101 |
|
|
| 102 |
|
|
| 103 |
|
|
| 104 |
|
|
| 105 |
-- |
|
| 106 | 85 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 107 | 86 |
-- |
| 108 | 87 |
|
| ... | ... | |
| 156 | 135 |
|
| 157 | 136 |
|
| 158 | 137 |
-- |
| 159 |
-- Name: _toGrowthform; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 160 |
-- |
|
| 161 |
|
|
| 162 |
CREATE TABLE `_toGrowthform` ( |
|
| 163 |
result text, |
|
| 164 |
not_null int(1) DEFAULT true NOT NULL, |
|
| 165 |
value text |
|
| 166 |
); |
|
| 167 |
|
|
| 168 |
|
|
| 169 |
-- |
|
| 170 |
-- Name: _toPlacerank; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 171 |
-- |
|
| 172 |
|
|
| 173 |
CREATE TABLE `_toPlacerank` ( |
|
| 174 |
result text, |
|
| 175 |
not_null int(1) DEFAULT true NOT NULL, |
|
| 176 |
value text |
|
| 177 |
); |
|
| 178 |
|
|
| 179 |
|
|
| 180 |
-- |
|
| 181 |
-- Name: _toTaxonrank; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 182 |
-- |
|
| 183 |
|
|
| 184 |
CREATE TABLE `_toTaxonrank` ( |
|
| 185 |
result text, |
|
| 186 |
not_null int(1) DEFAULT true NOT NULL, |
|
| 187 |
value text |
|
| 188 |
); |
|
| 189 |
|
|
| 190 |
|
|
| 191 |
|
|
| 192 |
|
|
| 193 |
-- |
|
| 194 | 138 |
-- Name: address; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 195 | 139 |
-- |
| 196 | 140 |
|
| ... | ... | |
| 3716 | 3660 |
|
| 3717 | 3661 |
|
| 3718 | 3662 |
-- |
| 3719 |
-- Name: _toGrowthform_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3720 |
-- |
|
| 3721 |
|
|
| 3722 |
|
|
| 3723 |
|
|
| 3724 |
|
|
| 3725 |
-- |
|
| 3726 |
-- Name: _toPlacerank_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3727 |
-- |
|
| 3728 |
|
|
| 3729 |
|
|
| 3730 |
|
|
| 3731 |
|
|
| 3732 |
-- |
|
| 3733 |
-- Name: _toTaxonrank_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3734 |
-- |
|
| 3735 |
|
|
| 3736 |
|
|
| 3737 |
|
|
| 3738 |
|
|
| 3739 |
-- |
|
| 3740 | 3663 |
-- Name: address_organization_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3741 | 3664 |
-- |
| 3742 | 3665 |
|
| ... | ... | |
| 4850 | 4773 |
|
| 4851 | 4774 |
|
| 4852 | 4775 |
-- |
| 4853 |
-- Name: _toGrowthform; Type: TRIGGER; Schema: public; Owner: - |
|
| 4854 |
-- |
|
| 4855 |
|
|
| 4856 |
|
|
| 4857 |
|
|
| 4858 |
|
|
| 4859 |
-- |
|
| 4860 |
-- Name: _toPlacerank; Type: TRIGGER; Schema: public; Owner: - |
|
| 4861 |
-- |
|
| 4862 |
|
|
| 4863 |
|
|
| 4864 |
|
|
| 4865 |
|
|
| 4866 |
-- |
|
| 4867 |
-- Name: _toTaxonrank; Type: TRIGGER; Schema: public; Owner: - |
|
| 4868 |
-- |
|
| 4869 |
|
|
| 4870 |
|
|
| 4871 |
|
|
| 4872 |
|
|
| 4873 |
-- |
|
| 4874 | 4776 |
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - |
| 4875 | 4777 |
-- |
| 4876 | 4778 |
|
Also available in: Unified diff
schemas/vegbien.sql, functions.sql: Removed _to* relational functions because type casting for those types is now automatic