initial version

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

1 files changed, 29 insertions, 0 deletions

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)
+);