-- createdb RVRS1

CREATE TABLE m_channels (
    id_ch smallint NOT NULL,
    descr_ch character varying
);

insert into m_channels values(1,'NHK総合');
insert into m_channels values(3,'NHK教育');
insert into m_channels values(4,'日本テレビ');
insert into m_channels values(6,'TBS');
insert into m_channels values(8,'フジテレビ');
insert into m_channels values(10,'テレビ朝日');
insert into m_channels values(12,'テレビ東京');

CREATE TABLE m_progstat (
    id_progstat smallint NOT NULL,
    descr_progstat character varying
);

insert into m_progstat values(0,'予約済み');
insert into m_progstat values(1,'準備完了');
insert into m_progstat values(2,'実行中');
insert into m_progstat values(3,'正常終了');
insert into m_progstat values(4,'エラー:デバイスが使用中');
insert into m_progstat values(5,'エラー:書き込み禁止');
insert into m_progstat values(6,'エラー:中断されました。');
insert into m_progstat values(7,'エラー:UnKnown');
insert into m_progstat values(8,'エラー:ジョブ登録失敗');

CREATE TABLE t_prog (
    id_cont serial primary key,
    id_ch int,
    title character varying,
    dtstart timestamp,
    duration interval,
    stat smallint
);