summaryrefslogtreecommitdiffstats
path: root/db_demo/sql/init.sql
blob: 3da1e332940149d2044b593e3797b21e6b6d9d5f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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