2 /* this is an optional configuration file. */
\r
3 /* it is used only when the ATutor configuration cannot be found, or if it */
\r
4 /* can be found but AT_ENABLE_HANDBOOK_NOTES is set to false. */
\r
6 /* use the settings found here to enable/disable user notes. */
\r
7 /* user notes require a valid database connection and a pre-existing */
\r
8 /* database table. */
\r
9 /* the structure/schema of the database table is defined at the bottom */
\r
10 /* of this file. use it to create the table before enabling user notes. */
\r
12 define('AT_HANDBOOK_DB_HOST', 'localhost');
\r
14 define('AT_HANDBOOK_DB_PORT', '3306');
\r
16 define('AT_HANDBOOK_DB_USER', '');
\r
18 define('AT_HANDBOOK_DB_PASSWORD', '');
\r
20 define('AT_HANDBOOK_DB_DATABASE', 'atutor');
\r
22 define('AT_HANDBOOK_DB_TABLE_PREFIX', 'AT_');
\r
24 define('AT_HANDBOOK_ADMIN_USERNAME', '');
\r
25 define('AT_HANDBOOK_ADMIN_PASSWORD', '');
\r
27 define('AT_HANDBOOK_ENABLE', true);
\r
30 # Note: you will have to add the table prefix!!
\r
32 CREATE TABLE `handbook_notes` (
\r
33 `note_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT ,
\r
34 `date` DATETIME NOT NULL ,
\r
35 `section` VARCHAR( 15 ) NOT NULL ,
\r
36 `page` VARCHAR( 50 ) NOT NULL ,
\r
37 `approved` TINYINT NOT NULL,
\r
38 `email` VARCHAR( 50 ) NOT NULL ,
\r
39 `note` TEXT NOT NULL ,
\r
40 PRIMARY KEY ( `note_id` )
\r