diff options
Diffstat (limited to 'db_demo/sql/tables/cr_const_gametype.sql')
| -rw-r--r-- | db_demo/sql/tables/cr_const_gametype.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db_demo/sql/tables/cr_const_gametype.sql b/db_demo/sql/tables/cr_const_gametype.sql new file mode 100644 index 0000000..d9e9a99 --- /dev/null +++ b/db_demo/sql/tables/cr_const_gametype.sql @@ -0,0 +1,7 @@ +CREATE TABLE const_gametype (
+ key integer PRIMARY KEY, -- primary key
+ boxsizeid integer NOT NULL REFERENCES const_boxsize(key), -- boxsize foreign key
+ headtracking boolean NOT NULL, -- headtracking on / off
+ stereo boolean NOT NULL, -- stereo vision on / off
+ shadow boolean NOT NULL -- shadow on / off
+);
\ No newline at end of file |