-
-
+
:
-
-
- |
- |
-
-
+
+
+
+
+
+
+
+
+
+
-
-
+ |
+
+ *
|
-
-
-
+
+ <%= ConfigurationItem.BOOLEAN_FORMAT %>
+
+
+
+ true
+ false
+
+
+
+
+
+
|
-
-
+
+
+
+
Index: lams_common/db/sql/insert_lams_unix_config_data.sql
===================================================================
diff -u -r053b3694d8631a983eb8e95e3f0374a22540b43a -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/db/sql/insert_lams_unix_config_data.sql (.../insert_lams_unix_config_data.sql) (revision 053b3694d8631a983eb8e95e3f0374a22540b43a)
+++ lams_common/db/sql/insert_lams_unix_config_data.sql (.../insert_lams_unix_config_data.sql) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -1,71 +1,212 @@
-insert into lams_configuration (config_key, config_value) values ('ServerURL','http://shaun.melcoe.mq.edu.au/lams/');
-insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','lams/');
-insert into lams_configuration (config_key, config_value) values ('Version','2.0.4 DEV');
-insert into lams_configuration (config_key, config_value) values ('TempDir','/var/opt/lams/temp');
-insert into lams_configuration (config_key, config_value) values ('DumpDir','/var/opt/lams/dump');
-insert into lams_configuration (config_key, config_value) values ('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear');
-insert into lams_configuration (config_key, config_value) values ('SMTPServer','');
-insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','/var/opt/lams/repository');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576');
-insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096');
-insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs');
-insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400');
-insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false');
-insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7');
-insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true');
-insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU');
-insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR');
-insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-05-24');
-insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/');
-insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin');
-insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire');
-insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','default');
-insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','defaultHTML');
-insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false');
-insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false');
-insert into lams_configuration (config_key, config_value) values ('AllowLiveEdit','true');
-insert into lams_configuration (config_key, config_value) values ('LDAPProvisioningEnabled','false');
-insert into lams_configuration (config_key, config_value) values ('LDAPProviderURL','ldap://192.168.111.15');
-insert into lams_configuration (config_key, config_value) values ('LDAPSecurityAuthentication','simple');
-insert into lams_configuration (config_key, config_value) values ('LDAPPrincipalDNPrefix','cn=');
-insert into lams_configuration (config_key, config_value) values ('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au');
-insert into lams_configuration (config_key, config_value) values ('LDAPSecurityProtocol','');
-insert into lams_configuration (config_key, config_value) values ('LDAPTruststorePath','');
-insert into lams_configuration (config_key, config_value) values ('LDAPTruststorePassword','');
-insert into lams_configuration (config_key, config_value) values ('LDAPLoginAttr','uid');
-insert into lams_configuration (config_key, config_value) values ('LDAPFNameAttr','givenName');
-insert into lams_configuration (config_key, config_value) values ('LDAPLNameAttr','sn');
-insert into lams_configuration (config_key, config_value) values ('LDAPEmailAttr','mail');
-insert into lams_configuration (config_key, config_value) values ('LDAPAddr1Attr','postalAddress');
-insert into lams_configuration (config_key, config_value) values ('LDAPAddr2Attr','');
-insert into lams_configuration (config_key, config_value) values ('LDAPAddr3Attr','');
-insert into lams_configuration (config_key, config_value) values ('LDAPCityAttr','l');
-insert into lams_configuration (config_key, config_value) values ('LDAPStateAttr','st');
-insert into lams_configuration (config_key, config_value) values ('LDAPPostcodeAttr','postalCode');
-insert into lams_configuration (config_key, config_value) values ('LDAPCountryAttr','');
-insert into lams_configuration (config_key, config_value) values ('LDAPDayPhoneAttr','telephoneNumber');
-insert into lams_configuration (config_key, config_value) values ('LDAPEveningPhoneAttr','homePhone');
-insert into lams_configuration (config_key, config_value) values ('LDAPFaxAttr','facsimileTelephoneNumber');
-insert into lams_configuration (config_key, config_value) values ('LDAPMobileAttr','mobile');
-insert into lams_configuration (config_key, config_value) values ('LDAPLocaleAttr','preferredLanguage');
-insert into lams_configuration (config_key, config_value) values ('LDAPDisabledAttr','!accountStatus');
-insert into lams_configuration (config_key, config_value) values ('LDAPOrgAttr','deetITSchoolCode');
-insert into lams_configuration (config_key, config_value) values ('LDAPRolesAttr','memberOf');
-insert into lams_configuration (config_key, config_value) values ('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPAuthorMap','Teacher;SeniorStaff;Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPGroupAdminMap','Teacher;SeniorStaff');
-insert into lams_configuration (config_key, config_value) values ('LDAPGroupManagerMap','Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPUpdateOnLogin', 'true');
-insert into lams_configuration (config_key, config_value) values ('LDAPOrgField', 'code');
-insert into lams_configuration (config_key, config_value) values ('LDAPOnlyOneOrg', 'true');
-insert into lams_configuration (config_key, config_value) values ('LDAPEncryptPasswordFromBrowser', 'true');
-insert into lams_configuration (config_key, config_value) values ('LDAPSearchResultsPageSize', '100');
\ No newline at end of file
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURL','http://shaun.melcoe.mq.edu.au/lams/', 'config.server.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURLContextPath','lams/', 'config.server.url.context.path', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('Version','2.0.4 DEV', 'config.version', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('TempDir','/var/opt/lams/temp', 'config.temp.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DumpDir','/var/opt/lams/dump', 'config.dump.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear', 'config.ear.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('SMTPServer','', 'config.smtp.server', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au', 'config.lams.support.email', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ContentRepositoryPath','/var/opt/lams/repository', 'config.content.repository.path', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxSize','1048576', 'config.upload.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadLargeFileMaxSize','10485760', 'config.upload.large.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxMemorySize','4096', 'config.upload.file.max.memory.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs', 'config.executable.extensions', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UserInactiveTimeout','86400', 'config.user.inactive.timeout', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UseCacheDebugListener','false', 'config.use.cache.debug.listener', 'config.header.system', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('CleanupPreviewOlderThanDays','7', 'config.cleanup.preview.older.than.days', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringActivitiesColour', 'true', 'config.authoring.activities.colour', 'config.header.look.feel', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringClientVersion','2.0.4.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('MonitorClientVersion','2.0.4.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LearnerClientVersion','2.0.4.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerVersionNumber','2.0.4.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerLanguage','en_AU', 'config.server.language', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerPageDirection','LTR', 'config.server.page.direction', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DictionaryDateCreated','2007-05-24', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/', 'config.help.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppDomain','shaun.melcoe.mq.edu.au', 'config.xmpp.domain', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppConference','conference.shaun.melcoe.mq.edu.au', 'config.xmpp.conference', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppAdmin','admin', 'config.xmpp.admin', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppPassword','wildfire', 'config.xmpp.password', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultFlashTheme','default', 'config.default.flash.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultHTMLTheme','defaultHTML', 'config.default.html.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowDirectLessonLaunch','false', 'config.allow.direct.lesson.launch', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LAMS_Community_enable','false', 'config.community.enable', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowLiveEdit','true', 'config.allow.live.edit', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProvisioningEnabled','false', 'config.ldap.provisioning.enabled', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProviderURL','ldap://192.168.111.15', 'config.ldap.provider.url', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityAuthentication','simple', 'config.ldap.security.authentication', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNPrefix','cn=', 'config.ldap.principal.dn.prefix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au', 'config.ldap.principal.dn.suffix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityProtocol','', 'config.ldap.security.protocol', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePath','', 'config.ldap.truststore.path', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePassword','', 'config.ldap.truststore.password', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLoginAttr','uid', 'config.ldap.login.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFNameAttr','givenName', 'config.ldap.fname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLNameAttr','sn', 'config.ldap.lname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEmailAttr','mail', 'config.ldap.email.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr1Attr','postalAddress', 'config.ldap.addr1.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr2Attr','', 'config.ldap.addr2.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr3Attr','', 'config.ldap.addr3.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCityAttr','l', 'config.ldap.city.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPStateAttr','st', 'config.ldap.state.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPostcodeAttr','postalCode', 'config.ldap.postcode.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCountryAttr','', 'config.ldap.country.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDayPhoneAttr','telephoneNumber', 'config.ldap.day.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEveningPhoneAttr','homePhone', 'config.ldap.evening.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFaxAttr','facsimileTelephoneNumber', 'config.ldap.fax.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMobileAttr','mobile', 'config.ldap.mobile.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLocaleAttr','preferredLanguage', 'config.ldap.locale.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDisabledAttr','!accountStatus', 'config.ldap.disabled.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgAttr','deetITSchoolCode', 'config.ldap.org.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPRolesAttr','memberOf', 'config.ldap.roles.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.learner.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.monitor.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAuthorMap','Teacher;SeniorStaff;Principal', 'config.ldap.author.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupAdminMap','Teacher;SeniorStaff', 'config.ldap.group.admin.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupManagerMap','Principal', 'config.ldap.group.manager.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPUpdateOnLogin', 'true', 'config.ldap.update.on.login', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgField', 'code', 'config.ldap.org.field', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOnlyOneOrg', 'true', 'config.ldap.only.one.org', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEncryptPasswordFromBrowser', 'true', 'config.ldap.encrypt.password.from.browser', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSearchResultsPageSize', '100', 'config.ldap.search.results.page.size', 'config.header.ldap', 'LONG', 0);
Index: lams_common/db/sql/insert_lams_windows_config_data.sql
===================================================================
diff -u -r053b3694d8631a983eb8e95e3f0374a22540b43a -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/db/sql/insert_lams_windows_config_data.sql (.../insert_lams_windows_config_data.sql) (revision 053b3694d8631a983eb8e95e3f0374a22540b43a)
+++ lams_common/db/sql/insert_lams_windows_config_data.sql (.../insert_lams_windows_config_data.sql) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -1,71 +1,212 @@
-insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/lams/');
-insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','lams/');
-insert into lams_configuration (config_key, config_value) values ('Version','2.0.4');
-insert into lams_configuration (config_key, config_value) values ('TempDir','C:/lams/temp');
-insert into lams_configuration (config_key, config_value) values ('DumpDir','C:/lams/dump');
-insert into lams_configuration (config_key, config_value) values ('EARDir','C:/jboss-4.0.2/server/default/deploy/lams.ear');
-insert into lams_configuration (config_key, config_value) values ('SMTPServer','');
-insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','C:/lams/repository');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576');
-insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096');
-insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs');
-insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400');
-insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false');
-insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7');
-insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true');
-insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','2.0.4.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU');
-insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR');
-insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-05-24');
-insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/');
-insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin');
-insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire');
-insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','default');
-insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','defaultHTML');
-insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false');
-insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false');
-insert into lams_configuration (config_key, config_value) values ('AllowLiveEdit','true');
-insert into lams_configuration (config_key, config_value) values ('LDAPProvisioningEnabled','false');
-insert into lams_configuration (config_key, config_value) values ('LDAPProviderURL','ldap://192.168.111.15');
-insert into lams_configuration (config_key, config_value) values ('LDAPSecurityAuthentication','simple');
-insert into lams_configuration (config_key, config_value) values ('LDAPPrincipalDNPrefix','cn=');
-insert into lams_configuration (config_key, config_value) values ('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au');
-insert into lams_configuration (config_key, config_value) values ('LDAPSecurityProtocol','');
-insert into lams_configuration (config_key, config_value) values ('LDAPTruststorePath','');
-insert into lams_configuration (config_key, config_value) values ('LDAPTruststorePassword','');
-insert into lams_configuration (config_key, config_value) values ('LDAPLoginAttr','uid');
-insert into lams_configuration (config_key, config_value) values ('LDAPFNameAttr','givenName');
-insert into lams_configuration (config_key, config_value) values ('LDAPLNameAttr','sn');
-insert into lams_configuration (config_key, config_value) values ('LDAPEmailAttr','mail');
-insert into lams_configuration (config_key, config_value) values ('LDAPAddr1Attr','postalAddress');
-insert into lams_configuration (config_key, config_value) values ('LDAPAddr2Attr','');
-insert into lams_configuration (config_key, config_value) values ('LDAPAddr3Attr','');
-insert into lams_configuration (config_key, config_value) values ('LDAPCityAttr','l');
-insert into lams_configuration (config_key, config_value) values ('LDAPStateAttr','st');
-insert into lams_configuration (config_key, config_value) values ('LDAPPostcodeAttr','postalCode');
-insert into lams_configuration (config_key, config_value) values ('LDAPCountryAttr','');
-insert into lams_configuration (config_key, config_value) values ('LDAPDayPhoneAttr','telephoneNumber');
-insert into lams_configuration (config_key, config_value) values ('LDAPEveningPhoneAttr','homePhone');
-insert into lams_configuration (config_key, config_value) values ('LDAPFaxAttr','facsimileTelephoneNumber');
-insert into lams_configuration (config_key, config_value) values ('LDAPMobileAttr','mobile');
-insert into lams_configuration (config_key, config_value) values ('LDAPLocaleAttr','preferredLanguage');
-insert into lams_configuration (config_key, config_value) values ('LDAPDisabledAttr','!accountStatus');
-insert into lams_configuration (config_key, config_value) values ('LDAPOrgAttr','deetITSchoolCode');
-insert into lams_configuration (config_key, config_value) values ('LDAPRolesAttr','memberOf');
-insert into lams_configuration (config_key, config_value) values ('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPAuthorMap','Teacher;SeniorStaff;Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPGroupAdminMap','Teacher;SeniorStaff');
-insert into lams_configuration (config_key, config_value) values ('LDAPGroupManagerMap','Principal');
-insert into lams_configuration (config_key, config_value) values ('LDAPUpdateOnLogin', 'true');
-insert into lams_configuration (config_key, config_value) values ('LDAPOrgField', 'code');
-insert into lams_configuration (config_key, config_value) values ('LDAPOnlyOneOrg', 'true');
-insert into lams_configuration (config_key, config_value) values ('LDAPEncryptPasswordFromBrowser', 'false');
-insert into lams_configuration (config_key, config_value) values ('LDAPSearchResultsPageSize', '100');
\ No newline at end of file
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURL','http://localhost:8080/lams/', 'config.server.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURLContextPath','lams/', 'config.server.url.context.path', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('Version','2.0.4', 'config.version', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('TempDir','C:/lams/temp', 'config.temp.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DumpDir','C:/lams/dump', 'config.dump.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('EARDir','C:/jboss-4.0.2/server/default/deploy/lams.ear', 'config.ear.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('SMTPServer','', 'config.smtp.server', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au', 'config.lams.support.email', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ContentRepositoryPath','C:/lams/repository', 'config.content.repository.path', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxSize','1048576', 'config.upload.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadLargeFileMaxSize','10485760', 'config.upload.large.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxMemorySize','4096', 'config.upload.file.max.memory.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs', 'config.executable.extensions', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UserInactiveTimeout','86400', 'config.user.inactive.timeout', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UseCacheDebugListener','false', 'config.use.cache.debug.listener', 'config.header.system', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('CleanupPreviewOlderThanDays','7', 'config.cleanup.preview.older.than.days', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringActivitiesColour', 'true', 'config.authoring.activities.colour', 'config.header.look.feel', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringClientVersion','2.0.4.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('MonitorClientVersion','2.0.4.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LearnerClientVersion','2.0.4.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerVersionNumber','2.0.4.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerLanguage','en_AU', 'config.server.language', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerPageDirection','LTR', 'config.server.page.direction', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DictionaryDateCreated','2007-05-24', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/', 'config.help.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppDomain','shaun.melcoe.mq.edu.au', 'config.xmpp.domain', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppConference','conference.shaun.melcoe.mq.edu.au', 'config.xmpp.conference', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppAdmin','admin', 'config.xmpp.admin', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppPassword','wildfire', 'config.xmpp.password', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultFlashTheme','default', 'config.default.flash.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultHTMLTheme','defaultHTML', 'config.default.html.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowDirectLessonLaunch','false', 'config.allow.direct.lesson.launch', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LAMS_Community_enable','false', 'config.community.enable', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowLiveEdit','true', 'config.allow.live.edit', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProvisioningEnabled','false', 'config.ldap.provisioning.enabled', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProviderURL','ldap://192.168.111.15', 'config.ldap.provider.url', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityAuthentication','simple', 'config.ldap.security.authentication', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNPrefix','cn=', 'config.ldap.principal.dn.prefix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au', 'config.ldap.principal.dn.suffix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityProtocol','', 'config.ldap.security.protocol', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePath','', 'config.ldap.truststore.path', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePassword','', 'config.ldap.truststore.password', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLoginAttr','uid', 'config.ldap.login.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFNameAttr','givenName', 'config.ldap.fname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLNameAttr','sn', 'config.ldap.lname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEmailAttr','mail', 'config.ldap.email.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr1Attr','postalAddress', 'config.ldap.addr1.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr2Attr','', 'config.ldap.addr2.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr3Attr','', 'config.ldap.addr3.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCityAttr','l', 'config.ldap.city.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPStateAttr','st', 'config.ldap.state.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPostcodeAttr','postalCode', 'config.ldap.postcode.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCountryAttr','', 'config.ldap.country.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDayPhoneAttr','telephoneNumber', 'config.ldap.day.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEveningPhoneAttr','homePhone', 'config.ldap.evening.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFaxAttr','facsimileTelephoneNumber', 'config.ldap.fax.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMobileAttr','mobile', 'config.ldap.mobile.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLocaleAttr','preferredLanguage', 'config.ldap.locale.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDisabledAttr','!accountStatus', 'config.ldap.disabled.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgAttr','deetITSchoolCode', 'config.ldap.org.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPRolesAttr','memberOf', 'config.ldap.roles.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.learner.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.monitor.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAuthorMap','Teacher;SeniorStaff;Principal', 'config.ldap.author.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupAdminMap','Teacher;SeniorStaff', 'config.ldap.group.admin.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupManagerMap','Principal', 'config.ldap.group.manager.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPUpdateOnLogin', 'true', 'config.ldap.update.on.login', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgField', 'code', 'config.ldap.org.field', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOnlyOneOrg', 'true', 'config.ldap.only.one.org', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEncryptPasswordFromBrowser', 'true', 'config.ldap.encrypt.password.from.browser', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSearchResultsPageSize', '100', 'config.ldap.search.results.page.size', 'config.header.ldap', 'LONG', 0);
Index: lams_common/db/sql/insert_rams_unix_config_data.sql
===================================================================
diff -u -re9eb94cfaf1cbbe9736dc5dc63aed57d4cccd57e -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/db/sql/insert_rams_unix_config_data.sql (.../insert_rams_unix_config_data.sql) (revision e9eb94cfaf1cbbe9736dc5dc63aed57d4cccd57e)
+++ lams_common/db/sql/insert_rams_unix_config_data.sql (.../insert_rams_unix_config_data.sql) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -1,34 +1,212 @@
-insert into lams_configuration (config_key, config_value) values ('ServerURL','http://shaun.melcoe.mq.edu.au/rams/');
-insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','rams/');
-insert into lams_configuration (config_key, config_value) values ('Version','1.0 Beta');
-insert into lams_configuration (config_key, config_value) values ('TempDir','/var/opt/rams/temp');
-insert into lams_configuration (config_key, config_value) values ('DumpDir','/var/opt/rams/dump');
-insert into lams_configuration (config_key, config_value) values ('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/rams.ear');
-insert into lams_configuration (config_key, config_value) values ('SMTPServer','');
-insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','/var/opt/rams/repository');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576');
-insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096');
-insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs');
-insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400');
-insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false');
-insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7');
-insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true');
-insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU');
-insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR');
-insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-05-24');
-insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/');
-insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin');
-insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire');
-insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','rams');
-insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','ramsthemeHTML');
-insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false');
-insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false');
-insert into lams_configuration (config_key, config_value) values ('AllowLiveEdit','true');
\ No newline at end of file
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURL','http://shaun.melcoe.mq.edu.au/rams/', 'config.server.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURLContextPath','rams/', 'config.server.url.context.path', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('Version','1.0 Beta', 'config.version', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('TempDir','/var/opt/rams/temp', 'config.temp.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DumpDir','/var/opt/rams/dump', 'config.dump.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/rams.ear', 'config.ear.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('SMTPServer','', 'config.smtp.server', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au', 'config.lams.support.email', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ContentRepositoryPath','/var/opt/rams/repository', 'config.content.repository.path', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxSize','1048576', 'config.upload.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadLargeFileMaxSize','10485760', 'config.upload.large.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxMemorySize','4096', 'config.upload.file.max.memory.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs', 'config.executable.extensions', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UserInactiveTimeout','86400', 'config.user.inactive.timeout', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UseCacheDebugListener','false', 'config.use.cache.debug.listener', 'config.header.system', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('CleanupPreviewOlderThanDays','7', 'config.cleanup.preview.older.than.days', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringActivitiesColour', 'true', 'config.authoring.activities.colour', 'config.header.look.feel', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringClientVersion','0.8.1.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('MonitorClientVersion','0.8.1.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LearnerClientVersion','0.8.1.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerVersionNumber','0.8.1.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerLanguage','en_AU', 'config.server.language', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerPageDirection','LTR', 'config.server.page.direction', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DictionaryDateCreated','2007-05-24', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/', 'config.help.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppDomain','shaun.melcoe.mq.edu.au', 'config.xmpp.domain', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppConference','conference.shaun.melcoe.mq.edu.au', 'config.xmpp.conference', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppAdmin','admin', 'config.xmpp.admin', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppPassword','wildfire', 'config.xmpp.password', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultFlashTheme','default', 'config.default.flash.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultHTMLTheme','defaultHTML', 'config.default.html.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowDirectLessonLaunch','false', 'config.allow.direct.lesson.launch', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LAMS_Community_enable','false', 'config.community.enable', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowLiveEdit','true', 'config.allow.live.edit', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProvisioningEnabled','false', 'config.ldap.provisioning.enabled', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProviderURL','ldap://192.168.111.15', 'config.ldap.provider.url', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityAuthentication','simple', 'config.ldap.security.authentication', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNPrefix','cn=', 'config.ldap.principal.dn.prefix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au', 'config.ldap.principal.dn.suffix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityProtocol','', 'config.ldap.security.protocol', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePath','', 'config.ldap.truststore.path', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePassword','', 'config.ldap.truststore.password', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLoginAttr','uid', 'config.ldap.login.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFNameAttr','givenName', 'config.ldap.fname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLNameAttr','sn', 'config.ldap.lname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEmailAttr','mail', 'config.ldap.email.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr1Attr','postalAddress', 'config.ldap.addr1.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr2Attr','', 'config.ldap.addr2.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr3Attr','', 'config.ldap.addr3.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCityAttr','l', 'config.ldap.city.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPStateAttr','st', 'config.ldap.state.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPostcodeAttr','postalCode', 'config.ldap.postcode.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCountryAttr','', 'config.ldap.country.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDayPhoneAttr','telephoneNumber', 'config.ldap.day.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEveningPhoneAttr','homePhone', 'config.ldap.evening.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFaxAttr','facsimileTelephoneNumber', 'config.ldap.fax.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMobileAttr','mobile', 'config.ldap.mobile.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLocaleAttr','preferredLanguage', 'config.ldap.locale.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDisabledAttr','!accountStatus', 'config.ldap.disabled.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgAttr','deetITSchoolCode', 'config.ldap.org.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPRolesAttr','memberOf', 'config.ldap.roles.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.learner.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.monitor.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAuthorMap','Teacher;SeniorStaff;Principal', 'config.ldap.author.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupAdminMap','Teacher;SeniorStaff', 'config.ldap.group.admin.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupManagerMap','Principal', 'config.ldap.group.manager.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPUpdateOnLogin', 'true', 'config.ldap.update.on.login', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgField', 'code', 'config.ldap.org.field', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOnlyOneOrg', 'true', 'config.ldap.only.one.org', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEncryptPasswordFromBrowser', 'true', 'config.ldap.encrypt.password.from.browser', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSearchResultsPageSize', '100', 'config.ldap.search.results.page.size', 'config.header.ldap', 'LONG', 0);
Index: lams_common/db/sql/insert_rams_windows_config_data.sql
===================================================================
diff -u -re9eb94cfaf1cbbe9736dc5dc63aed57d4cccd57e -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/db/sql/insert_rams_windows_config_data.sql (.../insert_rams_windows_config_data.sql) (revision e9eb94cfaf1cbbe9736dc5dc63aed57d4cccd57e)
+++ lams_common/db/sql/insert_rams_windows_config_data.sql (.../insert_rams_windows_config_data.sql) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -1,34 +1,212 @@
-insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/rams/');
-insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','rams/');
-insert into lams_configuration (config_key, config_value) values ('Version','1.0 Beta');
-insert into lams_configuration (config_key, config_value) values ('TempDir','C:/rams/temp');
-insert into lams_configuration (config_key, config_value) values ('DumpDir','C:/rams/dump');
-insert into lams_configuration (config_key, config_value) values ('EARDir','C:/jboss-4.0.2/server/default/deploy/rams.ear/');
-insert into lams_configuration (config_key, config_value) values ('SMTPServer','');
-insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','C:/rams/repository');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxSize','1048576');
-insert into lams_configuration (config_key, config_value) values ('UploadLargeFileMaxSize','10485760');
-insert into lams_configuration (config_key, config_value) values ('UploadFileMaxMemorySize','4096');
-insert into lams_configuration (config_key, config_value) values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs');
-insert into lams_configuration (config_key, config_value) values ('UserInactiveTimeout','86400');
-insert into lams_configuration (config_key, config_value) values ('UseCacheDebugListener','false');
-insert into lams_configuration (config_key, config_value) values ('CleanupPreviewOlderThanDays','7');
-insert into lams_configuration (config_key, config_value) values ('AuthoringActivitiesColour', 'true');
-insert into lams_configuration (config_key, config_value) values ('AuthoringClientVersion','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('MonitorClientVersion','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('LearnerClientVersion','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerVersionNumber','0.8.1.@datetimestamp@');
-insert into lams_configuration (config_key, config_value) values ('ServerLanguage','en_AU');
-insert into lams_configuration (config_key, config_value) values ('ServerPageDirection','LTR');
-insert into lams_configuration (config_key, config_value) values ('DictionaryDateCreated','2007-05-24');
-insert into lams_configuration (config_key, config_value) values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/');
-insert into lams_configuration (config_key, config_value) values ('XmppDomain','shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppConference','conference.shaun.melcoe.mq.edu.au');
-insert into lams_configuration (config_key, config_value) values ('XmppAdmin','admin');
-insert into lams_configuration (config_key, config_value) values ('XmppPassword','wildfire');
-insert into lams_configuration (config_key, config_value) values ('DefaultFlashTheme','rams');
-insert into lams_configuration (config_key, config_value) values ('DefaultHTMLTheme','ramsthemeHTML');
-insert into lams_configuration (config_key, config_value) values ('AllowDirectLessonLaunch','false');
-insert into lams_configuration (config_key, config_value) values ('LAMS_Community_enable','false');
-insert into lams_configuration (config_key, config_value) values ('AllowLiveEdit','true');
\ No newline at end of file
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURL','http://localhost:8080/rams/', 'config.server.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerURLContextPath','rams/', 'config.server.url.context.path', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('Version','1.0 Beta', 'config.version', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('TempDir','C:/rams/temp', 'config.temp.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DumpDir','C:/rams/dump', 'config.dump.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('EARDir','C:/jboss-4.0.2/server/default/deploy/rams.ear', 'config.ear.dir', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('SMTPServer','', 'config.smtp.server', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au', 'config.lams.support.email', 'config.header.email', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ContentRepositoryPath','C:/rams/repository', 'config.content.repository.path', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxSize','1048576', 'config.upload.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadLargeFileMaxSize','10485760', 'config.upload.large.file.max.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UploadFileMaxMemorySize','4096', 'config.upload.file.max.memory.size', 'config.header.uploads', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs', 'config.executable.extensions', 'config.header.uploads', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UserInactiveTimeout','86400', 'config.user.inactive.timeout', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('UseCacheDebugListener','false', 'config.use.cache.debug.listener', 'config.header.system', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('CleanupPreviewOlderThanDays','7', 'config.cleanup.preview.older.than.days', 'config.header.system', 'LONG', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringActivitiesColour', 'true', 'config.authoring.activities.colour', 'config.header.look.feel', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AuthoringClientVersion','0.8.1.@datetimestamp@', 'config.authoring.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('MonitorClientVersion','0.8.1.@datetimestamp@', 'config.monitor.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LearnerClientVersion','0.8.1.@datetimestamp@', 'config.learner.client.version', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerVersionNumber','0.8.1.@datetimestamp@', 'config.server.version.number', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerLanguage','en_AU', 'config.server.language', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('ServerPageDirection','LTR', 'config.server.page.direction', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DictionaryDateCreated','2007-05-24', 'config.dictionary.date.created', 'config.header.versions', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/', 'config.help.url', 'config.header.system', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppDomain','shaun.melcoe.mq.edu.au', 'config.xmpp.domain', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppConference','conference.shaun.melcoe.mq.edu.au', 'config.xmpp.conference', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppAdmin','admin', 'config.xmpp.admin', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('XmppPassword','wildfire', 'config.xmpp.password', 'config.header.chat', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultFlashTheme','default', 'config.default.flash.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('DefaultHTMLTheme','defaultHTML', 'config.default.html.theme', 'config.header.look.feel', 'STRING', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowDirectLessonLaunch','false', 'config.allow.direct.lesson.launch', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LAMS_Community_enable','false', 'config.community.enable', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('AllowLiveEdit','true', 'config.allow.live.edit', 'config.header.features', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProvisioningEnabled','false', 'config.ldap.provisioning.enabled', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPProviderURL','ldap://192.168.111.15', 'config.ldap.provider.url', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityAuthentication','simple', 'config.ldap.security.authentication', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNPrefix','cn=', 'config.ldap.principal.dn.prefix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au', 'config.ldap.principal.dn.suffix', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSecurityProtocol','', 'config.ldap.security.protocol', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePath','', 'config.ldap.truststore.path', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPTruststorePassword','', 'config.ldap.truststore.password', 'config.header.ldap', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLoginAttr','uid', 'config.ldap.login.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFNameAttr','givenName', 'config.ldap.fname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLNameAttr','sn', 'config.ldap.lname.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEmailAttr','mail', 'config.ldap.email.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr1Attr','postalAddress', 'config.ldap.addr1.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr2Attr','', 'config.ldap.addr2.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAddr3Attr','', 'config.ldap.addr3.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCityAttr','l', 'config.ldap.city.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPStateAttr','st', 'config.ldap.state.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPPostcodeAttr','postalCode', 'config.ldap.postcode.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPCountryAttr','', 'config.ldap.country.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDayPhoneAttr','telephoneNumber', 'config.ldap.day.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEveningPhoneAttr','homePhone', 'config.ldap.evening.phone.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPFaxAttr','facsimileTelephoneNumber', 'config.ldap.fax.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMobileAttr','mobile', 'config.ldap.mobile.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLocaleAttr','preferredLanguage', 'config.ldap.locale.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPDisabledAttr','!accountStatus', 'config.ldap.disabled.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgAttr','deetITSchoolCode', 'config.ldap.org.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPRolesAttr','memberOf', 'config.ldap.roles.attr', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.learner.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal', 'config.ldap.monitor.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPAuthorMap','Teacher;SeniorStaff;Principal', 'config.ldap.author.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupAdminMap','Teacher;SeniorStaff', 'config.ldap.group.admin.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPGroupManagerMap','Principal', 'config.ldap.group.manager.map', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPUpdateOnLogin', 'true', 'config.ldap.update.on.login', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOrgField', 'code', 'config.ldap.org.field', 'config.header.ldap.attributes', 'STRING', 0);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPOnlyOneOrg', 'true', 'config.ldap.only.one.org', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPEncryptPasswordFromBrowser', 'true', 'config.ldap.encrypt.password.from.browser', 'config.header.ldap', 'BOOLEAN', 1);
+
+insert into lams_configuration (config_key, config_value, description_key, header_name, format, required)
+values ('LDAPSearchResultsPageSize', '100', 'config.ldap.search.results.page.size', 'config.header.ldap', 'LONG', 0);
Index: lams_common/db/sql/updatescripts/alter_21_branching.sql
===================================================================
diff -u -r1e741053dedb977b7207ee80cbb3c2821b7a5cd6 -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/db/sql/updatescripts/alter_21_branching.sql (.../alter_21_branching.sql) (revision 1e741053dedb977b7207ee80cbb3c2821b7a5cd6)
+++ lams_common/db/sql/updatescripts/alter_21_branching.sql (.../alter_21_branching.sql) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -105,50 +105,75 @@
, ADD COLUMN format VARCHAR(30)
, ADD COLUMN required TINYINT NOT NULL DEFAULT 0;
-update lams_configuration set description_key = 'config.server.url', header_name='config.header.system', format='STRING', required=1
-where config_key = 'ServerURL';
+update lams_configuration st description_key='config.server.url', header_name='config.header.system', format='STRING', required=1 where config_key='ServerURL';
+update lams_configuration set description_key='config.server.url.context.path', header_name='config.header.system', format='STRING', required=1 where config_key='ServerURLContextPath';
+update lams_configuration set description_key='config.version', header_name='config.header.system', format='STRING', required=1 where config_key='Version';
+update lams_configuration set description_key='config.temp.dir', header_name='config.header.system', format='STRING', required=1 where config_key='TempDir';
+update lams_configuration set description_key='config.dump.dir', header_name='config.header.system', format='STRING', required=1 where config_key='DumpDir';
+update lams_configuration set description_key='config.ear.dir', header_name='config.header.system', format='STRING', required=1 where config_key='EARDir';
+update lams_configuration set description_key='config.smtp.server', header_name='config.header.email', format='STRING', required=1 where config_key='SMTPServer';
+update lams_configuration set description_key='config.lams.support.email', header_name='config.header.email', format='STRING', required=1 where config_key='LamsSupportEmail';
+update lams_configuration set description_key='config.content.repository.path', header_name='config.header.uploads', format='STRING', required=1 where config_key='ContentRepositoryPath';
+update lams_configuration set description_key='config.upload.file.max.size', header_name='config.header.uploads', format='LONG', required=1 where config_key='UploadFileMaxSize';
+update lams_configuration set description_key='config.upload.large.file.max.size', header_name='config.header.uploads', format='LONG', required=1 where config_key='UploadLargeFileMaxSize';
+update lams_configuration set description_key='config.upload.file.max.memory.size', header_name='config.header.uploads', format='LONG', required=1 where config_key='UploadFileMaxMemorySize';
+update lams_configuration set description_key='config.executable.extensions', header_name='config.header.uploads', format='STRING', required=1 where config_key='ExecutableExtensions';
+update lams_configuration set description_key='config.user.inactive.timeout', header_name='config.header.system', format='LONG', required=1 where config_key='UserInactiveTimeout';
+update lams_configuration set description_key='config.use.cache.debug.listener', header_name='config.header.system', format='BOOLEAN', required=1 where config_key='UseCacheDebugListener';
+update lams_configuration set description_key='config.cleanup.preview.older.than.days', header_name='config.header.system', format='LONG', required=1 where config_key='CleanupPreviewOlderThanDays';
+update lams_configuration set description_key='config.authoring.activities.colour', header_name='config.header.look.feel', format='BOOLEAN', required=1 where config_key='AuthoringActivitiesColour';
+update lams_configuration set description_key='config.authoring.client.version', header_name='config.header.versions', format='STRING', required=1 where config_key='AuthoringClientVersion';
+update lams_configuration set description_key='config.monitor.client.version', header_name='config.header.versions', format='STRING', required=1 where config_key='MonitorClientVersion';
+update lams_configuration set description_key='config.learner.client.version', header_name='config.header.versions', format='STRING', required=1 where config_key='LearnerClientVersion';
+update lams_configuration set description_key='config.server.version.number', header_name='config.header.versions', format='STRING', required=1 where config_key='ServerVersionNumber';
+update lams_configuration set description_key='config.server.language', header_name='config.header.look.feel', format='STRING', required=1 where config_key='ServerLanguage';
+update lams_configuration set description_key='config.server.page.direction', header_name='config.header.look.feel', format='STRING', required=1 where config_key='ServerPageDirection';
+update lams_configuration set description_key='config.dictionary.date.created', header_name='config.header.versions', format='STRING', required=1 where config_key='DictionaryDateCreated';
+update lams_configuration set description_key='config.help.url', header_name='config.header.system', format='STRING', required=1 where config_key='HelpURL';
+update lams_configuration set description_key='config.xmpp.domain', header_name='config.header.chat', format='STRING', required=1 where config_key='XmppDomain';
+update lams_configuration set description_key='config.xmpp.conference', header_name='config.header.chat', format='STRING', required=1 where config_key='XmppConference';
+update lams_configuration set description_key='config.xmpp.admin', header_name='config.header.chat', format='STRING', required=1 where config_key='XmppAdmin';
+update lams_configuration set description_key='config.xmpp.password', header_name='config.header.chat', format='STRING', required=1 where config_key='XmppPassword';
+update lams_configuration set description_key='config.default.flash.theme', header_name='config.header.look.feel', format='STRING', required=1 where config_key='DefaultFlashTheme';
+update lams_configuration set description_key='config.default.html.theme', header_name='config.header.look.feel', format='STRING', required=1 where config_key='DefaultHTMLTheme';
+update lams_configuration set description_key='config.allow.direct.lesson.launch', header_name='config.header.features', format='BOOLEAN', required=1 where config_key='AllowDirectLessonLaunch';
+update lams_configuration set description_key='config.community.enable', header_name='config.header.features', format='BOOLEAN', required=1 where config_key='LAMS_Community_enable';
+update lams_configuration set description_key='config.allow.live.edit', header_name='config.header.features', format='BOOLEAN', required=1 where config_key='AllowLiveEdit';
+update lams_configuration set description_key='config.ldap.provisioning.enabled', header_name='config.header.ldap', format='BOOLEAN', required=1 where config_key='LDAPProvisioningEnabled';
+update lams_configuration set description_key='config.ldap.provider.url', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPProviderURL';
+update lams_configuration set description_key='config.ldap.security.authentication', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPSecurityAuthentication';
+update lams_configuration set description_key='config.ldap.principal.dn.prefix', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPPrincipalDNPrefix';
+update lams_configuration set description_key='config.ldap.principal.dn.suffix', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPPrincipalDNSuffix';
+update lams_configuration set description_key='config.ldap.security.protocol', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPSecurityProtocol';
+update lams_configuration set description_key='config.ldap.truststore.path', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPTruststorePath';
+update lams_configuration set description_key='config.ldap.truststore.password', header_name='config.header.ldap', format='STRING', required=0 where config_key='LDAPTruststorePassword';
+update lams_configuration set description_key='config.ldap.login.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPLoginAttr';
+update lams_configuration set description_key='config.ldap.fname.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPFNameAttr';
+update lams_configuration set description_key='config.ldap.lname.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPLNameAttr';
+update lams_configuration set description_key='config.ldap.email.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPEmailAttr';
+update lams_configuration set description_key='config.ldap.addr1.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPAddr1Attr';
+update lams_configuration set description_key='config.ldap.addr2.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPAddr2Attr';
+update lams_configuration set description_key='config.ldap.addr3.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPAddr3Attr';
+update lams_configuration set description_key='config.ldap.city.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPCityAttr';
+update lams_configuration set description_key='config.ldap.state.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPStateAttr';
+update lams_configuration set description_key='config.ldap.postcode.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPPostcodeAttr';
+update lams_configuration set description_key='config.ldap.country.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPCountryAttr';
+update lams_configuration set description_key='config.ldap.day.phone.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPDayPhoneAttr';
+update lams_configuration set description_key='config.ldap.evening.phone.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPEveningPhoneAttr';
+update lams_configuration set description_key='config.ldap.fax.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPFaxAttr';
+update lams_configuration set description_key='config.ldap.mobile.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPMobileAttr';
+update lams_configuration set description_key='config.ldap.locale.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPLocaleAttr';
+update lams_configuration set description_key='config.ldap.disabled.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPDisabledAttr';
+update lams_configuration set description_key='config.ldap.org.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPOrgAttr';
+update lams_configuration set description_key='config.ldap.roles.attr', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPRolesAttr';
+update lams_configuration set description_key='config.ldap.learner.map', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPLearnerMap';
+update lams_configuration set description_key='config.ldap.monitor.map', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPMonitorMap';
+update lams_configuration set description_key='config.ldap.author.map', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPAuthorMap';
+update lams_configuration set description_key='config.ldap.group.admin.map', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPGroupAdminMap';
+update lams_configuration set description_key='config.ldap.group.manager.map', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPGroupManagerMap';
+update lams_configuration set description_key='config.ldap.update.on.login', header_name='config.header.ldap', format='BOOLEAN', required=1 where config_key='LDAPUpdateOnLogin';
+update lams_configuration set description_key='config.ldap.org.field', header_name='config.header.ldap.attributes', format='STRING', required=0 where config_key='LDAPOrgField';
+update lams_configuration set description_key='config.ldap.only.one.org', header_name='config.header.ldap', format='BOOLEAN', required=1 where config_key='LDAPOnlyOneOrg';
+update lams_configuration set description_key='config.ldap.encrypt.password.from.browser', header_name='config.header.ldap', format='BOOLEAN', required=1 where config_key='LDAPEncryptPasswordFromBrowser';
+update lams_configuration set description_key='config.ldap.search.results.page.size', header_name='config.header.ldap', format='LONG', required=0 where config_key='LDAPSearchResultsPageSize';
-update lams_configuration set description_key = 'config.server.url.context.path', header_name='config.header.system', format='STRING', required=1
-where config_key = 'ServerURLContextPath';
-
-update lams_configuration set description_key = 'config.version', header_name='config.header.system', format='STRING', required=1
-where config_key = 'Version';
-
-update lams_configuration set description_key = 'config.temp.dir', header_name='config.header.system', format='STRING', required=1
-where config_key = 'TempDir';
-
-update lams_configuration set description_key = 'config.dump.dir', header_name='config.header.system', format='STRING', required=1
-where config_key = 'DumpDir';
-
-update lams_configuration set description_key = 'config.ear.dir', header_name='config.header.system', format='STRING', required=1
-where config_key = 'EARDir';
-
-update lams_configuration set description_key = 'config.smtp.server', header_name='config.header.system', format='STRING', required=0
-where config_key = 'SMTPServer';
-
-update lams_configuration set description_key = 'config.lams.support.email', header_name='config.header.system', format='STRING', required=0
-where config_key = 'LamsSupportEmail';
-
-update lams_configuration set description_key = 'config.content.repository.path', header_name='config.header.system', format='STRING', required=1
-where config_key = 'ContentRepositoryPath';
-
-update lams_configuration set description_key = 'config.upload.file.max.size', header_name='config.header.system', format='LONG', required=1
-where config_key = 'UploadFileMaxSize';
-
-update lams_configuration set description_key = 'config.upload.large.file.max.size', header_name='config.header.system', format='LONG', required=1
-where config_key = 'UploadLargeFileMaxSize';
-
-update lams_configuration set description_key = 'config.upload.file.max.memory.size', header_name='config.header.system', format='LONG', required=1
-where config_key = 'UploadFileMaxMemorySize';
-
-update lams_configuration set description_key = 'config.executable.extensions', header_name='config.header.system', format='STRING', required=1
-where config_key = 'ExecutableExtensions';
-
-update lams_configuration set description_key = 'config.user.inactive.timeout', header_name='config.header.system', format='LONG', required=1
-where config_key = 'UserInactiveTimeout';
-
-update lams_configuration set description_key = 'config.use.cache.debug.listener', header_name='config.header.system', format='BOOLEAN', required=1
-where config_key = 'UseCacheDebugListener';
-
-update lams_configuration set description_key = 'config.cleanup.preview.older.than.days', header_name='config.header.system', format='LONG', required=1
-where config_key = 'CleanupPreviewOlderThanDays';
Index: lams_common/src/java/org/lamsfoundation/lams/config/ConfigurationItem.java
===================================================================
diff -u -r5eaa43d63738b6e4bfa6d42f3c8842cdacb9c798 -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/src/java/org/lamsfoundation/lams/config/ConfigurationItem.java (.../ConfigurationItem.java) (revision 5eaa43d63738b6e4bfa6d42f3c8842cdacb9c798)
+++ lams_common/src/java/org/lamsfoundation/lams/config/ConfigurationItem.java (.../ConfigurationItem.java) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -129,7 +129,7 @@
/**
* @hibernate.property column="required" not-null="true"
*/
- public Boolean isRequired() {
+ public Boolean getRequired() {
return required;
}
Index: lams_common/src/java/org/lamsfoundation/lams/config/dao/hibernate/ConfigurationDAO.java
===================================================================
diff -u -re136309c831c4509819e7651ce2f565747bccb57 -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/src/java/org/lamsfoundation/lams/config/dao/hibernate/ConfigurationDAO.java (.../ConfigurationDAO.java) (revision e136309c831c4509819e7651ce2f565747bccb57)
+++ lams_common/src/java/org/lamsfoundation/lams/config/dao/hibernate/ConfigurationDAO.java (.../ConfigurationDAO.java) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -31,7 +31,6 @@
import org.lamsfoundation.lams.config.dao.IConfigurationDAO;
import org.lamsfoundation.lams.dao.hibernate.BaseDAO;
import org.springframework.orm.hibernate3.HibernateCallback;
-import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
/**
@@ -41,7 +40,8 @@
*/
public class ConfigurationDAO extends BaseDAO implements IConfigurationDAO
{
- private static final String LOAD_CONFIG_ITEM_BY_KEY = "from configuration in class " + ConfigurationItem.class.getName() + " where configuration.key=:key";
+ private static final String LOAD_CONFIG_ITEM_BY_KEY = "from configuration in class " + ConfigurationItem.class.getName()
+ + " where configuration.key=:key";
/**
Index: lams_common/src/java/org/lamsfoundation/lams/util/Configuration.java
===================================================================
diff -u -r1c6f143c4fac1afe0405abad822e10e91c446682 -r7248fb9335792be231dcc498f37b28ffa0c794dc
--- lams_common/src/java/org/lamsfoundation/lams/util/Configuration.java (.../Configuration.java) (revision 1c6f143c4fac1afe0405abad822e10e91c446682)
+++ lams_common/src/java/org/lamsfoundation/lams/util/Configuration.java (.../Configuration.java) (revision 7248fb9335792be231dcc498f37b28ffa0c794dc)
@@ -97,6 +97,10 @@
return items;
}
+ public ConfigurationItem getConfigItemByKey(String key) {
+ return configurationDAO.getConfigItemByKey(key);
+ }
+
public static String getItemValue(Object obj) {
ConfigurationItem item = (ConfigurationItem) obj;
if(item.getValue() != null)