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/pgsql/sicepat_destination.pgsql | |
| parent | 6d12f3107f5a74700749b4b958b7880a659136e1 (diff) | |
SiCepat DB table prototypes
Diffstat (limited to 'dbconf/pgsql/sicepat_destination.pgsql')
| -rw-r--r-- | dbconf/pgsql/sicepat_destination.pgsql | 7 |
1 files changed, 7 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 |