assignment

(mysql): CREATE TABLE sunrise_assignment ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, assignmenttype VARCHAR(50) NOT NULL DEFAULT '', resubmit TINYINT(2) unsigned NOT NULL DEFAULT 0, preventlate TINYINT(2) unsigned NOT NULL DEFAULT 0, emailteachers TINYINT(2) unsigned NOT NULL DEFAULT 0, var1 BIGINT(10) DEFAULT 0, var2 BIGINT(10) DEFAULT 0, var3 BIGINT(10) DEFAULT 0, var4 BIGINT(10) DEFAULT 0, var5 BIGINT(10) DEFAULT 0, maxbytes BIGINT(10) unsigned NOT NULL DEFAULT 100000, timedue BIGINT(10) unsigned NOT NULL DEFAULT 0, timeavailable BIGINT(10) unsigned NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'sunrise_assignment' already exists
            ADOConnection._Execute(CREATE TABLE sunrise_assignment (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DE..., false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE sunrise_assignment (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DE...) % line   71, file: dmllib.php
      execute_sql(CREATE TABLE sunrise_assignment (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    course BIGINT(10) unsigned NOT NULL DE..., true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error
(mysql): ALTER TABLE sunrise_assignment COMMENT='Defines assignments'  
Success
(mysql): CREATE TABLE sunrise_assignment_submissions ( id BIGINT(10) unsigned NOT NULL auto_increment, assignment BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, numfiles BIGINT(10) unsigned NOT NULL DEFAULT 0, data1 TEXT NOT NULL, data2 TEXT NOT NULL, grade BIGINT(11) NOT NULL DEFAULT 0, submissioncomment TEXT NOT NULL, format SMALLINT(4) unsigned NOT NULL DEFAULT 0, teacher BIGINT(10) unsigned NOT NULL DEFAULT 0, timemarked BIGINT(10) unsigned NOT NULL DEFAULT 0, mailed TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )  
1050: Table 'sunrise_assignment_submissions' already exists
            ADOConnection._Execute(CREATE TABLE sunrise_assignment_submissions (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    assignment BIGINT(10) unsi..., false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(CREATE TABLE sunrise_assignment_submissions (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    assignment BIGINT(10) unsi...) % line   71, file: dmllib.php
      execute_sql(CREATE TABLE sunrise_assignment_submissions (
    id BIGINT(10) unsigned NOT NULL auto_increment,
    assignment BIGINT(10) unsi..., true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error
(mysql): ALTER TABLE sunrise_assignment_submissions COMMENT='Info about submitted assignments'  
Success
(mysql): INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')  
1062: Duplicate entry 'assignment-view' for key 'sunrise_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name'), false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name')) % line   71, file: dmllib.php
      execute_sql(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view', 'assignment', 'name'), true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error
(mysql): INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')  
1062: Duplicate entry 'assignment-add' for key 'sunrise_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name'), false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name')) % line   71, file: dmllib.php
      execute_sql(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'add', 'assignment', 'name'), true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error
(mysql): INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')  
1062: Duplicate entry 'assignment-update' for key 'sunrise_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name'), false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name')) % line   71, file: dmllib.php
      execute_sql(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'update', 'assignment', 'name'), true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error
(mysql): INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name')  
1062: Duplicate entry 'assignment-view submission' for key 'sunrise_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name'), false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name')) % line   71, file: dmllib.php
      execute_sql(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'view submission', 'assignment', 'name'), true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error
(mysql): INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')  
1062: Duplicate entry 'assignment-upload' for key 'sunrise_logdisp_modact_uix'
            ADOConnection._Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name'), false) % line  889, file: adodb.inc.php
         ADOConnection.Execute(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name')) % line   71, file: dmllib.php
      execute_sql(INSERT INTO sunrise_log_display(module, action, mtable, field) VALUES ('assignment', 'upload', 'assignment', 'name'), true) % line 1737, file: dmllib.php
   execute_sql_arr(Array[9]) % line  548, file: ddllib.php
install_from_xmldb_file(/var/www/datadrive/STTHERESE/Sunrise/mod/assignment/db/install.xml) % line  332, file: adminlib.php
Error

assignment tables could NOT be set up successfully!