Changeset 139 for trunk/edufeedr_tables.sql

Timestamp:

08/23/10 20:55:35 (21 months ago)

Author:

gnum

Message:

References #96, facilitators can now be added to course. Still need to check it all again and see if everything is working well. NB! This will require additional table declared in edufeedr_tables.sql

Files:

• trunk/edufeedr_tables.sql (modified) (1 diff)

trunk/edufeedr_tables.sql

@@ -27 +27 @@
         PRIMARY KEY (id)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS prefix_edufeedr_course_facilitators (
+        id bigint(20) unsigned NOT NULL auto_increment,
+        course_guid bigint(20) unsigned NOT NULL,
+        user_guid bigint(20) unsigned NOT NULL,
+        PRIMARY KEY (id)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;