| |
data.sql
-------------------------------------------------------------
insert into t_master(id,artist,album)
values ('2a087a04','Frank Zappa','Jawaka');
insert into t_detail(master_id,trackno,title)
values('2a087a04',1,'Big Swifty');
insert into t_detail(master_id,trackno,title)
values('2a087a04',2,'Your Mouth');
insert into t_detail(master_id,trackno,title)
values('2a087a04',3,'It Just Might Be a One-Shot Deal');
insert into t_detail(master_id,trackno,title)
values('2a087a04',4,'Waka/Jawaka');
-------------------------------------------------------------
insert into t_master(id,artist,album)
values ('8e0f950a','PK','Chishala');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',1,'Nakufele');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',2,'Umwaume Walutuku');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',3,'Church Elder');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',4,'Minofu Ya Mbowa');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',5,'Impumpa Mukowa');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',6,'Kubwaiche');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',7,'Mutete');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',8,'Na Musonda');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',9,'Pali Iwe');
insert into t_detail(master_id,trackno,title)
values('8e0f950a',10,'Umunandi');
-------------------------------------------------------------
insert into t_master(id,artist,album)
values ('f40d3812','Johann Sebastian Bach','Suites for Cello');
insert into t_detail(master_id,trackno,title)
values('f40d3812',1,'Suite No. 1 in G major, BWV 1007 - I. Prelude (moderato)');
insert into t_detail(master_id,trackno,title)
values('f40d3812',2,'Suite No. 1 in G major, BWV 1007 - II. Allemande (molto moderato)');
insert into t_detail(master_id,trackno,title)
values('f40d3812',3,'Suite No. 1 in G major, BWV 1007 - III. Courante (allegro non troppo)');
insert into t_detail(master_id,trackno,title)
values('f40d3812',4,'Suite No. 1 in G major, BWV 1007 - IV. Sarabande (lento)');
insert into t_detail(master_id,trackno,title)
values('f40d3812',5,'Suite No. 1 in G major, BWV 1007 - V. Menuetto I & II (allegro moderato)');
insert into t_detail(master_id,trackno,title)
values('f40d3812',6,'Suite No. 1 in G major, BWV 1007 - VI. Gigue (vivace)');
insert into t_detail(master_id,trackno,title)
values('f40d3812',7,'Suite No. 2 in D minor, BWV 1008 - I. Praeludium');
insert into t_detail(master_id,trackno,title)
values('f40d3812',8,'Suite No. 2 in D minor, BWV 1008 - II. Allemande');
insert into t_detail(master_id,trackno,title)
values('f40d3812',9,'Suite No. 2 in D minor, BWV 1008 - III. Courante');
insert into t_detail(master_id,trackno,title)
values('f40d3812',10,'Suite No. 2 in D minor, BWV 1008 - IV. Sarabande');
insert into t_detail(master_id,trackno,title)
values('f40d3812',11,'Suite No. 2 in D minor, BWV 1008 - V. Menuetto I & II');
insert into t_detail(master_id,trackno,title)
values('f40d3812',12,'Suite No. 2 in D minor, BWV 1008 - VI. Gigue');
insert into t_detail(master_id,trackno,title)
values('f40d3812',13,'Suite No. 3 in C major, BWV 1009 - I. Praeludium');
insert into t_detail(master_id,trackno,title)
values('f40d3812',14,'Suite No. 3 in C major, BWV 1009 - II. Allemande');
insert into t_detail(master_id,trackno,title)
values('f40d3812',15,'Suite No. 3 in C major, BWV 1009 - III. Courante');
insert into t_detail(master_id,trackno,title)
values('f40d3812',16,'Suite No. 3 in C major, BWV 1009 - IV. Sarabande');
insert into t_detail(master_id,trackno,title)
values('f40d3812',17,'Suite No. 3 in C major, BWV 1009 - V. Bourree I & II');
insert into t_detail(master_id,trackno,title)
values('f40d3812',18,'Suite No. 3 in C major, BWV 1009 - VI. Gigue');
|