Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
Both sides previous revision Previous revision Next revision | Previous revision | ||
le_risorse [05/08/2010 11:40] |
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; | + | |
\\ | \\ | ||
- | USERS vedi [[il modello generale | modello generale]] | + | 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; | ||
+ | \\ | ||
+ | **ATTACHMENTS** | ||
+ | \\ | ||
+ | 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; | ||
+ | \\ | ||
+ | **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]] | ||
\\ | \\ | ||
\\ | \\ |