diff options
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 |