show create table b_iblock_element
CREATE TABLE `b_iblock_element` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`TIMESTAMP_X` datetime DEFAULT NULL,
`MODIFIED_BY` int(18) DEFAULT NULL,
`DATE_CREATE` datetime DEFAULT NULL,
`CREATED_BY` int(18) DEFAULT NULL,
`IBLOCK_ID` int(11) NOT NULL DEFAULT '0',
`IBLOCK_SECTION_ID` int(11) DEFAULT NULL,
`ACTIVE` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`ACTIVE_FROM` datetime DEFAULT NULL,
`ACTIVE_TO` datetime DEFAULT NULL,
`SORT` int(11) NOT NULL DEFAULT '500',
`NAME` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`PREVIEW_PICTURE` int(18) DEFAULT NULL,
`PREVIEW_TEXT` text COLLATE utf8_unicode_ci,
`PREVIEW_TEXT_TYPE` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
`DETAIL_PICTURE` int(18) DEFAULT NULL,
`DETAIL_TEXT` longtext COLLATE utf8_unicode_ci,
`DETAIL_TEXT_TYPE` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'text',
`SEARCHABLE_CONTENT` text COLLATE utf8_unicode_ci,
`WF_STATUS_ID` int(18) DEFAULT '1',
`WF_PARENT_ELEMENT_ID` int(11) DEFAULT NULL,
`WF_NEW` char(1) COLLATE utf8_unicode_ci DEFAULT NULL,
`WF_LOCKED_BY` int(18) DEFAULT NULL,
`WF_DATE_LOCK` datetime DEFAULT NULL,
`WF_COMMENTS` text COLLATE utf8_unicode_ci,
`IN_SECTIONS` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`XML_ID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CODE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
[B]`TAGS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,[/B]
`TMP_ID` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`WF_LAST_HISTORY_ID` int(11) DEFAULT NULL,
`SHOW_COUNTER` int(18) DEFAULT NULL,
`SHOW_COUNTER_START` datetime DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `ix_iblock_element_1` (`IBLOCK_ID`,`IBLOCK_SECTION_ID`),
KEY `ix_iblock_element_4` (`IBLOCK_ID`,`XML_ID`,`WF_PARENT_ELEMENT_ID`),
KEY `ix_iblock_element_3` (`WF_PARENT_ELEMENT_ID`),
KEY `ix_iblock_element_code` (`IBLOCK_ID`,`CODE`)
) ENGINE=InnoDB AUTO_INCREMENT=155727 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci