Advertisement
Guest User

Untitled

a guest
Apr 24th, 2019
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. CREATE 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement