sql
来源：互联网 发布：js正则表达式可以为空 编辑：程序博客网 时间：2024/06/07 06:52
USE leadingcloud;
-- app --
UPDATE `app` SET `appid` = '169980672981471232', `appcode` = 'ENPServiceCircle', `name` = '企业项目服务圈', `description` = 'MIS生产管理二部', `mobilelogo` = null , `weblogo` = null , `logo` = null , `createdate` = null , `updatedate` = '2017/5/12 12:34:33', `versionid` = null , `developerid` = '168531410842161152', `developername` = 'ljcs1', `supportindependent` = 1 , `apptype` = '1', `pattern` = '0', `supportweb` = 1 , `webtemplate` = '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', `webjs` = '/AppPlus/ENPServiceCircle/PC/JS/ENPServiceCircle.js', `weburl` = null , `supportios` = 0 , `supportandroid` = 0 , `protogenesis` = 0 , `controller` = null , `activity` = '{
}', `html5` = '/AppPlus/ENPServiceCircle/Mobile/View/ENPServiceCircle.html', `setting` = 1 , `settingurl` = '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', `settingmode` = '1', `settingwebtemplate` = null , `settingwebjs` = null , `appnature` = null , `isdynamic` = null , `appcolour` = 'color-3', `englishname` = null , `englishprofile` = null , `isopen` = 0 , `isdesktop` = 0 , `meungroupid` = null , `iconrid` = null , `version` = '20170512v5', `extendversionjs` = null , `isexternal` = null , `supportsctype` = 0 WHERE (`APPID` = '169980672981471232');
INSERT INTO `app` ( `appid` , `appcode` , `name` , `description` , `updatedate` , `developerid` , `developername` , `supportindependent` , `apptype` , `pattern` , `supportweb` , `webtemplate` , `webjs` , `supportios` , `supportandroid` , `protogenesis` , `activity` , `html5` , `setting` , `settingurl` , `settingmode` , `appcolour` , `isopen` , `isdesktop` , `version` , `supportsctype` ) SELECT '169980672981471232', 'ENPServiceCircle', '企业项目服务圈', 'MIS生产管理二部', '2017/5/12 12:34:33', '168531410842161152', 'ljcs1', 1 , '1', '0', 1 , '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', '/AppPlus/ENPServiceCircle/PC/JS/ENPServiceCircle.js', 0 , 0 , 0 , '{
}', '/AppPlus/ENPServiceCircle/Mobile/View/ENPServiceCircle.html', 1 , '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', '1', 'color-3', 0 , 0 , '20170512v5', 0 FROM dual WHERE not exists (select * from app where (`APPID` = '169980672981471232') );
-- app_servers --
UPDATE `app_servers` SET `serverid` = '169987019395436544', `appid` = '169980672981471232', `http_webapi_host` = 'localhost', `http_webapi_port` = '8428', `http_html_host` = 'localhost', `http_html_port` = '8028', `https_webapi_host` = 'localhost', `https_webapi_port` = '9428', `https_html_host` = 'localhost', `https_html_port` = '9028', `sso` = null WHERE (`SERVERID` = '169987019395436544');
INSERT INTO `app_servers` ( `serverid` , `appid` , `http_webapi_host` , `http_webapi_port` , `http_html_host` , `http_html_port` , `https_webapi_host` , `https_webapi_port` , `https_html_host` , `https_html_port` ) SELECT '169987019395436544', '169980672981471232', 'localhost', '8428', 'localhost', '8028', 'localhost', '9428', 'localhost', '9028' FROM dual WHERE not exists (select * from app_servers where (`SERVERID` = '169987019395436544') );
-- app_module --
UPDATE `app_module` SET `modid` = '178712215203745792', `name` = '项目团队', `appid` = '169980672981471232', `codeguid` = '1', `businessguid` = '1', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = '178705086778585088', `webtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `webjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `weburl` = null , `ios` = null , `android` = null , `html5` = 'www.baidu.com', `modtype` = '1', `isdesktop` = 1 , `modindex` = '2', `iconrid` = '178712216122298368' WHERE (`MODID` = '178712215203745792');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `modlogo` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` , `iconrid` ) SELECT '178712215203745792', '项目团队', '169980672981471232', '1', '1', 'color-1', 0 , '178705086778585088', '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 'www.baidu.com', '1', 1 , '2', '178712216122298368' FROM dual WHERE not exists (select * from app_module where (`MODID` = '178712215203745792') );
UPDATE `app_module` SET `modid` = '178712218416582656', `name` = '客户问题反馈', `appid` = '169980672981471232', `codeguid` = '2', `businessguid` = '47ac9256-4a2f-4920-96ee-30d6d1bed46d', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = null , `webtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `webjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `weburl` = null , `ios` = null , `android` = null , `html5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `modtype` = '1', `isdesktop` = 1 , `modindex` = '3', `iconrid` = null WHERE (`MODID` = '178712218416582656');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` ) SELECT '178712218416582656', '客户问题反馈', '169980672981471232', '2', '47ac9256-4a2f-4920-96ee-30d6d1bed46d', 'color-1', 0 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', '1', 1 , '3' FROM dual WHERE not exists (select * from app_module where (`MODID` = '178712218416582656') );
UPDATE `app_module` SET `modid` = '178712220052361216', `name` = '客户问题内协', `appid` = '169980672981471232', `codeguid` = '3', `businessguid` = 'eede958e-ef9a-461e-9382-ff8516b1fd94', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = null , `webtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `webjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `weburl` = null , `ios` = null , `android` = null , `html5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `modtype` = '1', `isdesktop` = 1 , `modindex` = '4', `iconrid` = null WHERE (`MODID` = '178712220052361216');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` ) SELECT '178712220052361216', '客户问题内协', '169980672981471232', '3', 'eede958e-ef9a-461e-9382-ff8516b1fd94', 'color-1', 0 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', '1', 1 , '4' FROM dual WHERE not exists (select * from app_module where (`MODID` = '178712220052361216') );
UPDATE `app_module` SET `modid` = '179770579996250112', `name` = '项目信息及资料', `appid` = '169980672981471232', `codeguid` = '4', `businessguid` = '4', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = null , `webtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `webjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `weburl` = null , `ios` = null , `android` = null , `html5` = 'www.baidu.com', `modtype` = '1', `isdesktop` = 1 , `modindex` = '1', `iconrid` = null WHERE (`MODID` = '179770579996250112');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` ) SELECT '179770579996250112', '项目信息及资料', '169980672981471232', '4', '4', 'color-1', 0 , '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 'www.baidu.com', '1', 1 , '1' FROM dual WHERE not exists (select * from app_module where (`MODID` = '179770579996250112') );
-- file --
UPDATE `file` SET `fileid` = '178705086778585088', `filename` = '178705086778585088', `filesize` = '1218', `fileext` = 'png', `lastuploaddate` = '2017/5/8 11:10:13', `lastuploaduser` = '168531410842161152', `lastfilestorage` = null , `servername` = 'lzcloud', `filepath` = '2017/05/08/', `originalfilename` = '1', `createdate` = '2017/5/8 11:10:13', `key` = '2017/05/08/178705086778585088.png', `description` = '{"width":48.0,"height":48.0}', `zipdescription` = null , `notoken` = '0', `lock` = null , `lockdate` = null , `fsid` = '20170223501', `filetype` = 'icon' WHERE (`FILEID` = '178705086778585088');
INSERT INTO `file` ( `fileid` , `filename` , `filesize` , `fileext` , `lastuploaddate` , `lastuploaduser` , `servername` , `filepath` , `originalfilename` , `createdate` , `key` , `description` , `notoken` , `fsid` , `filetype` ) SELECT '178705086778585088', '178705086778585088', '1218', 'png', '2017/5/8 11:10:13', '168531410842161152', 'lzcloud', '2017/05/08/', '1', '2017/5/8 11:10:13', '2017/05/08/178705086778585088.png', '{"width":48.0,"height":48.0}', '0', '20170223501', 'icon' FROM dual WHERE not exists (select * from file where (`FILEID` = '178705086778585088') );
-- res --
UPDATE `res` SET `rid` = '178712216122298368', `partitiontype` = '0', `name` = '1', `rpid` = '55597343814205472', `rdid` = '15', `classid` = '55597343818399776', `createusername` = 'ljcs1', `createuserface` = '168531411429371904', `createuser` = '168531410842161152', `createdate` = '2017/5/8 11:38:33', `updateusername` = 'ljcs1', `updateuserface` = '168531411429371904', `updateuser` = '168531410842161152', `updatedate` = '2017/5/8 11:38:33', `lockdate` = null , `lockuser` = null , `lockstatus` = null , `version` = '1', `versionid` = '178712216122298368', `rtype` = '1', `ismain` = '1', `iscurrentversion` = '1', `exptype` = 'png', `size` = '1218', `expid` = '178705086778585088', `description` = null , `subcount` = '0', `isdel` = '1', `sortindex` = '1', `expandinfo` = '{"width":48.0,"height":48.0}', `contextupdatedate` = null , `contextupdateuser` = null , `contextupdateusername` = null , `contextupdateuserface` = null , `isrecyle` = null , `zipinfo` = null , `bid` = null WHERE (`RID` = '178712216122298368');
INSERT INTO `res` ( `rid` , `partitiontype` , `name` , `rpid` , `rdid` , `classid` , `createusername` , `createuserface` , `createuser` , `createdate` , `updateusername` , `updateuserface` , `updateuser` , `updatedate` , `version` , `versionid` , `rtype` , `ismain` , `iscurrentversion` , `exptype` , `size` , `expid` , `subcount` , `isdel` , `sortindex` , `expandinfo` ) SELECT '178712216122298368', '0', '1', '55597343814205472', '15', '55597343818399776', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', '1', '178712216122298368', '1', '1', '1', 'png', '1218', '178705086778585088', '0', '1', '1', '{"width":48.0,"height":48.0}' FROM dual WHERE not exists (select * from res where (`RID` = '178712216122298368') );
-- post_type --
UPDATE `post_type` SET `posttypeid` = '178768928682414080', `posttypename` = '协作任务模型动态类型', `posttypecode` = 'CTM_Post', `mobilelogo` = null , `logo` = null , `describe` = '（企业项目服务圈外部协作）协作任务模型类型', `appid` = '169980672981471232', `antwebapi` = null , `trunjs` = null , `trunmethod` = null , `iostrun` = '{"templatetype": "1", "platinfo": {"controllername": "PageTabBarViewController", "parametername": "context","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', `androidtrun` = '{"templatetype": "1","platinfo": {"activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', `isopen` = 1 , `opencomfig` = '{"url": {"state": {"stateName": "{BusinessModuleId}","url": "/{BusinessModuleId}/:appcode/:scenecode/:source/:id","templateUrl":"/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html","resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js"]},"params": {"id":"{TaskId}","businessModuleId": "{BusinessModuleId}","appcode": "{AppCode}","scenecode": "{SceneCode}","source": "{Source}"}},"openmode": "state" }', `appcode` = 'enpservicecircle', `baselinkcode` = null WHERE (`POSTTYPEID` = '178768928682414080');
INSERT INTO `post_type` ( `posttypeid` , `posttypename` , `posttypecode` , `describe` , `appid` , `iostrun` , `androidtrun` , `isopen` , `opencomfig` , `appcode` ) SELECT '178768928682414080', '协作任务模型动态类型', 'CTM_Post', '（企业项目服务圈外部协作）协作任务模型类型', '169980672981471232', '{"templatetype": "1", "platinfo": {"controllername": "PageTabBarViewController", "parametername": "context","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', '{"templatetype": "1","platinfo": {"activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', 1 , '{"url": {"state": {"stateName": "{BusinessModuleId}","url": "/{BusinessModuleId}/:appcode/:scenecode/:source/:id","templateUrl":"/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html","resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js"]},"params": {"id":"{TaskId}","businessModuleId": "{BusinessModuleId}","appcode": "{AppCode}","scenecode": "{SceneCode}","source": "{Source}"}},"openmode": "state" }', 'enpservicecircle' FROM dual WHERE not exists (select * from post_type where (`POSTTYPEID` = '178768928682414080') );
-- co_app --
UPDATE `co_app` SET `appid` = '178712216906633216', `mainappid` = '169980672981471232', `name` = '项目团队', `code` = '1', `weblogo` = '178705086778585088', `mobilelogo` = '178705086778585088', `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `projectwebjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = 'www.baidu.com', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '178712215203745792', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = '178712216122298368', `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '178712216906633216');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `weblogo` , `mobilelogo` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` , `iconrid` ) SELECT '178712216906633216', '169980672981471232', '项目团队', '1', '178705086778585088', '178705086778585088', 0 , 1 , 0 , 1 , '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 1 , 1 , 1 , 'www.baidu.com', 0 , 0 , '', '178712215203745792', 'color-1', '178712216122298368' FROM dual WHERE not exists (select * from co_app where (`APPID` = '178712216906633216') );
UPDATE `co_app` SET `appid` = '178712218676629504', `mainappid` = '169980672981471232', `name` = '客户问题反馈', `code` = '47ac9256-4a2f-4920-96ee-30d6d1bed46d', `weblogo` = null , `mobilelogo` = null , `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `projectwebjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '178712218416582656', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = null , `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '178712218676629504');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` ) SELECT '178712218676629504', '169980672981471232', '客户问题反馈', '47ac9256-4a2f-4920-96ee-30d6d1bed46d', 0 , 1 , 0 , 1 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', 1 , 1 , 1 , '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', 0 , 0 , '', '178712218416582656', 'color-1' FROM dual WHERE not exists (select * from co_app where (`APPID` = '178712218676629504') );
UPDATE `co_app` SET `appid` = '178712220379516928', `mainappid` = '169980672981471232', `name` = '客户问题内协', `code` = 'eede958e-ef9a-461e-9382-ff8516b1fd94', `weblogo` = null , `mobilelogo` = null , `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `projectwebjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '178712220052361216', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = null , `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '178712220379516928');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` ) SELECT '178712220379516928', '169980672981471232', '客户问题内协', 'eede958e-ef9a-461e-9382-ff8516b1fd94', 0 , 1 , 0 , 1 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', 1 , 1 , 1 , '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', 0 , 0 , '', '178712220052361216', 'color-1' FROM dual WHERE not exists (select * from co_app where (`APPID` = '178712220379516928') );
UPDATE `co_app` SET `appid` = '179770580256296960', `mainappid` = '169980672981471232', `name` = '项目信息及资料', `code` = '4', `weblogo` = null , `mobilelogo` = null , `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `projectwebjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = 'www.baidu.com', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '179770579996250112', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = null , `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '179770580256296960');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` ) SELECT '179770580256296960', '169980672981471232', '项目信息及资料', '4', 0 , 1 , 0 , 1 , '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 1 , 1 , 1 , 'www.baidu.com', 0 , 0 , '', '179770579996250112', 'color-1' FROM dual WHERE not exists (select * from co_app where (`APPID` = '179770580256296960') );
-- co_app_project_type --
UPDATE `co_app_project_type` SET `aptid` = '179887003909623808', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `ptname` = null WHERE (`APTID` = '179887003909623808');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887003909623808', '179864400155250688', '178712216906633216' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887003909623808') );
UPDATE `co_app_project_type` SET `aptid` = '180173758479077376', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `ptname` = null WHERE (`APTID` = '180173758479077376');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173758479077376', '179864400155250688', '178712216906633216' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173758479077376') );
UPDATE `co_app_project_type` SET `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `ptname` = null WHERE (`APTID` = '180175596913823744');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175596913823744', '179864400155250688', '178712216906633216' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175596913823744') );
UPDATE `co_app_project_type` SET `aptid` = '179887006069690368', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `ptname` = null WHERE (`APTID` = '179887006069690368');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887006069690368', '179864400155250688', '178712218676629504' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887006069690368') );
UPDATE `co_app_project_type` SET `aptid` = '180173760643338240', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `ptname` = null WHERE (`APTID` = '180173760643338240');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173760643338240', '179864400155250688', '178712218676629504' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173760643338240') );
UPDATE `co_app_project_type` SET `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `ptname` = null WHERE (`APTID` = '180175599203913728');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175599203913728', '179864400155250688', '178712218676629504' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175599203913728') );
UPDATE `co_app_project_type` SET `aptid` = '179887008301060096', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `ptname` = null WHERE (`APTID` = '179887008301060096');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887008301060096', '179864400155250688', '178712220379516928' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887008301060096') );
UPDATE `co_app_project_type` SET `aptid` = '180173763197669376', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `ptname` = null WHERE (`APTID` = '180173763197669376');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173763197669376', '179864400155250688', '178712220379516928' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173763197669376') );
UPDATE `co_app_project_type` SET `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `ptname` = null WHERE (`APTID` = '180175601762439168');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175601762439168', '179864400155250688', '178712220379516928' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175601762439168') );
UPDATE `co_app_project_type` SET `aptid` = '179887010331103232', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `ptname` = null WHERE (`APTID` = '179887010331103232');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887010331103232', '179864400155250688', '179770580256296960' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887010331103232') );
UPDATE `co_app_project_type` SET `aptid` = '180173756117684224', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `ptname` = null WHERE (`APTID` = '180173756117684224');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173756117684224', '179864400155250688', '179770580256296960' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173756117684224') );
UPDATE `co_app_project_type` SET `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `ptname` = null WHERE (`APTID` = '180175594485321728');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175594485321728', '179864400155250688', '179770580256296960' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175594485321728') );
-- co_app_project_userole --
UPDATE `co_app_project_userole` SET `aprid` = '179865400698081280', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865400698081280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865400698081280', '180175596913823744', '179864400155250688', '178712216906633216', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865400698081280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865400832299008', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865400832299008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865400832299008', '180175596913823744', '179864400155250688', '178712216906633216', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865400832299008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865400962322432', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865400962322432');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865400962322432', '180175596913823744', '179864400155250688', '178712216906633216', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865400962322432') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401092345856', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865401092345856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401092345856', '180175596913823744', '179864400155250688', '178712216906633216', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401092345856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401222369280', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865401222369280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401222369280', '180175596913823744', '179864400155250688', '178712216906633216', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401222369280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401419501568', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865401419501568');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401419501568', '180175596913823744', '179864400155250688', '178712216906633216', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401419501568') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401553719296', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865401553719296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401553719296', '180175596913823744', '179864400155250688', '178712216906633216', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401553719296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865403780894720', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865403780894720');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865403780894720', '180175599203913728', '179864400155250688', '178712218676629504', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865403780894720') );
UPDATE `co_app_project_userole` SET `aprid` = '179865403910918144', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865403910918144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865403910918144', '180175599203913728', '179864400155250688', '178712218676629504', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865403910918144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404040941568', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865404040941568');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404040941568', '180175599203913728', '179864400155250688', '178712218676629504', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404040941568') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404175159296', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865404175159296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404175159296', '180175599203913728', '179864400155250688', '178712218676629504', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404175159296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404305182720', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865404305182720');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404305182720', '180175599203913728', '179864400155250688', '178712218676629504', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404305182720') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404435206144', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865404435206144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404435206144', '180175599203913728', '179864400155250688', '178712218676629504', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404435206144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404502315008', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865404502315008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404502315008', '180175599203913728', '179864400155250688', '178712218676629504', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404502315008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407056646144', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865407056646144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407056646144', '180175601762439168', '179864400155250688', '178712220379516928', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407056646144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407186669568', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865407186669568');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407186669568', '180175601762439168', '179864400155250688', '178712220379516928', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407186669568') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407320887296', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865407320887296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407320887296', '180175601762439168', '179864400155250688', '178712220379516928', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407320887296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407383801856', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865407383801856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407383801856', '180175601762439168', '179864400155250688', '178712220379516928', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407383801856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407580934144', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865407580934144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407580934144', '180175601762439168', '179864400155250688', '178712220379516928', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407580934144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407648043008', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865407648043008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407648043008', '180175601762439168', '179864400155250688', '178712220379516928', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407648043008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407845175296', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865407845175296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407845175296', '180175601762439168', '179864400155250688', '178712220379516928', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407845175296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411578105856', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865411578105856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411578105856', '180175594485321728', '179864400155250688', '179770580256296960', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411578105856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411708129280', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865411708129280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411708129280', '180175594485321728', '179864400155250688', '179770580256296960', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411708129280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411842347008', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865411842347008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411842347008', '180175594485321728', '179864400155250688', '179770580256296960', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411842347008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411972370432', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865411972370432');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411972370432', '180175594485321728', '179864400155250688', '179770580256296960', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411972370432') );
UPDATE `co_app_project_userole` SET `aprid` = '179865412102393856', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865412102393856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865412102393856', '180175594485321728', '179864400155250688', '179770580256296960', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865412102393856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865412232417280', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865412232417280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865412232417280', '180175594485321728', '179864400155250688', '179770580256296960', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865412232417280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865412366635008', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865412366635008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865412366635008', '180175594485321728', '179864400155250688', '179770580256296960', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865412366635008') );
-- file --
UPDATE `file` SET `fileid` = '178705086778585088', `filename` = '178705086778585088', `filesize` = '1218', `fileext` = 'png', `lastuploaddate` = '2017/5/8 11:10:13', `lastuploaduser` = '168531410842161152', `lastfilestorage` = null , `servername` = 'lzcloud', `filepath` = '2017/05/08/', `originalfilename` = '1', `createdate` = '2017/5/8 11:10:13', `key` = '2017/05/08/178705086778585088.png', `description` = '{"width":48.0,"height":48.0}', `zipdescription` = null , `notoken` = '0', `lock` = null , `lockdate` = null , `fsid` = '20170223501', `filetype` = 'icon' WHERE (`FILEID` = '178705086778585088');
INSERT INTO `file` ( `fileid` , `filename` , `filesize` , `fileext` , `lastuploaddate` , `lastuploaduser` , `servername` , `filepath` , `originalfilename` , `createdate` , `key` , `description` , `notoken` , `fsid` , `filetype` ) SELECT '178705086778585088', '178705086778585088', '1218', 'png', '2017/5/8 11:10:13', '168531410842161152', 'lzcloud', '2017/05/08/', '1', '2017/5/8 11:10:13', '2017/05/08/178705086778585088.png', '{"width":48.0,"height":48.0}', '0', '20170223501', 'icon' FROM dual WHERE not exists (select * from file where (`FILEID` = '178705086778585088') );
-- res --
UPDATE `res` SET `rid` = '178712216122298368', `partitiontype` = '0', `name` = '1', `rpid` = '55597343814205472', `rdid` = '15', `classid` = '55597343818399776', `createusername` = 'ljcs1', `createuserface` = '168531411429371904', `createuser` = '168531410842161152', `createdate` = '2017/5/8 11:38:33', `updateusername` = 'ljcs1', `updateuserface` = '168531411429371904', `updateuser` = '168531410842161152', `updatedate` = '2017/5/8 11:38:33', `lockdate` = null , `lockuser` = null , `lockstatus` = null , `version` = '1', `versionid` = '178712216122298368', `rtype` = '1', `ismain` = '1', `iscurrentversion` = '1', `exptype` = 'png', `size` = '1218', `expid` = '178705086778585088', `description` = null , `subcount` = '0', `isdel` = '1', `sortindex` = '1', `expandinfo` = '{"width":48.0,"height":48.0}', `contextupdatedate` = null , `contextupdateuser` = null , `contextupdateusername` = null , `contextupdateuserface` = null , `isrecyle` = null , `zipinfo` = null , `bid` = null WHERE (`RID` = '178712216122298368');
INSERT INTO `res` ( `rid` , `partitiontype` , `name` , `rpid` , `rdid` , `classid` , `createusername` , `createuserface` , `createuser` , `createdate` , `updateusername` , `updateuserface` , `updateuser` , `updatedate` , `version` , `versionid` , `rtype` , `ismain` , `iscurrentversion` , `exptype` , `size` , `expid` , `subcount` , `isdel` , `sortindex` , `expandinfo` ) SELECT '178712216122298368', '0', '1', '55597343814205472', '15', '55597343818399776', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', '1', '178712216122298368', '1', '1', '1', 'png', '1218', '178705086778585088', '0', '1', '1', '{"width":48.0,"height":48.0}' FROM dual WHERE not exists (select * from res where (`RID` = '178712216122298368') );
-- stan_project_type --
UPDATE `stan_project_type` SET `ptid` = '179864400155250688', `name` = '项目服务圈', `adddate` = null , `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `roleid` = '179864400415297536' WHERE (`PTID` = '179864400155250688');
INSERT INTO `stan_project_type` ( `ptid` , `name` , `appid` , `ispass` , `roleid` ) SELECT '179864400155250688', '项目服务圈', '169980672981471232', 1 , '179864400415297536' FROM dual WHERE not exists (select * from stan_project_type where (`PTID` = '179864400155250688') );
-- stan_project_role --
UPDATE `stan_project_role` SET `roleid` = '179864400415297536', `ptid` = '179864400155250688', `name` = '项目经理', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864400415297536');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864400415297536', '179864400155250688', '项目经理', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864400415297536') );
UPDATE `stan_project_role` SET `roleid` = '179864618720432128', `ptid` = '179864400155250688', `name` = '项目监管', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 1 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864618720432128');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864618720432128', '179864400155250688', '项目监管', '169980672981471232', 1 , 1 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864618720432128') );
UPDATE `stan_project_role` SET `roleid` = '179864669639282688', `ptid` = '179864400155250688', `name` = '实施工程师', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 1 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864669639282688');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864669639282688', '179864400155250688', '实施工程师', '169980672981471232', 1 , 1 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864669639282688') );
UPDATE `stan_project_role` SET `roleid` = '179864708633726976', `ptid` = '179864400155250688', `name` = '客服中心', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 1 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864708633726976');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864708633726976', '179864400155250688', '客服中心', '169980672981471232', 1 , 1 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864708633726976') );
UPDATE `stan_project_role` SET `roleid` = '179864831581360128', `ptid` = '179864400155250688', `name` = '客户方项目负责人', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864831581360128');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864831581360128', '179864400155250688', '客户方项目负责人', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864831581360128') );
UPDATE `stan_project_role` SET `roleid` = '179864952821911552', `ptid` = '179864400155250688', `name` = '客户方联系人', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864952821911552');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864952821911552', '179864400155250688', '客户方联系人', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864952821911552') );
UPDATE `stan_project_role` SET `roleid` = '179865036775100416', `ptid` = '179864400155250688', `name` = '客户方企业负责人', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179865036775100416');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179865036775100416', '179864400155250688', '客户方企业负责人', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179865036775100416') );
-- transaction_type --
UPDATE `transaction_type` SET `ttid` = '178770425730174976', `name` = '协作任务模型任务类型', `description` = '协作任务模型任务类型', `pc` = '{ "url": { "state": { "stateName": "{businessmoduleid}", "url": "/{businessmoduleid}/:appcode/:scenecode/:id", "templateUrl": "/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html", "resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js" ] }, "params": { "id": "{businessid}", "appcode": "{appcode}", "scenecode": "{scenecode}" } }, "openmode": "state", "stateopensize": "full" }', `ios` = '{ "templatetype": "1", "platinfo": { "controllername": "PageTabBarViewController", "parametername": "context", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', `android` = '{ "templatetype": "1", "platinfo": { "activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', `appid` = '169980672981471232', `code` = 'CTM_Transaction_Task', `appcode` = 'ENPServiceCircle', `toolid` = null , `posttypeid` = null , `isshowcommontool` = '1', `baselinkcode` = null WHERE (`TTID` = '178770425730174976');
INSERT INTO `transaction_type` ( `ttid` , `name` , `description` , `pc` , `ios` , `android` , `appid` , `code` , `appcode` , `isshowcommontool` ) SELECT '178770425730174976', '协作任务模型任务类型', '协作任务模型任务类型', '{ "url": { "state": { "stateName": "{businessmoduleid}", "url": "/{businessmoduleid}/:appcode/:scenecode/:id", "templateUrl": "/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html", "resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js" ] }, "params": { "id": "{businessid}", "appcode": "{appcode}", "scenecode": "{scenecode}" } }, "openmode": "state", "stateopensize": "full" }', '{ "templatetype": "1", "platinfo": { "controllername": "PageTabBarViewController", "parametername": "context", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', '{ "templatetype": "1", "platinfo": { "activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', '169980672981471232', 'CTM_Transaction_Task', 'ENPServiceCircle', '1' FROM dual WHERE not exists (select * from transaction_type where (`TTID` = '178770425730174976') );
-- app --
UPDATE `app` SET `appid` = '169980672981471232', `appcode` = 'ENPServiceCircle', `name` = '企业项目服务圈', `description` = 'MIS生产管理二部', `mobilelogo` = null , `weblogo` = null , `logo` = null , `createdate` = null , `updatedate` = '2017/5/12 12:34:33', `versionid` = null , `developerid` = '168531410842161152', `developername` = 'ljcs1', `supportindependent` = 1 , `apptype` = '1', `pattern` = '0', `supportweb` = 1 , `webtemplate` = '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', `webjs` = '/AppPlus/ENPServiceCircle/PC/JS/ENPServiceCircle.js', `weburl` = null , `supportios` = 0 , `supportandroid` = 0 , `protogenesis` = 0 , `controller` = null , `activity` = '{
}', `html5` = '/AppPlus/ENPServiceCircle/Mobile/View/ENPServiceCircle.html', `setting` = 1 , `settingurl` = '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', `settingmode` = '1', `settingwebtemplate` = null , `settingwebjs` = null , `appnature` = null , `isdynamic` = null , `appcolour` = 'color-3', `englishname` = null , `englishprofile` = null , `isopen` = 0 , `isdesktop` = 0 , `meungroupid` = null , `iconrid` = null , `version` = '20170512v5', `extendversionjs` = null , `isexternal` = null , `supportsctype` = 0 WHERE (`APPID` = '169980672981471232');
INSERT INTO `app` ( `appid` , `appcode` , `name` , `description` , `updatedate` , `developerid` , `developername` , `supportindependent` , `apptype` , `pattern` , `supportweb` , `webtemplate` , `webjs` , `supportios` , `supportandroid` , `protogenesis` , `activity` , `html5` , `setting` , `settingurl` , `settingmode` , `appcolour` , `isopen` , `isdesktop` , `version` , `supportsctype` ) SELECT '169980672981471232', 'ENPServiceCircle', '企业项目服务圈', 'MIS生产管理二部', '2017/5/12 12:34:33', '168531410842161152', 'ljcs1', 1 , '1', '0', 1 , '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', '/AppPlus/ENPServiceCircle/PC/JS/ENPServiceCircle.js', 0 , 0 , 0 , '{
}', '/AppPlus/ENPServiceCircle/Mobile/View/ENPServiceCircle.html', 1 , '/AppPlus/ENPServiceCircle/PC/View/ENPServiceCircle.html', '1', 'color-3', 0 , 0 , '20170512v5', 0 FROM dual WHERE not exists (select * from app where (`APPID` = '169980672981471232') );
-- app_servers --
UPDATE `app_servers` SET `serverid` = '169987019395436544', `appid` = '169980672981471232', `http_webapi_host` = 'localhost', `http_webapi_port` = '8428', `http_html_host` = 'localhost', `http_html_port` = '8028', `https_webapi_host` = 'localhost', `https_webapi_port` = '9428', `https_html_host` = 'localhost', `https_html_port` = '9028', `sso` = null WHERE (`SERVERID` = '169987019395436544');
INSERT INTO `app_servers` ( `serverid` , `appid` , `http_webapi_host` , `http_webapi_port` , `http_html_host` , `http_html_port` , `https_webapi_host` , `https_webapi_port` , `https_html_host` , `https_html_port` ) SELECT '169987019395436544', '169980672981471232', 'localhost', '8428', 'localhost', '8028', 'localhost', '9428', 'localhost', '9028' FROM dual WHERE not exists (select * from app_servers where (`SERVERID` = '169987019395436544') );
-- app_module --
UPDATE `app_module` SET `modid` = '178712215203745792', `name` = '项目团队', `appid` = '169980672981471232', `codeguid` = '1', `businessguid` = '1', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = '178705086778585088', `webtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `webjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `weburl` = null , `ios` = null , `android` = null , `html5` = 'www.baidu.com', `modtype` = '1', `isdesktop` = 1 , `modindex` = '2', `iconrid` = '178712216122298368' WHERE (`MODID` = '178712215203745792');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `modlogo` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` , `iconrid` ) SELECT '178712215203745792', '项目团队', '169980672981471232', '1', '1', 'color-1', 0 , '178705086778585088', '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 'www.baidu.com', '1', 1 , '2', '178712216122298368' FROM dual WHERE not exists (select * from app_module where (`MODID` = '178712215203745792') );
UPDATE `app_module` SET `modid` = '178712218416582656', `name` = '客户问题反馈', `appid` = '169980672981471232', `codeguid` = '2', `businessguid` = '47ac9256-4a2f-4920-96ee-30d6d1bed46d', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = null , `webtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `webjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `weburl` = null , `ios` = null , `android` = null , `html5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `modtype` = '1', `isdesktop` = 1 , `modindex` = '3', `iconrid` = null WHERE (`MODID` = '178712218416582656');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` ) SELECT '178712218416582656', '客户问题反馈', '169980672981471232', '2', '47ac9256-4a2f-4920-96ee-30d6d1bed46d', 'color-1', 0 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', '1', 1 , '3' FROM dual WHERE not exists (select * from app_module where (`MODID` = '178712218416582656') );
UPDATE `app_module` SET `modid` = '178712220052361216', `name` = '客户问题内协', `appid` = '169980672981471232', `codeguid` = '3', `businessguid` = 'eede958e-ef9a-461e-9382-ff8516b1fd94', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = null , `webtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `webjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `weburl` = null , `ios` = null , `android` = null , `html5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `modtype` = '1', `isdesktop` = 1 , `modindex` = '4', `iconrid` = null WHERE (`MODID` = '178712220052361216');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` ) SELECT '178712220052361216', '客户问题内协', '169980672981471232', '3', 'eede958e-ef9a-461e-9382-ff8516b1fd94', 'color-1', 0 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', '1', 1 , '4' FROM dual WHERE not exists (select * from app_module where (`MODID` = '178712220052361216') );
UPDATE `app_module` SET `modid` = '179770579996250112', `name` = '项目信息及资料', `appid` = '169980672981471232', `codeguid` = '4', `businessguid` = '4', `modcolour` = 'color-1', `isplanning` = 0 , `modlogo` = null , `webtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `webjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `weburl` = null , `ios` = null , `android` = null , `html5` = 'www.baidu.com', `modtype` = '1', `isdesktop` = 1 , `modindex` = '1', `iconrid` = null WHERE (`MODID` = '179770579996250112');
INSERT INTO `app_module` ( `modid` , `name` , `appid` , `codeguid` , `businessguid` , `modcolour` , `isplanning` , `webtemplate` , `webjs` , `html5` , `modtype` , `isdesktop` , `modindex` ) SELECT '179770579996250112', '项目信息及资料', '169980672981471232', '4', '4', 'color-1', 0 , '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 'www.baidu.com', '1', 1 , '1' FROM dual WHERE not exists (select * from app_module where (`MODID` = '179770579996250112') );
-- file --
UPDATE `file` SET `fileid` = '178705086778585088', `filename` = '178705086778585088', `filesize` = '1218', `fileext` = 'png', `lastuploaddate` = '2017/5/8 11:10:13', `lastuploaduser` = '168531410842161152', `lastfilestorage` = null , `servername` = 'lzcloud', `filepath` = '2017/05/08/', `originalfilename` = '1', `createdate` = '2017/5/8 11:10:13', `key` = '2017/05/08/178705086778585088.png', `description` = '{"width":48.0,"height":48.0}', `zipdescription` = null , `notoken` = '0', `lock` = null , `lockdate` = null , `fsid` = '20170223501', `filetype` = 'icon' WHERE (`FILEID` = '178705086778585088');
INSERT INTO `file` ( `fileid` , `filename` , `filesize` , `fileext` , `lastuploaddate` , `lastuploaduser` , `servername` , `filepath` , `originalfilename` , `createdate` , `key` , `description` , `notoken` , `fsid` , `filetype` ) SELECT '178705086778585088', '178705086778585088', '1218', 'png', '2017/5/8 11:10:13', '168531410842161152', 'lzcloud', '2017/05/08/', '1', '2017/5/8 11:10:13', '2017/05/08/178705086778585088.png', '{"width":48.0,"height":48.0}', '0', '20170223501', 'icon' FROM dual WHERE not exists (select * from file where (`FILEID` = '178705086778585088') );
-- res --
UPDATE `res` SET `rid` = '178712216122298368', `partitiontype` = '0', `name` = '1', `rpid` = '55597343814205472', `rdid` = '15', `classid` = '55597343818399776', `createusername` = 'ljcs1', `createuserface` = '168531411429371904', `createuser` = '168531410842161152', `createdate` = '2017/5/8 11:38:33', `updateusername` = 'ljcs1', `updateuserface` = '168531411429371904', `updateuser` = '168531410842161152', `updatedate` = '2017/5/8 11:38:33', `lockdate` = null , `lockuser` = null , `lockstatus` = null , `version` = '1', `versionid` = '178712216122298368', `rtype` = '1', `ismain` = '1', `iscurrentversion` = '1', `exptype` = 'png', `size` = '1218', `expid` = '178705086778585088', `description` = null , `subcount` = '0', `isdel` = '1', `sortindex` = '1', `expandinfo` = '{"width":48.0,"height":48.0}', `contextupdatedate` = null , `contextupdateuser` = null , `contextupdateusername` = null , `contextupdateuserface` = null , `isrecyle` = null , `zipinfo` = null , `bid` = null WHERE (`RID` = '178712216122298368');
INSERT INTO `res` ( `rid` , `partitiontype` , `name` , `rpid` , `rdid` , `classid` , `createusername` , `createuserface` , `createuser` , `createdate` , `updateusername` , `updateuserface` , `updateuser` , `updatedate` , `version` , `versionid` , `rtype` , `ismain` , `iscurrentversion` , `exptype` , `size` , `expid` , `subcount` , `isdel` , `sortindex` , `expandinfo` ) SELECT '178712216122298368', '0', '1', '55597343814205472', '15', '55597343818399776', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', '1', '178712216122298368', '1', '1', '1', 'png', '1218', '178705086778585088', '0', '1', '1', '{"width":48.0,"height":48.0}' FROM dual WHERE not exists (select * from res where (`RID` = '178712216122298368') );
-- post_type --
UPDATE `post_type` SET `posttypeid` = '178768928682414080', `posttypename` = '协作任务模型动态类型', `posttypecode` = 'CTM_Post', `mobilelogo` = null , `logo` = null , `describe` = '（企业项目服务圈外部协作）协作任务模型类型', `appid` = '169980672981471232', `antwebapi` = null , `trunjs` = null , `trunmethod` = null , `iostrun` = '{"templatetype": "1", "platinfo": {"controllername": "PageTabBarViewController", "parametername": "context","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', `androidtrun` = '{"templatetype": "1","platinfo": {"activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', `isopen` = 1 , `opencomfig` = '{"url": {"state": {"stateName": "{BusinessModuleId}","url": "/{BusinessModuleId}/:appcode/:scenecode/:source/:id","templateUrl":"/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html","resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js"]},"params": {"id":"{TaskId}","businessModuleId": "{BusinessModuleId}","appcode": "{AppCode}","scenecode": "{SceneCode}","source": "{Source}"}},"openmode": "state" }', `appcode` = 'enpservicecircle', `baselinkcode` = null WHERE (`POSTTYPEID` = '178768928682414080');
INSERT INTO `post_type` ( `posttypeid` , `posttypename` , `posttypecode` , `describe` , `appid` , `iostrun` , `androidtrun` , `isopen` , `opencomfig` , `appcode` ) SELECT '178768928682414080', '协作任务模型动态类型', 'CTM_Post', '（企业项目服务圈外部协作）协作任务模型类型', '169980672981471232', '{"templatetype": "1", "platinfo": {"controllername": "PageTabBarViewController", "parametername": "context","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', '{"templatetype": "1","platinfo": {"activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA","constdata": {"hiddenwebview": {"html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html","appcode": "CooperationTaskModel"}}}}', 1 , '{"url": {"state": {"stateName": "{BusinessModuleId}","url": "/{BusinessModuleId}/:appcode/:scenecode/:source/:id","templateUrl":"/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html","resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js"]},"params": {"id":"{TaskId}","businessModuleId": "{BusinessModuleId}","appcode": "{AppCode}","scenecode": "{SceneCode}","source": "{Source}"}},"openmode": "state" }', 'enpservicecircle' FROM dual WHERE not exists (select * from post_type where (`POSTTYPEID` = '178768928682414080') );
-- co_app --
UPDATE `co_app` SET `appid` = '178712216906633216', `mainappid` = '169980672981471232', `name` = '项目团队', `code` = '1', `weblogo` = '178705086778585088', `mobilelogo` = '178705086778585088', `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `projectwebjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = 'www.baidu.com', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '178712215203745792', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = '178712216122298368', `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '178712216906633216');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `weblogo` , `mobilelogo` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` , `iconrid` ) SELECT '178712216906633216', '169980672981471232', '项目团队', '1', '178705086778585088', '178705086778585088', 0 , 1 , 0 , 1 , '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 1 , 1 , 1 , 'www.baidu.com', 0 , 0 , '', '178712215203745792', 'color-1', '178712216122298368' FROM dual WHERE not exists (select * from co_app where (`APPID` = '178712216906633216') );
UPDATE `co_app` SET `appid` = '178712218676629504', `mainappid` = '169980672981471232', `name` = '客户问题反馈', `code` = '47ac9256-4a2f-4920-96ee-30d6d1bed46d', `weblogo` = null , `mobilelogo` = null , `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `projectwebjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '178712218416582656', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = null , `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '178712218676629504');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` ) SELECT '178712218676629504', '169980672981471232', '客户问题反馈', '47ac9256-4a2f-4920-96ee-30d6d1bed46d', 0 , 1 , 0 , 1 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', 1 , 1 , 1 , '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', 0 , 0 , '', '178712218416582656', 'color-1' FROM dual WHERE not exists (select * from co_app where (`APPID` = '178712218676629504') );
UPDATE `co_app` SET `appid` = '178712220379516928', `mainappid` = '169980672981471232', `name` = '客户问题内协', `code` = 'eede958e-ef9a-461e-9382-ff8516b1fd94', `weblogo` = null , `mobilelogo` = null , `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/BasePlus/CooperationTaskModel/PC/View/List.html', `projectwebjs` = '/BasePlus/CooperationTaskModel/PC/JS/List.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '178712220052361216', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = null , `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '178712220379516928');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` ) SELECT '178712220379516928', '169980672981471232', '客户问题内协', 'eede958e-ef9a-461e-9382-ff8516b1fd94', 0 , 1 , 0 , 1 , '/BasePlus/CooperationTaskModel/PC/View/List.html', '/BasePlus/CooperationTaskModel/PC/JS/List.js', 1 , 1 , 1 , '/BasePlus/CooperationTaskModel/Mobile/View/TaskList.html', 0 , 0 , '', '178712220052361216', 'color-1' FROM dual WHERE not exists (select * from co_app where (`APPID` = '178712220379516928') );
UPDATE `co_app` SET `appid` = '179770580256296960', `mainappid` = '169980672981471232', `name` = '项目信息及资料', `code` = '4', `weblogo` = null , `mobilelogo` = null , `supportgroup` = 0 , `supportproject` = 1 , `supporttask` = 0 , `format` = null , `supportweb` = 1 , `groupwebtemplate` = null , `groupwebjs` = null , `taskwebtemplate` = null , `taskwebjs` = null , `projectwebtemplate` = '/AppPlus/ENPServiceCircle/PC/View/cs.html', `projectwebjs` = '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', `groupweburl` = null , `taskweburl` = null , `projectweburl` = null , `supportios` = 1 , `supportandroid` = 1 , `protogenesis` = 1 , `groupcontroller` = null , `groupactivity` = null , `grouphtml5` = null , `projectcontroller` = null , `projectactivity` = null , `projecthtml5` = 'www.baidu.com', `taskcontroller` = null , `taskactivity` = null , `taskhtml5` = null , `isadvancedexport` = 0 , `istemplate` = 0 , `exportsettingurl` = null , `exportsettingtemplate` = null , `exportsettingtemplatejs` = null , `englishname` = '', `modid` = '179770579996250112', `modname` = null , `rdid` = null , `coappcolour` = 'color-1', `iconrid` = null , `taskistemp` = null , `groupistemp` = null , `projectistemp` = null WHERE (`APPID` = '179770580256296960');
INSERT INTO `co_app` ( `appid` , `mainappid` , `name` , `code` , `supportgroup` , `supportproject` , `supporttask` , `supportweb` , `projectwebtemplate` , `projectwebjs` , `supportios` , `supportandroid` , `protogenesis` , `projecthtml5` , `isadvancedexport` , `istemplate` , `englishname` , `modid` , `coappcolour` ) SELECT '179770580256296960', '169980672981471232', '项目信息及资料', '4', 0 , 1 , 0 , 1 , '/AppPlus/ENPServiceCircle/PC/View/cs.html', '/BasePlus/MISPTModule/PC/JS/AppConfig/ModuleRedirect.js', 1 , 1 , 1 , 'www.baidu.com', 0 , 0 , '', '179770579996250112', 'color-1' FROM dual WHERE not exists (select * from co_app where (`APPID` = '179770580256296960') );
-- co_app_project_type --
UPDATE `co_app_project_type` SET `aptid` = '179887003909623808', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `ptname` = null WHERE (`APTID` = '179887003909623808');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887003909623808', '179864400155250688', '178712216906633216' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887003909623808') );
UPDATE `co_app_project_type` SET `aptid` = '180173758479077376', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `ptname` = null WHERE (`APTID` = '180173758479077376');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173758479077376', '179864400155250688', '178712216906633216' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173758479077376') );
UPDATE `co_app_project_type` SET `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `ptname` = null WHERE (`APTID` = '180175596913823744');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175596913823744', '179864400155250688', '178712216906633216' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175596913823744') );
UPDATE `co_app_project_type` SET `aptid` = '179887006069690368', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `ptname` = null WHERE (`APTID` = '179887006069690368');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887006069690368', '179864400155250688', '178712218676629504' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887006069690368') );
UPDATE `co_app_project_type` SET `aptid` = '180173760643338240', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `ptname` = null WHERE (`APTID` = '180173760643338240');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173760643338240', '179864400155250688', '178712218676629504' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173760643338240') );
UPDATE `co_app_project_type` SET `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `ptname` = null WHERE (`APTID` = '180175599203913728');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175599203913728', '179864400155250688', '178712218676629504' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175599203913728') );
UPDATE `co_app_project_type` SET `aptid` = '179887008301060096', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `ptname` = null WHERE (`APTID` = '179887008301060096');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887008301060096', '179864400155250688', '178712220379516928' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887008301060096') );
UPDATE `co_app_project_type` SET `aptid` = '180173763197669376', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `ptname` = null WHERE (`APTID` = '180173763197669376');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173763197669376', '179864400155250688', '178712220379516928' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173763197669376') );
UPDATE `co_app_project_type` SET `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `ptname` = null WHERE (`APTID` = '180175601762439168');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175601762439168', '179864400155250688', '178712220379516928' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175601762439168') );
UPDATE `co_app_project_type` SET `aptid` = '179887010331103232', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `ptname` = null WHERE (`APTID` = '179887010331103232');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '179887010331103232', '179864400155250688', '179770580256296960' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '179887010331103232') );
UPDATE `co_app_project_type` SET `aptid` = '180173756117684224', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `ptname` = null WHERE (`APTID` = '180173756117684224');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180173756117684224', '179864400155250688', '179770580256296960' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180173756117684224') );
UPDATE `co_app_project_type` SET `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `ptname` = null WHERE (`APTID` = '180175594485321728');
INSERT INTO `co_app_project_type` ( `aptid` , `ptid` , `coappid` ) SELECT '180175594485321728', '179864400155250688', '179770580256296960' FROM dual WHERE not exists (select * from co_app_project_type where (`APTID` = '180175594485321728') );
-- co_app_project_userole --
UPDATE `co_app_project_userole` SET `aprid` = '179865400698081280', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865400698081280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865400698081280', '180175596913823744', '179864400155250688', '178712216906633216', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865400698081280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865400832299008', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865400832299008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865400832299008', '180175596913823744', '179864400155250688', '178712216906633216', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865400832299008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865400962322432', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865400962322432');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865400962322432', '180175596913823744', '179864400155250688', '178712216906633216', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865400962322432') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401092345856', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865401092345856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401092345856', '180175596913823744', '179864400155250688', '178712216906633216', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401092345856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401222369280', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865401222369280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401222369280', '180175596913823744', '179864400155250688', '178712216906633216', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401222369280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401419501568', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865401419501568');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401419501568', '180175596913823744', '179864400155250688', '178712216906633216', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401419501568') );
UPDATE `co_app_project_userole` SET `aprid` = '179865401553719296', `aptid` = '180175596913823744', `ptid` = '179864400155250688', `coappid` = '178712216906633216', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865401553719296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865401553719296', '180175596913823744', '179864400155250688', '178712216906633216', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865401553719296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865403780894720', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865403780894720');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865403780894720', '180175599203913728', '179864400155250688', '178712218676629504', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865403780894720') );
UPDATE `co_app_project_userole` SET `aprid` = '179865403910918144', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865403910918144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865403910918144', '180175599203913728', '179864400155250688', '178712218676629504', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865403910918144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404040941568', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865404040941568');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404040941568', '180175599203913728', '179864400155250688', '178712218676629504', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404040941568') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404175159296', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865404175159296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404175159296', '180175599203913728', '179864400155250688', '178712218676629504', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404175159296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404305182720', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865404305182720');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404305182720', '180175599203913728', '179864400155250688', '178712218676629504', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404305182720') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404435206144', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865404435206144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404435206144', '180175599203913728', '179864400155250688', '178712218676629504', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404435206144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865404502315008', `aptid` = '180175599203913728', `ptid` = '179864400155250688', `coappid` = '178712218676629504', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865404502315008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865404502315008', '180175599203913728', '179864400155250688', '178712218676629504', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865404502315008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407056646144', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865407056646144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407056646144', '180175601762439168', '179864400155250688', '178712220379516928', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407056646144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407186669568', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865407186669568');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407186669568', '180175601762439168', '179864400155250688', '178712220379516928', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407186669568') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407320887296', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865407320887296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407320887296', '180175601762439168', '179864400155250688', '178712220379516928', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407320887296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407383801856', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865407383801856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407383801856', '180175601762439168', '179864400155250688', '178712220379516928', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407383801856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407580934144', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865407580934144');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407580934144', '180175601762439168', '179864400155250688', '178712220379516928', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407580934144') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407648043008', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865407648043008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407648043008', '180175601762439168', '179864400155250688', '178712220379516928', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407648043008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865407845175296', `aptid` = '180175601762439168', `ptid` = '179864400155250688', `coappid` = '178712220379516928', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865407845175296');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865407845175296', '180175601762439168', '179864400155250688', '178712220379516928', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865407845175296') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411578105856', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864400415297536', `rolename` = '项目经理' WHERE (`APRID` = '179865411578105856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411578105856', '180175594485321728', '179864400155250688', '179770580256296960', '179864400415297536', '项目经理' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411578105856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411708129280', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864618720432128', `rolename` = '项目监管' WHERE (`APRID` = '179865411708129280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411708129280', '180175594485321728', '179864400155250688', '179770580256296960', '179864618720432128', '项目监管' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411708129280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411842347008', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864669639282688', `rolename` = '实施工程师' WHERE (`APRID` = '179865411842347008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411842347008', '180175594485321728', '179864400155250688', '179770580256296960', '179864669639282688', '实施工程师' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411842347008') );
UPDATE `co_app_project_userole` SET `aprid` = '179865411972370432', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864708633726976', `rolename` = '客服中心' WHERE (`APRID` = '179865411972370432');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865411972370432', '180175594485321728', '179864400155250688', '179770580256296960', '179864708633726976', '客服中心' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865411972370432') );
UPDATE `co_app_project_userole` SET `aprid` = '179865412102393856', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864831581360128', `rolename` = '客户方项目负责人' WHERE (`APRID` = '179865412102393856');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865412102393856', '180175594485321728', '179864400155250688', '179770580256296960', '179864831581360128', '客户方项目负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865412102393856') );
UPDATE `co_app_project_userole` SET `aprid` = '179865412232417280', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179864952821911552', `rolename` = '客户方联系人' WHERE (`APRID` = '179865412232417280');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865412232417280', '180175594485321728', '179864400155250688', '179770580256296960', '179864952821911552', '客户方联系人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865412232417280') );
UPDATE `co_app_project_userole` SET `aprid` = '179865412366635008', `aptid` = '180175594485321728', `ptid` = '179864400155250688', `coappid` = '179770580256296960', `roleid` = '179865036775100416', `rolename` = '客户方企业负责人' WHERE (`APRID` = '179865412366635008');
INSERT INTO `co_app_project_userole` ( `aprid` , `aptid` , `ptid` , `coappid` , `roleid` , `rolename` ) SELECT '179865412366635008', '180175594485321728', '179864400155250688', '179770580256296960', '179865036775100416', '客户方企业负责人' FROM dual WHERE not exists (select * from co_app_project_userole where (`APRID` = '179865412366635008') );
-- file --
UPDATE `file` SET `fileid` = '178705086778585088', `filename` = '178705086778585088', `filesize` = '1218', `fileext` = 'png', `lastuploaddate` = '2017/5/8 11:10:13', `lastuploaduser` = '168531410842161152', `lastfilestorage` = null , `servername` = 'lzcloud', `filepath` = '2017/05/08/', `originalfilename` = '1', `createdate` = '2017/5/8 11:10:13', `key` = '2017/05/08/178705086778585088.png', `description` = '{"width":48.0,"height":48.0}', `zipdescription` = null , `notoken` = '0', `lock` = null , `lockdate` = null , `fsid` = '20170223501', `filetype` = 'icon' WHERE (`FILEID` = '178705086778585088');
INSERT INTO `file` ( `fileid` , `filename` , `filesize` , `fileext` , `lastuploaddate` , `lastuploaduser` , `servername` , `filepath` , `originalfilename` , `createdate` , `key` , `description` , `notoken` , `fsid` , `filetype` ) SELECT '178705086778585088', '178705086778585088', '1218', 'png', '2017/5/8 11:10:13', '168531410842161152', 'lzcloud', '2017/05/08/', '1', '2017/5/8 11:10:13', '2017/05/08/178705086778585088.png', '{"width":48.0,"height":48.0}', '0', '20170223501', 'icon' FROM dual WHERE not exists (select * from file where (`FILEID` = '178705086778585088') );
-- res --
UPDATE `res` SET `rid` = '178712216122298368', `partitiontype` = '0', `name` = '1', `rpid` = '55597343814205472', `rdid` = '15', `classid` = '55597343818399776', `createusername` = 'ljcs1', `createuserface` = '168531411429371904', `createuser` = '168531410842161152', `createdate` = '2017/5/8 11:38:33', `updateusername` = 'ljcs1', `updateuserface` = '168531411429371904', `updateuser` = '168531410842161152', `updatedate` = '2017/5/8 11:38:33', `lockdate` = null , `lockuser` = null , `lockstatus` = null , `version` = '1', `versionid` = '178712216122298368', `rtype` = '1', `ismain` = '1', `iscurrentversion` = '1', `exptype` = 'png', `size` = '1218', `expid` = '178705086778585088', `description` = null , `subcount` = '0', `isdel` = '1', `sortindex` = '1', `expandinfo` = '{"width":48.0,"height":48.0}', `contextupdatedate` = null , `contextupdateuser` = null , `contextupdateusername` = null , `contextupdateuserface` = null , `isrecyle` = null , `zipinfo` = null , `bid` = null WHERE (`RID` = '178712216122298368');
INSERT INTO `res` ( `rid` , `partitiontype` , `name` , `rpid` , `rdid` , `classid` , `createusername` , `createuserface` , `createuser` , `createdate` , `updateusername` , `updateuserface` , `updateuser` , `updatedate` , `version` , `versionid` , `rtype` , `ismain` , `iscurrentversion` , `exptype` , `size` , `expid` , `subcount` , `isdel` , `sortindex` , `expandinfo` ) SELECT '178712216122298368', '0', '1', '55597343814205472', '15', '55597343818399776', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', 'ljcs1', '168531411429371904', '168531410842161152', '2017/5/8 11:38:33', '1', '178712216122298368', '1', '1', '1', 'png', '1218', '178705086778585088', '0', '1', '1', '{"width":48.0,"height":48.0}' FROM dual WHERE not exists (select * from res where (`RID` = '178712216122298368') );
-- stan_project_type --
UPDATE `stan_project_type` SET `ptid` = '179864400155250688', `name` = '项目服务圈', `adddate` = null , `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `roleid` = '179864400415297536' WHERE (`PTID` = '179864400155250688');
INSERT INTO `stan_project_type` ( `ptid` , `name` , `appid` , `ispass` , `roleid` ) SELECT '179864400155250688', '项目服务圈', '169980672981471232', 1 , '179864400415297536' FROM dual WHERE not exists (select * from stan_project_type where (`PTID` = '179864400155250688') );
-- stan_project_role --
UPDATE `stan_project_role` SET `roleid` = '179864400415297536', `ptid` = '179864400155250688', `name` = '项目经理', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864400415297536');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864400415297536', '179864400155250688', '项目经理', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864400415297536') );
UPDATE `stan_project_role` SET `roleid` = '179864618720432128', `ptid` = '179864400155250688', `name` = '项目监管', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 1 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864618720432128');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864618720432128', '179864400155250688', '项目监管', '169980672981471232', 1 , 1 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864618720432128') );
UPDATE `stan_project_role` SET `roleid` = '179864669639282688', `ptid` = '179864400155250688', `name` = '实施工程师', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 1 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864669639282688');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864669639282688', '179864400155250688', '实施工程师', '169980672981471232', 1 , 1 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864669639282688') );
UPDATE `stan_project_role` SET `roleid` = '179864708633726976', `ptid` = '179864400155250688', `name` = '客服中心', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 1 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864708633726976');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864708633726976', '179864400155250688', '客服中心', '169980672981471232', 1 , 1 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864708633726976') );
UPDATE `stan_project_role` SET `roleid` = '179864831581360128', `ptid` = '179864400155250688', `name` = '客户方项目负责人', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864831581360128');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864831581360128', '179864400155250688', '客户方项目负责人', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864831581360128') );
UPDATE `stan_project_role` SET `roleid` = '179864952821911552', `ptid` = '179864400155250688', `name` = '客户方联系人', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179864952821911552');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179864952821911552', '179864400155250688', '客户方联系人', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179864952821911552') );
UPDATE `stan_project_role` SET `roleid` = '179865036775100416', `ptid` = '179864400155250688', `name` = '客户方企业负责人', `developerid` = null , `developername` = null , `appid` = '169980672981471232', `ispass` = 1 , `ismodify` = 0 , `remark` = null , `isauthorization` = null WHERE (`ROLEID` = '179865036775100416');
INSERT INTO `stan_project_role` ( `roleid` , `ptid` , `name` , `appid` , `ispass` , `ismodify` ) SELECT '179865036775100416', '179864400155250688', '客户方企业负责人', '169980672981471232', 1 , 0 FROM dual WHERE not exists (select * from stan_project_role where (`ROLEID` = '179865036775100416') );
-- transaction_type --
UPDATE `transaction_type` SET `ttid` = '178770425730174976', `name` = '协作任务模型任务类型', `description` = '协作任务模型任务类型', `pc` = '{ "url": { "state": { "stateName": "{businessmoduleid}", "url": "/{businessmoduleid}/:appcode/:scenecode/:id", "templateUrl": "/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html", "resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js" ] }, "params": { "id": "{businessid}", "appcode": "{appcode}", "scenecode": "{scenecode}" } }, "openmode": "state", "stateopensize": "full" }', `ios` = '{ "templatetype": "1", "platinfo": { "controllername": "PageTabBarViewController", "parametername": "context", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', `android` = '{ "templatetype": "1", "platinfo": { "activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', `appid` = '169980672981471232', `code` = 'CTM_Transaction_Task', `appcode` = 'ENPServiceCircle', `toolid` = null , `posttypeid` = null , `isshowcommontool` = '1', `baselinkcode` = null WHERE (`TTID` = '178770425730174976');
INSERT INTO `transaction_type` ( `ttid` , `name` , `description` , `pc` , `ios` , `android` , `appid` , `code` , `appcode` , `isshowcommontool` ) SELECT '178770425730174976', '协作任务模型任务类型', '协作任务模型任务类型', '{ "url": { "state": { "stateName": "{businessmoduleid}", "url": "/{businessmoduleid}/:appcode/:scenecode/:id", "templateUrl": "/BasePlus/CooperationTaskModel/PC/View/MyTaskRedirect.html", "resolve": [ "/BasePlus/CooperationTaskModel/PC/JS/MyTaskRedirect.js" ] }, "params": { "id": "{businessid}", "appcode": "{appcode}", "scenecode": "{scenecode}" } }, "openmode": "state", "stateopensize": "full" }', '{ "templatetype": "1", "platinfo": { "controllername": "PageTabBarViewController", "parametername": "context", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', '{ "templatetype": "1", "platinfo": { "activityname": "com.leading.cloud.ViewActivity.CommonViewActivity.WebView.JSNC.JSNC_ActivityTab", "parametername": "TRANSDATA", "constdata": { "hiddenwebview": { "html5": "/BasePlus/CooperationTaskModel/Mobile/View/TaskDetailFrame.html", "appcode": "CooperationTaskModel" } } } }', '169980672981471232', 'CTM_Transaction_Task', 'ENPServiceCircle', '1' FROM dual WHERE not exists (select * from transaction_type where (`TTID` = '178770425730174976') );
0 0
- SQL
- SQL
- SQL
- sql
- sql
- SQL
- sql
- SQL (-)
- sql
- SQL
- SQL
- SQL
- sql
- sql
- sql
- sql
- SQL
- sql
- Huffman树的创建
- faster rcnn论文
- Docker命令介绍
- 如何查找Oracle Data Integrator和Oracle GoldenGate的支持列表
- MyBatis传入多个参数的问题
- sql
- ABAP中的系统变量SY-INDEX与SY-TABIX
- 5-70 情人节 (15分)
- [leetcode: Python]219. Contains Duplicate 2
- 链表学习（2）
- SpringMVC文件上传
- LeetCode ZigZag Conversion
- Nginx 配置 Web服务器
- AOP concepts
