表更新时间字段

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

CREATE DATABASE IF NOT EXISTS `info`;

use `info`;

-- show variables like 'sql_mode';

SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_IN_DATE', '');
SET @@sql_mode := REPLACE(@@sql_mode, 'NO_ZERO_DATE', '');

CREATE TABLE IF NOT EXISTS `user` (
    `id` BIGINT(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `user_id` VARCHAR(32) NOT NULL COMMENT '用户id',
    `name` VARCHAR(32) NOT NULL COMMENT '用户名',
    `sex` TINYINT(1) NOT NULL DEFAULT -1 COMMENT '性别',
    `age` INTEGER(11) NOT NULL DEFAULT 0 COMMENT '年龄',
    `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at` TIMESTAMP NOT NULL DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    INDEX idx_userid(`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户信息';