· 9 years ago · Jan 08, 2017, 11:58 PM
1CREATE TABLE IF NOT EXISTS 'block'.'user' (
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,
11 PRIMARY KEY ('id'))
12ENGINE = InnoDB;