Differences

This shows you the differences between two versions of the page.

--- projects:cantata:version1:start [2015/09/30 00:59]
dwheele
+++ projects:cantata:version1:start [2016/06/10 00:34] (current)
admin ↷ Page moved from apps:cantata:version1:start to projects:cantata:version1:start
@@ Line 4: / Line 4: @@
 <code>
-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));
+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));
 </code>

Dan's Wiki