REM INSERTING into SCHOOL_USERS
SELECT * FROM SCHOOL;
SET DEFINE OFF;
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'ADMINISTRATOR',null,'ADMINISTRATOR','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','administrator','$2y$10$nPAtz1Jw4Ds6zlRg1OoXQ.pwFX/xGBhsHd93AOldTO8m351VWL1GC','SYSADMIN',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'REGISTRAR',null,'REGISTRAR','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','registrar','$2y$10$Iuh7SGl4iJhm1l5.Jfu8sO2bVJFEU3kbdCW/yFsHLBPeHJm1YW0L.','REGISTRA',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'FINANCE',null,'FINANCE','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','finance','$2y$10$Vik6bvRgtnwi3D/RBoWmh.YUCnd2oCU3QgHxOQb6xglIVtgpxneeS','FINANCE',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'ADMIN',null,'ADMIN','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','admin','ChangePassword','ADMINISTRATOR',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'TEACHER',null,'TEACHER','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','teacher','$2y$10$Iuh7SGl4iJhm1l5.Jfu8sO2bVJFEU3kbdCW/yFsHLBPeHJm1YW0L.','TEACHER',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'PRINCIPAL',null,'PRINCIPAL','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','principal','$2y$10$Iuh7SGl4iJhm1l5.Jfu8sO2bVJFEU3kbdCW/yFsHLBPeHJm1YW0L.','PRINCIPAL',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');
Insert into SCHOOL_USERS (S_ID,FIRSTNAME,MIDDLENAME,LASTNAME,DOB,GENDER,ADDRESS,MOBILE,WORK,EMAIL,USERNAME,PASSWORD,RIGHTS,CREATE_DT,STATUS) values (3,'AGENT',null,'AGENT','2000-02-08','MALE','BRUSUBI',3362056,3362056,'abjobarteh@niftyict.com','agent','$2y$10$Iuh7SGl4iJhm1l5.Jfu8sO2bVJFEU3kbdCW/yFsHLBPeHJm1YW0L.','AGENT',to_date('12-SEP-24','DD-MON-RR'),'ACTIVE');

commit;