54 lines
1.2 KiB
Transact-SQL
54 lines
1.2 KiB
Transact-SQL
|
|
ALTER TABLE [dbo].[PW_JointInfo] Add
|
|
[ISO_Type] [nvarchar](50) NULL
|
|
|
|
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¹ÜµÀÀà±ðºÅ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PW_JointInfo', @level2type=N'COLUMN',@level2name=N'ISO_Type'
|
|
|
|
|
|
INSERT INTO [dbo].[Sys_Const]
|
|
([ID]
|
|
,[ConstValue]
|
|
,[ConstText]
|
|
,[SortIndex]
|
|
,[GroupId]
|
|
)
|
|
VALUES
|
|
('D01E754E-7963-4F63-A690-97EA08550A98'
|
|
,'GC1'
|
|
,'GC1'
|
|
,1
|
|
,'ISOTYPE'
|
|
)
|
|
INSERT INTO [dbo].[Sys_Const]
|
|
([ID]
|
|
,[ConstValue]
|
|
,[ConstText]
|
|
,[SortIndex]
|
|
,[GroupId]
|
|
)
|
|
VALUES
|
|
('5BA78482-BBE9-4BEF-9230-9BA52F493675'
|
|
,'GC2'
|
|
,'GC2'
|
|
,2
|
|
,'ISOTYPE'
|
|
)
|
|
INSERT INTO [dbo].[Sys_Const]
|
|
([ID]
|
|
,[ConstValue]
|
|
,[ConstText]
|
|
,[SortIndex]
|
|
,[GroupId]
|
|
)
|
|
VALUES
|
|
('61245F4E-71F7-451E-B9D1-61FD9D4578DC'
|
|
,'GC3'
|
|
,'GC3'
|
|
,3
|
|
,'ISOTYPE'
|
|
)
|
|
|
|
|
|
|