summaryrefslogtreecommitdiffstats
path: root/db_demo/sql/tables/cr_const_gametype.sql
diff options
context:
space:
mode:
authorWilrik de Loose <wilrik@wilrik.nl>2008-05-08 19:07:50 (GMT)
committerWilrik de Loose <wilrik@wilrik.nl>2008-05-08 19:07:50 (GMT)
commitdc6caf529031dba2dd595b64ee008ffda39737b6 (patch)
tree9026623a73886e313097561b4bfc09f9cc77b025 /db_demo/sql/tables/cr_const_gametype.sql
parent4c0c2685a6d564c9a6170b8a56c873104046a832 (diff)
download2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.zip
2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.tar.gz
2iv55-dc6caf529031dba2dd595b64ee008ffda39737b6.tar.bz2
Tabel structuur aangemaakt
Diffstat (limited to 'db_demo/sql/tables/cr_const_gametype.sql')
-rw-r--r--db_demo/sql/tables/cr_const_gametype.sql7
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