Revision 6784
Added by Aaron Marcuse-Kubitza over 11 years ago
| bin/my2pg | ||
|---|---|---|
| 11 | 11 |
echo 'SET standard_conforming_strings = off;' |
| 12 | 12 |
echo 'SET escape_string_warning = off;' |
| 13 | 13 |
sed \ |
| 14 |
-e 's/^ KEY "([^"]*)" \([^)]*\)/ "\1_index" boolean/' \
|
|
| 14 |
-e 's/^ ((UNIQUE|FULLTEXT) )?KEY "([^"]*)" \([^)]*\)/ "\3_index" boolean/' \
|
|
| 15 | 15 |
-e "s/\/\*.* (SET NAMES )([0-9A-Za-z_]+) \*\/;/\1'\2';/" \ |
| 16 | 16 |
-e 's/ CHARACTER SET [0-9A-Za-z_]+//g' \ |
| 17 | 17 |
-e "s/ COMMENT '[^']*'//g" \ |
Also available in: Unified diff
my2pg: Also remove UNIQUE and FULLTEXT inline indexes