From 03194d6867ef9e34e9b7fd05ada0600456e132de Mon Sep 17 00:00:00 2001
From: CB2-20200827ONU\Administrator <liaoxujun@qq.com>
Date: 星期三, 22 九月 2021 09:33:56 +0800
Subject: [PATCH] no message

---
 20210922数据库修改表.sql |   55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 55 insertions(+), 0 deletions(-)

diff --git "a/20210922\346\225\260\346\215\256\345\272\223\344\277\256\346\224\271\350\241\250.sql" "b/20210922\346\225\260\346\215\256\345\272\223\344\277\256\346\224\271\350\241\250.sql"
new file mode 100644
index 0000000..78ae518
--- /dev/null
+++ "b/20210922\346\225\260\346\215\256\345\272\223\344\277\256\346\224\271\350\241\250.sql"
@@ -0,0 +1,55 @@
+USE [ECTEST]
+GO
+
+
+SET ANSI_NULLS ON
+GO
+/****** 在客户表中增加两个字段 例行维护字段和客户维护字段 ******/
+SET QUOTED_IDENTIFIER ON
+GO
+alter table [OA_CorporateClients] add [NeedWiHu] [bit] NULL,
+               [JieJiaRiWiHu] [bit] null
+               GO
+               
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'需要例行维护' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClients', @level2type=N'COLUMN',@level2name=N'NeedWiHu'
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'需要节假日维护' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClients', @level2type=N'COLUMN',@level2name=N'JieJiaRiWiHu'
+GO
+/****** 在客户表中增加两个字段 例行维护字段和客户维护字段 ******/
+CREATE TABLE [dbo].[OA_CorporateClientContract](
+	[Keyid] [uniqueidentifier] NOT NULL,
+	[CorporateClientsid] [uniqueidentifier] NOT NULL,
+	[CorporateClientsName] [varchar](255) NULL,
+	[FileName] [varchar](50) NULL,
+	[PageCode] [int] NULL,
+	[FilePath] [varchar](255) NULL,
+	[Remark] [varchar](200) NULL,
+	[Creater] [uniqueidentifier] NULL,
+	[CreateTime] [datetime] NULL,
+	[Updater] [uniqueidentifier] NULL,
+	[LastUpdateTime] [datetime] NULL,
+ CONSTRAINT [OA_CorporateClientsContract] PRIMARY KEY CLUSTERED 
+(
+	[Keyid] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClientContract', @level2type=N'COLUMN',@level2name=N'CorporateClientsid'
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClientContract', @level2type=N'COLUMN',@level2name=N'CorporateClientsName'
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClientContract', @level2type=N'COLUMN',@level2name=N'FileName'
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'页码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClientContract', @level2type=N'COLUMN',@level2name=N'PageCode'
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClientContract', @level2type=N'COLUMN',@level2name=N'FilePath'
+GO
+
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OA_CorporateClientContract', @level2type=N'COLUMN',@level2name=N'Remark'
+GO
\ No newline at end of file

--
Gitblit v1.9.1