1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
CREATE TABLE pbs (
id INTEGER PRIMARY KEY,
attribute TEXT,
val TEXT
);
INSERT INTO pbs (attribute, val) VALUES ("version", "0.1");
INSERT INTO pbs (attribute, val) VALUES ("location", "http://pbs.lan/");
INSERT INTO pbs (attribute, val) VALUES ("uclibrootfs-version", "1");
CREATE TABLE systems (
id INTEGER PRIMARY KEY,
external_id TEXT,
append TEXT,
description TEXT,
initrd TEXT,
kernel TEXT,
name TEXT,
source TEXT
);
CREATE TABLE sources (
ip TEXT PRIMARY KEY,
version TEXT,
lastdemux TEXT,
description TEXT
);
CREATE TABLE kernels (
id INTEGER PRIMARY KEY,
kernel TEXT,
kernel_md5 TEXT,
initramfs_md5 TEXT
);
CREATE TABLE bootmedia (
id INTEGER PRIMARY KEY,
kernel TEXT,
name TEXT,
identifier TEXT,
description TEXT,
created TEXT,
theme TEXT,
mediatype TEXT
);
CREATE TABLE menus (
id INTEGER PRIMARY KEY,
name TEXT,
description TEXT,
theme TEXT
);
CREATE TABLE menu_entries (
id INTEGER PRIMARY KEY,
menu_id INTEGER,
entry_order INTEGER,
system_id INTEGER,
overwrite_caption INTEGER,
overwrite_append INTEGER,
alternative_caption TEXT,
alternative_append TEXT
);
CREATE TABLE menu_assignments (
id INTEGER PRIMARY KEY,
name TEXT,
menu_id INTEGER
);
CREATE TABLE menu_assignment_iprules (
id INTEGER PRIMARY KEY,
menu_assignment_rule INTEGER,
ip TEXT,
netmask TEXT
);
CREATE TABLE menu_assignment_bmrules (
id INTEGER PRIMARY KEY,
menu_assignment_rule INTEGER,
bootmedia_id INTEGER
);
|