[Typo3-shop] zk_products extends tables

[Franz Holzinger]

Thomas Murphy schrieb:

>> Shall this remain so, and is it ok when the extension updates the 
>> fe_users and tt_content table?
> 
> 
> This is o.k.
> ...and you copied the zk_products over tt_products, right? Don't know 
> what happens if you just try to install it ...

Yes, first I extended tt_products with my own features. Then I have 
copied all the different things into tt_products. Of course there will 
be some work that needs to be done.

I have extended to the zk's ext_tables.sql and ext_tables.php . But when 
I try to install this version in the Extension Manager, I get only

---------------
Installing Shop system: DATABASE NEEDS TO BE UPDATED
Before the extension can be installed the database needs to be updated 
with new tables or fields. Please select which operations to perform:
Add tables
	CREATE TABLE tt_products (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
note text NOT NULL,
price varchar(20) DEFAULT '' NOT NULL,
price2 varchar(20) DEFAULT '' NOT NULL,
image tinyblob NOT NULL,
www varchar(80) DEFAULT '' NOT NULL,
itemnumber varchar(40) DEFAULT '' NOT NULL,
category int(10) unsigned DEFAULT '0' NOT NULL,
inStock int(11) DEFAULT '0' NOT NULL,
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
ordered int(10) unsigned DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
) TYPE=MyISAM;
-------------


However in the sql file I have already:

---------------
#
# Table structure for table 'tt_products'
#
CREATE TABLE tt_products (
   uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
   pid int(11) unsigned DEFAULT '0' NOT NULL,
   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
   starttime int(11) unsigned DEFAULT '0' NOT NULL,
   endtime int(11) unsigned DEFAULT '0' NOT NULL,
   title tinytext NOT NULL,
   note text NOT NULL,
   price varchar(20) DEFAULT '' NOT NULL,
   price2 varchar(20) DEFAULT '' NOT NULL,
   image tinyblob NOT NULL,
   www varchar(80) DEFAULT '' NOT NULL,
   itemnumber varchar(40) DEFAULT '' NOT NULL,
   category int(10) unsigned DEFAULT '0' NOT NULL,
   inStock int(11) DEFAULT '0' NOT NULL,
   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
   ordered int(10) unsigned DEFAULT '0' NOT NULL,
   fe_group int(11) DEFAULT '0' NOT NULL,
   tax int(11) DEFAULT '0' NOT NULL,
   weight varchar(20) DEFAULT '' NOT NULL,
   bulkily int(11) DEFAULT '0' NOT NULL,
   offer int(11) DEFAULT '0' NOT NULL,
   highlight int(11) DEFAULT '0' NOT NULL,
   directcost varchar(20) DEFAULT '' NOT NULL,
   color varchar(100) DEFAULT '' NOT NULL,
   size varchar(40) DEFAULT '' NOT NULL,
   special_preparation int(11) DEFAULT '0' NOT NULL,
   gradings varchar(40) DEFAULT '' NOT NULL,
   subtitle tinytext NOT NULL,
   PRIMARY KEY (uid),
   KEY parent (pid)
);
-----------

Can anyone give me a hint, what I still need to change?
Everything is already in the typo3/ext/tt_products folder, but I still 
do not get the correct update to the database.


 > the only thing I'm missing
> is some kind of "similar products" list. (But this requires some custom 
> algorithm for defining similarities anyway...)
You can put it on the wiki tt_products wish list.

Franz