AudioFerret/v2/cuts: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret | v2
heavily adapted from v1 "Title" |
mNo edit summary |
||
| (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>
