Index: unix_installer/installer-package/database/lams.dump =================================================================== diff -u -rb7b01efd191eaacd6f9220e339bb93b3c96a8215 -r13109a867357a8730a4df2d3091d1eb71b2d6bb9 --- unix_installer/installer-package/database/lams.dump (.../lams.dump) (revision b7b01efd191eaacd6f9220e339bb93b3c96a8215) +++ unix_installer/installer-package/database/lams.dump (.../lams.dump) (revision 13109a867357a8730a4df2d3091d1eb71b2d6bb9) @@ -2,7 +2,7 @@ -- -- Host: localhost Database: lams -- ------------------------------------------------------ --- Server version 5.0.45-Debian_1ubuntu3.1-log +-- Server version 5.0.45-Debian_1ubuntu3.3-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -15,6 +15,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + -- -- Table structure for table `lams_activity_category` -- @@ -185,7 +186,8 @@ LOCK TABLES `lams_configuration` WRITE; /*!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); +INSERT INTO `lams_configuration` VALUES ('AdminScreenSize','800x600','config.admin.screen.size','config.header.look.feel','STRING',1),('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.200804291240','config.authoring.client.version','config.header.versions','STRING',1),('AuthoringScreenSize','800x600','config.authoring.screen.size','config.header.look.feel','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.200804291240','config.learner.client.version','config.header.versions','STRING',1),('LearnerProgressBatchSize','10','config.learner.progress.batch.size','config.header.look.feel','LONG',1),('LearnerScreenSize','800x600','config.learner.screen.size','config.header.look.feel','STRING',1),('MonitorClientVersion','2.0.100.200804291240','config.monitor.client.version','config.header.versions','STRING',1),('MonitorScreenSize','800x600','config.monitor.screen.size','config.header.look.feel','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.200804291240','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','config.version','config.header.system','STRING',1),('XmppAdmin','admin','config.xmpp.admin','config.header.chat','STRING',0),('XmppConference','conference.shaun.melcoe.mq.edu.au','config.xmpp.conference','config.header.chat','STRING',0),('XmppDomain','shaun.melcoe.mq.edu.au','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; @@ -220,14 +222,15 @@ `name` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, PRIMARY KEY (`credential_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Records the identification properties for a tool.'; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Records the identification properties for a tool.'; -- -- Dumping data for table `lams_cr_credential` -- LOCK TABLES `lams_cr_credential` WRITE; /*!40000 ALTER TABLE `lams_cr_credential` DISABLE KEYS */; +INSERT INTO `lams_cr_credential` VALUES (1,'sharedresources','lams-sharedresources'); /*!40000 ALTER TABLE `lams_cr_credential` ENABLE KEYS */; UNLOCK TABLES; @@ -247,14 +250,15 @@ PRIMARY KEY (`node_id`), KEY `workspace_id` (`workspace_id`), CONSTRAINT `FK_lams_cr_node_1` FOREIGN KEY (`workspace_id`) REFERENCES `lams_cr_workspace` (`workspace_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The main table containing the node definition'; +) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='The main table containing the node definition'; -- -- Dumping data for table `lams_cr_node` -- LOCK TABLES `lams_cr_node` WRITE; /*!40000 ALTER TABLE `lams_cr_node` DISABLE KEYS */; +INSERT INTO `lams_cr_node` VALUES (1,1,NULL,'PACKAGENODE','2008-04-29 12:44:48',2,NULL),(2,1,'leanne.swf','FILENODE','2008-04-29 12:44:48',2,1),(3,1,'blueline.gif','FILENODE','2008-04-29 12:44:48',2,1),(4,1,'index.htm','FILENODE','2008-04-29 12:44:48',2,1),(5,1,NULL,'FILENODE','2008-04-29 12:44:48',2,NULL),(6,1,NULL,'PACKAGENODE','2008-04-29 12:44:57',2,NULL),(7,1,'blueline.gif','FILENODE','2008-04-29 12:44:57',2,6),(8,1,'index.htm','FILENODE','2008-04-29 12:44:57',2,6),(9,1,'leanne_2.swf','FILENODE','2008-04-29 12:44:57',2,6),(10,1,NULL,'PACKAGENODE','2008-04-29 12:44:58',2,NULL),(11,1,'m1_monitoring.swf','FILENODE','2008-04-29 12:44:58',2,10),(12,1,'blueline.gif','FILENODE','2008-04-29 12:44:58',2,10),(13,1,'index.htm','FILENODE','2008-04-29 12:44:58',2,10),(14,1,NULL,'PACKAGENODE','2008-04-29 12:44:58',2,NULL),(15,1,'authorintro.swf','FILENODE','2008-04-29 12:44:58',2,14),(16,1,'blueline.gif','FILENODE','2008-04-29 12:44:58',2,14),(17,1,'index.htm','FILENODE','2008-04-29 12:44:58',2,14),(18,1,NULL,'PACKAGENODE','2008-04-29 12:44:58',2,NULL),(19,1,'l2_noFlash.swf','FILENODE','2008-04-29 12:44:58',2,18),(20,1,'blueline.gif','FILENODE','2008-04-29 12:44:58',2,18),(21,1,'index.htm','FILENODE','2008-04-29 12:44:58',2,18),(22,1,NULL,'PACKAGENODE','2008-04-29 12:45:09',2,NULL),(23,1,'c5_noticeboard.swf','FILENODE','2008-04-29 12:45:09',2,22),(24,1,'blueline.gif','FILENODE','2008-04-29 12:45:09',2,22),(25,1,'index.htm','FILENODE','2008-04-29 12:45:09',2,22),(26,1,NULL,'PACKAGENODE','2008-04-29 12:45:09',2,NULL),(27,1,'c8_shareResources.swf','FILENODE','2008-04-29 12:45:09',2,26),(28,1,'blueline.gif','FILENODE','2008-04-29 12:45:09',2,26),(29,1,'index.htm','FILENODE','2008-04-29 12:45:09',2,26); /*!40000 ALTER TABLE `lams_cr_node` ENABLE KEYS */; UNLOCK TABLES; @@ -272,14 +276,15 @@ PRIMARY KEY (`nv_id`), KEY `node_id` (`node_id`), CONSTRAINT `FK_lams_cr_node_version_2` FOREIGN KEY (`node_id`) REFERENCES `lams_cr_node` (`node_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Represents a version of a node'; +) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='Represents a version of a node'; -- -- Dumping data for table `lams_cr_node_version` -- LOCK TABLES `lams_cr_node_version` WRITE; /*!40000 ALTER TABLE `lams_cr_node_version` DISABLE KEYS */; +INSERT INTO `lams_cr_node_version` VALUES (1,1,1,'2008-04-29 12:44:48',5),(2,2,1,'2008-04-29 12:44:48',5),(3,3,1,'2008-04-29 12:44:48',5),(4,4,1,'2008-04-29 12:44:48',5),(5,5,1,'2008-04-29 12:44:48',5),(6,6,1,'2008-04-29 12:44:57',5),(7,7,1,'2008-04-29 12:44:57',5),(8,8,1,'2008-04-29 12:44:57',5),(9,9,1,'2008-04-29 12:44:57',5),(10,10,1,'2008-04-29 12:44:58',5),(11,11,1,'2008-04-29 12:44:58',5),(12,12,1,'2008-04-29 12:44:58',5),(13,13,1,'2008-04-29 12:44:58',5),(14,14,1,'2008-04-29 12:44:58',5),(15,15,1,'2008-04-29 12:44:58',5),(16,16,1,'2008-04-29 12:44:58',5),(17,17,1,'2008-04-29 12:44:58',5),(18,18,1,'2008-04-29 12:44:58',5),(19,19,1,'2008-04-29 12:44:58',5),(20,20,1,'2008-04-29 12:44:58',5),(21,21,1,'2008-04-29 12:44:58',5),(22,22,1,'2008-04-29 12:45:09',5),(23,23,1,'2008-04-29 12:45:09',5),(24,24,1,'2008-04-29 12:45:09',5),(25,25,1,'2008-04-29 12:45:09',5),(26,26,1,'2008-04-29 12:45:09',5),(27,27,1,'2008-04-29 12:45:09',5),(28,28,1,'2008-04-29 12:45:09',5),(29,29,1,'2008-04-29 12:45:09',5); /*!40000 ALTER TABLE `lams_cr_node_version` ENABLE KEYS */; UNLOCK TABLES; @@ -297,14 +302,15 @@ PRIMARY KEY (`id`), KEY `nv_id` (`nv_id`), CONSTRAINT `FK_lams_cr_node_version_property_1` FOREIGN KEY (`nv_id`) REFERENCES `lams_cr_node_version` (`nv_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_cr_node_version_property` -- LOCK TABLES `lams_cr_node_version_property` WRITE; /*!40000 ALTER TABLE `lams_cr_node_version_property` DISABLE KEYS */; +INSERT INTO `lams_cr_node_version_property` VALUES (1,1,'INITIALPATH','index.htm',1),(2,2,'FILENAME','leanne.swf',1),(3,3,'FILENAME','blueline.gif',1),(4,4,'FILENAME','index.htm',1),(5,5,'FILENAME','Creating Groups in LAMS.pdf',1),(6,5,'TYPE','application/pdf',1),(7,6,'INITIALPATH','index.htm',1),(8,7,'FILENAME','blueline.gif',1),(9,8,'FILENAME','index.htm',1),(10,9,'FILENAME','leanne_2.swf',1),(11,10,'INITIALPATH','index.htm',1),(12,11,'FILENAME','m1_monitoring.swf',1),(13,12,'FILENAME','blueline.gif',1),(14,13,'FILENAME','index.htm',1),(15,14,'INITIALPATH','index.htm',1),(16,15,'FILENAME','authorintro.swf',1),(17,16,'FILENAME','blueline.gif',1),(18,17,'FILENAME','index.htm',1),(19,18,'INITIALPATH','index.htm',1),(20,19,'FILENAME','l2_noFlash.swf',1),(21,20,'FILENAME','blueline.gif',1),(22,21,'FILENAME','index.htm',1),(23,22,'INITIALPATH','index.htm',1),(24,23,'FILENAME','c5_noticeboard.swf',1),(25,24,'FILENAME','blueline.gif',1),(26,25,'FILENAME','index.htm',1),(27,26,'INITIALPATH','index.htm',1),(28,27,'FILENAME','c8_shareResources.swf',1),(29,28,'FILENAME','blueline.gif',1),(30,29,'FILENAME','index.htm',1); /*!40000 ALTER TABLE `lams_cr_node_version_property` ENABLE KEYS */; UNLOCK TABLES; @@ -317,14 +323,15 @@ `workspace_id` bigint(20) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL, PRIMARY KEY (`workspace_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Content repository workspace'; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Content repository workspace'; -- -- Dumping data for table `lams_cr_workspace` -- LOCK TABLES `lams_cr_workspace` WRITE; /*!40000 ALTER TABLE `lams_cr_workspace` DISABLE KEYS */; +INSERT INTO `lams_cr_workspace` VALUES (1,'sharedresourcesworkspace'); /*!40000 ALTER TABLE `lams_cr_workspace` ENABLE KEYS */; UNLOCK TABLES; @@ -342,14 +349,15 @@ KEY `credential_id` (`credential_id`), CONSTRAINT `FK_lams_cr_workspace_credential_1` FOREIGN KEY (`workspace_id`) REFERENCES `lams_cr_workspace` (`workspace_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_cr_workspace_credential_2` FOREIGN KEY (`credential_id`) REFERENCES `lams_cr_credential` (`credential_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Maps tools access to workspaces'; +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Maps tools access to workspaces'; -- -- Dumping data for table `lams_cr_workspace_credential` -- LOCK TABLES `lams_cr_workspace_credential` WRITE; /*!40000 ALTER TABLE `lams_cr_workspace_credential` DISABLE KEYS */; +INSERT INTO `lams_cr_workspace_credential` VALUES (1,1,1); /*!40000 ALTER TABLE `lams_cr_workspace_credential` ENABLE KEYS */; UNLOCK TABLES; @@ -546,14 +554,15 @@ 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 -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_group` -- LOCK TABLES `lams_group` WRITE; /*!40000 ALTER TABLE `lams_group` DISABLE KEYS */; +INSERT INTO `lams_group` VALUES (1,'Everybody learners',1,1,NULL),(2,'Everybody monitors',1,1,NULL),(3,'Everybody learners',2,1,NULL),(4,'Everybody monitors',2,1,NULL),(5,'Everybody learners',3,1,NULL),(6,'Everybody monitors',3,1,NULL); /*!40000 ALTER TABLE `lams_group` ENABLE KEYS */; UNLOCK TABLES; @@ -573,14 +582,15 @@ PRIMARY KEY (`grouping_id`), KEY `grouping_type_id` (`grouping_type_id`), CONSTRAINT `FK_lams_learning_grouping_1` FOREIGN KEY (`grouping_type_id`) REFERENCES `lams_grouping_type` (`grouping_type_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_grouping` -- LOCK TABLES `lams_grouping` WRITE; /*!40000 ALTER TABLE `lams_grouping` DISABLE KEYS */; +INSERT INTO `lams_grouping` VALUES (1,NULL,3,NULL,NULL,2,NULL),(2,NULL,3,NULL,NULL,4,NULL),(3,NULL,3,NULL,NULL,6,NULL); /*!40000 ALTER TABLE `lams_grouping` ENABLE KEYS */; UNLOCK TABLES; @@ -767,15 +777,15 @@ 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 AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_learning_activity` -- LOCK TABLES `lams_learning_activity` WRITE; /*!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); +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-04-29 12:41:04',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-04-29 12:41:08',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-04-29 12:41:11',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-04-29 12:41:14',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-04-29 12:41:20',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-04-29 12:41:27',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-04-29 12:41:29',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-04-29 12:41:35',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-04-29 12:41:41',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-04-29 12:41:46',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-04-29 12:41:50',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-04-29 12:41:51',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-04-29 12:41:51',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-04-29 12:41:51',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-04-29 12:41:52',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-04-29 12:41:52',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-04-29 12:41:52',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-04-29 12:41:52',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-04-29 12:41:52',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-04-29 12:41:52',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),(21,1,'Tool for displaying HTML content including external sources such as images and other media.','Introduction','Displays formatted text and links to external sources on a read only page.',40,51,NULL,NULL,1,2,0,NULL,NULL,NULL,0,1,NULL,'2008-04-29 12:44:48',0,NULL,NULL,NULL,2,12,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(22,8,'Tool for displaying HTML content including external sources such as images and other media.','Visual Workflow Environment','Displays formatted text and links to external sources on a read only page.',424,50,NULL,NULL,1,2,0,NULL,NULL,NULL,0,1,NULL,'2008-04-29 12:44:48',0,NULL,NULL,NULL,2,13,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(23,10,'Sharing resource with others.','Authoring Environment','Uploading your resources to share with others.',124,171,NULL,NULL,1,2,0,NULL,NULL,NULL,0,1,NULL,'2008-04-29 12:44:48',0,NULL,NULL,NULL,6,14,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(24,12,'Tool for displaying HTML content including external sources such as images and other media.','Summing Up','Displays formatted text and links to external sources on a read only page.',357,170,NULL,NULL,1,2,0,NULL,NULL,NULL,0,1,NULL,'2008-04-29 12:44:48',0,NULL,NULL,NULL,2,15,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(25,18,'Sharing resource with others.','Structure of LAMS','Uploading your resources to share with others.',234,48,NULL,NULL,1,2,0,NULL,NULL,NULL,0,1,NULL,'2008-04-29 12:44:48',0,NULL,NULL,NULL,6,16,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(26,1,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',46,213,NULL,NULL,1,2,0,NULL,NULL,NULL,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,2,17,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(27,4,NULL,'Optional Sequences',NULL,254,100,NULL,NULL,13,2,0,NULL,NULL,NULL,0,2,NULL,'2008-04-29 12:44:58',0,NULL,1,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(28,5,NULL,'The Learning Environment (Participate in a Lesson)',NULL,4,48,27,4,8,2,0,NULL,NULL,1,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,31,NULL,NULL,NULL,NULL,0),(29,13,'Sharing resource with others.','Learner Wink','Uploading your resources to share with others.',65,5,28,5,1,2,0,NULL,NULL,1,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,6,18,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(30,6,NULL,'The Authoring Environment (Create a Lesson)',NULL,4,105,27,4,8,2,0,NULL,NULL,2,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,37,NULL,NULL,NULL,NULL,0),(31,20,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',5,5,28,5,1,2,0,NULL,NULL,2,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,2,22,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(32,8,NULL,'The Monitoring Environment (Teach a Lesson)',NULL,4,162,27,4,8,2,0,NULL,NULL,3,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,35,NULL,NULL,NULL,NULL,0),(33,23,'Sharing resource with others.','NoFlash Wink','Uploading your resources to share with others.',124,5,28,5,1,2,0,NULL,NULL,3,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,6,23,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(34,16,NULL,'System Administration [Online Link]',NULL,4,219,27,4,8,2,0,NULL,NULL,4,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,36,NULL,NULL,NULL,NULL,0),(35,15,'Sharing resource with others.','Monitor Wink','Uploading your resources to share with others.',5,5,32,8,1,2,0,NULL,NULL,1,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,6,19,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(36,17,'Sharing resource with others.','Share Resources','Uploading your resources to share with others.',5,5,34,16,1,2,0,NULL,NULL,1,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,6,20,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(37,14,'Sharing resource with others.','Author Wink','Uploading your resources to share with others.',5,5,30,6,1,2,0,NULL,NULL,1,0,2,NULL,'2008-04-29 12:44:58',0,NULL,NULL,NULL,6,21,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(38,1,'Tool for displaying HTML content including external sources such as images and other media.','Introduction','Displays formatted text and links to external sources on a read only page.',19,33,NULL,NULL,1,2,0,NULL,NULL,NULL,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,24,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(39,2,'Tool for displaying HTML content including external sources such as images and other media.','Informative Tools','Displays formatted text and links to external sources on a read only page.',190,33,NULL,NULL,1,2,0,NULL,NULL,NULL,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,25,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(40,4,'Tool for displaying HTML content including external sources such as images and other media.','Fancy Noticeboard','Displays formatted text and links to external sources on a read only page.',360,33,NULL,NULL,1,2,0,NULL,NULL,NULL,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,26,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(41,6,'Sharing resource with others.','Share Resources','Uploading your resources to share with others.',19,99,NULL,NULL,1,2,0,NULL,NULL,NULL,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,6,27,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(42,8,'Which activity type would you like to learn about next?Select an option below then click CHOOSE.You can come back to this screen and select a different activity type to learn about if you wish.','Activity Types - Choose One',NULL,26,191,NULL,NULL,13,2,0,NULL,NULL,NULL,0,3,NULL,'2008-04-29 12:45:09',0,NULL,3,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(43,12,NULL,'Reflective - \'Capture\' Students Learning',NULL,4,162,42,8,8,2,0,NULL,NULL,3,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,51,NULL,NULL,NULL,NULL,0),(44,30,'Tool to create Surveys','Survey','Answer surveys.',124,5,43,12,1,2,0,NULL,NULL,3,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,9,37,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasurv11/images/icon_survey.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(45,32,'Allows voting format','Voting','Voting help text',184,5,43,12,1,2,0,NULL,NULL,4,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,7,38,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lavote11/images/icon_ranking.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(46,36,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',243,5,43,12,1,2,0,NULL,NULL,5,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,39,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(47,34,'Notebook Tool','Notebook','Notebook for notes and reflections',303,5,43,12,1,2,0,NULL,NULL,6,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,8,40,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lantbk11/images/icon_notebook.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(48,40,'Tool for displaying HTML content including external sources such as images and other media.','Winding Up','Displays formatted text and links to external sources on a read only page.',452,278,NULL,NULL,1,2,0,NULL,NULL,NULL,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,41,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(49,9,NULL,'Assessment - Collect Learner Responses',NULL,4,48,42,8,8,2,0,NULL,NULL,1,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,50,NULL,NULL,NULL,NULL,0),(50,13,'Tool for displaying HTML content including external sources such as images and other media.','Assessment Activities','Displays formatted text and links to external sources on a read only page.',5,5,49,9,1,2,0,NULL,NULL,1,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,28,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(51,15,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',5,5,43,12,1,2,0,NULL,NULL,1,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,30,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(52,10,NULL,'Collaborative - Get Learners to Work Together',NULL,4,105,42,8,8,2,0,NULL,NULL,2,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,58,NULL,NULL,NULL,NULL,0),(53,16,'Creates automated assessment questions. e.g. Multiple choice and true/false questions. Can provide feedback and scores.','Demo Multiple Choice','Learner answers a series of automated assessment questions. e.g. Multiple choice and true/false questions. Optional features include feedback on each question and scoring. Questions are weighted for scoring.',65,5,49,9,1,2,0,NULL,NULL,2,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,11,32,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lamc11/images/icon_mcq.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(54,22,'Tool for displaying HTML content including external sources such as images and other media.','Split-Screen Activities','Displays formatted text and links to external sources on a read only page.',65,5,52,10,1,2,0,NULL,NULL,2,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,33,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(55,28,'Each learner answers question(s) and then sees answers from all learners collated on the next page.','Q and A','Each learner answers one or more questions in short answer format and then sees answers from all learners collated on the next page.',65,5,43,12,1,2,0,NULL,NULL,2,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,3,34,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/laqa11/images/icon_questionanswer.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(56,18,'Learners submit files for assessment by the teacher. Scores and comments may be exported as a spreadsheet.','Demo Submit Files','Learners submit files for assessment by the teacher. Scores and comments for each learner are recorded and may be exported as a spreadsheet.',124,5,49,9,1,2,0,NULL,NULL,3,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,4,36,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasbmt11/images/icon_reportsubmission.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(57,60,'Combined Share Resources and Forum ','Resources and Forum','The top window has a Share Resources area and the bottom window has a forum for learners to discuss items they have view via the Share Resources area.',124,5,52,10,6,2,0,NULL,NULL,3,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_urlcontentmessageboard.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(58,14,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',5,5,52,10,1,2,0,NULL,NULL,1,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,2,29,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(59,61,'Sharing resource with others.','Share Resources','Uploading your resources to share with others.',8,45,57,60,1,2,0,NULL,NULL,1,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,6,31,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(60,62,'Online threaded discussion tool (asynchronous).','Forum','Discussion tool useful for long running collaborations and situations where learners are not all on line at the same time.',8,108,57,60,1,2,0,NULL,NULL,2,0,3,NULL,'2008-04-29 12:45:09',0,NULL,NULL,NULL,1,35,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,0),(61,10,'Sharing resource with others.','Authoring Environment','Uploading your resources to share with others.',124,171,NULL,NULL,1,2,0,NULL,NULL,NULL,0,4,NULL,'2008-04-29 12:45:29',0,NULL,NULL,NULL,6,45,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(62,8,'Tool for displaying HTML content including external sources such as images and other media.','Visual Workflow Environment','Displays formatted text and links to external sources on a read only page.',424,50,NULL,NULL,1,2,0,NULL,NULL,NULL,0,4,NULL,'2008-04-29 12:45:29',0,NULL,NULL,NULL,2,44,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(63,18,'Sharing resource with others.','Structure of LAMS','Uploading your resources to share with others.',234,48,NULL,NULL,1,2,0,NULL,NULL,NULL,0,4,NULL,'2008-04-29 12:45:29',0,NULL,NULL,NULL,6,43,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(64,1,'Tool for displaying HTML content including external sources such as images and other media.','Introduction','Displays formatted text and links to external sources on a read only page.',40,51,NULL,NULL,1,2,0,NULL,NULL,NULL,0,4,NULL,'2008-04-29 12:45:29',0,NULL,NULL,NULL,2,42,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(65,12,'Tool for displaying HTML content including external sources such as images and other media.','Summing Up','Displays formatted text and links to external sources on a read only page.',357,170,NULL,NULL,1,2,0,NULL,NULL,NULL,0,4,NULL,'2008-04-29 12:45:29',0,NULL,NULL,NULL,2,46,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(66,13,'Sharing resource with others.','Learner Wink','Uploading your resources to share with others.',65,5,71,5,1,2,0,NULL,NULL,1,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,6,52,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(67,20,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',5,5,71,5,1,2,0,NULL,NULL,2,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,2,50,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(68,4,NULL,'Optional Sequences',NULL,254,100,NULL,NULL,13,2,0,NULL,NULL,NULL,0,5,NULL,'2008-04-29 12:45:46',0,NULL,1,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(69,1,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',46,213,NULL,NULL,1,2,0,NULL,NULL,NULL,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,2,53,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(70,23,'Sharing resource with others.','NoFlash Wink','Uploading your resources to share with others.',124,5,71,5,1,2,0,NULL,NULL,3,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,6,51,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(71,5,NULL,'The Learning Environment (Participate in a Lesson)',NULL,4,48,68,4,8,2,0,NULL,NULL,1,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,67,NULL,NULL,NULL,NULL,0),(72,14,'Sharing resource with others.','Author Wink','Uploading your resources to share with others.',5,5,75,6,1,2,0,NULL,NULL,1,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,6,48,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(73,15,'Sharing resource with others.','Monitor Wink','Uploading your resources to share with others.',5,5,76,8,1,2,0,NULL,NULL,1,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,6,49,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(74,17,'Sharing resource with others.','Share Resources','Uploading your resources to share with others.',5,5,77,16,1,2,0,NULL,NULL,1,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,6,47,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(75,6,NULL,'The Authoring Environment (Create a Lesson)',NULL,4,105,68,4,8,2,0,NULL,NULL,2,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,72,NULL,NULL,NULL,NULL,0),(76,8,NULL,'The Monitoring Environment (Teach a Lesson)',NULL,4,162,68,4,8,2,0,NULL,NULL,3,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,73,NULL,NULL,NULL,NULL,0),(77,16,NULL,'System Administration [Online Link]',NULL,4,219,68,4,8,2,0,NULL,NULL,4,0,5,NULL,'2008-04-29 12:45:46',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,74,NULL,NULL,NULL,NULL,0),(78,30,'Tool to create Surveys','Survey','Answer surveys.',124,5,100,12,1,2,0,NULL,NULL,3,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,9,69,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasurv11/images/icon_survey.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(79,28,'Each learner answers question(s) and then sees answers from all learners collated on the next page.','Q and A','Each learner answers one or more questions in short answer format and then sees answers from all learners collated on the next page.',65,5,100,12,1,2,0,NULL,NULL,2,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,3,70,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/laqa11/images/icon_questionanswer.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(80,18,'Learners submit files for assessment by the teacher. Scores and comments may be exported as a spreadsheet.','Demo Submit Files','Learners submit files for assessment by the teacher. Scores and comments for each learner are recorded and may be exported as a spreadsheet.',124,5,96,9,1,2,0,NULL,NULL,3,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,4,65,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasbmt11/images/icon_reportsubmission.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(81,16,'Creates automated assessment questions. e.g. Multiple choice and true/false questions. Can provide feedback and scores.','Demo Multiple Choice','Learner answers a series of automated assessment questions. e.g. Multiple choice and true/false questions. Optional features include feedback on each question and scoring. Questions are weighted for scoring.',65,5,96,9,1,2,0,NULL,NULL,2,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,11,63,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lamc11/images/icon_mcq.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(82,8,'Which activity type would you like to learn about next?Select an option below then click CHOOSE.You can come back to this screen and select a different activity type to learn about if you wish.','Activity Types - Choose One',NULL,26,191,NULL,NULL,13,2,0,NULL,NULL,NULL,0,6,NULL,'2008-04-29 12:46:01',0,NULL,3,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(83,6,'Sharing resource with others.','Share Resources','Uploading your resources to share with others.',19,99,NULL,NULL,1,2,0,NULL,NULL,NULL,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,6,56,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(84,34,'Notebook Tool','Notebook','Notebook for notes and reflections',303,5,100,12,1,2,0,NULL,NULL,6,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,8,71,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lantbk11/images/icon_notebook.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(85,36,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',243,5,100,12,1,2,0,NULL,NULL,5,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,66,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(86,22,'Tool for displaying HTML content including external sources such as images and other media.','Split-Screen Activities','Displays formatted text and links to external sources on a read only page.',65,5,98,10,1,2,0,NULL,NULL,2,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,59,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(87,14,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',5,5,98,10,1,2,0,NULL,NULL,1,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,60,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(88,4,'Tool for displaying HTML content including external sources such as images and other media.','Fancy Noticeboard','Displays formatted text and links to external sources on a read only page.',360,33,NULL,NULL,1,2,0,NULL,NULL,NULL,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,57,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(89,2,'Tool for displaying HTML content including external sources such as images and other media.','Informative Tools','Displays formatted text and links to external sources on a read only page.',190,33,NULL,NULL,1,2,0,NULL,NULL,NULL,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,54,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(90,1,'Tool for displaying HTML content including external sources such as images and other media.','Introduction','Displays formatted text and links to external sources on a read only page.',19,33,NULL,NULL,1,2,0,NULL,NULL,NULL,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,58,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(91,13,'Tool for displaying HTML content including external sources such as images and other media.','Assessment Activities','Displays formatted text and links to external sources on a read only page.',5,5,96,9,1,2,0,NULL,NULL,1,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,64,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(92,32,'Allows voting format','Voting','Voting help text',184,5,100,12,1,2,0,NULL,NULL,4,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,7,67,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lavote11/images/icon_ranking.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(93,60,'Combined Share Resources and Forum ','Resources and Forum','The top window has a Share Resources area and the bottom window has a forum for learners to discuss items they have view via the Share Resources area.',124,5,98,10,6,2,0,NULL,NULL,3,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_urlcontentmessageboard.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(94,40,'Tool for displaying HTML content including external sources such as images and other media.','Winding Up','Displays formatted text and links to external sources on a read only page.',452,278,NULL,NULL,1,2,0,NULL,NULL,NULL,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,55,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(95,15,'Tool for displaying HTML content including external sources such as images and other media.','Noticeboard','Displays formatted text and links to external sources on a read only page.',5,5,100,12,1,2,0,NULL,NULL,1,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,2,68,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(96,9,NULL,'Assessment - Collect Learner Responses',NULL,4,48,82,8,8,2,0,NULL,NULL,1,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,91,NULL,NULL,NULL,NULL,0),(97,61,'Sharing resource with others.','Share Resources','Uploading your resources to share with others.',8,45,93,60,1,2,0,NULL,NULL,1,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,6,61,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(98,10,NULL,'Collaborative - Get Learners to Work Together',NULL,4,105,82,8,8,2,0,NULL,NULL,2,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,87,NULL,NULL,NULL,NULL,0),(99,62,'Online threaded discussion tool (asynchronous).','Forum','Discussion tool useful for long running collaborations and situations where learners are not all on line at the same time.',8,108,93,60,1,2,0,NULL,NULL,2,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,1,62,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,NULL,NULL,0,1,NULL,NULL,NULL,NULL,NULL,0),(100,12,NULL,'Reflective - \'Capture\' Students Learning',NULL,4,162,82,8,8,2,0,NULL,NULL,3,0,6,NULL,'2008-04-29 12:46:01',0,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,95,NULL,NULL,NULL,NULL,0); /*!40000 ALTER TABLE `lams_learning_activity` ENABLE KEYS */; UNLOCK TABLES; @@ -845,14 +855,15 @@ CONSTRAINT `FK_lams_learning_design_5` FOREIGN KEY (`license_id`) REFERENCES `lams_license` (`license_id`), CONSTRAINT `FK_lams_learning_design_6` FOREIGN KEY (`copy_type_id`) REFERENCES `lams_copy_type` (`copy_type_id`), CONSTRAINT `FK_lams_learning_design_7` FOREIGN KEY (`edit_override_user_id`) REFERENCES `lams_user` (`user_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_learning_design` -- LOCK TABLES `lams_learning_design` WRITE; /*!40000 ALTER TABLE `lams_learning_design` DISABLE KEYS */; +INSERT INTO `lams_learning_design` VALUES (1,NULL,'LAMS 101 Getting Started \"What is LAMS?\"A sequence introducing the concepts behind LAMS, basic use principles, and discusses where LAMS can be applied to a Pedagogical setting.','1-whatIs',21,20,1,0,NULL,5,NULL,NULL,NULL,1,'2008-04-29 12:44:48','2.0.100.200803121637',NULL,5,NULL,1,NULL,'2008-04-29 12:44:48','4028efbb18edfbb70118ee3b3b6d00b8',0,NULL,1),(2,NULL,'This is the second sequence in the LAMS 101 \"Getting Started\" CourseIt demonstrates the four different LAMS environments: - Learner - Monitor - Author - System Administration','2-Environments',26,24,1,0,NULL,5,NULL,NULL,NULL,1,'2008-04-29 12:44:58','2.0.100.200803121637',NULL,5,NULL,1,NULL,'2008-04-29 12:44:58','4028efbb18edfbb70118ee6bacc700d2',0,NULL,1),(3,NULL,'Lesson #3 in LAMS101:Getting Started.Discusses all of the tools available in LAMS and gives demonstrations of each in action.','3-tools',38,63,1,0,NULL,5,NULL,NULL,NULL,1,'2008-04-29 12:45:09','2.0.100.200803121637',NULL,5,NULL,1,NULL,'2008-04-29 12:45:09','4028efbb1935b8d301193606f5000051',0,NULL,1),(4,NULL,'LAMS 101 Getting Started \"What is LAMS?\"A sequence introducing the concepts behind LAMS, basic use principles, and discusses where LAMS can be applied to a Pedagogical setting.','1-whatIs',64,20,1,1,NULL,5,NULL,NULL,NULL,2,'2008-04-29 12:45:29','2.0.100.200803121637',1,22,NULL,1,NULL,'2008-04-29 12:45:29','4028efbb18edfbb70118ee3b3b6d00b8',0,NULL,1),(5,NULL,'This is the second sequence in the LAMS 101 \"Getting Started\" CourseIt demonstrates the four different LAMS environments: - Learner - Monitor - Author - System Administration','2-Environments',69,24,1,1,NULL,5,NULL,NULL,NULL,2,'2008-04-29 12:45:46','2.0.100.200803121637',2,22,NULL,1,NULL,'2008-04-29 12:45:46','4028efbb18edfbb70118ee6bacc700d2',0,NULL,1),(6,NULL,'Lesson #3 in LAMS101:Getting Started.Discusses all of the tools available in LAMS and gives demonstrations of each in action.','3-tools',90,63,1,1,NULL,5,NULL,NULL,NULL,2,'2008-04-29 12:46:01','2.0.100.200803121637',3,22,NULL,1,NULL,'2008-04-29 12:46:01','4028efbb1935b8d301193606f5000051',0,NULL,1); /*!40000 ALTER TABLE `lams_learning_design` ENABLE KEYS */; UNLOCK TABLES; @@ -876,7 +887,7 @@ LOCK TABLES `lams_learning_library` WRITE; /*!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'); +INSERT INTO `lams_learning_library` VALUES (1,'Forum, also known Message Board','Forum',1,'2008-04-29 12:41:04'),(2,'Displays a Noticeboard','Noticeboard',1,'2008-04-29 12:41:08'),(3,'Question and Answer Learning Library Description','Question and Answer',1,'2008-04-29 12:41:11'),(4,'Uploading of files by learners, for review by teachers.','Submit file',1,'2008-04-29 12:41:14'),(5,'Chat Tool','Chat',1,'2008-04-29 12:41:20'),(6,'Share resources','Share resources',1,'2008-04-29 12:41:27'),(7,'Voting Learning Library Description','Voting',1,'2008-04-29 12:41:29'),(8,'Notebook Tool','Notebook',1,'2008-04-29 12:41:35'),(9,'Survey','Survey',1,'2008-04-29 12:41:41'),(10,'Scribe Tool','Scribe',0,'2008-04-29 12:41:46'),(11,'MCQ Learning Library Description','MCQ',1,'2008-04-29 12:41:50'),(12,'Shared Resources and Forum','Resources and Forum',1,'2008-04-29 12:41:51'),(13,'Chat and Scribe','Chat and Scribe',1,'2008-04-29 12:41:52'),(14,'Forum and Scribe','Forum and Scribe',1,'2008-04-29 12:41:52'); /*!40000 ALTER TABLE `lams_learning_library` ENABLE KEYS */; UNLOCK TABLES; @@ -904,14 +915,15 @@ CONSTRAINT `FK_learning_transition_3` FOREIGN KEY (`from_activity_id`) REFERENCES `lams_learning_activity` (`activity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_learning_transition_2` FOREIGN KEY (`to_activity_id`) REFERENCES `lams_learning_activity` (`activity_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `lddefn_transition_ibfk_1` FOREIGN KEY (`learning_design_id`) REFERENCES `lams_learning_design` (`learning_design_id`) ON DELETE NO ACTION ON UPDATE NO ACTION -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_learning_transition` -- LOCK TABLES `lams_learning_transition` WRITE; /*!40000 ALTER TABLE `lams_learning_transition` DISABLE KEYS */; +INSERT INTO `lams_learning_transition` VALUES (1,19,NULL,NULL,25,21,1,'2008-04-29 12:44:48',18,1),(2,13,NULL,NULL,24,23,1,'2008-04-29 12:44:48',12,10),(3,20,NULL,NULL,22,25,1,'2008-04-29 12:44:48',8,18),(4,11,NULL,NULL,23,22,1,'2008-04-29 12:44:48',10,8),(5,7,NULL,NULL,27,26,2,'2008-04-29 12:44:58',4,1),(6,22,NULL,NULL,29,31,2,'2008-04-29 12:44:58',13,20),(7,24,NULL,NULL,33,29,2,'2008-04-29 12:44:58',23,13),(8,38,NULL,NULL,46,45,3,'2008-04-29 12:45:09',36,32),(9,7,NULL,NULL,41,40,3,'2008-04-29 12:45:09',6,4),(10,31,NULL,NULL,44,55,3,'2008-04-29 12:45:09',30,28),(11,39,NULL,NULL,47,46,3,'2008-04-29 12:45:09',34,36),(12,3,NULL,NULL,39,38,3,'2008-04-29 12:45:09',2,1),(13,63,NULL,NULL,57,54,3,'2008-04-29 12:45:09',60,22),(14,11,NULL,NULL,42,41,3,'2008-04-29 12:45:09',8,6),(15,19,NULL,NULL,56,53,3,'2008-04-29 12:45:09',18,16),(16,29,NULL,NULL,55,51,3,'2008-04-29 12:45:09',28,15),(17,41,NULL,NULL,48,42,3,'2008-04-29 12:45:09',40,8),(18,17,NULL,NULL,53,50,3,'2008-04-29 12:45:09',16,13),(19,42,NULL,NULL,54,58,3,'2008-04-29 12:45:09',22,14),(20,5,NULL,NULL,40,39,3,'2008-04-29 12:45:09',4,2),(21,33,NULL,NULL,45,44,3,'2008-04-29 12:45:09',32,30),(22,11,NULL,NULL,61,62,4,'2008-04-29 12:45:29',10,8),(23,20,NULL,NULL,62,63,4,'2008-04-29 12:45:29',8,18),(24,19,NULL,NULL,63,64,4,'2008-04-29 12:45:29',18,1),(25,13,NULL,NULL,65,61,4,'2008-04-29 12:45:29',12,10),(26,22,NULL,NULL,66,67,5,'2008-04-29 12:45:46',13,20),(27,7,NULL,NULL,68,69,5,'2008-04-29 12:45:46',4,1),(28,24,NULL,NULL,70,66,5,'2008-04-29 12:45:46',23,13),(29,31,NULL,NULL,78,79,6,'2008-04-29 12:46:01',30,28),(30,19,NULL,NULL,80,81,6,'2008-04-29 12:46:01',18,16),(31,11,NULL,NULL,82,83,6,'2008-04-29 12:46:01',8,6),(32,39,NULL,NULL,84,85,6,'2008-04-29 12:46:01',34,36),(33,42,NULL,NULL,86,87,6,'2008-04-29 12:46:01',22,14),(34,5,NULL,NULL,88,89,6,'2008-04-29 12:46:01',4,2),(35,3,NULL,NULL,89,90,6,'2008-04-29 12:46:01',2,1),(36,17,NULL,NULL,81,91,6,'2008-04-29 12:46:01',16,13),(37,38,NULL,NULL,85,92,6,'2008-04-29 12:46:01',36,32),(38,63,NULL,NULL,93,86,6,'2008-04-29 12:46:01',60,22),(39,33,NULL,NULL,92,78,6,'2008-04-29 12:46:01',32,30),(40,41,NULL,NULL,94,82,6,'2008-04-29 12:46:01',40,8),(41,7,NULL,NULL,83,88,6,'2008-04-29 12:46:01',6,4),(42,29,NULL,NULL,79,95,6,'2008-04-29 12:46:01',28,15); /*!40000 ALTER TABLE `lams_learning_transition` ENABLE KEYS */; UNLOCK TABLES; @@ -949,14 +961,15 @@ CONSTRAINT `FK_lams_lesson_3` FOREIGN KEY (`organisation_id`) REFERENCES `lams_organisation` (`organisation_id`), CONSTRAINT `FK_lams_lesson_4` FOREIGN KEY (`lesson_state_id`) REFERENCES `lams_lesson_state` (`lesson_state_id`), CONSTRAINT `FK_lams_lesson_5` FOREIGN KEY (`class_grouping_id`) REFERENCES `lams_grouping` (`grouping_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_lesson` -- LOCK TABLES `lams_lesson` WRITE; /*!40000 ALTER TABLE `lams_lesson` DISABLE KEYS */; +INSERT INTO `lams_lesson` VALUES (1,4,5,'1-whatIs','LAMS 101 Getting Started \"What is LAMS?\"A sequence introducing the concepts behind LAMS, basic use principles, and discusses where LAMS can be applied to a Pedagogical setting.','2008-04-29 12:45:29',3,1,3,'2008-04-29 12:45:29',NULL,NULL,NULL,NULL,1,0,2),(2,5,5,'2-Environments','This is the second sequence in the LAMS 101 \"Getting Started\" CourseIt demonstrates the four different LAMS environments: - Learner - Monitor - Author - System Administration','2008-04-29 12:45:46',3,2,3,'2008-04-29 12:45:46',NULL,NULL,NULL,NULL,1,0,2),(3,6,5,'3-tools','Lesson #3 in LAMS101:Getting Started.Discusses all of the tools available in LAMS and gives demonstrations of each in action.','2008-04-29 12:46:01',3,3,3,'2008-04-29 12:46:01',NULL,NULL,NULL,NULL,1,0,2); /*!40000 ALTER TABLE `lams_lesson` ENABLE KEYS */; UNLOCK TABLES; @@ -1145,7 +1158,7 @@ LOCK TABLES `lams_organisation` WRITE; /*!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); +INSERT INTO `lams_organisation` VALUES (1,'Root',NULL,'Root Organisation',NULL,1,'2008-04-29 12:40:58',1,1,1,0,0,0,0,1,NULL,NULL),(2,'Using LAMS','PP101','Using LAMS',1,2,'2008-04-29 12:40:58',1,2,1,0,0,0,0,1,NULL,NULL),(3,'Everybody',NULL,'All People In Course',2,3,'2008-04-29 12:40:58',1,NULL,1,0,0,0,0,1,NULL,'1,2,3,'),(4,'Mathematics 1','MATH111','Mathematics 1',1,2,'2008-04-29 12:40:58',1,3,1,0,0,0,0,2,NULL,NULL),(5,'Tutorial Group A','TUTA','Tutorial Group A',4,3,'2008-04-29 12:40:58',1,NULL,1,0,0,0,0,2,NULL,NULL),(6,'Tutorial Group B','TUTB','Tutorial Group B',4,3,'2008-04-29 12:40:58',1,NULL,1,0,0,0,0,2,NULL,NULL),(7,'Moodle','Moodle','Moodle Test',1,2,'2008-04-29 12:40:58',1,50,2,0,0,0,0,1,NULL,NULL); /*!40000 ALTER TABLE `lams_organisation` ENABLE KEYS */; UNLOCK TABLES; @@ -1592,7 +1605,7 @@ LOCK TABLES `lams_role` WRITE; /*!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'); +INSERT INTO `lams_role` VALUES (1,'SYSADMIN','LAMS System Adminstrator','2008-04-29 12:40:58'),(2,'GROUP MANAGER','Group Manager','2008-04-29 12:40:58'),(3,'AUTHOR','Authors Learning Designs','2008-04-29 12:40:58'),(4,'MONITOR','Member of Staff','2008-04-29 12:40:58'),(5,'LEARNER','Student','2008-04-29 12:40:58'),(6,'GROUP ADMIN','Group Administrator','2008-04-29 12:40:58'),(7,'AUTHOR ADMIN','Author Administrator','2008-04-29 12:40:58'); /*!40000 ALTER TABLE `lams_role` ENABLE KEYS */; UNLOCK TABLES; @@ -1679,7 +1692,7 @@ LOCK TABLES `lams_system_tool` WRITE; /*!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); +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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',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-04-29 12:40:58',NULL); /*!40000 ALTER TABLE `lams_system_tool` ENABLE KEYS */; UNLOCK TABLES; @@ -1718,6 +1731,7 @@ `classpath_addition` varchar(255) default NULL, `context_file` varchar(255) default NULL, `admin_url` text, + `supports_outputs` tinyint(1) default '0', PRIMARY KEY (`tool_id`), UNIQUE KEY `UQ_lams_tool_sig` (`tool_signature`), UNIQUE KEY `UQ_lams_tool_class_name` (`service_name`), @@ -1733,7 +1747,7 @@ LOCK TABLES `lams_tool` WRITE; /*!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); +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-04-29 12:41:04','org.lamsfoundation.lams.tool.forum.ApplicationResources','2008-04-29 12:41:04','lams-tool-lafrum11.jar','/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml',NULL,1),(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-04-29 12:41:08','org.lamsfoundation.lams.tool.noticeboard.ApplicationResources','2008-04-29 12:41:08','lams-tool-lanb11.jar','/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml',NULL,0),(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-04-29 12:41:11','org.lamsfoundation.lams.tool.qa.ApplicationResources','2008-04-29 12:41:11','lams-tool-laqa11.jar','/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml',NULL,0),(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-04-29 12:41:14','org.lamsfoundation.lams.tool.sbmt.ApplicationResources','2008-04-29 12:41:14','lams-tool-lasbmt11.jar','/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml',NULL,0),(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-04-29 12:41:20','org.lamsfoundation.lams.tool.chat.ApplicationResources','2008-04-29 12:41:20','lams-tool-lachat11.jar','/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml',NULL,0),(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-04-29 12:41:27','org.lamsfoundation.lams.tool.rsrc.ApplicationResources','2008-04-29 12:41:27','lams-tool-larsrc11.jar','/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml',NULL,0),(7,'lavote11','voteService','Voting','Voting','vote','20080326',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-04-29 12:41:29','org.lamsfoundation.lams.tool.vote.ApplicationResources','2008-04-29 12:41:29','lams-tool-lavote11.jar','/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml',NULL,1),(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-04-29 12:41:35','org.lamsfoundation.lams.tool.notebook.ApplicationResources','2008-04-29 12:41:35','lams-tool-lantbk11.jar','/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml',NULL,0),(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-04-29 12:41:41','org.lamsfoundation.lams.tool.survey.ApplicationResources','2008-04-29 12:41:41','lams-tool-lasurv11.jar','/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml',NULL,0),(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-04-29 12:41:46','org.lamsfoundation.lams.tool.scribe.ApplicationResources','2008-04-29 12:41:46','lams-tool-lascrb11.jar','/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml',NULL,0),(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-04-29 12:41:50','org.lamsfoundation.lams.tool.mc.ApplicationResources','2008-04-29 12:41:50','lams-tool-lamc11.jar','/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml',NULL,1); /*!40000 ALTER TABLE `lams_tool` ENABLE KEYS */; UNLOCK TABLES; @@ -1748,15 +1762,15 @@ 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 AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_tool_content` -- 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); +INSERT INTO `lams_tool_content` VALUES (1,1),(35,1),(62,1),(2,2),(12,2),(13,2),(15,2),(17,2),(22,2),(24,2),(25,2),(26,2),(28,2),(29,2),(30,2),(33,2),(39,2),(41,2),(42,2),(44,2),(46,2),(50,2),(53,2),(54,2),(55,2),(57,2),(58,2),(59,2),(60,2),(64,2),(66,2),(68,2),(3,3),(34,3),(70,3),(4,4),(36,4),(65,4),(5,5),(6,6),(14,6),(16,6),(18,6),(19,6),(20,6),(21,6),(23,6),(27,6),(31,6),(43,6),(45,6),(47,6),(48,6),(49,6),(51,6),(52,6),(56,6),(61,6),(7,7),(38,7),(67,7),(8,8),(40,8),(71,8),(9,9),(37,9),(69,9),(10,10),(11,11),(32,11),(63,11); /*!40000 ALTER TABLE `lams_tool_content` ENABLE KEYS */; UNLOCK TABLES; @@ -1810,14 +1824,15 @@ CONSTRAINT `FK_lams_tool_session_7` FOREIGN KEY (`tool_session_type_id`) REFERENCES `lams_tool_session_type` (`tool_session_type_id`), CONSTRAINT `FK_lams_tool_session_8` FOREIGN KEY (`activity_id`) REFERENCES `lams_learning_activity` (`activity_id`), CONSTRAINT `FK_lams_tool_session_1` FOREIGN KEY (`group_id`) REFERENCES `lams_group` (`group_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; -- -- Dumping data for table `lams_tool_session` -- LOCK TABLES `lams_tool_session` WRITE; /*!40000 ALTER TABLE `lams_tool_session` DISABLE KEYS */; +INSERT INTO `lams_tool_session` VALUES (1,'Everybody learners',1,1,61,1,'2008-04-29 12:45:29',1,NULL,'uq_61_1'),(2,'Everybody learners',1,1,62,1,'2008-04-29 12:45:29',1,NULL,'uq_62_1'),(3,'Everybody learners',1,1,63,1,'2008-04-29 12:45:29',1,NULL,'uq_63_1'),(4,'Everybody learners',1,1,64,1,'2008-04-29 12:45:29',1,NULL,'uq_64_1'),(5,'Everybody learners',1,1,65,1,'2008-04-29 12:45:29',1,NULL,'uq_65_1'),(6,'Everybody learners',1,2,66,1,'2008-04-29 12:45:46',3,NULL,'uq_66_3'),(7,'Everybody learners',1,2,72,1,'2008-04-29 12:45:46',3,NULL,'uq_72_3'),(8,'Everybody learners',1,2,73,1,'2008-04-29 12:45:46',3,NULL,'uq_73_3'),(9,'Everybody learners',1,2,74,1,'2008-04-29 12:45:46',3,NULL,'uq_74_3'),(10,'Everybody learners',1,2,67,1,'2008-04-29 12:45:46',3,NULL,'uq_67_3'),(11,'Everybody learners',1,2,69,1,'2008-04-29 12:45:46',3,NULL,'uq_69_3'),(12,'Everybody learners',1,2,70,1,'2008-04-29 12:45:46',3,NULL,'uq_70_3'),(13,'Everybody learners',1,3,87,1,'2008-04-29 12:46:01',5,NULL,'uq_87_5'),(14,'Everybody learners',1,3,91,1,'2008-04-29 12:46:01',5,NULL,'uq_91_5'),(15,'Everybody learners',1,3,95,1,'2008-04-29 12:46:01',5,NULL,'uq_95_5'),(16,'Everybody learners',1,3,97,1,'2008-04-29 12:46:01',5,NULL,'uq_97_5'),(17,'Everybody learners',1,3,79,1,'2008-04-29 12:46:01',5,NULL,'uq_79_5'),(18,'Everybody learners',1,3,81,1,'2008-04-29 12:46:01',5,NULL,'uq_81_5'),(19,'Everybody learners',1,3,86,1,'2008-04-29 12:46:02',5,NULL,'uq_86_5'),(20,'Everybody learners',1,3,99,1,'2008-04-29 12:46:02',5,NULL,'uq_99_5'),(21,'Everybody learners',1,3,78,1,'2008-04-29 12:46:02',5,NULL,'uq_78_5'),(22,'Everybody learners',1,3,80,1,'2008-04-29 12:46:02',5,NULL,'uq_80_5'),(23,'Everybody learners',1,3,83,1,'2008-04-29 12:46:02',5,NULL,'uq_83_5'),(24,'Everybody learners',1,3,92,1,'2008-04-29 12:46:02',5,NULL,'uq_92_5'),(25,'Everybody learners',1,3,85,1,'2008-04-29 12:46:02',5,NULL,'uq_85_5'),(26,'Everybody learners',1,3,84,1,'2008-04-29 12:46:02',5,NULL,'uq_84_5'),(27,'Everybody learners',1,3,88,1,'2008-04-29 12:46:02',5,NULL,'uq_88_5'),(28,'Everybody learners',1,3,89,1,'2008-04-29 12:46:02',5,NULL,'uq_89_5'),(29,'Everybody learners',1,3,90,1,'2008-04-29 12:46:02',5,NULL,'uq_90_5'),(30,'Everybody learners',1,3,94,1,'2008-04-29 12:46:02',5,NULL,'uq_94_5'); /*!40000 ALTER TABLE `lams_tool_session` ENABLE KEYS */; UNLOCK TABLES; @@ -1906,6 +1921,7 @@ KEY `html_theme_id` (`html_theme_id`), KEY `locale_id` (`locale_id`), KEY `login` (`login`), + KEY `email` (`email`), CONSTRAINT `FK_lams_user_1` FOREIGN KEY (`authentication_method_id`) REFERENCES `lams_authentication_method` (`authentication_method_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_lams_user_2` FOREIGN KEY (`workspace_id`) REFERENCES `lams_workspace` (`workspace_id`) ON DELETE NO ACTION ON UPDATE NO ACTION, 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, @@ -1919,7 +1935,7 @@ LOCK TABLES `lams_user` WRITE; /*!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); +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-04-29 12:40:58',1,51,1,2,NULL,1,NULL,0,1),(2,'test','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3','Dr','Testing','LDAP',NULL,NULL,NULL,'Sydney','NSW',NULL,'Australia',NULL,NULL,NULL,NULL,'test@xx.xx.xx',1,'2008-04-29 12:40:58',3,NULL,1,2,NULL,3,NULL,0,1),(3,'lamskh01','829c3804401b0727f70f73d4415e162400cbe57b','Mr','Jacky','Fang',NULL,NULL,NULL,'Sydney','NSW',NULL,'Australia',NULL,NULL,NULL,NULL,'jfang@melcoe.mq.edu.au',1,'2008-04-29 12:40:58',2,NULL,1,2,NULL,1,NULL,0,1),(4,'mmm','91223fd10ce86fc852b449583aa2196c304bf6e0','Ms','Mary','Morgan','99','First Ave',NULL,'Parramatta','NSW',NULL,'Australia','0295099999','0298939999','0499999999','0299999999','mmmmmmm@xx.os',1,'2004-12-23 00:00:00',1,4,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; @@ -1944,6 +1960,7 @@ LOCK TABLES `lams_user_group` WRITE; /*!40000 ALTER TABLE `lams_user_group` DISABLE KEYS */; +INSERT INTO `lams_user_group` VALUES (2,1),(2,3),(2,5),(3,1),(3,3),(3,5),(4,1),(4,3),(4,5),(5,1),(5,2),(5,3),(5,4),(5,5),(5,6),(6,1),(6,3),(6,5),(7,1),(7,3),(7,5),(8,1),(8,3),(8,5); /*!40000 ALTER TABLE `lams_user_group` ENABLE KEYS */; UNLOCK TABLES; @@ -2063,7 +2080,7 @@ 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); +INSERT INTO `lams_wkspc_wkspc_folder` VALUES (1,1,1),(2,2,2),(3,2,22),(4,3,3),(5,3,23),(6,4,4),(7,5,5),(8,6,6),(9,7,7),(10,8,8),(11,50,40),(12,51,45); /*!40000 ALTER TABLE `lams_wkspc_wkspc_folder` ENABLE KEYS */; UNLOCK TABLES; @@ -2090,7 +2107,7 @@ 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'); +INSERT INTO `lams_workspace` VALUES (1,1,NULL,'ROOT'),(2,2,22,'Using LAMS'),(3,3,23,'MATH111'),(4,4,NULL,'Mary Morgan'),(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'); /*!40000 ALTER TABLE `lams_workspace` ENABLE KEYS */; UNLOCK TABLES; @@ -2120,7 +2137,7 @@ 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); +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,'Using LAMS',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),(4,NULL,'Mary Morgan',4,'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,'Using LAMS Run Sequences',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); /*!40000 ALTER TABLE `lams_workspace_folder` ENABLE KEYS */; UNLOCK TABLES; @@ -2396,15 +2413,15 @@ UNIQUE KEY `content_id` (`content_id`), KEY `FK87917942E42F4351` (`create_by`), CONSTRAINT `FK87917942E42F4351` FOREIGN KEY (`create_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lafrum11_forum` -- 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); +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),(2,'2008-04-11 16:03:30','2008-04-29 12:45:09',1,'LAMS Resources Forum',0,0,0,'
First off, relax, the hard bits over! If you can see this sequence, LAMS is up and running on your server. You’ve also figured out how to log in, and participate in a "sequence" - that’s what we call a collection of LAMS activities.
\n
\n
In a word, that’s what LAMS does - it is a System that Manages sequences of Learning Activities. A Sequence is an online digital lesson that simulates the classroom environment in a virtual space.
\nSequences are first created by Authors, and are then run for different groups of Learners while a Monitor supervises. We’ll look more at these Roles in LAMS in Lesson Two of LAMS101.
\nEach sequence is made up of activities - each of which has a particular function, either:
\n\nThese activities can include a range of individual tasks, small group work and whole class activities based on both content and collaboration.
\nWhen you use LAMS, not only are you creating a real lesson for your learners, you also create the plan for the lesson at the same time. We’ll talk about this Visual Authoring Environment in a few moments.
\nDolly is our LAMS mascot. Back when LAMS was being redesigned up to version 2.0, it was the "next-generation" of LAMS. Dolly the sheep was the first mammal to have been successfully cloned from an adult cell, therefore, she was the next generation LAMB (see what we did there?).
\nOur marvelous designer, Shelly is the official mother of Dolly and also our front page model. So all kudos to her!
\nLAMS has many, many more functions that you can explore as part of your lessons.
\nThe new release of version 2.1 includes increased functionality in many areas, some of which are explored in the rest of this Getting Started course.
\n\n
YouTube Videos\n \n | \n MP3 Files\n\n \n LAMS PODCAST with ALAN CARRINGTON (CLPD Adelaide Uni) | \n
The Chat Activity runs a live (synchronous) discussion for learners.
\nThis is similar to Instant Messaging (IM) software that most learners will be familiar with.
Forums can be \'locked\' as an activity which is only available for the period of the specific activity (i.e.: no more contributions can be made once the learner clicks \'Finish\', or they can be \'unlocked\', in that learners can add to the Forum throughout the life of the whole sequence.
\nIt allows a group of Learners to collaborate and create a written report with one Learner as the \'Scribe,\' or Writer for the report. The activity is most effective when paired with another collaborative activity. In the current release of LAMS (2.0.4) Scribe is available to be paired with either Chat or Forum.
\nThe Scribe Activity should always used in conjunction with another activity that gives it context. For instance, if used with Chat, then the Scribe (one particular learner) is expected to collect or summarize the output of the Chat discussion into a succinct set of sentences. Once the scribe has done this, they publish the summary to the rest of the learners who vote whether they agree with the summary as proposed by the scribe. If not, they can ask the scribe to modify the report until all learners agree on the report.
\nOnce the Scribe submits the report, the other learners in the group or class can agree or disagree with the summary. The scribe can finished the scribe task at any time regardless of the number of learners that have agreed with the proposed summaries. The Scribe task can also be finished through the monitoring environment by a teacher or instructor.
\nOnce the scribe task is finished a report of the statements and summary is presented to all learners.
\nThe sequence Author can pen their own responses to each question, which are displayed to learners after they have submitted their own answers.
\nThe activity can also be configured to display answers collected from all learners in the sequence or group
\nThe Question and Answer Activity allows teachers to pose a question or questions to learners individually, and after they have entered their response, to see the responses of all their peers presented on a single answer screen.
\nThe Survey Tool is similar to Multiple Choice, in that it presents learners with a number of questions and collects their responses. However, unlike Multiple Choice there are no right or wrong answers - the system just collates all answers for analysis by the teacher in the monitoring area.
\nQuestion types include single response, multiple response and open text entry, and questions can be mandatory or optional. For multiple choice questions, Learners can also be provided with the option of adding their own answer to a list.
\nThe Voting Activity allows teachers to provide learners with a list of options to "Vote" on. It is similar to the Q&A Activity in that Voting shows first one screen with all the available voting options, then a screen showing the individual learner\'s selection, then a screen showing "progressive" voting results (i.e., a non-editable screen where learners can see results from themselves and other learners over time). Finally, there is Summary Screen of group results.
\nIt combines a Chat Activity with a Scribe Activity for collating the chat group\'s view on questions created by the teacher. When used in small group mode, the tool creates parallel Chat and Scribe areas for each small group, and then shows the outcome of each group collated on a whole class page.
\nFirst off, relax, the hard bits over! If you can see this sequence, LAMS is up and running on your server. You’ve also figured out how to log in, and participate in a "sequence" - that’s what we call a collection of LAMS activities.
\n
\n
In a word, that’s what LAMS does - it is a System that Manages sequences of Learning Activities. A Sequence is an online digital lesson that simulates the classroom environment in a virtual space.
\nSequences are first created by Authors, and are then run for different groups of Learners while a Monitor supervises. We’ll look more at these Roles in LAMS in Lesson Two of LAMS101.
\nEach sequence is made up of activities - each of which has a particular function, either:
\n\nThese activities can include a range of individual tasks, small group work and whole class activities based on both content and collaboration.
\nWhen you use LAMS, not only are you creating a real lesson for your learners, you also create the plan for the lesson at the same time. We’ll talk about this Visual Authoring Environment in a few moments.
\nDolly is our LAMS mascot. Back when LAMS was being redesigned up to version 2.0, it was the "next-generation" of LAMS. Dolly the sheep was the first mammal to have been successfully cloned from an adult cell, therefore, she was the next generation LAMB (see what we did there?).
\nOur marvelous designer, Shelly is the official mother of Dolly and also our front page model. So all kudos to her!
\nLAMS has many, many more functions that you can explore as part of your lessons.
\nThe new release of version 2.1 includes increased functionality in many areas, some of which are explored in the rest of this Getting Started course.
\n\n
YouTube Videos\n \n | \n MP3 Files\n\n \n LAMS PODCAST with ALAN CARRINGTON (CLPD Adelaide Uni) | \n
It combines a Chat Activity with a Scribe Activity for collating the chat group\'s view on questions created by the teacher. When used in small group mode, the tool creates parallel Chat and Scribe areas for each small group, and then shows the outcome of each group collated on a whole class page.
\nThe Chat Activity runs a live (synchronous) discussion for learners.
\nThis is similar to Instant Messaging (IM) software that most learners will be familiar with.
Forums can be \'locked\' as an activity which is only available for the period of the specific activity (i.e.: no more contributions can be made once the learner clicks \'Finish\', or they can be \'unlocked\', in that learners can add to the Forum throughout the life of the whole sequence.
\nIt allows a group of Learners to collaborate and create a written report with one Learner as the \'Scribe,\' or Writer for the report. The activity is most effective when paired with another collaborative activity. In the current release of LAMS (2.0.4) Scribe is available to be paired with either Chat or Forum.
\nThe Scribe Activity should always used in conjunction with another activity that gives it context. For instance, if used with Chat, then the Scribe (one particular learner) is expected to collect or summarize the output of the Chat discussion into a succinct set of sentences. Once the scribe has done this, they publish the summary to the rest of the learners who vote whether they agree with the summary as proposed by the scribe. If not, they can ask the scribe to modify the report until all learners agree on the report.
\nOnce the Scribe submits the report, the other learners in the group or class can agree or disagree with the summary. The scribe can finished the scribe task at any time regardless of the number of learners that have agreed with the proposed summaries. The Scribe task can also be finished through the monitoring environment by a teacher or instructor.
\nOnce the scribe task is finished a report of the statements and summary is presented to all learners.
\nThe sequence Author can pen their own responses to each question, which are displayed to learners after they have submitted their own answers.
\nThe activity can also be configured to display answers collected from all learners in the sequence or group
\nThe Question and Answer Activity allows teachers to pose a question or questions to learners individually, and after they have entered their response, to see the responses of all their peers presented on a single answer screen.
\nThe Survey Tool is similar to Multiple Choice, in that it presents learners with a number of questions and collects their responses. However, unlike Multiple Choice there are no right or wrong answers - the system just collates all answers for analysis by the teacher in the monitoring area.
\nQuestion types include single response, multiple response and open text entry, and questions can be mandatory or optional. For multiple choice questions, Learners can also be provided with the option of adding their own answer to a list.
\nThe Voting Activity allows teachers to provide learners with a list of options to "Vote" on. It is similar to the Q&A Activity in that Voting shows first one screen with all the available voting options, then a screen showing the individual learner\'s selection, then a screen showing "progressive" voting results (i.e., a non-editable screen where learners can see results from themselves and other learners over time). Finally, there is Summary Screen of group results.
\n\n In Real Life\n | \n \n In Lams\n | \n
\n
| \n \n
| \n
\n In Real Life\n | \n \n In Lams\n | \n
\n
| \n \n
| \n