93 lines
6.9 KiB
SQL
93 lines
6.9 KiB
SQL
-- 1. Enroll 表
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge1' and [object_id]=object_id(N'Enroll'))
|
|
BEGIN
|
|
alter table Enroll add AdditionalCharge1 money NULL
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项1', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'Enroll', @level2type = N'COLUMN', @level2name = 'AdditionalCharge1';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge2' and [object_id]=object_id(N'Enroll'))
|
|
BEGIN
|
|
alter table Enroll add AdditionalCharge2 money NULL
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项2', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'Enroll', @level2type = N'COLUMN', @level2name = 'AdditionalCharge2';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge3' and [object_id]=object_id(N'Enroll'))
|
|
BEGIN
|
|
alter table Enroll add AdditionalCharge3 money NULL
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项3', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'Enroll', @level2type = N'COLUMN', @level2name = 'AdditionalCharge3';
|
|
END
|
|
|
|
--IF not exists(select * from sys.columns where name='Note' and [object_id]=object_id(N'Enroll'))
|
|
-- BEGIN
|
|
-- alter table Enroll add Note nvarchar(1000) NULL
|
|
-- EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项说明', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'Enroll', @level2type = N'COLUMN', @level2name = 'Note';
|
|
-- END
|
|
|
|
-- 2. TrialRevenuesPrice 表
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge1' and [object_id]=object_id(N'TrialRevenuesPrice'))
|
|
BEGIN
|
|
alter table TrialRevenuesPrice add AdditionalCharge1 money NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项1', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPrice', @level2type = N'COLUMN', @level2name = 'AdditionalCharge1';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge2' and [object_id]=object_id(N'TrialRevenuesPrice'))
|
|
BEGIN
|
|
alter table TrialRevenuesPrice add AdditionalCharge2 money NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项2', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPrice', @level2type = N'COLUMN', @level2name = 'AdditionalCharge2';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge3' and [object_id]=object_id(N'TrialRevenuesPrice'))
|
|
BEGIN
|
|
alter table TrialRevenuesPrice add AdditionalCharge3 money NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项3', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPrice', @level2type = N'COLUMN', @level2name = 'AdditionalCharge3';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='Note' and [object_id]=object_id(N'TrialRevenuesPrice'))
|
|
BEGIN
|
|
alter table TrialRevenuesPrice add Note nvarchar(1000) NULL
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项说明', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPrice', @level2type = N'COLUMN', @level2name = 'Note';
|
|
END
|
|
|
|
-- 3. DoctorWorkload 表
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge1' and [object_id]=object_id(N'DoctorWorkload'))
|
|
BEGIN
|
|
alter table DoctorWorkload add AdditionalCharge1 money NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项1', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'DoctorWorkload', @level2type = N'COLUMN', @level2name = 'AdditionalCharge1';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge2' and [object_id]=object_id(N'DoctorWorkload'))
|
|
BEGIN
|
|
alter table DoctorWorkload add AdditionalCharge2 money NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项2', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'DoctorWorkload', @level2type = N'COLUMN', @level2name = 'AdditionalCharge2';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge3' and [object_id]=object_id(N'DoctorWorkload'))
|
|
BEGIN
|
|
alter table DoctorWorkload add AdditionalCharge3 money NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项3', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'DoctorWorkload', @level2type = N'COLUMN', @level2name = 'AdditionalCharge3';
|
|
END
|
|
|
|
--IF not exists(select * from sys.columns where name='Note' and [object_id]=object_id(N'DoctorWorkload'))
|
|
-- BEGIN
|
|
-- alter table DoctorWorkload add Note nvarchar(1000) NULL
|
|
-- EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项说明', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'DoctorWorkload', @level2type = N'COLUMN', @level2name = 'Note';
|
|
-- END
|
|
|
|
-- 4. TrialRevenuesPriceVerification 表 (类型保持为 bit)
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge1' and [object_id]=object_id(N'TrialRevenuesPriceVerification'))
|
|
BEGIN
|
|
alter table TrialRevenuesPriceVerification add AdditionalCharge1 bit NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项1是否配置', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPriceVerification', @level2type = N'COLUMN', @level2name = 'AdditionalCharge1';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge2' and [object_id]=object_id(N'TrialRevenuesPriceVerification'))
|
|
BEGIN
|
|
alter table TrialRevenuesPriceVerification add AdditionalCharge2 bit NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项2是否配置', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPriceVerification', @level2type = N'COLUMN', @level2name = 'AdditionalCharge2';
|
|
END
|
|
|
|
IF not exists(select * from sys.columns where name='AdditionalCharge3' and [object_id]=object_id(N'TrialRevenuesPriceVerification'))
|
|
BEGIN
|
|
alter table TrialRevenuesPriceVerification add AdditionalCharge3 bit NOT NULL DEFAULT 0
|
|
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'扩展付费项3是否配置', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'TABLE', @level1name = 'TrialRevenuesPriceVerification', @level2type = N'COLUMN', @level2name = 'AdditionalCharge3';
|
|
END |