Revision 7540
Added by Aaron Marcuse-Kubitza about 12 years ago
| my2pg | ||
|---|---|---|
| 11 | 11 |
echo 'SET standard_conforming_strings = off;' |
| 12 | 12 |
echo 'SET escape_string_warning = off;' |
| 13 | 13 |
sed \ |
| 14 |
-e 's/^ ((CONSTRAINT "[^"]*" )?((UNIQUE|FULLTEXT|FOREIGN) )?KEY .*[^,])(,?)$/ \/*\1*\/CHECK (true)\5/' \ |
|
| 14 |
-e 's/ UNIQUE KEY ("[^"]*")/ CONSTRAINT \1 UNIQUE/g' \
|
|
| 15 |
-e 's/ UNIQUE KEY/ UNIQUE/g' \ |
|
| 16 |
-e 's/^ ((CONSTRAINT "[^"]*" )?((FULLTEXT|FOREIGN) )?KEY .*[^,])(,?)$/ \/*\1*\/CHECK (true)\5/' \ |
|
| 15 | 17 |
-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \ |
| 16 | 18 |
-e 's/ (CHARACTER SET|COLLATE) [0-9A-Za-z_]+//g' \ |
| 17 | 19 |
-e "s/ COMMENT '[^']*'//g" \ |
Also available in: Unified diff
my2pg: Translate UNIQUE KEYs instead of removing them