63 lines
3.1 KiB
SQL
63 lines
3.1 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : localdsd
|
||
Source Server Type : PostgreSQL
|
||
Source Server Version : 120012
|
||
Source Host : localhost:5432
|
||
Source Catalog : xiuosiot
|
||
Source Schema : public
|
||
|
||
Target Server Type : PostgreSQL
|
||
Target Server Version : 120012
|
||
File Encoding : 65001
|
||
|
||
Date: 09/10/2022 20:15:09
|
||
*/
|
||
|
||
|
||
-- ----------------------------
|
||
-- Table structure for user_info
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS "public"."user_info";
|
||
CREATE TABLE "public"."user_info" (
|
||
"id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
||
"username" varchar(16) COLLATE "pg_catalog"."default",
|
||
"password" varchar(16) COLLATE "pg_catalog"."default",
|
||
"realname" varchar(16) COLLATE "pg_catalog"."default",
|
||
"phonenum" int4,
|
||
"updatetime" varchar(32) COLLATE "pg_catalog"."default",
|
||
"lastlogintime" varchar(32) COLLATE "pg_catalog"."default",
|
||
"lastloginip" varchar(32) COLLATE "pg_catalog"."default",
|
||
"org" varchar(32) COLLATE "pg_catalog"."default",
|
||
"corpname" varchar(255) COLLATE "pg_catalog"."default",
|
||
"abbrCorpName" varchar(255) COLLATE "pg_catalog"."default",
|
||
"permissions" varchar(255) COLLATE "pg_catalog"."default"
|
||
)
|
||
;
|
||
COMMENT ON COLUMN "public"."user_info"."id" IS '主键id，以时间戳递增';
|
||
COMMENT ON COLUMN "public"."user_info"."username" IS '用户名';
|
||
COMMENT ON COLUMN "public"."user_info"."password" IS '用户密码';
|
||
COMMENT ON COLUMN "public"."user_info"."realname" IS '真实姓名';
|
||
COMMENT ON COLUMN "public"."user_info"."phonenum" IS '电话';
|
||
COMMENT ON COLUMN "public"."user_info"."updatetime" IS '更新时间';
|
||
COMMENT ON COLUMN "public"."user_info"."lastlogintime" IS '最后登录时间';
|
||
COMMENT ON COLUMN "public"."user_info"."lastloginip" IS '最后登录ip';
|
||
COMMENT ON COLUMN "public"."user_info"."org" IS '所属公司';
|
||
COMMENT ON COLUMN "public"."user_info"."corpname" IS '公司名';
|
||
COMMENT ON COLUMN "public"."user_info"."abbrCorpName" IS '公司缩写';
|
||
COMMENT ON COLUMN "public"."user_info"."permissions" IS '权限';
|
||
|
||
-- ----------------------------
|
||
-- Records of user_info
|
||
-- ----------------------------
|
||
INSERT INTO "public"."user_info" VALUES ('20220915170504-xdl-dsd', 'xdl', '123456', 'boss', 1768872661, NULL, '2022-09-15 17:05:04', '127.0.0.1', 'dsd', '浙江大胜达包装股份有限公司', '大胜达', 'dashengda');
|
||
INSERT INTO "public"."user_info" VALUES ('1', 'wty', '123456', NULL, NULL, NULL, '2022-10-09 11:35:30', '127.0.0.1', 'dsd', '浙江大胜达包装股份有限公司', '大胜达', 'dashengda');
|
||
INSERT INTO "public"."user_info" VALUES ('2', 'aiitxios', 'xiosaiit', NULL, NULL, NULL, '2022-10-09 16:32:15', '127.0.0.1', 'dsd', '浙江大胜达包装股份有限公司', '大胜达', 'dashengda');
|
||
INSERT INTO "public"."user_info" VALUES ('3', 'hangxiao', 'hangxiao', NULL, NULL, NULL, '2022-10-09 16:27:44', '127.0.0.1', 'hxgg', '杭萧钢构股份有限公司', '杭萧钢构', '');
|
||
|
||
-- ----------------------------
|
||
-- Primary Key structure for table user_info
|
||
-- ----------------------------
|
||
ALTER TABLE "public"."user_info" ADD CONSTRAINT "user_info_pkey" PRIMARY KEY ("id");
|