38 lines
1.8 KiB
Smarty
38 lines
1.8 KiB
Smarty
|
-- /*******************************************************
|
||
|
|
-- * CRM-10477 - Extensions updates
|
||
|
|
-- *******************************************************/
|
||
|
|
CREATE TABLE `civicrm_extension` (
|
||
|
|
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Local Extension ID',
|
||
|
|
`type` enum('payment', 'search', 'report', 'module') NOT NULL ,
|
||
|
|
`full_name` varchar(255) NOT NULL COMMENT 'Fully qualified extension name',
|
||
|
|
`name` varchar(255) COMMENT 'Short name',
|
||
|
|
`label` varchar(255) COMMENT 'Short, printable name',
|
||
|
|
`file` varchar(255) COMMENT 'Primary PHP file',
|
||
|
|
`schema_version` varchar(63) COMMENT 'Revision code of the database schema; the format is module-defined',
|
||
|
|
`is_active` tinyint DEFAULT 1 COMMENT 'Is this extension active?' ,
|
||
|
|
PRIMARY KEY ( `id` ) ,
|
||
|
|
UNIQUE INDEX `UI_extension_full_name`(
|
||
|
|
`full_name`
|
||
|
|
),
|
||
|
|
INDEX `UI_extension_name`(
|
||
|
|
`name`
|
||
|
|
)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
|
||
|
|
|
||
|
|
-- assuming first value of array $locales is always en_US
|
||
|
|
{if $multilingual}
|
||
|
|
INSERT INTO civicrm_extension (label, full_name, name, type, file, is_active)
|
||
|
|
SELECT ov.label_{$locales.0}, ov.value, ov.name, ov.grouping, ov.description_{$locales.0}, ov.is_active
|
||
|
|
FROM civicrm_option_group og
|
||
|
|
INNER JOIN civicrm_option_value ov ON og.id = ov.option_group_id
|
||
|
|
WHERE og.name = "system_extensions";
|
||
|
|
{else}
|
||
|
|
INSERT INTO civicrm_extension (label, full_name, name, type, file, is_active)
|
||
|
|
SELECT ov.label, ov.value, ov.name, ov.grouping, ov.description, ov.is_active
|
||
|
|
FROM civicrm_option_group og
|
||
|
|
INNER JOIN civicrm_option_value ov ON og.id = ov.option_group_id
|
||
|
|
WHERE og.name = "system_extensions";
|
||
|
|
{/if}
|
||
|
|
DELETE FROM civicrm_option_group WHERE name = "system_extensions";
|
||
|
|
-- Note: Deletion cascades to civicrm_option_value
|