From 2c78cb7f8632d1384adbaa4a4828009716273bef Mon Sep 17 00:00:00 2001 From: chen.llin <1442464845@qq.comm> Date: 星期三, 24 十二月 2025 10:43:17 +0800 Subject: [PATCH] 新增参数字段sql --- src/main/java/monthly_settle.sql | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/src/main/java/monthly_settle.sql b/src/main/java/monthly_settle.sql index f9372ff..b4b964e 100644 --- a/src/main/java/monthly_settle.sql +++ b/src/main/java/monthly_settle.sql @@ -88,3 +88,21 @@ EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏈堢粨ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_log_pakout', @level2type = N'COLUMN', @level2name = N'monthly_settle_id'; EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏈堢粨缂栧彿', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_log_pakout', @level2type = N'COLUMN', @level2name = N'monthly_settle_no'; + +-- 涓� man_order_pakin 琛ㄦ坊鍔犳湀缁撳弬鏁板瓧娈� +ALTER TABLE [man_order_pakin] ADD [monthly_settle_id] bigint DEFAULT NULL; +ALTER TABLE [man_order_pakin] ADD [monthly_settle_no] varchar(255) DEFAULT NULL; +CREATE INDEX [idx_monthly_settle_id] ON [man_order_pakin] ([monthly_settle_id]); + +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏈堢粨ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_pakin', @level2type = N'COLUMN', @level2name = N'monthly_settle_id'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏈堢粨缂栧彿', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_pakin', @level2type = N'COLUMN', @level2name = N'monthly_settle_no'; + +-- 涓� man_order_pakout 琛ㄦ坊鍔犳湀缁撳弬鏁板瓧娈� +ALTER TABLE [man_order_pakout] ADD [monthly_settle_id] bigint DEFAULT NULL; +ALTER TABLE [man_order_pakout] ADD [monthly_settle_no] varchar(255) DEFAULT NULL; +CREATE INDEX [idx_monthly_settle_id] ON [man_order_pakout] ([monthly_settle_id]); + +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏈堢粨ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_pakout', @level2type = N'COLUMN', @level2name = N'monthly_settle_id'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏈堢粨缂栧彿', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_pakout', @level2type = N'COLUMN', @level2name = N'monthly_settle_no'; + + -- Gitblit v1.9.1