Index: lams_common/db/model/lams_11.clay
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/model/lams_11.clay,v
diff -u -r1.12 -r1.13
--- lams_common/db/model/lams_11.clay	31 Jan 2005 01:22:13 -0000	1.12
+++ lams_common/db/model/lams_11.clay	31 Jan 2005 06:22:19 -0000	1.13
@@ -323,11 +323,11 @@
 <variant type-name-pattern="TINYINT ZEROFILL"/>
 </data-type>
 </column>
-<column name="learning_design_id" alias="" remarks="" mandatory="false" column-size="20" decimal-digits="0" default-value="0" auto-increment="false">
+<column name="learning_design_id" alias="" remarks="" mandatory="false" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
-<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
@@ -336,11 +336,11 @@
 <variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
-<column name="learning_library_id" alias="" remarks="" mandatory="false" column-size="20" decimal-digits="0" default-value="0" auto-increment="false">
+<column name="learning_library_id" alias="" remarks="" mandatory="false" column-size="20" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="BIGINT" jdbc-type="-5" selected-variant-pattern="BIGINT(%n)">
-<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT"/>
+<variant type-name-pattern="BIGINT(%n)" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
 <variant type-name-pattern="BIGINT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="19"/>
@@ -413,11 +413,11 @@
 <variant type-name-pattern="BIGINT ZEROFILL"/>
 </data-type>
 </column>
-<column name="gate_activity_level_id" alias="" remarks="" mandatory="false" column-size="11" decimal-digits="0" default-value="0" auto-increment="false">
+<column name="gate_activity_level_id" alias="" remarks="" mandatory="false" column-size="11" decimal-digits="0" default-value="" auto-increment="false">
 <column-description/>
 <data-type name="INT" jdbc-type="4" selected-variant-pattern="INT(%n)">
-<variant type-name-pattern="INT(%n)" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT"/>
+<variant type-name-pattern="INT(%n)" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) UNSIGNED" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) UNSIGNED ZEROFILL" precision-variable="%n" precision-min="0" precision-max="10"/>
 <variant type-name-pattern="INT(%n) ZEROFILL" precision-variable="%n" precision-min="0" precision-max="10"/>
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.15 -r1.16
--- lams_common/db/sql/create_lams_11_tables.sql	31 Jan 2005 01:21:59 -0000	1.15
+++ lams_common/db/sql/create_lams_11_tables.sql	31 Jan 2005 06:22:29 -0000	1.16
@@ -281,15 +281,15 @@
      , grouping_id BIGINT(20)
      , order_id INT(11)
      , define_later_flag TINYINT(4) NOT NULL DEFAULT 0
-     , learning_design_id BIGINT(20) DEFAULT 0
-     , learning_library_id BIGINT(20) DEFAULT 0
+     , learning_design_id BIGINT(20)
+     , learning_library_id BIGINT(20)
      , create_date_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
      , offline_instructions TEXT
      , max_number_of_options INT(5)
      , min_number_of_options INT(5)
      , tool_id BIGINT(20)
      , tool_content_id BIGINT(20)
-     , gate_activity_level_id INT(11) DEFAULT 0
+     , gate_activity_level_id INT(11)
      , gate_start_date_time DATETIME
      , gate_end_date_time DATETIME
      , library_activity_ui_image VARCHAR(255)