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