create table pmtivo_suggestions ( suggestion_id integer primary key, when_start timestamptz not null, when_stop timestamptz not null, channel varchar(30), title varchar(100), description varchar(500), sub_title varchar(100), suggester_name varchar(200), suggester_email varchar(200), suggester_ip varchar(50) not null, status varchar(20) default 'Scheduled' check (status in ('Scheduled','Conflict', 'Dropped','Recorded','Watched','Other')), -- Suggester's comments. comments varchar(4000), -- My reaction. reply varchar(4000), when_suggested timestamptz default current_timestamp, active_p boolean default 't', status_img varchar(50), when_watched timestamptz ); -- Helper view for generating the RSS feed. create or replace view rsstv_feed_pmt as select title, sub_title, description || ' Recommended by ' || suggester_name || ' (' || suggester_email || ').' as description, when_start, when_stop, channel as tvchannel, when_start as when_order_by, status from pmtivo_suggestions where active_p = 't';