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