Questa è una vecchia versione del documento!
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;
GEOMAP vedi [[il modello generale | modello generale]]