Differenze

Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.

--- l_agenda [05/08/2010 11:28]
+++ l_agenda [05/06/2013 17:08] (versione attuale)
@@ 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`)
-  ) 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;
 \\
-  CREATE TABLE IF NOT EXISTS geomap (
+**GEOMAP** vedi [[il modello generale | modello generale]]
-    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;
 \\
 \\

Documentazione openDCN

Strumenti Utente

Strumenti Sito

Differenze

Strumenti Pagina