Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.77 -r1.78
--- lams_common/db/model/lams_11.clay	9 May 2007 01:14:31 -0000	1.77
+++ lams_common/db/model/lams_11.clay	15 May 2007 23:41:44 -0000	1.78
@@ -2858,11 +2858,11 @@
 <variant type-name-pattern="TINYINT ZEROFILL"/>
 </data-type>
 </column>
-<column alias="" auto-increment="false" column-size="1" decimal-digits="0" default-value="" mandatory="true" name="waiting_flag" remarks="">
+<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="waiting_flag" remarks="">
 <column-description></column-description>
-<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT(%n)">
-<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
+<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT">
 <variant type-name-pattern="TINYINT"/>
+<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
 <variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED"/>
 <variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL"/>
 <variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) ZEROFILL"/>
Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.92 -r1.93
--- lams_common/db/sql/create_lams_11_tables.sql	9 May 2007 01:14:31 -0000	1.92
+++ lams_common/db/sql/create_lams_11_tables.sql	15 May 2007 23:41:44 -0000	1.93
@@ -608,7 +608,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 NOT NULL
      , start_date_time DATETIME NOT NULL
      , finish_date_time DATETIME
      , current_activity_id BIGINT(20)
Index: lams_common/db/sql/insert_lams_unix_config_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/insert_lams_unix_config_data.sql,v
diff -u -r1.3 -r1.4
--- lams_common/db/sql/insert_lams_unix_config_data.sql	9 May 2007 01:17:51 -0000	1.3
+++ lams_common/db/sql/insert_lams_unix_config_data.sql	15 May 2007 23:41:44 -0000	1.4
@@ -1,9 +1,9 @@
-insert into lams_configuration (config_key, config_value) values ('ServerURL','http://shaun.melcoe.mq.edu.au/lams/');
+insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/lams/');
 insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','lams/');
 insert into lams_configuration (config_key, config_value) values ('Version','2.0.2');
 insert into lams_configuration (config_key, config_value) values ('TempDir','/var/opt/lams/temp');
 insert into lams_configuration (config_key, config_value) values ('DumpDir','/var/opt/lams/dump');
-insert into lams_configuration (config_key, config_value) values ('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/lams.ear');
+insert into lams_configuration (config_key, config_value) values ('EARDir','/Users/fiona/development/jboss-4.0.2/server/default/deploy/lams.ear');
 insert into lams_configuration (config_key, config_value) values ('SMTPServer','');
 insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au');
 insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','/var/opt/lams/repository');
Index: lams_common/db/sql/insert_rams_unix_config_data.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/Attic/insert_rams_unix_config_data.sql,v
diff -u -r1.4 -r1.5
--- lams_common/db/sql/insert_rams_unix_config_data.sql	9 May 2007 11:47:37 -0000	1.4
+++ lams_common/db/sql/insert_rams_unix_config_data.sql	15 May 2007 23:41:44 -0000	1.5
@@ -1,9 +1,9 @@
-insert into lams_configuration (config_key, config_value) values ('ServerURL','http://shaun.melcoe.mq.edu.au/rams/');
+insert into lams_configuration (config_key, config_value) values ('ServerURL','http://localhost:8080/rams/');
 insert into lams_configuration (config_key, config_value) values ('ServerURLContextPath','rams/');
 insert into lams_configuration (config_key, config_value) values ('Version','1.0 Beta');
 insert into lams_configuration (config_key, config_value) values ('TempDir','/var/opt/rams/temp');
 insert into lams_configuration (config_key, config_value) values ('DumpDir','/var/opt/rams/dump');
-insert into lams_configuration (config_key, config_value) values ('EARDir','/usr/local/jboss-4.0.2/server/default/deploy/rams.ear');
+insert into lams_configuration (config_key, config_value) values ('EARDir','/Users/fiona/development/jboss-4.0.2/server/default/deploy/rams.ear');
 insert into lams_configuration (config_key, config_value) values ('SMTPServer','');
 insert into lams_configuration (config_key, config_value) values ('LamsSupportEmail','lams_support@melcoe.mq.edu.au');
 insert into lams_configuration (config_key, config_value) values ('ContentRepositoryPath','/var/opt/rams/repository');
Fisheye: Tag 1.7 refers to a dead (removed) revision in file `lams_common/db/sql/lams_11.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `lams_common/db/sql/lams_learning_design.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: lams_common/db/sql/updatescripts/alter_203_learner_progress.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/updatescripts/Attic/alter_203_learner_progress.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_common/db/sql/updatescripts/alter_203_learner_progress.sql	15 May 2007 23:41:46 -0000	1.1
@@ -0,0 +1,7 @@
+-- Script to be run for LAMS 2.0.3 release, on LAMS 2.0.2 tables.
+-- Change waiting_flag as we want it to be a ternary value, rather than a boolean
+
+ALTER TABLE lams_learner_progress
+MODIFY COLUMN waiting_flag TINYINT;
+
+COMMIT;