setup.sql

create table android_metadata (
	locale text
);

create table stations (
	_id integer primary key,
	name text,
	url text
);

create table recording_type (
	_id integer primary key,
	type text
);

create table recording_schedule (
	_id integer primary key,
	start_time integer,
	end_time integer,
	station integer,
	type integer,
	foreign key (station) references stations (_id),
	foreign key (type) references recording_type (_id)
);

insert into recording_type values (null, 'One-Off' );
insert into recording_type values (null, 'Daily' );
insert into recording_type values (null, 'Weekly' );

insert into stations values (null, 'Sub.fm', 'http://sub.fm/listenwinamp128k.pls');
insert into stations values (null, 'Rinse.fm', 'http://podcast.dgen.net:8000/rinseradio.m3u');
insert into stations values (null, 'Passion Radio (Bristol)', 'http://88.208.231.77:9000/listen.pls');
insert into stations values (null, 'Kool London', 'http://uk1-pn.mixstream.net/8698.pls');