Difference between revisions of "AudioFerret/v2/cuts"
< AudioFerret | v2
Jump to navigation
Jump to search
m (using plural) |
m |
||
| Line 7: | Line 7: | ||
`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>