INSERT INTO `opl_menuItem` 
    VALUES 
    (1,NULL,'home',1,'blue','en','Home','','/bin/home',NULL,''),
    (2,1,NULL,1,NULL,'en','OPALS Home','','/bin/home','',''),
    (3,NULL,'search',2,'green','en','Search','\0','',NULL,''),
    (4,3,NULL,1,NULL,'en','Standard','\0','/bin/search/standard','',''),
    (6,3,NULL,3,NULL,'en','Advanced','\0','/bin/search/advance','',''),
    (7,3,NULL,4,NULL,'en','Beginner','\0','/bin/search/beginner','',''),
    (12,NULL,'myfile',3,'cyan','en','My File','\0','',NULL,''),
    (13,12,NULL,1,NULL,'en','Information','\0','/bin/user/myinfo','',''),
    (14,12,NULL,2,NULL,'en','Circulation','\0','/bin/user/myaccount','',''),
    (15,NULL,'circ',5,'brown','en','Circulation','\0','',NULL,''),
    (16,15,NULL,1,NULL,'en','Loans','\0','/bin/circ/loan','-----y','circ_loan'),
    (17,15,NULL,2,NULL,'en','Renewals','\0','/bin/circ/renew','-----y','circ_loan'),
    (18,15,NULL,3,NULL,'en','Returns','\0','/bin/circ/return','------y','circ_return'),
    (19,15,NULL,5,NULL,'en','Reserve','\0','/bin/circ/reserve','-------yy','circ_rsrv_self,circ_rsrv'),
    (20,15,NULL,6,NULL,'en','Payments','\0','/bin/circ/payments','-----------y','fine'),
    (21,15,NULL,6,NULL,'en','Notices','\0','/bin/circ/odnotice','------------y','notice'),
    (22,15,NULL,7,NULL,'en','In-Library Use','\0','/bin/circ/inlibrary','-----y','circ_loan'),
    (23,15,NULL,8,NULL,'en','Item Status','\0','/bin/circ/loan_itemStatus','-----y','circ_loan'),
    (24,NULL,'textbook',6,'green','en','Textbooks','\0','',NULL,''),
    (25,24,NULL,1,NULL,'en','Loans','\0','/bin/txtbk/circ/loan','--------------y','tb_circ_loan'),
    (26,24,NULL,2,NULL,'en','Returns','\0','/bin/txtbk/circ/return','--------------y','tb_circ_return'),
    (27,NULL,'user',6,'orange','en','Users','\0','',NULL,''),
    (28,27,NULL,1,NULL,'en','Information','\0','/bin/report/userCircStats','-y','user_edit'),
    (29,27,NULL,2,NULL,'en','Add','\0','/bin/user/add','y','user_add'),
    (30,27,NULL,3,NULL,'en','Quick Entry','\0','/bin/user/add?qk=1','y','user_add'),
    (31,27,NULL,5,NULL,'en','Edit','\0','/bin/user/edit','-y','user_edit'),
    (32,27,NULL,6,NULL,'en','Delete','\0','/bin/user/del','----------y','user_delete'),
    (33,27,NULL,7,NULL,'en','Group Editor','\0','/bin/user/grpedit','-y','user_edit'),
    (34,27,NULL,8,NULL,'en','Import','\0','/bin/user/import_user','y','user_add'),
    (35,NULL,'item',7,'turqoise','en','Items','\0','',NULL,''),
    (36,35,NULL,1,NULL,'en','Quick Item Entry','\0','/bin/marc21/quickItemEntry','--y','marc_edit'),
    (37,35,NULL,2,NULL,'en','MARC Editor','\0','/bin/marc21/edit','--y','marc_edit'),
    (38,35,NULL,3,NULL,'en','Global Editor','\0','/bin/record/ge852','--y','marc_edit'),
    (39,35,NULL,4,NULL,'en','Status','\0','/bin/record/status','--y','marc_edit'),
    (40,35,NULL,5,NULL,'en','Z-Import','\0','/bin/search/zimport','--y','marc_edit'),
    (41,35,NULL,6,NULL,'en','Import','\0','/bin/record/import','--y','marc_edit'),
    (42,35,NULL,7,NULL,'en','Merge','\0','/bin/record/merge','--y','marc_edit'),
    (43,35,NULL,8,NULL,'en','Export','\0','/bin/record/export','--y','marc_edit'),
    (44,NULL,'admin',8,'red','en','Administration','\0','',NULL,''),
    (45,44,NULL,1,NULL,'en','Preferences','\0','/bin/util/listpref','---y','pref_edit'),
    (46,44,NULL,2,NULL,'en','Reports/Tools','\0','/bin/report/listreport','---------y','report'),
    (47,44,NULL,3,NULL,'en','Inventory','\0','/bin/report/inventoryList','---------y','report'),
    (48,1,NULL,2,NULL,'en','New Items','','/bin/newitems','',''),
    (49,1,NULL,3,NULL,'en','News','','/bin/viewNewsEvent','',''),
    (50,1,NULL,4,NULL,'en','Library Hours','','/bin/lHours','',''),
    (51,1,NULL,5,NULL,'en','Web Links','','/bin/viewWeblink','',''),
    (52,27,NULL,4,NULL,'en','Quick Entry List',NULL,'/bin/user/edit?qk=1','y','user_add'),
    (53,3,NULL,6,NULL,'en','Author Browse',NULL,'/bin/search/authorBrowse','',''),
    (54,3,NULL,7,NULL,'en','Subject Browse',NULL,'/bin/search/subjectBrowse','',''),
    (55,3,NULL,5,NULL,'en','AR/RC/Lexile',NULL,'/bin/search/arl','',''),
    (56,NULL,'home',1,'blue','fr','Accueil','','/bin/home',NULL,''),
    (57,56,NULL,1,NULL,'fr','OPALS Accueil','','/bin/home','',''),
    (58,NULL,'search',2,'green','fr','Recherche','\0','',NULL,''),
    (59,58,NULL,1,NULL,'fr','Simple','\0','/bin/search/standard','',''),
    (60,58,NULL,3,NULL,'fr','Recherche avancÃƒÂƒÃ‚Â©e','\0','/bin/search/advance','',''),
    (61,58,NULL,4,NULL,'fr','Enfants','\0','/bin/search/beginner','',''),
    (62,NULL,'myfile',3,'cyan','fr','Mon dossier','\0','',NULL,''),
    (63,62,NULL,1,NULL,'fr','Mon Profil','\0','/bin/user/myinfo','',''),
    (64,62,NULL,2,NULL,'fr','PrÃƒÂƒÃ‚Âªts - Gestion','\0','/bin/user/myaccount','',''),
    (65,NULL,'circ',5,'brown','fr','PrÃƒÂƒÃ‚Âªts - Gestion','\0','',NULL,''),
    (66,65,NULL,1,NULL,'fr','PrÃƒÂƒÃ‚Âªts','\0','/bin/circ/loan','-----y','circ_loan'),
    (67,65,NULL,2,NULL,'fr','Renouveler','\0','/bin/circ/renew','-----y','circ_loan'),
    (68,65,NULL,3,NULL,'fr','Retourner','\0','/bin/circ/return','------y','circ_return'),
    (69,65,NULL,5,NULL,'fr','RÃƒÂƒÃ‚Â©server','\0','/bin/circ/reserve','-------yy','circ_rsrv_self,circ_rsrv'),
    (70,65,NULL,6,NULL,'fr','Paiements','\0','/bin/circ/payments','-----------y','fine'),
    (71,65,NULL,6,NULL,'fr','Avis','\0','/bin/circ/odnotice','------------y','notice'),
    (72,65,NULL,7,NULL,'fr','Consultation sur place','\0','/bin/circ/inlibrary','-----y','circ_loan'),
    (73,65,NULL,8,NULL,'fr','Statut','\0','/bin/circ/loan_itemStatus','-----y','circ_loan'),
    (74,NULL,'textbook',6,'green','fr','Manuels scolaires','\0','',NULL,''),
    (75,74,NULL,1,NULL,'fr','PrÃƒÂƒÃ‚Âªts','\0','/bin/circ/loan?tbk=1','-----y','circ_loan'),
    (76,74,NULL,2,NULL,'fr','Retours','\0','/bin/circ/return?tbk=1','------y','circ_return'),
    (77,NULL,'user',6,'orange','fr','Usagers','\0','',NULL,''),
    (78,77,NULL,1,NULL,'fr','Renseignments','\0','/bin/report/userCircStats','-y','user_edit'),
    (79,77,NULL,2,NULL,'fr','Ajouter','\0','/bin/user/add','y','user_add'),
    (80,77,NULL,3,NULL,'fr','Saisie rapide','\0','/bin/user/add?qk=1','y','user_add'),
    (81,77,NULL,5,NULL,'fr','Modifier','\0','/bin/user/edit','-y','user_edit'),
    (82,77,NULL,6,NULL,'fr','Effacer','\0','/bin/user/del','----------y','user_delete'),
    (83,77,NULL,7,NULL,'fr','Modification globale','\0','/bin/user/grpedit','-y','user_edit'),
    (84,77,NULL,8,NULL,'fr','Importer','\0','/bin/user/import_user','y','user_add'),
    (85,NULL,'item',7,'turqoise','fr','Document','\0','',NULL,''),
    (86,85,NULL,1,NULL,'fr','Saisie rapide','\0','/bin/marc21/quickItemEntry','--y','marc_edit'),
    (87,85,NULL,2,NULL,'fr','Editeur MARC','\0','/bin/marc21/edit','--y','marc_edit'),
    (88,85,NULL,3,NULL,'fr','Modification globale','\0','/bin/record/ge852','--y','marc_edit'),
    (89,85,NULL,4,NULL,'fr','Statut','\0','/bin/record/status','--y','marc_edit'),
    (90,85,NULL,5,NULL,'fr','Z-Import','\0','/bin/search/zimport','--y','marc_edit'),
    (91,85,NULL,6,NULL,'fr','Importer donnÃƒÂƒÃ‚Â©es MARC','\0','/bin/record/import','--y','marc_edit'),
    (92,85,NULL,7,NULL,'fr','Fusionner','\0','/bin/record/merge','--y','marc_edit'),
    (93,85,NULL,8,NULL,'fr','Exporter','\0','/bin/record/export','--y','marc_edit'),
    (94,NULL,'admin',8,'red','fr','Administration','\0','',NULL,''),
    (95,94,NULL,1,NULL,'fr','PrÃƒÂƒÃ‚Â©fÃƒÂƒÃ‚Â©rences','\0','/bin/util/listpref','---y','pref_edit'),
    (96,94,NULL,2,NULL,'fr','Rapports & Outils','\0','/bin/report/listreport','---------y','report'),
    (97,94,NULL,3,NULL,'fr','Inventaire','\0','/bin/report/inventoryList','---------y','report'),
    (98,56,NULL,2,NULL,'fr','NouveautÃƒÂƒÃ‚Â©s','','/bin/newitems','',''),
    (99,56,NULL,3,NULL,'fr','Nouvelles','','/bin/viewNewsEvent','',''),
    (100,56,NULL,4,NULL,'fr','Horaire','','/bin/lHours','',''),
    (101,56,NULL,5,NULL,'fr','Liens','','/bin/viewWeblink','',''),
    (102,77,NULL,4,NULL,'fr','Liste - Fiches incomplÃƒÂƒÃ‚Â¨tes',NULL,'/bin/user/edit?qk=1','y','user_add'),
    (103,58,NULL,6,NULL,'fr','Auteur-Liste alphabÃ©tique',NULL,'/bin/search/authorBrowse','',''),
    (104,58,NULL,7,NULL,'fr','Sujet-Liste alphabÃ©tique',NULL,'/bin/search/subjectBrowse','',''),
    (105,58,NULL,5,NULL,'fr','AR/RC/Lexile',NULL,'/bin/search/arl','',''),
    (106,27,NULL,9,NULL,'en','Import Pictures',NULL,'/bin/user/userImgImport','-----y','circ_loan'),
    (107,77,NULL,9,NULL,'fr','Import Pictures',NULL,'/bin/user/userImgImport','-----y','circ_loan'),
    (108,15,NULL,9,NULL,'en','Loaned Items',NULL,'/bin/report/itemonloan','-----y','circ_loan'),
    (109,65,NULL,9,NULL,'fr','Document prÃƒÂƒÃ‚ÂªtÃƒÂƒÃ‚Â©s',NULL,'/bin/report/itemonloan','-----y','circ_loan'),
    (110,NULL,'eqmnt',7,'cyan','en','Equipment',NULL,NULL,NULL,''),
    (111,110,NULL,6,NULL,'en','Define Fields',NULL,'/bin/eqmnt/eqDef','-------------y','eq_record_edit'),
    (112,110,NULL,7,NULL,'en','Add New',NULL,'/bin/eqmnt/eqRecord','-------------y','eq_record_edit'),
    (113,110,NULL,4,NULL,'en','Reserve',NULL,'/bin/eqmnt/reserve','-------------y','eq_circ_rsrv,eq_circ_rsrv_self'),
    (114,110,NULL,1,NULL,'en','Loans',NULL,'/bin/eqmnt/loan','-------------y','eq_circ_loan'),
    (115,110,NULL,3,NULL,'en','Returns',NULL,'/bin/eqmnt/return','-------------y','eq_circ_return'),
    (116,110,NULL,8,NULL,'en','Search',NULL,'/bin/eqmnt/search','-------------y',''),
    (117,110,NULL,5,NULL,'en','Item Status',NULL,'/bin/eqmnt/loan_itemStatus','-------------y','eq_circ_loan'),
    (118,110,NULL,2,NULL,'en','Renewals',NULL,'/bin/eqmnt/renew','-------------y','eq_circ_loan'),
    (119,110,NULL,9,NULL,'en','Item Loans & Notices',NULL,'/bin/eqmnt/report/itemOnLoan','-------------y','eq_report'),
    (120,110,NULL,10,NULL,'en','Reserved Items',NULL,'/bin/eqmnt/eqOnReserve','-------------y','eq_report'),
    (121,24,NULL,3,NULL,'en','Search',NULL,'/bin/txtbk/search','--------------y',''),
    (122,24,NULL,5,NULL,'en','Add New',NULL,'/bin/txtbk/bookEntry','--------------y','tb_record_edit'),
    (123,24,NULL,4,NULL,'en','Item Status',NULL,'/bin/txtbk/loan_itemStatus','--------------y','tb_circ_loan'),
    (124,24,NULL,6,NULL,'en','Loaned Reports',NULL,'/bin/txtbk/report/itemOnLoan','--------------y','tb_report'),
    (125,24,NULL,7,NULL,'en','Notices',NULL,'/bin/txtbk/odnotice','--------------y','tb_notice'),
    (126,1,NULL,6,NULL,'en','Pathfinders',NULL,'/bin/pf/pfList','',''),
    (127,24,NULL,8,NULL,'en','Teacher List',NULL,'/bin/txtbk/teacher/list','--------------y','tb_user_edit'),
    (128,24,NULL,9,NULL,'en','Course List',NULL,'/bin/txtbk/course/list','--------------y','tb_course_edit'),
    (129,24,NULL,10,NULL,'en','Link Teachers to Courses',NULL,'/bin/txtbk/teacher/teacherSchedule','--------------y','tb_user_edit'),
    (130,24,NULL,11,NULL,'en','Reports/Tools',NULL,'/bin/txtbk/report/listreport','--------------y','tb_report'),
    (131,3,NULL,2,NULL,'en','OWL Beginner',NULL,'/bin/search/bgnrSrch/srchPage','',''),
    (132,58,NULL,2,NULL,'fr','HIBOU Enfants',NULL,'/bin/search/bgnrSrch/srchPage','',''),
    (133,56,NULL,6,NULL,'fr','ÃƒÂƒÃ¢Â€Â°claireurs',NULL,'/bin/pf/pfList','',''),
    (134,15,NULL,4,NULL,'en','Quick Return',NULL,'/bin/circ/return?quickMode=true','------y','circ_return'),
    (135,65,NULL,4,NULL,'fr','Retourner Rapid',NULL,'/bin/circ/return?quickMode=true','------y','circ_return'),
    (136,110,NULL,11,NULL,'en','Reports',NULL,'/bin/eqmnt/report/listreport',NULL,'eq_report'),
    (142,12,NULL,3,NULL,'en','Student ILL Request List',NULL,'/bin/ill/list','','');

