CREATE TABLE `emp1` (
    `empid` SMALLINT(10) NOT NULL,
    `gender` CHAR(1) NULL,
    `birthdate` DATETIME NOT NULL,
    `name` CHAR(15) NOT NULL,
    `teamid` SMALLINT(15) NULL,
    PRIMARY KEY (`empid`),
    INDEX `teamid` (`teamid`)
)
COMMENT='table created by me 2'
COLLATE='utf8_polish_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT