CAO - FAKTURA

Code: Alles auswählen

CREATE TABLE ARTIKEL_SHOP (
    ARTIKEL_ID INT(11) NOT NULL DEFAULT '0',
    SHOP_ID INT(11) NOT NULL DEFAULT '0',
    SHOPARTIKEL TINYINT(4) NOT NULL DEFAULT '-1',
    SHOP_DATENBLATT VARCHAR(100) NOT NULL DEFAULT '',
    SHOP_IMAGE VARCHAR(100) NOT NULL DEFAULT '',
    SHOP_IMAGE_MED VARCHAR(100) NOT NULL DEFAULT '',
    SHOP_IMAGE_LARGE VARCHAR(100) NOT NULL DEFAULT '',
    FSK18_FLAG ENUM('N','Y') NOT NULL DEFAULT 'N',
    SHOP_DEL_FLAG ENUM('N','Y') NOT NULL DEFAULT 'N',
    SHOP_SORT INT(11) UNSIGNED NOT NULL DEFAULT '0',
    SHOP_LIEFSTATUS INT(11) NOT NULL DEFAULT '1',
    SHOP_LIEFTEXT VARCHAR(255) NOT NULL DEFAULT '',
    SHOP_CHANGE_LIEF INT(1) UNSIGNED NOT NULL DEFAULT '0',
    SHOP_ARTIKEL_ID INT(11) NOT NULL DEFAULT '-1',
    SHOP_CHANGE_FLAG TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
    SHOP_VISIBLE INT(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (ARTIKEL_ID, SHOP_ID)
)
Type=MyISAM;