Query Utils

From OpenKM Documentation
Revision as of 08:28, 7 September 2012 by Jllort (talk | contribs)

Jump to: navigation, search

Here are some queries that could be usefult for migration.

Save OKM_CONFIG table values

Creates update script with actual OKM_CONFIG table values to be restored in new OpenKM database; 

select  'UPDATE OKM_CONFIG SET CFG_VALUE=''' ||  CFG_VALUE || ''' WHERE CFG_KEY=''' || CFG_KEY || '''' from OKM_CONFIG;

Tested: OpenKM (6.x) Database (MySQL).

Retrieved from "https://www.openkm.com/wiki/index.php?title=Query_Utils&oldid=7089"