zentao/extension/max/sqlbuilder/ext/config/zentaomax.php

<?php
$config->sqlbuilder->sqlviewPrefix = 'qcv_';
$config->sqlbuilder->defaultAction = 'CREATE OR REPLACE VIEW qcv_ AS ';

$config->sqlbuilder->filterTableList['zt_action']                 = 'zt_action';
$config->sqlbuilder->filterTableList['zt_asset']                  = 'zt_asset';
$config->sqlbuilder->filterTableList['zt_attend']                 = 'zt_attend';
$config->sqlbuilder->filterTableList['zt_attendstat']             = 'zt_attendstat';
$config->sqlbuilder->filterTableList['zt_block']                  = 'zt_block';
$config->sqlbuilder->filterTableList['zt_branch']                 = 'zt_branch';
$config->sqlbuilder->filterTableList['zt_budget']                 = 'zt_budget';
$config->sqlbuilder->filterTableList['zt_burn']                   = 'zt_burn';
$config->sqlbuilder->filterTableList['zt_company']                = 'zt_company';
$config->sqlbuilder->filterTableList['zt_config']                 = 'zt_config';
$config->sqlbuilder->filterTableList['zt_cron']                   = 'zt_cron';
$config->sqlbuilder->filterTableList['zt_deploy']                 = 'zt_deploy';
$config->sqlbuilder->filterTableList['zt_deployproduct']          = 'zt_deployproduct';
$config->sqlbuilder->filterTableList['zt_deployscope']            = 'zt_deployscope';
$config->sqlbuilder->filterTableList['zt_deploystep']             = 'zt_deploystep';
$config->sqlbuilder->filterTableList['zt_doc']                    = 'zt_doc';
$config->sqlbuilder->filterTableList['zt_doccontent']             = 'zt_doccontent';
$config->sqlbuilder->filterTableList['zt_doclib']                 = 'zt_doclib';
$config->sqlbuilder->filterTableList['zt_entry']                  = 'zt_entry';
$config->sqlbuilder->filterTableList['zt_extension']              = 'zt_extension';
$config->sqlbuilder->filterTableList['zt_faq']                    = 'zt_faq';
$config->sqlbuilder->filterTableList['zt_feedback']               = 'zt_feedback';
$config->sqlbuilder->filterTableList['zt_feedbackview']           = 'zt_feedbackview';
$config->sqlbuilder->filterTableList['zt_file']                   = 'zt_file';
$config->sqlbuilder->filterTableList['zt_group']                  = 'zt_group';
$config->sqlbuilder->filterTableList['zt_grouppriv']              = 'zt_grouppriv';
$config->sqlbuilder->filterTableList['zt_history']                = 'zt_history';
$config->sqlbuilder->filterTableList['zt_holiday']                = 'zt_holiday';
$config->sqlbuilder->filterTableList['zt_host']                   = 'zt_host';
$config->sqlbuilder->filterTableList['zt_im_chat']                = 'zt_im_chat';
$config->sqlbuilder->filterTableList['zt_im_chatuser']            = 'zt_im_chatuser';
$config->sqlbuilder->filterTableList['zt_im_client']              = 'zt_im_client';
$config->sqlbuilder->filterTableList['zt_im_message']             = 'zt_im_message';
$config->sqlbuilder->filterTableList['zt_im_messagestatus']       = 'zt_im_messagestatus';
$config->sqlbuilder->filterTableList['zt_im_queue']               = 'zt_im_queue';
$config->sqlbuilder->filterTableList['zt_lang']                   = 'zt_lang';
$config->sqlbuilder->filterTableList['zt_leave']                  = 'zt_leave';
$config->sqlbuilder->filterTableList['zt_lieu']                   = 'zt_lieu';
$config->sqlbuilder->filterTableList['zt_log']                    = 'zt_log';
$config->sqlbuilder->filterTableList['zt_module']                 = 'zt_module';
$config->sqlbuilder->filterTableList['zt_notify']                 = 'zt_notify';
$config->sqlbuilder->filterTableList['zt_oauth']                  = 'zt_oauth';
$config->sqlbuilder->filterTableList['zt_overtime']               = 'zt_overtime';
$config->sqlbuilder->filterTableList['zt_relation']               = 'zt_relation';
$config->sqlbuilder->filterTableList['zt_relationoftasks']        = 'zt_relationoftasks';
$config->sqlbuilder->filterTableList['zt_repo']                   = 'zt_repo';
$config->sqlbuilder->filterTableList['zt_repobranch']             = 'zt_repobranch';
$config->sqlbuilder->filterTableList['zt_repofiles']              = 'zt_repofiles';
$config->sqlbuilder->filterTableList['zt_repohistory']            = 'zt_repohistory';
$config->sqlbuilder->filterTableList['zt_report']                 = 'zt_report';
$config->sqlbuilder->filterTableList['zt_score']                  = 'zt_score';
$config->sqlbuilder->filterTableList['zt_searchdict']             = 'zt_searchdict';
$config->sqlbuilder->filterTableList['zt_searchindex']            = 'zt_searchindex';
$config->sqlbuilder->filterTableList['zt_serverroom']             = 'zt_serverroom';
$config->sqlbuilder->filterTableList['zt_service']                = 'zt_service';
$config->sqlbuilder->filterTableList['zt_solutions']              = 'zt_solutions';
$config->sqlbuilder->filterTableList['zt_sqlview']                = 'zt_sqlview';
$config->sqlbuilder->filterTableList['zt_suitecase']              = 'zt_suitecase';
$config->sqlbuilder->filterTableList['zt_taskspec']               = 'zt_taskspec';
$config->sqlbuilder->filterTableList['zt_testreport']             = 'zt_testreport';
$config->sqlbuilder->filterTableList['zt_todo']                   = 'zt_todo';
$config->sqlbuilder->filterTableList['zt_trip']                   = 'zt_trip';
$config->sqlbuilder->filterTableList['zt_usercontact']            = 'zt_usercontact';
$config->sqlbuilder->filterTableList['zt_usergroup']              = 'zt_usergroup';
$config->sqlbuilder->filterTableList['zt_userquery']              = 'zt_userquery';
$config->sqlbuilder->filterTableList['zt_usertpl']                = 'zt_usertpl';
$config->sqlbuilder->filterTableList['zt_userview']               = 'zt_userview';
$config->sqlbuilder->filterTableList['zt_webhook']                = 'zt_webhook';
$config->sqlbuilder->filterTableList['zt_weeklyreport']           = 'zt_weeklyreport';
$config->sqlbuilder->filterTableList['zt_workestimation']         = 'zt_workestimation';
$config->sqlbuilder->filterTableList['zt_workflow']               = 'zt_workflow';
$config->sqlbuilder->filterTableList['zt_workflowaction']         = 'zt_workflowaction';
$config->sqlbuilder->filterTableList['zt_workflowdatasource']     = 'zt_workflowdatasource';
$config->sqlbuilder->filterTableList['zt_workflowfield']          = 'zt_workflowfield';
$config->sqlbuilder->filterTableList['zt_workflowlabel']          = 'zt_workflowlabel';
$config->sqlbuilder->filterTableList['zt_workflowlayout']         = 'zt_workflowlayout';
$config->sqlbuilder->filterTableList['zt_workflowlinkdata']       = 'zt_workflowlinkdata';
$config->sqlbuilder->filterTableList['zt_workflowrelation']       = 'zt_workflowrelation';
$config->sqlbuilder->filterTableList['zt_workflowrule']           = 'zt_workflowrule';
$config->sqlbuilder->filterTableList['zt_workflowsql']            = 'zt_workflowsql';
$config->sqlbuilder->filterTableList['zt_workflowversion']        = 'zt_workflowversion';
$config->sqlbuilder->filterTableList['ztv_dayactions']            = 'ztv_dayactions';
$config->sqlbuilder->filterTableList['ztv_daybugopen']            = 'ztv_daybugopen';
$config->sqlbuilder->filterTableList['ztv_daybugresolve']         = 'ztv_daybugresolve';
$config->sqlbuilder->filterTableList['ztv_dayeffort']             = 'ztv_dayeffort';
$config->sqlbuilder->filterTableList['ztv_daystoryclose']         = 'ztv_daystoryclose';
$config->sqlbuilder->filterTableList['ztv_daystoryopen']          = 'ztv_daystoryopen';
$config->sqlbuilder->filterTableList['ztv_daytaskfinish']         = 'ztv_daytaskfinish';
$config->sqlbuilder->filterTableList['ztv_daytaskopen']           = 'ztv_daytaskopen';
$config->sqlbuilder->filterTableList['ztv_dayuserlogin']          = 'ztv_dayuserlogin';
$config->sqlbuilder->filterTableList['ztv_productbugs']           = 'ztv_productbugs';
$config->sqlbuilder->filterTableList['ztv_productstories']        = 'ztv_productstories';
$config->sqlbuilder->filterTableList['ztv_projectbugs']           = 'ztv_projectbugs';
$config->sqlbuilder->filterTableList['ztv_projectstories']        = 'ztv_projectstories';
$config->sqlbuilder->filterTableList['ztv_projectsummary']        = 'ztv_projectsummary';
$config->sqlbuilder->filterTableList['ztv_projectteams']          = 'ztv_projectteams';
$config->sqlbuilder->filterTableList['zt_workflowrelationlayout'] = 'zt_workflowrelationlayout';