ddl.sql

drop table if exists t_detail ;
drop table if exists t_master ;
-------------------------------------------------------------
create table t_master(id varchar(10) primary key, artist varchar(64), album varchar(64))
;

create table t_detail(master_id varchar(10) references t_master(id), trackno numeric, title varchar(128))
;

© Willem Moors, 2009 - 2013