Differences

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

--- projects:cantata:version3:database [2016/09/09 03:11]
dwheele created
+++ projects:cantata:version3:database [2016/09/09 03:26] (current)
dwheele [SQL To Create Tables]
@@ Line 21: / Line 21: @@
 ^:::|updated_at|DATETIME|
-^KEYWORD|id|INT UNSIGNED|
+^KEYWORDS|id|INT UNSIGNED|
 ^:::|NAME|VARCHAR(64)|
 ^:::|DEFAULT_VALUE|VARCHAR(8)|
@@ 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