Revision 5233
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2034 | 2034 |
CREATE TABLE reference ( |
| 2035 | 2035 |
reference_id int(11) NOT NULL, |
| 2036 | 2036 |
shortname text, |
| 2037 |
fulltext__ text,
|
|
| 2037 |
`fulltext` text,
|
|
| 2038 | 2038 |
referencetype text, |
| 2039 | 2039 |
title text, |
| 2040 | 2040 |
titlesuperior text, |
| lib/PostgreSQL-MySQL.csv | ||
|---|---|---|
| 24 | 24 |
"boolean","int(1)", |
| 25 | 25 |
"bytea","blob", |
| 26 | 26 |
" with time zone\b",, |
| 27 |
"fulltext","\g<0>__",
|
|
| 27 |
"fulltext","`\g<0>`",
|
|
| 28 | 28 |
"\btimestamp\b(?: with time zone\b)?(?! NOT NULL\b)","\g<0> NULL", |
| 29 | 29 |
"^( *[a-z]\w* )(?!(?:double|int|text|timestamp)\b)\w+(?=\b[^;]*^\);)","\1text","custom types" |
Also available in: Unified diff
lib/PostgreSQL-MySQL.csv: Changed translation of fulltext to quote the identifier instead of appending characters to make it not a reserved word