[system] / trunk / wwmoodle / wwassignment / db / mysql.sql Repository:
ViewVC logotype

View of /trunk/wwmoodle/wwassignment/db/mysql.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 4174 - (download) (annotate)
Tue Jun 27 20:04:11 2006 UTC (13 years, 7 months ago) by gage
File size: 1692 byte(s)
Combining wwmoodle and wwmoodleset into one module called wwassign

    1 # This file contains a complete database schema for all the
    2 # tables used by this module, written in SQL
    3 
    4 # It may also contain INSERT statements for particular data
    5 # that may be used, especially new entries in the table log_display
    6 
    7 DROP TABLE IF EXISTS `prefix_wwmoodleset`;
    8 
    9 CREATE TABLE `prefix_wwassignment` (
   10   `id` int(10) unsigned NOT NULL auto_increment,
   11   `name` varchar(255) NOT NULL,
   12   `course` int(10) unsigned NOT NULL,
   13   `set_id` text NOT NULL,
   14   `description` text NOT NULL,
   15   `gradingmethod` int(3) unsigned NOT NULL,
   16   `timemodified` int(10) unsigned NOT NULL,
   17 
   18   PRIMARY KEY  (`id`),
   19   KEY (`course`)
   20 
   21 );
   22 
   23 
   24 
   25 # Insert sane defaults for config options:
   26 
   27 INSERT INTO `prefix_config` (`name`, `value`) VALUES ('wwmoodleset_webwork_url', '/webwork2');
   28 
   29 INSERT INTO `prefix_config` (`name`, `value`) VALUES ('wwmoodleset_iframe_width', '90%');
   30 
   31 INSERT INTO `prefix_config` (`name`, `value`) VALUES ('wwmoodleset_iframe_height', '500px');
   32 
   33 
   34 # This file contains a complete database schema for all the
   35 # tables used by this module, written in SQL
   36 
   37 # It may also contain INSERT statements for particular data
   38 # that may be used, especially new entries in the table log_display
   39 DROP TABLE IF EXISTS `prefix_wwmoodle`;
   40 
   41 CREATE TABLE `prefix_wwassignment_bridge` (
   42   `id` int(10) unsigned NOT NULL auto_increment,
   43   `name` varchar(255) NOT NULL,
   44   `allowedRecipients` text NOT NULL,
   45   `course` int(10) unsigned NOT NULL,
   46   `coursename` varchar(15) NOT NULL,
   47   `timemodified` int(10) unsigned NOT NULL,
   48 
   49   PRIMARY KEY  (`id`),
   50   KEY (`course`)
   51 
   52 );
   53 
   54 
   55 # Insert sane default config options:
   56 
   57 INSERT INTO `prefix_config` (`name`, `value`) VALUES ('wwmoodle_webwork_courses', '/opt/webwork2/courses/');

aubreyja at gmail dot com
ViewVC Help
Powered by ViewVC 1.0.9