Index: unix_installer/installer-package/.cvsignore =================================================================== diff -u --- unix_installer/installer-package/.cvsignore (revision 0) +++ unix_installer/installer-package/.cvsignore (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -0,0 +1,5 @@ +*.swp +build +build/* +assembly +assembly/* \ No newline at end of file Index: unix_installer/installer-package/ant-scripts/.configure-deploy.xml.swp =================================================================== diff -u Binary files differ Index: unix_installer/installer-package/ant-scripts/configure-deploy.xml =================================================================== diff -u -ra2f8b16b34b729e4cb97f9444102144c68a17dc1 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/ant-scripts/configure-deploy.xml (.../configure-deploy.xml) (revision a2f8b16b34b729e4cb97f9444102144c68a17dc1) +++ unix_installer/installer-package/ant-scripts/configure-deploy.xml (.../configure-deploy.xml) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -30,15 +30,6 @@ - - - - - - - - - Index: unix_installer/installer-package/ant-scripts/version.properties =================================================================== diff -u -ra2f8b16b34b729e4cb97f9444102144c68a17dc1 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/ant-scripts/version.properties (.../version.properties) (revision a2f8b16b34b729e4cb97f9444102144c68a17dc1) +++ unix_installer/installer-package/ant-scripts/version.properties (.../version.properties) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,5 +1,5 @@ # Version identifiers for this installer -LAMS_VERSION=2.0.4 -SERVER_VERSION=2.0.4.200706211047 -LANG_VERSION=2007-06-01 +LAMS_VERSION=2.1-RC1 +SERVER_VERSION=2.0.100.200803121637 +LANG_VERSION=2008-03-12 Index: unix_installer/installer-package/build.xml =================================================================== diff -u -r5ebd604f6669d4c6a2def5a0abe150106e033190 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/build.xml (.../build.xml) (revision 5ebd604f6669d4c6a2def5a0abe150106e033190) +++ unix_installer/installer-package/build.xml (.../build.xml) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,9 +1,9 @@ - + - - + + @@ -64,10 +64,23 @@ + + @@ -79,3 +92,4 @@ + Index: unix_installer/installer-package/conf/j2ee/application.xml =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/conf/j2ee/application.xml (.../application.xml) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/installer-package/conf/j2ee/application.xml (.../application.xml) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,9 +1,7 @@ - - - + LAMS - Learning Activty Management System + Learning Activity Management System @@ -112,6 +110,9 @@ commons-fileupload.jar + commons-io-1.4.jar + + commons-lang-2.0.jar @@ -224,15 +225,4 @@ - - + lams-tool-lafrum11.war/lams/tool/lafrum11lams-tool-lanb11.war/lams/tool/lanb11lams-tool-laqa11.war/lams/tool/laqa11lams-tool-lasbmt11.war/lams/tool/lasbmt11lams-tool-lachat11.war/lams/tool/lachat11lams-tool-larsrc11.war/lams/tool/larsrc11lams-tool-lavote11.war/lams/tool/lavote11lams-tool-lantbk11.war/lams/tool/lantbk11lams-tool-lasurv11.war/lams/tool/lasurv11lams-tool-lascrb11.war/lams/tool/lascrb11lams-tool-lamc11.war/lams/tool/lamc11 \ No newline at end of file Index: unix_installer/installer-package/conf/unix/jboss/.log4j.xml.swp =================================================================== diff -u Binary files differ Index: unix_installer/installer-package/conf/unix/jboss/log4j.xml =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/conf/unix/jboss/log4j.xml (.../log4j.xml) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/installer-package/conf/unix/jboss/log4j.xml (.../log4j.xml) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -36,10 +36,10 @@ - + @@ -53,7 +53,7 @@ - + --> @@ -69,7 +69,7 @@ - + @@ -96,7 +96,7 @@ - + --> @@ -154,7 +154,7 @@ - + @@ -166,15 +166,15 @@ - + - + @@ -185,7 +185,7 @@ - + @@ -195,6 +195,12 @@ + + + + + + @@ -218,7 +224,7 @@ - + Index: unix_installer/installer-package/conf/unix/jboss/login-config.xml =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/conf/unix/jboss/login-config.xml (.../login-config.xml) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/installer-package/conf/unix/jboss/login-config.xml (.../login-config.xml) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -150,13 +150,13 @@ - + - - java:/MySqlDS + + java:/jdbc/lams-ds select password from lams_user where login=? - SELECT DISTINCT r.name,'Roles' FROM + SELECT DISTINCT r.name,'Roles' FROM lams_user u LEFT OUTER JOIN lams_user_organisation uo USING(user_id) LEFT OUTER JOIN lams_user_organisation_role urr USING(user_organisation_id) LEFT OUTER JOIN lams_role r USING (role_id) @@ -166,14 +166,6 @@ - - - - @confdir@/lamsauthentication.xml - - - - Index: unix_installer/installer-package/database/lams.dump =================================================================== diff -u -rc6a8998567722aec174bb639b1fb4d81dece93d8 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/database/lams.dump (.../lams.dump) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) +++ unix_installer/installer-package/database/lams.dump (.../lams.dump) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,8 +1,8 @@ --- MySQL dump 10.10 +-- MySQL dump 10.11 -- -- Host: localhost Database: lams -- ------------------------------------------------------ --- Server version 5.0.24a-Debian_9ubuntu0.1-log +-- Server version 5.0.45-Debian_1ubuntu3.1-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -16,14 +16,6 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- --- Current Database: `lams` --- - ---CREATE DATABASE /*!32312 IF NOT EXISTS*/ `lams` /*!40100 DEFAULT CHARACTER SET utf8 */; - ---USE `lams`; - --- -- Table structure for table `lams_activity_category` -- @@ -38,12 +30,11 @@ -- Dumping data for table `lams_activity_category` -- - -/*!40000 ALTER TABLE `lams_activity_category` DISABLE KEYS */; LOCK TABLES `lams_activity_category` WRITE; +/*!40000 ALTER TABLE `lams_activity_category` DISABLE KEYS */; INSERT INTO `lams_activity_category` VALUES (1,'SYSTEM'),(2,'COLLABORATION'),(3,'ASSESSMENT'),(4,'CONTENT'),(5,'SPLIT'),(6,'RESPONSE'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_activity_category` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_activity_learners` @@ -63,11 +54,10 @@ -- Dumping data for table `lams_activity_learners` -- - -/*!40000 ALTER TABLE `lams_activity_learners` DISABLE KEYS */; LOCK TABLES `lams_activity_learners` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_activity_learners` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_activity_learners` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_auth_method_type` @@ -84,12 +74,11 @@ -- Dumping data for table `lams_auth_method_type` -- - -/*!40000 ALTER TABLE `lams_auth_method_type` DISABLE KEYS */; LOCK TABLES `lams_auth_method_type` WRITE; +/*!40000 ALTER TABLE `lams_auth_method_type` DISABLE KEYS */; INSERT INTO `lams_auth_method_type` VALUES (1,'LAMS'),(2,'WEB_AUTH'),(3,'LDAP'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_auth_method_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_authentication_method` @@ -110,34 +99,95 @@ -- Dumping data for table `lams_authentication_method` -- - -/*!40000 ALTER TABLE `lams_authentication_method` DISABLE KEYS */; LOCK TABLES `lams_authentication_method` WRITE; +/*!40000 ALTER TABLE `lams_authentication_method` DISABLE KEYS */; INSERT INTO `lams_authentication_method` VALUES (1,1,'LAMS-Database'),(2,2,'Oxford-WebAuth'),(3,3,'MQ-LDAP'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_authentication_method` ENABLE KEYS */; +UNLOCK TABLES; -- +-- Table structure for table `lams_branch_activity_entry` +-- + +DROP TABLE IF EXISTS `lams_branch_activity_entry`; +CREATE TABLE `lams_branch_activity_entry` ( + `entry_id` bigint(20) NOT NULL auto_increment, + `entry_ui_id` int(11) default NULL, + `group_id` bigint(20) default NULL, + `sequence_activity_id` bigint(20) NOT NULL, + `branch_activity_id` bigint(20) NOT NULL, + `condition_id` bigint(20) default NULL, + PRIMARY KEY (`entry_id`), + KEY `group_id` (`group_id`), + KEY `sequence_activity_id` (`sequence_activity_id`), + KEY `branch_activity_id` (`branch_activity_id`), + KEY `condition_id` (`condition_id`), + CONSTRAINT `FK_lams_group_activity_1` FOREIGN KEY (`group_id`) REFERENCES `lams_group` (`group_id`), + CONSTRAINT `FK_lams_branch_map_sequence` FOREIGN KEY (`sequence_activity_id`) REFERENCES `lams_learning_activity` (`activity_id`), + CONSTRAINT `FK_lams_branch_map_branch` FOREIGN KEY (`branch_activity_id`) REFERENCES `lams_learning_activity` (`activity_id`), + CONSTRAINT `FK_lams_branch_activity_entry_4` FOREIGN KEY (`condition_id`) REFERENCES `lams_branch_condition` (`condition_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `lams_branch_activity_entry` +-- + +LOCK TABLES `lams_branch_activity_entry` WRITE; +/*!40000 ALTER TABLE `lams_branch_activity_entry` DISABLE KEYS */; +/*!40000 ALTER TABLE `lams_branch_activity_entry` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `lams_branch_condition` +-- + +DROP TABLE IF EXISTS `lams_branch_condition`; +CREATE TABLE `lams_branch_condition` ( + `condition_id` bigint(20) NOT NULL auto_increment, + `condition_ui_id` int(11) default NULL, + `order_id` int(11) default NULL, + `name` varchar(255) NOT NULL, + `display_name` varchar(255) default NULL, + `type` varchar(30) NOT NULL, + `start_value` varchar(255) default NULL, + `end_value` varchar(255) default NULL, + `exact_match_value` varchar(255) default NULL, + PRIMARY KEY (`condition_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `lams_branch_condition` +-- + +LOCK TABLES `lams_branch_condition` WRITE; +/*!40000 ALTER TABLE `lams_branch_condition` DISABLE KEYS */; +/*!40000 ALTER TABLE `lams_branch_condition` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `lams_configuration` -- DROP TABLE IF EXISTS `lams_configuration`; CREATE TABLE `lams_configuration` ( `config_key` varchar(30) NOT NULL, `config_value` varchar(255) default NULL, + `description_key` varchar(255) default NULL, + `header_name` varchar(50) default NULL, + `format` varchar(30) default NULL, + `required` tinyint(4) NOT NULL default '0', PRIMARY KEY (`config_key`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_configuration` -- - -/*!40000 ALTER TABLE `lams_configuration` DISABLE KEYS */; LOCK TABLES `lams_configuration` WRITE; -INSERT INTO `lams_configuration` VALUES ('ServerURL','http://shaun.melcoe.mq.edu.au/lams/'),('ServerURLContextPath','lams/'),('Version','2.0.4'),('TempDir','/var/opt/lams/temp'),('DumpDir','/var/opt/lams/dump'),('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear'),('SMTPServer',''),('LamsSupportEmail','lams_support@melcoe.mq.edu.au'),('ContentRepositoryPath','/var/opt/lams/repository'),('UploadFileMaxSize','1048576'),('UploadLargeFileMaxSize','10485760'),('UploadFileMaxMemorySize','4096'),('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'),('UserInactiveTimeout','86400'),('UseCacheDebugListener','false'),('CleanupPreviewOlderThanDays','7'),('AuthoringActivitiesColour','true'),('AuthoringClientVersion','2.0.4.200706211047'),('MonitorClientVersion','2.0.4.200706211047'),('LearnerClientVersion','2.0.4.200706211047'),('ServerVersionNumber','2.0.4.200706211047'),('ServerLanguage','en_AU'),('ServerPageDirection','LTR'),('DictionaryDateCreated','2007-06-01'),('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'),('XmppDomain','shaun.melcoe.mq.edu.au'),('XmppConference','conference.shaun.melcoe.mq.edu.au'),('XmppAdmin','admin'),('XmppPassword','wildfire'),('DefaultFlashTheme','default'),('DefaultHTMLTheme','defaultHTML'),('AllowDirectLessonLaunch','false'),('LAMS_Community_enable','false'),('AllowLiveEdit','true'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_configuration` DISABLE KEYS */; +INSERT INTO `lams_configuration` VALUES ('AllowDirectLessonLaunch','false','config.allow.direct.lesson.launch','config.header.features','BOOLEAN',1),('AllowLiveEdit','true','config.allow.live.edit','config.header.features','BOOLEAN',1),('AuthoringActivitiesColour','true','config.authoring.activities.colour','config.header.look.feel','BOOLEAN',1),('AuthoringClientVersion','2.0.100.200803121637','config.authoring.client.version','config.header.versions','STRING',1),('CleanupPreviewOlderThanDays','7','config.cleanup.preview.older.than.days','config.header.system','LONG',1),('ContentRepositoryPath','/var/opt/lams/repository','config.content.repository.path','config.header.uploads','STRING',1),('CustomTabLink','','config.custom.tab.link','config.header.look.feel','STRING',0),('CustomTabTitle','','config.custom.tab.title','config.header.look.feel','STRING',0),('DefaultFlashTheme','default','config.default.flash.theme','config.header.look.feel','STRING',1),('DefaultHTMLTheme','defaultHTML','config.default.html.theme','config.header.look.feel','STRING',1),('DictionaryDateCreated','2008-03-12','config.dictionary.date.created','config.header.versions','STRING',1),('DumpDir','/var/opt/lams/dump','config.dump.dir','config.header.system','STRING',1),('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear','config.ear.dir','config.header.system','STRING',1),('EnableFlash','true','config.flash.enable','config.header.features','BOOLEAN',1),('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs','config.executable.extensions','config.header.uploads','STRING',1),('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/','config.help.url','config.header.system','STRING',1),('LamsSupportEmail','lams_support@melcoe.mq.edu.au','config.lams.support.email','config.header.email','STRING',0),('LAMS_Community_enable','false','config.community.enable','config.header.features','BOOLEAN',1),('LDAPAddr1Attr','postalAddress','admin.user.address_line_1','config.header.ldap.attributes','STRING',0),('LDAPAddr2Attr','','admin.user.address_line_2','config.header.ldap.attributes','STRING',0),('LDAPAddr3Attr','','admin.user.address_line_3','config.header.ldap.attributes','STRING',0),('LDAPAuthorMap','Teacher;SeniorStaff;Principal','config.ldap.author.map','config.header.ldap.attributes','STRING',0),('LDAPCityAttr','l','admin.user.city','config.header.ldap.attributes','STRING',0),('LDAPCountryAttr','','admin.user.country','config.header.ldap.attributes','STRING',0),('LDAPDayPhoneAttr','telephoneNumber','admin.user.day_phone','config.header.ldap.attributes','STRING',0),('LDAPDisabledAttr','!accountStatus','sysadmin.disabled','config.header.ldap.attributes','STRING',0),('LDAPEmailAttr','mail','admin.user.email','config.header.ldap.attributes','STRING',0),('LDAPEncryptPasswordFromBrowser','true','config.ldap.encrypt.password.from.browser','config.header.ldap','BOOLEAN',1),('LDAPEveningPhoneAttr','homePhone','admin.user.evening_phone','config.header.ldap.attributes','STRING',0),('LDAPFaxAttr','facsimileTelephoneNumber','admin.user.fax','config.header.ldap.attributes','STRING',0),('LDAPFNameAttr','givenName','admin.user.first_name','config.header.ldap.attributes','STRING',0),('LDAPGroupAdminMap','Teacher;SeniorStaff','config.ldap.group.admin.map','config.header.ldap.attributes','STRING',0),('LDAPGroupManagerMap','Principal','config.ldap.group.manager.map','config.header.ldap.attributes','STRING',0),('LDAPLearnerMap','Student;SchoolSupportStaff;Teacher;SeniorStaff;Principal','config.ldap.learner.map','config.header.ldap.attributes','STRING',0),('LDAPLNameAttr','sn','admin.user.last_name','config.header.ldap.attributes','STRING',0),('LDAPLocaleAttr','preferredLanguage','admin.organisation.locale','config.header.ldap.attributes','STRING',0),('LDAPLoginAttr','uid','admin.user.login','config.header.ldap.attributes','STRING',0),('LDAPMobileAttr','mobile','admin.user.mobile_phone','config.header.ldap.attributes','STRING',0),('LDAPMonitorMap','SchoolSupportStaff;Teacher;SeniorStaff;Principal','config.ldap.monitor.map','config.header.ldap.attributes','STRING',0),('LDAPOnlyOneOrg','true','config.ldap.only.one.org','config.header.ldap','BOOLEAN',1),('LDAPOrgAttr','schoolCode','admin.course','config.header.ldap.attributes','STRING',0),('LDAPOrgField','code','config.ldap.org.field','config.header.ldap.attributes','STRING',0),('LDAPPostcodeAttr','postalCode','admin.user.postcode','config.header.ldap.attributes','STRING',0),('LDAPPrincipalDNPrefix','cn=','config.ldap.principal.dn.prefix','config.header.ldap','STRING',0),('LDAPPrincipalDNSuffix',',ou=Users,dc=melcoe,dc=mq,dc=edu,dc=au','config.ldap.principal.dn.suffix','config.header.ldap','STRING',0),('LDAPProviderURL','ldap://192.168.111.15','config.ldap.provider.url','config.header.ldap','STRING',0),('LDAPProvisioningEnabled','false','config.ldap.provisioning.enabled','config.header.ldap','BOOLEAN',1),('LDAPRolesAttr','memberOf','admin.user.roles','config.header.ldap.attributes','STRING',0),('LDAPSearchResultsPageSize','100','config.ldap.search.results.page.size','config.header.ldap','LONG',0),('LDAPSecurityAuthentication','simple','config.ldap.security.authentication','config.header.ldap','STRING',0),('LDAPSecurityProtocol','','config.ldap.security.protocol','config.header.ldap','STRING',0),('LDAPStateAttr','st','admin.user.state','config.header.ldap.attributes','STRING',0),('LDAPTruststorePassword','','config.ldap.truststore.password','config.header.ldap','STRING',0),('LDAPTruststorePath','','config.ldap.truststore.path','config.header.ldap','STRING',0),('LDAPUpdateOnLogin','true','config.ldap.update.on.login','config.header.ldap','BOOLEAN',1),('LearnerClientVersion','2.0.100.200803121637','config.learner.client.version','config.header.versions','STRING',1),('LearnerProgressBatchSize','10','config.learner.progress.batch.size','config.header.look.feel','LONG',1),('MonitorClientVersion','2.0.100.200803121637','config.monitor.client.version','config.header.versions','STRING',1),('ServerLanguage','en_AU','config.server.language','config.header.look.feel','STRING',1),('ServerPageDirection','LTR','config.server.page.direction','config.header.look.feel','STRING',1),('ServerURL','http://localhost:8080/lams/','config.server.url','config.header.system','STRING',1),('ServerURLContextPath','lams/','config.server.url.context.path','config.header.system','STRING',1),('ServerVersionNumber','2.0.100.200803121637','config.server.version.number','config.header.versions','STRING',1),('SMTPServer','','config.smtp.server','config.header.email','STRING',0),('TempDir','/var/opt/lams/temp','config.temp.dir','config.header.system','STRING',1),('UploadFileMaxMemorySize','4096','config.upload.file.max.memory.size','config.header.uploads','LONG',1),('UploadFileMaxSize','1048576','config.upload.file.max.size','config.header.uploads','LONG',1),('UploadLargeFileMaxSize','10485760','config.upload.large.file.max.size','config.header.uploads','LONG',1),('UseCacheDebugListener','false','config.use.cache.debug.listener','config.header.system','BOOLEAN',1),('UserInactiveTimeout','86400','config.user.inactive.timeout','config.header.system','LONG',1),('Version','2.1 RC1','config.version','config.header.system','STRING',1),('XmppAdmin','admin','config.xmpp.admin','config.header.chat','STRING',0),('XmppConference','','config.xmpp.conference','config.header.chat','STRING',0),('XmppDomain','','config.xmpp.domain','config.header.chat','STRING',0),('XmppPassword','wildfire','config.xmpp.password','config.header.chat','STRING',0); /*!40000 ALTER TABLE `lams_configuration` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_copy_type` @@ -154,12 +204,11 @@ -- Dumping data for table `lams_copy_type` -- - -/*!40000 ALTER TABLE `lams_copy_type` DISABLE KEYS */; LOCK TABLES `lams_copy_type` WRITE; +/*!40000 ALTER TABLE `lams_copy_type` DISABLE KEYS */; INSERT INTO `lams_copy_type` VALUES (1,'NONE'),(2,'LESSON'),(3,'PREVIEW'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_copy_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_cr_credential` @@ -177,11 +226,10 @@ -- Dumping data for table `lams_cr_credential` -- - -/*!40000 ALTER TABLE `lams_cr_credential` DISABLE KEYS */; LOCK TABLES `lams_cr_credential` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_cr_credential` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_cr_credential` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_cr_node` @@ -205,11 +253,10 @@ -- Dumping data for table `lams_cr_node` -- - -/*!40000 ALTER TABLE `lams_cr_node` DISABLE KEYS */; LOCK TABLES `lams_cr_node` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_cr_node` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_cr_node` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_cr_node_version` @@ -231,11 +278,10 @@ -- Dumping data for table `lams_cr_node_version` -- - -/*!40000 ALTER TABLE `lams_cr_node_version` DISABLE KEYS */; LOCK TABLES `lams_cr_node_version` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_cr_node_version` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_cr_node_version` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_cr_node_version_property` @@ -257,11 +303,10 @@ -- Dumping data for table `lams_cr_node_version_property` -- - -/*!40000 ALTER TABLE `lams_cr_node_version_property` DISABLE KEYS */; LOCK TABLES `lams_cr_node_version_property` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_cr_node_version_property` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_cr_node_version_property` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_cr_workspace` @@ -278,11 +323,10 @@ -- Dumping data for table `lams_cr_workspace` -- - -/*!40000 ALTER TABLE `lams_cr_workspace` DISABLE KEYS */; LOCK TABLES `lams_cr_workspace` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_cr_workspace` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_cr_workspace` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_cr_workspace_credential` @@ -304,11 +348,10 @@ -- Dumping data for table `lams_cr_workspace_credential` -- - -/*!40000 ALTER TABLE `lams_cr_workspace_credential` DISABLE KEYS */; LOCK TABLES `lams_cr_workspace_credential` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_cr_workspace_credential` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_cr_workspace_credential` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_css_property` @@ -329,11 +372,10 @@ -- Dumping data for table `lams_css_property` -- - -/*!40000 ALTER TABLE `lams_css_property` DISABLE KEYS */; LOCK TABLES `lams_css_property` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_css_property` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_css_property` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_css_style` @@ -352,11 +394,10 @@ -- Dumping data for table `lams_css_style` -- - -/*!40000 ALTER TABLE `lams_css_style` DISABLE KEYS */; LOCK TABLES `lams_css_style` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_css_style` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_css_style` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_css_theme_ve` @@ -373,18 +414,17 @@ PRIMARY KEY (`theme_ve_id`), KEY `parent_id` (`parent_id`), CONSTRAINT `FK_lams_css_theme_ve_2` FOREIGN KEY (`parent_id`) REFERENCES `lams_css_theme_ve` (`theme_ve_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores both the Flash theme and visual element'; +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Stores both the Flash theme and visual element'; -- -- Dumping data for table `lams_css_theme_ve` -- - -/*!40000 ALTER TABLE `lams_css_theme_ve` DISABLE KEYS */; LOCK TABLES `lams_css_theme_ve` WRITE; +/*!40000 ALTER TABLE `lams_css_theme_ve` DISABLE KEYS */; INSERT INTO `lams_css_theme_ve` VALUES (1,'default','Default Flash style',NULL,1,NULL),(2,'defaultHTML','Default HTML style',NULL,1,'css'),(3,'rams','RAMS Default Flash style',NULL,1,NULL),(4,'ramsthemeHTML','RAMS Default HTML sty;e',NULL,1,'ramsthemecss'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_css_theme_ve` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_ext_course_class_map` @@ -407,11 +447,10 @@ -- Dumping data for table `lams_ext_course_class_map` -- - -/*!40000 ALTER TABLE `lams_ext_course_class_map` DISABLE KEYS */; LOCK TABLES `lams_ext_course_class_map` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_ext_course_class_map` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_ext_course_class_map` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_ext_server_org_map` @@ -428,24 +467,23 @@ `userinfo_url` text NOT NULL, `timeout_url` text NOT NULL, `disabled` bit(1) NOT NULL, - `orgid` bigint(20) NOT NULL, + `orgid` bigint(20) default NULL, PRIMARY KEY (`sid`), UNIQUE KEY `serverid` (`serverid`), UNIQUE KEY `prefix` (`prefix`), KEY `orgid` (`orgid`), CONSTRAINT `lams_ext_server_org_map_fk` FOREIGN KEY (`orgid`) REFERENCES `lams_organisation` (`organisation_id`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_ext_server_org_map` -- - -/*!40000 ALTER TABLE `lams_ext_server_org_map` DISABLE KEYS */; LOCK TABLES `lams_ext_server_org_map` WRITE; +/*!40000 ALTER TABLE `lams_ext_server_org_map` DISABLE KEYS */; INSERT INTO `lams_ext_server_org_map` VALUES (1,'moodle','moodle','moodle','moodle','mdl','http://localhost/moodle/mod/lamstwo/userinfo.php?ts=%timestamp%&un=%username%&hs=%hash%','http://dummy','\0',7); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_ext_server_org_map` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_ext_user_userid_map` @@ -468,11 +506,10 @@ -- Dumping data for table `lams_ext_user_userid_map` -- - -/*!40000 ALTER TABLE `lams_ext_user_userid_map` DISABLE KEYS */; LOCK TABLES `lams_ext_user_userid_map` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_ext_user_userid_map` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_ext_user_userid_map` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_gate_activity_level` @@ -489,12 +526,11 @@ -- Dumping data for table `lams_gate_activity_level` -- - -/*!40000 ALTER TABLE `lams_gate_activity_level` DISABLE KEYS */; LOCK TABLES `lams_gate_activity_level` WRITE; +/*!40000 ALTER TABLE `lams_gate_activity_level` DISABLE KEYS */; INSERT INTO `lams_gate_activity_level` VALUES (1,'LEARNER'),(2,'GROUP'),(3,'CLASS'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_gate_activity_level` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_group` @@ -506,6 +542,7 @@ `group_name` varchar(255) NOT NULL, `grouping_id` bigint(20) NOT NULL, `order_id` int(6) NOT NULL default '1', + `group_ui_id` int(11) default NULL, PRIMARY KEY (`group_id`), KEY `grouping_id` (`grouping_id`), CONSTRAINT `FK_lams_learning_group_1` FOREIGN KEY (`grouping_id`) REFERENCES `lams_grouping` (`grouping_id`) ON DELETE NO ACTION ON UPDATE NO ACTION @@ -515,11 +552,10 @@ -- Dumping data for table `lams_group` -- - -/*!40000 ALTER TABLE `lams_group` DISABLE KEYS */; LOCK TABLES `lams_group` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_group` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_group` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_grouping` @@ -543,11 +579,10 @@ -- Dumping data for table `lams_grouping` -- - -/*!40000 ALTER TABLE `lams_grouping` DISABLE KEYS */; LOCK TABLES `lams_grouping` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_grouping` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_grouping` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_grouping_support_type` @@ -564,12 +599,11 @@ -- Dumping data for table `lams_grouping_support_type` -- - -/*!40000 ALTER TABLE `lams_grouping_support_type` DISABLE KEYS */; LOCK TABLES `lams_grouping_support_type` WRITE; +/*!40000 ALTER TABLE `lams_grouping_support_type` DISABLE KEYS */; INSERT INTO `lams_grouping_support_type` VALUES (1,'NONE'),(2,'OPTIONAL'),(3,'REQUIRED'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_grouping_support_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_grouping_type` @@ -586,14 +620,37 @@ -- Dumping data for table `lams_grouping_type` -- - -/*!40000 ALTER TABLE `lams_grouping_type` DISABLE KEYS */; LOCK TABLES `lams_grouping_type` WRITE; +/*!40000 ALTER TABLE `lams_grouping_type` DISABLE KEYS */; INSERT INTO `lams_grouping_type` VALUES (1,'RANDOM_GROUPING'),(2,'CHOSEN_GROUPING'),(3,'CLASS_GROUPING'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_grouping_type` ENABLE KEYS */; +UNLOCK TABLES; -- +-- Table structure for table `lams_input_activity` +-- + +DROP TABLE IF EXISTS `lams_input_activity`; +CREATE TABLE `lams_input_activity` ( + `activity_id` bigint(20) NOT NULL, + `input_activity_id` bigint(20) NOT NULL, + UNIQUE KEY `UQ_lams_input_activity_1` (`activity_id`,`input_activity_id`), + KEY `activity_id` (`activity_id`), + KEY `activity_id_2` (`activity_id`), + CONSTRAINT `FK_lams_input_activity_1` FOREIGN KEY (`activity_id`) REFERENCES `lams_learning_activity` (`activity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, + CONSTRAINT `FK_lams_input_activity_2` FOREIGN KEY (`activity_id`) REFERENCES `lams_learning_activity` (`activity_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `lams_input_activity` +-- + +LOCK TABLES `lams_input_activity` WRITE; +/*!40000 ALTER TABLE `lams_input_activity` DISABLE KEYS */; +/*!40000 ALTER TABLE `lams_input_activity` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `lams_learner_progress` -- @@ -628,11 +685,10 @@ -- Dumping data for table `lams_learner_progress` -- - -/*!40000 ALTER TABLE `lams_learner_progress` DISABLE KEYS */; LOCK TABLES `lams_learner_progress` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_learner_progress` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_learner_progress` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_learning_activity` @@ -680,6 +736,12 @@ `system_tool_id` bigint(20) default NULL, `read_only` tinyint(4) default '0', `initialised` tinyint(4) default '0', + `default_activity_id` bigint(20) default NULL, + `start_xcoord` int(11) default NULL, + `start_ycoord` int(11) default NULL, + `end_xcoord` int(11) default NULL, + `end_ycoord` int(11) default NULL, + `stop_after_activity` tinyint(4) NOT NULL default '0', PRIMARY KEY (`activity_id`), KEY `learning_library_id` (`learning_library_id`), KEY `learning_design_id` (`learning_design_id`), @@ -705,18 +767,17 @@ CONSTRAINT `FK_lams_learning_activity_12` FOREIGN KEY (`activity_category_id`) REFERENCES `lams_activity_category` (`activity_category_id`), CONSTRAINT `FK_lams_learning_activity_13` FOREIGN KEY (`grouping_support_type_id`) REFERENCES `lams_grouping_support_type` (`grouping_support_type_id`), CONSTRAINT `FK_lams_learning_activity_14` FOREIGN KEY (`system_tool_id`) REFERENCES `lams_system_tool` (`system_tool_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_learning_activity` -- - -/*!40000 ALTER TABLE `lams_learning_activity` DISABLE KEYS */; LOCK TABLES `lams_learning_activity` WRITE; -INSERT INTO `lams_learning_activity` VALUES (1,NULL,'Forum/Message Board','Forum','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,1,'2007-06-04 14:44:58',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0),(2,NULL,'Displays a NoticeboardX','NoticeboardX','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,2,'2007-06-04 14:45:09',0,NULL,NULL,NULL,2,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.noticeboard.ApplicationResources',NULL,0,0),(3,NULL,'Allows creation and use of question and answer format','Question and Answer','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,3,'2007-06-04 14:45:14',0,NULL,NULL,NULL,3,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/laqa11/images/icon_questionanswer.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.qa.ApplicationResources',NULL,0,0),(4,NULL,'Uploading of files by learners, for review by teachers.','Submit File','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,4,'2007-06-04 14:45:21',0,NULL,NULL,NULL,4,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasbmt11/images/icon_reportsubmission.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.sbmt.ApplicationResources',NULL,0,0),(5,NULL,'Chat Tool','Chat Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,5,'2007-06-04 14:45:31',0,NULL,NULL,NULL,5,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lachat11/images/icon_chat.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.chat.ApplicationResources',NULL,0,0),(6,NULL,'Share Resources','Share Resources','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,6,'2007-06-04 14:45:42',0,NULL,NULL,NULL,6,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.rsrc.ApplicationResources',NULL,0,0),(7,NULL,'Allows creation and use of voting format','Voting','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,7,'2007-06-04 14:45:48',0,NULL,NULL,NULL,7,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lavote11/images/icon_ranking.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.vote.ApplicationResources',NULL,0,0),(8,NULL,'Notebook Tool','Notebook Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,8,'2007-06-04 14:45:57',0,NULL,NULL,NULL,8,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lantbk11/images/icon_notebook.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.notebook.ApplicationResources',NULL,0,0),(9,NULL,'Survey','Survey','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,9,'2007-06-04 14:46:08',0,NULL,NULL,NULL,9,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasurv11/images/icon_survey.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.survey.ApplicationResources',NULL,0,0),(10,NULL,'Scribe Tool','Scribe Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,10,'2007-06-04 14:46:19',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0),(11,NULL,'Allows creation and use of multiple choice questioning format','Multiple Choice Questions','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,11,'2007-06-04 14:46:24',0,NULL,NULL,NULL,11,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lamc11/images/icon_mcq.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.mc.ApplicationResources',NULL,0,0),(12,NULL,'Combined Share Resources and Forum','Discuss Shared Resources','Learners to discuss items they have viewed via Share Resources.',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,12,'2007-06-04 14:46:26',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_urlcontentmessageboard.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid12.ApplicationResources',NULL,0,0),(13,NULL,'Share Resources','Share Resources','Share Resources',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:26',0,NULL,NULL,NULL,6,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.rsrc.ApplicationResources',NULL,0,0),(14,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:26',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0),(15,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,13,'2007-06-04 14:46:28',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_groupreporting.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid13.ApplicationResources',NULL,0,0),(16,NULL,'Chat Tool','Chat Tool','Chat',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:28',0,NULL,NULL,NULL,5,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lachat11/images/icon_chat.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.chat.ApplicationResources',NULL,0,0),(17,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:28',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0),(18,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,14,'2007-06-04 14:46:29',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_forum_and_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid14.ApplicationResources',NULL,0,0),(19,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:29',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0),(20,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:29',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_learning_activity` DISABLE KEYS */; +INSERT INTO `lams_learning_activity` VALUES (1,NULL,'Forum/Message Board','Forum','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,1,'2008-03-12 16:37:23',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(2,NULL,'Displays a NoticeboardX','NoticeboardX','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,2,'2008-03-12 16:37:28',0,NULL,NULL,NULL,2,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.noticeboard.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(3,NULL,'Allows creation and use of question and answer format','Question and Answer','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,3,'2008-03-12 16:37:31',0,NULL,NULL,NULL,3,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/laqa11/images/icon_questionanswer.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.qa.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(4,NULL,'Uploading of files by learners, for review by teachers.','Submit File','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,4,'2008-03-12 16:37:36',0,NULL,NULL,NULL,4,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasbmt11/images/icon_reportsubmission.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.sbmt.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(5,NULL,'Chat Tool','Chat Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,5,'2008-03-12 16:37:43',0,NULL,NULL,NULL,5,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lachat11/images/icon_chat.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.chat.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(6,NULL,'Share Resources','Share Resources','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,6,'2008-03-12 16:37:52',0,NULL,NULL,NULL,6,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.rsrc.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(7,NULL,'Allows creation and use of voting format','Voting','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,7,'2008-03-12 16:37:57',0,NULL,NULL,NULL,7,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lavote11/images/icon_ranking.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.vote.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(8,NULL,'Notebook Tool','Notebook Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,8,'2008-03-12 16:38:03',0,NULL,NULL,NULL,8,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lantbk11/images/icon_notebook.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.notebook.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(9,NULL,'Survey','Survey','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,9,'2008-03-12 16:38:10',0,NULL,NULL,NULL,9,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasurv11/images/icon_survey.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.survey.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(10,NULL,'Scribe Tool','Scribe Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,10,'2008-03-12 16:38:17',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(11,NULL,'Allows creation and use of multiple choice questioning format','Multiple Choice Questions','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,11,'2008-03-12 16:38:20',0,NULL,NULL,NULL,11,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lamc11/images/icon_mcq.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.mc.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(12,NULL,'Combined Share Resources and Forum','Discuss Shared Resources','Learners to discuss items they have viewed via Share Resources.',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,12,'2008-03-12 16:38:22',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_urlcontentmessageboard.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid12.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(13,NULL,'Share Resources','Share Resources','Share Resources',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2008-03-12 16:38:22',0,NULL,NULL,NULL,6,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.rsrc.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(14,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2008-03-12 16:38:22',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(15,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,13,'2008-03-12 16:38:23',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_groupreporting.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid13.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(16,NULL,'Chat Tool','Chat Tool','Chat',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2008-03-12 16:38:23',0,NULL,NULL,NULL,5,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lachat11/images/icon_chat.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.chat.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(17,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2008-03-12 16:38:23',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(18,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,14,'2008-03-12 16:38:24',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_forum_and_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid14.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(19,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2008-03-12 16:38:24',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(20,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2008-03-12 16:38:24',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0,NULL,NULL,NULL,NULL,NULL,0); /*!40000 ALTER TABLE `lams_learning_activity` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_learning_activity_type` @@ -733,12 +794,11 @@ -- Dumping data for table `lams_learning_activity_type` -- - -/*!40000 ALTER TABLE `lams_learning_activity_type` DISABLE KEYS */; LOCK TABLES `lams_learning_activity_type` WRITE; -INSERT INTO `lams_learning_activity_type` VALUES (1,'TOOL'),(2,'GROUPING'),(3,'GATE_SYNCH'),(4,'GATE_SCHEDULE'),(5,'GATE_PERMISSION'),(6,'PARALLEL'),(7,'OPTIONS'),(8,'SEQUENCE'),(9,'GATE_SYSTEM'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_learning_activity_type` DISABLE KEYS */; +INSERT INTO `lams_learning_activity_type` VALUES (1,'TOOL'),(2,'GROUPING'),(3,'GATE_SYNCH'),(4,'GATE_SCHEDULE'),(5,'GATE_PERMISSION'),(6,'PARALLEL'),(7,'OPTIONS'),(8,'SEQUENCE'),(9,'GATE_SYSTEM'),(10,'BRANCHING_CHOSEN'),(11,'BRANCHING_GROUP'),(12,'BRANCHING_TOOL'),(13,'OPTIONS_WITH_SEQUENCES'); /*!40000 ALTER TABLE `lams_learning_activity_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_learning_design` @@ -791,11 +851,10 @@ -- Dumping data for table `lams_learning_design` -- - -/*!40000 ALTER TABLE `lams_learning_design` DISABLE KEYS */; LOCK TABLES `lams_learning_design` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_learning_design` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_learning_design` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_learning_library` @@ -809,18 +868,17 @@ `valid_flag` tinyint(1) NOT NULL default '1', `create_date_time` datetime NOT NULL, PRIMARY KEY (`learning_library_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_learning_library` -- - -/*!40000 ALTER TABLE `lams_learning_library` DISABLE KEYS */; LOCK TABLES `lams_learning_library` WRITE; -INSERT INTO `lams_learning_library` VALUES (1,'Forum, also known Message Board','Forum',1,'2007-06-04 14:44:58'),(2,'Displays a Noticeboard','Noticeboard',1,'2007-06-04 14:45:09'),(3,'Question and Answer Learning Library Description','Question and Answer',1,'2007-06-04 14:45:14'),(4,'Uploading of files by learners, for review by teachers.','Submit file',1,'2007-06-04 14:45:21'),(5,'Chat Tool','Chat',1,'2007-06-04 14:45:31'),(6,'Share resources','Share resources',1,'2007-06-04 14:45:42'),(7,'Voting Learning Library Description','Voting',1,'2007-06-04 14:45:48'),(8,'Notebook Tool','Notebook',1,'2007-06-04 14:45:57'),(9,'Survey','Survey',1,'2007-06-04 14:46:08'),(10,'Scribe Tool','Scribe',0,'2007-06-04 14:46:19'),(11,'MCQ Learning Library Description','MCQ',1,'2007-06-04 14:46:24'),(12,'Shared Resources and Forum','Resources and Forum',1,'2007-06-04 14:46:26'),(13,'Chat and Scribe','Chat and Scribe',1,'2007-06-04 14:46:28'),(14,'Forum and Scribe','Forum and Scribe',1,'2007-06-04 14:46:29'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_learning_library` DISABLE KEYS */; +INSERT INTO `lams_learning_library` VALUES (1,'Forum, also known Message Board','Forum',1,'2008-03-12 16:37:23'),(2,'Displays a Noticeboard','Noticeboard',1,'2008-03-12 16:37:28'),(3,'Question and Answer Learning Library Description','Question and Answer',1,'2008-03-12 16:37:31'),(4,'Uploading of files by learners, for review by teachers.','Submit file',1,'2008-03-12 16:37:36'),(5,'Chat Tool','Chat',1,'2008-03-12 16:37:43'),(6,'Share resources','Share resources',1,'2008-03-12 16:37:52'),(7,'Voting Learning Library Description','Voting',1,'2008-03-12 16:37:57'),(8,'Notebook Tool','Notebook',1,'2008-03-12 16:38:03'),(9,'Survey','Survey',1,'2008-03-12 16:38:10'),(10,'Scribe Tool','Scribe',0,'2008-03-12 16:38:17'),(11,'MCQ Learning Library Description','MCQ',1,'2008-03-12 16:38:20'),(12,'Shared Resources and Forum','Resources and Forum',1,'2008-03-12 16:38:22'),(13,'Chat and Scribe','Chat and Scribe',1,'2008-03-12 16:38:23'),(14,'Forum and Scribe','Forum and Scribe',1,'2008-03-12 16:38:24'); /*!40000 ALTER TABLE `lams_learning_library` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_learning_transition` @@ -852,11 +910,10 @@ -- Dumping data for table `lams_learning_transition` -- - -/*!40000 ALTER TABLE `lams_learning_transition` DISABLE KEYS */; LOCK TABLES `lams_learning_transition` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_learning_transition` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_learning_transition` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_lesson` @@ -898,11 +955,10 @@ -- Dumping data for table `lams_lesson` -- - -/*!40000 ALTER TABLE `lams_lesson` DISABLE KEYS */; LOCK TABLES `lams_lesson` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_lesson` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_lesson` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_lesson_learner` @@ -922,11 +978,10 @@ -- Dumping data for table `lams_lesson_learner` -- - -/*!40000 ALTER TABLE `lams_lesson_learner` DISABLE KEYS */; LOCK TABLES `lams_lesson_learner` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_lesson_learner` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_lesson_learner` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_lesson_state` @@ -943,12 +998,11 @@ -- Dumping data for table `lams_lesson_state` -- - -/*!40000 ALTER TABLE `lams_lesson_state` DISABLE KEYS */; LOCK TABLES `lams_lesson_state` WRITE; +/*!40000 ALTER TABLE `lams_lesson_state` DISABLE KEYS */; INSERT INTO `lams_lesson_state` VALUES (1,'CREATED'),(2,'NOT_STARTED'),(3,'STARTED'),(4,'SUSPENDED'),(5,'FINISHED'),(6,'ARCHIVED'),(7,'REMOVED'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_lesson_state` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_license` @@ -969,12 +1023,11 @@ -- Dumping data for table `lams_license` -- - -/*!40000 ALTER TABLE `lams_license` DISABLE KEYS */; LOCK TABLES `lams_license` WRITE; +/*!40000 ALTER TABLE `lams_license` DISABLE KEYS */; INSERT INTO `lams_license` VALUES (1,'LAMS Recommended: CC Attribution-Noncommercial-ShareAlike 2.5','by-nc-sa','http://creativecommons.org/licenses/by-nc-sa/2.5/',1,'/images/license/byncsa.jpg'),(2,'CC Attribution-No Derivatives 2.5','by-nd','http://creativecommons.org/licenses/by-nd/2.5/',0,'/images/license/bynd.jpg'),(3,'CC Attribution-Noncommercial-No Derivatives 2.5','by-nc-nd','http://creativecommons.org/licenses/by-nc-nd/2.5/',0,'/images/license/byncnd.jpg'),(4,'CC Attribution-Noncommercial 2.5','by-nc','http://creativecommons.org/licenses/by-nc/2.5/',0,'/images/license/bync.jpg'),(5,'CC Attribution-ShareAlike 2.5','by-sa','http://creativecommons.org/licenses/by-sa/2.5/',0,'/images/license/byncsa.jpg'),(6,'Other Licensing Agreement','other','',0,''); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_license` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_log_event` @@ -997,11 +1050,10 @@ -- Dumping data for table `lams_log_event` -- - -/*!40000 ALTER TABLE `lams_log_event` DISABLE KEYS */; LOCK TABLES `lams_log_event` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_log_event` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_log_event` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_log_event_type` @@ -1018,12 +1070,11 @@ -- Dumping data for table `lams_log_event_type` -- - -/*!40000 ALTER TABLE `lams_log_event_type` DISABLE KEYS */; LOCK TABLES `lams_log_event_type` WRITE; +/*!40000 ALTER TABLE `lams_log_event_type` DISABLE KEYS */; INSERT INTO `lams_log_event_type` VALUES (1,'LEARNER_LESSON_START'),(2,'LEARNER_LESSON_FINISH'),(3,'LEARNER_LESSON_EXIT'),(4,'LEARNER_LESSON_RESUME'),(5,'LEARNER_ACTIVITY_START'),(6,'LEARNER_ACTIVITY_FINISH'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_log_event_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_notebook_entry` @@ -1041,17 +1092,16 @@ `create_date` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_notebook_entry` -- - -/*!40000 ALTER TABLE `lams_notebook_entry` DISABLE KEYS */; LOCK TABLES `lams_notebook_entry` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_notebook_entry` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_notebook_entry` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_organisation` @@ -1075,27 +1125,29 @@ `admin_create_guest` tinyint(1) NOT NULL default '0', `locale_id` int(11) default NULL, `archived_date` datetime default NULL, + `ordered_lesson_ids` text, PRIMARY KEY (`organisation_id`), KEY `organisation_type_id` (`organisation_type_id`), KEY `workspace_id` (`workspace_id`), KEY `parent_organisation_id` (`parent_organisation_id`), KEY `organisation_state_id` (`organisation_state_id`), + KEY `locale_id` (`locale_id`), CONSTRAINT `FK_lams_organisation_1` FOREIGN KEY (`organisation_type_id`) REFERENCES `lams_organisation_type` (`organisation_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_organisation_2` FOREIGN KEY (`workspace_id`) REFERENCES `lams_workspace` (`workspace_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_organisation_3` FOREIGN KEY (`parent_organisation_id`) REFERENCES `lams_organisation` (`organisation_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, - CONSTRAINT `FK_lams_organisation_4` FOREIGN KEY (`organisation_state_id`) REFERENCES `lams_organisation_state` (`organisation_state_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + CONSTRAINT `FK_lams_organisation_4` FOREIGN KEY (`organisation_state_id`) REFERENCES `lams_organisation_state` (`organisation_state_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, + CONSTRAINT `FK_lams_organisation_5` FOREIGN KEY (`locale_id`) REFERENCES `lams_supported_locale` (`locale_id`) +) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_organisation` -- - -/*!40000 ALTER TABLE `lams_organisation` DISABLE KEYS */; LOCK TABLES `lams_organisation` WRITE; -INSERT INTO `lams_organisation` VALUES (1,'Root',NULL,'Root Organisation',NULL,1,'2007-06-04 14:44:48',1,1,1,0,0,0,0,1,NULL),(2,'Playpen','PP101','Developers Playpen',1,2,'2007-06-04 14:44:48',1,2,1,0,0,0,0,1,NULL),(3,'Everybody',NULL,'All People In Course',2,3,'2007-06-04 14:44:48',1,NULL,1,0,0,0,0,1,NULL),(4,'Mathematics 1','MATH111','Mathematics 1',1,2,'2007-06-04 14:44:48',1,3,1,0,0,0,0,2,NULL),(5,'Tutorial Group A','TUTA','Tutorial Group A',4,3,'2007-06-04 14:44:48',1,NULL,1,0,0,0,0,2,NULL),(6,'Tutorial Group B','TUTB','Tutorial Group B',4,3,'2007-06-04 14:44:48',1,NULL,1,0,0,0,0,2,NULL),(7,'Moodle','Moodle','Moodle Test',1,2,'2007-06-04 14:44:48',1,50,2,0,0,0,0,1,NULL); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_organisation` DISABLE KEYS */; +INSERT INTO `lams_organisation` VALUES (1,'Root',NULL,'Root Organisation',NULL,1,'2008-03-12 16:37:15',1,1,1,0,0,0,0,1,NULL,NULL),(2,'Playpen','PP101','Developers Playpen',1,2,'2008-03-12 16:37:15',1,2,1,0,0,0,0,1,NULL,NULL),(3,'Everybody',NULL,'All People In Course',2,3,'2008-03-12 16:37:15',1,NULL,1,0,0,0,0,1,NULL,NULL),(4,'Mathematics 1','MATH111','Mathematics 1',1,2,'2008-03-12 16:37:15',1,3,1,0,0,0,0,2,NULL,NULL),(5,'Tutorial Group A','TUTA','Tutorial Group A',4,3,'2008-03-12 16:37:15',1,NULL,1,0,0,0,0,2,NULL,NULL),(6,'Tutorial Group B','TUTB','Tutorial Group B',4,3,'2008-03-12 16:37:15',1,NULL,1,0,0,0,0,2,NULL,NULL),(7,'Moodle','Moodle','Moodle Test',1,2,'2008-03-12 16:37:15',1,50,2,0,0,0,0,1,NULL,NULL); /*!40000 ALTER TABLE `lams_organisation` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_organisation_state` @@ -1112,12 +1164,11 @@ -- Dumping data for table `lams_organisation_state` -- - -/*!40000 ALTER TABLE `lams_organisation_state` DISABLE KEYS */; LOCK TABLES `lams_organisation_state` WRITE; +/*!40000 ALTER TABLE `lams_organisation_state` DISABLE KEYS */; INSERT INTO `lams_organisation_state` VALUES (1,'ACTIVE'),(2,'HIDDEN'),(3,'ARCHIVED'),(4,'REMOVED'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_organisation_state` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_organisation_type` @@ -1136,14 +1187,36 @@ -- Dumping data for table `lams_organisation_type` -- - -/*!40000 ALTER TABLE `lams_organisation_type` DISABLE KEYS */; LOCK TABLES `lams_organisation_type` WRITE; +/*!40000 ALTER TABLE `lams_organisation_type` DISABLE KEYS */; INSERT INTO `lams_organisation_type` VALUES (1,'ROOT ORGANISATION','root all other organisations: controlled by Sysadmin'),(2,'COURSE ORGANISATION','main organisation level - equivalent to an entire course.'),(3,'CLASS','runtime organisation level - lessons are run for classes.'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_organisation_type` ENABLE KEYS */; +UNLOCK TABLES; -- +-- Table structure for table `lams_password_request` +-- + +DROP TABLE IF EXISTS `lams_password_request`; +CREATE TABLE `lams_password_request` ( + `request_id` bigint(20) NOT NULL auto_increment, + `user_id` bigint(20) NOT NULL, + `request_key` varchar(32) NOT NULL, + `request_date` datetime NOT NULL, + PRIMARY KEY (`request_id`), + UNIQUE KEY `IX_lams_psswd_rqst_key` (`request_key`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `lams_password_request` +-- + +LOCK TABLES `lams_password_request` WRITE; +/*!40000 ALTER TABLE `lams_password_request` DISABLE KEYS */; +/*!40000 ALTER TABLE `lams_password_request` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `lams_privilege` -- @@ -1154,18 +1227,17 @@ `description` varchar(255) default NULL, PRIMARY KEY (`privilege_id`), UNIQUE KEY `IX_lams_privilege_code` (`code`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_privilege` -- - -/*!40000 ALTER TABLE `lams_privilege` DISABLE KEYS */; LOCK TABLES `lams_privilege` WRITE; +/*!40000 ALTER TABLE `lams_privilege` DISABLE KEYS */; INSERT INTO `lams_privilege` VALUES (1,'Z','do anything'),(2,'A','add/remove/modify classes within the course'),(3,'B','create running instances of sequences and assign those to a class'),(4,'C','stop/start running sequences'),(5,'D','monitor the progress of learners'),(6,'E','participates in sequences'),(7,'F','export their progress on each running sequence'),(8,'G','write/create/delete permissions in course content folder'),(9,'H','read course content folder'),(10,'I','create new users'),(11,'J','create guest users'),(12,'K','change status of course'),(13,'L','browse all users in the system'),(14,'M','write/create/delete permissions in all course content folders'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_privilege` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_progress_attempted` @@ -1186,11 +1258,10 @@ -- Dumping data for table `lams_progress_attempted` -- - -/*!40000 ALTER TABLE `lams_progress_attempted` DISABLE KEYS */; LOCK TABLES `lams_progress_attempted` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_progress_attempted` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_progress_attempted` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_progress_completed` @@ -1211,11 +1282,10 @@ -- Dumping data for table `lams_progress_completed` -- - -/*!40000 ALTER TABLE `lams_progress_completed` DISABLE KEYS */; LOCK TABLES `lams_progress_completed` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_progress_completed` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_progress_completed` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_BLOB_TRIGGERS` @@ -1226,18 +1296,18 @@ `TRIGGER_NAME` varchar(80) NOT NULL, `TRIGGER_GROUP` varchar(80) NOT NULL, `BLOB_DATA` blob, - PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `lams_qtz_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_BLOB_TRIGGERS` -- - -/*!40000 ALTER TABLE `lams_qtz_BLOB_TRIGGERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_BLOB_TRIGGERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_BLOB_TRIGGERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_BLOB_TRIGGERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_CALENDARS` @@ -1248,17 +1318,16 @@ `CALENDAR_NAME` varchar(80) NOT NULL, `CALENDAR` blob NOT NULL, PRIMARY KEY (`CALENDAR_NAME`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_CALENDARS` -- - -/*!40000 ALTER TABLE `lams_qtz_CALENDARS` DISABLE KEYS */; LOCK TABLES `lams_qtz_CALENDARS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_CALENDARS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_CALENDARS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_CRON_TRIGGERS` @@ -1270,18 +1339,18 @@ `TRIGGER_GROUP` varchar(80) NOT NULL, `CRON_EXPRESSION` varchar(80) NOT NULL, `TIME_ZONE_ID` varchar(80) default NULL, - PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `lams_qtz_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_CRON_TRIGGERS` -- - -/*!40000 ALTER TABLE `lams_qtz_CRON_TRIGGERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_CRON_TRIGGERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_CRON_TRIGGERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_CRON_TRIGGERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_FIRED_TRIGGERS` @@ -1301,17 +1370,16 @@ `IS_STATEFUL` varchar(1) default NULL, `REQUESTS_RECOVERY` varchar(1) default NULL, PRIMARY KEY (`ENTRY_ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_FIRED_TRIGGERS` -- - -/*!40000 ALTER TABLE `lams_qtz_FIRED_TRIGGERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_FIRED_TRIGGERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_FIRED_TRIGGERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_FIRED_TRIGGERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_JOB_DETAILS` @@ -1329,17 +1397,16 @@ `REQUESTS_RECOVERY` varchar(1) NOT NULL, `JOB_DATA` blob, PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_JOB_DETAILS` -- - -/*!40000 ALTER TABLE `lams_qtz_JOB_DETAILS` DISABLE KEYS */; LOCK TABLES `lams_qtz_JOB_DETAILS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_JOB_DETAILS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_JOB_DETAILS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_JOB_LISTENERS` @@ -1350,18 +1417,18 @@ `JOB_NAME` varchar(80) NOT NULL, `JOB_GROUP` varchar(80) NOT NULL, `JOB_LISTENER` varchar(80) NOT NULL, - PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`,`JOB_LISTENER`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`,`JOB_LISTENER`), + CONSTRAINT `lams_qtz_JOB_LISTENERS_ibfk_1` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `lams_qtz_JOB_DETAILS` (`JOB_NAME`, `JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_JOB_LISTENERS` -- - -/*!40000 ALTER TABLE `lams_qtz_JOB_LISTENERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_JOB_LISTENERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_JOB_LISTENERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_JOB_LISTENERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_LOCKS` @@ -1371,18 +1438,17 @@ CREATE TABLE `lams_qtz_LOCKS` ( `LOCK_NAME` varchar(40) NOT NULL, PRIMARY KEY (`LOCK_NAME`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_LOCKS` -- - -/*!40000 ALTER TABLE `lams_qtz_LOCKS` DISABLE KEYS */; LOCK TABLES `lams_qtz_LOCKS` WRITE; +/*!40000 ALTER TABLE `lams_qtz_LOCKS` DISABLE KEYS */; INSERT INTO `lams_qtz_LOCKS` VALUES ('CALENDAR_ACCESS'),('JOB_ACCESS'),('MISFIRE_ACCESS'),('STATE_ACCESS'),('TRIGGER_ACCESS'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_qtz_LOCKS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_PAUSED_TRIGGER_GRPS` @@ -1392,17 +1458,16 @@ CREATE TABLE `lams_qtz_PAUSED_TRIGGER_GRPS` ( `TRIGGER_GROUP` varchar(80) NOT NULL, PRIMARY KEY (`TRIGGER_GROUP`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_PAUSED_TRIGGER_GRPS` -- - -/*!40000 ALTER TABLE `lams_qtz_PAUSED_TRIGGER_GRPS` DISABLE KEYS */; LOCK TABLES `lams_qtz_PAUSED_TRIGGER_GRPS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_PAUSED_TRIGGER_GRPS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_PAUSED_TRIGGER_GRPS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_SCHEDULER_STATE` @@ -1415,17 +1480,16 @@ `CHECKIN_INTERVAL` bigint(13) NOT NULL, `RECOVERER` varchar(80) default NULL, PRIMARY KEY (`INSTANCE_NAME`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_SCHEDULER_STATE` -- - -/*!40000 ALTER TABLE `lams_qtz_SCHEDULER_STATE` DISABLE KEYS */; LOCK TABLES `lams_qtz_SCHEDULER_STATE` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_SCHEDULER_STATE` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_SCHEDULER_STATE` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_SIMPLE_TRIGGERS` @@ -1438,18 +1502,18 @@ `REPEAT_COUNT` bigint(7) NOT NULL, `REPEAT_INTERVAL` bigint(12) NOT NULL, `TIMES_TRIGGERED` bigint(7) NOT NULL, - PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `lams_qtz_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_SIMPLE_TRIGGERS` -- - -/*!40000 ALTER TABLE `lams_qtz_SIMPLE_TRIGGERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_SIMPLE_TRIGGERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_SIMPLE_TRIGGERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_SIMPLE_TRIGGERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_TRIGGERS` @@ -1473,18 +1537,18 @@ `MISFIRE_INSTR` smallint(2) default NULL, `JOB_DATA` blob, PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`), - KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `JOB_NAME` (`JOB_NAME`,`JOB_GROUP`), + CONSTRAINT `lams_qtz_TRIGGERS_ibfk_1` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `lams_qtz_JOB_DETAILS` (`JOB_NAME`, `JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_TRIGGERS` -- - -/*!40000 ALTER TABLE `lams_qtz_TRIGGERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_TRIGGERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_TRIGGERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_TRIGGERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_qtz_TRIGGER_LISTENERS` @@ -1495,18 +1559,18 @@ `TRIGGER_NAME` varchar(80) NOT NULL, `TRIGGER_GROUP` varchar(80) NOT NULL, `TRIGGER_LISTENER` varchar(80) NOT NULL, - PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_LISTENER`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_LISTENER`), + CONSTRAINT `lams_qtz_TRIGGER_LISTENERS_ibfk_1` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `lams_qtz_TRIGGERS` (`TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_qtz_TRIGGER_LISTENERS` -- - -/*!40000 ALTER TABLE `lams_qtz_TRIGGER_LISTENERS` DISABLE KEYS */; LOCK TABLES `lams_qtz_TRIGGER_LISTENERS` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_qtz_TRIGGER_LISTENERS` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_qtz_TRIGGER_LISTENERS` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_role` @@ -1526,12 +1590,11 @@ -- Dumping data for table `lams_role` -- - -/*!40000 ALTER TABLE `lams_role` DISABLE KEYS */; LOCK TABLES `lams_role` WRITE; -INSERT INTO `lams_role` VALUES (1,'SYSADMIN','LAMS System Adminstrator','2007-06-04 14:44:48'),(2,'GROUP MANAGER','Group Manager','2007-06-04 14:44:48'),(3,'AUTHOR','Authors Learning Designs','2007-06-04 14:44:48'),(4,'MONITOR','Member of Staff','2007-06-04 14:44:48'),(5,'LEARNER','Student','2007-06-04 14:44:48'),(6,'GROUP ADMIN','Group Administrator','2007-06-04 14:44:48'),(7,'AUTHOR ADMIN','Author Administrator','2007-06-04 14:44:48'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_role` DISABLE KEYS */; +INSERT INTO `lams_role` VALUES (1,'SYSADMIN','LAMS System Adminstrator','2008-03-12 16:37:15'),(2,'GROUP MANAGER','Group Manager','2008-03-12 16:37:15'),(3,'AUTHOR','Authors Learning Designs','2008-03-12 16:37:15'),(4,'MONITOR','Member of Staff','2008-03-12 16:37:15'),(5,'LEARNER','Student','2008-03-12 16:37:15'),(6,'GROUP ADMIN','Group Administrator','2008-03-12 16:37:15'),(7,'AUTHOR ADMIN','Author Administrator','2008-03-12 16:37:15'); /*!40000 ALTER TABLE `lams_role` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_role_privilege` @@ -1547,18 +1610,17 @@ KEY `role_id` (`role_id`), CONSTRAINT `FK_lams_role_privilege_1` FOREIGN KEY (`privilege_id`) REFERENCES `lams_privilege` (`privilege_id`), CONSTRAINT `FK_lams_role_privilege_2` FOREIGN KEY (`role_id`) REFERENCES `lams_role` (`role_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_role_privilege` -- - -/*!40000 ALTER TABLE `lams_role_privilege` DISABLE KEYS */; LOCK TABLES `lams_role_privilege` WRITE; +/*!40000 ALTER TABLE `lams_role_privilege` DISABLE KEYS */; INSERT INTO `lams_role_privilege` VALUES (1,1,1),(2,2,2),(3,2,3),(4,2,4),(5,2,5),(6,2,8),(7,2,9),(8,2,10),(9,2,12),(10,2,13),(11,3,8),(12,3,9),(13,4,3),(14,4,4),(15,4,5),(16,5,6),(17,5,7),(18,6,2),(19,6,10),(20,6,12),(21,6,13),(22,7,14); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_role_privilege` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_supported_locale` @@ -1571,19 +1633,19 @@ `country_iso_code` varchar(2) default NULL COMMENT 'ISO 3166 Country Code. Cannot use in unique key as allows null.', `description` varchar(255) NOT NULL, `direction` varchar(3) NOT NULL, + `fckeditor_code` varchar(10) default NULL, PRIMARY KEY (`locale_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Describes the valid language/country combinations.'; +) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='Describes the valid language/country combinations.'; -- -- Dumping data for table `lams_supported_locale` -- - -/*!40000 ALTER TABLE `lams_supported_locale` DISABLE KEYS */; LOCK TABLES `lams_supported_locale` WRITE; -INSERT INTO `lams_supported_locale` VALUES (1,'en','AU','English (Australia)','LTR'),(2,'es','ES','Español','LTR'),(3,'mi','NZ','Māori','LTR'),(4,'de','DE','Deutsch','LTR'),(5,'zh','CN','简体中文','LTR'),(6,'fr','FR','Français','LTR'),(7,'it','IT','Italiano','LTR'),(8,'no','NO','Norsk','LTR'),(9,'sv','SE','Svenska','LTR'),(10,'ko','KR','한국어','LTR'),(11,'pl','PL','Polski','LTR'),(12,'pt','BR','Português (Brasil)','LTR'),(13,'hu','HU','Magyar','LTR'),(14,'bg','BG','Български','LTR'),(15,'cy','GB','Cymraeg (Cymru)','LTR'),(16,'th','TH','Thai','LTR'),(17,'el','GR','Ελληνικά','LTR'),(18,'nl','BE','Nederlands (België)','LTR'),(19,'ar','JO','عربي','RTL'),(20,'da','DK','Dansk','LTR'),(21,'ru','RU','Русский','LTR'),(22,'vi','VN','Tiếng Việt','LTR'),(23,'zh','TW','Chinese (Taiwan)','LTR'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_supported_locale` DISABLE KEYS */; +INSERT INTO `lams_supported_locale` VALUES (1,'en','AU','English (Australia)','LTR','en-au'),(2,'es','ES','Español','LTR','es'),(3,'mi','NZ','Māori','LTR','en-au'),(4,'de','DE','Deutsch','LTR','de'),(5,'zh','CN','简体中文','LTR','zh-cn'),(6,'fr','FR','Français','LTR','fr'),(7,'it','IT','Italiano','LTR','it'),(8,'no','NO','Norsk','LTR','no'),(9,'sv','SE','Svenska','LTR','sv'),(10,'ko','KR','한국어','LTR','ko'),(11,'pl','PL','Polski','LTR','pl'),(12,'pt','BR','Português (Brasil)','LTR','pt-br'),(13,'hu','HU','Magyar','LTR','hu'),(14,'bg','BG','Български','LTR','bg'),(15,'cy','GB','Cymraeg (Cymru)','LTR','en-au'),(16,'th','TH','Thai','LTR','th'),(17,'el','GR','Ελληνικά','LTR','el'),(18,'nl','BE','Nederlands (België)','LTR','nl'),(19,'ar','JO','عربي','RTL','ar'),(20,'da','DK','Dansk','LTR','da'),(21,'ru','RU','Русский','LTR','ru'),(22,'vi','VN','Tiếng Việt','LTR','vi'),(23,'zh','TW','Chinese (Taiwan)','LTR','zh'),(24,'ja','JP','Japanese (Japan)','LTR','ja'),(25,'ms','MY','Malay (Malaysia)','LTR','ms'); /*!40000 ALTER TABLE `lams_supported_locale` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_system_tool` @@ -1604,22 +1666,22 @@ `contribute_url` text, `help_url` text, `create_date_time` datetime NOT NULL, + `admin_url` text, PRIMARY KEY (`system_tool_id`), UNIQUE KEY `UQ_systool_activity_type` (`learning_activity_type_id`), KEY `learning_activity_type_id` (`learning_activity_type_id`), CONSTRAINT `FK_lams_system_tool` FOREIGN KEY (`learning_activity_type_id`) REFERENCES `lams_learning_activity_type` (`learning_activity_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_system_tool` -- - -/*!40000 ALTER TABLE `lams_system_tool` DISABLE KEYS */; LOCK TABLES `lams_system_tool` WRITE; -INSERT INTO `lams_system_tool` VALUES (1,2,'Grouping','All types of grouping including random and chosen.','learning/grouping.do?method=performGrouping','learning/grouping.do?method=performGrouping','learning/grouping.do?method=viewGrouping&mode=teacher','learning/groupingExportPortfolio?mode=learner','learning/groupingExportPortfolio?mode=teacher','monitoring/grouping.do?method=startGrouping','monitoring/grouping.do?method=startGrouping',NULL,'2007-06-04 14:44:48'),(2,3,'Sync Gate','Gate: Synchronise Learners.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'),(3,4,'Schedule Gate','Gate: Opens/shuts at particular times.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'),(4,5,'Permission Gate','Gate: Opens under teacher or staff control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'),(5,9,'System Gate','Gate: Opens under system control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_system_tool` DISABLE KEYS */; +INSERT INTO `lams_system_tool` VALUES (1,2,'Grouping','All types of grouping including random and chosen.','learning/grouping.do?method=performGrouping','learning/grouping.do?method=performGrouping','learning/grouping.do?method=viewGrouping&mode=teacher','learning/groupingExportPortfolio?mode=learner','learning/groupingExportPortfolio?mode=teacher','monitoring/grouping.do?method=startGrouping','monitoring/grouping.do?method=startGrouping',NULL,'2008-03-12 16:37:15',NULL),(2,3,'Sync Gate','Gate: Synchronise Learners.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2008-03-12 16:37:15',NULL),(3,4,'Schedule Gate','Gate: Opens/shuts at particular times.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2008-03-12 16:37:15',NULL),(4,5,'Permission Gate','Gate: Opens under teacher or staff control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2008-03-12 16:37:15',NULL),(5,9,'System Gate','Gate: Opens under system control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2008-03-12 16:37:15',NULL),(6,10,'Monitor Chosen Branching','Select between multiple sequence activities, with the branch chosen in monitoring.','learning/branching.do?method=performBranching','learning/branching.do?method=performBranching','monitoring/complexProgress.do',NULL,'monitoring/branchingExportPortfolio?mode=teacher','monitoring/chosenBranching.do?method=assignBranch','monitoring/chosenBranching.do?method=assignBranch',NULL,'2008-03-12 16:37:15',NULL),(7,11,'Group Based Branching','Select between multiple sequence activities, with the branch chosen by an existing group.','learning/branching.do?method=performBranching','learning/branching.do?method=performBranching','monitoring/complexProgress.do',NULL,'monitoring/branchingExportPortfolio?mode=teacher','monitoring/groupedBranching.do?method=viewBranching','monitoring/groupedBranching.do?method=assignBranch',NULL,'2008-03-12 16:37:15',NULL),(8,12,'Tool Output Based Branching','Select between multiple sequence activities, with the branch chosen on results of another activity.','learning/branching.do?method=performBranching','learning/branching.do?method=performBranching','monitoring/complexProgress.do',NULL,'monitoring/branchingExportPortfolio?mode=teacher','monitoring/toolBranching.do?method=viewBranching','monitoring/toolBranching.do?method=viewBranching',NULL,'2008-03-12 16:37:15',NULL),(9,8,'Sequence','A sequence of activities','learning/SequenceActivity.do','learning/SequenceActivity.do','monitoring/complexProgress.do',NULL,'monitoring/sequenceExportPortfolio?mode=teacher','monitoring/sequence.do?method=viewSequence','monitoring/sequence.do?method=viewSequence',NULL,'2008-03-12 16:37:15',NULL); /*!40000 ALTER TABLE `lams_system_tool` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_tool` @@ -1655,25 +1717,25 @@ `modified_date_time` datetime default NULL, `classpath_addition` varchar(255) default NULL, `context_file` varchar(255) default NULL, + `admin_url` text, PRIMARY KEY (`tool_id`), UNIQUE KEY `UQ_lams_tool_sig` (`tool_signature`), UNIQUE KEY `UQ_lams_tool_class_name` (`service_name`), KEY `learning_library_id` (`learning_library_id`), KEY `grouping_support_type_id` (`grouping_support_type_id`), CONSTRAINT `FK_lams_tool_1` FOREIGN KEY (`learning_library_id`) REFERENCES `lams_learning_library` (`learning_library_id`), CONSTRAINT `FK_lams_tool_2` FOREIGN KEY (`grouping_support_type_id`) REFERENCES `lams_grouping_support_type` (`grouping_support_type_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_tool` -- - -/*!40000 ALTER TABLE `lams_tool` DISABLE KEYS */; LOCK TABLES `lams_tool` WRITE; -INSERT INTO `lams_tool` VALUES (1,'lafrum11','forumService','Forum','Forum / Message Boards','forum','20070524',1,1,1,2,1,'tool/lafrum11/learning/viewForum.do?mode=learner','tool/lafrum11/learning/viewForum.do?mode=author','tool/lafrum11/learning/viewForum.do?mode=teacher','tool/lafrum11/authoring.do','tool/lafrum11/defineLater.do','tool/lafrum11/exportPortfolio?mode=learner','tool/lafrum11/exportPortfolio?mode=teacher','tool/lafrum11/monitoring.do','tool/lafrum11/contribute.do','tool/lafrum11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lafrum11','2007-06-04 14:44:58','org.lamsfoundation.lams.tool.forum.ApplicationResources','2007-06-04 14:44:58','lams-tool-lafrum11.jar','/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml'),(2,'lanb11','nbService','NoticeboardX','Displays a NoticeboardX','nb','20070524',2,2,1,2,1,'tool/lanb11/starter/learner.do?mode=learner','tool/lanb11/starter/learner.do?mode=author','tool/lanb11/starter/learner.do?mode=teacher','tool/lanb11/authoring.do','tool/lanb11/authoring.do?defineLater=true','tool/lanb11/portfolioExport?mode=learner','tool/lanb11/portfolioExport?mode=teacher','tool/lanb11/monitoring.do',NULL,NULL,'http://wiki.lamsfoundation.org/display/lamsdocs/lanb11','2007-06-04 14:45:09','org.lamsfoundation.lams.tool.noticeboard.ApplicationResources','2007-06-04 14:45:09','lams-tool-lanb11.jar','/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml'),(3,'laqa11','qaService','Question and Answer','Q/A Tool','qa','20070524',3,3,1,2,1,'tool/laqa11/learningStarter.do?mode=learner','tool/laqa11/learningStarter.do?mode=author','tool/laqa11/learningStarter.do?mode=teacher','tool/laqa11/authoringStarter.do','tool/laqa11/defineLaterStarter.do','tool/laqa11/exportPortfolio?mode=learner','tool/laqa11/exportPortfolio?mode=teacher','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/laqa11','2007-06-04 14:45:14','org.lamsfoundation.lams.tool.qa.ApplicationResources','2007-06-04 14:45:14','lams-tool-laqa11.jar','/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml'),(4,'lasbmt11','submitFilesService','Submit File','Submit File Tool Description','submitfile','20070524',4,4,1,2,1,'tool/lasbmt11/learner.do?mode=learner','tool/lasbmt11/learner.do?mode=author','tool/lasbmt11/learner.do?mode=teacher','tool/lasbmt11/authoring.do','tool/lasbmt11/definelater.do?mode=teacher','tool/lasbmt11/exportPortfolio?mode=learner','tool/lasbmt11/exportPortfolio?mode=teacher','tool/lasbmt11/monitoring.do','tool/lasbmt11/contribute.do','tool/lasbmt11/moderation.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasbmt11','2007-06-04 14:45:21','org.lamsfoundation.lams.tool.sbmt.ApplicationResources','2007-06-04 14:45:21','lams-tool-lasbmt11.jar','/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml'),(5,'lachat11','chatService','Chat','Chat','chat','20070524',5,5,1,2,1,'tool/lachat11/learning.do?mode=learner','tool/lachat11/learning.do?mode=author','tool/lachat11/learning.do?mode=teacher','tool/lachat11/authoring.do','tool/lachat11/authoring.do?mode=teacher','tool/lachat11/exportPortfolio?mode=learner','tool/lachat11/exportPortfolio?mode=teacher','tool/lachat11/monitoring.do','tool/lachat11/contribute.do','tool/lachat11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lachat11','2007-06-04 14:45:31','org.lamsfoundation.lams.tool.chat.ApplicationResources','2007-06-04 14:45:31','lams-tool-lachat11.jar','/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml'),(6,'larsrc11','resourceService','Shared Resources','Shared Resources','sharedresources','20070524',6,6,1,2,1,'tool/larsrc11/learning/start.do?mode=learner','tool/larsrc11/learning/start.do?mode=author','tool/larsrc11/learning/start.do?mode=teacher','tool/larsrc11/authoring/start.do','tool/larsrc11/definelater.do','tool/larsrc11/exportPortfolio?mode=learner','tool/larsrc11/exportPortfolio?mode=teacher','tool/larsrc11/monitoring/summary.do','tool/larsrc11/contribute.do','tool/larsrc11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/larsrc11','2007-06-04 14:45:42','org.lamsfoundation.lams.tool.rsrc.ApplicationResources','2007-06-04 14:45:42','lams-tool-larsrc11.jar','/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml'),(7,'lavote11','voteService','Voting','Voting','vote','20070524',7,7,1,2,1,'tool/lavote11/learningStarter.do?mode=learner','tool/lavote11/learningStarter.do?mode=author','tool/lavote11/learningStarter.do?mode=teacher','tool/lavote11/authoringStarter.do','tool/lavote11/defineLaterStarter.do','tool/lavote11/exportPortfolio?mode=learner','tool/lavote11/exportPortfolio?mode=teacher','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lavote11','2007-06-04 14:45:48','org.lamsfoundation.lams.tool.vote.ApplicationResources','2007-06-04 14:45:48','lams-tool-lavote11.jar','/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml'),(8,'lantbk11','notebookService','Notebook','Notebook','notebook','20070524',8,8,1,2,1,'tool/lantbk11/learning.do?mode=learner','tool/lantbk11/learning.do?mode=author','tool/lantbk11/learning.do?mode=teacher','tool/lantbk11/authoring.do','tool/lantbk11/authoring.do?mode=teacher','tool/lantbk11/exportPortfolio?mode=learner','tool/lantbk11/exportPortfolio?mode=teacher','tool/lantbk11/monitoring.do','tool/lantbk11/contribute.do','tool/lantbk11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lantbk11','2007-06-04 14:45:57','org.lamsfoundation.lams.tool.notebook.ApplicationResources','2007-06-04 14:45:57','lams-tool-lantbk11.jar','/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml'),(9,'lasurv11','lasurvSurveyService','Survey','Survey','survey','20070524',9,9,1,2,1,'tool/lasurv11/learning/start.do?mode=learner','tool/lasurv11/learning/start.do?mode=author','tool/lasurv11/learning/start.do?mode=teacher','tool/lasurv11/authoring/start.do','tool/lasurv11/definelater.do','tool/lasurv11/exportPortfolio?mode=learner','tool/lasurv11/exportPortfolio?mode=teacher','tool/lasurv11/monitoring/summary.do','tool/lasurv11/contribute.do','tool/lasurv11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasurv11','2007-06-04 14:46:08','org.lamsfoundation.lams.tool.survey.ApplicationResources','2007-06-04 14:46:08','lams-tool-lasurv11.jar','/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml'),(10,'lascrb11','lascrbScribeService','Scribe','Scribe','scribe','20070524',10,10,1,2,1,'tool/lascrb11/learning.do?mode=learner','tool/lascrb11/learning.do?mode=author','tool/lascrb11/learning.do?mode=teacher','tool/lascrb11/authoring.do','tool/lascrb11/authoring.do?mode=teacher','tool/lascrb11/exportPortfolio?mode=learner','tool/lascrb11/exportPortfolio?mode=teacher','tool/lascrb11/monitoring.do','tool/lascrb11/contribute.do','tool/lascrb11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lascrb11','2007-06-04 14:46:19','org.lamsfoundation.lams.tool.scribe.ApplicationResources','2007-06-04 14:46:19','lams-tool-lascrb11.jar','/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml'),(11,'lamc11','mcService','MCQ','Multiple Choice Questions','mc','20070524',11,11,1,2,1,'tool/lamc11/learningStarter.do?mode=learner','tool/lamc11/learningStarter.do?mode=author','tool/lamc11/learningStarter.do?mode=teacher','tool/lamc11/authoringStarter.do','tool/lamc11/defineLaterStarter.do','tool/lamc11/exportPortfolio?mode=learner','tool/lamc11/exportPortfolio?mode=teacher','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lamc11','2007-06-04 14:46:24','org.lamsfoundation.lams.tool.mc.ApplicationResources','2007-06-04 14:46:24','lams-tool-lamc11.jar','/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml'); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_tool` DISABLE KEYS */; +INSERT INTO `lams_tool` VALUES (1,'lafrum11','forumService','Forum','Forum / Message Boards','forum','20080220',1,1,1,2,1,'tool/lafrum11/learning/viewForum.do?mode=learner','tool/lafrum11/learning/viewForum.do?mode=author','tool/lafrum11/learning/viewForum.do?mode=teacher','tool/lafrum11/authoring.do','tool/lafrum11/defineLater.do','tool/lafrum11/exportPortfolio?mode=learner','tool/lafrum11/exportPortfolio?mode=teacher','tool/lafrum11/monitoring.do','tool/lafrum11/contribute.do','tool/lafrum11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lafrum11','2008-03-12 16:37:23','org.lamsfoundation.lams.tool.forum.ApplicationResources','2008-03-12 16:37:23','lams-tool-lafrum11.jar','/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml',NULL),(2,'lanb11','nbService','NoticeboardX','Displays a NoticeboardX','nb','20070524',2,2,1,2,1,'tool/lanb11/starter/learner.do?mode=learner','tool/lanb11/starter/learner.do?mode=author','tool/lanb11/starter/learner.do?mode=teacher','tool/lanb11/authoring.do','tool/lanb11/authoring.do?defineLater=true','tool/lanb11/portfolioExport?mode=learner','tool/lanb11/portfolioExport?mode=teacher','tool/lanb11/monitoring.do',NULL,NULL,'http://wiki.lamsfoundation.org/display/lamsdocs/lanb11','2008-03-12 16:37:28','org.lamsfoundation.lams.tool.noticeboard.ApplicationResources','2008-03-12 16:37:28','lams-tool-lanb11.jar','/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml',NULL),(3,'laqa11','qaService','Question and Answer','Q/A Tool','qa','20080108',3,3,1,2,1,'tool/laqa11/learningStarter.do?mode=learner','tool/laqa11/learningStarter.do?mode=author','tool/laqa11/learningStarter.do?mode=teacher','tool/laqa11/authoringStarter.do','tool/laqa11/defineLaterStarter.do','tool/laqa11/exportPortfolio?mode=learner','tool/laqa11/exportPortfolio?mode=teacher','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/laqa11','2008-03-12 16:37:31','org.lamsfoundation.lams.tool.qa.ApplicationResources','2008-03-12 16:37:31','lams-tool-laqa11.jar','/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml',NULL),(4,'lasbmt11','submitFilesService','Submit File','Submit File Tool Description','submitfile','20070524',4,4,1,2,1,'tool/lasbmt11/learner.do?mode=learner','tool/lasbmt11/learner.do?mode=author','tool/lasbmt11/learner.do?mode=teacher','tool/lasbmt11/authoring.do','tool/lasbmt11/definelater.do?mode=teacher','tool/lasbmt11/exportPortfolio?mode=learner','tool/lasbmt11/exportPortfolio?mode=teacher','tool/lasbmt11/monitoring.do','tool/lasbmt11/contribute.do','tool/lasbmt11/moderation.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasbmt11','2008-03-12 16:37:36','org.lamsfoundation.lams.tool.sbmt.ApplicationResources','2008-03-12 16:37:36','lams-tool-lasbmt11.jar','/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml',NULL),(5,'lachat11','chatService','Chat','Chat','chat','20080229',5,5,1,2,1,'tool/lachat11/learning.do?mode=learner','tool/lachat11/learning.do?mode=author','tool/lachat11/learning.do?mode=teacher','tool/lachat11/authoring.do','tool/lachat11/authoring.do?mode=teacher','tool/lachat11/exportPortfolio?mode=learner','tool/lachat11/exportPortfolio?mode=teacher','tool/lachat11/monitoring.do','tool/lachat11/contribute.do','tool/lachat11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lachat11','2008-03-12 16:37:43','org.lamsfoundation.lams.tool.chat.ApplicationResources','2008-03-12 16:37:43','lams-tool-lachat11.jar','/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml',NULL),(6,'larsrc11','resourceService','Shared Resources','Shared Resources','sharedresources','20080229',6,6,1,2,1,'tool/larsrc11/learning/start.do?mode=learner','tool/larsrc11/learning/start.do?mode=author','tool/larsrc11/learning/start.do?mode=teacher','tool/larsrc11/authoring/start.do','tool/larsrc11/definelater.do','tool/larsrc11/exportPortfolio?mode=learner','tool/larsrc11/exportPortfolio?mode=teacher','tool/larsrc11/monitoring/summary.do','tool/larsrc11/contribute.do','tool/larsrc11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/larsrc11','2008-03-12 16:37:52','org.lamsfoundation.lams.tool.rsrc.ApplicationResources','2008-03-12 16:37:52','lams-tool-larsrc11.jar','/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml',NULL),(7,'lavote11','voteService','Voting','Voting','vote','20080108',7,7,1,2,1,'tool/lavote11/learningStarter.do?mode=learner','tool/lavote11/learningStarter.do?mode=author','tool/lavote11/learningStarter.do?mode=teacher','tool/lavote11/authoringStarter.do','tool/lavote11/defineLaterStarter.do','tool/lavote11/exportPortfolio?mode=learner','tool/lavote11/exportPortfolio?mode=teacher','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lavote11','2008-03-12 16:37:57','org.lamsfoundation.lams.tool.vote.ApplicationResources','2008-03-12 16:37:57','lams-tool-lavote11.jar','/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml',NULL),(8,'lantbk11','notebookService','Notebook','Notebook','notebook','20080229',8,8,1,2,1,'tool/lantbk11/learning.do?mode=learner','tool/lantbk11/learning.do?mode=author','tool/lantbk11/learning.do?mode=teacher','tool/lantbk11/authoring.do','tool/lantbk11/authoring.do?mode=teacher','tool/lantbk11/exportPortfolio?mode=learner','tool/lantbk11/exportPortfolio?mode=teacher','tool/lantbk11/monitoring.do','tool/lantbk11/contribute.do','tool/lantbk11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lantbk11','2008-03-12 16:38:03','org.lamsfoundation.lams.tool.notebook.ApplicationResources','2008-03-12 16:38:03','lams-tool-lantbk11.jar','/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml',NULL),(9,'lasurv11','lasurvSurveyService','Survey','Survey','survey','20080229',9,9,1,2,1,'tool/lasurv11/learning/start.do?mode=learner','tool/lasurv11/learning/start.do?mode=author','tool/lasurv11/learning/start.do?mode=teacher','tool/lasurv11/authoring/start.do','tool/lasurv11/definelater.do','tool/lasurv11/exportPortfolio?mode=learner','tool/lasurv11/exportPortfolio?mode=teacher','tool/lasurv11/monitoring/summary.do','tool/lasurv11/contribute.do','tool/lasurv11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasurv11','2008-03-12 16:38:10','org.lamsfoundation.lams.tool.survey.ApplicationResources','2008-03-12 16:38:10','lams-tool-lasurv11.jar','/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml',NULL),(10,'lascrb11','lascrbScribeService','Scribe','Scribe','scribe','20080229',10,10,1,2,1,'tool/lascrb11/learning.do?mode=learner','tool/lascrb11/learning.do?mode=author','tool/lascrb11/learning.do?mode=teacher','tool/lascrb11/authoring.do','tool/lascrb11/authoring.do?mode=teacher','tool/lascrb11/exportPortfolio?mode=learner','tool/lascrb11/exportPortfolio?mode=teacher','tool/lascrb11/monitoring.do','tool/lascrb11/contribute.do','tool/lascrb11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lascrb11','2008-03-12 16:38:17','org.lamsfoundation.lams.tool.scribe.ApplicationResources','2008-03-12 16:38:17','lams-tool-lascrb11.jar','/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml',NULL),(11,'lamc11','mcService','MCQ','Multiple Choice Questions','mc','20070820',11,11,1,2,1,'tool/lamc11/learningStarter.do?mode=learner','tool/lamc11/learningStarter.do?mode=author','tool/lamc11/learningStarter.do?mode=teacher','tool/lamc11/authoringStarter.do','tool/lamc11/defineLaterStarter.do','tool/lamc11/exportPortfolio?mode=learner','tool/lamc11/exportPortfolio?mode=teacher','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lamc11','2008-03-12 16:38:20','org.lamsfoundation.lams.tool.mc.ApplicationResources','2008-03-12 16:38:20','lams-tool-lamc11.jar','/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml',NULL); /*!40000 ALTER TABLE `lams_tool` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_tool_content` @@ -1686,18 +1748,17 @@ PRIMARY KEY (`tool_content_id`), KEY `tool_id` (`tool_id`), CONSTRAINT `FK_lams_tool_content_1` FOREIGN KEY (`tool_id`) REFERENCES `lams_tool` (`tool_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_tool_content` -- - -/*!40000 ALTER TABLE `lams_tool_content` DISABLE KEYS */; LOCK TABLES `lams_tool_content` WRITE; +/*!40000 ALTER TABLE `lams_tool_content` DISABLE KEYS */; INSERT INTO `lams_tool_content` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_tool_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_tool_import_support` @@ -1709,18 +1770,17 @@ `installed_tool_signature` varchar(15) NOT NULL, `supports_tool_signature` varchar(50) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_tool_import_support` -- - -/*!40000 ALTER TABLE `lams_tool_import_support` DISABLE KEYS */; LOCK TABLES `lams_tool_import_support` WRITE; +/*!40000 ALTER TABLE `lams_tool_import_support` DISABLE KEYS */; INSERT INTO `lams_tool_import_support` VALUES (1,'lafrum11','messageboard'),(2,'lamc11','simpleassessment'),(3,'lanb11','noticeboard'),(4,'lanb11','htmlnb'),(5,'laqa11','qa'),(6,'lasbmt11','reportsubmission'),(7,'lachat11','chat'),(8,'larsrc11','urlcontent'),(11,'lavote11','ranking'),(12,'lantbk11','journal'),(13,'lascrb11','groupreporting'),(14,'lasurv11','survey'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_tool_import_support` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_tool_session` @@ -1756,11 +1816,10 @@ -- Dumping data for table `lams_tool_session` -- - -/*!40000 ALTER TABLE `lams_tool_session` DISABLE KEYS */; LOCK TABLES `lams_tool_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_tool_session` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_tool_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_tool_session_state` @@ -1777,12 +1836,11 @@ -- Dumping data for table `lams_tool_session_state` -- - -/*!40000 ALTER TABLE `lams_tool_session_state` DISABLE KEYS */; LOCK TABLES `lams_tool_session_state` WRITE; +/*!40000 ALTER TABLE `lams_tool_session_state` DISABLE KEYS */; INSERT INTO `lams_tool_session_state` VALUES (1,'STARTED'),(2,'ENDED'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_tool_session_state` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_tool_session_type` @@ -1799,12 +1857,11 @@ -- Dumping data for table `lams_tool_session_type` -- - -/*!40000 ALTER TABLE `lams_tool_session_type` DISABLE KEYS */; LOCK TABLES `lams_tool_session_type` WRITE; +/*!40000 ALTER TABLE `lams_tool_session_type` DISABLE KEYS */; INSERT INTO `lams_tool_session_type` VALUES (1,'NON_GROUPED'),(2,'GROUPED'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_tool_session_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_user` @@ -1840,6 +1897,7 @@ `locale_id` int(11) default NULL, `portrait_uuid` bigint(20) default NULL, `change_password` tinyint(4) default '0', + `enable_flash` tinyint(1) default '1', PRIMARY KEY (`user_id`), UNIQUE KEY `UQ_lams_user_login` (`login`), KEY `authentication_method_id` (`authentication_method_id`), @@ -1853,18 +1911,17 @@ CONSTRAINT `FK_lams_user_4` FOREIGN KEY (`flash_theme_id`) REFERENCES `lams_css_theme_ve` (`theme_ve_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_user_5` FOREIGN KEY (`html_theme_id`) REFERENCES `lams_css_theme_ve` (`theme_ve_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_user_6` FOREIGN KEY (`locale_id`) REFERENCES `lams_supported_locale` (`locale_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_user` -- - -/*!40000 ALTER TABLE `lams_user` DISABLE KEYS */; LOCK TABLES `lams_user` WRITE; -INSERT INTO `lams_user` VALUES (1,'sysadmin','a159b7ae81ba3552af61e9731b20870515944538','The','System','Administrator',NULL,NULL,NULL,'Sydney','NSW',NULL,'Australia',NULL,NULL,NULL,NULL,'sysadmin@x.x',0,'2007-06-04 14:44:48',1,51,1,2,NULL,1,NULL,0),(5,'test1','b444ac06613fc8d63795be9ad0beaf55011936ac','Dr','One','Test','1','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test1@xx.os',0,'2004-12-23 00:00:00',1,5,1,2,NULL,1,NULL,0),(6,'test2','109f4b3c50d7b0df729d299bc6f8e9ef9066971f','Dr','Two','Test','2','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test2@xx.os',0,'2004-12-23 00:00:00',1,6,1,2,NULL,1,NULL,0),(7,'test3','3ebfa301dc59196f18593c45e519287a23297589','Dr','Three','Test','3','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test3@xx.os',0,'2004-12-23 00:00:00',1,7,1,2,NULL,1,NULL,0),(8,'test4','1ff2b3704aede04eecb51e50ca698efd50a1379b','Dr','Four','Test','4','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test4@xx.os',0,'2004-12-23 00:00:00',1,8,1,2,NULL,1,NULL,0); -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_user` DISABLE KEYS */; +INSERT INTO `lams_user` VALUES (1,'sysadmin','a159b7ae81ba3552af61e9731b20870515944538','The','System','Administrator',NULL,NULL,NULL,'Sydney','NSW',NULL,'Australia',NULL,NULL,NULL,NULL,'sysadmin@x.x',0,'2008-03-12 16:37:15',1,51,1,2,NULL,1,NULL,0,1),(5,'test1','b444ac06613fc8d63795be9ad0beaf55011936ac','Dr','One','Test','1','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test1@xx.os',0,'2004-12-23 00:00:00',1,5,1,2,NULL,1,NULL,0,1),(6,'test2','109f4b3c50d7b0df729d299bc6f8e9ef9066971f','Dr','Two','Test','2','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test2@xx.os',0,'2004-12-23 00:00:00',1,6,1,2,NULL,1,NULL,0,1),(7,'test3','3ebfa301dc59196f18593c45e519287a23297589','Dr','Three','Test','3','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test3@xx.os',0,'2004-12-23 00:00:00',1,7,1,2,NULL,1,NULL,0,1),(8,'test4','1ff2b3704aede04eecb51e50ca698efd50a1379b','Dr','Four','Test','4','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test4@xx.os',0,'2004-12-23 00:00:00',1,8,1,2,NULL,1,NULL,0,1); /*!40000 ALTER TABLE `lams_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_user_group` @@ -1885,11 +1942,10 @@ -- Dumping data for table `lams_user_group` -- - -/*!40000 ALTER TABLE `lams_user_group` DISABLE KEYS */; LOCK TABLES `lams_user_group` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_user_group` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_user_group` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_user_organisation` @@ -1905,20 +1961,40 @@ KEY `user_id` (`user_id`), CONSTRAINT `FK_lams_user_organisation_1` FOREIGN KEY (`organisation_id`) REFERENCES `lams_organisation` (`organisation_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_user_organisation_2` FOREIGN KEY (`user_id`) REFERENCES `lams_user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_user_organisation` -- - -/*!40000 ALTER TABLE `lams_user_organisation` DISABLE KEYS */; LOCK TABLES `lams_user_organisation` WRITE; +/*!40000 ALTER TABLE `lams_user_organisation` DISABLE KEYS */; INSERT INTO `lams_user_organisation` VALUES (1,1,1),(5,2,5),(6,2,6),(7,2,7),(8,2,8),(12,3,5),(13,3,6),(14,3,7),(15,3,8),(19,4,5),(20,4,6),(21,4,7),(22,4,8),(26,5,5),(27,5,6),(28,6,7),(29,6,8); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_user_organisation` ENABLE KEYS */; +UNLOCK TABLES; -- +-- Table structure for table `lams_user_organisation_collapsed` +-- + +DROP TABLE IF EXISTS `lams_user_organisation_collapsed`; +CREATE TABLE `lams_user_organisation_collapsed` ( + `user_organisation_id` bigint(20) NOT NULL, + `collapsed` tinyint(1) NOT NULL default '1', + PRIMARY KEY (`user_organisation_id`), + CONSTRAINT `FK_lams_user_organisation_collapsed_1` FOREIGN KEY (`user_organisation_id`) REFERENCES `lams_user_organisation` (`user_organisation_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `lams_user_organisation_collapsed` +-- + +LOCK TABLES `lams_user_organisation_collapsed` WRITE; +/*!40000 ALTER TABLE `lams_user_organisation_collapsed` DISABLE KEYS */; +/*!40000 ALTER TABLE `lams_user_organisation_collapsed` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `lams_user_organisation_role` -- @@ -1932,18 +2008,17 @@ KEY `user_organisation_id` (`user_organisation_id`), CONSTRAINT `FK_lams_user_organisation_role_2` FOREIGN KEY (`role_id`) REFERENCES `lams_role` (`role_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_user_organisation_role_3` FOREIGN KEY (`user_organisation_id`) REFERENCES `lams_user_organisation` (`user_organisation_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_user_organisation_role` -- - -/*!40000 ALTER TABLE `lams_user_organisation_role` DISABLE KEYS */; LOCK TABLES `lams_user_organisation_role` WRITE; +/*!40000 ALTER TABLE `lams_user_organisation_role` DISABLE KEYS */; INSERT INTO `lams_user_organisation_role` VALUES (1,1,1),(5,5,3),(6,6,3),(7,7,3),(8,8,3),(12,5,4),(13,6,4),(14,7,4),(15,8,4),(19,5,5),(20,6,5),(21,7,5),(22,8,5),(26,12,4),(27,13,4),(28,14,4),(33,12,5),(34,13,5),(35,14,5),(36,15,5),(40,19,3),(41,20,3),(42,21,3),(43,22,3),(47,19,4),(48,20,4),(49,21,4),(50,22,4),(54,19,5),(55,20,5),(56,21,5),(57,22,5),(61,26,4),(62,27,4),(63,28,4),(64,29,4),(68,26,5),(69,27,5),(70,28,5),(71,29,5); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_user_organisation_role` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_wkspc_fld_content_type` @@ -1954,18 +2029,17 @@ `content_type_id` int(3) NOT NULL auto_increment, `description` varchar(64) NOT NULL, PRIMARY KEY (`content_type_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_wkspc_fld_content_type` -- - -/*!40000 ALTER TABLE `lams_wkspc_fld_content_type` DISABLE KEYS */; LOCK TABLES `lams_wkspc_fld_content_type` WRITE; +/*!40000 ALTER TABLE `lams_wkspc_fld_content_type` DISABLE KEYS */; INSERT INTO `lams_wkspc_fld_content_type` VALUES (1,'FILE'),(2,'PACKAGE'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_wkspc_fld_content_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_wkspc_wkspc_folder` @@ -1981,18 +2055,17 @@ KEY `workspace_folder_id` (`workspace_folder_id`), CONSTRAINT `FK_lams_ww_folder_1` FOREIGN KEY (`workspace_id`) REFERENCES `lams_workspace` (`workspace_id`), CONSTRAINT `FK_lams_ww_folder_2` FOREIGN KEY (`workspace_folder_id`) REFERENCES `lams_workspace_folder` (`workspace_folder_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_wkspc_wkspc_folder` -- - -/*!40000 ALTER TABLE `lams_wkspc_wkspc_folder` DISABLE KEYS */; LOCK TABLES `lams_wkspc_wkspc_folder` WRITE; +/*!40000 ALTER TABLE `lams_wkspc_wkspc_folder` DISABLE KEYS */; INSERT INTO `lams_wkspc_wkspc_folder` VALUES (1,1,1),(2,2,2),(3,2,22),(4,3,3),(5,3,23),(7,5,5),(8,6,6),(9,7,7),(10,8,8),(11,50,40),(12,51,45); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_wkspc_wkspc_folder` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_workspace` @@ -2009,18 +2082,17 @@ KEY `default_fld_id` (`default_fld_id`), CONSTRAINT `FK_lams_workspace_1` FOREIGN KEY (`def_run_seq_fld_id`) REFERENCES `lams_workspace_folder` (`workspace_folder_id`), CONSTRAINT `FK_lams_workspace_2` FOREIGN KEY (`default_fld_id`) REFERENCES `lams_workspace_folder` (`workspace_folder_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_workspace` -- - -/*!40000 ALTER TABLE `lams_workspace` DISABLE KEYS */; LOCK TABLES `lams_workspace` WRITE; +/*!40000 ALTER TABLE `lams_workspace` DISABLE KEYS */; INSERT INTO `lams_workspace` VALUES (1,1,NULL,'ROOT'),(2,2,22,'Developers Playpen'),(3,3,23,'MATH111'),(5,5,NULL,'One Test'),(6,6,NULL,'Two Test'),(7,7,NULL,'Three Test'),(8,8,NULL,'Four Test'),(50,40,41,'Moodle Test'),(51,45,NULL,'System Administrator'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_workspace` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_workspace_folder` @@ -2040,18 +2112,17 @@ KEY `lams_workspace_folder_type_id` (`lams_workspace_folder_type_id`), CONSTRAINT `FK_lams_workspace_folder_2` FOREIGN KEY (`parent_folder_id`) REFERENCES `lams_workspace_folder` (`workspace_folder_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_workspace_folder_4` FOREIGN KEY (`lams_workspace_folder_type_id`) REFERENCES `lams_workspace_folder_type` (`lams_workspace_folder_type_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_workspace_folder` -- - -/*!40000 ALTER TABLE `lams_workspace_folder` DISABLE KEYS */; LOCK TABLES `lams_workspace_folder` WRITE; +/*!40000 ALTER TABLE `lams_workspace_folder` DISABLE KEYS */; INSERT INTO `lams_workspace_folder` VALUES (1,NULL,'ROOT',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(2,1,'Developers Playpen',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(3,1,'MATH111',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(5,NULL,'One Test',5,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(6,NULL,'Two Test',6,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(7,NULL,'Three Test',7,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(8,NULL,'Four Test',8,'2004-12-23 00:00:00','2004-12-23 00:00:00',1),(22,2,'Lesson Sequence Folder',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',2),(23,3,'Lesson Sequence Folder',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',2),(40,1,'Moodle Test',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',2),(41,40,'Lesson Sequence Folder',1,'2004-12-23 00:00:00','2004-12-23 00:00:00',2),(45,NULL,'System Administrator',1,'2006-11-01 00:00:00','2006-11-01 00:00:00',1); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_workspace_folder` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_workspace_folder_content` @@ -2082,11 +2153,10 @@ -- Dumping data for table `lams_workspace_folder_content` -- - -/*!40000 ALTER TABLE `lams_workspace_folder_content` DISABLE KEYS */; LOCK TABLES `lams_workspace_folder_content` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `lams_workspace_folder_content` DISABLE KEYS */; /*!40000 ALTER TABLE `lams_workspace_folder_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `lams_workspace_folder_type` @@ -2103,12 +2173,11 @@ -- Dumping data for table `lams_workspace_folder_type` -- - -/*!40000 ALTER TABLE `lams_workspace_folder_type` DISABLE KEYS */; LOCK TABLES `lams_workspace_folder_type` WRITE; +/*!40000 ALTER TABLE `lams_workspace_folder_type` DISABLE KEYS */; INSERT INTO `lams_workspace_folder_type` VALUES (1,'NORMAL'),(2,'RUN SEQUENCES'); -UNLOCK TABLES; /*!40000 ALTER TABLE `lams_workspace_folder_type` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lachat11_attachment` @@ -2124,18 +2193,18 @@ `create_date` datetime default NULL, `chat_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK9ED6CB2E1A3926E3` (`chat_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK9ED6CB2E1A3926E3` (`chat_uid`), + CONSTRAINT `FK9ED6CB2E1A3926E3` FOREIGN KEY (`chat_uid`) REFERENCES `tl_lachat11_chat` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_attachment` -- - -/*!40000 ALTER TABLE `tl_lachat11_attachment` DISABLE KEYS */; LOCK TABLES `tl_lachat11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lachat11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lachat11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lachat11_chat` @@ -2161,18 +2230,17 @@ `filtering_enabled` bit(1) default NULL, `filter_keywords` text, PRIMARY KEY (`uid`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_chat` -- - -/*!40000 ALTER TABLE `tl_lachat11_chat` DISABLE KEYS */; LOCK TABLES `tl_lachat11_chat` WRITE; +/*!40000 ALTER TABLE `tl_lachat11_chat` DISABLE KEYS */; INSERT INTO `tl_lachat11_chat` VALUES (1,NULL,NULL,NULL,'Chat','Instructions','\0','\0','\0',NULL,'','','\0','\0',5,'\0',NULL); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lachat11_chat` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lachat11_message` @@ -2191,18 +2259,20 @@ PRIMARY KEY (`uid`), KEY `FKCC08C1DC2AF61E05` (`to_user_uid`), KEY `FKCC08C1DC9C8469FC` (`chat_session_uid`), - KEY `FKCC08C1DCCF3BF9B6` (`from_user_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FKCC08C1DCCF3BF9B6` (`from_user_uid`), + CONSTRAINT `FKCC08C1DCCF3BF9B6` FOREIGN KEY (`from_user_uid`) REFERENCES `tl_lachat11_user` (`uid`), + CONSTRAINT `FKCC08C1DC2AF61E05` FOREIGN KEY (`to_user_uid`) REFERENCES `tl_lachat11_user` (`uid`), + CONSTRAINT `FKCC08C1DC9C8469FC` FOREIGN KEY (`chat_session_uid`) REFERENCES `tl_lachat11_session` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_message` -- - -/*!40000 ALTER TABLE `tl_lachat11_message` DISABLE KEYS */; LOCK TABLES `tl_lachat11_message` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lachat11_message` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lachat11_message` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lachat11_session` @@ -2220,18 +2290,18 @@ `jabber_room` varchar(250) default NULL, `room_created` bit(1) default NULL, PRIMARY KEY (`uid`), - KEY `FK96E446B1A3926E3` (`chat_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK96E446B1A3926E3` (`chat_uid`), + CONSTRAINT `FK96E446B1A3926E3` FOREIGN KEY (`chat_uid`) REFERENCES `tl_lachat11_chat` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_session` -- - -/*!40000 ALTER TABLE `tl_lachat11_session` DISABLE KEYS */; LOCK TABLES `tl_lachat11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lachat11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lachat11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lachat11_user` @@ -2249,18 +2319,18 @@ `jabber_nickname` varchar(255) default NULL, `chat_session_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK4EB82169C8469FC` (`chat_session_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK4EB82169C8469FC` (`chat_session_uid`), + CONSTRAINT `FK4EB82169C8469FC` FOREIGN KEY (`chat_session_uid`) REFERENCES `tl_lachat11_session` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_user` -- - -/*!40000 ALTER TABLE `tl_lachat11_user` DISABLE KEYS */; LOCK TABLES `tl_lachat11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lachat11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lachat11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_attachment` @@ -2287,11 +2357,10 @@ -- Dumping data for table `tl_lafrum11_attachment` -- - -/*!40000 ALTER TABLE `tl_lafrum11_attachment` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lafrum11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lafrum11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_forum` @@ -2327,18 +2396,17 @@ UNIQUE KEY `content_id` (`content_id`), KEY `FK87917942E42F4351` (`create_by`), CONSTRAINT `FK87917942E42F4351` FOREIGN KEY (`create_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lafrum11_forum` -- - -/*!40000 ALTER TABLE `tl_lafrum11_forum` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_forum` WRITE; +/*!40000 ALTER TABLE `tl_lafrum11_forum` DISABLE KEYS */; INSERT INTO `tl_lafrum11_forum` VALUES (1,NULL,NULL,NULL,'Forum',0,0,0,'Instructions',NULL,NULL,0,0,1,1,0,1,0,1,0,5000,1,NULL,0); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lafrum11_forum` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_forum_user` @@ -2362,11 +2430,10 @@ -- Dumping data for table `tl_lafrum11_forum_user` -- - -/*!40000 ALTER TABLE `tl_lafrum11_forum_user` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_forum_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lafrum11_forum_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lafrum11_forum_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_message` @@ -2390,31 +2457,32 @@ `reply_number` int(11) default NULL, `hide_flag` smallint(6) default NULL, `report_id` bigint(20) default NULL, + `authored_parent_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), KEY `FK4A6067E8E42F4351` (`create_by`), KEY `FK4A6067E897F0DB46` (`report_id`), KEY `FK4A6067E8131CE31E` (`forum_uid`), KEY `FK4A6067E824089E4D` (`parent_uid`), KEY `FK4A6067E89357B45B` (`forum_session_uid`), KEY `FK4A6067E8647A7264` (`modified_by`), - CONSTRAINT `FK4A6067E8647A7264` FOREIGN KEY (`modified_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`), + KEY `IX_msg_auth_parent` (`authored_parent_uid`), CONSTRAINT `FK4A6067E8131CE31E` FOREIGN KEY (`forum_uid`) REFERENCES `tl_lafrum11_forum` (`uid`), CONSTRAINT `FK4A6067E824089E4D` FOREIGN KEY (`parent_uid`) REFERENCES `tl_lafrum11_message` (`uid`), + CONSTRAINT `FK4A6067E8647A7264` FOREIGN KEY (`modified_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`), CONSTRAINT `FK4A6067E89357B45B` FOREIGN KEY (`forum_session_uid`) REFERENCES `tl_lafrum11_tool_session` (`uid`), CONSTRAINT `FK4A6067E897F0DB46` FOREIGN KEY (`report_id`) REFERENCES `tl_lafrum11_report` (`uid`), CONSTRAINT `FK4A6067E8E42F4351` FOREIGN KEY (`create_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lafrum11_message` -- - -/*!40000 ALTER TABLE `tl_lafrum11_message` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_message` WRITE; -INSERT INTO `tl_lafrum11_message` VALUES (1,'2007-06-04 14:44:59','2007-06-04 14:44:59','2007-06-04 14:44:59',NULL,NULL,'Topic Heading','Topic message',1,0,NULL,NULL,1,0,0,NULL); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lafrum11_message` DISABLE KEYS */; +INSERT INTO `tl_lafrum11_message` VALUES (1,'2008-03-12 16:37:23','2008-03-12 16:37:23','2008-03-12 16:37:23',NULL,NULL,'Topic Heading','Topic message',1,0,NULL,NULL,1,0,0,NULL,NULL); /*!40000 ALTER TABLE `tl_lafrum11_message` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_message_seq` @@ -2437,11 +2505,10 @@ -- Dumping data for table `tl_lafrum11_message_seq` -- - -/*!40000 ALTER TABLE `tl_lafrum11_message_seq` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_message_seq` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lafrum11_message_seq` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lafrum11_message_seq` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_report` @@ -2460,11 +2527,10 @@ -- Dumping data for table `tl_lafrum11_report` -- - -/*!40000 ALTER TABLE `tl_lafrum11_report` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_report` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lafrum11_report` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lafrum11_report` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lafrum11_tool_session` @@ -2490,11 +2556,10 @@ -- Dumping data for table `tl_lafrum11_tool_session` -- - -/*!40000 ALTER TABLE `tl_lafrum11_tool_session` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_tool_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lafrum11_tool_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lafrum11_tool_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_content` @@ -2522,20 +2587,20 @@ `reflectionSubject` text, `showMarks` tinyint(1) NOT NULL default '0', `randomize` tinyint(1) NOT NULL default '0', + `displayAnswers` tinyint(1) NOT NULL default '1', PRIMARY KEY (`uid`), UNIQUE KEY `UQ_tl_lamc11_content_1` (`content_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lamc11_content` -- - -/*!40000 ALTER TABLE `tl_lamc11_content` DISABLE KEYS */; LOCK TABLES `tl_lamc11_content` WRITE; -INSERT INTO `tl_lamc11_content` VALUES (1,11,'MCQ','Instructions','2007-06-04 14:46:24',NULL,0,0,1,0,0,'','',0,0,0,0,NULL,0,0); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lamc11_content` DISABLE KEYS */; +INSERT INTO `tl_lamc11_content` VALUES (1,11,'MCQ','Instructions','2008-03-12 16:38:21',NULL,0,0,1,0,0,'','',0,0,0,0,NULL,0,0,1); /*!40000 ALTER TABLE `tl_lamc11_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_options_content` @@ -2551,18 +2616,17 @@ PRIMARY KEY (`uid`), KEY `mc_que_content_id` (`mc_que_content_id`), CONSTRAINT `FK_tl_lamc11_options_content_1` FOREIGN KEY (`mc_que_content_id`) REFERENCES `tl_lamc11_que_content` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lamc11_options_content` -- - -/*!40000 ALTER TABLE `tl_lamc11_options_content` DISABLE KEYS */; LOCK TABLES `tl_lamc11_options_content` WRITE; -INSERT INTO `tl_lamc11_options_content` VALUES (1,0,1,'Candidate Answer 1',1),(2,1,1,'Candidate Answer 2',2); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lamc11_options_content` DISABLE KEYS */; +INSERT INTO `tl_lamc11_options_content` VALUES (1,0,1,'Answer 1',1),(2,1,1,'Answer 2',2); /*!40000 ALTER TABLE `tl_lamc11_options_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_que_content` @@ -2579,18 +2643,17 @@ PRIMARY KEY (`uid`), KEY `mc_content_id` (`mc_content_id`), CONSTRAINT `FK_tl_lamc11_que_content_1` FOREIGN KEY (`mc_content_id`) REFERENCES `tl_lamc11_content` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lamc11_que_content` -- - -/*!40000 ALTER TABLE `tl_lamc11_que_content` DISABLE KEYS */; LOCK TABLES `tl_lamc11_que_content` WRITE; +/*!40000 ALTER TABLE `tl_lamc11_que_content` DISABLE KEYS */; INSERT INTO `tl_lamc11_que_content` VALUES (1,'A Sample question?',1,1,1,NULL); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lamc11_que_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_que_usr` @@ -2605,6 +2668,8 @@ `fullname` varchar(255) default NULL, `responseFinalised` tinyint(1) NOT NULL default '0', `viewSummaryRequested` tinyint(1) NOT NULL default '0', + `last_attempt_order` int(11) default NULL, + `last_attempt_total_mark` int(11) default NULL, PRIMARY KEY (`uid`), KEY `mc_session_id` (`mc_session_id`), CONSTRAINT `FK_tl_lamc11_que_usr_1` FOREIGN KEY (`mc_session_id`) REFERENCES `tl_lamc11_session` (`uid`) @@ -2614,11 +2679,10 @@ -- Dumping data for table `tl_lamc11_que_usr` -- - -/*!40000 ALTER TABLE `tl_lamc11_que_usr` DISABLE KEYS */; LOCK TABLES `tl_lamc11_que_usr` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lamc11_que_usr` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lamc11_que_usr` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_session` @@ -2643,11 +2707,10 @@ -- Dumping data for table `tl_lamc11_session` -- - -/*!40000 ALTER TABLE `tl_lamc11_session` DISABLE KEYS */; LOCK TABLES `tl_lamc11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lamc11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lamc11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_uploadedfile` @@ -2669,11 +2732,10 @@ -- Dumping data for table `tl_lamc11_uploadedfile` -- - -/*!40000 ALTER TABLE `tl_lamc11_uploadedfile` DISABLE KEYS */; LOCK TABLES `tl_lamc11_uploadedfile` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lamc11_uploadedfile` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lamc11_uploadedfile` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lamc11_usr_attempt` @@ -2704,11 +2766,10 @@ -- Dumping data for table `tl_lamc11_usr_attempt` -- - -/*!40000 ALTER TABLE `tl_lamc11_usr_attempt` DISABLE KEYS */; LOCK TABLES `tl_lamc11_usr_attempt` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lamc11_usr_attempt` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lamc11_usr_attempt` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lanb11_attachment` @@ -2731,11 +2792,10 @@ -- Dumping data for table `tl_lanb11_attachment` -- - -/*!40000 ALTER TABLE `tl_lanb11_attachment` DISABLE KEYS */; LOCK TABLES `tl_lanb11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lanb11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lanb11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lanb11_content` @@ -2759,18 +2819,17 @@ `date_updated` datetime default NULL, PRIMARY KEY (`uid`), UNIQUE KEY `nb_content_id` (`nb_content_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lanb11_content` -- - -/*!40000 ALTER TABLE `tl_lanb11_content` DISABLE KEYS */; LOCK TABLES `tl_lanb11_content` WRITE; -INSERT INTO `tl_lanb11_content` VALUES (1,2,'Noticeboard','Content','','',0,0,0,'Reflect on noticeboard',0,NULL,'2007-06-04 14:45:09',NULL); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lanb11_content` DISABLE KEYS */; +INSERT INTO `tl_lanb11_content` VALUES (1,2,'Noticeboard','Content','','',0,0,0,'Reflect on noticeboard',0,NULL,'2008-03-12 16:37:28',NULL); /*!40000 ALTER TABLE `tl_lanb11_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lanb11_session` @@ -2795,11 +2854,10 @@ -- Dumping data for table `tl_lanb11_session` -- - -/*!40000 ALTER TABLE `tl_lanb11_session` DISABLE KEYS */; LOCK TABLES `tl_lanb11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lanb11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lanb11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lanb11_user` @@ -2822,11 +2880,10 @@ -- Dumping data for table `tl_lanb11_user` -- - -/*!40000 ALTER TABLE `tl_lanb11_user` DISABLE KEYS */; LOCK TABLES `tl_lanb11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lanb11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lanb11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lantbk11_attachment` @@ -2842,18 +2899,18 @@ `create_date` datetime default NULL, `notebook_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK12090F57FC940906` (`notebook_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK12090F57FC940906` (`notebook_uid`), + CONSTRAINT `FK12090F57FC940906` FOREIGN KEY (`notebook_uid`) REFERENCES `tl_lantbk11_notebook` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lantbk11_attachment` -- - -/*!40000 ALTER TABLE `tl_lantbk11_attachment` DISABLE KEYS */; LOCK TABLES `tl_lantbk11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lantbk11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lantbk11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lantbk11_notebook` @@ -2876,18 +2933,17 @@ `define_later` bit(1) default NULL, `tool_content_id` bigint(20) default NULL, PRIMARY KEY (`uid`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lantbk11_notebook` -- - -/*!40000 ALTER TABLE `tl_lantbk11_notebook` DISABLE KEYS */; LOCK TABLES `tl_lantbk11_notebook` WRITE; +/*!40000 ALTER TABLE `tl_lantbk11_notebook` DISABLE KEYS */; INSERT INTO `tl_lantbk11_notebook` VALUES (1,NULL,NULL,NULL,'Notebook','Instructions','\0','\0','\0','','','\0','\0',8); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lantbk11_notebook` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lantbk11_session` @@ -2903,18 +2959,18 @@ `session_name` varchar(250) default NULL, `notebook_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FKB7C198E2FC940906` (`notebook_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FKB7C198E2FC940906` (`notebook_uid`), + CONSTRAINT `FKB7C198E2FC940906` FOREIGN KEY (`notebook_uid`) REFERENCES `tl_lantbk11_notebook` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lantbk11_session` -- - -/*!40000 ALTER TABLE `tl_lantbk11_session` DISABLE KEYS */; LOCK TABLES `tl_lantbk11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lantbk11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lantbk11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lantbk11_user` @@ -2931,18 +2987,18 @@ `notebook_session_uid` bigint(20) default NULL, `entry_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FKCB8A58FFA3B0FADF` (`notebook_session_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FKCB8A58FFA3B0FADF` (`notebook_session_uid`), + CONSTRAINT `FKCB8A58FFA3B0FADF` FOREIGN KEY (`notebook_session_uid`) REFERENCES `tl_lantbk11_session` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lantbk11_user` -- - -/*!40000 ALTER TABLE `tl_lantbk11_user` DISABLE KEYS */; LOCK TABLES `tl_lantbk11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lantbk11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lantbk11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_laqa11_content` @@ -2970,18 +3026,17 @@ `lockWhenFinished` tinyint(1) NOT NULL default '1', `showOtherAnswers` tinyint(1) NOT NULL default '1', PRIMARY KEY (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_laqa11_content` -- - -/*!40000 ALTER TABLE `tl_laqa11_content` DISABLE KEYS */; LOCK TABLES `tl_laqa11_content` WRITE; -INSERT INTO `tl_laqa11_content` VALUES (1,3,'Q&A','Instructions','2007-06-04 14:45:14',NULL,0,0,0,0,0,0,0,NULL,NULL,0,NULL,1,1); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_laqa11_content` DISABLE KEYS */; +INSERT INTO `tl_laqa11_content` VALUES (1,3,'Q&A','Instructions','2008-03-12 16:37:32',NULL,0,0,0,0,0,0,0,NULL,NULL,0,NULL,0,1); /*!40000 ALTER TABLE `tl_laqa11_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_laqa11_que_content` @@ -2997,18 +3052,17 @@ PRIMARY KEY (`uid`), KEY `qa_content_id` (`qa_content_id`), CONSTRAINT `FK_tl_laqa11_que_content_1` FOREIGN KEY (`qa_content_id`) REFERENCES `tl_laqa11_content` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_laqa11_que_content` -- - -/*!40000 ALTER TABLE `tl_laqa11_que_content` DISABLE KEYS */; LOCK TABLES `tl_laqa11_que_content` WRITE; +/*!40000 ALTER TABLE `tl_laqa11_que_content` DISABLE KEYS */; INSERT INTO `tl_laqa11_que_content` VALUES (1,'Sample Question 1?',NULL,1,1); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_laqa11_que_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_laqa11_que_usr` @@ -3032,11 +3086,10 @@ -- Dumping data for table `tl_laqa11_que_usr` -- - -/*!40000 ALTER TABLE `tl_laqa11_que_usr` DISABLE KEYS */; LOCK TABLES `tl_laqa11_que_usr` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_laqa11_que_usr` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_laqa11_que_usr` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_laqa11_session` @@ -3060,11 +3113,10 @@ -- Dumping data for table `tl_laqa11_session` -- - -/*!40000 ALTER TABLE `tl_laqa11_session` DISABLE KEYS */; LOCK TABLES `tl_laqa11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_laqa11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_laqa11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_laqa11_uploadedfile` @@ -3086,11 +3138,10 @@ -- Dumping data for table `tl_laqa11_uploadedfile` -- - -/*!40000 ALTER TABLE `tl_laqa11_uploadedfile` DISABLE KEYS */; LOCK TABLES `tl_laqa11_uploadedfile` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_laqa11_uploadedfile` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_laqa11_uploadedfile` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_laqa11_usr_resp` @@ -3117,11 +3168,10 @@ -- Dumping data for table `tl_laqa11_usr_resp` -- - -/*!40000 ALTER TABLE `tl_laqa11_usr_resp` DISABLE KEYS */; LOCK TABLES `tl_laqa11_usr_resp` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_laqa11_usr_resp` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_laqa11_usr_resp` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_attachment` @@ -3137,18 +3187,18 @@ `create_date` datetime default NULL, `resource_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK1E7009430E79035` (`resource_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK1E7009430E79035` (`resource_uid`), + CONSTRAINT `FK1E7009430E79035` FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_attachment` -- - -/*!40000 ALTER TABLE `tl_larsrc11_attachment` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_larsrc11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_larsrc11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_item_instruction` @@ -3161,19 +3211,19 @@ `sequence_id` int(11) default NULL, `item_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FKA5665013980570ED` (`item_uid`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; + KEY `FKA5665013980570ED` (`item_uid`), + CONSTRAINT `FKA5665013980570ED` FOREIGN KEY (`item_uid`) REFERENCES `tl_larsrc11_resource_item` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_item_instruction` -- - -/*!40000 ALTER TABLE `tl_larsrc11_item_instruction` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_item_instruction` WRITE; +/*!40000 ALTER TABLE `tl_larsrc11_item_instruction` DISABLE KEYS */; INSERT INTO `tl_larsrc11_item_instruction` VALUES (1,'Use Google to search the web',0,1); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_larsrc11_item_instruction` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_item_log` @@ -3189,18 +3239,19 @@ `session_id` bigint(20) default NULL, PRIMARY KEY (`uid`), KEY `FK693580A438BF8DFE` (`resource_item_uid`), - KEY `FK693580A441F9365D` (`user_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK693580A441F9365D` (`user_uid`), + CONSTRAINT `FK693580A441F9365D` FOREIGN KEY (`user_uid`) REFERENCES `tl_larsrc11_user` (`uid`), + CONSTRAINT `FK693580A438BF8DFE` FOREIGN KEY (`resource_item_uid`) REFERENCES `tl_larsrc11_resource_item` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_item_log` -- - -/*!40000 ALTER TABLE `tl_larsrc11_item_log` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_item_log` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_larsrc11_item_log` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_larsrc11_item_log` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_resource` @@ -3229,19 +3280,19 @@ `reflect_on_activity` smallint(6) default NULL, PRIMARY KEY (`uid`), UNIQUE KEY `content_id` (`content_id`), - KEY `FK89093BF758092FB` (`create_by`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; + KEY `FK89093BF758092FB` (`create_by`), + CONSTRAINT `FK89093BF758092FB` FOREIGN KEY (`create_by`) REFERENCES `tl_larsrc11_user` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_resource` -- - -/*!40000 ALTER TABLE `tl_larsrc11_resource` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_resource` WRITE; +/*!40000 ALTER TABLE `tl_larsrc11_resource` DISABLE KEYS */; INSERT INTO `tl_larsrc11_resource` VALUES (1,NULL,NULL,NULL,'Resources',0,0,'Instructions ',NULL,NULL,0,0,6,0,0,0,0,NULL,0); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_larsrc11_resource` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_resource_item` @@ -3271,19 +3322,21 @@ PRIMARY KEY (`uid`), KEY `FKF52D1F93758092FB` (`create_by`), KEY `FKF52D1F9330E79035` (`resource_uid`), - KEY `FKF52D1F93EC0D3147` (`session_uid`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; + KEY `FKF52D1F93EC0D3147` (`session_uid`), + CONSTRAINT `FKF52D1F93EC0D3147` FOREIGN KEY (`session_uid`) REFERENCES `tl_larsrc11_session` (`uid`), + CONSTRAINT `FKF52D1F9330E79035` FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`), + CONSTRAINT `FKF52D1F93758092FB` FOREIGN KEY (`create_by`) REFERENCES `tl_larsrc11_user` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_resource_item` -- - -/*!40000 ALTER TABLE `tl_larsrc11_resource_item` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_resource_item` WRITE; -INSERT INTO `tl_larsrc11_resource_item` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Web Search','http://www.google.com ',NULL,'2007-06-04 14:45:43',1,0,1,NULL,NULL,0,1,NULL); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_larsrc11_resource_item` DISABLE KEYS */; +INSERT INTO `tl_larsrc11_resource_item` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Web Search','http://www.google.com ',NULL,'2008-03-12 16:37:53',1,0,1,NULL,NULL,0,1,NULL); /*!40000 ALTER TABLE `tl_larsrc11_resource_item` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_session` @@ -3299,18 +3352,18 @@ `session_id` bigint(20) default NULL, `session_name` varchar(250) default NULL, PRIMARY KEY (`uid`), - KEY `FK24AA78C530E79035` (`resource_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK24AA78C530E79035` (`resource_uid`), + CONSTRAINT `FK24AA78C530E79035` FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_session` -- - -/*!40000 ALTER TABLE `tl_larsrc11_session` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_larsrc11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_larsrc11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_larsrc11_user` @@ -3328,18 +3381,19 @@ `resource_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), KEY `FK30113BFCEC0D3147` (`session_uid`), - KEY `FK30113BFC309ED320` (`resource_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK30113BFC309ED320` (`resource_uid`), + CONSTRAINT `FK30113BFC309ED320` FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`), + CONSTRAINT `FK30113BFCEC0D3147` FOREIGN KEY (`session_uid`) REFERENCES `tl_larsrc11_session` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_larsrc11_user` -- - -/*!40000 ALTER TABLE `tl_larsrc11_user` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_larsrc11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_larsrc11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasbmt11_content` @@ -3372,12 +3426,11 @@ -- Dumping data for table `tl_lasbmt11_content` -- - -/*!40000 ALTER TABLE `tl_lasbmt11_content` DISABLE KEYS */; LOCK TABLES `tl_lasbmt11_content` WRITE; +/*!40000 ALTER TABLE `tl_lasbmt11_content` DISABLE KEYS */; INSERT INTO `tl_lasbmt11_content` VALUES (4,'Submit Files','Instructions',0,0,NULL,NULL,0,0,NULL,0,0,1,NULL,NULL,NULL); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lasbmt11_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasbmt11_instruction_files` @@ -3400,11 +3453,10 @@ -- Dumping data for table `tl_lasbmt11_instruction_files` -- - -/*!40000 ALTER TABLE `tl_lasbmt11_instruction_files` DISABLE KEYS */; LOCK TABLES `tl_lasbmt11_instruction_files` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasbmt11_instruction_files` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasbmt11_instruction_files` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasbmt11_report` @@ -3423,11 +3475,10 @@ -- Dumping data for table `tl_lasbmt11_report` -- - -/*!40000 ALTER TABLE `tl_lasbmt11_report` DISABLE KEYS */; LOCK TABLES `tl_lasbmt11_report` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasbmt11_report` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasbmt11_report` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasbmt11_session` @@ -3448,11 +3499,10 @@ -- Dumping data for table `tl_lasbmt11_session` -- - -/*!40000 ALTER TABLE `tl_lasbmt11_session` DISABLE KEYS */; LOCK TABLES `tl_lasbmt11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasbmt11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasbmt11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasbmt11_submission_details` @@ -3479,11 +3529,10 @@ -- Dumping data for table `tl_lasbmt11_submission_details` -- - -/*!40000 ALTER TABLE `tl_lasbmt11_submission_details` DISABLE KEYS */; LOCK TABLES `tl_lasbmt11_submission_details` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasbmt11_submission_details` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasbmt11_submission_details` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasbmt11_user` @@ -3506,11 +3555,10 @@ -- Dumping data for table `tl_lasbmt11_user` -- - -/*!40000 ALTER TABLE `tl_lasbmt11_user` DISABLE KEYS */; LOCK TABLES `tl_lasbmt11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasbmt11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasbmt11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lascrb11_attachment` @@ -3526,18 +3574,18 @@ `create_date` datetime default NULL, `scribe_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK57953706B3FA1495` (`scribe_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK57953706B3FA1495` (`scribe_uid`), + CONSTRAINT `FK57953706B3FA1495` FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lascrb11_attachment` -- - -/*!40000 ALTER TABLE `tl_lascrb11_attachment` DISABLE KEYS */; LOCK TABLES `tl_lascrb11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lascrb11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lascrb11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lascrb11_heading` @@ -3550,19 +3598,19 @@ `scribe_uid` bigint(20) default NULL, `display_order` int(11) default NULL, PRIMARY KEY (`uid`), - KEY `FK428A22FFB3FA1495` (`scribe_uid`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; + KEY `FK428A22FFB3FA1495` (`scribe_uid`), + CONSTRAINT `FK428A22FFB3FA1495` FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lascrb11_heading` -- - -/*!40000 ALTER TABLE `tl_lascrb11_heading` DISABLE KEYS */; LOCK TABLES `tl_lascrb11_heading` WRITE; +/*!40000 ALTER TABLE `tl_lascrb11_heading` DISABLE KEYS */; INSERT INTO `tl_lascrb11_heading` VALUES (1,'Scribe Heading',1,0); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lascrb11_heading` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lascrb11_report_entry` @@ -3576,18 +3624,19 @@ `scribe_session_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), KEY `FK5439FACAEA50D086` (`scribe_heading_uid`), - KEY `FK5439FACA1C266FAE` (`scribe_session_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK5439FACA1C266FAE` (`scribe_session_uid`), + CONSTRAINT `FK5439FACA1C266FAE` FOREIGN KEY (`scribe_session_uid`) REFERENCES `tl_lascrb11_session` (`uid`), + CONSTRAINT `FK5439FACAEA50D086` FOREIGN KEY (`scribe_heading_uid`) REFERENCES `tl_lascrb11_heading` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lascrb11_report_entry` -- - -/*!40000 ALTER TABLE `tl_lascrb11_report_entry` DISABLE KEYS */; LOCK TABLES `tl_lascrb11_report_entry` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lascrb11_report_entry` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lascrb11_report_entry` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lascrb11_scribe` @@ -3611,19 +3660,19 @@ `content_in_use` bit(1) default NULL, `define_later` bit(1) default NULL, `tool_content_id` bigint(20) default NULL, + `aggregated_reports` bit(1) default '\0', PRIMARY KEY (`uid`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lascrb11_scribe` -- - -/*!40000 ALTER TABLE `tl_lascrb11_scribe` DISABLE KEYS */; LOCK TABLES `tl_lascrb11_scribe` WRITE; -INSERT INTO `tl_lascrb11_scribe` VALUES (1,NULL,NULL,NULL,'Scribe','Instructions','\0','','','\0',NULL,'','','\0','\0',10); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lascrb11_scribe` DISABLE KEYS */; +INSERT INTO `tl_lascrb11_scribe` VALUES (1,NULL,NULL,NULL,'Scribe','Instructions','\0','','','\0',NULL,'','','\0','\0',10,'\0'); /*!40000 ALTER TABLE `tl_lascrb11_scribe` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lascrb11_session` @@ -3644,18 +3693,19 @@ `report_submitted` bit(1) default NULL, PRIMARY KEY (`uid`), KEY `FK89732793B3FA1495` (`scribe_uid`), - KEY `FK89732793E46919FF` (`appointed_scribe_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK89732793E46919FF` (`appointed_scribe_uid`), + CONSTRAINT `FK89732793E46919FF` FOREIGN KEY (`appointed_scribe_uid`) REFERENCES `tl_lascrb11_user` (`uid`), + CONSTRAINT `FK89732793B3FA1495` FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lascrb11_session` -- - -/*!40000 ALTER TABLE `tl_lascrb11_session` DISABLE KEYS */; LOCK TABLES `tl_lascrb11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lascrb11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lascrb11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lascrb11_user` @@ -3673,18 +3723,18 @@ `report_approved` bit(1) default NULL, `started_activity` bit(1) default NULL, PRIMARY KEY (`uid`), - KEY `FK187DAFEE1C266FAE` (`scribe_session_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK187DAFEE1C266FAE` (`scribe_session_uid`), + CONSTRAINT `FK187DAFEE1C266FAE` FOREIGN KEY (`scribe_session_uid`) REFERENCES `tl_lascrb11_session` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lascrb11_user` -- - -/*!40000 ALTER TABLE `tl_lascrb11_user` DISABLE KEYS */; LOCK TABLES `tl_lascrb11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lascrb11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lascrb11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_answer` @@ -3700,18 +3750,19 @@ `answer_text` text, PRIMARY KEY (`uid`), KEY `FK6DAAFE3BB1423DC1` (`user_uid`), - KEY `FK6DAAFE3B25F3BB77` (`question_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK6DAAFE3B25F3BB77` (`question_uid`), + CONSTRAINT `FK6DAAFE3B25F3BB77` FOREIGN KEY (`question_uid`) REFERENCES `tl_lasurv11_question` (`uid`), + CONSTRAINT `FK6DAAFE3BB1423DC1` FOREIGN KEY (`user_uid`) REFERENCES `tl_lasurv11_user` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_answer` -- - -/*!40000 ALTER TABLE `tl_lasurv11_answer` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_answer` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasurv11_answer` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasurv11_answer` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_attachment` @@ -3727,18 +3778,18 @@ `create_date` datetime default NULL, `survey_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FKD92A9120D14146E5` (`survey_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FKD92A9120D14146E5` (`survey_uid`), + CONSTRAINT `FKD92A9120D14146E5` FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_attachment` -- - -/*!40000 ALTER TABLE `tl_lasurv11_attachment` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_attachment` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasurv11_attachment` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasurv11_attachment` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_option` @@ -3751,19 +3802,19 @@ `sequence_id` int(11) default NULL, `question_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK85AB46F26966134F` (`question_uid`) -) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; + KEY `FK85AB46F26966134F` (`question_uid`), + CONSTRAINT `FK85AB46F26966134F` FOREIGN KEY (`question_uid`) REFERENCES `tl_lasurv11_question` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_option` -- - -/*!40000 ALTER TABLE `tl_lasurv11_option` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_option` WRITE; +/*!40000 ALTER TABLE `tl_lasurv11_option` DISABLE KEYS */; INSERT INTO `tl_lasurv11_option` VALUES (1,'Option 1',0,1),(2,'Option 2',1,1),(3,'Option 3',2,1),(4,'Option 1',0,2),(5,'Option 2',1,2),(6,'Option 3',2,2); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lasurv11_option` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_question` @@ -3783,19 +3834,20 @@ `survey_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), KEY `FK872D4F23D14146E5` (`survey_uid`), - KEY `FK872D4F23E4C99A5F` (`create_by`) -) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; + KEY `FK872D4F23E4C99A5F` (`create_by`), + CONSTRAINT `FK872D4F23E4C99A5F` FOREIGN KEY (`create_by`) REFERENCES `tl_lasurv11_user` (`uid`), + CONSTRAINT `FK872D4F23D14146E5` FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_question` -- - -/*!40000 ALTER TABLE `tl_lasurv11_question` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_question` WRITE; -INSERT INTO `tl_lasurv11_question` VALUES (1,1,'Sample Multiple choice - only one response allowed?',NULL,'2007-06-04 14:46:08',1,0,0,0,1),(2,2,'Sample Multiple choice - multiple response allowed?',NULL,'2007-06-04 14:46:08',2,0,0,1,1),(3,3,'Sample Free text question?',NULL,'2007-06-04 14:46:08',3,0,0,0,1); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasurv11_question` DISABLE KEYS */; +INSERT INTO `tl_lasurv11_question` VALUES (1,1,'Sample Multiple choice - only one response allowed?',NULL,'2008-03-12 16:38:10',1,0,0,0,1),(2,2,'Sample Multiple choice - multiple response allowed?',NULL,'2008-03-12 16:38:10',2,0,0,1,1),(3,3,'Sample Free text question?',NULL,'2008-03-12 16:38:10',3,0,0,0,1); /*!40000 ALTER TABLE `tl_lasurv11_question` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_session` @@ -3810,18 +3862,18 @@ `session_id` bigint(20) default NULL, `session_name` varchar(250) default NULL, PRIMARY KEY (`uid`), - KEY `FKF08793B9D14146E5` (`survey_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FKF08793B9D14146E5` (`survey_uid`), + CONSTRAINT `FKF08793B9D14146E5` FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_session` -- - -/*!40000 ALTER TABLE `tl_lasurv11_session` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasurv11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasurv11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_survey` @@ -3847,19 +3899,19 @@ `create_by` bigint(20) default NULL, PRIMARY KEY (`uid`), UNIQUE KEY `content_id` (`content_id`), - KEY `FK8CC465D7E4C99A5F` (`create_by`) -) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; + KEY `FK8CC465D7E4C99A5F` (`create_by`), + CONSTRAINT `FK8CC465D7E4C99A5F` FOREIGN KEY (`create_by`) REFERENCES `tl_lasurv11_user` (`uid`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_survey` -- - -/*!40000 ALTER TABLE `tl_lasurv11_survey` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_survey` WRITE; +/*!40000 ALTER TABLE `tl_lasurv11_survey` DISABLE KEYS */; INSERT INTO `tl_lasurv11_survey` VALUES (1,'Survey',0,1,'Instructions',NULL,NULL,0,0,9,NULL,0,1,NULL,NULL,NULL); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lasurv11_survey` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lasurv11_user` @@ -3877,18 +3929,19 @@ `session_finished` smallint(6) default NULL, PRIMARY KEY (`uid`), KEY `FK633F25884F803F63` (`session_uid`), - KEY `FK633F2588D14146E5` (`survey_uid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `FK633F2588D14146E5` (`survey_uid`), + CONSTRAINT `FK633F2588D14146E5` FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`), + CONSTRAINT `FK633F25884F803F63` FOREIGN KEY (`session_uid`) REFERENCES `tl_lasurv11_session` (`uid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lasurv11_user` -- - -/*!40000 ALTER TABLE `tl_lasurv11_user` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_user` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lasurv11_user` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lasurv11_user` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lavote11_content` @@ -3915,18 +3968,17 @@ `retries` tinyint(1) NOT NULL default '0', `reflectionSubject` text, PRIMARY KEY (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lavote11_content` -- - -/*!40000 ALTER TABLE `tl_lavote11_content` DISABLE KEYS */; LOCK TABLES `tl_lavote11_content` WRITE; -INSERT INTO `tl_lavote11_content` VALUES (1,7,'Voting','Instructions','2007-06-04 14:45:48',NULL,'1',0,0,1,0,0,'','',0,1,0,NULL); -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lavote11_content` DISABLE KEYS */; +INSERT INTO `tl_lavote11_content` VALUES (1,7,'Voting','Instructions','2008-03-12 16:37:57',NULL,'1',0,0,1,0,0,'','',0,0,0,NULL); /*!40000 ALTER TABLE `tl_lavote11_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lavote11_nomination_content` @@ -3941,18 +3993,17 @@ PRIMARY KEY (`uid`), KEY `vote_content_id` (`vote_content_id`), CONSTRAINT `FK_tl_lavote11_nomination_content_1` FOREIGN KEY (`vote_content_id`) REFERENCES `tl_lavote11_content` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lavote11_nomination_content` -- - -/*!40000 ALTER TABLE `tl_lavote11_nomination_content` DISABLE KEYS */; LOCK TABLES `tl_lavote11_nomination_content` WRITE; +/*!40000 ALTER TABLE `tl_lavote11_nomination_content` DISABLE KEYS */; INSERT INTO `tl_lavote11_nomination_content` VALUES (1,'Sample Nomination 1',1,1),(2,'Sample Nomination 2',2,1); -UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lavote11_nomination_content` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lavote11_session` @@ -3977,11 +4028,10 @@ -- Dumping data for table `tl_lavote11_session` -- - -/*!40000 ALTER TABLE `tl_lavote11_session` DISABLE KEYS */; LOCK TABLES `tl_lavote11_session` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lavote11_session` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lavote11_session` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lavote11_uploadedfile` @@ -4003,11 +4053,10 @@ -- Dumping data for table `tl_lavote11_uploadedfile` -- - -/*!40000 ALTER TABLE `tl_lavote11_uploadedfile` DISABLE KEYS */; LOCK TABLES `tl_lavote11_uploadedfile` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lavote11_uploadedfile` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lavote11_uploadedfile` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lavote11_usr` @@ -4031,11 +4080,10 @@ -- Dumping data for table `tl_lavote11_usr` -- - -/*!40000 ALTER TABLE `tl_lavote11_usr` DISABLE KEYS */; LOCK TABLES `tl_lavote11_usr` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lavote11_usr` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lavote11_usr` ENABLE KEYS */; +UNLOCK TABLES; -- -- Table structure for table `tl_lavote11_usr_attempt` @@ -4062,11 +4110,10 @@ -- Dumping data for table `tl_lavote11_usr_attempt` -- - -/*!40000 ALTER TABLE `tl_lavote11_usr_attempt` DISABLE KEYS */; LOCK TABLES `tl_lavote11_usr_attempt` WRITE; -UNLOCK TABLES; +/*!40000 ALTER TABLE `tl_lavote11_usr_attempt` DISABLE KEYS */; /*!40000 ALTER TABLE `tl_lavote11_usr_attempt` ENABLE KEYS */; +UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; @@ -4077,3 +4124,4 @@ /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; +-- Dump completed on 2008-03-12 5:50:10 Index: unix_installer/installer-package/install-lams.sh =================================================================== diff -u -r4998bf8aaf66a1c8a2388865732c396c855bbd5e -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/install-lams.sh (.../install-lams.sh) (revision 4998bf8aaf66a1c8a2388865732c396c855bbd5e) +++ unix_installer/installer-package/install-lams.sh (.../install-lams.sh) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,428 +1,446 @@ -#!/bin/sh -# Copyright (C) 2006-2007 LAMS Foundation (http://lamsfoundation.org) -# License Information: http://lamsfoundation.org/licensing/lams/2.0/ -# -# This program is free software; you can redistribute it and/or modify -# it under the terms of the GNU General Public License version 2.0 -# as published by the Free Software Foundation. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program; if not, write to the Free Software -# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 -# USA -# -# http://www.gnu.org/licenses/gpl.txt -# -# Author: Luke Foxton - -# Installer shell script for LAMS 2.0.4 - -# Usage: sudo ./install.sh - -LAMS_VERSION=2.0.4 -MYSQL_VERSION_STR=5. -JAVA_REQ_VERSION=1.5 -# Transform the required version string into a number that can be used in comparisons -JAVA_REQ_VERSION=`echo $JAVA_REQ_VERSION | sed -e 's;\.;0;g'` - -# getting all the lams.properties variables into the variable space -. ./lams.properties - -wrapper="" - -# invoked when the install is failed -installfailed() -{ - echo "" - export JAVA_HOME=$ORIG_JAVA_HOME - exit 1 -} - -# Invoked when the install is exited -installexit() -{ - echo "" - export JAVA_HOME=$ORIG_JAVA_HOME - exit 0 -} - -checkJava() -{ - ORIG_JAVA_HOME=$JAVA_HOME - export JAVA_HOME=$JDK_DIR - JAVA_EXE=$JAVA_HOME/bin/java - - java -cp bin testJava - if [ "$?" -ne "0" ] - then - echo "Install failed. Could not verify java installation, check your lams.properties file for the correct JDK_DIR entry, and that you have set your JAVA_HOME and PATH environment variables correctly." - echo "Refer to the readme for help with setting up java for LAMS." - installfailed - fi - - # Check JAVA_HOME directory to see if Java version is adequate - if [ $JAVA_HOME ] - then - JAVA_EXE=$JAVA_HOME/bin/java - $JAVA_EXE -version 2> tmp.ver - VERSION=`cat tmp.ver | grep "java version" | awk '{ print substr($3, 2, length($3)-2); }'` - rm tmp.ver - VERSION=`echo $VERSION | awk '{ print substr($1, 1, 3); }' | sed -e 's;\.;0;g'` - if [ $VERSION ] - then - if [ $VERSION -ge $JAVA_REQ_VERSION ] - then - JAVA_HOME=`echo $JAVA_EXE | awk '{ print substr($1, 1, length($1)-9); }'` - else - JAVA_HOME= - fi - else - JAVA_HOME= - fi - fi - - # If the existing JAVA_HOME directory is adequate, then leave it alone - # otherwise, use 'locate' to search for other possible java candidates and - # check their versions. - if [ $JAVA_HOME ] - then - : - else - for JAVA_EXE in `locate bin/java | grep java$ | xargs echo` - do - if [ $JAVA_HOME ] - then - : - else - $JAVA_EXE -version 2> tmp.ver 1> /dev/null - VERSION=`cat tmp.ver | grep "java version" | awk '{ print substr($3, 2, length($3)-2); }'` - rm tmp.ver - VERSION=`echo $VERSION | awk '{ print substr($1, 1, 3); }' | sed -e 's;\.;0;g'` - if [ $VERSION ] - then - if [ $VERSION -ge $JAVA_REQ_VERSION ] - then - JAVA_HOME=`echo $JAVA_EXE | awk '{ print substr($1, 1, length($1)-9); }'` - fi - fi - fi - done - fi - - # If the correct Java version is detected, then export the JAVA_HOME environment variable - if [ $JAVA_HOME ] - then - export JAVA_HOME - else - echo "No installation of java found, please set your JAVA_HOME to point to java 1.5 or newer, then run the installer." - installexit - fi -} - -checkMysql() -{ - if [ $SQL_HOST = localhost ] - then - - $JDK_DIR/bin/java -cp .:bin/:assembly/lams.ear/mysql-connector-java-3.1.12-bin.jar checkmysql "$MYSQL_DB_URL" "root" "$DB_ROOT_PASSWORD" "$MYSQL_VERSION_STR" - if [ "$?" -ne "0" ] - then - printf "\nInstall Failed. MySql check did not pass. Please check that your DB_ROOT_PASSWORD in lams.properties is set to the root password of your MySql 5.x server\n\n" - installfailed - fi - fi -} - -createDatabase() -{ - if [ $SQL_HOST = localhost ] - then - printf "\nCreating LAMS database.\n" - - ant/bin/ant -buildfile ant-scripts/configure-database.xml -logfile log/create-database.log create-database - if [ "$?" -ne "0" ] - then - echo "Install failed. Error creating the LAMS database. Check your MySql settings and try again." - installfailed - fi - printf "Database Created.\n \n" - fi - - printf "Filling database with LAMS tables\n\n" - ant/bin/ant -buildfile ant-scripts/filter-config.xml -logfile log/filter-config.log filter-config - if [ "$?" -ne "0" ] - then - echo "Install failed. Error generating setLamsConfiguration.sql. Please check log/filter-config for errors.\n\n" - installfailed - fi - - - ant/bin/ant -buildfile ant-scripts/configure-database.xml -logfile log/fill-database.log fill-database - if [ "$?" -ne "0" ] - then - printf "\nInstall failed. Could not fill the LAMS database. If you are installing with a remote MySql server, please check that your SQL_HOST in lams.properties points to a MySql 5.x installation and that you have created a database with the name DB_NAME as in lams.properties and that the DB_USER has remote access granted. Check the readme for instructions on how to do this.\n\n" - installfailed - fi - print "Done.\n\n" - -} - -chooseWrapper() -{ - isMac=`uname -a | grep Mac` - if [ "$isMac" ] - then - printf "\nIt looks like you have a Macintosh. We can't install the wrapper automatically for Macs. If you want to use the wrapper, you will need to install it manually. \nSee http://wiki.lamsfoundation.org/display/lamsdocs/Setup+Java+Service+Wrapper+for+LAMS.\n\nPress enter to continue with installation." - read temp - else - isMac=`uname -a | grep Darwin` - if [ "$isMac" ] - then - printf "\nIt looks like you have a Macintosh. We can't install the wrapper automatically for Macs. If you want to use the wrapper, you will need to install it manually. \nSee http://wiki.lamsfoundation.org/display/lamsdocs/Setup+Java+Service+Wrapper+for+LAMS.\n\nPress enter to continue with installation." - read temp - else - arch=`uname -m` - if [ $arch = i386 ] - then - wrapper=wrapper-linux-x86-32-3.2.3 - fi - - if [ $arch = "ia64" ] || [ $arch = "IA64" ] - then - wrapper=wrapper-linux-x86-64-3.2.3 - fi - - if [ $arch = "ppc" ]|| [ $arch = "PPC" ] - then - wrapper=wrapper-linux-ppc-64-3.2.3 - fi - - if [ $wrapper ] - then - printf "\nThe installer has detected that you need this wrapper: $wrapper\n" - printf "If you wish to use one of the others please select it instead.\n" - else - printf "\nThe installer could not detect a suitable wrapper, please select one from below.\n" - fi - printf "(1) wrapper-linux-x86-32-3.2.3\n" - printf "(2) wrapper-linux-x86-64-3.2.3\n" - printf "(3) wrapper-linux-ppc-64-3.2.3\n" - printf "(n) No wrapper, continue with install\n" - printf "(q) quit\n" - printf "> " - input="" - read input - - case "$input" in - 1) - wrapper=wrapper-linux-x86-32-3.2.3 - ;; - 2) - wrapper=wrapper-linux-x86-64-3.2.3 - ;; - 3) - wrapper=wrapper-linux-ppc-64-3.2.3 - ;; - q) - printf "\n\nBye!\n\n" - installexit - ;; - n) - wrapper="" - ;; - *) - printf "\nPlease type 1, 2, 3, n or q and press enter.\n" - chooseWrapper - ;; - esac - - fi - fi -} - - - -installWrapper() -{ - printf "\nDo you wish to install LAMS as a Java Service Wrapper? (y)es, (n)o, (q)uit: " - input="" - read input - - case "$input" in - q) - printf "\n\nBye!\n\n" - installexit - ;; - y) - chooseWrapper - ;; - n) - ;; - *) - printf "\nPlease enter y, n or q.\n" - installWrapper - ;; - esac -} - -configureWrapper() -{ - if [ $wrapper ] - then - printf "\n\nInstalling and configuring Java Service Wrapper: $wrapper\n" - cp "wrapper/$wrapper/bin/wrapper" "$JBOSS_DIR/bin" - cp "wrapper/sh.script.in" "$JBOSS_DIR/bin/lams2" - - cp "wrapper/$wrapper/lib/libwrapper.so" "wrapper/$wrapper/lib/wrapper.jar" "$JBOSS_DIR/lib" - #cp "wrapper/wrapper.conf.in" "$JBOSS_DIR/conf/wrapper.conf" - ant/bin/ant -buildfile ant-scripts/configure-deploy.xml -logfile log/configure-wrapper.log configure-wrapper - if [ "$?" -ne "0" ] - then - echo "\nInstall Failed. Problem while configuring wrapper. Please configure-wrapper.log for details.\n\n" - installfailed - fi - - - if [ -f "$JBOSS_DIR/logs/" ] - then - printf " " - else - mkdir "$JBOSS_DIR/logs/" - fi - cp wrapper/run.sh "$JBOSS_DIR/bin" - - if [ -f /etc/init.d/lams2 ] - then - rm /etc/init.d/lams2 - fi - ln -s "$JBOSS_DIR/bin/lams2" /etc/init.d/lams2 - printf "Done.\n\n" - fi -} - -checkJboss() -{ - if [ -f "$JBOSS_DIR/lib/jboss-common.jar" ] - then - echo "JBoss Directory Found" - else - printf "\n\nInstall Failed. No installation of JBoss-4.0.2 was found at $JBOSS_DIR. Please check your lams.properties file and retry.\n\n" - installfailed - fi -} - -checkJava -checkMysql -checkJboss - -clear -printf "\n--------------------------------------------------------------------------------\n\n" -printf "WELCOME to the LAMS $LAMS_VERSION unix Installer! \n\n" -printf "Please ensure you have read and accepted the license agreement before continuing\n\n" -printf "Make sure you have correctly configured the lams.properties file to your \n" -printf "preferred settings.\n\n" -printf "You should read the installation guide before continuing.\n" -printf "\nJAVA_HOME = $JAVA_HOME\n" -printf "\n--------------------------------------------------------------------------------\n\n" - -if [ $SQL_HOST != localhost ] -then - printf "You are installing LAMS with a remote MySQL server. You MUST first create the \nLAMS database and user with remote privileges before continuing. Refer to the\nreadme chapter 'Setting up MySql on a Different Server' for instructions on how\nto do this.\n\nDo you wish to Continue? (y)es or (n)o: " - continue="" - read continue - case "$continue" in - y) - printf "\n" - ;; - n) - printf "\nBye!\n\n" - installexit - ;; - *) printf "\n\n" - installfailed - ;; - esac -fi - -printf "LAMS requires about 117MB of space, continue with installation? (y)es, (n)o: " -continue="" -read continue -case "$continue" in -y) - ;; -n) printf "\nBye!\n\n" - installexit - ;; -*) printf "\n\n" - installfailed - ;; -esac - -# Choosing whether to install the wrapper -installWrapper - - -printf "\nUsing LAMS database with the following parameters...\n" -printf "Database name: $DB_NAME\n" -printf "Database user: $DB_USER\n" -printf "Database password: $DB_PASS\n" -createDatabase -printf "\nDatabase Created.\n\n" - -# Copying the main lams files -printf "Copying lams.ear directory to ${DEFAULT_DIR}/deploy.\n" -cp -rv assembly/lams.ear ${DEFAULT_DIR}/deploy - -printf "\nDone.\n\n" -if [ "$?" -ne "0" ] - then - echo "Install Failed. Problem while copying the jboss-4.0.2 directory, please try again." - installfailed -fi - -# UNCOMMENT FOR (2.1) Create news-unmodified.html and place it with news.html such that the upgrader can do a -# diff between the two files to determine whether it should update news.html or not. -# cp assembly/lams.ear/lams-www.war/news.html ${DEFAULT_DIR}/deploy/lams.ear/lams-www.war/news-unmodified.html - -# Configuring jboss with settings from lams.properties -printf "Configuring JBoss with your settings.\n" -ant/bin/ant -buildfile ant-scripts/configure-deploy.xml -logfile log/copy-conf.log copy-conf -if [ "$?" -ne "0" ] - then - echo "Install Failed. Problem while copying the jboss-4.0.2 configuration files, check log/configure-deploy.log for details." - installfailed -fi - -chmod 755 $JBOSS_DIR/bin/run-lams.sh - -# configure the wrapper -printf "\nConfiguring the java Wrapper\n" -configureWrapper - -# configure jboss -mkdir ${DEFAULT_DIR}/lib -cp $JBOSS_DIR/server/all/lib/jgroups.jar $JBOSS_DIR/server/all/lib/jboss-cache.jar ${DEFAULT_DIR}/lib -cp assembly/lams-session.jar assembly/lams-valve.jar ${DEFAULT_DIR}/lib -if [ "$?" -ne "0" ] - then - echo "\nInstall Failed. Problem while configuring JBoss, please ensure you have the correct version of JBoss (4.0.2).\n\n" - installfailed -fi - - -printf "Copying lams.properties to /etc.\n" -mkdir -p /etc/lams2 -cp lams.properties /etc/lams2/ - -# changing JAVA_HOME back -export JAVA_HOME=$ORIG_JAVA_HOME - -printf "\n\nLAMS $LAMS_VERSION Configuration completed!\n" -printf "Please view the README for instructions on how to run LAMS.\n\n" - - +#!/bin/sh +# Copyright (C) 2006-2008 LAMS Foundation (http://lamsfoundation.org) +# License Information: http://lamsfoundation.org/licensing/lams/2.0/ +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License version 2.0 +# as published by the Free Software Foundation. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 +# USA +# +# http://www.gnu.org/licenses/gpl.txt +# +# Author: Luke Foxton + +# Installer shell script for LAMS + +# Usage: sudo ./install.sh + +LAMS_VERSION=2.1-RC1 +MYSQL_VERSION_STR=5. +JAVA_REQ_VERSION=1.5 +# Transform the required version string into a number that can be used in comparisons +JAVA_REQ_VERSION=`echo $JAVA_REQ_VERSION | sed -e 's;\.;0;g'` + +# getting all the lams.properties variables into the variable space +. ./lams.properties + +wrapper="" + +# invoked when the install is failed +installfailed() +{ + echo "" + export JAVA_HOME=$ORIG_JAVA_HOME + exit 1 +} + +# Invoked when the install is exited +installexit() +{ + echo "" + export JAVA_HOME=$ORIG_JAVA_HOME + exit 0 +} + +checkJava() +{ + ORIG_JAVA_HOME=$JAVA_HOME + export JAVA_HOME=$JDK_DIR + JAVA_EXE=$JAVA_HOME/bin/java + + $JAVA_HOME/bin/java -cp bin testJava + if [ "$?" -ne "0" ] + then + echo "Install failed. Could not verify java installation, check your lams.properties file for the correct JDK_DIR entry, and that you have set your JAVA_HOME and PATH environment variables correctly." + echo "Refer to the readme for help with setting up java for LAMS." + installfailed + fi + + # Check JAVA_HOME directory to see if Java version is adequate + if [ $JAVA_HOME ] + then + JAVA_EXE=$JAVA_HOME/bin/java + $JAVA_EXE -version 2> tmp.ver + VERSION=`cat tmp.ver | grep "java version" | awk '{ print substr($3, 2, length($3)-2); }'` + rm tmp.ver + VERSION=`echo $VERSION | awk '{ print substr($1, 1, 3); }' | sed -e 's;\.;0;g'` + if [ $VERSION ] + then + if [ $VERSION -ge $JAVA_REQ_VERSION ] + then + JAVA_HOME=`echo $JAVA_EXE | awk '{ print substr($1, 1, length($1)-9); }'` + else + JAVA_HOME= + fi + else + JAVA_HOME= + fi + fi + + # If the existing JAVA_HOME directory is adequate, then leave it alone + # otherwise, use 'locate' to search for other possible java candidates and + # check their versions. + if [ $JAVA_HOME ] + then + : + else + for JAVA_EXE in `locate bin/java | grep java$ | xargs echo` + do + if [ $JAVA_HOME ] + then + : + else + $JAVA_EXE -version 2> tmp.ver 1> /dev/null + VERSION=`cat tmp.ver | grep "java version" | awk '{ print substr($3, 2, length($3)-2); }'` + rm tmp.ver + VERSION=`echo $VERSION | awk '{ print substr($1, 1, 3); }' | sed -e 's;\.;0;g'` + if [ $VERSION ] + then + if [ $VERSION -ge $JAVA_REQ_VERSION ] + then + JAVA_HOME=`echo $JAVA_EXE | awk '{ print substr($1, 1, length($1)-9); }'` + fi + fi + fi + done + fi + + # If the correct Java version is detected, then export the JAVA_HOME environment variable + if [ $JAVA_HOME ] + then + export JAVA_HOME + else + echo "No installation of java found, please set your JAVA_HOME to point to java 1.5 or newer, then run the installer." + installexit + fi +} + +checkMysql() +{ + if [ $SQL_HOST = localhost ] + then + + $JDK_DIR/bin/java -cp .:bin/:assembly/lams.ear/mysql-connector-java-3.1.12-bin.jar checkmysql "$MYSQL_DB_URL" "root" "$DB_ROOT_PASSWORD" "$MYSQL_VERSION_STR" + if [ "$?" -ne "0" ] + then + printf "\nInstall Failed. MySql check did not pass. Please check that your DB_ROOT_PASSWORD in lams.properties is set to the root password of your MySql 5.x server\n\n" + installfailed + fi + fi +} + +createDatabase() +{ + if [ $SQL_HOST = localhost ] + then + printf "\nCreating LAMS database.\n" + + ant/bin/ant -buildfile ant-scripts/configure-database.xml -logfile log/create-database.log create-database + if [ "$?" -ne "0" ] + then + echo "Install failed. Error creating the LAMS database. Check your MySql settings and try again." + installfailed + fi + printf "Database Created.\n \n" + fi + + printf "Filling database with LAMS tables\n\n" + ant/bin/ant -buildfile ant-scripts/filter-config.xml -logfile log/filter-config.log filter-config + if [ "$?" -ne "0" ] + then + echo "Install failed. Error generating setLamsConfiguration.sql. Please check log/filter-config for errors.\n\n" + installfailed + fi + + + ant/bin/ant -buildfile ant-scripts/configure-database.xml -logfile log/fill-database.log fill-database + if [ "$?" -ne "0" ] + then + printf "\nInstall failed. Could not fill the LAMS database. If you are installing with a remote MySql server, please check that your SQL_HOST in lams.properties points to a MySql 5.x installation and that you have created a database with the name DB_NAME as in lams.properties and that the DB_USER has remote access granted. Check the readme for instructions on how to do this.\n\n" + installfailed + fi + printf "Done.\n\n" + +} + +chooseWrapper() +{ + isMac=`uname -a | grep Mac` + if [ "$isMac" ] + then + printf "\nIt looks like you have a Macintosh. We can't install the wrapper automatically for Macs. If you want to use the wrapper, you will need to install it manually. \nSee http://wiki.lamsfoundation.org/display/lamsdocs/Setup+Java+Service+Wrapper+for+LAMS.\n\nPress enter to continue with installation." + read temp + else + isMac=`uname -a | grep Darwin` + if [ "$isMac" ] + then + printf "\nIt looks like you have a Macintosh. We can't install the wrapper automatically for Macs. If you want to use the wrapper, you will need to install it manually. \nSee http://wiki.lamsfoundation.org/display/lamsdocs/Setup+Java+Service+Wrapper+for+LAMS.\n\nPress enter to continue with installation." + read temp + else + arch=`uname -m` + if [ $arch = i386 ] + then + wrapper=wrapper-linux-x86-32-3.2.3 + fi + + if [ $arch = "ia64" ] || [ $arch = "IA64" ] + then + wrapper=wrapper-linux-x86-64-3.2.3 + fi + + if [ $arch = "ppc" ]|| [ $arch = "PPC" ] + then + wrapper=wrapper-linux-ppc-64-3.2.3 + fi + + if [ $wrapper ] + then + printf "\nThe installer has detected that you need this wrapper: $wrapper\n" + printf "If you wish to use one of the others please select it instead.\n" + else + printf "\nThe installer could not detect a suitable wrapper, please select one from below.\n" + fi + printf "(1) wrapper-linux-x86-32-3.2.3\n" + printf "(2) wrapper-linux-x86-64-3.2.3\n" + printf "(3) wrapper-linux-ppc-64-3.2.3\n" + printf "(n) No wrapper, continue with install\n" + printf "(q) quit\n" + printf "> " + input="" + read input + + case "$input" in + 1) + wrapper=wrapper-linux-x86-32-3.2.3 + ;; + 2) + wrapper=wrapper-linux-x86-64-3.2.3 + ;; + 3) + wrapper=wrapper-linux-ppc-64-3.2.3 + ;; + q) + printf "\n\nBye!\n\n" + installexit + ;; + n) + wrapper="" + ;; + *) + printf "\nPlease type 1, 2, 3, n or q and press enter.\n" + chooseWrapper + ;; + esac + + fi + fi +} + + + +installWrapper() +{ + printf "\nDo you wish to install LAMS as a Java Service Wrapper? (y)es, (n)o, (q)uit: " + input="" + read input + + case "$input" in + q) + printf "\n\nBye!\n\n" + installexit + ;; + y) + chooseWrapper + ;; + n) + ;; + *) + printf "\nPlease enter y, n or q.\n" + installWrapper + ;; + esac +} + +configureWrapper() +{ + if [ $wrapper ] + then + printf "\n\nInstalling and configuring Java Service Wrapper: $wrapper\n" + cp "wrapper/$wrapper/bin/wrapper" "$JBOSS_DIR/bin" + cp "wrapper/sh.script.in" "$JBOSS_DIR/bin/lams2" + + cp "wrapper/$wrapper/lib/libwrapper.so" "wrapper/$wrapper/lib/wrapper.jar" "$JBOSS_DIR/lib" + #cp "wrapper/wrapper.conf.in" "$JBOSS_DIR/conf/wrapper.conf" + ant/bin/ant -buildfile ant-scripts/configure-deploy.xml -logfile log/configure-wrapper.log configure-wrapper + if [ "$?" -ne "0" ] + then + echo "\nInstall Failed. Problem while configuring wrapper. Please configure-wrapper.log for details.\n\n" + installfailed + fi + + + if [ -f "$JBOSS_DIR/logs/" ] + then + printf " " + else + mkdir "$JBOSS_DIR/logs/" + fi + cp wrapper/run.sh "$JBOSS_DIR/bin" + + if [ -f /etc/init.d/lams2 ] + then + rm /etc/init.d/lams2 + fi + ln -s "$JBOSS_DIR/bin/lams2" /etc/init.d/lams2 + printf "Done.\n\n" + fi +} + +checkJboss() +{ + if [ -f "$JBOSS_DIR/lib/jboss-common.jar" ] + then + echo "JBoss Directory Found" + else + printf "\n\nInstall Failed. No installation of JBoss-4.0.2 was found at $JBOSS_DIR. Please check your lams.properties file and retry.\n\n" + installfailed + fi +} + +checkJava +checkMysql +checkJboss + +clear +printf "\n--------------------------------------------------------------------------------\n\n" +printf "WELCOME to the LAMS $LAMS_VERSION unix Installer! \n\n" +printf "Please ensure you have read and accepted the license agreement before continuing\n\n" +printf "Make sure you have correctly configured the lams.properties file to your \n" +printf "preferred settings.\n\n" +printf "You should read the installation guide before continuing.\n" +printf "\nJAVA_HOME = $JAVA_HOME\n" +printf "\n--------------------------------------------------------------------------------\n\n" + +if [ $SQL_HOST != localhost ] +then + printf "You are installing LAMS with a remote MySQL server. You MUST first create the \nLAMS database and user with remote privileges before continuing. Refer to the\nreadme chapter 'Setting up MySql on a Different Server' for instructions on how\nto do this.\n\nDo you wish to Continue? (y)es or (n)o: " + continue="" + read continue + case "$continue" in + y) + printf "\n" + ;; + n) + printf "\nBye!\n\n" + installexit + ;; + *) printf "\n\n" + installfailed + ;; + esac +fi + +printf "LAMS requires about 117MB of space, continue with installation? (y)es, (n)o: " +continue="" +read continue +case "$continue" in +y) + ;; +n) printf "\nBye!\n\n" + installexit + ;; +*) printf "\n\n" + installfailed + ;; +esac + +# Choosing whether to install the wrapper +installWrapper + + +printf "\nUsing LAMS database with the following parameters...\n" +printf "Database name: $DB_NAME\n" +printf "Database user: $DB_USER\n" +printf "Database password: $DB_PASS\n" +createDatabase +printf "\nDatabase Created.\n\n" + +# Copying the main lams files +printf "Copying lams.ear directory to ${DEFAULT_DIR}/deploy.\n" +cp -rv assembly/lams.ear ${DEFAULT_DIR}/deploy + +printf "\nDone.\n\n" +if [ "$?" -ne "0" ] + then + echo "Install Failed. Problem while copying the jboss-4.0.2 directory, please try again." + installfailed +fi + +# UNCOMMENT FOR (2.1) Create news-unmodified.html and place it with news.html such that the upgrader can do a +# diff between the two files to determine whether it should update news.html or not. +cp assembly/lams.ear/lams-www.war/news.html ${DEFAULT_DIR}/deploy/lams.ear/lams-www.war/news-unmodified.html + +# Configuring jboss with settings from lams.properties +printf "Configuring JBoss with your settings.\n" +ant/bin/ant -buildfile ant-scripts/configure-deploy.xml -logfile log/copy-conf.log copy-conf +if [ "$?" -ne "0" ] + then + echo "Install Failed. Problem while copying the jboss-4.0.2 configuration files, check log/configure-deploy.log for details." + installfailed +fi + +chmod 755 $JBOSS_DIR/bin/run-lams.sh + +if [ -f $JBOSS_DIR/bin/wrapper ] + then + chmod 755 $JBOSS_DIR/bin/wrapper +fi + +# configure the wrapper +printf "\nConfiguring the java Wrapper\n" +configureWrapper + +# configure jboss +if [ -d ${DEFAULT_DIR}/lib ] + then + printf "\n${DEFAULT_DIR}/lib exists.\n\n" +else + mkdir ${DEFAULT_DIR}/lib +fi + + + +cp $JBOSS_DIR/server/all/lib/jgroups.jar $JBOSS_DIR/server/all/lib/jboss-cache.jar ${DEFAULT_DIR}/lib +cp assembly/lams-session.jar assembly/lams-valve.jar ${DEFAULT_DIR}/lib +if [ "$?" -ne "0" ] + then + echo "\nInstall Failed. Problem while configuring JBoss, please ensure you have the correct version of JBoss (4.0.2).\n\n" + installfailed +fi + + +printf "Copying lams.properties to /etc.\n" +if [ -d /etc/lams2 ] + then + printf "\n/etc/lams2 exists.\n" +else + mkdir -p /etc/lams2 +fi +cp lams.properties /etc/lams2/ + +# changing JAVA_HOME back +export JAVA_HOME=$ORIG_JAVA_HOME + +printf "\n\nLAMS $LAMS_VERSION Configuration completed!\n" +printf "Please view the README for instructions on how to run LAMS.\n\n" + + Index: unix_installer/installer-package/lams.properties =================================================================== diff -u -rc6a8998567722aec174bb639b1fb4d81dece93d8 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/lams.properties (.../lams.properties) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) +++ unix_installer/installer-package/lams.properties (.../lams.properties) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,4 +1,4 @@ -# Copyright (C) 2005 LAMS Foundation (http://lamsfoundation.org) +# Copyright (C) 2008 LAMS Foundation (http://lamsfoundation.org) # License Information: http://lamsfoundation.org/licensing/lams/2.0/ # # This program is free software; you can redistribute it and/or modify @@ -37,8 +37,8 @@ # Database name, username and password for your LAMS database -DB_NAME=lams -DB_USER=lams +DB_NAME=lams2 +DB_USER=lamsuser DB_PASS=lamsdemo @@ -71,7 +71,7 @@ JBOSS_DIR=/usr/local/jboss-4.0.2 # The directory that contains your JDK. (Must be 1.5 or higher) -JDK_DIR=/usr/bin/java/jdk1.6.0_01/ +JDK_DIR=/usr/bin/java/jdk1.5.0_11/ # The location of your mysql executable (Must be 5.0 or higher) SQL_DIR=/usr/bin Index: unix_installer/installer-package/license =================================================================== diff -u -rc6a8998567722aec174bb639b1fb4d81dece93d8 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/license (.../license) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) +++ unix_installer/installer-package/license (.../license) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,4 +1,4 @@ -LAMS 2.0.4 is released under the GPL license detailed below. This package +LAMS 2.1 RC1 is released under the GPL license detailed below. This package also includes other libraries/packages, whose respective licenses are detailed below. Index: unix_installer/installer-package/readme =================================================================== diff -u -rc6a8998567722aec174bb639b1fb4d81dece93d8 -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 --- unix_installer/installer-package/readme (.../readme) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) +++ unix_installer/installer-package/readme (.../readme) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) @@ -1,10 +1,19 @@ -LAMS 2.0.4 - Learning Activity Management System Installer +LAMS 2.1 RC1 - Learning Activity Management System Installer -------------------------------------------------------------------------------- -This is an installer package for LAMS 2.0.4. Please read this +This is an installer package for LAMS 2.1 RC1. Please read this document carefully before installing. Please also ensure that you have read and understood the terms of the license agreement. +LAMS 2.1 RC1 has been released for users to explore the new Branching +features coming in LAMS 2.1. + +Do NOT use this installer to set up production server for LAMS. + +You cannot use this installer to upgrade an existing copy of LAMS 2.0. + +For release notes goto: http://wiki.lamsfoundation.org/display/lams/2.1_RC1 + CONTENTS ========