在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称:bboss-cms开源软件地址:https://gitee.com/bboss/bboss-cms开源软件介绍:1.内容管理ie9下设置模板时,有中文乱码2.去除内容管理模板管理列表页面存在session操作3.内容管理文档内部分类中文乱码4.解决模板管理上传zip包存放路径不正确问题 ---------------------------oracle------------------------- ALTER TABLE TD_WF_RUN_TASKDROP 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_PKPRIMARY 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_TASKADD (DEALER NVARCHAR2(255)) COMMENT ON COLUMNTD_WF_RUN_TASK.DEALER IS'任务处理人账号'; ALTER TABLE TD_WF_RUN_TASKADD (Task_type NUMBER(1) DEFAULT 0) COMMENT ON COLUMNTD_WF_RUN_TASK.Task_type IS'任务类型,0-普通任务类型 1-抄送通知任务类型'; ALTER TABLE TD_WF_RUN_TASKADD (senderworkno VARCHAR2(50 BYTE)); COMMENT ON COLUMNTD_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); |
请发表评论