Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
le_risorse [02/08/2010 17:20] |
le_risorse [05/06/2013 17:08] |
||
---|---|---|---|
Linea 1: | Linea 1: | ||
- | ====== ER delle Risorse ====== | ||
- | \\ | ||
- | {{:risorse_er_2.jpg|}} | ||
- | \\ | ||
- | ---- | ||
- | \\ | ||
- | SQL delle tabelle: | ||
- | \\ | ||
- | \\ | ||
- | CREATE TABLE `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` ( | ||
- | `owner` varchar(45) NOT NULL, | ||
- | `owner_id` int(10) unsigned NOT NULL, | ||
- | `resource_id` int(10) unsigned NOT NULL, | ||
- | `public` tinyint(1) NOT NULL, | ||
- | PRIMARY KEY (`owner`,`owner_id`,`resource_id`) | ||
- | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
- | \\ | ||
- | CREATE TABLE `links` ( | ||
- | `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` ( | ||
- | `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, | ||
- | `name` VARCHAR(255) NOT NULL, | ||
- | `fsname` VARCHAR(255) NOT NULL, | ||
- | `size` INTEGER UNSIGNED NOT NULL, | ||
- | `type` VARCHAR(255) NOT NULL, | ||
- | `resource_id` INTEGER UNSIGNED NOT NULL, | ||
- | PRIMARY KEY(`id`) | ||
- | ) | ||
- | ENGINE = MYISAM; | ||
- | \\ | ||
- | CREATE TABLE `videos` ( | ||
- | `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` ( | ||
- | `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 | ||
- | \\ | ||