-- auto-generated definition
create table public.youtube_channel
(
  id        varchar(150)                                 not null
    constraint youtube_channel_pkey
    primary key,
  name      varchar(150)                                 not null,
  lastvideo varchar(150) default '' :: character varying not null,
  expire    integer default '-1' :: integer              not null,
  ctime     timestamp with time zone default now()       not null,
  mtime     timestamp with time zone default now()       not null
);

-- auto-generated definition
create table public.line_youtube_rt
(
  line    varchar(100)                                 not null
    constraint line_youtube_rt_line_group_id_fk
    references public.line_group
    on delete cascade,
  youtube varchar(150)                                 not null
    constraint line_youtube_rt_youtube_channel_id_fk
    references public.youtube_channel
    on delete cascade,
  tmpl    varchar(300) default '' :: character varying not null,
  constraint line_youtube_rt_line_youtube_pk
  primary key (line, youtube)
);