diff options
author | Wilrik de Loose <wilrik@wilrik.nl> | 2008-05-27 09:50:18 (GMT) |
---|---|---|
committer | Wilrik de Loose <wilrik@wilrik.nl> | 2008-05-27 09:50:18 (GMT) |
commit | e2b5d9764888e0f307ebcdf9c20835b197a0f63c (patch) | |
tree | 00bf9c6fbc7dae49d14ac91d44fe5e3f20d1454d /db_demo/sql/tables/cr_tbl_turn.sql | |
parent | 9b5236ed96a79e0fe979e2d7a7bc7173170af6cf (diff) | |
download | 2iv55-e2b5d9764888e0f307ebcdf9c20835b197a0f63c.zip 2iv55-e2b5d9764888e0f307ebcdf9c20835b197a0f63c.tar.gz 2iv55-e2b5d9764888e0f307ebcdf9c20835b197a0f63c.tar.bz2 |
db functies
Diffstat (limited to 'db_demo/sql/tables/cr_tbl_turn.sql')
-rw-r--r-- | db_demo/sql/tables/cr_tbl_turn.sql | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/db_demo/sql/tables/cr_tbl_turn.sql b/db_demo/sql/tables/cr_tbl_turn.sql index f0b7cc3..10218e2 100644 --- a/db_demo/sql/tables/cr_tbl_turn.sql +++ b/db_demo/sql/tables/cr_tbl_turn.sql @@ -1,9 +1,11 @@ CREATE SEQUENCE seq_turn START 1;
CREATE TABLE tbl_turn (
- key integer PRIMARY KEY, -- primary key
- testid integer NOT NULL REFERENCES tbl_test(key), -- test foreign key
- blockid integer NOT NULL REFERENCES const_block(key), -- block foreign key
- elapsedtime time NOT NULL, -- time in ms.
- holeposition integer NOT NULL -- position of the hole
+ key integer DEFAULT nextval('seq_turn') PRIMARY KEY, -- primary key
+ testid integer NOT NULL REFERENCES tbl_test(key), -- test foreign key
+ blockid integer NOT NULL REFERENCES const_block(key), -- block foreign key
+ elapsedtime time NOT NULL, -- time in ms.
+ holeposition integer NOT NULL, -- position of the hole
+ inserttime timestamp DEFAULT current_timestamp -- time of insertion
+ CONSTRAINT valid_hole CHECK (holeposition >= 0 AND holeposition < 16)
);
\ No newline at end of file |