Revision 10351
Added by Aaron Marcuse-Kubitza almost 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 186 | 186 |
|
| 187 | 187 |
|
| 188 | 188 |
-- |
| 189 |
-- Name: _filter_genus(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 189 |
-- Name: _filter_genus(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 190 | 190 |
-- |
| 191 | 191 |
|
| 192 | 192 |
|
| ... | ... | |
| 235 | 235 |
|
| 236 | 236 |
|
| 237 | 237 |
-- |
| 238 |
-- Name: _locationnarrative_is_cultivated(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 238 |
-- Name: _locationnarrative_is_cultivated(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 239 | 239 |
-- |
| 240 | 240 |
|
| 241 | 241 |
|
| ... | ... | |
| 270 | 270 |
|
| 271 | 271 |
|
| 272 | 272 |
-- |
| 273 |
-- Name: _or(boolean, int(1), int(1), int(1), int(1)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 273 |
-- Name: _or(int(1), int(1), int(1), int(1), int(1)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 274 | 274 |
-- |
| 275 | 275 |
|
| 276 | 276 |
|
| ... | ... | |
| 291 | 291 |
|
| 292 | 292 |
|
| 293 | 293 |
-- |
| 294 |
-- Name: _taxon_family_require_std(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 294 |
-- Name: _taxon_family_require_std(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 295 | 295 |
-- |
| 296 | 296 |
|
| 297 | 297 |
|
| 298 | 298 |
|
| 299 | 299 |
|
| 300 | 300 |
-- |
| 301 |
-- Name: _taxonlabel_set_matched_label_id(integer, int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 301 |
-- Name: _taxonlabel_set_matched_label_id(int(11), int(11), double precision); Type: FUNCTION; Schema: public; Owner: -
|
|
| 302 | 302 |
-- |
| 303 | 303 |
|
| 304 | 304 |
|
| 305 | 305 |
|
| 306 | 306 |
|
| 307 | 307 |
-- |
| 308 |
-- Name: _taxonlabel_set_parent_id(integer, int(11)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 308 |
-- Name: _taxonlabel_set_parent_id(int(11), int(11)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 309 | 309 |
-- |
| 310 | 310 |
|
| 311 | 311 |
|
| ... | ... | |
| 319 | 319 |
|
| 320 | 320 |
|
| 321 | 321 |
-- |
| 322 |
-- Name: delete_scrubbed_taxondeterminations(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 322 |
-- Name: delete_scrubbed_taxondeterminations(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 323 | 323 |
-- |
| 324 | 324 |
|
| 325 | 325 |
|
| ... | ... | |
| 423 | 423 |
|
| 424 | 424 |
|
| 425 | 425 |
-- |
| 426 |
-- Name: source_by_shortname(text); Type: FUNCTION; Schema: public; Owner: -
|
|
| 426 |
-- Name: source_by_shortname(varchar(255)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 427 | 427 |
-- |
| 428 | 428 |
|
| 429 | 429 |
|
| ... | ... | |
| 465 | 465 |
|
| 466 | 466 |
|
| 467 | 467 |
-- |
| 468 |
-- Name: taxondetermination_set_iscurrent(integer); Type: FUNCTION; Schema: public; Owner: -
|
|
| 468 |
-- Name: taxondetermination_set_iscurrent(int(11)); Type: FUNCTION; Schema: public; Owner: -
|
|
| 469 | 469 |
-- |
| 470 | 470 |
|
| 471 | 471 |
|
| ... | ... | |
| 623 | 623 |
|
| 624 | 624 |
|
| 625 | 625 |
-- |
| 626 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: -
|
|
| 626 |
-- Name: concat(varchar(255)); Type: AGGREGATE; Schema: public; Owner: -
|
|
| 627 | 627 |
-- |
| 628 | 628 |
|
| 629 | 629 |
|
| ... | ... | |
| 3413 | 3413 |
userdefinedname varchar(255) NOT NULL, |
| 3414 | 3414 |
userdefinedmetadata varchar(255), |
| 3415 | 3415 |
userdefinedcategory varchar(255), |
| 3416 |
userdefinedtype varchar(255) DEFAULT 'text' NOT NULL,
|
|
| 3416 |
userdefinedtype varchar(255) DEFAULT 'varchar(255)' NOT NULL,
|
|
| 3417 | 3417 |
tablename varchar(255) NOT NULL |
| 3418 | 3418 |
); |
| 3419 | 3419 |
|
Also available in: Unified diff
schemas/vegbien.my.sql: updated for new bin/repl text mode matching, which also affects non-regexps. this causes the replacement of a few more occurrences of PostgreSQL-only one-word typenames with their MySQL equivalents.