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;
USERS vedi modello generale
indietro