Preparation

You need to provide a database to use with the connector. Just one table must be present in this database, called 'resource', according to the following schema:

CREATE TABLE `resource` (
    `import_timestamp` TIMESTAMP NOT NULL,
    `resource_id` INT UNSIGNED NOT NULL,
    `object_id` INT UNSIGNED NOT NULL,
    `inventory_number` VARCHAR(255) NOT NULL,
    `original_filename` VARCHAR(255) NOT NULL,
    `width` INT UNSIGNED NOT NULL DEFAULT 0,
    `height` INT UNSIGNED NOT NULL DEFAULT 0,
    `filesize` INT UNSIGNED NOT NULL DEFAULT 0,
    `linked` TINYINT UNSIGNED NOT NULL DEFAULT 0
);
CREATE TABLE `unlinked_resource` (
    `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
    `import_timestamp` TIMESTAMP NOT NULL,
    `resource_id` INT UNSIGNED NOT NULL,
    `object_id` INT UNSIGNED NOT NULL,
    `inventory_number` VARCHAR(255) NOT NULL,
    `original_filename` VARCHAR(255) NOT NULL,
    `width` INT UNSIGNED NOT NULL DEFAULT 0,
    `height` INT UNSIGNED NOT NULL DEFAULT 0,
    `filesize` INT UNSIGNED NOT NULL DEFAULT 0,
    `linked` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    PRIMARY KEY(id)
);