SELECT * FROM `zt_userview` wHeRe account = 'admin'
DELETE FROM `zt_grouppriv` wHeRe `group` = '17' AND module IN ('index','my','todo','product','branch','story','productplan','release','project','task','build','qa','bug','testcase','testtask','testreport','testsuite','caselib','doc','mail','custom','datatable','svn','git','company','dept','group','user','tree','report','search','admin','extension','editor','convert','api','file','misc','message','action','backup','cron','dev','chat')
REPLACE `zt_grouppriv` SET `group` = '17',`module` = 'index',`method` = 'index' |