· 9 years ago · Jan 31, 2017, 12:12 AM
1CREATE TABLE IF NOT EXISTS `claritytractor`.`turno` (
2 `IDTURNO` INT(11) NOT NULL AUTO_INCREMENT,
3 `NOMBRE` VARCHAR(150) NULL DEFAULT NULL,
4 `CANTIDADHORAS` INT(11) NULL DEFAULT NULL,
5 `HORAINICIAL` DATE NULL DEFAULT NULL,
6 `COLACION` INT(11) NULL DEFAULT NULL,
7 `FECHAMODIFICACION` DATETIME NULL DEFAULT NULL,
8 `STATUS` INT(11) NULL DEFAULT NULL,
9 PRIMARY KEY (`IDTURNO`))
10ENGINE = InnoDB
11DEFAULT CHARACTER SET = latin1;
12
13INSERT INTO `claritytractor`.`turno` (`NOMBRE`, `CANTIDADHORAS`, `HORAINICIAL`, `COLACION`, `FECHAMODIFICACION`, `STATUS`) VALUES ('Normal', 8, '08:00:00', '1', '2016-12-20', '0');