Database Table: import_items

From Dreamwidth Notes
Revision as of 15:56, 22 July 2010 by Exor674Bot (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This is a global table.

Definition

CREATE TABLE import_items (
    userid INT UNSIGNED NOT NULL,
    item VARCHAR(255) NOT NULL,
    STATUS ENUM('init', 'ready', 'queued', 'failed', 'succeeded', 'aborted') NOT NULL DEFAULT 'init',
    created INT UNSIGNED NOT NULL,
    last_touch INT UNSIGNED NOT NULL,
    import_data_id INT UNSIGNED NOT NULL,
    priority INT UNSIGNED NOT NULL,
 
    PRIMARY KEY (userid, item, import_data_id),
    INDEX (priority, STATUS)
)

Relationships