From 5dca49269399c21333b16d62945c7f74570f9ad5 Mon Sep 17 00:00:00 2001 From: chen.llin <1442464845@qq.comm> Date: 星期三, 24 十二月 2025 20:33:59 +0800 Subject: [PATCH] 字段调整 --- src/main/resources/sql/man_order_time_change_log.sql | 29 +++++++++++++++++++++++++++++ 1 files changed, 29 insertions(+), 0 deletions(-) diff --git a/src/main/resources/sql/man_order_time_change_log.sql b/src/main/resources/sql/man_order_time_change_log.sql new file mode 100644 index 0000000..52904f6 --- /dev/null +++ b/src/main/resources/sql/man_order_time_change_log.sql @@ -0,0 +1,29 @@ +-- 涓氬姟鏃堕棿鍙樻洿璁板綍琛� +CREATE TABLE [man_order_time_change_log] ( + [id] bigint NOT NULL IDENTITY(1,1), + [order_id] bigint NOT NULL, + [order_no] varchar(255) NOT NULL, + [order_type] int NOT NULL, + [old_order_time] varchar(255) NOT NULL, + [new_order_time] varchar(255) NOT NULL, + [memo] varchar(500) DEFAULT NULL, + [create_by] bigint DEFAULT NULL, + [create_time] datetime DEFAULT NULL, + PRIMARY KEY ([id]) +); + +CREATE INDEX [idx_order_id] ON [man_order_time_change_log] ([order_id]); +CREATE INDEX [idx_order_no] ON [man_order_time_change_log] ([order_no]); +CREATE INDEX [idx_create_time] ON [man_order_time_change_log] ([create_time]); + +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'涓氬姟鏃堕棿鍙樻洿璁板綍琛�', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'id'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'璁㈠崟ID', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'order_id'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鍗曟嵁缂栧彿', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'order_no'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'璁㈠崟绫诲瀷 1:鍏ュ簱 2:鍑哄簱', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'order_type'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鍘熶笟鍔℃椂闂�', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'old_order_time'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鏂颁笟鍔℃椂闂�', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'new_order_time'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'澶囨敞', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'memo'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鍒涘缓浜�', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'create_by'; +EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'鍒涘缓鏃堕棿', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'man_order_time_change_log', @level2type = N'COLUMN', @level2name = N'create_time'; + -- Gitblit v1.9.1