PageRenderTime 59ms CodeModel.GetById 29ms RepoModel.GetById 0ms app.codeStats 0ms

/SQL/UpdateInfoTo1.2.10.sql

https://github.com/jwigal/churchinfo
SQL | 244 lines | 167 code | 22 blank | 55 comment | 0 complexity | 2807a8498420c2c492cec0ddad17d107 MD5 | raw file
Possible License(s): LGPL-2.1
  1. -- It is highly recommended you backup your MySQL database before executing this
  2. -- script. To backup from the command prompt use the following.
  3. --
  4. -- system> mysqldump -u root -p db_name > filename.sql
  5. --
  6. -- Upon success filename.sql contains all the SQL to rebuild the database db_name.
  7. -- In case you need to restore your backup use the following command.
  8. --
  9. -- system> mysql -u root -p db_name < filename.sql
  10. --
  11. -- The SQL script below will migrate your database from version 1.2.9 to 1.2.10.
  12. --
  13. -- *****************************************************************************
  14. -- The following adds control parameters for MRBS plugin.
  15. -- *****************************************************************************
  16. -- Insert rows to table `config_cfg`
  17. --
  18. INSERT INTO `config_cfg` VALUES (2001, 'sMRBS_eable_periods', '', 'boolean', '0', 'Use "clock" based intervals (FALSE) or user defined periods (TRUE). If user-defined periods are used then sMRBS_resolution, sMRBS_morningstarts, sMRBS_eveningends, sMRBS_morningstart_min and sMRBS_eveningends_min are ignored.', 'General');
  19. INSERT INTO `config_cfg` VALUES (2002, 'sMRBS_resolution', '1800', 'number', '1800', 'Resolution - what blocks can be booked, in seconds.', 'General');
  20. INSERT INTO `config_cfg` VALUES (2003, 'sMRBS_morningstarts', '7', 'number', '7', 'Start of day, integer hours only, 0-23.\r\nsMRBS_morningstarts must be < sMRBS_eveningends. See also sMRBS_eveningends.', 'General');
  21. INSERT INTO `config_cfg` VALUES (2004, 'sMRBS_eveningends', '19', 'number', '19', 'endof day, integer hours only, 0-23.\r\nsMRBS_eveningends must be > sMRBS_eveningends. See also sMRBS_morningstarts.', 'General');
  22. INSERT INTO `config_cfg` VALUES (2005, 'sMRBS_morningstart_min', '0', 'number', '0', 'Minutes to add to sMRBS_morningstarts to get to the real start of the day. Be sure to consider the value of sMRBS_eveningends_min if you change this, so that you do not cause a day to finish before the start of the last period. ', 'General');
  23. INSERT INTO `config_cfg` VALUES (2006, 'sMRBS_eveningends_min', '0', 'number', '0', 'Minutes to add to sMRBS_eveningends hours to get the real end of the day.', 'General');
  24. INSERT INTO `config_cfg` VALUES (2007, 'sMRBS_weekstarts', '0', 'number', '0', 'Start of week: 0 for Sunday, 1 for Monday, 2 Ffor Tuesday etc.', 'General');
  25. INSERT INTO `config_cfg` VALUES (2008, 'sMRBS_dateformat', '0', 'number', '0', 'Trailer date format: 0 to show dates as "Jul 10", 1 for "10 Jul"', 'General');
  26. INSERT INTO `config_cfg` VALUES (2009, 'sMRBS_24hrs_format', '1', 'number', '1', 'Time format in pages. 0 to show dates in 12 hour format, 1 to show them in 24 hour format', 'General');
  27. INSERT INTO `config_cfg` VALUES (2010, 'sMRBS_default_rpt_days', '60', 'number', '60', 'Default report span in days', 'General');
  28. INSERT INTO `config_cfg` VALUES (2011, 'sMRBS_search_count', '20', 'number', '20', 'Results per page for searching', 'General');
  29. INSERT INTO `config_cfg` VALUES (2012, 'sMRBS_refresh_rate', '0', 'number', '0', 'Page refresh time (in seconds). Set to 0 to disable', 'General');
  30. INSERT INTO `config_cfg` VALUES (2013, 'sMRBS_area_list_fmt', 'list', 'text', 'list', 'should areas be shown as a list or a drop-down select box? (list / select)', 'General');
  31. INSERT INTO `config_cfg` VALUES (2014, 'sMRBS_mon_v_entries_dtl', 'both', 'text', 'both', 'Entries in monthly view can be shown as start/end slot, brief description or\r\nboth. Set to "description" for brief description, "slot" for time slot and "both" for both. Default is "both", but 6 entries per day are shown instead of 12.\r\n', 'General');
  32. --
  33. -- Insert rows to Table userconfig_ucfg
  34. -- to add access control to mrbs for admin
  35. --
  36. INSERT INTO `userconfig_ucfg` VALUES (0, 8, 'bEditMRBSBooking', '', 'boolean', 'Reserve resources in MRBS system, modify reservations and delete self reservations', 'TRUE');
  37. INSERT INTO `userconfig_ucfg` VALUES (0, 9, 'bAddMRBSResource', '', 'boolean', 'Add, modify and delete resources in MRBS, modify other user''s reservations.', 'TRUE');
  38. -- --------------------------------------------------------
  39. --
  40. -- Table structure for table `mrbs_area`
  41. --
  42. DROP TABLE IF EXISTS `mrbs_area`;
  43. CREATE TABLE `mrbs_area` (
  44. `id` int(11) NOT NULL auto_increment,
  45. `area_name` varchar(30) default NULL,
  46. `area_admin_email` text,
  47. PRIMARY KEY (`id`)
  48. ) ENGINE=MyISAM DEFAULT CHARSET=ucs2 AUTO_INCREMENT=1 ;
  49. --
  50. -- Table structure for table `mrbs_entry`
  51. --
  52. DROP TABLE IF EXISTS `mrbs_entry`;
  53. CREATE TABLE `mrbs_entry` (
  54. `id` int(11) NOT NULL auto_increment,
  55. `start_time` int(11) NOT NULL default '0',
  56. `end_time` int(11) NOT NULL default '0',
  57. `entry_type` int(11) NOT NULL default '0',
  58. `repeat_id` int(11) NOT NULL default '0',
  59. `room_id` int(11) NOT NULL default '1',
  60. `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  61. `create_by` varchar(80) NOT NULL default '',
  62. `name` varchar(80) NOT NULL default '',
  63. `type` char(1) NOT NULL default 'E',
  64. `description` text,
  65. PRIMARY KEY (`id`),
  66. KEY `idxStartTime` (`start_time`),
  67. KEY `idxEndTime` (`end_time`)
  68. ) ENGINE=MyISAM DEFAULT CHARSET=ucs2 AUTO_INCREMENT=1 ;
  69. --
  70. -- Table structure for table `mrbs_repeat`
  71. --
  72. DROP TABLE IF EXISTS `mrbs_repeat`;
  73. CREATE TABLE `mrbs_repeat` (
  74. `id` int(11) NOT NULL auto_increment,
  75. `start_time` int(11) NOT NULL default '0',
  76. `end_time` int(11) NOT NULL default '0',
  77. `rep_type` int(11) NOT NULL default '0',
  78. `end_date` int(11) NOT NULL default '0',
  79. `rep_opt` varchar(32) NOT NULL default '',
  80. `room_id` int(11) NOT NULL default '1',
  81. `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  82. `create_by` varchar(80) NOT NULL default '',
  83. `name` varchar(80) NOT NULL default '',
  84. `type` char(1) NOT NULL default 'E',
  85. `description` text,
  86. `rep_num_weeks` smallint(6) default NULL,
  87. PRIMARY KEY (`id`)
  88. ) ENGINE=MyISAM DEFAULT CHARSET=ucs2 AUTO_INCREMENT=1 ;
  89. --
  90. -- Table structure for table `mrbs_room`
  91. --
  92. DROP TABLE IF EXISTS `mrbs_room`;
  93. CREATE TABLE `mrbs_room` (
  94. `id` int(11) NOT NULL auto_increment,
  95. `area_id` int(11) NOT NULL default '0',
  96. `room_name` varchar(25) NOT NULL default '',
  97. `description` varchar(60) default NULL,
  98. `capacity` int(11) NOT NULL default '0',
  99. `room_admin_email` text,
  100. PRIMARY KEY (`id`)
  101. ) ENGINE=MyISAM DEFAULT CHARSET=ucs2 AUTO_INCREMENT=1 ;
  102. -- *************************************************************************
  103. -- MRBS plug-in database changes end here
  104. -- *************************************************************************
  105. -- *************************************************************************
  106. -- The following SQL adds Nativation Menu definition information
  107. -- *************************************************************************
  108. --
  109. -- Table structure for table `menuconfig_mcf`
  110. --
  111. CREATE TABLE `menuconfig_mcf` (
  112. `mid` int(11) NOT NULL auto_increment,
  113. `name` varchar(20) NOT NULL,
  114. `parent` varchar(20) NOT NULL,
  115. `ismenu` tinyint(1) NOT NULL,
  116. `content` varchar(100) NOT NULL,
  117. `uri` varchar(255) NOT NULL,
  118. `statustext` varchar(255) NOT NULL,
  119. `security_grp` varchar(50) NOT NULL,
  120. `session_var` varchar(50) default NULL,
  121. `session_var_in_text` tinyint(1) NOT NULL,
  122. `session_var_in_uri` tinyint(1) NOT NULL,
  123. `url_parm_name` varchar(50) default NULL,
  124. `active` tinyint(1) NOT NULL,
  125. `sortorder` tinyint(3) NOT NULL,
  126. PRIMARY KEY (`mid`)
  127. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=81 ;
  128. --
  129. -- Dumping data for table `menuconfig_mcf`
  130. --
  131. INSERT INTO `menuconfig_mcf` VALUES (1, 'ROOT', '', 1, 'Main', '', '', 'bAll', NULL, 0, 0, NULL, 1, 0);
  132. INSERT INTO `menuconfig_mcf` VALUES (2, 'main', 'root', 1, 'Main', '', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  133. INSERT INTO `menuconfig_mcf` VALUES (3, 'logoff', 'main', 0, 'Log Off', 'Default.php?Logoff=True', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  134. INSERT INTO `menuconfig_mcf` VALUES (4, 'chgpassword', 'main', 0, 'Change My Password', 'UserPasswordChange.php', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  135. INSERT INTO `menuconfig_mcf` VALUES (5, 'chgsetting', 'main', 0, 'Change My Settings', 'SettingsIndividual.php', '', 'bAll', NULL, 0, 0, NULL, 1, 0);
  136. INSERT INTO `menuconfig_mcf` VALUES (6, 'admin', 'root', 1, 'Admin', '', '', 'bAdmin', NULL, 0, 0, NULL, 1, 2);
  137. INSERT INTO `menuconfig_mcf` VALUES (7, 'editusers', 'admin', 0, 'Edit Users', 'UserList.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 1);
  138. INSERT INTO `menuconfig_mcf` VALUES (8, 'addnewuser', 'admin', 0, 'Add New User', 'UserEditor.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 2);
  139. INSERT INTO `menuconfig_mcf` VALUES (9, 'custompersonfld', 'admin', 0, 'Edit Custom Person Fields', 'PersonCustomFieldsEditor.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 3);
  140. INSERT INTO `menuconfig_mcf` VALUES (10, 'donationfund', 'admin', 0, 'Edit Donation Funds', 'DonationFundEditor.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 4);
  141. INSERT INTO `menuconfig_mcf` VALUES (11, 'dbbackup', 'admin', 0, 'Backup Database', 'BackupDatabase.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 5);
  142. INSERT INTO `menuconfig_mcf` VALUES (12, 'cvsimport', 'admin', 0, 'CSV Import', 'CSVImport.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 6);
  143. INSERT INTO `menuconfig_mcf` VALUES (13, 'accessreport', 'admin', 0, 'Access report', 'AccessReport.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 7);
  144. INSERT INTO `menuconfig_mcf` VALUES (14, 'generalsetting', 'admin', 0, 'Edit General Settings', 'SettingsGeneral.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 8);
  145. INSERT INTO `menuconfig_mcf` VALUES (15, 'reportsetting', 'admin', 0, 'Edit Report Settings', 'SettingsReport.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 9);
  146. INSERT INTO `menuconfig_mcf` VALUES (16, 'userdefault', 'admin', 0, 'Edit User Default Settings', 'SettingsUser.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 10);
  147. INSERT INTO `menuconfig_mcf` VALUES (17, 'envelopmgr', 'admin', 0, 'Envelope Manager', 'ManageEnvelopes.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 11);
  148. INSERT INTO `menuconfig_mcf` VALUES (18, 'register', 'admin', 0, 'Please select this option to register ChurchInfo after configuring.', 'Register.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 12);
  149. INSERT INTO `menuconfig_mcf` VALUES (19, 'people', 'root', 1, 'People/Families', '', 'People/Families', 'bAll', NULL, 0, 0, NULL, 1, 3);
  150. INSERT INTO `menuconfig_mcf` VALUES (20, 'newperson', 'people', 0, 'Add New Person', 'PersonEditor.php', '', 'bAddRecords', NULL, 0, 0, NULL, 1, 1);
  151. INSERT INTO `menuconfig_mcf` VALUES (21, 'viewperson', 'people', 0, 'View All Persons', 'SelectList.php?mode=person', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  152. INSERT INTO `menuconfig_mcf` VALUES (22, 'classes', 'people', 0, 'Classification Manager', 'OptionManager.php?mode=classes', '', 'bMenuOptions', NULL, 0, 0, NULL, 1, 3);
  153. INSERT INTO `menuconfig_mcf` VALUES (23, 'separator1', 'people', 0, '---------------------------', '', '', 'bAll', NULL, 0, 0, NULL, 1, 4);
  154. INSERT INTO `menuconfig_mcf` VALUES (24, 'volunteeropportunity', 'people', 0, 'Edit volunteer opportunities', 'VolunteerOpportunityEditor.php', '', 'bAll', NULL, 0, 0, NULL, 1, 5);
  155. INSERT INTO `menuconfig_mcf` VALUES (25, 'separator2', 'people', 0, '---------------------------', '', '', 'bAll', NULL, 0, 0, NULL, 1, 6);
  156. INSERT INTO `menuconfig_mcf` VALUES (26, 'newfamily', 'people', 0, 'Add New Family', 'FamilyEditor.php', '', 'bAddRecords', NULL, 0, 0, NULL, 1, 7);
  157. INSERT INTO `menuconfig_mcf` VALUES (27, 'viewfamily', 'people', 0, 'View All Families', 'SelectList.php?mode=family', '', 'bAll', NULL, 0, 0, NULL, 1, 8);
  158. INSERT INTO `menuconfig_mcf` VALUES (28, 'familygeotools', 'people', 0, 'Family Geographic Utilties', 'GeoPage.php', '', 'bAll', NULL, 0, 0, NULL, 1, 9);
  159. INSERT INTO `menuconfig_mcf` VALUES (29, 'familymap', 'people', 0, 'Family Map', 'MapUsingGoogle.php?GroupID=-1', '', 'bAll', NULL, 0, 0, NULL, 1, 10);
  160. INSERT INTO `menuconfig_mcf` VALUES (30, 'rolemanager', 'people', 0, 'Family Roles Manager', 'OptionManager.php?mode=famroles', '', 'bMenuOptions', NULL, 0, 0, NULL, 1, 11);
  161. INSERT INTO `menuconfig_mcf` VALUES (31, 'events', 'root', 1, 'Events', '', 'Events', 'bAll', NULL, 0, 0, NULL, 1, 4);
  162. INSERT INTO `menuconfig_mcf` VALUES (32, 'listevent', 'events', 0, 'List Church Events', 'ListEvents.php', 'List Church Events', 'bAll', NULL, 0, 0, NULL, 1, 1);
  163. INSERT INTO `menuconfig_mcf` VALUES (33, 'addevent', 'events', 0, 'Add Church Event', 'EventNames.php', 'Add Church Event', 'bAll', NULL, 0, 0, NULL, 1, 2);
  164. INSERT INTO `menuconfig_mcf` VALUES (34, 'eventype', 'events', 0, 'List Event Types', 'EventNames.php', '', 'bAdmin', NULL, 0, 0, NULL, 1, 3);
  165. INSERT INTO `menuconfig_mcf` VALUES (35, 'deposit', 'root', 1, 'Deposit', '', '', 'bFinance', NULL, 0, 0, NULL, 1, 5);
  166. INSERT INTO `menuconfig_mcf` VALUES (36, 'newdeposit', 'deposit', 0, 'Create New Deposit', 'DepositSlipEditor.php?DepositType=Bank', '', 'bFinance', NULL, 0, 0, NULL, 1, 1);
  167. INSERT INTO `menuconfig_mcf` VALUES (37, 'viewdeposit', 'deposit', 0, 'View All Deposits', 'FindDepositSlip.php', '', 'bFinance', NULL, 0, 0, NULL, 1, 2);
  168. INSERT INTO `menuconfig_mcf` VALUES (38, 'depositreport', 'deposit', 0, 'Deposit Reports', 'FinancialReports.php', '', 'bFinance', NULL, 0, 0, NULL, 1, 3);
  169. INSERT INTO `menuconfig_mcf` VALUES (39, 'separator3', 'deposit', 0, '---------------------------', '', '', 'bFinance', NULL, 0, 0, NULL, 1, 4);
  170. INSERT INTO `menuconfig_mcf` VALUES (40, 'depositslip', 'deposit', 0, 'Edit Deposit Slip', 'DepositSlipEditor.php', '', 'bFinance', 'iCurrentDeposit', 1, 1, 'DepositSlipID', 1, 5);
  171. INSERT INTO `menuconfig_mcf` VALUES (41, 'cart', 'root', 1, 'Cart', '', '', 'bAll', NULL, 0, 0, NULL, 1, 6);
  172. INSERT INTO `menuconfig_mcf` VALUES (42, 'viewcart', 'cart', 0, 'List Cart Items', 'CartView.php', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  173. INSERT INTO `menuconfig_mcf` VALUES (43, 'emptycart', 'cart', 0, 'Empty Cart', 'CartView.php?Action=EmptyCart', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  174. INSERT INTO `menuconfig_mcf` VALUES (44, 'carttogroup', 'cart', 0, 'Empty Cart to Group', 'CartToGroup.php', '', 'bManageGroups', NULL, 0, 0, NULL, 1, 3);
  175. INSERT INTO `menuconfig_mcf` VALUES (45, 'carttofamily', 'cart', 0, 'Empty Cart to Family', 'CartToFamily.php', '', 'bAddRecords', NULL, 0, 0, NULL, 1, 4);
  176. INSERT INTO `menuconfig_mcf` VALUES (46, 'carttoevent', 'cart', 0, 'Empty Cart to Event', 'CartToEvent.php', 'Empty Cart contents to Event', 'bAll', NULL, 0, 0, NULL, 1, 5);
  177. INSERT INTO `menuconfig_mcf` VALUES (47, 'report', 'root', 1, 'Data/Reports', '', '', 'bAll', NULL, 0, 0, NULL, 1, 7);
  178. INSERT INTO `menuconfig_mcf` VALUES (48, 'cvsexport', 'report', 0, 'CSV Export Records', 'CSVExport.php', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  179. INSERT INTO `menuconfig_mcf` VALUES (49, 'querymenu', 'report', 0, 'Query Menu', 'QueryList.php', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  180. INSERT INTO `menuconfig_mcf` VALUES (50, 'reportmenu', 'report', 0, 'Reports Menu', 'ReportList.php', '', 'bAll', NULL, 0, 0, NULL, 1, 3);
  181. INSERT INTO `menuconfig_mcf` VALUES (51, 'groups', 'root', 1, 'Groups', '', '', 'bAll', NULL, 0, 0, NULL, 1, 8);
  182. INSERT INTO `menuconfig_mcf` VALUES (52, 'listgroups', 'groups', 0, 'List Groups', 'GroupList.php', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  183. INSERT INTO `menuconfig_mcf` VALUES (53, 'newgroup', 'groups', 0, 'Add a New Group', 'GroupEditor.php', '', 'bManageGroups', NULL, 0, 0, NULL, 1, 2);
  184. INSERT INTO `menuconfig_mcf` VALUES (54, 'editgroup', 'groups', 0, 'Edit Group Types', 'OptionManager.php?mode=grptypes', '', 'bMenuOptions', NULL, 0, 0, NULL, 1, 3);
  185. INSERT INTO `menuconfig_mcf` VALUES (55, 'assigngroup', 'group', 0, 'Group Assignment Helper', 'SelectList.php?mode=groupassign', '', 'bAll', NULL, 0, 0, NULL, 1, 4);
  186. INSERT INTO `menuconfig_mcf` VALUES (56, 'properties', 'root', 1, 'Properties', '', '', 'bAll', NULL, 0, 0, NULL, 1, 9);
  187. INSERT INTO `menuconfig_mcf` VALUES (57, 'peopleproperty', 'properties', 0, 'People Properties', 'PropertyList.php?Type=p', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  188. INSERT INTO `menuconfig_mcf` VALUES (58, 'familyproperty', 'properties', 0, 'Family Properties', 'PropertyList.php?Type=f', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  189. INSERT INTO `menuconfig_mcf` VALUES (59, 'groupproperty', 'properties', 0, 'Group Properties', 'PropertyList.php?Type=g', '', 'bAll', NULL, 0, 0, NULL, 1, 3);
  190. INSERT INTO `menuconfig_mcf` VALUES (60, 'propertytype', 'properties', 0, 'Property Types', 'PropertyTypeList.php', '', 'bAll', NULL, 0, 0, NULL, 1, 4);
  191. INSERT INTO `menuconfig_mcf` VALUES (61, 'booking', 'root', 1, 'Booking', '', 'Resources Reservation', 'bAll', NULL, 0, 0, NULL, 1, 10);
  192. INSERT INTO `menuconfig_mcf` VALUES (62, 'overview', 'booking', 0, 'Reservation', 'mrbs/index.php', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  193. INSERT INTO `menuconfig_mcf` VALUES (63, 'bookingreport', 'booking', 0, 'Reports', 'mrbs/report.php', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  194. INSERT INTO `menuconfig_mcf` VALUES (64, 'help', 'root', 1, 'Help', '', '', 'bAll', NULL, 0, 0, NULL, 1, 127);
  195. INSERT INTO `menuconfig_mcf` VALUES (65, 'about', 'help', 0, 'About ChurchInfo', 'Help.php?page=About', '', 'bAll', NULL, 0, 0, NULL, 1, 1);
  196. INSERT INTO `menuconfig_mcf` VALUES (66, 'wiki', 'help', 0, 'Wiki Documentation', 'JumpToWiki.php', '', 'bAll', NULL, 0, 0, NULL, 1, 2);
  197. INSERT INTO `menuconfig_mcf` VALUES (67, 'helppeople', 'help', 0, 'People', 'Help.php?page=People', '', 'bAll', NULL, 0, 0, NULL, 1, 3);
  198. INSERT INTO `menuconfig_mcf` VALUES (68, 'helpfamily', 'help', 0, 'Families', 'Help.php?page=Family', '', 'bAll', NULL, 0, 0, NULL, 1, 4);
  199. INSERT INTO `menuconfig_mcf` VALUES (69, 'helpgeofeature', 'help', 0, 'Geographic features', 'Help.php?page=Geographic', '', 'bAll', NULL, 0, 0, NULL, 1, 5);
  200. INSERT INTO `menuconfig_mcf` VALUES (70, 'helpgroups', 'help', 0, 'Groups', 'Help.php?page=Groups', '', 'bAll', NULL, 0, 0, NULL, 1, 6);
  201. INSERT INTO `menuconfig_mcf` VALUES (71, 'helpfinance', 'help', 0, 'Finances', 'Help.php?page=Finances', '', 'bAll', NULL, 0, 0, NULL, 1, 7);
  202. INSERT INTO `menuconfig_mcf` VALUES (72, 'helpreports', 'help', 0, 'Reports', 'Help.php?page=Reports', '', 'bAll', NULL, 0, 0, NULL, 1, 8);
  203. INSERT INTO `menuconfig_mcf` VALUES (73, 'helpadmin', 'help', 0, 'Administration', 'Help.php?page=Admin', '', 'bAll', NULL, 0, 0, NULL, 1, 9);
  204. INSERT INTO `menuconfig_mcf` VALUES (74, 'helpcart', 'help', 0, 'Cart', 'Help.php?page=Cart', '', 'bAll', NULL, 0, 0, NULL, 1, 10);
  205. INSERT INTO `menuconfig_mcf` VALUES (75, 'helpproperty', 'help', 0, 'Properties', 'Help.php?page=Properties', '', 'bAll', NULL, 0, 0, NULL, 1, 11);
  206. INSERT INTO `menuconfig_mcf` VALUES (76, 'helpnotes', 'help', 0, 'Notes', 'Help.php?page=Notes', '', 'bAll', NULL, 0, 0, NULL, 1, 12);
  207. INSERT INTO `menuconfig_mcf` VALUES (77, 'helpcustomfields', 'help', 0, 'Custom Fields', 'Help.php?page=Custom', '', 'bAll', NULL, 0, 0, NULL, 1, 13);
  208. INSERT INTO `menuconfig_mcf` VALUES (78, 'helpclassification', 'help', 0, 'Classifications', 'Help.php?page=Class', '', 'bAll', NULL, 0, 0, NULL, 1, 14);
  209. INSERT INTO `menuconfig_mcf` VALUES (79, 'helpcanvass', 'help', 0, 'Canvass Support', 'Help.php?page=Canvass', '', 'bAll', NULL, 0, 0, NULL, 1, 15);
  210. INSERT INTO `menuconfig_mcf` VALUES (80, 'helpevents', 'help', 0, 'Events', 'Help.php?page=Events', '', 'bAll', NULL, 0, 0, NULL, 1, 16);
  211. -- *************************************************************************
  212. -- Nativation Menu Definition Control ends here
  213. -- *************************************************************************
  214. -- *************************************************************************
  215. -- The following SQL parameterizes Event time period from hard-coding inside program
  216. -- *************************************************************************
  217. INSERT INTO `config_cfg` VALUES (61, 'iEventPeriodStartHr', '7', 'number', '7', 'Church Event Valid Period Start Hour (0-23)', 'General');
  218. INSERT INTO `config_cfg` VALUES (62, 'iEventPeriodEndHr', '18', 'number', '18', 'Church Event Valid Period End Hour (0-23, must be greater than iEventStartHr)', 'General');
  219. INSERT INTO `config_cfg` VALUES (63, 'iEventPeriodIntervalMin', '15', 'number', '15', 'Event Period interval (in minutes)', 'General');
  220. -- *************************************************************************
  221. -- Event Time Period parameterization change ends here
  222. -- *************************************************************************