Mercurial > dive4elements > river
comparison flys-backend/doc/schema/postgresql-spatial.sql @ 5010:ee52faa6b7ac dami
Corrected typo in field name
| author | Tom Gottfried <tom.gottfried@intevation.de> |
|---|---|
| date | Tue, 19 Feb 2013 09:44:38 +0100 |
| parents | 929ec3ed7dc2 |
| children | eecd1ebba128 |
comparison
equal
deleted
inserted
replaced
| 5007:4e5d209253dd | 5010:ee52faa6b7ac |
|---|---|
| 171 kind_id int REFERENCES hws_kinds(id) DEFAULT 2, | 171 kind_id int REFERENCES hws_kinds(id) DEFAULT 2, |
| 172 fed_state_id int REFERENCES fed_states(id), | 172 fed_state_id int REFERENCES fed_states(id), |
| 173 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 173 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 174 name VARCHAR(256), | 174 name VARCHAR(256), |
| 175 path VARCHAR(256), | 175 path VARCHAR(256), |
| 176 offical INT DEFAULT 0, | 176 official INT DEFAULT 0, |
| 177 agency VARCHAR(256), | 177 agency VARCHAR(256), |
| 178 range VARCHAR(256), | 178 range VARCHAR(256), |
| 179 shore_side INT DEFAULT 0, | 179 shore_side INT DEFAULT 0, |
| 180 source VARCHAR(256), | 180 source VARCHAR(256), |
| 181 status_date TIMESTAMP, | 181 status_date TIMESTAMP, |
| 196 kind_id int REFERENCES hws_kinds(id) DEFAULT 2, | 196 kind_id int REFERENCES hws_kinds(id) DEFAULT 2, |
| 197 fed_state_id int REFERENCES fed_states(id), | 197 fed_state_id int REFERENCES fed_states(id), |
| 198 river_id int REFERENCES rivers(id) ON DELETE CASCADE, | 198 river_id int REFERENCES rivers(id) ON DELETE CASCADE, |
| 199 name VARCHAR, | 199 name VARCHAR, |
| 200 path VARCHAR, | 200 path VARCHAR, |
| 201 offical INT DEFAULT 0, | 201 official INT DEFAULT 0, |
| 202 agency VARCHAR, | 202 agency VARCHAR, |
| 203 range VARCHAR, | 203 range VARCHAR, |
| 204 shore_side INT DEFAULT 0, | 204 shore_side INT DEFAULT 0, |
| 205 source VARCHAR, | 205 source VARCHAR, |
| 206 status_date VARCHAR, | 206 status_date VARCHAR, |