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 );