ALTER TABLE PERSONNEL 
ADD (
    IDP_ACCOUNT VARCHAR2(100) NULL,
    NFC_NUMBER VARCHAR2(50) NULL,
    U_POST VARCHAR2(30) NULL,
    U_MANAGEMENT VARCHAR2(1) NULL,
    RETIREMENTDATE TIMESTAMP NULL,
    EMPLOYMENTDATE TIMESTAMP NULL,
);

ALTER TABLE FOLDER_TEMPLATE 
ADD (
    IS_BEEQUERY VARCHAR2(1) DEFAULT 'F' NULL,
    TRANSLATE_ID VARCHAR2(100) NULL
);

CREATE TABLE SYS_LANGUAGE_MAP (
	"IDENTITY" VARCHAR(800) NOT NULL,
	"LANGUAGE" VARCHAR(800) DEFAULT 'en-US' NOT NULL,
	FUNCTION_TYPE VARCHAR(1600) NOT NULL,
	DESCRIPTION VARCHAR(1600) NULL,
	MAP_JSON TEXT NULL,
	MODIFIED_ON DATETIME NULL,
	MODIFIED_BY VARCHAR(1600) NULL,
	REMOVEFLAG VARCHAR(16) DEFAULT 'F' NULL,
	CONSTRAINT PK_SYS_LANGUAGE_MAP PRIMARY KEY ("IDENTITY",FUNCTION_TYPE,"LANGUAGE")
);


ALTER TABLE WORKFLOW_TEMPLATE 
ADD (
	TRANSLATE_ID VARCHAR2(100) NULL
);

CREATE TABLE CLICK_THROUGH_RATE_HEADER (
	"IDENTITY" VARCHAR(4608) NOT NULL,
	"TYPE" VARCHAR(4608) NULL,
	CLICK_DIS VARCHAR(12800) NULL,
	MODIFIED_ON TIMESTAMP NULL,
	MODIFIED_BY VARCHAR(2560) NULL,
	TOKEN_ID VARCHAR2(100) NULL,
	URL VARCHAR(6400) NULL,
	CONSTRAINT PK_CLICK_THROUGH_RATE_HEADER PRIMARY KEY ("IDENTITY")
);


CREATE TABLE DATA_LANGUAGE_MAP (
	"IDENTITY" VARCHAR(800) NOT NULL,
	TABLE_NAME VARCHAR(3200) NOT NULL,
	"LANGUAGE" VARCHAR(800) NULL,
	DATA_TYPE VARCHAR(1600) NULL,
	RECORD_KEY VARCHAR(16000) NULL,
	FIELD_NAME VARCHAR(3200) NULL,
	VALUE_MAP_BEFORE VARCHAR(8000) NULL,
	VALUE_MAP_AFTER VARCHAR(32000) NULL,
	MODIFIED_ON DATETIME NULL,
	MODIFIED_BY VARCHAR(320) NULL,
	REMOVEFLAG VARCHAR(16) NULL,
	ZB_DOWNLOAD VARCHAR2(1) DEFAULT 'F' NULL,
	CONSTRAINT PK_DATA_LANGUAGE_MAP PRIMARY KEY ("IDENTITY")
);

ALTER TABLE WORKFLOW_DATA ADD (
	TRANSLATE_ID VARCHAR2(100) NULL
);



-- LIMS_JH.FOLDER_TEMPLATE_D 定义
ALTER TABLE FOLDER_TEMPLATE_D ADD (
	IS_AUDIT VARCHAR2(1) DEFAULT 'F' NULL
);



-- LIMS_JH.FOLDER_TEMP_COLUMN 定义

ALTER TABLE FOLDER_TEMP_COLUMN ADD (
	IS_AUDIT VARCHAR2(1) DEFAULT 'F' NULL
);


ALTER TABLE FOLDER_TEMP_BUTTON ADD (
	IS_AUDIT VARCHAR2(1) DEFAULT 'F' NULL
);

ALTER TABLE FORM_SERVER_CONFIG ADD (
	IS_AUDIT VARCHAR2(1) DEFAULT 'F' NULL
);


ALTER TABLE FORM_SERVER_CONFIG ADD (
	CALLBACK_CODE TEXT NULL
);

CREATE TABLE FORM_SERVER_CONFIG_BAK AS SELECT * FROM FORM_SERVER_CONFIG;

DROP TABLE FORM_SERVER_CONFIG;

CREATE TABLE FORM_SERVER_CONFIG (
	"IDENTITY" NVARCHAR(288) NOT NULL,
	"LANGUAGE" NVARCHAR(400) NOT NULL,
	NAME NVARCHAR(800) NULL,
	DESCRIPTION NVARCHAR(2032) NULL,
	URL NVARCHAR(2032) NULL,
	PARAMETERS NVARCHAR(32000) NULL,
	CALLBACK_CODE TEXT NULL,
	PAGE_URL NVARCHAR(2032) NULL,
	PAGE_PARAMETERS NVARCHAR(32000) NULL,
	PAGE_CALLBACK_CODE TEXT NULL,
	GROUP_ID NVARCHAR(800) NULL,
	ORDER_NUMBER INT NULL,
	MODIFIED_ON DATE NULL,
	MODIFIED_BY NVARCHAR(800) NULL,
	REMOVEFLAG NVARCHAR(8) NULL,
	CONSTRAINT PK_FORM_SERVER_CONFIG PRIMARY KEY ("IDENTITY","LANGUAGE")
);

INSERT INTO FORM_SERVER_CONFIG (
"IDENTITY", "LANGUAGE", NAME, DESCRIPTION, URL, PARAMETERS, CALLBACK_CODE, PAGE_URL, PAGE_PARAMETERS, PAGE_CALLBACK_CODE, GROUP_ID, ORDER_NUMBER, MODIFIED_ON, MODIFIED_BY, REMOVEFLAG
)
 SELECT "IDENTITY", "LANGUAGE", NAME, DESCRIPTION, URL, PARAMETERS, CALLBACK_CODE, PAGE_URL, PAGE_PARAMETERS, PAGE_CALLBACK_CODE, GROUP_ID, ORDER_NUMBER, MODIFIED_ON, MODIFIED_BY, REMOVEFLAG
FROM FORM_SERVER_CONFIG_BAK;

DROP TABLE FORM_SERVER_CONFIG_BAK;



ALTER TABLE GRID_DISPLAY ADD (
	IS_AUDIT VARCHAR2(1) DEFAULT 'F' NULL
);


ALTER TABLE GRID_DISPLAY ADD (
	FUNCTION_TYPE VARCHAR2(100) NULL
);


ALTER TABLE GRID_DISPLAY ADD (
	FUNCTION_DESC VARCHAR2(500) NULL
);


ALTER TABLE S_ANAL ADD (
	REMOVE_FLAG VARCHAR(128) DEFAULT 'F' NULL
);

ALTER TABLE "LANGUAGE" ADD (
	IS_TOGETHER VARCHAR2(1) DEFAULT 'F' NULL
);

CREATE TABLE S_METHOD_COMPONENT (
	METHOD_CODE VARCHAR2(100) NOT NULL,
	COMPONENT_CODE VARCHAR2(100) NOT NULL,
	UNITS VARCHAR2(200) NOT NULL,
	ORDER_INDEX INT NULL,
	MODIFIED_ON TIMESTAMP NULL,
	MODIFIED_BY VARCHAR2(100) NULL,
	REMOVE_FLAG VARCHAR2(8) DEFAULT 'F' NULL,
	"##ROWID" VARCHAR(32) NULL,
	CONSTRAINT PK_S_METHOD_COMPONENT PRIMARY KEY (METHOD_CODE,UNITS,COMPONENT_CODE)
);

ALTER TABLE S_COMPONENT ADD (
	S_NAME VARCHAR2(100) NULL,
	STANDARD_CODE VARCHAR2(20) NULL
);


CREATE OR REPLACE  VIEW  "S_METHOD_COMPONENT_VIEW" ("IDENTITY","NAME","S_NAME","STANDARD_CODE","STATUS")   AS  
SELECT DISTINCT  sm."IDENTITY" ,sc.NAME ,sc.S_NAME,sc.STANDARD_CODE,sc.STATUS  from S_METHOD_COMPONENT smc  left join 
S_COMPONENT sc on sc.STANDARD_CODE =smc.COMPONENT_CODE left join S_METHOD sm on sm.STANDARD_CODE =smc.METHOD_CODE;


-- LIMS_JH.SAMPLE_POINT 定义

ALTER TABLE LIMS_JH.SAMPLE_POINT ADD (
	SHORT_CODE VARCHAR2(100) NULL,
	IS_SECRECY VARCHAR(16) DEFAULT 'F' NULL,
	TANK_STATUS VARCHAR2(100) NULL,
	HEIGHT_TANK FLOAT NULL,
	HEIGHT_SAFE FLOAT NULL,
	POINT_TYPE VARCHAR2(100) NULL,
	MES_CODE VARCHAR2(100) NULL,
	MDM_NAME VARCHAR2(500) NULL,
	MDM_SHORT_NAME VARCHAR2(500) NULL,
	MDM_STATUS VARCHAR2(1) NULL,
	NFC_NUMBER VARCHAR2(200) NULL,
	NFC_MODIFIED_BY VARCHAR2(100) NULL,
	NFC_MODIFIED_ON TIMESTAMP NULL,
	GW_DESCRIPTION VARCHAR2(800) NULL
);


ALTER TABLE MLP_HEADER ADD (
	SF_HGMATERIAL VARCHAR2(20) NULL,
	AUTH_OWN VARCHAR2(1) DEFAULT 'F' NULL,
	BELONG_TO VARCHAR2(200) NULL,
	ORIGINAL_TEMPLATE VARCHAR2(200) DEFAULT '' NULL,
	IS_SECRECY VARCHAR(16) DEFAULT 'F' NULL,
	IS_DATA_PRIVACY VARCHAR2(1) NULL,
	CTSOA VARCHAR2(100) NULL,
	CTSO VARCHAR2(100) NULL,
	AREA_ID VARCHAR2(100) NULL,
	SAMPLE_AMOUNT VARCHAR2(100) NULL
);

CREATE OR REPLACE  VIEW           "MLP_HEADER_VIEW" ("IDENTITY","PRODUCT_VERSION","NAME","DESCRIPTION","PRODUCT_GROUP","TEST_SCHEDULE","PRODUCT_STATUS","REPORT_FILE_NUM","GROUP_ID","VERSION_COMMENT","VERSION_STATUS","CREATED_DATE","MODIFIABLE","MODIFIED_ON","MODIFIED_BY","REMOVEFLAG","APPROVAL_REQD","APPROVAL_STATUS","HAS_ATTACHMENTS","U_S_MATE_ID","U_STANDARDS","U_PRODUCT_SPEC","U_CPMC","U_SAMPLE_POINT","U_CPPH","U_LICENCE_NO","U_IF_TASK_FILE","U_BGDBH","U_HGZBH","U_BZ","PRODUCT_ATTRIBUTE","U_SAMPLE_TYPE","ALLOW_HGZ_LOSE_ITEM","ALLOW_HGZ_OUT_RANGE","BATCH_REPEAT_CHECK","U_IF_HGZ_NK","U_YPXL","U_BGD_STAMP","U_CREATE_HGZ_USE_SAMP_NOTE","U_BATCH_RULE","U_HGZFLOW_ID","U_HGZFLOW_LANGUAGE","U_USE_LES","U_USE_SOP","U_USE_SOP_FILTER","ACTIVE","ACTIVE_FROM","ACTIVE_TO","AUTH_OWN","BELONG_TO","ORIGINAL_TEMPLATE","SF_HGMATERIAL","IS_SECRECY","IS_DATA_PRIVACY","CTSOA","CTSO","AREA_ID","SAMPLE_AMOUNT")  
AS  SELECT H."IDENTITY",H.PRODUCT_VERSION,H.NAME,H.DESCRIPTION,H.PRODUCT_GROUP,H.TEST_SCHEDULE,H.PRODUCT_STATUS,REPORT_FILE_NUM
,H.GROUP_ID,H.VERSION_COMMENT,H.VERSION_STATUS,H.CREATED_DATE,H.MODIFIABLE,H.MODIFIED_ON,H.MODIFIED_BY,H.REMOVEFLAG,H.APPROVAL_REQD,H.APPROVAL_STATUS
,H.HAS_ATTACHMENTS,H.U_S_MATE_ID,H.U_STANDARDS,H.U_PRODUCT_SPEC,H.U_CPMC,H.U_SAMPLE_POINT,H.U_CPPH,H.U_LICENCE_NO,H.U_IF_TASK_FILE,H.U_BGDBH,H.U_HGZBH,H.U_BZ
,H.PRODUCT_ATTRIBUTE,H.U_SAMPLE_TYPE,H.ALLOW_HGZ_LOSE_ITEM,H.ALLOW_HGZ_OUT_RANGE,H.BATCH_REPEAT_CHECK,H.U_IF_HGZ_NK,H.U_YPXL,H.U_BGD_STAMP
,H.U_CREATE_HGZ_USE_SAMP_NOTE,H.U_BATCH_RULE,H.U_HGZFLOW_ID,H.U_HGZFLOW_LANGUAGE,H.U_USE_LES,H.U_USE_SOP,H.U_USE_SOP_FILTER,H.ACTIVE,H.ACTIVE_FROM,H.ACTIVE_TO,AUTH_OWN,H.BELONG_TO，
H.ORIGINAL_TEMPLATE,H.SF_HGMATERIAL,H.IS_SECRECY,H.IS_DATA_PRIVACY,H.CTSOA,H.CTSO,H.AREA_ID,H.SAMPLE_AMOUNT 
FROM MLP_HEADER AS H WHERE H.PRODUCT_VERSION = ( SELECT MAX(H1.PRODUCT_VERSION) FROM MLP_HEADER AS H1 WHERE  (H1."IDENTITY" = H."IDENTITY" AND H1.APPROVAL_STATUS = 'A' ));

SELECT "IDENTITY",ANALYSIS_VERSION,GROUP_ID,ANALYSIS_TYPE,DESCRIPTION,INSTTYPE_ID,PREPARATION_ID,EXPECTED_TIME,CHARGECODE,RESULT_SCREEN,MODIFIABLE,SHOW_NAME,CALCULATION,REPLICATES,ACCESS_FLAGS,COMP_REPLICATES,GENERIC_ANALYSIS,APPROVAL_REQD,ALLOW_CATEGORY,APPROVAL_STATUS,INSPECTION_PLAN,SAMPLING_PLAN_TYPE,AUTO_VALIDATE,INSTRUMENT_REQUIRED,SOP_REFERENCE,UNCERTAINTY_TEXT,NAME,ACTIVE,ACTIVE_FROM,ACTIVE_TO,WORKFLOW_ID,ENTITY_TEMPLATE_ID,HAS_ATTACHMENTS,U_COST,U_FILE_NUM,U_S_ANAL_ID,U_METHOD,U_PRODUCT_TYPE,U_METHOD_TYPE,AUXILIARY_DESCRIPTION,OPERATION_GROUP_ID,INSTRUMENT_ID,INSTRUMENT_NAME,ORIGINAL_TEMPLATE,REPORT_TEMPLATE,IS_DELIVERY,REPORT_NUM,TEST_REQUIRE,DATA_PROCESS,OLD_IDENTITY,ZB_DOWNLOAD,ZB_ANALYSIS_IDENTITY,MODIFIED_ON,MODIFIED_BY,REMOVEFLAG,IM_COMPONENT_MODIFY FROM ANALYSIS_VIEW WHERE ( "IDENTITY" in ( ? , ? , ? , ? , ? , ? ) and REMOVEFLAG = ? )