|
1
|
DELETE FROM CM_ALLCODE WHERE CDNAME ='AUTH_STATUS' AND CDTYPE = 'CONREQDOC'
|
|
2
|
DELETE FROM CM_ALLCODE WHERE CDNAME ='AUTH_STATUS' AND CDTYPE = 'BLUEPRINT'
|
|
3
|
|
|
4
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'A',N'Đã duyệt',N'CONREQDOC',NULL)
|
|
5
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'U',N'Chờ duyệt',N'CONREQDOC',NULL)
|
|
6
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'R',N'Từ chối',N'CONREQDOC',NULL)
|
|
7
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'E',N'Lưu nháp',N'CONREQDOC',NULL)
|
|
8
|
|
|
9
|
|
|
10
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'A',N'Đã duyệt',N'BLUEPRINT',NULL)
|
|
11
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'U',N'Chờ duyệt',N'BLUEPRINT',NULL)
|
|
12
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'E',N'Lưu nháp',N'BLUEPRINT',NULL)
|
|
13
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'R',N'Từ chối',N'BLUEPRINT',NULL)
|
|
14
|
INSERT INTO [CM_ALLCODE] ([CDNAME],[CDVAL],[CONTENT],[CDTYPE],[LSTODR])VALUES(N'AUTH_STATUS',N'M',N'Tôi xử lý',N'BLUEPRINT',NULL)
|