sicuan_lims/sql/init_sql/microservices/0.5.0/mytask-sqlserver(日程).txt

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

CREATE TABLE [T_CORE_MYTASK] (
[ID] bigint NOT NULL ,
[TASKDESC] VARCHAR(600) NULL ,
[TASKSTARTTIME] DATETIME NULL ,
[TASKENDTIME] DATETIME NULL ,
[CREATEDBYID] VARCHAR(32) NULL ,
[CREATEDBYNAME] VARCHAR(64) NULL ,
[CREATEDTIME] DATETIME NULL ,
[CREATEDBYORGID] VARCHAR(32) NULL ,
[CREATEDBYORGNAME] VARCHAR(256) NULL ,
CONSTRAINT PK_CORE_MYTASK PRIMARY KEY(ID)
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
NULL, NULL)) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'日常管理表'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'日常管理表'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'ID')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'主键'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'ID'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'主键'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'ID'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'TASKDESC')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'日程描述'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'TASKDESC'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'日程描述'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'TASKDESC'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'TASKSTARTTIME')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'日程开始时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'TASKSTARTTIME'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'日程开始时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'TASKSTARTTIME'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'TASKENDTIME')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'日程结束时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'TASKENDTIME'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'日程结束时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'TASKENDTIME'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'CREATEDBYID')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'制单人编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYID'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'制单人编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYID'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'CREATEDBYNAME')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'制单人名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYNAME'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'制单人名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYNAME'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'CREATEDTIME')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'制单日期'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDTIME'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'制单日期'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDTIME'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'CREATEDBYORGID')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'单据单位编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYORGID'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'单据单位编码'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYORGID'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'T_CORE_MYTASK', 
'COLUMN', N'CREATEDBYORGNAME')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'单据单位名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYORGNAME'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'单据单位名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'T_CORE_MYTASK'
, @level2type = 'COLUMN', @level2name = N'CREATEDBYORGNAME'
GO

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

-- ----------------------------- 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', '');
-- ----------------------------- 2020-04-18 add by liyang--------------end