mysql 操作记录

CREATE DATABASE IF NOT EXISTS ice
CHARACTER SET 'utf8mb4' 
COLLATE 'utf8mb4_general_ci';
USE ice;

use ice;
/*禁用外键检查*/
SET FOREIGN_KEY_CHECKS = 0;

/* 建立用户表 */
DROP TABLE
IF EXISTS t_user;

CREATE TABLE t_user (
    guid CHAR (100) NOT NULL COMMENT '用户guid',
    id BIGINT NOT NULL UNIQUE COMMENT '数字id',
    userCode CHAR (100) NULL DEFAULT '' UNIQUE COMMENT '自定义编码',
    account VARCHAR (200) NOT NULL COMMENT '账号',
    userPassword VARCHAR (200) NOT NULL COMMENT '密码',
    salt VARCHAR (200) NOT NULL COMMENT 'salt 值',
    nickName VARCHAR (200) NOT NULL COMMENT '昵称',
    userStatus CHAR (20) NOT NULL DEFAULT 'active' COMMENT '用户状态,active(激活),logoff(注销)',
    isDeleted bit NOT NULL DEFAULT 0 COMMENT '是否删除',
    createTime datetime NOT NULL COMMENT '创建时间',
    creatorGuid CHAR (100) NOT NULL COMMENT '创建人 guid',
    updateTime datetime NOT NULL COMMENT '更新时间',
    updatorGuid CHAR (100) NOT NULL COMMENT '更新人 guid',
    PRIMARY KEY (guid)
);

/*用户数据*/
INSERT INTO `t_user` (`guid`, `id`, `userCode`, `account`, `userPassword`, `salt`, `nickName`, `userStatus`, `isDeleted`, `createTime`, `creatorGuid`, `updateTime`, `updatorGuid`) VALUES ('00000000-00FF-0000-0000-00000000A000', 0, 'U0', 'root', 'pwd123', '0', 'Root', 'active', '\0', '2000-1-1 00:00:00', '00000000-00FF-0000-0000-00000000A000', '2000-1-1 00:00:00', '00000000-00FF-0000-0000-00000000A000');
INSERT INTO `t_user` (`guid`, `id`, `userCode`, `account`, `userPassword`, `salt`, `nickName`, `userStatus`, `isDeleted`, `createTime`, `creatorGuid`, `updateTime`, `updatorGuid`) VALUES ('00000000-00FF-0000-0000-00000000A001', 1, 'U1', 'admin', 'pwd123', '0', 'Administrator', 'active', '\0', '2000-1-1 00:00:00', '00000000-00FF-0000-0000-00000000A000', '2000-1-1 00:00:00', '00000000-00FF-0000-0000-00000000A000');