blob: f0b7cc32555e302010499c3d56c7f87c89f56d61 (
plain)
1
2
3
4
5
6
7
8
9
|
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
);
|