Struktur
Feldname | Datentyp | Beschreibung |
templates_id | int(10) unsigned NOT NULL default '0' | DATENSATZ ID |
table_name | varchar(250) NOT NULL | Tabellen Name |
template_name | varchar(250) NOT NULL | Template Name |
allocations | text NOT NULL | Zuweisungen |
import_mode | varchar(250) NOT NULL | Import Modus |
conditions | text NOT NULL | Bedingungen |
overwrite | enum('0','1') NOT NULL | Überschreiben |
stores | varchar(255) NOT NULL | Store ID (ref. ms_store) |
languages | varchar(255) NOT NULL | Sprach ID (ref. languages) |
special_settings | text NOT NULL | Sonstige Bedingungen |
import_separator | varchar(10) NOT NULL | Spaltentrenner |
distributor | int(5) NOT NULL | Lieferanten ID (ref. supplier) |
Indize
Indextyp | Indexname | Indexspalten |
PRIMARY KEY | templates_id, table_name |