Difference between revisions of "AudioFerret/v2/cuts"
< AudioFerret | v2
Jump to navigation
Jump to search
(heavily adapted from v1 "Title") |
m |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
* '''Purpose''': a "cut" is, most commonly, a specific recording (of a specific song or other work), but it may appear in multiple collections (e.g. albums). | * '''Purpose''': a "cut" is, most commonly, a specific recording (of a specific song or other work), but it may appear in multiple collections (e.g. albums). | ||
==SQL== | ==SQL== | ||
| − | <mysql>CREATE TABLE ` | + | <mysql>CREATE TABLE `cuts` ( |
`ID` int(11) NOT NULL auto_increment, | `ID` int(11) NOT NULL auto_increment, | ||
`Name` varchar(255) default NULL, | `Name` varchar(255) default NULL, | ||
`WhenAdded` DATETIME DEFAULT NULL COMMENT "when the cut was added to the database", | `WhenAdded` DATETIME DEFAULT NULL COMMENT "when the cut was added to the database", | ||
`WhenChanged` DATETIME DEFAULT NULL COMMENT "when information about the cut was last modified", | `WhenChanged` DATETIME DEFAULT NULL COMMENT "when information about the cut was last modified", | ||
| − | PRIMARY KEY (`ID`) | + | PRIMARY KEY (`ID`) |
) ENGINE=MyISAM;</mysql> | ) ENGINE=MyISAM;</mysql> | ||
Latest revision as of 22:24, 25 August 2013
About
- Purpose: a "cut" is, most commonly, a specific recording (of a specific song or other work), but it may appear in multiple collections (e.g. albums).
SQL
<mysql>CREATE TABLE `cuts` (
`ID` int(11) NOT NULL auto_increment, `Name` varchar(255) default NULL, `WhenAdded` DATETIME DEFAULT NULL COMMENT "when the cut was added to the database", `WhenChanged` DATETIME DEFAULT NULL COMMENT "when information about the cut was last modified", PRIMARY KEY (`ID`)
) ENGINE=MyISAM;</mysql>