diff options
| -rw-r--r-- | dbconf/pgsql/sicepat_destination.pgsql | 7 | ||||
| -rw-r--r-- | dbconf/pgsql/sicepat_origin.pgsql | 5 |
2 files changed, 12 insertions, 0 deletions
diff --git a/dbconf/pgsql/sicepat_destination.pgsql b/dbconf/pgsql/sicepat_destination.pgsql new file mode 100644 index 0000000..c4856c3 --- /dev/null +++ b/dbconf/pgsql/sicepat_destination.pgsql @@ -0,0 +1,7 @@ +Database sicepat_destination sicepat_destination.txt __SQLDSN__ +Database sicepat_destination DEFAULT_TYPE VARCHAR(64) +Database sicepat_destination COLUMN_DEF "code=CHAR(8) NOT NULL PRIMARY KEY" +Database sicepat_destination COLUMN_DEF "district=VARCHAR(64) NOT NULL" +Database sicepat_destination COLUMN_DEF "city=VARCHAR(64) NOT NULL" +Database sicepat_destination COLUMN_DEF "province=VARCHAR(32) NOT NULL" +Database sicepat_destination INDEX district diff --git a/dbconf/pgsql/sicepat_origin.pgsql b/dbconf/pgsql/sicepat_origin.pgsql new file mode 100644 index 0000000..b5c1ff0 --- /dev/null +++ b/dbconf/pgsql/sicepat_origin.pgsql @@ -0,0 +1,5 @@ +Database sicepat_origin sicepat_origin.txt __SQLDSN__ +Database sicepat_origin DEFAULT_TYPE VARCHAR(64) +Database sicepat_origin COLUMN_DEF "code=CHAR(3) NOT NULL PRIMARY KEY" +Database sicepat_origin COLUMN_DEF "city=VARCHAR(64) NOT NULL" +Database sicepat_origin INDEX city |