Index: temp_moodle_dev/lamstwo/db/install.xml
===================================================================
RCS file: /usr/local/cvsroot/temp_moodle_dev/lamstwo/db/Attic/install.xml,v
diff -u -r1.3 -r1.4
--- temp_moodle_dev/lamstwo/db/install.xml	19 Aug 2008 07:35:52 -0000	1.3
+++ temp_moodle_dev/lamstwo/db/install.xml	27 Aug 2008 07:03:23 -0000	1.4
@@ -24,8 +24,8 @@
         <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="lamstwo" NEXT="intro"/>
         <FIELD NAME="intro" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="groupid"/>
         <FIELD NAME="groupid" TYPE="int" LENGTH="20" NOTNULL="false" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="intro" NEXT="sequence_id"/>
-        <FIELD NAME="sequence_id" TYPE="int" LENGTH="20" NOTNULL="false" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="groupid" NEXT="lesson_id"/>
-        <FIELD NAME="lesson_id" TYPE="int" LENGTH="20" NOTNULL="false" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="sequence_id" NEXT="timemodified"/>
+        <FIELD NAME="sequence_id" TYPE="int" LENGTH="20" NOTNULL="false" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="groupid" NEXT="lesson_id"/>
+        <FIELD NAME="lesson_id" TYPE="int" LENGTH="20" NOTNULL="false" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="sequence_id" NEXT="timemodified"/>
         <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="lesson_id" />
       </FIELDS>
       <KEYS>
@@ -40,7 +40,7 @@
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="lamstwolesson"/>
         <FIELD NAME="lamstwolesson" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="user"/>
         <FIELD NAME="user" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="lamstwolesson" NEXT="completed"/>
-        <FIELD NAME="completed" TYPE="int" LENGTH="1" NOTNULL="false" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="user"/>
+        <FIELD NAME="completed" TYPE="int" LENGTH="1" NOTNULL="false" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="user"/>
       </FIELDS>
       <KEYS>
         <KEY NAME="primary_lamstwo_grade" TYPE="primary" FIELDS="id" COMMENT="Primary key for lamstwo_grade"/>
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `temp_moodle_dev/lamstwo/db/mysql.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `temp_moodle_dev/lamstwo/db/postgres7.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: temp_moodle_dev/lamstwo/db/upgrade.php
===================================================================
RCS file: /usr/local/cvsroot/temp_moodle_dev/lamstwo/db/Attic/upgrade.php,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ temp_moodle_dev/lamstwo/db/upgrade.php	27 Aug 2008 07:03:23 -0000	1.1
@@ -0,0 +1,115 @@
+<?php
+
+// This file keeps track of upgrades to 
+// the forum module
+//
+// Sometimes, changes between versions involve
+// alterations to database structures and other
+// major things that may break installations.
+//
+// The upgrade function in this file will attempt
+// to perform all the necessary actions to upgrade
+// your older installtion to the current version.
+//
+// If there's something it cannot do itself, it
+// will tell you what you need to do.
+//
+// The commands in here will all be database-neutral,
+// using the functions defined in lib/ddllib.php
+
+function xmldb_lamstwo_upgrade($oldversion=0) {
+
+    $result = true;
+
+    if ($result && $oldversion < 2008052100) {
+    
+        // LDEV-1435
+        $table = new XMLDBTable('lamstwo');
+        $field = new XMLDBField('introduction');
+        $field->setAttributes(XMLDB_TYPE_TEXT, 'small', null, true, null, null, null, null, null);
+        $result = change_field_default($table, $field);
+        
+        // modify lamstwo table
+        $result = $result && rename_field($table, $field, 'intro');
+        $result = $result && drop_field($table, new XMLDBField('sequence_id'));
+        $result = $result && drop_field($table, new XMLDBField('lesson_id'));
+        
+        // add table lamstwo_lesson
+        $table = new XMLDBTable('lamstwo_lesson');
+        
+        $field = new XMLDBField('id');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, true, null, null, null, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('course');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('lamstwo');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('name');
+        $field->setAttributes(XMLDB_TYPE_CHAR, 255, null, true, null, null, null, null, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('intro');
+        $field->setAttributes(XMLDB_TYPE_TEXT, 'small', null, true, null, null, null, null, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('groupid');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 20, null, null, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('sequence_id');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 20, true, null, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('lesson_id');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 20, true, null, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('timemodified');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $key = new XMLDBKey('primary_lamstwo_lesson');
+        $key->setAttributes(XMLDB_KEY_PRIMARY, array('id'));
+        $table->addKey($key);
+        
+        $index = new XMLDBIndex('course_lamstwo_lesson');
+        $index->setAttributes(XMLDB_INDEX_NOTUNIQUE, array('course'));
+        $table->addIndex($index);
+        
+        $result = $result && create_table($table);
+        
+        // add table lamstwo_grade
+        $table = new XMLDBTable('lamstwo_grade');
+        
+        $field = new XMLDBField('id');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, true, null, null, null, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('lamstwolesson');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('user');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 10, true, true, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $field = new XMLDBField('completed');
+        $field->setAttributes(XMLDB_TYPE_INTEGER, 1, true, null, null, null, null, 0, null);
+        $table->addField($field);
+        
+        $key = new XMLDBKey('primary_lamstwo_grade');
+        $key->setAttributes(XMLDB_KEY_PRIMARY, array('id'));
+        $table->addKey($key);
+        
+        $result = $result && create_table($table);
+    }
+
+    return $result;
+}
+
+?>