1 files changed, 9 insertions, 0 deletions
diff --git a/db_demo/sql/tables/cr_tbl_turn.sql b/db_demo/sql/tables/cr_tbl_turn.sql
new file mode 100644
index 0000000..f0b7cc3
--- /dev/null
+++ b/db_demo/sql/tables/cr_tbl_turn.sql
@@ -0,0 +1,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
+);
+\ No newline at end of file