summaryrefslogtreecommitdiff
path: root/dbconf/pgsql
diff options
context:
space:
mode:
Diffstat (limited to 'dbconf/pgsql')
-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