Database Table: vgift_ids

From Dreamwidth Notes
Revision as of 17:21, 29 October 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 vgift_ids (
    vgiftid      INT UNSIGNED NOT NULL PRIMARY KEY,
    name         VARCHAR(255) NOT NULL,
    created_t    INT UNSIGNED NOT NULL,   #unixtime
    creatorid    INT UNSIGNED NOT NULL DEFAULT 0,
    active       ENUM('Y','N') NOT NULL DEFAULT 'N',
    featured     ENUM('Y','N') NOT NULL DEFAULT 'N',
    custom       ENUM('Y','N') NOT NULL DEFAULT 'N',
    approved     ENUM('Y','N'),
    approved_by  INT UNSIGNED,
    approved_why MEDIUMTEXT,
    description  MEDIUMTEXT,
    cost         INT UNSIGNED NOT NULL DEFAULT 0,
    mime_small   VARCHAR(255),
    mime_large   VARCHAR(255),
 
    UNIQUE KEY (name)
)

Relationships