002.sql 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. INSERT INTO sm_appregister (
  2. pk_appregister,
  3. app_desc,
  4. apptype,
  5. code,
  6. creationtime,
  7. creator,
  8. dr,
  9. fun_property,
  10. funtype,
  11. height,
  12. help_name,
  13. image_src,
  14. iscauserusable,
  15. iscopypage,
  16. isenable,
  17. mdid,
  18. modifiedtime,
  19. modifier,
  20. mountid,
  21. name,
  22. orgtypecode,
  23. own_module,
  24. parent_id,
  25. pk_group,
  26. resid,
  27. source_app_code,
  28. target_path,
  29. ts,
  30. uselicense_load,
  31. width
  32. )
  33. VALUES
  34. (
  35. '0001ZZZZ7a8b7524a54b',
  36. '',
  37. 1,
  38. '60201070',
  39. '2021-09-09 16:12:39',
  40. '~',
  41. 0,
  42. 0,
  43. 0,
  44. 1,
  45. '',
  46. 'businessprocess',
  47. 'N',
  48. 'N',
  49. 'Y',
  50. '~',
  51. NULL,
  52. '~',
  53. NULL,
  54. '本月加班申请',
  55. 'GLOBLE00000000000000',
  56. '6020',
  57. '0001ZZZZZZ0000602010',
  58. '~',
  59. '',
  60. '60201070',
  61. NULL,
  62. '2021-09-09 16:12:39',
  63. 'Y',
  64. 1
  65. );
  66. go
  67. insert into sm_apppage(pk_apppage,creationtime,creator,dr,iscarddefault,isdefault,modifiedtime,modifier,pagecode,pagedesc,pagename,pageurl,parent_id,parentcode,resid,ts) values('0001ZZZZ52d564646e02',null,'~',0,'N','Y',null,'~','60201070_LIST',null,'本月加班申请列表页面','/nccloud/resources/hrkq/hrkq/60201070/main/index.html#/list','0001ZZZZ7a8b7524a54b','60201070','60201070_LIST','2021-09-09 16:12:39');
  68. go
  69. insert into sm_apppage(pk_apppage,creationtime,creator,dr,iscarddefault,isdefault,modifiedtime,modifier,pagecode,pagedesc,pagename,pageurl,parent_id,parentcode,resid,ts) values('0001ZZZZ6937030c8810',null,'~',0,'Y','N',null,'~','60201070_CARD',null,'本月加班申请卡片页面','/nccloud/resources/hrkq/hrkq/60201070/main/index.html#/card','0001ZZZZ7a8b7524a54b','60201070','60201070_CARD','2021-09-09 16:12:39');
  70. go
  71. insert into sm_appmenuitem(pk_menuitem,appcode,appid,dr,menudes,menuitemcode,menuitemname,parentcode,pk_group,pk_menu,resid,ts)
  72. values('0001ZZZZ13135565e3b8','60201070','0001ZZZZ7a8b7524a54b',0,'本月加班申请','60323021','hrkq','603230','~','1004Z510000000000FFL',null,'2021-09-09 16:12:39');
  73. go
  74. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZd9b65a83d187','0001ZZZZ7a8b7524a54b','card_head','SaveGroup','button_secondary','编辑按钮组','',0,'buttongroup',0,'Y','N',null,null,'60201070_CARD',null,null,'2021-09-09 16:12:39')
  75. ;
  76. go
  77. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZeb7ef86a2db5','0001ZZZZ7a8b7524a54b','card_head','SaveBtn','button_main','','保存',1,'general_btn',0,'Y','N','Ctrl+S',null,'60201070_CARD','SaveGroup','60201070_CARDSaveBtn','2021-09-09 16:12:39')
  78. ;
  79. go
  80. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZafb14d9152f3','0001ZZZZ7a8b7524a54b','card_head','SaveAddBtn','button_secondary','','保存新增',2,'general_btn',0,'Y','N','Alt+S',null,'60201070_CARD','SaveGroup','60201070_CARDSaveAddBtn','2021-09-09 16:12:39')
  81. ;
  82. go
  83. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZde465689cdf3','0001ZZZZ7a8b7524a54b','card_head','CancelBtn','button_secondary','','取消',4,'general_btn',0,'Y','N','Alt+Q',null,'60201070_CARD',null,'60201070_CARDCancelBtn','2021-09-09 16:12:39')
  84. ;
  85. go
  86. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ3fb32e5c27ae','0001ZZZZ7a8b7524a54b','card_head','CUDGroup','button_secondary','CUD组','',5,'buttongroup',0,'Y','N','',null,'60201070_CARD',null,null,'2021-09-09 16:12:39')
  87. ;
  88. go
  89. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZbbccf66512ad','0001ZZZZ7a8b7524a54b','card_head','CreateBtn','button_secondary','','新增',6,'general_btn',0,'Y','N','Ctrl+/',null,'60201070_CARD','CUDGroup','60201070_CARDCreateBtn','2021-09-09 16:12:39')
  90. ;
  91. go
  92. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ2a06fa1891c9','0001ZZZZ7a8b7524a54b','card_head','UpdateBtn','button_secondary','','修改',7,'general_btn',0,'Y','N','Alt+P',null,'60201070_CARD','CUDGroup','60201070_CARDUpdateBtn','2021-09-09 16:12:39')
  93. ;
  94. go
  95. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZd5914297988f','0001ZZZZ7a8b7524a54b','card_head','DeleteBtn','button_secondary','','删除',8,'general_btn',0,'Y','N','Ctrl+Del',null,'60201070_CARD','CUDGroup','60201070_CARDDeleteBtn','2021-09-09 16:12:39')
  96. ;
  97. go
  98. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ013f3dc0a674','0001ZZZZ7a8b7524a54b','card_head','RefreshBtn','button_secondary','',null,8,'general_btn',0,'Y','N',null,null,'60201070_CARD',null,null,'2021-09-09 16:12:39')
  99. ;
  100. go
  101. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZb619af2ab805','0001ZZZZ7a8b7524a54b','tabs_head','addRow','button_secondary',null,'增行',29,'general_btn',0,'Y','N','Alt+N',null,'60201070_CARD',null,'60201070_CARDaddRow','2021-09-09 16:12:39')
  102. ;
  103. go
  104. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZf9b2a74b18a5','0001ZZZZ7a8b7524a54b','tabs_head','deleteRow','button_secondary',null,'删行',30,'general_btn',0,'Y','N','Alt+Del',null,'60201070_CARD',null,'60201070_CARDdeleteRow','2021-09-09 16:12:39')
  105. ;
  106. go
  107. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ2174f335732f','0001ZZZZ7a8b7524a54b','tabs_body','expand','button_secondary',null,'展开',34,'general_btn',0,'Y','N','F4',null,'60201070_CARD',null,'60201070_CARDexpand','2021-09-09 16:12:39')
  108. ;
  109. go
  110. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZfaa674f08132','0001ZZZZ7a8b7524a54b','tabs_body','insertRow','button_secondary',null,'插行',35,'general_btn',0,'Y','N','Alt+I',null,'60201070_CARD',null,'60201070_CARDinsertRow','2021-09-09 16:12:39')
  111. ;
  112. go
  113. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZf10f5c6bb3ec','0001ZZZZ7a8b7524a54b','tabs_body','delRow','button_secondary',null,'删行',36,'general_btn',0,'Y','N','Alt+Del',null,'60201070_CARD',null,'60201070_CARDdelRow','2021-09-09 16:12:39')
  114. ;
  115. go
  116. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ34183dbaad1d','0001ZZZZ7a8b7524a54b','tabs_body','pasteHere','button_secondary',null,'粘贴至此',37,'general_btn',0,'Y','N','Alt+V',null,'60201070_CARD',null,'60201070_CARDpasteHere','2021-09-09 16:12:39')
  117. ;
  118. go
  119. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ82551b6a3d9d','0001ZZZZ7a8b7524a54b','tabs_body','fold','button_secondary',null,'收起',38,'general_btn',0,'Y','N','F4',null,'60201070_CARD',null,'60201070_CARDfold','2021-09-09 16:12:39')
  120. ;
  121. go
  122. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ142fd9e8e212','0001ZZZZ7a8b7524a54b','tabs_body','unfold','button_secondary',null,'展开',38,'general_btn',0,'Y','N','F4',null,'60201070_CARD',null,'60201070_CARDunfold','2021-09-09 16:12:39')
  123. ;
  124. go
  125. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZeac101dff260','0001ZZZZ7a8b7524a54b','list_head','AddDelGroup','button_secondary','增删按钮组',null,0,'buttongroup',0,'Y','N',null,null,'60201070_LIST',null,null,'2021-09-09 16:12:39')
  126. ;
  127. go
  128. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZce1a06eedd0c','0001ZZZZ7a8b7524a54b','list_head','AddBtn','button_main',null,'新增',1,'general_btn',0,'Y','N','Ctrl+/',null,'60201070_LIST','AddDelGroup','60201070_LISTAddBtn','2021-09-09 16:12:39')
  129. ;
  130. go
  131. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ33a35ecebfe2','0001ZZZZ7a8b7524a54b','list_head','RefreshBtn','button_secondary',null,null,13,'general_btn',0,'Y','N',null,null,'60201070_LIST',null,null,'2021-09-09 16:12:39')
  132. ;
  133. go
  134. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ32f7b686d5bc','0001ZZZZ7a8b7524a54b','list_inner','edit','button_secondary',null,'修改',14,'general_btn',0,'Y','N','Alt+P',null,'60201070_LIST',null,'60201070_LISTedit','2021-09-09 16:12:39')
  135. ;
  136. go
  137. insert into sm_appbutnregister(pk_btn,appid,btnarea,btncode,btncolor,btndesc,btnname,btnorder,btntype,dr,isenable,iskeyfunc,keyboard,pageareacode,pagecode,parent_code,resid,ts) values('0001ZZZZ9b947e26ac48','0001ZZZZ7a8b7524a54b','list_inner','delete','button_secondary',null,'删除',16,'general_btn',0,'Y','N','Ctrl+Del',null,'60201070_LIST',null,'60201070_LISTDelBtn','2021-09-09 16:12:39')
  138. ;
  139. go