国产化数据库创建数据表

1.人大金仓数据库创建用户表

-- 创建用户表
CREATE TABLE "user" (
    id SERIAL PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(100) NOT NULL,
    gender CHAR(1) DEFAULT 'o' NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    updated_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);

-- 创建函数用于自动更新updated_time字段
CREATE OR REPLACE FUNCTION user_updated_time()
RETURNS TRIGGER AS $$
BEGIN
    NEW.updated_time = CURRENT_TIMESTAMP;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- 创建触发器，在每次更新记录时更新updated_time字段
CREATE TRIGGER user_updated_time
BEFORE UPDATE ON "user"
FOR EACH ROW
EXECUTE FUNCTION user_updated_time();

2.达梦数据库创建用户表

-- 创建用户表
CREATE TABLE "user" (
    id INT IDENTITY(1,1) PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    "password" VARCHAR(100) NOT NULL,
    gender CHAR(1) DEFAULT 'o' NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
    updated_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
);

-- 创建触发器，在每次更新记录时更新updated_time字段
CREATE OR REPLACE TRIGGER user_updated_time 
BEFORE UPDATE ON "user" 
FOR EACH ROW
BEGIN
    :NEW.updated_time := CURRENT_TIMESTAMP;
END;