crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/CRM/Upgrade/Incremental/sql/4.2.beta6.mysql.tpl

   1 -- FIXME: the final release version is uncertain -- could 4.2.0 or 4.2.1; make sure this fixed before merging
   2 -- CRM-10660
   3 CREATE TABLE `civicrm_managed` (
   4
   5
   6      `id` int unsigned NOT NULL AUTO_INCREMENT  COMMENT 'Surrogate Key',
   7      `module` varchar(127) NOT NULL   COMMENT 'Name of the module which declared this object',
   8      `name` varchar(127)    COMMENT 'Symbolic name used by the module to identify the object',
   9      `entity_type` varchar(64) NOT NULL   COMMENT 'API entity type',
  10      `entity_id` int unsigned NOT NULL   COMMENT 'Foreign key to the referenced item.',
  11     PRIMARY KEY ( `id` )
  12
  13     ,     INDEX `UI_managed_module_name`(
  14         `module`
  15       , `name`
  16   )
  17   ,     INDEX `UI_managed_entity`(
  18         `entity_type`
  19       , `entity_id`
  20   )
  21
  22
  23 )  ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;