3 files changed, 56 insertions, 0 deletions
diff --git a/db_demo/sql/views/cr_vw_person.sql b/db_demo/sql/views/cr_vw_person.sql
new file mode 100644
index 0000000..0f8a973
--- /dev/null
+++ b/db_demo/sql/views/cr_vw_person.sql
@@ -0,0 +1,14 @@
+CREATE OR REPLACE VIEW vw_person AS
+SELECT
+  p.key AS personid,
+  p.c_experience,
+  p.w_experience,
+
+  a.key AS agegroupid,
+  a.description AS agegroup
+FROM
+  tbl_person p,
+  const_agegroup a
+WHERE
+  p.agegroupid = a.key
+;
+\ No newline at end of file
diff --git a/db_demo/sql/views/cr_vw_test.sql b/db_demo/sql/views/cr_vw_test.sql
new file mode 100644
index 0000000..3996188
--- /dev/null
+++ b/db_demo/sql/views/cr_vw_test.sql
@@ -0,0 +1,24 @@
+CREATE OR REPLACE VIEW vw_test AS
+SELECT
+  p.*,
+
+  t.key AS testid,
+
+  g.key AS gametypeid,
+  g.headtracking,
+  g.stereo,
+  g.shadow,
+
+  b.key AS boxsizeid,
+  b.description AS boxsize
+
+FROM
+  tbl_test t,
+  vw_person p,
+  const_gametype g,
+  const_boxsize b
+WHERE
+  t.personid   = p.personid AND
+  t.gametypeid = g.key AND
+  g.boxsizeid  = b.key
+;
+\ No newline at end of file
diff --git a/db_demo/sql/views/cr_vw_turn.sql b/db_demo/sql/views/cr_vw_turn.sql
new file mode 100644
index 0000000..93485bf
--- /dev/null
+++ b/db_demo/sql/views/cr_vw_turn.sql
@@ -0,0 +1,18 @@
+CREATE OR REPLACE VIEW vw_turn AS
+SELECT
+  ts.*,
+
+  t.key AS turnid,
+  t.elapsedtime,
+  t.holeposition,
+
+  b.key AS blockid,
+  b.description AS block  
+FROM
+  tbl_turn t,
+  vw_test ts,
+  const_block b
+WHERE
+  t.testid  = ts.testid AND
+  t.blockid = b.key
+;
+\ No newline at end of file