#!/bin/sh

DATA=data/ECO13148.mdb
OUTPUT=ecoembes.sql

> $OUTPUT

mdb-schema -S $DATA postgres | \
    perl -np \
        -e 's{^DROP.*$}{}xms;' \
        -e 's{(\s+)(90\d)}{$1N_$2}xms;' \
        -e 's{Bool}{Int4}xms;' \
        > ecoembes.sql