Revision 921adf5b
Von Stephan Köhler vor fast 19 Jahren hinzugefügt
| sql/Pg-upgrade-2.1.1-2.1.2.sql | ||
|---|---|---|
| 253 | 253 |
alter table invoice add column cusordnumber text; |
| 254 | 254 |
-- |
| 255 | 255 |
|
| 256 |
-- |
|
| 257 |
-- add unqiue constraint to project |
|
| 258 |
ALTER TABLE project ADD constraint project_projectnumber_key UNIQUE(projectnumber); |
|
| 259 |
|
|
| 256 | 260 |
update defaults set version = '2.1.2'; |
| 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
Merge von 825,826 aus unstable: Bugfix 165
-Bugfix 165: Projektnummern muessen jetzt eindeutig sein.
-Nachtrag r825, Reihenfolge DB-Schemata