模板:
CREATE TABLE customer
(
id BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL,
create_time DATETIME DEFAULT CURRENT_TIMESTAMP,
update_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
version INT DEFAULT 1,
deleted INT DEFAULT 0,
name VARCHAR(20) UNIQUE,
age INT
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
网友评论