Differences

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

--- projects:cantata:version3:database [2016/09/09 03:25]
dwheele
+++ projects:cantata:version3:database [2016/09/09 03:26] (current)
dwheele [SQL To Create Tables]
@@ Line 50: / Line 50: @@
 ==== SQL To Create Tables ====
 <code>
-create table KEYWORD (ID INT PRIMARY KEY, NAME varchar(64), DEFAULT_VALUE varchar(8), created_at datetime, updated_at datetime) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+create table KEYWORDS (ID INT PRIMARY KEY, NAME varchar(64), DEFAULT_VALUE varchar(8), created_at datetime, updated_at datetime) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 create table FILE_META (ID INT PRIMARY KEY, SONG_NAME VARCHAR(128) NOT NULL, FILE_NAME varchar(128), LAST_UPDATED datetime, MUSIC_KEY varchar(16), COMMENTS varchar(1024), TYPE varchar(12), created_at datetime, updated_at datetime)

Dan's Wiki