resource-sharing-lc/lcsharing.sql

/*
 Navicat Premium Data Transfer

 Source Server         : PG
 Source Server Type    : PostgreSQL
 Source Server Version : 150002 (150002)
 Source Host           : localhost:5432
 Source Catalog        : lcsharing
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 150002 (150002)
 File Encoding         : 65001

 Date: 24/01/2024 10:23:41
*/


-- ----------------------------
-- Sequence structure for lc_interface_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."lc_interface_id_seq";
CREATE SEQUENCE "public"."lc_interface_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for lc_menu_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."lc_menu_id_seq";
CREATE SEQUENCE "public"."lc_menu_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for lc_role_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."lc_role_id_seq";
CREATE SEQUENCE "public"."lc_role_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;

-- ----------------------------
-- Table structure for lc_interface
-- ----------------------------
DROP TABLE IF EXISTS "public"."lc_interface";
CREATE TABLE "public"."lc_interface" (
  "id" int4 NOT NULL DEFAULT nextval('lc_interface_id_seq'::regclass),
  "interface_name" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "resource" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "role_ids" varchar(30) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "request_method" varchar(6) COLLATE "pg_catalog"."default" DEFAULT 'GET'::character varying
)
;
COMMENT ON COLUMN "public"."lc_interface"."role_ids" IS '冗余字段，用于存储此接口那个角色可以访问';
COMMENT ON COLUMN "public"."lc_interface"."request_method" IS '请求方式';
COMMENT ON TABLE "public"."lc_interface" IS '接口表，主要用于控制后端接口权限';

-- ----------------------------
-- Records of lc_interface
-- ----------------------------
INSERT INTO "public"."lc_interface" VALUES (1, '保存人员', '/person', '2', NULL, NULL, 'POST');
INSERT INTO "public"."lc_interface" VALUES (2, '人员列表', '/person', '2', NULL, NULL, 'GET');

-- ----------------------------
-- Table structure for lc_menu
-- ----------------------------
DROP TABLE IF EXISTS "public"."lc_menu";
CREATE TABLE "public"."lc_menu" (
  "id" int4 NOT NULL DEFAULT nextval('lc_menu_id_seq'::regclass),
  "menu_name" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "resource" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "parent" int4 DEFAULT 0
)
;
COMMENT ON COLUMN "public"."lc_menu"."parent" IS '关联父菜单';
COMMENT ON TABLE "public"."lc_menu" IS '菜单表，主要用于控制前端列表权限';

-- ----------------------------
-- Records of lc_menu
-- ----------------------------
INSERT INTO "public"."lc_menu" VALUES (1, '人员列表', '/person', '2023-07-20 10:26:57', NULL, 0);
INSERT INTO "public"."lc_menu" VALUES (2, 'a', '/a', NULL, NULL, 1);
INSERT INTO "public"."lc_menu" VALUES (3, 'b', '/b', '2023-07-22 10:49:59', NULL, 0);
INSERT INTO "public"."lc_menu" VALUES (4, 'c', '/c', NULL, NULL, 3);
INSERT INTO "public"."lc_menu" VALUES (5, 'd', '/d', NULL, NULL, 3);
INSERT INTO "public"."lc_menu" VALUES (6, 'e', '/e', NULL, NULL, 5);

-- ----------------------------
-- Table structure for lc_person
-- ----------------------------
DROP TABLE IF EXISTS "public"."lc_person";
CREATE TABLE "public"."lc_person" (
  "id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "username" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "email" varchar(25) COLLATE "pg_catalog"."default" NOT NULL,
  "password" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "enable" int2 NOT NULL DEFAULT 1,
  "status" int2 NOT NULL DEFAULT 0,
  "ip" char(12) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "role_id" int4 NOT NULL DEFAULT 1,
  "salt" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
  "is_del" int2 NOT NULL DEFAULT 0,
  "update_name" varchar(16) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."lc_person"."enable" IS '是否启用';
COMMENT ON COLUMN "public"."lc_person"."status" IS '状态，0为注册了但是未通过邮箱验证，1表示正常';
COMMENT ON COLUMN "public"."lc_person"."role_id" IS '外键，角色id';
COMMENT ON COLUMN "public"."lc_person"."salt" IS '盐';
COMMENT ON COLUMN "public"."lc_person"."is_del" IS '0未删除，1删除';
COMMENT ON COLUMN "public"."lc_person"."update_name" IS '修改人';
COMMENT ON TABLE "public"."lc_person" IS '账户表';

-- ----------------------------
-- Records of lc_person
-- ----------------------------
INSERT INTO "public"."lc_person" VALUES ('1680197396198248449', 'zB88NObo', '780771603@qq.com', 'b9d7c1c558b959b888f9187bfd6f78a1', 1, 0, '127.0.0.1   ', '2023-07-15 20:47:30.472188', NULL, 1, '88323f7283bbdbce299a9c78cac6edfd', 0, NULL);
INSERT INTO "public"."lc_person" VALUES ('1', 'ty', '2879823308@qq.com', '902ef683c3f1726f1093275dfd1b3dd8', 1, 0, '127.0.0.1   ', '2023-07-13 16:24:38', NULL, 2, '93c174669ddb620b4808a97fcb32949e', 0, NULL);

-- ----------------------------
-- Table structure for lc_role
-- ----------------------------
DROP TABLE IF EXISTS "public"."lc_role";
CREATE TABLE "public"."lc_role" (
  "id" int4 NOT NULL DEFAULT nextval('lc_role_id_seq'::regclass),
  "role_name" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "menu_id" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "interface_id" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "create_time" timestamp(6),
  "update_time" timestamp(6),
  "role_name_str" varchar(16) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."lc_role"."role_name_str" IS '中文，展示用';
COMMENT ON TABLE "public"."lc_role" IS '角色表';

-- ----------------------------
-- Records of lc_role
-- ----------------------------
INSERT INTO "public"."lc_role" VALUES (1, 'user', '1,2', '1', '2023-07-19 17:43:03', '2023-07-19 17:43:06', '用户');
INSERT INTO "public"."lc_role" VALUES (2, 'admin', '2', '1,2', NULL, NULL, '管理员');

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."lc_interface_id_seq"
OWNED BY "public"."lc_interface"."id";
SELECT setval('"public"."lc_interface_id_seq"', 1, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."lc_menu_id_seq"
OWNED BY "public"."lc_menu"."id";
SELECT setval('"public"."lc_menu_id_seq"', 1, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."lc_role_id_seq"
OWNED BY "public"."lc_role"."id";
SELECT setval('"public"."lc_role_id_seq"', 1, false);

-- ----------------------------
-- Primary Key structure for table lc_interface
-- ----------------------------
ALTER TABLE "public"."lc_interface" ADD CONSTRAINT "lc_interface_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table lc_menu
-- ----------------------------
ALTER TABLE "public"."lc_menu" ADD CONSTRAINT "lc_menu_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table lc_person
-- ----------------------------
ALTER TABLE "public"."lc_person" ADD CONSTRAINT "lc_person_pkey" PRIMARY KEY ("id");

-- ----------------------------
-- Primary Key structure for table lc_role
-- ----------------------------
ALTER TABLE "public"."lc_role" ADD CONSTRAINT "lc_role_pkey" PRIMARY KEY ("id");