(2793,'New Record inserted On students id 458','458',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2794,'New Record inserted On  student session id 458','458',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2795,'New Record inserted On users id 1071','1071',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2796,'New Record inserted On users id 1072','1072',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2797,'Record updated On students id 458','458',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2798,'New Record inserted On students id 459','459',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2799,'New Record inserted On  student session id 459','459',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2800,'New Record inserted On users id 1073','1073',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2801,'New Record inserted On users id 1074','1074',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2802,'Record updated On students id 459','459',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2803,'New Record inserted On students id 460','460',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2804,'New Record inserted On  student session id 460','460',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2805,'New Record inserted On users id 1075','1075',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2806,'New Record inserted On users id 1076','1076',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2807,'Record updated On students id 460','460',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2808,'New Record inserted On students id 461','461',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2809,'New Record inserted On  student session id 461','461',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2810,'New Record inserted On users id 1077','1077',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2811,'New Record inserted On users id 1078','1078',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2812,'Record updated On students id 461','461',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2813,'New Record inserted On students id 462','462',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2814,'New Record inserted On  student session id 462','462',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2815,'New Record inserted On users id 1079','1079',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2816,'New Record inserted On users id 1080','1080',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2817,'Record updated On students id 462','462',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2818,'New Record inserted On students id 463','463',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2819,'New Record inserted On  student session id 463','463',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2820,'New Record inserted On users id 1081','1081',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2821,'New Record inserted On users id 1082','1082',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2822,'Record updated On students id 463','463',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2823,'New Record inserted On students id 464','464',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2824,'New Record inserted On  student session id 464','464',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2825,'New Record inserted On users id 1083','1083',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2826,'New Record inserted On users id 1084','1084',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2827,'Record updated On students id 464','464',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2828,'New Record inserted On students id 465','465',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2829,'New Record inserted On  student session id 465','465',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2830,'New Record inserted On users id 1085','1085',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2831,'New Record inserted On users id 1086','1086',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2832,'Record updated On students id 465','465',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2833,'New Record inserted On students id 466','466',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2834,'New Record inserted On  student session id 466','466',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2835,'New Record inserted On users id 1087','1087',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2836,'New Record inserted On users id 1088','1088',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2837,'Record updated On students id 466','466',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2838,'New Record inserted On students id 467','467',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2839,'New Record inserted On  student session id 467','467',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2840,'New Record inserted On users id 1089','1089',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2841,'New Record inserted On users id 1090','1090',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2842,'Record updated On students id 467','467',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2843,'New Record inserted On students id 468','468',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2844,'New Record inserted On  student session id 468','468',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2845,'New Record inserted On users id 1091','1091',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2846,'New Record inserted On users id 1092','1092',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2847,'Record updated On students id 468','468',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2848,'New Record inserted On students id 469','469',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2849,'New Record inserted On  student session id 469','469',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2850,'New Record inserted On users id 1093','1093',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2851,'New Record inserted On users id 1094','1094',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2852,'Record updated On students id 469','469',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2853,'New Record inserted On students id 470','470',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2854,'New Record inserted On  student session id 470','470',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2855,'New Record inserted On users id 1095','1095',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2856,'New Record inserted On users id 1096','1096',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2857,'Record updated On students id 470','470',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:39:47',NULL),(2858,'New Record inserted On students id 471','471',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2859,'New Record inserted On  student session id 471','471',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2860,'New Record inserted On users id 1097','1097',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2861,'New Record inserted On users id 1098','1098',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2862,'Record updated On students id 471','471',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2863,'New Record inserted On students id 472','472',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2864,'New Record inserted On  student session id 472','472',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2865,'New Record inserted On users id 1099','1099',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2866,'New Record inserted On users id 1100','1100',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2867,'Record updated On students id 472','472',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2868,'New Record inserted On students id 473','473',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2869,'New Record inserted On  student session id 473','473',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2870,'New Record inserted On users id 1101','1101',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2871,'New Record inserted On users id 1102','1102',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2872,'Record updated On students id 473','473',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2873,'New Record inserted On students id 474','474',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2874,'New Record inserted On  student session id 474','474',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2875,'New Record inserted On users id 1103','1103',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2876,'New Record inserted On users id 1104','1104',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2877,'Record updated On students id 474','474',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2878,'New Record inserted On students id 475','475',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2879,'New Record inserted On  student session id 475','475',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2880,'New Record inserted On users id 1105','1105',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2881,'New Record inserted On users id 1106','1106',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2882,'Record updated On students id 475','475',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2883,'New Record inserted On students id 476','476',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2884,'New Record inserted On  student session id 476','476',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2885,'New Record inserted On users id 1107','1107',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2886,'New Record inserted On users id 1108','1108',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2887,'Record updated On students id 476','476',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 14:40:09',NULL),(2888,'New Record inserted On students id 477','477',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2889,'New Record inserted On  student session id 477','477',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2890,'New Record inserted On users id 1109','1109',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2891,'New Record inserted On users id 1110','1110',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2892,'Record updated On students id 477','477',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2893,'New Record inserted On students id 478','478',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2894,'New Record inserted On  student session id 478','478',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2895,'New Record inserted On users id 1111','1111',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2896,'New Record inserted On users id 1112','1112',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2897,'Record updated On students id 478','478',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2898,'New Record inserted On students id 479','479',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2899,'New Record inserted On  student session id 479','479',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2900,'New Record inserted On users id 1113','1113',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2901,'New Record inserted On users id 1114','1114',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2902,'Record updated On students id 479','479',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2903,'New Record inserted On students id 480','480',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2904,'New Record inserted On  student session id 480','480',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2905,'New Record inserted On users id 1115','1115',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2906,'New Record inserted On users id 1116','1116',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2907,'Record updated On students id 480','480',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2908,'New Record inserted On students id 481','481',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2909,'New Record inserted On  student session id 481','481',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2910,'New Record inserted On users id 1117','1117',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2911,'New Record inserted On users id 1118','1118',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2912,'Record updated On students id 481','481',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2913,'New Record inserted On students id 482','482',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2914,'New Record inserted On  student session id 482','482',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2915,'New Record inserted On users id 1119','1119',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2916,'New Record inserted On users id 1120','1120',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2917,'Record updated On students id 482','482',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2918,'New Record inserted On students id 483','483',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2919,'New Record inserted On  student session id 483','483',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2920,'New Record inserted On users id 1121','1121',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2921,'New Record inserted On users id 1122','1122',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2922,'Record updated On students id 483','483',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2923,'New Record inserted On students id 484','484',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2924,'New Record inserted On  student session id 484','484',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2925,'New Record inserted On users id 1123','1123',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2926,'New Record inserted On users id 1124','1124',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2927,'Record updated On students id 484','484',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2928,'New Record inserted On students id 485','485',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2929,'New Record inserted On  student session id 485','485',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2930,'New Record inserted On users id 1125','1125',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2931,'New Record inserted On users id 1126','1126',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2932,'Record updated On students id 485','485',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2933,'New Record inserted On students id 486','486',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2934,'New Record inserted On  student session id 486','486',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2935,'New Record inserted On users id 1127','1127',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2936,'New Record inserted On users id 1128','1128',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2937,'Record updated On students id 486','486',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2938,'New Record inserted On students id 487','487',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2939,'New Record inserted On  student session id 487','487',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2940,'New Record inserted On users id 1129','1129',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2941,'New Record inserted On users id 1130','1130',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2942,'Record updated On students id 487','487',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2943,'New Record inserted On students id 488','488',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2944,'New Record inserted On  student session id 488','488',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2945,'New Record inserted On users id 1131','1131',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2946,'New Record inserted On users id 1132','1132',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2947,'Record updated On students id 488','488',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2948,'New Record inserted On students id 489','489',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2949,'New Record inserted On  student session id 489','489',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2950,'New Record inserted On users id 1133','1133',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2951,'New Record inserted On users id 1134','1134',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2952,'Record updated On students id 489','489',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2953,'New Record inserted On students id 490','490',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2954,'New Record inserted On  student session id 490','490',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2955,'New Record inserted On users id 1135','1135',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2956,'New Record inserted On users id 1136','1136',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2957,'Record updated On students id 490','490',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2958,'New Record inserted On students id 491','491',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2959,'New Record inserted On  student session id 491','491',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2960,'New Record inserted On users id 1137','1137',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2961,'New Record inserted On users id 1138','1138',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2962,'Record updated On students id 491','491',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2963,'New Record inserted On students id 492','492',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2964,'New Record inserted On  student session id 492','492',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2965,'New Record inserted On users id 1139','1139',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2966,'New Record inserted On users id 1140','1140',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2967,'Record updated On students id 492','492',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2968,'New Record inserted On students id 493','493',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2969,'New Record inserted On  student session id 493','493',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2970,'New Record inserted On users id 1141','1141',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2971,'New Record inserted On users id 1142','1142',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2972,'Record updated On students id 493','493',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2973,'New Record inserted On students id 494','494',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2974,'New Record inserted On  student session id 494','494',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2975,'New Record inserted On users id 1143','1143',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2976,'New Record inserted On users id 1144','1144',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2977,'Record updated On students id 494','494',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2978,'New Record inserted On students id 495','495',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2979,'New Record inserted On  student session id 495','495',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:55',NULL),(2980,'New Record inserted On users id 1145','1145',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2981,'New Record inserted On users id 1146','1146',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2982,'Record updated On students id 495','495',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2983,'New Record inserted On students id 496','496',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2984,'New Record inserted On  student session id 496','496',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2985,'New Record inserted On users id 1147','1147',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2986,'New Record inserted On users id 1148','1148',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2987,'Record updated On students id 496','496',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2988,'New Record inserted On students id 497','497',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2989,'New Record inserted On  student session id 497','497',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2990,'New Record inserted On users id 1149','1149',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2991,'New Record inserted On users id 1150','1150',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2992,'Record updated On students id 497','497',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2993,'New Record inserted On students id 498','498',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2994,'New Record inserted On  student session id 498','498',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2995,'New Record inserted On users id 1151','1151',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2996,'New Record inserted On users id 1152','1152',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2997,'Record updated On students id 498','498',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2998,'New Record inserted On students id 499','499',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(2999,'New Record inserted On  student session id 499','499',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3000,'New Record inserted On users id 1153','1153',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3001,'New Record inserted On users id 1154','1154',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3002,'Record updated On students id 499','499',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3003,'New Record inserted On students id 500','500',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3004,'New Record inserted On  student session id 500','500',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3005,'New Record inserted On users id 1155','1155',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3006,'New Record inserted On users id 1156','1156',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3007,'Record updated On students id 500','500',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3008,'New Record inserted On students id 501','501',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3009,'New Record inserted On  student session id 501','501',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3010,'New Record inserted On users id 1157','1157',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3011,'New Record inserted On users id 1158','1158',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3012,'Record updated On students id 501','501',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3013,'New Record inserted On students id 502','502',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3014,'New Record inserted On  student session id 502','502',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3015,'New Record inserted On users id 1159','1159',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3016,'New Record inserted On users id 1160','1160',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3017,'Record updated On students id 502','502',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3018,'New Record inserted On students id 503','503',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3019,'New Record inserted On  student session id 503','503',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3020,'New Record inserted On users id 1161','1161',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3021,'New Record inserted On users id 1162','1162',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3022,'Record updated On students id 503','503',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3023,'New Record inserted On students id 504','504',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3024,'New Record inserted On  student session id 504','504',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3025,'New Record inserted On users id 1163','1163',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3026,'New Record inserted On users id 1164','1164',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3027,'Record updated On students id 504','504',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3028,'New Record inserted On students id 505','505',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3029,'New Record inserted On  student session id 505','505',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3030,'New Record inserted On users id 1165','1165',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3031,'New Record inserted On users id 1166','1166',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3032,'Record updated On students id 505','505',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:06:56',NULL),(3033,'New Record inserted On class teacher id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3034,'New Record inserted On class teacher id 2','2',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3035,'New Record inserted On class teacher id 3','3',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3036,'New Record inserted On class teacher id 4','4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3037,'New Record inserted On class teacher id 5','5',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3038,'New Record inserted On class teacher id 6','6',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3039,'New Record inserted On class teacher id 7','7',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3040,'New Record inserted On class teacher id 8','8',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3041,'New Record inserted On class teacher id 9','9',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3042,'New Record inserted On class teacher id 10','10',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3043,'New Record inserted On class teacher id 11','11',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:14:55',NULL),(3044,'New Record inserted On class teacher id 12','12',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3045,'New Record inserted On class teacher id 13','13',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3046,'New Record inserted On class teacher id 14','14',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3047,'New Record inserted On class teacher id 15','15',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3048,'New Record inserted On class teacher id 16','16',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3049,'New Record inserted On class teacher id 17','17',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3050,'New Record inserted On class teacher id 18','18',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3051,'New Record inserted On class teacher id 19','19',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3052,'New Record inserted On class teacher id 20','20',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3053,'New Record inserted On class teacher id 21','21',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3054,'New Record inserted On class teacher id 22','22',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3055,'New Record inserted On class teacher id 23','23',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:15:26',NULL),(3056,'New Record inserted On  subject timetable id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3057,'New Record inserted On  subject timetable id 0','0',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3058,'New Record inserted On  subject timetable id -1','-1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3059,'New Record inserted On  subject timetable id -2','-2',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3060,'New Record inserted On  subject timetable id -3','-3',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3061,'New Record inserted On  subject timetable id -4','-4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3062,'New Record inserted On  subject timetable id -5','-5',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:20:52',NULL),(3063,'New Record inserted On student fees master id 55','55',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3064,'New Record inserted On student fees master id 56','56',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3065,'New Record inserted On student fees master id 57','57',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3066,'New Record inserted On student fees master id 58','58',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3067,'New Record inserted On student fees master id 59','59',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3068,'New Record inserted On student fees master id 60','60',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3069,'New Record inserted On student fees master id 61','61',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3070,'New Record inserted On student fees master id 62','62',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3071,'New Record inserted On student fees master id 63','63',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3072,'New Record inserted On student fees master id 64','64',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3073,'New Record inserted On student fees master id 65','65',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3074,'New Record inserted On student fees master id 66','66',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3075,'New Record inserted On student fees master id 67','67',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3076,'New Record inserted On student fees master id 68','68',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3077,'New Record inserted On student fees master id 69','69',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3078,'New Record inserted On student fees master id 70','70',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3079,'New Record inserted On student fees master id 71','71',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3080,'New Record inserted On student fees master id 72','72',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3081,'New Record inserted On student fees master id 73','73',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3082,'New Record inserted On student fees master id 74','74',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3083,'New Record inserted On student fees master id 75','75',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3084,'New Record inserted On student fees master id 76','76',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3085,'New Record inserted On student fees master id 77','77',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3086,'New Record inserted On student fees master id 78','78',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3087,'New Record inserted On student fees master id 79','79',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3088,'New Record inserted On student fees master id 80','80',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3089,'New Record inserted On student fees master id 81','81',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3090,'New Record inserted On student fees master id 82','82',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3091,'New Record inserted On student fees master id 83','83',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3092,'New Record inserted On student fees master id 84','84',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3093,'New Record inserted On student fees master id 85','85',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3094,'New Record inserted On student fees master id 86','86',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3095,'New Record inserted On student fees master id 87','87',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3096,'New Record inserted On student fees master id 88','88',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3097,'New Record inserted On student fees master id 89','89',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3098,'New Record inserted On student fees master id 90','90',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3099,'New Record inserted On student fees master id 91','91',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3100,'New Record inserted On student fees master id 92','92',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3101,'New Record inserted On student fees master id 93','93',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3102,'New Record inserted On student fees master id 94','94',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3103,'New Record inserted On student fees master id 95','95',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3104,'New Record inserted On student fees master id 96','96',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3105,'New Record inserted On student fees master id 97','97',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3106,'New Record inserted On student fees master id 98','98',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3107,'New Record inserted On student fees master id 99','99',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3108,'New Record inserted On student fees master id 100','100',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3109,'New Record inserted On student fees master id 101','101',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3110,'New Record inserted On student fees master id 102','102',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:15',NULL),(3111,'New Record inserted On student fees master id 103','103',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3112,'New Record inserted On student fees master id 104','104',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3113,'New Record inserted On student fees master id 105','105',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3114,'New Record inserted On student fees master id 106','106',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3115,'New Record inserted On student fees master id 107','107',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3116,'New Record inserted On student fees master id 108','108',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3117,'New Record inserted On student fees master id 109','109',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3118,'New Record inserted On student fees master id 110','110',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3119,'New Record inserted On student fees master id 111','111',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3120,'New Record inserted On student fees master id 112','112',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3121,'New Record inserted On student fees master id 113','113',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:24:16',NULL),(3122,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:25:43',NULL),(3123,'Record updated On staff id 42','42',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:33:25',NULL),(3124,'Record updated On permission group id 12','12',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:40:40',NULL),(3125,'Record updated On permission group id 9','9',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:40:56',NULL),(3126,'Record updated On staff id 42','42',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:43:10',NULL),(3127,'Record updated On staff id 42','42',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 15:43:10',NULL),(3128,'New Record inserted On send notification id 1','1',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-07 16:04:37',NULL),(3129,'New Record inserted On subjects id 13','13',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-07 16:21:13',NULL),(3130,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 16:21:37',NULL),(3131,'New Record inserted On subjects id 14','14',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-07 16:21:42',NULL),(3132,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 16:21:52',NULL),(3133,'New Record inserted On subject groups id 5','5',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-07 16:22:41',NULL),(3134,'New Record inserted On subject groups id 6','6',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-07 16:23:54',NULL),(3135,'Record updated On Front CMS Setting id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 16:24:41',NULL),(3136,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-07 16:24:41',NULL),(3137,'Record updated On settings id 1','1',1,'Update','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:02:44',NULL),(3138,'Record updated On settings id 1','1',1,'Update','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:03:37',NULL),(3139,'Record updated On settings id 1','1',1,'Update','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:16:27',NULL),(3140,'New Record inserted On students id 506','506',1,'Insert','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:33:13',NULL),(3141,'New Record inserted On  student session id 506','506',1,'Insert','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:33:13',NULL),(3142,'New Record inserted On users id 1167','1167',1,'Insert','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:33:13',NULL),(3143,'New Record inserted On users id 1168','1168',1,'Insert','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:33:13',NULL),(3144,'Record updated On students id 506','506',1,'Update','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:33:13',NULL),(3145,'Record updated On students id 506','506',1,'Update','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:50:46',NULL),(3146,'Record updated On  student session id 506','506',1,'Update','41.78.72.130','Windows 10','Firefox 125.0','2024-05-07 23:50:46',NULL),(3147,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:10:11',NULL),(3148,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:10:45',NULL),(3149,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:17:48',NULL),(3150,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:22:10',NULL),(3151,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:26:48',NULL),(3152,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:27:22',NULL),(3153,'New Record inserted On  categories id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:35:05',NULL),(3154,'New Record inserted On  categories id 2','2',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:35:35',NULL),(3155,'New Record inserted On  categories id 3','3',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:36:02',NULL),(3156,'New Record inserted On  categories id 4','4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:37:07',NULL),(3157,'Record updated On students id 160','160',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:38:34',NULL),(3158,'Record updated On  student session id 160','160',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:38:34',NULL),(3159,'Record updated On students id 148','148',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:39:18',NULL),(3160,'Record updated On  student session id 148','148',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:39:18',NULL),(3161,'Record updated On students id 377','377',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:40:21',NULL),(3162,'Record updated On  student session id 377','377',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:40:21',NULL),(3163,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:48:43',NULL),(3164,'New Record inserted On exam groups id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:58:41',NULL),(3165,'New Record inserted On exam groups id 2','2',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:59:07',NULL),(3166,'New Record inserted On exam groups id 3','3',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 06:59:26',NULL),(3167,'New Record inserted On exam groups id 4','4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 07:00:53',NULL),(3168,'Record updated On  exam groups id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 07:01:01',NULL),(3169,'New Record inserted On exam group exams name id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 07:02:38',NULL),(3170,'Record updated On  admit cards id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 07:09:53',NULL),(3171,'Record updated On  admit cards id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 07:10:26',NULL),(3172,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-08 07:35:21',NULL),(3173,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-08 07:41:43',NULL),(3174,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 09:13:00',NULL),(3175,'New Record inserted On exam groups id 5','5',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 10:01:49',NULL),(3176,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 11:16:32',NULL),(3177,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 13:26:14',NULL),(3178,'Record updated On  marksheets id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-08 14:18:06',NULL),(3179,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Mac OS X','Safari 605.1.15','2024-05-08 16:30:34',NULL),(3180,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Mac OS X','Safari 605.1.15','2024-05-08 16:36:57',NULL),(3181,'Record updated On  admit cards id 1','1',42,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 08:18:11',NULL),(3182,'New Record inserted On student edit fields id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:48:57',NULL),(3183,'New Record inserted On student edit fields id 2','2',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:49:06',NULL),(3184,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:49:07',NULL),(3185,'New Record inserted On student edit fields id 3','3',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:50:25',NULL),(3186,'New Record inserted On student edit fields id 4','4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:50:28',NULL),(3187,'Record updated On  student edit fields id 4','4',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:50:35',NULL),(3188,'New Record inserted On student edit fields id 5','5',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:50:41',NULL),(3189,'New Record inserted On student edit fields id 6','6',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:50:48',NULL),(3190,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 09:50:55',NULL),(3191,'New Record inserted On homework id 1','1',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 11:14:43',NULL),(3192,'Record updated On Daily Assignment id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 11:17:21',NULL),(3193,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-09 11:24:17',NULL),(3194,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 11:24:32',NULL),(3195,'Record deleted On languages id 95','95',1,'Delete','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 11:27:52',NULL),(3196,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-09 11:27:52',NULL),(3197,'Record updated On permission group id 700','700',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-09 12:08:06',NULL),(3198,'Record updated On permission group id 700','700',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-09 12:08:11',NULL),(3199,'New Record inserted On lesson id 1','1',42,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 06:55:51',NULL),(3200,'New Record inserted On topic id 1','1',42,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 06:56:16',NULL),(3201,'New Record inserted On  content_types id 1','1',42,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:01:03',NULL),(3202,'New Record inserted On  upload_contents id 1','1',42,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:01:24',NULL),(3203,'New Record inserted On  upload_contents id 2','2',42,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:04:39',NULL),(3204,'Record deleted On upload_contents id 1','1',42,'Delete','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:04:46',NULL),(3205,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:06:54',NULL),(3206,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:08:51',NULL),(3207,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 07:20:37',NULL),(3208,'New Record inserted On  subject timetable id 36','36',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 08:54:34',NULL),(3209,'New Record inserted On  subject timetable id 35','35',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 08:54:34',NULL),(3210,'New Record inserted On  subject timetable id 34','34',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 08:54:34',NULL),(3211,'New Record inserted On class teacher id 24','24',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 08:55:44',NULL),(3212,'New Record inserted On sections id 4','4',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 08:59:25',NULL),(3213,'New Record inserted On disable reason id 1','1',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 09:14:12',NULL),(3214,'Record updated On students id 107','107',42,'Update','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 09:15:12',NULL),(3215,'Record updated On users id 369','369',42,'Update','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 09:15:43',NULL),(3216,'New Record inserted On  fee group id 4','4',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 09:31:09',NULL),(3217,'New Record inserted On  fee groups feetype id 3','3',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 09:31:38',NULL),(3218,'Record updated On staff rating id 1','1',42,'Update','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 09:59:53',NULL),(3219,'New Record inserted On send notification id 2','2',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 10:01:57',NULL),(3220,'New Record inserted On lesson id 2','2',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 10:06:09',NULL),(3221,'New Record inserted On topic id 2','2',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 10:06:45',NULL),(3222,'New Record inserted On topic id 3','3',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 10:06:45',NULL),(3223,'New Record inserted On topic id 4','4',42,'Insert','192.145.174.250','Windows 10','Chrome 124.0.0.0','2024-05-11 10:06:45',NULL),(3224,'New Record inserted On  fee type id 4','4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:28:22',NULL),(3225,'Record deleted On  fee type id 3','3',1,'Delete','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:28:33',NULL),(3226,'Record deleted On  fee type id 2','2',1,'Delete','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:28:36',NULL),(3227,'Record deleted On  fee type id 1','1',1,'Delete','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:28:39',NULL),(3228,'New Record inserted On  fee type id 5','5',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:33:42',NULL),(3229,'New Record inserted On  fee group id 5','5',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:34:34',NULL),(3230,'New Record inserted On  fee group id 6','6',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:34:52',NULL),(3231,'New Record inserted On  fee groups feetype id 4','4',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:36:55',NULL),(3232,'New Record inserted On students id 507','507',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:38:27',NULL),(3233,'New Record inserted On  student session id 507','507',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:38:27',NULL),(3234,'New Record inserted On users id 1169','1169',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:38:27',NULL),(3235,'New Record inserted On users id 1170','1170',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:38:27',NULL),(3236,'Record updated On students id 507','507',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:38:27',NULL),(3237,'New Record inserted On students id 508','508',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:43:49',NULL),(3238,'New Record inserted On  student session id 508','508',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:43:49',NULL),(3239,'New Record inserted On users id 1171','1171',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:43:49',NULL),(3240,'New Record inserted On users id 1172','1172',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:43:49',NULL),(3241,'Record updated On students id 508','508',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:43:49',NULL),(3242,'New Record inserted On students id 509','509',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:45:43',NULL),(3243,'New Record inserted On  student session id 509','509',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:45:43',NULL),(3244,'New Record inserted On users id 1173','1173',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:45:43',NULL),(3245,'New Record inserted On users id 1174','1174',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:45:43',NULL),(3246,'Record updated On students id 509','509',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-11 14:45:43',NULL),(3247,'New Record inserted On students id 510','510',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-12 06:26:10',NULL),(3248,'New Record inserted On  student session id 510','510',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-12 06:26:10',NULL),(3249,'New Record inserted On users id 1175','1175',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-12 06:26:10',NULL),(3250,'New Record inserted On users id 1176','1176',1,'Insert','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-12 06:26:10',NULL),(3251,'Record updated On students id 510','510',1,'Update','102.38.51.177','Windows 10','Chrome 124.0.0.0','2024-05-12 06:26:11',NULL),(3252,'New Record inserted On students id 511','511',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:30:10',NULL),(3253,'New Record inserted On  student session id 511','511',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:30:11',NULL),(3254,'New Record inserted On users id 1177','1177',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:30:11',NULL),(3255,'New Record inserted On users id 1178','1178',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:30:11',NULL),(3256,'Record updated On students id 511','511',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:30:11',NULL),(3257,'New Record inserted On students id 512','512',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:36:48',NULL),(3258,'New Record inserted On  student session id 512','512',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:36:48',NULL),(3259,'New Record inserted On users id 1179','1179',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:36:48',NULL),(3260,'New Record inserted On users id 1180','1180',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:36:48',NULL),(3261,'Record updated On students id 512','512',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 10:36:48',NULL),(3262,'New Record inserted On students id 513','513',1,'Insert','192.145.168.87','Windows 10','Firefox 125.0','2024-05-12 10:42:03',NULL),(3263,'New Record inserted On  student session id 513','513',1,'Insert','192.145.168.87','Windows 10','Firefox 125.0','2024-05-12 10:42:03',NULL),(3264,'New Record inserted On users id 1181','1181',1,'Insert','192.145.168.87','Windows 10','Firefox 125.0','2024-05-12 10:42:03',NULL),(3265,'New Record inserted On users id 1182','1182',1,'Insert','192.145.168.87','Windows 10','Firefox 125.0','2024-05-12 10:42:03',NULL),(3266,'Record updated On students id 513','513',1,'Update','192.145.168.87','Windows 10','Firefox 125.0','2024-05-12 10:42:03',NULL),(3267,'New Record inserted On students id 514','514',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:17:55',NULL),(3268,'New Record inserted On  student session id 514','514',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:17:55',NULL),(3269,'New Record inserted On users id 1183','1183',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:17:55',NULL),(3270,'New Record inserted On users id 1184','1184',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:17:55',NULL),(3271,'Record updated On students id 514','514',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:17:55',NULL),(3272,'New Record inserted On student fees master id 121','121',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3273,'New Record inserted On student fees master id 122','122',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3274,'New Record inserted On student fees master id 123','123',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3275,'New Record inserted On student fees master id 124','124',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3276,'New Record inserted On student fees master id 125','125',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3277,'New Record inserted On student fees master id 126','126',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3278,'New Record inserted On student fees master id 127','127',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3279,'New Record inserted On student fees master id 128','128',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3280,'New Record inserted On student fees master id 129','129',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3281,'New Record inserted On student fees master id 130','130',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3282,'New Record inserted On student fees master id 131','131',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3283,'New Record inserted On student fees master id 132','132',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3284,'New Record inserted On student fees master id 133','133',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3285,'New Record inserted On student fees master id 134','134',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3286,'New Record inserted On student fees master id 135','135',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3287,'New Record inserted On student fees master id 136','136',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3288,'New Record inserted On student fees master id 137','137',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3289,'New Record inserted On student fees master id 138','138',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3290,'New Record inserted On student fees master id 139','139',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3291,'New Record inserted On student fees master id 140','140',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3292,'New Record inserted On student fees master id 141','141',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3293,'New Record inserted On student fees master id 142','142',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3294,'New Record inserted On student fees master id 143','143',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3295,'New Record inserted On student fees master id 144','144',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3296,'New Record inserted On student fees master id 145','145',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3297,'New Record inserted On student fees master id 146','146',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3298,'New Record inserted On student fees master id 147','147',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3299,'New Record inserted On student fees master id 148','148',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3300,'New Record inserted On student fees master id 149','149',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3301,'New Record inserted On student fees master id 150','150',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:20:10',NULL),(3302,'New Record inserted On  fee type id 6','6',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:26:15',NULL),(3303,'New Record inserted On  fee groups feetype id 5','5',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:27:10',NULL),(3304,'New Record inserted On  income head   id 1','1',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:39:09',NULL),(3305,'New Record inserted On  Income   id 1','1',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:40:29',NULL),(3306,'New Record inserted On student fees master id 151','151',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3307,'New Record inserted On student fees master id 152','152',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3308,'New Record inserted On student fees master id 153','153',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3309,'New Record inserted On student fees master id 154','154',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3310,'New Record inserted On student fees master id 155','155',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3311,'New Record inserted On student fees master id 156','156',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3312,'New Record inserted On student fees master id 157','157',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3313,'New Record inserted On student fees master id 158','158',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3314,'New Record inserted On student fees master id 159','159',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3315,'New Record inserted On student fees master id 160','160',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3316,'New Record inserted On student fees master id 161','161',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3317,'New Record inserted On student fees master id 162','162',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3318,'New Record inserted On student fees master id 163','163',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3319,'New Record inserted On student fees master id 164','164',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3320,'New Record inserted On student fees master id 165','165',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3321,'New Record inserted On student fees master id 166','166',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3322,'New Record inserted On student fees master id 167','167',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3323,'New Record inserted On student fees master id 168','168',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:16',NULL),(3324,'New Record inserted On student fees master id 169','169',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3325,'New Record inserted On student fees master id 170','170',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3326,'New Record inserted On student fees master id 171','171',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3327,'New Record inserted On student fees master id 172','172',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3328,'New Record inserted On student fees master id 173','173',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3329,'New Record inserted On student fees master id 174','174',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3330,'New Record inserted On student fees master id 175','175',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3331,'New Record inserted On student fees master id 176','176',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:42:17',NULL),(3332,'New Record inserted On students id 515','515',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:55:49',NULL),(3333,'New Record inserted On  student session id 515','515',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:55:49',NULL),(3334,'New Record inserted On users id 1185','1185',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:55:49',NULL),(3335,'New Record inserted On users id 1186','1186',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:55:49',NULL),(3336,'Record updated On students id 515','515',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:55:49',NULL),(3337,'New Record inserted On students id 516','516',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:57:45',NULL),(3338,'New Record inserted On  student session id 516','516',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:57:45',NULL),(3339,'New Record inserted On users id 1187','1187',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:57:45',NULL),(3340,'New Record inserted On users id 1188','1188',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:57:45',NULL),(3341,'Record updated On students id 516','516',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 12:57:45',NULL),(3342,'New Record inserted On students id 517','517',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-12 13:02:55',NULL),(3343,'New Record inserted On  student session id 517','517',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-12 13:02:55',NULL),(3344,'New Record inserted On users id 1189','1189',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-12 13:02:55',NULL),(3345,'New Record inserted On users id 1190','1190',1,'Insert','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-12 13:02:55',NULL),(3346,'Record updated On students id 517','517',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-12 13:02:55',NULL),(3347,'New Record inserted On students id 518','518',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:15:43',NULL),(3348,'New Record inserted On  student session id 518','518',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:15:43',NULL),(3349,'New Record inserted On users id 1191','1191',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:15:43',NULL),(3350,'New Record inserted On users id 1192','1192',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:15:43',NULL),(3351,'Record updated On students id 518','518',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:15:43',NULL),(3352,'New Record inserted On students id 519','519',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:31:16',NULL),(3353,'New Record inserted On  student session id 519','519',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:31:16',NULL),(3354,'New Record inserted On users id 1193','1193',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:31:16',NULL),(3355,'New Record inserted On users id 1194','1194',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:31:16',NULL),(3356,'Record updated On students id 519','519',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:31:16',NULL),(3357,'New Record inserted On students id 520','520',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:34:11',NULL),(3358,'New Record inserted On  student session id 520','520',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:34:11',NULL),(3359,'New Record inserted On users id 1195','1195',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:34:11',NULL),(3360,'New Record inserted On users id 1196','1196',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:34:11',NULL),(3361,'Record updated On students id 520','520',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:34:11',NULL),(3362,'New Record inserted On students id 521','521',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:35:33',NULL),(3363,'New Record inserted On  student session id 521','521',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:35:33',NULL),(3364,'New Record inserted On users id 1197','1197',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:35:33',NULL),(3365,'New Record inserted On users id 1198','1198',42,'Insert','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:35:33',NULL),(3366,'Record updated On students id 521','521',42,'Update','102.38.51.177','Windows 10','Chrome 92.0.4515.131','2024-05-12 13:35:33',NULL),(3367,'Record updated On settings id 1','1',1,'Update','102.38.51.177','Mac OS X','Chrome 124.0.0.0','2024-05-16 17:31:27',NULL);

--
-- Table structure for table `mark_divisions`
--

CREATE TABLE `mark_divisions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT NULL,
  `percentage_from` float(10,2) DEFAULT NULL,
  `percentage_to` float(10,2) DEFAULT NULL,
  `is_active` int DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mark_divisions`
--


--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `template_id` varchar(100) DEFAULT NULL,
  `email_template_id` int DEFAULT NULL,
  `sms_template_id` int DEFAULT NULL,
  `send_through` varchar(20) DEFAULT NULL,
  `message` text,
  `send_mail` varchar(10) DEFAULT '0',
  `send_sms` varchar(10) DEFAULT '0',
  `is_group` varchar(10) DEFAULT '0',
  `is_individual` varchar(10) DEFAULT '0',
  `is_class` int NOT NULL DEFAULT '0',
  `is_schedule` int NOT NULL,
  `sent` int DEFAULT NULL,
  `schedule_date_time` datetime DEFAULT NULL,
  `group_list` text,
  `user_list` text,
  `schedule_class` int DEFAULT NULL,
  `schedule_section` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `messages`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `version` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `migrations`
--


--
-- Table structure for table `multi_branch`
--

CREATE TABLE `multi_branch` (
  `id` int NOT NULL AUTO_INCREMENT,
  `branch_name` varchar(200) DEFAULT NULL,
  `branch_url` varchar(500) NOT NULL,
  `hostname` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `database_name` varchar(200) DEFAULT NULL,
  `directory_path` varchar(500) DEFAULT NULL,
  `is_verified` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `multi_branch`
--


--
-- Table structure for table `notification_roles`
--

CREATE TABLE `notification_roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `send_notification_id` int DEFAULT NULL,
  `role_id` int DEFAULT NULL,
  `is_active` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `send_notification_id` (`send_notification_id`),
  KEY `role_id` (`role_id`),
  CONSTRAINT `notification_roles_ibfk_1` FOREIGN KEY (`send_notification_id`) REFERENCES `send_notification` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notification_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `notification_roles`
--

INSERT INTO `notification_roles` VALUES (1,1,1,0,'2024-05-07 16:04:37'),(2,1,7,0,'2024-05-07 16:04:37'),(3,2,7,0,'2024-05-11 10:01:57'),(4,2,1,0,'2024-05-11 10:01:57'),(5,2,2,0,'2024-05-11 10:01:57'),(6,2,3,0,'2024-05-11 10:01:57'),(7,2,4,0,'2024-05-11 10:01:57');

--
-- Table structure for table `notification_setting`
--

CREATE TABLE `notification_setting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(100) DEFAULT NULL,
  `is_mail` varchar(10) DEFAULT '0',
  `is_sms` varchar(10) DEFAULT '0',
  `is_notification` int NOT NULL DEFAULT '0',
  `display_notification` int NOT NULL DEFAULT '0',
  `display_sms` int NOT NULL DEFAULT '1',
  `is_student_recipient` int DEFAULT NULL,
  `is_guardian_recipient` int DEFAULT NULL,
  `is_staff_recipient` int DEFAULT NULL,
  `display_student_recipient` int DEFAULT NULL,
  `display_guardian_recipient` int DEFAULT NULL,
  `display_staff_recipient` int DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `template_id` varchar(100) NOT NULL,
  `template` longtext NOT NULL,
  `variables` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `notification_setting`
--

INSERT INTO `notification_setting` VALUES (1,'student_admission','1','0',0,0,1,1,1,NULL,1,1,NULL,'Student Admission','','Dear {{student_name}} your admission is confirm in Class: {{class}} Section:  {{section}} for Session: {{current_session_name}} for more \r\ndetail\r\n contact\r\n System\r\n Admin\r\n {{class}} {{section}} {{admission_no}} {{roll_no}} {{admission_date}} {{mobileno}} {{email}} {{dob}} {{guardian_name}} {{guardian_relation}} {{guardian_phone}} {{father_name}} {{father_phone}} {{blood_group}} {{mother_name}} {{gender}} {{guardian_email}}','{{student_name}} {{class}}  {{section}}  {{admission_no}}  {{roll_no}}  {{admission_date}}   {{mobileno}}  {{email}}  {{dob}}  {{guardian_name}}  {{guardian_relation}}  {{guardian_phone}}  {{father_name}}  {{father_phone}}  {{blood_group}}  {{mother_name}}  {{gender}} {{guardian_email}} {{current_session_name}} ','2022-12-28 09:52:24'),(2,'exam_result','1','0',0,1,1,1,NULL,NULL,1,1,NULL,'Exam Result','','Dear {{student_name}} - {{exam_roll_no}}, your {{exam}} result has been published.','{{student_name}} {{exam_roll_no}} {{exam}}','2022-12-28 09:52:24'),(3,'fee_submission','1','0',0,1,1,1,1,NULL,1,1,NULL,'Fee Submission','','Dear parents, we have received Fees Amount {{fee_amount}} for  {{student_name}}  by Your School Name \r\n{{class}} {{section}} {{fine_type}} {{fine_percentage}} {{fine_amount}} {{fee_group_name}} {{type}} {{code}} {{email}} {{contact_no}} {{invoice_id}} {{sub_invoice_id}} {{due_date}} {{amount}} {{fee_amount}}','{{student_name}} {{class}} {{section}} {{fine_type}} {{fine_percentage}} {{fine_amount}} {{fee_group_name}} {{type}} {{code}} {{email}} {{contact_no}} {{invoice_id}} {{sub_invoice_id}} {{due_date}} {{amount}} {{fee_amount}}','2022-12-28 09:52:24'),(4,'absent_attendence','1','0',0,1,1,1,1,NULL,1,1,NULL,'Absent Attendence','','Absent Notice :{{student_name}}  was absent on date {{date}} in period {{subject_name}} {{subject_code}} {{subject_type}} from Your School Name','{{student_name}} {{mobileno}} {{email}} {{father_name}} {{father_phone}} {{father_occupation}} {{mother_name}} {{mother_phone}} {{guardian_name}} {{guardian_phone}} {{guardian_occupation}} {{guardian_email}} {{date}} {{current_session_name}} {{time_from}} {{time_to}} {{subject_name}} {{subject_code}} {{subject_type}}  ','2022-12-28 09:52:24'),(6,'homework','1','0',0,1,1,1,NULL,NULL,1,1,NULL,'Homework','','New Homework has been created for \r\n{{student_name}} at\r\n\r\n\r\n\r\n{{homework_date}} for the class {{class}} {{section}} {{subject}}. kindly submit your\r\n\r\n\r\n homework before {{submit_date}} .Thank you','{{homework_date}} {{submit_date}} {{class}} {{section}} {{subject}} {{student_name}} {{admission_no}} ','2022-12-28 09:52:24'),(7,'fees_reminder','1','0',0,1,1,1,1,NULL,1,1,NULL,'Fees Reminder','','Dear parents, please pay fee amount Rs.{{due_amount}} of {{fee_type}} before {{due_date}} for {{student_name}}  from smart school (ignore if you already paid)','{{fee_type}}{{fee_code}}{{due_date}}{{student_name}}{{school_name}}{{fee_amount}}{{due_amount}}{{deposit_amount}} ','2022-12-28 09:52:24'),(8,'forgot_password','1','0',0,0,0,1,1,1,1,1,1,'Forgot Password','','Dear  {{name}} , \r\n    Recently a request was submitted to reset password for your account. If you didn\'t make the request, just ignore this email. Otherwise you can reset your password using this link <a href=\'{{resetPassLink}}\'>Click here to reset your password</a>,\r\nif you\'re having trouble clicking the password reset button, copy and paste the URL below into your web browser. your username {{username}}\r\n{{resetPassLink}}\r\n Regards,\r\n {{school_name}}','{{school_name}}{{name}}{{username}}{{resetPassLink}} ','2022-12-28 09:52:24'),(9,'online_examination_publish_exam','1','0',0,1,1,1,NULL,NULL,1,1,NULL,'Online Examination Publish Exam','','A new exam {{exam_title}} has been created for  duration: {{time_duration}} min, which will be available from:  {{exam_from}} to  {{exam_to}}.','{{exam_title}} {{exam_from}} {{exam_to}} {{time_duration}} {{attempt}} {{passing_percentage}}','2022-12-28 09:52:24'),(10,'online_examination_publish_result','1','0',0,1,1,1,NULL,NULL,1,1,NULL,'Online Examination Publish Result','','Exam {{exam_title}} result has been declared which was conducted between  {{exam_from}} to   {{exam_to}}, for more details, please check your student portal.','{{exam_title}} {{exam_from}} {{exam_to}} {{time_duration}} {{attempt}} {{passing_percentage}}','2022-12-28 09:52:24'),(11,'online_admission_form_submission','1','0',0,1,1,1,1,NULL,1,1,NULL,'Online Admission Form Submission','','Dear {{firstname}}  {{lastname}} your online admission form is Submitted successfully  on date {{date}}. Your Reference number is {{reference_no}}. Please remember your reference number for further process.',' {{firstname}} {{lastname}} {{date}} {{reference_no}}','2022-12-28 09:52:24'),(12,'online_admission_fees_submission','0','0',0,1,1,1,1,NULL,1,1,NULL,'Online Admission Fees Submission','','Dear {{firstname}}  {{lastname}} your online admission form is Submitted successfully and the payment of {{paid_amount}} has recieved successfully on date {{date}}. Your Reference number is {{reference_no}}. Please remember your reference number for further process.',' {{firstname}} {{lastname}} {{date}} {{paid_amount}} {{reference_no}}','2022-12-28 09:52:24'),(13,'student_login_credential','1','1',0,0,1,1,1,0,1,1,NULL,'Student Login Credential','1707163291685208209','Hello {{display_name}} your login details for Url: {{url}} Username: {{username}}  Password: {{password}} admission No: {{admission_no}}','{{url}} {{display_name}} {{username}} {{password}} {{admission_no}}','2022-08-06 05:34:41'),(14,'staff_login_credential','1','1',0,0,1,0,0,1,NULL,NULL,1,'Staff Login Credential','1707163291685208209','Hello {{first_name}} {{last_name}} your login details for Url: {{url}} Username: {{username}}  Password: {{password}} Employee ID: {{employee_id}}','{{url}} {{first_name}} {{last_name}} {{username}} {{password}} {{employee_id}}','2021-12-23 11:59:13'),(15,'fee_processing','1','1',1,1,1,1,1,0,1,1,NULL,'Fee processing','1707163291301326898','Dear parents, we have received Fees Amount {{fee_amount}} for  {{student_name}}  by Your School Name \r\n{{class}} {{section}} {{email}} {{contact_no}}\r\n\r\n{{student_name}} {{class}} {{section}} {{email}} {{contact_no}} transaction_id :{{transaction_id}} {{fee_amount}}','{{student_name}} {{class}} {{section}} {{email}} {{contact_no}} {{transaction_id}} {{fee_amount}}','2021-12-22 10:15:42'),(16,'online_admission_fees_processing','1','1',1,1,1,1,1,0,1,1,NULL,'Online Admission Fees Processing','','Dear {{firstname}}  {{lastname}} your online admission form is Submitted successfully and the payment of {{paid_amount}} has processing on date {{date}}. Your Reference number is {{reference_no}} and your transaction id {{transaction_id}}. Please remember your reference number for further process.',' {{firstname}} {{lastname}} {{date}} {{paid_amount}} {{reference_no}} {{transaction_id}}','2022-08-06 11:09:47'),(17,'student_apply_leave','1','1',0,0,1,0,1,1,NULL,1,1,'Student Apply Leave ( {{student_name}} - {{admission_no}} )','','My Name is {{student_name}} Class {{class}} section {{section}}. I have to apply leave on {{apply_date}}and from {{from_date}} to {{to_date}}. {{message}} please provide.','{{message}} {{apply_date}} {{from_date}} {{to_date}} {{student_name}} {{class}} {{section}}','2022-03-12 11:58:37'),(18,'email_pdf_exam_marksheet','1','0',0,0,0,1,1,0,1,1,NULL,'Email PDF Exam Marksheet ( {{student_name}} - {{admission_no}} )','','Dear {{student_name}} ({{admission_no}}) {{class}} Section {{section}}. We have mailed you the marksheet of Exam {{exam}} Roll no.{{roll_no}}','{{student_name}} {{class}}  {{section}}  {{admission_no}}  {{roll_no}} {{exam}} {{admit_card_roll_no}} ','2022-03-12 12:24:42'),(19,'online_course_publish','1','1',0,1,1,1,NULL,NULL,1,1,NULL,'Online Course Publish','','Dear student, a new online course {{title}} and price {{price}} with discount {{discount}}% for {{class}} {{section}} is {{paid_free}} now available and assign to {{assign_teacher}}.','{{title}} {{class}} {{section}} {{price}} {{discount}} {{paid_free}} {{assign_teacher}}\r\n ','2022-11-15 03:09:13'),(20,'online_course_purchase','1','1',0,1,1,1,NULL,NULL,1,1,NULL,'Online Course Purchase','','Thanks for purchasing course {{title}} amount {{price}} purchase date {{purchase_date}} class {{class}} section {{section}} and assign for {{assign_teacher}}  discount {{discount}}%','{{title}} {{class}} {{section}} {{price}} {{discount}}  \r\n{{purchase_date}}','2022-11-19 07:09:29'),(21,'online_course_purchase_for_guest_user','1','1',0,0,1,1,NULL,NULL,1,NULL,NULL,'Online Course Purchase For Guest','','Thanks for purchasing course {{title}} discount {{discount}} amount {{price}} purchase date {{purchase_date}}','{{title}} {{price}} {{discount}} {{purchase_date}}','2022-07-15 02:53:52'),(22,'online_course_guest_user_sign_up','1','0',0,0,0,1,NULL,NULL,1,NULL,NULL,'Online Course Guest User Sign Up','','Dear {{guest_user_name}} you have successfully sign up with Email: {{email}} Url {{url}}','{{guest_user_name}} {{email}} {{url}}','2022-07-15 02:56:31');

--
-- Table structure for table `offline_fees_payments`
--

CREATE TABLE `offline_fees_payments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `invoice_id` varchar(50) DEFAULT NULL,
  `student_session_id` int DEFAULT NULL,
  `student_fees_master_id` int DEFAULT NULL,
  `fee_groups_feetype_id` int DEFAULT NULL,
  `student_transport_fee_id` int DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `bank_from` varchar(200) DEFAULT NULL,
  `bank_account_transferred` varchar(200) DEFAULT NULL,
  `reference` varchar(200) DEFAULT NULL,
  `amount` float(10,2) DEFAULT NULL,
  `submit_date` datetime DEFAULT NULL,
  `approve_date` datetime DEFAULT NULL,
  `attachment` text,
  `reply` text,
  `approved_by` int DEFAULT NULL,
  `is_active` varchar(1) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `student_fees_master_id` (`student_fees_master_id`),
  KEY `fee_groups_feetype_id` (`fee_groups_feetype_id`),
  KEY `student_transport_fee_id` (`student_transport_fee_id`),
  KEY `offline_fees_payments_ibfk_4` (`approved_by`),
  KEY `student_session_id` (`student_session_id`),
  CONSTRAINT `offline_fees_payments_ibfk_1` FOREIGN KEY (`student_fees_master_id`) REFERENCES `student_fees_master` (`id`) ON DELETE CASCADE,
  CONSTRAINT `offline_fees_payments_ibfk_2` FOREIGN KEY (`fee_groups_feetype_id`) REFERENCES `fee_groups_feetype` (`id`) ON DELETE CASCADE,
  CONSTRAINT `offline_fees_payments_ibfk_3` FOREIGN KEY (`student_transport_fee_id`) REFERENCES `student_transport_fees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `offline_fees_payments_ibfk_4` FOREIGN KEY (`approved_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `offline_fees_payments_ibfk_5` FOREIGN KEY (`student_session_id`) REFERENCES `student_session` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `offline_fees_payments`
--


--
-- Table structure for table `online_admission_custom_field_value`
--

CREATE TABLE `online_admission_custom_field_value` (
  `id` int NOT NULL AUTO_INCREMENT,
  `belong_table_id` int DEFAULT NULL,
  `custom_field_id` int DEFAULT NULL,
  `field_value` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_field_id` (`custom_field_id`),
  KEY `idx_belong_table_id` (`belong_table_id`),
  KEY `idx_field_value` (`field_value`(200)),
  CONSTRAINT `online_admission_custom_field_value_ibfk_1` FOREIGN KEY (`custom_field_id`) REFERENCES `custom_fields` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_admission_custom_field_value`
--


--
-- Table structure for table `online_admission_fields`
--

CREATE TABLE `online_admission_fields` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_admission_fields`
--

INSERT INTO `online_admission_fields` VALUES (1,'middlename',0,'2021-05-28 10:29:23'),(2,'lastname',1,'2021-06-02 04:49:19'),(3,'category',0,'2021-06-02 04:48:35'),(4,'religion',0,'2021-06-02 04:48:35'),(5,'cast',0,'2021-06-02 04:48:35'),(6,'mobile_no',1,'2021-06-02 04:50:24'),(7,'admission_date',0,'2021-06-02 04:48:35'),(8,'student_photo',0,'2021-06-02 04:48:35'),(9,'is_student_house',0,'2021-05-29 13:22:53'),(10,'is_blood_group',0,'2021-06-02 04:48:35'),(11,'student_height',0,'2021-06-02 04:48:35'),(12,'student_weight',0,'2021-06-02 04:48:35'),(13,'father_name',0,'2021-06-02 04:48:35'),(14,'father_phone',0,'2021-06-02 04:48:35'),(15,'father_occupation',0,'2021-06-02 04:48:35'),(16,'father_pic',0,'2021-06-02 04:48:35'),(17,'mother_name',0,'2021-06-02 04:48:35'),(18,'mother_phone',0,'2021-06-02 04:48:35'),(19,'mother_occupation',0,'2021-06-02 04:48:35'),(20,'mother_pic',0,'2021-06-02 04:48:35'),(21,'guardian_name',0,'2024-05-07 13:21:09'),(22,'guardian_phone',0,'2024-05-07 13:21:16'),(23,'if_guardian_is',0,'2024-05-07 13:21:09'),(24,'guardian_relation',0,'2024-05-07 13:21:16'),(25,'guardian_email',0,'2024-05-07 13:21:20'),(26,'guardian_occupation',0,'2024-05-07 13:21:23'),(27,'guardian_address',0,'2024-05-07 13:21:29'),(28,'bank_account_no',0,'2021-06-02 04:48:35'),(29,'bank_name',0,'2021-06-02 04:48:35'),(30,'ifsc_code',0,'2021-06-02 04:48:35'),(31,'national_identification_no',0,'2021-06-02 04:48:35'),(32,'local_identification_no',0,'2021-06-02 04:48:35'),(33,'rte',0,'2021-06-02 04:48:35'),(34,'previous_school_details',0,'2021-06-02 04:48:35'),(35,'guardian_photo',1,'2021-06-02 04:51:29'),(36,'student_note',0,'2021-06-02 04:55:08'),(37,'measurement_date',0,'2021-06-02 04:48:35'),(38,'student_email',1,'2021-06-02 04:49:38'),(39,'current_address',0,'2021-06-02 04:48:35'),(40,'permanent_address',0,'2021-06-02 04:48:35'),(41,'upload_documents',1,'2022-09-20 08:00:32');

--
-- Table structure for table `online_admission_payment`
--

CREATE TABLE `online_admission_payment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `online_admission_id` int NOT NULL,
  `paid_amount` float(10,2) NOT NULL,
  `payment_mode` varchar(50) NOT NULL,
  `payment_type` varchar(100) NOT NULL,
  `transaction_id` varchar(100) NOT NULL,
  `note` varchar(100) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `online_admission_id` (`online_admission_id`),
  CONSTRAINT `online_admission_payment_ibfk_1` FOREIGN KEY (`online_admission_id`) REFERENCES `online_admissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_admission_payment`
--


--
-- Table structure for table `online_admissions`
--

CREATE TABLE `online_admissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `admission_no` varchar(100) DEFAULT NULL,
  `roll_no` varchar(100) DEFAULT NULL,
  `reference_no` varchar(50) NOT NULL,
  `admission_date` date DEFAULT NULL,
  `firstname` varchar(100) DEFAULT NULL,
  `middlename` varchar(255) NOT NULL,
  `lastname` varchar(100) DEFAULT NULL,
  `rte` varchar(20) NOT NULL DEFAULT 'No',
  `image` varchar(255) DEFAULT NULL,
  `mobileno` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `pincode` varchar(100) DEFAULT NULL,
  `religion` varchar(100) DEFAULT NULL,
  `cast` varchar(50) NOT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `current_address` text,
  `permanent_address` text,
  `category_id` int DEFAULT NULL,
  `class_section_id` int DEFAULT NULL,
  `route_id` int NOT NULL,
  `school_house_id` int DEFAULT NULL,
  `blood_group` varchar(200) NOT NULL,
  `vehroute_id` int NOT NULL,
  `hostel_room_id` int DEFAULT NULL,
  `adhar_no` varchar(100) DEFAULT NULL,
  `samagra_id` varchar(100) DEFAULT NULL,
  `bank_account_no` varchar(100) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `ifsc_code` varchar(100) DEFAULT NULL,
  `guardian_is` varchar(100) NOT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `father_phone` varchar(100) DEFAULT NULL,
  `father_occupation` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `mother_phone` varchar(100) DEFAULT NULL,
  `mother_occupation` varchar(100) DEFAULT NULL,
  `guardian_name` varchar(100) DEFAULT NULL,
  `guardian_relation` varchar(100) DEFAULT NULL,
  `guardian_phone` varchar(100) DEFAULT NULL,
  `guardian_occupation` varchar(150) NOT NULL,
  `guardian_address` text,
  `guardian_email` varchar(100) NOT NULL,
  `father_pic` varchar(255) NOT NULL,
  `mother_pic` varchar(255) NOT NULL,
  `guardian_pic` varchar(255) NOT NULL,
  `is_enroll` int DEFAULT '0',
  `previous_school` text,
  `height` varchar(100) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `note` text NOT NULL,
  `form_status` int NOT NULL,
  `paid_status` int NOT NULL,
  `measurement_date` date DEFAULT NULL,
  `app_key` text,
  `document` text,
  `submit_date` date DEFAULT NULL,
  `disable_at` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `class_section_id` (`class_section_id`),
  KEY `category_id` (`category_id`),
  KEY `hostel_room_id` (`hostel_room_id`),
  KEY `school_house_id` (`school_house_id`),
  KEY `idx_reference_no` (`reference_no`),
  KEY `idx_mobileno` (`mobileno`),
  CONSTRAINT `online_admissions_ibfk_1` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `online_admissions_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `online_admissions_ibfk_3` FOREIGN KEY (`hostel_room_id`) REFERENCES `hostel_rooms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `online_admissions_ibfk_4` FOREIGN KEY (`school_house_id`) REFERENCES `school_houses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_admissions`
--


--
-- Table structure for table `online_course_class_sections`
--

CREATE TABLE `online_course_class_sections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_id` int DEFAULT NULL,
  `class_section_id` int DEFAULT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `class_section_id` (`class_section_id`),
  CONSTRAINT `online_course_class_sections_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `online_courses` (`id`),
  CONSTRAINT `online_course_class_sections_ibfk_2` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_class_sections`
--


--
-- Table structure for table `online_course_lesson`
--

CREATE TABLE `online_course_lesson` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_section_id` int DEFAULT NULL,
  `lesson_title` varchar(255) DEFAULT NULL,
  `lesson_type` varchar(20) DEFAULT NULL,
  `thumbnail` varchar(100) DEFAULT NULL,
  `summary` text,
  `attachment` varchar(200) DEFAULT NULL,
  `video_provider` varchar(20) DEFAULT NULL,
  `video_url` text,
  `video_id` varchar(50) DEFAULT NULL,
  `duration` time DEFAULT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `course_section_id` (`course_section_id`) USING BTREE,
  CONSTRAINT `online_course_lesson_ibfk_1` FOREIGN KEY (`course_section_id`) REFERENCES `online_course_section` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_lesson`
--


--
-- Table structure for table `online_course_payment`
--

CREATE TABLE `online_course_payment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int DEFAULT NULL,
  `guest_id` int DEFAULT NULL,
  `online_courses_id` int DEFAULT NULL,
  `course_name` varchar(255) DEFAULT NULL,
  `actual_price` float(10,2) NOT NULL DEFAULT '0.00',
  `paid_amount` float(10,2) NOT NULL DEFAULT '0.00',
  `payment_mode` varchar(50) DEFAULT NULL,
  `payment_type` varchar(100) DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `note` text,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_online_courses_id` (`online_courses_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_payment`
--


--
-- Table structure for table `online_course_processing_payment`
--

CREATE TABLE `online_course_processing_payment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int DEFAULT NULL,
  `guest_id` int DEFAULT NULL,
  `online_courses_id` int DEFAULT NULL,
  `course_name` varchar(255) DEFAULT NULL,
  `actual_price` float(10,2) NOT NULL DEFAULT '0.00',
  `paid_amount` float(10,2) NOT NULL DEFAULT '0.00',
  `payment_mode` varchar(50) DEFAULT NULL,
  `payment_type` varchar(100) DEFAULT NULL,
  `transaction_id` varchar(100) DEFAULT NULL,
  `note` text,
  `date` datetime DEFAULT NULL,
  `gateway_ins_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_id` (`student_id`),
  KEY `online_courses_id` (`online_courses_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_processing_payment`
--


--
-- Table structure for table `online_course_quiz`
--

CREATE TABLE `online_course_quiz` (
  `id` int NOT NULL AUTO_INCREMENT,
  `course_section_id` int DEFAULT NULL,
  `quiz_title` varchar(255) DEFAULT NULL,
  `quiz_instruction` text,
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `course_section_id` (`course_section_id`) USING BTREE,
  CONSTRAINT `online_course_quiz_ibfk_1` FOREIGN KEY (`course_section_id`) REFERENCES `online_course_section` (`id`),
  CONSTRAINT `online_course_quiz_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_quiz`
--


--
-- Table structure for table `online_course_section`
--

CREATE TABLE `online_course_section` (
  `id` int NOT NULL AUTO_INCREMENT,
  `online_course_id` int DEFAULT NULL,
  `section_title` varchar(255) DEFAULT NULL,
  `order` int DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `online_course_id` (`online_course_id`),
  CONSTRAINT `online_course_section_ibfk_1` FOREIGN KEY (`online_course_id`) REFERENCES `online_courses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_section`
--


--
-- Table structure for table `online_course_settings`
--

CREATE TABLE `online_course_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `guest_prefix` varchar(50) NOT NULL,
  `guest_id_start_from` int NOT NULL,
  `guest_login` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_course_settings`
--


--
-- Table structure for table `online_courses`
--

CREATE TABLE `online_courses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(200) NOT NULL,
  `url` varchar(200) NOT NULL,
  `description` text,
  `teacher_id` int DEFAULT NULL,
  `category_id` int NOT NULL,
  `outcomes` text,
  `course_thumbnail` varchar(100) DEFAULT NULL,
  `course_provider` varchar(100) DEFAULT NULL,
  `course_url` varchar(255) DEFAULT NULL,
  `video_id` text,
  `price` float(10,2) NOT NULL DEFAULT '0.00',
  `discount` float(10,2) NOT NULL DEFAULT '0.00',
  `free_course` tinyint(1) DEFAULT NULL COMMENT '0=paid,1=free',
  `view_count` int DEFAULT NULL,
  `front_side_visibility` varchar(10) NOT NULL DEFAULT 'yes',
  `status` tinyint(1) DEFAULT '0',
  `created_by` int DEFAULT NULL,
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`),
  KEY `created_by` (`created_by`),
  KEY `idx_category_id` (`category_id`),
  CONSTRAINT `online_courses_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `online_courses`
--


--
-- Table structure for table `onlineexam`
--

CREATE TABLE `onlineexam` (
  `id` int NOT NULL AUTO_INCREMENT,
  `session_id` int DEFAULT NULL,
  `exam` text,
  `attempt` int NOT NULL,
  `exam_from` datetime DEFAULT NULL,
  `exam_to` datetime DEFAULT NULL,
  `is_quiz` int NOT NULL DEFAULT '0',
  `auto_publish_date` datetime DEFAULT NULL,
  `time_from` time DEFAULT NULL,
  `time_to` time DEFAULT NULL,
  `duration` time NOT NULL,
  `passing_percentage` float NOT NULL DEFAULT '0',
  `description` text,
  `publish_result` int NOT NULL DEFAULT '0',
  `answer_word_count` int NOT NULL DEFAULT '-1',
  `is_active` varchar(1) DEFAULT '0',
  `is_marks_display` int NOT NULL DEFAULT '0',
  `is_neg_marking` int NOT NULL DEFAULT '0',
  `is_random_question` int NOT NULL DEFAULT '0',
  `is_rank_generated` int NOT NULL DEFAULT '0',
  `publish_exam_notification` int NOT NULL,
  `publish_result_notification` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `session_id` (`session_id`),
  CONSTRAINT `onlineexam_ibfk_1` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `onlineexam`
--


--
-- Table structure for table `onlineexam_attempts`
--

CREATE TABLE `onlineexam_attempts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `onlineexam_student_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `onlineexam_student_id` (`onlineexam_student_id`),
  CONSTRAINT `onlineexam_attempts_ibfk_1` FOREIGN KEY (`onlineexam_student_id`) REFERENCES `onlineexam_students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `onlineexam_attempts`
--


--
-- Table structure for table `onlineexam_questions`
--

CREATE TABLE `onlineexam_questions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `question_id` int DEFAULT NULL,
  `onlineexam_id` int DEFAULT NULL,
  `session_id` int DEFAULT NULL,
  `marks` float(10,2) NOT NULL DEFAULT '0.00',
  `neg_marks` float(10,2) DEFAULT '0.00',
  `is_active` varchar(1) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `onlineexam_id` (`onlineexam_id`),
  KEY `question_id` (`question_id`),
  KEY `session_id` (`session_id`),
  CONSTRAINT `onlineexam_questions_ibfk_1` FOREIGN KEY (`onlineexam_id`) REFERENCES `onlineexam` (`id`) ON DELETE CASCADE,
  CONSTRAINT `onlineexam_questions_ibfk_2` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `onlineexam_questions_ibfk_3` FOREIGN KEY (`session_id`) REFERENCES `sessions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `onlineexam_questions`
--


--
-- Table structure for table `onlineexam_student_results`
--

CREATE TABLE `onlineexam_student_results` (
  `id` int NOT NULL AUTO_INCREMENT,
  `onlineexam_student_id` int NOT NULL,
  `onlineexam_question_id` int NOT NULL,
  `select_option` longtext,
  `marks` float(10,2) NOT NULL DEFAULT '0.00',
  `remark` text,
  `attachment_name` text,
  `attachment_upload_name` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `onlineexam_student_id` (`onlineexam_student_id`),
  KEY `onlineexam_question_id` (`onlineexam_question_id`),
  CONSTRAINT `onlineexam_student_results_ibfk_1` FOREIGN KEY (`onlineexam_student_id`) REFERENCES `onlineexam_students` (`id`) ON DELETE CASCADE,
  CONSTRAINT `onlineexam_student_results_ibfk_2` FOREIGN KEY (`onlineexam_question_id`) REFERENCES `onlineexam_questions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `onlineexam_student_results`
--


--
-- Table structure for table `onlineexam_students`
--

CREATE TABLE `onlineexam_students` (
  `id` int NOT NULL AUTO_INCREMENT,
  `onlineexam_id` int DEFAULT NULL,
  `student_session_id` int DEFAULT NULL,
  `is_attempted` int NOT NULL DEFAULT '0',
  `rank` int DEFAULT '0',
  `quiz_attempted` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `onlineexam_id` (`onlineexam_id`),
  KEY `student_session_id` (`student_session_id`),
  CONSTRAINT `onlineexam_students_ibfk_1` FOREIGN KEY (`onlineexam_id`) REFERENCES `onlineexam` (`id`) ON DELETE CASCADE,
  CONSTRAINT `onlineexam_students_ibfk_2` FOREIGN KEY (`student_session_id`) REFERENCES `student_session` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `onlineexam_students`
--


--
-- Table structure for table `payment_settings`
--

CREATE TABLE `payment_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payment_type` varchar(200) NOT NULL,
  `api_username` varchar(200) DEFAULT NULL,
  `api_secret_key` varchar(200) NOT NULL,
  `salt` varchar(200) NOT NULL,
  `api_publishable_key` varchar(200) NOT NULL,
  `api_password` varchar(200) DEFAULT NULL,
  `api_signature` varchar(200) DEFAULT NULL,
  `api_email` varchar(200) DEFAULT NULL,
  `paypal_demo` varchar(100) NOT NULL,
  `account_no` varchar(200) NOT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `gateway_mode` int NOT NULL COMMENT '0 Testing, 1 live',
  `paytm_website` varchar(255) NOT NULL,
  `paytm_industrytype` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `payment_settings`
--


--
-- Table structure for table `payslip_allowance`
--

CREATE TABLE `payslip_allowance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `payslip_id` int NOT NULL,
  `allowance_type` varchar(200) NOT NULL,
  `amount` float NOT NULL,
  `staff_id` int NOT NULL,
  `cal_type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`),
  KEY `payslip_id` (`payslip_id`),
  CONSTRAINT `payslip_allowance_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `payslip_allowance_ibfk_2` FOREIGN KEY (`payslip_id`) REFERENCES `staff_payslip` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `payslip_allowance`
--


--
-- Table structure for table `permission_category`
--

CREATE TABLE `permission_category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `perm_group_id` int DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) DEFAULT NULL,
  `enable_view` int DEFAULT '0',
  `enable_add` int DEFAULT '0',
  `enable_edit` int DEFAULT '0',
  `enable_delete` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_short_code` (`short_code`),
  KEY `perm_group_id` (`perm_group_id`),
  CONSTRAINT `permission_category_ibfk_1` FOREIGN KEY (`perm_group_id`) REFERENCES `permission_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10008 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `permission_category`
--

INSERT INTO `permission_category` VALUES (1,1,'Student','student',1,1,1,1,'2019-10-24 05:42:03'),(2,1,'Import Student','import_student',1,0,0,0,'2018-06-22 10:17:19'),(3,1,'Student Categories','student_categories',1,1,1,1,'2018-06-22 10:17:36'),(4,1,'Student Houses','student_houses',1,1,1,1,'2018-06-22 10:17:53'),(5,2,'Collect Fees','collect_fees',1,1,0,1,'2018-06-22 10:21:03'),(6,2,'Fees Carry Forward','fees_carry_forward',1,0,0,0,'2018-06-27 00:18:15'),(7,2,'Fees Master','fees_master',1,1,1,1,'2018-06-27 00:18:57'),(8,2,'Fees Group','fees_group',1,1,1,1,'2018-06-22 10:21:46'),(9,3,'Income','income',1,1,1,1,'2018-06-22 10:23:21'),(10,3,'Income Head','income_head',1,1,1,1,'2018-06-22 10:22:44'),(11,3,'Search Income','search_income',1,0,0,0,'2018-06-22 10:23:00'),(12,4,'Expense','expense',1,1,1,1,'2018-06-22 10:24:06'),(13,4,'Expense Head','expense_head',1,1,1,1,'2018-06-22 10:23:47'),(14,4,'Search Expense','search_expense',1,0,0,0,'2018-06-22 10:24:13'),(15,5,'Student / Period Attendance','student_attendance',1,1,1,0,'2019-11-29 01:19:05'),(20,6,'Marks Grade','marks_grade',1,1,1,1,'2018-06-22 10:25:25'),(21,7,'Class Timetable','class_timetable',1,0,1,0,'2019-11-24 03:05:17'),(23,7,'Subject','subject',1,1,1,1,'2018-06-22 10:32:17'),(24,7,'Class','class',1,1,1,1,'2018-06-22 10:32:35'),(25,7,'Section','section',1,1,1,1,'2018-06-22 10:31:10'),(26,7,'Promote Student','promote_student',1,0,0,0,'2018-06-22 10:32:47'),(27,8,'Upload Content','upload_content',1,1,0,1,'2018-06-22 10:33:19'),(28,9,'Books List','books',1,1,1,1,'2019-11-24 00:37:12'),(29,9,'Issue Return','issue_return',1,0,0,0,'2019-11-24 00:37:18'),(30,9,'Add Staff Member','add_staff_member',1,0,0,0,'2018-07-02 11:37:00'),(31,10,'Issue Item','issue_item',1,1,1,1,'2019-11-29 06:39:27'),(32,10,'Add Item Stock','item_stock',1,1,1,1,'2019-11-24 00:39:17'),(33,10,'Add Item','item',1,1,1,1,'2019-11-24 00:39:39'),(34,10,'Item Store','store',1,1,1,1,'2019-11-24 00:40:41'),(35,10,'Item Supplier','supplier',1,1,1,1,'2019-11-24 00:40:49'),(37,11,'Routes','routes',1,1,1,1,'2018-06-22 10:39:17'),(38,11,'Vehicle','vehicle',1,1,1,1,'2018-06-22 10:39:36'),(39,11,'Assign Vehicle','assign_vehicle',1,1,1,1,'2018-06-27 04:39:20'),(40,12,'Hostel','hostel',1,1,1,1,'2018-06-22 10:40:49'),(41,12,'Room Type','room_type',1,1,1,1,'2018-06-22 10:40:27'),(42,12,'Hostel Rooms','hostel_rooms',1,1,1,1,'2018-06-25 06:23:03'),(43,13,'Notice Board','notice_board',1,1,1,1,'2018-06-22 10:41:17'),(44,13,'Email','email',1,0,0,0,'2019-11-26 05:20:37'),(46,13,'Email / SMS Log','email_sms_log',1,0,0,0,'2018-06-22 10:41:23'),(53,15,'Languages','languages',0,1,0,1,'2021-01-23 07:09:32'),(54,15,'General Setting','general_setting',1,0,1,0,'2018-07-05 09:08:35'),(55,15,'Session Setting','session_setting',1,1,1,1,'2018-06-22 10:44:15'),(56,15,'Notification Setting','notification_setting',1,0,1,0,'2018-07-05 09:08:41'),(57,15,'SMS Setting','sms_setting',1,0,1,0,'2018-07-05 09:08:47'),(58,15,'Email Setting','email_setting',1,0,1,0,'2018-07-05 09:08:51'),(59,15,'Front CMS Setting','front_cms_setting',1,0,1,0,'2018-07-05 09:08:55'),(60,15,'Payment Methods','payment_methods',1,0,1,0,'2018-07-05 09:08:59'),(61,16,'Menus','menus',1,1,0,1,'2018-07-09 03:50:06'),(62,16,'Media Manager','media_manager',1,1,0,1,'2018-07-09 03:50:26'),(63,16,'Banner Images','banner_images',1,1,0,1,'2018-06-22 10:46:02'),(64,16,'Pages','pages',1,1,1,1,'2018-06-22 10:46:21'),(65,16,'Gallery','gallery',1,1,1,1,'2018-06-22 10:47:02'),(66,16,'Event','event',1,1,1,1,'2018-06-22 10:47:20'),(67,16,'News','notice',1,1,1,1,'2018-07-03 08:39:34'),(68,2,'Fees Group Assign','fees_group_assign',1,0,0,0,'2018-06-22 10:20:42'),(69,2,'Fees Type','fees_type',1,1,1,1,'2018-06-22 10:19:34'),(70,2,'Fees Discount','fees_discount',1,1,1,1,'2018-06-22 10:20:10'),(71,2,'Fees Discount Assign','fees_discount_assign',1,0,0,0,'2018-06-22 10:20:17'),(73,2,'Search Fees Payment','search_fees_payment',1,0,0,0,'2018-06-22 10:20:27'),(74,2,'Search Due Fees','search_due_fees',1,0,0,0,'2018-06-22 10:20:35'),(77,7,'Assign Class Teacher','assign_class_teacher',1,1,1,1,'2018-06-22 10:30:52'),(78,17,'Admission Enquiry','admission_enquiry',1,1,1,1,'2018-06-22 10:51:24'),(79,17,'Follow Up Admission Enquiry','follow_up_admission_enquiry',1,1,0,1,'2018-06-22 10:51:39'),(80,17,'Visitor Book','visitor_book',1,1,1,1,'2018-06-22 10:48:58'),(81,17,'Phone Call Log','phone_call_log',1,1,1,1,'2018-06-22 10:50:57'),(82,17,'Postal Dispatch','postal_dispatch',1,1,1,1,'2018-06-22 10:50:21'),(83,17,'Postal Receive','postal_receive',1,1,1,1,'2018-06-22 10:50:04'),(84,17,'Complain','complaint',1,1,1,1,'2018-07-03 08:40:55'),(85,17,'Setup Font Office','setup_font_office',1,1,1,1,'2018-06-22 10:49:24'),(86,18,'Staff','staff',1,1,1,1,'2018-06-22 10:53:31'),(87,18,'Disable Staff','disable_staff',1,0,0,0,'2018-06-22 10:53:12'),(88,18,'Staff Attendance','staff_attendance',1,1,1,0,'2018-06-22 10:53:10'),(90,18,'Staff Payroll','staff_payroll',1,1,0,1,'2018-06-22 10:52:51'),(93,19,'Homework','homework',1,1,1,1,'2018-06-22 10:53:50'),(94,19,'Homework Evaluation','homework_evaluation',1,1,0,0,'2018-06-27 03:07:21'),(96,20,'Student Certificate','student_certificate',1,1,1,1,'2018-07-06 10:41:07'),(97,20,'Generate Certificate','generate_certificate',1,0,0,0,'2018-07-06 10:37:16'),(98,20,'Student ID Card','student_id_card',1,1,1,1,'2018-07-06 10:41:28'),(99,20,'Generate ID Card','generate_id_card',1,0,0,0,'2018-07-06 10:41:49'),(102,21,'Calendar To Do List','calendar_to_do_list',1,1,1,1,'2018-06-22 10:54:41'),(104,10,'Item Category','item_category',1,1,1,1,'2018-06-22 10:34:33'),(106,22,'Quick Session Change','quick_session_change',1,0,0,0,'2018-06-22 10:54:45'),(107,1,'Disable Student','disable_student',1,0,0,0,'2018-06-25 06:21:34'),(108,18,' Approve Leave Request','approve_leave_request',1,0,1,1,'2020-10-05 08:56:27'),(109,18,'Apply Leave','apply_leave',1,1,0,0,'2019-11-28 23:47:46'),(110,18,'Leave Types ','leave_types',1,1,1,1,'2018-07-02 10:17:56'),(111,18,'Department','department',1,1,1,1,'2018-06-26 03:57:07'),(112,18,'Designation','designation',1,1,1,1,'2018-06-26 03:57:07'),(113,22,'Fees Collection And Expense Monthly Chart','fees_collection_and_expense_monthly_chart',1,0,0,0,'2018-07-03 07:08:15'),(114,22,'Fees Collection And Expense Yearly Chart','fees_collection_and_expense_yearly_chart',1,0,0,0,'2018-07-03 07:08:15'),(115,22,'Monthly Fees Collection Widget','Monthly fees_collection_widget',1,0,0,0,'2018-07-03 07:13:35'),(116,22,'Monthly Expense Widget','monthly_expense_widget',1,0,0,0,'2018-07-03 07:13:35'),(117,22,'Student Count Widget','student_count_widget',1,0,0,0,'2018-07-03 07:13:35'),(118,22,'Staff Role Count Widget','staff_role_count_widget',1,0,0,0,'2018-07-03 07:13:35'),(122,5,'Attendance By Date','attendance_by_date',1,0,0,0,'2018-07-03 08:42:29'),(123,9,'Add Student','add_student',1,0,0,0,'2018-07-03 08:42:29'),(126,15,'User Status','user_status',1,0,0,0,'2018-07-03 08:42:29'),(127,18,'Can See Other Users Profile','can_see_other_users_profile',1,0,0,0,'2018-07-03 08:42:29'),(128,1,'Student Timeline','student_timeline',1,1,1,1,'2022-12-28 09:52:24'),(129,18,'Staff Timeline','staff_timeline',1,1,1,1,'2022-12-28 09:52:24'),(130,15,'Backup','backup',1,1,0,1,'2018-07-09 04:17:17'),(131,15,'Restore','restore',1,0,0,0,'2018-07-09 04:17:17'),(134,1,'Disable Reason','disable_reason',1,1,1,1,'2019-11-27 06:39:21'),(135,2,'Fees Reminder','fees_reminder',1,0,1,0,'2019-10-25 00:39:49'),(136,5,'Approve Leave','approve_leave',1,1,1,1,'2022-12-28 09:52:24'),(137,6,'Exam Group','exam_group',1,1,1,1,'2019-10-25 01:02:34'),(141,6,'Design Admit Card','design_admit_card',1,1,1,1,'2019-10-25 01:06:59'),(142,6,'Print Admit Card','print_admit_card',1,0,0,0,'2019-11-23 23:57:51'),(143,6,'Design Marksheet','design_marksheet',1,1,1,1,'2019-10-25 01:10:25'),(144,6,'Print Marksheet','print_marksheet',1,0,0,0,'2019-10-25 01:11:02'),(145,7,'Teachers Timetable','teachers_time_table',1,0,0,0,'2019-11-30 02:52:21'),(146,14,'Student Report','student_report',1,0,0,0,'2019-10-25 01:27:00'),(147,14,'Guardian Report','guardian_report',1,0,0,0,'2019-10-25 01:30:27'),(148,14,'Student History','student_history',1,0,0,0,'2019-10-25 01:39:07'),(149,14,'Student Login Credential Report','student_login_credential_report',1,0,0,0,'2019-10-25 01:39:07'),(150,14,'Class Subject Report','class_subject_report',1,0,0,0,'2019-10-25 01:39:07'),(151,14,'Admission Report','admission_report',1,0,0,0,'2019-10-25 01:39:07'),(152,14,'Sibling Report','sibling_report',1,0,0,0,'2019-10-25 01:39:07'),(153,14,'Homework Evaluation Report','homehork_evaluation_report',1,0,0,0,'2019-11-24 01:04:24'),(154,14,'Student Profile','student_profile',1,0,0,0,'2019-10-25 01:39:07'),(155,14,'Fees Statement','fees_statement',1,0,0,0,'2019-10-25 01:55:52'),(156,14,'Balance Fees Report','balance_fees_report',1,0,0,0,'2019-10-25 01:55:52'),(157,14,'Fees Collection Report','fees_collection_report',1,0,0,0,'2019-10-25 01:55:52'),(158,14,'Online Fees Collection Report','online_fees_collection_report',1,0,0,0,'2019-10-25 01:55:52'),(159,14,'Income Report','income_report',1,0,0,0,'2019-10-25 01:55:52'),(160,14,'Expense Report','expense_report',1,0,0,0,'2019-10-25 01:55:52'),(161,14,'PayRoll Report','payroll_report',1,0,0,0,'2019-10-31 00:23:22'),(162,14,'Income Group Report','income_group_report',1,0,0,0,'2019-10-25 01:55:52'),(163,14,'Expense Group Report','expense_group_report',1,0,0,0,'2019-10-25 01:55:52'),(164,14,'Attendance Report','attendance_report',1,0,0,0,'2019-10-25 02:08:06'),(165,14,'Staff Attendance Report','staff_attendance_report',1,0,0,0,'2019-10-25 02:08:06'),(174,14,'Transport Report','transport_report',1,0,0,0,'2019-10-25 02:13:56'),(175,14,'Hostel Report','hostel_report',1,0,0,0,'2019-11-27 06:51:53'),(176,14,'Audit Trail Report','audit_trail_report',1,0,0,0,'2019-10-25 02:16:39'),(177,14,'User Log','user_log',1,0,0,0,'2019-10-25 02:19:27'),(178,14,'Book Issue Report','book_issue_report',1,0,0,0,'2019-10-25 02:29:04'),(179,14,'Book Due Report','book_due_report',1,0,0,0,'2019-10-25 02:29:04'),(180,14,'Book Inventory Report','book_inventory_report',1,0,0,0,'2019-10-25 02:29:04'),(181,14,'Stock Report','stock_report',1,0,0,0,'2019-10-25 02:31:28'),(182,14,'Add Item Report','add_item_report',1,0,0,0,'2019-10-25 02:31:28'),(183,14,'Issue Item Report','issue_item_report',1,0,0,0,'2019-11-29 03:48:06'),(185,23,'Online Examination','online_examination',1,1,1,1,'2019-11-23 23:54:50'),(186,23,'Question Bank','question_bank',1,1,1,1,'2019-11-23 23:55:18'),(187,6,'Exam Result','exam_result',1,0,0,0,'2019-11-23 23:58:50'),(188,7,'Subject Group','subject_group',1,1,1,1,'2019-11-24 00:34:32'),(189,18,'Teachers Rating','teachers_rating',1,0,1,1,'2019-11-24 03:12:54'),(190,22,'Fees Awaiting Payment Widegts','fees_awaiting_payment_widegts',1,0,0,0,'2019-11-24 00:52:51'),(191,22,'Conveted Leads Widegts','conveted_leads_widegts',1,0,0,0,'2019-11-24 00:58:24'),(192,22,'Fees Overview Widegts','fees_overview_widegts',1,0,0,0,'2019-11-24 00:57:41'),(193,22,'Enquiry Overview Widegts','enquiry_overview_widegts',1,0,0,0,'2019-12-02 05:06:09'),(194,22,'Library Overview Widegts','book_overview_widegts',1,0,0,0,'2019-12-01 01:13:04'),(195,22,'Student Today Attendance Widegts','today_attendance_widegts',1,0,0,0,'2019-12-03 04:57:45'),(196,6,'Marks Import','marks_import',1,0,0,0,'2019-11-24 01:02:11'),(197,14,'Student Attendance Type Report','student_attendance_type_report',1,0,0,0,'2019-11-24 01:06:32'),(198,14,'Exam Marks Report','exam_marks_report',1,0,0,0,'2019-11-24 01:11:15'),(200,14,'Online Exam Wise Report','online_exam_wise_report',1,0,0,0,'2019-11-24 01:18:14'),(201,14,'Online Exams Report','online_exams_report',1,0,0,0,'2019-11-29 02:48:05'),(202,14,'Online Exams Attempt Report','online_exams_attempt_report',1,0,0,0,'2019-11-29 02:46:24'),(203,14,'Online Exams Rank Report','online_exams_rank_report',1,0,0,0,'2019-11-24 01:22:25'),(204,14,'Staff Report','staff_report',1,0,0,0,'2019-11-24 01:25:27'),(205,6,'Exam','exam',1,1,1,1,'2019-11-24 04:55:48'),(207,6,'Exam Publish','exam_publish',1,0,0,0,'2019-11-24 05:15:04'),(208,6,'Link Exam','link_exam',1,0,1,0,'2019-11-24 05:15:04'),(210,6,'Assign / View student','exam_assign_view_student',1,0,1,0,'2019-11-24 05:15:04'),(211,6,'Exam Subject','exam_subject',1,0,1,0,'2019-11-24 05:15:04'),(212,6,'Exam Marks','exam_marks',1,0,1,0,'2019-11-24 05:15:04'),(213,15,'Language Switcher','language_switcher',1,0,0,0,'2019-11-24 05:17:11'),(214,23,'Add Questions in Exam ','add_questions_in_exam',1,0,1,0,'2019-11-28 01:38:57'),(215,15,'Custom Fields','custom_fields',1,0,0,0,'2019-11-29 04:08:35'),(216,15,'System Fields','system_fields',1,0,0,0,'2019-11-25 00:15:01'),(217,13,'SMS','sms',1,0,0,0,'2018-06-22 10:40:54'),(219,14,'Student / Period Attendance Report','student_period_attendance_report',1,0,0,0,'2019-11-29 02:19:31'),(220,14,'Biometric Attendance Log','biometric_attendance_log',1,0,0,0,'2019-11-27 05:59:16'),(221,14,'Book Issue Return Report','book_issue_return_report',1,0,0,0,'2019-11-27 06:30:23'),(222,23,'Assign / View Student','online_assign_view_student',1,0,1,0,'2019-11-28 04:20:22'),(223,14,'Rank Report','rank_report',1,0,0,0,'2019-11-29 02:30:21'),(224,25,'Chat','chat',1,0,0,0,'2019-11-29 04:10:28'),(226,22,'Income Donut Graph','income_donut_graph',1,0,0,0,'2019-11-29 05:00:33'),(227,22,'Expense Donut Graph','expense_donut_graph',1,0,0,0,'2019-11-29 05:01:10'),(228,9,'Import Book','import_book',1,0,0,0,'2019-11-29 06:21:01'),(229,22,'Staff Present Today Widegts','staff_present_today_widegts',1,0,0,0,'2019-11-29 06:48:00'),(230,22,'Student Present Today Widegts','student_present_today_widegts',1,0,0,0,'2019-11-29 06:47:42'),(231,26,'Multi Class Student','multi_class_student',1,1,1,1,'2020-10-05 08:56:27'),(232,27,'Online Admission','online_admission',1,0,1,1,'2019-12-02 06:11:10'),(233,15,'Print Header Footer','print_header_footer',1,0,0,0,'2020-02-12 02:02:02'),(234,28,'Manage Alumni','manage_alumni',1,1,1,1,'2020-06-02 03:15:46'),(235,28,'Events','events',1,1,1,1,'2020-05-28 21:48:52'),(236,29,'Manage Lesson Plan','manage_lesson_plan',1,1,1,0,'2020-05-28 22:17:37'),(237,29,'Manage Syllabus Status','manage_syllabus_status',1,0,1,0,'2020-05-28 22:20:11'),(238,29,'Lesson','lesson',1,1,1,1,'2020-05-28 22:20:11'),(239,29,'Topic','topic',1,1,1,1,'2020-05-28 22:20:11'),(240,14,'Syllabus Status Report','syllabus_status_report',1,0,0,0,'2020-05-28 23:17:54'),(241,14,'Teacher Syllabus Status Report','teacher_syllabus_status_report',1,0,0,0,'2020-05-28 23:17:54'),(242,14,'Alumni Report','alumni_report',1,0,0,0,'2020-06-07 23:59:54'),(243,15,'Student Profile Update','student_profile_update',1,0,0,0,'2020-08-21 05:36:33'),(244,14,'Student Gender Ratio Report','student_gender_ratio_report',1,0,0,0,'2020-08-22 12:37:51'),(245,14,'Student Teacher Ratio Report','student_teacher_ratio_report',1,0,0,0,'2020-08-22 12:42:27'),(246,14,'Daily Attendance Report','daily_attendance_report',1,0,0,0,'2020-08-22 12:43:16'),(247,23,'Import Question','import_question',1,0,0,0,'2019-11-23 18:25:18'),(248,20,'Staff ID Card','staff_id_card',1,1,1,1,'2018-07-06 10:41:28'),(249,20,'Generate Staff ID Card','generate_staff_id_card',1,0,0,0,'2018-07-06 10:41:49'),(250,19,'Daily Assignment','daily_assignment',1,0,0,0,'2022-03-02 07:28:23'),(251,6,'Marks Division','marks_division',1,1,1,1,'2022-07-01 15:24:16'),(252,13,'Schedule Email SMS Log','schedule_email_sms_log',1,0,1,0,'2022-07-09 11:25:16'),(253,13,'Login Credentials Send','login_credentials_send',1,0,0,0,'2022-07-01 15:46:10'),(254,13,'Email Template','email_template',1,1,1,1,'2022-07-01 15:46:10'),(255,13,'SMS Template','sms_template',1,1,1,1,'2022-07-01 15:46:10'),(256,14,'Balance Fees Report With Remark','balance_fees_report_with_remark',1,0,0,0,'2019-10-25 01:55:52'),(257,14,'Balance Fees Statement','balance_fees_statement',1,0,0,0,'2019-10-25 01:55:52'),(258,14,'Daily Collection Report','daily_collection_report',1,0,0,0,'2019-10-25 01:55:52'),(259,11,'Fees Master','transport_fees_master',1,0,1,0,'2022-07-05 09:29:19'),(260,11,'Pickup Point','pickup_point',1,1,1,1,'2022-07-04 09:50:08'),(261,11,'Route Pickup Point','route_pickup_point',1,1,1,1,'2022-07-04 09:50:08'),(262,11,'Student Transport Fees','student_transport_fees',1,1,1,0,'2022-07-05 10:15:55'),(263,29,'Comments','lesson_plan_comments',1,1,0,1,'2020-05-28 22:20:11'),(264,15,'Sidebar Menu','sidebar_menu',1,0,0,0,'2022-07-11 12:01:17'),(265,15,'Currency','currency',1,0,0,0,'2020-08-21 05:36:33'),(266,6,'Exam Schedule','exam_schedule',1,0,0,0,'2019-11-23 23:58:50'),(267,6,'Generate Rank','generate_rank',1,0,0,0,'2019-11-24 05:15:04'),(268,8,'Content Type','content_type',1,1,1,1,'2022-07-08 05:18:54'),(269,8,'Content Share List','content_share_list',1,0,0,1,'2022-07-08 05:18:58'),(270,8,'Video Tutorial','video_tutorial',1,1,1,1,'2022-07-08 05:19:01'),(271,15,'Currency Switcher','currency_switcher',1,0,0,0,'2019-11-24 05:17:11'),(272,2,'Offline Bank Payments','offline_bank_payments',1,0,0,0,'2018-06-27 00:18:15'),(273,29,'Copy Old Lessons','copy_old_lesson',1,0,0,0,'2020-05-28 22:20:11'),(7001,700,'Online Course','online_course',1,1,1,1,'2019-11-23 15:25:18'),(7002,700,'Course Publish','course_publish',1,0,0,0,'2019-11-23 15:25:18'),(7003,700,'Course Section','online_course_section',1,1,1,1,'2021-05-17 02:26:33'),(7004,700,'Course Lesson','online_course_lesson',1,1,1,1,'2021-05-17 02:26:24'),(7005,700,'Course Quiz','online_course_quiz',1,1,1,1,'2021-05-17 02:26:20'),(7006,700,'Offline Payment','online_course_offline_payment',1,1,0,0,'2021-05-17 02:26:17'),(7007,700,'Student Course Purchase Report','student_course_purchase_report',1,0,0,0,'2021-05-17 02:25:56'),(7008,700,'Course Sell Count Report','course_sell_count_report',1,0,0,0,'2021-05-17 02:25:52'),(7009,700,'Course Trending Report','course_trending_report',1,0,0,0,'2021-05-17 02:25:49'),(7010,700,'Course Complete Report','course_complete_report',1,0,0,0,'2021-05-17 02:25:42'),(7011,700,'Setting','online_course_setting',1,0,0,0,'2021-05-17 02:25:37'),(7012,700,'Course Rating Report','course_rating_report',1,0,0,1,'2022-06-14 08:24:57'),(7013,700,'Guest Report','guest_report',1,0,1,1,'2022-06-14 08:33:09'),(7014,700,'Course Category','course_category',1,1,1,1,'2019-11-23 15:25:18'),(10001,1000,'Overview','multi_branch_overview',1,0,0,0,'2022-11-15 02:07:36'),(10002,1000,'Daily Collection Report','multi_branch_daily_collection_report',1,0,0,0,'2022-11-15 01:57:02'),(10003,1000,'Payroll Report','multi_branch_payroll',1,0,0,0,'2022-11-16 08:19:48'),(10004,1000,'Income Report','multi_branch_income_report',1,0,0,0,'2022-11-15 02:07:36'),(10005,1000,'Expense Report','multi_branch_expense_report',1,0,0,0,'2022-11-15 02:02:27'),(10006,1000,'User Log Report','multi_branch_user_log_report',1,0,0,0,'2022-11-15 02:02:27'),(10007,1000,'Setting','multi_branch_setting',1,0,0,0,'2022-11-15 02:07:36');

--
-- Table structure for table `permission_group`
--

CREATE TABLE `permission_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) NOT NULL,
  `is_active` int DEFAULT '0',
  `system` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `permission_group`
--

INSERT INTO `permission_group` VALUES (1,'Student Information','student_information',1,1,'2019-03-15 09:30:22'),(2,'Fees Collection','fees_collection',1,0,'2020-06-11 00:51:35'),(3,'Income','income',1,0,'2020-06-01 01:57:39'),(4,'Expense','expense',1,0,'2019-03-15 09:06:22'),(5,'Student Attendance','student_attendance',1,0,'2018-07-02 07:48:08'),(6,'Examination','examination',1,0,'2018-07-11 02:49:08'),(7,'Academics','academics',1,1,'2018-07-02 07:25:43'),(8,'Download Center','download_center',1,0,'2018-07-02 07:49:29'),(9,'Library','library',0,0,'2024-05-07 15:40:56'),(10,'Inventory','inventory',1,0,'2018-06-27 00:48:58'),(11,'Transport','transport',1,0,'2018-06-27 07:51:26'),(12,'Hostel','hostel',0,0,'2024-05-07 15:40:40'),(13,'Communicate','communicate',1,0,'2018-07-02 07:50:00'),(14,'Reports','reports',1,1,'2018-06-27 03:40:22'),(15,'System Settings','system_settings',1,1,'2018-06-27 03:40:28'),(16,'Front CMS','front_cms',1,0,'2018-07-10 05:16:54'),(17,'Front Office','front_office',1,0,'2018-06-27 03:45:30'),(18,'Human Resource','human_resource',1,1,'2018-06-27 03:41:02'),(19,'Homework','homework',1,0,'2018-06-27 00:49:38'),(20,'Certificate','certificate',1,0,'2018-06-27 07:51:29'),(21,'Calendar To Do List','calendar_to_do_list',1,0,'2019-03-15 09:06:25'),(22,'Dashboard and Widgets','dashboard_and_widgets',1,1,'2018-06-27 03:41:17'),(23,'Online Examination','online_examination',1,0,'2020-06-01 02:25:36'),(25,'Chat','chat',1,0,'2019-11-23 23:54:04'),(26,'Multi Class','multi_class',1,0,'2019-11-27 12:14:14'),(27,'Online Admission','online_admission',1,0,'2019-11-27 02:42:13'),(28,'Alumni','alumni',1,0,'2020-05-29 00:26:38'),(29,'Lesson Plan','lesson_plan',1,0,'2020-06-07 05:38:30'),(700,'Online Course','online_course',1,0,'2024-05-09 12:08:11'),(1000,'Multi Branch','multi_branch',1,0,'2022-11-17 07:53:36');

--
-- Table structure for table `permission_student`
--

CREATE TABLE `permission_student` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `short_code` varchar(100) NOT NULL,
  `system` int NOT NULL,
  `student` int NOT NULL,
  `parent` int NOT NULL,
  `group_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  CONSTRAINT `permission_student_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `permission_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=701 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `permission_student`
--

INSERT INTO `permission_student` VALUES (1,'Fees','fees',0,1,1,2,'2020-06-11 00:51:35'),(2,'Class Timetable','class_timetable',1,1,1,7,'2020-05-30 19:57:50'),(3,'Homework','homework',0,1,1,19,'2020-06-01 02:49:14'),(4,'Download Center','download_center',0,1,1,8,'2020-06-01 02:52:49'),(5,'Attendance','attendance',0,1,1,5,'2020-06-01 02:57:18'),(7,'Examinations','examinations',0,1,1,6,'2020-06-01 02:59:50'),(8,'Notice Board','notice_board',0,1,1,13,'2020-06-01 03:00:35'),(11,'Library','library',0,0,0,9,'2024-05-07 15:40:56'),(12,'Transport Routes','transport_routes',0,1,1,11,'2020-06-01 03:51:30'),(13,'Hostel Rooms','hostel_rooms',0,0,0,12,'2024-05-07 15:40:40'),(14,'Calendar To Do List','calendar_to_do_list',0,1,1,21,'2020-06-01 03:53:18'),(15,'Online Examination','online_examination',0,1,1,23,'2020-06-11 05:20:01'),(16,'Teachers Rating','teachers_rating',0,1,1,NULL,'2022-12-28 09:52:28'),(17,'Chat','chat',0,1,1,25,'2020-06-01 04:53:06'),(18,'Multi Class','multi_class',1,1,1,26,'2020-05-30 19:56:52'),(19,'Lesson Plan','lesson_plan',0,1,1,29,'2020-06-07 05:38:30'),(20,'Syllabus Status','syllabus_status',0,1,1,29,'2020-06-07 05:38:30'),(23,'Apply Leave','apply_leave',0,1,1,NULL,'2022-12-28 09:52:28'),(24,'Visitor Book','visitor_book',0,1,1,NULL,'2022-10-10 11:45:18'),(25,'Student Timeline','student_timeline',0,1,1,NULL,'2022-10-11 04:50:29'),(700,'Online Course','online_course',0,1,1,700,'2024-05-09 12:08:11');

--
-- Table structure for table `pickup_point`
--

CREATE TABLE `pickup_point` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `latitude` varchar(100) DEFAULT NULL,
  `longitude` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pickup_point`
--


--
-- Table structure for table `print_headerfooter`
--

CREATE TABLE `print_headerfooter` (
  `id` int NOT NULL AUTO_INCREMENT,
  `print_type` varchar(255) NOT NULL,
  `header_image` varchar(255) NOT NULL,
  `footer_content` text NOT NULL,
  `created_by` int NOT NULL,
  `entry_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `print_headerfooter`
--

INSERT INTO `print_headerfooter` VALUES (1,'staff_payslip','1715409199-1143975818663f112fb00fa!Header-01.png','This payslip is computer generated hence no signature is required.',1,'2024-05-11 06:33:19','2022-12-28 09:52:24'),(2,'student_receipt','1715087293-1930388985663a27bd94a76!Print Header Footer-01-01.jpg','This receipt is computer generated hence no signature is required.',1,'2024-05-07 13:08:13','2022-12-28 09:52:24'),(3,'online_admission_receipt','header_image.jpg','This receipt is for online admission  computer ffffffff generated hence no signature is required.',1,'2021-05-27 12:50:24','2022-12-28 09:52:24'),(4,'online_exam','1655913577-198504634062b33c698fde1!online-exam.jpg','This receipt is for online exam computer  generated hence no signature is required.',1,'2022-08-30 12:58:46','2022-09-08 17:28:34');

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int DEFAULT NULL,
  `subject_id` int DEFAULT NULL,
  `question_type` varchar(100) NOT NULL,
  `level` varchar(10) NOT NULL,
  `class_id` int NOT NULL,
  `section_id` int DEFAULT NULL,
  `class_section_id` int DEFAULT NULL,
  `question` text,
  `opt_a` text,
  `opt_b` text,
  `opt_c` text,
  `opt_d` text,
  `opt_e` text,
  `correct` text,
  `descriptive_word_limit` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject_id` (`subject_id`),
  KEY `staff_id` (`staff_id`),
  KEY `class_id` (`class_id`),
  KEY `section_id` (`section_id`),
  KEY `class_section_id` (`class_section_id`),
  CONSTRAINT `questions_ibfk_1` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_ibfk_3` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_ibfk_4` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_ibfk_5` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_ibfk_6` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `questions`
--


--
-- Table structure for table `read_notification`
--

CREATE TABLE `read_notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `student_id` int DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `notification_id` int DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_id` (`notification_id`),
  KEY `staff_id` (`staff_id`),
  KEY `student_id` (`student_id`),
  CONSTRAINT `read_notification_ibfk_1` FOREIGN KEY (`notification_id`) REFERENCES `send_notification` (`id`) ON DELETE CASCADE,
  CONSTRAINT `read_notification_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `read_notification_ibfk_3` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `read_notification`
--


--
-- Table structure for table `reference`
--

CREATE TABLE `reference` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reference` varchar(100) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `reference`
--


--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `slug` varchar(150) DEFAULT NULL,
  `is_active` int DEFAULT '0',
  `is_system` int NOT NULL DEFAULT '0',
  `is_superadmin` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin',NULL,0,1,0,'2018-06-30 15:39:11','0000-00-00'),(2,'Teacher',NULL,0,1,0,'2018-06-30 15:39:14','0000-00-00'),(3,'Accountant',NULL,0,1,0,'2018-06-30 15:39:17','0000-00-00'),(4,'Librarian',NULL,0,1,0,'2018-06-30 15:39:21','0000-00-00'),(6,'Receptionist',NULL,0,1,0,'2018-07-02 05:39:03','0000-00-00'),(7,'Super Admin',NULL,0,1,1,'2018-07-11 14:11:29','0000-00-00');

--
-- Table structure for table `roles_permissions`
--

CREATE TABLE `roles_permissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role_id` int DEFAULT NULL,
  `perm_cat_id` int DEFAULT NULL,
  `can_view` int DEFAULT NULL,
  `can_add` int DEFAULT NULL,
  `can_edit` int DEFAULT NULL,
  `can_delete` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `role_id` (`role_id`),
  KEY `perm_cat_id` (`perm_cat_id`),
  CONSTRAINT `roles_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `roles_permissions_ibfk_2` FOREIGN KEY (`perm_cat_id`) REFERENCES `permission_category` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1552 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `roles_permissions`
--

INSERT INTO `roles_permissions` VALUES (11,1,78,1,1,1,1,'2018-07-03 00:49:43'),(23,1,12,1,1,1,1,'2018-07-06 09:45:38'),(24,1,13,1,1,1,1,'2018-07-06 09:48:28'),(26,1,15,1,1,1,0,'2019-11-27 23:47:28'),(31,1,21,1,0,1,0,'2019-11-26 04:51:15'),(34,1,24,1,1,1,1,'2019-11-28 06:35:20'),(43,1,32,1,1,1,1,'2018-07-06 10:22:05'),(44,1,33,1,1,1,1,'2018-07-06 10:22:29'),(45,1,34,1,1,1,1,'2018-07-06 10:23:59'),(46,1,35,1,1,1,1,'2018-07-06 10:24:34'),(47,1,104,1,1,1,1,'2018-07-06 10:23:08'),(48,1,37,1,1,1,1,'2018-07-06 10:25:30'),(49,1,38,1,1,1,1,'2018-07-09 05:15:27'),(73,1,67,1,1,1,1,'2018-07-09 03:14:47'),(74,1,79,1,1,0,1,'2019-11-30 01:32:51'),(75,1,80,1,1,1,1,'2018-07-06 09:41:23'),(76,1,81,1,1,1,1,'2018-07-06 09:41:23'),(79,1,84,1,1,1,1,'2018-07-06 09:41:23'),(80,1,85,1,1,1,1,'2018-07-12 00:16:00'),(120,1,39,1,1,1,1,'2018-07-06 10:26:28'),(156,1,9,1,1,1,1,'2019-11-27 23:45:46'),(157,1,10,1,1,1,1,'2019-11-27 23:45:46'),(201,1,14,1,0,0,0,'2018-07-02 11:22:03'),(204,1,26,1,0,0,0,'2018-07-02 11:32:05'),(208,1,31,1,1,1,1,'2019-11-30 01:32:51'),(222,1,1,1,1,1,1,'2019-11-27 22:55:06'),(369,1,102,1,1,1,1,'2019-12-02 05:02:15'),(435,1,96,1,1,1,1,'2018-07-09 01:03:54'),(461,1,97,1,0,0,0,'2018-07-09 01:00:16'),(464,1,86,1,1,1,1,'2019-11-28 06:39:19'),(557,6,82,1,1,1,1,'2019-12-01 01:48:28'),(558,6,83,1,1,1,1,'2019-12-01 01:49:08'),(559,6,84,1,1,1,1,'2019-12-01 01:49:59'),(575,6,44,1,0,0,0,'2018-07-10 07:35:33'),(576,6,46,1,0,0,0,'2018-07-10 07:35:33'),(578,6,102,1,1,1,1,'2019-12-01 01:52:27'),(634,4,102,1,1,1,1,'2019-12-01 01:03:00'),(669,1,145,1,0,0,0,'2019-11-26 04:51:15'),(677,1,153,1,0,0,0,'2019-11-01 02:28:24'),(728,1,185,1,1,1,1,'2019-11-28 02:50:33'),(729,1,186,1,1,1,1,'2019-11-28 02:49:07'),(730,1,214,1,0,1,0,'2019-11-28 01:47:53'),(732,1,198,1,0,0,0,'2019-11-26 05:24:30'),(734,1,200,1,0,0,0,'2019-11-26 05:24:30'),(735,1,201,1,0,0,0,'2019-11-26 05:24:30'),(736,1,202,1,0,0,0,'2019-11-26 05:24:30'),(737,1,203,1,0,0,0,'2019-11-26 05:24:30'),(747,1,2,1,0,0,0,'2019-11-27 22:56:08'),(748,1,3,1,1,1,1,'2019-11-27 22:56:32'),(751,1,128,1,1,1,1,'2024-05-07 15:39:51'),(754,1,134,1,1,1,1,'2019-11-27 23:18:21'),(755,1,5,1,1,0,1,'2019-11-27 23:35:07'),(756,1,6,1,0,0,0,'2019-11-27 23:35:25'),(757,1,7,1,1,1,1,'2019-11-27 23:36:35'),(758,1,8,1,1,1,1,'2019-11-27 23:37:27'),(760,1,68,1,0,0,0,'2019-11-27 23:38:06'),(761,1,69,1,1,1,1,'2019-11-27 23:39:06'),(762,1,70,1,1,1,1,'2019-11-27 23:39:41'),(763,1,71,1,0,0,0,'2019-11-27 23:39:59'),(765,1,73,1,0,0,0,'2019-11-27 23:43:15'),(766,1,74,1,0,0,0,'2019-11-27 23:43:55'),(768,1,11,1,0,0,0,'2019-11-27 23:45:46'),(769,1,122,1,0,0,0,'2019-11-27 23:52:43'),(771,1,136,1,1,1,1,'2024-05-07 15:39:51'),(772,1,20,1,1,1,1,'2019-11-28 04:06:44'),(773,1,137,1,1,1,1,'2019-11-28 00:46:14'),(774,1,141,1,1,1,1,'2019-11-28 00:59:42'),(775,1,142,1,0,0,0,'2019-11-27 23:56:12'),(776,1,143,1,1,1,1,'2019-11-28 00:59:42'),(777,1,144,1,0,0,0,'2019-11-27 23:56:12'),(778,1,187,1,0,0,0,'2019-11-27 23:56:12'),(779,1,196,1,0,0,0,'2019-11-27 23:56:12'),(781,1,207,1,0,0,0,'2019-11-27 23:56:12'),(782,1,208,1,0,1,0,'2019-11-28 00:10:22'),(783,1,210,1,0,1,0,'2019-11-28 00:34:40'),(784,1,211,1,0,1,0,'2019-11-28 00:38:23'),(785,1,212,1,0,1,0,'2019-11-28 00:42:15'),(786,1,205,1,1,1,1,'2019-11-28 00:42:15'),(787,1,222,1,0,1,0,'2019-11-28 01:36:36'),(788,1,77,1,1,1,1,'2019-11-28 06:22:10'),(789,1,188,1,1,1,1,'2019-11-28 06:26:16'),(790,1,23,1,1,1,1,'2019-11-28 06:34:20'),(791,1,25,1,1,1,1,'2019-11-28 06:36:20'),(792,1,127,1,0,0,0,'2019-11-28 06:41:25'),(794,1,88,1,1,1,0,'2019-11-28 06:43:04'),(795,1,90,1,1,0,1,'2019-11-28 06:46:22'),(796,1,108,1,0,1,1,'2021-01-23 07:09:32'),(797,1,109,1,1,0,0,'2019-11-28 23:38:11'),(798,1,110,1,1,1,1,'2019-11-28 23:49:29'),(799,1,111,1,1,1,1,'2019-11-28 23:49:57'),(800,1,112,1,1,1,1,'2019-11-28 23:49:57'),(801,1,129,1,1,1,1,'2024-05-07 15:39:51'),(802,1,189,1,0,1,1,'2019-11-28 23:59:22'),(810,2,1,1,1,1,1,'2019-11-30 02:54:16'),(817,1,93,1,1,1,1,'2019-11-29 00:56:14'),(825,1,87,1,0,0,0,'2019-11-29 00:56:14'),(829,1,94,1,1,0,0,'2019-11-29 00:57:57'),(836,1,146,1,0,0,0,'2019-11-29 01:13:28'),(837,1,147,1,0,0,0,'2019-11-29 01:13:28'),(838,1,148,1,0,0,0,'2019-11-29 01:13:28'),(839,1,149,1,0,0,0,'2019-11-29 01:13:28'),(840,1,150,1,0,0,0,'2019-11-29 01:13:28'),(841,1,151,1,0,0,0,'2019-11-29 01:13:28'),(842,1,152,1,0,0,0,'2019-11-29 01:13:28'),(843,1,154,1,0,0,0,'2019-11-29 01:13:28'),(862,1,155,1,0,0,0,'2019-11-29 02:07:30'),(863,1,156,1,0,0,0,'2019-11-29 02:07:52'),(864,1,157,1,0,0,0,'2019-11-29 02:08:05'),(874,1,158,1,0,0,0,'2019-11-29 02:14:03'),(875,1,159,1,0,0,0,'2019-11-29 02:14:31'),(876,1,160,1,0,0,0,'2019-11-29 02:14:44'),(878,1,162,1,0,0,0,'2019-11-29 02:15:58'),(879,1,163,1,0,0,0,'2019-11-29 02:16:19'),(882,1,164,1,0,0,0,'2019-11-29 02:25:17'),(884,1,165,1,0,0,0,'2019-11-29 02:25:30'),(886,1,197,1,0,0,0,'2019-11-29 02:25:48'),(887,1,219,1,0,0,0,'2019-11-29 02:26:05'),(889,1,220,1,0,0,0,'2019-11-29 02:26:22'),(932,1,204,1,0,0,0,'2019-11-29 03:43:27'),(933,1,221,1,0,0,0,'2019-11-29 03:45:04'),(936,1,161,1,0,0,0,'2019-11-29 03:45:48'),(941,1,174,1,0,0,0,'2019-11-29 03:50:53'),(944,1,177,1,0,0,0,'2019-11-29 03:52:22'),(974,1,224,1,0,0,0,'2019-11-29 04:32:52'),(1026,1,135,1,0,1,0,'2019-11-29 06:02:12'),(1089,1,217,1,0,0,0,'2019-11-30 00:49:39'),(1090,1,98,1,1,1,1,'2019-11-30 01:32:51'),(1091,1,99,1,0,0,0,'2019-11-30 01:30:18'),(1092,1,223,1,0,0,0,'2019-11-30 01:32:51'),(1103,2,205,1,1,1,1,'2019-11-30 01:56:04'),(1119,2,117,1,0,0,0,'2019-11-30 01:56:04'),(1123,3,8,1,1,1,1,'2019-11-30 06:46:18'),(1125,3,69,1,1,1,1,'2019-11-30 07:00:49'),(1126,3,70,1,1,1,1,'2019-11-30 07:04:46'),(1130,3,9,1,1,1,1,'2019-11-30 07:14:54'),(1131,3,10,1,1,1,1,'2019-11-30 07:16:02'),(1134,3,35,1,1,1,1,'2019-11-30 07:25:04'),(1135,3,104,1,1,1,1,'2019-11-30 07:25:53'),(1140,3,41,1,1,1,1,'2019-11-30 07:37:13'),(1141,3,42,1,1,1,1,'2019-11-30 07:37:46'),(1142,3,43,1,1,1,1,'2019-11-30 07:42:06'),(1151,3,87,1,0,0,0,'2019-11-30 02:23:13'),(1152,3,88,1,1,1,0,'2019-11-30 02:23:13'),(1153,3,90,1,1,0,1,'2019-11-30 02:23:13'),(1154,3,108,1,0,1,0,'2019-11-30 02:23:13'),(1155,3,109,1,1,0,0,'2019-11-30 02:23:13'),(1156,3,110,1,1,1,1,'2019-11-30 02:23:13'),(1157,3,111,1,1,1,1,'2019-11-30 02:23:13'),(1158,3,112,1,1,1,1,'2019-11-30 02:23:13'),(1159,3,127,1,0,0,0,'2019-11-30 02:23:13'),(1160,3,129,0,1,0,1,'2019-11-30 02:23:13'),(1161,3,102,1,1,1,1,'2019-11-30 02:23:13'),(1162,3,106,1,0,0,0,'2019-11-30 02:23:13'),(1163,3,113,1,0,0,0,'2019-11-30 02:23:13'),(1164,3,114,1,0,0,0,'2019-11-30 02:23:13'),(1165,3,115,1,0,0,0,'2019-11-30 02:23:13'),(1166,3,116,1,0,0,0,'2019-11-30 02:23:13'),(1167,3,117,1,0,0,0,'2019-11-30 02:23:13'),(1168,3,118,1,0,0,0,'2019-11-30 02:23:13'),(1179,2,212,1,0,1,0,'2019-11-30 02:36:17'),(1185,2,150,1,0,0,0,'2019-11-30 02:36:17'),(1187,2,152,1,0,0,0,'2019-11-30 02:36:17'),(1188,2,153,1,0,0,0,'2019-11-30 02:36:17'),(1189,2,154,1,0,0,0,'2019-11-30 02:36:17'),(1190,2,197,1,0,0,0,'2019-11-30 02:36:17'),(1191,2,198,1,0,0,0,'2019-11-30 02:36:17'),(1193,2,200,1,0,0,0,'2019-11-30 02:36:17'),(1194,2,201,1,0,0,0,'2019-11-30 02:36:17'),(1195,2,202,1,0,0,0,'2019-11-30 02:36:17'),(1196,2,203,1,0,0,0,'2019-11-30 02:36:17'),(1197,2,219,1,0,0,0,'2019-11-30 02:36:17'),(1199,2,213,1,0,0,0,'2019-11-30 02:36:17'),(1201,2,230,1,0,0,0,'2019-11-30 02:36:17'),(1204,2,214,1,0,1,0,'2019-11-30 02:36:17'),(1206,2,224,1,0,0,0,'2019-11-30 02:36:17'),(1218,2,128,0,1,0,1,'2019-11-30 03:37:44'),(1220,3,135,1,0,1,0,'2019-11-30 07:08:56'),(1231,3,190,1,0,0,0,'2019-11-30 03:44:02'),(1232,3,192,1,0,0,0,'2019-11-30 03:44:02'),(1233,3,226,1,0,0,0,'2019-11-30 03:44:02'),(1234,3,227,1,0,0,0,'2019-11-30 03:44:02'),(1235,3,224,1,0,0,0,'2019-11-30 03:44:02'),(1236,2,15,1,1,1,0,'2019-11-30 03:54:25'),(1239,2,122,1,0,0,0,'2019-11-30 03:57:48'),(1240,2,136,1,0,0,0,'2019-11-30 03:57:48'),(1242,6,217,1,0,0,0,'2019-11-30 04:00:13'),(1243,6,224,1,0,0,0,'2019-11-30 04:00:13'),(1245,2,20,1,1,1,1,'2019-11-30 04:01:28'),(1246,2,137,1,1,1,1,'2019-11-30 04:02:40'),(1250,2,187,1,0,0,0,'2019-11-30 04:11:19'),(1252,2,207,1,0,0,0,'2019-11-30 04:21:21'),(1253,2,208,1,0,1,0,'2019-11-30 04:22:00'),(1255,2,210,1,0,1,0,'2019-11-30 04:22:58'),(1256,2,211,1,0,1,0,'2019-11-30 04:24:03'),(1262,2,43,1,1,1,1,'2019-11-30 04:39:42'),(1263,2,44,1,0,0,0,'2019-11-30 04:41:43'),(1264,2,46,1,0,0,0,'2019-11-30 04:41:43'),(1265,2,217,1,0,0,0,'2019-11-30 04:41:43'),(1269,2,164,1,0,0,0,'2019-11-30 04:51:04'),(1271,2,109,1,1,0,0,'2019-11-30 05:03:37'),(1272,2,93,1,1,1,1,'2019-11-30 05:07:25'),(1273,2,94,1,1,0,0,'2019-11-30 05:07:42'),(1275,2,102,1,1,1,1,'2019-11-30 05:11:22'),(1277,2,196,1,0,0,0,'2019-11-30 05:15:01'),(1278,2,195,1,0,0,0,'2019-11-30 05:19:08'),(1279,2,185,1,1,1,1,'2019-11-30 05:21:44'),(1280,2,186,1,1,1,1,'2019-11-30 05:22:43'),(1281,2,222,1,0,1,0,'2019-11-30 05:24:30'),(1283,3,5,1,1,0,1,'2019-11-30 06:43:04'),(1284,3,6,1,0,0,0,'2019-11-30 06:43:29'),(1285,3,7,1,1,1,1,'2019-11-30 06:44:39'),(1286,3,68,1,0,0,0,'2019-11-30 06:46:58'),(1287,3,71,1,0,0,0,'2019-11-30 07:05:41'),(1288,3,73,1,0,0,0,'2019-11-30 07:05:59'),(1289,3,74,1,0,0,0,'2019-11-30 07:06:08'),(1290,3,11,1,0,0,0,'2019-11-30 07:16:37'),(1291,3,12,1,1,1,1,'2019-11-30 07:19:29'),(1292,3,13,1,1,1,1,'2019-11-30 07:22:27'),(1294,3,14,1,0,0,0,'2019-11-30 07:22:55'),(1295,3,31,1,1,1,1,'2019-12-02 06:30:37'),(1297,3,37,1,1,1,1,'2019-11-30 07:28:09'),(1298,3,38,1,1,1,1,'2019-11-30 07:29:02'),(1299,3,39,1,1,1,1,'2019-11-30 07:30:07'),(1300,3,40,1,1,1,1,'2019-11-30 07:32:43'),(1301,3,44,1,0,0,0,'2019-11-30 07:44:09'),(1302,3,46,1,0,0,0,'2019-11-30 07:44:09'),(1303,3,217,1,0,0,0,'2019-11-30 07:44:09'),(1304,3,155,1,0,0,0,'2019-11-30 07:44:32'),(1305,3,156,1,0,0,0,'2019-11-30 07:45:18'),(1306,3,157,1,0,0,0,'2019-11-30 07:45:42'),(1307,3,158,1,0,0,0,'2019-11-30 07:46:07'),(1308,3,159,1,0,0,0,'2019-11-30 07:46:21'),(1309,3,160,1,0,0,0,'2019-11-30 07:46:33'),(1313,3,161,1,0,0,0,'2019-11-30 07:48:26'),(1314,3,162,1,0,0,0,'2019-11-30 07:48:48'),(1315,3,163,1,0,0,0,'2019-11-30 07:48:48'),(1316,3,164,1,0,0,0,'2019-11-30 07:49:47'),(1317,3,165,1,0,0,0,'2019-11-30 07:49:47'),(1318,3,174,1,0,0,0,'2019-11-30 07:49:47'),(1319,3,175,1,0,0,0,'2019-11-30 07:49:59'),(1320,3,181,1,0,0,0,'2019-11-30 07:50:08'),(1321,3,86,1,1,1,1,'2019-11-30 07:54:08'),(1322,4,28,1,1,1,1,'2019-12-01 00:52:39'),(1324,4,29,1,0,0,0,'2019-12-01 00:53:46'),(1325,4,30,1,0,0,0,'2019-12-01 00:53:59'),(1326,4,123,1,0,0,0,'2019-12-01 00:54:26'),(1327,4,228,1,0,0,0,'2019-12-01 00:54:39'),(1328,4,43,1,1,1,1,'2019-12-01 00:58:05'),(1332,4,44,1,0,0,0,'2019-12-01 00:59:16'),(1333,4,46,1,0,0,0,'2019-12-01 00:59:16'),(1334,4,217,1,0,0,0,'2019-12-01 00:59:16'),(1335,4,178,1,0,0,0,'2019-12-01 00:59:59'),(1336,4,179,1,0,0,0,'2019-12-01 01:00:11'),(1337,4,180,1,0,0,0,'2019-12-01 01:00:29'),(1338,4,221,1,0,0,0,'2019-12-01 01:00:46'),(1339,4,86,1,0,0,0,'2019-12-01 01:01:02'),(1341,4,106,1,0,0,0,'2019-12-01 01:05:21'),(1342,1,107,1,0,0,0,'2019-12-01 01:06:44'),(1343,4,117,1,0,0,0,'2019-12-01 01:10:20'),(1344,4,194,1,0,0,0,'2019-12-01 01:11:35'),(1348,4,230,1,0,0,0,'2019-12-01 01:19:15'),(1350,6,1,1,0,0,0,'2019-12-01 01:35:32'),(1351,6,21,1,0,0,0,'2019-12-01 01:36:29'),(1352,6,23,1,0,0,0,'2019-12-01 01:36:45'),(1353,6,24,1,0,0,0,'2019-12-01 01:37:05'),(1354,6,25,1,0,0,0,'2019-12-01 01:37:34'),(1355,6,77,1,0,0,0,'2019-12-01 01:38:08'),(1356,6,188,1,0,0,0,'2019-12-01 01:38:45'),(1357,6,43,1,1,1,1,'2019-12-01 01:40:44'),(1358,6,78,1,1,1,1,'2019-12-01 01:43:04'),(1360,6,79,1,1,0,1,'2019-12-01 01:44:39'),(1361,6,80,1,1,1,1,'2019-12-01 01:45:08'),(1362,6,81,1,1,1,1,'2019-12-01 01:47:50'),(1363,6,85,1,1,1,1,'2019-12-01 01:50:43'),(1364,6,86,1,0,0,0,'2019-12-01 01:51:10'),(1365,6,106,1,0,0,0,'2019-12-01 01:52:55'),(1366,6,117,1,0,0,0,'2019-12-01 01:53:08'),(1394,1,106,1,0,0,0,'2019-12-02 05:20:33'),(1395,1,113,1,0,0,0,'2019-12-02 05:20:59'),(1396,1,114,1,0,0,0,'2019-12-02 05:21:34'),(1397,1,115,1,0,0,0,'2019-12-02 05:21:34'),(1398,1,116,1,0,0,0,'2019-12-02 05:21:54'),(1399,1,117,1,0,0,0,'2019-12-02 05:22:04'),(1400,1,118,1,0,0,0,'2019-12-02 05:22:20'),(1402,1,191,1,0,0,0,'2019-12-02 05:23:34'),(1403,1,192,1,0,0,0,'2019-12-02 05:23:47'),(1404,1,193,1,0,0,0,'2019-12-02 05:23:58'),(1406,1,195,1,0,0,0,'2019-12-02 05:24:20'),(1408,1,227,1,0,0,0,'2019-12-02 05:25:47'),(1410,1,226,1,0,0,0,'2019-12-02 05:31:41'),(1411,1,229,1,0,0,0,'2019-12-02 05:32:57'),(1412,1,230,1,0,0,0,'2019-12-02 05:32:57'),(1413,1,190,1,0,0,0,'2019-12-02 05:43:41'),(1418,2,232,1,0,1,1,'2019-12-02 06:11:27'),(1421,1,232,1,0,1,1,'2019-12-02 06:19:32'),(1422,3,32,1,1,1,1,'2019-12-02 06:30:37'),(1423,3,33,1,1,1,1,'2019-12-02 06:30:37'),(1424,3,34,1,1,1,1,'2019-12-02 06:30:37'),(1425,3,182,1,0,0,0,'2019-12-02 06:30:37'),(1426,3,183,1,0,0,0,'2019-12-02 06:30:37'),(1427,3,189,1,0,1,1,'2019-12-02 06:30:37'),(1428,3,229,1,0,0,0,'2019-12-02 06:30:37'),(1429,3,230,1,0,0,0,'2019-12-02 06:30:37'),(1430,4,213,1,0,0,0,'2019-12-02 06:32:14'),(1432,4,224,1,0,0,0,'2019-12-02 06:32:14'),(1433,4,195,1,0,0,0,'2019-12-03 04:57:53'),(1434,4,229,1,0,0,0,'2019-12-03 04:58:19'),(1436,6,213,1,0,0,0,'2019-12-03 05:10:11'),(1437,6,191,1,0,0,0,'2019-12-03 05:10:11'),(1438,6,193,1,0,0,0,'2019-12-03 05:10:11'),(1439,6,230,1,0,0,0,'2019-12-03 05:10:11'),(1441,2,107,1,0,0,0,'2020-02-12 02:10:13'),(1442,2,134,1,1,1,1,'2020-02-12 02:12:36'),(1445,3,233,1,0,0,0,'2020-02-12 03:51:17'),(1446,1,234,1,1,1,1,'2020-06-01 21:51:09'),(1447,1,235,1,1,1,1,'2020-05-29 23:17:01'),(1448,1,236,1,1,1,0,'2020-05-29 23:17:52'),(1449,1,237,1,0,1,0,'2020-05-29 23:18:18'),(1450,1,238,1,1,1,1,'2020-05-29 23:19:52'),(1451,1,239,1,1,1,1,'2020-05-29 23:22:10'),(1458,1,240,1,0,0,0,'2020-06-07 18:30:42'),(1459,1,241,1,0,0,0,'2020-06-07 18:30:42'),(1460,1,242,1,0,0,0,'2020-06-07 18:30:42'),(1462,3,242,1,0,0,0,'2020-06-14 22:46:54'),(1463,6,242,1,0,0,0,'2020-06-14 22:48:14'),(1465,1,109,1,1,0,0,'2020-09-21 06:33:50'),(1466,1,108,1,0,1,1,'2023-11-04 12:52:08'),(1467,1,244,1,0,0,0,'2020-09-21 06:59:54'),(1468,1,245,1,0,0,0,'2020-09-21 06:59:54'),(1469,1,246,1,0,0,0,'2020-09-21 06:59:54'),(1470,1,247,1,0,0,0,'2021-01-07 06:12:14'),(1472,2,247,1,0,0,0,'2021-01-21 12:46:40'),(1473,1,248,1,1,1,1,'2021-05-19 12:52:49'),(1474,1,249,1,0,0,0,'2021-05-19 12:52:49'),(1476,3,248,1,1,1,1,'2021-05-28 09:36:16'),(1477,3,249,1,0,0,0,'2021-05-28 09:36:16'),(1478,6,248,1,0,0,0,'2021-05-28 09:56:14'),(1479,6,249,1,0,0,0,'2021-05-28 09:56:14'),(1481,1,269,1,0,0,1,'2023-11-04 12:52:08'),(1482,2,269,1,0,0,1,'2023-11-04 12:52:28'),(1483,3,269,1,0,0,1,'2023-11-04 12:53:22'),(1484,4,269,1,0,0,1,'2023-11-04 12:53:34'),(1485,6,269,1,0,0,1,'2023-11-04 12:53:52'),(1486,1,272,1,0,0,0,'2024-05-07 15:39:51'),(1487,1,259,1,0,1,0,'2024-05-07 15:39:51'),(1488,1,260,1,1,1,1,'2024-05-07 15:39:51'),(1489,1,261,1,1,1,1,'2024-05-07 15:39:51'),(1490,1,262,1,1,1,0,'2024-05-07 15:39:51'),(1491,1,256,1,0,0,0,'2024-05-07 15:39:51'),(1492,1,257,1,0,0,0,'2024-05-07 15:39:51'),(1493,1,258,1,0,0,0,'2024-05-07 15:39:51'),(1494,1,250,1,0,0,0,'2024-05-07 15:39:51'),(1495,1,27,1,1,0,1,'2024-05-07 16:16:23'),(1496,1,268,1,1,1,1,'2024-05-07 16:16:23'),(1497,1,270,1,1,1,1,'2024-05-07 16:16:23'),(1498,1,43,1,1,1,1,'2024-05-07 16:16:23'),(1499,1,44,1,0,0,0,'2024-05-07 16:16:23'),(1500,1,46,1,0,0,0,'2024-05-07 16:16:23'),(1501,1,252,1,0,1,0,'2024-05-07 16:16:23'),(1502,1,253,1,0,0,0,'2024-05-07 16:16:23'),(1503,1,263,1,1,0,1,'2024-05-07 16:16:23'),(1504,1,7001,1,1,1,1,'2021-05-11 04:21:33'),(1505,1,7002,1,0,0,0,'2021-05-17 02:28:47'),(1506,1,7003,1,1,1,1,'2021-05-11 05:29:37'),(1507,1,7005,1,1,1,1,'2021-05-17 02:28:47'),(1508,1,7004,1,1,1,1,'2021-05-11 07:00:50'),(1509,1,7006,1,1,0,0,'2021-05-17 02:28:47'),(1510,1,7007,1,0,0,0,'2021-05-11 07:00:50'),(1511,1,7008,1,0,0,0,'2021-05-11 07:00:50'),(1512,1,7009,1,0,0,0,'2021-05-11 07:00:50'),(1513,1,7010,1,0,0,0,'2021-05-11 07:00:50'),(1514,2,7001,1,1,1,1,'2021-05-15 08:07:28'),(1515,2,7002,1,0,0,0,'2021-05-17 07:51:44'),(1516,2,7003,1,1,1,1,'2021-05-15 07:28:38'),(1517,2,7004,1,1,1,1,'2021-05-15 07:28:38'),(1518,3,7006,1,1,0,0,'2021-05-17 07:52:19'),(1519,3,7007,1,0,0,0,'2021-05-17 01:32:06'),(1520,1,7011,1,0,0,0,'2021-05-17 02:28:47'),(1521,2,7005,1,1,1,1,'2021-05-17 07:51:44'),(1522,2,7010,1,0,0,0,'2021-05-17 07:51:44'),(1523,1,7012,1,0,0,1,'2022-06-20 01:20:01'),(1524,1,7013,1,0,1,1,'2022-06-18 06:52:16'),(1525,1,7014,1,1,1,1,'2021-05-15 07:28:38'),(1526,6,7014,1,1,1,1,'2022-06-18 06:09:15'),(1527,6,7013,1,0,0,0,'2022-06-18 06:13:07'),(1528,4,7012,1,0,0,0,'2022-07-15 01:22:20'),(1529,4,7013,1,0,1,1,'2022-07-15 01:26:29'),(1530,4,7014,1,1,1,1,'2022-07-15 01:24:48'),(1531,2,7012,1,0,0,1,'2022-07-15 02:01:12'),(1534,3,7012,1,0,0,0,'2022-07-15 02:31:18'),(1535,3,7013,1,0,0,0,'2022-07-15 02:31:18'),(1536,3,7014,1,0,0,0,'2022-07-15 02:31:18'),(1544,2,250,1,0,0,0,'2024-05-11 06:46:04'),(1545,1,126,1,0,0,0,'2024-05-11 07:22:13'),(1546,1,251,1,1,1,1,'2024-05-11 11:41:37'),(1547,1,266,1,0,0,0,'2024-05-11 11:41:37'),(1548,1,267,1,0,0,0,'2024-05-11 11:41:37'),(1549,1,254,1,1,1,1,'2024-05-11 11:41:37'),(1550,1,255,1,1,1,1,'2024-05-11 11:41:37'),(1551,1,176,1,0,0,0,'2024-05-11 11:41:37');

--
-- Table structure for table `room_types`
--

CREATE TABLE `room_types` (
  `id` int NOT NULL AUTO_INCREMENT,
  `room_type` varchar(200) DEFAULT NULL,
  `description` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `room_types`
--


--
-- Table structure for table `route_pickup_point`
--

CREATE TABLE `route_pickup_point` (
  `id` int NOT NULL AUTO_INCREMENT,
  `transport_route_id` int NOT NULL,
  `pickup_point_id` int NOT NULL,
  `fees` float(10,2) DEFAULT '0.00',
  `destination_distance` float(10,1) DEFAULT '0.0',
  `pickup_time` time DEFAULT NULL,
  `order_number` float NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `transport_route_id` (`transport_route_id`),
  KEY `pickup_point_id` (`pickup_point_id`),
  CONSTRAINT `route_pickup_point_ibfk_1` FOREIGN KEY (`transport_route_id`) REFERENCES `transport_route` (`id`) ON DELETE CASCADE,
  CONSTRAINT `route_pickup_point_ibfk_2` FOREIGN KEY (`pickup_point_id`) REFERENCES `pickup_point` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `route_pickup_point`
--


--
-- Table structure for table `sch_settings`
--

CREATE TABLE `sch_settings` (
  `id` int NOT NULL,
  `base_url` varchar(500) DEFAULT NULL,
  `folder_path` text,
  `name` varchar(100) DEFAULT NULL,
  `biometric` int DEFAULT '0',
  `biometric_device` text,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text,
  `lang_id` int DEFAULT NULL,
  `languages` varchar(500) NOT NULL,
  `dise_code` varchar(50) DEFAULT NULL,
  `date_format` varchar(50) NOT NULL,
  `time_format` varchar(255) NOT NULL,
  `currency` varchar(50) NOT NULL,
  `currency_symbol` varchar(50) NOT NULL,
  `is_rtl` varchar(10) DEFAULT 'disabled',
  `is_duplicate_fees_invoice` varchar(100) DEFAULT '0',
  `collect_back_date_fees` int NOT NULL,
  `single_page_print` int DEFAULT '0',
  `timezone` varchar(30) DEFAULT 'UTC',
  `session_id` int DEFAULT NULL,
  `cron_secret_key` varchar(100) NOT NULL,
  `currency_place` varchar(50) NOT NULL DEFAULT 'before_number',
  `currency_format` varchar(20) DEFAULT NULL,
  `class_teacher` varchar(100) NOT NULL,
  `start_month` varchar(40) NOT NULL,
  `attendence_type` int NOT NULL DEFAULT '0',
  `low_attendance_limit` float(10,2) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `admin_logo` varchar(255) NOT NULL,
  `admin_small_logo` varchar(255) NOT NULL,
  `admin_login_page_background` varchar(255) NOT NULL,
  `user_login_page_background` varchar(255) NOT NULL,
  `theme` varchar(200) NOT NULL DEFAULT 'default.jpg',
  `fee_due_days` int DEFAULT '0',
  `adm_auto_insert` int NOT NULL DEFAULT '1',
  `adm_prefix` varchar(50) NOT NULL DEFAULT 'ssadm19/20',
  `adm_start_from` varchar(11) NOT NULL,
  `adm_no_digit` int NOT NULL DEFAULT '6',
  `adm_update_status` int NOT NULL DEFAULT '0',
  `staffid_auto_insert` int NOT NULL DEFAULT '1',
  `staffid_prefix` varchar(100) NOT NULL DEFAULT 'staffss/19/20',
  `staffid_start_from` varchar(50) NOT NULL,
  `staffid_no_digit` int NOT NULL DEFAULT '6',
  `staffid_update_status` int NOT NULL DEFAULT '0',
  `is_active` varchar(255) DEFAULT 'no',
  `online_admission` int DEFAULT '0',
  `online_admission_payment` varchar(50) NOT NULL,
  `online_admission_amount` float NOT NULL,
  `online_admission_instruction` text NOT NULL,
  `online_admission_conditions` text NOT NULL,
  `online_admission_application_form` varchar(255) DEFAULT NULL,
  `exam_result` int NOT NULL,
  `is_blood_group` int NOT NULL DEFAULT '1',
  `is_student_house` int NOT NULL DEFAULT '1',
  `roll_no` int NOT NULL DEFAULT '1',
  `category` int NOT NULL,
  `religion` int NOT NULL DEFAULT '1',
  `cast` int NOT NULL DEFAULT '1',
  `mobile_no` int NOT NULL DEFAULT '1',
  `student_email` int NOT NULL DEFAULT '1',
  `admission_date` int NOT NULL DEFAULT '1',
  `lastname` int NOT NULL,
  `middlename` int NOT NULL DEFAULT '1',
  `student_photo` int NOT NULL DEFAULT '1',
  `student_height` int NOT NULL DEFAULT '1',
  `student_weight` int NOT NULL DEFAULT '1',
  `measurement_date` int NOT NULL DEFAULT '1',
  `father_name` int NOT NULL DEFAULT '1',
  `father_phone` int NOT NULL DEFAULT '1',
  `father_occupation` int NOT NULL DEFAULT '1',
  `father_pic` int NOT NULL DEFAULT '1',
  `mother_name` int NOT NULL DEFAULT '1',
  `mother_phone` int NOT NULL DEFAULT '1',
  `mother_occupation` int NOT NULL DEFAULT '1',
  `mother_pic` int NOT NULL DEFAULT '1',
  `guardian_name` int NOT NULL,
  `guardian_relation` int NOT NULL DEFAULT '1',
  `guardian_phone` int NOT NULL,
  `guardian_email` int NOT NULL DEFAULT '1',
  `guardian_pic` int NOT NULL DEFAULT '1',
  `guardian_occupation` int NOT NULL,
  `guardian_address` int NOT NULL DEFAULT '1',
  `current_address` int NOT NULL DEFAULT '1',
  `permanent_address` int NOT NULL DEFAULT '1',
  `route_list` int NOT NULL DEFAULT '1',
  `hostel_id` int NOT NULL DEFAULT '1',
  `bank_account_no` int NOT NULL DEFAULT '1',
  `ifsc_code` int NOT NULL,
  `bank_name` int NOT NULL,
  `national_identification_no` int NOT NULL DEFAULT '1',
  `local_identification_no` int NOT NULL DEFAULT '1',
  `rte` int NOT NULL DEFAULT '1',
  `previous_school_details` int NOT NULL DEFAULT '1',
  `student_note` int NOT NULL DEFAULT '1',
  `upload_documents` int NOT NULL DEFAULT '1',
  `student_barcode` int NOT NULL DEFAULT '1',
  `staff_designation` int NOT NULL DEFAULT '1',
  `staff_department` int NOT NULL DEFAULT '1',
  `staff_last_name` int NOT NULL DEFAULT '1',
  `staff_father_name` int NOT NULL DEFAULT '1',
  `staff_mother_name` int NOT NULL DEFAULT '1',
  `staff_date_of_joining` int NOT NULL DEFAULT '1',
  `staff_phone` int NOT NULL DEFAULT '1',
  `staff_emergency_contact` int NOT NULL DEFAULT '1',
  `staff_marital_status` int NOT NULL DEFAULT '1',
  `staff_photo` int NOT NULL DEFAULT '1',
  `staff_current_address` int NOT NULL DEFAULT '1',
  `staff_permanent_address` int NOT NULL DEFAULT '1',
  `staff_qualification` int NOT NULL DEFAULT '1',
  `staff_work_experience` int NOT NULL DEFAULT '1',
  `staff_note` int NOT NULL DEFAULT '1',
  `staff_epf_no` int NOT NULL DEFAULT '1',
  `staff_basic_salary` int NOT NULL DEFAULT '1',
  `staff_contract_type` int NOT NULL DEFAULT '1',
  `staff_work_shift` int NOT NULL DEFAULT '1',
  `staff_work_location` int NOT NULL DEFAULT '1',
  `staff_leaves` int NOT NULL DEFAULT '1',
  `staff_account_details` int NOT NULL DEFAULT '1',
  `staff_social_media` int NOT NULL DEFAULT '1',
  `staff_upload_documents` int NOT NULL DEFAULT '1',
  `staff_barcode` int NOT NULL DEFAULT '1',
  `staff_notification_email` varchar(50) NOT NULL,
  `mobile_api_url` tinytext NOT NULL,
  `app_primary_color_code` varchar(20) DEFAULT NULL,
  `app_secondary_color_code` varchar(20) DEFAULT NULL,
  `admin_mobile_api_url` tinytext NOT NULL,
  `admin_app_primary_color_code` varchar(20) NOT NULL,
  `admin_app_secondary_color_code` varchar(20) NOT NULL,
  `app_logo` varchar(250) DEFAULT NULL,
  `student_profile_edit` int NOT NULL DEFAULT '0',
  `start_week` varchar(10) NOT NULL,
  `my_question` int NOT NULL,
  `superadmin_restriction` varchar(20) NOT NULL,
  `student_timeline` varchar(20) NOT NULL,
  `calendar_event_reminder` int DEFAULT NULL,
  `event_reminder` varchar(20) NOT NULL,
  `student_login` varchar(100) DEFAULT NULL,
  `parent_login` varchar(100) DEFAULT NULL,
  `student_panel_login` int NOT NULL DEFAULT '1',
  `parent_panel_login` int NOT NULL DEFAULT '1',
  `is_student_feature_lock` int NOT NULL DEFAULT '0',
  `maintenance_mode` int NOT NULL DEFAULT '0',
  `lock_grace_period` int NOT NULL DEFAULT '0',
  `is_offline_fee_payment` int NOT NULL DEFAULT '0',
  `offline_bank_payment_instruction` text NOT NULL,
  `scan_code_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'barcode',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lang_id` (`lang_id`),
  KEY `session_id` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sch_settings`
--

INSERT INTO `sch_settings` VALUES (1,'https://nagayle.qalamplatform.com/nagayle2/','/var/www/nagayle.qalamplatform.com/html/nagayle2','Nagayle Primary and Secondary School',0,'','madaale2025@gmail.com','+25261 5707551','kaaraan xaliima hiite, Mogadishu, Somalia',4,'[\"4\",\"5\",\"5\"]','1418','d-m-Y','12-hour','150','$','disabled','0,1',1,1,'Africa/Mogadishu',19,'','after_number','#,###.##','no','5',1,50.00,'1715084586-299668284663a1d2adca4a!Print Logo-01.jpg','1715084626-359908736663a1d5270656!ADMIN LOGO-01.png','1715084636-891217797663a1d5c99f56!Admin Small Logo-01.png','1715098912-1630147603663a55202c30b!437701641_979596237295376_3446951848330414258_n.jpg','1715098897-586761373663a5511b6b05!437701641_979596237295376_3446951848330414258_n.jpg','red.jpg',60,1,'std','0001',4,1,0,'NG','001',3,1,'no',0,'',0,'','<p>&nbsp;Please enter your institution online admission terms & conditions here.</p>',NULL,1,1,0,1,1,0,0,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'','https://nagayle.qalamplatform.com/nagayle1/api/','#FE0001','#1EA422','','','','1715149642-245833168663b1b4a99345!ADMIN LOGO-01.png',1,'Saturday',1,'enabled','disabled',3,'enabled','[\"admission_no\",\"mobile_number\"]','null',1,1,0,0,0,1,'<p>*789*650456*lacagta#</p>','qrcode','2024-05-16 17:31:27',NULL);

--
-- Table structure for table `school_houses`
--

CREATE TABLE `school_houses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `house_name` varchar(200) NOT NULL,
  `description` varchar(400) NOT NULL,
  `is_active` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `school_houses`
--


--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int NOT NULL AUTO_INCREMENT,
  `section` varchar(60) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` VALUES (1,'A','no','2024-05-06 09:27:46',NULL),(3,'B','no','2024-05-06 15:54:48',NULL),(4,'C','no','2024-05-11 08:59:25',NULL);

--
-- Table structure for table `send_notification`
--

CREATE TABLE `send_notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `publish_date` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `attachment` varchar(500) DEFAULT NULL,
  `message` text,
  `visible_student` varchar(10) NOT NULL DEFAULT 'no',
  `visible_staff` varchar(10) NOT NULL DEFAULT 'no',
  `visible_parent` varchar(10) NOT NULL DEFAULT 'no',
  `created_by` varchar(60) DEFAULT NULL,
  `created_id` int DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_id` (`created_id`),
  CONSTRAINT `send_notification_ibfk_1` FOREIGN KEY (`created_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `send_notification`
--

INSERT INTO `send_notification` VALUES (1,'Test','2024-05-07','2024-05-07',NULL,'<p>waa tijaabo Qalams oo diray</p>','No','Yes','No','Super Admin',1,'no','2024-05-07 16:04:37',NULL),(2,'Fasax ciid adxaa','2024-05-11','2024-05-11',NULL,'<p>Maanta waaa maalinta ciida adxaaa, iskuulka waa fasax,ciid wanagsan.</p>','Yes','Yes','Yes','Admin',42,'no','2024-05-11 10:01:57',NULL);

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `session` varchar(60) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'no',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES (19,'2023-24','no','2016-10-01 05:29:10','0000-00-00'),(20,'2024-25','no','2016-10-01 05:29:18','0000-00-00'),(21,'2025-26','no','2016-10-01 05:30:10','0000-00-00'),(22,'2026-27','no','2016-10-01 05:30:18','0000-00-00'),(23,'2027-28','no','2016-10-01 05:30:24','0000-00-00'),(24,'2028-29','no','2016-10-01 05:30:30','0000-00-00'),(25,'2029-30','no','2016-10-01 05:30:37','0000-00-00');

--
-- Table structure for table `share_content_for`
--

CREATE TABLE `share_content_for` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_id` varchar(20) DEFAULT NULL,
  `student_id` int DEFAULT NULL,
  `user_parent_id` int DEFAULT NULL,
  `staff_id` int DEFAULT NULL,
  `class_section_id` int DEFAULT NULL,
  `share_content_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `upload_content_id` (`share_content_id`),
  KEY `student_id` (`student_id`),
  KEY `staff_id` (`staff_id`),
  KEY `class_section_id` (`class_section_id`),
  KEY `user_parent_id` (`user_parent_id`),
  CONSTRAINT `share_content_for_ibfk_1` FOREIGN KEY (`share_content_id`) REFERENCES `share_contents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `share_content_for_ibfk_2` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`),
  CONSTRAINT `share_content_for_ibfk_3` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`),
  CONSTRAINT `share_content_for_ibfk_4` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`),
  CONSTRAINT `share_content_for_ibfk_5` FOREIGN KEY (`user_parent_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `share_content_for`
--

INSERT INTO `share_content_for` VALUES (1,NULL,NULL,NULL,NULL,13,1,'2024-05-11 07:11:15'),(2,NULL,478,NULL,NULL,NULL,2,'2024-05-11 10:10:16');

--
-- Table structure for table `share_contents`
--

CREATE TABLE `share_contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `send_to` varchar(50) DEFAULT NULL,
  `title` text,
  `share_date` date DEFAULT NULL,
  `valid_upto` date DEFAULT NULL,
  `description` text,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  CONSTRAINT `share_contents_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `share_contents`
--

INSERT INTO `share_contents` VALUES (1,'class','Biology Book f4','2024-05-11','2024-05-15','',1,'2024-05-11 07:11:15'),(2,'individual','New BOok','2024-05-11','2024-05-11','Book fiican, kafaaideysio',42,'2024-05-11 10:10:16');

--
-- Table structure for table `share_upload_contents`
--

CREATE TABLE `share_upload_contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `upload_content_id` int DEFAULT NULL,
  `share_content_id` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `upload_content_id` (`upload_content_id`),
  KEY `share_content_id` (`share_content_id`),
  CONSTRAINT `share_upload_contents_ibfk_1` FOREIGN KEY (`upload_content_id`) REFERENCES `upload_contents` (`id`) ON DELETE CASCADE,
  CONSTRAINT `share_upload_contents_ibfk_2` FOREIGN KEY (`share_content_id`) REFERENCES `share_contents` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `share_upload_contents`
--

INSERT INTO `share_upload_contents` VALUES (1,2,1,'2024-05-11 07:11:15'),(2,2,2,'2024-05-11 10:10:16');

--
-- Table structure for table `sidebar_menus`
--

CREATE TABLE `sidebar_menus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `permission_group_id` int DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `menu` varchar(500) DEFAULT NULL,
  `activate_menu` varchar(100) DEFAULT NULL,
  `lang_key` varchar(250) NOT NULL,
  `system_level` int DEFAULT '0',
  `level` int DEFAULT NULL,
  `sidebar_display` int DEFAULT '0',
  `access_permissions` text,
  `is_active` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `permission_group_id` (`permission_group_id`),
  CONSTRAINT `sidebar_menus_ibfk_1` FOREIGN KEY (`permission_group_id`) REFERENCES `permission_group` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sidebar_menus`
--

INSERT INTO `sidebar_menus` VALUES (1,17,'fa fa-ioxhost ftlayer','Front Office','front_office','front_office',10,1,1,'(\'admission_enquiry\', \'can_view\') || (\'visitor_book\', \'can_view\') ||       (\'phon_call_log\', \'can_view\') ||  (\'postal_dispatch\', \'can_view\') ||       (\'postal_receive\', \'can_view\') || (\'complaint\', \'can_view\') ||(\'setup_font_office\', \'can_view\')',1,'2023-01-10 12:49:51'),(2,1,'fa fa-user-plus ftlayer','Student Information','student_information','student_information',20,3,1,'(\'student\', \'can_view\') || (\'student\', \'can_add\') || (\'student_history\', \'can_view\') || (\'student_categories\', \'can_view\') || (\'student_houses\', \'can_view\') || (\'disable_student\', \'can_view\') || (\'disable_reason\', \'can_view\') || (\'online_admission\', \'can_view\') || (\'multiclass_student\', \'can_view\') || (\'disable_reason\', \'can_view\')',1,'2024-05-07 15:42:05'),(3,2,'fa fa-money ftlayer','Fees Collection','fees_collection','fees_collection',30,4,1,'(\'collect_fees\', \'can_view\') || (\'search_fees_payment\', \'can_view\') || (\'search_due_fees\', \'can_view\') || (\'fees_statement\', \'can_view\') || (\'fees_carry_forward\', \'can_view\') || (\'fees_master\', \'can_view\') || (\'fees_group\', \'can_view\') || (\'fees_type\', \'can_view\') || (\'fees_discount\', \'can_view\') || (\'accountants\', \'can_view\')',1,'2024-05-07 15:42:05'),(4,3,'fa fa-usd ftlayer','Income','income','income',40,8,1,'(\'income\', \'can_view\') || (\'search_income\', \'can_view\') || (\'income_head\', \'can_view\')',1,'2024-05-07 15:42:19'),(7,4,'fa fa-credit-card ftlayer','Expense','expense','expenses',50,9,1,'(\'expense\', \'can_view\') || (\'search_expense\', \'can_view\') || (\'expense_head\', \'can_view\')',1,'2024-05-07 15:42:19'),(10,5,'fa fa-calendar-check-o ftlayer','Attendance','attendance','attendance',60,10,1,'(\'student_attendance\', \'can_view\')',1,'2024-05-07 15:42:19'),(11,6,'fa fa-map-o ftlayer','Examinations','examinations','examinations',70,5,1,'(\'exam_group\', \'can_view\') || (\'exam_result\', \'can_view\') || (\'design_admit_card\', \'can_view\') || (\'print_admit_card\', \'can_view\') || (\'design_marksheet\', \'can_view\') || (\'print_marksheet\', \'can_view\') || (\'marks_grade\', \'can_view\')',1,'2024-05-07 15:42:10'),(12,23,'fa fa-rss ftlayer','Online Examinations','online_examinations','online_examinations',80,11,1,'(\'online_examination\', \'can_view\') ||  (\'question_bank\', \'can_view\'',1,'2024-05-07 15:42:19'),(13,29,'fa fa-list-alt ftlayer','Lesson Plan','lesson_plan','lesson_plan',90,12,1,'(\'manage_lesson_plan\', \'can_view\') || (\'manage_syllabus_status\', \'can_view\') || (\'lesson\', \'can_view\') ||  (\'topic\', \'can_view\')||  (\'copy_old_lesson\', \'can_view\')',1,'2024-05-07 15:42:19'),(14,7,'fa fa-mortar-board ftlayer','Academics','academics','academics',100,2,1,'(\'class_timetable\', \'can_view\') || (\'teachers_timetable\', \'can_view\') || (\'assign_class_teacher\', \'can_view\') || (\'promote_student\', \'can_view\') || (\'subject_group\', \'can_view\') || (\'section\', \'can_view\') || (\'subject\', \'can_view\') || (\'class\', \'can_view\') || (\'section\', \'can_view\')',1,'2024-05-07 15:42:05'),(15,18,'fa fa-sitemap ftlayer','Human Resource','human_resource','human_resource',110,6,1,'(\'staff\', \'can_view\') || (\'approve_leave_request\', \'can_view\') || (\'apply_leave\', \'can_view\') || (\'leave_types\', \'can_view\') || (\'teachers_rating\', \'can_view\') || (\'department\', \'can_view\') || (\'designation\', \'can_view\') || (\'disable_staff\', \'can_view\')',1,'2024-05-07 15:42:14'),(16,13,'fa fa-bullhorn ftlayer','Communicate','communicate','communicate',120,7,1,'(\'notice_board\', \'can_view\') || (\'email\', \'can_view\') || (\'sms\', \'can_view\') || (\'email_sms_log\', \'can_view\')',1,'2024-05-07 15:42:19'),(17,8,'fa fa-download ftlayer','Download Center','download_center','download_center',130,13,1,'(\'upload_content\', \'can_view\') || (\'video_tutorial\', \'can_view\') || (\'content_type\', \'can_view\') || (\'content_share_list\', \'can_view\')',1,'2024-05-06 09:09:59'),(18,19,'fa fa-flask ftlayer','Homework','homework','homework',140,14,1,'(\'homework\', \'can_view\') || (\'homework\', \'can_view\')',1,'2024-05-06 09:09:59'),(19,9,'fa fa-book ftlayer','Library','library','library',150,15,1,'(\'books\', \'can_view\') || (\'issue_return\', \'can_view\') || (\'add_staff_member\', \'can_view\') || (\'add_student\', \'can_view\')',1,'2024-05-06 09:09:59'),(20,10,'fa fa-object-group ftlayer','Inventory','inventory','inventory',160,16,1,'(\'issue_item\', \'can_view\') || (\'item_stock\', \'can_view\') || (\'item\', \'can_view\') || (\'item_category\', \'can_view\') || (\'item_category\', \'can_view\') || (\'store\', \'can_view\') || (\'supplier\', \'can_view\')',1,'2024-05-06 09:09:59'),(21,11,'fa fa-bus ftlayer','Transport','transport','transport',170,17,1,'(\'routes\', \'can_view\') || (\'vehicle\', \'can_view\') || (\'assign_vehicle\', \'can_view\') || (\'transport_fees_master\', \'can_view\') || (\'pickup_point\', \'can_view\') || (\'route_pickup_point\', \'can_view\') || (\'student_transport_fees\', \'can_view\')      ',1,'2024-05-06 09:09:59'),(22,12,'fa fa-building-o ftlayer','Hostel','hostel','hostel',180,24,0,'(\'hostel_rooms\', \'can_view\') || (\'room_type\', \'can_view\') || (\'hostel\', \'can_view\')',1,'2024-05-06 09:09:59'),(23,20,'fa fa-newspaper-o ftlayer','Certificate','certificate','certificate',190,18,1,'(\'student_certificate\', \'can_view\') || (\'generate_certificate\', \'can_view\') || (\'student_id_card\', \'can_view\') || (\'generate_id_card\', \'can_view\') || (\'staff_id_card\', \'can_view\') || (\'generate_staff_id_card\', \'can_view\')',1,'2024-05-06 09:09:59'),(24,16,'fa fa-empire ftlayer','Front CMS','front_cms','front_cms',200,19,1,'(\'event\', \'can_view\') || (\'gallery\', \'can_view\') || (\'notice\', \'can_view\') || (\'media_manager\', \'can_view\') || (\'pages\', \'can_view\') || (\'menus\', \'can_view\') || (\'banner_images\', \'can_view\')',1,'2024-05-06 09:09:59'),(25,28,'fa fa-universal-access ftlayer','Alumni','alumni','alumni',210,20,1,'(\'manage_alumni\', \'can_view\') || (\'events\', \'can_view\')',1,'2024-05-06 09:09:59'),(26,14,'fa fa-line-chart ftlayer','Reports','reports','reports',220,21,1,'(\'student_report\', \'can_view\') || (\'guardian_report\', \'can_view\') || (\'student_history\', \'can_view\') || (\'student_login_credential_report\', \'can_view\') || (\'class_subject_report\', \'can_view\') || (\'admission_report\', \'can_view\') || (\'sibling_report\', \'can_view\') || (\'evaluation_report\', \'can_view\') || (\'student_profile\', \'can_view\') || (\'fees_statement\', \'can_view\') || (\'balance_fees_report\', \'can_view\') || (\'fees_collection_report\', \'can_view\') || (\'online_fees_collection_report\', \'can_view\') || (\'income_report\', \'can_view\') || (\'expense_report\', \'can_view\') || (\'payroll_report\', \'can_view\') || (\'income_group_report\', \'can_view\') || (\'expense_group_report\', \'can_view\') || (\'attendance_report\', \'can_view\') || (\'staff_attendance_report\', \'can_view\') || (\'exam_marks_report\', \'can_view\') ||        (\'online_exam_wise_report\', \'can_view\') || (\'online_exams_report\', \'can_view\') || (\'online_exams_attempt_report\', \'can_view\') || (\'online_exams_rank_report\', \'can_view\') || (\'payroll_report\', \'can_view\') || (\'transport_report\', \'can_view\') || (\'hostel_report\', \'can_view\') || (\'audit_trail_report\', \'can_view\') || (\'user_log\', \'can_view\') || (\'book_issue_report\', \'can_view\') || (\'book_due_report\', \'can_view\') || (\'book_inventory_report\', \'can_view\') || (\'stock_report\', \'can_view\') ||      (\'add_item_report\', \'can_view\') || (\'issue_inventory_report\', \'can_view\') || (\'syllabus_status_report\', \'can_view\') ||    (\'teacher_syllabus_status_report\', \'can_view\') || (\'daily_collection_report\', \'can_view\') || (\'balance_fees_statement\', \'can_view\') || (\'balance_fees_report_with_remark\', \'can_view\')',1,'2024-05-06 09:09:59'),(27,15,'fa fa-gears ftlayer','System Settings','system_settings','system_setting',230,22,1,'(\'general_setting\', \'can_view\') || (\'session_setting\', \'can_view\') || (\'notification_setting\', \'can_view\') || (\'sms_setting\', \'can_view\') || (\'email_setting\', \'can_view\') || (\'payment_methods\', \'can_view\') || (\'languages\', \'can_view\') || (\'user_status\', \'can_view\') || (\'backup_restore\', \'can_view\') || (\'print_header_footer\', \'can_view\') || (\'backup\', \'can_view\') || (\'front_cms_setting\', \'can_view\') || (\'custom_fields\', \'can_view\') || (\'system_fields\', \'can_view\') || (\'student_profile_update\', \'can_view\') || (\'currency\', \'can_view\') || (\'language_switcher\', \'can_view\') || (\'sidebar_menu\', \'can_view\') || (\'online_admission\', \'can_view\')\r\n',1,'2024-05-06 09:09:59'),(28,700,'fa fa-file-video-o ftlayer','Online Course','online_course','online_course',0,4,1,'(\'online_course\', \'can_view\') || (\'online_course_offline_payment\', \'can_view\') || (\'student_course_purchase_report\', \'can_view\') || (\'course_sell_count_report\', \'can_view\') || (\'online_course_setting\', \'can_view\')|| (\'course_category\', \'can_view\') || (\'guest_report\', \'can_view\')|| (\'course_rating_report\', \'can_view\')',1,'2023-01-10 09:49:51'),(33,1000,'fa fa-sitemap ftlayer','Multi Branch','multi_branch','multi_branch',0,4,1,'(\'multi_branch_overview\', \'can_view\') || (\'multi_branch_daily_collection_report\', \'can_view\') || (\'multi_branch_payroll\', \'can_view\') || (\'multi_branch_income_report\', \'can_view\') || (\'multi_branch_expense_report\', \'can_view\') || (\'multi_branch_user_log_report\', \'can_view\') || (\'multi_branch_setting\', \'can_view\')',1,'2023-01-10 09:49:51');

--
-- Table structure for table `sidebar_sub_menus`
--

CREATE TABLE `sidebar_sub_menus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sidebar_menu_id` int DEFAULT NULL,
  `menu` varchar(500) DEFAULT NULL,
  `key` varchar(500) DEFAULT NULL,
  `lang_key` varchar(250) DEFAULT NULL,
  `url` text,
  `level` int DEFAULT NULL,
  `access_permissions` varchar(500) DEFAULT NULL,
  `permission_group_id` int DEFAULT NULL,
  `activate_controller` varchar(100) DEFAULT NULL COMMENT 'income',
  `activate_methods` varchar(500) DEFAULT NULL COMMENT 'index,edit',
  `addon_permission` varchar(100) DEFAULT NULL,
  `is_active` int DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sidebar_menu_id` (`sidebar_menu_id`),
  KEY `permission_group_id` (`permission_group_id`),
  CONSTRAINT `sidebar_sub_menus_ibfk_1` FOREIGN KEY (`sidebar_menu_id`) REFERENCES `sidebar_menus` (`id`) ON DELETE CASCADE,
  CONSTRAINT `sidebar_sub_menus_ibfk_2` FOREIGN KEY (`permission_group_id`) REFERENCES `permission_group` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sidebar_sub_menus`
--

INSERT INTO `sidebar_sub_menus` VALUES (1,1,'admission_enquiry',NULL,'admission_enquiry','admin/enquiry',1,'(\'admission_enquiry\', \'can_view\')',NULL,'enquiry','index',NULL,1,'2022-07-11 12:04:46'),(2,1,'visitor_book',NULL,'visitor_book','admin/visitors',2,'(\'visitor_book\', \'can_view\')',NULL,'visitors','index',NULL,1,'2022-07-11 12:04:46'),(3,1,'phone_call_log',NULL,'phone_call_log','admin/generalcall',3,'(\'phone_call_log\', \'can_view\')',NULL,'generalcall','index,edit',NULL,1,'2022-05-10 11:40:07'),(4,1,'postal_dispatch',NULL,'postal_dispatch','admin/dispatch',4,'(\'postal_dispatch\', \'can_view\')',NULL,'dispatch','index,editdispatch',NULL,1,'2022-05-10 11:40:09'),(5,1,'postal_receive',NULL,'postal_receive','admin/receive',5,'(\'postal_receive\', \'can_view\')',NULL,'receive','index,editreceive',NULL,1,'2022-05-10 11:40:09'),(6,1,'complain',NULL,'complain','admin/complaint',6,'(\'complaint\', \'can_view\')',NULL,'complaint','index,edit',NULL,1,'2022-05-10 11:40:00'),(7,1,'setup_front_office',NULL,'setup_front_office','admin/visitorspurpose',7,'(\'setup_font_office\', \'can_view\')',NULL,'visitorspurpose','index,edit',NULL,1,'2022-04-18 15:43:15'),(9,2,'student_admission',NULL,'student_admission','student/create',2,'(\'student\', \'can_add\')',NULL,'student','create,import',NULL,1,'2022-08-30 07:51:02'),(10,2,'online_admission',NULL,'online_admission','admin/onlinestudent',3,'(\'online_admission\', \'can_view\')',27,'onlinestudent','index,edit',NULL,1,'2022-05-10 11:40:30'),(11,2,'disable_student',NULL,'disabled_students','student/disablestudentslist',4,'(\'disable_student\', \'can_view\')',NULL,'student','disablestudentslist','',1,'2022-07-23 06:49:00'),(12,3,'collect_fees',NULL,'collect_fees','studentfee',1,'(\'collect_fees\', \'can_view\')',NULL,'studentfee','index,addfee',NULL,1,'2022-07-23 06:53:34'),(13,3,'search_fees_payment',NULL,'search_fees_payment','studentfee/searchpayment',3,'(\'search_fees_payment\', \'can_view\')',NULL,'studentfee','searchpayment',NULL,1,'2022-08-08 06:03:40'),(14,3,'search_due_fees',NULL,'search_due_fees','studentfee/feesearch',4,'(\'search_due_fees\', \'can_view\')',NULL,'studentfee','feesearch',NULL,1,'2022-08-08 06:03:38'),(15,3,'fees_master',NULL,'fees_master','admin/feemaster',5,'(\'fees_master\', \'can_view\')',NULL,'feemaster','index,assign,edit',NULL,1,'2022-09-24 07:35:55'),(16,3,'fees_group',NULL,'fees_group','admin/feegroup',6,'(\'fees_group\', \'can_view\')',NULL,'feegroup','index,edit',NULL,1,'2022-08-08 06:03:32'),(17,4,'add_income',NULL,'add_income','admin/income',1,'(\'income\', \'can_view\')',NULL,'income','index,edit',NULL,1,'2022-07-23 07:03:40'),(18,4,'search_income',NULL,'search_income','admin/income/incomesearch',2,'(\'search_income\', \'can_view\')',NULL,'income','incomesearch',NULL,1,'2022-07-23 07:10:13'),(19,4,'income_head',NULL,'income_head','admin/incomehead',3,'(\'income_head\', \'can_view\')',NULL,'incomehead','index,edit',NULL,1,'2022-07-23 07:11:11'),(20,2,'student_details',NULL,'student_details','student/search',1,'(\'student\', \'can_view\')',NULL,'student','search,view,edit',NULL,1,'2022-08-30 07:51:05'),(21,2,'multi_class_student',NULL,'multi_class_student','student/multiclass',5,'(\'multi_class_student\', \'can_view\')',26,'student','multiclass',NULL,1,'2022-07-23 06:48:37'),(22,2,'bulk_delete',NULL,'bulk_delete','student/bulkdelete',6,'(\'student\', \'can_delete\')',NULL,'student','bulkdelete',NULL,1,'2022-07-23 06:48:11'),(23,2,'student_categories',NULL,'student_categories','category',7,'(\'student_categories\', \'can_view\')',NULL,'category','index,edit',NULL,1,'2022-07-23 06:47:24'),(24,2,'student_house',NULL,'student_house','admin/schoolhouse',8,'(\'student_houses\', \'can_view\')',NULL,'schoolhouse','index,edit',NULL,1,'2022-07-23 06:49:59'),(25,2,'disable_reason',NULL,'disable_reason','admin/disable_reason',9,'(\'disable_reason\', \'can_view\')',NULL,'disable_reason','index,edit',NULL,1,'2022-07-23 06:50:41'),(29,7,'add_expense',NULL,'add_expense','admin/expense',1,'(\'expense\', \'can_view\')',NULL,'expense','index,edit','',1,'2022-07-23 07:12:25'),(32,3,'fees_type',NULL,'fees_type','admin/feetype',7,'(\'fees_type\', \'can_view\')',NULL,'feetype','index,edit','',1,'2022-08-08 06:03:29'),(33,10,'attendance_by_date','attendance_by_date','attendance_by_date','admin/stuattendence/attendencereport',3,'(\'attendance_by_date\', \'can_view\')',NULL,'stuattendence','attendencereport','',0,'2024-05-06 15:03:42'),(34,10,'student_attendance','student_attendance','student_attendance','admin/stuattendence',1,'(\'student_attendance\', \'can_view\')',NULL,'stuattendence','index','',0,'2024-05-06 15:03:42'),(35,10,'approve_leave','approve_leave','approve_leave','admin/approve_leave',2,'(\'approve_leave\', \'can_view\')',NULL,'approve_leave','index','',1,'2022-10-14 16:16:44'),(36,11,'exam_group',NULL,'exam_group','admin/examgroup',1,'(\'exam_group\', \'can_view\')',NULL,'examgroup','index,addexam,edit','',1,'2022-07-23 07:23:01'),(37,11,'exam_schedule',NULL,'exam_schedule','admin/exam_schedule',2,'(\'student_attendance\', \'can_view\')',NULL,'exam_schedule','index','',1,'2022-05-16 07:01:34'),(38,11,'exam_result',NULL,'exam_result','admin/examresult',3,'(\'exam_result\', \'can_view\')',NULL,'examresult','index','',1,'2022-05-16 07:01:34'),(39,11,'design_admit_card',NULL,'design_admit_card','admin/admitcard',4,'(\'design_admit_card\', \'can_view\')',NULL,'admitcard','index,edit','',1,'2022-07-23 07:28:02'),(40,11,'print_admit_card',NULL,'print_admit_card','admin/examresult/admitcard',5,'(\'print_admit_card\', \'can_view\')',NULL,'examresult','admitcard','',1,'2022-05-16 07:01:34'),(41,11,'design_marksheet',NULL,'design_marksheet','admin/marksheet',6,'(\'design_marksheet\', \'can_view\')',NULL,'marksheet','index,edit','',1,'2022-07-23 07:35:35'),(42,11,'print_marksheet',NULL,'print_marksheet','admin/examresult/marksheet',7,'(\'print_marksheet\', \'can_view\')',NULL,'examresult','marksheet','',1,'2022-05-16 07:01:38'),(43,11,'marks_grade',NULL,'marks_grade','admin/grade',8,'(\'marks_grade\', \'can_view\')',NULL,'grade','index,edit','',1,'2022-07-23 07:37:15'),(44,11,'marks_division',NULL,'marks_division','admin/marksdivision',9,'(\'marks_division\', \'can_view\')',NULL,'marksdivision','index,edit','',1,'2022-08-25 06:04:26'),(45,12,'online_exam',NULL,'online_exam','admin/onlineexam',1,'(\'online_examination\', \'can_view\')',NULL,'onlineexam','index,evalution,assign','',1,'2022-08-30 13:03:45'),(46,12,'question_bank',NULL,'question_bank','admin/question',1,'(\'question_bank\', \'can_view\')',NULL,'question','index,read','',1,'2022-08-30 11:03:13'),(47,13,'manage_lesson_plan',NULL,'manage_lesson_plan','admin/syllabus',2,'(\'manage_lesson_plan\', \'can_view\')',NULL,'syllabus','index','',1,'2022-09-03 16:59:31'),(48,13,'manage_syllabus_status',NULL,'manage_syllabus_status','admin/syllabus/status',3,'(\'manage_syllabus_status\', \'can_view\')',NULL,'syllabus','status','',1,'2022-09-03 16:59:35'),(49,13,'lesson',NULL,'lesson','admin/lessonplan/lesson',4,'(\'lesson\', \'can_view\')',NULL,'lessonplan','lesson,editlesson','',1,'2022-09-15 11:30:55'),(50,13,'topic',NULL,'topic','admin/lessonplan/topic',5,'(\'topic\', \'can_view\')',NULL,'lessonplan','topic,edittopic','',1,'2022-09-15 11:30:24'),(51,14,'class_timetable',NULL,'class_timetable','admin/timetable/classreport',1,'(\'class_timetable\', \'can_view\')',NULL,'timetable','classreport,create','',1,'2022-07-23 09:01:22'),(52,14,'teachers_timetable',NULL,'teachers_timetable','admin/timetable/mytimetable',2,'(\'teachers_time_table\', \'can_view\')',NULL,'timetable','mytimetable','',1,'2022-07-20 12:22:59'),(53,14,'assign_class_teacher',NULL,'assign_class_teacher','admin/teacher/assign_class_teacher',3,'(\'assign_class_teacher\', \'can_view\')',NULL,'teacher','assign_class_teacher,update_class_teacher','',1,'2022-07-23 09:00:19'),(54,14,'promote_students',NULL,'promote_students','admin/stdtransfer',4,'(\'promote_student\', \'can_view\')',NULL,'stdtransfer','index','',1,'2022-07-20 12:22:54'),(55,14,'subject_group',NULL,'subject_group','admin/subjectgroup',5,'(\'subject_group\', \'can_view\')',NULL,'subjectgroup','index,edit','',1,'2022-07-23 08:59:42'),(56,14,'subjects',NULL,'subjects','admin/subject',6,'(\'subject\', \'can_view\')',NULL,'subject','index,edit','',1,'2022-07-23 08:59:20'),(57,14,'class',NULL,'class','classes',7,'(\'class\', \'can_view\')',NULL,'classes','index,edit','',1,'2022-07-23 08:58:49'),(58,14,'sections',NULL,'sections','sections',8,'(\'section\', \'can_view\')',NULL,'sections','index,edit','',1,'2022-07-23 08:58:21'),(59,15,'staff_directory',NULL,'staff_directory','admin/staff',1,'(\'staff\', \'can_view\')',NULL,'staff','index,edit,profile,create','',1,'2022-10-12 09:13:24'),(60,15,'staff_attendance',NULL,'staff_attendance','admin/staffattendance',1,'(\'staff_attendance\', \'can_view\')',NULL,'staffattendance','index','',1,'2022-09-07 12:04:15'),(61,15,'payroll',NULL,'payroll','admin/payroll',1,'(\'staff_payroll\', \'can_view\')',NULL,'payroll','index,edit,create','',1,'2022-08-16 11:58:44'),(62,15,'approve_leave_request',NULL,'approve_leave_request','admin/leaverequest/leaverequest',1,'(\'approve_leave_request\', \'can_view\')',NULL,'leaverequest','leaverequest','',1,'2022-05-16 09:04:33'),(74,15,'apply_leave',NULL,'apply_leave','admin/staff/leaverequest',1,'(\'apply_leave\', \'can_view\')',NULL,'staff','leaverequest','',1,'2022-05-16 09:11:41'),(75,15,'leave_type',NULL,'leave_type','admin/leavetypes',1,'(\'leave_types\', \'can_view\')',NULL,'leavetypes','index,leaveedit,createleavetype','',1,'2022-10-18 11:19:22'),(76,15,'teachers_rating',NULL,'teachers_rating','admin/staff/rating',1,'(\'teachers_rating\', \'can_view\')',NULL,'staff','rating','',1,'2022-05-16 09:15:31'),(77,15,'department',NULL,'department','admin/department/department',1,'(\'department\', \'can_view\')',NULL,'department','department,departmentedit','',1,'2022-07-23 09:14:20'),(78,15,'designation',NULL,'designation','admin/designation/designation',1,'(\'designation\', \'can_view\')',NULL,'designation','designation,designationedit','',1,'2022-07-23 09:15:04'),(79,15,'disabled_staff',NULL,'disabled_staff','admin/staff/disablestafflist',1,'(\'disable_staff\', \'can_view\')',NULL,'staff','disablestafflist','',1,'2022-09-13 07:46:56'),(80,16,'notice_board',NULL,'notice_board','admin/notification',1,'(\'notice_board\', \'can_view\')',NULL,'notification','index,edit,add','',1,'2022-07-23 09:17:24'),(81,16,'send_email',NULL,'send_email','admin/mailsms/compose',2,'(\'email\', \'can_view\')',NULL,'mailsms','compose','',1,'2022-09-02 16:52:46'),(82,16,'send_sms',NULL,'send_sms','admin/mailsms/compose_sms',3,'(\'sms\', \'can_view\')',NULL,'mailsms','compose_sms','',1,'2022-09-02 16:52:46'),(83,16,'email_sms_log',NULL,'email_sms_log','admin/mailsms/index',4,'(\'email_sms_log\', \'can_view\')',NULL,'mailsms','index','',1,'2022-09-02 16:52:50'),(84,16,'schedule_email_sms_log',NULL,'schedule_email_sms_log','admin/mailsms/schedule',5,'(\'schedule_email_sms_log\', \'can_view\')',NULL,'mailsms','schedule,edit_schedule','',1,'2022-09-13 07:07:38'),(85,16,'login_credentials_send',NULL,'login_credentials_send','student/bulkmail',6,'(\'login_credentials_send\', \'can_view\')',NULL,'student','bulkmail','',1,'2022-09-02 16:52:46'),(86,16,'email_template',NULL,'email_template','admin/mailsms/email_template',7,'(\'email_template\', \'can_view\')',NULL,'mailsms','email_template','',1,'2022-09-02 16:52:46'),(87,16,'sms_template',NULL,'sms_template','admin/mailsms/sms_template',8,'(\'sms_template\', \'can_view\')',NULL,'mailsms','sms_template','',1,'2022-09-02 16:52:46'),(88,17,'content_type',NULL,'content_type','admin/contenttype',1,'(\'content_type\', \'can_view\')',NULL,'contenttype','index,edit','',1,'2022-07-23 09:24:45'),(89,17,'content_share_list',NULL,'content_share_list','admin/content/list',1,'(\'content_share_list\', \'can_view\')',NULL,'content','list','',1,'2022-07-22 10:07:17'),(90,17,'upload_content',NULL,'upload_content','admin/content/upload',1,'(\'upload_content\', \'can_view\')',NULL,'content','upload','',1,'2022-07-22 10:07:17'),(91,17,'video_tutorial',NULL,'video_tutorial','admin/video_tutorial',1,'(\'video_tutorial\', \'can_view\')',NULL,'video_tutorial','index','',1,'2022-07-22 10:07:17'),(92,18,'add_homework',NULL,'add_homework','homework',1,'(\'homework\', \'can_view\')',NULL,'homework','index','',1,'2022-06-25 09:50:01'),(93,18,'daily_assignment',NULL,'daily_assignment','homework/dailyassignment',2,'(\'daily_assignment\', \'can_view\')',NULL,'homework','dailyassignment','',1,'2022-07-23 09:27:23'),(94,19,'book_list',NULL,'book_list','admin/book/getall',1,'(\'books\', \'can_view\')',NULL,'book','getall,index,edit,import,issue_returnreport','',1,'2022-09-07 11:45:50'),(95,19,'issue_return',NULL,'issue_return','admin/member',1,'(\'issue_return\', \'can_view\')',NULL,'member','index,issue','',1,'2022-07-23 09:32:48'),(96,19,'add_student',NULL,'add_student','admin/member/student',1,'(\'add_student\', \'can_view\')',NULL,'member','student','',1,'2022-05-16 11:22:54'),(97,19,'add_staff_member',NULL,'add_staff_member','admin/member/teacher',1,'(\'add_staff_member\', \'can_view\')',NULL,'member','teacher','',1,'2022-05-16 11:31:43'),(98,7,'search_expense',NULL,'search_expense','admin/expense/expensesearch',1,'(\'search_expense\', \'can_view\')',NULL,'expense','expensesearch','',1,'2022-05-16 11:36:09'),(99,7,'expense_head',NULL,'expense_head','admin/expensehead',1,'(\'expense_head\', \'can_view\')',NULL,'expensehead','index,edit','',1,'2022-07-23 07:16:17'),(100,20,'issue_item',NULL,'issue_item','admin/issueitem',1,'(\'issue_item\', \'can_view\')',NULL,'issueitem','index,create','',1,'2022-07-23 09:35:03'),(101,20,'add_item_stock',NULL,'add_item_stock','admin/itemstock',1,'(\'item_stock\', \'can_view\')',NULL,'itemstock','index,edit','',1,'2022-07-23 09:36:17'),(102,20,'add_item',NULL,'add_item','admin/item',1,'(\'item\', \'can_view\')',NULL,'item','index,edit','',1,'2022-07-23 09:36:56'),(103,20,'item_category',NULL,'item_category','admin/itemcategory',1,'(\'item_category\', \'can_view\')',NULL,'itemcategory','index,edit','',1,'2022-07-23 09:37:12'),(104,20,'item_store',NULL,'item_store','admin/itemstore',1,'(\'store\', \'can_view\')',NULL,'itemstore','index,edit,create','',1,'2022-09-16 11:49:03'),(105,20,'item_supplier',NULL,'item_supplier','admin/itemsupplier',1,'(\'supplier\', \'can_view\')',NULL,'itemsupplier','index,edit,create','',1,'2022-07-23 09:38:22'),(106,21,'fees_master',NULL,'fees_master','admin/transport/feemaster',1,'(\'transport_fees_master\', \'can_view\')',NULL,'transport','feemaster','',1,'2023-03-31 05:33:14'),(107,21,'pickup_point',NULL,'pickup_point','admin/pickuppoint',1,'(\'pickup_point\', \'can_view\')',NULL,'pickuppoint','index','',1,'2023-03-31 05:24:24'),(108,21,'routes',NULL,'routes','admin/route',1,'(\'routes\', \'can_view\')',NULL,'route','index,edit','',1,'2022-09-17 06:21:23'),(109,21,'vehicles',NULL,'vehicles','admin/vehicle',1,'(\'vehicle\', \'can_view\')',NULL,'vehicle','index','',1,'2022-05-16 12:29:35'),(110,21,'assign_vehicle',NULL,'assign_vehicle','admin/vehroute',1,'(\'assign_vehicle\',\'can_view\')',NULL,'vehroute','index,edit','',1,'2022-10-19 07:06:08'),(111,21,'route_pickup_point',NULL,'route_pickup_point','admin/pickuppoint/assign',1,'(\'route_pickup_point\', \'can_view\')',NULL,'pickuppoint','assign','',1,'2023-03-31 05:25:08'),(112,21,'student_transport_fees',NULL,'student_transport_fees','admin/pickuppoint/student_fees',1,'(\'student_transport_fees\', \'can_view\')',NULL,'pickuppoint','student_fees','',1,'2023-03-31 05:25:43'),(113,22,'hostel_rooms',NULL,'hostel_rooms','admin/hostelroom',1,'(\'hostel_rooms\', \'can_view\')',NULL,'hostelroom','index,edit','',1,'2022-07-23 10:27:48'),(114,22,'room_type',NULL,'room_type','admin/roomtype',2,'(\'room_type\', \'can_view\')',NULL,'roomtype','index,edit','',1,'2022-07-23 10:32:14'),(115,22,'hostel',NULL,'hostel','admin/hostel',3,'(\'hostel\', \'can_view\')',NULL,'hostel','index,edit','',1,'2022-07-23 10:32:39'),(116,23,'student_certificate',NULL,'student_certificate','admin/certificate',1,'(\'student_certificate\', \'can_view\')',NULL,'certificate','index,edit','',1,'2022-07-23 10:44:30'),(117,23,'generate_certificate',NULL,'generate_certificate','admin/generatecertificate',1,'(\'generate_certificate\', \'can_view\')',NULL,'generatecertificate','index,search','',1,'2022-07-23 10:46:16'),(118,23,'student_id_card',NULL,'student_id_card','admin/studentidcard',1,'(\'student_id_card\', \'can_view\')',NULL,'studentidcard','index,edit','',1,'2022-07-23 10:47:01'),(119,23,'generate_id_card',NULL,'generate_id_card','admin/generateidcard/search',1,'(\'generate_id_card\', \'can_view\')',NULL,'generateidcard','search','',1,'2022-05-18 05:35:13'),(120,23,'staff_id_card',NULL,'staff_id_card','admin/staffidcard',1,'(\'staff_id_card\', \'can_view\')',NULL,'staffidcard','index,edit','',1,'2022-07-23 10:48:13'),(121,23,'generate_staff_id_card',NULL,'generate_staff_id_card','admin/generatestaffidcard',1,'(\'generate_staff_id_card\', \'can_view\')',NULL,'generatestaffidcard','index,search','',1,'2022-07-23 10:49:06'),(122,24,'event',NULL,'event','admin/front/events',1,'(\'event\', \'can_view\')',NULL,'events','index,edit,create','',1,'2022-07-23 10:51:51'),(123,24,'gallery',NULL,'gallery','admin/front/gallery',1,'(\'gallery\', \'can_view\')',NULL,'gallery','index,edit,create','',1,'2022-07-23 10:52:22'),(124,24,'news',NULL,'news','admin/front/notice',1,'(\'notice\', \'can_view\')',NULL,'notice','index,edit,create','',1,'2022-07-23 10:54:23'),(125,24,'media_manager',NULL,'media_manager','admin/front/media',1,'(\'media_manager\', \'can_view\')',NULL,'media','index','',1,'2022-05-18 06:03:32'),(126,24,'pages',NULL,'pages','admin/front/page',1,'(\'pages\', \'can_view\')',NULL,'page','index,edit,create','',1,'2022-07-23 10:55:28'),(127,24,'menus',NULL,'menus','admin/front/menus',1,'(\'menus\', \'can_view\')',NULL,'menus','index,additem','',1,'2022-07-23 10:56:31'),(128,24,'banner_images',NULL,'banner_images','admin/front/banner',1,'(\'banner_images\', \'can_view\')',NULL,'banner','index','',1,'2022-05-18 06:10:53'),(129,25,'manage_alumini',NULL,'manage_alumini','admin/alumni/alumnilist',1,'(\'manage_alumni\', \'can_view\')',NULL,'alumni','alumnilist','',1,'2022-07-23 10:58:36'),(130,25,'events',NULL,'events','admin/alumni/events',1,'(\'events\', \'can_view\')',NULL,'alumni','events','',1,'2022-07-23 10:59:09'),(131,26,'student_information',NULL,'student_information','report/studentinformation',1,'(\'student_report\', \'can_view\') || (\'guardian_report\', \'can_view\') || (\'student_history\', \'can_view\') || (\'student_login_credential_report\', \'can_view\') || (\'class_subject_report\', \'can_view\') || (\'admission_report\', \'can_view\') || (\'sibling_report\', \'can_view\') || (\'homehork_evaluation_report\', \'can_view\') || (\'student_profile\', \'can_view\') || (\'student_gender_ratio_report\', \'can_view\') || (\'student_teacher_ratio_report\', \'can_view\')',NULL,'report','studentinformation,studentreport,online_admission_report,student_teacher_ratio,boys_girls_ratio,student_profile,sibling_report,admission_report,class_subject,classsectionreport,guardianreport,admissionreport,logindetailreport,parentlogindetailreport','',1,'2022-09-26 05:26:53'),(132,26,'finance',NULL,'finance','financereports/finance',2,'(\'fees_statement\', \'can_view\') || (\'balance_fees_report\', \'can_view\') || (\'fees_collection_report\', \'can_view\') || (\'online_fees_collection_report\', \'can_view\') || (\'income_report\', \'can_view\') || (\'expense_report\', \'can_view\') || (\'payroll_report\', \'can_view\') || (\'income_group_report\', \'can_view\') || (\'expense_group_report\', \'can_view\') || (\'online_admission\', \'can_view\')',NULL,'financereports','finance,reportduefees,reportdailycollection,reportbyname,studentacademicreport,collection_report,onlinefees_report,duefeesremark,income,expense,payroll,incomegroup,expensegroup,onlineadmission','',1,'2022-09-24 12:20:32'),(133,26,'attendance',NULL,'attendance','attendencereports/attendance',3,'(\'attendance_report\', \'can_view\') || (\'student_attendance_type_report\', \'can_view\') || (\'daily_attendance_report\', \'can_view\') || (\'staff_attendance_report\', \'can_view\')',NULL,'attendencereports','attendance,classattendencereport,attendancereport,daily_attendance_report,staffattendancereport,biometric_attlog,reportbymonthstudent,reportbymonth','',1,'2022-09-26 11:36:08'),(134,26,'examinations',NULL,'examinations','admin/examresult/examinations',4,'(\'rank_report\', \'can_view\')',NULL,'examresult','rankreport,examinations','',1,'2022-09-20 08:34:13'),(135,26,'lesson_plan',NULL,'lesson_plan','report/lesson_plan',6,'(\'syllabus_status_report\', \'can_view\') || (\'teacher_syllabus_status_report\', \'can_view\')',NULL,'report','lesson_plan,teachersyllabusstatus','',1,'2022-07-25 11:39:17'),(136,26,'human_resource',NULL,'human_resource','report/human_resource',7,'(\'staff_report\', \'can_view\') || (\'payroll_report\', \'can_view\')',NULL,'report','human_resource,staff_report,payrollreport','',1,'2022-07-25 11:38:20'),(137,26,'library',NULL,'library','report/library',9,'(\'book_issue_report\', \'can_view\') || (\'book_due_report\', \'can_view\') || (\'book_issue_return_report\', \'can_view\') || (\'book_inventory_report\', \'can_view\')',NULL,'report','library,studentbookissuereport,bookduereport,bookinventory','',1,'2022-09-07 11:53:15'),(138,26,'inventory',NULL,'inventory','report/inventory',10,'(\'stock_report\', \'can_view\') || (\'add_item_report\', \'can_view\') || (\'issue_item_report\', \'can_view\')',NULL,'report','inventory,inventorystock,additem,issueinventory','',1,'2022-07-25 11:30:57'),(139,26,'hostel',NULL,'hostel','admin/hostelroom/studenthosteldetails',12,'(\'hostel_report\', \'can_view\')',NULL,'hostelroom','studenthosteldetails','',1,'2022-07-20 12:30:07'),(140,26,'alumni',NULL,'alumni','report/alumnireport',13,'(\'alumni_report\', \'can_view\')',NULL,'report','alumnireport','',1,'2022-07-20 12:30:07'),(141,26,'user_log',NULL,'user_log','admin/userlog',14,'(\'user_log\', \'can_view\')',NULL,'userlog','index','',1,'2022-07-20 12:30:07'),(142,26,'audit_trail_report',NULL,'audit_trail_report','admin/audit',15,'(\'audit_trail_report\', \'can_view\')',NULL,'audit','index','',1,'2022-07-20 12:30:07'),(143,26,'online_examinations',NULL,'online_examinations','admin/onlineexam/report',5,'(\'online_exam_wise_report\', \'can_view\') || (\'online_exams_report\', \'can_view\') || (\'online_exams_attempt_report\', \'can_view\') || (\'online_exams_rank_report\', \'can_view\')',NULL,'onlineexam','report,onlineexams','',1,'2022-07-25 11:48:23'),(144,26,'homework',NULL,'homework','homework/homeworkordailyassignmentreport',8,'(\'homework\', \'can_view\') || (\'daily_assignment\', \'can_view\')',NULL,'homework','homeworkordailyassignmentreport,homeworkreport,evaluation_report,dailyassignmentreport','',1,'2022-09-21 09:28:47'),(145,26,'transport',NULL,'transport','admin/route/studenttransportdetails',11,'(\'transport_report\', \'can_view\')',NULL,'route','studenttransportdetails','',1,'2022-07-20 12:30:07'),(146,27,'general_setting',NULL,'general_setting','schsettings',2,'(\'general_setting\', \'can_view\')',NULL,'schsettings','index,logo,miscellaneous,backendtheme,mobileapp,studentguardianpanel,fees,idautogeneration,attendancetype,maintenance','',1,'2024-05-07 16:00:03'),(147,27,'session_setting',NULL,'session_setting','sessions',3,'(\'session_setting\', \'can_view\')',NULL,'sessions','index,edit','',1,'2024-05-07 16:00:03'),(148,27,'notification_setting',NULL,'notification_setting','admin/notification/setting',4,'(\'notification_setting\', \'can_view\')',NULL,'notification','setting','',1,'2024-05-07 16:00:03'),(149,27,'sms_setting',NULL,'sms_setting','smsconfig',5,'(\'sms_setting\', \'can_view\')',NULL,'smsconfig','index','',1,'2024-05-07 16:00:03'),(150,27,'email_setting',NULL,'email_setting','emailconfig',6,'(\'email_setting\', \'can_view\')',NULL,'emailconfig','index','',1,'2024-05-07 15:59:54'),(151,27,'payment_methods',NULL,'payment_methods','admin/paymentsettings',7,'(\'payment_methods\', \'can_view\')',NULL,'paymentsettings','index','',1,'2024-05-07 15:59:54'),(152,27,'print_headerfooter',NULL,'print_headerfooter','admin/print_headerfooter',8,'(\'print_header_footer\', \'can_view\')',NULL,'print_headerfooter','index','',1,'2024-05-07 15:59:54'),(153,27,'front_cms_setting',NULL,'front_cms_setting','admin/frontcms',9,'(\'front_cms_setting\', \'can_view\')',NULL,'frontcms','index','',1,'2024-05-07 15:59:54'),(154,27,'roles_permissions',NULL,'roles_permissions','admin/roles',10,'(\'superadmin\', \'can_view\')',NULL,'roles','index,permission','',1,'2024-05-07 15:59:54'),(155,27,'backup_restore',NULL,'backup_restore','admin/admin/backup',11,'(\'backup\', \'can_view\')',NULL,'admin','backup','',1,'2024-05-07 15:59:54'),(156,27,'users',NULL,'users','admin/users',14,'(\'user_status\', \'can_view\')',NULL,'users','index','',1,'2024-05-07 15:59:54'),(157,27,'languages',NULL,'languages','admin/language',12,'(\'languages\', \'can_view\')',NULL,'language','index,create','',1,'2024-05-07 15:59:54'),(158,27,'modules',NULL,'modules','admin/module',15,'(\'superadmin\', \'can_view\')',NULL,'module','index','',1,'2024-05-07 15:59:54'),(159,27,'custom_fields',NULL,'custom_fields','admin/customfield',16,'(\'custom_fields\', \'can_view\')',NULL,'customfield','index,edit','',1,'2024-05-07 15:59:54'),(160,27,'captcha_setting',NULL,'captcha_setting','admin/captcha',17,'(\'superadmin\', \'can_view\')',NULL,'captcha','index','',1,'2024-05-07 15:59:54'),(161,27,'system_fields',NULL,'system_fields','admin/systemfield',18,'(\'system_fields\', \'can_view\')',NULL,'systemfield','index','',1,'2024-05-07 15:59:54'),(162,27,'student_profile_update',NULL,'student_profile_update','student/profilesetting',19,'(\'student_profile_update\', \'can_view\')',NULL,'student','profilesetting','',1,'2024-05-07 15:59:54'),(163,27,'online_admission',NULL,'online_admission','admin/onlineadmission/admissionsetting',1,'(\'online_admission\', \'can_view\')',NULL,'onlineadmission','admissionsetting','',1,'2024-05-07 16:00:03'),(164,27,'file_types',NULL,'file_types','admin/admin/filetype',20,'(\'superadmin\', \'can_view\')',NULL,'admin','filetype','',1,'2022-07-20 12:34:30'),(165,27,'system_update',NULL,'system_update','admin/updater',22,'(\'superadmin\', \'can_view\')',NULL,'updater','index','',1,'2022-10-13 11:49:51'),(166,27,'sidebar_menu',NULL,'sidebar_menu','admin/sidemenu',21,'(\'sidebar_menu\', \'can_view\')',NULL,'sidemenu','index','',1,'2022-10-13 11:49:51'),(167,28,'online_course',NULL,'online_course','onlinecourse/course/index',1,'(\'online_course\', \'can_view\')',NULL,'course','index','',1,'2024-05-09 12:10:45'),(168,28,'offline_payment',NULL,'offline_payment','onlinecourse/offlinepayment/payment',2,'(\'online_course_offline_payment\', \'can_view\')',NULL,'offlinepayment','payment','',1,'2024-05-09 12:10:43'),(169,28,'course_category',NULL,'course_category','onlinecourse/coursecategory/categoryadd',3,'(\'course_category\', \'can_view\') || (\'course_category\', \'can_add\') || (\'course_category\', \'can_edit\') || (\'course_category\', \'can_delete\')',NULL,'coursecategory','categoryadd,categoryedit','',1,'2024-05-09 12:10:44'),(180,28,'online_course_report',NULL,'online_course_report','onlinecourse/coursereport/report',4,'(\'student_course_purchase_report\', \'can_view\') || (\'course_sell_count_report\', \'can_view\') || (\'course_trending_report\', \'can_view\') || (\'course_complete_report\', \'can_view\')  || (\'course_rating_report\', \'can_view\')  || (\'guest_report\', \'can_view\')',NULL,'coursereport','report,coursepurchase,coursesellreport,trendingreport,completereport,courseratingreport,guestlist,quizperformance','',1,'2024-05-09 12:10:43'),(181,3,'fees_discount',NULL,'fees_discount','admin/feediscount',8,'(\'fees_discount\', \'can_view\')',NULL,'feediscount','index,edit,assign','',1,'2022-08-08 06:03:27'),(182,3,'fees_carry_forward',NULL,'fees_carry_forward','admin/feesforward',9,'(\'fees_carry_forward\', \'can_view\')',NULL,'feesforward','index','',1,'2022-08-08 06:03:24'),(183,3,'fees_reminder',NULL,'fees_reminder','admin/feereminder/setting',10,'(\'fees_reminder\', \'can_view\')',NULL,'feereminder','setting','',1,'2022-08-08 06:03:21'),(184,27,'currency',NULL,'currency','admin/currency',13,'(\'currency\', \'can_view\')',NULL,'currency','index','',1,'2024-05-07 15:59:54'),(190,3,'offline_bank_payments',NULL,'offline_bank_payments','admin/offlinepayment',2,'(\'offline_bank_payments\', \'can_view\')',NULL,'offlinepayment','index','',1,'2022-08-08 06:05:29'),(191,13,'Copy Old Lessons',NULL,'copy_old_lesson','admin/lessonplan/copylesson',1,'(\'copy_old_lesson\', \'can_view\')',NULL,'lessonplan','copylesson',NULL,1,'2022-09-09 10:20:37'),(192,10,'Period Attendance','period_attendance','period_attendance','admin/subjectattendence/index',4,'(\'student_attendance\',\'can_view\')',NULL,'subjectattendence','index',NULL,1,'2024-05-06 15:03:42'),(193,10,'Period Attendance By Date','period_attendance_by_date','period_attendance_by_date','admin/subjectattendence/reportbydate',5,'(\'attendance_by_date\', \'can_view\')',NULL,'subjectattendence','reportbydate',NULL,1,'2024-05-06 15:03:42'),(197,28,'setting',NULL,'setting','onlinecourse/course/setting',5,'(\'online_course_setting\', \'can_view\')',NULL,'course','setting','',1,'2022-07-21 22:13:30'),(198,33,'overview',NULL,'overview','admin/multibranch/branch/overview',1,'(\'multi_branch_overview\', \'can_view\')',NULL,'branch','overview','',1,'2024-05-10 19:37:43'),(199,33,'report',NULL,'report','admin/multibranch/finance/index',1,'(\'multi_branch_daily_collection_report\', \'can_view\') || (\'multi_branch_payroll\', \'can_view\') || (\'multi_branch_income_report\', \'can_view\') || (\'multi_branch_expense_report\', \'can_view\') || (\'multi_branch_user_log_report\', \'can_view\')',NULL,'finance','dailycollectionreport,payroll,incomelist,expenselist,incomereport,expensereport,userlogreport,index','',1,'2024-05-10 19:38:59'),(200,33,'setting',NULL,'setting','admin/multibranch/branch',1,'(\'multi_branch_setting\', \'can_view\')',NULL,'branch','index','',1,'2022-11-15 02:45:32');

--
-- Table structure for table `sms_config`
--

CREATE TABLE `sms_config` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `api_id` varchar(100) NOT NULL,
  `authkey` varchar(100) NOT NULL,
  `senderid` varchar(100) NOT NULL,
  `contact` text,
  `username` varchar(150) DEFAULT NULL,
  `url` varchar(150) DEFAULT NULL,
  `password` varchar(150) DEFAULT NULL,
  `is_active` varchar(255) DEFAULT 'disabled',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sms_config`
--


--
-- Table structure for table `sms_template`
--

CREATE TABLE `sms_template` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `created_at` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `sms_template`
--


--
-- Table structure for table `source`
--

CREATE TABLE `source` (
  `id` int NOT NULL AUTO_INCREMENT,
  `source` varchar(100) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `source`
--


--
-- Table structure for table `staff`
--

CREATE TABLE `staff` (
  `id` int NOT NULL AUTO_INCREMENT,
  `employee_id` varchar(200) NOT NULL,
  `lang_id` int NOT NULL,
  `currency_id` int DEFAULT '0',
  `department` int DEFAULT NULL,
  `designation` int DEFAULT NULL,
  `qualification` varchar(200) NOT NULL,
  `work_exp` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `surname` varchar(200) NOT NULL,
  `father_name` varchar(200) NOT NULL,
  `mother_name` varchar(200) NOT NULL,
  `contact_no` varchar(200) NOT NULL,
  `emergency_contact_no` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `dob` date NOT NULL,
  `marital_status` varchar(100) NOT NULL,
  `date_of_joining` date DEFAULT NULL,
  `date_of_leaving` date DEFAULT NULL,
  `local_address` varchar(300) NOT NULL,
  `permanent_address` varchar(200) NOT NULL,
  `note` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `password` varchar(250) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `account_title` varchar(200) NOT NULL,
  `bank_account_no` varchar(200) NOT NULL,
  `bank_name` varchar(200) NOT NULL,
  `ifsc_code` varchar(200) NOT NULL,
  `bank_branch` varchar(100) NOT NULL,
  `payscale` varchar(200) NOT NULL,
  `basic_salary` int DEFAULT NULL,
  `epf_no` varchar(200) NOT NULL,
  `contract_type` varchar(100) NOT NULL,
  `shift` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `facebook` varchar(200) NOT NULL,
  `twitter` varchar(200) NOT NULL,
  `linkedin` varchar(200) NOT NULL,
  `instagram` varchar(200) NOT NULL,
  `resume` varchar(200) NOT NULL,
  `joining_letter` varchar(200) NOT NULL,
  `resignation_letter` varchar(200) NOT NULL,
  `other_document_name` varchar(200) NOT NULL,
  `other_document_file` varchar(200) NOT NULL,
  `user_id` int NOT NULL,
  `is_active` int NOT NULL,
  `verification_code` varchar(100) NOT NULL,
  `disable_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `employee_id` (`employee_id`),
  KEY `designation` (`designation`),
  KEY `department` (`department`),
  CONSTRAINT `staff_ibfk_1` FOREIGN KEY (`designation`) REFERENCES `staff_designation` (`id`) ON DELETE CASCADE,
  CONSTRAINT `staff_ibfk_2` FOREIGN KEY (`department`) REFERENCES `department` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff`
--

INSERT INTO `staff` VALUES (1,'9000',4,0,NULL,NULL,'','','Super Admin','','','','','','dayib12@gmail.com','2020-01-01','',NULL,NULL,'','','','','$2y$10$2iGmkv9/RcRzJnrar4QRf.xSSosJ0FiceSDWb30j5MRPLEXknlJEi','Male','','','','','','',0,'','','','','','','','','','','','Other Document','',0,1,'',NULL),(28,'1',0,0,1,1,'','','Abdulkadir Mohamed Hamid','','','','617489789','','Teacher1@qalam.so','2024-07-05','','0001-11-30','0001-11-30','','','','','$2y$10$bzBD7P51FRiabBOSTvKtV.C7V94ODPvO7RoL8u1xYaePjKJNiK3xe','Male','','','','','','',180,'','','','','','','','','','','','Other Document','',2,1,'',NULL),(29,'2',0,0,1,1,'','','Maxamed Saciid Yuusuf','','','','618558727','','Teacher2@qalam.so','2024-07-06','','0000-00-00','0000-00-00','Kaaraan - buula maaxaay','','','','$2y$10$m8/lUEL/E8E/9CxuCxAdOu/tlAGHwluxd3z7vmW235fahIWPTIc/K','Male','','','','','','',180,'','','','','','','','','','','','','',2,1,'',NULL),(30,'3',0,0,1,1,'','','Cabdicasiis Maxamed Mahdi','','','','618307614','','Teacher3@qalam.so','2024-07-07','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$uTWPaN6Fz1UkM5SulePqeuHmt7kIFDxS/qC45GtveXpPy9vMbylfK','Male','','','','','','',150,'','','','','','','','','','','','','',2,1,'',NULL),(31,'4',0,0,1,1,'','','Cabdisamad Axmed Yaasiin','','','','618366105','','Teacher4@qalam.so','2024-07-08','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$HD.3xp7qtFcLezUwsCqILevJCsxuqsYzPoRUEaLfo1K63Pi4YlDrC','Male','','','','','','',150,'','','','','','','','','','','','','',2,1,'',NULL),(32,'5',0,0,1,1,'','','Ciise Ibraahim Axmed','','','','615103671','','Teacher5@qalam.so','2024-07-09','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$qfaFhn24mh5Ns.ufRQjBTOgLYr6rWPNCe.ypvCiceUw4v00lZTxja','Male','','','','','','',180,'','','','','','','','','','','','','',2,1,'',NULL),(33,'6',0,0,1,1,'','','Cali Maxamed Muuke','','','','618002200','','Teacher6@qalam.so','2024-07-10','','0000-00-00','0000-00-00','Kaaraan - buula maaxaay','','','','$2y$10$QBsCV4Ydo8FjRVWpf5vm0OeRqyXwl8e1ePc/QYBx/4nQaBjqMCov6','Male','','','','','','',100,'','','','','','','','','','','','','',2,1,'',NULL),(34,'7',0,0,1,1,'','','Zakariye Cabdi Muxudiin','','','','616618371','','Teacher7@qalam.so','2024-07-11','','0000-00-00','0000-00-00','Kaaraan - WAJEER','','','','$2y$10$p30bzX71d0sqNtTHS8wIbeS9KX9FiVIVqiFsp.kX/CdLnJStNatQG','Male','','','','','','',80,'','','','','','','','','','','','','',2,1,'',NULL),(35,'8',0,0,1,1,'','','Ismaaciil Cumar Shuur','','','','615077488','','Teacher8@qalam.so','2024-07-12','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$ecEkOAs5im6hEyhnL9fyAOwLJGkp94sjAOkVwFRHHArBxVQV5QCxm','Male','','','','','','',150,'','','','','','','','','','','','','',2,1,'',NULL),(36,'9',0,0,1,1,'','','Maxamud Muuse Sheekh Xasan','','','','615053278','','Teacher9@qalam.so','2024-07-13','','0000-00-00','0000-00-00','Yaaqshiid - Saldhiga','','','','$2y$10$PUaT49E99H00t8gUqkvowu2wN9uJkG3o4adC/BjUeQ2m6GwWA6iNO','Male','','','','','','',180,'','','','','','','','','','','','','',2,1,'',NULL),(37,'10',0,0,1,1,'','','Saabariin Maxamed Cali','','','','619034683','','Teacher10@qalam.so','2024-07-14','','0000-00-00','0000-00-00','Kaaraan - buula maaxaay','','','','$2y$10$u7Mv/7aGjYv7hkmXuTX52.JADfPBlVmEyA8rE43MlYFkXaZsFO.iW','Female','','','','','','',70,'','','','','','','','','','','','','',2,1,'',NULL),(38,'11',0,0,1,1,'','','Shariif Macalin C/llaahi','','','','618812890','','Teacher11@qalam.so','2024-07-15','','0000-00-00','0000-00-00','Kaaraan - MAXA SH CALI','','','','$2y$10$a4XPSiMHF1r7yKgsPI2eAu52SChEkzTy5MbkTWwh3mHE1KkAZau1.','Male','','','','','','',120,'','','','','','','','','','','','','',2,1,'',NULL),(39,'12',0,0,1,1,'','','Maxamed C/llaahi Maxamed','','','','612528376','','Teacher12@qalam.so','2024-07-16','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$djDHL0khkPW1TB7vdjB5dulQytfBkfqdV0df5HR1kDRIru1UjVjYi','Male','','','','','','',150,'','','','','','','','','','','','','',2,1,'',NULL),(40,'13',0,0,1,1,'','','Muuse Maxamed Maxamud','','','','618909780','','Teacher13@qalam.so','2024-07-17','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$072W14dsXsBWUfIRaAwiau6XCIYZInZS0Ok5.vmTKYRhc8fPRW3dC','Male','','','','','','',50,'','','','','','','','','','','','','',2,1,'',NULL),(41,'14',0,0,1,1,'','','Ustaad Muuse Shuur','','','','618154522','','Teacher14@qalam.so','2024-07-18','','0000-00-00','0000-00-00','Kaaraan - Nagayle','','','','$2y$10$xMXoUWA9wusKjD2rU89Mau/LBs1.6qRdiPybp33Gj8E01PKs9sV9W','Male','','','','','','',50,'','','','','','','','','','','','','',2,1,'',NULL),(42,'15',0,0,4,2,'','','Cabdixakiin Xuseen Caamir','','','615707551','','','Nagayle@qalamsms.so','2024-05-01','Married','2024-05-01',NULL,'','','','','$2y$10$.f9qjcIX9JrCb5pgTCBpFey79wUsoCZn93NxXRfk4gHfZjcK0hjra','Male','','','','','','',0,'','','','','','','','','','','','Other Document','',0,1,'',NULL);

--
-- Table structure for table `staff_attendance`
--

CREATE TABLE `staff_attendance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `staff_id` int NOT NULL,
  `staff_attendance_type_id` int NOT NULL,
  `biometric_attendence` int DEFAULT '0',
  `qrcode_attendance` int NOT NULL DEFAULT '0',
  `biometric_device_data` text,
  `user_agent` varchar(250) DEFAULT NULL,
  `remark` varchar(200) NOT NULL,
  `is_active` int NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_staff_attendance_staff` (`staff_id`),
  KEY `FK_staff_attendance_staff_attendance_type` (`staff_attendance_type_id`),
  CONSTRAINT `FK_staff_attendance_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_staff_attendance_staff_attendance_type` FOREIGN KEY (`staff_attendance_type_id`) REFERENCES `staff_attendance_type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_attendance`
--


--
-- Table structure for table `staff_attendance_type`
--

CREATE TABLE `staff_attendance_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(200) NOT NULL,
  `key_value` varchar(200) NOT NULL,
  `is_active` varchar(50) NOT NULL,
  `for_qr_attendance` int NOT NULL DEFAULT '1',
  `long_lang_name` varchar(250) DEFAULT NULL,
  `long_name_style` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_attendance_type`
--

INSERT INTO `staff_attendance_type` VALUES (1,'Present','<b class=\"text text-success\">P</b>','yes',1,'present','label label-success','2023-12-13 10:15:57','2023-11-10'),(2,'Late','<b class=\"text text-warning\">L</b>','yes',1,'late','label label-warning','2023-12-13 10:16:01','2023-11-10'),(3,'Absent','<b class=\"text text-danger\">A</b>','yes',0,'absent','label label-danger','2023-12-13 10:16:06','2023-11-10'),(4,'Half Day','<b class=\"text text-warning\">F</b>','yes',1,'half_day','label label-info','2023-12-14 12:57:07','2023-11-10'),(5,'Holiday','H','yes',0,'holiday','label label-warning text-dark','2023-12-13 10:16:17','2023-11-10');

--
-- Table structure for table `staff_designation`
--

CREATE TABLE `staff_designation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `designation` varchar(200) NOT NULL,
  `is_active` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_designation`
--

INSERT INTO `staff_designation` VALUES (1,'Teachers','yes'),(2,'Admin','yes'),(3,'Accountant','yes'),(4,'Receptionist','yes'),(5,'Principal','yes'),(6,'Librarian','yes');

--
-- Table structure for table `staff_id_card`
--

CREATE TABLE `staff_id_card` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `school_name` varchar(255) NOT NULL,
  `school_address` varchar(255) NOT NULL,
  `background` varchar(100) NOT NULL,
  `logo` varchar(100) NOT NULL,
  `sign_image` varchar(100) NOT NULL,
  `header_color` varchar(100) NOT NULL,
  `enable_vertical_card` int NOT NULL DEFAULT '0',
  `enable_staff_role` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_staff_id` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_staff_department` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_designation` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_name` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_fathers_name` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_mothers_name` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_date_of_joining` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_permanent_address` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_staff_dob` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_staff_phone` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `enable_staff_barcode` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  `status` tinyint(1) NOT NULL COMMENT '0=disable,1=enable',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_id_card`
--

INSERT INTO `staff_id_card` VALUES (1,'Sample Staff ID Card Horizontal','Mount Carmel School','110 Kings Street, CA','background1.png','logo1.png','sign1.png','#9b1818',0,0,1,0,0,1,1,1,1,1,1,1,0,1),(2,'Sample Staff ID Card Vertical','Mount Carmel School','110 Kings Street, CA','background1.png','logo1.png','sign1.png','#9b1818',1,0,1,0,0,1,1,1,1,1,1,1,0,1);

--
-- Table structure for table `staff_leave_details`
--

CREATE TABLE `staff_leave_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int NOT NULL,
  `leave_type_id` int NOT NULL,
  `alloted_leave` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_staff_leave_details_staff` (`staff_id`),
  KEY `FK_staff_leave_details_leave_types` (`leave_type_id`),
  CONSTRAINT `FK_staff_leave_details_leave_types` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_staff_leave_details_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_leave_details`
--

INSERT INTO `staff_leave_details` VALUES (13,1,1,''),(14,1,2,''),(15,1,3,''),(16,1,4,''),(17,28,3,''),(18,28,1,''),(19,28,2,''),(20,28,4,''),(21,42,1,''),(22,42,2,''),(23,42,3,''),(24,42,4,'');

--
-- Table structure for table `staff_leave_request`
--

CREATE TABLE `staff_leave_request` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int NOT NULL,
  `leave_type_id` int NOT NULL,
  `leave_from` date NOT NULL,
  `leave_to` date NOT NULL,
  `leave_days` int NOT NULL,
  `employee_remark` varchar(200) NOT NULL,
  `admin_remark` varchar(200) NOT NULL,
  `status` varchar(50) NOT NULL,
  `applied_by` int DEFAULT NULL,
  `document_file` varchar(200) NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `FK_staff_leave_request_staff` (`staff_id`),
  KEY `FK_staff_leave_request_leave_types` (`leave_type_id`),
  KEY `applied_by` (`applied_by`),
  CONSTRAINT `FK_staff_leave_request_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `staff_leave_request_ibfk_1` FOREIGN KEY (`applied_by`) REFERENCES `staff` (`id`) ON DELETE CASCADE,
  CONSTRAINT `staff_leave_request_ibfk_2` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_leave_request`
--


--
-- Table structure for table `staff_payroll`
--

CREATE TABLE `staff_payroll` (
  `id` int NOT NULL AUTO_INCREMENT,
  `basic_salary` int NOT NULL,
  `pay_scale` varchar(200) NOT NULL,
  `grade` varchar(50) NOT NULL,
  `is_active` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `staff_payroll`
--


--
-- Table structure for table `staff_payslip`
--

CREATE TABLE `staff_payslip` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int NOT NULL,
  `basic` float(10,2) NOT NULL,
  `total_allowance` float(10,2) NOT NULL,
  `total_deduction` float(10,2) NOT NULL,
  `leave_deduction` int NOT NULL,
  `tax` varchar(200) NOT NULL,
  `net_salary` float(10,2) NOT NULL,
  `status` varchar(100) NOT NULL,
  `month` varchar(200) NOT NULL,
  `year` varchar(200) NOT NULL,
  `payment_mode` varchar(200) NOT NULL,
  `payment_date` date NOT NULL,
  `remark` varchar(200) NOT NULL,
  `generated_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `FK_staff_payslip_staff` (`staff_id`),
  CONSTRAINT `FK_staff_payslip_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
