1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
#!/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/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/ENGINE=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
|
