database.php

<?php


$DATABASE_UNINSTALL = array(
"drop table if exists {$CFG->dbprefix}context_map"
);

$DATABASE_INSTALL = array(
array( "{$CFG->dbprefix}context_map",
"create table {$CFG->dbprefix}context_map (
    context_id  INTEGER NOT NULL,
    user_id     INTEGER NOT NULL,
    lat         FLOAT,
    lng         FLOAT,
    color       INTEGER,
    email       TINYINT,
    name        TINYINT,
    first       TINYINT,
    updated_at  DATETIME NOT NULL,

    CONSTRAINT `{$CFG->dbprefix}context_map_ibfk_1`
        FOREIGN KEY (`context_id`)
        REFERENCES `{$CFG->dbprefix}lti_context` (`context_id`)
        ON DELETE CASCADE ON UPDATE CASCADE,

    CONSTRAINT `{$CFG->dbprefix}context_map_ibfk_2`
        FOREIGN KEY (`user_id`)
        REFERENCES `{$CFG->dbprefix}lti_user` (`user_id`)
        ON DELETE CASCADE ON UPDATE CASCADE,

    UNIQUE(context_id, user_id)
) ENGINE = InnoDB DEFAULT CHARSET=utf8")

);


$DATABASE_UPGRADE = function($oldversion) {
    global $CFG, $PDOX;

    $table = "{$CFG->dbprefix}context_map";
    $add_some_fields = array(
        array('email', 'TINYINT'),
        array('name', 'TINYINT'),
        array('first', 'TINYINT'),
    );
    foreach ( $add_some_fields as $add_field ) {
        $column = $add_field[0];
        $type = $add_field[1];
        if ( $PDOX->columnExists($column, $table) ) continue;
        $sql= "ALTER TABLE {$table} ADD {$column} {$type}";
        echo("Upgrading: ".$sql."<br/>\n");
        error_log("Upgrading: ".$sql);
        $q = $PDOX->queryReturnError($sql);
    }
    return 2014042000;
};