diff options
author | OpenSLX | 2010-01-20 16:47:35 +0100 |
---|---|---|
committer | OpenSLX | 2010-01-20 16:47:35 +0100 |
commit | 04173263974af0e7a354e066b9d7ec9c13c4289d (patch) | |
tree | 82dc2e2662d24e0aaba8a16c4c90b3819c06a662 /application/configs/db.sql | |
download | pbs-04173263974af0e7a354e066b9d7ec9c13c4289d.tar.gz pbs-04173263974af0e7a354e066b9d7ec9c13c4289d.tar.xz pbs-04173263974af0e7a354e066b9d7ec9c13c4289d.zip |
initial import
Diffstat (limited to 'application/configs/db.sql')
-rw-r--r-- | application/configs/db.sql | 83 |
1 files changed, 83 insertions, 0 deletions
diff --git a/application/configs/db.sql b/application/configs/db.sql new file mode 100644 index 0000000..48efbe3 --- /dev/null +++ b/application/configs/db.sql @@ -0,0 +1,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 +); + |