Revision 10351
Added by Aaron Marcuse-Kubitza almost 11 years ago
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.