-- ----------------------------- 2020-04-15 add by zhanghang------------begin

CREATE TABLE "T_CORE_MYTASK" (
"ID" NUMBER(20) NOT NULL ,
"TASKDESC" VARCHAR2(600) NULL ,
"TASKSTARTTIME" DATE NULL ,
"TASKENDTIME" DATE NULL ,
"CREATEDBYID" VARCHAR2(32) NULL ,
"CREATEDBYNAME" VARCHAR2(64) NULL ,
"CREATEDTIME" DATE NULL ,
"CREATEDBYORGID" VARCHAR2(32) NULL ,
"CREATEDBYORGNAME" VARCHAR2(256) NULL 
);
COMMENT ON TABLE "T_CORE_MYTASK" IS '日常管理表';
COMMENT ON COLUMN "T_CORE_MYTASK"."ID" IS '主键';
COMMENT ON COLUMN "T_CORE_MYTASK"."TASKDESC" IS '日程描述';
COMMENT ON COLUMN "T_CORE_MYTASK"."TASKSTARTTIME" IS '日程开始时间';
COMMENT ON COLUMN "T_CORE_MYTASK"."TASKENDTIME" IS '日程结束时间';
COMMENT ON COLUMN "T_CORE_MYTASK"."CREATEDBYID" IS '制单人编码';
COMMENT ON COLUMN "T_CORE_MYTASK"."CREATEDBYNAME" IS '制单人名称';
COMMENT ON COLUMN "T_CORE_MYTASK"."CREATEDTIME" IS '制单日期';
COMMENT ON COLUMN "T_CORE_MYTASK"."CREATEDBYORGID" IS '单据单位编码';
COMMENT ON COLUMN "T_CORE_MYTASK"."CREATEDBYORGNAME" IS '单据单位名称';


ALTER TABLE T_CORE_MYTASK ADD CONSTRAINT PK_CORE_MYTASK PRIMARY KEY (ID);

INSERT INTO T_CORE_TABLE (ID,AUDITABLE,ATTACHMENT) VALUES ('T_CORE_MYTASK', '0', '0');
commit;

-- ----------------------------- 2020-04-15 add by zhanghang------------end

-- ----------------------------- 2020-04-18 add by liyang--------------begin
INSERT INTO t_core_menu(ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON) 
VALUES ('88', '日常管理', NULL, NULL, 9, '日常管理', '076.svg', '');

INSERT INTO t_core_menu(ID, MENUNAME, HREF, PARENTID, ORDERNO, MENUINITNAME, ICON, TODOICON) 
VALUES ('8801', '日程', '/secure/core/module/my-tasks/page/edit-list', '88', 8801, '日程', '076.svg', '');
commit;
-- ----------------------------- 2020-04-18 add by liyang--------------end