move everything down a directory

git-svn-id: file:///home/lennart/svn/public/sse/trunk@6 5fbabb74-0606-0410-a5e4-b5cc6a42724e

1 files changed, 6 insertions, 5 deletions

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;