wtx6ih5m

1Cannot execute CREATE TABLE `civicrm_setting` ( 
2`id` int(10) unsigned NOT NULL AUTO_INCREMENT, 
3`group_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'group name for setting element, useful in caching setting elements', 
4`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Unique name for setting', 
5`value` text COLLATE utf8_unicode_ci COMMENT 'data associated with this group / name combo', 
6`domain_id` int(10) unsigned NOT NULL COMMENT 'Which Domain is this menu item for', 
7`contact_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to Contact ID if the setting is localized to a contact', 
8`is_domain` tinyint(4) DEFAULT NULL COMMENT 'Is this setting a contact specific or site wide setting?', 
9`component_id` int(10) unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to', 
10`created_date` datetime DEFAULT NULL COMMENT 'When was the setting created', 
11`created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this setting', 
12PRIMARY KEY (`id`), 
13KEY `index_group_name` (`group_name`,`name`), 
14KEY `FK_civicrm_setting_domain_id` (`domain_id`), 
15KEY `FK_civicrm_setting_contact_id` (`contact_id`), 
16KEY `FK_civicrm_setting_component_id` (`component_id`), 
17KEY `FK_civicrm_setting_created_id` (`created_id`), 
18CONSTRAINT `FK_civicrm_setting_domain_id` FOREIGN KEY (`domain_id`) REFERENCES `civicrm_domain` (`id`) ON DELETE CASCADE, 
19CONSTRAINT `FK_civicrm_setting_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE CASCADE, 
20CONSTRAINT `FK_civicrm_setting_component_id` FOREIGN KEY (`component_id`) REFERENCES `civicrm_component` (`id`), 
21CONSTRAINT `FK_civicrm_setting_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL ) 
22ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1: 
23DB Error: already exists