| 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 ; |