· 9 years ago · Jan 08, 2017, 11:44 PM
1CREATE TABLE IF NOT EXISTS `block`.`usern` (
2 `id` INT NOT NULL ,
3 `nm_name` VARCHAR( 100 ) NULL ,
4 `lastName` VARCHAR( 100 ) NULL ,
5 `gender` VARCHAR( 45 ) NULL ,
6 `street` VARCHAR( 45 ) NULL ,
7 `city` VARCHAR( 90 ) NULL ,
8 `state` VARCHAR( 90 ) NULL ,
9 `code` VARCHAR( 90 ) NULL ,
10 `blockid` TEXT NULL ,
11PRIMARY KEY ( `id` )
12) ENGINE = INNODB;