не отображается
в базе есть таблицы есть
Код: Выделить всё
mysql> SHOW COLUMNS FROM customer_user ;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| login | varchar(200) | NO | UNI | NULL | |
| email | varchar(150) | NO | | NULL | |
| customer_id | varchar(150) | NO | | NULL | |
| pw | varchar(64) | YES | | NULL | |
| title | varchar(50) | YES | | NULL | |
| first_name | varchar(100) | NO | | NULL | |
| middle_name | varchar(50) | YES | | NULL | |
| last_name | varchar(100) | NO | | NULL | |
| phone | varchar(150) | YES | | NULL | |
| fax | varchar(150) | YES | | NULL | |
| mobile | varchar(150) | YES | | NULL | |
| street | varchar(150) | YES | | NULL | |
| zip | varchar(200) | YES | | NULL | |
| city | varchar(200) | YES | | NULL | |
| country | varchar(200) | YES | | NULL | |
| comments | varchar(250) | YES | | NULL | |
| valid_id | smallint(6) | NO | MUL | NULL | |
| create_time | datetime | NO | | NULL | |
| create_by | int(11) | NO | MUL | NULL | |
| change_time | datetime | NO | | NULL | |
| change_by | int(11) | NO | MUL | NULL | |
+-------------+--------------+------+-----+---------+----------------+
Код: Выделить всё
[ 'UserFirstname', 'Firstname', 'givenname', 1, 1, 'var' ],
[ 'UserLastname', 'Lastname', 'sn', 1, 1, 'var' ],
[ 'UserLogin', 'Login', 'sAMAccountName', 1, 1, 'var' ],
[ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
[ 'UserCustomerID', 'CustomerID', 'mail', 0, 1, 'var' ],
[ 'UserTitle', 'Title', 'title', 1, 0, 'var' ],
[ 'UserPhone', 'Phone', 'telephonenumber', 1, 0, 'var' ],
[ 'UserCity', 'City', 'l', 1, 0, 'var' ],
[ 'UserAddress', 'Address', 'postaladdress', 1, 0, 'var', '', 0 ],
[ 'UserComment', 'Comment', 'description', 1, 0, 'var', '', 0 ],
],
Должность: <OTRS_CUSTOMER_DATA_UserTitle>
Телефон: <OTRS_CUSTOMER_DATA_UserPhone>
Отдел: <OTRS_CUSTOMER_DATA_UserComment>
Город: <OTRS_CUSTOMER_DATA_UserCity>