SHOW COLUMNS FROM kunden
Array
(
[Field] => reihe
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
Array
(
[Field] => R_Artikel
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => R_Kopien
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Aktive
[Type] => char(5)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => name
[Type] => char(40)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Nr
[Type] => char(15)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Abrech_Art
[Type] => smallint(6)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Str
[Type] => char(40)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => PLZ
[Type] => char(20)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Ort
[Type] => char(40)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Bemerkung
[Type] => char(200)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Vor
[Type] => char(10)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Tel
[Type] => char(10)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Fax
[Type] => char(10)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Anrede
[Type] => char(20)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Ansprech
[Type] => char(40)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Guthaben
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Abrech_Tag
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Abrech_Datum
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => PA_1
[Type] => char(10)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Trans
[Type] => char(120)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Art
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Rabat
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => vorname
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => zeit
[Type] => timestamp
[Null] => NO
[Key] =>
[Default] => current_timestamp()
[Extra] => on update current_timestamp()
)
Array
(
[Field] => online_state
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => online_in
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => R_Kopien_G
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => Datum
[Type] => timestamp
[Null] => NO
[Key] =>
[Default] => 0000-00-00 00:00:00
[Extra] =>
)
SHOW KEYS FROM `kunden`
SHOW TABLES FROM daten