meadmin.sql

-- Database export: meadmin
-- Date: 2026-09-18 19:54:18
-- Generated by DBX

CREATE TABLE "admin_role" (
  "system_admin_id" character varying(20) NOT NULL,
  "system_role_id" character varying(20) NOT NULL,
  CONSTRAINT "admin_role_pkey" PRIMARY KEY (system_admin_id, system_role_id)
);

INSERT INTO "admin_role" ("system_admin_id", "system_role_id") VALUES ('604612615536115712', '635392868638261248'), ('632899190933946368', '635419305097297920'), ('632899190933946368', '635419444721483776');

CREATE TABLE "example_book" (
  "id" character varying(20) NOT NULL,
  "name" character varying(20) NOT NULL DEFAULT ''::character varying,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  CONSTRAINT "example_book_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "example_book" IS '示例_书籍';
COMMENT ON COLUMN "example_book"."name" IS '名称';
COMMENT ON COLUMN "example_book"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "example_book"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "example_book"."created_at" IS '创建时间';
COMMENT ON COLUMN "example_book"."updated_at" IS '最后更新时间';

INSERT INTO "example_book" ("id", "name", "created_admin_id", "updated_admin_id", "created_at", "updated_at") VALUES ('1', '平凡的世界', '604612615536115712', '604612615536115712', '2026-01-08 15:16:13+08:00', '2026-01-08 15:16:17+08:00'), ('2', '钢铁是怎样练成的', '604612615536115712', '604612615536115712', '2026-01-08 15:17:01+08:00', '2026-01-08 15:17:04+08:00'), ('3', '基督山伯爵', '604612615536115712', '604612615536115712', '2026-01-08 15:17:23+08:00', '2026-01-08 15:17:26+08:00'), ('4', '西游记', '604612615536115712', '604612615536115712', '2026-01-08 15:17:44+08:00', '2026-01-08 15:17:47+08:00'), ('5', '水浒传', '604612615536115712', '604612615536115712', '2026-01-08 15:18:07+08:00', '2026-01-08 15:18:09+08:00'), ('6', '红楼梦', '604612615536115712', '604612615536115712', '2026-01-08 15:18:28+08:00', '2026-01-08 15:18:30+08:00'), ('7', '三国演绎', '604612615536115712', '604612615536115712', '2026-01-08 15:18:48+08:00', '2026-01-08 15:18:51+08:00');

CREATE TABLE "example_demo" (
  "id" character varying(20) NOT NULL,
  "name" character varying(20) NOT NULL DEFAULT ''::character varying,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "mobile" character varying(11),
  "type" smallint NOT NULL DEFAULT 0,
  "user_id" character varying(20),
  "avatar_file_id" character varying(20),
  "deleted_at" timestamp(6) with time zone,
  CONSTRAINT "example_demo_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "example_demo" IS '示例_Demo';
COMMENT ON COLUMN "example_demo"."name" IS '名称';
COMMENT ON COLUMN "example_demo"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "example_demo"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "example_demo"."created_at" IS '创建时间';
COMMENT ON COLUMN "example_demo"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "example_demo"."mobile" IS '手机号';
COMMENT ON COLUMN "example_demo"."type" IS '类型:0=书籍;1=电子产品;2=卡片';
COMMENT ON COLUMN "example_demo"."user_id" IS '关联前台用户id';
COMMENT ON COLUMN "example_demo"."avatar_file_id" IS '头像附件id';
COMMENT ON COLUMN "example_demo"."deleted_at" IS '删除时间';
CREATE UNIQUE INDEX "example_demo_mobile_unique" ON "example_demo" USING btree ("mobile") WHERE (NOT (deleted_at IS NULL));

INSERT INTO "example_demo" ("id", "name", "created_admin_id", "updated_admin_id", "created_at", "updated_at", "mobile", "type", "user_id", "avatar_file_id", "deleted_at") VALUES ('664043217833951232', '测试', '604612615536115712', '604612615536115712', '2026-01-07 17:50:40.459+08:00', '2026-01-08 20:53:13.587+08:00', '13333333333', '0', '657558079876890624', '646151944066301952', NULL);

CREATE TABLE "example_demo_books" (
  "example_book_id" character varying(20) NOT NULL,
  "example_demo_id" character varying(20) NOT NULL,
  CONSTRAINT "example_demo_books_pkey" PRIMARY KEY (example_book_id, example_demo_id)
);

INSERT INTO "example_demo_books" ("example_book_id", "example_demo_id") VALUES ('1', '664043217833951232');

CREATE TABLE "example_demo_files" (
  "file_id" character varying(20) NOT NULL,
  "example_demo_id" character varying(20) NOT NULL,
  CONSTRAINT "example_demo_files_pkey" PRIMARY KEY (file_id, example_demo_id)
);

INSERT INTO "example_demo_files" ("file_id", "example_demo_id") VALUES ('639448903602667520', '664043217833951232'), ('644498186374742016', '664043217833951232'), ('640524238482046976', '664043217833951232'), ('646269163429429248', '664043217833951232'), ('646155434071162880', '664043217833951232'), ('639466180326719488', '664043217833951232'), ('664481511247970304', '664043217833951232');

CREATE TABLE "file" (
  "id" character varying(20) NOT NULL,
  "name" character varying(300) NOT NULL DEFAULT ''::character varying,
  "mime_type" character varying(50) NOT NULL DEFAULT ''::character varying,
  "size" integer,
  "storage" character varying(50) NOT NULL DEFAULT 'storage'::character varying,
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "path" character varying(200) NOT NULL DEFAULT ''::character varying,
  "md5" character varying(32) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT "file_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "file" IS '附件表';
COMMENT ON COLUMN "file"."name" IS '文件名';
COMMENT ON COLUMN "file"."mime_type" IS 'mime类型';
COMMENT ON COLUMN "file"."size" IS '文件大小(b)';
COMMENT ON COLUMN "file"."storage" IS '存储引擎';
COMMENT ON COLUMN "file"."created_at" IS '创建时间';
COMMENT ON COLUMN "file"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "file"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "file"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "file"."path" IS '路径';
COMMENT ON COLUMN "file"."md5" IS '文件MD5值';

INSERT INTO "file" ("id", "name", "mime_type", "size", "storage", "created_at", "updated_at", "created_admin_id", "updated_admin_id", "path", "md5") VALUES ('694716253889101824', '973093c9-1fd1-4969-8448-6043090de4e9.png', 'image/png', '167404', 'local', '2026-04-02 09:14:22.131+08:00', '2026-04-02 09:14:22.131+08:00', '604612615536115712', '604612615536115712', 'b51e6a53459859d203041f8c0dffcd92.png', 'b51e6a53459859d203041f8c0dffcd92'), ('694720410150764544', '973093c9-1fd1-4969-8448-6043090de4e9.png', 'image/png', '167404', 'local', '2026-04-02 09:30:53.061+08:00', '2026-04-02 09:30:53.061+08:00', '604612615536115712', '604612615536115712', 'b51e6a53459859d203041f8c0dffcd92.png', 'b51e6a53459859d203041f8c0dffcd92'), ('694721036209356800', '973093c9-1fd1-4969-8448-6043090de4e9.png', 'image/png', '167404', 'local', '2026-04-02 09:33:22.326+08:00', '2026-04-02 09:33:22.326+08:00', '604612615536115712', '604612615536115712', 'b51e6a53459859d203041f8c0dffcd92.png', 'b51e6a53459859d203041f8c0dffcd92'), ('694721432378146816', '973093c9-1fd1-4969-8448-6043090de4e9.png', 'image/png', '167404', 'local', '2026-04-02 09:34:56.78+08:00', '2026-04-02 09:34:56.78+08:00', '604612615536115712', '604612615536115712', 'b51e6a53459859d203041f8c0dffcd92.png', 'b51e6a53459859d203041f8c0dffcd92'), ('693988309440921600', 'image.png', 'image/png', '39008', 'local', '2026-03-31 17:01:46.65+08:00', '2026-03-31 17:01:46.65+08:00', '604612615536115712', '604612615536115712', '3832e40249f4eb6c4feca1c257718907.png', '3832e40249f4eb6c4feca1c257718907'), ('694058309212176384', 'image.png', 'image/png', '91238', 'local', '2026-03-31 21:39:55.897+08:00', '2026-03-31 21:39:55.897+08:00', '604612615536115712', '604612615536115712', 'e27aae898e9bd0f8f1706246c1e6f372.png', 'e27aae898e9bd0f8f1706246c1e6f372'), ('694058854975012864', 'image.png', 'image/png', '91238', 'local', '2026-03-31 21:42:06.016+08:00', '2026-03-31 21:42:06.016+08:00', '604612615536115712', '604612615536115712', 'e27aae898e9bd0f8f1706246c1e6f372.png', 'e27aae898e9bd0f8f1706246c1e6f372'), ('694066691864264704', '82af4fb1-7049-491b-b346-78a73dd26d77.png', 'image/png', '66346', 'local', '2026-03-31 22:13:14.476+08:00', '2026-03-31 22:13:14.476+08:00', '604612615536115712', '604612615536115712', 'dac00cfc094a2b9acefeb67be311e1f5.png', 'dac00cfc094a2b9acefeb67be311e1f5'), ('755738869244100608', 'logo.png', 'image/png', '2483', 'local', '2026-09-17 18:36:27.377+08:00', '2026-09-17 18:36:27.377+08:00', '604612615536115712', '604612615536115712', 'cdfa039cf2cc04b2d9fbfabbb485bd72.png', 'cdfa039cf2cc04b2d9fbfabbb485bd72'), ('755975999350374400', 'A_minimalist_flat_illustration_2026-09-18T02-17-25.png', 'image/png', '442831', 'local', '2026-09-18 10:18:43.601+08:00', '2026-09-18 10:18:43.601+08:00', '604612615536115712', '604612615536115712', 'b0faa183985a2a91a49fbdf94091b4cd.png', 'b0faa183985a2a91a49fbdf94091b4cd');

CREATE TABLE "job" (
  "id" character varying(20) NOT NULL,
  "name" character varying(50) NOT NULL DEFAULT ''::character varying,
  "strategy" smallint NOT NULL DEFAULT 1,
  "delay" bigint DEFAULT 0,
  "cron" character varying(200) DEFAULT ''::character varying,
  "deduplication" smallint NOT NULL DEFAULT 1,
  "job_id" character varying(100) NOT NULL,
  "progress" double precision,
  "type" smallint NOT NULL DEFAULT 1,
  "sql" text NOT NULL DEFAULT ''::text,
  "url" character varying(200) NOT NULL DEFAULT ''::character varying,
  "method" character varying(10) NOT NULL DEFAULT ''::character varying,
  "headers" text NOT NULL DEFAULT ''::text,
  "body" text NOT NULL DEFAULT ''::text,
  "query" text NOT NULL DEFAULT ''::text,
  "queue_name" character varying(200) NOT NULL DEFAULT ''::character varying,
  "queue_options" text NOT NULL DEFAULT ''::text,
  "status" character varying(20),
  "result" jsonb NOT NULL DEFAULT '[]'::jsonb,
  "sucessed_num" bigint NOT NULL DEFAULT 0,
  "failed_num" bigint NOT NULL DEFAULT 0,
  "failed_response" jsonb NOT NULL DEFAULT '[]'::jsonb,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  CONSTRAINT "job_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "job" IS '任务表';
COMMENT ON COLUMN "job"."name" IS '任务名称';
COMMENT ON COLUMN "job"."strategy" IS '执行策略:1=立即执行;2=延时执行;3=定时执行;4=放弃执行';
COMMENT ON COLUMN "job"."delay" IS '延时时间(ms)';
COMMENT ON COLUMN "job"."cron" IS '定时表达式(cron)';
COMMENT ON COLUMN "job"."deduplication" IS '去重策略:1=可重复;2=去重;3=覆盖';
COMMENT ON COLUMN "job"."progress" IS '任务进度';
COMMENT ON COLUMN "job"."type" IS '任务类型:1=sql;2=url请求;3=自定义';
COMMENT ON COLUMN "job"."sql" IS 'sql语句';
COMMENT ON COLUMN "job"."url" IS 'url请求地址';
COMMENT ON COLUMN "job"."method" IS '请求方法';
COMMENT ON COLUMN "job"."headers" IS '请求头';
COMMENT ON COLUMN "job"."body" IS 'POST请求体(json格式)';
COMMENT ON COLUMN "job"."query" IS 'GET参数(json格式)';
COMMENT ON COLUMN "job"."queue_name" IS '自定义任务处理器';
COMMENT ON COLUMN "job"."queue_options" IS '自定义任务处理器参数(json格式)';
COMMENT ON COLUMN "job"."status" IS '任务状态:active=执行中;completed=已完成;failed=失败;waiting=等待中';
COMMENT ON COLUMN "job"."result" IS '任务执行结果';
COMMENT ON COLUMN "job"."sucessed_num" IS '任务执行成功数';
COMMENT ON COLUMN "job"."failed_num" IS '任务执行失败数';
COMMENT ON COLUMN "job"."failed_response" IS '任务执行失败响应';
COMMENT ON COLUMN "job"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "job"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "job"."created_at" IS '创建时间';
COMMENT ON COLUMN "job"."updated_at" IS '最后更新时间';
CREATE UNIQUE INDEX "job_name_unique" ON "job" USING btree ("name");

INSERT INTO "job" ("id", "name", "strategy", "delay", "cron", "deduplication", "job_id", "progress", "type", "sql", "url", "method", "headers", "body", "query", "queue_name", "queue_options", "status", "result", "sucessed_num", "failed_num", "failed_response", "created_admin_id", "updated_admin_id", "created_at", "updated_at") VALUES ('748740617445572608', '测试分开执行', '4', '0', '*/10 * * * * *', '1', 'repeat:scheduler-测试分开执行:1789129140000', '100', '1', 'select count(*) from user', '', '', '', '', '', '', '', 'completed', E'["{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1787975370000\\",\\"time\\":\\"2026-08-29 11:50:08.647\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1787975410000\\",\\"time\\":\\"2026-08-29 11:50:10.157\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1787975420000\\",\\"time\\":\\"2026-09-11 20:11:34.921\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128700000\\",\\"time\\":\\"2026-09-11 20:11:40.101\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128710000\\",\\"time\\":\\"2026-09-11 20:11:50.136\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128720000\\",\\"time\\":\\"2026-09-11 20:12:00.187\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128730000\\",\\"time\\":\\"2026-09-11 20:12:10.100\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128740000\\",\\"time\\":\\"2026-09-11 20:12:20.137\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128750000\\",\\"time\\":\\"2026-09-11 20:12:30.074\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128760000\\",\\"time\\":\\"2026-09-11 20:12:40.108\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128770000\\",\\"time\\":\\"2026-09-11 20:12:50.145\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128780000\\",\\"time\\":\\"2026-09-11 20:13:00.081\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128790000\\",\\"time\\":\\"2026-09-11 20:13:10.113\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128800000\\",\\"time\\":\\"2026-09-11 20:13:20.149\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128810000\\",\\"time\\":\\"2026-09-11 20:13:30.083\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128820000\\",\\"time\\":\\"2026-09-11 20:13:40.120\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128830000\\",\\"time\\":\\"2026-09-11 20:13:50.154\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128840000\\",\\"time\\":\\"2026-09-11 20:14:00.090\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128850000\\",\\"time\\":\\"2026-09-11 20:14:10.124\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128860000\\",\\"time\\":\\"2026-09-11 20:14:20.158\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128870000\\",\\"time\\":\\"2026-09-11 20:14:30.096\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128880000\\",\\"time\\":\\"2026-09-11 20:14:40.131\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128890000\\",\\"time\\":\\"2026-09-11 20:14:50.166\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128900000\\",\\"time\\":\\"2026-09-11 20:15:00.100\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128910000\\",\\"time\\":\\"2026-09-11 20:15:10.138\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128920000\\",\\"time\\":\\"2026-09-11 20:15:20.084\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128930000\\",\\"time\\":\\"2026-09-11 20:15:30.109\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128940000\\",\\"time\\":\\"2026-09-11 20:15:40.164\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128950000\\",\\"time\\":\\"2026-09-11 20:15:50.079\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128960000\\",\\"time\\":\\"2026-09-11 20:16:00.116\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128970000\\",\\"time\\":\\"2026-09-11 20:16:10.150\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128980000\\",\\"time\\":\\"2026-09-11 20:16:20.086\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789128990000\\",\\"time\\":\\"2026-09-11 20:16:30.121\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129000000\\",\\"time\\":\\"2026-09-11 20:16:40.155\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129010000\\",\\"time\\":\\"2026-09-11 20:16:50.092\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129020000\\",\\"time\\":\\"2026-09-11 20:17:00.126\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129030000\\",\\"time\\":\\"2026-09-11 20:17:10.164\\"}", "{\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129040000\\",\\"time\\":\\"2026-09-11 20:17:30.717\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129060000\\",\\"time\\":\\"2026-09-11 20:17:44.496\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129070000\\",\\"time\\":\\"2026-09-11 20:18:06.273\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129090000\\",\\"time\\":\\"2026-09-11 20:18:10.642\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129100000\\",\\"time\\":\\"2026-09-11 20:18:20.117\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129110000\\",\\"time\\":\\"2026-09-11 20:18:30.165\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129120000\\",\\"time\\":\\"2026-09-11 20:18:40.091\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129130000\\",\\"time\\":\\"2026-09-11 20:18:50.119\\"}", "{\\"result\\":[[{\\"count\\":\\"1\\"}],{\\"command\\":\\"SELECT\\",\\"rowCount\\":1,\\"oid\\":null,\\"rows\\":[{\\"count\\":\\"1\\"}],\\"fields\\":[{\\"name\\":\\"count\\",\\"tableID\\":0,\\"columnID\\":0,\\"dataTypeID\\":20,\\"dataTypeSize\\":8,\\"dataTypeModifier\\":-1,\\"format\\":\\"text\\"}],\\"_parsers\\":[null],\\"_types\\":{\\"_types\\":{},\\"text\\":{},\\"binary\\":{}},\\"RowCtor\\":null,\\"rowAsArray\\":false,\\"_prebuiltEmptyResultObject\\":{\\"count\\":null}}],\\"jobId\\":\\"repeat:scheduler-测试分开执行:1789129140000\\",\\"time\\":\\"2026-09-11 20:19:00.158\\"}"]', '46', '0', '[]', '604612615536115712', '604612615536115712', '2026-08-29 11:07:54.128+08:00', '2026-09-11 20:19:06.617+08:00');

CREATE TABLE "organization_admin" (
  "system_admin_id" character varying(20) NOT NULL,
  "system_organization_id" character varying(20) NOT NULL,
  CONSTRAINT "organization_admin_pkey" PRIMARY KEY (system_admin_id, system_organization_id)
);

INSERT INTO "organization_admin" ("system_admin_id", "system_organization_id") VALUES ('604612615536115712', '740174696351268864'), ('632899190933946368', '740175409059987456'), ('632899190933946368', '740176007411007488'), ('604612615536115712', '740175409059987456');

CREATE TABLE "role_menu" (
  "system_menu_id" character varying(20) NOT NULL,
  "system_role_id" character varying(20) NOT NULL,
  CONSTRAINT "role_menu_pkey" PRIMARY KEY (system_menu_id, system_role_id)
);

INSERT INTO "role_menu" ("system_menu_id", "system_role_id") VALUES ('701403170512830464', '635419154098159616'), ('658270533162369024', '635419154098159616'), ('719446779690483712', '635419154098159616'), ('701403170512830464', '635419305097297920'), ('658270533162369024', '635419305097297920'), ('664799640041816064', '635419305097297920'), ('664802471784218624', '635419305097297920'), ('664033966046576640', '635419305097297920'), ('664033966474395648', '635419305097297920'), ('664033966889631744', '635419305097297920'), ('664033967292284928', '635419305097297920'), ('664033967724298240', '635419305097297920'), ('664033968131145728', '635419305097297920'), ('742297138695766016', '635419305097297920'), ('2', '635419305097297920'), ('664798918835437568', '635419305097297920'), ('3', '635419305097297920'), ('1', '635419305097297920'), ('639418081101217792', '635419305097297920'), ('664816340996980736', '635419305097297920'), ('664033965581008896', '635419305097297920'), ('742297136913186816', '635419305097297920'), ('719446779690483712', '635419305097297920'), ('719446778558021632', '635419305097297920'), ('754242324053098496', '635419305097297920'), ('753838055642628096', '635424437604188160'), ('664033965581008896', '635424437604188160');

CREATE TABLE "system_admin" (
  "id" character varying(20) NOT NULL,
  "username" character varying(50) NOT NULL DEFAULT ''::character varying,
  "nickname" character varying(20) NOT NULL DEFAULT ''::character varying,
  "password" character varying(64) NOT NULL DEFAULT ''::character varying,
  "salt" character varying(32) NOT NULL DEFAULT ''::character varying,
  "email" character varying(100),
  "mobile" character varying(11),
  "login_failure" smallint NOT NULL DEFAULT 0,
  "last_login_at" timestamp with time zone,
  "last_login_ip" character varying(50) NOT NULL DEFAULT ''::character varying,
  "status" smallint NOT NULL DEFAULT 1,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "deleted_at" timestamp(6) with time zone,
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "avatar_file_id" character varying(20),
  CONSTRAINT "system_admin_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "system_admin" IS '管理员表';
COMMENT ON COLUMN "system_admin"."username" IS '用户名';
COMMENT ON COLUMN "system_admin"."nickname" IS '昵称';
COMMENT ON COLUMN "system_admin"."password" IS '密码';
COMMENT ON COLUMN "system_admin"."salt" IS '密码盐';
COMMENT ON COLUMN "system_admin"."email" IS '邮箱';
COMMENT ON COLUMN "system_admin"."mobile" IS '手机号';
COMMENT ON COLUMN "system_admin"."login_failure" IS '登录失败次数';
COMMENT ON COLUMN "system_admin"."last_login_at" IS '登录时间';
COMMENT ON COLUMN "system_admin"."last_login_ip" IS '登录ip';
COMMENT ON COLUMN "system_admin"."status" IS '状态:1=启用;0=禁用';
COMMENT ON COLUMN "system_admin"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "system_admin"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "system_admin"."deleted_at" IS '删除时间';
COMMENT ON COLUMN "system_admin"."created_at" IS '创建时间';
COMMENT ON COLUMN "system_admin"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "system_admin"."avatar_file_id" IS '头像附件id';
CREATE UNIQUE INDEX "system_admin_email_unique" ON "system_admin" USING btree ("email") WHERE (deleted_at IS NOT NULL);
CREATE UNIQUE INDEX "system_admin_mobile_unique" ON "system_admin" USING btree ("mobile") WHERE (deleted_at IS NOT NULL);
CREATE UNIQUE INDEX "system_admin_username_unique" ON "system_admin" USING btree ("username") WHERE (deleted_at IS NOT NULL);

INSERT INTO "system_admin" ("id", "username", "nickname", "password", "salt", "email", "mobile", "login_failure", "last_login_at", "last_login_ip", "status", "created_admin_id", "updated_admin_id", "deleted_at", "created_at", "updated_at", "avatar_file_id") VALUES ('632899190933946368', 'Test', 'test', 'f7e1c73f94a6443bea4b7b02c50958ab2ba0bfce22b33d29df0f8e978678f2dc', 'b1aa1d58153e0eb912caa2be930ccb59', NULL, '15555555555', '0', '2026-09-13 15:33:59.68+08:00', '::ffff:127.0.0.1', '1', '604612615536115712', '604612615536115712', NULL, '2025-10-13 19:15:25.818+08:00', '2026-09-17 18:36:48.146+08:00', NULL), ('604612615536115712', 'admin', 'Admin', 'e8e51c59da6333bce7a443efc3e8e2e792ac6b5592a70523a16b074ba1dcc3c0', 'd06d09e00fbb3ed98f6ce1f004be912c', 'admin@outlock.com', '13333333333', '0', '2026-09-18 16:20:41.01+08:00', '::ffff:127.0.0.1', '1', '604612615536115712', '604612615536115712', NULL, '2025-07-27 17:54:40.704+08:00', '2026-09-18 17:04:49.048+08:00', NULL);

CREATE TABLE "system_config" (
  "id" character varying(20) NOT NULL,
  "variable_type" character varying(20) NOT NULL DEFAULT 'string'::character varying,
  "variable_title" character varying(100) NOT NULL DEFAULT ''::character varying,
  "is_builtin" boolean NOT NULL DEFAULT false,
  "group_id" character varying(20) NOT NULL,
  "value" text,
  "options" jsonb NOT NULL DEFAULT '[]'::jsonb,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "sort_order" integer NOT NULL DEFAULT 100,
  "is_required" boolean NOT NULL DEFAULT false,
  "status" integer NOT NULL DEFAULT 1,
  "description" text NOT NULL DEFAULT ''::text,
  "variable_code" character varying(100) NOT NULL DEFAULT ''::character varying,
  CONSTRAINT "system_config_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "system_config" IS '系统配置项表';
COMMENT ON COLUMN "system_config"."variable_type" IS '变量类型';
COMMENT ON COLUMN "system_config"."variable_title" IS '变量标题';
COMMENT ON COLUMN "system_config"."is_builtin" IS '是否内置';
COMMENT ON COLUMN "system_config"."group_id" IS '分组ID';
COMMENT ON COLUMN "system_config"."value" IS '配置值';
COMMENT ON COLUMN "system_config"."options" IS '字典选项';
COMMENT ON COLUMN "system_config"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "system_config"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "system_config"."created_at" IS '创建时间';
COMMENT ON COLUMN "system_config"."updated_at" IS '最后更新时间';
CREATE INDEX "system_config_group_id_idx" ON "system_config" USING btree ("group_id");

INSERT INTO "system_config" ("id", "variable_type", "variable_title", "is_builtin", "group_id", "value", "options", "created_admin_id", "updated_admin_id", "created_at", "updated_at", "sort_order", "is_required", "status", "description", "variable_code") VALUES ('4ce57e09046d37e6bc76', 'string', '备案号', 't', 'b15270a767c4b63c7088', 'x公网安备 xxxxxxxxxxxxxx号', '[]', NULL, '604612615536115712', '2026-09-13 22:36:07.261478+08:00', '2026-09-18 19:37:25.779+08:00', '2', 'f', '1', 'ICP 备案号，显示在页脚', 'icp_number'), ('18a46e4d5de5b7dcb73c', 'number', '组织状态', 't', '3010fae57e1e341cb08f', '1', '[]', NULL, '604612615536115712', '2026-09-13 22:48:59.372478+08:00', '2026-09-14 20:13:59.137+08:00', '3', 'f', '1', '组织状态选项', 'org_status'), ('6dc6dcd471de906e0981', 'number', '菜单状态', 't', '3010fae57e1e341cb08f', '1', '[{"sort": 1, "label": "启用", "value": 1, "status": 1}, {"sort": 2, "label": "禁用", "value": 0, "status": 1}]', NULL, NULL, '2026-09-13 22:48:59.372478+08:00', '2026-09-14 20:01:17.640934+08:00', '4', 'f', '1', '菜单状态选项', 'menu_status'), ('a95f89131904ddb24583', 'number', '角色状态', 't', '3010fae57e1e341cb08f', '1', '[{"sort": 1, "label": "启用", "value": 1, "status": 1}, {"sort": 2, "label": "禁用", "value": 0, "status": 1}]', NULL, NULL, '2026-09-13 22:48:59.372478+08:00', '2026-09-14 20:01:17.640934+08:00', '2', 'f', '1', '角色状态选项', 'role_status'), ('0e474535b9337c44b5ee', 'number', '菜单类型', 't', '3010fae57e1e341cb08f', '2', '[{"sort": 1, "label": "目录", "value": 1, "status": 1}, {"sort": 2, "label": "菜单", "value": 2, "status": 1}, {"sort": 3, "label": "按钮", "value": 3, "status": 1}]', NULL, NULL, '2026-09-13 22:48:59.372478+08:00', '2026-09-14 20:01:17.640934+08:00', '5', 'f', '1', '菜单类型选项', 'menu_type'), ('08b89d3caec7cf7e0564', 'string', '站点名称', 't', 'b15270a767c4b63c7088', 'Me - Admin', '[]', NULL, '604612615536115712', '2026-09-13 22:36:07.261478+08:00', '2026-09-14 20:01:17.640934+08:00', '1', 't', '1', '网站名称，显示在浏览器标题栏', 'site_name'), ('00ad413cd55327bae636', 'string', '版本号', 't', 'b15270a767c4b63c7088', '1.3.6', '[]', NULL, '604612615536115712', '2026-09-13 22:36:07.261478+08:00', '2026-09-14 20:01:17.640934+08:00', '3', 'f', '1', '当前系统版本号', 'version_number'), ('bde5f4d278db872edcae', 'text', '站点说明', 't', 'b15270a767c4b63c7088', 'Me-Admin 基于 Midway + Vue 3 + TypeScript 构建，一键 CRUD、SSR 渲染、权限体系开箱即用，助你以最小成本交付企业级应用。', '[]', NULL, '604612615536115712', '2026-09-13 22:36:07.261478+08:00', '2026-09-17 18:41:13.816+08:00', '4', 'f', '1', '站点简介，用于 SEO', 'site_description'), ('49cc72fe940b0dc9b2ea', 'string', '联系电话', 'f', 'fb17ef9c47d7ae19a7de', '', '[]', NULL, '604612615536115712', '2026-09-14 20:01:17.640934+08:00', '2026-09-14 20:01:17.640934+08:00', '2', 'f', '1', '客服联系电话', 'contact_phone'), ('5b321c245a8fb77752d6', 'keyvalue', 'API 端点映射', 'f', 'fb17ef9c47d7ae19a7de', '{"order":"/api/order","user":"/api/user"}', '[]', NULL, '604612615536115712', '2026-09-14 19:28:53.189009+08:00', '2026-09-14 21:38:31.287+08:00', '5', 'f', '1', '键值对类型示例', 'api_endpoint_mapping'), ('754695313331060736', 'number', '建站年份', 'f', 'fb17ef9c47d7ae19a7de', '2026', '[]', '604612615536115712', '604612615536115712', '2026-09-14 21:29:44.26+08:00', '2026-09-14 21:38:35.991+08:00', '100', 'f', '1', '数字类型示例', 'site_founding_year'), ('754743795144196096', 'dict', '分页测试字典1', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:23.225+08:00', '2026-09-15 00:42:23.225+08:00', '901', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_1'), ('754743796306018304', 'dict', '分页测试字典2', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:23.501+08:00', '2026-09-15 00:42:23.501+08:00', '902', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_2'), ('754743798604496896', 'dict', '分页测试字典4', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:24.049+08:00', '2026-09-15 00:42:24.049+08:00', '904', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_4'), ('755083054686404608', 'dict', '分页测试字典12', 'f', '3010fae57e1e341cb08f', '{}', '[]', '604612615536115712', '604612615536115712', '2026-09-15 23:10:29.002+08:00', '2026-09-15 23:10:29.002+08:00', '100', 't', '1', '', 'pagination_test_dict_12'), ('754743799728570368', 'dict', '分页测试字典5', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:24.317+08:00', '2026-09-15 00:42:24.317+08:00', '905', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_5'), ('fcc59df6502cdfe58635', 'number', '数据权限范围', 't', '3010fae57e1e341cb08f', '1', '[{"sort": 1, "label": "全部数据", "value": 1, "status": 1}, {"sort": 2, "label": "组织数据", "value": 2, "status": 1}, {"sort": 3, "label": "组织及以下数据", "value": 3, "status": 1}, {"sort": 4, "label": "仅本人数据", "value": 4, "status": 1}]', NULL, NULL, '2026-09-13 22:48:59.372478+08:00', '2026-09-14 20:01:17.640934+08:00', '6', 'f', '1', '数据权限范围选项', 'data_permission_scope'), ('754743800861032448', 'dict', '分页测试字典6', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:24.587+08:00', '2026-09-15 00:42:24.587+08:00', '906', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_6'), ('754743802056409088', 'dict', '分页测试字典7', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:24.872+08:00', '2026-09-15 00:42:24.872+08:00', '907', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_7'), ('754743803184676864', 'dict', '分页测试字典8', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:25.141+08:00', '2026-09-15 00:42:25.141+08:00', '908', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_8'), ('754743804266807296', 'dict', '分页测试字典9', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:25.399+08:00', '2026-09-15 00:42:25.399+08:00', '909', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_9'), ('60022e7b07e610fddf4b', 'string', '联系邮箱', 'f', 'fb17ef9c47d7ae19a7de', '', '[]', NULL, '604612615536115712', '2026-09-14 20:01:17.640934+08:00', '2026-09-14 20:01:17.640934+08:00', '1', 'f', '1', '客服联系邮箱', 'contact_email'), ('df90297e452691428b67', 'text', '页脚说明', 'f', 'fb17ef9c47d7ae19a7de', '', '[]', NULL, '604612615536115712', '2026-09-14 20:01:17.640934+08:00', '2026-09-14 20:01:17.640934+08:00', '3', 'f', '1', '页脚额外说明文字', 'footer_description'), ('d14b8c705500cb1455f9', 'array', '启用功能', 'f', 'fb17ef9c47d7ae19a7de', '["用户管理","日志审计","数据权限"]', '[]', NULL, '604612615536115712', '2026-09-14 19:28:53.189009+08:00', '2026-09-14 20:01:17.640934+08:00', '4', 'f', '1', '数组类型示例', 'enabled_features'), ('754743805374103552', 'dict', '分页测试字典10', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:25.663+08:00', '2026-09-15 00:42:25.663+08:00', '910', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_10'), ('d427a687e0c2f12e2640', 'dict', '语言选项', 'f', 'fb17ef9c47d7ae19a7de', '{"backend":"zh-cn","frontend":"en-us"}', '[{"sort": 1, "label": "后台", "value": "backend", "status": 1}, {"sort": 2, "label": "前台", "value": "frontend", "status": 1}]', NULL, '604612615536115712', '2026-09-14 19:28:53.189009+08:00', '2026-09-14 20:01:17.640934+08:00', '6', 'f', '1', '自定义字典类型示例', 'language_options'), ('754743806481399808', 'dict', '分页测试字典11', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:25.927+08:00', '2026-09-15 00:42:25.927+08:00', '911', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_11'), ('754743797493006336', 'dict', '分页测试字典3', 'f', '3010fae57e1e341cb08f', '{}', '[{"sort": 1, "label": "是", "value": "yes", "status": 1}]', '604612615536115712', '604612615536115712', '2026-09-15 00:42:23.784+08:00', '2026-09-15 00:42:23.784+08:00', '903', 'f', '1', '浏览器验收测试数据，可删除', 'pagination_test_dict_3'), ('755707959958306816', 'string', '品牌名称', 'f', '755707956825161728', 'Me - Admin', '[]', '604612615536115712', '604612615536115712', '2026-09-17 16:33:38.029+08:00', '2026-09-17 16:33:38.029+08:00', '10', 'f', '1', '页脚品牌名称，默认沿用网站实际名称。', 'brand_name'), ('755707961283706880', 'string', '品牌链接', 'f', '755707956825161728', '/', '[]', '604612615536115712', '604612615536115712', '2026-09-17 16:33:38.345+08:00', '2026-09-17 16:33:38.345+08:00', '20', 'f', '1', '品牌点击地址，仅使用站内路径或 http/https 地址。', 'brand_url'), ('755707962567163904', 'string', '版权信息', 'f', '755707956825161728', '© 2025 - {year}. All Rights Reserved. Power by MeAdmin', '[]', '604612615536115712', '604612615536115712', '2026-09-17 16:33:38.651+08:00', '2026-09-17 18:17:58.69+08:00', '30', 'f', '1', '版权文本，{year} 自动替换为当前年份。', 'copyright'), ('755707965943578624', 'number', '手机显示链接', 'f', '755707956825161728', '0', '[]', '604612615536115712', '604612615536115712', '2026-09-17 16:33:39.456+08:00', '2026-09-17 16:33:39.456+08:00', '50', 'f', '1', '手机端是否显示链接列：0 隐藏，1 显示。', 'mobile_links'), ('756114051557228544', 'string', '描述', 'f', '755707956825161728', '基于 Midway + Vue 3 + TypeScript 的全栈一站式解决方案，让后台开发更简单、更优雅。', '[]', '604612615536115712', '604612615536115712', '2026-09-18 19:27:17.811+08:00', '2026-09-18 19:27:34.224+08:00', '100', 'f', '1', '', 'description'), ('1789634019124443384', 'textarea', '页脚链接列', 'f', '755707956825161728', '[{"title":"支持","links":[{"text":"反馈","url":"https://github.com/meadmin-cn/meadmin/issues","target":"_self","enabled":true},{"text":"加入社区","url":"https://github.com/meadmin-cn/meadmin/issues","target":"_self","enabled":true},{"text":"QQ 交流群","url":"https://jq.qq.com/?_wv=1027&k=zSjWSant","target":"_self","enabled":true},{"text":"商务合作","url":"https://github.com/meadmin-cn/meadmin/issues","target":"_self","enabled":true}],"enabled":true},{"title":"相关链接","links":[{"text":"文档","url":"https://www.meadmin.cn/aon/doc/","target":"_self","enabled":true},{"text":"演示","url":"https://demo.meadmin.cn/aon/doc/","target":"_self","enabled":true},{"text":"后台演示","url":"https://demo.meadmin.cn/aon/doc/demo","target":"_self","enabled":true}],"enabled":true}]', '[]', '604612615536115712', '604612615536115712', '2026-09-17 16:33:39.124+08:00', '2026-09-18 19:32:58.751+08:00', '40', 'f', '1', 'JSON数组：每项含title、enabled、links；links每项含text、url、target、enabled。数组顺序即显示顺序；enabled=false隐藏；target为_self或_blank；[]隐藏全部栏目。支持站内路径、http/https、mailto/tel。', 'columns');

CREATE TABLE "system_config_group" (
  "id" character varying(20) NOT NULL,
  "group_code" character varying(50) NOT NULL DEFAULT ''::character varying,
  "group_name" character varying(100) NOT NULL DEFAULT ''::character varying,
  "group_type" character varying(20) NOT NULL DEFAULT 'custom'::character varying,
  "is_builtin" boolean NOT NULL DEFAULT false,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "sort_order" integer NOT NULL DEFAULT 100,
  "description" text NOT NULL DEFAULT ''::text,
  "status" integer NOT NULL DEFAULT 1,
  CONSTRAINT "system_config_group_pkey" PRIMARY KEY (id),
  CONSTRAINT "system_config_group_group_code_unique" UNIQUE (group_code)
);
COMMENT ON TABLE "system_config_group" IS '系统配置分组表';
COMMENT ON COLUMN "system_config_group"."group_code" IS '分组编码';
COMMENT ON COLUMN "system_config_group"."group_name" IS '分组名称';
COMMENT ON COLUMN "system_config_group"."group_type" IS '分组类型:base=基础;dict=字典;custom=自定义';
COMMENT ON COLUMN "system_config_group"."is_builtin" IS '是否内置';
COMMENT ON COLUMN "system_config_group"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "system_config_group"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "system_config_group"."created_at" IS '创建时间';
COMMENT ON COLUMN "system_config_group"."updated_at" IS '最后更新时间';
CREATE UNIQUE INDEX "system_config_group_code_unique" ON "system_config_group" USING btree ("group_code");

INSERT INTO "system_config_group" ("id", "group_code", "group_name", "group_type", "is_builtin", "created_admin_id", "updated_admin_id", "created_at", "updated_at", "sort_order", "description", "status") VALUES ('b15270a767c4b63c7088', 'base', '基础配置', 'base', 't', NULL, NULL, '2026-09-13 22:36:07.261478+08:00', '2026-09-14 20:01:17.640934+08:00', '1', '系统基础运行配置', '1'), ('3010fae57e1e341cb08f', 'dict', '字典配置', 'dict', 't', NULL, NULL, '2026-09-13 22:36:07.261478+08:00', '2026-09-14 20:01:17.640934+08:00', '2', '系统业务字典配置', '1'), ('755707956825161728', 'site_footer', '站点页脚配置', 'custom', 'f', '604612615536115712', '604612615536115712', '2026-09-17 16:33:37.282+08:00', '2026-09-18 19:26:11.648+08:00', '100', '前台页脚品牌、版权与链接列配置。', '1'), ('fb17ef9c47d7ae19a7de', 'site_extend', '站点扩展配置', 'custom', 'f', NULL, '604612615536115712', '2026-09-14 19:28:53.189009+08:00', '2026-09-18 19:26:11.674+08:00', '101', '站点扩展配置示例', '1');

CREATE TABLE "system_menu" (
  "id" character varying(20) NOT NULL,
  "title" character varying(100) NOT NULL DEFAULT ''::character varying,
  "menu_type" smallint NOT NULL,
  "status" smallint NOT NULL DEFAULT 1,
  "rule" character varying(100) NOT NULL DEFAULT ''::character varying,
  "order_num" smallint NOT NULL DEFAULT 0,
  "path" character varying(500) NOT NULL DEFAULT ''::character varying,
  "is_link" smallint NOT NULL DEFAULT 0,
  "component" character varying(500) NOT NULL DEFAULT ''::character varying,
  "hide_menu" smallint NOT NULL DEFAULT 0,
  "cache" smallint NOT NULL DEFAULT 0,
  "icon" character varying(50) NOT NULL DEFAULT ''::character varying,
  "affix" smallint NOT NULL DEFAULT 0,
  "always_show" smallint NOT NULL DEFAULT 0,
  "breadcrumb" smallint NOT NULL DEFAULT 1,
  "parent_id" character varying(100),
  "left" bigint,
  "right" bigint,
  "lock_version" character varying(100) NOT NULL DEFAULT ''::character varying,
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  CONSTRAINT "system_menu_copy_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "system_menu" IS '菜单表';
COMMENT ON COLUMN "system_menu"."title" IS '菜单名称';
COMMENT ON COLUMN "system_menu"."menu_type" IS '类型:1=目录;2=菜单;3=按钮';
COMMENT ON COLUMN "system_menu"."status" IS '状态:1=启用;0=禁用';
COMMENT ON COLUMN "system_menu"."rule" IS '权限';
COMMENT ON COLUMN "system_menu"."order_num" IS '排序(降序)';
COMMENT ON COLUMN "system_menu"."path" IS '路径';
COMMENT ON COLUMN "system_menu"."is_link" IS '外链:1=是;0=否';
COMMENT ON COLUMN "system_menu"."component" IS '组件路径(相对于views文件夹)';
COMMENT ON COLUMN "system_menu"."hide_menu" IS '隐藏:1=是;0=否';
COMMENT ON COLUMN "system_menu"."cache" IS '缓存:1=是;0=否';
COMMENT ON COLUMN "system_menu"."icon" IS '图标';
COMMENT ON COLUMN "system_menu"."affix" IS '固定tag:1=是;0=否';
COMMENT ON COLUMN "system_menu"."always_show" IS '恒定展示(只有一个子元素时不隐藏):1=是;0=否';
COMMENT ON COLUMN "system_menu"."breadcrumb" IS '面包屑:1=展示;0=不展示';
COMMENT ON COLUMN "system_menu"."parent_id" IS '父级id';
COMMENT ON COLUMN "system_menu"."left" IS '左树边界';
COMMENT ON COLUMN "system_menu"."right" IS '右树边界';
COMMENT ON COLUMN "system_menu"."lock_version" IS '锁版本号';
COMMENT ON COLUMN "system_menu"."created_at" IS '创建时间';
COMMENT ON COLUMN "system_menu"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "system_menu"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "system_menu"."updated_admin_id" IS '最后更新者(管理员)Id';
CREATE UNIQUE INDEX "system_menu_copy_rule_idx" ON "system_menu" USING btree ("rule");
CREATE UNIQUE INDEX "system_menu_copy_rule_idx1" ON "system_menu" USING btree ("rule");

INSERT INTO "system_menu" ("id", "title", "menu_type", "status", "rule", "order_num", "path", "is_link", "component", "hide_menu", "cache", "icon", "affix", "always_show", "breadcrumb", "parent_id", "left", "right", "lock_version", "created_at", "updated_at", "created_admin_id", "updated_admin_id") VALUES ('664033965581008896', '示例', '1', '1', 'example', '995', '/example', '0', '', '0', '0', 'MelIconPlatform', '0', '1', '1', NULL, '1', '26', '', '2026-01-07 17:13:54.549+08:00', '2026-09-18 10:29:54.413+08:00', NULL, '604612615536115712'), ('755101402446954496', '新增字典', '3', '1', 'system_config_dict_add', '85', '', '0', '', '0', '0', '', '0', '0', '1', '755095762555109376', '34', '35', '', '2026-09-16 00:23:23.449+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('755101403113848832', '编辑字典', '3', '1', 'system_config_dict_edit', '84', '', '0', '', '0', '0', '', '0', '0', '1', '755095762555109376', '36', '37', '', '2026-09-16 00:23:23.608+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('755237799904411648', '查看字典配置', '3', '1', 'system_config_dict_list', '999', '', '0', '', '0', '1', 'MelIconList', '0', '0', '1', '755095762555109376', '38', '39', '', '2026-09-16 09:25:23.138+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('754710315110760448', '编辑配置组', '3', '1', 'system_config_group_edit', '87', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '755095763259752448', '44', '45', '', '2026-09-14 22:29:20.962+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('755237961372532736', '查看配置组', '3', '1', 'system_config_group_list', '999', '', '0', '', '0', '1', 'MelIconList', '0', '0', '1', '755095763259752448', '48', '49', '', '2026-09-16 09:26:01.635+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('754710314548723712', '新增配置组', '3', '1', 'system_config_group_add', '88', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '755095763259752448', '46', '47', '', '2026-09-14 22:29:20.828+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('742297140071497728', '启动', '3', '1', 'job_start', '95', '', '0', '', '0', '0', 'MelIconOpen', '0', '0', '1', '742297136913186816', '134', '135', '', '2026-08-11 16:23:49.407+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('754285047413997568', '多级菜单1-3', '2', '1', 'menu1-3', '997', 'menu1-3', '0', 'example/demo/index', '0', '1', 'MelIconList', '0', '0', '1', '753838055642628096', '15', '16', '', '2026-09-13 18:19:29.242+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('754346488292704256', '列表', '3', '1', 'system_config_list', '100', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '754346487625809920', '29', '30', '', '2026-09-13 22:23:37.889+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('755101403734605824', '删除字典', '3', '1', 'system_config_dict_del', '83', '', '0', '', '0', '0', '', '0', '0', '1', '755095762555109376', '40', '41', '', '2026-09-16 00:23:23.756+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('754710316213862400', '新增配置字段', '3', '1', 'system_config_field_add', '85', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '755095763259752448', '50', '51', '', '2026-09-14 22:29:21.225+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('754346487625809920', '系统配置', '2', '1', 'system_config', '97', '/system/config', '0', 'system/config/index', '0', '1', 'MelIconSetting', '0', '0', '1', '1', '28', '61', '', '2026-09-13 22:23:37.731+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('719446780197994496', '详情', '3', '1', 'system_organization_info', '98', '', '0', '', '0', '0', '', '0', '0', '1', '719446778558021632', '63', '64', '', '2026-06-09 15:04:39.074+08:00', '2026-09-18 10:29:54.414+08:00', NULL, '604612615536115712'), ('719446781074604032', '编辑', '3', '1', 'system_organization_edit', '96', '', '0', '', '0', '0', '', '0', '0', '1', '719446778558021632', '67', '68', '', '2026-06-09 15:04:39.284+08:00', '2026-09-18 10:29:54.414+08:00', NULL, '604612615536115712'), ('754242324053098496', '添加关联用户', '3', '1', 'system_organization_add_user', '94', '', '0', '', '0', '1', 'MelIconList', '0', '0', '1', '719446778558021632', '65', '66', '', '2026-09-13 15:29:43.2+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('719446779690483712', '列表', '3', '1', 'system_organization_list', '99', '', '0', '', '0', '0', '', '0', '0', '1', '719446778558021632', '69', '70', '', '2026-06-09 15:04:38.953+08:00', '2026-09-18 10:29:54.414+08:00', NULL, '604612615536115712'), ('719446781531783168', '删除', '3', '1', 'system_organization_del', '95', '', '0', '', '0', '0', '', '0', '0', '1', '719446778558021632', '71', '72', '', '2026-06-09 15:04:39.392+08:00', '2026-09-18 10:29:54.415+08:00', NULL, '604612615536115712'), ('658270767712043008', '编辑', '3', '1', 'system_admin_edit', '96', '', '0', '', '0', '1', '', '0', '0', '1', '2', '79', '80', '', '2025-12-22 19:33:01.102+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('754320714072326144', '修复树关系', '3', '1', 'system_menu_perfect_tree', '1', '', '0', '', '0', '1', '', '0', '0', '1', '3', '91', '92', '', '2026-09-13 20:41:12.837+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664797660825255936', '删除', '3', '1', 'system_menu_del', '95', '', '0', '', '0', '1', '', '0', '0', '1', '664799196632580096', '94', '95', '', '2026-01-09 19:48:33.684+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664797278774493184', '列表', '3', '1', 'system_menu_list', '99', '', '0', '', '0', '1', '', '0', '0', '1', '664799196632580096', '96', '97', '', '2026-01-09 19:47:02.598+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664800095295766528', '删除', '3', '1', 'system_role_del', '95', '', '0', '', '0', '1', '', '0', '0', '1', '664798918835437568', '106', '107', '', '2026-01-09 19:58:14.107+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('754320715573886976', '修复树关系', '3', '1', 'system_role_perfect_tree', '1', '', '0', '', '0', '1', '', '0', '0', '1', '664798918835437568', '108', '109', '', '2026-09-13 20:41:13.194+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664799846128943104', '新增', '3', '1', 'system_role_add', '97', '', '0', '', '0', '1', '', '0', '0', '1', '664798918835437568', '110', '111', '', '2026-01-09 19:57:14.701+08:00', '2026-09-18 10:29:54.416+08:00', '604612615536115712', '604612615536115712'), ('664813416312995840', '编辑', '3', '1', 'user_edit', '96', '', '0', '', '0', '0', '', '0', '0', '1', '664813414475890688', '122', '123', '', '2026-01-09 20:51:10.085+08:00', '2026-09-18 10:29:54.416+08:00', NULL, '604612615536115712'), ('664813415910342656', '新增', '3', '1', 'user_add', '97', '', '0', '', '0', '0', '', '0', '0', '1', '664813414475890688', '124', '125', '', '2026-01-09 20:51:09.989+08:00', '2026-09-18 10:29:54.416+08:00', NULL, '604612615536115712'), ('742297138695766016', '列表', '3', '1', 'job_list', '99', '', '0', '', '0', '0', '', '0', '0', '1', '742297136913186816', '136', '137', '', '2026-08-11 16:23:49.079+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('742297139157139456', '详情', '3', '1', 'job_info', '98', '', '0', '', '0', '0', '', '0', '0', '1', '742297136913186816', '138', '139', '', '2026-08-11 16:23:49.189+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('742297139618512896', '新增', '3', '1', 'job_add', '97', '', '0', '', '0', '0', '', '0', '0', '1', '742297136913186816', '140', '141', '', '2026-08-11 16:23:49.299+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('664816036704419840', '删除', '3', '1', 'user_file_del', '95', '', '0', '', '0', '0', '', '0', '0', '1', '664816034456272896', '163', '164', '', '2026-01-09 21:01:34.835+08:00', '2026-09-18 10:29:54.419+08:00', NULL, '604612615536115712'), ('664033967724298240', '编辑', '3', '1', 'example_demo_edit', '96', '', '0', '', '0', '0', '', '0', '0', '1', '664033966046576640', '3', '4', '', '2026-01-07 17:13:55.06+08:00', '2026-09-18 10:29:54.411+08:00', NULL, '604612615536115712'), ('664033967292284928', '新增', '3', '1', 'example_demo_add', '97', '', '0', '', '0', '0', '', '0', '0', '1', '664033966046576640', '5', '6', '', '2026-01-07 17:13:54.958+08:00', '2026-09-18 10:29:54.412+08:00', NULL, '604612615536115712'), ('664033968131145728', '删除', '3', '1', 'example_demo_del', '95', '', '0', '', '0', '0', '', '0', '0', '1', '664033966046576640', '7', '8', '', '2026-01-07 17:13:55.158+08:00', '2026-09-18 10:29:54.412+08:00', NULL, '604612615536115712'), ('753838717554130944', '多级菜单1-2', '2', '1', 'menu1-2', '998', 'menu1-2', '0', 'example/demo/index', '0', '1', 'MelIconList', '0', '0', '1', '753838055642628096', '17', '18', '', '2026-09-12 12:45:55.911+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('754285401115459584', '多级菜单1-4', '1', '1', 'menu1-4', '996', 'menu1-4', '0', 'example/demo/index', '0', '1', 'MelIconList', '0', '0', '1', '753838055642628096', '19', '22', '', '2026-09-13 18:20:53.571+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('754305706844225536', '多级菜单1-1', '2', '1', 'menu1-1', '999', 'menu1-1', '0', 'example/demo/index', '0', '1', 'MelIconList', '0', '0', '1', '753838055642628096', '23', '24', '', '2026-09-13 19:41:34.834+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('754346488909266944', '详情', '3', '1', 'system_config_info', '99', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '754346487625809920', '31', '32', '', '2026-09-13 22:23:38.036+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('755095762555109376', '字典配置', '1', '1', 'system_config_dict', '80', '', '0', '', '1', '0', 'MelIconList', '0', '0', '1', '754346487625809920', '33', '42', '', '2026-09-16 00:00:58.794+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('754320714852466688', '修复树关系', '3', '1', 'system_organization_perfect_tree', '1', '', '0', '', '0', '1', '', '0', '0', '1', '719446778558021632', '73', '74', '', '2026-09-13 20:41:13.022+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('754285606355337216', '多级菜单1-4-1', '2', '1', 'menu1-4-1', '999', 'menu1-4-1', '0', 'example/demo/index', '0', '1', 'MelIconList', '0', '0', '1', '754285401115459584', '20', '21', '', '2026-09-13 18:21:42.505+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('755095763259752448', '配置组管理', '1', '1', 'system_config_group', '70', '', '0', '', '1', '0', 'MelIconList', '0', '0', '1', '754346487625809920', '43', '58', '', '2026-09-16 00:00:58.963+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('719446778558021632', '组织', '2', '1', 'system_organization', '98', '/system/organization', '0', 'system/organization/index', '0', '0', 'MelIconList', '0', '0', '1', '1', '62', '77', '', '2026-06-09 15:04:38.684+08:00', '2026-09-18 10:29:54.415+08:00', NULL, '604612615536115712'), ('664798399022759936', '详情', '3', '1', 'system_admin_info', '98', '', '0', '', '0', '1', '', '0', '0', '1', '2', '81', '82', '', '2026-01-09 19:51:29.684+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('1', '系统设置', '1', '1', 'system', '998', '/system', '0', '', '0', '0', 'MelIconSetting', '0', '0', '1', NULL, '27', '120', '', '2025-07-31 15:20:29+08:00', '2026-09-18 10:29:54.416+08:00', NULL, '604612615536115712'), ('664813415503495168', '详情', '3', '1', 'user_info', '98', '', '0', '', '0', '0', '', '0', '0', '1', '664813414475890688', '128', '129', '', '2026-01-09 20:51:09.892+08:00', '2026-09-18 10:29:54.417+08:00', NULL, '604612615536115712'), ('664813415100841984', '列表', '3', '1', 'user_list', '99', '', '0', '', '0', '0', '', '0', '0', '1', '664813414475890688', '126', '127', '', '2026-01-09 20:51:09.796+08:00', '2026-09-18 10:29:54.416+08:00', NULL, '604612615536115712'), ('664816036259823616', '编辑', '3', '1', 'user_file_edit', '96', '', '0', '', '0', '0', '', '0', '0', '1', '664816034456272896', '165', '166', '', '2026-01-09 21:01:34.729+08:00', '2026-09-18 10:29:54.419+08:00', NULL, '604612615536115712'), ('754710317916749824', '修改配置', '3', '1', 'system_config_value_edit', '82', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '754346487625809920', '59', '60', '', '2026-09-14 22:29:21.631+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('719446780625813504', '新增', '3', '1', 'system_organization_add', '97', '', '0', '', '0', '0', '', '0', '0', '1', '719446778558021632', '75', '76', '', '2026-06-09 15:04:39.176+08:00', '2026-09-18 10:29:54.415+08:00', NULL, '604612615536115712'), ('658270653836689408', '新增', '3', '1', 'system_admin_add', '97', '', '0', '', '0', '1', '', '0', '0', '1', '2', '83', '84', '', '2025-12-22 19:32:33.952+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('658270533162369024', '列表', '3', '1', 'system_admin_list', '99', '', '0', '', '0', '1', '', '0', '0', '1', '2', '85', '86', '', '2025-12-22 19:32:05.181+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('2', '管理员', '2', '1', 'system_admin', '99', '/system/admin', '0', 'system/admin/index', '0', '0', 'MelIconUser', '0', '0', '1', '1', '78', '89', '', '2025-07-31 15:20:29+08:00', '2026-09-18 10:29:54.415+08:00', NULL, '604612615536115712'), ('658270899723567104', '删除', '3', '1', 'system_admin_del', '95', '', '0', '', '0', '1', '', '0', '0', '1', '2', '87', '88', '', '2025-12-22 19:33:32.576+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('3', '菜单权限', '2', '1', 'system_menu_role', '97', '/system/menu', '0', 'system/menuRole/index', '0', '0', 'MelIconMenu', '0', '0', '1', '1', '90', '119', '', '2025-07-31 15:20:29+08:00', '2026-09-18 10:29:54.416+08:00', NULL, '604612615536115712'), ('664813414475890688', '用户管理', '2', '1', 'user', '996', '/user', '0', 'user/index', '0', '0', 'MelIconUser', '0', '0', '1', NULL, '121', '132', '', '2026-01-09 20:51:09.647+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('747780486675300352', '停止', '3', '1', 'job_stop', '94', '', '0', '', '0', '1', 'MelIconTurnOff', '0', '0', '1', '742297136913186816', '142', '143', '', '2026-08-26 19:32:41.114+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('664802471784218624', '列表', '3', '1', 'file_list', '99', '', '0', '', '0', '1', '', '0', '0', '1', '639418081101217792', '151', '152', '', '2026-01-09 20:07:40.707+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('754710316767510528', '编辑配置字段', '3', '1', 'system_config_field_edit', '84', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '755095763259752448', '52', '53', '', '2026-09-14 22:29:21.357+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('664813416715649024', '删除', '3', '1', 'user_del', '95', '', '0', '', '0', '0', '', '0', '0', '1', '664813414475890688', '130', '131', '', '2026-01-09 20:51:10.181+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('742297136913186816', '队列任务', '2', '1', 'job', '99', '/job', '0', 'job/index', '0', '0', 'MelIconList', '0', '0', '1', NULL, '133', '146', '', '2026-08-11 16:23:48.655+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('701403170512830464', '控制台', '2', '1', 'dashboard', '999', 'index', '0', 'index/index', '0', '1', 'MeIconDashboard', '1', '0', '1', '', '147', '148', '', '2026-04-20 20:05:47.292+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('639418081101217792', '管理员附件', '2', '1', 'file', '999', 'file', '0', 'file/index', '0', '1', 'MelIconFolder', '0', '0', '1', '664816340996980736', '150', '161', '', '2025-10-31 18:59:10.348+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('754710317321158656', '删除配置字段', '3', '1', 'system_config_field_del', '83', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '755095763259752448', '54', '55', '', '2026-09-14 22:29:21.489+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('664797436325134336', '新增', '3', '1', 'system_menu_add', '97', '', '0', '', '0', '1', '', '0', '0', '1', '664799196632580096', '98', '99', '', '2026-01-09 19:47:40.16+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664797552121479168', '编辑', '3', '1', 'system_menu_edit', '96', '', '0', '', '0', '1', '', '0', '0', '1', '664799196632580096', '100', '101', '', '2026-01-09 19:48:07.767+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664799999699189760', '编辑', '3', '1', 'system_role_edit', '96', '', '0', '', '0', '1', '', '0', '0', '1', '664798918835437568', '112', '113', '', '2026-01-09 19:57:51.316+08:00', '2026-09-18 10:29:54.416+08:00', '604612615536115712', '604612615536115712'), ('664799732303921152', '详情', '3', '1', 'system_role_info', '98', '', '0', '', '0', '1', '', '0', '0', '1', '664798918835437568', '114', '115', '', '2026-01-09 19:56:47.563+08:00', '2026-09-18 10:29:54.416+08:00', '604612615536115712', '604612615536115712'), ('742297140545454080', '删除', '3', '1', 'job_del', '96', '', '0', '', '0', '0', '', '0', '0', '1', '742297136913186816', '144', '145', '', '2026-08-11 16:23:49.52+08:00', '2026-09-18 10:29:54.418+08:00', NULL, '604612615536115712'), ('664816034934423552', '列表', '3', '1', 'user_file_list', '99', '', '0', '', '0', '0', '', '0', '0', '1', '664816034456272896', '167', '168', '', '2026-01-09 21:01:34.413+08:00', '2026-09-18 10:29:54.419+08:00', NULL, '604612615536115712'), ('664033966046576640', 'Demo', '2', '1', 'example_demo', '999', '/example/demo', '0', 'example/demo/index', '0', '0', '', '0', '0', '1', '664033965581008896', '2', '13', '', '2026-01-07 17:13:54.66+08:00', '2026-09-18 10:29:54.413+08:00', NULL, '604612615536115712'), ('753838055642628096', '多级菜单测试1', '1', '1', 'menu1', '1000', '/menu1', '0', '', '0', '1', 'MelIconList', '0', '0', '1', '664033965581008896', '14', '25', '', '2026-09-12 12:43:18.099+08:00', '2026-09-18 10:29:54.413+08:00', '604612615536115712', '604612615536115712'), ('754710315660214272', '删除配置组', '3', '1', 'system_config_group_del', '86', '', '0', '', '0', '0', 'MelIconList', '0', '0', '1', '755095763259752448', '56', '57', '', '2026-09-14 22:29:21.093+08:00', '2026-09-18 10:29:54.414+08:00', '604612615536115712', '604612615536115712'), ('664797875221299200', '详情', '3', '1', 'system_menu_info', '98', '', '0', '', '0', '1', '', '0', '0', '1', '664799196632580096', '102', '103', '', '2026-01-09 19:49:24.8+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664799196632580096', '菜单', '3', '1', 'system_menu', '98', '', '0', '', '0', '1', '', '0', '0', '1', '3', '93', '104', '', '2026-01-09 19:54:39.849+08:00', '2026-09-18 10:29:54.415+08:00', '604612615536115712', '604612615536115712'), ('664799640041816064', '列表', '3', '1', 'system_role_list', '99', '', '0', '', '0', '1', '', '0', '0', '1', '664798918835437568', '116', '117', '', '2026-01-09 19:56:25.566+08:00', '2026-09-18 10:29:54.416+08:00', '604612615536115712', '604612615536115712'), ('664798918835437568', '角色组', '3', '1', 'system_role', '99', '', '0', '', '0', '1', '', '0', '0', '1', '3', '105', '118', '', '2026-01-09 19:53:33.617+08:00', '2026-09-18 10:29:54.416+08:00', '604612615536115712', '604612615536115712'), ('664803080839102464', '新增', '3', '1', 'file_add', '97', '', '0', '', '0', '1', '', '0', '0', '1', '639418081101217792', '153', '154', '', '2026-01-09 20:10:05.916+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('664802570002235392', '详情', '3', '1', 'file_info', '98', '', '0', '', '0', '1', '', '0', '0', '1', '639418081101217792', '155', '156', '', '2026-01-09 20:08:04.123+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('664803191971381248', '删除', '3', '1', 'file_del', '95', '', '0', '', '0', '1', '', '0', '0', '1', '639418081101217792', '157', '158', '', '2026-01-09 20:10:32.412+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('664816035383214080', '详情', '3', '1', 'user_file_info', '98', '', '0', '', '0', '0', '', '0', '0', '1', '664816034456272896', '169', '170', '', '2026-01-09 21:01:34.52+08:00', '2026-09-18 10:29:54.419+08:00', NULL, '604612615536115712'), ('664816035819421696', '新增', '3', '1', 'user_file_add', '97', '', '0', '', '0', '0', '', '0', '0', '1', '664816034456272896', '171', '172', '', '2026-01-09 21:01:34.624+08:00', '2026-09-18 10:29:54.419+08:00', NULL, '604612615536115712'), ('664816034456272896', '前台附件', '2', '1', 'user_file', '998', 'user/file', '0', 'user/file/index', '0', '0', 'MelIconFolder', '0', '0', '1', '664816340996980736', '162', '173', '', '2026-01-09 21:01:34.3+08:00', '2026-09-18 10:29:54.419+08:00', NULL, '604612615536115712'), ('664033966474395648', '列表', '3', '1', 'example_demo_list', '99', '', '0', '', '0', '0', '', '0', '0', '1', '664033966046576640', '9', '10', '', '2026-01-07 17:13:54.762+08:00', '2026-09-18 10:29:54.412+08:00', NULL, '604612615536115712'), ('664033966889631744', '详情', '3', '1', 'example_demo_info', '98', '', '0', '', '0', '0', '', '0', '0', '1', '664033966046576640', '11', '12', '', '2026-01-07 17:13:54.862+08:00', '2026-09-18 10:29:54.413+08:00', NULL, '604612615536115712'), ('664802952766029824', '编辑', '3', '1', 'file_edit', '96', '', '0', '', '0', '1', '', '0', '0', '1', '639418081101217792', '159', '160', '', '2026-01-09 20:09:35.381+08:00', '2026-09-18 10:29:54.418+08:00', '604612615536115712', '604612615536115712'), ('664816340996980736', '附件管理', '1', '1', 'file_manage', '997', 'fileManage', '0', '', '0', '1', 'MelIconFiles', '0', '0', '1', NULL, '149', '174', '', '2026-01-09 21:02:47.384+08:00', '2026-09-18 10:29:54.419+08:00', '604612615536115712', '604612615536115712'), ('682444732227387392', 'Doc', '1', '1', 'addons_doc', '99', '/addons/doc', '0', '', '0', '0', '', '0', '1', '1', NULL, '93', '112', '', '2026-02-27 12:31:43.374+08:00', '2026-03-31 18:32:01.92+08:00', NULL, NULL);

CREATE TABLE "system_organization" (
  "id" character varying(20) NOT NULL,
  "org_name" character varying(50) NOT NULL DEFAULT ''::character varying,
  "order_num" smallint NOT NULL DEFAULT 0,
  "status" smallint NOT NULL DEFAULT 1,
  "remark" character varying(100) NOT NULL DEFAULT ''::character varying,
  "leader" character varying(100) NOT NULL DEFAULT ''::character varying,
  "phone" character varying(100) NOT NULL DEFAULT ''::character varying,
  "email" character varying(100) NOT NULL DEFAULT ''::character varying,
  "parent_id" character varying(100),
  "left" bigint,
  "right" bigint,
  "lock_version" character varying(100) NOT NULL DEFAULT ''::character varying,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  CONSTRAINT "system_organization_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "system_organization" IS '组织表';
COMMENT ON COLUMN "system_organization"."org_name" IS '组织名称';
COMMENT ON COLUMN "system_organization"."order_num" IS '排序(降序)';
COMMENT ON COLUMN "system_organization"."status" IS '状态:1=启用;0=禁用';
COMMENT ON COLUMN "system_organization"."remark" IS '备注';
COMMENT ON COLUMN "system_organization"."leader" IS '负责人';
COMMENT ON COLUMN "system_organization"."phone" IS '联系电话';
COMMENT ON COLUMN "system_organization"."email" IS '邮箱';
COMMENT ON COLUMN "system_organization"."parent_id" IS '父级id';
COMMENT ON COLUMN "system_organization"."left" IS '左树边界';
COMMENT ON COLUMN "system_organization"."right" IS '右树边界';
COMMENT ON COLUMN "system_organization"."lock_version" IS '锁版本号';
COMMENT ON COLUMN "system_organization"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "system_organization"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "system_organization"."created_at" IS '创建时间';
COMMENT ON COLUMN "system_organization"."updated_at" IS '最后更新时间';

INSERT INTO "system_organization" ("id", "org_name", "order_num", "status", "remark", "leader", "phone", "email", "parent_id", "left", "right", "lock_version", "created_admin_id", "updated_admin_id", "created_at", "updated_at") VALUES ('740175601565958144', '广东分公司', '997', '1', '', '', '', '', '740174696351268864', '2', '3', '', '604612615536115712', '604612615536115712', '2026-08-05 19:53:35.212+08:00', '2026-09-13 20:43:27.822+08:00'), ('740175473295753216', '河南分公司', '998', '1', '', '', '', '', '740174696351268864', '4', '5', '', '604612615536115712', '604612615536115712', '2026-08-05 19:53:04.629+08:00', '2026-09-13 20:43:27.822+08:00'), ('740176056484364288', '聊城分公司', '999', '1', '', '', '', '', '740175409059987456', '7', '8', '', '604612615536115712', '604612615536115712', '2026-08-05 19:55:23.672+08:00', '2026-09-13 20:43:27.823+08:00'), ('740176007411007488', '济南分公司', '0', '1', '', '', '', '', '740175409059987456', '9', '10', '', '604612615536115712', '632899190933946368', '2026-08-05 19:55:11.972+08:00', '2026-09-13 20:43:27.823+08:00'), ('740175409059987456', '山东分公司', '0', '1', '', '', '', '', '740174696351268864', '6', '11', '', '604612615536115712', '604612615536115712', '2026-08-05 19:52:49.314+08:00', '2026-09-13 20:43:27.823+08:00'), ('740174696351268864', '总公司', '0', '1', '', '', '', '', '', '1', '12', '', '604612615536115712', '604612615536115712', '2026-08-05 19:49:59.391+08:00', '2026-09-13 20:43:27.823+08:00');

CREATE TABLE "system_role" (
  "id" character varying(20) NOT NULL,
  "role_name" character varying(50) NOT NULL DEFAULT ''::character varying,
  "role_key" character varying(50) NOT NULL DEFAULT ''::character varying,
  "order_num" smallint NOT NULL DEFAULT 0,
  "status" smallint NOT NULL DEFAULT 1,
  "remark" character varying(100) NOT NULL DEFAULT ''::character varying,
  "parent_id" character varying(100),
  "left" bigint,
  "right" bigint,
  "lock_version" character varying(100) NOT NULL DEFAULT ''::character varying,
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  "is_super" smallint NOT NULL DEFAULT 0,
  "data_scope" smallint NOT NULL DEFAULT 3,
  CONSTRAINT "system_role_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "system_role" IS '角色表';
COMMENT ON COLUMN "system_role"."role_name" IS '角色名称';
COMMENT ON COLUMN "system_role"."role_key" IS '角色标识';
COMMENT ON COLUMN "system_role"."order_num" IS '排序(降序)';
COMMENT ON COLUMN "system_role"."status" IS '状态:1=启用;0=禁用';
COMMENT ON COLUMN "system_role"."remark" IS '备注';
COMMENT ON COLUMN "system_role"."parent_id" IS '父级id';
COMMENT ON COLUMN "system_role"."left" IS '左树边界';
COMMENT ON COLUMN "system_role"."right" IS '右树边界';
COMMENT ON COLUMN "system_role"."lock_version" IS '锁版本号';
COMMENT ON COLUMN "system_role"."created_at" IS '创建时间';
COMMENT ON COLUMN "system_role"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "system_role"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "system_role"."updated_admin_id" IS '最后更新者(管理员)Id';
COMMENT ON COLUMN "system_role"."is_super" IS '超级管理员:1=是;0=不是';
COMMENT ON COLUMN "system_role"."data_scope" IS '数据权限:1=全部;2=组织;3=组织及以下;4=仅本人';
CREATE UNIQUE INDEX "system_role_role_key_unique" ON "system_role" USING btree ("role_key");

INSERT INTO "system_role" ("id", "role_name", "role_key", "order_num", "status", "remark", "parent_id", "left", "right", "lock_version", "created_at", "updated_at", "created_admin_id", "updated_admin_id", "is_super", "data_scope") VALUES ('635419444721483776', '三级管理员2', 'three_admin3', '997', '1', '', '635419154098159616', '3', '4', '', '2025-10-20 18:10:01.144+08:00', '2026-09-13 14:36:54.81+08:00', '604612615536115712', '604612615536115712', '0', '3'), ('635419686065930240', '三级管理员', 'three_admin', '999', '1', '', '635419154098159616', '5', '6', '', '2025-10-20 18:10:58.686+08:00', '2026-09-13 14:36:54.81+08:00', '604612615536115712', '604612615536115712', '0', '3'), ('635424437604188160', '三级管理员1', 'three_admin1', '0', '1', '', '635419154098159616', '7', '8', '', '2025-10-20 18:29:51.54+08:00', '2026-09-13 14:36:54.81+08:00', '604612615536115712', '604612615536115712', '0', '3'), ('635419154098159616', '二级管理员', 'tow_admin', '0', '1', '', '635392868638261248', '2', '9', '', '2025-10-20 18:08:51.855+08:00', '2026-09-13 14:36:54.81+08:00', '604612615536115712', '604612615536115712', '0', '3'), ('635392868638261248', '超级管理员', 'super_admin', '999', '1', '', '', '1', '12', '', '2025-10-20 16:24:24.912+08:00', '2026-09-13 14:36:54.841+08:00', '604612615536115712', '604612615536115712', '1', '3'), ('635419305097297920', '二级管理员2', 'tow_admin2', '0', '1', '', '635392868638261248', '10', '11', '', '2025-10-20 18:09:27.855+08:00', '2026-09-13 14:36:54.876+08:00', '604612615536115712', '604612615536115712', '0', '3');
UPDATE "system_role" SET data_scope = 1 WHERE  is_super = 1;
CREATE TABLE "user" (
  "id" character varying(20) NOT NULL,
  "username" character varying(50) NOT NULL DEFAULT ''::character varying,
  "nickname" character varying(20) NOT NULL DEFAULT ''::character varying,
  "password" character varying(64) NOT NULL DEFAULT ''::character varying,
  "salt" character varying(32) NOT NULL DEFAULT ''::character varying,
  "avatar_file_id" character varying(20),
  "email" character varying(100) DEFAULT NULL::character varying,
  "mobile" character varying(11) DEFAULT NULL::character varying,
  "login_failure" smallint NOT NULL DEFAULT 0,
  "last_login_at" timestamp with time zone,
  "last_login_ip" character varying(50) NOT NULL DEFAULT ''::character varying,
  "status" smallint NOT NULL DEFAULT 1,
  "deleted_at" timestamp(6) with time zone,
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "created_user_id" character varying(20),
  "updated_user_id" character varying(20),
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  CONSTRAINT "user_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "user" IS '用户表';
COMMENT ON COLUMN "user"."username" IS '用户名';
COMMENT ON COLUMN "user"."nickname" IS '昵称';
COMMENT ON COLUMN "user"."password" IS '密码';
COMMENT ON COLUMN "user"."salt" IS '密码盐';
COMMENT ON COLUMN "user"."avatar_file_id" IS '头像附件id';
COMMENT ON COLUMN "user"."email" IS '邮箱';
COMMENT ON COLUMN "user"."mobile" IS '手机号';
COMMENT ON COLUMN "user"."login_failure" IS '登录失败次数';
COMMENT ON COLUMN "user"."last_login_at" IS '登录时间';
COMMENT ON COLUMN "user"."last_login_ip" IS '登录ip';
COMMENT ON COLUMN "user"."status" IS '状态:1=启用;0=禁用';
COMMENT ON COLUMN "user"."deleted_at" IS '删除时间';
COMMENT ON COLUMN "user"."created_at" IS '创建时间';
COMMENT ON COLUMN "user"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "user"."created_user_id" IS '创建者(用户)Id';
COMMENT ON COLUMN "user"."updated_user_id" IS '最后更新者(用户)Id';
COMMENT ON COLUMN "user"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "user"."updated_admin_id" IS '最后更新者(管理员)Id';
CREATE UNIQUE INDEX "user_email_unique" ON "user" USING btree ("email") WHERE (deleted_at IS NOT NULL);
CREATE UNIQUE INDEX "user_mobile_unique" ON "user" USING btree ("mobile") WHERE (deleted_at IS NOT NULL);
CREATE UNIQUE INDEX "user_username_unique" ON "user" USING btree ("username") WHERE (deleted_at IS NOT NULL);

INSERT INTO "user" ("id", "username", "nickname", "password", "salt", "avatar_file_id", "email", "mobile", "login_failure", "last_login_at", "last_login_ip", "status", "deleted_at", "created_at", "updated_at", "created_user_id", "updated_user_id", "created_admin_id", "updated_admin_id") VALUES ('657558079876890624', 'test', '测试账户', '0872954db1998fff1a92b4ff42f8f9aeb2932e67d0c7fb96e31dfa3db3504ec5', 'c10ebfb00d8075bb9045d74b3affc81e', '755976093718020096', '1111@qq.com', NULL, '0', NULL, '', '1', NULL, '2025-12-20 20:21:03.082+08:00', '2026-09-18 10:19:07.507+08:00', NULL, '657558079876890624', NULL, '604612615536115712');

CREATE TABLE "user_file" (
  "id" character varying(20) NOT NULL,
  "name" character varying(300) NOT NULL DEFAULT ''::character varying,
  "path" character varying(200) NOT NULL DEFAULT ''::character varying,
  "mime_type" character varying(50) NOT NULL DEFAULT ''::character varying,
  "size" integer,
  "storage" character varying(50) NOT NULL DEFAULT 'storage'::character varying,
  "md5" character varying(32) NOT NULL DEFAULT ''::character varying,
  "created_user_id" character varying(20),
  "updated_user_id" character varying(20),
  "created_at" timestamp(6) with time zone NOT NULL,
  "updated_at" timestamp(6) with time zone NOT NULL,
  "created_admin_id" character varying(20),
  "updated_admin_id" character varying(20),
  CONSTRAINT "user_file_pkey" PRIMARY KEY (id)
);
COMMENT ON TABLE "user_file" IS '用户附件表(前台)';
COMMENT ON COLUMN "user_file"."name" IS '文件名';
COMMENT ON COLUMN "user_file"."path" IS '路径';
COMMENT ON COLUMN "user_file"."mime_type" IS 'mime类型';
COMMENT ON COLUMN "user_file"."size" IS '文件大小(b)';
COMMENT ON COLUMN "user_file"."storage" IS '存储引擎';
COMMENT ON COLUMN "user_file"."md5" IS '文件MD5值';
COMMENT ON COLUMN "user_file"."created_user_id" IS '创建者(用户)Id';
COMMENT ON COLUMN "user_file"."updated_user_id" IS '最后更新者(用户)Id';
COMMENT ON COLUMN "user_file"."created_at" IS '创建时间';
COMMENT ON COLUMN "user_file"."updated_at" IS '最后更新时间';
COMMENT ON COLUMN "user_file"."created_admin_id" IS '创建者(管理员)Id';
COMMENT ON COLUMN "user_file"."updated_admin_id" IS '最后更新者(管理员)Id';

INSERT INTO "user_file" ("id", "name", "path", "mime_type", "size", "storage", "md5", "created_user_id", "updated_user_id", "created_at", "updated_at", "created_admin_id", "updated_admin_id") VALUES ('694463724789956608', 'logo.png', 'c99e23ad65db6db5bea03d828fb6166e.png', 'image/png', '356830', 'local', 'c99e23ad65db6db5bea03d828fb6166e', '657558079876890624', '657558079876890624', '2026-04-01 16:30:54.503+08:00', '2026-04-01 16:30:54.503+08:00', NULL, NULL), ('755976093718020096', 'A_minimalist_flat_illustration_2026-09-18T02-17-25.png', 'b0faa183985a2a91a49fbdf94091b4cd.png', 'image/png', '442831', 'local', 'b0faa183985a2a91a49fbdf94091b4cd', NULL, NULL, '2026-09-18 10:19:06.099+08:00', '2026-09-18 10:19:06.099+08:00', '604612615536115712', '604612615536115712');