AudioFerret/v1/sql/discarded

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot

< AudioFerret‎ | v1‎ | sql

Jump to navigation Jump to search

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This was eventually going to be part of a subsystem for encouraging legit copies of "pirated" tracks. It isn't necessary in order to make the thing work, but I do plan to continue working with it for the next version. <mysql>CREATE TABLE `Source_Types` (

 `id` int(11) NOT NULL,
 `descr` varchar(50) default NULL,
 `islegalcopy` tinyint(1) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `Source_Types` VALUES (1,'CD rip of owned CD',1),

(2,'CD rip of owned content (other media)',1),
(3,'Skimmed from LP',1),
(4,'Skimmed from 45',1),
(5,'Legal free download',1),
(6,'Public Filesharing',0),
(7,'Copied by 3rd party',0);</mysql>

Advanced Data

These tables had not been used yet, and I think there's probably a better way to provide this functionality using a hierarchical topic/value tree.

The basic idea was to provide data on everything known about an album -- the names of everyone who worked on it, the studio where it was recorded, dates, etc. so that these could be cross-referenced and other works recorded at the same place, produced by the same person, etc. could also be looked up. <mysql>CREATE TABLE `Locations` (

 `id` int(11) NOT NULL,
 `path` varchar(255) default NULL,
 `descr` varchar(50) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Personnel` (

 `id` int(11) NOT NULL,
 `name` varchar(255) default NULL,
 `sort` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Release_Data` (

 `id` int(11) NOT NULL,
 `id_release` int(11) default NULL,
 `id_type` int(11) default NULL,
 `id_person` int(11) default NULL,
 `notes` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Release_Data_Types` (

 `id` int(11) NOT NULL,
 `descr` varchar(50) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Releases` (

 `id` int(11) NOT NULL,
 `id_artist` int(11) default NULL,
 `name` varchar(255) default NULL,
 `label` varchar(50) default NULL,
 `catnum` varchar(50) default NULL,
 `notes` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Song_Data` (

 `id` int(11) NOT NULL,
 `id_song` int(11) default NULL,
 `id_type` varchar(50) default NULL,
 `id_person` int(11) default NULL,
 `notes` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Song_Data_Types` (

 `id` varchar(50) NOT NULL,
 `descr` varchar(50) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Songs` (

 `id` int(11) NOT NULL,
 `name` varchar(255) default NULL,
 `which` varchar(50) default NULL,
 `notes` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Take_Data` (

 `id` int(11) NOT NULL,
 `id_take` int(11) default NULL,
 `id_type` varchar(50) default NULL,
 `id_person` int(11) default NULL,
 `value` varchar(255) default NULL,
 `notes` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Take_Data_Types` (

 `id` varchar(50) NOT NULL,
 `descr` varchar(50) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `Takes` (

 `id` int(11) NOT NULL,
 `id_song` int(11) default NULL,
 `which` varchar(50) default NULL,
 `descr` varchar(255) default NULL,
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=AudioFerret/v1/sql/discarded&oldid=16653"