I'm trying to install the "Wishlist" addon, all done, except creating mysql tables.
Code:
1146 Table 'grainspace.un_wishlists' doesn't exist
in:
[SELECT id FROM un_wishlists w WHERE w.customers_id=2 and w.default_status=1 ]
I'm using this to create the tables.
Code:
# --------------------------------------------------------
#
# Table structure for table un_wishlists
#
DROP TABLE IF EXISTS `un_wishlists`;
CREATE TABLE `un_wishlists` (
`id` int(11) NOT NULL auto_increment,
`customers_id` int(11) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(255) default NULL,
`comment` varchar(255) default NULL,
`default_status` tinyint(1) NOT NULL default '0',
`public_status` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Table structure for table un_products_to_wishlists
#
DROP TABLE IF EXISTS `un_products_to_wishlists`;
CREATE TABLE `un_products_to_wishlists` (
`products_id` int(11) NOT NULL default '0',
`un_wishlists_id` int(11) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`quantity` int(2) NOT NULL default '1',
`priority` int(1) NOT NULL default '2',
`comment` varchar(255) default NULL,
PRIMARY KEY (`products_id`,`un_wishlists_id`)
) TYPE=MyISAM;
ANy help appreciated. Thanks.
Bookmarks