From 57556b16aafbafebc7f9fc86745ac2ea83e7616d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 01 七月 2021 14:26:35 +0800
Subject: [PATCH] 流程 请假 销假 待办 已办 我得申请
---
表修改.sql | 230 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 230 insertions(+), 0 deletions(-)
diff --git "a/\350\241\250\344\277\256\346\224\271.sql" "b/\350\241\250\344\277\256\346\224\271.sql"
index 38629a9..1d9825a 100644
--- "a/\350\241\250\344\277\256\346\224\271.sql"
+++ "b/\350\241\250\344\277\256\346\224\271.sql"
@@ -1,3 +1,233 @@
+
+
+USE [zhengcaioa]
+GO
+
+
+ALTER TABLE [dbo].[wf_run_process] ADD [deelurl] [nvarchar](500) NULL;
+GO
+
+
+
+
+
+
+ALTER TABLE [dbo].[IntentionCustomer] ADD [Yixiangtime] [datetime] NULL;
+GO
+
+ALTER TABLE [dbo].[IntentionCustomer] ADD [Yixiang] [nvarchar](50) NULL;
+GO
+
+ALTER TABLE [dbo].[IntentionCustomer] ADD [dianxiaozhuanyuan] [nvarchar](50) NULL;
+GO
+
+ALTER TABLE [dbo].[IntentionCustomer] ADD [zuijinzhuizongtime] [datetime] NULL;
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[l_zhuanjiahuida] Script Date: 2021/6/27 12:38:30 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='l_zhuanjiahuida') --查询表名costSeparateConfig是否存在
+drop table [l_zhuanjiahuida]
+GO
+CREATE TABLE [dbo].[l_zhuanjiahuida](
+ [Id] [nvarchar](50) NOT NULL,
+ [userid] [nvarchar](50) NULL,
+ [username] [nvarchar](100) NULL,
+ [anwser] [nvarchar](4000) NULL,
+ [question] [nvarchar](500) NULL,
+ [huida_status] [nvarchar](1) NOT NULL,
+ [rec_status] [nvarchar](1) NOT NULL,
+ [creater] [nvarchar](50) NOT NULL,
+ [createtime] [datetime] NOT NULL,
+ [modifier] [nvarchar](50) NOT NULL,
+ [modifytime] [datetime] NOT NULL,
+
+ CONSTRAINT [PK_zhuanjiahuida] PRIMARY KEY CLUSTERED
+(
+ [Id] 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
+
+ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[l_zhuanjiahuida] ADD CONSTRAINT [DF_l_zhuanjiahuida_createtime] DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[l_zhuanjiahuida] ADD CONSTRAINT [DF_l_zhuanjiahuida_modifytime] DEFAULT (getdate()) FOR [modifytime]
+GO
+ALTER TABLE [dbo].[l_zhuanjiahuida] ADD DEFAULT ('D') FOR [huida_status]
+GO
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[cus_fangwenjilu] Script Date: 2021/6/9 14:15:04 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='cus_fangwenjilu') --查询表名costSeparateConfig是否存在
+drop table [cus_fangwenjilu]
+GO
+
+CREATE TABLE [dbo].[cus_fangwenjilu](
+ [Id] [nvarchar](50) NOT NULL,
+ [fasongfangshi] [nvarchar](50) NULL,
+ [fasongneirong] [nvarchar](4000) NULL,
+ [jieshouren] [nvarchar](2000) NULL,
+
+
+
+ [rec_status] [nvarchar](1) NOT NULL,
+ [creater] [nvarchar](50) NOT NULL,
+ [createtime] [datetime] NOT NULL,
+ [modifier] [nvarchar](50) NOT NULL,
+ [modifytime] [datetime] NOT NULL,
+ CONSTRAINT [PK_cus_fangwenjilu] PRIMARY KEY CLUSTERED
+(
+ [Id] 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
+
+ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[cus_fangwenjilu] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
USE [zhengcaioa]
GO
--
Gitblit v1.9.1