blob: 5686f23ce50edfb3932a8dc97a73e1e857540520 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
create table if not exists torrents (
id serial not null primary key,
infohash character varying(40) unique,
size bigint,
name text,
seen timestamp with 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)
);
|
