-
Notifications
You must be signed in to change notification settings - Fork 0
/
tables.sql
76 lines (58 loc) · 1.99 KB
/
tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
-- Table: public.arjlover_source
-- DROP TABLE public.arjlover_source;
CREATE TABLE IF NOT EXISTS public.arjlover_source
(
url text COLLATE pg_catalog."default" NOT NULL,
title text COLLATE pg_catalog."default",
size bigint,
md5 text COLLATE pg_catalog."default",
linked text[] COLLATE pg_catalog."default",
http text COLLATE pg_catalog."default",
torrent text COLLATE pg_catalog."default",
id integer NOT NULL GENERATED ALWAYS AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ),
category text COLLATE pg_catalog."default" NOT NULL,
CONSTRAINT arjlover_source_pkey PRIMARY KEY (id)
)
TABLESPACE pg_default;
ALTER TABLE public.arjlover_source
OWNER to postgres;
-- Table: public.kinopoisk_source
-- DROP TABLE public.kinopoisk_source;
CREATE TABLE IF NOT EXISTS public.kinopoisk_source
(
film_id integer NOT NULL,
name_ru text COLLATE pg_catalog."default",
year integer,
description text COLLATE pg_catalog."default",
countries text[] COLLATE pg_catalog."default",
genres text[] COLLATE pg_catalog."default",
rating text COLLATE pg_catalog."default",
rating_vote_count integer,
poster_url text COLLATE pg_catalog."default",
ref_id integer,
name_en text COLLATE pg_catalog."default",
CONSTRAINT fk_id FOREIGN KEY (ref_id)
REFERENCES public.arjlover_source (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
TABLESPACE pg_default;
ALTER TABLE public.kinopoisk_source
OWNER to postgres;
-- Table: public.rating_source
-- DROP TABLE public.rating_source;
CREATE TABLE IF NOT EXISTS public.rating_source
(
kp double precision,
kp_votes integer,
imdb double precision,
imdb_votes integer,
ref_id integer NOT NULL,
CONSTRAINT fk_id FOREIGN KEY (ref_id)
REFERENCES public.arjlover_source (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
TABLESPACE pg_default;
ALTER TABLE public.rating_source
OWNER to postgres;