banners

  • Banner

    Struktur

    Feldname Datentyp Beschreibung
    banners_id int(11) NOT NULL auto_increment Datensatz ID
    banners_title varchar(64) NOT NULL default Banner Titel
    banners_url varchar(255) NOT NULL default Banner URL
    banners_image varchar(64) NOT NULL default Banner Bild
    banners_group varchar(10) NOT NULL default Banner Gruppe
    banners_store int(1) NOT NULL default '1' Store ID
    banners_html_text text Banner HTML Text
    expires_impressions int(7) default '0' Banner Impressionen
    expires_date datetime default NULL Gültig bis Datum
    date_scheduled datetime default NULL Beginn Datum
    date_added datetime NOT NULL default '0000-00-00 00:00:00' Hizugefügt am
    date_status_change datetime default NULL Geändert am
    banner_status int(1) NOT NULL default '1' Banner Status


    Indize

    Indextyp Indexname Indexspalten
    PRIMARY KEY banners_id

Share