[dev] Horde incubator/thomas and merk sql schema files

[Ralf Lang]

@duck: If you already answered on this, sorry. I might have lost the mail to 
an over-zealous spam guard.

-- INCUBATOR/THOMAS --
I just installed horde thomas and found the thomas.mysql.sql file is missing 
the 
category_parentid row for thomas_categories.

I figured from the error message it must be something like

CREATE TABLE `thomas_categories` (
    `category_id` INT UNSIGNED NOT NULL ,
    `category_name` VARCHAR( 50 ) NOT NULL ,
    `category_parentid` INT UNSIGNED, 
    `category_description` VARCHAR( 255 ) NOT NULL ,
    PRIMARY KEY ( `category_id` )
);

Tried it, but there still seems to be something wrong. That's probably just 
the way it is with incubator code.

-- MERK --

Hi duck, there are two problems with merk's script/sql/merk.mysql.sql as of 
today's CVS

ERROR 1064 (42000) at line 28: You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax to 
use near 'KEY `category_nls` (`category_nls`)
)' at line 7

Here, a comma after the primary_key line is missing


Enter password:
ERROR 1072 (42000) at line 111: Key column 'stock_item' doesn't exist in table
debian3:/var/www/sites/dtc/solesystems.de/subdomains/webmail/html/merk/scripts/sql# 

Here, I deleted the second "key" statement. I'm not sure what you were about 
to do there. 

My fixed file thus looks as attached.

-- 

My current horde-based project will end sometime in may. I'd like to 
contribute something to parts of the horde platform that are useful to a 
commercial platform like banner-ads (midas and classified I think), shop 
(merk) and 
invoicing (minerva?).

I notice there is also an inactive, archived book library module which I'm 
interested but currently lack the time to investigate. So if you say merk 
doesn't need additional input right now or you don't have the time to answer 
the typical questions that might come up when one dives into existing code, I 
might as well look after that project.

What would be a good, needed contribution to merk/midas/minerva or other 
shop-related parts?




-- 
Ralf Lang
IT-Consultant / Trainer
-------------- next part --------------
CREATE TABLE `merk_cart_contents` (
  `cart_id` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `stock_id` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `stock_quantity` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  KEY `cart_id` (cart_id),
  KEY `stock_id` (`stock_id`)
);

CREATE TABLE `merk_carts` (
  `cart_id` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `user_uid` varchar(85) DEFAULT '' NOT NULL,
  `session_id` varchar(85) DEFAULT '' NOT NULL,
  `cart_updated` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  PRIMARY KEY  (`cart_id`),
  KEY `session_id` (`session_id`),
  KEY `user_uid` (`user_uid`)
);

CREATE TABLE `merk_categories` (
  `category_id` int(11) UNSIGNED NOT NULL,
  `category_parentid` int(10) UNSIGNED NOT NULL default '0',
  `category_image` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY  (`category_id`)
);

CREATE TABLE `merk_categories_nls` (
  `category_id` int(10) UNSIGNED NOT NULL,
  `category_nls` char(5) NOT NULL,
  `category_name` varchar(50) NOT NULL,
  `category_description` varchar(255) NOT NULL,
  PRIMARY KEY  (`category_id`,`category_nls`),
  KEY `category_nls` (`category_nls`)
);

CREATE TABLE `merk_deliveries` (
  `delivery_id` int(4) UNSIGNED NOT NULL,
  `delivery_country` varchar(255) NOT NULL,
  `delivery_price` varchar(7) DEFAULT '' NOT NULL,
  `delivery_minimal` varchar(7) DEFAULT '' NOT NULL,
  `delivery_tax` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  PRIMARY KEY  (`delivery_id`)
);

CREATE TABLE `merk_deliveries_attributes` (
  `delivery_id` int(4) UNSIGNED NOT NULL,
  `attribute_name` varchar(85) DEFAULT '' NOT NULL,
  `attribute_key` varchar(85) DEFAULT '' NOT NULL,
  `attribute_value` text,
  KEY `delivery_id` (`delivery_id`)
);

CREATE TABLE `merk_invoices` (
  `invoice_id` int(4) UNSIGNED NOT NULL,
  `invoice_user_uid` varchar(17) DEFAULT '' NOT NULL,
  `invoice_address` text NOT NULL,
  `invoice_items` text NOT NULL,
  `invoice_total` varchar(7) DEFAULT '' NOT NULL,
  `invoice_total_tax` varchar(7) DEFAULT '0' NOT NULL,
  `invoice_timestamp` varchar(17) DEFAULT '' NOT NULL,
  PRIMARY KEY  (`invoice_id`)
);

CREATE TABLE `merk_item_attributes` (
  `item_id` int(255) UNSIGNED NOT NULL,
  `nls` char(5) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_desc` text NOT NULL,
  KEY `item_id` (`item_id`,`nls`)
);

CREATE TABLE `merk_items` (
  `item_id` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `user_uid` varchar(85) DEFAULT '' NOT NULL,
  `cid` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `item_price` varchar(85) DEFAULT '' NOT NULL,
  `item_model` varchar(255) NOT NULL,
  `item_tax` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `item_discount` varchar(85) DEFAULT '' NOT NULL,
  `item_service` tinyint(1) UNSIGNED NOT NULL,
  `item_seller` int(11) UNSIGNED DEFAULT 0,
  `item_startdate` int(11) UNSIGNED DEFAULT 0,
  `item_enddate` int(11) UNSIGNED DEFAULT 0,
  `item_image` tinyint(1) UNSIGNED DEFAULT 0 NOT NULL,
  `item_gallery` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `item_enabled` smallint(6) UNSIGNED DEFAULT 0 NOT NULL,
  `item_updated` timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`item_id`),
  KEY `cid` (`cid`)
);

CREATE TABLE `merk_options` (
  `option_id` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `option_attribute_name` varchar(85) DEFAULT '' NOT NULL,
  `option_attribute_key` varchar(85) DEFAULT '' NOT NULL,
  `option_attribute_value` text,
  KEY `option_attribute_idx` (`option_id`),
  KEY `option_attribute_name_idx` (`option_attribute_name`),
  KEY `option_attribute_key_idx` (`option_attribute_key`)
);

CREATE TABLE `merk_stock_attributes` (
  `stock_id` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `attribute_key` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  `attribute_value` int(11) UNSIGNED DEFAULT 0 NOT NULL,
  KEY `stock_attribute_idx` (`stock_id`),
  KEY `stock_attribute_key_idx` (`attribute_key`)
);

CREATE TABLE `merk_stocks` (
  `stock_id` int(11) UNSIGNED NOT NULL default '0',
  `item_id` int(11) UNSIGNED NOT NULL default '0',
  `item_model` char(50) NOT NULL,
  `stock_quantity` int(11) UNSIGNED NOT NULL default '0',
  PRIMARY KEY  (`stock_id`),
  KEY `stock_quantity` (`stock_quantity`)
  );

CREATE TABLE `merk_sellers` (
  `seller_id` int(10) UNSIGNED NOT NULL auto_increment,
  `seller_name` varchar(255) NOT NULL,
  `seller_city` varchar(255) NOT NULL,
  `seller_address` varchar(255) NOT NULL,
  `seller_zipcode` varchar(255) NOT NULL,
  `seller_tel` varchar(255) NOT NULL,
  `seller_email` varchar(255) NOT NULL,
  `seller_url` varchar(255) NOT NULL,
  `seller_vat` char(10) NOT NULL,
  `seller_image` tinyint(1) UNSIGNED DEFAULT 0 NOT NULL,
  `horde_uid` varchar(32) NOT NULL,
  PRIMARY KEY  (`seller_id`)
);
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
Url : http://lists.horde.org/archives/dev/attachments/20080507/9977fbab/attachment-0001.bin