Index: temp_moodle_dev/lamstwo/db/install.xml
===================================================================
diff -u -rc38e7385ccdf90536303d2299f492accdd29d869 -r10a8a9d91b8a91cf597fa766680c3d61b7e01e7a
--- temp_moodle_dev/lamstwo/db/install.xml	(.../install.xml)	(revision c38e7385ccdf90536303d2299f492accdd29d869)
+++ temp_moodle_dev/lamstwo/db/install.xml	(.../install.xml)	(revision 10a8a9d91b8a91cf597fa766680c3d61b7e01e7a)
@@ -1,22 +1,47 @@
 <?xml version="1.0" encoding="UTF-8" ?>
-<XMLDB PATH="mod/lamstwo/db" VERSION="20060801" COMMENT="XMLDB file for Moodle mod/lamstwo">
+<XMLDB PATH="mod/lamstwo/db" VERSION="20080521" COMMENT="XMLDB file for Moodle mod/lamstwo">
   <TABLES>
-    <TABLE NAME="lamstwo" COMMENT="LAMS activity">
+    <TABLE NAME="lamstwo" COMMENT="LAMS module" NEXT="lamstwo_lesson">
       <FIELDS>
         <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="course"/>
         <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="name"/>
-        <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="course" NEXT="introduction"/>
-        <FIELD NAME="introduction" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="sequence_id"/>
-        <FIELD NAME="sequence_id" TYPE="int" LENGTH="20" NOTNULL="false" UNSIGNED="false" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="introduction" NEXT="lesson_id"/>
+        <FIELD NAME="name" TYPE="char" LENGTH="255" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="course" NEXT="intro"/>
+        <FIELD NAME="intro" TYPE="text" LENGTH="small" NOTNULL="true" SEQUENCE="false" ENUM="false" PREVIOUS="name" NEXT="timemodified"/>
+        <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="intro"/>
+      </FIELDS>
+      <KEYS>
+        <KEY NAME="primary_lamstwo" TYPE="primary" FIELDS="id" COMMENT="Primary key for lamstwo"/>
+      </KEYS>
+      <INDEXES>
+        <INDEX NAME="course_lamstwo" UNIQUE="false" FIELDS="course"/>
+      </INDEXES>
+    </TABLE>
+    <TABLE NAME="lamstwo_lesson" COMMENT="LAMS lesson" PREVIOUS="lamstwo" NEXT="lamstwo_grade">
+      <FIELDS>
+        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="course"/>
+        <FIELD NAME="course" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="id" NEXT="lamstwo"/>
+        <FIELD NAME="lamstwo" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="course" NEXT="name"/>
+        <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="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="lesson_id"/>
+        <FIELD NAME="timemodified" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" DEFAULT="0" SEQUENCE="false" ENUM="false" PREVIOUS="lesson_id" NEXT="completed"/>
       </FIELDS>
       <KEYS>
-        <KEY NAME="primary" TYPE="primary" FIELDS="id" COMMENT="Primary key for lamstwo"/>
+        <KEY NAME="primary_lamstwo_lesson" TYPE="primary" FIELDS="id" COMMENT="Primary key for lamstwo_lesson"/>
       </KEYS>
       <INDEXES>
-        <INDEX NAME="course" UNIQUE="false" FIELDS="course"/>
+        <INDEX NAME="course_lamstwo_lesson" UNIQUE="false" FIELDS="course"/>
       </INDEXES>
     </TABLE>
+    <TABLE NAME="lamstwo_grade" COMMENT="LAMS user grade" PREVIOUS="lamstwo_lesson">
+      <FIELDS>
+        <FIELD NAME="id" TYPE="int" LENGTH="10" NOTNULL="true" UNSIGNED="true" SEQUENCE="true" ENUM="false" NEXT="course"/>
+        <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="lamstwolesson"/>
+      </FIELDS>
+    </TABLE>
   </TABLES>
-</XMLDB>
\ No newline at end of file
+</XMLDB>
Index: temp_moodle_dev/lamstwo/db/mysql.sql
===================================================================
diff -u -rc38e7385ccdf90536303d2299f492accdd29d869 -r10a8a9d91b8a91cf597fa766680c3d61b7e01e7a
--- temp_moodle_dev/lamstwo/db/mysql.sql	(.../mysql.sql)	(revision c38e7385ccdf90536303d2299f492accdd29d869)
+++ temp_moodle_dev/lamstwo/db/mysql.sql	(.../mysql.sql)	(revision 10a8a9d91b8a91cf597fa766680c3d61b7e01e7a)
@@ -8,11 +8,29 @@
   id int(10) unsigned NOT NULL auto_increment,
   course int(10) unsigned NOT NULL default '0',
   name varchar(255) NOT NULL default '',
-  introduction text NOT NULL default '',
-  sequence_id bigint(20) default '0',
-  lesson_id bigint(20) default '0',
+  intro text NOT NULL default '',
   timemodified int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (id),
   KEY course (course)
 )COMMENT='LAMS2 activity';  
 
+CREATE TABLE prefix_lamstwo_lesson (
+  id int(10) unsigned NOT NULL auto_increment,
+  course int(10) unsigned NOT NULL default '0',
+  lamstwo int(10) unsigned NOT NULL default '0',
+  name varchar(255) NOT NULL default '',
+  intro text NOT NULL default '',
+  groupid bigint(10) NOT NULL default '-1',
+  sequence_id bigint(20) default '0',
+  lesson_id bigint(20) default '0',
+  timemodified int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (id)
+); 
+
+CREATE TABLE mdl_lamstwo_grade (
+  id int(10) unsigned NOT NULL auto_increment,
+  lamstwolesson int(10) unsigned NOT NULL default '0',
+  user int(10) unsigned NOT NULL default '0',
+  completed int(1) unsigned NOT NULL default '0',
+  PRIMARY KEY (id)
+);