Mercurial > dive4elements > river
comparison backend/doc/schema/postgresql.sql @ 6817:63a24b4fbebf double-precision
fixed syntax errors in Postgres-schema.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 12 Aug 2013 18:12:14 +0200 |
| parents | 3b93f439e954 |
| children | 5ce6a3d7d632 |
comparison
equal
deleted
inserted
replaced
| 6816:a3c4f094707e | 6817:63a24b4fbebf |
|---|---|
| 323 CREATE TABLE cross_section_points ( | 323 CREATE TABLE cross_section_points ( |
| 324 id int PRIMARY KEY NOT NULL, | 324 id int PRIMARY KEY NOT NULL, |
| 325 cross_section_line_id int NOT NULL REFERENCES cross_section_lines(id) ON DELETE CASCADE, | 325 cross_section_line_id int NOT NULL REFERENCES cross_section_lines(id) ON DELETE CASCADE, |
| 326 col_pos int NOT NULL, | 326 col_pos int NOT NULL, |
| 327 x NUMERIC NOT NULL, | 327 x NUMERIC NOT NULL, |
| 328 y NUMERIC NOT NULL, | 328 y NUMERIC NOT NULL |
| 329 ); | 329 ); |
| 330 | 330 |
| 331 -- Indices for faster access of the points | 331 -- Indices for faster access of the points |
| 332 CREATE INDEX cross_section_lines_km_idx | 332 CREATE INDEX cross_section_lines_km_idx |
| 333 ON cross_section_lines(km); | 333 ON cross_section_lines(km); |