TQHCxLDn

1CREATE TABLE IF NOT EXISTS `product` (
2    `product_id` INT(11) NOT NULL AUTO_INCREMENT,
3    `name` VARCHAR(32) NOT NULL,
4    `description` TEXT NOT NULL,
5    `price` FLOAT(10,2) NOT NULL DEFAULT 0.00,
6    `category_id` INT(11) NOT NULL,
7    `date_upd` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
8    `date_add` DATETIME NOT NULL,
9    PRIMARY KEY (`product_id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT = 65;