From d071b989f94d82709ba6a088056e6d4629c1b7c7 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?=EA=A6=8C=EA=A6=AB=EA=A6=B6=EA=A6=8F=EA=A7=80=EA=A6=A6?= =?UTF-8?q?=EA=A6=BF=EA=A6=A7=EA=A6=AE=EA=A6=91=EA=A6=A9=EA=A6=AD=EA=A7=80?= Date: Sun, 25 Jul 2021 21:00:57 +0800 Subject: SiCepat DB table prototypes --- dbconf/pgsql/sicepat_destination.pgsql | 7 +++++++ dbconf/pgsql/sicepat_origin.pgsql | 5 +++++ 2 files changed, 12 insertions(+) create mode 100644 dbconf/pgsql/sicepat_destination.pgsql create mode 100644 dbconf/pgsql/sicepat_origin.pgsql (limited to 'dbconf') 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 -- cgit v1.2.3