From 82645238a5855f6f7b8c397d1f8fa8b4a3155b94 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 14 七月 2021 16:00:18 +0800 Subject: [PATCH] 提交 --- 表修改.sql | 105 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 105 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 cb08a9f..f177e5c 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,111 @@ 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 -- Gitblit v1.9.1