CREATE TABLE `catalog` (
|
`uid` bigint(20) unsigned NOT NULL,
|
`security_uid` int(10) unsigned DEFAULT NULL,
|
`agent_security_uid` int(10) unsigned DEFAULT NULL,
|
`owner` varbinary(255) NOT NULL DEFAULT '',
|
`viewable_owner` varbinary(255) NOT NULL DEFAULT '',
|
`viewable_associate` varbinary(255) NOT NULL DEFAULT '',
|
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
`relative_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
|
`parent_uid` bigint(20) unsigned DEFAULT 0,
|
`id` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`description` text COLLATE utf8_unicode_ci DEFAULT NULL,
|
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`meta_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`portal_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`opportunity_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`corporate_registration_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
`ean13_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
`validation_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`simulation_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`causality_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`invoice_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`payment_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`event_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`immobilisation_state` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`reference` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
|
`grouping_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`grouping_date` datetime DEFAULT NULL,
|
`source_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`destination_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
|
`string_index` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
|
`int_index` int(11) DEFAULT NULL,
|
`float_index` double DEFAULT NULL,
|
`has_cell_content` tinyint(1) DEFAULT NULL,
|
`creation_date` datetime DEFAULT NULL,
|
`modification_date` datetime DEFAULT NULL,
|
`indexation_timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
|
PRIMARY KEY (`uid`),
|
KEY `security_uid` (`security_uid`),
|
KEY `owner` (`owner`),
|
KEY `viewable_owner` (`viewable_owner`),
|
KEY `viewable_associate` (`viewable_associate`),
|
KEY `Parent` (`parent_uid`),
|
KEY `Path` (`path`),
|
KEY `Title` (`title`),
|
KEY `Reference` (`reference`),
|
KEY `relative_url` (`relative_url`),
|
KEY `Portal Type` (`portal_type`,`reference`),
|
KEY `source_reference` (`source_reference`,`portal_type`),
|
KEY `destination_reference` (`destination_reference`,`portal_type`),
|
KEY `validation_state_portal_type` (`validation_state`,`portal_type`),
|
KEY `simulation_state_portal_type` (`simulation_state`,`portal_type`),
|
KEY `causality_state_portal_type` (`causality_state`,`portal_type`),
|
KEY `grouping_reference` (`grouping_reference`,`portal_type`),
|
KEY `agent_security_uid` (`agent_security_uid`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
|