t* my version of playonbsd.com data URI git clone git://git.codevoid.de/playonbsd-sdk.git DIR Log DIR Files DIR Refs DIR README --- tschema.sql (993B) --- 1 -- game list to be shown on the index 2 -- each game can have one engine (game 1:1 engine) 3 -- each game can have N storesources (game 1:N store) 4 -- but each store entry is specific to one game (store 1:1 game) 5 6 -- list of games 7 create table if not exists game ( 8 id integer primary key autoincrement, 9 name string not null, 10 imgsrc string, 11 engine_id integer REFERENCES engine(id), 12 comment string, 13 createdat integer not null, 14 changedat integer not null 15 ); 16 17 -- list of engines 18 create table if not exists engine ( 19 id integer primary key autoincrement, 20 name string not null, 21 href string, 22 port string, 23 descr string, 24 createdat integer not null, 25 changedat integer not null 26 ); 27 28 -- store entries 29 create table if not exists storeinfo ( 30 id integer primary key autoincrement, 31 game_id integer REFERENCES game(id), 32 name string not null, 33 href string, 34 info string, 35 createdat integer not null, 36 changedat integer not null 37 );