Wiki » 历史记录 » 版本 3
星 yan, 2026-09-23 06:45
| 1 | 2 | 星 yan | # SQL |
|---|---|---|---|
| 2 | ``` sql |
||
| 3 | CREATE TABLE [dbo].[hyx_guarantee_account_amount] ( |
||
| 4 | [id] bigint IDENTITY(1,1) NOT NULL, |
||
| 5 | [account_id] bigint, |
||
| 6 | [create_time] datetime NULL, |
||
| 7 | [update_time] datetime NULL, |
||
| 8 | [deleted] bigint NULL, |
||
| 9 | [company_name] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, |
||
| 10 | [total_amount] float DEFAULT 0 NULL |
||
| 11 | ) |
||
| 12 | GO |
||
| 13 | |||
| 14 | ALTER TABLE [dbo].[hyx_guarantee_account_amount] SET (LOCK_ESCALATION = TABLE) |
||
| 15 | GO |
||
| 16 | |||
| 17 | EXEC sp_addextendedproperty |
||
| 18 | 'MS_Description', N'企业名称', |
||
| 19 | 'SCHEMA', N'dbo', |
||
| 20 | 'TABLE', N'hyx_guarantee_account_amount', |
||
| 21 | 'COLUMN', N'company_name' |
||
| 22 | GO |
||
| 23 | |||
| 24 | EXEC sp_addextendedproperty |
||
| 25 | 'MS_Description', N'账户总金额', |
||
| 26 | 'SCHEMA', N'dbo', |
||
| 27 | 'TABLE', N'hyx_guarantee_account_amount', |
||
| 28 | 'COLUMN', N'total_amount' |
||
| 29 | GO |
||
| 30 | |||
| 31 | ``` |