56 lines
2.1 KiB
SQL
56 lines
2.1 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : localxiuos
|
|
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: 30/08/2023 09:42:24
|
|
*/
|
|
|
|
DROP SEQUENCE IF EXISTS "public"."seq_firmware_info";
|
|
CREATE SEQUENCE "public"."seq_firmware_info"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
ALTER SEQUENCE "public"."seq_firmware_info" OWNER TO "xiuosiot";
|
|
-- ----------------------------
|
|
-- Table structure for firmware_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."firmware_info";
|
|
CREATE TABLE "public"."firmware_info" (
|
|
"id" int4 NOT NULL DEFAULT nextval('seq_firmware_info'::regclass),
|
|
"file_name" varchar(32) COLLATE "pg_catalog"."default",
|
|
"file_version" varchar(32) COLLATE "pg_catalog"."default",
|
|
"create_time" timestamp(6),
|
|
"file_md5" varchar(64) COLLATE "pg_catalog"."default",
|
|
"file_desc" varchar(100) COLLATE "pg_catalog"."default",
|
|
"org" varchar(32) COLLATE "pg_catalog"."default",
|
|
"verify" varchar(32) COLLATE "pg_catalog"."default",
|
|
"file_size" int4
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."firmware_info"."id" IS '主键';
|
|
COMMENT ON COLUMN "public"."firmware_info"."file_name" IS '固件名';
|
|
COMMENT ON COLUMN "public"."firmware_info"."file_version" IS '固件版本';
|
|
COMMENT ON COLUMN "public"."firmware_info"."create_time" IS '上传时间';
|
|
COMMENT ON COLUMN "public"."firmware_info"."file_md5" IS 'md5码';
|
|
COMMENT ON COLUMN "public"."firmware_info"."file_desc" IS '固件描述';
|
|
COMMENT ON COLUMN "public"."firmware_info"."org" IS '所属企业';
|
|
COMMENT ON COLUMN "public"."firmware_info"."verify" IS '验证状态 未验证 验证成功 验证失败';
|
|
COMMENT ON COLUMN "public"."firmware_info"."file_size" IS '文件数量';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table firmware_info
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."firmware_info" ADD CONSTRAINT "firmware_info_pkey" PRIMARY KEY ("id");
|