Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
l_agenda [02/08/2010 17:13] |
l_agenda [05/06/2013 17:08] |
||
---|---|---|---|
Linea 1: | Linea 1: | ||
- | ====== ER dell'Agenda ====== | ||
- | {{:agenda_er.jpg|}} | ||
- | |||
- | ---- | ||
- | \\ | ||
- | 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; | ||
- | \\ |