· 6 years ago · Apr 24, 2019, 07:00 PM
1CREATE TABLE IF NOT EXISTS `category` (
2 `category_id` INT(11) NOT NULL AUTO_INCREMENT,
3 `name` VARCHAR(255) NOT NULL,
4 `description` TEXT NOT NULL,
5 `date_upd` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
6 `date_add` DATETIME NOT NULL,
7 PRIMARY KEY (`category_id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19;