Index: lams_tool_laqa/build.properties =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/build.properties,v diff -u -r1.19 -r1.20 --- lams_tool_laqa/build.properties 13 Feb 2007 01:01:28 -0000 1.19 +++ lams_tool_laqa/build.properties 14 Feb 2007 11:17:21 -0000 1.20 @@ -4,7 +4,7 @@ signature=laqa11 #version of this project -tool.version=20061113 +tool.version=20070214 #submit files package definition qa.package=org.lamsfoundation.lams.tool.qa Index: lams_tool_laqa/conf/hibernate/mappings/org/lamsfoundation/lams/tool/qa/QaQueUsr.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/conf/hibernate/mappings/org/lamsfoundation/lams/tool/qa/QaQueUsr.hbm.xml,v diff -u -r1.3 -r1.4 --- lams_tool_laqa/conf/hibernate/mappings/org/lamsfoundation/lams/tool/qa/QaQueUsr.hbm.xml 24 Aug 2006 08:43:34 -0000 1.3 +++ lams_tool_laqa/conf/hibernate/mappings/org/lamsfoundation/lams/tool/qa/QaQueUsr.hbm.xml 14 Feb 2007 11:17:21 -0000 1.4 @@ -31,14 +31,14 @@ name="username" type="java.lang.String" column="username" - length="100" + length="255" > Index: lams_tool_laqa/db/model/lams_tool_qa.clay =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/model/lams_tool_qa.clay,v diff -u -r1.25 -r1.26 --- lams_tool_laqa/db/model/lams_tool_qa.clay 13 Nov 2006 19:38:45 -0000 1.25 +++ lams_tool_laqa/db/model/lams_tool_qa.clay 14 Feb 2007 11:17:21 -0000 1.26 @@ -1,18 +1,18 @@ - - + + QA Tool for Lams 1.1 - + - + - + @@ -25,7 +25,7 @@ - + @@ -38,33 +38,33 @@ - + - + - + - + - + @@ -78,13 +78,13 @@ - + - + @@ -94,11 +94,11 @@
- + - + @@ -111,7 +111,7 @@ - + @@ -124,31 +124,31 @@ - + - + - + - + - + @@ -161,7 +161,7 @@ - + @@ -174,7 +174,7 @@ - + @@ -187,7 +187,7 @@ - + @@ -200,7 +200,7 @@ - + @@ -213,7 +213,7 @@ - + @@ -226,7 +226,7 @@ - + @@ -239,19 +239,19 @@ - + - + - + @@ -264,13 +264,13 @@ - + - + @@ -283,10 +283,10 @@ - + - + @@ -297,19 +297,19 @@ - +
- - + + - + @@ -322,7 +322,7 @@ - + @@ -334,15 +334,15 @@ - - + + - + @@ -355,7 +355,7 @@ - + @@ -367,15 +367,15 @@ - - + + - + @@ -389,13 +389,13 @@ - + - + @@ -405,11 +405,11 @@
- + - + @@ -422,19 +422,19 @@ - + - + - + @@ -447,7 +447,7 @@ - + @@ -461,13 +461,13 @@ - + - + @@ -477,11 +477,11 @@
- + - + @@ -494,7 +494,7 @@ - + @@ -507,26 +507,26 @@ - + - + - + - + @@ -539,7 +539,7 @@ - + @@ -552,7 +552,7 @@ - + @@ -566,20 +566,20 @@ - + - + - + @@ -589,11 +589,11 @@
- + - + @@ -606,14 +606,14 @@ - + - + @@ -626,14 +626,14 @@ - + - + @@ -647,13 +647,13 @@ - + - + Index: lams_tool_laqa/db/sql/create_lams_tool_qa.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/create_lams_tool_qa.sql,v diff -u -r1.45 -r1.46 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql 13 Nov 2006 19:38:47 -0000 1.45 +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql 14 Feb 2007 11:17:21 -0000 1.46 @@ -38,10 +38,10 @@ CREATE TABLE tl_laqa11_que_usr ( uid BIGINT(20) NOT NULL AUTO_INCREMENT , que_usr_id BIGINT(20) NOT NULL - , username VARCHAR(100) + , username VARCHAR(255) , responseFinalized TINYINT(1) NOT NULL DEFAULT 0 , qa_session_id BIGINT(20) NOT NULL - , fullname VARCHAR(100) + , fullname VARCHAR(255) , learnerFinished TINYINT(1) NOT NULL , PRIMARY KEY (uid) , INDEX (qa_session_id) Index: lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/updatescripts/Attic/updateTo20070214.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql 14 Feb 2007 11:17:21 -0000 1.1 @@ -0,0 +1,6 @@ +-- Update the Q&A tables from version 20061113 to 20070214 +-- This is for the LAMS 2.0.1 release. + +ALTER TABLE tl_laqa11_que_usr +CHANGE COLUMN username username VARCHAR(255), +CHANGE COLUMN fullname fullname VARCHAR(255); Index: lams_tool_nb/build.properties =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/build.properties,v diff -u -r1.12 -r1.13 --- lams_tool_nb/build.properties 13 Feb 2007 01:09:05 -0000 1.12 +++ lams_tool_nb/build.properties 14 Feb 2007 11:17:54 -0000 1.13 @@ -9,6 +9,6 @@ test.contentid=355 # project version -tool.version=20061102 +tool.version=20070214 Index: lams_tool_nb/conf/hibernate/mappings/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.hbm.xml =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/conf/hibernate/mappings/org/lamsfoundation/lams/tool/noticeboard/Attic/NoticeboardUser.hbm.xml,v diff -u -r1.3 -r1.4 --- lams_tool_nb/conf/hibernate/mappings/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.hbm.xml 15 Feb 2006 01:38:10 -0000 1.3 +++ lams_tool_nb/conf/hibernate/mappings/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.hbm.xml 14 Feb 2007 11:17:41 -0000 1.4 @@ -31,7 +31,7 @@ update="true" insert="true" column="fullname" - length="50" + length="255" /> - - + + + - + -
+
- + - + - - + + - - - + + + - + - - + + - - - + + + - + - + - + - + - + - + - + - + - + - - + + - - - + + + - + - - + + - - - + + + - + - - + + - - - + + + - + - - + + - - - + + + - + - + - + - + - +
- +
- + - + - - + + - - - + + + - + - - + + - - - + + + - + - - + + - - - + + + - + - + - + - + - + - - - + + + - + - + @@ -213,78 +213,78 @@
- +
- + - + - - + + - - - + + + - + - - + + - - - + + + - + - - + + - - - + + + - + - - - + + + - + - - - + + + - + - - - + + + - + - + @@ -294,90 +294,90 @@
- +
- + - + - - + + - - - + + + - + - - + + - - - + + + - + - - - + + + - + - - + + - - - + + + - + - - + + - - - + + + - + - - + + - - - + + + - + - + Index: lams_tool_nb/db/sql/create_lams_tool_nb.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/create_lams_tool_nb.sql,v diff -u -r1.18 -r1.19 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql 31 Oct 2006 04:22:52 -0000 1.18 +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql 14 Feb 2007 11:17:54 -0000 1.19 @@ -36,8 +36,8 @@ uid BIGINT(20) NOT NULL AUTO_INCREMENT , user_id BIGINT(20) NOT NULL , nb_session_uid BIGINT(20) NOT NULL - , username VARCHAR(50) - , fullname VARCHAR(50) + , username VARCHAR(255) + , fullname VARCHAR(255) , user_status VARCHAR(50) , PRIMARY KEY (uid) , INDEX (nb_session_uid) Index: lams_tool_nb/db/sql/init_lams_tool_nb.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/Attic/init_lams_tool_nb.sql,v diff -u -r1.13 -r1.14 --- lams_tool_nb/db/sql/init_lams_tool_nb.sql 21 Mar 2006 06:54:17 -0000 1.13 +++ lams_tool_nb/db/sql/init_lams_tool_nb.sql 14 Feb 2007 11:17:54 -0000 1.14 @@ -40,8 +40,8 @@ uid BIGINT(20) NOT NULL AUTO_INCREMENT , user_id BIGINT(20) NOT NULL , nb_session_uid BIGINT(20) NOT NULL - , username VARCHAR(50) - , fullname VARCHAR(50) + , username VARCHAR(255) + , fullname VARCHAR(255) , user_status VARCHAR(50) , PRIMARY KEY (uid) , INDEX (nb_session_uid) Index: lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/updatescripts/Attic/updateTo20070214.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql 14 Feb 2007 11:17:54 -0000 1.1 @@ -0,0 +1,6 @@ +-- Update the Noticeboard tables to 20070214 +-- This is for the LAMS 2.0.1 release. + +ALTER TABLE tl_lanb11_user +CHANGE COLUMN username username VARCHAR(255), +CHANGE COLUMN fullname fullname VARCHAR(255); Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.java =================================================================== RCS file: /usr/local/cvsroot/lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.java,v diff -u -r1.6 -r1.7 --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.java 17 Sep 2006 06:26:26 -0000 1.6 +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.java 14 Feb 2007 11:17:41 -0000 1.7 @@ -89,7 +89,7 @@ /** * @hibernate.property * column="fullname" - * length="50" + * length="255" * * @return Returns the fullname. */ @@ -156,7 +156,7 @@ /** * @hibernate.property * column="username" - * length="50" + * length="255" * * @return Returns the username. */ Index: lams_tool_vote/build.properties =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/build.properties,v diff -u -r1.3 -r1.4 --- lams_tool_vote/build.properties 13 Feb 2007 01:27:51 -0000 1.3 +++ lams_tool_vote/build.properties 14 Feb 2007 11:18:11 -0000 1.4 @@ -4,7 +4,7 @@ signature=lavote11 #project version -tool.version=20061113 +tool.version=20070214 #submit files package definition vote.package=org.lamsfoundation.lams.tool.vote Index: lams_tool_vote/db/model/lams_tool_vote.clay =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/db/model/lams_tool_vote.clay,v diff -u -r1.17 -r1.18 --- lams_tool_vote/db/model/lams_tool_vote.clay 11 Nov 2006 15:56:56 -0000 1.17 +++ lams_tool_vote/db/model/lams_tool_vote.clay 14 Feb 2007 11:18:11 -0000 1.18 @@ -1,18 +1,18 @@ - - + + Voting Tool for Lams 1.1 - +
- + - + @@ -25,7 +25,7 @@ - + @@ -38,33 +38,33 @@ - + - + - + - + - + @@ -78,18 +78,18 @@ - + - + - + @@ -99,11 +99,11 @@
- + - + @@ -116,7 +116,7 @@ - + @@ -129,7 +129,7 @@ - + @@ -142,27 +142,27 @@ - + - + - + - + @@ -175,7 +175,7 @@ - + @@ -189,20 +189,20 @@ - + - + - + @@ -212,11 +212,11 @@
- - + + - + @@ -229,7 +229,7 @@ - + @@ -242,7 +242,7 @@ - + @@ -254,22 +254,22 @@ - - + + - - + + - + @@ -282,7 +282,7 @@ - + @@ -296,13 +296,13 @@ - + - + @@ -312,11 +312,11 @@
- + - + @@ -329,13 +329,13 @@ - + - + @@ -348,7 +348,7 @@ - + @@ -362,13 +362,13 @@ - + - + @@ -378,11 +378,11 @@
- + - + @@ -395,7 +395,7 @@ - + @@ -408,38 +408,38 @@ - + - + - + - + - + - + @@ -452,7 +452,7 @@ - + @@ -465,7 +465,7 @@ - + @@ -478,7 +478,7 @@ - + @@ -491,7 +491,7 @@ - + @@ -504,19 +504,19 @@ - + - + - + @@ -529,10 +529,10 @@ - + - + @@ -542,7 +542,7 @@ - + @@ -555,26 +555,26 @@ - + - +
- + - + @@ -587,14 +587,14 @@ - + - + @@ -607,14 +607,14 @@ - + - + @@ -628,13 +628,13 @@ - + - + Index: lams_tool_vote/db/sql/create_lams_tool_vote.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/create_lams_tool_vote.sql,v diff -u -r1.21 -r1.22 --- lams_tool_vote/db/sql/create_lams_tool_vote.sql 11 Nov 2006 15:56:56 -0000 1.21 +++ lams_tool_vote/db/sql/create_lams_tool_vote.sql 14 Feb 2007 11:18:11 -0000 1.22 @@ -39,8 +39,8 @@ uid BIGINT(20) NOT NULL AUTO_INCREMENT , user_id BIGINT(20) NOT NULL , vote_session_id BIGINT(20) NOT NULL - , username VARCHAR(100) - , fullname VARCHAR(20) + , username VARCHAR(255) + , fullname VARCHAR(255) , responseFinalised TINYINT(1) NOT NULL DEFAULT 0 , finalScreenRequested TINYINT(1) NOT NULL DEFAULT 0 , PRIMARY KEY (uid) Index: lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/updatescripts/Attic/updateTo20070214.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql 14 Feb 2007 11:18:11 -0000 1.1 @@ -0,0 +1,6 @@ +-- Update the Vote tables to 20070214 +-- This is for the LAMS 2.0.1 release. + +ALTER TABLE tl_lavote11_usr +CHANGE COLUMN username username VARCHAR(255), +CHANGE COLUMN fullname fullname VARCHAR(255);