Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `product` (
- `product_id` INT(11) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(32) NOT NULL,
- `description` TEXT NOT NULL,
- `price` FLOAT(10,2) NOT NULL DEFAULT 0.00,
- `category_id` INT(11) NOT NULL,
- `date_upd` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `date_add` DATETIME NOT NULL,
- PRIMARY KEY (`product_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT = 65;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement