From 67a0042c5f29e4bb0e0b82f6190f2bc51480b45c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 28 二月 2023 13:25:09 +0800
Subject: [PATCH] 工资绩效改版
---
表修改.sql | 2178 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 2,178 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 b5438b0..eca7a23 100644
--- "a/\350\241\250\344\277\256\346\224\271.sql"
+++ "b/\350\241\250\344\277\256\346\224\271.sql"
@@ -1,6 +1,2184 @@
USE [zhengcaioa]
GO
+/****** Object: Table [dbo].[ADM_AskJiaojie] Script Date: 2021/8/26 8:56:15 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskJiaojie](
+ [Id] [nvarchar](50) NOT NULL,
+ [CiZhiId] [nvarchar](50) NULL,
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskJiaojie__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+
+
+ALTER TABLE [dbo].[ADM_AskJiaojie] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojie] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojie] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojie] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojie] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojie] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskJiaojieDtl] Script Date: 2021/8/26 8:56:15 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskJiaojieDtl](
+ [Id] [nvarchar](50) NOT NULL,
+ [JiaojieId] [nvarchar](50) NULL,
+
+
+ [Jiaojietime] [datetime] NULL,
+ [JiaojieType] [nvarchar](50) NULL,
+ [Kehudanwei] [nvarchar](500) NULL,
+ [JiaojieNeirong] [nvarchar](500) NULL,
+ [JiaojieUserId] [nvarchar](50) NULL,
+ [JieShoutime] [datetime] NULL,
+
+
+ [jiaojie_status] [nvarchar](1) 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__AskJiaojieDtl__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+
+
+ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD DEFAULT ('D') FOR [jiaojie_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskJiaojieDtl] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskCiZhi] Script Date: 2021/8/25 8:43:44 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskCiZhi](
+ [Id] [nvarchar](50) NOT NULL,
+
+ [OrderType] [nvarchar](50) NULL,
+
+
+ [Remark] [nvarchar](2000) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [DeptName] [nvarchar](50) NULL,
+ [PostName] [nvarchar](50) NULL,
+ [CreatetimeName] [nvarchar](50) NULL,
+ [RuzhitimeName] [nvarchar](50) NULL,
+ [JiaojieUser] [nvarchar](500) NULL,
+ [Outtime] [datetime] NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskCiZhi __3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+
+ALTER TABLE [dbo].[ADM_AskCiZhi] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCiZhi] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCiZhi] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCiZhi] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCiZhi] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCiZhi] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+ALTER TABLE [dbo].[adm_goods_manage] ADD [haocai_status] [nvarchar](1) DEFAULT ('D')
+GO
+
+
+update [adm_goods_manage] set [haocai_status]='D'
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_Customer_withdrawal] Script Date: 2021/8/9 13:43:29 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_Customer_withdrawal](
+ [Id] [nvarchar](50) NOT NULL,
+ [OrderNo] [nvarchar](50) NULL,
+ [Jine] [money] NULL,
+ [HuiyuanName] [nvarchar](100) NULL,
+ [HuiyuanId] [nvarchar](50) NULL,
+ [HuiyuanPhone] [nvarchar](50) NULL,
+
+ [BankAcount] [nvarchar](50) NULL,
+ [BankName] [nvarchar](50) NULL,
+ [Username] [nvarchar](50) NULL,
+
+
+
+ [Shenqingtime] [datetime] NOT NULL,
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__Customer_withdrawal__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ((0)) FOR [Jine]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [Shenqingtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+
+ALTER TABLE [Liaotian] ALTER COLUMN [shiyongfatiao] [nvarchar](1000) NULL
+GO
+
+
+
+ALTER TABLE [dbo].[Project] ADD [caigouyusuan] [money] NULL
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_Customer_withdrawal] Script Date: 2021/8/3 9:08:32 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_Customer_withdrawal](
+ [Id] [nvarchar](50) NOT NULL,
+ [OrderNo] [nvarchar](50) NULL,
+ [Jine] [money] NULL,
+ [HuiyuanName] [nvarchar](100) NULL,
+ [HuiyuanId] [nvarchar](50) NULL,
+ [HuiyuanPhone] [nvarchar](50) NULL,
+ [Shenqingtime] [datetime] NOT NULL,
+
+
+
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__Customer_withdrawal__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ((0)) FOR [Jine]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+ALTER TABLE [dbo].[ADM_Customer_withdrawal] ADD DEFAULT (getdate()) FOR [Shenqingtime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskBaiFang] Script Date: 2021/7/30 9:03:25 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskBaiFang](
+ [Id] [nvarchar](50) NOT NULL,
+
+ [CustomerId] [nvarchar](50) NULL,
+ [VisType] [nvarchar](50) NULL,
+ [Jtype] [nvarchar](50) NULL,
+ [BaiFangtime] [datetime] NULL,
+ [Remark] [nvarchar](500) NULL,
+
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskBaiFang __3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_AskBaiFang] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskBaiFang] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskBaiFang] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskBaiFang] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskBaiFang] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskBaiFang] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskYouHui] Script Date: 2021/7/30 9:03:25 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskYouHui](
+ [Id] [nvarchar](50) NOT NULL,
+ [CustomerId] [nvarchar](50) NULL,
+ [OrderType] [nvarchar](50) NULL,
+ [Youhuistandard] [nvarchar](50) NULL,
+ [YouHui] [money] NULL,
+ [Remark] [nvarchar](500) NULL,
+
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskYouHui __3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT ((0)) FOR [YouHui]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskYouHui] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD [break_precedentId] [nvarchar](50) NULL;
+GO
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD [ToUserId] [nvarchar](50) NULL;
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskMarketingCost] Script Date: 2021/7/28 8:39:35 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskMarketingCost](
+ [Id] [nvarchar](50) NOT NULL,
+ [Feiyong] [money] NULL,
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskMarketingCost __3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT ((0)) FOR [Feiyong]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskMarketingCost] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskCar] Script Date: 2021/7/28 8:39:35 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskCar](
+ [Id] [nvarchar](50) NOT NULL,
+ [CarLaiyuan] [nvarchar](50) NULL,
+ [Feiyong] [money] NULL,
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskCar__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT ((0)) FOR [Feiyong]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskCar] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_Askovertime] Script Date: 2021/7/26 8:55:14 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_Askovertime](
+ [Id] [nvarchar](50) NOT NULL,
+ [overtime] [money] NULL,
+ [jiabantime] [datetime] NULL,
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__Askovertime__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT ((0)) FOR [overtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_Askovertime] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_AskGoods] Script Date: 2021/7/23 8:54:23 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_AskGoods](
+ [Id] [nvarchar](50) NOT NULL,
+ [GoodsId] [nvarchar](50) NULL,
+ [Shuliang] [money] NULL,
+
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__AskGoods__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+
+
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT ((0)) FOR [Shuliang]
+GO
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_AskGoods] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[ADM_Askcost] Script Date: 2021/7/23 8:54:23 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[ADM_Askcost](
+ [Id] [nvarchar](50) NOT NULL,
+
+ [Cost] [money] NULL,
+
+ [Remark] [nvarchar](500) NULL,
+ [shenpi_status] [nvarchar](1) 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,
+ [createrName] [nvarchar](50) NULL,
+ [tittle] [nvarchar](50) NULL,
+ CONSTRAINT [PK__Askcost__3214EC077AC5FA48] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+
+
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT ((0)) FOR [Cost]
+GO
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT ('D') FOR [shenpi_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[ADM_Askcost] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+ALTER TABLE [dbo].[plt_user] ADD [yaoqingma] [nvarchar](50) NULL
+
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [weixiner] [nvarchar](50) NULL
+
+GO
+ ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [weixintime] [datetime] NULL
+
+GO
+
+
+ ALTER TABLE [dbo].[Liaotian] ADD [shenhetime] [datetime] NULL
+
+GO
+ALTER TABLE [dbo].[Liaotian] ADD [shenheer] [nvarchar](50) NULL
+
+GO
+
+
+ALTER TABLE [dbo].[adm_piece_check] ADD [shuliang] [money] NULL
+
+GO
+
+
+USE [zhengcaioa]
+GO
+
+ALTER TABLE [dbo].[IntentionCustomer] ADD [weixiner] [nvarchar](50) NULL
+
+GO
+ ALTER TABLE [dbo].[IntentionCustomer] ADD [weixintime] [datetime] NULL
+
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[sys_updatetime] Script Date: 2021/7/13 14:21:26 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[sys_updatetime](
+ [Id] [nvarchar](50) NOT NULL,
+ [updatename] [nvarchar](100) NOT NULL,
+ [updatetime] [datetime] NOT NULL,
+ CONSTRAINT [PK_sys_updatetime] 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
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+ALTER TABLE [dbo].[CooperatecustomCustomer] ADD [huiyuanId] [nvarchar](50) NULL
+
+GO
+EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CooperatecustomCustomer', @level2type=N'COLUMN',@level2name=N'huiyuanId'
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+ALTER TABLE [dbo].[CooperOrder] ADD [songhuo_gongsi] [nvarchar](100) NULL
+GO
+ALTER TABLE [dbo].[CooperOrder] ADD [songhuo_danhao] [nvarchar](100) NULL
+GO
+
+ALTER TABLE [dbo].[CooperOrder] ADD [songhuo_time] [datetime] NULL
+GO
+
+
+
+ALTER TABLE [dbo].[CooperOrder] ADD [huifang_jdr] [nvarchar](100) NULL
+GO
+
+
+ALTER TABLE [dbo].[CooperOrder] ADD [huifang_kehuyijian] [nvarchar](500) NULL
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[Liaotian_shoucang] Script Date: 2021/7/8 8:49:01 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+
+CREATE TABLE [dbo].[Liaotian_shoucang](
+ [Id] [nvarchar](50) NOT NULL,
+ [Liaotian_id] [nvarchar](50) 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_Liaotian_shoucang] 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].[Liaotian_shoucang] ADD DEFAULT ('a') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[Liaotian_shoucang] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[Liaotian_shoucang] ADD CONSTRAINT [DF_Liaotian_shoucang_createtime] DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[Liaotian_shoucang] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[Liaotian_shoucang] ADD CONSTRAINT [DF_Liaotian_shoucang_modifytime] DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+ALTER TABLE [dbo].[Liaotian] ADD [chushu_status] [nvarchar](1) NULL DEFAULT ('D')
+GO
+
+update [dbo].[Liaotian] set [chushu_status] = 'D'
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[order_banci_order] Script Date: 2021/7/5 14:33:24 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='order_banci_order') --查询表名costSeparateConfig是否存在
+drop table [order_banci_order]
+GO
+CREATE TABLE [dbo].[order_banci_order](
+ [Id] [nvarchar](50) NOT NULL,
+ [baomingtime] [datetime] NOT NULL,
+ [banci_id] [nvarchar](50) NULL,
+ [peixunbanci] [nvarchar](100) NULL,
+ [kechengleixing_id] [nvarchar](50) NULL,
+ [kechengleixing] [nvarchar](100) NULL,
+ [person_id] [nvarchar](100) NULL,
+ [xingming] [nvarchar](100) NULL,
+ [lianxidianhua] [nvarchar](100) NULL,
+ [shenfenzheng] [nvarchar](100) NULL,
+ [xuefei] [money] NULL,
+ [baomingrenshu] [int] NULL,
+ [jine] [money] 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_order_banci_order] 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].[order_banci_order] ADD CONSTRAINT [DF_order_banci_order_rec_status] DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[order_banci_order] ADD CONSTRAINT [DF_order_banci_order_creater] DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[order_banci_order] ADD CONSTRAINT [DF_order_banci_order_createtime] DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[order_banci_order] ADD CONSTRAINT [DF_order_banci_order_modifier] DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[order_banci_order] ADD CONSTRAINT [DF_order_banci_order_modifytime] DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[order_banci] Script Date: 2021/7/5 14:33:24 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='order_banci') --查询表名costSeparateConfig是否存在
+drop table [order_banci]
+GO
+CREATE TABLE [dbo].[order_banci](
+ [Id] [nvarchar](50) NOT NULL,
+ [banci] [nvarchar](100) NULL,
+ [mingcheng] [nvarchar](100) NULL,
+ [shijian] [datetime] NULL,
+ [shijianend] [datetime] NULL,
+ [didian] [nvarchar](500) NULL,
+ [renshu] [int] 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_order_banci] 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].[order_banci] ADD CONSTRAINT [DF_order_banci_rec_status] DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[order_banci] ADD CONSTRAINT [DF_order_banci_creater] DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[order_banci] ADD CONSTRAINT [DF_order_banci_createtime] DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[order_banci] ADD CONSTRAINT [DF_order_banci_modifier] DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[order_banci] ADD CONSTRAINT [DF_order_banci_modifytime] DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[order_banci_dtl] Script Date: 2021/7/5 14:33:24 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='order_banci_dtl') --查询表名costSeparateConfig是否存在
+drop table [order_banci_dtl]
+GO
+CREATE TABLE [dbo].[order_banci_dtl](
+ [Id] [nvarchar](50) NOT NULL,
+ [order_banci_id] [nvarchar](50) NULL,
+ [shangxiawu] [nvarchar](100) NULL,
+ [shijian] [nvarchar](100) NULL,
+ [shixiamg] [nvarchar](500) NULL,
+ [zhujiangren] [nvarchar](100) NULL,
+ [sort] [int] 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_order_banci_dtl] 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].[order_banci_dtl] ADD CONSTRAINT [DF_order_banci_order_sort] DEFAULT (0) FOR [sort]
+GO
+ALTER TABLE [dbo].[order_banci_dtl] ADD CONSTRAINT [DF_order_banci_dtl_rec_status] DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[order_banci_dtl] ADD CONSTRAINT [DF_order_banci_dtl_creater] DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[order_banci_dtl] ADD CONSTRAINT [DF_order_banci_dtl_createtime] DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[order_banci_dtl] ADD CONSTRAINT [DF_order_banci_dtl_modifier] DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[order_banci_dtl] ADD CONSTRAINT [DF_order_banci_dtl_modifytime] DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[IntentionVisit_duanxin] Script Date: 2021/7/5 14:33:24 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='IntentionVisit_duanxin') --查询表名costSeparateConfig是否存在
+drop table [IntentionVisit_duanxin]
+GO
+CREATE TABLE [dbo].[IntentionVisit_duanxin](
+ [Id] [nvarchar](50) NOT NULL,
+ [duanxin_title] [nvarchar](50) NULL,
+ [duanxin_neirong] [nvarchar](500) 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_IntentionVisit_duanxin] 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].[IntentionVisit_duanxin] ADD CONSTRAINT [DF_IntentionVisit_duanxin_rec_status] DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD CONSTRAINT [DF_IntentionVisit_duanxin_creater] DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD CONSTRAINT [DF_IntentionVisit_duanxin_createtime] DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD CONSTRAINT [DF_IntentionVisit_duanxin_modifier] DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[IntentionVisit_duanxin] ADD CONSTRAINT [DF_IntentionVisit_duanxin_modifytime] DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+ ALTER TABLE [dbo].[IntentionVisit] ADD [duanxin_neirong] [nvarchar](500) NULL
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
/****** Object: Table [dbo].[fi_member] Script Date: 2021/7/5 14:33:24 ******/
SET ANSI_NULLS ON
GO
--
Gitblit v1.9.1