From f0226fac55f50b362d145ce969e66d41606a8b06 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 30 七月 2021 14:13:16 +0800
Subject: [PATCH] 今日开发  订单优惠   下订单的时候计算优惠                访问申请

---
 表修改.sql |  295 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 295 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 82e0866..e2b94cf 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,298 @@
+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

--
Gitblit v1.9.1