From 2e177c04047f38876f89e5d9ccabcc3bed112727 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 08 七月 2021 15:06:20 +0800
Subject: [PATCH] 今日开发 问题新增 增加是否出书 是否收藏：是、否 每个人的收藏不一样 档案客户访问： 选择短信内容，然后提交的时候发送短信给客户
---
表修改.sql | 106 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 106 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..bac131b 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,112 @@
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
--
Gitblit v1.9.1