Mercurial > dive4elements > river
view contrib/make_flys_release/h2/commons-dbcp-1.2.2.jar @ 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 | 9d404069f361 |
children |