Add torrent tagging

- Move to postgresql to reduce locking issues
- Move ih hash to single thread
- Clean up stuff

1 files changed, 22 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..a0acf5b
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,22 @@
+create table if not exists torrents (
+    id serial not null primary key,
+    infohash character varying(40) unique,
+    size bigint,
+    name text,
+    seen timestamp without time zone
+);
+create table if not exists files (
+    id serial not null primary key,
+    torrent_id integer not null references torrents,
+    path text,
+    size bigint
+);
+create table if not exists tags (
+    id serial not null primary key,
+    name text
+);
+create table if not exists tags_torrents (
+    tag_id integer not null references tags,
+    torrent_id integer not null references torrents,
+    primary key (tag_id, torrent_id)
+);