--------------------------------------------------------
--  File created - Wednesday-June-20-2018   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_ADMIN
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_ADMIN"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 141 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_CERTIFICATION
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_CERTIFICATION"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 301 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_COLUMN
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_COLUMN"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1061 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_CUSTOMIZED
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_CUSTOMIZED"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_DATABASE
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_DATABASE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 341 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_REPORT
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_REPORT"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 181 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_TABLE
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_TABLE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 441 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Sequence SEQ_AI_USER
--------------------------------------------------------

   CREATE SEQUENCE  "DI"."SEQ_AI_USER"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  GLOBAL ;
--------------------------------------------------------
--  DDL for Table T_ANALYSIS_CUSTOMIZED
--------------------------------------------------------

  CREATE TABLE "DI"."T_ANALYSIS_CUSTOMIZED" 
   (	"AID" NUMBER(*,0), 
	"USERID" NUMBER(*,0), 
	"GENERATEDATE" DATE, 
	"DESCRIPTION" VARCHAR2(256 BYTE), 
	"SCRIPT" VARCHAR2(4000 BYTE)
   ) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_ANALYSIS_CUSTOMIZED"."AID" IS '?????ID';
   COMMENT ON COLUMN "DI"."T_ANALYSIS_CUSTOMIZED"."USERID" IS '????';
   COMMENT ON COLUMN "DI"."T_ANALYSIS_CUSTOMIZED"."GENERATEDATE" IS '????';
   COMMENT ON COLUMN "DI"."T_ANALYSIS_CUSTOMIZED"."DESCRIPTION" IS '????';
   COMMENT ON COLUMN "DI"."T_ANALYSIS_CUSTOMIZED"."SCRIPT" IS '????';
--------------------------------------------------------
--  DDL for Table T_DATABASE_CERTIFICATION
--------------------------------------------------------

  CREATE TABLE "DI"."T_DATABASE_CERTIFICATION" 
   (	"CID" NUMBER(*,0), 
	"USERID" NUMBER(*,0), 
	"DID" NUMBER(*,0), 
	"USERNAME" VARCHAR2(64 BYTE), 
	"PASSWORD" VARCHAR2(64 BYTE), 
	"PRIVILEGE" VARCHAR2(128 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DATABASE_CERTIFICATION"."CID" IS '??ID';
   COMMENT ON COLUMN "DI"."T_DATABASE_CERTIFICATION"."USERID" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_CERTIFICATION"."DID" IS '?????';
   COMMENT ON COLUMN "DI"."T_DATABASE_CERTIFICATION"."USERNAME" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_CERTIFICATION"."PASSWORD" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_CERTIFICATION"."PRIVILEGE" IS '????';
--------------------------------------------------------
--  DDL for Table T_DATABASE_COLUMN
--------------------------------------------------------

  CREATE TABLE "DI"."T_DATABASE_COLUMN" 
   (	"COLID" NUMBER(*,0), 
	"TID" NUMBER(*,0), 
	"DID" NUMBER(*,0), 
	"USERID" NUMBER(*,0), 
	"COLUMNNAME" VARCHAR2(32 BYTE), 
	"DATATYPE" VARCHAR2(32 BYTE), 
	"ISPRIMARY" NUMBER(*,0), 
	"ISFOREIGNKEY" NUMBER(*,0), 
	"FOREIGNKEYREF" NUMBER(*,0)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."COLID" IS '?ID';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."TID" IS '???';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."DID" IS '?????';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."USERID" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."COLUMNNAME" IS '??';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."DATATYPE" IS '?????';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."ISPRIMARY" IS '?????';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."ISFOREIGNKEY" IS '?????';
   COMMENT ON COLUMN "DI"."T_DATABASE_COLUMN"."FOREIGNKEYREF" IS '?????ID';
--------------------------------------------------------
--  DDL for Table T_DATABASE_INFO
--------------------------------------------------------

  CREATE TABLE "DI"."T_DATABASE_INFO" 
   (	"DID" NUMBER(*,0), 
	"USERID" NUMBER(*,0), 
	"NAME" VARCHAR2(128 BYTE), 
	"HOST" VARCHAR2(128 BYTE), 
	"ADDDATE" DATE, 
	"LASTVISIT" DATE, 
	"DBTYPE" NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."DID" IS '???ID';
   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."USERID" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."NAME" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."HOST" IS '???????';
   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."ADDDATE" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."LASTVISIT" IS '??????';
   COMMENT ON COLUMN "DI"."T_DATABASE_INFO"."DBTYPE" IS '?????';
--------------------------------------------------------
--  DDL for Table T_DATABASE_REPORT
--------------------------------------------------------

  CREATE TABLE "DI"."T_DATABASE_REPORT" 
   (	"RID" NUMBER(*,0), 
	"USERID" NUMBER(*,0), 
	"TITLE" VARCHAR2(64 BYTE), 
	"GENERATEDATE" DATE, 
	"DESCRIPTION" VARCHAR2(1200 BYTE), 
	"REPORTCONTENT" CLOB, 
	"RELATION" VARCHAR2(1000 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" 
 LOB ("REPORTCONTENT") STORE AS SECUREFILE (
  TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192
  NOCACHE LOGGING  NOCOMPRESS  KEEP_DUPLICATES 
  STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;

   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."RID" IS '??ID';
   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."USERID" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."TITLE" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."GENERATEDATE" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."DESCRIPTION" IS ' ????';
   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."REPORTCONTENT" IS '????';
   COMMENT ON COLUMN "DI"."T_DATABASE_REPORT"."RELATION" IS '???';
--------------------------------------------------------
--  DDL for Table T_DATABASE_TABLE
--------------------------------------------------------

  CREATE TABLE "DI"."T_DATABASE_TABLE" 
   (	"TID" NUMBER(*,0), 
	"DID" NUMBER(*,0), 
	"TNAME" VARCHAR2(256 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DATABASE_TABLE"."TID" IS '?ID';
   COMMENT ON COLUMN "DI"."T_DATABASE_TABLE"."DID" IS '?????';
   COMMENT ON COLUMN "DI"."T_DATABASE_TABLE"."TNAME" IS '??';
--------------------------------------------------------
--  DDL for Table T_DI_ADMIN
--------------------------------------------------------

  CREATE TABLE "DI"."T_DI_ADMIN" 
   (	"ADMINID" NUMBER(*,0), 
	"USERNAME" VARCHAR2(32 BYTE), 
	"PASSWORD" VARCHAR2(64 BYTE), 
	"EMAIL" VARCHAR2(128 BYTE), 
	"LASTLOGIN" DATE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DI_ADMIN"."ADMINID" IS '???ID';
   COMMENT ON COLUMN "DI"."T_DI_ADMIN"."USERNAME" IS '??????';
   COMMENT ON COLUMN "DI"."T_DI_ADMIN"."PASSWORD" IS '?????';
   COMMENT ON COLUMN "DI"."T_DI_ADMIN"."EMAIL" IS '?????';
   COMMENT ON COLUMN "DI"."T_DI_ADMIN"."LASTLOGIN" IS '??????';
--------------------------------------------------------
--  DDL for Table T_DI_LOG
--------------------------------------------------------

  CREATE TABLE "DI"."T_DI_LOG" 
   (	"LID" NUMBER(*,0), 
	"USERID" NUMBER(*,0), 
	"LTYPE" NUMBER(*,0), 
	"LDATE" DATE, 
	"LDBNAME" VARCHAR2(50 BYTE), 
	"LTNAME" VARCHAR2(50 BYTE), 
	"LMESSAGE" VARCHAR2(200 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DI_LOG"."LID" IS '??ID???';
   COMMENT ON COLUMN "DI"."T_DI_LOG"."USERID" IS '??ID,??';
   COMMENT ON COLUMN "DI"."T_DI_LOG"."LTYPE" IS '???? 1-?? 2-?? 3-??';
   COMMENT ON COLUMN "DI"."T_DI_LOG"."LDATE" IS '?????????';
   COMMENT ON COLUMN "DI"."T_DI_LOG"."LDBNAME" IS '????';
   COMMENT ON COLUMN "DI"."T_DI_LOG"."LTNAME" IS '??';
   COMMENT ON COLUMN "DI"."T_DI_LOG"."LMESSAGE" IS '????';
--------------------------------------------------------
--  DDL for Table T_DI_USER
--------------------------------------------------------

  CREATE TABLE "DI"."T_DI_USER" 
   (	"USERID" NUMBER(*,0), 
	"USERNAME" VARCHAR2(32 BYTE), 
	"PASSWORD" VARCHAR2(64 BYTE), 
	"STATUS" NUMBER(*,0), 
	"LASTLOGIN" DATE, 
	"EMAIL" VARCHAR2(32 BYTE), 
	"USESSION" VARCHAR2(128 BYTE)
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;

   COMMENT ON COLUMN "DI"."T_DI_USER"."USERID" IS '??ID';
   COMMENT ON COLUMN "DI"."T_DI_USER"."USERNAME" IS '???';
   COMMENT ON COLUMN "DI"."T_DI_USER"."PASSWORD" IS '????';
   COMMENT ON COLUMN "DI"."T_DI_USER"."STATUS" IS '????';
   COMMENT ON COLUMN "DI"."T_DI_USER"."LASTLOGIN" IS '??????';
   COMMENT ON COLUMN "DI"."T_DI_USER"."EMAIL" IS '????';
   COMMENT ON COLUMN "DI"."T_DI_USER"."USESSION" IS '????SESSION
 ';
REM INSERTING into DI.T_ANALYSIS_CUSTOMIZED
SET DEFINE OFF;
REM INSERTING into DI.T_DATABASE_CERTIFICATION
SET DEFINE OFF;
Insert into DI.T_DATABASE_CERTIFICATION (CID,USERID,DID,USERNAME,PASSWORD,PRIVILEGE) values (263,48,303,'di','DI2017',null);
Insert into DI.T_DATABASE_CERTIFICATION (CID,USERID,DID,USERNAME,PASSWORD,PRIVILEGE) values (265,43,305,'dbitest','dbitest',null);
Insert into DI.T_DATABASE_CERTIFICATION (CID,USERID,DID,USERNAME,PASSWORD,PRIVILEGE) values (281,43,321,'boss','111111',null);
Insert into DI.T_DATABASE_CERTIFICATION (CID,USERID,DID,USERNAME,PASSWORD,PRIVILEGE) values (264,43,304,'di','DI2017',null);
REM INSERTING into DI.T_DATABASE_COLUMN
SET DEFINE OFF;
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (853,399,303,48,'PASSWORD','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (854,399,303,48,'STATUS','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (855,399,303,48,'LASTLOGIN','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (856,399,303,48,'EMAIL','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (857,399,303,48,'USESSION','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (858,400,303,48,'RID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (859,400,303,48,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (860,400,303,48,'TITLE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (861,400,303,48,'GENERATEDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (862,400,303,48,'DESCRIPTION','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (863,400,303,48,'CHARTSDATA','CLOB',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (864,401,303,48,'CID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (865,401,303,48,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (866,401,303,48,'DID','NUMBER',0,1,875);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (867,401,303,48,'USERNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (868,401,303,48,'PASSWORD','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (869,401,303,48,'PRIVILEGE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (870,402,303,48,'AID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (871,402,303,48,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (872,402,303,48,'GENERATEDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (873,402,303,48,'DESCRIPTION','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (874,402,303,48,'SCRIPT','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (875,403,303,48,'DID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (876,403,303,48,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (877,403,303,48,'NAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (878,403,303,48,'HOST','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (879,403,303,48,'ADDDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (880,403,303,48,'LASTVISIT','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (881,403,303,48,'DBTYPE','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (882,404,303,48,'TID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (883,404,303,48,'DID','NUMBER',0,1,875);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (884,404,303,48,'TNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (885,405,303,48,'ADMINID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (886,405,303,48,'USERNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (887,405,303,48,'PASSWORD','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (888,405,303,48,'EMAIL','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (889,405,303,48,'LASTLOGIN','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (890,406,303,48,'COLID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (891,406,303,48,'TID','NUMBER',0,1,882);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (892,406,303,48,'DID','NUMBER',0,1,875);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (893,406,303,48,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (894,406,303,48,'COLUMNNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (895,406,303,48,'DATATYPE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (896,406,303,48,'ISPRIMARY','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (897,406,303,48,'ISFOREIGNKEY','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (898,406,303,48,'FOREIGNKEYREF','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (899,407,303,48,'LID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (900,407,303,48,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (901,407,303,48,'LTYPE','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (902,407,303,48,'LDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (903,407,303,48,'LDBNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (904,407,303,48,'LTNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (905,407,303,48,'LMESSAGE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (851,399,303,48,'USERID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (852,399,303,48,'USERNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (908,408,304,43,'PASSWORD','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (909,408,304,43,'STATUS','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (910,408,304,43,'LASTLOGIN','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (911,408,304,43,'EMAIL','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (912,408,304,43,'USESSION','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (913,409,304,43,'RID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (914,409,304,43,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (915,409,304,43,'TITLE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (916,409,304,43,'GENERATEDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (917,409,304,43,'DESCRIPTION','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (918,409,304,43,'CHARTSDATA','CLOB',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (919,410,304,43,'CID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (920,410,304,43,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (921,410,304,43,'DID','NUMBER',0,1,875);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (922,410,304,43,'USERNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (923,410,304,43,'PASSWORD','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (924,410,304,43,'PRIVILEGE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (925,411,304,43,'AID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (926,411,304,43,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (927,411,304,43,'GENERATEDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (928,411,304,43,'DESCRIPTION','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (929,411,304,43,'SCRIPT','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (930,412,304,43,'DID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (931,412,304,43,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (932,412,304,43,'NAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (933,412,304,43,'HOST','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (934,412,304,43,'ADDDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (935,412,304,43,'LASTVISIT','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (936,412,304,43,'DBTYPE','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (937,413,304,43,'TID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (938,413,304,43,'DID','NUMBER',0,1,875);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (939,413,304,43,'TNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (940,414,304,43,'ADMINID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (941,414,304,43,'USERNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (942,414,304,43,'PASSWORD','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (943,414,304,43,'EMAIL','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (944,414,304,43,'LASTLOGIN','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (945,415,304,43,'COLID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (946,415,304,43,'TID','NUMBER',0,1,882);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (947,415,304,43,'DID','NUMBER',0,1,875);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (948,415,304,43,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (949,415,304,43,'COLUMNNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (950,415,304,43,'DATATYPE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (951,415,304,43,'ISPRIMARY','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (952,415,304,43,'ISFOREIGNKEY','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (953,415,304,43,'FOREIGNKEYREF','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (954,416,304,43,'LID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (955,416,304,43,'USERID','NUMBER',0,1,851);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (956,416,304,43,'LTYPE','NUMBER',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (957,416,304,43,'LDATE','DATE',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (958,416,304,43,'LDBNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (959,416,304,43,'LTNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (960,416,304,43,'LMESSAGE','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (961,417,305,43,'stunum','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (962,417,305,43,'name','text',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (906,408,304,43,'USERID','NUMBER',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (907,408,304,43,'USERNAME','VARCHAR2',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (963,417,305,43,'gender','text',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (964,417,305,43,'sum','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (965,417,305,43,'basis','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (966,417,305,43,'addition','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (967,417,305,43,'c','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (968,418,305,43,'num','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (969,418,305,43,'stunum','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (970,418,305,43,'name','text',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (971,418,305,43,'one','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (972,418,305,43,'six','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (973,418,305,43,'abandonce','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (974,418,305,43,'abancetime','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (975,418,305,43,'score','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (976,418,305,43,'sum','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (981,421,321,43,'serv_id','int',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (982,421,321,43,'user_id','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (983,421,321,43,'serv_name','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (984,421,321,43,'serv_type','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (985,421,321,43,'serv_submit_time','datetime',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (986,421,321,43,'serv_end_time','datetime',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (987,421,321,43,'serv_begin_time','datetime',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (988,421,321,43,'serv_finish_time','datetime',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (989,421,321,43,'serv_content','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (990,421,321,43,'serv_status','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (991,421,321,43,'serv_comm','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (992,422,321,43,'Host','char',1,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (993,422,321,43,'User','char',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (994,422,321,43,'Password','char',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (995,422,321,43,'Select_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (996,422,321,43,'Insert_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (997,422,321,43,'Update_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (998,422,321,43,'Delete_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (999,422,321,43,'Create_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1000,422,321,43,'Drop_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1001,422,321,43,'Reload_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1002,422,321,43,'Shutdown_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1003,422,321,43,'Process_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1004,422,321,43,'File_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1005,422,321,43,'Grant_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1006,422,321,43,'References_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1007,422,321,43,'Index_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1008,422,321,43,'Alter_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1009,422,321,43,'Show_db_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1010,422,321,43,'Super_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1011,422,321,43,'Create_tmp_table_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1012,422,321,43,'Lock_tables_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1013,422,321,43,'Execute_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1014,422,321,43,'Repl_slave_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1015,422,321,43,'Repl_client_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1016,422,321,43,'Create_view_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1017,422,321,43,'Show_view_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1018,422,321,43,'Create_routine_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1019,422,321,43,'Alter_routine_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1020,422,321,43,'Create_user_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1021,422,321,43,'Event_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1022,422,321,43,'Trigger_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1023,422,321,43,'Create_tablespace_priv','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1024,422,321,43,'ssl_type','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1025,422,321,43,'ssl_cipher','blob',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1026,422,321,43,'x509_issuer','blob',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1027,422,321,43,'x509_subject','blob',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1028,422,321,43,'max_questions','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1029,422,321,43,'max_updates','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1030,422,321,43,'max_connections','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1031,422,321,43,'max_user_connections','int',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1032,422,321,43,'plugin','char',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1033,422,321,43,'authentication_string','text',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1034,422,321,43,'password_expired','enum',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1035,422,321,43,'user_id','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1036,422,321,43,'user_name','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1037,422,321,43,'password','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1038,422,321,43,'user_sex','tinyint',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1039,422,321,43,'user_phone','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1040,422,321,43,'user_address','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1041,422,321,43,'user_id','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1042,422,321,43,'password','varchar',0,0,null);
Insert into DI.T_DATABASE_COLUMN (COLID,TID,DID,USERID,COLUMNNAME,DATATYPE,ISPRIMARY,ISFOREIGNKEY,FOREIGNKEYREF) values (1043,422,321,43,'user_name','varchar',0,0,null);
REM INSERTING into DI.T_DATABASE_INFO
SET DEFINE OFF;
Insert into DI.T_DATABASE_INFO (DID,USERID,NAME,HOST,ADDDATE,LASTVISIT,DBTYPE) values (303,48,'DatabaseInsights','cd.kcs.akakanch.com',to_date('15-JUN-18','DD-MON-RR'),null,1000);
Insert into DI.T_DATABASE_INFO (DID,USERID,NAME,HOST,ADDDATE,LASTVISIT,DBTYPE) values (321,43,'ss','123.207.114.186',to_date('18-JUN-18','DD-MON-RR'),null,2000);
Insert into DI.T_DATABASE_INFO (DID,USERID,NAME,HOST,ADDDATE,LASTVISIT,DBTYPE) values (304,43,'DatabaseInsights','cd.kcs.akakanch.com',to_date('15-JUN-18','DD-MON-RR'),null,1000);
Insert into DI.T_DATABASE_INFO (DID,USERID,NAME,HOST,ADDDATE,LASTVISIT,DBTYPE) values (305,43,'DBITEST','cd.kcs.akakanch.com',to_date('15-JUN-18','DD-MON-RR'),null,2000);
REM INSERTING into DI.T_DATABASE_REPORT
SET DEFINE OFF;
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (141,43,'DatabaseInsights ??????',to_date('17-JUN-18','DD-MON-RR'),'???????????????????????
??????????? Alphabet ????????? DeepMind ????????????????????????????????? AI ????????????????????“??”?????????????????????????DeepMind ?????????????????????????? 2D ????????? 3D ?????','DatabaseInsights->T_DI_USER;');
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (111,43,'title',to_date('07-MAY-04','DD-MON-RR'),'discrition',null);
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (103,48,'no title specified',to_date('16-JUN-18','DD-MON-RR'),' ',null);
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (122,43,'?????????????',to_date('16-JUN-18','DD-MON-RR'),'?????????? DatabaseInsights????????????????????????','DatabaseInsights->T_DI_USER;');
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (102,48,'mmmddd',to_date('16-JUN-18','DD-MON-RR'),'descrot',null);
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (104,48,'no title specified',to_date('16-JUN-18','DD-MON-RR'),' ',null);
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (106,43,'no title specified',to_date('16-JUN-18','DD-MON-RR'),' ',null);
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (161,43,'Score of Java',to_date('18-JUN-18','DD-MON-RR'),'This report shows the distributions for make up of java score. In this report ou can gain a lost of knowlodges .
First of all, .....','DBITEST->javascore;');
Insert into DI.T_DATABASE_REPORT (RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,RELATION) values (105,48,'no title specified',to_date('16-JUN-18','DD-MON-RR'),' ',null);
REM INSERTING into DI.T_DATABASE_TABLE
SET DEFINE OFF;
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (401,303,'T_DATABASE_CERTIFICATION');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (402,303,'T_ANALYSIS_CUSTOMIZED');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (403,303,'T_DATABASE_INFO');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (404,303,'T_DATABASE_TABLE');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (405,303,'T_DI_ADMIN');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (406,303,'T_DATABASE_COLUMN');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (407,303,'T_DI_LOG');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (399,303,'T_DI_USER');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (400,303,'T_DATABASE_REPORT');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (410,304,'T_DATABASE_CERTIFICATION');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (411,304,'T_ANALYSIS_CUSTOMIZED');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (412,304,'T_DATABASE_INFO');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (413,304,'T_DATABASE_TABLE');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (414,304,'T_DI_ADMIN');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (415,304,'T_DATABASE_COLUMN');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (416,304,'T_DI_LOG');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (408,304,'T_DI_USER');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (417,305,'dfy');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (418,305,'javascore');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (409,304,'T_DATABASE_REPORT');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (421,321,'service');
Insert into DI.T_DATABASE_TABLE (TID,DID,TNAME) values (422,321,'user');
REM INSERTING into DI.T_DI_ADMIN
SET DEFINE OFF;
REM INSERTING into DI.T_DI_LOG
SET DEFINE OFF;
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (81,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (84,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (86,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (90,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (95,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (109,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (55,43,1000,to_date('17-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (69,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (120,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_LOG','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (125,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (68,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (71,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (73,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (56,43,1000,to_date('17-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (57,43,1000,to_date('17-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (76,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (78,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (89,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (92,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (98,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (104,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (106,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (110,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (113,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (114,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (117,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (121,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (126,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (130,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (65,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (66,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (80,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (83,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (85,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (87,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (94,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (96,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (99,43,1000,to_date('18-JUN-18','DD-MON-RR'),'N/A','N/A','create a new report with title Score of Java');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (100,43,1000,to_date('18-JUN-18','DD-MON-RR'),'N/A','N/A','create a new report with title Score of Java');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (101,43,1000,to_date('18-JUN-18','DD-MON-RR'),'N/A','N/A','create a new report with title Score of Java');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (102,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (107,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (112,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (118,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (122,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (127,43,1000,to_date('18-JUN-18','DD-MON-RR'),'ss','service','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (131,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (75,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (22,43,1010,to_date('17-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','try to login, but password incorrect.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (77,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (88,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (91,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (103,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (64,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (70,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (108,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (115,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (123,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (128,43,1000,to_date('18-JUN-18','DD-MON-RR'),'ss','service','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (129,43,1000,to_date('18-JUN-18','DD-MON-RR'),'ss','service','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (61,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_USER','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (62,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (63,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (67,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (58,43,1000,to_date('17-JUN-18','DD-MON-RR'),'N/A','N/A','create a new report with title DatabaseInsights ??????');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (59,43,1000,to_date('17-JUN-18','DD-MON-RR'),'N/A','N/A','create a new report with title DatabaseInsights ??????');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (72,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (74,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (79,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (82,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (93,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (97,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform customize analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (105,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (111,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','javascore','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (116,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (119,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DatabaseInsights','T_DI_LOG','perform automatic analysis.');
Insert into DI.T_DI_LOG (LID,USERID,LTYPE,LDATE,LDBNAME,LTNAME,LMESSAGE) values (124,43,1000,to_date('18-JUN-18','DD-MON-RR'),'DBITEST','dfy','perform automatic analysis.');
REM INSERTING into DI.T_DI_USER
SET DEFINE OFF;
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (43,'TEST_P','DI2017',1,to_date('20-JUN-18','DD-MON-RR'),'724350512@qq.com','4427BB1E06CC59835B85FB82859345B5');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (123123,'AS','PWD',1,to_date('15-APR-18','DD-MON-RR'),'asdasdasdi','SDFERFEF');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (44,'Scoot','TEST_P',1,null,'TEST_P','D34RQWEAFE');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (48,'test_user','test',1,to_date('19-JUN-18','DD-MON-RR'),'1075900121@qq.com','877660B350E09F4B300DA2D500D38788');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (25,'Kanch Zhang','PWD',1,null,'kanchisme@gmail.com','SDASDF23QRWEFAWEF');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (2015051152,'long zhang','PWD',0,null,'kanchisme@gmail.com','EWR43634Y65EYGTRGD');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (12345,'qqqzzzz','PWD',9,null,'test','12312EQWDASDCAFERYTH56H');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (2015051111,'zzz','PWD',-1,null,'zzz@zzz.com','WER3Q524R23');
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (5,'test','111',1,to_date('21-APR-18','DD-MON-RR'),'qqq.qqq@qq.com',null);
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (45,'Thmpso','TEST_P',1,null,'kanchisme@gmail.com',null);
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (63,'test4','111',1,null,'111@qqq.com',null);
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (61,'test1','111',1,null,'111@qqq.com',null);
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (62,'test3','111',1,null,'111@qqq.com',null);
Insert into DI.T_DI_USER (USERID,USERNAME,PASSWORD,STATUS,LASTLOGIN,EMAIL,USESSION) values (64,'test5','111',1,null,'111@qqq.com',null);
--------------------------------------------------------
--  DDL for Index T_ANALYSIS_CUSTOMIZED_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_ANALYSIS_CUSTOMIZED_PK" ON "DI"."T_ANALYSIS_CUSTOMIZED" ("AID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DATABASE_CERTIFICATION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DATABASE_CERTIFICATION_PK" ON "DI"."T_DATABASE_CERTIFICATION" ("CID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DATABASE_COLUMN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DATABASE_COLUMN_PK" ON "DI"."T_DATABASE_COLUMN" ("COLID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DATABASE_INFO_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DATABASE_INFO_PK" ON "DI"."T_DATABASE_INFO" ("DID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DATABASE_REPORT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DATABASE_REPORT_PK" ON "DI"."T_DATABASE_REPORT" ("RID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DATABASE_TABLE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DATABASE_TABLE_PK" ON "DI"."T_DATABASE_TABLE" ("TID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DI_ADMIN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DI_ADMIN_PK" ON "DI"."T_DI_ADMIN" ("ADMINID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Index T_DI_USER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DI"."T_DI_USER_PK" ON "DI"."T_DI_USER" ("USERID") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS" ;
--------------------------------------------------------
--  DDL for Trigger T_ANALYSIS_CUSTOMIZED_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_ANALYSIS_CUSTOMIZED_TRG" 
BEFORE INSERT ON T_ANALYSIS_CUSTOMIZED 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.AID IS NULL THEN
      SELECT SEQ_AI_CUSTOMIZED.NEXTVAL INTO :NEW.AID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_ANALYSIS_CUSTOMIZED_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DATABASE_CERTIFICATION_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DATABASE_CERTIFICATION_TRG" 
BEFORE INSERT ON T_DATABASE_CERTIFICATION 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.CID IS NULL THEN
      SELECT SEQ_AI_CERTIFICATION.NEXTVAL INTO :NEW.CID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DATABASE_CERTIFICATION_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DATABASE_COLUMN_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DATABASE_COLUMN_TRG" 
BEFORE INSERT ON T_DATABASE_COLUMN 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.COLID IS NULL THEN
      SELECT SEQ_AI_COLUMN.NEXTVAL INTO :NEW.COLID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DATABASE_COLUMN_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DATABASE_INFO_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DATABASE_INFO_TRG" 
BEFORE INSERT ON T_DATABASE_INFO 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.DID IS NULL THEN
      SELECT SEQ_AI_DATABASE.NEXTVAL INTO :NEW.DID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DATABASE_INFO_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DATABASE_REPORT_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DATABASE_REPORT_TRG" 
BEFORE INSERT ON T_DATABASE_REPORT 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.RID IS NULL THEN
      SELECT SEQ_AI_REPORT.NEXTVAL INTO :NEW.RID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DATABASE_REPORT_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DATABASE_TABLE_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DATABASE_TABLE_TRG" 
BEFORE INSERT ON T_DATABASE_TABLE 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.TID IS NULL THEN
      SELECT SEQ_AI_TABLE.NEXTVAL INTO :NEW.TID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DATABASE_TABLE_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DI_ADMIN_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DI_ADMIN_TRG" 
BEFORE INSERT ON T_DI_ADMIN 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.ADMINID IS NULL THEN
      SELECT SEQ_AI_ADMIN.NEXTVAL INTO :NEW.ADMINID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DI_ADMIN_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DI_LOG_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DI_LOG_TRG" 
   before insert on "DI"."T_DI_LOG" 
   for each row 
begin  
   if inserting then 
      if :NEW."LID" is null then 
         select SEQ_AI_ADMIN.nextval into :NEW."LID" from dual; 
      end if; 
   end if; 
end;

/
ALTER TRIGGER "DI"."T_DI_LOG_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Trigger T_DI_USER_TRG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE TRIGGER "DI"."T_DI_USER_TRG" 
BEFORE INSERT ON T_DI_USER 
FOR EACH ROW 
BEGIN
  <<COLUMN_SEQUENCES>>
  BEGIN
    IF INSERTING AND :NEW.USERID IS NULL THEN
      SELECT SEQ_AI_USER.NEXTVAL INTO :NEW.USERID FROM SYS.DUAL;
    END IF;
  END COLUMN_SEQUENCES;
END;
/
ALTER TRIGGER "DI"."T_DI_USER_TRG" ENABLE;
--------------------------------------------------------
--  DDL for Procedure INSERT_REPORT
--------------------------------------------------------
set define off;

  CREATE OR REPLACE EDITIONABLE PROCEDURE "DI"."INSERT_REPORT" AS 
 REALLYBIGTEXTSTRING CLOB;
 BEGIN
   REALLYBIGTEXTSTRING:= ' ';
   INSERT INTO T_DATABASE_REPORT(RID,USERID,TITLE,GENERATEDATE,DESCRIPTION,REPORTCONTENT) 
   VALUES(111,43, 'title', to_date('2004-05-07 13:23:44','yyyy-mm-dd hh24:mi:ss') ,'discrition',REALLYBIGTEXTSTRING);
   commit; 
END;

/
--------------------------------------------------------
--  DDL for Function F_ALTER_CREDENTIAL
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_ALTER_CREDENTIAL" 
(
  CRDID IN VARCHAR2
, DBNAMES IN VARCHAR2
, DBHOSTS IN VARCHAR2
, PASSWORDS IN VARCHAR2
) RETURN NUMBER AS 
RESULTS NUMBER;
BEGIN 
      BEGIN
        SELECT DID INTO RESULTS FROM T_DATABASE_CERTIFICATION WHERE CID=CRDID;
        EXCEPTION
          WHEN NO_DATA_FOUND THEN
          RETURN -1; 
    END;
    UPDATE T_DATABASE_CERTIFICATION SET PASSWORD=PASSWORDS WHERE DID=RESULTS;
    UPDATE T_DATABASE_INFO SET NAME=DBNAMES,HOST=DBHOSTS WHERE DID=RESULTS;
      RETURN 1;
      
END F_ALTER_CREDENTIAL;

/
--------------------------------------------------------
--  DDL for Function F_CREATE_CREDENTIAL
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_CREATE_CREDENTIAL" 
(DBHOSTS IN VARCHAR2 
, DBNAMES IN VARCHAR2 
, DBUSERS IN VARCHAR2 
, DBPAWDS IN VARCHAR2 
, USERSESSION IN VARCHAR2 
, DBTYPES IN NUMBER
) RETURN NUMBER AS 
DIDS NUMBER;
USERIDS NUMBER; 
BEGIN
    BEGIN
        SELECT USERID INTO USERIDS FROM T_DI_USER WHERE USESSION=USERSESSION;
        INSERT INTO T_DATABASE_INFO(USERID, NAME, HOST, ADDDATE,DBTYPE) VALUES ( USERIDS,DBNAMES,DBHOSTS,SYSDATE,DBTYPES) RETURNING DID INTO DIDS;
        INSERT INTO T_DATABASE_CERTIFICATION (USERID, DID, USERNAME, PASSWORD) VALUES (USERIDS,DIDS,DBUSERS,DBPAWDS);
        COMMIT;
    EXCEPTION
        WHEN NO_DATA_FOUND THEN
            RETURN -3;
    END;
    RETURN 1;
END F_CREATE_CREDENTIAL;

/
--------------------------------------------------------
--  DDL for Function F_CREATE_USER
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_CREATE_USER" 
(
  NEW_USERNAME IN VARCHAR2 
, NEW_PASSWORD IN VARCHAR2 
, NEW_EMAIL IN VARCHAR2 
) RETURN NUMBER AS 
NEW_ID NUMBER;
BEGIN 
    BEGIN
        SELECT USERID INTO NEW_ID FROM T_DI_USER WHERE USERNAME=NEW_USERNAME;
    EXCEPTION 
        WHEN NO_DATA_FOUND THEN
            INSERT INTO T_DI_USER(USERNAME,PASSWORD,EMAIL,STATUS) VALUES(NEW_USERNAME,NEW_PASSWORD,NEW_EMAIL,1);
            COMMIT;
            SELECT USERID INTO NEW_ID FROM T_DI_USER WHERE USERNAME=NEW_USERNAME;
            RETURN NEW_ID;
    END;
    RETURN -1; 
END F_CREATE_USER;

/
--------------------------------------------------------
--  DDL for Function F_DELETE_CREDENTIAL
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_DELETE_CREDENTIAL" 
(
  CIDS IN VARCHAR2 
) RETURN NUMBER AS 
RESULTS NUMBER;
BEGIN
  BEGIN
        SELECT DID INTO RESULTS FROM T_DATABASE_CERTIFICATION WHERE CID=CIDS;
        EXCEPTION
          WHEN NO_DATA_FOUND THEN
          RETURN -1; 
    END;
    DELETE FROM T_DATABASE_CERTIFICATION WHERE CID=CIDS;
    DELETE FROM T_DATABASE_COLUMN WHERE DID=RESULTS;
    DELETE FROM T_DATABASE_TABLE WHERE DID=RESULTS;
    DELETE FROM T_DATABASE_INFO WHERE DID=RESULTS;
  RETURN 1;  
END F_DELETE_CREDENTIAL;

/
--------------------------------------------------------
--  DDL for Function F_DELETE_REPORT
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_DELETE_REPORT" 
(
  REPID IN NUMBER 
) RETURN NUMBER AS 
BEGIN
  DELETE FROM T_DATABASE_REPORT WHERE RID=REPID;
  RETURN 1;
END F_DELETE_REPORT;

/
--------------------------------------------------------
--  DDL for Function F_INSERT_REPORT
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_INSERT_REPORT" 
(
  RUSERID IN NUMBER,
  RTITLE IN VARCHAR,
  RDESCRIPTION IN VARCHAR,
  REPORTCONTENTS IN CLOB,
  RRELATION IN VARCHAR
) RETURN VARCHAR2 AS
BEGIN
  BEGIN
  INSERT INTO T_DATABASE_REPORT(USERID,TITLE,GENERATEDATE,DESCRIPTION,REPORTCONTENT,RELATION) 
   VALUES(RUSERID, RTITLE, sysdate,RDESCRIPTION,REPORTCONTENTS,RRELATION);
   EXCEPTION
       WHEN OTHERS THEN
            RETURN 0;
       END;
  RETURN 1;
END F_INSERT_REPORT;

/
--------------------------------------------------------
--  DDL for Function F_LOGIN_USER
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_LOGIN_USER" 
(
  V_USERNAME IN VARCHAR2 
, V_PASSWORD IN VARCHAR2
, V_USESSION IN VARCHAR2 
) RETURN NUMBER AS 
V_USERID NUMBER;
BEGIN
    -- First check if the user already login (by check username and session matches,we stores username in cookies)
    BEGIN
        SELECT USERID INTO V_USERID FROM T_DI_USER WHERE USESSION=V_USESSION;
        RETURN 1;
    EXCEPTION 
        WHEN NO_DATA_FOUND THEN
            -- user didn't login, then we check if username and password matches, if so, login.
            BEGIN
                SELECT USERID INTO V_USERID FROM T_DI_USER WHERE USERNAME=V_USERNAME AND PASSWORD=V_PASSWORD;
            EXCEPTION 
                WHEN NO_DATA_FOUND THEN
                    RETURN -1;
            END;
    END;
    -- log user in, and update session
    UPDATE T_DI_USER SET LASTLOGIN=SYSDATE,USESSION=V_USESSION WHERE USERID=V_USERID;  
    RETURN 1; 
END F_LOGIN_USER;

/
--------------------------------------------------------
--  DDL for Function F_VALIDATE_SESSION
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE FUNCTION "DI"."F_VALIDATE_SESSION" 
(
 V_USESSION IN VARCHAR2 
) RETURN NUMBER AS 
V_USERID NUMBER;
BEGIN
    -- First check if the user already login (by check username and session matches,we stores username in cookies)
    BEGIN
        SELECT USERID INTO V_USERID FROM T_DI_USER WHERE USESSION=V_USESSION;
        RETURN 1;
    EXCEPTION 
        WHEN NO_DATA_FOUND THEN
            RETURN -1;
        WHEN OTHERS THEN
            RETURN -1;
    END;
END F_VALIDATE_SESSION;

/
--------------------------------------------------------
--  Constraints for Table T_DATABASE_REPORT
--------------------------------------------------------

  ALTER TABLE "DI"."T_DATABASE_REPORT" MODIFY ("USERID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_REPORT" MODIFY ("TITLE" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_REPORT" MODIFY ("GENERATEDATE" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_REPORT" ADD CONSTRAINT "T_DATABASE_REPORT_PK" PRIMARY KEY ("RID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
  ALTER TABLE "DI"."T_DATABASE_REPORT" MODIFY ("DESCRIPTION" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_REPORT" MODIFY ("REPORTCONTENT" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table T_ANALYSIS_CUSTOMIZED
--------------------------------------------------------

  ALTER TABLE "DI"."T_ANALYSIS_CUSTOMIZED" MODIFY ("AID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_ANALYSIS_CUSTOMIZED" MODIFY ("USERID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_ANALYSIS_CUSTOMIZED" MODIFY ("GENERATEDATE" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_ANALYSIS_CUSTOMIZED" MODIFY ("DESCRIPTION" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_ANALYSIS_CUSTOMIZED" MODIFY ("SCRIPT" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_ANALYSIS_CUSTOMIZED" ADD CONSTRAINT "T_ANALYSIS_CUSTOMIZED_PK" PRIMARY KEY ("AID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table T_DI_LOG
--------------------------------------------------------

  ALTER TABLE "DI"."T_DI_LOG" ADD PRIMARY KEY ("LID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table T_DATABASE_TABLE
--------------------------------------------------------

  ALTER TABLE "DI"."T_DATABASE_TABLE" MODIFY ("TID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_TABLE" MODIFY ("DID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_TABLE" MODIFY ("TNAME" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_TABLE" ADD CONSTRAINT "T_DATABASE_TABLE_PK" PRIMARY KEY ("TID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table T_DATABASE_COLUMN
--------------------------------------------------------

  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("COLID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("TID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("DID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("USERID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("COLUMNNAME" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("DATATYPE" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("ISPRIMARY" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" MODIFY ("ISFOREIGNKEY" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_COLUMN" ADD CONSTRAINT "T_DATABASE_COLUMN_PK" PRIMARY KEY ("COLID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table T_DATABASE_INFO
--------------------------------------------------------

  ALTER TABLE "DI"."T_DATABASE_INFO" MODIFY ("DID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_INFO" MODIFY ("USERID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_INFO" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_INFO" MODIFY ("HOST" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_INFO" MODIFY ("ADDDATE" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_INFO" ADD CONSTRAINT "T_DATABASE_INFO_PK" PRIMARY KEY ("DID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
  ALTER TABLE "DI"."T_DATABASE_INFO" MODIFY ("DBTYPE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table T_DI_ADMIN
--------------------------------------------------------

  ALTER TABLE "DI"."T_DI_ADMIN" MODIFY ("ADMINID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_ADMIN" MODIFY ("USERNAME" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_ADMIN" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_ADMIN" MODIFY ("EMAIL" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_ADMIN" ADD CONSTRAINT "T_DI_ADMIN_PK" PRIMARY KEY ("ADMINID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table T_DATABASE_CERTIFICATION
--------------------------------------------------------

  ALTER TABLE "DI"."T_DATABASE_CERTIFICATION" MODIFY ("CID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_CERTIFICATION" MODIFY ("USERID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_CERTIFICATION" MODIFY ("DID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_CERTIFICATION" MODIFY ("USERNAME" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_CERTIFICATION" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DATABASE_CERTIFICATION" ADD CONSTRAINT "T_DATABASE_CERTIFICATION_PK" PRIMARY KEY ("CID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Constraints for Table T_DI_USER
--------------------------------------------------------

  ALTER TABLE "DI"."T_DI_USER" MODIFY ("USERID" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_USER" MODIFY ("USERNAME" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_USER" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_USER" MODIFY ("STATUS" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_USER" MODIFY ("EMAIL" NOT NULL ENABLE);
  ALTER TABLE "DI"."T_DI_USER" ADD CONSTRAINT "T_DI_USER_PK" PRIMARY KEY ("USERID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "USERS"  ENABLE;
