saving some work on sqlite related stuff

1 files changed, 4 insertions, 0 deletions

diff --git a/db.sql b/db.sql
new file mode 100644
index 0000000..a7fe50e
--- /dev/null
+++ b/db.sql
@@ -0,0 +1,4 @@
+create table packages ( id int, package varchar(256), format varchar(32), diffgz varchar(1024), loc varchar(1024), type varchar(32), version varchar(256), updated int );
+create table releases ( id int, name varchar(32), md5sum varchar(32), updated int );
+create table components ( id int, name varchar(32), updated int );
+create table pkg_rel ( rel_id int, comp_id int, pkg_id int );