From 60cd2a763756529262ae7bbe58b3272ed51e5598 Mon Sep 17 00:00:00 2001
From: Lennart Poettering <lennart@poettering.net>
Date: Mon, 21 Nov 2005 14:15:24 +0000
Subject: move everything down a directory

git-svn-id: file:///home/lennart/svn/public/sse/trunk@6 5fbabb74-0606-0410-a5e4-b5cc6a42724e
---
 sse.sql | 11 ++++++-----
 1 file changed, 6 insertions(+), 5 deletions(-)

(limited to 'sse.sql')

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

