From 0ff40b23e97276fe829677f9fa0118b0bdb4d6ab Mon Sep 17 00:00:00 2001
From: Lennart Poettering <lennart@poettering.net>
Date: Sun, 20 Nov 2005 22:15:04 +0000
Subject: initial version

git-svn-id: file:///home/lennart/svn/public/sse/trunk@3 5fbabb74-0606-0410-a5e4-b5cc6a42724e
---
 sse.sql | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100644 sse.sql

(limited to 'sse.sql')

diff --git a/sse.sql b/sse.sql
new file mode 100644
index 0000000..0b4b8e6
--- /dev/null
+++ b/sse.sql
@@ -0,0 +1,29 @@
+DROP TABLE word;
+DROP TABLE file;
+DROP TABLE package;
+
+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,
+    PRIMARY KEY (text, type, file_id)
+);
+
+CREATE TABLE file (
+    id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+    package_id INTEGER UNSIGNED NOT NULL,
+    path VARBINARY(255) NOT NULL,
+    language_id TINYINT UNSIGNED NOT NULL,
+    PRIMARY KEY (id)
+);
+
+CREATE TABLE package (
+    id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+    filename VARBINARY(255) NOT NULL,
+    url VARBINARY(255) NOT NULL,
+    timestamp TIMESTAMP NOT NULL,
+    md CHAR(32) NOT NULL,
+    PRIMARY KEY(id),
+    KEY (md)
+);
-- 
cgit