| 123456789101112 |
- CREATE TABLE
- IF NOT EXISTS t_user (
- id INT NOT NULL auto_increment COMMENT '主键',
- code VARCHAR(20) NOT NULL COMMENT '用户编码',
- enuu INT(11) NOT NULL COMMENT 'enuu',
- password VARCHAR(255) NOT NULL COMMENT '用户密码',
- useruu INT(11) NOT NULL COMMENT 'useruu',
- create_time TIMESTAMP DEFAULT current_timestamp COMMENT '创建时间',
- update_time TIMESTAMP DEFAULT current_timestamp ON UPDATE current_timestamp COMMENT '修改时间',
- PRIMARY KEY (id),
- UNIQUE KEY UK_code (code)
- ) ENGINE = INNODB auto_increment = 1 DEFAULT charset = utf8 COMMENT '允许访问用户信息表';
|
