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