From fc1fe356e1cb43c7654c653e8921ee9e72150f96 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 21 七月 2021 16:18:30 +0800
Subject: [PATCH] 今日开发   7月5日以及之前的订单删除                增加功能 账户转账                会员订单同步到会员端                员工获取会员邀请码

---
 表修改.sql |  364 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 364 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 f5c27f9..7d13546 100644
--- "a/\350\241\250\344\277\256\346\224\271.sql"
+++ "b/\350\241\250\344\277\256\346\224\271.sql"
@@ -1,5 +1,369 @@
 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

--
Gitblit v1.9.1