Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
le_risorse [05/08/2010 12:47] |
le_risorse [05/06/2013 17:08] |
||
---|---|---|---|
Linea 1: | Linea 1: | ||
- | ====== ER delle Risorse ====== | + | |
- | \\ | + | |
- | {{:risorse_er_2.jpg|}} | + | |
- | \\ | + | |
- | ---- | + | |
- | \\ | + | |
- | SQL delle tabelle: | + | |
- | \\ | + | |
- | \\ | + | |
- | CREATE TABLE IF NOT EXISTS `resources` ( | + | |
- | `id` int(10) unsigned NOT NULL auto_increment, | + | |
- | `title` varchar(255) NOT NULL, | + | |
- | `description` text NOT NULL, | + | |
- | `created` datetime NOT NULL, | + | |
- | `modified` datetime NOT NULL, | + | |
- | `user_id` int(10) unsigned default NULL, | + | |
- | `anonymous_id` int(10) unsigned default NULL, | + | |
- | PRIMARY KEY (`id`) | + | |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | |
- | \\ | + | |
- | CREATE TABLE IF NOT EXISTS `owner_resources` ( | + | |
- | `owner` varchar(45) NOT NULL, | + | |
- | `owner_id` int(10) unsigned NOT NULL, | + | |
- | `resource_id` int(10) unsigned NOT NULL, | + | |
- | `public` tinyint(1) default NULL, | + | |
- | `id` int(10) unsigned NOT NULL auto_increment, | + | |
- | `status` tinyint(1) default NULL, | + | |
- | PRIMARY KEY (`id`) | + | |
- | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | + | |
- | \\ | + | |
- | CREATE TABLE IF NOT EXISTS `links` ( | + | |
- | `id` int(10) unsigned NOT NULL auto_increment, | + | |
- | `title` varchar(255) NOT NULL, | + | |
- | `url` varchar(255) NOT NULL, | + | |
- | `resource_id` int(11) NOT NULL, | + | |
- | `created` datetime NOT NULL, | + | |
- | `modified` datetime NOT NULL, | + | |
- | PRIMARY KEY (`id`) | + | |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | |
- | \\ | + | |
- | CREATE TABLE IF NOT EXISTS `attachments` ( | + | |
- | `id` int(10) unsigned NOT NULL auto_increment, | + | |
- | `name` varchar(255) NOT NULL, | + | |
- | `fsname` varchar(255) NOT NULL, | + | |
- | `size` int(10) unsigned NOT NULL, | + | |
- | `type` varchar(255) NOT NULL, | + | |
- | `resource_id` int(10) unsigned NOT NULL, | + | |
- | `created` datetime NOT NULL, | + | |
- | `modified` datetime NOT NULL, | + | |
- | PRIMARY KEY (`id`) | + | |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | |
- | \\ | + | |
- | CREATE TABLE IF NOT EXISTS `videos` ( | + | |
- | `id` int(10) unsigned NOT NULL auto_increment, | + | |
- | `title` varchar(255) NOT NULL, | + | |
- | `url` varchar(255) NOT NULL, | + | |
- | `type` varchar(255) NOT NULL, | + | |
- | `resource_id` int(11) NOT NULL, | + | |
- | `created` datetime NOT NULL, | + | |
- | `modified` datetime NOT NULL, | + | |
- | PRIMARY KEY (`id`) | + | |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | |
- | \\ | + | |
- | USERS vedi [[il modello generale | modello generale]] | + | |
- | \\ | + | |
- | \\ | + | |
- | \\ | + | |
- | \\ | + | |
- | [[la di | indietro]] | + |