Index: lams_tool_laqa/build.properties =================================================================== diff -u -r0b1d9b25bb467095dddfd12e2350a4d261a0306f -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_laqa/build.properties (.../build.properties) (revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f) +++ lams_tool_laqa/build.properties (.../build.properties) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -rfb8def0d68dd0173cbf63822e7711caed05df2e2 -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_laqa/conf/hibernate/mappings/org/lamsfoundation/lams/tool/qa/QaQueUsr.hbm.xml (.../QaQueUsr.hbm.xml) (revision fb8def0d68dd0173cbf63822e7711caed05df2e2) +++ lams_tool_laqa/conf/hibernate/mappings/org/lamsfoundation/lams/tool/qa/QaQueUsr.hbm.xml (.../QaQueUsr.hbm.xml) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r1046868d6997114f3b043778a68b371e03182faf -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_laqa/db/model/lams_tool_qa.clay (.../lams_tool_qa.clay) (revision 1046868d6997114f3b043778a68b371e03182faf) +++ lams_tool_laqa/db/model/lams_tool_qa.clay (.../lams_tool_qa.clay) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r1046868d6997114f3b043778a68b371e03182faf -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 1046868d6997114f3b043778a68b371e03182faf) +++ lams_tool_laqa/db/sql/create_lams_tool_qa.sql (.../create_lams_tool_qa.sql) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u --- lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql (revision 0) +++ lams_tool_laqa/db/sql/updatescripts/updateTo20070214.sql (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r72b6b6e1dd023b2cf48526d929dc7eb40bf364fb -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_nb/build.properties (.../build.properties) (revision 72b6b6e1dd023b2cf48526d929dc7eb40bf364fb) +++ lams_tool_nb/build.properties (.../build.properties) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -rdce659b59eb25956ec196310c7aa8eeaba6a6beb -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_nb/conf/hibernate/mappings/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.hbm.xml (.../NoticeboardUser.hbm.xml) (revision dce659b59eb25956ec196310c7aa8eeaba6a6beb) +++ lams_tool_nb/conf/hibernate/mappings/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.hbm.xml (.../NoticeboardUser.hbm.xml) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r34c66fb7023ee64ab44d876ae375236e69400fe9 -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 34c66fb7023ee64ab44d876ae375236e69400fe9) +++ lams_tool_nb/db/sql/create_lams_tool_nb.sql (.../create_lams_tool_nb.sql) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r0020142e02f5cd9631e5602a538189b8077350ef -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_nb/db/sql/init_lams_tool_nb.sql (.../init_lams_tool_nb.sql) (revision 0020142e02f5cd9631e5602a538189b8077350ef) +++ lams_tool_nb/db/sql/init_lams_tool_nb.sql (.../init_lams_tool_nb.sql) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u --- lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql (revision 0) +++ lams_tool_nb/db/sql/updatescripts/updateTo20070214.sql (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r08950e1090443c3423a3d1c587416a2fccd8bbdf -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.java (.../NoticeboardUser.java) (revision 08950e1090443c3423a3d1c587416a2fccd8bbdf) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/NoticeboardUser.java (.../NoticeboardUser.java) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -r658b820953ee6971924d2381cb7891b06f0f4adb -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_vote/build.properties (.../build.properties) (revision 658b820953ee6971924d2381cb7891b06f0f4adb) +++ lams_tool_vote/build.properties (.../build.properties) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -rc7d0851ee500379b5241d2e9b2dd05c1dcd8f658 -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_vote/db/model/lams_tool_vote.clay (.../lams_tool_vote.clay) (revision c7d0851ee500379b5241d2e9b2dd05c1dcd8f658) +++ lams_tool_vote/db/model/lams_tool_vote.clay (.../lams_tool_vote.clay) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u -rc7d0851ee500379b5241d2e9b2dd05c1dcd8f658 -r89b6e076006b36f7edcf712cfa97b87ef9010e23 --- lams_tool_vote/db/sql/create_lams_tool_vote.sql (.../create_lams_tool_vote.sql) (revision c7d0851ee500379b5241d2e9b2dd05c1dcd8f658) +++ lams_tool_vote/db/sql/create_lams_tool_vote.sql (.../create_lams_tool_vote.sql) (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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 =================================================================== diff -u --- lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql (revision 0) +++ lams_tool_vote/db/sql/updatescripts/updateTo20070214.sql (revision 89b6e076006b36f7edcf712cfa97b87ef9010e23) @@ -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);