modules/discography/discography.sql

-- 
-- Table structure for table discography
-- 

CREATE TABLE `discography` (
  `nid` int(10) unsigned NOT NULL default '0',
  `year` int(4) unsigned default '0',
  `artist` varchar(128) default NULL,
  `label` varchar(32) default NULL,
  `ITMS` varchar(128) default NULL,
  `tracks` longtext,
  `ASIN` varchar(16) default NULL,
  `Cassette` tinyint(1) default NULL,
  `CD` tinyint(1) default NULL,
  `DVD` tinyint(1) default NULL,
  PRIMARY KEY  (`nid`)
) TYPE=MyISAM;
1	--
2	-- Table structure for table discography
3	--
4
5	CREATE TABLE `discography` (
6	`nid` int(10) unsigned NOT NULL default '0',
7	`year` int(4) unsigned default '0',
8	`artist` varchar(128) default NULL,
9	`label` varchar(32) default NULL,
10	`ITMS` varchar(128) default NULL,
11	`tracks` longtext,
12	`ASIN` varchar(16) default NULL,
13	`Cassette` tinyint(1) default NULL,
14	`CD` tinyint(1) default NULL,
15	`DVD` tinyint(1) default NULL,
16	PRIMARY KEY (`nid`)
17	) TYPE=MyISAM;