ext/search/sql/auto_install.sql

   1 -- +--------------------------------------------------------------------+
   2 -- | Copyright CiviCRM LLC. All rights reserved.                        |
   3 -- |                                                                    |
   4 -- | This work is published under the GNU AGPLv3 license with some      |
   5 -- | permitted exceptions and without any warranty. For full license    |
   6 -- | and copyright information, see https://civicrm.org/licensing       |
   7 -- +--------------------------------------------------------------------+
   8 --
   9 -- Generated from schema.tpl
  10 -- DO NOT EDIT.  Generated by CRM_Core_CodeGen
  11 --
  12
  13
  14 -- +--------------------------------------------------------------------+
  15 -- | Copyright CiviCRM LLC. All rights reserved.                        |
  16 -- |                                                                    |
  17 -- | This work is published under the GNU AGPLv3 license with some      |
  18 -- | permitted exceptions and without any warranty. For full license    |
  19 -- | and copyright information, see https://civicrm.org/licensing       |
  20 -- +--------------------------------------------------------------------+
  21 --
  22 -- Generated from drop.tpl
  23 -- DO NOT EDIT.  Generated by CRM_Core_CodeGen
  24 --
  25 -- /*******************************************************
  26 -- *
  27 -- * Clean up the exisiting tables
  28 -- *
  29 -- *******************************************************/
  30
  31 SET FOREIGN_KEY_CHECKS=0;
  32
  33 DROP TABLE IF EXISTS `civicrm_search_display`;
  34
  35 SET FOREIGN_KEY_CHECKS=1;
  36 -- /*******************************************************
  37 -- *
  38 -- * Create new tables
  39 -- *
  40 -- *******************************************************/
  41
  42 -- /*******************************************************
  43 -- *
  44 -- * civicrm_search_display
  45 -- *
  46 -- * Search Kit - saved search displays
  47 -- *
  48 -- *******************************************************/
  49 CREATE TABLE `civicrm_search_display` (
  50
  51
  52      `id` int unsigned NOT NULL AUTO_INCREMENT  COMMENT 'Unique SearchDisplay ID',
  53      `name` varchar(255) NOT NULL   COMMENT 'Unique name for identifying search display',
  54      `label` varchar(255) NOT NULL   COMMENT 'Label for identifying search display to administrators',
  55      `saved_search_id` int unsigned NOT NULL   COMMENT 'FK to saved search table.',
  56      `type` varchar(128) NOT NULL   COMMENT 'Type of display',
  57      `settings` text   DEFAULT NULL COMMENT 'Configuration data for the search display'
  58 ,
  59         PRIMARY KEY (`id`)
  60
  61     ,     UNIQUE INDEX `UI_saved_search__id_name`(
  62         saved_search_id
  63       , name
  64   )
  65
  66 ,          CONSTRAINT FK_civicrm_search_display_saved_search_id FOREIGN KEY (`saved_search_id`) REFERENCES `civicrm_saved_search`(`id`) ON DELETE CASCADE
  67 )    ;
  68
  69