User authentication using external database.

Django authentication backend overriden to authenticate user using spoken tutorial database. Added database router to handle the database operations.
author: prathamesh 2014-03-26 14:48:45 +0530
committer: prathamesh 2014-03-26 14:48:45 +0530
commit: ba50e500a1da9266f9bee5bc38b69635637f6129 (patch)
tree: 4836211b8109824d9f8912e80f83be1e6f857ce0 /testapp
parent: b2a95b4f99debc4d165bb0122b03b8e67f26b669 (diff)
download: online_test-ba50e500a1da9266f9bee5bc38b69635637f6129.tar.gz
online_test-ba50e500a1da9266f9bee5bc38b69635637f6129.tar.bz2
online_test-ba50e500a1da9266f9bee5bc38b69635637f6129.zip
10 files changed, 4128 insertions, 3 deletions
diff --git a/testapp/exam/urls.py b/testapp/exam/urls.py
index 33b2edf..afeda68 100644
--- a/testapp/exam/urls.py
+++ b/testapp/exam/urls.py
@@ -11,7 +11,7 @@ urlpatterns = patterns('exam.views',
     url(r'^intro/(?P<questionpaper_id>\d+)/$','intro'),
     url(r'^complete/$', 'complete'),   
     url(r'^complete/(?P<questionpaper_id>\d+)/$', 'complete'),
-    url(r'^register/$', 'user_register'),
+    #url(r'^register/$', 'user_register'),
     url(r'^(?P<q_id>\d+)/$', 'question'),
     url(r'^(?P<q_id>\d+)/check/$', 'check'),
     url(r'^(?P<q_id>\d+)/check/(?P<questionpaper_id>\d+)/$', 'check'),
diff --git a/testapp/myauthentication/__init__.py b/testapp/myauthentication/__init__.py
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/testapp/myauthentication/__init__.py
diff --git a/testapp/myauthentication/backend.py b/testapp/myauthentication/backend.py
new file mode 100644
index 0000000..35dcfeb
--- /dev/null
+++ b/testapp/myauthentication/backend.py
@@ -0,0 +1,37 @@
+import hashlib
+from django.contrib.auth.models import User, check_password
+from models_spoken import MdlUser
+
+class MyBackend:
+    supports_object_permissions = False
+    supports_anonymous_user = False
+    supports_inactive_user = False
+
+    def authenticate(self, username=None, password=None):
+        try:
+            user = MdlUser.objects.get(username=username)
+            pwd = user.password
+            uid = user.id
+            firstname = user.firstname
+            lastname = user.lastname
+            email = user.email
+            p = hashlib.md5(password)
+	    pwd_valid =  (pwd == p.hexdigest())
+            if user and pwd_valid:
+                 try:
+                     print "here"
+                     user = User.objects.get(username=username)
+                     print "hh"
+                     return user
+                 except Exception, e:
+                     user=User(id=uid, username=username, password=pwd, first_name=firstname, last_name=lastname, email=email)
+                     user.save()
+                     return user
+        except Exception, e:
+            return None
+
+    def get_user(self, user_id):
+        try:
+            return User.objects.get(pk=user_id)
+        except Exception, e:
+            return None
diff --git a/testapp/myauthentication/models_spoken.py b/testapp/myauthentication/models_spoken.py
new file mode 100644
index 0000000..049a1d6
--- /dev/null
+++ b/testapp/myauthentication/models_spoken.py
@@ -0,0 +1,4039 @@
+# This is an auto-generated Django model module.
+# You'll have to do the following manually to clean this up:
+#     * Rearrange models' order
+#     * Make sure each model has one field with primary_key=True
+# Feel free to rename the models, but don't rename db_table values or field names.
+#
+# Also note: You'll have to insert the output of 'django-admin.py sqlcustom [appname]'
+# into your database.
+
+from django.db import models
+
+class ConQuestion(models.Model):
+    id = models.IntegerField(primary_key=True)
+    questiontext = models.TextField(blank=True)
+    qtype = models.CharField(max_length=150, blank=True)
+    count = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'con_question'
+
+class ConQuestionAnswerMcq(models.Model):
+    id = models.IntegerField(primary_key=True)
+    question = models.ForeignKey(ConQuestion, null=True, blank=True)
+    option1 = models.CharField(max_length=150, blank=True)
+    option2 = models.CharField(max_length=150, blank=True)
+    option3 = models.CharField(max_length=150, blank=True)
+    option4 = models.CharField(max_length=150, blank=True)
+    answer = models.CharField(max_length=150, blank=True)
+    class Meta:
+        db_table = u'con_question_answer_mcq'
+
+class ConQuestionAnswerShortanswer(models.Model):
+    id = models.IntegerField(primary_key=True)
+    question = models.ForeignKey(ConQuestion, null=True, blank=True)
+    answer = models.CharField(max_length=150, blank=True)
+    class Meta:
+        db_table = u'con_question_answer_shortanswer'
+
+class ConQuestionAnswerTruefalse(models.Model):
+    id = models.IntegerField(primary_key=True)
+    question = models.ForeignKey(ConQuestion, null=True, blank=True)
+    optiontrue = models.CharField(max_length=45, blank=True)
+    optionfalse = models.CharField(max_length=45, blank=True)
+    answer = models.CharField(max_length=45, blank=True)
+    class Meta:
+        db_table = u'con_question_answer_truefalse'
+
+class MdlAssign(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    alwaysshowdescription = models.IntegerField()
+    nosubmissions = models.IntegerField()
+    submissiondrafts = models.IntegerField()
+    sendnotifications = models.IntegerField()
+    sendlatenotifications = models.IntegerField()
+    duedate = models.BigIntegerField()
+    allowsubmissionsfromdate = models.BigIntegerField()
+    grade = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    requiresubmissionstatement = models.IntegerField()
+    completionsubmit = models.IntegerField()
+    cutoffdate = models.BigIntegerField()
+    teamsubmission = models.IntegerField()
+    requireallteammemberssubmit = models.IntegerField()
+    teamsubmissiongroupingid = models.BigIntegerField()
+    blindmarking = models.IntegerField()
+    revealidentities = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_assign'
+
+class MdlAssignGrades(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    grader = models.BigIntegerField()
+    grade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    locked = models.IntegerField()
+    mailed = models.IntegerField()
+    extensionduedate = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_assign_grades'
+
+class MdlAssignPluginConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    plugin = models.CharField(max_length=84)
+    subtype = models.CharField(max_length=84)
+    name = models.CharField(max_length=84)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_assign_plugin_config'
+
+class MdlAssignSubmission(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    status = models.CharField(max_length=30, blank=True)
+    groupid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_assign_submission'
+
+class MdlAssignUserMapping(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_assign_user_mapping'
+
+class MdlAssignfeedbackComments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    grade = models.BigIntegerField()
+    commenttext = models.TextField(blank=True)
+    commentformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_assignfeedback_comments'
+
+class MdlAssignfeedbackFile(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    grade = models.BigIntegerField()
+    numfiles = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_assignfeedback_file'
+
+class MdlAssignment(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    assignmenttype = models.CharField(max_length=150)
+    resubmit = models.IntegerField()
+    preventlate = models.IntegerField()
+    emailteachers = models.IntegerField()
+    var1 = models.BigIntegerField(null=True, blank=True)
+    var2 = models.BigIntegerField(null=True, blank=True)
+    var3 = models.BigIntegerField(null=True, blank=True)
+    var4 = models.BigIntegerField(null=True, blank=True)
+    var5 = models.BigIntegerField(null=True, blank=True)
+    maxbytes = models.BigIntegerField()
+    timedue = models.BigIntegerField()
+    timeavailable = models.BigIntegerField()
+    grade = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_assignment'
+
+class MdlAssignmentSubmissions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    numfiles = models.BigIntegerField()
+    data1 = models.TextField(blank=True)
+    data2 = models.TextField(blank=True)
+    grade = models.BigIntegerField()
+    submissioncomment = models.TextField()
+    format = models.IntegerField()
+    teacher = models.BigIntegerField()
+    timemarked = models.BigIntegerField()
+    mailed = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_assignment_submissions'
+
+class MdlAssignsubmissionFile(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    submission = models.BigIntegerField()
+    numfiles = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_assignsubmission_file'
+
+class MdlAssignsubmissionOnlinetext(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assignment = models.BigIntegerField()
+    submission = models.BigIntegerField()
+    onlinetext = models.TextField(blank=True)
+    onlineformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_assignsubmission_onlinetext'
+
+class MdlBackupControllers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    backupid = models.CharField(unique=True, max_length=96)
+    operation = models.CharField(max_length=60)
+    type = models.CharField(max_length=30)
+    itemid = models.BigIntegerField()
+    format = models.CharField(max_length=60)
+    interactive = models.IntegerField()
+    purpose = models.IntegerField()
+    userid = models.BigIntegerField()
+    status = models.IntegerField()
+    execution = models.IntegerField()
+    executiontime = models.BigIntegerField()
+    checksum = models.CharField(max_length=96)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    controller = models.TextField()
+    class Meta:
+        db_table = u'mdl_backup_controllers'
+
+class MdlBackupCourses(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField(unique=True)
+    laststarttime = models.BigIntegerField()
+    lastendtime = models.BigIntegerField()
+    laststatus = models.CharField(max_length=3)
+    nextstarttime = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_backup_courses'
+
+class MdlBackupFilesTemplate(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    backupid = models.CharField(max_length=96)
+    contextid = models.BigIntegerField()
+    component = models.CharField(max_length=300)
+    filearea = models.CharField(max_length=150)
+    itemid = models.BigIntegerField()
+    info = models.TextField(blank=True)
+    newcontextid = models.BigIntegerField(null=True, blank=True)
+    newitemid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_backup_files_template'
+
+class MdlBackupIdsTemplate(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    backupid = models.CharField(max_length=96)
+    itemname = models.CharField(max_length=480)
+    itemid = models.BigIntegerField(unique=True)
+    newitemid = models.BigIntegerField()
+    parentitemid = models.BigIntegerField(null=True, blank=True)
+    info = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_backup_ids_template'
+
+class MdlBackupLogs(models.Model):
+    id = models.BigIntegerField(unique=True)
+    backupid = models.CharField(max_length=96)
+    loglevel = models.IntegerField()
+    message = models.CharField(max_length=765)
+    timecreated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_backup_logs'
+
+class MdlBlock(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=120)
+    version = models.BigIntegerField()
+    cron = models.BigIntegerField()
+    lastcron = models.BigIntegerField()
+    visible = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_block'
+
+class MdlBlockCommunity(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    coursename = models.CharField(max_length=765)
+    coursedescription = models.TextField(blank=True)
+    courseurl = models.CharField(max_length=765)
+    imageurl = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_block_community'
+
+class MdlBlockInstances(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    blockname = models.CharField(max_length=120)
+    parentcontextid = models.BigIntegerField()
+    showinsubcontexts = models.IntegerField()
+    pagetypepattern = models.CharField(max_length=192)
+    subpagepattern = models.CharField(max_length=48, blank=True)
+    defaultregion = models.CharField(max_length=48)
+    defaultweight = models.BigIntegerField()
+    configdata = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_block_instances'
+
+class MdlBlockPositions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    blockinstanceid = models.BigIntegerField()
+    contextid = models.BigIntegerField()
+    pagetype = models.CharField(unique=True, max_length=192)
+    subpage = models.CharField(unique=True, max_length=48)
+    visible = models.IntegerField()
+    region = models.CharField(max_length=48)
+    weight = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_block_positions'
+
+class MdlBlockRssClient(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    title = models.TextField()
+    preferredtitle = models.CharField(max_length=192)
+    description = models.TextField()
+    shared = models.IntegerField()
+    url = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_block_rss_client'
+
+class MdlBlogAssociation(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    blogid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_blog_association'
+
+class MdlBlogExternal(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    description = models.TextField(blank=True)
+    url = models.TextField()
+    filtertags = models.CharField(max_length=765, blank=True)
+    failedlastsync = models.IntegerField()
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    timefetched = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_blog_external'
+
+class MdlBook(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    numbering = models.IntegerField()
+    customtitles = models.IntegerField()
+    revision = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_book'
+
+class MdlBookChapters(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    bookid = models.BigIntegerField()
+    pagenum = models.BigIntegerField()
+    subchapter = models.BigIntegerField()
+    title = models.CharField(max_length=765)
+    content = models.TextField()
+    contentformat = models.IntegerField()
+    hidden = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    importsrc = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_book_chapters'
+
+class MdlCacheFilters(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    filter = models.CharField(max_length=96)
+    version = models.BigIntegerField()
+    md5key = models.CharField(max_length=96)
+    rawtext = models.TextField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_cache_filters'
+
+class MdlCacheFlags(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    flagtype = models.CharField(max_length=765)
+    name = models.CharField(max_length=765)
+    timemodified = models.BigIntegerField()
+    value = models.TextField()
+    expiry = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_cache_flags'
+
+class MdlCacheText(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    md5key = models.CharField(max_length=96)
+    formattedtext = models.TextField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_cache_text'
+
+class MdlCapabilities(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=765)
+    captype = models.CharField(max_length=150)
+    contextlevel = models.BigIntegerField()
+    component = models.CharField(max_length=300)
+    riskbitmask = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_capabilities'
+
+class MdlChat(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    keepdays = models.BigIntegerField()
+    studentlogs = models.IntegerField()
+    chattime = models.BigIntegerField()
+    schedule = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_chat'
+
+class MdlChatMessages(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    chatid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    system = models.IntegerField()
+    message = models.TextField()
+    timestamp = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_chat_messages'
+
+class MdlChatMessagesCurrent(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    chatid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    system = models.IntegerField()
+    message = models.TextField()
+    timestamp = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_chat_messages_current'
+
+class MdlChatUsers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    chatid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    version = models.CharField(max_length=48)
+    ip = models.CharField(max_length=135)
+    firstping = models.BigIntegerField()
+    lastping = models.BigIntegerField()
+    lastmessageping = models.BigIntegerField()
+    sid = models.CharField(max_length=96)
+    course = models.BigIntegerField()
+    lang = models.CharField(max_length=90)
+    class Meta:
+        db_table = u'mdl_chat_users'
+
+class MdlChoice(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    publish = models.IntegerField()
+    showresults = models.IntegerField()
+    display = models.IntegerField()
+    allowupdate = models.IntegerField()
+    showunanswered = models.IntegerField()
+    limitanswers = models.IntegerField()
+    timeopen = models.BigIntegerField()
+    timeclose = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    completionsubmit = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_choice'
+
+class MdlChoiceAnswers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    choiceid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    optionid = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_choice_answers'
+
+class MdlChoiceOptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    choiceid = models.BigIntegerField()
+    text = models.TextField(blank=True)
+    maxanswers = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_choice_options'
+
+class MdlCohort(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    name = models.CharField(max_length=762)
+    idnumber = models.CharField(max_length=300, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    component = models.CharField(max_length=300)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_cohort'
+
+class MdlCohortMembers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    cohortid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timeadded = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_cohort_members'
+
+class MdlComments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    commentarea = models.CharField(max_length=765)
+    itemid = models.BigIntegerField()
+    content = models.TextField()
+    format = models.IntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_comments'
+
+class MdlConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=765)
+    value = models.TextField()
+    class Meta:
+        db_table = u'mdl_config'
+
+class MdlConfigLog(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    plugin = models.CharField(max_length=300, blank=True)
+    name = models.CharField(max_length=300)
+    value = models.TextField(blank=True)
+    oldvalue = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_config_log'
+
+class MdlConfigPlugins(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    plugin = models.CharField(unique=True, max_length=300)
+    name = models.CharField(unique=True, max_length=300)
+    value = models.TextField()
+    class Meta:
+        db_table = u'mdl_config_plugins'
+
+class MdlContext(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextlevel = models.BigIntegerField(unique=True)
+    instanceid = models.BigIntegerField()
+    path = models.CharField(max_length=765, blank=True)
+    depth = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_context'
+
+class MdlContextTemp(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    path = models.CharField(max_length=765)
+    depth = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_context_temp'
+
+class MdlCourse(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    category = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    fullname = models.CharField(max_length=762)
+    shortname = models.CharField(max_length=765)
+    idnumber = models.CharField(max_length=300)
+    summary = models.TextField(blank=True)
+    summaryformat = models.IntegerField()
+    format = models.CharField(max_length=63)
+    showgrades = models.IntegerField()
+    sectioncache = models.TextField(blank=True)
+    modinfo = models.TextField(blank=True)
+    newsitems = models.IntegerField()
+    startdate = models.BigIntegerField()
+    marker = models.BigIntegerField()
+    maxbytes = models.BigIntegerField()
+    legacyfiles = models.IntegerField()
+    showreports = models.IntegerField()
+    visible = models.IntegerField()
+    visibleold = models.IntegerField()
+    groupmode = models.IntegerField()
+    groupmodeforce = models.IntegerField()
+    defaultgroupingid = models.BigIntegerField()
+    lang = models.CharField(max_length=90)
+    theme = models.CharField(max_length=150)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    requested = models.IntegerField()
+    enablecompletion = models.IntegerField()
+    completionstartonenrol = models.IntegerField()
+    completionnotify = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_course'
+
+class MdlCourseCategories(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    idnumber = models.CharField(max_length=300, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    parent = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    coursecount = models.BigIntegerField()
+    visible = models.IntegerField()
+    visibleold = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    depth = models.BigIntegerField()
+    path = models.CharField(max_length=765)
+    theme = models.CharField(max_length=150, blank=True)
+    class Meta:
+        db_table = u'mdl_course_categories'
+
+class MdlCourseCompletionAggrMethd(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    criteriatype = models.BigIntegerField(null=True, blank=True)
+    method = models.IntegerField()
+    value = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    class Meta:
+        db_table = u'mdl_course_completion_aggr_methd'
+
+class MdlCourseCompletionCritCompl(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    course = models.BigIntegerField()
+    criteriaid = models.BigIntegerField()
+    gradefinal = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    unenroled = models.BigIntegerField(null=True, blank=True)
+    timecompleted = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_course_completion_crit_compl'
+
+class MdlCourseCompletionCriteria(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    criteriatype = models.BigIntegerField()
+    module = models.CharField(max_length=300, blank=True)
+    moduleinstance = models.BigIntegerField(null=True, blank=True)
+    courseinstance = models.BigIntegerField(null=True, blank=True)
+    enrolperiod = models.BigIntegerField(null=True, blank=True)
+    timeend = models.BigIntegerField(null=True, blank=True)
+    gradepass = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    role = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_course_completion_criteria'
+
+class MdlCourseCompletions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    course = models.BigIntegerField()
+    timeenrolled = models.BigIntegerField()
+    timestarted = models.BigIntegerField()
+    timecompleted = models.BigIntegerField(null=True, blank=True)
+    reaggregate = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_course_completions'
+
+class MdlCourseFormatOptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    format = models.CharField(unique=True, max_length=63)
+    sectionid = models.BigIntegerField(unique=True)
+    name = models.CharField(unique=True, max_length=300)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_course_format_options'
+
+class MdlCourseModules(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    module = models.BigIntegerField()
+    instance = models.BigIntegerField()
+    section = models.BigIntegerField()
+    idnumber = models.CharField(max_length=300, blank=True)
+    added = models.BigIntegerField()
+    score = models.IntegerField()
+    indent = models.IntegerField()
+    visible = models.IntegerField()
+    visibleold = models.IntegerField()
+    groupmode = models.IntegerField()
+    groupingid = models.BigIntegerField()
+    groupmembersonly = models.IntegerField()
+    completion = models.IntegerField()
+    completiongradeitemnumber = models.BigIntegerField(null=True, blank=True)
+    completionview = models.IntegerField()
+    completionexpected = models.BigIntegerField()
+    availablefrom = models.BigIntegerField()
+    availableuntil = models.BigIntegerField()
+    showavailability = models.IntegerField()
+    showdescription = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_course_modules'
+
+class MdlCourseModulesAvailFields(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    coursemoduleid = models.BigIntegerField()
+    userfield = models.CharField(max_length=150, blank=True)
+    customfieldid = models.BigIntegerField(null=True, blank=True)
+    operator = models.CharField(max_length=60)
+    value = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_course_modules_avail_fields'
+
+class MdlCourseModulesAvailability(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    coursemoduleid = models.BigIntegerField()
+    sourcecmid = models.BigIntegerField(null=True, blank=True)
+    requiredcompletion = models.IntegerField(null=True, blank=True)
+    gradeitemid = models.BigIntegerField(null=True, blank=True)
+    grademin = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    grademax = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    class Meta:
+        db_table = u'mdl_course_modules_availability'
+
+class MdlCourseModulesCompletion(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    coursemoduleid = models.BigIntegerField()
+    userid = models.BigIntegerField(unique=True)
+    completionstate = models.IntegerField()
+    viewed = models.IntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_course_modules_completion'
+
+class MdlCoursePublished(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    huburl = models.CharField(max_length=765, blank=True)
+    courseid = models.BigIntegerField()
+    timepublished = models.BigIntegerField()
+    enrollable = models.IntegerField()
+    hubcourseid = models.BigIntegerField()
+    status = models.IntegerField(null=True, blank=True)
+    timechecked = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_course_published'
+
+class MdlCourseRequest(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    fullname = models.CharField(max_length=762)
+    shortname = models.CharField(max_length=300)
+    summary = models.TextField()
+    summaryformat = models.IntegerField()
+    category = models.BigIntegerField()
+    reason = models.TextField()
+    requester = models.BigIntegerField()
+    password = models.CharField(max_length=150)
+    class Meta:
+        db_table = u'mdl_course_request'
+
+class MdlCourseSections(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField(unique=True)
+    section = models.BigIntegerField(unique=True)
+    name = models.CharField(max_length=765, blank=True)
+    summary = models.TextField(blank=True)
+    summaryformat = models.IntegerField()
+    sequence = models.TextField(blank=True)
+    visible = models.IntegerField()
+    availablefrom = models.BigIntegerField()
+    availableuntil = models.BigIntegerField()
+    showavailability = models.IntegerField()
+    groupingid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_course_sections'
+
+class MdlCourseSectionsAvailFields(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    coursesectionid = models.BigIntegerField()
+    userfield = models.CharField(max_length=150, blank=True)
+    customfieldid = models.BigIntegerField(null=True, blank=True)
+    operator = models.CharField(max_length=60)
+    value = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_course_sections_avail_fields'
+
+class MdlCourseSectionsAvailability(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    coursesectionid = models.BigIntegerField()
+    sourcecmid = models.BigIntegerField(null=True, blank=True)
+    requiredcompletion = models.IntegerField(null=True, blank=True)
+    gradeitemid = models.BigIntegerField(null=True, blank=True)
+    grademin = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    grademax = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    class Meta:
+        db_table = u'mdl_course_sections_availability'
+
+class MdlData(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    comments = models.IntegerField()
+    timeavailablefrom = models.BigIntegerField()
+    timeavailableto = models.BigIntegerField()
+    timeviewfrom = models.BigIntegerField()
+    timeviewto = models.BigIntegerField()
+    requiredentries = models.IntegerField()
+    requiredentriestoview = models.IntegerField()
+    maxentries = models.IntegerField()
+    rssarticles = models.IntegerField()
+    singletemplate = models.TextField(blank=True)
+    listtemplate = models.TextField(blank=True)
+    listtemplateheader = models.TextField(blank=True)
+    listtemplatefooter = models.TextField(blank=True)
+    addtemplate = models.TextField(blank=True)
+    rsstemplate = models.TextField(blank=True)
+    rsstitletemplate = models.TextField(blank=True)
+    csstemplate = models.TextField(blank=True)
+    jstemplate = models.TextField(blank=True)
+    asearchtemplate = models.TextField(blank=True)
+    approval = models.IntegerField()
+    scale = models.BigIntegerField()
+    assessed = models.BigIntegerField()
+    assesstimestart = models.BigIntegerField()
+    assesstimefinish = models.BigIntegerField()
+    defaultsort = models.BigIntegerField()
+    defaultsortdir = models.IntegerField()
+    editany = models.IntegerField()
+    notification = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_data'
+
+class MdlDataContent(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    fieldid = models.BigIntegerField()
+    recordid = models.BigIntegerField()
+    content = models.TextField(blank=True)
+    content1 = models.TextField(blank=True)
+    content2 = models.TextField(blank=True)
+    content3 = models.TextField(blank=True)
+    content4 = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_data_content'
+
+class MdlDataFields(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    dataid = models.BigIntegerField()
+    type = models.CharField(max_length=765)
+    name = models.CharField(max_length=765)
+    description = models.TextField()
+    param1 = models.TextField(blank=True)
+    param2 = models.TextField(blank=True)
+    param3 = models.TextField(blank=True)
+    param4 = models.TextField(blank=True)
+    param5 = models.TextField(blank=True)
+    param6 = models.TextField(blank=True)
+    param7 = models.TextField(blank=True)
+    param8 = models.TextField(blank=True)
+    param9 = models.TextField(blank=True)
+    param10 = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_data_fields'
+
+class MdlDataRecords(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    dataid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    approved = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_data_records'
+
+class MdlEnrol(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    enrol = models.CharField(max_length=60)
+    status = models.BigIntegerField()
+    courseid = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    name = models.CharField(max_length=765, blank=True)
+    enrolperiod = models.BigIntegerField(null=True, blank=True)
+    enrolstartdate = models.BigIntegerField(null=True, blank=True)
+    enrolenddate = models.BigIntegerField(null=True, blank=True)
+    expirynotify = models.IntegerField(null=True, blank=True)
+    expirythreshold = models.BigIntegerField(null=True, blank=True)
+    notifyall = models.IntegerField(null=True, blank=True)
+    password = models.CharField(max_length=150, blank=True)
+    cost = models.CharField(max_length=60, blank=True)
+    currency = models.CharField(max_length=9, blank=True)
+    roleid = models.BigIntegerField(null=True, blank=True)
+    customint1 = models.BigIntegerField(null=True, blank=True)
+    customint2 = models.BigIntegerField(null=True, blank=True)
+    customint3 = models.BigIntegerField(null=True, blank=True)
+    customint4 = models.BigIntegerField(null=True, blank=True)
+    customint5 = models.BigIntegerField(null=True, blank=True)
+    customint6 = models.BigIntegerField(null=True, blank=True)
+    customint7 = models.BigIntegerField(null=True, blank=True)
+    customint8 = models.BigIntegerField(null=True, blank=True)
+    customchar1 = models.CharField(max_length=765, blank=True)
+    customchar2 = models.CharField(max_length=765, blank=True)
+    customchar3 = models.CharField(max_length=3999, blank=True)
+    customdec1 = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    customdec2 = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    customtext1 = models.TextField(blank=True)
+    customtext2 = models.TextField(blank=True)
+    customtext3 = models.TextField(blank=True)
+    customtext4 = models.TextField(blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_enrol'
+
+class MdlEnrolAuthorize(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    paymentmethod = models.CharField(max_length=18)
+    refundinfo = models.IntegerField()
+    ccname = models.CharField(max_length=765)
+    courseid = models.BigIntegerField()
+    instanceid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    transid = models.BigIntegerField()
+    status = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    settletime = models.BigIntegerField()
+    amount = models.CharField(max_length=30)
+    currency = models.CharField(max_length=9)
+    class Meta:
+        db_table = u'mdl_enrol_authorize'
+
+class MdlEnrolAuthorizeRefunds(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    orderid = models.BigIntegerField()
+    status = models.IntegerField()
+    amount = models.CharField(max_length=30)
+    transid = models.BigIntegerField(null=True, blank=True)
+    settletime = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_enrol_authorize_refunds'
+
+class MdlEnrolFlatfile(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    action = models.CharField(max_length=90)
+    roleid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    courseid = models.BigIntegerField()
+    timestart = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_enrol_flatfile'
+
+class MdlEnrolPaypal(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    business = models.CharField(max_length=765)
+    receiver_email = models.CharField(max_length=765)
+    receiver_id = models.CharField(max_length=765)
+    item_name = models.CharField(max_length=765)
+    courseid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    instanceid = models.BigIntegerField()
+    memo = models.CharField(max_length=765)
+    tax = models.CharField(max_length=765)
+    option_name1 = models.CharField(max_length=765)
+    option_selection1_x = models.CharField(max_length=765)
+    option_name2 = models.CharField(max_length=765)
+    option_selection2_x = models.CharField(max_length=765)
+    payment_status = models.CharField(max_length=765)
+    pending_reason = models.CharField(max_length=765)
+    reason_code = models.CharField(max_length=90)
+    txn_id = models.CharField(max_length=765)
+    parent_txn_id = models.CharField(max_length=765)
+    payment_type = models.CharField(max_length=90)
+    timeupdated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_enrol_paypal'
+
+class MdlEvent(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    description = models.TextField()
+    format = models.IntegerField()
+    courseid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    repeatid = models.BigIntegerField()
+    modulename = models.CharField(max_length=60)
+    instance = models.BigIntegerField()
+    eventtype = models.CharField(max_length=60)
+    timestart = models.BigIntegerField()
+    timeduration = models.BigIntegerField()
+    visible = models.IntegerField()
+    uuid = models.CharField(max_length=765)
+    sequence = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    subscriptionid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_event'
+
+class MdlEventSubscriptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    url = models.CharField(max_length=765)
+    courseid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    eventtype = models.CharField(max_length=60)
+    pollinterval = models.BigIntegerField()
+    lastupdated = models.BigIntegerField(null=True, blank=True)
+    name = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_event_subscriptions'
+
+class MdlEventsHandlers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    eventname = models.CharField(unique=True, max_length=498)
+    component = models.CharField(unique=True, max_length=498)
+    handlerfile = models.CharField(max_length=765)
+    handlerfunction = models.TextField(blank=True)
+    schedule = models.CharField(max_length=765, blank=True)
+    status = models.BigIntegerField()
+    internal = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_events_handlers'
+
+class MdlEventsQueue(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    eventdata = models.TextField()
+    stackdump = models.TextField(blank=True)
+    userid = models.BigIntegerField(null=True, blank=True)
+    timecreated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_events_queue'
+
+class MdlEventsQueueHandlers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    queuedeventid = models.BigIntegerField()
+    handlerid = models.BigIntegerField()
+    status = models.BigIntegerField(null=True, blank=True)
+    errormessage = models.TextField(blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_events_queue_handlers'
+
+class MdlExternalFunctions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=600)
+    classname = models.CharField(max_length=300)
+    methodname = models.CharField(max_length=300)
+    classpath = models.CharField(max_length=765, blank=True)
+    component = models.CharField(max_length=300)
+    capabilities = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_external_functions'
+
+class MdlExternalServices(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=600)
+    enabled = models.IntegerField()
+    requiredcapability = models.CharField(max_length=450, blank=True)
+    restrictedusers = models.IntegerField()
+    component = models.CharField(max_length=300, blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    shortname = models.CharField(max_length=765, blank=True)
+    downloadfiles = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_external_services'
+
+class MdlExternalServicesFunctions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    externalserviceid = models.BigIntegerField()
+    functionname = models.CharField(max_length=600)
+    class Meta:
+        db_table = u'mdl_external_services_functions'
+
+class MdlExternalServicesUsers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    externalserviceid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    iprestriction = models.CharField(max_length=765, blank=True)
+    validuntil = models.BigIntegerField(null=True, blank=True)
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_external_services_users'
+
+class MdlExternalTokens(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    token = models.CharField(max_length=384)
+    tokentype = models.IntegerField()
+    userid = models.BigIntegerField()
+    externalserviceid = models.BigIntegerField()
+    sid = models.CharField(max_length=384, blank=True)
+    contextid = models.BigIntegerField()
+    creatorid = models.BigIntegerField()
+    iprestriction = models.CharField(max_length=765, blank=True)
+    validuntil = models.BigIntegerField(null=True, blank=True)
+    timecreated = models.BigIntegerField()
+    lastaccess = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_external_tokens'
+
+class MdlFeedback(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    anonymous = models.IntegerField()
+    email_notification = models.IntegerField()
+    multiple_submit = models.IntegerField()
+    autonumbering = models.IntegerField()
+    site_after_submit = models.CharField(max_length=765)
+    page_after_submit = models.TextField()
+    page_after_submitformat = models.IntegerField()
+    publish_stats = models.IntegerField()
+    timeopen = models.BigIntegerField()
+    timeclose = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    completionsubmit = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_feedback'
+
+class MdlFeedbackCompleted(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    feedback = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    random_response = models.BigIntegerField()
+    anonymous_response = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_feedback_completed'
+
+class MdlFeedbackCompletedtmp(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    feedback = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    guestid = models.CharField(max_length=765)
+    timemodified = models.BigIntegerField()
+    random_response = models.BigIntegerField()
+    anonymous_response = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_feedback_completedtmp'
+
+class MdlFeedbackItem(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    feedback = models.BigIntegerField()
+    template = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    label = models.CharField(max_length=765)
+    presentation = models.TextField()
+    typ = models.CharField(max_length=765)
+    hasvalue = models.IntegerField()
+    position = models.IntegerField()
+    required = models.IntegerField()
+    dependitem = models.BigIntegerField()
+    dependvalue = models.CharField(max_length=765)
+    options = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_feedback_item'
+
+class MdlFeedbackSitecourseMap(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    feedbackid = models.BigIntegerField()
+    courseid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_feedback_sitecourse_map'
+
+class MdlFeedbackTemplate(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    ispublic = models.IntegerField()
+    name = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_feedback_template'
+
+class MdlFeedbackTracking(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    feedback = models.BigIntegerField()
+    completed = models.BigIntegerField()
+    tmp_completed = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_feedback_tracking'
+
+class MdlFeedbackValue(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course_id = models.BigIntegerField()
+    item = models.BigIntegerField()
+    completed = models.BigIntegerField()
+    tmp_completed = models.BigIntegerField()
+    value = models.TextField()
+    class Meta:
+        db_table = u'mdl_feedback_value'
+
+class MdlFeedbackValuetmp(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course_id = models.BigIntegerField()
+    item = models.BigIntegerField()
+    completed = models.BigIntegerField()
+    tmp_completed = models.BigIntegerField()
+    value = models.TextField()
+    class Meta:
+        db_table = u'mdl_feedback_valuetmp'
+
+class MdlFiles(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contenthash = models.CharField(max_length=120)
+    pathnamehash = models.CharField(unique=True, max_length=120)
+    contextid = models.BigIntegerField()
+    component = models.CharField(max_length=300)
+    filearea = models.CharField(max_length=150)
+    itemid = models.BigIntegerField()
+    filepath = models.CharField(max_length=765)
+    filename = models.CharField(max_length=765)
+    userid = models.BigIntegerField(null=True, blank=True)
+    filesize = models.BigIntegerField()
+    mimetype = models.CharField(max_length=300, blank=True)
+    status = models.BigIntegerField()
+    source = models.TextField(blank=True)
+    author = models.CharField(max_length=765, blank=True)
+    license = models.CharField(max_length=765, blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    referencefileid = models.BigIntegerField(null=True, blank=True)
+    referencelastsync = models.BigIntegerField(null=True, blank=True)
+    referencelifetime = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_files'
+
+class MdlFilesReference(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    repositoryid = models.BigIntegerField()
+    lastsync = models.BigIntegerField(null=True, blank=True)
+    lifetime = models.BigIntegerField(null=True, blank=True)
+    reference = models.TextField(blank=True)
+    referencehash = models.CharField(unique=True, max_length=120)
+    class Meta:
+        db_table = u'mdl_files_reference'
+
+class MdlFilterActive(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    filter = models.CharField(unique=True, max_length=96)
+    contextid = models.BigIntegerField()
+    active = models.IntegerField()
+    sortorder = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_filter_active'
+
+class MdlFilterConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    filter = models.CharField(unique=True, max_length=96)
+    contextid = models.BigIntegerField()
+    name = models.CharField(unique=True, max_length=765)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_filter_config'
+
+class MdlFolder(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    revision = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_folder'
+
+class MdlForum(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    type = models.CharField(max_length=60)
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    assessed = models.BigIntegerField()
+    assesstimestart = models.BigIntegerField()
+    assesstimefinish = models.BigIntegerField()
+    scale = models.BigIntegerField()
+    maxbytes = models.BigIntegerField()
+    maxattachments = models.BigIntegerField()
+    forcesubscribe = models.IntegerField()
+    trackingtype = models.IntegerField()
+    rsstype = models.IntegerField()
+    rssarticles = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    warnafter = models.BigIntegerField()
+    blockafter = models.BigIntegerField()
+    blockperiod = models.BigIntegerField()
+    completiondiscussions = models.IntegerField()
+    completionreplies = models.IntegerField()
+    completionposts = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_forum'
+
+class MdlForumDiscussions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    forum = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    firstpost = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    assessed = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    usermodified = models.BigIntegerField()
+    timestart = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_forum_discussions'
+
+class MdlForumPosts(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    discussion = models.BigIntegerField()
+    parent = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    created = models.BigIntegerField()
+    modified = models.BigIntegerField()
+    mailed = models.IntegerField()
+    subject = models.CharField(max_length=765)
+    message = models.TextField()
+    messageformat = models.IntegerField()
+    messagetrust = models.IntegerField()
+    attachment = models.CharField(max_length=300)
+    totalscore = models.IntegerField()
+    mailnow = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_forum_posts'
+
+class MdlForumQueue(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    discussionid = models.BigIntegerField()
+    postid = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_forum_queue'
+
+class MdlForumRead(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    forumid = models.BigIntegerField()
+    discussionid = models.BigIntegerField()
+    postid = models.BigIntegerField()
+    firstread = models.BigIntegerField()
+    lastread = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_forum_read'
+
+class MdlForumSubscriptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    forum = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_forum_subscriptions'
+
+class MdlForumTrackPrefs(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    forumid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_forum_track_prefs'
+
+class MdlGlossary(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    allowduplicatedentries = models.IntegerField()
+    displayformat = models.CharField(max_length=150)
+    mainglossary = models.IntegerField()
+    showspecial = models.IntegerField()
+    showalphabet = models.IntegerField()
+    showall = models.IntegerField()
+    allowcomments = models.IntegerField()
+    allowprintview = models.IntegerField()
+    usedynalink = models.IntegerField()
+    defaultapproval = models.IntegerField()
+    approvaldisplayformat = models.CharField(max_length=150)
+    globalglossary = models.IntegerField()
+    entbypage = models.IntegerField()
+    editalways = models.IntegerField()
+    rsstype = models.IntegerField()
+    rssarticles = models.IntegerField()
+    assessed = models.BigIntegerField()
+    assesstimestart = models.BigIntegerField()
+    assesstimefinish = models.BigIntegerField()
+    scale = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    completionentries = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_glossary'
+
+class MdlGlossaryAlias(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    entryid = models.BigIntegerField()
+    alias = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_glossary_alias'
+
+class MdlGlossaryCategories(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    glossaryid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    usedynalink = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_glossary_categories'
+
+class MdlGlossaryEntries(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    glossaryid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    concept = models.CharField(max_length=765)
+    definition = models.TextField()
+    definitionformat = models.IntegerField()
+    definitiontrust = models.IntegerField()
+    attachment = models.CharField(max_length=300)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    teacherentry = models.IntegerField()
+    sourceglossaryid = models.BigIntegerField()
+    usedynalink = models.IntegerField()
+    casesensitive = models.IntegerField()
+    fullmatch = models.IntegerField()
+    approved = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_glossary_entries'
+
+class MdlGlossaryEntriesCategories(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    categoryid = models.BigIntegerField()
+    entryid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_glossary_entries_categories'
+
+class MdlGlossaryFormats(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=150)
+    popupformatname = models.CharField(max_length=150)
+    visible = models.IntegerField()
+    showgroup = models.IntegerField()
+    defaultmode = models.CharField(max_length=150)
+    defaulthook = models.CharField(max_length=150)
+    sortkey = models.CharField(max_length=150)
+    sortorder = models.CharField(max_length=150)
+    class Meta:
+        db_table = u'mdl_glossary_formats'
+
+class MdlGradeCategories(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    parent = models.BigIntegerField(null=True, blank=True)
+    depth = models.BigIntegerField()
+    path = models.CharField(max_length=765, blank=True)
+    fullname = models.CharField(max_length=765)
+    aggregation = models.BigIntegerField()
+    keephigh = models.BigIntegerField()
+    droplow = models.BigIntegerField()
+    aggregateonlygraded = models.IntegerField()
+    aggregateoutcomes = models.IntegerField()
+    aggregatesubcats = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    hidden = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_grade_categories'
+
+class MdlGradeCategoriesHistory(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    action = models.BigIntegerField()
+    oldid = models.BigIntegerField()
+    source = models.CharField(max_length=765, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    loggeduser = models.BigIntegerField(null=True, blank=True)
+    courseid = models.BigIntegerField()
+    parent = models.BigIntegerField(null=True, blank=True)
+    depth = models.BigIntegerField()
+    path = models.CharField(max_length=765, blank=True)
+    fullname = models.CharField(max_length=765)
+    aggregation = models.BigIntegerField()
+    keephigh = models.BigIntegerField()
+    droplow = models.BigIntegerField()
+    aggregateonlygraded = models.IntegerField()
+    aggregateoutcomes = models.IntegerField()
+    aggregatesubcats = models.IntegerField()
+    hidden = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_grade_categories_history'
+
+class MdlGradeGrades(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    itemid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    rawgrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    rawgrademax = models.DecimalField(max_digits=12, decimal_places=5)
+    rawgrademin = models.DecimalField(max_digits=12, decimal_places=5)
+    rawscaleid = models.BigIntegerField(null=True, blank=True)
+    usermodified = models.BigIntegerField(null=True, blank=True)
+    finalgrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    hidden = models.BigIntegerField()
+    locked = models.BigIntegerField()
+    locktime = models.BigIntegerField()
+    exported = models.BigIntegerField()
+    overridden = models.BigIntegerField()
+    excluded = models.BigIntegerField()
+    feedback = models.TextField(blank=True)
+    feedbackformat = models.BigIntegerField()
+    information = models.TextField(blank=True)
+    informationformat = models.BigIntegerField()
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_grade_grades'
+
+class MdlGradeGradesHistory(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    action = models.BigIntegerField()
+    oldid = models.BigIntegerField()
+    source = models.CharField(max_length=765, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    loggeduser = models.BigIntegerField(null=True, blank=True)
+    itemid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    rawgrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    rawgrademax = models.DecimalField(max_digits=12, decimal_places=5)
+    rawgrademin = models.DecimalField(max_digits=12, decimal_places=5)
+    rawscaleid = models.BigIntegerField(null=True, blank=True)
+    usermodified = models.BigIntegerField(null=True, blank=True)
+    finalgrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    hidden = models.BigIntegerField()
+    locked = models.BigIntegerField()
+    locktime = models.BigIntegerField()
+    exported = models.BigIntegerField()
+    overridden = models.BigIntegerField()
+    excluded = models.BigIntegerField()
+    feedback = models.TextField(blank=True)
+    feedbackformat = models.BigIntegerField()
+    information = models.TextField(blank=True)
+    informationformat = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_grade_grades_history'
+
+class MdlGradeImportNewitem(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    itemname = models.CharField(max_length=765)
+    importcode = models.BigIntegerField()
+    importer = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_grade_import_newitem'
+
+class MdlGradeImportValues(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    itemid = models.BigIntegerField(null=True, blank=True)
+    newgradeitem = models.BigIntegerField(null=True, blank=True)
+    userid = models.BigIntegerField()
+    finalgrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    feedback = models.TextField(blank=True)
+    importcode = models.BigIntegerField()
+    importer = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_grade_import_values'
+
+class MdlGradeItems(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField(null=True, blank=True)
+    categoryid = models.BigIntegerField(null=True, blank=True)
+    itemname = models.CharField(max_length=765, blank=True)
+    itemtype = models.CharField(max_length=90)
+    itemmodule = models.CharField(max_length=90, blank=True)
+    iteminstance = models.BigIntegerField(null=True, blank=True)
+    itemnumber = models.BigIntegerField(null=True, blank=True)
+    iteminfo = models.TextField(blank=True)
+    idnumber = models.CharField(max_length=765, blank=True)
+    calculation = models.TextField(blank=True)
+    gradetype = models.IntegerField()
+    grademax = models.DecimalField(max_digits=12, decimal_places=5)
+    grademin = models.DecimalField(max_digits=12, decimal_places=5)
+    scaleid = models.BigIntegerField(null=True, blank=True)
+    outcomeid = models.BigIntegerField(null=True, blank=True)
+    gradepass = models.DecimalField(max_digits=12, decimal_places=5)
+    multfactor = models.DecimalField(max_digits=12, decimal_places=5)
+    plusfactor = models.DecimalField(max_digits=12, decimal_places=5)
+    aggregationcoef = models.DecimalField(max_digits=12, decimal_places=5)
+    sortorder = models.BigIntegerField()
+    display = models.BigIntegerField()
+    decimals = models.IntegerField(null=True, blank=True)
+    hidden = models.BigIntegerField()
+    locked = models.BigIntegerField()
+    locktime = models.BigIntegerField()
+    needsupdate = models.BigIntegerField()
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_grade_items'
+
+class MdlGradeItemsHistory(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    action = models.BigIntegerField()
+    oldid = models.BigIntegerField()
+    source = models.CharField(max_length=765, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    loggeduser = models.BigIntegerField(null=True, blank=True)
+    courseid = models.BigIntegerField(null=True, blank=True)
+    categoryid = models.BigIntegerField(null=True, blank=True)
+    itemname = models.CharField(max_length=765, blank=True)
+    itemtype = models.CharField(max_length=90)
+    itemmodule = models.CharField(max_length=90, blank=True)
+    iteminstance = models.BigIntegerField(null=True, blank=True)
+    itemnumber = models.BigIntegerField(null=True, blank=True)
+    iteminfo = models.TextField(blank=True)
+    idnumber = models.CharField(max_length=765, blank=True)
+    calculation = models.TextField(blank=True)
+    gradetype = models.IntegerField()
+    grademax = models.DecimalField(max_digits=12, decimal_places=5)
+    grademin = models.DecimalField(max_digits=12, decimal_places=5)
+    scaleid = models.BigIntegerField(null=True, blank=True)
+    outcomeid = models.BigIntegerField(null=True, blank=True)
+    gradepass = models.DecimalField(max_digits=12, decimal_places=5)
+    multfactor = models.DecimalField(max_digits=12, decimal_places=5)
+    plusfactor = models.DecimalField(max_digits=12, decimal_places=5)
+    aggregationcoef = models.DecimalField(max_digits=12, decimal_places=5)
+    sortorder = models.BigIntegerField()
+    hidden = models.BigIntegerField()
+    locked = models.BigIntegerField()
+    locktime = models.BigIntegerField()
+    needsupdate = models.BigIntegerField()
+    display = models.BigIntegerField()
+    decimals = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_grade_items_history'
+
+class MdlGradeLetters(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField(unique=True)
+    lowerboundary = models.DecimalField(unique=True, max_digits=12, decimal_places=5)
+    letter = models.CharField(unique=True, max_length=765)
+    class Meta:
+        db_table = u'mdl_grade_letters'
+
+class MdlGradeOutcomes(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField(null=True, blank=True)
+    shortname = models.CharField(unique=True, max_length=765)
+    fullname = models.TextField()
+    scaleid = models.BigIntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    usermodified = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_grade_outcomes'
+
+class MdlGradeOutcomesCourses(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    outcomeid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_grade_outcomes_courses'
+
+class MdlGradeOutcomesHistory(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    action = models.BigIntegerField()
+    oldid = models.BigIntegerField()
+    source = models.CharField(max_length=765, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    loggeduser = models.BigIntegerField(null=True, blank=True)
+    courseid = models.BigIntegerField(null=True, blank=True)
+    shortname = models.CharField(max_length=765)
+    fullname = models.TextField()
+    scaleid = models.BigIntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_grade_outcomes_history'
+
+class MdlGradeSettings(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    name = models.CharField(unique=True, max_length=765)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_grade_settings'
+
+class MdlGradingAreas(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    component = models.CharField(unique=True, max_length=300)
+    areaname = models.CharField(unique=True, max_length=300)
+    activemethod = models.CharField(max_length=300, blank=True)
+    class Meta:
+        db_table = u'mdl_grading_areas'
+
+class MdlGradingDefinitions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    areaid = models.BigIntegerField()
+    method = models.CharField(unique=True, max_length=300)
+    name = models.CharField(max_length=765)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    status = models.BigIntegerField()
+    copiedfromid = models.BigIntegerField(null=True, blank=True)
+    timecreated = models.BigIntegerField()
+    usercreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    usermodified = models.BigIntegerField()
+    timecopied = models.BigIntegerField(null=True, blank=True)
+    options = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_grading_definitions'
+
+class MdlGradingInstances(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    definitionid = models.BigIntegerField()
+    raterid = models.BigIntegerField()
+    itemid = models.BigIntegerField(null=True, blank=True)
+    rawgrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    status = models.BigIntegerField()
+    feedback = models.TextField(blank=True)
+    feedbackformat = models.IntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_grading_instances'
+
+class MdlGradingformGuideComments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    definitionid = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_gradingform_guide_comments'
+
+class MdlGradingformGuideCriteria(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    definitionid = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    shortname = models.CharField(max_length=765)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    descriptionmarkers = models.TextField(blank=True)
+    descriptionmarkersformat = models.IntegerField(null=True, blank=True)
+    maxscore = models.DecimalField(max_digits=12, decimal_places=5)
+    class Meta:
+        db_table = u'mdl_gradingform_guide_criteria'
+
+class MdlGradingformGuideFillings(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    instanceid = models.BigIntegerField()
+    criterionid = models.BigIntegerField()
+    remark = models.TextField(blank=True)
+    remarkformat = models.IntegerField(null=True, blank=True)
+    score = models.DecimalField(max_digits=12, decimal_places=5)
+    class Meta:
+        db_table = u'mdl_gradingform_guide_fillings'
+
+class MdlGradingformRubricCriteria(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    definitionid = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_gradingform_rubric_criteria'
+
+class MdlGradingformRubricFillings(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    instanceid = models.BigIntegerField()
+    criterionid = models.BigIntegerField()
+    levelid = models.BigIntegerField(null=True, blank=True)
+    remark = models.TextField(blank=True)
+    remarkformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_gradingform_rubric_fillings'
+
+class MdlGradingformRubricLevels(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    criterionid = models.BigIntegerField()
+    score = models.DecimalField(max_digits=12, decimal_places=5)
+    definition = models.TextField(blank=True)
+    definitionformat = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_gradingform_rubric_levels'
+
+class MdlGroupings(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    idnumber = models.CharField(max_length=300)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    configdata = models.TextField(blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_groupings'
+
+class MdlGroupingsGroups(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    groupingid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    timeadded = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_groupings_groups'
+
+class MdlGroups(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    idnumber = models.CharField(max_length=300)
+    name = models.CharField(max_length=762)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    enrolmentkey = models.CharField(max_length=150, blank=True)
+    picture = models.BigIntegerField()
+    hidepicture = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_groups'
+
+class MdlGroupsMembers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    groupid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timeadded = models.BigIntegerField()
+    component = models.CharField(max_length=300)
+    itemid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_groups_members'
+
+class MdlImscp(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    revision = models.BigIntegerField()
+    keepold = models.BigIntegerField()
+    structure = models.TextField(blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_imscp'
+
+class MdlLabel(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_label'
+
+class MdlLesson(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    practice = models.IntegerField()
+    modattempts = models.IntegerField()
+    usepassword = models.IntegerField()
+    password = models.CharField(max_length=96)
+    dependency = models.BigIntegerField()
+    conditions = models.TextField()
+    grade = models.IntegerField()
+    custom = models.IntegerField()
+    ongoing = models.IntegerField()
+    usemaxgrade = models.IntegerField()
+    maxanswers = models.IntegerField()
+    maxattempts = models.IntegerField()
+    review = models.IntegerField()
+    nextpagedefault = models.IntegerField()
+    feedback = models.IntegerField()
+    minquestions = models.IntegerField()
+    maxpages = models.IntegerField()
+    timed = models.IntegerField()
+    maxtime = models.BigIntegerField()
+    retake = models.IntegerField()
+    activitylink = models.BigIntegerField()
+    mediafile = models.CharField(max_length=765)
+    mediaheight = models.BigIntegerField()
+    mediawidth = models.BigIntegerField()
+    mediaclose = models.IntegerField()
+    slideshow = models.IntegerField()
+    width = models.BigIntegerField()
+    height = models.BigIntegerField()
+    bgcolor = models.CharField(max_length=21)
+    displayleft = models.IntegerField()
+    displayleftif = models.IntegerField()
+    progressbar = models.IntegerField()
+    highscores = models.IntegerField()
+    maxhighscores = models.BigIntegerField()
+    available = models.BigIntegerField()
+    deadline = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_lesson'
+
+class MdlLessonAnswers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    pageid = models.BigIntegerField()
+    jumpto = models.BigIntegerField()
+    grade = models.IntegerField()
+    score = models.BigIntegerField()
+    flags = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    answer = models.TextField(blank=True)
+    answerformat = models.IntegerField()
+    response = models.TextField(blank=True)
+    responseformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_lesson_answers'
+
+class MdlLessonAttempts(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    pageid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    answerid = models.BigIntegerField()
+    retry = models.IntegerField()
+    correct = models.BigIntegerField()
+    useranswer = models.TextField(blank=True)
+    timeseen = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_lesson_attempts'
+
+class MdlLessonBranch(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    pageid = models.BigIntegerField()
+    retry = models.BigIntegerField()
+    flag = models.IntegerField()
+    timeseen = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_lesson_branch'
+
+class MdlLessonGrades(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    grade = models.FloatField()
+    late = models.IntegerField()
+    completed = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_lesson_grades'
+
+class MdlLessonHighScores(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    gradeid = models.BigIntegerField()
+    nickname = models.CharField(max_length=15)
+    class Meta:
+        db_table = u'mdl_lesson_high_scores'
+
+class MdlLessonPages(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    prevpageid = models.BigIntegerField()
+    nextpageid = models.BigIntegerField()
+    qtype = models.IntegerField()
+    qoption = models.IntegerField()
+    layout = models.IntegerField()
+    display = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    title = models.CharField(max_length=765)
+    contents = models.TextField()
+    contentsformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_lesson_pages'
+
+class MdlLessonTimer(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lessonid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    starttime = models.BigIntegerField()
+    lessontime = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_lesson_timer'
+
+class MdlLicense(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    shortname = models.CharField(max_length=765, blank=True)
+    fullname = models.TextField(blank=True)
+    source = models.CharField(max_length=765, blank=True)
+    enabled = models.IntegerField()
+    version = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_license'
+
+class MdlLog(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    time = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    ip = models.CharField(max_length=135)
+    course = models.BigIntegerField()
+    module = models.CharField(max_length=60)
+    cmid = models.BigIntegerField()
+    action = models.CharField(max_length=120)
+    url = models.CharField(max_length=300)
+    info = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_log'
+
+class MdlLogDisplay(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    module = models.CharField(unique=True, max_length=60)
+    action = models.CharField(unique=True, max_length=120)
+    mtable = models.CharField(max_length=90)
+    field = models.CharField(max_length=600)
+    component = models.CharField(max_length=300)
+    class Meta:
+        db_table = u'mdl_log_display'
+
+class MdlLogQueries(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    qtype = models.IntegerField()
+    sqltext = models.TextField()
+    sqlparams = models.TextField(blank=True)
+    error = models.IntegerField()
+    info = models.TextField(blank=True)
+    backtrace = models.TextField(blank=True)
+    exectime = models.DecimalField(max_digits=12, decimal_places=5)
+    timelogged = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_log_queries'
+
+class MdlLti(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField(null=True, blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    typeid = models.BigIntegerField(null=True, blank=True)
+    toolurl = models.TextField()
+    securetoolurl = models.TextField(blank=True)
+    instructorchoicesendname = models.IntegerField(null=True, blank=True)
+    instructorchoicesendemailaddr = models.IntegerField(null=True, blank=True)
+    instructorchoiceallowroster = models.IntegerField(null=True, blank=True)
+    instructorchoiceallowsetting = models.IntegerField(null=True, blank=True)
+    instructorcustomparameters = models.CharField(max_length=765, blank=True)
+    instructorchoiceacceptgrades = models.IntegerField(null=True, blank=True)
+    grade = models.DecimalField(max_digits=12, decimal_places=5)
+    launchcontainer = models.IntegerField()
+    resourcekey = models.CharField(max_length=765, blank=True)
+    password = models.CharField(max_length=765, blank=True)
+    debuglaunch = models.IntegerField()
+    showtitlelaunch = models.IntegerField()
+    showdescriptionlaunch = models.IntegerField()
+    servicesalt = models.CharField(max_length=120, blank=True)
+    icon = models.TextField(blank=True)
+    secureicon = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_lti'
+
+class MdlLtiSubmission(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    ltiid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    datesubmitted = models.BigIntegerField()
+    dateupdated = models.BigIntegerField()
+    gradepercent = models.DecimalField(max_digits=12, decimal_places=5)
+    originalgrade = models.DecimalField(max_digits=12, decimal_places=5)
+    launchid = models.BigIntegerField()
+    state = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_lti_submission'
+
+class MdlLtiTypes(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    baseurl = models.TextField()
+    tooldomain = models.CharField(max_length=765)
+    state = models.IntegerField()
+    course = models.BigIntegerField()
+    coursevisible = models.IntegerField()
+    createdby = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_lti_types'
+
+class MdlLtiTypesConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    typeid = models.BigIntegerField()
+    name = models.CharField(max_length=300)
+    value = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_lti_types_config'
+
+class MdlMessage(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    useridfrom = models.BigIntegerField()
+    useridto = models.BigIntegerField()
+    subject = models.TextField(blank=True)
+    fullmessage = models.TextField(blank=True)
+    fullmessageformat = models.IntegerField(null=True, blank=True)
+    fullmessagehtml = models.TextField(blank=True)
+    smallmessage = models.TextField(blank=True)
+    notification = models.IntegerField(null=True, blank=True)
+    contexturl = models.TextField(blank=True)
+    contexturlname = models.TextField(blank=True)
+    timecreated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_message'
+
+class MdlMessageContacts(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField(unique=True)
+    contactid = models.BigIntegerField(unique=True)
+    blocked = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_message_contacts'
+
+class MdlMessageProcessors(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=498)
+    enabled = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_message_processors'
+
+class MdlMessageProviders(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=300)
+    component = models.CharField(unique=True, max_length=600)
+    capability = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_message_providers'
+
+class MdlMessageRead(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    useridfrom = models.BigIntegerField()
+    useridto = models.BigIntegerField()
+    subject = models.TextField(blank=True)
+    fullmessage = models.TextField(blank=True)
+    fullmessageformat = models.IntegerField(null=True, blank=True)
+    fullmessagehtml = models.TextField(blank=True)
+    smallmessage = models.TextField(blank=True)
+    notification = models.IntegerField(null=True, blank=True)
+    contexturl = models.TextField(blank=True)
+    contexturlname = models.TextField(blank=True)
+    timecreated = models.BigIntegerField()
+    timeread = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_message_read'
+
+class MdlMessageWorking(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    unreadmessageid = models.BigIntegerField()
+    processorid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_message_working'
+
+class MdlMnetApplication(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=150)
+    display_name = models.CharField(max_length=150)
+    xmlrpc_server_url = models.CharField(max_length=765)
+    sso_land_url = models.CharField(max_length=765)
+    sso_jump_url = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_mnet_application'
+
+class MdlMnetHost(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    deleted = models.IntegerField()
+    wwwroot = models.CharField(max_length=765)
+    ip_address = models.CharField(max_length=135)
+    name = models.CharField(max_length=240)
+    public_key = models.TextField()
+    public_key_expires = models.BigIntegerField()
+    transport = models.IntegerField()
+    portno = models.IntegerField()
+    last_connect_time = models.BigIntegerField()
+    last_log_id = models.BigIntegerField()
+    force_theme = models.IntegerField()
+    theme = models.CharField(max_length=300, blank=True)
+    applicationid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_mnet_host'
+
+class MdlMnetHost2Service(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    hostid = models.BigIntegerField(unique=True)
+    serviceid = models.BigIntegerField(unique=True)
+    publish = models.IntegerField()
+    subscribe = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_mnet_host2service'
+
+class MdlMnetLog(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    hostid = models.BigIntegerField()
+    remoteid = models.BigIntegerField()
+    time = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    ip = models.CharField(max_length=135)
+    course = models.BigIntegerField()
+    coursename = models.CharField(max_length=120)
+    module = models.CharField(max_length=60)
+    cmid = models.BigIntegerField()
+    action = models.CharField(max_length=120)
+    url = models.CharField(max_length=300)
+    info = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_mnet_log'
+
+class MdlMnetRemoteRpc(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    functionname = models.CharField(max_length=120)
+    xmlrpcpath = models.CharField(max_length=240)
+    plugintype = models.CharField(max_length=60)
+    pluginname = models.CharField(max_length=60)
+    enabled = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_mnet_remote_rpc'
+
+class MdlMnetRemoteService2Rpc(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    serviceid = models.BigIntegerField(unique=True)
+    rpcid = models.BigIntegerField(unique=True)
+    class Meta:
+        db_table = u'mdl_mnet_remote_service2rpc'
+
+class MdlMnetRpc(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    functionname = models.CharField(max_length=120)
+    xmlrpcpath = models.CharField(max_length=240)
+    plugintype = models.CharField(max_length=60)
+    pluginname = models.CharField(max_length=60)
+    enabled = models.IntegerField()
+    help = models.TextField()
+    profile = models.TextField()
+    filename = models.CharField(max_length=300)
+    classname = models.CharField(max_length=450, blank=True)
+    static = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_mnet_rpc'
+
+class MdlMnetService(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=120)
+    description = models.CharField(max_length=120)
+    apiversion = models.CharField(max_length=30)
+    offer = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_mnet_service'
+
+class MdlMnetService2Rpc(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    serviceid = models.BigIntegerField(unique=True)
+    rpcid = models.BigIntegerField(unique=True)
+    class Meta:
+        db_table = u'mdl_mnet_service2rpc'
+
+class MdlMnetSession(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    username = models.CharField(max_length=300)
+    token = models.CharField(unique=True, max_length=120)
+    mnethostid = models.BigIntegerField()
+    useragent = models.CharField(max_length=120)
+    confirm_timeout = models.BigIntegerField()
+    session_id = models.CharField(max_length=120)
+    expires = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_mnet_session'
+
+class MdlMnetSsoAccessControl(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    username = models.CharField(unique=True, max_length=300)
+    mnet_host_id = models.BigIntegerField(unique=True)
+    accessctrl = models.CharField(max_length=60)
+    class Meta:
+        db_table = u'mdl_mnet_sso_access_control'
+
+class MdlMnetserviceEnrolCourses(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    hostid = models.BigIntegerField(unique=True)
+    remoteid = models.BigIntegerField(unique=True)
+    categoryid = models.BigIntegerField()
+    categoryname = models.CharField(max_length=765)
+    sortorder = models.BigIntegerField()
+    fullname = models.CharField(max_length=762)
+    shortname = models.CharField(max_length=300)
+    idnumber = models.CharField(max_length=300)
+    summary = models.TextField()
+    summaryformat = models.IntegerField(null=True, blank=True)
+    startdate = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    rolename = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_mnetservice_enrol_courses'
+
+class MdlMnetserviceEnrolEnrolments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    hostid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    remotecourseid = models.BigIntegerField()
+    rolename = models.CharField(max_length=765)
+    enroltime = models.BigIntegerField()
+    enroltype = models.CharField(max_length=60)
+    class Meta:
+        db_table = u'mdl_mnetservice_enrol_enrolments'
+
+class MdlModules(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=60)
+    version = models.BigIntegerField()
+    cron = models.BigIntegerField()
+    lastcron = models.BigIntegerField()
+    search = models.CharField(max_length=765)
+    visible = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_modules'
+
+class MdlMyPages(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField(null=True, blank=True)
+    name = models.CharField(max_length=600)
+    private = models.IntegerField()
+    sortorder = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_my_pages'
+
+class MdlPage(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    content = models.TextField(blank=True)
+    contentformat = models.IntegerField()
+    legacyfiles = models.IntegerField()
+    legacyfileslast = models.BigIntegerField(null=True, blank=True)
+    display = models.IntegerField()
+    displayoptions = models.TextField(blank=True)
+    revision = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_page'
+
+class MdlPortfolioInstance(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    plugin = models.CharField(max_length=150)
+    name = models.CharField(max_length=765)
+    visible = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_portfolio_instance'
+
+class MdlPortfolioInstanceConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    instance = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_portfolio_instance_config'
+
+class MdlPortfolioInstanceUser(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    instance = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_portfolio_instance_user'
+
+class MdlPortfolioLog(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    time = models.BigIntegerField()
+    portfolio = models.BigIntegerField()
+    caller_class = models.CharField(max_length=450)
+    caller_file = models.CharField(max_length=765)
+    caller_component = models.CharField(max_length=765, blank=True)
+    caller_sha1 = models.CharField(max_length=765)
+    tempdataid = models.BigIntegerField()
+    returnurl = models.CharField(max_length=765)
+    continueurl = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_portfolio_log'
+
+class MdlPortfolioMaharaQueue(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    transferid = models.BigIntegerField()
+    token = models.CharField(max_length=150)
+    class Meta:
+        db_table = u'mdl_portfolio_mahara_queue'
+
+class MdlPortfolioTempdata(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    data = models.TextField(blank=True)
+    expirytime = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    instance = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_portfolio_tempdata'
+
+class MdlPost(models.Model):
+    id = models.BigIntegerField(unique=True)
+    module = models.CharField(max_length=60)
+    userid = models.BigIntegerField(unique=True)
+    courseid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    moduleid = models.BigIntegerField()
+    coursemoduleid = models.BigIntegerField()
+    subject = models.CharField(max_length=384)
+    summary = models.TextField(blank=True)
+    content = models.TextField(blank=True)
+    uniquehash = models.CharField(max_length=765)
+    rating = models.BigIntegerField()
+    format = models.BigIntegerField()
+    summaryformat = models.IntegerField()
+    attachment = models.CharField(max_length=300, blank=True)
+    publishstate = models.CharField(max_length=60)
+    lastmodified = models.BigIntegerField()
+    created = models.BigIntegerField()
+    usermodified = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_post'
+
+class MdlProfiling(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    runid = models.CharField(unique=True, max_length=96)
+    url = models.CharField(max_length=765)
+    data = models.TextField()
+    totalexecutiontime = models.BigIntegerField()
+    totalcputime = models.BigIntegerField()
+    totalcalls = models.BigIntegerField()
+    totalmemory = models.BigIntegerField()
+    runreference = models.IntegerField()
+    runcomment = models.CharField(max_length=765)
+    timecreated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_profiling'
+
+class MdlQtypeEssayOptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    questionid = models.BigIntegerField(unique=True)
+    responseformat = models.CharField(max_length=48)
+    responsefieldlines = models.IntegerField()
+    attachments = models.IntegerField()
+    graderinfo = models.TextField(blank=True)
+    graderinfoformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_qtype_essay_options'
+
+class MdlQuestion(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    category = models.BigIntegerField()
+    parent = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    questiontext = models.TextField()
+    questiontextformat = models.IntegerField()
+    generalfeedback = models.TextField()
+    generalfeedbackformat = models.IntegerField()
+    defaultmark = models.DecimalField(max_digits=14, decimal_places=7)
+    penalty = models.DecimalField(max_digits=14, decimal_places=7)
+    qtype = models.CharField(max_length=60)
+    length = models.BigIntegerField()
+    stamp = models.CharField(max_length=765)
+    version = models.CharField(max_length=765)
+    hidden = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    createdby = models.BigIntegerField(null=True, blank=True)
+    modifiedby = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_question'
+
+class MdlQuestionAnswers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    answer = models.TextField()
+    answerformat = models.IntegerField()
+    fraction = models.DecimalField(max_digits=14, decimal_places=7)
+    feedback = models.TextField()
+    feedbackformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_question_answers'
+
+class MdlQuestionAttemptStepData(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    attemptstepid = models.BigIntegerField()
+    name = models.CharField(unique=True, max_length=96)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_question_attempt_step_data'
+
+class MdlQuestionAttemptSteps(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    questionattemptid = models.BigIntegerField()
+    sequencenumber = models.BigIntegerField(unique=True)
+    state = models.CharField(max_length=39)
+    fraction = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    timecreated = models.BigIntegerField()
+    userid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_question_attempt_steps'
+
+class MdlQuestionAttempts(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    questionusageid = models.BigIntegerField()
+    slot = models.BigIntegerField(unique=True)
+    behaviour = models.CharField(max_length=96)
+    questionid = models.BigIntegerField()
+    variant = models.BigIntegerField()
+    maxmark = models.DecimalField(max_digits=14, decimal_places=7)
+    minfraction = models.DecimalField(max_digits=14, decimal_places=7)
+    flagged = models.IntegerField()
+    questionsummary = models.TextField(blank=True)
+    rightanswer = models.TextField(blank=True)
+    responsesummary = models.TextField(blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_attempts'
+
+class MdlQuestionCalculated(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    answer = models.BigIntegerField()
+    tolerance = models.CharField(max_length=60)
+    tolerancetype = models.BigIntegerField()
+    correctanswerlength = models.BigIntegerField()
+    correctanswerformat = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_calculated'
+
+class MdlQuestionCalculatedOptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    synchronize = models.IntegerField()
+    single = models.IntegerField()
+    shuffleanswers = models.IntegerField()
+    correctfeedback = models.TextField(blank=True)
+    correctfeedbackformat = models.IntegerField()
+    partiallycorrectfeedback = models.TextField(blank=True)
+    partiallycorrectfeedbackformat = models.IntegerField()
+    incorrectfeedback = models.TextField(blank=True)
+    incorrectfeedbackformat = models.IntegerField()
+    answernumbering = models.CharField(max_length=30)
+    shownumcorrect = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_question_calculated_options'
+
+class MdlQuestionCategories(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    contextid = models.BigIntegerField()
+    info = models.TextField()
+    infoformat = models.IntegerField()
+    stamp = models.CharField(max_length=765)
+    parent = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_categories'
+
+class MdlQuestionDatasetDefinitions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    category = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    type = models.BigIntegerField()
+    options = models.CharField(max_length=765)
+    itemcount = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_dataset_definitions'
+
+class MdlQuestionDatasetItems(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    definition = models.BigIntegerField()
+    itemnumber = models.BigIntegerField()
+    value = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_question_dataset_items'
+
+class MdlQuestionDatasets(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    datasetdefinition = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_datasets'
+
+class MdlQuestionHints(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    questionid = models.BigIntegerField()
+    hint = models.TextField()
+    hintformat = models.IntegerField()
+    shownumcorrect = models.IntegerField(null=True, blank=True)
+    clearwrong = models.IntegerField(null=True, blank=True)
+    options = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_question_hints'
+
+class MdlQuestionMatch(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    subquestions = models.CharField(max_length=765)
+    shuffleanswers = models.IntegerField()
+    correctfeedback = models.TextField()
+    correctfeedbackformat = models.IntegerField()
+    partiallycorrectfeedback = models.TextField()
+    partiallycorrectfeedbackformat = models.IntegerField()
+    incorrectfeedback = models.TextField()
+    incorrectfeedbackformat = models.IntegerField()
+    shownumcorrect = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_question_match'
+
+class MdlQuestionMatchSub(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    code = models.BigIntegerField()
+    question = models.BigIntegerField()
+    questiontext = models.TextField()
+    questiontextformat = models.IntegerField()
+    answertext = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_question_match_sub'
+
+class MdlQuestionMultianswer(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    sequence = models.TextField()
+    class Meta:
+        db_table = u'mdl_question_multianswer'
+
+class MdlQuestionMultichoice(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    layout = models.IntegerField()
+    answers = models.CharField(max_length=765)
+    single = models.IntegerField()
+    shuffleanswers = models.IntegerField()
+    correctfeedback = models.TextField()
+    correctfeedbackformat = models.IntegerField()
+    partiallycorrectfeedback = models.TextField()
+    partiallycorrectfeedbackformat = models.IntegerField()
+    incorrectfeedback = models.TextField()
+    incorrectfeedbackformat = models.IntegerField()
+    answernumbering = models.CharField(max_length=30)
+    shownumcorrect = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_question_multichoice'
+
+class MdlQuestionNumerical(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    answer = models.BigIntegerField()
+    tolerance = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_question_numerical'
+
+class MdlQuestionNumericalOptions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    showunits = models.IntegerField()
+    unitsleft = models.IntegerField()
+    unitgradingtype = models.IntegerField()
+    unitpenalty = models.DecimalField(max_digits=14, decimal_places=7)
+    class Meta:
+        db_table = u'mdl_question_numerical_options'
+
+class MdlQuestionNumericalUnits(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    multiplier = models.DecimalField(max_digits=42, decimal_places=20)
+    unit = models.CharField(unique=True, max_length=150)
+    class Meta:
+        db_table = u'mdl_question_numerical_units'
+
+class MdlQuestionRandomsamatch(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    choose = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_randomsamatch'
+
+class MdlQuestionSessions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    attemptid = models.BigIntegerField()
+    questionid = models.BigIntegerField()
+    newest = models.BigIntegerField()
+    newgraded = models.BigIntegerField()
+    sumpenalty = models.DecimalField(max_digits=14, decimal_places=7)
+    manualcomment = models.TextField()
+    manualcommentformat = models.IntegerField()
+    flagged = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_question_sessions'
+
+class MdlQuestionShortanswer(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    answers = models.CharField(max_length=765)
+    usecase = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_question_shortanswer'
+
+class MdlQuestionStates(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    attempt = models.BigIntegerField()
+    question = models.BigIntegerField()
+    seq_number = models.IntegerField()
+    answer = models.TextField()
+    timestamp = models.BigIntegerField()
+    event = models.IntegerField()
+    grade = models.DecimalField(max_digits=14, decimal_places=7)
+    raw_grade = models.DecimalField(max_digits=14, decimal_places=7)
+    penalty = models.DecimalField(max_digits=14, decimal_places=7)
+    class Meta:
+        db_table = u'mdl_question_states'
+
+class MdlQuestionTruefalse(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    question = models.BigIntegerField()
+    trueanswer = models.BigIntegerField()
+    falseanswer = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_question_truefalse'
+
+class MdlQuestionUsages(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    component = models.CharField(max_length=765)
+    preferredbehaviour = models.CharField(max_length=96)
+    class Meta:
+        db_table = u'mdl_question_usages'
+
+class MdlQuiz(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    timeopen = models.BigIntegerField()
+    timeclose = models.BigIntegerField()
+    timelimit = models.BigIntegerField()
+    overduehandling = models.CharField(max_length=48)
+    graceperiod = models.BigIntegerField()
+    preferredbehaviour = models.CharField(max_length=96)
+    attempts = models.IntegerField()
+    attemptonlast = models.IntegerField()
+    grademethod = models.IntegerField()
+    decimalpoints = models.IntegerField()
+    questiondecimalpoints = models.IntegerField()
+    reviewattempt = models.IntegerField()
+    reviewcorrectness = models.IntegerField()
+    reviewmarks = models.IntegerField()
+    reviewspecificfeedback = models.IntegerField()
+    reviewgeneralfeedback = models.IntegerField()
+    reviewrightanswer = models.IntegerField()
+    reviewoverallfeedback = models.IntegerField()
+    questionsperpage = models.BigIntegerField()
+    navmethod = models.CharField(max_length=48)
+    shufflequestions = models.IntegerField()
+    shuffleanswers = models.IntegerField()
+    questions = models.TextField()
+    sumgrades = models.DecimalField(max_digits=12, decimal_places=5)
+    grade = models.DecimalField(max_digits=12, decimal_places=5)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    password = models.CharField(max_length=765)
+    subnet = models.CharField(max_length=765)
+    browsersecurity = models.CharField(max_length=96)
+    delay1 = models.BigIntegerField()
+    delay2 = models.BigIntegerField()
+    showuserpicture = models.IntegerField()
+    showblocks = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_quiz'
+
+class MdlQuizAttempts(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quiz = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    attempt = models.IntegerField(unique=True)
+    uniqueid = models.BigIntegerField(unique=True)
+    layout = models.TextField()
+    currentpage = models.BigIntegerField()
+    preview = models.IntegerField()
+    state = models.CharField(max_length=48)
+    timestart = models.BigIntegerField()
+    timefinish = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    timecheckstate = models.BigIntegerField(null=True, blank=True)
+    sumgrades = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    needsupgradetonewqe = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_quiz_attempts'
+
+class MdlQuizFeedback(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quizid = models.BigIntegerField()
+    feedbacktext = models.TextField()
+    feedbacktextformat = models.IntegerField()
+    mingrade = models.DecimalField(max_digits=12, decimal_places=5)
+    maxgrade = models.DecimalField(max_digits=12, decimal_places=5)
+    class Meta:
+        db_table = u'mdl_quiz_feedback'
+
+class MdlQuizGrades(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quiz = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    grade = models.DecimalField(max_digits=12, decimal_places=5)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_quiz_grades'
+
+class MdlQuizOverrides(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quiz = models.BigIntegerField()
+    groupid = models.BigIntegerField(null=True, blank=True)
+    userid = models.BigIntegerField(null=True, blank=True)
+    timeopen = models.BigIntegerField(null=True, blank=True)
+    timeclose = models.BigIntegerField(null=True, blank=True)
+    timelimit = models.BigIntegerField(null=True, blank=True)
+    attempts = models.IntegerField(null=True, blank=True)
+    password = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_quiz_overrides'
+
+class MdlQuizOverviewRegrades(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    questionusageid = models.BigIntegerField()
+    slot = models.BigIntegerField()
+    newfraction = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    oldfraction = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    regraded = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_quiz_overview_regrades'
+
+class MdlQuizQuestionInstances(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quiz = models.BigIntegerField()
+    question = models.BigIntegerField()
+    grade = models.DecimalField(max_digits=14, decimal_places=7)
+    class Meta:
+        db_table = u'mdl_quiz_question_instances'
+
+class MdlQuizQuestionResponseStats(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quizstatisticsid = models.BigIntegerField()
+    questionid = models.BigIntegerField()
+    subqid = models.CharField(max_length=300)
+    aid = models.CharField(max_length=300, blank=True)
+    response = models.TextField(blank=True)
+    rcount = models.BigIntegerField(null=True, blank=True)
+    credit = models.DecimalField(max_digits=17, decimal_places=5)
+    class Meta:
+        db_table = u'mdl_quiz_question_response_stats'
+
+class MdlQuizQuestionStatistics(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quizstatisticsid = models.BigIntegerField()
+    questionid = models.BigIntegerField()
+    slot = models.BigIntegerField(null=True, blank=True)
+    subquestion = models.IntegerField()
+    s = models.BigIntegerField()
+    effectiveweight = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    negcovar = models.IntegerField()
+    discriminationindex = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    discriminativeefficiency = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    sd = models.DecimalField(null=True, max_digits=17, decimal_places=10, blank=True)
+    facility = models.DecimalField(null=True, max_digits=17, decimal_places=10, blank=True)
+    subquestions = models.TextField(blank=True)
+    maxmark = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    positions = models.TextField(blank=True)
+    randomguessscore = models.DecimalField(null=True, max_digits=14, decimal_places=7, blank=True)
+    class Meta:
+        db_table = u'mdl_quiz_question_statistics'
+
+class MdlQuizReports(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(unique=True, max_length=765, blank=True)
+    displayorder = models.BigIntegerField()
+    capability = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_quiz_reports'
+
+class MdlQuizStatistics(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    quizid = models.BigIntegerField()
+    groupid = models.BigIntegerField()
+    allattempts = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    firstattemptscount = models.BigIntegerField()
+    allattemptscount = models.BigIntegerField()
+    firstattemptsavg = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    allattemptsavg = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    median = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    standarddeviation = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    skewness = models.DecimalField(null=True, max_digits=17, decimal_places=10, blank=True)
+    kurtosis = models.DecimalField(null=True, max_digits=17, decimal_places=5, blank=True)
+    cic = models.DecimalField(null=True, max_digits=17, decimal_places=10, blank=True)
+    errorratio = models.DecimalField(null=True, max_digits=17, decimal_places=10, blank=True)
+    standarderror = models.DecimalField(null=True, max_digits=17, decimal_places=10, blank=True)
+    class Meta:
+        db_table = u'mdl_quiz_statistics'
+
+class MdlRating(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    component = models.CharField(max_length=300)
+    ratingarea = models.CharField(max_length=150)
+    itemid = models.BigIntegerField()
+    scaleid = models.BigIntegerField()
+    rating = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_rating'
+
+class MdlRegistrationHubs(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    token = models.CharField(max_length=765)
+    hubname = models.CharField(max_length=765)
+    huburl = models.CharField(max_length=765)
+    confirmed = models.IntegerField()
+    secret = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_registration_hubs'
+
+class MdlRepository(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    type = models.CharField(max_length=765)
+    visible = models.IntegerField(null=True, blank=True)
+    sortorder = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_repository'
+
+class MdlRepositoryInstanceConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    instanceid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_repository_instance_config'
+
+class MdlRepositoryInstances(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    typeid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    contextid = models.BigIntegerField()
+    username = models.CharField(max_length=765, blank=True)
+    password = models.CharField(max_length=765, blank=True)
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    readonly = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_repository_instances'
+
+class MdlResource(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    tobemigrated = models.IntegerField()
+    legacyfiles = models.IntegerField()
+    legacyfileslast = models.BigIntegerField(null=True, blank=True)
+    display = models.IntegerField()
+    displayoptions = models.TextField(blank=True)
+    filterfiles = models.IntegerField()
+    revision = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_resource'
+
+class MdlResourceOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    type = models.CharField(max_length=90)
+    reference = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    alltext = models.TextField()
+    popup = models.TextField()
+    options = models.CharField(max_length=765)
+    timemodified = models.BigIntegerField()
+    oldid = models.BigIntegerField(unique=True)
+    cmid = models.BigIntegerField(null=True, blank=True)
+    newmodule = models.CharField(max_length=150, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    migrated = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_resource_old'
+
+class MdlRole(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    shortname = models.CharField(unique=True, max_length=300)
+    description = models.TextField()
+    sortorder = models.BigIntegerField(unique=True)
+    archetype = models.CharField(max_length=90)
+    class Meta:
+        db_table = u'mdl_role'
+
+class MdlRoleAllowAssign(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    roleid = models.BigIntegerField()
+    allowassign = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_role_allow_assign'
+
+class MdlRoleAllowOverride(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    roleid = models.BigIntegerField()
+    allowoverride = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_role_allow_override'
+
+class MdlRoleAllowSwitch(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    roleid = models.BigIntegerField()
+    allowswitch = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_role_allow_switch'
+
+class MdlRoleAssignments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    roleid = models.BigIntegerField()
+    contextid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    modifierid = models.BigIntegerField()
+    component = models.CharField(max_length=300)
+    itemid = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_role_assignments'
+
+class MdlRoleCapabilities(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    contextid = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    capability = models.CharField(max_length=765)
+    permission = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    modifierid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_role_capabilities'
+
+class MdlRoleContextLevels(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    roleid = models.BigIntegerField()
+    contextlevel = models.BigIntegerField(unique=True)
+    class Meta:
+        db_table = u'mdl_role_context_levels'
+
+class MdlRoleNames(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    roleid = models.BigIntegerField()
+    contextid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_role_names'
+
+class MdlRoleSortorder(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    contextid = models.BigIntegerField()
+    sortoder = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_role_sortorder'
+
+class MdlScale(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    scale = models.TextField()
+    description = models.TextField()
+    descriptionformat = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_scale'
+
+class MdlScaleHistory(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    action = models.BigIntegerField()
+    oldid = models.BigIntegerField()
+    source = models.CharField(max_length=765, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    loggeduser = models.BigIntegerField(null=True, blank=True)
+    courseid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    scale = models.TextField()
+    description = models.TextField()
+    class Meta:
+        db_table = u'mdl_scale_history'
+
+class MdlScorm(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    scormtype = models.CharField(max_length=150)
+    reference = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    version = models.CharField(max_length=27)
+    maxgrade = models.FloatField()
+    grademethod = models.IntegerField()
+    whatgrade = models.BigIntegerField()
+    maxattempt = models.BigIntegerField()
+    forcecompleted = models.IntegerField()
+    forcenewattempt = models.IntegerField()
+    lastattemptlock = models.IntegerField()
+    displayattemptstatus = models.IntegerField()
+    displaycoursestructure = models.IntegerField()
+    updatefreq = models.IntegerField()
+    sha1hash = models.CharField(max_length=120, blank=True)
+    md5hash = models.CharField(max_length=96)
+    revision = models.BigIntegerField()
+    launch = models.BigIntegerField()
+    skipview = models.IntegerField()
+    hidebrowse = models.IntegerField()
+    hidetoc = models.IntegerField()
+    hidenav = models.IntegerField()
+    auto = models.IntegerField()
+    popup = models.IntegerField()
+    options = models.CharField(max_length=765)
+    width = models.BigIntegerField()
+    height = models.BigIntegerField()
+    timeopen = models.BigIntegerField()
+    timeclose = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    completionstatusrequired = models.IntegerField(null=True, blank=True)
+    completionscorerequired = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_scorm'
+
+class MdlScormAiccSession(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    scormid = models.BigIntegerField()
+    hacpsession = models.CharField(max_length=765)
+    scoid = models.BigIntegerField(null=True, blank=True)
+    scormmode = models.CharField(max_length=150, blank=True)
+    scormstatus = models.CharField(max_length=765, blank=True)
+    attempt = models.BigIntegerField(null=True, blank=True)
+    lessonstatus = models.CharField(max_length=765, blank=True)
+    sessiontime = models.CharField(max_length=765, blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_scorm_aicc_session'
+
+class MdlScormScoes(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    scorm = models.BigIntegerField()
+    manifest = models.CharField(max_length=765)
+    organization = models.CharField(max_length=765)
+    parent = models.CharField(max_length=765)
+    identifier = models.CharField(max_length=765)
+    launch = models.TextField()
+    scormtype = models.CharField(max_length=15)
+    title = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_scorm_scoes'
+
+class MdlScormScoesData(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    scoid = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    value = models.TextField()
+    class Meta:
+        db_table = u'mdl_scorm_scoes_data'
+
+class MdlScormScoesTrack(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    scormid = models.BigIntegerField()
+    scoid = models.BigIntegerField()
+    attempt = models.BigIntegerField(unique=True)
+    element = models.CharField(max_length=765)
+    value = models.TextField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_scorm_scoes_track'
+
+class MdlScormSeqMapinfo(models.Model):
+    id = models.BigIntegerField(unique=True)
+    scoid = models.BigIntegerField()
+    objectiveid = models.BigIntegerField()
+    targetobjectiveid = models.BigIntegerField()
+    readsatisfiedstatus = models.IntegerField()
+    readnormalizedmeasure = models.IntegerField()
+    writesatisfiedstatus = models.IntegerField()
+    writenormalizedmeasure = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_scorm_seq_mapinfo'
+
+class MdlScormSeqObjective(models.Model):
+    id = models.BigIntegerField(unique=True)
+    scoid = models.BigIntegerField()
+    primaryobj = models.IntegerField()
+    objectiveid = models.CharField(max_length=765)
+    satisfiedbymeasure = models.IntegerField()
+    minnormalizedmeasure = models.FloatField()
+    class Meta:
+        db_table = u'mdl_scorm_seq_objective'
+
+class MdlScormSeqRolluprule(models.Model):
+    id = models.BigIntegerField(unique=True)
+    scoid = models.BigIntegerField()
+    childactivityset = models.CharField(max_length=45)
+    minimumcount = models.BigIntegerField()
+    minimumpercent = models.FloatField()
+    conditioncombination = models.CharField(max_length=9)
+    action = models.CharField(max_length=45)
+    class Meta:
+        db_table = u'mdl_scorm_seq_rolluprule'
+
+class MdlScormSeqRolluprulecond(models.Model):
+    id = models.BigIntegerField(unique=True)
+    scoid = models.BigIntegerField()
+    rollupruleid = models.BigIntegerField()
+    operator = models.CharField(max_length=15)
+    cond = models.CharField(max_length=75)
+    class Meta:
+        db_table = u'mdl_scorm_seq_rolluprulecond'
+
+class MdlScormSeqRulecond(models.Model):
+    id = models.BigIntegerField(unique=True)
+    scoid = models.BigIntegerField()
+    ruleconditionsid = models.BigIntegerField()
+    refrencedobjective = models.CharField(max_length=765)
+    measurethreshold = models.FloatField()
+    operator = models.CharField(max_length=15)
+    cond = models.CharField(max_length=90)
+    class Meta:
+        db_table = u'mdl_scorm_seq_rulecond'
+
+class MdlScormSeqRuleconds(models.Model):
+    id = models.BigIntegerField(unique=True)
+    scoid = models.BigIntegerField()
+    conditioncombination = models.CharField(max_length=9)
+    ruletype = models.IntegerField()
+    action = models.CharField(max_length=75)
+    class Meta:
+        db_table = u'mdl_scorm_seq_ruleconds'
+
+class MdlSessions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    state = models.BigIntegerField()
+    sid = models.CharField(unique=True, max_length=384)
+    userid = models.BigIntegerField()
+    sessdata = models.TextField(blank=True)
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    firstip = models.CharField(max_length=135, blank=True)
+    lastip = models.CharField(max_length=135, blank=True)
+    class Meta:
+        db_table = u'mdl_sessions'
+
+class MdlStatsDaily(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    stattype = models.CharField(max_length=60)
+    stat1 = models.BigIntegerField()
+    stat2 = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_stats_daily'
+
+class MdlStatsMonthly(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    stattype = models.CharField(max_length=60)
+    stat1 = models.BigIntegerField()
+    stat2 = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_stats_monthly'
+
+class MdlStatsUserDaily(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    statsreads = models.BigIntegerField()
+    statswrites = models.BigIntegerField()
+    stattype = models.CharField(max_length=90)
+    class Meta:
+        db_table = u'mdl_stats_user_daily'
+
+class MdlStatsUserMonthly(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    statsreads = models.BigIntegerField()
+    statswrites = models.BigIntegerField()
+    stattype = models.CharField(max_length=90)
+    class Meta:
+        db_table = u'mdl_stats_user_monthly'
+
+class MdlStatsUserWeekly(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    statsreads = models.BigIntegerField()
+    statswrites = models.BigIntegerField()
+    stattype = models.CharField(max_length=90)
+    class Meta:
+        db_table = u'mdl_stats_user_weekly'
+
+class MdlStatsWeekly(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    courseid = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    stattype = models.CharField(max_length=60)
+    stat1 = models.BigIntegerField()
+    stat2 = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_stats_weekly'
+
+class MdlSurvey(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    template = models.BigIntegerField()
+    days = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField()
+    introformat = models.IntegerField()
+    questions = models.CharField(max_length=765)
+    class Meta:
+        db_table = u'mdl_survey'
+
+class MdlSurveyAnalysis(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    survey = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    notes = models.TextField()
+    class Meta:
+        db_table = u'mdl_survey_analysis'
+
+class MdlSurveyAnswers(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    survey = models.BigIntegerField()
+    question = models.BigIntegerField()
+    time = models.BigIntegerField()
+    answer1 = models.TextField()
+    answer2 = models.TextField()
+    class Meta:
+        db_table = u'mdl_survey_answers'
+
+class MdlSurveyQuestions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    text = models.CharField(max_length=765)
+    shorttext = models.CharField(max_length=90)
+    multi = models.CharField(max_length=300)
+    intro = models.CharField(max_length=150)
+    type = models.IntegerField()
+    options = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_survey_questions'
+
+class MdlTag(models.Model):
+    id = models.BigIntegerField(unique=True)
+    userid = models.BigIntegerField()
+    name = models.CharField(unique=True, max_length=765)
+    rawname = models.CharField(max_length=765)
+    tagtype = models.CharField(max_length=765, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    flag = models.IntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_tag'
+
+class MdlTagCorrelation(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    tagid = models.BigIntegerField()
+    correlatedtags = models.TextField()
+    class Meta:
+        db_table = u'mdl_tag_correlation'
+
+class MdlTagInstance(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    tagid = models.BigIntegerField()
+    itemtype = models.CharField(unique=True, max_length=765)
+    itemid = models.BigIntegerField(unique=True)
+    tiuserid = models.BigIntegerField(unique=True)
+    ordering = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_tag_instance'
+
+class MdlTempEnroledTemplate(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    courseid = models.BigIntegerField()
+    roleid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_temp_enroled_template'
+
+class MdlTempLogTemplate(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    course = models.BigIntegerField()
+    action = models.CharField(max_length=120)
+    class Meta:
+        db_table = u'mdl_temp_log_template'
+
+class MdlTimezone(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=300)
+    year = models.BigIntegerField()
+    tzrule = models.CharField(max_length=60)
+    gmtoff = models.BigIntegerField()
+    dstoff = models.BigIntegerField()
+    dst_month = models.IntegerField()
+    dst_startday = models.IntegerField()
+    dst_weekday = models.IntegerField()
+    dst_skipweeks = models.IntegerField()
+    dst_time = models.CharField(max_length=18)
+    std_month = models.IntegerField()
+    std_startday = models.IntegerField()
+    std_weekday = models.IntegerField()
+    std_skipweeks = models.IntegerField()
+    std_time = models.CharField(max_length=18)
+    class Meta:
+        db_table = u'mdl_timezone'
+
+class MdlToolCustomlang(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    lang = models.CharField(unique=True, max_length=60)
+    componentid = models.BigIntegerField()
+    stringid = models.CharField(unique=True, max_length=765)
+    original = models.TextField()
+    master = models.TextField(blank=True)
+    local = models.TextField(blank=True)
+    timemodified = models.BigIntegerField()
+    timecustomized = models.BigIntegerField(null=True, blank=True)
+    outdated = models.IntegerField(null=True, blank=True)
+    modified = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_tool_customlang'
+
+class MdlToolCustomlangComponents(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    version = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_tool_customlang_components'
+
+class MdlUpgradeLog(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    type = models.BigIntegerField()
+    plugin = models.CharField(max_length=300, blank=True)
+    version = models.CharField(max_length=300, blank=True)
+    targetversion = models.CharField(max_length=300, blank=True)
+    info = models.CharField(max_length=765)
+    details = models.TextField(blank=True)
+    backtrace = models.TextField(blank=True)
+    userid = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_upgrade_log'
+
+class MdlUrl(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    externalurl = models.TextField()
+    display = models.IntegerField()
+    displayoptions = models.TextField(blank=True)
+    parameters = models.TextField(blank=True)
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_url'
+
+class MdlUser(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    auth = models.CharField(max_length=60)
+    confirmed = models.IntegerField()
+    policyagreed = models.IntegerField()
+    deleted = models.IntegerField()
+    suspended = models.IntegerField()
+    mnethostid = models.BigIntegerField(unique=True)
+    username = models.CharField(unique=True, max_length=300)
+    password = models.CharField(max_length=96)
+    idnumber = models.CharField(max_length=765)
+    firstname = models.CharField(max_length=300)
+    lastname = models.CharField(max_length=300)
+    email = models.CharField(max_length=300)
+    emailstop = models.IntegerField()
+    icq = models.CharField(max_length=45)
+    skype = models.CharField(max_length=150)
+    yahoo = models.CharField(max_length=150)
+    aim = models.CharField(max_length=150)
+    msn = models.CharField(max_length=150)
+    phone1 = models.CharField(max_length=60)
+    phone2 = models.CharField(max_length=60)
+    institution = models.CharField(max_length=120)
+    department = models.CharField(max_length=90)
+    address = models.CharField(max_length=210)
+    city = models.CharField(max_length=360)
+    country = models.CharField(max_length=6)
+    lang = models.CharField(max_length=90)
+    theme = models.CharField(max_length=150)
+    timezone = models.CharField(max_length=300)
+    firstaccess = models.BigIntegerField()
+    lastaccess = models.BigIntegerField()
+    lastlogin = models.BigIntegerField()
+    currentlogin = models.BigIntegerField()
+    lastip = models.CharField(max_length=135)
+    secret = models.CharField(max_length=45)
+    picture = models.BigIntegerField()
+    url = models.CharField(max_length=765)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    mailformat = models.IntegerField()
+    maildigest = models.IntegerField()
+    maildisplay = models.IntegerField()
+    htmleditor = models.IntegerField()
+    autosubscribe = models.IntegerField()
+    trackforums = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    trustbitmask = models.BigIntegerField()
+    imagealt = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_user'
+
+class MdlUserEnrolments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    status = models.BigIntegerField()
+    enrolid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timestart = models.BigIntegerField()
+    timeend = models.BigIntegerField()
+    modifierid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_user_enrolments'
+
+class MdlUserInfoCategory(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    name = models.CharField(max_length=765)
+    sortorder = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_user_info_category'
+
+class MdlUserInfoData(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    fieldid = models.BigIntegerField()
+    data = models.TextField()
+    dataformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_user_info_data'
+
+class MdlUserInfoField(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    shortname = models.CharField(max_length=765)
+    name = models.TextField()
+    datatype = models.CharField(max_length=765)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField()
+    categoryid = models.BigIntegerField()
+    sortorder = models.BigIntegerField()
+    required = models.IntegerField()
+    locked = models.IntegerField()
+    visible = models.IntegerField()
+    forceunique = models.IntegerField()
+    signup = models.IntegerField()
+    defaultdata = models.TextField(blank=True)
+    defaultdataformat = models.IntegerField()
+    param1 = models.TextField(blank=True)
+    param2 = models.TextField(blank=True)
+    param3 = models.TextField(blank=True)
+    param4 = models.TextField(blank=True)
+    param5 = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_user_info_field'
+
+class MdlUserLastaccess(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField()
+    courseid = models.BigIntegerField()
+    timeaccess = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_user_lastaccess'
+
+class MdlUserPreferences(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    userid = models.BigIntegerField(unique=True)
+    name = models.CharField(unique=True, max_length=765)
+    value = models.CharField(max_length=3999)
+    class Meta:
+        db_table = u'mdl_user_preferences'
+
+class MdlUserPrivateKey(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    script = models.CharField(max_length=384)
+    value = models.CharField(max_length=384)
+    userid = models.BigIntegerField()
+    instance = models.BigIntegerField(null=True, blank=True)
+    iprestriction = models.CharField(max_length=765, blank=True)
+    validuntil = models.BigIntegerField(null=True, blank=True)
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_user_private_key'
+
+class MdlWebdavLocks(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    token = models.CharField(unique=True, max_length=765)
+    path = models.CharField(max_length=765)
+    expiry = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    recursive = models.IntegerField()
+    exclusivelock = models.IntegerField()
+    created = models.BigIntegerField()
+    modified = models.BigIntegerField()
+    owner = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_webdav_locks'
+
+class MdlWiki(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    firstpagetitle = models.CharField(max_length=765)
+    wikimode = models.CharField(max_length=60)
+    defaultformat = models.CharField(max_length=60)
+    forceformat = models.IntegerField()
+    editbegin = models.BigIntegerField()
+    editend = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_wiki'
+
+class MdlWikiLinks(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    subwikiid = models.BigIntegerField()
+    frompageid = models.BigIntegerField()
+    topageid = models.BigIntegerField()
+    tomissingpage = models.CharField(max_length=765, blank=True)
+    class Meta:
+        db_table = u'mdl_wiki_links'
+
+class MdlWikiLocks(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    pageid = models.BigIntegerField()
+    sectionname = models.CharField(max_length=765, blank=True)
+    userid = models.BigIntegerField()
+    lockedat = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_wiki_locks'
+
+class MdlWikiPages(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    subwikiid = models.BigIntegerField()
+    title = models.CharField(unique=True, max_length=765)
+    cachedcontent = models.TextField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    timerendered = models.BigIntegerField()
+    userid = models.BigIntegerField(unique=True)
+    pageviews = models.BigIntegerField()
+    readonly = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_wiki_pages'
+
+class MdlWikiSubwikis(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    wikiid = models.BigIntegerField()
+    groupid = models.BigIntegerField(unique=True)
+    userid = models.BigIntegerField(unique=True)
+    class Meta:
+        db_table = u'mdl_wiki_subwikis'
+
+class MdlWikiSynonyms(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    subwikiid = models.BigIntegerField()
+    pageid = models.BigIntegerField(unique=True)
+    pagesynonym = models.CharField(unique=True, max_length=765)
+    class Meta:
+        db_table = u'mdl_wiki_synonyms'
+
+class MdlWikiVersions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    pageid = models.BigIntegerField()
+    content = models.TextField()
+    contentformat = models.CharField(max_length=60)
+    version = models.IntegerField()
+    timecreated = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    class Meta:
+        db_table = u'mdl_wiki_versions'
+
+class MdlWorkshop(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    intro = models.TextField(blank=True)
+    introformat = models.IntegerField()
+    instructauthors = models.TextField(blank=True)
+    instructauthorsformat = models.IntegerField()
+    instructreviewers = models.TextField(blank=True)
+    instructreviewersformat = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    phase = models.IntegerField(null=True, blank=True)
+    useexamples = models.IntegerField(null=True, blank=True)
+    usepeerassessment = models.IntegerField(null=True, blank=True)
+    useselfassessment = models.IntegerField(null=True, blank=True)
+    grade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    gradinggrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    strategy = models.CharField(max_length=90)
+    evaluation = models.CharField(max_length=90)
+    gradedecimals = models.IntegerField(null=True, blank=True)
+    nattachments = models.IntegerField(null=True, blank=True)
+    latesubmissions = models.IntegerField(null=True, blank=True)
+    maxbytes = models.BigIntegerField(null=True, blank=True)
+    examplesmode = models.IntegerField(null=True, blank=True)
+    submissionstart = models.BigIntegerField(null=True, blank=True)
+    submissionend = models.BigIntegerField(null=True, blank=True)
+    assessmentstart = models.BigIntegerField(null=True, blank=True)
+    assessmentend = models.BigIntegerField(null=True, blank=True)
+    phaseswitchassessment = models.IntegerField()
+    conclusion = models.TextField(blank=True)
+    conclusionformat = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_workshop'
+
+class MdlWorkshopAggregations(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    gradinggrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    timegraded = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_aggregations'
+
+class MdlWorkshopAssessments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    submissionid = models.BigIntegerField()
+    reviewerid = models.BigIntegerField()
+    weight = models.BigIntegerField()
+    timecreated = models.BigIntegerField(null=True, blank=True)
+    timemodified = models.BigIntegerField(null=True, blank=True)
+    grade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    gradinggrade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    gradinggradeover = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    gradinggradeoverby = models.BigIntegerField(null=True, blank=True)
+    feedbackauthor = models.TextField(blank=True)
+    feedbackauthorformat = models.IntegerField(null=True, blank=True)
+    feedbackreviewer = models.TextField(blank=True)
+    feedbackreviewerformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_assessments'
+
+class MdlWorkshopAssessmentsOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    submissionid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timegraded = models.BigIntegerField()
+    timeagreed = models.BigIntegerField()
+    grade = models.FloatField()
+    gradinggrade = models.IntegerField()
+    teachergraded = models.IntegerField()
+    mailed = models.IntegerField()
+    resubmission = models.IntegerField()
+    donotuse = models.IntegerField()
+    generalcomment = models.TextField(blank=True)
+    teachercomment = models.TextField(blank=True)
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_assessments_old'
+
+class MdlWorkshopCommentsOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    assessmentid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    mailed = models.IntegerField()
+    comments = models.TextField()
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_comments_old'
+
+class MdlWorkshopElementsOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    elementno = models.IntegerField()
+    description = models.TextField()
+    scale = models.IntegerField()
+    maxscore = models.IntegerField()
+    weight = models.IntegerField()
+    stddev = models.FloatField()
+    totalassessments = models.BigIntegerField()
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_elements_old'
+
+class MdlWorkshopGrades(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    assessmentid = models.BigIntegerField()
+    strategy = models.CharField(unique=True, max_length=90)
+    dimensionid = models.BigIntegerField(unique=True)
+    grade = models.DecimalField(max_digits=12, decimal_places=5)
+    peercomment = models.TextField(blank=True)
+    peercommentformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_grades'
+
+class MdlWorkshopGradesOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    assessmentid = models.BigIntegerField()
+    elementno = models.BigIntegerField()
+    feedback = models.TextField()
+    grade = models.IntegerField()
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_grades_old'
+
+class MdlWorkshopOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    course = models.BigIntegerField()
+    name = models.CharField(max_length=765)
+    description = models.TextField()
+    wtype = models.IntegerField()
+    nelements = models.IntegerField()
+    nattachments = models.IntegerField()
+    phase = models.IntegerField()
+    format = models.IntegerField()
+    gradingstrategy = models.IntegerField()
+    resubmit = models.IntegerField()
+    agreeassessments = models.IntegerField()
+    hidegrades = models.IntegerField()
+    anonymous = models.IntegerField()
+    includeself = models.IntegerField()
+    maxbytes = models.BigIntegerField()
+    submissionstart = models.BigIntegerField()
+    assessmentstart = models.BigIntegerField()
+    submissionend = models.BigIntegerField()
+    assessmentend = models.BigIntegerField()
+    releasegrades = models.BigIntegerField()
+    grade = models.IntegerField()
+    gradinggrade = models.IntegerField()
+    ntassessments = models.IntegerField()
+    assessmentcomps = models.IntegerField()
+    nsassessments = models.IntegerField()
+    overallocation = models.IntegerField()
+    timemodified = models.BigIntegerField()
+    teacherweight = models.IntegerField()
+    showleaguetable = models.IntegerField()
+    usepassword = models.IntegerField()
+    password = models.CharField(max_length=96)
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_old'
+
+class MdlWorkshopRubricsOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    elementno = models.BigIntegerField()
+    rubricno = models.IntegerField()
+    description = models.TextField()
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_rubrics_old'
+
+class MdlWorkshopStockcommentsOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    elementno = models.BigIntegerField()
+    comments = models.TextField()
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_stockcomments_old'
+
+class MdlWorkshopSubmissions(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    example = models.IntegerField(null=True, blank=True)
+    authorid = models.BigIntegerField()
+    timecreated = models.BigIntegerField()
+    timemodified = models.BigIntegerField()
+    title = models.CharField(max_length=765)
+    content = models.TextField(blank=True)
+    contentformat = models.IntegerField()
+    contenttrust = models.IntegerField()
+    attachment = models.IntegerField(null=True, blank=True)
+    grade = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    gradeover = models.DecimalField(null=True, max_digits=12, decimal_places=5, blank=True)
+    gradeoverby = models.BigIntegerField(null=True, blank=True)
+    feedbackauthor = models.TextField(blank=True)
+    feedbackauthorformat = models.IntegerField(null=True, blank=True)
+    timegraded = models.BigIntegerField(null=True, blank=True)
+    published = models.IntegerField(null=True, blank=True)
+    late = models.IntegerField()
+    class Meta:
+        db_table = u'mdl_workshop_submissions'
+
+class MdlWorkshopSubmissionsOld(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    userid = models.BigIntegerField()
+    title = models.CharField(max_length=300)
+    timecreated = models.BigIntegerField()
+    mailed = models.IntegerField()
+    description = models.TextField()
+    gradinggrade = models.IntegerField()
+    finalgrade = models.IntegerField()
+    late = models.IntegerField()
+    nassessments = models.BigIntegerField()
+    newplugin = models.CharField(max_length=84, blank=True)
+    newid = models.BigIntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshop_submissions_old'
+
+class MdlWorkshopallocationScheduled(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField(unique=True)
+    enabled = models.IntegerField()
+    submissionend = models.BigIntegerField()
+    timeallocated = models.BigIntegerField(null=True, blank=True)
+    settings = models.TextField(blank=True)
+    resultstatus = models.BigIntegerField(null=True, blank=True)
+    resultmessage = models.CharField(max_length=3999, blank=True)
+    resultlog = models.TextField(blank=True)
+    class Meta:
+        db_table = u'mdl_workshopallocation_scheduled'
+
+class MdlWorkshopevalBestSettings(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField(unique=True)
+    comparison = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopeval_best_settings'
+
+class MdlWorkshopformAccumulative(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    sort = models.BigIntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    grade = models.BigIntegerField()
+    weight = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopform_accumulative'
+
+class MdlWorkshopformComments(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    sort = models.BigIntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopform_comments'
+
+class MdlWorkshopformNumerrors(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    sort = models.BigIntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    descriptiontrust = models.BigIntegerField(null=True, blank=True)
+    grade0 = models.CharField(max_length=150, blank=True)
+    grade1 = models.CharField(max_length=150, blank=True)
+    weight = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopform_numerrors'
+
+class MdlWorkshopformNumerrorsMap(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    nonegative = models.BigIntegerField(unique=True)
+    grade = models.DecimalField(max_digits=12, decimal_places=5)
+    class Meta:
+        db_table = u'mdl_workshopform_numerrors_map'
+
+class MdlWorkshopformRubric(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField()
+    sort = models.BigIntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    descriptionformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopform_rubric'
+
+class MdlWorkshopformRubricConfig(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    workshopid = models.BigIntegerField(unique=True)
+    layout = models.CharField(max_length=90, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopform_rubric_config'
+
+class MdlWorkshopformRubricLevels(models.Model):
+    id = models.BigIntegerField(primary_key=True)
+    dimensionid = models.BigIntegerField()
+    grade = models.DecimalField(max_digits=12, decimal_places=5)
+    definition = models.TextField(blank=True)
+    definitionformat = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'mdl_workshopform_rubric_levels'
+
+class UserResult(models.Model):
+    username = models.CharField(max_length=75, primary_key=True)
+    foss = models.CharField(max_length=75, primary_key=True)
+    percent_score = models.DecimalField(null=True, max_digits=6, decimal_places=2, blank=True)
+    class Meta:
+        db_table = u'user_result'
+
diff --git a/testapp/myauthentication/router.py b/testapp/myauthentication/router.py
new file mode 100644
index 0000000..ffdf122
--- /dev/null
+++ b/testapp/myauthentication/router.py
@@ -0,0 +1,12 @@
+class MyDatabaseRouter(object):
+    """
+        A router to manage database operations in the myauthentication app.
+    """
+    def db_for_read(self, model, **hints):
+		"""
+			Point all read operations on myauthentication app to spoken
+			database.
+		"""
+		if model._meta.app_label == 'myauthentication':
+			return 'spoken'
+		return None
diff --git a/testapp/myauthentication/tests.py b/testapp/myauthentication/tests.py
new file mode 100644
index 0000000..501deb7
--- /dev/null
+++ b/testapp/myauthentication/tests.py
@@ -0,0 +1,16 @@
+"""
+This file demonstrates writing tests using the unittest module. These will pass
+when you run "manage.py test".
+
+Replace this with more appropriate tests for your application.
+"""
+
+from django.test import TestCase
+
+
+class SimpleTest(TestCase):
+    def test_basic_addition(self):
+        """
+        Tests that 1 + 1 always equals 2.
+        """
+        self.assertEqual(1 + 1, 2)
diff --git a/testapp/myauthentication/urls.py b/testapp/myauthentication/urls.py
new file mode 100644
index 0000000..3ac130d
--- /dev/null
+++ b/testapp/myauthentication/urls.py
@@ -0,0 +1,4 @@
+from django.conf.urls.defaults import patterns, url
+
+urlpatterns = patterns('',
+)
diff --git a/testapp/myauthentication/views.py b/testapp/myauthentication/views.py
new file mode 100644
index 0000000..60f00ef
--- /dev/null
+++ b/testapp/myauthentication/views.py
@@ -0,0 +1 @@
+# Create your views here.
diff --git a/testapp/settings.py b/testapp/settings.py
index 0002476..e809cf4 100644
--- a/testapp/settings.py
+++ b/testapp/settings.py
@@ -5,6 +5,14 @@ from os.path import dirname, join, basename, abspath
 DEBUG = True
 TEMPLATE_DEBUG = DEBUG
 
+# Authentication using other database table.
+# Comment the line below if you want the authentication to be done
+# using django user table.
+AUTHENTICATION_BACKENDS = ('myauthentication.backend.MyBackend',)
+
+# Router for database
+DATABASE_ROUTERS = ['myauthentication.router.MyDatabaseRouter',]
+
 # The ports the code server should run on.  This will run one separate 
 # server for each port listed in the following list.
 SERVER_PORTS = [8001] # range(8001, 8026)
@@ -41,6 +49,14 @@ DATABASES = {
         'PASSWORD': '',                  # Not used with sqlite3.
         'HOST': '',                      # Set to empty string for localhost. Not used with sqlite3.
         'PORT': '',                      # Set to empty string for default. Not used with sqlite3.
+    },
+    'spoken' : {
+        'ENGINE' : 'django.db.backends.mysql',
+        'NAME'   : 'YOUR DATABASE',
+        'USER'   : 'YOUR USERNAME',
+        'PASSWORD': 'YOUR PASSWORD',
+        'HOST'    :'',
+        'PORT'    :'',
     }
 }
 
diff --git a/testapp/templates/exam/login.html b/testapp/templates/exam/login.html
index 078e7a7..d63d639 100644
--- a/testapp/templates/exam/login.html
+++ b/testapp/templates/exam/login.html
@@ -15,8 +15,8 @@
         {{ form.as_table }}
         </table></center>
         <center><button class="btn" type="submit">Login</button>&nbsp;&nbsp;&nbsp;&nbsp;<button class="btn" type="reset">Cancel</button></center>
-        <br><center><a href="{{URL_ROOT}}/exam/forgotpassword/">Forgot Password?</a></center><br>
-        <center><a href="{{URL_ROOT}}/exam/register/">New User? Sign-Up </a></center>
+<!--        <br><center><a href="{{URL_ROOT}}/exam/forgotpassword/">Forgot Password?</a></center><br>
+        <center><a href="{{URL_ROOT}}/exam/register/">New User? Sign-Up </a></center>-->
         </form>
       
 {% endblock content %}
author	prathamesh	2014-03-26 14:48:45 +0530
committer	prathamesh	2014-03-26 14:48:45 +0530
commit	ba50e500a1da9266f9bee5bc38b69635637f6129 (patch)
tree	4836211b8109824d9f8912e80f83be1e6f857ce0 /testapp
parent	b2a95b4f99debc4d165bb0122b03b8e67f26b669 (diff)
download	online_test-ba50e500a1da9266f9bee5bc38b69635637f6129.tar.gz online_test-ba50e500a1da9266f9bee5bc38b69635637f6129.tar.bz2 online_test-ba50e500a1da9266f9bee5bc38b69635637f6129.zip