Cantata Version 1

CREATE TABLE LIST_ITEM_T (ID varchar(50) NOT NULL, 
TITLE varchar(100) DEFAULT NULL, FILE_NAME varchar(64) DEFAULT NULL, 
MUSIC_KEY varchar(16) DEFAULT NULL, comments varchar(1024) DEFAULT NULL, 
LIST_ID varchar(50) NOT NULL, ITEM_ORDER int(11) DEFAULT NULL, 
PRIMARY KEY (ID)) ENGINE=MyISAM DEFAULT CHARSET=latin1

create table LIST_T (ID VARCHAR(50) PRIMARY KEY, NAME VARCHAR(100) NOT NULL, 
ROLE VARCHAR(16) NOT NULL, FOR_DATE DATETIME, LAST_UPDATED DATETIME, 
COMMENTS VARCHAR(1024));