phoenix110 / bboss-cms Goto Github PK

1.内容管理ie9下设置模板时，有中文乱码 2.去除内容管理模板管理列表页面存在session操作 3.内容管理文档内部分类中文乱码 4.解决模板管理上传zip包存放路径不正确问题

---------------------------oracle-------------------------

ALTER TABLE TD_WF_RUN_TASK DROP PRIMARY KEY CASCADE; DROP TABLE TD_WF_RUN_TASK CASCADE CONSTRAINTS PURGE;

CREATE TABLE TD_WF_RUN_TASK ( BUSINESS_KEY NVARCHAR2(255), PROCESS_KEY NVARCHAR2(255), PROCESS_ID NVARCHAR2(64) NOT NULL, SENDER NVARCHAR2(255), SENDERNAME NVARCHAR2(255), TASK_ID NVARCHAR2(64) NOT NULL, TASK_NAME NVARCHAR2(255), TASK_KEY NVARCHAR2(255), TASK_URL NVARCHAR2(200), CREATE_DATETIME TIMESTAMP(6), DEALERS NVARCHAR2(500), DEALERWORKNO NVARCHAR2(500), DEALERNAMES NVARCHAR2(500), LAST_OP NVARCHAR2(64), LAST_OPER NVARCHAR2(64), DEALER NVARCHAR2(255), TASK_TYPE NUMBER(1) DEFAULT 0, DEALERNAME NVARCHAR2(255), SENDERWORKNO VARCHAR2(50 BYTE) );

COMMENT ON TABLE TD_WF_RUN_TASK IS '统一代办任务表';

COMMENT ON COLUMN TD_WF_RUN_TASK.BUSINESS_KEY IS '业务id';

COMMENT ON COLUMN TD_WF_RUN_TASK.PROCESS_KEY IS '流程key';

COMMENT ON COLUMN TD_WF_RUN_TASK.PROCESS_ID IS '流程实例id';

COMMENT ON COLUMN TD_WF_RUN_TASK.SENDER IS '流程发起人';

COMMENT ON COLUMN TD_WF_RUN_TASK.SENDERNAME IS '流程发起人姓名';

COMMENT ON COLUMN TD_WF_RUN_TASK.TASK_ID IS '任务id';

COMMENT ON COLUMN TD_WF_RUN_TASK.TASK_NAME IS '节点名称';

COMMENT ON COLUMN TD_WF_RUN_TASK.TASK_KEY IS '任务key';

COMMENT ON COLUMN TD_WF_RUN_TASK.TASK_URL IS '代办url';

COMMENT ON COLUMN TD_WF_RUN_TASK.CREATE_DATETIME IS '任务创建时间';

COMMENT ON COLUMN TD_WF_RUN_TASK.DEALERS IS '当前任务处理人';

COMMENT ON COLUMN TD_WF_RUN_TASK.DEALERWORKNO IS '当前任务处理人工号';

COMMENT ON COLUMN TD_WF_RUN_TASK.DEALERNAMES IS '当前任务处理人姓名';

COMMENT ON COLUMN TD_WF_RUN_TASK.LAST_OP IS '上一次处理动作';

COMMENT ON COLUMN TD_WF_RUN_TASK.LAST_OPER IS '上一次处理人';

COMMENT ON COLUMN TD_WF_RUN_TASK.DEALER IS '任务处理人账号';

COMMENT ON COLUMN TD_WF_RUN_TASK.TASK_TYPE IS '任务类型，0-普通任务类型 1-抄送通知任务类型';

COMMENT ON COLUMN TD_WF_RUN_TASK.SENDERWORKNO IS '提交人工号';

ALTER TABLE TD_WF_RUN_TASK ADD ( PRIMARY KEY (TASK_ID, DEALER));

DROP TABLE TD_COMMON_ORDER CASCADE CONSTRAINTS PURGE;

CREATE TABLE TD_COMMON_ORDER ( ORDER_ID NVARCHAR2(50), ORDER_NO NVARCHAR2(32), ORDER_TYPE NVARCHAR2(20), ORDER_TYPE_NAME NVARCHAR2(40), ORDER_STATE NVARCHAR2(20), ORDER_STATE_NAME NVARCHAR2(40), APPLY_PERSON NVARCHAR2(120), APPLY_PERSON_NAME NVARCHAR2(240), APPLY_PERSON_WORKNUMBER NVARCHAR2(120), CREATE_DATETIME TIMESTAMP(6), CREATE_PERSON NVARCHAR2(40), CREATE_PERSON_NAME NVARCHAR2(80), CREATE_PERSON_WORKNUMBER NVARCHAR2(40), PROCESS_ID NVARCHAR2(42), PROCESS_KEY NVARCHAR2(20), TITLE NVARCHAR2(200), DEAL_TITLE NVARCHAR2(200), DEAL_STATE NVARCHAR2(20), DEAL_STATE_NAME NVARCHAR2(40), DEAL_PERSON NVARCHAR2(200), DEAL_PERSON_NAME NVARCHAR2(400), DEAL_PERSON_WORKNUMBER NVARCHAR2(200), APPROVE_PERSON NVARCHAR2(1000), APPROVE_PERSON_NAME NVARCHAR2(2000), APPROVE_PERSON_WORKNUMBER NVARCHAR2(1000), LIMIT_DATETIME TIMESTAMP(6), MODIFY_DATETIME TIMESTAMP(6), END_DATETIME TIMESTAMP(6), ORDER_PARAM NVARCHAR2(100) );

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_ID IS '申请单ID ';

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_NO IS '申请单编码 ';

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_TYPE IS '申请单类型 ';

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_TYPE_NAME IS '申请单类型名称 ';

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_STATE IS '申请单状态 ';

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_STATE_NAME IS '申请单状态名称 ';

COMMENT ON COLUMN TD_COMMON_ORDER.APPLY_PERSON IS '申请人 ';

COMMENT ON COLUMN TD_COMMON_ORDER.APPLY_PERSON_NAME IS '申请人名称 ';

COMMENT ON COLUMN TD_COMMON_ORDER.APPLY_PERSON_WORKNUMBER IS '申请人工号 ';

COMMENT ON COLUMN TD_COMMON_ORDER.CREATE_DATETIME IS '申请日期 ';

COMMENT ON COLUMN TD_COMMON_ORDER.CREATE_PERSON IS '提交人 ';

COMMENT ON COLUMN TD_COMMON_ORDER.CREATE_PERSON_NAME IS '提交人名称 ';

COMMENT ON COLUMN TD_COMMON_ORDER.CREATE_PERSON_WORKNUMBER IS '提交人工号 ';

COMMENT ON COLUMN TD_COMMON_ORDER.PROCESS_ID IS '流程ID ';

COMMENT ON COLUMN TD_COMMON_ORDER.PROCESS_KEY IS '流程KEY ';

COMMENT ON COLUMN TD_COMMON_ORDER.TITLE IS '标题 ';

COMMENT ON COLUMN TD_COMMON_ORDER.DEAL_TITLE IS '标题_DEAL ';

COMMENT ON COLUMN TD_COMMON_ORDER.DEAL_STATE IS '处理状态 ';

COMMENT ON COLUMN TD_COMMON_ORDER.DEAL_STATE_NAME IS '状态_DEAl_NAME ';

COMMENT ON COLUMN TD_COMMON_ORDER.DEAL_PERSON IS '处理人 ';

COMMENT ON COLUMN TD_COMMON_ORDER.DEAL_PERSON_NAME IS '处理人名称 ';

COMMENT ON COLUMN TD_COMMON_ORDER.DEAL_PERSON_WORKNUMBER IS '处理人工号 ';

COMMENT ON COLUMN TD_COMMON_ORDER.APPROVE_PERSON IS '审批人 ';

COMMENT ON COLUMN TD_COMMON_ORDER.APPROVE_PERSON_NAME IS '审批人名称 ';

COMMENT ON COLUMN TD_COMMON_ORDER.APPROVE_PERSON_WORKNUMBER IS '审批人工号 ';

COMMENT ON COLUMN TD_COMMON_ORDER.LIMIT_DATETIME IS '处理期限 ';

COMMENT ON COLUMN TD_COMMON_ORDER.MODIFY_DATETIME IS '修改时间 ';

COMMENT ON COLUMN TD_COMMON_ORDER.END_DATETIME IS '结束时间 ';

COMMENT ON COLUMN TD_COMMON_ORDER.ORDER_PARAM IS '申请单参数';

------------------------------mysql----------------------------------

==========================物资出门数据变更===========================

CREATE TABLE TD_WF_RUN_TASK ( BUSINESS_KEY VARCHAR(255), PROCESS_KEY VARCHAR(255), PROCESS_ID VARCHAR(64) NOT NULL, SENDER VARCHAR(255), SENDERNAME VARCHAR(255), TASK_ID VARCHAR(64) NOT NULL, TASK_NAME VARCHAR(255), TASK_KEY VARCHAR(255), TASK_URL VARCHAR(200), CREATE_DATETIME TIMESTAMP(6) NULL DEFAULT NULL, DEALERS VARCHAR(500), DEALERWORKNO VARCHAR(500), DEALERNAMES VARCHAR(500), LAST_OP VARCHAR(64), LAST_OPER VARCHAR(64) );

CREATE UNIQUE INDEX TD_WF_RUN_TASK_PK ON TD_WF_RUN_TASK (PROCESS_ID, TASK_ID);

ALTER TABLE TD_WF_RUN_TASK ADD ( CONSTRAINT TD_WF_RUN_TASK_PK PRIMARY KEY (PROCESS_ID, TASK_ID));

CREATE TABLE TD_COMMON_ORDER ( ORDER_ID VARCHAR(50), ORDER_NO VARCHAR(32), ORDER_TYPE VARCHAR(20), ORDER_TYPE_NAME VARCHAR(40), ORDER_STATE VARCHAR(20), ORDER_STATE_NAME VARCHAR(40), APPLY_PERSON VARCHAR(120), APPLY_PERSON_NAME VARCHAR(240), APPLY_PERSON_WORKNUMBER VARCHAR(120), CREATE_DATETIME TIMESTAMP(6) NULL DEFAULT NULL, CREATE_PERSON VARCHAR(40), CREATE_PERSON_NAME VARCHAR(80), CREATE_PERSON_WORKNUMBER VARCHAR(40), PROCESS_ID VARCHAR(42), PROCESS_KEY VARCHAR(20), TITLE VARCHAR(200), DEAL_TITLE VARCHAR(200), DEAL_STATE VARCHAR(20), DEAL_STATE_NAME VARCHAR(40), DEAL_PERSON VARCHAR(200), DEAL_PERSON_NAME VARCHAR(400), DEAL_PERSON_WORKNUMBER VARCHAR(200), APPROVE_PERSON VARCHAR(1000), APPROVE_PERSON_NAME VARCHAR(2000), APPROVE_PERSON_WORKNUMBER VARCHAR(1000), LIMIT_DATETIME TIMESTAMP(6) NULL DEFAULT NULL, MODIFY_DATETIME TIMESTAMP(6) NULL DEFAULT NULL, END_DATETIME TIMESTAMP(6) NULL DEFAULT NULL, ORDER_PARAM VARCHAR(100) );

oracle升级脚本： ALTER TABLE TD_WF_RUN_TASK ADD (DEALER NVARCHAR2(255))

COMMENT ON COLUMN TD_WF_RUN_TASK.DEALER IS '任务处理人账号';

ALTER TABLE TD_WF_RUN_TASK ADD (Task_type NUMBER(1) DEFAULT 0)

COMMENT ON COLUMN TD_WF_RUN_TASK.Task_type IS '任务类型，0-普通任务类型 1-抄送通知任务类型';

ALTER TABLE TD_WF_RUN_TASK ADD (senderworkno VARCHAR2(50 BYTE));

COMMENT ON COLUMN TD_WF_RUN_TASK.senderworkno IS '提交人工号'; ALTER TABLE TD_WF_RUN_TASK ADD (DEALERNAME NVARCHAR2(255)); ALTER TABLE TD_WF_RUN_TASK DROP CONSTRAINT TD_WF_RUN_TASK_PK;

ALTER TABLE TD_WF_RUN_TASK ADD PRIMARY KEY (TASK_ID, DEALER);