Differences

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

--- projects:cantata:database3 [2016/09/03 00:29]
dwheele [SQL (copied from Cantata2, not actual)]
+++ — (current)
@@ Line 1: / Line 1: @@
-===== Cantata 3 Database =====
-Compared to Cantata2, this Cantata3 database information takes into account the move to Laravel. Also, when setting up the Model/DB Tables, noticed that the Keywords for Cantata2 only applied to the Song Level, but perhaps should have been at the File level as well. This would allow filtering or tagging for various people leading - to make it quicker to select keys, etc.
-^Database Name|quizkidn_cantata3|
-^User Name|quizkidn_can3|
-  * create database quizkidn_cantata3;
-  * create user 'quizkidn_can3'@'%' identified by 'cantatapass3';
-  * grant all on quizkidn_cantata3.* to 'quizkidn_can3'@'%';
-  * FLUSH PRIVILEGES;
-  * select user from mysql.user;
-^FILE_META|id|INT UNSIGNED|
-^:::|SONG_NAME|VARCHAR(128)|
-^:::|FILE_NAME|VARCHAR(128)|Will hold URL if TYPE=URL|
-^:::|LAST_UPDATED|DATETIME|
-^:::|MUSIC_KEY|VARCHAR(16)|
-^:::|COMMENTS|VARCHAR(1024)|
-^:::|TYPE|VARCHAR(12)|One of 'Chart', 'Audio', or 'URL'|
-^KEYWORD|id|INT UNSIGNED|
-^:::|NAME|VARCHAR(64)|
-^:::|DEFAULT_VALUE|VARCHAR(8)|
-^KEYWORD_FILE_META_XREF|id|INT UNSIGNED|
-^:::|KEYWORD_ID|INT UNSIGNED|
-^:::|FILE_META_ID|INT UNSIGNED|
-^LIST_META|id|INT UNSIGNED|
-^:::|LIST_DATE|DATETIME|
-^:::|TYPE|VARCHAR(64)|
-^:::|COMMENTS|VARCHAR(1024)|
-^LIST_ITEM|id|INT UNSIGNED|
-^:::|FILE_META_ID|INT UNSIGNED|
-^:::|DISPLAY_TITLE|VARCHAR(100)|
-^:::|SONG_ORDER|INT|
-==== SQL (copied from Cantata2, not actual) ====
-<code>
-create table KEYWORD (ID INT PRIMARY KEY, NAME varchar(64), DEFAULT_VALUE varchar(8)) 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))
- ENGINE=InnoDB DEFAULT CHARSET=latin1;
-create table KEYWORD_FILE_META_XREF (ID VARCHAR(50) PRIMARY KEY,
-KEYWORD_ID VARCHAR(50) NOT NULL,
-FILE_META_ID VARCHAR(50) NOT NULL,
-FOREIGN KEY (KEYWORD_ID) REFERENCES KEYWORD (ID),
-FOREIGN KEY (SONG_META_ID) REFERENCES SONG_META (ID)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-create table LIST_META (ID VARCHAR(50) PRIMARY KEY, LIST_DATE DATETIME,
-TYPE VARCHAR(64), COMMENTS VARCHAR(1024)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-create table LIST_ITEM (ID VARCHAR(50) PRIMARY KEY, LIST_META_ID VARCHAR(50), FILE_META_ID VARCHAR(50),
-DISPLAY_TITLE VARCHAR(100), SONG_ORDER int,
-FOREIGN KEY (LIST_META_ID) REFERENCES LIST_META(ID),
-FOREIGN KEY (FILE_META_ID) REFERENCES FILE_META(ID)) ENGINE=InnoDB DEFAULT CHARSET=latin1;;
-</code>

Dan's Wiki

User Tools

Site Tools

Differences

Page Tools