Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.24 -r1.25
--- lams_common/db/model/lams_11.clay	22 Feb 2005 02:30:22 -0000	1.24
+++ lams_common/db/model/lams_11.clay	25 Feb 2005 00:16:33 -0000	1.25
@@ -153,7 +153,7 @@
 </table>
 <table name="lams_grouping_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="113" y="1411" width="-1" height="-1"/>
+<table-figure-bounds x="167" y="1408" width="-1" height="-1"/>
 <column-list>
 <column name="grouping_type_id" alias="" remarks="" mandatory="true" column-size="11" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -390,8 +390,8 @@
 <column name="run_offline_flag" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="TINYINT" jdbc-type="-6" selected-variant-pattern="TINYINT(%n)">
-<variant type-name-pattern="TINYINT"/>
 <variant type-name-pattern="TINYINT(%n)" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT"/>
 <variant type-name-pattern="TINYINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="1"/>
 <variant type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
 <variant type-name-pattern="TINYINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
@@ -1218,7 +1218,7 @@
 </table>
 <table name="lams_learning_transition" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="7" y="1489" width="-1" height="-1"/>
+<table-figure-bounds x="-11" y="1625" width="-1" height="-1"/>
 <column-list>
 <column name="transition_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1380,7 +1380,7 @@
 </table>
 <table name="lams_organisation" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="130" y="185" width="-1" height="-1"/>
+<table-figure-bounds x="198" y="15" width="-1" height="-1"/>
 <column-list>
 <column name="organisation_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -1614,7 +1614,7 @@
 </table>
 <table name="lams_user" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="904" y="304" width="-1" height="-1"/>
+<table-figure-bounds x="1116" y="290" width="-1" height="-1"/>
 <column-list>
 <column name="user_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2089,7 +2089,7 @@
 </table>
 <table name="lams_workspace_folder" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="311" y="429" width="-1" height="-1"/>
+<table-figure-bounds x="465" y="459" width="-1" height="-1"/>
 <column-list>
 <column name="workspace_folder_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="true">
 <column-description/>
@@ -2364,6 +2364,19 @@
 <variant type-name-pattern="TINYINT ZEROFILL"/>
 </data-type>
 </column>
+<column name="waiting_flag" alias="" remarks="" mandatory="true" column-size="1" decimal-digits="0" default-value="" auto-increment="false">
+<column-description/>
+<data-type name="TINYINT" jdbc-type="-6" selected-variant-pattern="TINYINT(%n)">
+<variant type-name-pattern="TINYINT"/>
+<variant type-name-pattern="TINYINT(%n)" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="1"/>
+<variant type-name-pattern="TINYINT UNSIGNED"/>
+<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
+<variant type-name-pattern="TINYINT ZEROFILL"/>
+</data-type>
+</column>
 <column name="start_date_time" alias="" remarks="" mandatory="true" column-size="0" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="DATETIME" jdbc-type="93" selected-variant-pattern="DATETIME" literal-prefix="'" literal-suffix="'">
@@ -2975,7 +2988,7 @@
 </table>
 <table name="lams_lesson_state" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-36" y="446" width="-1" height="-1"/>
+<table-figure-bounds x="-12" y="159" width="-1" height="-1"/>
 <column-list>
 <column name="lesson_state_id" alias="" remarks="" mandatory="true" column-size="3" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3108,7 +3121,7 @@
 </table>
 <table name="lams_lesson_learner" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="72" y="370" width="-1" height="-1"/>
+<table-figure-bounds x="136" y="262" width="-1" height="-1"/>
 <column-list>
 <column name="lesson_id" alias="" remarks="" mandatory="true" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
@@ -3261,7 +3274,7 @@
 </table>
 <table name="lams_copy_type" alias="" remarks="">
 <table-description/>
-<table-figure-bounds x="-57" y="1397" width="-1" height="-1"/>
+<table-figure-bounds x="-58" y="1440" width="-1" height="-1"/>
 <column-list>
 <column name="copy_type_id" alias="" remarks="" mandatory="true" column-size="4" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
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.29 -r1.30
--- lams_common/db/sql/create_lams_11_tables.sql	22 Feb 2005 02:30:22 -0000	1.29
+++ lams_common/db/sql/create_lams_11_tables.sql	25 Feb 2005 00:16:33 -0000	1.30
@@ -366,6 +366,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
      , start_date_time DATETIME NOT NULL
      , finish_date_time DATETIME
      , current_activity_id BIGINT(20)