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 | |
22 | ||
6a488035 | 23 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ; |