1 files changed, 7 insertions, 3 deletions
diff --git a/sse.sql b/sse.sql
index 2345053..03117dd 100644
--- a/sse.sql
+++ b/sse.sql
@@ -25,7 +25,7 @@ CREATE TABLE file (
     path VARBINARY(255) NOT NULL,
     language_id TINYINT UNSIGNED NOT NULL,
 
-    PRIMARY KEY (crawler_id, id),
+    PRIMARY KEY (id, crawler_id),
     UNIQUE KEY (crawler_id, package_id, path)
 ) ENGINE=InnoDB;
 
@@ -37,7 +37,7 @@ CREATE TABLE package (
     timestamp TIMESTAMP NOT NULL,
     md CHAR(32) NOT NULL DEFAULT '',
 
-    PRIMARY KEY(crawler_id, id),
+    PRIMARY KEY(id, crawler_id),
     UNIQUE KEY (md)
 ) ENGINE=InnoDB;
 
@@ -61,7 +61,11 @@ CREATE TABLE crawler (
     id TINYINT UNSIGNED NOT NULL,
 
     name VARCHAR(255) NOT NULL,
-    url VARBINATY(255) NOT NULL,
+    url VARBINARY(255) NOT NULL,
 
     PRIMARY KEY(id)
 ) ENGINE=InnoDB;
+
+INSERT INTO crawler (id, name, url) VALUES 
+    (1, "Tango", "http://poehlsen.org/sse/"),
+    (2, "Soleil", "http://soleil.ethium.org:8000/sse/");