diff options
Diffstat (limited to 'db_demo/sql/data')
-rw-r--r-- | db_demo/sql/data/cr_data_agegroup.sql | 3 | ||||
-rw-r--r-- | db_demo/sql/data/cr_data_block.sql | 4 | ||||
-rw-r--r-- | db_demo/sql/data/cr_data_boxsize.sql | 3 | ||||
-rw-r--r-- | db_demo/sql/data/cr_data_gametype.sql | 39 |
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');
|