From bd772e79514f6a0109329d6feb7e99ba10d4b67a Mon Sep 17 00:00:00 2001
From: ’zhaoyh6‘ <zhaoyh6@asiainfo.com>
Date: Sat, 18 Sep 2021 15:55:13 +0800
Subject: feat:Add file transfer function

Issue-ID: USECASEUI-605
Signed-off-by: zhaoyh6 <zhaoyh6@asiainfo.com>
Change-Id: Iae729bc56718839bad8c49408b0f50c020909765
---
 .../dbscripts/postgres/uui_create_table.sql        | 54 ++++++++++++++++++++++
 1 file changed, 54 insertions(+)

(limited to 'standalone')

diff --git a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
index eb953e57..c1fb78f0 100644
--- a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
+++ b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_table.sql
@@ -146,3 +146,57 @@ CREATE TABLE sort_master  (
   "language" varchar(50) NOT NULL,
   CONSTRAINT sort_master_pk PRIMARY KEY (sort_type, sort_code, language)
 );
+
+-- ----------------------------
+-- Table structure for sort_master
+-- ----------------------------
+DROP TABLE IF EXISTS instance_performance;
+CREATE TABLE instance_performance
+(
+    id                   integer not null,
+    job_id               varchar(32),
+    resource_instance_id varchar(64),
+    bandwidth            numeric,
+    date                 date,
+    max_bandwidth        numeric,
+    CONSTRAINT instance_performance_pk PRIMARY KEY (id)
+);
+
+-- ----------------------------
+-- Table structure for intent_instance
+-- ----------------------------
+DROP TABLE IF EXISTS intent_instance;
+CREATE TABLE intent_instance
+(
+    id                          serial not null
+        constraint intent_instance_pk
+            primary key,
+    instance_id                 varchar(16),
+    job_id                      varchar(16),
+    progress                    integer,
+    status                      char,
+    resource_instance_id        varchar(16),
+    name                        varchar(255),
+    cloud_point_name            varchar(255),
+    access_point_one_name       varchar(255),
+    access_point_one_band_width integer,
+    line_num                    varchar(64),
+    delete_state                integer default 0
+);
+
+-- ----------------------------
+-- Table structure for intent_model
+-- ----------------------------
+DROP TABLE IF EXISTS intent_model;
+create table intent_model
+(
+    id          serial not null
+        constraint intent_model_pk
+            primary key,
+    model_name  varchar(100) default NULL::character varying,
+    file_path   varchar(500) default NULL::character varying,
+    create_time varchar(100) default NULL::character varying,
+    size        numeric(10, 3),
+    active      integer,
+    "modelType" integer      default 0
+);
-- 
cgit 1.2.3-korg