6 files changed, 6 insertions, 5 deletions
diff --git a/Makefile b/feed/Makefile
index 3830946..3830946 100644
--- a/Makefile
+++ b/feed/Makefile
diff --git a/lex-c.l b/feed/lex-c.l
index 243c9ab..243c9ab 100644
--- a/lex-c.l
+++ b/feed/lex-c.l
diff --git a/sse-feed b/feed/sse-feed
index 29718ca..29718ca 100755
--- a/sse-feed
+++ b/feed/sse-feed
diff --git a/sse-fm b/feed/sse-fm
index f9fae44..f9fae44 100755
--- a/sse-fm
+++ b/feed/sse-fm
diff --git a/sse-tar b/feed/sse-tar
index 1f27ab0..1f27ab0 100755
--- a/sse-tar
+++ b/feed/sse-tar
diff --git a/sse.sql b/sse.sql
index 2e48816..2e4e9cc 100644
--- a/sse.sql
+++ b/sse.sql
@@ -6,7 +6,7 @@ CREATE TABLE word (
     text VARCHAR(40) NOT NULL,
     type ENUM ('word', 'subword') DEFAULT 'word' NOT NULL,
     file_id INTEGER UNSIGNED NOT NULL,
-    cnt INTEGER UNSIGNED NOT NULL,
+    cnt INTEGER UNSIGNED DEFAULT 0 NOT NULL,
     PRIMARY KEY (text, type, file_id)
 ) ENGINE=InnoDB;
 
@@ -20,10 +20,11 @@ CREATE TABLE file (
 
 CREATE TABLE package (
     id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-    filename VARBINARY(255) NOT NULL,
-    url VARBINARY(255) NOT NULL,
+    path VARBINARY(255) NOT NULL,
+    name VARBINARY(255) NOT NULL DEFAULT 'noname',
+    url VARBINARY(255) NOT NULL DEFAULT '',
     timestamp TIMESTAMP NOT NULL,
-    md CHAR(32) NOT NULL,
+    md CHAR(32) NOT NULL DEFAULT '',
     PRIMARY KEY(id),
-    KEY (md)
+    UNIQUE KEY (md)
 ) ENGINE=InnoDB;