Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
l_agenda [05/08/2010 11:38] |
l_agenda [06/08/2010 15:22] |
||
---|---|---|---|
Linea 8: | Linea 8: | ||
\\ | \\ | ||
\\ | \\ | ||
- | CREATE TABLE `agendas` ( | + | **AGENDA** |
- | `id` int(10) unsigned NOT NULL auto_increment, | + | \\ |
- | `title` varchar(255) NOT NULL, | + | CREATE TABLE IF NOT EXISTS `agendas` ( |
- | `description` text NOT NULL, | + | `id` int(10) unsigned NOT NULL auto_increment, |
- | `start` datetime NOT NULL, | + | `title` varchar(255) NOT NULL, |
- | `end` datetime NOT NULL, | + | `description` text NOT NULL, |
- | `status` tinyint(3) unsigned NOT NULL, | + | `start` datetime NOT NULL, |
- | `location_id` int(10) unsigned NOT NULL, | + | `end` datetime NOT NULL, |
+ | `real_start` datetime NOT NULL, | ||
+ | `real_end` datetime NOT NULL, | ||
+ | `status` tinyint(3) unsigned NOT NULL, | ||
+ | `location_id` int(10) unsigned NOT NULL, | ||
+ | `introduction_url` varchar(255) NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | ) 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 TOOLS** |
- | `agenda_id` int(10) unsigned NOT NULL, | + | \\ |
- | `tool` varchar(255) NOT NULL, | + | CREATE TABLE IF NOT EXISTS `agenda_tools` ( |
- | `tool_id` int(10) unsigned NOT NULL, | + | `agenda_id` int(10) unsigned NOT NULL, |
- | `dependences` text NOT NULL | + | `tool` varchar(255) NOT NULL, |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | `tool_id` int(10) unsigned NOT NULL, |
- | ALTER TABLE `agenda_tools` | + | `title` varchar(255) NOT NULL, |
- | ADD COLUMN `title` VARCHAR(255) NOT NULL AFTER `tool_id`, | + | `description` text NOT NULL, |
- | ADD COLUMN `description` TEXT NOT NULL AFTER `title`, | + | `dependences` text NOT NULL, |
- | ADD COLUMN `start` DATETIME NOT NULL AFTER `dependences`, | + | `start` datetime NOT NULL, |
- | ADD COLUMN `end` DATETIME NOT NULL AFTER `start`, | + | `end` datetime NOT NULL, |
- | ADD COLUMN `real_start` DATETIME NOT NULL AFTER `end`, | + | `real_start` datetime NOT NULL, |
- | ADD COLUMN `real_end` DATETIME NOT NULL AFTER `real_start`, | + | `real_end` datetime NOT NULL, |
- | ADD COLUMN `status` TINYINT UNSIGNED NOT NULL AFTER `real_end`; | + | `status` tinyint(3) unsigned NOT NULL, |
- | ALTER TABLE `agenda_tools` ADD COLUMN `id` INTEGER UNSIGNED NOT NULL AFTER `description`, ADD PRIMARY KEY (`id`); | + | `id` int(10) unsigned NOT NULL auto_increment, |
- | ALTER TABLE `agenda_tools` MODIFY COLUMN `id` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT; | + | PRIMARY KEY (`id`) |
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
\\ | \\ | ||
- | GEOMAP vedi [[il modello generale | modello generale]] | + | GEOMAP vedi [[il modello generale | modello generale]] |
\\ | \\ | ||
\\ | \\ |