CREATE TABLE `category` ( `cat_id` INT(10) NOT NULL AUTO_INCREMENT, `catparent_id` VARCHAR(10) NULL DEFAULT NULL, `cat_name` VARCHAR(100) NOT NULL, `cat_image` LONGBLOB NULL, PRIMARY KEY (`cat_id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT AUTO_INCREMENT=1
CREATE TABLE `product` ( `pd_id` INT(11) NOT NULL AUTO_INCREMENT, `pd_name` VARCHAR(120) NOT NULL DEFAULT '""', `pd_description` TEXT NOT NULL, `pd_price` DECIMAL(7,2) NULL DEFAULT '0.00', `pd_qty` SMALLINT(6) UNSIGNED NULL DEFAULT '0', `pd_application` VARCHAR(255) NULL DEFAULT NULL, `pd_image` LONGBLOB NULL, `pd_thumb` LONGBLOB NULL, `pdf_name` VARCHAR(100) NULL DEFAULT NULL, `pd_pdf` LONGBLOB NULL, `pd_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `pd_last_update` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`pd_id`), INDEX `pd_name` (`pd_name`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT AUTO_INCREMENT=1 CREATE TABLE `productcategory` ( `pd_id` INT(11) NOT NULL, `cat_id` INT(11) NOT NULL, PRIMARY KEY (`pd_id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT Thanks and regards,Trifon.
CREATE TABLE `product` ( `pd_id` INT(11) NOT NULL AUTO_INCREMENT, `pd_name` VARCHAR(120) NOT NULL DEFAULT '""', `pd_description` TEXT NOT NULL, `pd_price` DECIMAL(7,2) NULL DEFAULT '0.00', `pd_qty` SMALLINT(6) UNSIGNED NULL DEFAULT '0', `pd_application` VARCHAR(255) NULL DEFAULT NULL, `pd_image` LONGBLOB NULL, `pd_thumb` LONGBLOB NULL, `pdf_name` VARCHAR(100) NULL DEFAULT NULL, `pd_pdf` LONGBLOB NULL, `pd_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `pd_last_update` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`pd_id`), INDEX `pd_name` (`pd_name`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT AUTO_INCREMENT=1
CREATE TABLE `productcategory` ( `pd_id` INT(11) NOT NULL, `cat_id` INT(11) NOT NULL, PRIMARY KEY (`pd_id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT Thanks and regards,Trifon.
CREATE TABLE `productcategory` ( `pd_id` INT(11) NOT NULL, `cat_id` INT(11) NOT NULL, PRIMARY KEY (`pd_id`) ) COLLATE='utf8_general_ci' ENGINE=InnoDB ROW_FORMAT=DEFAULT
Thanks and regards,
Trifon.