Mercurial > dive4elements > river
annotate artifacts/doc/mapserver/dbconnection.include @ 6721:df402b3e0281
minfo-schema-change/issue1393: add kind column to sediment_yield table.
To change existing databases, issue following sql command:
ALTER TABLE sediment_yield ADD kind INT DEFAULT 0;
For oracles it might look like
ALTER TABLE sediment_yield ADD kind NUMBER(38,0) DEFAULT 0;
.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Wed, 31 Jul 2013 11:10:11 +0200 |
| parents | 5aa05a7a34b7 |
| children |
| rev | line source |
|---|---|
|
1182
8ad0331e444f
Added inital mapserver configuration files.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
1 CONNECTIONTYPE postgis |
|
8ad0331e444f
Added inital mapserver configuration files.
Bjoern Schilberg <bjoern@intevation.de>
parents:
diff
changeset
|
2 CONNECTION "dbname='flys3' host=127.0.0.1 port=5432 user='flys' password='flys' sslmode=disable" |