AudioFerret/v2/cuts

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret‎ | v2
Revision as of 03:17, 24 December 2012 by Woozle (talk | contribs) (heavily adapted from v1 "Title")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 `cut` (

 `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>