Database Table: vgift_ids

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)
)