[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.2.beta6.mysql.tpl

-- FIXME: the final release version is uncertain -- could 4.2.0 or 4.2.1; make sure this fixed before merging
-- CRM-10660
CREATE TABLE `civicrm_managed` (


     `id` int unsigned NOT NULL AUTO_INCREMENT  COMMENT 'Surrogate Key',
     `module` varchar(127) NOT NULL   COMMENT 'Name of the module which declared this object',
     `name` varchar(127)    COMMENT 'Symbolic name used by the module to identify the object',
     `entity_type` varchar(64) NOT NULL   COMMENT 'API entity type',
     `entity_id` int unsigned NOT NULL   COMMENT 'Foreign key to the referenced item.',
    PRIMARY KEY ( `id` )

    ,     INDEX `UI_managed_module_name`(
        `module`
      , `name`
  )
  ,     INDEX `UI_managed_entity`(
        `entity_type`
      , `entity_id`
  )


)  ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci  ;
Commit	Line	Data
6a488035 TO	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` )
10824d34	12
6a488035 TO	13	, INDEX `UI_managed_module_name`(
	14	`module`
	15	, `name`
	16	)
	17	, INDEX `UI_managed_entity`(
	18	`entity_type`
	19	, `entity_id`
	20	)
10824d34	21
10824d34	22
6a488035	23	) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;