开发环境建设.md 3.5 KB

开发环境建设

  • docker启动数据库和redis

    # 数据库
    docker run -d --restart=always --name=postgres -p 5432:5432 -e POSTGRES_PASSWORD=fantuan1985 -v /home/lfq/Documents/docker/postgresql:/var/lib/postgresql/data --privileged postgres
    
    # redis
    docker run --name=redis --restart=always -p 6379:6379 -d redis
    
  • 引入数据

    -- 创建模式
    create schema sqmdb_rpt;
    -- 创建acl_user表
    CREATE TABLE sqmdb_rpt.acl_user (
    	user_id serial4 NOT NULL,
    	login_name varchar NULL,
    	user_name varchar NULL,
    	phone varchar NULL,
    	email varchar NULL,
    	city_id int4 NULL,
    	area_id int4 NULL,
    	province_id int4 NULL,
    	org varchar NULL,
    	CONSTRAINT user_pk PRIMARY KEY (user_id)
    );
    -- 创建acl_user_role_city表
    CREATE TABLE sqmdb_rpt.acl_user_role_city (
    	id serial4 NOT NULL,
    	user_id int4 NOT NULL,
    	role_id int4 NOT NULL,
    	city_id int4 NOT NULL,
    	CONSTRAINT user_role_city_pk PRIMARY KEY (id)
    );
    -- 创建acl_area表
    CREATE TABLE sqmdb_rpt.acl_area (
    	area_id int4 NOT NULL,
    	area_name varchar NOT NULL,
    	area_type varchar NOT NULL,
    	type_code int4 NOT NULL,
    	parent_id int4 NULL
    );
    -- 创建acl_role表
    CREATE TABLE sqmdb_rpt.acl_role (
    	role_id serial4 NOT NULL,
    	role_name varchar NULL,
    	"system" varchar NULL,
    	CONSTRAINT role_pk PRIMARY KEY (role_id)
    );
    -- sqmdb_rpt.acl_function definition
    
    -- Drop table
    
    -- DROP TABLE sqmdb_rpt.acl_function;
    
    CREATE TABLE sqmdb_rpt.acl_function (
    	id int4 NOT NULL, -- 主键
    	"name" varchar NOT NULL, -- 功能名称
    	url varchar NOT NULL, -- 功能链接
    	client int4 NOT NULL, -- 展示的客户端
    	CONSTRAINT acl_app_function_pk PRIMARY KEY (id)
    );
    COMMENT ON TABLE sqmdb_rpt.acl_function IS '功能';
    
    -- Column comments
    
    COMMENT ON COLUMN sqmdb_rpt.acl_function.id IS '主键';
    COMMENT ON COLUMN sqmdb_rpt.acl_function."name" IS '功能名称';
    COMMENT ON COLUMN sqmdb_rpt.acl_function.url IS '功能链接';
    COMMENT ON COLUMN sqmdb_rpt.acl_function.client IS '展示的客户端';
    -- sqmdb_rpt.acl__user_function definition
    
    -- Drop table
    
    -- DROP TABLE sqmdb_rpt.acl__user_function;
    
    CREATE TABLE sqmdb_rpt.acl__user_function (
    	user_id int4 NOT NULL, -- 用户id
    	function_id int4 NOT NULL, -- 功能id
    	CONSTRAINT acl_app_user_function_pk PRIMARY KEY (user_id, function_id)
    );
    COMMENT ON TABLE sqmdb_rpt.acl__user_function IS '用户功能关联';
    
    -- Column comments
    
    COMMENT ON COLUMN sqmdb_rpt.acl__user_function.user_id IS '用户id';
    COMMENT ON COLUMN sqmdb_rpt.acl__user_function.function_id IS '功能id';
        
    -- sqmdb_rpt.acl_verification_log definition
    
    -- Drop table
    
    -- DROP TABLE sqmdb_rpt.acl_verification_log;
    
    CREATE TABLE sqmdb_rpt.acl_verification_log (
    	id bigserial NOT NULL, -- 主键
    	user_id int4 NOT NULL, -- 用户id
    	login_name varchar NOT NULL, -- 用户账号
    	user_name varchar NOT NULL, -- 用户姓名
    	city_id int4 NOT NULL, -- 所属地市
    	"system" varchar NOT NULL, -- 登入模块
    	login_time timestamp NOT NULL, -- 登录时间
    	CONSTRAINT acl_verification_log_pk PRIMARY KEY (id)
    );
    COMMENT ON TABLE sqmdb_rpt.acl_verification_log IS '用户登录日志';
    
    -- Column comments
    
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log.id IS '主键';
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log.user_id IS '用户id';
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log.login_name IS '用户账号';
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log.user_name IS '用户姓名';
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log.city_id IS '所属地市';
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log."system" IS '登入模块';
    COMMENT ON COLUMN sqmdb_rpt.acl_verification_log.login_time IS '登录时间';