forked from osseed/com.osseed.eventcalendar
-
Notifications
You must be signed in to change notification settings - Fork 0
/
install.sql
executable file
·17 lines (14 loc) · 1.1 KB
/
install.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SELECT @domain_id := min(id) FROM civicrm_domain;
SELECT @administerID := MAX(id) FROM civicrm_navigation where name = 'Events';
SELECT @adminCampaignWeight := MAX(weight)+1 FROM civicrm_navigation where parent_id = @administerID;
INSERT INTO civicrm_navigation
( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
VALUES
( @domain_id,'civicrm/showevents', 'Show Events Calendar', 'Show Events Calendar', 'view event info', 'AND', @administerID, '1', NULL, @adminCampaignWeight );
SELECT @domain_id := min(id) FROM civicrm_domain;
SELECT @administerID := MAX(id) FROM civicrm_navigation where name = 'CiviEvent';
SELECT @adminCampaignWeight := MAX(weight)+1 FROM civicrm_navigation where parent_id = @administerID;
INSERT INTO civicrm_navigation
( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
VALUES
( @domain_id,'civicrm/eventcalendarsettings', 'Event Calendar Settings', 'Event Calendar Settings', 'view event info', 'AND', @administerID, '1', NULL, @adminCampaignWeight );