/usr/share/libpreludedb/classic/mysql2pgsql.sh is in libpreludedb0 1.0.0-1.1build2.
This file is owned by root:root, with mode 0o755.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | #!/bin/sh
sed \
-e 's/#.*//' \
-e 's/ INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT/ SERIAL PRIMARY KEY/' \
-e 's/BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT/BIGSERIAL PRIMARY KEY/' \
-e 's/DROP TABLE IF EXISTS/DROP TABLE/' \
-e 's/BLOB/BYTEA/' \
-e 's/ TINYINT UNSIGNED / INT2 /g' \
-e 's/ TINYINT / INT2 /g' \
-e 's/ SMALLINT UNSIGNED / INT4 /g' \
-e 's/ SMALLINT / INT2 /g' \
-e 's/ BIGINT UNSIGNED / INT8 /g' \
-e 's/ BIGINT / INT8 /g' \
-e 's/ INT\(EGER\)\{0,1\} UNSIGNED / INT8 /g' \
-e 's/ INT\(EGER\)\{0,1\} / INT4 /g' \
-e 's/DATETIME/TIMESTAMP/' \
-e 's/TYPE=InnoDB//' \
-e "s/\"\([^\"]*\)\"/'\1'/g" \
-e 's/\_parent_type ENUM(\(.*\))/_parent_type VARCHAR(1) CHECK \(_parent_type IN \(\1\)\)/' \
-e 's/\(.*\) ENUM(\(.*\))/\1 VARCHAR(32) CHECK \(\1 IN \(\2\)\)/' \
-e 's/\([[:lower:]_]\{1,\}\)([0-9]\{1,\})/\1/g' \
$1
|