Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 1008:17e9d1b2d471 schema-update
Removed column name, added column kommentar in messprogramm
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 08:55:36 +0200 |
| parents | 6a313cb77fda |
| children | f0ac901a4387 |
comparison
equal
deleted
inserted
replaced
| 1007:6a313cb77fda | 1008:17e9d1b2d471 |
|---|---|
| 112 -- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace: | 112 -- Name: messprogramm; Type: TABLE; Schema: land; Owner: -; Tablespace: |
| 113 -- | 113 -- |
| 114 | 114 |
| 115 CREATE TABLE messprogramm ( | 115 CREATE TABLE messprogramm ( |
| 116 id serial PRIMARY KEY, | 116 id serial PRIMARY KEY, |
| 117 name character varying(256), | 117 kommentar character varying(1000), |
| 118 test boolean DEFAULT false NOT NULL, | 118 test boolean DEFAULT false NOT NULL, |
| 119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 119 mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, | 120 labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle, |
| 121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, | 121 datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis, |
| 122 ba_id character varying(1), | 122 ba_id character varying(1), |