acl_tousu/doc/开发测试文档/开发环境建设/开发环境建设.md

开发环境建设

• 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)
  )