summaryrefslogtreecommitdiff
path: root/dbconf
diff options
context:
space:
mode:
authorꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id>2021-07-07 21:49:14 +0800
committerꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id>2021-07-07 21:49:14 +0800
commit7f6204d3bf48f69170098113af8694b63f1687b3 (patch)
treed28e9a137e34688df96f84fa0f5085c429a4800f /dbconf
parent460e8f76d62d072775758ea1cc958bb02d94dc92 (diff)
Shipping codes prototype
Diffstat (limited to 'dbconf')
-rw-r--r--dbconf/pgsql/shipping.pgsql7
1 files changed, 7 insertions, 0 deletions
diff --git a/dbconf/pgsql/shipping.pgsql b/dbconf/pgsql/shipping.pgsql
new file mode 100644
index 0000000..f0b1870
--- /dev/null
+++ b/dbconf/pgsql/shipping.pgsql
@@ -0,0 +1,7 @@
+Database shipping shipping.txt __SQLDSN__
+Database shipping DEFAULT_TYPE VARCHAR(64)
+Database shipping COLUMN_DEF "code=VARCHAR(8) NOT NULL PRIMARY KEY"
+Database shipping COLUMN_DEF "district=VARCHAR(64) NOT NULL"
+Database shipping COLUMN_DEF "city=VARCHAR(32) NOT NULL"
+Database shipping COLUMN_DEF "province=VARCHAR(32) NOT NULL"
+Database shipping INDEX district