SQL delle tabelle:

CREATE TABLE  `agendas` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `title` varchar(255) NOT NULL,
 `description` text NOT NULL,
 `start` datetime NOT NULL,
 `end` datetime NOT NULL,
 `status` tinyint(3) unsigned NOT NULL,
 `location_id` int(10) unsigned NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `agendas` ADD COLUMN `introduction_url` VARCHAR(255) NOT NULL AFTER `location_id`;
ALTER TABLE `agendas` ADD COLUMN `real_start` datetime  NOT NULL AFTER `end`,
ADD COLUMN `real_end` datetime  NOT NULL AFTER `real_start`;

CREATE TABLE `agenda_tools` (
 `agenda_id` int(10) unsigned NOT NULL,
 `tool` varchar(255) NOT NULL,
 `tool_id` int(10) unsigned NOT NULL,
 `dependences` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE `agenda_tools` 
ADD COLUMN `title` VARCHAR(255) NOT NULL AFTER `tool_id`,
ADD COLUMN `description` TEXT NOT NULL AFTER `title`,
ADD COLUMN `start` DATETIME NOT NULL AFTER `dependences`,
ADD COLUMN `end` DATETIME NOT NULL AFTER `start`,
ADD COLUMN `real_start` DATETIME NOT NULL AFTER `end`,
ADD COLUMN `real_end` DATETIME NOT NULL AFTER `real_start`,
ADD COLUMN `status` TINYINT UNSIGNED NOT NULL AFTER `real_end`;
ALTER TABLE `agenda_tools` ADD COLUMN `id` INTEGER UNSIGNED NOT NULL AFTER `description`, ADD PRIMARY KEY (`id`);
ALTER TABLE `agenda_tools` MODIFY COLUMN `id` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT;

CREATE TABLE IF NOT EXISTS geomap (
  id             INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
  label          MEDIUMTEXT        ,
  boundingBox    GEOMETRY          NOT NULL,
  owner          MEDIUMTEXT        NOT NULL,
  owner_id       INTEGER           NOT NULL,
  maptype        MEDIUMTEXT        NOT NULL,
  PRIMARY KEY(id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=INNODB;