Questa è una vecchia versione del documento!
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