View Single Post
  #5  
Old 04-08-2005, 04:16 PM
 
usiripakdi usiripakdi is offline
 

Advanced Member
  
Join Date: Jan 2005
Posts: 47
 

Default

There is no xcart_categories file in sql dir. I found xcart_tables.sql in that dir, and found this code.

CREATE TABLE xcart_categories (
categoryid int(11) NOT NULL auto_increment,
parentid int(11) NOT NULL default '0',
categoryid_path varchar(255) NOT NULL default '',
image_x int(11) NOT NULL default '0',
image_y int(11) NOT NULL default '0',
category varchar(255) NOT NULL default '',
description text NOT NULL,
meta_descr varchar(255) NOT NULL default '',
avail char(1) NOT NULL default 'Y',
views_stats int(11) NOT NULL default '0',
order_by int(11) NOT NULL default '0',
membership varchar(32) NOT NULL default '',
threshold_bestsellers int(11) NOT NULL default '1',
product_count int(11) NOT NULL default '0',
meta_keywords varchar(255) NOT NULL default '',
PRIMARY KEY (categoryid),
KEY category_path (parentid,categoryid_path),
KEY category_path2 (categoryid,categoryid_path),
KEY avail (avail),
KEY membership (membership),
KEY order_by (order_by,category),
KEY am (avail,membership),
KEY pam (categoryid_path,avail,membership),
KEY ia (categoryid,avail),
KEY iam (categoryid,avail,membership)
) TYPE=MyISAM;

Should I add the field

ALTER TABLE `xcart_categories` ADD `show_image` CHAR( 1 ) DEFAULT 'Y' NOT NULL ;

inside the xcart_categories() ??

Thanks.
__________________
Siripakdi
Version 4.0.13
Reply With Quote