modules/amazon_items/amazon_items.sql

#
# Table structure for table `amazon_items`
#
CREATE TABLE `amazon_items` (
  `aid` int(10) unsigned NOT NULL default '0',
  `asin` varchar(10) NOT NULL default '0',
  `nid` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `imgsmall` varchar(255) NOT NULL default '',
  `imgmedium` varchar(255) NOT NULL default '',
  `imglarge` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM;
1	#
2	# Table structure for table `amazon_items`
3	#
4	CREATE TABLE `amazon_items` (
5	`aid` int(10) unsigned NOT NULL default '0',
6	`asin` varchar(10) NOT NULL default '0',
7	`nid` int(10) unsigned NOT NULL default '0',
8	`name` varchar(255) NOT NULL default '',
9	`url` varchar(255) NOT NULL default '',
10	`imgsmall` varchar(255) NOT NULL default '',
11	`imgmedium` varchar(255) NOT NULL default '',
12	`imglarge` varchar(255) NOT NULL default '',
13	PRIMARY KEY (`aid`)
14	) TYPE=MyISAM;