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