/*
Navicat Oracle Data Transfer
Oracle Client Version : 10.2.0.5.0

Source Server         : 192.168.1.22
Source Server Version : 110200
Source Host           : 192.168.1.22:1521
Source Schema         : WGCLOUD

Target Server Type    : ORACLE
Target Server Version : 110200
File Encoding         : 65001

Date: 2024-03-03 10:21:10
*/

-- ----------------------------
-- Table structure for EQUIPMENT
-- ----------------------------
CREATE TABLE "EQUIPMENT" (
"ID" VARCHAR2(32) NOT NULL ,
"EQ_NAME" VARCHAR2(50) NULL ,
"XINGHAO" VARCHAR2(50) NULL ,
"PERSON" VARCHAR2(50) NULL ,
"DEPT" VARCHAR2(50) NULL ,
"CODE" VARCHAR2(50) NULL ,
"PRICE" NUMBER NULL ,
"GONGYINGSHANG" VARCHAR2(50) NULL ,
"CAIGOU_DATE" VARCHAR2(50) NULL ,
"WEIBAO_DATE" VARCHAR2(50) NULL ,
"REMARK" VARCHAR2(255) NULL ,
"CREATE_TIME" DATE NULL ,
"GROUP_ID" VARCHAR2(500) NULL ,
"ACCOUNT" VARCHAR2(50) NULL 
);
ALTER TABLE "EQUIPMENT" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Table structure for HOST_GROUP
-- ----------------------------
CREATE TABLE "HOST_GROUP" (
"ID" VARCHAR2(32) NOT NULL ,
"GROUP_NAME" VARCHAR2(50) NULL ,
"CREATE_TIME" DATE NULL ,
"REMARK" VARCHAR2(255) NULL ,
"ACCOUNT" VARCHAR2(50) NULL ,
"GROUP_TYPE" VARCHAR2(5) NULL 
);
ALTER TABLE "HOST_GROUP" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Table structure for LOG_INFO
-- ----------------------------
CREATE TABLE "LOG_INFO" (
"ID" VARCHAR2(32) NOT NULL ,
"HOST_NAME" VARCHAR2(200) NULL ,
"INFO_CONTENT" NCLOB NULL ,
"STATE" VARCHAR2(1) NULL ,
"CREATE_TIME" DATE NOT NULL 
);
ALTER TABLE "LOG_INFO" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Table structure for MAIL_SET
-- ----------------------------
CREATE TABLE "MAIL_SET" (
"ID" VARCHAR2(32) NOT NULL ,
"SEND_MAIL" VARCHAR2(60) NULL ,
"FROM_MAIL_NAME" VARCHAR2(60) NULL ,
"FROM_PWD" VARCHAR2(100) NULL ,
"SMTP_HOST" VARCHAR2(100) NULL ,
"SMTP_PORT" VARCHAR2(30) NULL ,
"SMTP_SSL" VARCHAR2(30) NULL ,
"TO_MAIL" VARCHAR2(300) NULL ,
"CPU_PER" VARCHAR2(30) NULL ,
"CREATE_TIME" DATE NULL ,
"ACTIVE" VARCHAR2(30) NULL ,
"JAVAX_MAIL" VARCHAR2(30) NULL 
);
ALTER TABLE "MAIL_SET" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Table structure for ACCOUNT_INFO
-- ----------------------------
CREATE TABLE "ACCOUNT_INFO" (
"ID" VARCHAR2(32) NOT NULL ,
"ACCOUNT" VARCHAR2(50) NULL ,
"EMAIL" VARCHAR2(200) NULL ,
"PASSWD" VARCHAR2(50) NULL ,
"ACCOUNT_KEY" VARCHAR2(50) NULL ,
"REMARK" VARCHAR2(50) NULL ,
"MENU_IDS" VARCHAR2(200) NULL ,
"ACCOUNT_ROLE" VARCHAR2(10) NULL ,
"REAL_NAME" VARCHAR2(50) NULL ,
"DEPT_NAME" VARCHAR2(50) NULL ,
"STATE" VARCHAR2(1) NULL ,
"CREATE_TIME" DATE NULL 
);
ALTER TABLE "ACCOUNT_INFO" ADD PRIMARY KEY ("ID");

CREATE TABLE "PASSWD_INFO" (
  "ID" VARCHAR2(32) NOT NULL,
  "HOST_NAME" VARCHAR2(100) NULL,
  "HOST_ACCOUNT" VARCHAR2(50) NULL,
  "HOST_PASSWD" VARCHAR2(100) NULL,
  "HOST_REMARK" VARCHAR2(300) NULL,
  "ACCOUNT" VARCHAR2(50) NULL,
  "GROUP_ID" VARCHAR2(500)NULL,
  "HOST_MARK" VARCHAR2(100)NULL,
  "CREATE_TIME" DATE NULL
);
ALTER TABLE "PASSWD_INFO" ADD PRIMARY KEY ("ID");

CREATE TABLE "SHELL_NOTE_INFO" (
"ID" VARCHAR2(32) NOT NULL,
"SHELL_TITLE" VARCHAR2(100) NULL,
"SHELL_CONTENT" NCLOB NULL,
"ACCOUNT" VARCHAR2(50) NULL,
"CREATE_TIME" DATE NULL 
);
ALTER TABLE "SHELL_NOTE_INFO" ADD PRIMARY KEY ("ID");

CREATE TABLE "WORK_INFO" (
"ID" VARCHAR2(32) NOT NULL,
"WORK_TITLE" VARCHAR2(100) NULL,
"WORK_CONTENT" VARCHAR2(3000) NULL,
"STATE" VARCHAR2(1) NULL,
"WORK_TYPE" VARCHAR2(50) NULL,
"ADD_ACCOUNT" VARCHAR2(50) NULL,
"ADD_ACCOUNT_NAME" VARCHAR2(50) NULL,
"ACCEPT_ACCOUNT" VARCHAR2(50) NULL,
"ACCEPT_ACCOUNT_NAME" VARCHAR2(50) NULL,
"GROUP_ID" VARCHAR2(500) NULL ,
"WORK_CODE" NUMBER(11) NULL ,
"WORK_LEVEL" VARCHAR2(10) NULL ,
"WORK_PRIVATE" VARCHAR2(10) NULL ,
"UPDATE_TIME" DATE NULL,
"CREATE_TIME" DATE NULL 
);
ALTER TABLE "WORK_INFO" ADD PRIMARY KEY ("ID");

CREATE TABLE "WORK_HANDLE_INFO" (
"ID" VARCHAR2(32) NOT NULL,
"WORK_INFO_ID" VARCHAR2(32) NULL,
"WORK_CONTENT" VARCHAR2(2000) NULL,
"STATE" VARCHAR2(1) NULL,
"ACCEPT_ACCOUNT_NAME" VARCHAR2(50) NULL,
"HANDLE_ACCOUNT_NAME" VARCHAR2(50) NULL,
"CREATE_TIME" DATE NULL 
);
ALTER TABLE "WORK_HANDLE_INFO" ADD PRIMARY KEY ("ID");

CREATE TABLE "WORK_FILE_INFO" (
"ID" VARCHAR2(32) NOT NULL,
"WORK_INFO_ID" VARCHAR2(32) NULL,
"FILE_NAME" VARCHAR2(100) NULL,
"FILE_PATH" VARCHAR2(200) NULL,
"FILE_SIZE" VARCHAR2(20) NULL,
"CREATE_TIME" DATE NULL 
);
ALTER TABLE "WORK_FILE_INFO" ADD PRIMARY KEY ("ID");