Index: unix_installer/installer-package/assembly/lams-session.jar =================================================================== diff -u -rc1718fd4c6b36e80a5feabb88b99fd65778f0d49 -rc6a8998567722aec174bb639b1fb4d81dece93d8 Binary files differ Index: unix_installer/installer-package/assembly/lams-valve.jar =================================================================== diff -u -rc1718fd4c6b36e80a5feabb88b99fd65778f0d49 -rc6a8998567722aec174bb639b1fb4d81dece93d8 Binary files differ Index: unix_installer/installer-package/bin/checkmysql.class =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rc6a8998567722aec174bb639b1fb4d81dece93d8 Binary files differ Index: unix_installer/installer-package/bin/run-lams.sh =================================================================== diff -u -re8455cad5a4c25a1ff9edb5e4637481a6e94d9d6 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/bin/run-lams.sh (.../run-lams.sh) (revision e8455cad5a4c25a1ff9edb5e4637481a6e94d9d6) +++ unix_installer/installer-package/bin/run-lams.sh (.../run-lams.sh) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -26,7 +26,7 @@ echo " " echo "LAMS will take a few minutes to startup..." echo " " -echo "Check server/defalt/log/boot.log and server/defalt/log/server.log to see if LAMS has started correctly. The server.log will contain a line similar to 'JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2 date=200505022023)] Started in 1m:6s:987ms' when LAMS has finished loading." +echo "Check server/default/log/boot.log and server/default/log/server.log to see if LAMS has started correctly. The server.log will contain a line similar to 'JBoss (MX MicroKernel) [4.0.2 (build: CVSTag=JBoss_4_0_2 date=200505022023)] Started in 1m:6s:987ms' when LAMS has finished loading." echo " " nohup ./run.sh > /dev/null & Index: unix_installer/installer-package/conf/unix/authentication/lamsauthentication.xml =================================================================== diff -u -re8455cad5a4c25a1ff9edb5e4637481a6e94d9d6 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/conf/unix/authentication/lamsauthentication.xml (.../lamsauthentication.xml) (revision e8455cad5a4c25a1ff9edb5e4637481a6e94d9d6) +++ unix_installer/installer-package/conf/unix/authentication/lamsauthentication.xml (.../lamsauthentication.xml) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -1,20 +1,28 @@ - + com.sun.jndi.ldap.LdapCtxFactory - ldap://mams.melcoe.mq.edu.au:636 + ldap://192.168.111.35 simple - ssl - uid= - ,ou=mams,dc=melcoe,dc=mq,dc=edu,dc=au - java:/MySqlDS + cn= + ,dc=melcoe,dc=local + java:/jdbc/lams-ds select password from lams_user where login=? - select name,'Roles' from lams_role, lams_user where login=? + + SELECT DISTINCT r.name,'Roles' FROM + lams_user u LEFT OUTER JOIN lams_user_organisation uo USING(user_id) + LEFT OUTER JOIN lams_user_organisation_role urr USING(user_organisation_id) + LEFT OUTER JOIN lams_role r USING (role_id) + WHERE u.login=? + + Index: unix_installer/installer-package/conf/unix/jboss/service/mysql-ds.xml =================================================================== diff -u -re8455cad5a4c25a1ff9edb5e4637481a6e94d9d6 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/conf/unix/jboss/service/mysql-ds.xml (.../mysql-ds.xml) (revision e8455cad5a4c25a1ff9edb5e4637481a6e94d9d6) +++ unix_installer/installer-package/conf/unix/jboss/service/mysql-ds.xml (.../mysql-ds.xml) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -9,7 +9,7 @@ jdbc/lams-ds - jdbc:mysql://localhost:3306/@DB_NAME@ + jdbc:mysql://@MYSQL_HOST@:3306/@DB_NAME@ com.mysql.jdbc.Driver @@ -29,7 +29,7 @@ jdbc/tool-ds - jdbc:mysql://localhost:3306/@DB_NAME@ + jdbc:mysql://@MYSQL_HOST@:3306/@DB_NAME@ com.mysql.jdbc.Driver @@ -49,7 +49,7 @@ jdbc/quartz-ds - jdbc:mysql://localhost:3306/@DB_NAME@ + jdbc:mysql://@MYSQL_HOST@:3306/@DB_NAME@ com.mysql.jdbc.Driver TRANSACTION_READ_COMMITTED Index: unix_installer/installer-package/database/create-database.sql =================================================================== diff -u --- unix_installer/installer-package/database/create-database.sql (revision 0) +++ unix_installer/installer-package/database/create-database.sql (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -0,0 +1,7 @@ +SET FOREIGN_KEY_CHECKS=0; +DROP DATABASE IF EXISTS lamstest; +CREATE DATABASE lamstest DEFAULT CHARACTER SET utf8; +SET FOREIGN_KEY_CHECKS=1; +GRANT ALL PRIVILEGES ON *.* TO lamsusertest@localhost IDENTIFIED BY 'lamsdemo'; +REVOKE PROCESS,SUPER ON *.* from lamsusertest@localhost; +USE lamstest; Index: unix_installer/installer-package/database/lams.dump =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/database/lams.dump (.../lams.dump) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/installer-package/database/lams.dump (.../lams.dump) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -1,6 +1,6 @@ -- MySQL dump 10.10 -- --- Host: localhost D +-- Host: localhost Database: lams -- ------------------------------------------------------ -- Server version 5.0.24a-Debian_9ubuntu0.1-log @@ -16,6 +16,14 @@ /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- +-- Current Database: `lams` +-- + +--CREATE DATABASE /*!32312 IF NOT EXISTS*/ `lams` /*!40100 DEFAULT CHARACTER SET utf8 */; + +--USE `lams`; + +-- -- Table structure for table `lams_activity_category` -- @@ -127,7 +135,7 @@ /*!40000 ALTER TABLE `lams_configuration` DISABLE KEYS */; LOCK TABLES `lams_configuration` WRITE; -INSERT INTO `lams_configuration` VALUES ('ServerURL','http://137.111.246.57:8080/lams/'),('Version','2.0.2'),('TempDir','/var/opt/lams/temp'),('DumpDir','/var/opt/lams/dump'),('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear'),('SMTPServer',''),('LamsSupportEmail','lams_support@melcoe.mq.edu.au'),('ContentRepositoryPath','/var/opt/lams/repository'),('UploadFileMaxSize','1048576'),('UploadLargeFileMaxSize','10485760'),('UploadFileMaxMemorySize','4096'),('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'),('UserInactiveTimeout','86400'),('UseCacheDebugListener','false'),('CleanupPreviewOlderThanDays','7'),('AuthoringActivitiesColour','true'),('AuthoringClientVersion','2.0.2.200705030401'),('MonitorClientVersion','2.0.2.200705030401'),('LearnerClientVersion','2.0.2.200705030401'),('ServerVersionNumber','2.0.2.200705030401'),('ServerLanguage','en_AU'),('ServerPageDirection','LTR'),('DictionaryDateCreated','2007-03-19'),('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'),('XmppDomain','shaun.melcoe.mq.edu.au'),('XmppConference','conference.shaun.melcoe.mq.edu.au'),('XmppAdmin','admin'),('XmppPassword','wildfire'),('DefaultFlashTheme','default'),('DefaultHTMLTheme','defaultHTML'),('AllowDirectLessonLaunch','false'),('LAMS_Community_enable','false'); +INSERT INTO `lams_configuration` VALUES ('ServerURL','http://shaun.melcoe.mq.edu.au/lams/'),('ServerURLContextPath','lams/'),('Version','2.0.4'),('TempDir','/var/opt/lams/temp'),('DumpDir','/var/opt/lams/dump'),('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear'),('SMTPServer',''),('LamsSupportEmail','lams_support@melcoe.mq.edu.au'),('ContentRepositoryPath','/var/opt/lams/repository'),('UploadFileMaxSize','1048576'),('UploadLargeFileMaxSize','10485760'),('UploadFileMaxMemorySize','4096'),('ExecutableExtensions','.bat,.bin,.com,.cmd,.exe,.msi,.msp,.ocx,.pif,.scr,.sct,.sh,.shs,.vbs'),('UserInactiveTimeout','86400'),('UseCacheDebugListener','false'),('CleanupPreviewOlderThanDays','7'),('AuthoringActivitiesColour','true'),('AuthoringClientVersion','2.0.4.200706211047'),('MonitorClientVersion','2.0.4.200706211047'),('LearnerClientVersion','2.0.4.200706211047'),('ServerVersionNumber','2.0.4.200706211047'),('ServerLanguage','en_AU'),('ServerPageDirection','LTR'),('DictionaryDateCreated','2007-06-01'),('HelpURL','http://wiki.lamsfoundation.org/display/lamsdocs/'),('XmppDomain','shaun.melcoe.mq.edu.au'),('XmppConference','conference.shaun.melcoe.mq.edu.au'),('XmppAdmin','admin'),('XmppPassword','wildfire'),('DefaultFlashTheme','default'),('DefaultHTMLTheme','defaultHTML'),('AllowDirectLessonLaunch','false'),('LAMS_Community_enable','false'),('AllowLiveEdit','true'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_configuration` ENABLE KEYS */; @@ -374,7 +382,7 @@ /*!40000 ALTER TABLE `lams_css_theme_ve` DISABLE KEYS */; LOCK TABLES `lams_css_theme_ve` WRITE; -INSERT INTO `lams_css_theme_ve` VALUES (1,'default','Default Flash style',NULL,1,NULL),(2,'defaultHTML','Default HTML style',NULL,1,'css'); +INSERT INTO `lams_css_theme_ve` VALUES (1,'default','Default Flash style',NULL,1,NULL),(2,'defaultHTML','Default HTML style',NULL,1,'css'),(3,'rams','RAMS Default Flash style',NULL,1,NULL),(4,'ramsthemeHTML','RAMS Default HTML sty;e',NULL,1,'ramsthemecss'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_css_theme_ve` ENABLE KEYS */; @@ -595,7 +603,7 @@ `user_id` bigint(20) NOT NULL, `lesson_id` bigint(20) NOT NULL, `lesson_completed_flag` tinyint(1) NOT NULL default '0', - `waiting_flag` tinyint(1) NOT NULL, + `waiting_flag` tinyint(4) NOT NULL, `start_date_time` datetime NOT NULL, `finish_date_time` datetime default NULL, `current_activity_id` bigint(20) default NULL, @@ -670,6 +678,8 @@ `library_activity_id` bigint(20) default NULL, `language_file` varchar(255) default NULL, `system_tool_id` bigint(20) default NULL, + `read_only` tinyint(4) default '0', + `initialised` tinyint(4) default '0', PRIMARY KEY (`activity_id`), KEY `learning_library_id` (`learning_library_id`), KEY `learning_design_id` (`learning_design_id`), @@ -704,7 +714,7 @@ /*!40000 ALTER TABLE `lams_learning_activity` DISABLE KEYS */; LOCK TABLES `lams_learning_activity` WRITE; -INSERT INTO `lams_learning_activity` VALUES (1,NULL,'Forum/Message Board','Forum','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,1,'2007-05-03 04:01:43',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),(2,NULL,'Displays a NoticeboardX','NoticeboardX','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,2,'2007-05-03 04:01:50',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),(3,NULL,'Allows creation and use of question and answer format','Question and Answer','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,3,'2007-05-03 04:01:55',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),(4,NULL,'Uploading of files by learners, for review by teachers.','Submit File','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,4,'2007-05-03 04:02:01',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),(5,NULL,'Chat Tool','Chat Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,5,'2007-05-03 04:02:12',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),(6,NULL,'Share Resources','Share Resources','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,6,'2007-05-03 04:02:23',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),(7,NULL,'Allows creation and use of voting format','Voting','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,7,'2007-05-03 04:02: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),(8,NULL,'Notebook Tool','Notebook Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,8,'2007-05-03 04:02:38',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),(9,NULL,'Survey','Survey','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,9,'2007-05-03 04:02:49',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),(10,NULL,'Scribe Tool','Scribe Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,10,'2007-05-03 04:02:59',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),(11,NULL,'Allows creation and use of multiple choice questioning format','Multiple Choice Questions','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,11,'2007-05-03 04:03:05',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),(12,NULL,'Combined Share Resources and Forum','Discuss Shared Resources','Learners to discuss items they have viewed via Share Resources.',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,12,'2007-05-03 04:03:07',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),(13,NULL,'Share Resources','Share Resources','Share Resources',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-05-03 04:03:07',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),(14,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-05-03 04:03:07',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),(15,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,13,'2007-05-03 04:03:08',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),(16,NULL,'Chat Tool','Chat Tool','Chat',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-05-03 04:03:08',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),(17,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-05-03 04:03:08',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),(18,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,14,'2007-05-03 04:03:10',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),(19,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-05-03 04:03:10',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),(20,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-05-03 04:03:10',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); +INSERT INTO `lams_learning_activity` VALUES (1,NULL,'Forum/Message Board','Forum','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,1,'2007-06-04 14:44:58',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0),(2,NULL,'Displays a NoticeboardX','NoticeboardX','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,2,'2007-06-04 14:45:09',0,NULL,NULL,NULL,2,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lanb11/images/icon_htmlnb.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.noticeboard.ApplicationResources',NULL,0,0),(3,NULL,'Allows creation and use of question and answer format','Question and Answer','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,3,'2007-06-04 14:45:14',0,NULL,NULL,NULL,3,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/laqa11/images/icon_questionanswer.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.qa.ApplicationResources',NULL,0,0),(4,NULL,'Uploading of files by learners, for review by teachers.','Submit File','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,4,'2007-06-04 14:45:21',0,NULL,NULL,NULL,4,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasbmt11/images/icon_reportsubmission.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.sbmt.ApplicationResources',NULL,0,0),(5,NULL,'Chat Tool','Chat Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,5,'2007-06-04 14:45:31',0,NULL,NULL,NULL,5,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lachat11/images/icon_chat.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.chat.ApplicationResources',NULL,0,0),(6,NULL,'Share Resources','Share Resources','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,6,'2007-06-04 14:45:42',0,NULL,NULL,NULL,6,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.rsrc.ApplicationResources',NULL,0,0),(7,NULL,'Allows creation and use of voting format','Voting','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,7,'2007-06-04 14:45:48',0,NULL,NULL,NULL,7,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lavote11/images/icon_ranking.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.vote.ApplicationResources',NULL,0,0),(8,NULL,'Notebook Tool','Notebook Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,8,'2007-06-04 14:45:57',0,NULL,NULL,NULL,8,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lantbk11/images/icon_notebook.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.notebook.ApplicationResources',NULL,0,0),(9,NULL,'Survey','Survey','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,9,'2007-06-04 14:46:08',0,NULL,NULL,NULL,9,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lasurv11/images/icon_survey.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.survey.ApplicationResources',NULL,0,0),(10,NULL,'Scribe Tool','Scribe Tool','Put some help text here.',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,10,'2007-06-04 14:46:19',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0),(11,NULL,'Allows creation and use of multiple choice questioning format','Multiple Choice Questions','Help text',NULL,NULL,NULL,NULL,1,2,0,NULL,NULL,NULL,0,NULL,11,'2007-06-04 14:46:24',0,NULL,NULL,NULL,11,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lamc11/images/icon_mcq.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.mc.ApplicationResources',NULL,0,0),(12,NULL,'Combined Share Resources and Forum','Discuss Shared Resources','Learners to discuss items they have viewed via Share Resources.',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,12,'2007-06-04 14:46:26',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_urlcontentmessageboard.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid12.ApplicationResources',NULL,0,0),(13,NULL,'Share Resources','Share Resources','Share Resources',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:26',0,NULL,NULL,NULL,6,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,'tool/larsrc11/images/icon_rsrc.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.rsrc.ApplicationResources',NULL,0,0),(14,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,12,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:26',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0),(15,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,13,'2007-06-04 14:46:28',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_groupreporting.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid13.ApplicationResources',NULL,0,0),(16,NULL,'Chat Tool','Chat Tool','Chat',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:28',0,NULL,NULL,NULL,5,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lachat11/images/icon_chat.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.chat.ApplicationResources',NULL,0,0),(17,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,15,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:28',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0),(18,NULL,'Combined Chat and Scribe','Prepare Group Report','Learners to prepare group report, discussing report in chat',NULL,NULL,NULL,NULL,6,2,0,NULL,NULL,NULL,0,NULL,14,'2007-06-04 14:46:29',0,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,'images/icon_forum_and_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.library.llid14.ApplicationResources',NULL,0,0),(19,NULL,'Forum/Message Board','Forum','Forum/Message Board',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:29',0,NULL,NULL,NULL,1,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lafrum11/images/icon_forum.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.forum.ApplicationResources',NULL,0,0),(20,NULL,'Scribe Tool','Scribe Tool','Scribe',NULL,NULL,18,NULL,1,2,0,NULL,NULL,NULL,0,NULL,NULL,'2007-06-04 14:46:29',0,NULL,NULL,NULL,10,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,'tool/lascrb11/images/icon_scribe.swf',NULL,NULL,NULL,'org.lamsfoundation.lams.tool.scribe.ApplicationResources',NULL,0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_learning_activity` ENABLE KEYS */; @@ -726,7 +736,7 @@ /*!40000 ALTER TABLE `lams_learning_activity_type` DISABLE KEYS */; LOCK TABLES `lams_learning_activity_type` WRITE; -INSERT INTO `lams_learning_activity_type` VALUES (1,'TOOL'),(2,'GROUPING'),(3,'GATE_SYNCH'),(4,'GATE_SCHEDULE'),(5,'GATE_PERMISSION'),(6,'PARALLEL'),(7,'OPTIONS'),(8,'SEQUENCE'); +INSERT INTO `lams_learning_activity_type` VALUES (1,'TOOL'),(2,'GROUPING'),(3,'GATE_SYNCH'),(4,'GATE_SCHEDULE'),(5,'GATE_PERMISSION'),(6,'PARALLEL'),(7,'OPTIONS'),(8,'SEQUENCE'),(9,'GATE_SYSTEM'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_learning_activity_type` ENABLE KEYS */; @@ -759,17 +769,22 @@ `license_text` text, `last_modified_date_time` datetime default NULL, `content_folder_id` varchar(32) default NULL, + `edit_override_lock` tinyint(4) default '0', + `edit_override_user_id` bigint(20) default NULL, + `design_version` int(11) default '1', PRIMARY KEY (`learning_design_id`), KEY `user_id` (`user_id`), KEY `workspace_folder_id` (`workspace_folder_id`), KEY `license_id` (`license_id`), KEY `copy_type_id` (`copy_type_id`), + KEY `edit_override_user_id` (`edit_override_user_id`), KEY `idx_design_parent_id` (`original_learning_design_id`), KEY `idx_design_first_act` (`first_activity_id`), CONSTRAINT `FK_lams_learning_design_3` FOREIGN KEY (`user_id`) REFERENCES `lams_user` (`user_id`), CONSTRAINT `FK_lams_learning_design_4` FOREIGN KEY (`workspace_folder_id`) REFERENCES `lams_workspace_folder` (`workspace_folder_id`), 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_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; -- @@ -803,7 +818,7 @@ /*!40000 ALTER TABLE `lams_learning_library` DISABLE KEYS */; LOCK TABLES `lams_learning_library` WRITE; -INSERT INTO `lams_learning_library` VALUES (1,'Forum, also known Message Board','Forum',1,'2007-05-03 04:01:43'),(2,'Displays a Noticeboard','Noticeboard',1,'2007-05-03 04:01:50'),(3,'Question and Answer Learning Library Description','Question and Answer',1,'2007-05-03 04:01:55'),(4,'Uploading of files by learners, for review by teachers.','Submit file',1,'2007-05-03 04:02:01'),(5,'Chat Tool','Chat',1,'2007-05-03 04:02:12'),(6,'Share resources','Share resources',1,'2007-05-03 04:02:23'),(7,'Voting Learning Library Description','Voting',1,'2007-05-03 04:02:29'),(8,'Notebook Tool','Notebook',1,'2007-05-03 04:02:38'),(9,'Survey','Survey',1,'2007-05-03 04:02:49'),(10,'Scribe Tool','Scribe',0,'2007-05-03 04:02:59'),(11,'MCQ Learning Library Description','MCQ',1,'2007-05-03 04:03:04'),(12,'Shared Resources and Forum','Resources and Forum',1,'2007-05-03 04:03:07'),(13,'Chat and Scribe','Chat and Scribe',1,'2007-05-03 04:03:08'),(14,'Forum and Scribe','Forum and Scribe',1,'2007-05-03 04:03:10'); +INSERT INTO `lams_learning_library` VALUES (1,'Forum, also known Message Board','Forum',1,'2007-06-04 14:44:58'),(2,'Displays a Noticeboard','Noticeboard',1,'2007-06-04 14:45:09'),(3,'Question and Answer Learning Library Description','Question and Answer',1,'2007-06-04 14:45:14'),(4,'Uploading of files by learners, for review by teachers.','Submit file',1,'2007-06-04 14:45:21'),(5,'Chat Tool','Chat',1,'2007-06-04 14:45:31'),(6,'Share resources','Share resources',1,'2007-06-04 14:45:42'),(7,'Voting Learning Library Description','Voting',1,'2007-06-04 14:45:48'),(8,'Notebook Tool','Notebook',1,'2007-06-04 14:45:57'),(9,'Survey','Survey',1,'2007-06-04 14:46:08'),(10,'Scribe Tool','Scribe',0,'2007-06-04 14:46:19'),(11,'MCQ Learning Library Description','MCQ',1,'2007-06-04 14:46:24'),(12,'Shared Resources and Forum','Resources and Forum',1,'2007-06-04 14:46:26'),(13,'Chat and Scribe','Chat and Scribe',1,'2007-06-04 14:46:28'),(14,'Forum and Scribe','Forum and Scribe',1,'2007-06-04 14:46:29'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_learning_library` ENABLE KEYS */; @@ -824,6 +839,7 @@ `to_ui_id` int(11) default NULL, `from_ui_id` int(11) default NULL, PRIMARY KEY (`transition_id`), + UNIQUE KEY `UQ_transition_activities` (`from_activity_id`,`to_activity_id`), KEY `from_activity_id` (`from_activity_id`), KEY `to_activity_id` (`to_activity_id`), KEY `learning_design_id` (`learning_design_id`), @@ -862,7 +878,9 @@ `end_date_time` datetime default NULL, `schedule_end_date_time` datetime default NULL, `previous_state_id` int(3) default NULL, - `learner_exportport_avail` tinyint(1) default NULL, + `learner_exportport_avail` tinyint(1) default '1', + `locked_for_edit` tinyint(4) default '0', + `version` int(11) default '1', PRIMARY KEY (`lesson_id`), KEY `learning_design_id` (`learning_design_id`), KEY `user_id` (`user_id`), @@ -1075,7 +1093,7 @@ /*!40000 ALTER TABLE `lams_organisation` DISABLE KEYS */; LOCK TABLES `lams_organisation` WRITE; -INSERT INTO `lams_organisation` VALUES (1,'Root',NULL,'Root Organisation',NULL,1,'2007-05-03 04:01:31',1,1,1,0,0,0,0,1,NULL),(2,'Playpen','PP101','Developers Playpen',1,2,'2007-05-03 04:01:31',1,2,1,0,0,0,0,1,NULL),(3,'Everybody',NULL,'All People In Course',2,3,'2007-05-03 04:01:31',1,NULL,1,0,0,0,0,1,NULL),(4,'Mathematics 1','MATH111','Mathematics 1',1,2,'2007-05-03 04:01:31',1,3,1,0,0,0,0,2,NULL),(5,'Tutorial Group A','TUTA','Tutorial Group A',4,3,'2007-05-03 04:01:31',1,NULL,1,0,0,0,0,2,NULL),(6,'Tutorial Group B','TUTB','Tutorial Group B',4,3,'2007-05-03 04:01:31',1,NULL,1,0,0,0,0,2,NULL),(7,'Moodle','Moodle','Moodle Test',1,2,'2007-05-03 04:01:31',1,50,2,0,0,0,0,1,NULL); +INSERT INTO `lams_organisation` VALUES (1,'Root',NULL,'Root Organisation',NULL,1,'2007-06-04 14:44:48',1,1,1,0,0,0,0,1,NULL),(2,'Playpen','PP101','Developers Playpen',1,2,'2007-06-04 14:44:48',1,2,1,0,0,0,0,1,NULL),(3,'Everybody',NULL,'All People In Course',2,3,'2007-06-04 14:44:48',1,NULL,1,0,0,0,0,1,NULL),(4,'Mathematics 1','MATH111','Mathematics 1',1,2,'2007-06-04 14:44:48',1,3,1,0,0,0,0,2,NULL),(5,'Tutorial Group A','TUTA','Tutorial Group A',4,3,'2007-06-04 14:44:48',1,NULL,1,0,0,0,0,2,NULL),(6,'Tutorial Group B','TUTB','Tutorial Group B',4,3,'2007-06-04 14:44:48',1,NULL,1,0,0,0,0,2,NULL),(7,'Moodle','Moodle','Moodle Test',1,2,'2007-06-04 14:44:48',1,50,2,0,0,0,0,1,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_organisation` ENABLE KEYS */; @@ -1511,7 +1529,7 @@ /*!40000 ALTER TABLE `lams_role` DISABLE KEYS */; LOCK TABLES `lams_role` WRITE; -INSERT INTO `lams_role` VALUES (1,'SYSADMIN','LAMS System Adminstrator','2007-05-03 04:01:31'),(2,'GROUP MANAGER','Group Manager','2007-05-03 04:01:31'),(3,'AUTHOR','Authors Learning Designs','2007-05-03 04:01:31'),(4,'MONITOR','Member of Staff','2007-05-03 04:01:31'),(5,'LEARNER','Student','2007-05-03 04:01:31'),(6,'GROUP ADMIN','Group Administrator','2007-05-03 04:01:31'),(7,'AUTHOR ADMIN','Author Administrator','2007-05-03 04:01:31'); +INSERT INTO `lams_role` VALUES (1,'SYSADMIN','LAMS System Adminstrator','2007-06-04 14:44:48'),(2,'GROUP MANAGER','Group Manager','2007-06-04 14:44:48'),(3,'AUTHOR','Authors Learning Designs','2007-06-04 14:44:48'),(4,'MONITOR','Member of Staff','2007-06-04 14:44:48'),(5,'LEARNER','Student','2007-06-04 14:44:48'),(6,'GROUP ADMIN','Group Administrator','2007-06-04 14:44:48'),(7,'AUTHOR ADMIN','Author Administrator','2007-06-04 14:44:48'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_role` ENABLE KEYS */; @@ -1599,7 +1617,7 @@ /*!40000 ALTER TABLE `lams_system_tool` DISABLE KEYS */; LOCK TABLES `lams_system_tool` WRITE; -INSERT INTO `lams_system_tool` VALUES (1,2,'Grouping','All types of grouping including random and chosen.','learning/grouping.do?method=performGrouping','learning/grouping.do?method=performGrouping','learning/grouping.do?method=viewGrouping&mode=teacher','learning/groupingExportPortfolio?mode=learner','learning/groupingExportPortfolio?mode=teacher','monitoring/grouping.do?method=startGrouping','monitoring/grouping.do?method=startGrouping',NULL,'2007-05-03 04:01:31'),(2,3,'Sync Gate','Gate: Synchronise Learners.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-05-03 04:01:31'),(3,4,'Schedule Gate','Gate: Opens/shuts at particular times.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-05-03 04:01:31'),(4,5,'Permission Gate','Gate: Opens under teacher or staff control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-05-03 04:01:31'); +INSERT INTO `lams_system_tool` VALUES (1,2,'Grouping','All types of grouping including random and chosen.','learning/grouping.do?method=performGrouping','learning/grouping.do?method=performGrouping','learning/grouping.do?method=viewGrouping&mode=teacher','learning/groupingExportPortfolio?mode=learner','learning/groupingExportPortfolio?mode=teacher','monitoring/grouping.do?method=startGrouping','monitoring/grouping.do?method=startGrouping',NULL,'2007-06-04 14:44:48'),(2,3,'Sync Gate','Gate: Synchronise Learners.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'),(3,4,'Schedule Gate','Gate: Opens/shuts at particular times.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'),(4,5,'Permission Gate','Gate: Opens under teacher or staff control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'),(5,9,'System Gate','Gate: Opens under system control.','learning/gate.do?method=knockGate','learning/gate.do?method=knockGate',NULL,NULL,'monitoring/gateExportPortfolio?mode=teacher','monitoring/gate.do?method=viewGate','monitoring/gate.do?method=viewGate',NULL,'2007-06-04 14:44:48'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_system_tool` ENABLE KEYS */; @@ -1653,7 +1671,7 @@ /*!40000 ALTER TABLE `lams_tool` DISABLE KEYS */; LOCK TABLES `lams_tool` WRITE; -INSERT INTO `lams_tool` VALUES (1,'lafrum11','forumService','Forum','Forum / Message Boards','forum','20070227',1,1,1,2,1,'tool/lafrum11/learning/viewForum.do?mode=learner','tool/lafrum11/learning/viewForum.do?mode=author','tool/lafrum11/learning/viewForum.do?mode=teacher','tool/lafrum11/authoring.do','tool/lafrum11/defineLater.do','tool/lafrum11/exportPortfolio?mode=learner','tool/lafrum11/exportPortfolio?mode=teacher','tool/lafrum11/monitoring.do','tool/lafrum11/contribute.do','tool/lafrum11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lafrum11','2007-05-03 04:01:43','org.lamsfoundation.lams.tool.forum.ApplicationResources','2007-05-03 04:01:43','lams-tool-lafrum11.jar','/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml'),(2,'lanb11','nbService','NoticeboardX','Displays a NoticeboardX','nb','20070315',2,2,1,2,1,'tool/lanb11/starter/learner.do?mode=learner','tool/lanb11/starter/learner.do?mode=author','tool/lanb11/starter/learner.do?mode=teacher','tool/lanb11/authoring.do','tool/lanb11/authoring.do?defineLater=true','tool/lanb11/portfolioExport?mode=learner','tool/lanb11/portfolioExport?mode=teacher','tool/lanb11/monitoring.do',NULL,NULL,'http://wiki.lamsfoundation.org/display/lamsdocs/lanb11','2007-05-03 04:01:50','org.lamsfoundation.lams.tool.noticeboard.ApplicationResources','2007-05-03 04:01:50','lams-tool-lanb11.jar','/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml'),(3,'laqa11','qaService','Question and Answer','Q/A Tool','qa','20070214',3,3,1,2,1,'tool/laqa11/learningStarter.do?mode=learner','tool/laqa11/learningStarter.do?mode=author','tool/laqa11/learningStarter.do?mode=teacher','tool/laqa11/authoringStarter.do','tool/laqa11/defineLaterStarter.do','tool/laqa11/exportPortfolio?mode=learner','tool/laqa11/exportPortfolio?mode=teacher','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/laqa11','2007-05-03 04:01:55','org.lamsfoundation.lams.tool.qa.ApplicationResources','2007-05-03 04:01:55','lams-tool-laqa11.jar','/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml'),(4,'lasbmt11','submitFilesService','Submit File','Submit File Tool Description','submitfile','20070227',4,4,1,2,1,'tool/lasbmt11/learner.do?mode=learner','tool/lasbmt11/learner.do?mode=author','tool/lasbmt11/learner.do?mode=teacher','tool/lasbmt11/authoring.do','tool/lasbmt11/definelater.do?mode=teacher','tool/lasbmt11/exportPortfolio?mode=learner','tool/lasbmt11/exportPortfolio?mode=teacher','tool/lasbmt11/monitoring.do','tool/lasbmt11/contribute.do','tool/lasbmt11/moderation.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasbmt11','2007-05-03 04:02:01','org.lamsfoundation.lams.tool.sbmt.ApplicationResources','2007-05-03 04:02:01','lams-tool-lasbmt11.jar','/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml'),(5,'lachat11','chatService','Chat','Chat','chat','20070315',5,5,1,2,1,'tool/lachat11/learning.do?mode=learner','tool/lachat11/learning.do?mode=author','tool/lachat11/learning.do?mode=teacher','tool/lachat11/authoring.do','tool/lachat11/authoring.do?mode=teacher','tool/lachat11/exportPortfolio?mode=learner','tool/lachat11/exportPortfolio?mode=teacher','tool/lachat11/monitoring.do','tool/lachat11/contribute.do','tool/lachat11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lachat11','2007-05-03 04:02:12','org.lamsfoundation.lams.tool.chat.ApplicationResources','2007-05-03 04:02:12','lams-tool-lachat11.jar','/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml'),(6,'larsrc11','resourceService','Shared Resources','Shared Resources','sharedresources','20070227',6,6,1,2,1,'tool/larsrc11/learning/start.do?mode=learner','tool/larsrc11/learning/start.do?mode=author','tool/larsrc11/learning/start.do?mode=teacher','tool/larsrc11/authoring/start.do','tool/larsrc11/definelater.do','tool/larsrc11/exportPortfolio?mode=learner','tool/larsrc11/exportPortfolio?mode=teacher','tool/larsrc11/monitoring/summary.do','tool/larsrc11/contribute.do','tool/larsrc11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/larsrc11','2007-05-03 04:02:23','org.lamsfoundation.lams.tool.rsrc.ApplicationResources','2007-05-03 04:02:23','lams-tool-larsrc11.jar','/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml'),(7,'lavote11','voteService','Voting','Voting','vote','20070214',7,7,1,2,1,'tool/lavote11/learningStarter.do?mode=learner','tool/lavote11/learningStarter.do?mode=author','tool/lavote11/learningStarter.do?mode=teacher','tool/lavote11/authoringStarter.do','tool/lavote11/defineLaterStarter.do','tool/lavote11/exportPortfolio?mode=learner','tool/lavote11/exportPortfolio?mode=teacher','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lavote11','2007-05-03 04:02:29','org.lamsfoundation.lams.tool.vote.ApplicationResources','2007-05-03 04:02:29','lams-tool-lavote11.jar','/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml'),(8,'lantbk11','notebookService','Notebook','Notebook','notebook','20070227',8,8,1,2,1,'tool/lantbk11/learning.do?mode=learner','tool/lantbk11/learning.do?mode=author','tool/lantbk11/learning.do?mode=teacher','tool/lantbk11/authoring.do','tool/lantbk11/authoring.do?mode=teacher','tool/lantbk11/exportPortfolio?mode=learner','tool/lantbk11/exportPortfolio?mode=teacher','tool/lantbk11/monitoring.do','tool/lantbk11/contribute.do','tool/lantbk11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lantbk11','2007-05-03 04:02:38','org.lamsfoundation.lams.tool.notebook.ApplicationResources','2007-05-03 04:02:38','lams-tool-lantbk11.jar','/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml'),(9,'lasurv11','lasurvSurveyService','Survey','Survey','survey','20070220',9,9,1,2,1,'tool/lasurv11/learning/start.do?mode=learner','tool/lasurv11/learning/start.do?mode=author','tool/lasurv11/learning/start.do?mode=teacher','tool/lasurv11/authoring/start.do','tool/lasurv11/definelater.do','tool/lasurv11/exportPortfolio?mode=learner','tool/lasurv11/exportPortfolio?mode=teacher','tool/lasurv11/monitoring/summary.do','tool/lasurv11/contribute.do','tool/lasurv11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasurv11','2007-05-03 04:02:49','org.lamsfoundation.lams.tool.survey.ApplicationResources','2007-05-03 04:02:49','lams-tool-lasurv11.jar','/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml'),(10,'lascrb11','lascrbScribeService','Scribe','Scribe','scribe','20070315',10,10,1,2,1,'tool/lascrb11/learning.do?mode=learner','tool/lascrb11/learning.do?mode=author','tool/lascrb11/learning.do?mode=teacher','tool/lascrb11/authoring.do','tool/lascrb11/authoring.do?mode=teacher','tool/lascrb11/exportPortfolio?mode=learner','tool/lascrb11/exportPortfolio?mode=teacher','tool/lascrb11/monitoring.do','tool/lascrb11/contribute.do','tool/lascrb11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lascrb11','2007-05-03 04:02:59','org.lamsfoundation.lams.tool.scribe.ApplicationResources','2007-05-03 04:02:59','lams-tool-lascrb11.jar','/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml'),(11,'lamc11','mcService','MCQ','Multiple Choice Questions','mc','20070214',11,11,1,2,1,'tool/lamc11/learningStarter.do?mode=learner','tool/lamc11/learningStarter.do?mode=author','tool/lamc11/learningStarter.do?mode=teacher','tool/lamc11/authoringStarter.do','tool/lamc11/defineLaterStarter.do','tool/lamc11/exportPortfolio?mode=learner','tool/lamc11/exportPortfolio?mode=teacher','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lamc11','2007-05-03 04:03:04','org.lamsfoundation.lams.tool.mc.ApplicationResources','2007-05-03 04:03:04','lams-tool-lamc11.jar','/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml'); +INSERT INTO `lams_tool` VALUES (1,'lafrum11','forumService','Forum','Forum / Message Boards','forum','20070524',1,1,1,2,1,'tool/lafrum11/learning/viewForum.do?mode=learner','tool/lafrum11/learning/viewForum.do?mode=author','tool/lafrum11/learning/viewForum.do?mode=teacher','tool/lafrum11/authoring.do','tool/lafrum11/defineLater.do','tool/lafrum11/exportPortfolio?mode=learner','tool/lafrum11/exportPortfolio?mode=teacher','tool/lafrum11/monitoring.do','tool/lafrum11/contribute.do','tool/lafrum11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lafrum11','2007-06-04 14:44:58','org.lamsfoundation.lams.tool.forum.ApplicationResources','2007-06-04 14:44:58','lams-tool-lafrum11.jar','/org/lamsfoundation/lams/tool/forum/forumApplicationContext.xml'),(2,'lanb11','nbService','NoticeboardX','Displays a NoticeboardX','nb','20070524',2,2,1,2,1,'tool/lanb11/starter/learner.do?mode=learner','tool/lanb11/starter/learner.do?mode=author','tool/lanb11/starter/learner.do?mode=teacher','tool/lanb11/authoring.do','tool/lanb11/authoring.do?defineLater=true','tool/lanb11/portfolioExport?mode=learner','tool/lanb11/portfolioExport?mode=teacher','tool/lanb11/monitoring.do',NULL,NULL,'http://wiki.lamsfoundation.org/display/lamsdocs/lanb11','2007-06-04 14:45:09','org.lamsfoundation.lams.tool.noticeboard.ApplicationResources','2007-06-04 14:45:09','lams-tool-lanb11.jar','/org/lamsfoundation/lams/tool/noticeboard/applicationContext.xml'),(3,'laqa11','qaService','Question and Answer','Q/A Tool','qa','20070524',3,3,1,2,1,'tool/laqa11/learningStarter.do?mode=learner','tool/laqa11/learningStarter.do?mode=author','tool/laqa11/learningStarter.do?mode=teacher','tool/laqa11/authoringStarter.do','tool/laqa11/defineLaterStarter.do','tool/laqa11/exportPortfolio?mode=learner','tool/laqa11/exportPortfolio?mode=teacher','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','tool/laqa11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/laqa11','2007-06-04 14:45:14','org.lamsfoundation.lams.tool.qa.ApplicationResources','2007-06-04 14:45:14','lams-tool-laqa11.jar','/org/lamsfoundation/lams/tool/qa/qaApplicationContext.xml'),(4,'lasbmt11','submitFilesService','Submit File','Submit File Tool Description','submitfile','20070524',4,4,1,2,1,'tool/lasbmt11/learner.do?mode=learner','tool/lasbmt11/learner.do?mode=author','tool/lasbmt11/learner.do?mode=teacher','tool/lasbmt11/authoring.do','tool/lasbmt11/definelater.do?mode=teacher','tool/lasbmt11/exportPortfolio?mode=learner','tool/lasbmt11/exportPortfolio?mode=teacher','tool/lasbmt11/monitoring.do','tool/lasbmt11/contribute.do','tool/lasbmt11/moderation.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasbmt11','2007-06-04 14:45:21','org.lamsfoundation.lams.tool.sbmt.ApplicationResources','2007-06-04 14:45:21','lams-tool-lasbmt11.jar','/org/lamsfoundation/lams/tool/sbmt/submitFilesApplicationContext.xml'),(5,'lachat11','chatService','Chat','Chat','chat','20070524',5,5,1,2,1,'tool/lachat11/learning.do?mode=learner','tool/lachat11/learning.do?mode=author','tool/lachat11/learning.do?mode=teacher','tool/lachat11/authoring.do','tool/lachat11/authoring.do?mode=teacher','tool/lachat11/exportPortfolio?mode=learner','tool/lachat11/exportPortfolio?mode=teacher','tool/lachat11/monitoring.do','tool/lachat11/contribute.do','tool/lachat11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lachat11','2007-06-04 14:45:31','org.lamsfoundation.lams.tool.chat.ApplicationResources','2007-06-04 14:45:31','lams-tool-lachat11.jar','/org/lamsfoundation/lams/tool/chat/chatApplicationContext.xml'),(6,'larsrc11','resourceService','Shared Resources','Shared Resources','sharedresources','20070524',6,6,1,2,1,'tool/larsrc11/learning/start.do?mode=learner','tool/larsrc11/learning/start.do?mode=author','tool/larsrc11/learning/start.do?mode=teacher','tool/larsrc11/authoring/start.do','tool/larsrc11/definelater.do','tool/larsrc11/exportPortfolio?mode=learner','tool/larsrc11/exportPortfolio?mode=teacher','tool/larsrc11/monitoring/summary.do','tool/larsrc11/contribute.do','tool/larsrc11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/larsrc11','2007-06-04 14:45:42','org.lamsfoundation.lams.tool.rsrc.ApplicationResources','2007-06-04 14:45:42','lams-tool-larsrc11.jar','/org/lamsfoundation/lams/tool/rsrc/rsrcApplicationContext.xml'),(7,'lavote11','voteService','Voting','Voting','vote','20070524',7,7,1,2,1,'tool/lavote11/learningStarter.do?mode=learner','tool/lavote11/learningStarter.do?mode=author','tool/lavote11/learningStarter.do?mode=teacher','tool/lavote11/authoringStarter.do','tool/lavote11/defineLaterStarter.do','tool/lavote11/exportPortfolio?mode=learner','tool/lavote11/exportPortfolio?mode=teacher','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','tool/lavote11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lavote11','2007-06-04 14:45:48','org.lamsfoundation.lams.tool.vote.ApplicationResources','2007-06-04 14:45:48','lams-tool-lavote11.jar','/org/lamsfoundation/lams/tool/vote/voteApplicationContext.xml'),(8,'lantbk11','notebookService','Notebook','Notebook','notebook','20070524',8,8,1,2,1,'tool/lantbk11/learning.do?mode=learner','tool/lantbk11/learning.do?mode=author','tool/lantbk11/learning.do?mode=teacher','tool/lantbk11/authoring.do','tool/lantbk11/authoring.do?mode=teacher','tool/lantbk11/exportPortfolio?mode=learner','tool/lantbk11/exportPortfolio?mode=teacher','tool/lantbk11/monitoring.do','tool/lantbk11/contribute.do','tool/lantbk11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lantbk11','2007-06-04 14:45:57','org.lamsfoundation.lams.tool.notebook.ApplicationResources','2007-06-04 14:45:57','lams-tool-lantbk11.jar','/org/lamsfoundation/lams/tool/notebook/notebookApplicationContext.xml'),(9,'lasurv11','lasurvSurveyService','Survey','Survey','survey','20070524',9,9,1,2,1,'tool/lasurv11/learning/start.do?mode=learner','tool/lasurv11/learning/start.do?mode=author','tool/lasurv11/learning/start.do?mode=teacher','tool/lasurv11/authoring/start.do','tool/lasurv11/definelater.do','tool/lasurv11/exportPortfolio?mode=learner','tool/lasurv11/exportPortfolio?mode=teacher','tool/lasurv11/monitoring/summary.do','tool/lasurv11/contribute.do','tool/lasurv11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lasurv11','2007-06-04 14:46:08','org.lamsfoundation.lams.tool.survey.ApplicationResources','2007-06-04 14:46:08','lams-tool-lasurv11.jar','/org/lamsfoundation/lams/tool/survey/surveyApplicationContext.xml'),(10,'lascrb11','lascrbScribeService','Scribe','Scribe','scribe','20070524',10,10,1,2,1,'tool/lascrb11/learning.do?mode=learner','tool/lascrb11/learning.do?mode=author','tool/lascrb11/learning.do?mode=teacher','tool/lascrb11/authoring.do','tool/lascrb11/authoring.do?mode=teacher','tool/lascrb11/exportPortfolio?mode=learner','tool/lascrb11/exportPortfolio?mode=teacher','tool/lascrb11/monitoring.do','tool/lascrb11/contribute.do','tool/lascrb11/moderate.do','http://wiki.lamsfoundation.org/display/lamsdocs/lascrb11','2007-06-04 14:46:19','org.lamsfoundation.lams.tool.scribe.ApplicationResources','2007-06-04 14:46:19','lams-tool-lascrb11.jar','/org/lamsfoundation/lams/tool/scribe/scribeApplicationContext.xml'),(11,'lamc11','mcService','MCQ','Multiple Choice Questions','mc','20070524',11,11,1,2,1,'tool/lamc11/learningStarter.do?mode=learner','tool/lamc11/learningStarter.do?mode=author','tool/lamc11/learningStarter.do?mode=teacher','tool/lamc11/authoringStarter.do','tool/lamc11/defineLaterStarter.do','tool/lamc11/exportPortfolio?mode=learner','tool/lamc11/exportPortfolio?mode=teacher','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','tool/lamc11/monitoringStarter.do','http://wiki.lamsfoundation.org/display/lamsdocs/lamc11','2007-06-04 14:46:24','org.lamsfoundation.lams.tool.mc.ApplicationResources','2007-06-04 14:46:24','lams-tool-lamc11.jar','/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml'); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_tool` ENABLE KEYS */; @@ -1844,7 +1862,7 @@ /*!40000 ALTER TABLE `lams_user` DISABLE KEYS */; LOCK TABLES `lams_user` WRITE; -INSERT INTO `lams_user` VALUES (1,'sysadmin','a159b7ae81ba3552af61e9731b20870515944538','The','System','Administrator',NULL,NULL,NULL,'Sydney','NSW',NULL,'Australia',NULL,NULL,NULL,NULL,'sysadmin@x.x',0,'2007-05-03 04:01:31',1,51,1,2,NULL,1,NULL,0),(5,'test1','b444ac06613fc8d63795be9ad0beaf55011936ac','Dr','One','Test','1','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test1@xx.os',0,'2004-12-23 00:00:00',1,5,1,2,NULL,1,NULL,0),(6,'test2','109f4b3c50d7b0df729d299bc6f8e9ef9066971f','Dr','Two','Test','2','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test2@xx.os',0,'2004-12-23 00:00:00',1,6,1,2,NULL,1,NULL,0),(7,'test3','3ebfa301dc59196f18593c45e519287a23297589','Dr','Three','Test','3','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test3@xx.os',0,'2004-12-23 00:00:00',1,7,1,2,NULL,1,NULL,0),(8,'test4','1ff2b3704aede04eecb51e50ca698efd50a1379b','Dr','Four','Test','4','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test4@xx.os',0,'2004-12-23 00:00:00',1,8,1,2,NULL,1,NULL,0); +INSERT INTO `lams_user` VALUES (1,'sysadmin','a159b7ae81ba3552af61e9731b20870515944538','The','System','Administrator',NULL,NULL,NULL,'Sydney','NSW',NULL,'Australia',NULL,NULL,NULL,NULL,'sysadmin@x.x',0,'2007-06-04 14:44:48',1,51,1,2,NULL,1,NULL,0),(5,'test1','b444ac06613fc8d63795be9ad0beaf55011936ac','Dr','One','Test','1','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test1@xx.os',0,'2004-12-23 00:00:00',1,5,1,2,NULL,1,NULL,0),(6,'test2','109f4b3c50d7b0df729d299bc6f8e9ef9066971f','Dr','Two','Test','2','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test2@xx.os',0,'2004-12-23 00:00:00',1,6,1,2,NULL,1,NULL,0),(7,'test3','3ebfa301dc59196f18593c45e519287a23297589','Dr','Three','Test','3','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test3@xx.os',0,'2004-12-23 00:00:00',1,7,1,2,NULL,1,NULL,0),(8,'test4','1ff2b3704aede04eecb51e50ca698efd50a1379b','Dr','Four','Test','4','Test Ave',NULL,'Nowhere','NSW',NULL,'Australia','0211111111','0211111112','0411111111','0211111113','test4@xx.os',0,'2004-12-23 00:00:00',1,8,1,2,NULL,1,NULL,0); UNLOCK TABLES; /*!40000 ALTER TABLE `lams_user` ENABLE KEYS */; @@ -2106,9 +2124,8 @@ `create_date` datetime default NULL, `chat_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK9ED6CB2E1A3926E3` (`chat_uid`), - CONSTRAINT `FK9ED6CB2E1A3926E3` FOREIGN KEY (`chat_uid`) REFERENCES `tl_lachat11_chat` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + KEY `FK9ED6CB2E1A3926E3` (`chat_uid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_attachment` @@ -2144,7 +2161,7 @@ `filtering_enabled` bit(1) default NULL, `filter_keywords` text, PRIMARY KEY (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_chat` @@ -2174,11 +2191,8 @@ PRIMARY KEY (`uid`), KEY `FKCC08C1DC2AF61E05` (`to_user_uid`), KEY `FKCC08C1DC9C8469FC` (`chat_session_uid`), - KEY `FKCC08C1DCCF3BF9B6` (`from_user_uid`), - CONSTRAINT `FKCC08C1DCCF3BF9B6` FOREIGN KEY (`from_user_uid`) REFERENCES `tl_lachat11_user` (`uid`), - CONSTRAINT `FKCC08C1DC2AF61E05` FOREIGN KEY (`to_user_uid`) REFERENCES `tl_lachat11_user` (`uid`), - CONSTRAINT `FKCC08C1DC9C8469FC` FOREIGN KEY (`chat_session_uid`) REFERENCES `tl_lachat11_session` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + KEY `FKCC08C1DCCF3BF9B6` (`from_user_uid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_message` @@ -2204,10 +2218,10 @@ `session_name` varchar(250) default NULL, `chat_uid` bigint(20) default NULL, `jabber_room` varchar(250) default NULL, + `room_created` bit(1) default NULL, PRIMARY KEY (`uid`), - KEY `FK96E446B1A3926E3` (`chat_uid`), - CONSTRAINT `FK96E446B1A3926E3` FOREIGN KEY (`chat_uid`) REFERENCES `tl_lachat11_chat` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + KEY `FK96E446B1A3926E3` (`chat_uid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_session` @@ -2235,9 +2249,8 @@ `jabber_nickname` varchar(255) default NULL, `chat_session_uid` bigint(20) default NULL, PRIMARY KEY (`uid`), - KEY `FK4EB82169C8469FC` (`chat_session_uid`), - CONSTRAINT `FK4EB82169C8469FC` FOREIGN KEY (`chat_session_uid`) REFERENCES `tl_lachat11_session` (`uid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8; + KEY `FK4EB82169C8469FC` (`chat_session_uid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `tl_lachat11_user` @@ -2399,7 +2412,7 @@ /*!40000 ALTER TABLE `tl_lafrum11_message` DISABLE KEYS */; LOCK TABLES `tl_lafrum11_message` WRITE; -INSERT INTO `tl_lafrum11_message` VALUES (1,'2007-05-03 04:01:43','2007-05-03 04:01:43','2007-05-03 04:01:43',NULL,NULL,'Topic Heading','Topic message',1,0,NULL,NULL,1,0,0,NULL); +INSERT INTO `tl_lafrum11_message` VALUES (1,'2007-06-04 14:44:59','2007-06-04 14:44:59','2007-06-04 14:44:59',NULL,NULL,'Topic Heading','Topic message',1,0,NULL,NULL,1,0,0,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lafrum11_message` ENABLE KEYS */; @@ -2520,7 +2533,7 @@ /*!40000 ALTER TABLE `tl_lamc11_content` DISABLE KEYS */; LOCK TABLES `tl_lamc11_content` WRITE; -INSERT INTO `tl_lamc11_content` VALUES (1,11,'MCQ','Instructions','2007-05-03 04:03:05',NULL,0,0,1,0,0,'','',0,0,0,0,NULL,0,0); +INSERT INTO `tl_lamc11_content` VALUES (1,11,'MCQ','Instructions','2007-06-04 14:46:24',NULL,0,0,1,0,0,'','',0,0,0,0,NULL,0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lamc11_content` ENABLE KEYS */; @@ -2755,7 +2768,7 @@ /*!40000 ALTER TABLE `tl_lanb11_content` DISABLE KEYS */; LOCK TABLES `tl_lanb11_content` WRITE; -INSERT INTO `tl_lanb11_content` VALUES (1,2,'Noticeboard','Content','','',0,0,0,'Reflect on noticeboard',0,NULL,'2007-05-03 04:01:50',NULL); +INSERT INTO `tl_lanb11_content` VALUES (1,2,'Noticeboard','Content','','',0,0,0,'Reflect on noticeboard',0,NULL,'2007-06-04 14:45:09',NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lanb11_content` ENABLE KEYS */; @@ -2966,7 +2979,7 @@ /*!40000 ALTER TABLE `tl_laqa11_content` DISABLE KEYS */; LOCK TABLES `tl_laqa11_content` WRITE; -INSERT INTO `tl_laqa11_content` VALUES (1,3,'Q&A','Instructions','2007-05-03 04:01:55',NULL,0,0,0,0,0,0,0,NULL,NULL,0,NULL,1,1); +INSERT INTO `tl_laqa11_content` VALUES (1,3,'Q&A','Instructions','2007-06-04 14:45:14',NULL,0,0,0,0,0,0,0,NULL,NULL,0,NULL,1,1); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_laqa11_content` ENABLE KEYS */; @@ -3268,7 +3281,7 @@ /*!40000 ALTER TABLE `tl_larsrc11_resource_item` DISABLE KEYS */; LOCK TABLES `tl_larsrc11_resource_item` WRITE; -INSERT INTO `tl_larsrc11_resource_item` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Web Search','http://www.google.com ',NULL,'2007-05-03 04:02:23',1,0,1,NULL,NULL,0,1,NULL); +INSERT INTO `tl_larsrc11_resource_item` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,'Web Search','http://www.google.com ',NULL,'2007-06-04 14:45:43',1,0,1,NULL,NULL,0,1,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_larsrc11_resource_item` ENABLE KEYS */; @@ -3780,7 +3793,7 @@ /*!40000 ALTER TABLE `tl_lasurv11_question` DISABLE KEYS */; LOCK TABLES `tl_lasurv11_question` WRITE; -INSERT INTO `tl_lasurv11_question` VALUES (1,1,'Sample Multiple choice - only one response allowed?',NULL,'2007-05-03 04:02:49',1,0,0,0,1),(2,2,'Sample Multiple choice - multiple response allowed?',NULL,'2007-05-03 04:02:49',2,0,0,1,1),(3,3,'Sample Free text question?',NULL,'2007-05-03 04:02:49',3,0,0,0,1); +INSERT INTO `tl_lasurv11_question` VALUES (1,1,'Sample Multiple choice - only one response allowed?',NULL,'2007-06-04 14:46:08',1,0,0,0,1),(2,2,'Sample Multiple choice - multiple response allowed?',NULL,'2007-06-04 14:46:08',2,0,0,1,1),(3,3,'Sample Free text question?',NULL,'2007-06-04 14:46:08',3,0,0,0,1); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lasurv11_question` ENABLE KEYS */; @@ -3911,7 +3924,7 @@ /*!40000 ALTER TABLE `tl_lavote11_content` DISABLE KEYS */; LOCK TABLES `tl_lavote11_content` WRITE; -INSERT INTO `tl_lavote11_content` VALUES (1,7,'Voting','Instructions','2007-05-03 04:02:29',NULL,'1',0,0,1,0,0,'','',0,1,0,NULL); +INSERT INTO `tl_lavote11_content` VALUES (1,7,'Voting','Instructions','2007-06-04 14:45:48',NULL,'1',0,0,1,0,0,'','',0,1,0,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `tl_lavote11_content` ENABLE KEYS */; Index: unix_installer/installer-package/install-lams.sh =================================================================== diff -u -r780e3f3487698b222a79e54f0645b9f3270502b2 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/install-lams.sh (.../install-lams.sh) (revision 780e3f3487698b222a79e54f0645b9f3270502b2) +++ unix_installer/installer-package/install-lams.sh (.../install-lams.sh) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -20,10 +20,12 @@ # # Author: Luke Foxton -# Installer shell script for LAMS 2.0.2 +# Installer shell script for LAMS 2.0.4 # Usage: sudo ./install.sh +LAMS_VERSION=2.0.4 +MYSQL_VERSION_STR=5. JAVA_REQ_VERSION=1.5 # Transform the required version string into a number that can be used in comparisons JAVA_REQ_VERSION=`echo $JAVA_REQ_VERSION | sed -e 's;\.;0;g'` @@ -106,84 +108,51 @@ } checkMysql() -{ - if [ -x "$SQL_DIR/mysql" ] +{ + if [ $SQL_HOST = localhost ] then - echo "Found mysql executable" - else - echo "Install failed, could not find sql executable at $SQL_DIR. Check your lams.properties file for correct configurations." - exit 1 - fi - sql_version=`$SQL_DIR/mysql -V | grep 5.` - echo $sql_version - if [ "$sql_version" ] - then - echo "Mysql executable valid." - else - echo "Install failed. Could not find MySql 5.0 or higher executable at $SQL_DIR. Check your lams.properties file and that your MySql installation is a compatible version for LAMS." - exit 1 + $JDK_DIR/bin/java -cp .:bin/:assembly/lams.ear/mysql-connector-java-3.1.12-bin.jar checkmysql "$MYSQL_DB_URL" "root" "$DB_ROOT_PASSWORD" "$MYSQL_VERSION_STR" + if [ "$?" -ne "0" ] + then + printf "\nInstall Failed. MySql check did not pass. Please check that your DB_ROOT_PASSWORD in lams.properties is set to the root password of your MySql 5.x server\n\n" + exit 1 + fi fi } createDatabase() { - if [ $DB_ROOT_PASSWORD ] + if [ $SQL_HOST = localhost ] + then + printf "\nCreating LAMS database.\n" + + ant/bin/ant -buildfile ant-scripts/configure-database.xml -logfile log/create-database.log create-database + if [ "$?" -ne "0" ] + then + echo "Install failed. Error creating the LAMS database. Check your MySql settings and try again." + exit 1 + fi + printf "Database Created.\n \n" + fi + + printf "Filling database with LAMS tables\n\n" + ant/bin/ant -buildfile ant-scripts/filter-config.xml -logfile log/filter-config.log filter-config + if [ "$?" -ne "0" ] then - $SQL_DIR/mysql -uroot -p$DB_ROOT_PASSWORD -e "SET FOREIGN_KEY_CHECKS=0" - $SQL_DIR/mysql -uroot -p$DB_ROOT_PASSWORD -e "DROP DATABASE IF EXISTS $DB_NAME" - $SQL_DIR/mysql -uroot -p$DB_ROOT_PASSWORD -e "CREATE DATABASE $DB_NAME DEFAULT CHARACTER SET utf8" - $SQL_DIR/mysql -uroot -p$DB_ROOT_PASSWORD -e "SET FOREIGN_KEY_CHECKS=1" - $SQL_DIR/mysql -uroot -p$DB_ROOT_PASSWORD -e "GRANT ALL PRIVILEGES ON *.* TO $DB_USER@localhost IDENTIFIED BY '$DB_PASS'" - $SQL_DIR/mysql -uroot -p$DB_ROOT_PASSWORD -e "REVOKE PROCESS,SUPER ON *.* from $DB_USER@localhost" - if [ "$?" -ne "0" ] - then - echo "Install Failed. Could not create database. Check that your root mysql password corresponds to the DB_ROOT_PASSWORD property in lams.properties\n." + echo "Install failed. Error generating setLamsConfiguration.sql. Please check log/filter-config for errors.\n\n" exit 1 - fi - else - $SQL_DIR/mysql -uroot -e "SET FOREIGN_KEY_CHECKS=0" - $SQL_DIR/mysql -uroot -e "DROP DATABASE IF EXISTS $DB_NAME" - $SQL_DIR/mysql -uroot -e "CREATE DATABASE $DB_NAME DEFAULT CHARACTER SET utf8" - $SQL_DIR/mysql -uroot -e "SET FOREIGN_KEY_CHECKS=1" - $SQL_DIR/mysql -uroot -e "GRANT ALL PRIVILEGES ON *.* TO $DB_USER@localhost IDENTIFIED BY '$DB_PASS'" - $SQL_DIR/mysql -uroot -e "REVOKE PROCESS,SUPER ON *.* from $DB_USER@localhost" - if [ "$?" -ne "0" ] - then - echo "Install Failed. Could not create database. Check that your root mysql password corresponds to the DB_ROOT_PASSWORD property in lams.properties\n." - exit 1 - fi fi - # Filling the database with tables - $SQL_DIR/mysql -u$DB_USER -p$DB_PASS $DB_NAME < database/lams.dump + + ant/bin/ant -buildfile ant-scripts/configure-database.xml -logfile log/fill-database.log fill-database if [ "$?" -ne "0" ] then - echo "Install Failed. Error filling datbase with tables. Check your database settings and try again." - exit 1 + printf "\nInstall failed. Could not fill the LAMS database. If you are installing with a remote MySql server, please check that your SQL_HOST in lams.properties points to a MySql 5.x installation and that you have created a database with the name DB_NAME as in lams.properties and that the DB_USER has remote access granted. Check the readme for instructions on how to do this.\n\n" + exit 1 fi + print "Done.\n\n" - # Applying the settings from lams.properties to the lams_configuration table - ant/bin/ant -buildfile ant-scripts/filter-config.xml -logfile log/filter-config.log filter-config - if [ "$?" -ne "0" ] - then - echo "Installation Failed. Error during ant tasks, check log/filter-config.log for details and check your lams.properties for mistakes." - exit 1 - fi - - - printf "Configuring LAMS database with your settings..." - # running the sql script - $SQL_DIR/mysql -u$DB_USER -p$DB_PASS $DB_NAME < sql-scripts/setLamsConfiguration.sql - if [ "$?" -ne "0" ] - -then - echo "Install failed. Error updating database with LAMS configuration. Check your MySql settings and try again." - exit 1 - fi - - printf "Done. \n" - } chooseWrapper() @@ -337,14 +306,33 @@ clear printf "\n--------------------------------------------------------------------------------\n\n" printf "WELCOME to the LAMS $LAMS_VERSION unix Installer! \n\n" -printf "Please ensure you have read and accepted the licence agreement before continuing\n\n" +printf "Please ensure you have read and accepted the license agreement before continuing\n\n" printf "Make sure you have correctly configured the lams.properties file to your \n" printf "preferred settings.\n\n" printf "You should read the installation guide before continuing.\n" printf "\nJAVA_HOME = $JAVA_HOME\n" printf "\n--------------------------------------------------------------------------------\n\n" -printf "LAMS requires about 117MB of space, do you wish to continue? (y)es, (n)o: " +if [ $SQL_HOST != localhost ] +then + printf "You are installing LAMS with a remote MySQL server. You MUST first create the \nLAMS database and user with remote privileges before continuing. Refer to the\nreadme chapter 'Setting up MySql on a Different Server' for instructions on how\nto do this.\n\nDo you wish to Continue? (y)es or (n)o: " + continue="" + read continue + case "$continue" in + y) + printf "\n" + ;; + n) + printf "\nBye!\n\n" + exit 0 + ;; + *) printf "\n\n" + exit 1 + ;; + esac +fi + +printf "LAMS requires about 117MB of space, continue with installation? (y)es, (n)o: " continue="" read continue case "$continue" in @@ -362,7 +350,7 @@ installWrapper -printf "\nCreating LAMS database with the following parameters...\n" +printf "\nUsing LAMS database with the following parameters...\n" printf "Database name: $DB_NAME\n" printf "Database user: $DB_USER\n" printf "Database password: $DB_PASS\n" @@ -411,7 +399,7 @@ cp lams.properties /etc/lams2/ -printf "\n\nLAMS 2.0.2 Configuration completed!\n" +printf "\n\nLAMS $LAMS_VERSION Configuration completed!\n" printf "Please view the README for instructions on how to run LAMS.\n\n" Index: unix_installer/installer-package/lams.properties =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/lams.properties (.../lams.properties) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/installer-package/lams.properties (.../lams.properties) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -17,7 +17,6 @@ # # http://www.gnu.org/licenses/gpl.txt # -# Author: Luke Foxton ######################################################################################### # Installation Options # @@ -55,7 +54,6 @@ - ######################################################################################### # Essential Settings # # These setting must be correct in order for the install to complete successfully # @@ -76,11 +74,15 @@ JDK_DIR=/usr/bin/java/jdk1.6.0_01/ # The location of your mysql executable (Must be 5.0 or higher) -SQL_DIR=/usr/bin/ +SQL_DIR=/usr/bin -# The URL that you jdbc driver will be running through -SQL_URL=jdbc:mysql://localhost/${DB_NAME}?characterEncoding=utf8 +# The location of your MySql server, leave as localhost unless you are useing MySql on +# a separate server +SQL_HOST=localhost +# The URL that your jdbc driver will be running through +SQL_URL=jdbc:mysql://${SQL_HOST}/${DB_NAME}?characterEncoding=utf8&autoReconnect=true + # The root password to access the database DB_ROOT_PASSWORD= @@ -117,5 +119,8 @@ SQL_DRIVER=com.mysql.jdbc.Driver SQL_JAR=mysql-connector-java-3.1.12-bin.jar +# The URL of the default mysql database +MYSQL_DB_URL=jdbc:mysql://${SQL_HOST}/mysql?characterEncoding=utf8 + ######################################################################################### Index: unix_installer/installer-package/license =================================================================== diff -u -r0965ee8a6bd49be2d53cad08225f707b32a61674 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/license (.../license) (revision 0965ee8a6bd49be2d53cad08225f707b32a61674) +++ unix_installer/installer-package/license (.../license) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -1,4 +1,4 @@ -LAMS 2.0.2 is released under the GPL license detailed below. This package +LAMS 2.0.4 is released under the GPL license detailed below. This package also includes other libraries/packages, whose respective licenses are detailed below. Index: unix_installer/installer-package/readme =================================================================== diff -u -r3436c5d5de04dd767d26f63663f0d33dbff36e35 -rc6a8998567722aec174bb639b1fb4d81dece93d8 --- unix_installer/installer-package/readme (.../readme) (revision 3436c5d5de04dd767d26f63663f0d33dbff36e35) +++ unix_installer/installer-package/readme (.../readme) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -1,7 +1,7 @@ -LAMS 2.0.2 - Learning Activity Management System Installer +LAMS 2.0.4 - Learning Activity Management System Installer -------------------------------------------------------------------------------- -This is an installer package for LAMS 2.0.2. Please read this +This is an installer package for LAMS 2.0.4. Please read this document carefully before installing. Please also ensure that you have read and understood the terms of the license agreement. @@ -11,11 +11,12 @@ 1) Required Software 2) Installation 3) Languages and Locales -4) Server Configuration -5) Startup and Shutdown -6) Using the Java Service Wrapper -7) Backing up LAMS -8) Web Resources and further help +4) Setting up MySql on a Different Server +5) Server Configuration +6) Startup and Shutdown +7) Using the Java Service Wrapper +8) Backing up LAMS +9) Web Resources and further help 1. Required Software @@ -37,10 +38,10 @@ There are a few steps to installing LAMS on your computer. Firstly make sure you have all the required software installed on your computer. -You will need to make sure that mysql is running. +You will need to make sure that MySql is running. -Next, you need to edit the lams.properties file (located in the root directory of -the package) to comply with the settings you want for your computer. Open the +Next, you need to edit the lams.properties file (located in the root directory +of the package) to comply with the settings you want for your computer. Open the lams.properties file in a text editor and follow the instructions to alter the settings. The default settings are in the lams.properties file already so you need not change a lot. Pay particular attention to the Installation Options @@ -58,57 +59,88 @@ install script. Go to the root directory of the package and type: > sudo ./install-lams.sh -Follow the prompts in the install script. The installer will ask you if you wish -to set up lams as a service, this will make lams start automatically each time -you boot your machine. The installer will attempt to detect the wrapper jar +Follow the prompts in the install script. The installer will ask you if you +wish to set up lams as a service, this will make lams start automatically each +time you boot your machine. The installer will attempt to detect the wrapper jar that is suitable for you, if it cannot you can choose the wrapper that is the closest to suiting your architecture, or follow the instructions at: http://wiki.lamsfoundation.org/display/lamsdocs/Setup+Java+Service+Wrapper+for+LAMS to set up the wrapper manually. You can find out your architecture types by typing -> uname -a to get all the inforamtion +> uname -a to get all the information > uname -m to get the architecture type wrapper-linux-ppc-64-3.2.3 Linux PPC wrapper-linux-x86-32-3.2.3 Linux i386 -wrapper-linux-x86-64-3.2.3 Linix IA64 +wrapper-linux-x86-64-3.2.3 Linux IA64 3. Languages and Locales ======================== -In LAMS 2.0 you can set the defualt language of your server to be one of many +In LAMS 2.0 you can set the default language of your server to be one of many languages, and more to come, see http://lamscommunity.org -Look out for unix language packs to add to your list of language locales +Look out for UNIX language packs to add to your list of language locales The locale options for LAMS-2.0 available are listed below, simply put in your lams.properties file (under Installation Options): LOCALE - (locale) LOCALE_DIRECTION - (locale direction) -Language Locale Locale-Direction ------------------------------------------------- -English (Australia) en_AU LTR -Español (Spanish) es_ES LTR -Deutsch (German) de_DE LTR -简体中文 (Chinese Simplified) zh_CN LTR -Français (French) fr_FR LTR -Italiano (Italian) it_IT LTR -Norsk (Norwegian) no_NO LTR -Svenska (Swedish) sv_SE LTR -한국어 (Korean) ko_KR LTR -Polski (Polish) pl_PL LTR -Português (Portuguese Brazil) pt_BR LTR -Tiếng Việt (Vietnamese) vi_VN LTR -Chinese (Taiwan) zh_TW LTR -Arabic (عربي) (Jordan) ar_JO RTL -Ελληνικά (Greek) el_GR LTR +Language Locale Locale-Direction +------------------------------------------------------- +English (Australia) en_AU LTR +Espanol (Spanish) es_ES LTR +Deutsch (German) de_DE LTR +Chinese (Simplified) zh_CN LTR +Francais (French) fr_FR LTR +Italiano (Italian) it_IT LTR +Norsk (Norwegian) no_NO LTR +Svenska (Swedish) sv_SE LTR +Korean ko_KR LTR +Polski (Polish) pl_PL LTR +Portugues (Brazil Portuguese) pl_PL LTR +Tieng Viet (Vietnamese) vi_VN LTR +Chinese (Taiwan) zh_TW LTR +Arabic (Jordan) ar_JO RTL +Greek el_GR LTR -4. Production Server Configuration +4. Setting up MySql on a Different Server +========================================= + +If you wish to use a separate server for your MySql database, there are a few +steps to follow. + +Firstly, you need to create the database and user on the MySql server. For +this example we will use the MySql host IP "111.111.111.11", the database +name "lams", the database user "user" and the password "pass". These +correspond to the MYSQL_HOST, DB_NAME, DB_USER and DB_PASS fields in +lams.properties, you should change them to match your own. + +Start the MySql command line on your MySql server and type the following: +mysql> SET FOREIGN_KEY_CHECKS=0; +mysql> DROP DATABASE IF EXISTS lams; +mysql> CREATE DATABASE lams DEFAULT CHARACTER SET utf8; +mysql> SET FOREIGN_KEY_CHECKS=1; +mysql> GRANT ALL PRIVILEGES ON *.* TO user@111.111.111.11 IDENTIFIED BY 'pass'; +mysql> REVOKE PROCESS,SUPER ON *.* from user@111.111.111.11; + +Finally, you have to grant remote permission to this user. Still in Mysql +command line, type the following: +mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'pass'; + +This user now has remote access to the database, you can continue with the +installation. + +For more help on setting up MySql on a separate server, go to: +http://wiki.lamsfoundation.org/display/lamsdocs/Moving+MySQL+to+another+Server + + +5. Production Server Configuration ============================ For single user installations, (i.e. personal use on your desktop), please @@ -127,7 +159,7 @@ http://wiki.lamsfoundation.org/display/lamsdocs/Production+Server+Settings -5. Startup and Shutdown +6. Startup and Shutdown ======================= To start LAMS 2.0 go to (jboss directory)/bin and type: @@ -150,7 +182,6 @@ If you aren't sure which version of 'ps' to use, try the '-ef' version and if that gives and error 'ps: illegal option --f" then try the -A version. - If you can see the LAMS 2.0 process still running, type: > sudo kill (pid) Where pid is the process id listed next to the LAMS 2.0 process @@ -159,7 +190,7 @@ stop another process on your server, and as you are using sudo you could stop an important process! -6. Using the Java Service Wrapper +7. Using the Java Service Wrapper ================================ If the wrapper installed correctly, LAMS will start automatically when you @@ -176,10 +207,11 @@ > sudo ./lams2 dump (send a kill -3 signal to the wrapper causing the JVM to do a full thread dump) -For more information about using the Jave Service Wrapper with LAMS, go to +For more information about using the Java Service Wrapper with LAMS, go to wiki.lamsfoundation.org/display/lamsdocs/Setup+Java+Service+Wrapper+for+LAMS -7. Backing up LAMS + +8. Backing up LAMS ================== To backup your LAMS installation manually, simply follow the following steps @@ -198,7 +230,7 @@ /mysqldump -u -p > /lams.dump -8. Web Resources +9. Web Resources ================ Unix Installer help wiki @@ -224,3 +256,4 @@ LAMS Foundation http://www.lamsfoundation.org + Index: unix_installer/installer-package/sql-scripts/create-database.sql =================================================================== diff -u --- unix_installer/installer-package/sql-scripts/create-database.sql (revision 0) +++ unix_installer/installer-package/sql-scripts/create-database.sql (revision c6a8998567722aec174bb639b1fb4d81dece93d8) @@ -0,0 +1,7 @@ +SET FOREIGN_KEY_CHECKS=0; +DROP DATABASE IF EXISTS @DB_NAME@; +CREATE DATABASE @DB_NAME@ DEFAULT CHARACTER SET utf8; +SET FOREIGN_KEY_CHECKS=1; +GRANT ALL PRIVILEGES ON *.* TO @DB_USER@@@SQL_GRANT@ IDENTIFIED BY '@DB_PASS@'; +REVOKE PROCESS,SUPER ON *.* from @DB_USER@@@SQL_GRANT@; +USE @DB_NAME@;