Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1032:1c6c83037b8c schema-update
Updated sql query strings to match the new schema.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 31 Aug 2016 15:47:52 +0200 |
| parents | 330dec7ee0bb |
| children | 9615be7b1626 |
comparison
equal
deleted
inserted
replaced
| 1031:2977a7ac414f | 1032:1c6c83037b8c |
|---|---|
| 291 | 291 |
| 292 CREATE TABLE query ( | 292 CREATE TABLE query ( |
| 293 id serial PRIMARY KEY, | 293 id serial PRIMARY KEY, |
| 294 name character varying(80) NOT NULL, | 294 name character varying(80) NOT NULL, |
| 295 type integer NOT NULL REFERENCES query_type, | 295 type integer NOT NULL REFERENCES query_type, |
| 296 sql character varying(1500) NOT NULL, | 296 sql character varying(2500) NOT NULL, |
| 297 description character varying(100) | 297 description character varying(100) |
| 298 ); | 298 ); |
| 299 | 299 |
| 300 | 300 |
| 301 CREATE TABLE favorite ( | 301 CREATE TABLE favorite ( |