Index: temp_moodle_dev/lamstwo/db/mysql.sql
===================================================================
RCS file: /usr/local/cvsroot/temp_moodle_dev/lamstwo/db/Attic/mysql.sql,v
diff -u -r1.1 -r1.2
--- temp_moodle_dev/lamstwo/db/mysql.sql	24 Nov 2006 01:54:15 -0000	1.1
+++ temp_moodle_dev/lamstwo/db/mysql.sql	19 Aug 2008 07:29:31 -0000	1.2
@@ -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)
+);
