text: 
  --删除应用名 --OPCFBLOG 要删除的表应用名
  --显示的应用名
  delete from maxapps where app='OPCFBLOG';
  --xml
  delete from maxpresentation where app='OPCFBLOG';
  --签名
  delete from sigoption where app='OPCFBLOG';
  --权限组
  delete from applicationauth where app='OPCFBLOG';
  --页面label等设置
  delete from maxlabels where app='OPCFBLOG';
  --菜单配置
  --MENUTYPE='APPMENU' 选择操作
  --MENUTYPE='APPTOOL' 工具栏
  --MENUTYPE='SEARCHMENU' 查找菜单
  delete from maxmenu where moduleapp='OPCFBLOG' and menutype !='MODULE';
  delete from maxmenu where moduleapp='OPCFBLOG' and elementtype='APP' and keyvalue='OPCFBLOG';
  delete from maxmenu where keyvalue = 'OPCFBLOG';
  delete from appdoctype where app= 'OPCFBLOG';
  --启动中心
  delete from FACONFIG where app= 'OPCFBLOG';
  
  --显示statusdate时间为2011年以后的
  SELECT personid, status, displayname, department, title, statusdate
    FROM person
   where statusdate > =TO_DATE('2011-01-01', 'YYYY-MM-DD')
  --显示示statusdate时间为2011年6月的
  SELECT personid, status, displayname, department, title, statusdate
    FROM person
   where statusdate >= TO_DATE('2011-06-01', 'YYYY-MM-DD') AND statusdate < TO_DATE('2011-7-1', 'YYYY-MM-DD')
  
  
  
  --标签改为中文
  update MAXLABELS set value='高级搜索' where property='label' and value='More Search Fields' and upper(app) in (upper('AppName'),upper('AppName2'));
  update MAXLABELS set value='取消' where property='label' and value='Cancel' and upper(app) in (upper('AppName'),upper('AppName2'));
  update MAXLABELS set value='查找' where property='label' and value='Find' and upper(app) in (upper('AppName'),upper('AppName2'));
  update MAXLABELS set value='列表' where property='label' and value='List' and upper(app) in (upper('AppName'),upper('AppName2'));
  update MAXLABELS set value='列表' where property='label' and value='TABLE TITLE' and upper(app) in (upper('AppName'),upper('AppName2'));
  update MAXLABELS set value='详细信息' where property='label' and value='Main';
  update MAXLABELS set value='新建行' where property='label' and value='New Row';
  
  
  --标签改为中文
  update MAXLABELS set value='高级搜索' where property='label' and value='More Search Fields' ;
  update MAXLABELS set value='取消' where property='label' and value='Cancel';
  update MAXLABELS set value='查找' where property='label' and value='Find';
  update MAXLABELS set value='列表' where property='label' and value='List';
  update MAXLABELS set value='列表' where property='label' and value='TABLE TITLE' ;
  update MAXLABELS set value='详细信息' where property='label' and value='Main';
  update MAXLABELS set value='新建行' where property='label' and value='New Row';
  
  
  L_MAXAPPS			--ownerid=MAXAPPS.MAXAPPSID description=选择对应语言后显示的信息
  
  
  
  
  
  
  
  
  
  --数据库配置
  select   OBJECTNAME,ATTRIBUTENAME,alias,AUTOKEYNAME,ATTRIBUTENO,CANAUTONUM,CLASSNAME,COLUMNNAME,DEFAULTVALUE,DOMAINID,EAUDITENABLED,ENTITYNAME,ESIGENABLED,ISLDOWNER,ISPOSITIVE,length,MAXTYPE,MUSTBE,required,PERSISTENT,PRIMARYKEYCOLSEQ,REMARKS,SAMEASATTRIBUTE,SAMEASOBJECT,scale,TITLE,USERDEFINED,CHANGED,SEARCHTYPE,MLSUPPORTED,MLINUSE,HANDLECOLUMNNAME,MAXATTRIBUTEID,restricted,LOCALIZABLE,ROWSTAMP,TEXTDIRECTION,COMPLEXEXPRESSION from MAXATTRIBUTECFG
  
  
  --
  :%s/^.*$/insert into   MAXATTRIBUTECFG (OBJECTNAME,ATTRIBUTENAME,alias,AUTOKEYNAME,ATTRIBUTENO,CANAUTONUM,CLASSNAME,COLUMNNAME,DEFAULTVALUE,DOMAINID,EAUDITENABLED,ENTITYNAME,ESIGENABLED,ISLDOWNER,ISPOSITIVE,length,MAXTYPE,MUSTBE,required,PERSISTENT,PRIMARYKEYCOLSEQ,REMARKS,SAMEASATTRIBUTE,SAMEASOBJECT,scale,TITLE,USERDEFINED,CHANGED,SEARCHTYPE,MLSUPPORTED,MLINUSE,HANDLECOLUMNNAME,MAXATTRIBUTEID,restricted,LOCALIZABLE,ROWSTAMP,TEXTDIRECTION,COMPLEXEXPRESSION)values('&/g
  :%s/,'$/);/g
  
  
  