Commit | Line | Data |
---|---|---|
e991ce44 CW |
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 |