Strumenti Utente
la_di
Differenze
Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
la_di [05/08/2010 11:30] |
la_di [05/06/2013 17:08] (versione attuale) |
||
|---|---|---|---|
| Linea 1: | Linea 1: | ||
| ====== ER della Discussione Informata ====== | ====== ER della Discussione Informata ====== | ||
| - | {{:infodiscs:infodisc_er.jpg|}} | + | {{:infodisc_er2.jpg|}} |
| \\ | \\ | ||
| \\ | \\ | ||
| Linea 15: | Linea 15: | ||
| \\ | \\ | ||
| \\ | \\ | ||
| - | CREATE TABLE `infodiscs` ( | + | **INFODISCS** |
| - | `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, | + | |
| - | `title` VARCHAR(255) NOT NULL, | + | |
| - | `description` TEXT NOT NULL, | + | |
| - | `status` TINYINT UNSIGNED NOT NULL, | + | |
| - | `infodisc_id` INTEGER UNSIGNED NOT NULL, | + | |
| - | `start` DATETIME NOT NULL, | + | |
| - | `end` DATETIME NOT NULL, | + | |
| - | `created` DATETIME NOT NULL, | + | |
| - | `modified` DATETIME NOT NULL, | + | |
| - | PRIMARY KEY(`id`) | + | |
| - | ) | + | |
| - | ENGINE = MYISAM; | + | |
| \\ | \\ | ||
| - | CREATE TABLE `infodiscs_posts` ( | + | CREATE TABLE IF NOT EXISTS `infodiscs` ( |
| - | `id` int(10) unsigned NOT NULL auto_increment, | + | `id` int(10) unsigned NOT NULL auto_increment, |
| - | `parent_id` int(10) unsigned NOT NULL default '0', | + | `title` varchar(255) NOT NULL, |
| - | `title` text character set latin1 collate latin1_general_ci NOT NULL, | + | `description` text NOT NULL, |
| - | `body` text character set latin1 collate latin1_general_ci NOT NULL, | + | `introduction_url` varchar(255) NOT NULL, |
| - | `status` tinyint(3) unsigned NOT NULL default '0', | + | `status` tinyint(3) unsigned NOT NULL, |
| - | `created` datetime NOT NULL default '0000-00-00 00:00:00', | + | `location_id` int(11) NOT NULL, |
| - | `modified` datetime NOT NULL default '0000-00-00 00:00:00', | + | `start` datetime NOT NULL, |
| - | `infodisc_id` int(10) unsigned NOT NULL default '0', | + | `end` datetime NOT NULL, |
| - | `discussion_id` int(10) unsigned NOT NULL default '0', | + | `created` datetime NOT NULL, |
| - | `user_id` int(10) unsigned NOT NULL default '0', | + | `modified` datetime NOT NULL, |
| - | `anonymous_id` int(10) unsigned NOT NULL default '0', | + | `discussions` int(11) default NULL, |
| + | `markerset_id` int(11) default NULL, | ||
| + | `moderation` int(11) default NULL, | ||
| + | `mapview` tinyint(1) default NULL, | ||
| + | `points` tinyint(4) default NULL, | ||
| + | `lines` tinyint(4) default NULL, | ||
| + | `polygons` tinyint(4) default NULL, | ||
| + | `default_location` text, | ||
| + | `default_marker` int(11) default NULL, | ||
| + | `default_geolocation` int(11) default NULL, | ||
| + | `multiple_marker` int(11) default NULL, | ||
| + | `advanced_resource` tinyint(4) NOT NULL default '1', | ||
| + | `default_shape_color` varchar(7) NOT NULL default '#000000', | ||
| PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
| - | ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1; | + | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
| \\ | \\ | ||
| - | CREATE TABLE `users` ( | + | **INFODISCS POSTS** |
| - | `id` int(11) NOT NULL auto_increment, | + | |
| - | `username` varchar(255) NOT NULL default '', | + | |
| - | `password` varchar(36) NOT NULL default '', | + | |
| - | `first_name` varchar(255) default '', | + | |
| - | `last_name` varchar(255) default '', | + | |
| - | `email` varchar(255) NOT NULL default '', | + | |
| - | `showemail` tinyint(1) NOT NULL default '0', | + | |
| - | `admin` tinyint(1) NOT NULL default '0', | + | |
| - | `active` tinyint(1) NOT NULL default '0', | + | |
| - | `created` datetime default NULL, | + | |
| - | `modified` datetime default NULL, | + | |
| - | PRIMARY KEY (`id`), | + | |
| - | UNIQUE KEY `username` (`username`), | + | |
| - | UNIQUE KEY `email` (`email`) | + | |
| - | ) ENGINE=MyISAM | + | |
| \\ | \\ | ||
| - | CREATE TABLE IF NOT EXISTS geomap ( | + | CREATE TABLE IF NOT EXISTS `infodiscs_posts` ( |
| - | id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, | + | `id` int(10) unsigned NOT NULL auto_increment, |
| - | label MEDIUMTEXT , | + | `parent_id` int(10) unsigned NOT NULL default '0', |
| - | boundingBox GEOMETRY NOT NULL, | + | `title` text character set latin1 collate latin1_general_ci NOT NULL, |
| - | owner MEDIUMTEXT NOT NULL, | + | `body` text character set latin1 collate latin1_general_ci NOT NULL, |
| - | owner_id INTEGER NOT NULL, | + | `status` tinyint(3) unsigned NOT NULL default '0', |
| - | maptype MEDIUMTEXT NOT NULL, | + | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| - | PRIMARY KEY(id) | + | `modified` datetime NOT NULL default '0000-00-00 00:00:00', |
| - | ) CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=INNODB; | + | `infodisc_id` int(10) unsigned NOT NULL default '0', |
| + | `discussion_id` int(10) unsigned NOT NULL default '0', | ||
| + | `geolocation_id` int(10) unsigned default NULL, | ||
| + | `user_id` int(10) unsigned NOT NULL default '0', | ||
| + | `anonymous_id` int(10) unsigned NOT NULL default '0', | ||
| + | `argument` int(11) default NULL, | ||
| + | PRIMARY KEY (`id`) | ||
| + | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
| + | \\ | ||
| + | **GEOMAP** e **USERS** vedi [[il modello generale | modello generale]] | ||
| \\ | \\ | ||
| \\ | \\ | ||
la_di.1281000636.txt.gz · Ultima modifica: 05/06/2013 17:08 (modifica esterna)
Strumenti Pagina
Ad eccezione da dove è diversamente indicato, il contenuto di questo wiki è soggetto alla seguente licenza: CC Attribution-Noncommercial-Share Alike 3.0 Unported
