Hi, this is a problem with linux and case sensitivity and OpenKM. In linux / Unix the MySQL table names are case sensitive while in windows they are not. OpenKM requires upper case table names for linux. I have already informed the development team and they are currently preparing a new version that address this problem. In the mean time you can use the attached files to properly create the OpenKM tables for linux. Just move them in the scriptum install folder (replace the script file) update your root password and execute the script. 2011/10/4 Γραφείο Ανάπτυξης Ιστοσελίδας ΠΔΕ Θεσσαλίας < webmaster [ at ] thess [ dot ] pde [ dot ] sch [ dot ] gr> > ** > Καλημέρα σας, > > Έκανα εγκατάσταση σε Ubuntu 10.04.3 LTS κανονικά και όταν κάνω RUN τον > server στο log file εχω σφάλματα (errors) και δεν μπορώ να συνδεθώ με τους > αρχικούς κωδικούς ούτε στο eProtocol ούτε στο OpenKM (μου εμφανίζει > Authentication Error). > > Να σημειώσω ότι όταν δοκίμασα την εγκατάσταση σε Windows δούλεψε > κανονικά.... > > Δοκίμασα τα εξής: > Διέγραψα την βάση δεδομένων από την MySQL και έκανα τα sql script > κατευθείαν import στην βάση μήπως ΄παρουσιάζει πρόβλημα το install script.. > χωρίς αποτέλεσμα. > > Αν πρέπει να κάνω upgrade σε καινούργια έκδοση ή αν έχετε συγκεκριμένη > έκδοση Ubuntu να προτείνετε παρακαλώ να με ενημερώσετε. > > Να σημειώσω ότι η προσπάθεια εγκατάστασης και ορθής εκκίνησης χωρίς > σφάλματα έγινε αρκετές φορές και αρκετές φορές έγινε και επανεγκατάσταση του > Ubuntu Server 10.04.3 > > > Τα σφάλματα που έχω στο log file τα χώρισα σε δύο ομάδες: > *Α. Ομάδα (όσα αφορούν πίνακες που το σύστημα λέει ότι δεν υπάρχουν)* > Line 6123: 2011-10-04 10:34:30,463 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_ITEMS' > doesn't exist > Line 6280: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_USER_ITEMS' doesn't exist > Line 6303: 2011-10-04 10:34:30,794 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_MIME_TYPE' > doesn't exist > Line 6460: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_MIME_TYPE' doesn't exist > Line 6483: 2011-10-04 10:34:30,824 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 6504: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 6530: 2011-10-04 10:34:30,910 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' > doesn't exist > Line 6562: 2011-10-04 10:34:35,858 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 6583: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 6923: 2011-10-04 10:34:45,913 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 6944: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 15990: 2011-10-04 10:35:00,696 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 16010: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 16059: 2011-10-04 10:35:06,086 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 16082: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17232: 2011-10-04 10:35:46,115 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 17253: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17276: 2011-10-04 10:36:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17296: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17426: 2011-10-04 10:37:00,022 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17446: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17469: 2011-10-04 10:37:06,131 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 17490: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17615: 2011-10-04 10:38:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17635: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17760: 2011-10-04 10:39:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17780: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17905: 2011-10-04 10:39:46,145 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 17926: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17949: 2011-10-04 10:40:00,020 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17969: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 18094: 2011-10-04 10:41:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 18114: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 18424: 2011-10-04 10:41:59,242 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_DOCUMENT' > doesn't exist > Line 18522: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_USER_DOCUMENT' doesn't exist > Line 18556: 2011-10-04 10:41:59,803 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' > doesn't exist > > > *Οι πίνακες φυσικά υπάρχουν στην βάση...* > > > *Β. Ομάδα (Όλα όσα έχουν error)* > Line 592: 2011-10-04 10:33:41,343 DEBUG > [org.jboss.system.ServiceConfigurator] SuppressTransformationErrors set to > true in jboss.aop:service=AspectManager > Line 4819: at org.hsqldb.jdbc.Util.throwError(Unknown Source) > Line 4938: at org.hsqldb.jdbc.Util.throwError(Unknown Source) > Line 6122: 2011-10-04 10:34:30,462 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 6123: 2011-10-04 10:34:30,463 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_ITEMS' > doesn't exist > Line 6280: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_USER_ITEMS' doesn't exist > Line 6287: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6287: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6288: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 6289: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 6302: 2011-10-04 10:34:30,794 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 6303: 2011-10-04 10:34:30,794 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_MIME_TYPE' > doesn't exist > Line 6304: 2011-10-04 10:34:30,802 ERROR [com.openkm.core.Config] could > not execute query > Line 6460: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_MIME_TYPE' doesn't exist > Line 6467: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6467: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6468: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 6469: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 6482: 2011-10-04 10:34:30,811 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 6483: 2011-10-04 10:34:30,824 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 6484: 2011-10-04 10:34:30,824 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 6485: 2011-10-04 10:34:30,832 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 5000 milliseconds > Line 6504: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 6511: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6511: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6512: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 6513: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 6529: 2011-10-04 10:34:30,910 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 6530: 2011-10-04 10:34:30,910 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' > doesn't exist > Line 6531: 2011-10-04 10:34:30,914 ERROR [com.openkm.util.UserActivity] > could not insert: [com.openkm.dao.bean.Activity] > Line 6561: 2011-10-04 10:34:35,844 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 6562: 2011-10-04 10:34:35,858 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 6563: 2011-10-04 10:34:35,858 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 6564: 2011-10-04 10:34:35,860 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 10000 milliseconds > Line 6583: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 6590: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6590: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6591: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 6592: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 6922: 2011-10-04 10:34:45,884 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 6923: 2011-10-04 10:34:45,913 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 6924: 2011-10-04 10:34:45,913 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 6925: 2011-10-04 10:34:46,029 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 20000 milliseconds > Line 6944: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 6951: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6951: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 6952: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 6953: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 15989: 2011-10-04 10:35:00,681 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 15990: 2011-10-04 10:35:00,696 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 15991: 2011-10-04 10:35:00,696 ERROR [com.openkm.core.Cron] could not > execute query > Line 16010: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 16017: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 16017: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 16018: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 16019: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 16058: 2011-10-04 10:35:06,071 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 16059: 2011-10-04 10:35:06,086 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 16060: 2011-10-04 10:35:06,086 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 16063: 2011-10-04 10:35:06,092 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 40000 milliseconds > Line 16082: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 16089: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 16089: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 16090: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 16091: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 16500: 2011-10-04 10:35:31,686 INFO > [org.springframework.security.config.http.HttpSecurityBeanDefinitionParser] > Checking sorted filter chain: [<zkDesktopReuseFilter>, order = -2147483648, > Root bean: class > [org.springframework.security.web.context.SecurityContextPersistenceFilter]; > scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; > autowireCandidate=true; primary=false; factoryBeanName=null; > factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = > 300, Root bean: class > [org.springframework.security.web.authentication.logout.LogoutFilter]; > scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; > autowireCandidate=true; primary=false; factoryBeanName=null; > factoryMethodName=null; initMethodName=null; destroyMethodName=null, order = > 400, <zkError403Filter>, order = 401, <zkDisableSessionInvalidateFilter>, > order = 799, Root bean: class > [org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter]; > scope=; abstract=f... > Line 16502: 2011-10-04 10:35:31,800 DEBUG > [org.springframework.web.context.support.XmlWebApplicationContext] Bean > factory for Root WebApplicationContext: > org.springframework.beans.factory.support.DefaultListableBeanFactory@1abd6b0: > defining beans > [scriptumUserDetailsService,sriptumLogoutSuccessHandler,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuth... > Line 16510: 2011-10-04 10:35:32,185 INFO > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Pre-instantiating singletons in > org.springframework.beans.factory.support.DefaultListableBeanFactory@1abd6b0: > defining beans > [scriptumUserDetailsService,sriptumLogoutSuccessHandler,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuthenticatio... > Line 16758: 2011-10-04 10:35:32,748 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Creating shared instance of singleton bean 'zkError403Filter' > Line 16759: 2011-10-04 10:35:32,748 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Creating instance of bean 'zkError403Filter' > Line 16760: 2011-10-04 10:35:32,753 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Eagerly caching bean 'zkError403Filter' to allow for resolving potential > circular references > Line 16763: 2011-10-04 10:35:32,758 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Invoking afterPropertiesSet() on bean with name 'zkError403Filter' > Line 16764: 2011-10-04 10:35:32,758 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Finished creating instance of bean 'zkError403Filter' > Line 16831: 2011-10-04 10:35:32,854 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Returning cached instance of singleton bean 'zkError403Filter' > Line 16853: 2011-10-04 10:35:33,016 ERROR [STDERR] Oct 4, 2011 10:35:32 AM > org.zkoss.zk.ui.http.WebManager <init>:111 > Line 16855: 2011-10-04 10:35:33,058 ERROR [STDERR] Oct 4, 2011 10:35:33 AM > org.zkoss.zk.ui.sys.ConfigParser parseConfigXml:148 > Line 16857: 2011-10-04 10:35:33,269 ERROR [STDERR] Oct 4, 2011 10:35:33 AM > org.zkoss.zk.ui.sys.ConfigParser parse:259 > Line 17083: <element maxOccurs='1' minOccurs='0' name='error' > type='string'/> > Line 17231: 2011-10-04 10:35:46,110 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17232: 2011-10-04 10:35:46,115 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 17233: 2011-10-04 10:35:46,115 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 17234: 2011-10-04 10:35:46,121 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 80000 milliseconds > Line 17253: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17260: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17260: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17261: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17262: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17275: 2011-10-04 10:36:00,018 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17276: 2011-10-04 10:36:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17277: 2011-10-04 10:36:00,019 ERROR [com.openkm.core.Cron] could not > execute query > Line 17296: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17303: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17303: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17304: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17305: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17327: 2011-10-04 10:36:24,499 ERROR [STDERR] Oct 4, 2011 10:36:24 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance > Line 17374: 2011-10-04 10:36:25,573 ERROR > [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception > Line 17401: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17401: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17421: 2011-10-04 10:36:25,917 ERROR [STDERR] Oct 4, 2011 10:36:25 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17421: 2011-10-04 10:36:25,917 ERROR [STDERR] Oct 4, 2011 10:36:25 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17424: 2011-10-04 10:36:25,918 ERROR > [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] > java.lang.Exception: Response > [requestId=6fc71d80-716a-463d-bd67-cd8dcea71314, completed=Tue Oct 04 > 10:36:25 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] > Line 17425: 2011-10-04 10:37:00,020 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17426: 2011-10-04 10:37:00,022 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17427: 2011-10-04 10:37:00,023 ERROR [com.openkm.core.Cron] could not > execute query > Line 17446: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17453: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17453: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17454: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17455: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17468: 2011-10-04 10:37:06,131 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17469: 2011-10-04 10:37:06,131 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 17470: 2011-10-04 10:37:06,131 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 17471: 2011-10-04 10:37:06,135 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 160000 milliseconds > Line 17490: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17497: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17497: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17498: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17499: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17521: 2011-10-04 10:37:26,030 ERROR [STDERR] Oct 4, 2011 10:37:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance > Line 17563: 2011-10-04 10:37:26,062 ERROR > [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception > Line 17590: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17590: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17610: 2011-10-04 10:37:26,081 ERROR [STDERR] Oct 4, 2011 10:37:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17610: 2011-10-04 10:37:26,081 ERROR [STDERR] Oct 4, 2011 10:37:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17613: 2011-10-04 10:37:26,081 ERROR > [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] > java.lang.Exception: Response > [requestId=37dbe7c5-2f3e-4891-abff-355d8ba4fd7d, completed=Tue Oct 04 > 10:37:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] > Line 17614: 2011-10-04 10:38:00,019 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17615: 2011-10-04 10:38:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17616: 2011-10-04 10:38:00,019 ERROR [com.openkm.core.Cron] could not > execute query > Line 17635: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17642: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17642: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17643: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17644: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17666: 2011-10-04 10:38:26,121 ERROR [STDERR] Oct 4, 2011 10:38:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance > Line 17708: 2011-10-04 10:38:26,134 ERROR > [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception > Line 17735: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17735: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17755: 2011-10-04 10:38:26,145 ERROR [STDERR] Oct 4, 2011 10:38:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17755: 2011-10-04 10:38:26,145 ERROR [STDERR] Oct 4, 2011 10:38:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17758: 2011-10-04 10:38:26,145 ERROR > [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] > java.lang.Exception: Response > [requestId=6019eb35-d7e8-40f7-afac-64495208cd31, completed=Tue Oct 04 > 10:38:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] > Line 17759: 2011-10-04 10:39:00,018 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17760: 2011-10-04 10:39:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17761: 2011-10-04 10:39:00,019 ERROR [com.openkm.core.Cron] could not > execute query > Line 17780: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17787: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17787: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17788: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17789: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17811: 2011-10-04 10:39:26,195 ERROR [STDERR] Oct 4, 2011 10:39:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance > Line 17853: 2011-10-04 10:39:26,209 ERROR > [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception > Line 17880: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17880: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 17900: 2011-10-04 10:39:26,219 ERROR [STDERR] Oct 4, 2011 10:39:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17900: 2011-10-04 10:39:26,219 ERROR [STDERR] Oct 4, 2011 10:39:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 17903: 2011-10-04 10:39:26,220 ERROR > [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] > java.lang.Exception: Response > [requestId=d36e7457-60c6-4378-95cf-55d0079d5c50, completed=Tue Oct 04 > 10:39:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] > Line 17904: 2011-10-04 10:39:46,144 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17905: 2011-10-04 10:39:46,145 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.JBPM_JOB' doesn't > exist > Line 17906: 2011-10-04 10:39:46,145 ERROR [org.jbpm.db.JobSession] > org.hibernate.exception.SQLGrammarException: could not execute query > Line 17907: 2011-10-04 10:39:46,148 ERROR > [org.jbpm.job.executor.JobExecutorThread] exception in job executor thread. > waiting 320000 milliseconds > Line 17926: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.JBPM_JOB' doesn't exist > Line 17933: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17933: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17934: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17935: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 17948: 2011-10-04 10:40:00,019 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 17949: 2011-10-04 10:40:00,020 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 17950: 2011-10-04 10:40:00,021 ERROR [com.openkm.core.Cron] could not > execute query > Line 17969: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 17976: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17976: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 17977: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 17978: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 18000: 2011-10-04 10:40:26,257 ERROR [STDERR] Oct 4, 2011 10:40:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance > Line 18042: 2011-10-04 10:40:26,270 ERROR > [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception > Line 18069: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 18069: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 18089: 2011-10-04 10:40:26,281 ERROR [STDERR] Oct 4, 2011 10:40:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 18089: 2011-10-04 10:40:26,281 ERROR [STDERR] Oct 4, 2011 10:40:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 18092: 2011-10-04 10:40:26,281 ERROR > [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] > java.lang.Exception: Response > [requestId=70249393-75c4-4e84-8d67-d1e381cf746d, completed=Tue Oct 04 > 10:40:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] > Line 18093: 2011-10-04 10:41:00,018 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 18094: 2011-10-04 10:41:00,019 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_CRON_TAB' > doesn't exist > Line 18095: 2011-10-04 10:41:00,019 ERROR [com.openkm.core.Cron] could not > execute query > Line 18114: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_CRON_TAB' doesn't exist > Line 18120: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 18120: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 18121: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 18122: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 18144: 2011-10-04 10:41:26,373 ERROR [STDERR] Oct 4, 2011 10:41:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl getInstance > Line 18186: 2011-10-04 10:41:26,415 ERROR > [org.jboss.ws.core.jaxws.SOAPFaultHelperJAXWS] SOAP request exception > Line 18213: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 18213: at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > Line 18233: 2011-10-04 10:41:26,437 ERROR [STDERR] Oct 4, 2011 10:41:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 18233: 2011-10-04 10:41:26,437 ERROR [STDERR] Oct 4, 2011 10:41:26 AM > gr.scriptum.eprotocol.ws.OkmProtocolDispatcherImpl createErrorResponse > Line 18236: 2011-10-04 10:41:26,438 ERROR > [gr.scriptum.eprotocol.mailclients.FetchIncomingMailsWork] > java.lang.Exception: Response > [requestId=0b085f71-9b97-4aa4-b638-ed6dd2ad97af, completed=Tue Oct 04 > 10:41:26 EEST 2011, eCode=0001, eMessage=java.lang.NullPointerException] > Line 18282: 2011-10-04 10:41:57,288 INFO > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Destroying singletons in > org.springframework.beans.factory.support.DefaultListableBeanFactory@1abd6b0: > defining beans > [scriptumUserDetailsService,sriptumLogoutSuccessHandler,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuthenticationEntryP... > Line 18301: 2011-10-04 10:41:57,299 DEBUG > [org.springframework.beans.factory.support.DisposableBeanAdapter] Invoking > destroy() on bean with name 'zkError403Filter' > Line 18302: 2011-10-04 10:41:57,299 DEBUG > [org.springframework.beans.factory.support.DefaultListableBeanFactory] > Retrieved dependent beans for bean '(inner bean)#61': [zkError403Filter] > Line 18423: 2011-10-04 10:41:59,242 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 18424: 2011-10-04 10:41:59,242 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_USER_DOCUMENT' > doesn't exist > Line 18522: Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table > 'okm_app.OKM_USER_DOCUMENT' doesn't exist > Line 18528: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 18528: at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) > Line 18529: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562) > Line 18530: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494) > Line 18555: 2011-10-04 10:41:59,803 WARN > [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02 > Line 18556: 2011-10-04 10:41:59,803 ERROR > [org.hibernate.util.JDBCExceptionReporter] Table 'okm_app.OKM_ACTIVITY' > doesn't exist > Line 18557: 2011-10-04 10:41:59,815 ERROR [com.openkm.util.UserActivity] > could not insert: [com.openkm.dao.bean.Activity] > > > > Με εκτίμηση > Χρήστος Πρασσάς > > Γραφείο Ανάπτυξης Ιστοσελίδας Περιφερειακής Δ/σης Πρωτοβάθμιας & > Δευτεροβάθμιας Εκπ/σης Θεσσαλίας > Υπεύθυνος: Πρασσάς Χρήστος > Τηλ. επικοινωνίας: 2410539222 ή 2410539226 > http://thess.pde.sch.gr > > _______________________________________________ > scriptum-users mailing list > scriptum-users [ at ] ellak [ dot ] gr > http://lists.ellak.gr/listinfo/scriptum-users > > -- Ιωσήφ Καραγιαννόπουλος Τεχνική υποστήριξη. Email: ict2 [ at ] antiproedros [ dot ] gov [ dot ] gr Phone: +30 213 150 2122 / 2100
/*
SQLyog Community- MySQL GUI v8.22
MySQL - 5.1.48-community : Database - okm_repo
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`okm_repo` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
USE `okm_repo`;
/*Table structure for table `VERSION_BINVAL` */
DROP TABLE IF EXISTS `VERSION_BINVAL`;
CREATE TABLE `VERSION_BINVAL` (
`BINVAL_ID` varchar(64) COLLATE utf8_bin NOT NULL,
`BINVAL_DATA` longblob NOT NULL,
UNIQUE KEY `VERSION_BINVAL_IDX` (`BINVAL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*Data for the table `VERSION_BINVAL` */
/*Table structure for table `VERSION_BUNDLE` */
DROP TABLE IF EXISTS `VERSION_BUNDLE`;
CREATE TABLE `VERSION_BUNDLE` (
`NODE_ID` varbinary(16) NOT NULL,
`BUNDLE_DATA` longblob NOT NULL,
UNIQUE KEY `VERSION_BUNDLE_IDX` (`NODE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*Data for the table `VERSION_BUNDLE` */
insert into `VERSION_BUNDLE`(`NODE_ID`,`BUNDLE_DATA`) values ('U/顁b億湉','\0\0\0\0\0猺橘瑣杇瑣杇瑣\0\0\0橤廄r0<Nw蒲�%暊P0\0\0\020\0\0\0\0'),('W�;\"�M����:','\0\0\0\0\0橤廄r0<Nw蒲�%暊P0\0\0\0\0\0'),('猺橘瑣杇瑣杇瑣','\0\0\0\0\0猺橘杇瑣杇瑣杇瑣\0\0\0U/顁b億湉\0\0\0\0ba\0\0\0'),('橤廄r0<Nw蒲�%暊P�','\0\0\0\0\0U/顁b億湉\0\0\0W�;\"�M����:\0\0\0\05e\0\0\0\0');
/*Table structure for table `VERSION_NAMES` */
DROP TABLE IF EXISTS `VERSION_NAMES`;
CREATE TABLE `VERSION_NAMES` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(255) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*Data for the table `VERSION_NAMES` */
insert into `VERSION_NAMES`(`ID`,`NAME`) values (1,'versionStorage'),(2,'versionLabels'),(3,'version'),(4,'predecessors'),(5,'created'),(6,'successors'),(7,'frozenNode'),(8,'frozenUuid'),(9,'frozenPrimaryType'),(10,'versionHistory'),(11,'versionableUuid'),(12,'versionComment'),(13,'data'),(14,'author'),(15,'mimeType'),(16,'size');
/*Table structure for table `VERSION_REFS` */
DROP TABLE IF EXISTS `VERSION_REFS`;
CREATE TABLE `VERSION_REFS` (
`NODE_ID` varbinary(16) NOT NULL,
`REFS_DATA` longblob NOT NULL,
UNIQUE KEY `VERSION_REFS_IDX` (`NODE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*Data for the table `VERSION_REFS` */
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- MySQL dump 10.11
--
-- Host: localhost Database: okm_app
-- ------------------------------------------------------
-- Server version 5.0.77
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `JBPM_ACTION`
--
DROP TABLE IF EXISTS `JBPM_ACTION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_ACTION` (
`ID_` bigint(20) NOT NULL auto_increment,
`class` char(1) collate utf8_bin NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`ISPROPAGATIONALLOWED_` bit(1) default NULL,
`ACTIONEXPRESSION_` varchar(255) collate utf8_bin default NULL,
`ISASYNC_` bit(1) default NULL,
`REFERENCEDACTION_` bigint(20) default NULL,
`ACTIONDELEGATION_` bigint(20) default NULL,
`EVENT_` bigint(20) default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`EXPRESSION_` varchar(4000) collate utf8_bin default NULL,
`TIMERNAME_` varchar(255) collate utf8_bin default NULL,
`DUEDATE_` varchar(255) collate utf8_bin default NULL,
`REPEAT_` varchar(255) collate utf8_bin default NULL,
`TRANSITIONNAME_` varchar(255) collate utf8_bin default NULL,
`TIMERACTION_` bigint(20) default NULL,
`EVENTINDEX_` int(11) default NULL,
`EXCEPTIONHANDLER_` bigint(20) default NULL,
`EXCEPTIONHANDLERINDEX_` int(11) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_ACTION_ACTNDL` (`ACTIONDELEGATION_`),
KEY `IDX_ACTION_PROCDF` (`PROCESSDEFINITION_`),
KEY `IDX_ACTION_EVENT` (`EVENT_`),
KEY `FK_ACTION_REFACT` (`REFERENCEDACTION_`),
KEY `FK_CRTETIMERACT_TA` (`TIMERACTION_`),
KEY `FK_ACTION_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_ACTION_EVENT` (`EVENT_`),
KEY `FK_ACTION_ACTNDEL` (`ACTIONDELEGATION_`),
KEY `FK_ACTION_EXPTHDL` (`EXCEPTIONHANDLER_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_ACTION`
--
LOCK TABLES `JBPM_ACTION` WRITE;
/*!40000 ALTER TABLE `JBPM_ACTION` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_ACTION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_BYTEARRAY`
--
DROP TABLE IF EXISTS `JBPM_BYTEARRAY`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_BYTEARRAY` (
`ID_` bigint(20) NOT NULL auto_increment,
`NAME_` varchar(255) collate utf8_bin default NULL,
`FILEDEFINITION_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `FK_BYTEARR_FILDEF` (`FILEDEFINITION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_BYTEARRAY`
--
LOCK TABLES `JBPM_BYTEARRAY` WRITE;
/*!40000 ALTER TABLE `JBPM_BYTEARRAY` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_BYTEARRAY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_BYTEBLOCK`
--
DROP TABLE IF EXISTS `JBPM_BYTEBLOCK`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_BYTEBLOCK` (
`PROCESSFILE_` bigint(20) NOT NULL,
`BYTES_` blob,
`INDEX_` int(11) NOT NULL,
PRIMARY KEY (`PROCESSFILE_`,`INDEX_`),
KEY `FK_BYTEBLOCK_FILE` (`PROCESSFILE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_BYTEBLOCK`
--
LOCK TABLES `JBPM_BYTEBLOCK` WRITE;
/*!40000 ALTER TABLE `JBPM_BYTEBLOCK` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_BYTEBLOCK` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_COMMENT`
--
DROP TABLE IF EXISTS `JBPM_COMMENT`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_COMMENT` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`ACTORID_` varchar(255) collate utf8_bin default NULL,
`TIME_` datetime default NULL,
`MESSAGE_` varchar(4000) collate utf8_bin default NULL,
`TOKEN_` bigint(20) default NULL,
`TASKINSTANCE_` bigint(20) default NULL,
`TOKENINDEX_` int(11) default NULL,
`TASKINSTANCEINDEX_` int(11) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_COMMENT_TSK` (`TASKINSTANCE_`),
KEY `IDX_COMMENT_TOKEN` (`TOKEN_`),
KEY `FK_COMMENT_TOKEN` (`TOKEN_`),
KEY `FK_COMMENT_TSK` (`TASKINSTANCE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_COMMENT`
--
LOCK TABLES `JBPM_COMMENT` WRITE;
/*!40000 ALTER TABLE `JBPM_COMMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_COMMENT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_DECISIONCONDITIONS`
--
DROP TABLE IF EXISTS `JBPM_DECISIONCONDITIONS`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_DECISIONCONDITIONS` (
`DECISION_` bigint(20) NOT NULL,
`TRANSITIONNAME_` varchar(255) collate utf8_bin default NULL,
`EXPRESSION_` varchar(255) collate utf8_bin default NULL,
`INDEX_` int(11) NOT NULL,
PRIMARY KEY (`DECISION_`,`INDEX_`),
KEY `FK_DECCOND_DEC` (`DECISION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_DECISIONCONDITIONS`
--
LOCK TABLES `JBPM_DECISIONCONDITIONS` WRITE;
/*!40000 ALTER TABLE `JBPM_DECISIONCONDITIONS` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_DECISIONCONDITIONS` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_DELEGATION`
--
DROP TABLE IF EXISTS `JBPM_DELEGATION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_DELEGATION` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASSNAME_` varchar(4000) collate utf8_bin default NULL,
`CONFIGURATION_` varchar(4000) collate utf8_bin default NULL,
`CONFIGTYPE_` varchar(255) collate utf8_bin default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_DELEG_PRCD` (`PROCESSDEFINITION_`),
KEY `FK_DELEGATION_PRCD` (`PROCESSDEFINITION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_DELEGATION`
--
LOCK TABLES `JBPM_DELEGATION` WRITE;
/*!40000 ALTER TABLE `JBPM_DELEGATION` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_DELEGATION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_EVENT`
--
DROP TABLE IF EXISTS `JBPM_EVENT`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_EVENT` (
`ID_` bigint(20) NOT NULL auto_increment,
`EVENTTYPE_` varchar(255) collate utf8_bin default NULL,
`TYPE_` char(1) collate utf8_bin default NULL,
`GRAPHELEMENT_` bigint(20) default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`NODE_` bigint(20) default NULL,
`TRANSITION_` bigint(20) default NULL,
`TASK_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `FK_EVENT_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_EVENT_TRANS` (`TRANSITION_`),
KEY `FK_EVENT_NODE` (`NODE_`),
KEY `FK_EVENT_TASK` (`TASK_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_EVENT`
--
LOCK TABLES `JBPM_EVENT` WRITE;
/*!40000 ALTER TABLE `JBPM_EVENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_EVENT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_EXCEPTIONHANDLER`
--
DROP TABLE IF EXISTS `JBPM_EXCEPTIONHANDLER`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_EXCEPTIONHANDLER` (
`ID_` bigint(20) NOT NULL auto_increment,
`EXCEPTIONCLASSNAME_` varchar(4000) collate utf8_bin default NULL,
`TYPE_` char(1) collate utf8_bin default NULL,
`GRAPHELEMENT_` bigint(20) default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`GRAPHELEMENTINDEX_` int(11) default NULL,
`NODE_` bigint(20) default NULL,
`TRANSITION_` bigint(20) default NULL,
`TASK_` bigint(20) default NULL,
PRIMARY KEY (`ID_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_EXCEPTIONHANDLER`
--
LOCK TABLES `JBPM_EXCEPTIONHANDLER` WRITE;
/*!40000 ALTER TABLE `JBPM_EXCEPTIONHANDLER` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_EXCEPTIONHANDLER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_JOB`
--
DROP TABLE IF EXISTS `JBPM_JOB`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_JOB` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`VERSION_` int(11) NOT NULL,
`DUEDATE_` datetime default NULL,
`PROCESSINSTANCE_` bigint(20) default NULL,
`TOKEN_` bigint(20) default NULL,
`TASKINSTANCE_` bigint(20) default NULL,
`ISSUSPENDED_` bit(1) default NULL,
`ISEXCLUSIVE_` bit(1) default NULL,
`LOCKOWNER_` varchar(255) collate utf8_bin default NULL,
`LOCKTIME_` datetime default NULL,
`EXCEPTION_` varchar(4000) collate utf8_bin default NULL,
`RETRIES_` int(11) default NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`REPEAT_` varchar(255) collate utf8_bin default NULL,
`TRANSITIONNAME_` varchar(255) collate utf8_bin default NULL,
`ACTION_` bigint(20) default NULL,
`GRAPHELEMENTTYPE_` varchar(255) collate utf8_bin default NULL,
`GRAPHELEMENT_` bigint(20) default NULL,
`NODE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_JOB_TSKINST` (`TASKINSTANCE_`),
KEY `IDX_JOB_TOKEN` (`TOKEN_`),
KEY `IDX_JOB_PRINST` (`PROCESSINSTANCE_`),
KEY `FK_JOB_PRINST` (`PROCESSINSTANCE_`),
KEY `FK_JOB_ACTION` (`ACTION_`),
KEY `FK_JOB_TOKEN` (`TOKEN_`),
KEY `FK_JOB_NODE` (`NODE_`),
KEY `FK_JOB_TSKINST` (`TASKINSTANCE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_JOB`
--
LOCK TABLES `JBPM_JOB` WRITE;
/*!40000 ALTER TABLE `JBPM_JOB` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_JOB` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_LOG`
--
DROP TABLE IF EXISTS `JBPM_LOG`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_LOG` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`INDEX_` int(11) default NULL,
`DATE_` datetime default NULL,
`TOKEN_` bigint(20) default NULL,
`PARENT_` bigint(20) default NULL,
`MESSAGE_` varchar(4000) collate utf8_bin default NULL,
`EXCEPTION_` varchar(4000) collate utf8_bin default NULL,
`ACTION_` bigint(20) default NULL,
`NODE_` bigint(20) default NULL,
`ENTER_` datetime default NULL,
`LEAVE_` datetime default NULL,
`DURATION_` bigint(20) default NULL,
`NEWLONGVALUE_` bigint(20) default NULL,
`TRANSITION_` bigint(20) default NULL,
`CHILD_` bigint(20) default NULL,
`SOURCENODE_` bigint(20) default NULL,
`DESTINATIONNODE_` bigint(20) default NULL,
`VARIABLEINSTANCE_` bigint(20) default NULL,
`OLDBYTEARRAY_` bigint(20) default NULL,
`NEWBYTEARRAY_` bigint(20) default NULL,
`OLDDATEVALUE_` datetime default NULL,
`NEWDATEVALUE_` datetime default NULL,
`OLDDOUBLEVALUE_` double default NULL,
`NEWDOUBLEVALUE_` double default NULL,
`OLDLONGIDCLASS_` varchar(255) collate utf8_bin default NULL,
`OLDLONGIDVALUE_` bigint(20) default NULL,
`NEWLONGIDCLASS_` varchar(255) collate utf8_bin default NULL,
`NEWLONGIDVALUE_` bigint(20) default NULL,
`OLDSTRINGIDCLASS_` varchar(255) collate utf8_bin default NULL,
`OLDSTRINGIDVALUE_` varchar(255) collate utf8_bin default NULL,
`NEWSTRINGIDCLASS_` varchar(255) collate utf8_bin default NULL,
`NEWSTRINGIDVALUE_` varchar(255) collate utf8_bin default NULL,
`OLDLONGVALUE_` bigint(20) default NULL,
`OLDSTRINGVALUE_` varchar(4000) collate utf8_bin default NULL,
`NEWSTRINGVALUE_` varchar(4000) collate utf8_bin default NULL,
`TASKINSTANCE_` bigint(20) default NULL,
`TASKACTORID_` varchar(255) collate utf8_bin default NULL,
`TASKOLDACTORID_` varchar(255) collate utf8_bin default NULL,
`SWIMLANEINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `FK_LOG_SOURCENODE` (`SOURCENODE_`),
KEY `FK_LOG_DESTNODE` (`DESTINATIONNODE_`),
KEY `FK_LOG_TOKEN` (`TOKEN_`),
KEY `FK_LOG_TRANSITION` (`TRANSITION_`),
KEY `FK_LOG_TASKINST` (`TASKINSTANCE_`),
KEY `FK_LOG_CHILDTOKEN` (`CHILD_`),
KEY `FK_LOG_OLDBYTES` (`OLDBYTEARRAY_`),
KEY `FK_LOG_SWIMINST` (`SWIMLANEINSTANCE_`),
KEY `FK_LOG_NEWBYTES` (`NEWBYTEARRAY_`),
KEY `FK_LOG_ACTION` (`ACTION_`),
KEY `FK_LOG_VARINST` (`VARIABLEINSTANCE_`),
KEY `FK_LOG_NODE` (`NODE_`),
KEY `FK_LOG_PARENT` (`PARENT_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_LOG`
--
LOCK TABLES `JBPM_LOG` WRITE;
/*!40000 ALTER TABLE `JBPM_LOG` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_LOG` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_MODULEDEFINITION`
--
DROP TABLE IF EXISTS `JBPM_MODULEDEFINITION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_MODULEDEFINITION` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`NAME_` varchar(4000) collate utf8_bin default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`STARTTASK_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_MODDEF_PROCDF` (`PROCESSDEFINITION_`),
KEY `FK_MODDEF_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_TSKDEF_START` (`STARTTASK_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_MODULEDEFINITION`
--
LOCK TABLES `JBPM_MODULEDEFINITION` WRITE;
/*!40000 ALTER TABLE `JBPM_MODULEDEFINITION` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_MODULEDEFINITION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_MODULEINSTANCE`
--
DROP TABLE IF EXISTS `JBPM_MODULEINSTANCE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_MODULEINSTANCE` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`VERSION_` int(11) NOT NULL,
`PROCESSINSTANCE_` bigint(20) default NULL,
`TASKMGMTDEFINITION_` bigint(20) default NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_MODINST_PRINST` (`PROCESSINSTANCE_`),
KEY `FK_MODINST_PRCINST` (`PROCESSINSTANCE_`),
KEY `FK_TASKMGTINST_TMD` (`TASKMGMTDEFINITION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_MODULEINSTANCE`
--
LOCK TABLES `JBPM_MODULEINSTANCE` WRITE;
/*!40000 ALTER TABLE `JBPM_MODULEINSTANCE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_MODULEINSTANCE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_NODE`
--
DROP TABLE IF EXISTS `JBPM_NODE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_NODE` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`ISASYNC_` bit(1) default NULL,
`ISASYNCEXCL_` bit(1) default NULL,
`ACTION_` bigint(20) default NULL,
`SUPERSTATE_` bigint(20) default NULL,
`SUBPROCNAME_` varchar(255) collate utf8_bin default NULL,
`SUBPROCESSDEFINITION_` bigint(20) default NULL,
`DECISIONEXPRESSION_` varchar(255) collate utf8_bin default NULL,
`DECISIONDELEGATION` bigint(20) default NULL,
`SCRIPT_` bigint(20) default NULL,
`SIGNAL_` int(11) default NULL,
`CREATETASKS_` bit(1) default NULL,
`ENDTASKS_` bit(1) default NULL,
`NODECOLLECTIONINDEX_` int(11) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_PSTATE_SBPRCDEF` (`SUBPROCESSDEFINITION_`),
KEY `IDX_NODE_PROCDEF` (`PROCESSDEFINITION_`),
KEY `IDX_NODE_ACTION` (`ACTION_`),
KEY `IDX_NODE_SUPRSTATE` (`SUPERSTATE_`),
KEY `FK_DECISION_DELEG` (`DECISIONDELEGATION`),
KEY `FK_NODE_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_NODE_ACTION` (`ACTION_`),
KEY `FK_PROCST_SBPRCDEF` (`SUBPROCESSDEFINITION_`),
KEY `FK_NODE_SCRIPT` (`SCRIPT_`),
KEY `FK_NODE_SUPERSTATE` (`SUPERSTATE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_NODE`
--
LOCK TABLES `JBPM_NODE` WRITE;
/*!40000 ALTER TABLE `JBPM_NODE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_NODE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_POOLEDACTOR`
--
DROP TABLE IF EXISTS `JBPM_POOLEDACTOR`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_POOLEDACTOR` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`ACTORID_` varchar(255) collate utf8_bin default NULL,
`SWIMLANEINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TSKINST_SWLANE` (`SWIMLANEINSTANCE_`),
KEY `IDX_PLDACTR_ACTID` (`ACTORID_`),
KEY `FK_POOLEDACTOR_SLI` (`SWIMLANEINSTANCE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_POOLEDACTOR`
--
LOCK TABLES `JBPM_POOLEDACTOR` WRITE;
/*!40000 ALTER TABLE `JBPM_POOLEDACTOR` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_POOLEDACTOR` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_PROCESSDEFINITION`
--
DROP TABLE IF EXISTS `JBPM_PROCESSDEFINITION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_PROCESSDEFINITION` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,
`VERSION_` int(11) default NULL,
`ISTERMINATIONIMPLICIT_` bit(1) default NULL,
`STARTSTATE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_PROCDEF_STRTST` (`STARTSTATE_`),
KEY `FK_PROCDEF_STRTSTA` (`STARTSTATE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_PROCESSDEFINITION`
--
LOCK TABLES `JBPM_PROCESSDEFINITION` WRITE;
/*!40000 ALTER TABLE `JBPM_PROCESSDEFINITION` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_PROCESSDEFINITION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_PROCESSINSTANCE`
--
DROP TABLE IF EXISTS `JBPM_PROCESSINSTANCE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_PROCESSINSTANCE` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`KEY_` varchar(255) collate utf8_bin default NULL,
`START_` datetime default NULL,
`END_` datetime default NULL,
`ISSUSPENDED_` bit(1) default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`ROOTTOKEN_` bigint(20) default NULL,
`SUPERPROCESSTOKEN_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_PROCIN_SPROCTK` (`SUPERPROCESSTOKEN_`),
KEY `IDX_PROCIN_ROOTTK` (`ROOTTOKEN_`),
KEY `IDX_PROCIN_PROCDEF` (`PROCESSDEFINITION_`),
KEY `IDX_PROCIN_KEY` (`KEY_`),
KEY `FK_PROCIN_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_PROCIN_ROOTTKN` (`ROOTTOKEN_`),
KEY `FK_PROCIN_SPROCTKN` (`SUPERPROCESSTOKEN_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_PROCESSINSTANCE`
--
LOCK TABLES `JBPM_PROCESSINSTANCE` WRITE;
/*!40000 ALTER TABLE `JBPM_PROCESSINSTANCE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_PROCESSINSTANCE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_RUNTIMEACTION`
--
DROP TABLE IF EXISTS `JBPM_RUNTIMEACTION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_RUNTIMEACTION` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`EVENTTYPE_` varchar(255) collate utf8_bin default NULL,
`TYPE_` char(1) collate utf8_bin default NULL,
`GRAPHELEMENT_` bigint(20) default NULL,
`PROCESSINSTANCE_` bigint(20) default NULL,
`ACTION_` bigint(20) default NULL,
`PROCESSINSTANCEINDEX_` int(11) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_RTACTN_ACTION` (`ACTION_`),
KEY `IDX_RTACTN_PRCINST` (`PROCESSINSTANCE_`),
KEY `FK_RTACTN_PROCINST` (`PROCESSINSTANCE_`),
KEY `FK_RTACTN_ACTION` (`ACTION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_RUNTIMEACTION`
--
LOCK TABLES `JBPM_RUNTIMEACTION` WRITE;
/*!40000 ALTER TABLE `JBPM_RUNTIMEACTION` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_RUNTIMEACTION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_SWIMLANE`
--
DROP TABLE IF EXISTS `JBPM_SWIMLANE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_SWIMLANE` (
`ID_` bigint(20) NOT NULL auto_increment,
`NAME_` varchar(255) collate utf8_bin default NULL,
`ACTORIDEXPRESSION_` varchar(255) collate utf8_bin default NULL,
`POOLEDACTORSEXPRESSION_` varchar(255) collate utf8_bin default NULL,
`ASSIGNMENTDELEGATION_` bigint(20) default NULL,
`TASKMGMTDEFINITION_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `FK_SWL_ASSDEL` (`ASSIGNMENTDELEGATION_`),
KEY `FK_SWL_TSKMGMTDEF` (`TASKMGMTDEFINITION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_SWIMLANE`
--
LOCK TABLES `JBPM_SWIMLANE` WRITE;
/*!40000 ALTER TABLE `JBPM_SWIMLANE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_SWIMLANE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_SWIMLANEINSTANCE`
--
DROP TABLE IF EXISTS `JBPM_SWIMLANEINSTANCE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_SWIMLANEINSTANCE` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`ACTORID_` varchar(255) collate utf8_bin default NULL,
`SWIMLANE_` bigint(20) default NULL,
`TASKMGMTINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_SWIMLINST_SL` (`SWIMLANE_`),
KEY `FK_SWIMLANEINST_TM` (`TASKMGMTINSTANCE_`),
KEY `FK_SWIMLANEINST_SL` (`SWIMLANE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_SWIMLANEINSTANCE`
--
LOCK TABLES `JBPM_SWIMLANEINSTANCE` WRITE;
/*!40000 ALTER TABLE `JBPM_SWIMLANEINSTANCE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_SWIMLANEINSTANCE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TASK`
--
DROP TABLE IF EXISTS `JBPM_TASK`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TASK` (
`ID_` bigint(20) NOT NULL auto_increment,
`NAME_` varchar(255) collate utf8_bin default NULL,
`DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`ISBLOCKING_` bit(1) default NULL,
`ISSIGNALLING_` bit(1) default NULL,
`CONDITION_` varchar(255) collate utf8_bin default NULL,
`DUEDATE_` varchar(255) collate utf8_bin default NULL,
`PRIORITY_` int(11) default NULL,
`ACTORIDEXPRESSION_` varchar(255) collate utf8_bin default NULL,
`POOLEDACTORSEXPRESSION_` varchar(255) collate utf8_bin default NULL,
`TASKMGMTDEFINITION_` bigint(20) default NULL,
`TASKNODE_` bigint(20) default NULL,
`STARTSTATE_` bigint(20) default NULL,
`ASSIGNMENTDELEGATION_` bigint(20) default NULL,
`SWIMLANE_` bigint(20) default NULL,
`TASKCONTROLLER_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TASK_PROCDEF` (`PROCESSDEFINITION_`),
KEY `IDX_TASK_TSKNODE` (`TASKNODE_`),
KEY `IDX_TASK_TASKMGTDF` (`TASKMGMTDEFINITION_`),
KEY `FK_TASK_STARTST` (`STARTSTATE_`),
KEY `FK_TASK_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_TASK_ASSDEL` (`ASSIGNMENTDELEGATION_`),
KEY `FK_TASK_SWIMLANE` (`SWIMLANE_`),
KEY `FK_TASK_TASKNODE` (`TASKNODE_`),
KEY `FK_TASK_TASKMGTDEF` (`TASKMGMTDEFINITION_`),
KEY `FK_TSK_TSKCTRL` (`TASKCONTROLLER_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TASK`
--
LOCK TABLES `JBPM_TASK` WRITE;
/*!40000 ALTER TABLE `JBPM_TASK` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TASK` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TASKACTORPOOL`
--
DROP TABLE IF EXISTS `JBPM_TASKACTORPOOL`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TASKACTORPOOL` (
`TASKINSTANCE_` bigint(20) NOT NULL,
`POOLEDACTOR_` bigint(20) NOT NULL,
PRIMARY KEY (`TASKINSTANCE_`,`POOLEDACTOR_`),
KEY `FK_TASKACTPL_TSKI` (`TASKINSTANCE_`),
KEY `FK_TSKACTPOL_PLACT` (`POOLEDACTOR_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TASKACTORPOOL`
--
LOCK TABLES `JBPM_TASKACTORPOOL` WRITE;
/*!40000 ALTER TABLE `JBPM_TASKACTORPOOL` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TASKACTORPOOL` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TASKCONTROLLER`
--
DROP TABLE IF EXISTS `JBPM_TASKCONTROLLER`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TASKCONTROLLER` (
`ID_` bigint(20) NOT NULL auto_increment,
`TASKCONTROLLERDELEGATION_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `FK_TSKCTRL_DELEG` (`TASKCONTROLLERDELEGATION_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TASKCONTROLLER`
--
LOCK TABLES `JBPM_TASKCONTROLLER` WRITE;
/*!40000 ALTER TABLE `JBPM_TASKCONTROLLER` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TASKCONTROLLER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TASKINSTANCE`
--
DROP TABLE IF EXISTS `JBPM_TASKINSTANCE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TASKINSTANCE` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,
`ACTORID_` varchar(255) collate utf8_bin default NULL,
`CREATE_` datetime default NULL,
`START_` datetime default NULL,
`END_` datetime default NULL,
`DUEDATE_` datetime default NULL,
`PRIORITY_` int(11) default NULL,
`ISCANCELLED_` bit(1) default NULL,
`ISSUSPENDED_` bit(1) default NULL,
`ISOPEN_` bit(1) default NULL,
`ISSIGNALLING_` bit(1) default NULL,
`ISBLOCKING_` bit(1) default NULL,
`TASK_` bigint(20) default NULL,
`TOKEN_` bigint(20) default NULL,
`PROCINST_` bigint(20) default NULL,
`SWIMLANINSTANCE_` bigint(20) default NULL,
`TASKMGMTINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TSKINST_TMINST` (`TASKMGMTINSTANCE_`),
KEY `IDX_TSKINST_SLINST` (`SWIMLANINSTANCE_`),
KEY `IDX_TASKINST_TOKN` (`TOKEN_`),
KEY `IDX_TASK_ACTORID` (`ACTORID_`),
KEY `IDX_TASKINST_TSK` (`TASK_`,`PROCINST_`),
KEY `FK_TSKINS_PRCINS` (`PROCINST_`),
KEY `FK_TASKINST_TMINST` (`TASKMGMTINSTANCE_`),
KEY `FK_TASKINST_TOKEN` (`TOKEN_`),
KEY `FK_TASKINST_SLINST` (`SWIMLANINSTANCE_`),
KEY `FK_TASKINST_TASK` (`TASK_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TASKINSTANCE`
--
LOCK TABLES `JBPM_TASKINSTANCE` WRITE;
/*!40000 ALTER TABLE `JBPM_TASKINSTANCE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TASKINSTANCE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TOKEN`
--
DROP TABLE IF EXISTS `JBPM_TOKEN`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TOKEN` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`START_` datetime default NULL,
`END_` datetime default NULL,
`NODEENTER_` datetime default NULL,
`NEXTLOGINDEX_` int(11) default NULL,
`ISABLETOREACTIVATEPARENT_` bit(1) default NULL,
`ISTERMINATIONIMPLICIT_` bit(1) default NULL,
`ISSUSPENDED_` bit(1) default NULL,
`LOCK_` varchar(255) collate utf8_bin default NULL,
`NODE_` bigint(20) default NULL,
`PROCESSINSTANCE_` bigint(20) default NULL,
`PARENT_` bigint(20) default NULL,
`SUBPROCESSINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TOKEN_PARENT` (`PARENT_`),
KEY `IDX_TOKEN_PROCIN` (`PROCESSINSTANCE_`),
KEY `IDX_TOKEN_NODE` (`NODE_`),
KEY `IDX_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`),
KEY `FK_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`),
KEY `FK_TOKEN_PROCINST` (`PROCESSINSTANCE_`),
KEY `FK_TOKEN_NODE` (`NODE_`),
KEY `FK_TOKEN_PARENT` (`PARENT_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TOKEN`
--
LOCK TABLES `JBPM_TOKEN` WRITE;
/*!40000 ALTER TABLE `JBPM_TOKEN` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TOKEN` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TOKENVARIABLEMAP`
--
DROP TABLE IF EXISTS `JBPM_TOKENVARIABLEMAP`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TOKENVARIABLEMAP` (
`ID_` bigint(20) NOT NULL auto_increment,
`VERSION_` int(11) NOT NULL,
`TOKEN_` bigint(20) default NULL,
`CONTEXTINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TKVVARMP_TOKEN` (`TOKEN_`),
KEY `IDX_TKVARMAP_CTXT` (`CONTEXTINSTANCE_`),
KEY `FK_TKVARMAP_TOKEN` (`TOKEN_`),
KEY `FK_TKVARMAP_CTXT` (`CONTEXTINSTANCE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TOKENVARIABLEMAP`
--
LOCK TABLES `JBPM_TOKENVARIABLEMAP` WRITE;
/*!40000 ALTER TABLE `JBPM_TOKENVARIABLEMAP` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TOKENVARIABLEMAP` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_TRANSITION`
--
DROP TABLE IF EXISTS `JBPM_TRANSITION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_TRANSITION` (
`ID_` bigint(20) NOT NULL auto_increment,
`NAME_` varchar(255) collate utf8_bin default NULL,
`DESCRIPTION_` varchar(4000) collate utf8_bin default NULL,
`PROCESSDEFINITION_` bigint(20) default NULL,
`FROM_` bigint(20) default NULL,
`TO_` bigint(20) default NULL,
`CONDITION_` varchar(255) collate utf8_bin default NULL,
`FROMINDEX_` int(11) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TRANS_PROCDEF` (`PROCESSDEFINITION_`),
KEY `IDX_TRANSIT_FROM` (`FROM_`),
KEY `IDX_TRANSIT_TO` (`TO_`),
KEY `FK_TRANSITION_FROM` (`FROM_`),
KEY `FK_TRANS_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_TRANSITION_TO` (`TO_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_TRANSITION`
--
LOCK TABLES `JBPM_TRANSITION` WRITE;
/*!40000 ALTER TABLE `JBPM_TRANSITION` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_TRANSITION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_VARIABLEACCESS`
--
DROP TABLE IF EXISTS `JBPM_VARIABLEACCESS`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_VARIABLEACCESS` (
`ID_` bigint(20) NOT NULL auto_increment,
`VARIABLENAME_` varchar(255) collate utf8_bin default NULL,
`ACCESS_` varchar(255) collate utf8_bin default NULL,
`MAPPEDNAME_` varchar(255) collate utf8_bin default NULL,
`SCRIPT_` bigint(20) default NULL,
`PROCESSSTATE_` bigint(20) default NULL,
`TASKCONTROLLER_` bigint(20) default NULL,
`INDEX_` int(11) default NULL,
PRIMARY KEY (`ID_`),
KEY `FK_VARACC_PROCST` (`PROCESSSTATE_`),
KEY `FK_VARACC_SCRIPT` (`SCRIPT_`),
KEY `FK_VARACC_TSKCTRL` (`TASKCONTROLLER_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_VARIABLEACCESS`
--
LOCK TABLES `JBPM_VARIABLEACCESS` WRITE;
/*!40000 ALTER TABLE `JBPM_VARIABLEACCESS` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_VARIABLEACCESS` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `JBPM_VARIABLEINSTANCE`
--
DROP TABLE IF EXISTS `JBPM_VARIABLEINSTANCE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `JBPM_VARIABLEINSTANCE` (
`ID_` bigint(20) NOT NULL auto_increment,
`CLASS_` char(1) collate utf8_bin NOT NULL,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) collate utf8_bin default NULL,
`CONVERTER_` char(1) collate utf8_bin default NULL,
`TOKEN_` bigint(20) default NULL,
`TOKENVARIABLEMAP_` bigint(20) default NULL,
`PROCESSINSTANCE_` bigint(20) default NULL,
`BYTEARRAYVALUE_` bigint(20) default NULL,
`DATEVALUE_` datetime default NULL,
`DOUBLEVALUE_` double default NULL,
`LONGIDCLASS_` varchar(255) collate utf8_bin default NULL,
`LONGVALUE_` bigint(20) default NULL,
`STRINGIDCLASS_` varchar(255) collate utf8_bin default NULL,
`STRINGVALUE_` varchar(4000) collate utf8_bin default NULL,
`TASKINSTANCE_` bigint(20) default NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_VARINST_TK` (`TOKEN_`),
KEY `IDX_VARINST_TKVARMP` (`TOKENVARIABLEMAP_`),
KEY `IDX_VARINST_PRCINS` (`PROCESSINSTANCE_`),
KEY `FK_VARINST_PRCINST` (`PROCESSINSTANCE_`),
KEY `FK_VARINST_TKVARMP` (`TOKENVARIABLEMAP_`),
KEY `FK_VARINST_TK` (`TOKEN_`),
KEY `FK_BYTEINST_ARRAY` (`BYTEARRAYVALUE_`),
KEY `FK_VAR_TSKINST` (`TASKINSTANCE_`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `JBPM_VARIABLEINSTANCE`
--
LOCK TABLES `JBPM_VARIABLEINSTANCE` WRITE;
/*!40000 ALTER TABLE `JBPM_VARIABLEINSTANCE` DISABLE KEYS */;
/*!40000 ALTER TABLE `JBPM_VARIABLEINSTANCE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_ACTIVITY`
--
DROP TABLE IF EXISTS `OKM_ACTIVITY`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_ACTIVITY` (
`ACT_ID` int(11) NOT NULL auto_increment,
`ACT_DATE` datetime NOT NULL,
`ACT_USER` varchar(127) collate utf8_bin NOT NULL,
`ACT_ACTION` varchar(255) collate utf8_bin NOT NULL,
`ACT_ITEM` text collate utf8_bin,
`ACT_PARAMS` text collate utf8_bin,
PRIMARY KEY (`ACT_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_ACTIVITY`
--
LOCK TABLES `OKM_ACTIVITY` WRITE;
/*!40000 ALTER TABLE `OKM_ACTIVITY` DISABLE KEYS */;
INSERT INTO `OKM_ACTIVITY` VALUES (1,'2011-07-28 09:43:52','system','OPENKM_START',NULL,NULL),(2,'2011-07-28 09:44:55','okmAdmin','LOGIN',NULL,NULL),(3,'2011-07-28 09:44:55','okmAdmin','GET_ROOT_FOLDER',NULL,'/okm:root'),(4,'2011-07-28 09:44:56','okmAdmin','GET_ROOT_FOLDER',NULL,'/okm:root'),(5,'2011-07-28 09:44:56','okmAdmin','FIND_USER_TASK_INSTANCES',NULL,NULL),(6,'2011-07-28 09:44:56','okmAdmin','FIND_POOLED_TASK_INSTANCES',NULL,NULL),(7,'2011-07-28 09:44:56','okmAdmin','GET_DASHBOARD_USER_SEARCHS',NULL,NULL),(8,'2011-07-28 09:44:57','okmAdmin','GET_ROOT_FOLDER',NULL,'/okm:root'),(9,'2011-07-28 09:44:57','okmAdmin','GET_CATEGORIES_FOLDER',NULL,'/okm:categories'),(10,'2011-07-28 09:44:57','okmAdmin','GET_THESAURUS_FOLDER',NULL,'/okm:thesaurus'),(11,'2011-07-28 09:44:57','okmAdmin','GET_TEMPLATES_FOLDER',NULL,'/okm:templates'),(12,'2011-07-28 09:44:57','okmAdmin','GET_PERSONAL_FOLDER_BASE',NULL,'/okm:personal'),(13,'2011-07-28 09:44:57','okmAdmin','GET_MAIL_FOLDER_BASE',NULL,'/okm:mail'),(14,'2011-07-28 09:44:57','okmAdmin','GET_TRASH_FOLDER_BASE',NULL,'/okm:trash'),(15,'2011-07-28 09:44:57','okmAdmin','USER_CONFIG_GET_CONFIG',NULL,NULL),(16,'2011-07-28 09:44:57','okmAdmin','BOOKMARK_GET_ALL',NULL,NULL),(17,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:root',NULL),(18,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:root',NULL),(19,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_DOCUMENTS','/okm:root',NULL),(20,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_MAILS','/okm:root',NULL),(21,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:categories',NULL),(22,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:templates',NULL),(23,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:thesaurus',NULL),(24,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:trash',NULL),(25,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:personal',NULL),(26,'2011-07-28 09:44:57','okmAdmin','GET_DASHBOARD_USER_SEARCHS',NULL,NULL),(27,'2011-07-28 09:44:57','okmAdmin','GET_ALL_SEARCHS',NULL,NULL),(28,'2011-07-28 09:44:57','okmAdmin','GET_CHILD_FOLDERS','/okm:mail',NULL),(29,'2011-07-28 09:44:59','okmAdmin','GET_CHILD_FOLDERS','/okm:root/IncomingProtocol',NULL),(30,'2011-07-28 09:44:59','okmAdmin','GET_CHILD_FOLDERS','/okm:root/IncomingProtocol',NULL),(31,'2011-07-28 09:44:59','okmAdmin','GET_CHILD_DOCUMENTS','/okm:root/IncomingProtocol',NULL),(32,'2011-07-28 09:44:59','okmAdmin','GET_CHILD_MAILS','/okm:root/IncomingProtocol',NULL),(33,'2011-07-28 09:45:00','okmAdmin','GET_CHILD_FOLDERS','/okm:root/OutgoingProtocol',NULL),(34,'2011-07-28 09:45:00','okmAdmin','GET_CHILD_FOLDERS','/okm:root/OutgoingProtocol',NULL),(35,'2011-07-28 09:45:00','okmAdmin','GET_CHILD_DOCUMENTS','/okm:root/OutgoingProtocol',NULL),(36,'2011-07-28 09:45:00','okmAdmin','GET_CHILD_MAILS','/okm:root/OutgoingProtocol',NULL),(37,'2011-07-28 09:45:00','okmAdmin','GET_CHILD_FOLDERS','/okm:root/PendingIncoming',NULL),(38,'2011-07-28 09:45:00','okmAdmin','GET_CHILD_FOLDERS','/okm:root/PendingIncoming',NULL),(39,'2011-07-28 09:45:01','okmAdmin','GET_CHILD_DOCUMENTS','/okm:root/PendingIncoming',NULL),(40,'2011-07-28 09:45:01','okmAdmin','GET_CHILD_MAILS','/okm:root/PendingIncoming',NULL),(41,'2011-07-28 09:45:01','okmAdmin','GET_CHILD_FOLDERS','/okm:root/PendingOutgoing',NULL),(42,'2011-07-28 09:45:01','okmAdmin','GET_CHILD_FOLDERS','/okm:root/PendingOutgoing',NULL),(43,'2011-07-28 09:45:01','okmAdmin','GET_CHILD_DOCUMENTS','/okm:root/PendingOutgoing',NULL),(44,'2011-07-28 09:45:01','okmAdmin','GET_CHILD_MAILS','/okm:root/PendingOutgoing',NULL),(45,'2011-07-28 09:45:04','okmAdmin','LOGOUT',NULL,NULL),(46,'2011-07-28 09:45:04','okmAdmin','SESSION_DESTROYED','26FA6503582ED8E64D410B4A7785E25A',NULL),(47,'2011-07-28 09:45:09','system','OPENKM_STOP',NULL,NULL);
/*!40000 ALTER TABLE `OKM_ACTIVITY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_BOOKMARK`
--
DROP TABLE IF EXISTS `OKM_BOOKMARK`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_BOOKMARK` (
`BM_ID` int(11) NOT NULL auto_increment,
`BM_USER` varchar(127) collate utf8_bin NOT NULL,
`BM_NAME` varchar(255) collate utf8_bin NOT NULL,
`BM_PATH` varchar(255) collate utf8_bin NOT NULL,
`BM_UUID` varchar(255) collate utf8_bin NOT NULL,
`BM_TYPE` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`BM_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_BOOKMARK`
--
LOCK TABLES `OKM_BOOKMARK` WRITE;
/*!40000 ALTER TABLE `OKM_BOOKMARK` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_BOOKMARK` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_CRON_TAB`
--
DROP TABLE IF EXISTS `OKM_CRON_TAB`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_CRON_TAB` (
`CT_ID` int(11) NOT NULL auto_increment,
`CT_NAME` varchar(255) collate utf8_bin NOT NULL,
`CT_EXPRESSION` varchar(255) collate utf8_bin NOT NULL,
`CT_TYPE` varchar(255) collate utf8_bin NOT NULL,
`CT_FILE_CONTENT` text collate utf8_bin NOT NULL,
`CT_FILE_NAME` varchar(255) collate utf8_bin NOT NULL,
`CT_MAIL` varchar(255) collate utf8_bin NOT NULL,
`CT_ACTIVE` bit(1) NOT NULL,
`CT_LAST_BEGIN` datetime default NULL,
`CT_LAST_END` datetime default NULL,
PRIMARY KEY (`CT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_CRON_TAB`
--
LOCK TABLES `OKM_CRON_TAB` WRITE;
/*!40000 ALTER TABLE `OKM_CRON_TAB` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_CRON_TAB` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_DASHBOARD`
--
DROP TABLE IF EXISTS `OKM_DASHBOARD`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_DASHBOARD` (
`DB_ID` int(11) NOT NULL auto_increment,
`DB_USER` varchar(127) collate utf8_bin NOT NULL,
`DB_SOURCE` varchar(255) collate utf8_bin NOT NULL,
`DB_NODE` varchar(255) collate utf8_bin NOT NULL,
`DB_DATE` datetime NOT NULL,
PRIMARY KEY (`DB_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_DASHBOARD`
--
LOCK TABLES `OKM_DASHBOARD` WRITE;
/*!40000 ALTER TABLE `OKM_DASHBOARD` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_DASHBOARD` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_EXTENSION`
--
DROP TABLE IF EXISTS `OKM_EXTENSION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_EXTENSION` (
`EX_UUID` varchar(127) collate utf8_bin NOT NULL,
`EX_DESCRIPTION` text collate utf8_bin NOT NULL,
PRIMARY KEY (`EX_UUID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_EXTENSION`
--
LOCK TABLES `OKM_EXTENSION` WRITE;
/*!40000 ALTER TABLE `OKM_EXTENSION` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_EXTENSION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_FILTER_RULE`
--
DROP TABLE IF EXISTS `OKM_FILTER_RULE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_FILTER_RULE` (
`FR_ID` int(11) NOT NULL auto_increment,
`FR_FIELD` varchar(255) collate utf8_bin NOT NULL,
`FR_OPERATION` varchar(255) collate utf8_bin NOT NULL,
`FR_VALUE` varchar(255) collate utf8_bin NOT NULL,
`FR_ACTIVE` bit(1) NOT NULL,
`FR_MAIL_FILTER` int(11) NOT NULL,
PRIMARY KEY (`FR_ID`),
KEY `FKCC0FA2157CF377A9` (`FR_MAIL_FILTER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_FILTER_RULE`
--
LOCK TABLES `OKM_FILTER_RULE` WRITE;
/*!40000 ALTER TABLE `OKM_FILTER_RULE` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_FILTER_RULE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_LOCK_TOKEN`
--
DROP TABLE IF EXISTS `OKM_LOCK_TOKEN`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_LOCK_TOKEN` (
`LT_ID` int(11) NOT NULL auto_increment,
`LT_USER` varchar(127) collate utf8_bin NOT NULL,
`LT_TOKEN` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`LT_ID`),
UNIQUE KEY `LT_TOKEN` (`LT_TOKEN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_LOCK_TOKEN`
--
LOCK TABLES `OKM_LOCK_TOKEN` WRITE;
/*!40000 ALTER TABLE `OKM_LOCK_TOKEN` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_LOCK_TOKEN` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_MAIL_ACCOUNT`
--
DROP TABLE IF EXISTS `OKM_MAIL_ACCOUNT`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_MAIL_ACCOUNT` (
`MA_ID` int(11) NOT NULL auto_increment,
`MA_USER` varchar(127) collate utf8_bin NOT NULL,
`MA_MPROTOCOL` varchar(255) collate utf8_bin NOT NULL,
`MA_MHOST` varchar(255) collate utf8_bin NOT NULL,
`MA_MFOLDER` varchar(255) collate utf8_bin NOT NULL,
`MA_MUSER` varchar(255) collate utf8_bin NOT NULL,
`MA_MPASSWORD` varchar(255) collate utf8_bin NOT NULL,
`MA_MMARK_SEEN` bit(1) NOT NULL,
`MA_MMARK_DELETED` bit(1) NOT NULL,
`MA_ACTIVE` bit(1) NOT NULL,
PRIMARY KEY (`MA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_MAIL_ACCOUNT`
--
LOCK TABLES `OKM_MAIL_ACCOUNT` WRITE;
/*!40000 ALTER TABLE `OKM_MAIL_ACCOUNT` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_MAIL_ACCOUNT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_MAIL_FILTER`
--
DROP TABLE IF EXISTS `OKM_MAIL_FILTER`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_MAIL_FILTER` (
`MF_ID` int(11) NOT NULL auto_increment,
`MF_PATH` varchar(255) collate utf8_bin NOT NULL,
`MF_UUID` varchar(255) collate utf8_bin NOT NULL,
`MF_GROUPING` bit(1) NOT NULL,
`MF_ACTIVE` bit(1) NOT NULL,
`MF_MAIL_ACCOUNT` int(11) NOT NULL,
PRIMARY KEY (`MF_ID`),
KEY `FK89DD61B2D99BBF14` (`MF_MAIL_ACCOUNT`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_MAIL_FILTER`
--
LOCK TABLES `OKM_MAIL_FILTER` WRITE;
/*!40000 ALTER TABLE `OKM_MAIL_FILTER` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_MAIL_FILTER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_MIME_TYPE`
--
DROP TABLE IF EXISTS `OKM_MIME_TYPE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_MIME_TYPE` (
`MT_ID` int(11) NOT NULL auto_increment,
`MT_NAME` varchar(255) collate utf8_bin NOT NULL,
`MT_IMAGE_CONTENT` text collate utf8_bin NOT NULL,
`MT_IMAGE_MIME` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`MT_ID`),
UNIQUE KEY `MT_NAME` (`MT_NAME`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_MIME_TYPE`
--
LOCK TABLES `OKM_MIME_TYPE` WRITE;
/*!40000 ALTER TABLE `OKM_MIME_TYPE` DISABLE KEYS */;
INSERT INTO `OKM_MIME_TYPE` VALUES (1,'application/vnd.oasis.opendocument.text','R0lGODlhFwAQAOeeABUyQBkyPxc2Rhg5SRg6Sh84RR05Rxk7Sxk7TCE6SBk9Tho9Tho+Txo+UBtAUhtBUxxEVx1FWB5GWSVLXSZOYTVWZzpVYkJVYkNXYz5ZZj5aZ0VYYjpdb0Jeb0JfbUNgbklebEhfa0Bic0pfbUxicUZlc01jckpqeVFpeUtsfFNqelRreFhuflJxgFZvgFl0hVl0hlp1hl52hl55i155jF56jF97jWB7jWR6iGV9iGl/jmiAkG9/h2uAjWiElnWDjG+GlXaEjniIkHeOmHmNmnaPoHeQoYGSnHyUn32UoICUooWTnIaWoYyVmo+Xm4yZoI+Yn4qbp46bo4mdq4qeq5GcpI6eqo+gq5Kgpo2isI6ir5WhqZGlrpakrZeosaGlqJmos56nraGnqZ2or5ypsp6ttpyuuaWsr6CutqGwuqKyvaOzu6KzvqO0v6S0v6izvKe1vq20t6e2wai2wLK1tqi4w7K4u7W4urK7wba6vLe7vbe8vrPBy77Bw7nEy7/Dxb/ExbrGzMXHyMbJysPKzcLN1MfMzsPP1tDR0tHS087T1tHT09DV2NTV1tTW1tTb39Tc39fd4Nzi5tzj597k5+Lm6uHn6uPo6+fn5+Pp7Onq6/Dx8fv7+/3+/v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAjlAP8J/HeCAgEATpwI+cHjR5OBECO+0ADAghM9mDh5MkTpzJ2IEV2EeORJo0InPyRx4uEE5EATK2QACMCDRxNHTlR64uFSoIUEAGZiKqmJxwoTX1b0/Oekk6ennpzQGRSpUZ8fP3pG8gToDI9OPJ6kqcNn0yYhPQcN+hm0hI8iRqZMycSp5VISEwAU2MRJI1RND3vGOJHXRKHDhfwaCuzyRokIAErIlZvpKZ2l/26IeADgTKfPoDt9wayZMxHEiDmNXppjc2QjsGFP2fRx6YwSnFmY3W12EGOXFIIGaFLli3HjxUEGBAA7','image/gif'),(2,'application/vnd.oasis.opendocument.presentation','R0lGODlhFwAQAOesABQwPSgwMhg3Rhg5SRg6Shg7TBk7TBk8TS43OBo+Tzo1LRo/URs/UBxBUz03MBxCVBxCVR1EWB5HWiVLXSZOYTVWZ0VTVz5ZZj9baTpdb0Fea0tdZT9hcUNgbqtFAJZNGk1kb0dmdXJZRkpqektsfLxLAL1MAMFNAMJNAFJxgMlQANdWAMhcFNNaCWV9iOJaAG5+huldAOleAupeAOxeANtkFe1fAO5fAPViAORnFPdjAHiJkHeOmbl6UcV3Q+5rFLKBXutxIP5sCd12MnyTn/ZvFX2UoKKNfoyVmYuZoNGGVP55IP95IOKDRK6Vg8KRcN6JUOmGQ5OgptONXpGlrvGJQ82UbeOOVeCPWfiKQviLQ5eosdSWbfeMROWTXeaUXaSoqv+PRLmklv+QRuyWXeqYYdaeeKCvt9ChgvOZXeadbe6bY6iws+SfcPyYVaSzu+ygbayztvOha7G3usGzqf+iZP+iZfqla8m0pv2la/ymbOishP2mbLa7vci3rPyocOmvif+pcOC0lu2yir/CxL3Dxcy/tvK0i/2xfrrGzNK/s/a2i/K6lfu4i87GwcTKzv26jODIudTNyc7Pz/3DnNXPy/3EndbQy//EnejOvdvSzOvRv9Tc3/XVwPLYxt7k5/3cx//dx+fl5Ofo6Pzi0f3i0P/j0f/k0fPw7vP09Pj49/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAjeAP8J/BeCAgEASJDs2AFjB5KBECOmuCDAgpQ+o1StmiSKTZ+IEjtwWkVSoRQYn1TBeAhSIAgQLgAEgLGSE5KUq2C0FGihAQCZolapQgXjJRgQO/8lIckUSZxHnCYRarhzZCEwMFZJIcRpVKpVqHbsfPTIAoOfH1jUCBJkiKVVLHeCmCAT0CBGeOEEGRUXZIoRdEUwJckoyqS+EV2EiABA8ODCcZL+c8EBAoAjg1cVBiOZsk8geEPDycQ5KeUHjdmqbkJqTucQPlOgmk0b1SPEESn8DIBECpjfv6VIARkQADs=','image/gif'),(3,'application/vnd.oasis.opendocument.spreadsheet','R0lGODlhFwAQAOfAABQwPRg3Rh85Mxg5SRg6Shg7TBk7TBk8TRo+Txo/URs/UBxBUyRCOhxCVBxCVSlFMR1EWB5HWitIMyVLXSZOYTVWZz5aWD5ZZkVZYj9baTpdb0Feaz9hcUNgbkhga0dmdUpqelNyRUtsfFJxgGCFJGmIDGqIDGV9iG5+h3SVDnSWDnaZDneaDniIkHyfDneOmYSqD3yUn32UoIWrD4apGIyWmY6jVY2wH4uZoI2hgZCyJJOqTJC4EI+5EpC5EZKqbpKgppK8EZqlgpe1O5Glrpm0T5fCEZjEEpeosZ25RqKwc53BLp+7SaKoqaK4X57GIaOqrqDHJp+utaPAS6mvlqDLG6e4cqbCUKXIPKm+aqOzuqyztq2/dKzEY6zFXqrLR6nQMKnRMLC+ha7FZqzMS67GZ7PDgK7TO7O5u7LKZ7DRS7i8q7a7vbLST7PSUbLVRbTOa7bPZ7fMd7zBrbjOdrjOd7u/wbnOd7nOeLfTZLnRbbrOfrfYUb7EqrnUZ7nUaLvRdr3Td73Sfr/ExrrGzL7UeL/Ve8PIuMDXdcHWfsTRm8PJzMPXgsbMtcPXg8bJysjKwcPcdcXWksTbf8XedsfYkcXed8bfeMbfesfef8bgesfge8jhesnhgMvdk8rig8vihdDWutHTy9HS0s3gk9LUzM/gnM/jktTWz9HmlNfaz9ffwNTc39riwtjppNjqo9rrpN7k5+HpyeHqxOfn5erq6+jyy+nzy+r0y+vz0+vz1O311O311fDx7fz9/P7+/v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAjhAP8J/PeBAgEANWq0aIGiRY2BECOOuBDAAhA2tHwBe0RrC5qIEj2wAqZRIRAUsXyheAhS4AcQJwAIQLFSVY2UwFC0FGhhAQCZtEjWQuHBQxMPO//V0AisaY0tj1iNGtRw58hBUFD4AmKHVa1evnq12PnokQUFP4GMqsWUJMudHybIpHHjho67smq9BTkChFwJsoDpCDxY1N6IJz5AAECCsOMtSf+d4OCA8d3LOmw1iTzZJ4lZvm6AvsFrc9LJDRi3Cr36hq6Ppz/4lECjdu0htB4djkjhp4AaQJoIFw4ECMiAADs=','image/gif'),(4,'application/vnd.oasis.opendocument.graphics','R0lGODlhFwAQAOegAAoYHwwcJAwdJRAnMhInMR4lKB4mKhIqNhIrNxMsORMtOhQvPRUxPhYzQRY0QyExORg6Sic4QBxBVCY+ShxCVBxCVR1EWDBDTSJJXSdJWS9OXCxQYjxMUz5OVj5SWzpZaD9hcUZgbUBic0Jjc0pjcUVnd0doeE9mb2JjZEtremRkZFZrdWZmZlhxf1h1gmRxd1t3g2R1fVx6iGp3fnB3e2F9iWB9jHZ2dmJ/jXp6enp7e3p8fX5+foCAgJmAQYGBgYODg4SEhIaGhoSHh4mJiYuLi46Ojo+Pj5CQkI2Wmo2Xm5WVlZWWlpaWlpSYmpOanJmZmZebnJqampubm5ycnJ2dndSbEp6enqGgoaSkpKWlpaOpraSrr+unBqWtsO6pBq2trrCwsPavBrKysvuyBvazFfyzBre3t/61Bv+1Bri4uLu7u/+6Fu67QL6+vva8M8LCwvbBQsDFx//DNfvFQ8jIx8jIyMnJyf/IRMrKysvLy83NzfzNY/7QZNXV1dPY29fX1/7Xc//Xc9ra2v/Zg9zc3O7ctN3d3fbfq+Hh4fzgoOPj4+Xl5ejo6Orq6uzs7O3t7e7u7vDw8P/x0PPz8/b29v/24Pn5+f757vr6+v/67/v7+/z8/Pz9/f39/f7+/v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAj+AP8J/GdiAwQETpgMAZLjR5GBECO6+OCAQ5Q1jS6B0rMIjJqIEVuE+AOKEygoRKb0SHRpRxOQA0+siBHAwI0cRwBJYQlKB0yBHS4QAFCAEahLkG6wQKFFxc9/TzqBmgpqyZg7h/zA4RHkZyFQcrbQ8HTFzSBHlDZJEvIzjx0PEw4I8GGlCxlBUzO9fEoiQ4MIX8rQYZNmEqhHR57CSIGhwQxCmjTNKQxqj5GnOEpYWKAElCXCeKaGefoPh4gKCrh8CoSmD6ZPn7KQtgFCQgIvnPiYUcSpNxbSNUZQUJCkEiIxYt7EeXOGtIwSEhi8iBTJUJsv2OtcfqphwYAHSKoJaBk/nsoVkAEBADs=','image/gif'),(5,'application/vnd.oasis.opendocument.database','R0lGODlhFwAQAOfOABQwPSMuMhg3RjAwLSg0OBg5SRg6SjIyMBg7TBk7TBk8TRo+Txo/URs/UBxBUxxCVBxCVR1EWB5HWiVLXSZOYYQyAYQzAVtCMXY+GpE4AUFRV5Q5AZU5ATVXZ5c8BJs7AYlBFD5ZZp89AT9baUZZYjpdb6I+AaI/AUFea6ZAAT9hcUNgbqdCBKRFCkphbK5DAa5EAq5EA7NEAUdmdbRFAaVKEbJGBLNGA7ZGAbdGAbBJCbdIBEpqerdJBbFLDEtsfL5JAcFLAapTHcJMBK1UHlJxgMZSCsVUD7JaJMdUDq9cKbxcIbldJLFhMLViLsBfJMpcGrRjMcVeIGV8iKdpRLxkLsZhJKBtTm1+hsliIstiIcdjJ8NnLsxlJsloLsxqLc9tMXiIkLt2S7V5VXeOmc52QJWIfs54Q855RXyTn32UoMN/Va6GbdR7Rch/UryFY6KNgbeKb8SHYpCYnMaIYYyaoNeEUr2MbtSHWc6MZJOgptmMXbyWfsmScdiOYcuSb5Glrs6SbtqPYNqPYcKXfdSTa9STbK+flJeosdmVbNuWbKKoqtuXbdCbedOad9CcfNuZcdebddCeft6acdicd5+utt+ddKeustGihN+edaSzu+Chetujgdukgqyzt9ymhbyxquGmgt+nhM+slr+xqeKng8Syp7O4u+Oqh+Gsi7a7vd2xlce9tsu8s73CxbrGzMHExue5nOe5nem6ncvEwNXDt8TKzt7KvdPOy8/Q0OHMv9XQzdnSztjT0OnPwOjTx9Tc3/HXx/LXx/Pd0N7k5/Le0fXe0ePk5fXf0efl5O/s6vr6+v39/f7+/v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAjxAP8J/DeDggEAc+aECYMljJmBECMWCSFAwxxVyZY1s3Xs0qmIElcAa8as2RwzCo8twzIH5EAXPKYECICFZa85KpthcSlQgwMAM481W6YMiwsXi1zw/DenZLOnczzZAtYLVkOeI2EtwsLsitdRGZU9dGnLloYGQDGAUNLEQ5OMLZe6mAA0wy+NujxgUhbXZREedAd4IHTrVh8Pj3L1BTllRgQAFzzU8CBZr6el/6aogAAAA5VkxYola9JnEWbNPzE0YcaaGWnTSzU/gJxh1K9fmCqM+hh7xk8XYzKAAJGBTTJbi0FSAACAwBw9i6JHfw4yIAA7','image/gif'),(6,'application/msword','R0lGODlhFwAQAMQfAJSt6Ofq99Xc57rK8mR5rfn6/fP1+3CT6RM6VydNjylWpKSyu6e77HuX1xVGkVV3yWaI23OTykR13DRgse3v+Yij30ZswICc1QY4gnmNnVh91HKN0maBwV2C1v///////yH5BAEAAB8ALAAAAAAXABAAAAW/4PcdJAlBXac9j+VOYiweQ20zOAPsACzPA49wWCgWDb0fcCg0FgxQgEI5GjQ2mwejoCiwNJbKVAmx7ggeSGIA4EwuYmonWCEEKoA1Y4KgVBJyWw0cDBwSCQAWCRkUFw5UGlsbBBeHFm4IAo2PSloFHAeHAhqHjAGOVJ4PhwEUipkBAQ2cPxYMBgoJCwYUCggLsQERGFQWAFBQFMoUwcLESsbIy8zNw8U8ABXaFxcNEd/WShPjCuUJDugOGOvrPyEAOw==','image/gif'),(7,'application/vnd.ms-excel','R0lGODlhFwAQAMQfAPz9/ISsddvp2+v06425gHijaFGLOg1uDfX59URpL+Lu4nS1ay1QHFmkVJzHlGeVWHGbXufw51mCVqfQnbLWqjSHMVh8QkuVSPD38GGHTGarXy9RKzdcJUtyOV6TSP///yH5BAEAAB8ALAAAAAAXABAAAAW94PcRRBAUBfQ8WWa9XSfOIkFR0+TsZGkWMlqNAigaEUgMZgAUigJEIwCJUA6YQWFgAlhoNA+kZCwZQBLOT4F7oSwWHsmiUTkozumCo3iZeA10BxEKD2hOEHtIFQ4aDQl2CoSGQg8EVHQEHhccKwoeHGmVVQ1zB5mbAQKfaRmWDRuwGwdwm6qgThYBS1eDAbEbAgYMabm8g5ECycnCxAUDEccKysrMTh0oKSoPHtwG3tVCMR0J5OUc5wzpwzQhADs=','image/gif'),(8,'application/vnd.ms-powerpoint','R0lGODlhFwAQAMQfAK5JMvqnbOtyM//695E0Kv7ayGoVE+iSbPy5h7RcQ//m2f7z7f3RufDDjdVkLu2IVb1bK//u5dN4Wf3DpsNjSfmVV8ttUfeISeKGZfN/Qe6RSdqAYO+XXsFzWv///////yH5BAEAAB8ALAAAAAAXABAAAAXJ4PcdJIZtkmRRVJIAsCiLB2IHeFBV15VlAsBMVvMYj4PBYhkJDmkIz+GkWrUSTeETEzUmlcyIQkB4fjYBIyNBICQQEfG4/JSkGYDFwNBGMAwKDnRDdgMJeh4GEA8JCgoFgmYWFQMEGQ8HAA8cBBMGBRCDMxSUBA0NCA+bBAWtEAZmFBcLCRoNAaoZCZ6gsE8JGQt4GhwPGQAIrQyvZsBxDB1tHckFDHi+QwACco6tytYA2DPaAuUCDugQ6hAw4jIwAG3yBAb19u4hADs=','image/gif'),(9,'application/vnd.ms-project','R0lGODlhFwAQAMQfALTGs9Pb0+T45Ki0qfv++lBpT9jr2IyajXWVcoakhZukmpu1l2N3ZHiJeWyCab/QvkhaR/D38KbDoYCcf4+qjeTw5aK6nztUN+3+7JWvk4CUgEBZPVl1VmSAYW+Kb////yH5BAEAAB8ALAAAAAAXABAAAAXd4PdJ0jAoVJJoiOc4XMeJtEg+OCBZgLVYmQViVhMtHoSk4GEJJCMYTIZYXACSBJzmEKhEIgIKtZa5EgxMRiDw6GIohaIocY3gOo12ADAwwOUfdARsFB0BCicDBwsZcXITEhEDABwLGA8UGgweAH9yCBIADQ0doWiaCAYJEICgFgwaexkWFBkNAxirgA4LFQoKXQCaDA0GAhOscrwYEYcDAQMeDAMVBhMbgB0UXxEVAAcHEx4G5NeAHBkYAgJRBhYIANXHF+ceCRP4LC2jLwX0ch1kFBg4EILBgwaLhAAAOw==','image/gif'),(10,'application/vnd.ms-access','R0lGODlhFwAQAMQfALeQpcqYrnAhT6hykclokv77/te5xc+nuYxddujK1+OpwZdqhP/r+oQzYf/z/d/D0PHX6FETPPTr8t+Wsvbl631RZZdggvjn9bCBnu7o76Vgguny9c5+nff0+////////yH5BAEAAB8ALAAAAAAXABAAAAXP4PdNymEGAIANrIVYjSiLypM8j6GbR4AOsRkt4Sl6CgWH5OIoYoLCA9FYoOhSjwJGIBQdHkaPNRHQDBaJbfcTyB4LNgWBw6mkuN2AofA2TDgEgQIqeEIYBlQHdIENEQ9qXYdGZBMEDQIRAB0LhTMYB0cPAXQCFQsGDgwDEWsDBw4GAROXCBQOHRQMC6xdGgEQPhUVEA4UEscOu2u+EhWlCR0bFxIZErq8QggAHhAPGQUdHQzjDMnYMxYDGBgqLCwL8AuNaw31Avf4Efr75x8hADs=','image/gif'),(11,'application/vnd.visio','R0lGODlhFwAQAOfAABcZRBwkZBwlZB8maCIpbSIpbiUrcyUrdCcteSkvfywyhSwyhi4ziy40jDA1kTE2kTI3ljM5mzQ5mzY8nzc8oDg9ozs/pzZMpjRNrzRNsENQvENRu0BWtj9ZukFav05enENfy0dhxUtlzkxmyktmzk9i31NpwFVn4FVo4FFs2VNt2FBu4Ftu4lx102J142N44WJ63WN54WV82HN+sHN+sWh75XN/s3SAtnWBtm2B0XWCuHWCuXaEvHeEvXeFv2+C52+F23iGwHCD53uGwXmHw3mHxHuJx36KxHyLyn2LzHeK6X2Nz4GNyn6O0HuO2X6P0n+P0oOS0H+R6nuS83yT7H2T64GT4YCS636V7n+V7H6W84OX5oCX8oKY8YaY7YeY7Yeb6oma7Yec7Ymb7Yic8oud7o2d7Yye7o6f7o6g6Yyg74+g7pCi75yl0pOk8JSk8JSl8JWl8Jio8Zmo8qCr35ur8Jyr85ys8Z2s852t8p+v8aGw86Cx9qCy96Ky8qKy86Oy8qKz9qez6qyz4ay04q204KW19Ka19Ka19aO1/qW29qW4/6m49ay57qq59a2797G/9rW/8Le/7LTA87PB97jB67vE87rG9bvH+LvI+MPP/8vR8c3T9c3T9tPX+Nzg+N7g+eDg9eHl++Pl++bm+efm+efn+ebq/Ovq+urs++vt++7s+uvu/O7t+u7u+u/u++/v/PDw/PHw++/y/fDy/fLy/fPz/fTz/fP1/fX0/fb1/ff2/ff3/fn4/vr6/v3+/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEAAP8ALAAAAAAXABAAAAj+AP/9MwNIz504aL5cUfKjhgsWKEpoEEhRoB9FlCA9cnToD545cNicCRPDQkWKeij9wjWL1SlRvnqp2pLrFpQKJwXWgYTrEqZAXFb04pWKjq1aTSbk/Pfm0axMmhJhIbFLF6xJtWQlibAUDSNWfBZpkdFBV65ROWS9QgJhqRdDp7pMgWHiQs1Yn161MvJgqZQ9tBo5aRGlzdFPIFytKsJgqRI7MSuJ2XRUFihOq1AFUbBUiJyhlsh0yuoJkRpJpnokWFrDDS9dkaiASWMlT58sIwjtQLDUxRqzglSI8MABSJUUGZjgMLCURZlclV8pHhQCw5BQNggsPTHmVla9mUkxFToSqtSMAUtLvHiyJAkSI0R88NBxwwaNDwKWbrBQgYIECA40sEACCBxQwAABAHBSQAA7','image/gif'),(12,'application/x-mspublisher','R0lGODlhFwAQAOfpABIlLBY7RBY8RRg9Rho+SBo/SB1BSh1BSyBFUCFFTyRIVCZKViZLVidOWihPWyxRXS1RXi9SXy9TXzJUYTZaZjZbZjpfajtfajJmcjljbzRmbylwfUJqdDJ0gTd3hDd5hj1+ij99ikN/i0CBjFB+hkOEj1d9hFh+hFh+hUKHk1l/hVp/hVeBiFuAhlyBiEuIk12BiFCHk16CilKHklOIk0+KlVGKlF+FjFeIkleIk2GGjGKGjmGHj16Jj1iMlFiMmFSPmWOKkFyNl2SLkVuPml6OmWaMkmSOlV2RnGaOlF6RmmCRm2iPlFSXommPlVqVn2mQlV6UnmKTmlmXoGuQlmaTmmuSmFyYomySmGeUm2GXoWyTmmSWoGeVn26Um2WYomiYomuXoGqYomWapWeapG2YoWmapGSdpmacpmWdpmKfqGWeqHCaom6bpGWgqmegqXKcpGahqnCdpnGdpm+ep3qaoWuirHaepnGhqmqkrm2krHWhqnKjq3GkrXmhqHiiq3uhqnyhqnyiqXqjrHujrIKhp3imroWiqXmpsoijq4qjqn2ptICrtH6stnuvuYGut4Stt4KvuH+xuoWwuIWxuoeyuoO1vIizu4W2v4u0vJWwuIi2vou1vou2vYu3vo+3vo64wJK3voy6wpC5wJK4wJG5wJC6xJW6wJa7wpS9wpa8w5C/xpa9xZi+xpbAx5q/xZu/x5bCyZzAyKa9wqHAxZ3DyZ7DyKTCyaXFyqPIzqjIz6nIzafK0K/HzKzJzavL0qzM0q7L067N0rPP1LnU2LrU2LvV2r/W2b/Y3cbd4c/e5M/i5NTj6Nbj6Njn69vn7N3r7OHs7eLu8OTu7uXu9efv7+fv9Ofv9efx8uz09+r29+729+/39/D4+fX3/PX7+/f6+/j7+/T9/fn7/Pf9//v9/ff///j///z//////////////////////////////////////////////////////////////////////////////////////////////yH5BAEAAP8ALAAAAAAXABAAAAj+AP/9MxIIkJ87cNiUCdNlSREhOXBwEEhRICFTrViVGvWp0yZKkR41WjTmQkWKg2SVGxeuJbhw38SZI+dtS4WTAv/AwmXLlShHeZo84ZTMGzcrE3D+m4PK2CtkdiypWZMimKpQy5xEUCoHVTphv/Sck+YGBClnZHwxgaC0zal0vGq90XbszAZawEIU6uFAqZhS6XJhmhInzYcYxLT4qBNkgVIwoNDFQjRiD51byzy9IKGMhwKlXDKZW9VHRDFs0IYBUXKI2o0ESpFc6iYJjQczeHbxscGCmTUXBpQSqZTqSo0OGLJEKSEl0bVqKwgo/TFJFyNDghT1OlJFR7Nq004+DFBKA5JRbty2ZXumaRb4aCYEKJ3xxQsWKlCSDNkhA0YLFShoEIBSGVhAwQQSPNAAAwogcEABAwgQAAAnBQQAOw==','image/gif'),(13,'application/vnd.openxmlformats-officedocument.wordprocessingml.document','R0lGODlhFwAQAOeOAAAugQUzmBRGpyREoDVJYzZKZCtKqCRPnSFTxSVVpjNSsExUX0hXazpZuTBcwEBdmD5eo0JiwSxqz0lqyk1urkhvxVFx01NzwVJ10Ft2snR3fnR4flh52nd6fnl7fzuF2Xl8f3p8fl9/xFx/4F+CyV6C1mWKvniXznyY14GW4H+X4Xej63uk6ZOit3ql6JWkuX+n54Cn54+k2Zamu5movpWm5ISr5piqvIWs5oit5ZyrwIqu5JCu1pWs3Zytx4yv5I+x45Gx4pWz4p+w5pW04pyz66W0ypm24Ka2y6i2zZ243p6436e16KG63aq5z6u60aS73aW83K290q286a6+1LDA1rHB17LC2LbD67rF1MDW7Mfa+Mnb+crb+Mzd+M7e+M7e+dDg+dbh7dLh+tLi+tPi+tPi+9bk+tbk+9fl+tfl+9jl+tnm+9rm+9rn+93n9Nbq89zo+9Tr9d3p+9/q++Hq++Hr+9ru9uHs/OLs++Ls/Nvv9+Tt/OXt/Obu/Ofv/OLx+Ojw/ePy+enw/Onw/enx/ezx+e30/e/0/ez2++/1/fP3/vT3/vT6/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAj8AP8JFHjFShUqUp44SYLEyMCHEEdInDhi0aJDOgpAhKhiCpaPHzkwYoToRRaNG/9ZGMLEkcuXjkIoalGgZsoJNWoUKfEGhaEMJxjwKBQFCkqIEVKkaIRBBokeFG6A4DEITxMCKRsgQJCowoUDDh6I8cDDDx0lWDcqkCBBEAQRCQD4ANSBB585R9JCNPDhw54AWkwIgHNHaJ02QvQ+HMBYjuPHcjToiXMGiOKNCzZsYMCZMw81Y3ZchkgjEKFAf/rYiZOmDBgcox/OyKOHh+3bX7rEiD3wRRs3bNagMRPGC5ctLHgLbEFmyREiQX7ksAHDxQrl/who3859O8SAADs=','image/gif'),(14,'application/vnd.openxmlformats-officedocument.wordprocessingml.template','R0lGODlhFwAQAOerAAAugQUzmBRGpyREoDZJZDVKYzZKZDZLZTdLZjhMZitKqDhNaDlNZzlNaCRPnTpOaDpOaTtPajxQa0pPVz1SbSFTxSVVpj9UbjNSsEFVcEJWcUhXa0RYc0ZadEZcdjpZuTBcwEBdmEhed0leeD5eo1BheVJke0JiwSxqz1Vofllqgklqyk1urkhvxV1wh2tvdV9yil5zjmFzjFFx01NzwVJ10Ft2snF2fmV4kHR4fmZ7lml7k1h52mp9ljuF2Xt8f19/xH1+f1x/4F+CyV6C1neDk2+FoXiElHmFlXqGlmWKvtJ7In2JmYKOnYaSoX+XtniXzouXpXyY14GW4H+X4YObuY+aqJSeq4mgvZSfruyXO+2XO4+mwo+k2e2ZPO2aPO2cPJWm5O6dPJiqvO2ePe+gPJesyZStzpCu1pWs3e6iPZytx/CkPvCnP5+w5p+zzpu00/GqPpyz6/KuQKe16PKwQK+3wqa51POzQaa71/O0Qau+2K286bbBz6/C27bD67fI3r3N4fvMdfvOesDW7PvRgfvTivvWlMvd+czd+dbe6s7f+tDf+dbh7dPi+tXk+tbk+tfm+t3n9Nvn+9bq89zo+9Tr9d3o+uDr++Hr/Nru9tvv9+Xu++bv/eLx+OPy+enw/Onw/erx/ezx+e7z/e70/ez2+/L2/fT4/vT6/Pf6/v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAj+AP8JHKgHT505cdqwKSPmy5YlAyMKFEKxopBDhwwVGiQIokSBVPj8GTmShxo1ZMB40eJR4gw3dFbJnLkqiCpUpQJB+PhvRZgwcohIkjLKBpQNaNCIAvSA54kpU1LV6DIkDYsxP06h6eSnAc8PFSqYakHDAYgQjTaQQpMpDwOeGFCg+EQCiAUAazxtCIWmEpwFPBX48LEpACElAihpQorm0ZkEPAdItkS5sqUbkyAxegKZp8AJL3JsGD06aaIYCDwLzKIIFCdMlyI5WoQohpEDnu1csRLFSRMmSZAcKVKEiw4DnvvAMPKkChYuZt7c2cMlhh8CqkuUMJFChQsZOHYY9Ojx5EwB1QL7jBDhoQMHDRkuUJAQQWJAADs=','image/gif'),(15,'application/vnd.openxmlformats-officedocument.presentationml.template','R0lGODlhFwAQAOeVAKQXCMcSANUWAK4iEDZJZDVKYzZKZDZLZTdLZjhMZrouGDhNaDlNZzlNaDpOaDpOaTtPajxQa0pPV9EuGD1SbT9UbkFVcEJWcUhXa0RYc8U6IkZadEZcdkhed0leeFBhedRENlJke9NIK1Vofu9GG1lqgl1wh2tvdd5UNd9UN19yimlxfV5zjmFzjGtzfW1zfW50fXB1fdxbSmV4kHJ3fXR4fmZ7lml7k+pfPWp9lnl7fv1hK3eDk2+FoXiElHmFlehsTHqGlvRrRdJ7In2JmYKOnfx0S4aSoe59Wn+XtouXpYObuY+aqNaLhpSeq4mgve6OdvGPd+yXO+2XO4+mwu2ZPO2aPO2cPO6dPO2ePe+gPJesyZStzpCu1u6iPfKcgt2gnPCkPvCnP5+zzpu00/GqPvKuQPKwQK+3wuaqpKa51POzQaa716u+2OWyrrbBz6/C2+65s7fI3u3Avr3N4fvMdfvOevvRgfvTivvTjPvUj/vVkfrRz8vd+czd+c7f+tDf+frZ19Xk+tbk+tvn+/vh4Nzo++Hr/OLs/P3q6ebv/enw/erx/ezz/e70/f7z8vL2/fT4/vf6/vn7/v76+v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAj+AP8JHOhlzRkzZcSE0YLFypQhAyNG9LJHTx48GPHcsVMHosSBRkKKNJKl5JUqUjx+jBJnjkuXQiZJkhTJEZ0HH//hSOOmks+flTB06cJIjoOcKMCAoUTpCxJKT3VAaqQIToOcIpo0eQQFCJBHYIV2OcSGQU4NAgQkSsGWbaIaixAZIrMgpwISJArJmMBXRiGxgrgkyDlgx45AgUAEAIH4BaFBgJIM/gigMp/LmPmI9cMCQc6BEk7UoBEDhosVf/qw6HHgMxonTJQcKUIkyA8fPHhQsWHg8xsVPZIseUJlyxg1baiwgEPg878PH0KMKGGixYwbOXIk4VLAucA3HjoNcNiQ4YKFChQiQJAYEAA7','image/gif'),(16,'application/vnd.openxmlformats-officedocument.presentationml.slideshow','R0lGODlhFwAQAOeFACFEjCJHkjVJYzZKZDdNaCdQpTxQaXw4sDxSby5YrUBZeUZZckZZc0Vgg1FifDpjt8FMGsFNG0tojT5ou0BpvVdpgkVuwFFvljly4lV2n1l7p0p+41x/rGOP5W+X54eWs3Ga6Hac6Hec6Haf7Hej63uk6ZOit5WkuYCn54Sm6pinvYCq7mTJGIWs5pyrwJyswIqu5JCu1oiu9Y+x4+WigpWz4oy086W0yqa2y6i2zZ243qG63aq5zzzqLqu60aS73bG6xq290pq/+KPA+LDA1rHB17LC2LrCzKjE+rrF1KfK/MTK0rDQ/83T2MLV9sPV9rXkmsfY99PY3Lvnmsfa+Mnb+crb+Mzd+M7e+dDg+dHg/9Lh+tPi+tPi+9bk+tbk+9fl+trm+9vn/9zo+93p+9/q++Hr++Hs/OLs/OTt/OXt/Ofv/Ojv/Onw/Onw/erx/ezz/O3z/e30/e/0/e/1/fD1/fL3/vP3/vP4/vT4/fT4/vX4/vb6/vf6/vj7/vn7/vr8/vv8/vv8//z9//7+/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAjuAP8JHGikCJEgPnjkwHFjoMOHAo0UIjQIEJ87clwMgDhwgcePH/3koXMiyUaO/1RIabLkCJAFgWLINDGgJkoVU3pA+fBhgaA+eOa0OfPjJEQVB1hEEKPFwB+ZMsvsEHDzHwQagwYJ6KNnzps0ZHRQRVnBAQMDW6HKDFNjLMp/DPbssVMHDhs0Y7zMcMuRwQsGdOKojbEFBl+OIaK4WaPGzBgwXLC0OPwwxRAPT8oMtoKC8kARSGSA6ODkS5csV6pQKeH5X4gHFEZMSFCACRMlQmysINFa4AYLAThw0JDhgoQGChAQePsPQwAAzB8GBAA7','image/gif'),(17,'application/vnd.openxmlformats-officedocument.presentationml.presentation','R0lGODlhFwAQAMZwAKQXCMcSANUWAK4iEDVJYzZKZLouGNEuGExUX0hXa8U6ItRENtNIK+9GG95UNd9UN9xbSnR3fupfPXp7fnp8fv1hK+hsTPRrRfx0S+59WtaLhnej63uk6ZOit+6Odnql6PGPd5WkuX+n54Cn55amu5movoSr5oWs5oit5ZyrwIqu5JCu1oyv5PKcgt2gnI+x45Gx4pWz4pW04qW0ypm24Ka2y6i2zZ243p643+aqpKG63aq5z6u60aS73aW83K290q6+1OWyrrDA1rHB17rF1O65s+3Avsfa+Mnb+crb+PrRz8zd+M7e+dDg+dLh+vrZ19Li+tPi+tPi+9bk+tbk+9fl+tjl+tnm+9rm+9rn+/vh4Nzo+93p+9/q++Hr++Hs/OLs++Ls/OTt/OXt/P3q6enw/Orx/e30/e/0/e/1/f7z8vP3/vT3/PT3/vT4/f76+v///////////////////////////////////////////////////////////////yH5BAEKAH8ALAAAAAAXABAAAAfggH+CgiVDQkA/PDs2NTODj5AYkpMYa2tnKQWQkCBFRp+fF21taCFEmpt/EjlBcK6vcBRpHQW1qQ4uLm9vLRlvvgkrKz49qJAMGhpqHhYWas8TaGVfOgSpCgICZA/c3GTBK1031psGDQ1aEAfrEFoTZmJcNOSQAxUVT08LAQv54Fgx6D0CQFCJwYNKIoTZMuWFwE0IJkxIMDEBOCcqHkIq4aYjmzFetlSJwuSExkckwIQJJ6xlkhEnB4XAkuWKFSpSmixBcoRDTEEdoOCgIQMGCxQmRHzY8PMPgadQo0KFFAgAOw==','image/gif'),(18,'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','R0lGODlhFwAQAOeEADVJYzZKZBdjFxJlEx1sHRZ5GSN3I0tvOkh2NiqDKmdscmZtdkx8PUx8PxqRGzKOMk+FP3B1fXF2fnJ2fnN3fnR3fnR4fkOOPz+QP1WJTHd6fnl8f3p8fjmaOj+lP26bZEWuRVymW12rYV2sY0u3S2OuZ26ra3ej63uk6ZOit3ql6HG0cZWkuX+n54Cn55amu3G5epmovoSr5oWs5oit5ZyrwIqu5JCu1nDCcIe5iYyv5I+x45Gx4pWz4pW04pK+jYbEhqW0ypm24Ka2y6i2zZ243p6436G63aq5z6u60aS73aW83K290q6+1JLOkrDA1rHB17LC2JrSmrrF1KTZpa3ersPdvsfa+Mnb+crb+Mzd+M7e+czmwdDg+dLh+tLi+tPi+9bk+tbk+9fl+tjl+tnm+9rm+9rn+trn+9zo+93o+93p+9/q+9bx0uHr++Hs/OLs++Ls/OXt/N7z3Ofv/Ojw/enw/erx/ef24+30/e/0/d3/x+/1/eL/0PP3/vT3/un/2/D/5vb/8fz/+f///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAj5AP8JFBgFypMmTJIgITIkyMCHEElInEjCj588NQJAhIiDSpWPH0H8+aOHxRSNG/95cCKFkMuXhDjwSRGgZsoOQIAMEmFiUA4MgxbcuLFECUqID1asEISnxIUMcwRt0HPjzREAKRMMGBCoDYwRCKwEEnqDTRGsGw0UKAAIQoMfIRgA0nDnxhohaCEScOCgj18uHw70IWumR96HAhLvWcx4T4U4acLsOLxRgYXLFCZEkKDmhhcblCHGqGOnDh05bm6MubFlRuiHL+AMHXpmdhYXrweyMIOmDBkxYLpowXIFRW6BKb4YEeKDhw4aMlqoOHH8H4Dr2LNjhxgQADs=','image/gif'),(19,'application/vnd.openxmlformats-officedocument.spreadsheetml.template','R0lGODlhFwAQAOejADZJZDVKYzZKZDZLZTdLZjhMZjhNaDlNZzlNaDpOaDpOaTtPahdjFxJlEzxQaz1SbT9UbkFVcEJWcR1sHURYc0ZadEZcdkhed0leeBZ5GSN3I1BheVJke0tvOlVofkh2NllqgiqDKmpsb0x8PUx8P11wh2lvd2tvdRqRG19yil5zjmFzjGtzfW1zfW50fTKOMk+FP3B1fWV4kHJ3fXR4fkOOP2Z7lml7kz+QP1WJTGp9lnl7fnt9fzmaOneDk2+FoXiElHmFlXqGltJ7In2JmT+lP4KOnW6bZEWuRYaSoVymW3+Xtl2rYYuXpV2sY4ObuUu3S4+aqGOuZ26ra5Seq4mgvZSfrnG0ceyXO+2XO4+mwu2ZPO2aPHG5eu2cPO6dPO2ePe+gPJesyZStzpCu1nDCcIe5ifCkPvCnP5+zzpu005K+jfGqPobEhvKuQPKwQK+3wqa51POzQaa71/O0Qau+2JLOkrbBz6/C25rSmrfI3qTZpb3N4fvMda3ervvOevvRgcPdvvvTisvd+czd+dbe6s7f+tDf+czmwdPi+tXk+tfm+tvn+9zo+93o+tbx0uDr++Hr/N7z3OXu++bv/enw/Onw/erx/ef24+70/d3/x+L/0PL2/fT4/un/2/f6/vD/5vb/8fz/+f///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAj+AP8JHEhHzhs3bNCcCfOFS5YhAyMKhEKxIhRBGAH96QNRosAye/yIFIkEjEkvW7B0lFjETp5RMGOO4vGpUyY+Cjz+69GmjSgmU0SZwSHKBBkyl/Qk0PniypVQmKTUyCEp1A5OZCjhQaAzRIMGoB51cfIhECijZCLNOaBTQ4YMnmCQWKNkhCcalsg0UmNA5wQUKDYJRnSkwya0isYU0MmgsabHkDW1YETm0JLFOgWKOEFjRgwXLNASUkEgs0ArhSpNguRoUSJDg1T8GJAZDpUoTZIYISIkCBAfPrTYEJD5ToofS55U0SImTZw6WlTgAWB6wwYOHkCUWCHjhg4dS8YUBDAt8A6GCxYqUJAQAcIDBwskBgQAOw==','image/gif'),(20,'image/gif','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(21,'image/jpeg','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(22,'image/png','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(23,'image/tiff','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(24,'image/bmp','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(25,'image/x-ico','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(26,'image/x-psd','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(27,'image/x-freehand','R0lGODlhFwAQAMZlAFWGLFqLMaF4MWCRNk6XTmaXPHCLuGudQnWSwF6oL3mTuXCiR3iVwniVw2OqMXqVwHqVwXiWw3mWw32XwWymZX6ZxGqtOX6axX+axn+bxH+bxX+bxoedw4Sex4SfxXeuWISfx4WfyIefw4afx4Wgx3W0OcyeT4mqy4mu0ovAQJC8Xo2y1o3CSJXERZG32pq30pnHT5zISKm40Z/KSp3KU5u93p6+3K691r6+vqjPWq7H37HI3LvP4cjZ58zb6ebm5ufn5+np6erq6urr6+vr6+zs7Obt9+bu9u3t7eju8ufu9uru8uzu8Ofv9e/v7+nw9+zx9+3x9vHx8fLy8u7z9+/z9/Pz8+/09/D09/D0+PH0+PT09PD19/T19/X19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/OISFhoKIg2BjZI2OYDiJg2NbXpZSTkFkQJF/ChwIGxEYpBkyQmRfW5EiQ12vsEkeRI5kOA1dPiozLR87TyFSRUI/thJcPTE5NCUvTRleU05Itg1XPCkwLA4nSiRgX1ZT1VQ6FBYJBCjeYmFfX7YRUDY1JgIuK0caY2FhYLYMoiw4UGBAAABGLogRA+YfjgdMtGTBUqXikhELF9oyMAECiAogOnTwcGOMSUadcNRa6ShlGJa1wqQ0RNNQIAA7','image/gif'),(28,'application/illustrator','R0lGODlhFwAQAIQfAOKSsbGxsapKg/Hx8ZBNcOvr69ZimNfX1/Da5KKioklHQI2Njfv7+8djlL5UkNlamNB1pOGkxON+msxViOzK3MDAwOLh4clEi8dPkfrt9Pfi6uBwmvb29iYmJsfHx////yH5BAEAAB8ALAAAAAAXABAAAAWp4CeKR2CeZjGu7Ocx3DAUVmUFVtt6c+FbCcYtpxvxZL0FQxhQFV0xZCGxqCYOTyhyAEBELJ5FJevhmBsUDARjgBzGz5cZMnFgGhMAJUDmaGITAg4SBhEXfHESFxcQEBsYDxsGBohFLxQQD5EEAgYbG5U6HggNBAQSDgoEBoShOxoRAAICEgQNAA0NriwvGQYNEg0ODg0GD7srL7ACwhizEcdZFSjUJnAjIQA7','image/gif'),(29,'application/zip','R0lGODlhFwAQAMQfAPveavzxkPzysNq6MIvH9iRgsbF6E3e69/b89pS330yL1WKp6zyC0fv1y9WpHvzUOVun8HSk4Lzd+WW1/9SkC3Wx51GY4s+hDt61AfEZAejRh2+f2gRLsCdpx////////yH5BAEAAB8ALAAAAAAXABAAAAWL4CeOI3Gc1bKQ7KddsLYgUk2YSjteWX91wCADYuHoPpeBcrk0eCoVo84RaAiugSzAmSBIW1SENQAAPDBc75E6Lj/O6S+LLSCb4Z6unMTW3tF5ajoUAQ4OFxSJFIAJUUcGkJBBQRsVEHtHMxMTJwcQDEc6Cx0FpQWYoSwqqUcWERsWCgoMqK02lkUsIQA7','image/gif'),(30,'application/x-rar-compressed','R0lGODlhFwAQAMQfAPveavzxkPzysNq6MIvH9iRgsbF6E3e69/b89pS330yL1WKp6zyC0fv1y9WpHvzUOVun8HSk4Lzd+WW1/9SkC3Wx51GY4s+hDt61AfEZAejRh2+f2gRLsCdpx////////yH5BAEAAB8ALAAAAAAXABAAAAWL4CeOI3Gc1bKQ7KddsLYgUk2YSjteWX91wCADYuHoPpeBcrk0eCoVo84RaAiugSzAmSBIW1SENQAAPDBc75E6Lj/O6S+LLSCb4Z6unMTW3tF5ajoUAQ4OFxSJFIAJUUcGkJBBQRsVEHtHMxMTJwcQDEc6Cx0FpQWYoSwqqUcWERsWCgoMqK02lkUsIQA7','image/gif'),(31,'application/x-tar','R0lGODlhFwAQAMQfAPveavzxkPzysNq6MIvH9iRgsbF6E3e69/b89pS330yL1WKp6zyC0fv1y9WpHvzUOVun8HSk4Lzd+WW1/9SkC3Wx51GY4s+hDt61AfEZAejRh2+f2gRLsCdpx////////yH5BAEAAB8ALAAAAAAXABAAAAWL4CeOI3Gc1bKQ7KddsLYgUk2YSjteWX91wCADYuHoPpeBcrk0eCoVo84RaAiugSzAmSBIW1SENQAAPDBc75E6Lj/O6S+LLSCb4Z6unMTW3tF5ajoUAQ4OFxSJFIAJUUcGkJBBQRsVEHtHMxMTJwcQDEc6Cx0FpQWYoSwqqUcWERsWCgoMqK02lkUsIQA7','image/gif'),(32,'application/x-gzip','R0lGODlhFwAQAMQfAPveavzxkPzysNq6MIvH9iRgsbF6E3e69/b89pS330yL1WKp6zyC0fv1y9WpHvzUOVun8HSk4Lzd+WW1/9SkC3Wx51GY4s+hDt61AfEZAejRh2+f2gRLsCdpx////////yH5BAEAAB8ALAAAAAAXABAAAAWL4CeOI3Gc1bKQ7KddsLYgUk2YSjteWX91wCADYuHoPpeBcrk0eCoVo84RaAiugSzAmSBIW1SENQAAPDBc75E6Lj/O6S+LLSCb4Z6unMTW3tF5ajoUAQ4OFxSJFIAJUUcGkJBBQRsVEHtHMxMTJwcQDEc6Cx0FpQWYoSwqqUcWERsWCgoMqK02lkUsIQA7','image/gif'),(33,'application/x-compressed-tar','R0lGODlhFwAQAMQfAPveavzxkPzysNq6MIvH9iRgsbF6E3e69/b89pS330yL1WKp6zyC0fv1y9WpHvzUOVun8HSk4Lzd+WW1/9SkC3Wx51GY4s+hDt61AfEZAejRh2+f2gRLsCdpx////////yH5BAEAAB8ALAAAAAAXABAAAAWL4CeOI3Gc1bKQ7KddsLYgUk2YSjteWX91wCADYuHoPpeBcrk0eCoVo84RaAiugSzAmSBIW1SENQAAPDBc75E6Lj/O6S+LLSCb4Z6unMTW3tF5ajoUAQ4OFxSJFIAJUUcGkJBBQRsVEHtHMxMTJwcQDEc6Cx0FpQWYoSwqqUcWERsWCgoMqK02lkUsIQA7','image/gif'),(34,'text/plain','R0lGODlhFwAQAKUzAKWlpaqqqqysrK6urq+vr7GxsbS0tLi4uLq6ury8vL29vb6+vsDAwMLCwsPDw8bGxsfHx8jIyMrKysvLy83Nzc7Ozs/Pz9PT09TU1NXV1dbW1tfX19nZ2dvb293d3ebm5ufn5+np6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////yH5BAEKAD8ALAIAAAAQABAAAAaKwN9vQSwahciha8ZsylyL5DCmWllPpZAMFEUuZK1Xq5UyiWQsVXcoezEQBkIAIKvLut9YPeZanUYiH3dCXzIQDQsHBgUDAiSDbHZ7LiwpKJCFFRIPDgwKCQgsmJJ2MS8vLqMyGhcWFBMREQ+peJIxMTC5uaoeHRwbGRjCerWkxngvTU52L3hGz0ZBADs=','image/gif'),(35,'text/html','R0lGODlhFwAQAMZ1AEWJwGWVVk+RwGqZWU2YvG2cXGudWWyeWmyeW1KlZGyfWlahim2fW26gXFCh02ajg2elolil1VmmzX+nalap4Ver23yrdICrcoCsbIGrc4GscoGsc4Ksc2OuyISteGis2YWud4WueVW5nIaveG6uzmq1qoiyfIKzhFvDYWq0zIq5bWe8t424eIu1pnC8wI22u5a6e5K6kXzFdEXaX3rA1prDf5vDhZ/CiHfIxYTD2mzPrILGyozD0VvbfaPEkY7Kr3HWk6jFn6nFn729vanIj6LKmqvHoavIoavIonnZlZ/LuoPVsKHRjaPXlJHfi5rV2J/bj8LUu4znoaPb27zaubXc1MfZwcLirtLdzb7k1NPfz6vxu7rsyb3q1dnk1Nrm1ubm5ufn58/yzenp6erq6uvr6+zs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////yH5BAEKAH8ALAAAAAAXABAAAAfXgH+Cf0OFhoeDiYqEcHN0j5BwQ4uLQ3NtbplqaGN0YZOUg0NHGgwbQlppZHRvbaChAz5UVUonI1FlkHSvig1XYllTOTxFIFhmZGC7lAc2W1xPNCtAThhBa2hny4sMTVJdKTg9Myg3GW9sa9uKDFBJOxIuOiIJRAhxb2/riQpMSx0VHAAQ8AAGhzhx4OwbdICFjBIRKBBYYKKAETlwFPJKZKDGDxIfIKiY4MGLnJMLEwWw0OJFjAMhrMyZ6WhjoiFGLiDYgOSLrkc2RcX5+TNOUEGHkiZVFAgAOw==','image/gif'),(36,'text/css','R0lGODlhFwAQAKU+AM+oKM+vRL6+vvTBLPPDKfTDMvTDM/XHMPfOUffPTffQTPbQVPbPYfjSUvjSWffTdvfWZ/jXZvjZYvnYavfXhffZcvjac/nZevjadPndgvndg/neg/jei/rgi/rgjPjiqubm5ufn5/novOnp6erq6uvr6+zs7Prtxe3t7fjuy+/v7/Dw8Prw1Pvx0PHx8fLy8vPz8/T09PX19fb29vf39/v47Pz47Pj4+Pn5+fz69Pr6+vv7+/z7+fz8/P///////yH5BAEKAD8ALAAAAAAXABAAAAakwJ/wJygaj8Okknjb9Z7Qm2C5FOxisqxLNeqFptShoEfD0WiwFak3i4HDglYKZ569StDeu1qBPHc3Mi4mJCB6YT8BEQ4cJzmAMi8qKIdLEhMWHRkIBQ89gDMwL5VLDRgeGgsMPE86ODMzpEsKGxcDLFA7dDeySgkHBAYiO8Q6Oje8e0oANjUUH8XGxr1JY3nE2E7K1XndUNtiON55OOBCR+joSkEAOw==','image/gif'),(37,'text/csv','R0lGODlhFwAQAKUzAKWlpaqqqqysrK6urq+vr7GxsbS0tLi4uLq6ury8vL29vb6+vsDAwMLCwsPDw8bGxsfHx8jIyMrKysvLy83Nzc7Ozs/Pz9PT09TU1NXV1dbW1tfX19nZ2dvb293d3ebm5ufn5+np6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////yH5BAEKAD8ALAIAAAAQABAAAAaLwN9vQSwahciha8ZsylyL5DCmWllPpZAMFEUuZK1Xq5UyiWQsVXcoezEQMULgJKvLut9YPeZanUYiH3dCXzIQDTIHBi4DAiSDbHZ7LiwpKJCFFRIyDgwxCQgsmJJ2MS8vLqMyGhcyFBMwEQ+peJIxMTC5uaoeHTEbGTIYGHq1pMd4L01Odi94RtBGQQA7','image/gif'),(38,'text/xml','R0lGODlhFwAQAMZHADl4z0SS2FWQ4F2U4WWV4Vma41ec42eZ41+c5FWf5Vqe5Geb42Gg5Vik5WKi5WWj5Ven51um5l2o6GWn6Fur6Wio52Wp6Gqq6GKv6Gau6XCw6nGz6mq163Wy6We37HG16nK263K363m47Ha77L29va/F7bDJ7dHf9NLh9ebm5ufn5+np6erq6uXr+Ovr6+zs7OXt+O3t7ebv+erv9u/v7+vw+PDw8Ozx9+7x+PHx8fLy8vPz8/T09PD1+vX19fT1+Pb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAAAAAAXABAAAAe6gH+CfySFhoeDiYqEQkVGj5BCJIuLJEU8Ppk5NCtGKpOUgyRGQUNBQTs2LEZAPKChJD1Ds0FAOi6QRq+VGxhGHiE3PjkvLCm6oX8BIBZGHCMaMz46NDHIlBQfEzBGMhkfEiZAOzrXihAiDSeQKBEdCj9AQOaKCRcILUYwDhcGJbNC6CkC8GCAEQYVFtQgQkRIwF2KSBAQYKTAARwMMwpMNCpXkY8gN4rKRRISRI5DSuYaclLUoZeIEgUCADs=','image/gif'),(39,'text/x-sql','R0lGODlhFwAQAMZCAJOTk5SUlJaWlpeXl5qamp2dnZ6enqKioqWlpaampqenp6ioqKWqpaurq6urrKysrKysra2tra2urqyvrLCwsLGxsba2tre3t7i4uLy8vL6+vr+/v8DBw8LCwsXFxcbGxsjIyMrKysvLy8/Pz9DQ0NHR0dTU1NXV1dfX19nZ2dvb2+Li4uTk5Obm5ufn5+jo6Onp6erq6uvr6+zs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAAAAAAXABAAAAfWgH+CfwsDAYeIh4OLjH8DPUBBkpM9CI2NAUA6O5w3NTBBLgmXgxwNGRgbJTM5NjFBPDoLpBImND5ANikXPDgyk0EBlxM7Org8PAs9OzczMS3Blww4KSwrIDcIQMs4NTTRjRE9KjUkJEIHQds8OTjgjA4uJzUiIkIGkj8+yO+LEC6rPHwQQkASEB8+evQbROEFihUhRggBAATIjx89FAprVKFDDBs4ZoQoYPHixYWDLBR4oCCBBhsVY0baeCkAsJuTaDYS4AMnMB8DSP1RICCR0QADFDAKBAA7','image/gif'),(40,'text/x-java','R0lGODlhFwAQAMZMAI9QNZJVO5RYP5tkTJxlTp1mT55oUXt7e6V0X42NjbKIdraQgKOjo7+ekK6ursWpnbCwsLGxsbW1tbe3t7m5uc21qrq6uru7u7y8vL29vb+/v8LCwsPDw8TExMbGxsjIyNbFvsvLy8zMzM3Nzc7Ozs/Pz9DQ0NHR0dLS0tPT09TU1NfX19vb293d3d7e3uDg4OHh4eLi4uPj4+Tk5OXl5ebm5ufn5+jo6Onp6erq6uvr6+zs7O3t7e7u7u/v7/Dw8PHx8fTx7/Ly8vPz8/T09PX19fb29vj4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAe+gH9/GYSFhoKIg0dKS42ORxmJg0pERZZAPjhLNpGIGSUkIyEhHysxS0ZEnR0tNzc4NzY0JxmajRkaPxUDAQAAAgYPLxk5NUsZDkJBDQoEBQgLIDkSPjzHFElHPkU93Tg0NBZDQscbSzIXMzIxLigyKipGRtdHJB4wLy0rKDsRM0hHjv0hwYJEDRoxWtBAwaHIkYCdGJjgwUNHDBEYeCTZKHAQiQkTJEBIMUSJSUadMjhayTIlEpYskaQ0RNNQIAA7','image/gif'),(41,'application/pdf','R0lGODlhEAAQAMZHAMAWEMoVDs0YEdo4Ld9QRttVT99VTOZeU+JlXeVpYOpoXehqYOFsZeRuZud1bex2bO52aeV5cuR8duR9d+WBeu5/dPF/c/GEeOaHge2cl+mgm+ujn/Kmnu2rp/Otpr6+vu+4tPO/ufHDwPLLyfXQzPTV0/fW1Pba2Pfc2vfd2/je3Obm5ufn5/jl5Onp6erq6uvr6/fp6Ozs7Pnp5+3t7e/v7/Dw8Pnu7fHx8fTx8fLy8vPz8/fz8vT09Pnz8/X19fb29vf39/j4+Pn5+fr6+vv7+/z8/OrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAQABAAAAemgH9/H4SFhoKIg0JFRo2OQh+Jg0U5FyE/ODUuRiyRiB9GPBYkQTs2L0ZAPZ6DRkMQHEFAOjCORp6gRRUeRUKYMi8rt4KgRgoPRr0/OjU0w60qBwsmyUJAOzrPoA4ZKQkoRkRDQEDaMwYtJw0DBAgRHULaExQgGyIlGAwSGvGeGwU3GhUpQoRIDB9EhhUoMMLWwIeMPizcYKuiI1xDLNoagsuQR0OBAAA7','image/gif'),(42,'application/rtf','R0lGODlhFwAQAKUzAKWlpaqqqqysrK6urq+vr7GxsbS0tLi4uLq6ury8vL29vb6+vsDAwMLCwsPDw8bGxsfHx8jIyMrKysvLy83Nzc7Ozs/Pz9PT09TU1NXV1dbW1tfX19nZ2dvb293d3ebm5ufn5+np6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////yH5BAEKAD8ALAIAAAAQABAAAAaKwN9vQSwahciha8ZsylyL5DCmWllPpZAMFEUuZK1Xq5UyiWQsVXcoezEQBkIAIKvLut9YPeZanUYiH3dCXzIQDQsHBgUDAiSDbHZ7LiwpKJCFFRIPDgwKCQgsmJJ2MS8vLqMyGhcWFBMREQ+peJIxMTC5uaoeHRwbGRjCerWkxngvTU52L3hGz0ZBADs=','image/gif'),(43,'application/x-shellscript','R0lGODlhFwAQAMZKAFNTU1xcXF5eXmBgYGVlZWlpaW1tbXJycoGBgYKCgoaGhoeHh4iIiIqKiouLi4+Pj5mZmZqampubm5ycnKCgoKGhoaKioqWlpaurq7GxsbS0tLW1tba2tre3t7i4uLq6ur29vb6+vr+/v8DAwMLCwsTExMjIyMnJycrKysvLy9LS0tTU1NXV1dbW1tjY2Nra2t/f3+Dg4OHh4eLi4ubm5ufn5+jo6Onp6erq6uvr6+zs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAepgH8hg4SFf4eIIUVISY2ORSGIhyFIQUKXPjw3STWRiUlERkREQD04SUNBnoJJRq5EQz85jkmeIUmMuEVCPjo4NLWTtLpCHxo7way0MCE4IyExGQ/CtB8vIi0uHisM1I4tKhgIDRooCd5J5TYKR0URMxwLyo0XHTITR0cSLBAE86gpToCYEGEDiQHoklA4cQEFiQolDEwyQmtDgRYWHJgQAGBSoUIHAkgKBAA7','image/gif'),(44,'application/x-perl','R0lGODlhFwAQAMZKAFNTU1xcXF5eXmBgYGVlZWlpaW1tbXJycoGBgYKCgoaGhoeHh4iIiIqKiouLi4+Pj5mZmZqampubm5ycnKCgoKGhoaKioqWlpaurq7GxsbS0tLW1tba2tre3t7i4uLq6ur29vb6+vr+/v8DAwMLCwsTExMjIyMnJycrKysvLy9LS0tTU1NXV1dbW1tjY2Nra2t/f3+Dg4OHh4eLi4ubm5ufn5+jo6Onp6erq6uvr6+zs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAIAAAAQABAAAAepgH8hg4SFf4eIIUVISY2ORSGIhyFIQUKXPjw3STWRiUlERkREQD04SUNBnoJJRq5EQz85jkmeIUmMuEVCPjo4NLWTtLpCHxo7way0MCE4IyExGQ/CtB8vIi0uHisM1I4tKhgIDRooCd5J5TYKR0URMxwLyo0XHTITR0cSLBAE86gpToCYEGEDiQHoklA4cQEFiQolDEwyQmtDgRYWHJgQAGBSoUIHAkgKBAA7','image/gif'),(45,'application/x-revelation','R0lGODlhFwAQAMZwAAAAAAAAAQYJCgUKDgcKDAMMEwYNFAcNFAYRHA0XIBEYHQ0eLwofNR0jKB0lLR4nLxgqPBYzURw1TC4yNSk2PzQ9Qzc9QCBCZDs+QTpARDlDSylJaD9FS0NFRi1MZ0BLVENPVzNVc0pQVFBTVV5VMj5deURif1deYUlsi0xwkWtra2lsb11wfVt6lWKCm2mGmX6FiXmXr32Xrn2Yq3ufu4CetoGhuYGju4SkvImnvYunvY6nvJuor42txZKwxJmyxpS1zJu2yZu2yp22yZe40J23yqS5yK+4vqK8zaG90au/z6nB0arC0ra/xb+/v6/E1K3F1a7F063F1qvI26zK3rLP4rvS4LzS4cDR3b7T4LzV58bS3MXW4sLX5sfW4r/Z6cbX48TY5O7WgMjY5MjZ5Mfc6cvc6M3c6NLe5dbg59Xk7Njk7Njl7tnl7dzp8e3t7f///////////////////////////////////////////////////////////////yH5BAEAAH8ALAAAAAAXABAAAAe2gH+Cg4SFhocaJyMdGBwPh5AZK0dtbmZeTRMKkIQWMGlqZV1ha2xbIAKcfxQiaGRZX1pXXGNnRg2qHzxYSVNVVFZgT0pQLACcFTI1PUBEJADQUUEzAZwOOjk3NCRiYm9v0OGQCSlDUjgAAODf307HhwkoP0tMAE4q3+npnAMSLkVIWthz56MEgneQDmwQsiOEOgAxbDCopgqAgRcmLjz0AGGfqj8ACCyIYA9AAY8fBenTl7Ilp0AAOw==','image/gif'),(46,'application/x-argouml','R0lGODlhFwAQAOfUACtQfy5TgjFWhDVaiDhdizldizlejDpfjTtgjjZhmzdinTlimjdjnjpjnDxjmjxkmDtknDdloT1lnT5lnDxmnj5mnTtnoj5nnj9nnT9on0Bon0Fonj1po0BpoEBpoUFpoEJpn0Jqn0RroEFspTdvp0VsoTVxqUZtokdtokduokdvpUhvozhzq0lvo0ZwpUlwpEpwo0pwpDx1rExzpk1zpk50p091qEB5rUx2rVB2qFB2qVF3qVF3qk14rlJ3qk54rlN4qFN5q1J6rUd+rlN8r1p7p1R8r05+r1Z8rVd8rFZ9sFh9rVh9rlZ+r1d+sVl+r1KAsVd/sVp/r1t/r2N+tmCBrl2Csl6CsFyDtGGDr1+Es1SJs1aLtXCGpmSJt2WJtnaInlqPuGiLt2eMuXaKoWiMuWmMuWmNummOumqOvGaRt2yQvGyRvnKPwm2RvW6RvWGWv3GSunCSvXKTvHCUv3CUwHGUwHKVwGKawXWVvISUp3SXw3SYwnWYw2udvnaaxHeaxJOaknmdx36dwpGbpnyex32exn+ew3yfyI2cvH+gyX6hyYyftn+iy4ugxYGkzIKkzI6hyIKmvoOmzoSnzoWnz5KkyomoxYaozp+lsqqkn5GpxYmr0Yyrzoyt06GpwZutwZOwzJCw1Z6uwpGy0K2urZKy1q2wsKuwtpO02Kqxt7KzsbKywKq1wZm50q65xbG7xr+/vrvBxsLDwr/Iz8XJysTK0MrMytnIys/R097Nz9fX1tna2Nzc2+na293e3PHb3ODg3ubh0OLi4ePj4vPg3+Xl4+np5+vu1+7u7Pnu1//u7PX23vf44vz49/r74///6///7P//+f//+////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH+EUNyZWF0ZWQgd2l0aCBHSU1QACH5BAEKAP8ALAAAAAAXABAAAAj+AP8JTLAAQoUMHT4o1HBBQgMGAiNGVOAAQ4gSKVrEiPFiBQoRGyZEkBiRAogTMWbY0MHDx44cNYAUgWGBpEAPK2joCIKEyZMrU4ZsIROoCgeb/1RkSYJEihUtYhiBodLKmTAoI5AuyaRHzRcvZfwok5WLGjVdXEggPcJKmq1EcPAQonZsVbJouMKYQHqjC7VozT61AZYsWSxi1DTFYYFUSB5Uy5JBq1WqcLJTzFTNkYHUiBlJzyzzmjXM2K5br+TgQKpkzCFY0SwnC9br17RRa3ogdXLmziVk0YJDK+aLFqhBbn4gjYLGjqFNjiJZCuWKVCdFfd4ot0nkDB1AizAveTKVShQnSIX4uHGB9AGWNHX+IHpEqdKkRoL2sGmCNCKAAAIMUAACBB5gAAH9BQQAOw==','image/gif'),(47,'application/x-planner','R0lGODlhFwAQAIQcAAAAAAoNDg4TFRsjKCErMSg0Oi06QS06Qi07QjE/RzxOWEBUXkZbZkphbUthbkxib0xjcFVvfVVvfmJ/kGKAkWOAkYOqwISswoixyIy2zo240JG91v///////////////yH+EUNyZWF0ZWQgd2l0aCBHSU1QACH5BAEKAB8ALAAAAAAXABAAAAVD4CeOZGmeaEoCbOu2aizPKrXd+AbRSuT/EQTtBBiaFJVkZUIwSi7Qi6Vg/LyKsoejwRBUF5pMBjOofhIHgyFgbrs/IQA7','image/gif'),(48,'application/x-php','R0lGODlhFwAQAKU0AD0+c1FTmlJUmlZYnVpcn1xeoGxuqW1uqnJzrX1+s4OFt4SFt4WHuJGSvqWmyKanx6ipzKqqyqqrzbOz07i51b6+vsjJ39PU5tzc6t7f7OHh5ubm5ubm6Ofn5+bn8ejo7+np6enp8urq6uvs8u3t7e/v7/Dw8PHx8fLy8vPz8/T09PT0+fX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///////////////////////////////////////////////yH5BAEKAD8ALAIAAAAQABAAAAaRwN+vQiwahcjhSzZrOl+V5FCmYllPJdCsE0VWZi6Yy5UyiWYtVXcoOSACAYNDw2x24YELHv7gbGZRARYXEyGEgxMBESSAcBkFFh4FGY8WCQQojXmCGHl6FggCLZorFxCJE6UQAQ0vgD+be3oBDB+uXQALA3gDChQjMTGvQ05NMsfIw1/FzHZCFTDNxTBdRtbWQQA7','image/gif'),(49,'audio/mpeg','R0lGODlhFwAQAMZWAFl/tV+EuGSJu2mKu2yLt2mNvmqNvm2Pv3GTw3OUwneUv3SVw3iYxHiYxXuaxnyaxX+cw4CeyX+fyoGgy4yiwYWjzIymy42myZKmw4unz4uoz4ypz5GqzpCq0paqxp+pt5KrzpCs0ZWsy5St0Jity5Wu0Jau0ZuuyJ+wyJix1Z+32KK31LW6wK3A2r6+vrHB2cjT5NTd6dbd6Nff69nh7Nnh7dvi7Nvj7dzj7d7l7d/l7ubm5ufn5+Xp8Onp6eXq8urq6uzs7O3t7ezv9O/v7/Dw8PHx8fLy8vDz9vPz8/T09PX19fb29vb3+fb4+ff4+fj4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAe/gH+Cfy6FhoeDiYqEUFWOj1RQLouLLlNKS5lGRD5UPJOUgyw/OTo4NjJFQFRMSqChKCopIRsZDktGVLpUr4snHSYjIA4LuEFAO7yhfx4VNbolBlNQTElCyqEYETS6HALT1UfYlBQNM043FgFUU1FRTOOLEAkwLQwFA+zuUPGDEhoTHqw4gACACCkIpfDrNQgBAgIvYlxQQKJHQoT9En1oQgXJkCe7dE3JOMhFyJO7GCZyEeURpF1RVJY8RBNRokAAOw==','image/gif'),(50,'audio/x-ogg','R0lGODlhFwAQAMZWAFl/tV+EuGSJu2mKu2yLt2mNvmqNvm2Pv3GTw3OUwneUv3SVw3iYxHiYxXuaxnyaxX+cw4CeyX+fyoGgy4yiwYWjzIymy42myZKmw4unz4uoz4ypz5GqzpCq0paqxp+pt5KrzpCs0ZWsy5St0Jity5Wu0Jau0ZuuyJ+wyJix1Z+32KK31LW6wK3A2r6+vrHB2cjT5NTd6dbd6Nff69nh7Nnh7dvi7Nvj7dzj7d7l7d/l7ubm5ufn5+Xp8Onp6eXq8urq6uzs7O3t7ezv9O/v7/Dw8PHx8fLy8vDz9vPz8/T09PX19fb29vb3+fb4+ff4+fj4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAe/gH+Cfy6FhoeDiYqEUFWOj1RQLouLLlNKS5lGRD5UPJOUgyw/OTo4NjJFQFRMSqChKCopIRsZDktGVLpUr4snHSYjIA4LuEFAO7yhfx4VNbolBlNQTElCyqEYETS6HALT1UfYlBQNM043FgFUU1FRTOOLEAkwLQwFA+zuUPGDEhoTHqw4gACACCkIpfDrNQgBAgIvYlxQQKJHQoT9En1oQgXJkCe7dE3JOMhFyJO7GCZyEeURpF1RVJY8RBNRokAAOw==','image/gif'),(51,'video/x-flv','R0lGODlhFwAQAMZaACwsLDMzMzs7O0RERE9PT1RUVFhYWFBcTFRfY15eXl9fX2BgYGNjY2VlZWZmZmpqamxsbHBtX2Z0bnR0dG92dnl1aHJ3bnd3d3h4eHp6emqDeWeIemKPUnmIXmuJf4SEhEqbVIGGiV2SkVeYlE+iZ2SncXCpYZqilGyuvGuu0mm2i3uvx6inn6KprlnBpFvEh6SrsHfAZWG+x6auoaiuo2W922W934e3t7GxfYLFYHPJe3i+5HvPZLK+lLu7u76+vtjY2NnZ2ePj4+Xl5ebm5ufn5+jo6Onp6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAfFgH+Cfz+FhoeDiYqEVFmOj1hUP4uLP1dQUZlNS0dYRZOUgz5YU1WaTEhYUlCglB8TITAtLBMfUU1YuVitihkVIikrOBUZt0lIRLuhGBQkLjY3FBhXVFJPSsqUFxImPDoqEhfU1k7Ziw0EGh4bHQQNWFdXVVLmihARIzU7PREQ8FVVqNRLxAABiBcyUCBgcMWKQ4G8Ei04wCFHjBIHFjjcOHCQggIWaMw4UUCBLngdB/04yVJXxEQ/qjyCpKvKS5WHciJKFAgAOw==','image/gif'),(52,'video/mp4','R0lGODlhFwAQAMZaACwsLDMzMzs7O0RERE9PT1RUVFhYWFBcTFRfY15eXl9fX2BgYGNjY2VlZWZmZmpqamxsbHBtX2Z0bnR0dG92dnl1aHJ3bnd3d3h4eHp6emqDeWeIemKPUnmIXmuJf4SEhEqbVIGGiV2SkVeYlE+iZ2SncXCpYZqilGyuvGuu0mm2i3uvx6inn6KprlnBpFvEh6SrsHfAZWG+x6auoaiuo2W922W934e3t7GxfYLFYHPJe3i+5HvPZLK+lLu7u76+vtjY2NnZ2ePj4+Xl5ebm5ufn5+jo6Onp6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAfFgH+Cfz+FhoeDiYqEVFmOj1hUP4uLP1dQUZlNS0dYRZOUgz5YU1WaTEhYUlCglB8TITAtLBMfUU1YuVitihkVIikrOBUZt0lIRLuhGBQkLjY3FBhXVFJPSsqUFxImPDoqEhfU1k7Ziw0EGh4bHQQNWFdXVVLmihARIzU7PREQ8FVVqNRLxAABiBcyUCBgcMWKQ4G8Ei04wCFHjBIHFjjcOHCQggIWaMw4UUCBLngdB/04yVJXxEQ/qjyCpKvKS5WHciJKFAgAOw==','image/gif'),(53,'video/mpeg','R0lGODlhFwAQAMZaACwsLDMzMzs7O0RERE9PT1RUVFhYWFBcTFRfY15eXl9fX2BgYGNjY2VlZWZmZmpqamxsbHBtX2Z0bnR0dG92dnl1aHJ3bnd3d3h4eHp6emqDeWeIemKPUnmIXmuJf4SEhEqbVIGGiV2SkVeYlE+iZ2SncXCpYZqilGyuvGuu0mm2i3uvx6inn6KprlnBpFvEh6SrsHfAZWG+x6auoaiuo2W922W934e3t7GxfYLFYHPJe3i+5HvPZLK+lLu7u76+vtjY2NnZ2ePj4+Xl5ebm5ufn5+jo6Onp6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAfFgH+Cfz+FhoeDiYqEVFmOj1hUP4uLP1dQUZlNS0dYRZOUgz5YU1WaTEhYUlCglB8TITAtLBMfUU1YuVitihkVIikrOBUZt0lIRLuhGBQkLjY3FBhXVFJPSsqUFxImPDoqEhfU1k7Ziw0EGh4bHQQNWFdXVVLmihARIzU7PREQ8FVVqNRLxAABiBcyUCBgcMWKQ4G8Ei04wCFHjBIHFjjcOHCQggIWaMw4UUCBLngdB/04yVJXxEQ/qjyCpKvKS5WHciJKFAgAOw==','image/gif'),(54,'video/x-msvideo','R0lGODlhFwAQAMZaACwsLDMzMzs7O0RERE9PT1RUVFhYWFBcTFRfY15eXl9fX2BgYGNjY2VlZWZmZmpqamxsbHBtX2Z0bnR0dG92dnl1aHJ3bnd3d3h4eHp6emqDeWeIemKPUnmIXmuJf4SEhEqbVIGGiV2SkVeYlE+iZ2SncXCpYZqilGyuvGuu0mm2i3uvx6inn6KprlnBpFvEh6SrsHfAZWG+x6auoaiuo2W922W934e3t7GxfYLFYHPJe3i+5HvPZLK+lLu7u76+vtjY2NnZ2ePj4+Xl5ebm5ufn5+jo6Onp6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAfFgH+Cfz+FhoeDiYqEVFmOj1hUP4uLP1dQUZlNS0dYRZOUgz5YU1WaTEhYUlCglB8TITAtLBMfUU1YuVitihkVIikrOBUZt0lIRLuhGBQkLjY3FBhXVFJPSsqUFxImPDoqEhfU1k7Ziw0EGh4bHQQNWFdXVVLmihARIzU7PREQ8FVVqNRLxAABiBcyUCBgcMWKQ4G8Ei04wCFHjBIHFjjcOHCQggIWaMw4UUCBLngdB/04yVJXxEQ/qjyCpKvKS5WHciJKFAgAOw==','image/gif'),(55,'video/x-ms-wmv','R0lGODlhFwAQAMZaACwsLDMzMzs7O0RERE9PT1RUVFhYWFBcTFRfY15eXl9fX2BgYGNjY2VlZWZmZmpqamxsbHBtX2Z0bnR0dG92dnl1aHJ3bnd3d3h4eHp6emqDeWeIemKPUnmIXmuJf4SEhEqbVIGGiV2SkVeYlE+iZ2SncXCpYZqilGyuvGuu0mm2i3uvx6inn6KprlnBpFvEh6SrsHfAZWG+x6auoaiuo2W922W934e3t7GxfYLFYHPJe3i+5HvPZLK+lLu7u76+vtjY2NnZ2ePj4+Xl5ebm5ufn5+jo6Onp6erq6uzs7O3t7e/v7/Dw8PHx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z8/P///+rXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgOrXgCH5BAEKAH8ALAAAAAAXABAAAAfFgH+Cfz+FhoeDiYqEVFmOj1hUP4uLP1dQUZlNS0dYRZOUgz5YU1WaTEhYUlCglB8TITAtLBMfUU1YuVitihkVIikrOBUZt0lIRLuhGBQkLjY3FBhXVFJPSsqUFxImPDoqEhfU1k7Ziw0EGh4bHQQNWFdXVVLmihARIzU7PREQ8FVVqNRLxAABiBcyUCBgcMWKQ4G8Ei04wCFHjBIHFjjcOHCQggIWaMw4UUCBLngdB/04yVJXxEQ/qjyCpKvKS5WHciJKFAgAOw==','image/gif'),(56,'application/x-shockwave-flash','R0lGODlhFwAQAMZIAOItM/E1O/E5P/I6P+Y+QvI7QPE8QfI8QPI8QfJARfNARPNBRfRHSvVJTPFKT/RKTfZXWvdXWfdcW/dgYfhlYvltafpybfV0d/t1cPZ4evt4cvt4c/t8dvx+ePWAhPiBg/WChPWDhvyEfPeIifiNj76+vvm9vfnAwvfHyPnLzfrV1vrW1/vY2frd3ubm5ufn5/rk5enp6erq6uvr6+zs7Pvo6e3t7fvr6+/v7/Dw8Pvu7/Hx8fLy8vPz8/T09PX19fb29vf39/j4+Pn5+fr6+vv7+/z7+/z8/P///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAMAAAAQABAAAAeqgH9/JYSFhoKIg0JFR42OQiWJg0U+P5Y7ODFHL5GIJUdBQygjIDkyR0A+nYNHQyYTIg08M45HnZ8tERgQFz87NDIutoIlRh8cGTdFQj88ODbDgywSDyc6R8tAPTzRJSQbHQcejURDQEDdDxoIAuPYQ0NC0QQWCSkrMEVFRERC8iUMFhigEKKRPn4IbSkoUMFBDUf6IjIqMSAAABW1Mja6NURjrSG3DIk0FAgAOw==','image/gif'),(57,'application/octet-stream','R0lGODlhFwAQAMZrANldWqxqc+deWliBrtFlZehhXehiXlqEtFmFtOhkYVuGs+hoZmeJs1+LuGGMuOtraa2AX2OOuutua6yCYulvbaqCa+1vbutxbmuQud54cbuEc+12de52dW2VvnSVuJeNpe54d2yefnCfa+Z7duN8du17eXaYvYSVs3SigfB+fJWXr++DgvCEhH2odpWctYmiwOyLieuNjYGweomnxYOwfoWwfoWzfZSqxPSTlI6uzYy3ho+vzpKwz8OmpJOwz/ScnZi/kLG4sKbAmaa/2L69vaXIn76+vqjJoua1svC8ue/CwbrUtO/NzMrY2tTc5dzi6Obm5ufn5+np6fDo5+rq6uzs7O3t7fHs7O/u7+/v7/Dw8PLw8PHx8fbw7/bx8PLy8vPz8/Tz8/T09PX19fb29vj4+Pj4+fn5+fr6+vv7+/z8/P///////////////////////////////////////////////////////////////////////////////////yH5BAEKAH8ALAAAAAAXABAAAAfLgH+Cf0aFhoeDiYqEZWuOj2plRouLRmliY5lcWVJqUZOUg0RdTElKU1taVGpkYqChPTEUDwswSGFcarpqr4saLBYbEhwkV1xVVFC8lC02ED8pIAkGI15lZGBWy4syQBMrOCUFAhlY12Bf24o6S0IVBBcAASceaWlnZOqJNUdFKC4fVJjocODemTL6EomgEcLHkBwRHCBAQxFhL0VBmszgsaOBAgYUKSZMZMSMkxcYBtx4sivNyEFGdsmceZHkmUeQdp2pCfOQT0SJAgEAOw==','image/gif');
/*!40000 ALTER TABLE `OKM_MIME_TYPE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_MIME_TYPE_EXTENSION`
--
DROP TABLE IF EXISTS `OKM_MIME_TYPE_EXTENSION`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_MIME_TYPE_EXTENSION` (
`MTE_ID` int(11) NOT NULL,
`MTE_NAME` varchar(255) collate utf8_bin default NULL,
KEY `FK198BAD77C645F9B7` (`MTE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_MIME_TYPE_EXTENSION`
--
LOCK TABLES `OKM_MIME_TYPE_EXTENSION` WRITE;
/*!40000 ALTER TABLE `OKM_MIME_TYPE_EXTENSION` DISABLE KEYS */;
INSERT INTO `OKM_MIME_TYPE_EXTENSION` VALUES (1,'ott'),(1,'odt'),(2,'odp'),(2,'otp'),(3,'ots'),(3,'ods'),(4,'odg'),(5,'odb'),(6,'doc'),(6,'dot'),(7,'xls'),(8,'pps'),(8,'ppt'),(9,'mpp'),(10,'mdb'),(11,'vsd'),(12,'pub'),(13,'docx'),(14,'dotx'),(15,'potx'),(16,'ppsx'),(17,'pptx'),(18,'xlsx'),(19,'xltx'),(20,'gif'),(21,'jpg'),(22,'png'),(23,'tif'),(23,'tiff'),(24,'bmp'),(25,'ico'),(26,'psd'),(27,'fh9'),(27,'fh8'),(27,'fh10'),(27,'fh11'),(27,'fh'),(28,'ai'),(29,'zip'),(30,'rar'),(31,'tar'),(32,'gz'),(33,'tgz'),(34,'properties'),(34,'txt'),(35,'html'),(35,'htm'),(36,'css'),(37,'csv'),(38,'xml'),(39,'sql'),(40,'java'),(41,'pdf'),(42,'rtf'),(43,'sh'),(44,'pl'),(45,'rvl'),(46,'zargo'),(47,'planner'),(48,'php'),(49,'mp3'),(50,'ogg'),(51,'flv'),(52,'mp4'),(53,'mpeg'),(53,'mpg'),(54,'avi'),(55,'wmv'),(56,'swf'),(57,'*');
/*!40000 ALTER TABLE `OKM_MIME_TYPE_EXTENSION` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_PROFILE`
--
DROP TABLE IF EXISTS `OKM_PROFILE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_PROFILE` (
`PRF_ID` int(11) NOT NULL auto_increment,
`PRF_NAME` varchar(255) collate utf8_bin NOT NULL,
`PRF_ACTIVE` bit(1) NOT NULL,
`PRF_MSC_ADVANCED_FILTERS` bit(1) default b'0',
`PRF_MSC_USER_QUOTA` bigint(20) default '0',
`PRF_MSC_WEB_SKIN` varchar(255) collate utf8_bin default 'default',
`PRF_CHT_CHAT_EN` bit(1) default b'0',
`PRF_CHT_AUTO_LOGIN_EN` bit(1) default b'0',
`PRF_WZRD_PROPERTY_GROUPS` varchar(255) collate utf8_bin default '',
`PRF_WZRD_WORKFLOWS` varchar(255) collate utf8_bin default '',
`PRF_WZRD_KEYWORDS_EN` bit(1) default b'0',
`PRF_WZRD_CATEGORIES_EN` bit(1) default b'0',
`PRF_STCK_TAXONOMY_VIS` bit(1) default b'1',
`PRF_STCK_CATEGORIES_VIS` bit(1) default b'1',
`PRF_STCK_THESAURUS_VIS` bit(1) default b'1',
`PRF_STCK_TEMPLATES_VIS` bit(1) default b'1',
`PRF_STCK_PERSONAL_VIS` bit(1) default b'1',
`PRF_STCK_MAIL_VIS` bit(1) default b'1',
`PRF_STCK_TRASH_VIS` bit(1) default b'1',
`PRF_TB_DESKTOP_VIS` bit(1) default b'1',
`PRF_TB_SEARCH_VIS` bit(1) default b'1',
`PRF_TB_DASHBOARD_VIS` bit(1) default b'1',
`PRF_TB_ADMIN_VIS` bit(1) default b'1',
`PRF_TB_DOC_PROPS_VIS` bit(1) default b'1',
`PRF_TB_DOC_SECURITY_VIS` bit(1) default b'1',
`PRF_TB_DOC_NOTES_VIS` bit(1) default b'1',
`PRF_TB_DOC_VERSIONS_VIS` bit(1) default b'1',
`PRF_TB_DOC_PREVIEW_VIS` bit(1) default b'1',
`PRF_TB_DOC_PROP_GRPS_VIS` bit(1) default b'1',
`PRF_TB_FLD_PROPS_VIS` bit(1) default b'1',
`PRF_TB_FLD_SECURITY_VIS` bit(1) default b'1',
`PRF_TB_ML_PROPS_VIS` bit(1) default b'1',
`PRF_TB_ML_SECURITY_VIS` bit(1) default b'1',
`PRF_DB_USER_VIS` bit(1) default b'1',
`PRF_DB_MAIL_VIS` bit(1) default b'1',
`PRF_DB_NEWS_VIS` bit(1) default b'1',
`PRF_DB_GENERAL_VIS` bit(1) default b'1',
`PRF_DB_WORKFLOW_VIS` bit(1) default b'1',
`PRF_DB_KEYWORDS_VIS` bit(1) default b'1',
`PRF_MN_FILE_VIS` bit(1) default b'1',
`PRF_MN_EDIT_VIS` bit(1) default b'1',
`PRF_MN_TOOLS_VIS` bit(1) default b'1',
`PRF_MN_BOOKMARKS_VIS` bit(1) default b'1',
`PRF_MN_HELP_VIS` bit(1) default b'1',
`PRF_MN_FI_CREATE_FLD_VIS` bit(1) default b'1',
`PRF_MN_FI_FIND_FLD_VIS` bit(1) default b'1',
`PRF_MN_FI_GO_FLD_VIS` bit(1) default b'1',
`PRF_MN_FI_DOWNLOAD_VIS` bit(1) default b'1',
`PRF_MN_FI_DOWNLOAD_PDF_VIS` bit(1) default b'1',
`PRF_MN_FI_ADD_DOC_VIS` bit(1) default b'1',
`PRF_MN_FI_START_WORKFLOW_VIS` bit(1) default b'1',
`PRF_MN_FI_REFRESH_VIS` bit(1) default b'1',
`PRF_MN_FI_SCANNER_VIS` bit(1) default b'1',
`PRF_MN_FI_UPLOADER_VIS` bit(1) default b'1',
`PRF_MN_FI_PURGE_VIS` bit(1) default b'1',
`PRF_MN_FI_PURGE_TRASH_VIS` bit(1) default b'1',
`PRF_MN_FI_RESTORE_VIS` bit(1) default b'1',
`PRF_MN_FI_EXPORT_VIS` bit(1) default b'1',
`PRF_MN_FI_CREATE_FROM_TPL_VIS` bit(1) default b'1',
`PRF_MN_FI_SEND_DOC_LINK_VIS` bit(1) default b'1',
`PRF_MN_FI_SEND_DOC_ATTACH_VIS` bit(1) default b'1',
`PRF_MN_ED_LOCK_VIS` bit(1) default b'1',
`PRF_MN_ED_UNLOCK_VIS` bit(1) default b'1',
`PRF_MN_ED_CIN_VIS` bit(1) default b'1',
`PRF_MN_ED_COUT_VIS` bit(1) default b'1',
`PRF_MN_ED_CANCEL_COUT_VIS` bit(1) default b'1',
`PRF_MN_ED_DELETE_VIS` bit(1) default b'1',
`PRF_MN_ED_RENAME_VIS` bit(1) default b'1',
`PRF_MN_ED_COPY_VIS` bit(1) default b'1',
`PRF_MN_ED_MOVE_VIS` bit(1) default b'1',
`PRF_MN_ED_ADD_PROP_GRP_VIS` bit(1) default b'1',
`PRF_MN_ED_REM_PROP_GRP_VIS` bit(1) default b'1',
`PRF_MN_ED_ADD_SUBS_VIS` bit(1) default b'1',
`PRF_MN_ED_REM_SUBS_VIS` bit(1) default b'1',
`PRF_MN_BM_MNG_BOOKMARKS_VIS` bit(1) default b'1',
`PRF_MN_BM_ADD_BOOKMARK_VIS` bit(1) default b'1',
`PRF_MN_BM_SET_HOME_VIS` bit(1) default b'1',
`PRF_MN_BM_GO_HOME_VIS` bit(1) default b'1',
`PRF_MN_TL_LANGS_VIS` bit(1) default b'1',
`PRF_MN_TL_SKIN_VIS` bit(1) default b'1',
`PRF_MN_TL_DEBUG_VIS` bit(1) default b'1',
`PRF_MN_TL_ADMIN_VIS` bit(1) default b'1',
`PRF_MN_TL_PREFS_VIS` bit(1) default b'1',
`PRF_MN_HLP_DOC_VIS` bit(1) default b'1',
`PRF_MN_HLP_BUG_TRACKING_VIS` bit(1) default b'1',
`PRF_MN_HLP_SUPPORT_VIS` bit(1) default b'1',
`PRF_MN_HLP_FORUM_VIS` bit(1) default b'1',
`PRF_MN_HLP_CHANGELOG_VIS` bit(1) default b'1',
`PRF_MN_HLP_WEB_SITE_VIS` bit(1) default b'1',
`PRF_MNU_HLP_ABOUT_VIS` bit(1) default b'1',
PRIMARY KEY (`PRF_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_PROFILE`
--
LOCK TABLES `OKM_PROFILE` WRITE;
/*!40000 ALTER TABLE `OKM_PROFILE` DISABLE KEYS */;
INSERT INTO `OKM_PROFILE` VALUES (1,'Default','','\0',0,'default','\0','\0','','','\0','\0','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');
/*!40000 ALTER TABLE `OKM_PROFILE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_QUERY_PARAMS`
--
DROP TABLE IF EXISTS `OKM_QUERY_PARAMS`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_QUERY_PARAMS` (
`QP_ID` int(11) NOT NULL auto_increment,
`QP_QUERY_NAME` varchar(255) collate utf8_bin NOT NULL,
`QP_USER` varchar(127) collate utf8_bin NOT NULL,
`QP_NAME` varchar(255) collate utf8_bin default NULL,
`QP_CONTENT` varchar(255) collate utf8_bin default NULL,
`QP_MIME_TYPE` varchar(255) collate utf8_bin default NULL,
`QP_AUTHOR` varchar(255) collate utf8_bin default NULL,
`QP_PATH` varchar(255) collate utf8_bin default NULL,
`QP_DASHBOARD` bit(1) default NULL,
`QP_LAST_MODIFIED_FROM` datetime default NULL,
`QP_LAST_MODIFIED_TO` datetime default NULL,
`QP_MAIL_SUBJECT` varchar(255) collate utf8_bin default NULL,
`QP_MAIL_FROM` varchar(255) collate utf8_bin default NULL,
`QP_MAIL_TO` varchar(255) collate utf8_bin default NULL,
PRIMARY KEY (`QP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_QUERY_PARAMS`
--
LOCK TABLES `OKM_QUERY_PARAMS` WRITE;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_QUERY_PARAMS_CATEGORY`
--
DROP TABLE IF EXISTS `OKM_QUERY_PARAMS_CATEGORY`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_QUERY_PARAMS_CATEGORY` (
`QPC_ID` int(11) NOT NULL,
`QPC_NAME` varchar(255) collate utf8_bin default NULL,
KEY `FKE27BE632200C4397` (`QPC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_QUERY_PARAMS_CATEGORY`
--
LOCK TABLES `OKM_QUERY_PARAMS_CATEGORY` WRITE;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS_CATEGORY` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS_CATEGORY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_QUERY_PARAMS_KEYWORD`
--
DROP TABLE IF EXISTS `OKM_QUERY_PARAMS_KEYWORD`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_QUERY_PARAMS_KEYWORD` (
`QPK_ID` int(11) NOT NULL,
`QPK_NAME` varchar(255) collate utf8_bin default NULL,
KEY `FK4A477A15200FE68F` (`QPK_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_QUERY_PARAMS_KEYWORD`
--
LOCK TABLES `OKM_QUERY_PARAMS_KEYWORD` WRITE;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS_KEYWORD` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS_KEYWORD` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_QUERY_PARAMS_PROPERTY`
--
DROP TABLE IF EXISTS `OKM_QUERY_PARAMS_PROPERTY`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_QUERY_PARAMS_PROPERTY` (
`QPP_ID` int(11) NOT NULL,
`QPP_VALUE` varchar(255) collate utf8_bin default NULL,
`QPP_NAME` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`QPP_ID`,`QPP_NAME`),
KEY `FKA447070920122C6A` (`QPP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_QUERY_PARAMS_PROPERTY`
--
LOCK TABLES `OKM_QUERY_PARAMS_PROPERTY` WRITE;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS_PROPERTY` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_QUERY_PARAMS_PROPERTY` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_REPORT`
--
DROP TABLE IF EXISTS `OKM_REPORT`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_REPORT` (
`RP_ID` int(11) NOT NULL auto_increment,
`RP_NAME` varchar(255) collate utf8_bin NOT NULL,
`RP_TYPE` varchar(255) collate utf8_bin NOT NULL,
`RP_FILE_CONTENT` text collate utf8_bin NOT NULL,
`RP_FILE_NAME` varchar(255) collate utf8_bin NOT NULL,
`RP_ACTIVE` bit(1) NOT NULL,
PRIMARY KEY (`RP_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_REPORT`
--
LOCK TABLES `OKM_REPORT` WRITE;
/*!40000 ALTER TABLE `OKM_REPORT` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_REPORT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_ROLE`
--
DROP TABLE IF EXISTS `OKM_ROLE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_ROLE` (
`ROL_ID` varchar(127) collate utf8_bin NOT NULL,
`ROL_ACTIVE` bit(1) NOT NULL,
PRIMARY KEY (`ROL_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_ROLE`
--
LOCK TABLES `OKM_ROLE` WRITE;
/*!40000 ALTER TABLE `OKM_ROLE` DISABLE KEYS */;
INSERT INTO `OKM_ROLE` VALUES ('AdminRole',''),('UserRole','');
/*!40000 ALTER TABLE `OKM_ROLE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_STAPLE`
--
DROP TABLE IF EXISTS `OKM_STAPLE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_STAPLE` (
`ST_ID` int(11) NOT NULL auto_increment,
`ST_UUID` varchar(255) collate utf8_bin NOT NULL,
`ST_TYPE` varchar(255) collate utf8_bin NOT NULL,
`ST_GROUPID` int(11) default NULL,
PRIMARY KEY (`ST_ID`),
KEY `FK45419DD7E6CC0B56` (`ST_GROUPID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_STAPLE`
--
LOCK TABLES `OKM_STAPLE` WRITE;
/*!40000 ALTER TABLE `OKM_STAPLE` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_STAPLE` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_STAPLE_GROUP`
--
DROP TABLE IF EXISTS `OKM_STAPLE_GROUP`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_STAPLE_GROUP` (
`SG_ID` int(11) NOT NULL auto_increment,
`SG_USER` varchar(127) collate utf8_bin NOT NULL,
PRIMARY KEY (`SG_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_STAPLE_GROUP`
--
LOCK TABLES `OKM_STAPLE_GROUP` WRITE;
/*!40000 ALTER TABLE `OKM_STAPLE_GROUP` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_STAPLE_GROUP` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_TWITTER_ACCOUNT`
--
DROP TABLE IF EXISTS `OKM_TWITTER_ACCOUNT`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_TWITTER_ACCOUNT` (
`TA_ID` int(11) NOT NULL auto_increment,
`TA_USER` varchar(127) collate utf8_bin NOT NULL,
`TA_TUSER` varchar(255) collate utf8_bin NOT NULL,
`TA_ACTIVE` bit(1) NOT NULL,
PRIMARY KEY (`TA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_TWITTER_ACCOUNT`
--
LOCK TABLES `OKM_TWITTER_ACCOUNT` WRITE;
/*!40000 ALTER TABLE `OKM_TWITTER_ACCOUNT` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_TWITTER_ACCOUNT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_USER`
--
DROP TABLE IF EXISTS `OKM_USER`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_USER` (
`USR_ID` varchar(127) collate utf8_bin NOT NULL,
`USR_NAME` varchar(255) collate utf8_bin NOT NULL,
`USR_PASSWORD` varchar(255) collate utf8_bin NOT NULL,
`USR_EMAIL` varchar(255) collate utf8_bin NOT NULL,
`USR_ACTIVE` bit(1) NOT NULL,
PRIMARY KEY (`USR_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_USER`
--
LOCK TABLES `OKM_USER` WRITE;
/*!40000 ALTER TABLE `OKM_USER` DISABLE KEYS */;
INSERT INTO `OKM_USER` VALUES ('okmAdmin','Administrator','21232f297a57a5a743894a0e4a801fc3','admin [ at ] noreply [ dot ] com','');
/*!40000 ALTER TABLE `OKM_USER` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_USER_CONFIG`
--
DROP TABLE IF EXISTS `OKM_USER_CONFIG`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_USER_CONFIG` (
`UC_USER` varchar(127) collate utf8_bin NOT NULL,
`UC_HOME_PATH` varchar(255) collate utf8_bin NOT NULL,
`UC_HOME_UUID` varchar(255) collate utf8_bin NOT NULL,
`UC_HOME_TYPE` varchar(255) collate utf8_bin NOT NULL,
`UC_PROFILE` int(11) default NULL,
PRIMARY KEY (`UC_USER`),
KEY `FK7798F4E88FDAFE34` (`UC_PROFILE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_USER_CONFIG`
--
LOCK TABLES `OKM_USER_CONFIG` WRITE;
/*!40000 ALTER TABLE `OKM_USER_CONFIG` DISABLE KEYS */;
INSERT INTO `OKM_USER_CONFIG` VALUES ('okmAdmin','/okm:root','b72f146d-7598-40df-a6e8-8338077707a4','okm:folder',1);
/*!40000 ALTER TABLE `OKM_USER_CONFIG` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_USER_DOCUMENT`
--
DROP TABLE IF EXISTS `OKM_USER_DOCUMENT`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_USER_DOCUMENT` (
`UD_ID` int(11) NOT NULL auto_increment,
`UD_USER` varchar(255) collate utf8_bin NOT NULL,
`UD_DOCUMENT` varchar(255) collate utf8_bin NOT NULL,
PRIMARY KEY (`UD_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_USER_DOCUMENT`
--
LOCK TABLES `OKM_USER_DOCUMENT` WRITE;
/*!40000 ALTER TABLE `OKM_USER_DOCUMENT` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_USER_DOCUMENT` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_USER_DOCUMENT_KEYWORD`
--
DROP TABLE IF EXISTS `OKM_USER_DOCUMENT_KEYWORD`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_USER_DOCUMENT_KEYWORD` (
`UDK_ID` int(11) NOT NULL,
`UDK_NAME` varchar(255) collate utf8_bin default NULL,
KEY `FK7A93ECCB47DCC8C7` (`UDK_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_USER_DOCUMENT_KEYWORD`
--
LOCK TABLES `OKM_USER_DOCUMENT_KEYWORD` WRITE;
/*!40000 ALTER TABLE `OKM_USER_DOCUMENT_KEYWORD` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_USER_DOCUMENT_KEYWORD` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_USER_ITEMS`
--
DROP TABLE IF EXISTS `OKM_USER_ITEMS`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_USER_ITEMS` (
`UI_USER` varchar(255) collate utf8_bin NOT NULL,
`UI_FOLDERS` int(11) default NULL,
`UI_DOCUMENTS` int(11) default NULL,
`UI_MAILS` int(11) default NULL,
`UI_SIZE` bigint(20) default NULL,
PRIMARY KEY (`UI_USER`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_USER_ITEMS`
--
LOCK TABLES `OKM_USER_ITEMS` WRITE;
/*!40000 ALTER TABLE `OKM_USER_ITEMS` DISABLE KEYS */;
/*!40000 ALTER TABLE `OKM_USER_ITEMS` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `OKM_USER_ROLE`
--
DROP TABLE IF EXISTS `OKM_USER_ROLE`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `OKM_USER_ROLE` (
`UR_USER` varchar(127) collate utf8_bin NOT NULL,
`UR_ROLE` varchar(127) collate utf8_bin NOT NULL,
PRIMARY KEY (`UR_USER`,`UR_ROLE`),
KEY `FK79C279CF1C15945` (`UR_USER`),
KEY `FK79C279CF1BE829B` (`UR_ROLE`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `OKM_USER_ROLE`
--
LOCK TABLES `OKM_USER_ROLE` WRITE;
/*!40000 ALTER TABLE `OKM_USER_ROLE` DISABLE KEYS */;
INSERT INTO `OKM_USER_ROLE` VALUES ('okmAdmin','AdminRole');
/*!40000 ALTER TABLE `OKM_USER_ROLE` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-07-28 6:48:35
Attachment:
create_databases.sh
Description: Bourne shell script