summaryrefslogtreecommitdiffstats
path: root/db_demo/sql/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db_demo/sql/init.sql')
-rw-r--r--db_demo/sql/init.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/db_demo/sql/init.sql b/db_demo/sql/init.sql
new file mode 100644
index 0000000..3da1e33
--- /dev/null
+++ b/db_demo/sql/init.sql
@@ -0,0 +1,21 @@
+-- create constant tables (4)
+\i tables/cr_const_block.sql
+\i tables/cr_const_boxsize.sql
+\i tables/cr_const_gametype.sql
+\i tables/cr_const_agegroup.sql
+
+-- create user tables (3)
+\i tables/cr_tbl_person.sql
+\i tables/cr_tbl_test.sql
+\i tables/cr_tbl_turn.sql
+
+-- create constant data (4)
+\i data/cr_data_block.sql
+\i data/cr_data_boxsize.sql
+\i data/cr_data_gametype.sql
+\i data/cr_data_agegroup.sql
+
+-- create views (3)
+\i views/cr_vw_person.sql
+\i views/cr_vw_test.sql
+\i views/cr_vw_turn.sql \ No newline at end of file