Documentazione openDCN

Strumenti Utente

Strumenti Sito

Ti trovi qui: start » le_risorse
le_risorse

Differenze

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

Link a questa pagina di confronto

Both sides previous revision Previous revision
Next revision 		Previous revision
le_risorse [05/08/2010 11:33]
 le_risorse [05/06/2013 17:08] (versione attuale)
Linea 8: Linea 8:
 \\ \\
 \\ \\
-  CREATE TABLE `resources` ( +**RESOURCES**
-   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,​ +
-   ​`title` VARCHAR(255) NOT NULL, +
-   ​`description` TEXT NOT NULL, +
-   ​`created` DATETIME NOT NULL, +
-   ​`modified` DATETIME NOT NULL, +
-   ​`user_id` INTEGER UNSIGNED, +
-   ​`anonymous_id` INTEGER UNSIGNED, +
-  PRIMARY KEY(`id`) +
-  ) +
-  ENGINE = MYISAM;+
 \\ \\
-  CREATE TABLE  `owner_resources` ( +  CREATE TABLE IF NOT EXISTS ​`resources` ( 
-   ​`owner` varchar(45) NOT NULL, +  `id` int(10) unsigned ​NOT NULL auto_increment, 
-   ​`owner_id` int(10) unsigned ​NOT NULL, +  `title` varchar(255) NOT NULL, 
-   ​`resource_id` int(10) unsigned ​NOT NULL, +  ​`description` text NOT NULL, 
-   ​`public` tinyint(1) NOT NULL, +  `created` datetime NOT NULL, 
-  PRIMARY KEY  (`owner`,​`owner_id`,​`resource_id`) +  `modified` datetime NOT NULL, 
-  ) ENGINE=InnoDB ​DEFAULT CHARSET=latin1;​+  ​`user_id` int(10) unsigned ​default ​NULL, 
 +  `anonymous_id` int(10) unsigned default ​NULL, 
 +  PRIMARY KEY  (`id`) 
 +  ) ENGINE=MyISAM  ​DEFAULT CHARSET=latin1;​
 \\ \\
-  CREATE TABLE `links` ( +**OWNER RESOURCES**
-   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,​ +
-   ​`title` VARCHAR(255) NOT NULL, +
-   `url` VARCHAR(255) NOT NULL, +
-   ​`resource_id INTEGER NOT NULL, +
-   ​`created` DATETIME NOT NULL, +
-   ​`modified` DATETIME NOT NULL, +
-  PRIMARY KEY(`id`) +
-  ) +
-  ENGINE = MYISAM;+
 \\ \\
-  CREATE TABLE `attachments` ( +  CREATE TABLE IF NOT EXISTS ​`owner_resources` ( 
-   ​`id` INTEGER UNSIGNED ​NOT NULL AUTO_INCREMENT, +  `owner` varchar(45) ​NOT NULL, 
-   ​`name` VARCHAR(255) NOT NULL, +  `owner_id` int(10) unsigned ​NOT NULL, 
-   ​`fsname` VARCHAR(255) NOT NULL, +  `resource_id` int(10) unsigned ​NOT NULL, 
-   ​`size` INTEGER UNSIGNED NOT NULL, +  `public` tinyint(1) default ​NULL, 
-   ​`type` VARCHAR(255) NOT NULL, +  `id` int(10) unsigned ​NOT NULL auto_increment, 
-   ​`resource_id` INTEGER UNSIGNED NOT NULL, +  `status` tinyint(1) default ​NULL, 
-  PRIMARY KEY(`id`) +  PRIMARY KEY  (`id`) 
-  ) +  ) ENGINE=InnoDB ​ DEFAULT CHARSET=latin1;
-  ​ENGINE = MYISAM;+
 \\ \\
-  CREATE TABLE `videos` ( +**LINKS**
-   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,​ +
-   ​`title` VARCHAR(255) NOT NULL, +
-   `url` VARCHAR(255) NOT NULL, +
-   ​`type` VARCHAR(255) NOT NULL, +
-   ​`resource_id` INTEGER NOT NULL, +
-   ​`created` DATETIME NOT NULL, +
-   ​`modified` DATETIME NOT NULL, +
-  PRIMARY KEY(`id`) +
-  ) +
-  ENGINE = MYISAM;+
 \\ \\
-  CREATE TABLE  `users` ( +  CREATE TABLE IF NOT EXISTS ​`links` ( 
-   ​`id` int(11) NOT NULL auto_increment,​ +  `id` int(10) unsigned ​NOT NULL auto_increment,​ 
-   ​`username` varchar(255) NOT NULL default ''​, +  `title` varchar(255) NOT NULL, 
-   ​`password` varchar(36) NOT NULL default ''​, +  `url` varchar(255) NOT NULL, 
-   ​`first_name` varchar(255) default ''​, +  `resource_id` int(11) NOT NULL, 
-   ​`last_name` varchar(255) ​default ''​, +  `created` datetime NOT NULL, 
-   ​`email` varchar(255) NOT NULL default ''​, +  `modified` datetime NOT NULL, 
-   ​`showemail` tinyint(1) NOT NULL default '​0'​, +  PRIMARY KEY  (`id`) 
-   ​`admin` tinyint(1) NOT NULL default '​0'​, +  ) ENGINE=MyISAM ​ DEFAULT CHARSET=latin1;​ 
-   ​`active` tinyint(1) NOT NULL default '​0'​, +\\ 
-   ​`created` datetime ​default ​NULL, +**ATTACHMENTS** 
-   ​`modified` datetime ​default ​NULL, +\\ 
-  PRIMARY KEY  (`id`), +  CREATE TABLE IF NOT EXISTS `attachments` ( 
-  ​UNIQUE KEY `username` (`username`), +  `id` int(10) unsigned NOT NULL auto_increment,​ 
-  ​UNIQUE KEY `email` (`email`) +  `name` varchar(255) ​NOT NULL, 
-  ) ENGINE=MyISAM+  `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;​ 
 +\\ 
 +**VIDEOS** 
 +\\ 
 +  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]]
 \\ \\
 \\ \\
le_risorse.1281000821.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
CC Attribution-Noncommercial-Share Alike 3.0 Unported Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki