Difference between revisions of "AudioFerret/v2/cuts"
< AudioFerret | v2
Jump to navigation
Jump to search
m (Woozle moved page AudioFerret/v2/cut to AudioFerret/v2/cuts without leaving a redirect: singular is starting to seem weird; maybe it only made sense in VB) |
m (using plural) |
||
| 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, | ||
Revision as of 15:21, 24 December 2012
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>