diff options
| author | prathamesh | 2014-06-06 12:21:31 +0530 |
|---|---|---|
| committer | prathamesh | 2014-06-06 12:21:31 +0530 |
| commit | 6ed7eb5a06d16a3a761f4c6c99b9fc78ed4027d5 (patch) | |
| tree | 331c95e4cf51bdef56dda6a936273db1f0721f82 | |
| parent | ba50e500a1da9266f9bee5bc38b69635637f6129 (diff) | |
| download | online_test-6ed7eb5a06d16a3a761f4c6c99b9fc78ed4027d5.tar.gz online_test-6ed7eb5a06d16a3a761f4c6c99b9fc78ed4027d5.tar.bz2 online_test-6ed7eb5a06d16a3a761f4c6c99b9fc78ed4027d5.zip | |
README file added to the authentication app.
| -rw-r--r-- | testapp/exam/urls.py | 2 | ||||
| -rw-r--r-- | testapp/myauthentication/README | 11 | ||||
| -rw-r--r-- | testapp/myauthentication/backend.py | 13 | ||||
| -rw-r--r-- | testapp/myauthentication/models_spoken.py | 4013 | ||||
| -rw-r--r-- | testapp/myauthentication/router.py | 14 | ||||
| -rw-r--r-- | testapp/myauthentication/urls.py | 4 | ||||
| -rw-r--r-- | testapp/settings.py | 4 | ||||
| -rw-r--r-- | testapp/templates/exam/login.html | 4 |
8 files changed, 32 insertions, 4033 deletions
diff --git a/testapp/exam/urls.py b/testapp/exam/urls.py index afeda68..33b2edf 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/README b/testapp/myauthentication/README new file mode 100644 index 0000000..8ef6ab7 --- /dev/null +++ b/testapp/myauthentication/README @@ -0,0 +1,11 @@ +To use authentication from external source, follow the instructions given below: + +1. In settings.py uncomment, + AUTHENTICATION_BACKENDS = ('myauthentication.backend.MyBackend',) and + AUTHENTICATION_BACKENDS = ('myauthentication.backend.MyBackend',) + +2. From login.html template comment 'New User? Sign-Up' link. + This is to be done so that user will register only from external + application and their details will be stored in the external database. + +3. In urls.py comment 'register' url pattern. diff --git a/testapp/myauthentication/backend.py b/testapp/myauthentication/backend.py index 35dcfeb..698ec54 100644 --- a/testapp/myauthentication/backend.py +++ b/testapp/myauthentication/backend.py @@ -8,23 +8,28 @@ class MyBackend: supports_inactive_user = False def authenticate(self, username=None, password=None): + ''' + Checks username and password with external User table. + If valid then adds the user detail in django User table + and authenticates user. + ''' try: user = MdlUser.objects.get(username=username) pwd = user.password uid = user.id firstname = user.firstname lastname = user.lastname - email = user.email + email_id = 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=User(id=uid, username=username, password=pwd,\ + first_name=firstname, last_name=lastname,\ + email=email_id) user.save() return user except Exception, e: diff --git a/testapp/myauthentication/models_spoken.py b/testapp/myauthentication/models_spoken.py index 049a1d6..2526a0e 100644 --- a/testapp/myauthentication/models_spoken.py +++ b/testapp/myauthentication/models_spoken.py @@ -9,4031 +9,18 @@ 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 index ffdf122..eeb4cdb 100644 --- a/testapp/myauthentication/router.py +++ b/testapp/myauthentication/router.py @@ -3,10 +3,10 @@ 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 + """ + 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/urls.py b/testapp/myauthentication/urls.py index 3ac130d..e69de29 100644 --- a/testapp/myauthentication/urls.py +++ b/testapp/myauthentication/urls.py @@ -1,4 +0,0 @@ -from django.conf.urls.defaults import patterns, url - -urlpatterns = patterns('', -) diff --git a/testapp/settings.py b/testapp/settings.py index e809cf4..543c0e3 100644 --- a/testapp/settings.py +++ b/testapp/settings.py @@ -8,10 +8,10 @@ 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',) +#AUTHENTICATION_BACKENDS = ('myauthentication.backend.MyBackend',) # Router for database -DATABASE_ROUTERS = ['myauthentication.router.MyDatabaseRouter',] +#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. diff --git a/testapp/templates/exam/login.html b/testapp/templates/exam/login.html index d63d639..078e7a7 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> <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 %} |