diff options
| author | ꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id> | 2021-07-25 21:00:57 +0800 |
|---|---|---|
| committer | ꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id> | 2021-07-25 21:00:57 +0800 |
| commit | d071b989f94d82709ba6a088056e6d4629c1b7c7 (patch) | |
| tree | 275257479697c8d9dcfa6aad083d16e774c9809f /dbconf | |
| parent | 6d12f3107f5a74700749b4b958b7880a659136e1 (diff) | |
SiCepat DB table prototypes
Diffstat (limited to 'dbconf')
| -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 |