Revision 2d72b516
Von Sven Schöling vor fast 19 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 320 | 320 |
|
| 321 | 321 |
update defaults set version = '2.1.2'; |
| 322 | 322 |
|
| 323 |
|
|
| 323 |
-- |
|
| 324 |
-- add unqiue constraint to project |
|
| 325 |
ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); |
|
| sql/lx-office.sql | ||
|---|---|---|
| 453 | 453 |
|
| 454 | 454 |
CREATE TABLE "project" ( |
| 455 | 455 |
"id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
|
| 456 |
"projectnumber" text, |
|
| 456 |
"projectnumber" text UNIQUE,
|
|
| 457 | 457 |
"description" text, |
| 458 | 458 |
"itime" timestamp DEFAULT now(), |
| 459 | 459 |
"mtime" timestamp |
Auch abrufbar als: Unified diff
Bugfix 165: Projektnummern muessen jetzt eindeutig sein.