Difference between revisions of "Database Table: import items"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with '{{Database Table|name=import_items|table type=global}} Category:Database Tables Needing Description = Definition = <source lang="sql"> CREATE TABLE import_items ( userid …')
(No difference)

Revision as of 12:35, 27 January 2010

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. 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