From 10ec50f8e9ded45e8b439114a17ed89297c948c7 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 13 七月 2021 15:04:51 +0800 Subject: [PATCH] 提交 --- 表修改.sql | 130 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 130 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 bac131b..cb08a9f 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,136 @@ 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 -- Gitblit v1.9.1