|
1
|
|
|
2
|
|
|
3
|
DELETE FROM TL_SYSROLE_LIMIT WHERE LIMIT_TYPE='DCNS'
|
|
4
|
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000012',N'GDK',150000000,N'GDK_DC',N'admin',N'U',NULL,NULL,NULL,N'1',N'DCNS',2,NULL)
|
|
5
|
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000013',N'PTGD',150000000,N'PTGD_DC',N'admin',N'U',NULL,NULL,NULL,N'2',N'DCNS',2,NULL)
|
|
6
|
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000014',N'TGD',NULL,N'TGD_DC',N'admin',N'U',NULL,NULL,NULL,N'3',N'DCNS',NULL,NULL)
|
|
7
|
INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LMI00014',N'GDDV',20000000,N'',N'',N'',N'',N'Nov 30 2020 10:33AM',N'',N'',N'DCNS',30,N'')
|
|
8
|
|
|
9
|
|
|
10
|
INSERT dbo.SYS_PREFIX
|
|
11
|
(
|
|
12
|
ID,
|
|
13
|
Prefix,
|
|
14
|
Description
|
|
15
|
)
|
|
16
|
VALUES
|
|
17
|
( 'LIMIT_ACCUMULATE', -- ID - varchar(100)
|
|
18
|
'LMAC', -- Prefix - varchar(10)
|
|
19
|
N'' -- Description - nvarchar(1000)
|
|
20
|
)
|