summaryrefslogtreecommitdiffstats
path: root/db_demo/sql/data
diff options
context:
space:
mode:
Diffstat (limited to 'db_demo/sql/data')
-rw-r--r--db_demo/sql/data/cr_data_agegroup.sql3
-rw-r--r--db_demo/sql/data/cr_data_block.sql4
-rw-r--r--db_demo/sql/data/cr_data_boxsize.sql3
-rw-r--r--db_demo/sql/data/cr_data_gametype.sql39
4 files changed, 49 insertions, 0 deletions
diff --git a/db_demo/sql/data/cr_data_agegroup.sql b/db_demo/sql/data/cr_data_agegroup.sql
new file mode 100644
index 0000000..deee698
--- /dev/null
+++ b/db_demo/sql/data/cr_data_agegroup.sql
@@ -0,0 +1,3 @@
+INSERT INTO const_agegroup (key, description) VALUES (100, 'Age < 20');
+INSERT INTO const_agegroup (key, description) VALUES (101, '20 < age < 30');
+INSERT INTO const_agegroup (key, description) VALUES (102, '30 < age');
diff --git a/db_demo/sql/data/cr_data_block.sql b/db_demo/sql/data/cr_data_block.sql
new file mode 100644
index 0000000..ea2c86b
--- /dev/null
+++ b/db_demo/sql/data/cr_data_block.sql
@@ -0,0 +1,4 @@
+INSERT INTO const_block (key, description) VALUES (100, 'Square');
+INSERT INTO const_block (key, description) VALUES (101, 'Circle');
+INSERT INTO const_block (key, description) VALUES (102, 'Triangle');
+INSERT INTO const_block (key, description) VALUES (103, 'Cross');
diff --git a/db_demo/sql/data/cr_data_boxsize.sql b/db_demo/sql/data/cr_data_boxsize.sql
new file mode 100644
index 0000000..01bb3e4
--- /dev/null
+++ b/db_demo/sql/data/cr_data_boxsize.sql
@@ -0,0 +1,3 @@
+INSERT INTO const_boxsize (key, description) VALUES (100, 'Small');
+INSERT INTO const_boxsize (key, description) VALUES (101, 'Medium');
+INSERT INTO const_boxsize (key, description) VALUES (102, 'Large'); \ No newline at end of file
diff --git a/db_demo/sql/data/cr_data_gametype.sql b/db_demo/sql/data/cr_data_gametype.sql
new file mode 100644
index 0000000..61e95ff
--- /dev/null
+++ b/db_demo/sql/data/cr_data_gametype.sql
@@ -0,0 +1,39 @@
+-- no headtracking / no stereo / no shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (100, 100, 'f', 'f', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (101, 101, 'f', 'f', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (102, 102, 'f', 'f', 'f');
+
+-- with headtracking / no stereo / no shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (103, 100, 't', 'f', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (104, 101, 't', 'f', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (105, 102, 't', 'f', 'f');
+
+-- no headtracking / with stereo / no shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (106, 100, 'f', 't', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (107, 101, 'f', 't', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (108, 102, 'f', 't', 'f');
+
+-- with headtracking / with stereo / no shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (109, 100, 't', 't', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (110, 101, 't', 't', 'f');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (111, 102, 't', 't', 'f');
+
+-- no headtracking / no stereo / with shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (112, 100, 'f', 'f', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (113, 101, 'f', 'f', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (114, 102, 'f', 'f', 't');
+
+-- with headtracking / no stereo / with shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (115, 100, 't', 'f', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (116, 101, 't', 'f', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (117, 102, 't', 'f', 't');
+
+-- no headtracking / with stereo / with shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (118, 100, 'f', 't', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (119, 101, 'f', 't', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (120, 102, 'f', 't', 't');
+
+-- with headtracking / with stereo / with shadow
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (121, 100, 't', 't', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (122, 101, 't', 't', 't');
+INSERT INTO const_gametype (key, boxsizeid, headtracking, stereo, shadow) VALUES (123, 102, 't', 't', 't');