Revision 706
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 90 | 90 |
plantobservation_id int(11), |
| 91 | 91 |
stratum_id int(11), |
| 92 | 92 |
sizeclass_id int(11), |
| 93 |
coverindex_id int(11), |
|
| 94 |
CONSTRAINT aggregateoccurrence_plantobs_count_1 CHECK (((plantobservation_id IS NULL) OR (NOT (count IS DISTINCT FROM 1)))) |
|
| 93 |
coverindex_id int(11) |
|
| 95 | 94 |
); |
| 96 | 95 |
|
| 97 | 96 |
|
| lib/PostgreSQL-MySQL.csv | ||
|---|---|---|
| 6 | 6 |
"^COMMENT\b[^;]*;",, |
| 7 | 7 |
"^ALTER TABLE\b[^;]*\bSET DEFAULT nextval\([^;]*\)[^;]*;",, |
| 8 | 8 |
"^CREATE\b[^;]*\bINDEX\b[^;]*\([^;]*\([^;]*;",, |
| 9 |
",\n *CONSTRAINT\b.*\bCHECK\b.*?(?=,?$)",, |
|
| 9 | 10 |
"\bDEFAULT \w*\(.*\)",,".* rather than .*? to allow nested ()" |
| 10 | 11 |
"^(CREATE\b[^;]*\bINDEX\b[^;]*\b)USING \w+","\1", |
| 11 | 12 |
"(?<=\bALTER TABLE )ONLY ",, |
Also available in: Unified diff
PostgreSQL-MySQL.csv: Remove CHECK constraints