From 15eb82df2d6ec539e9d4245bfe08d531e8eb6379 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期日, 27 四月 2025 14:33:26 +0800
Subject: [PATCH] 修改培训订单占多个座位

---
 表修改.sql |  531 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 531 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 0091523..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,533 @@
 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
@@ -63,6 +590,10 @@
 
 
 
+ 
+
+
+
 
 
 

--
Gitblit v1.9.1