pixous.lk database

INSERT INTO `cdr` ( `calldate` , `clid` , `src` , `dst` , `dcontext` , `channel` , `dstchannel` , `lastapp` , `lastdata` , `duration` , `billsec` , `disposition` , `amaflags` , `accountcode` , `uniqueid` , `userfield` , `did` , `recordingfile` , `cnum` , `cnam` , `outbound_cnum` , `outbound_cnam` , `dst_cnam` , `linkedid` , `peeraccount` , `sequence` , `id` ) VALUES     INSERT INTO `PROFILE` ( `PROFILE_ID` , `CREATED_BY` , `CREATED_DATE` , `MODIFIED_BY` , `MODIFIED_DATE` , `DOB` , `EMAIL` , `FIRST_NAME` , `GENDER` , `HOME_NUMBER` , `INDEX_NUMBER` , `LAST_NAME` , `MIDDLE_NAME` , `MOBILE_NUMBER` , `OCCUPATION` , `PROFILE_TYPE` , `RELIGION` , `USER_ID` ) VALUES

INSERT INTO `PROFILE` ( `PROFILE_ID` , `CREATED_BY` , `CREATED_DATE` , `MODIFIED_BY` , `MODIFIED_DATE` , `DOB` , `EMAIL` , `FIRST_NAME` , `GENDER` , `HOME_NUMBER` , `INDEX_NUMBER` , `LAST_NAME` , `MIDDLE_NAME` , `MOBILE_NUMBER` , `OCCUPATION` , `PROFILE_TYPE` , `RELIGION` , `USER_ID` ) VALUES ( 1 , NULL , NULL , 'SYSTEM' , '2021-11-17 14:54:45' , '1993-08-19' , 'admin@ .com' , 'Test' , 'MALE' , '0775186640' , 'N/A' , 'User' , 'Admin' , '0775186640' , 'Engineer' , 'USER' , 'BUDDHIST' , 1 ), ( 2 , 'SYSTEM' , '2021-07-18 12:22:26' , 'SYSTEM' , '2021-07-18 12:22:26' , '2018-02-09' , ' student1@agportal.com ' , 'Santhul' , 'MALE' , NULL , '17/PNK/5296' , 'Hettige' , NULL , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 3 , 'SYSTEM' , '2021-07-18 13:39:47' , 'SYSTEM' , '2021-07-18 13:39:47' , '2018-02-09' , ' student2@agportal.com ' , 'H.M.Sayuni' , 'MALE' , NULL , '17/PNK/5244' , 'Ranasinghe' , NULL , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 4 , 'SYSTEM' , '2021-07-18 13:40:27' , 'SYSTEM' , '2021-07-18 13:40:27' , '2018-02-09' , ' student3@agportal.com ' , 'Rusandu' , 'MALE' , NULL , '17/PNK/4976' , 'Gamage' , 'Kithnuka' , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 5 , 'SYSTEM' , '2021-07-28 23:50:38' , 'SYSTEM' , '2021-07-28 23:50:38' , '2021-07-28' , ' k.thisara@gmail.com ' , 'Test' , 'MALE' , '0775186640' , 'NA' , 'Guardian' , NULL , '0775186640' , 'Naaa' , 'GUARDIAN' , 'BUDDHIST' , 3 ), ( 6 , 'SYSTEM' , '2021-07-29 15:16:34' , 'SYSTEM' , '2021-07-29 15:16:34' , '2018-02-09' , ' student11@agportal.com ' , 'W.Thenushi' , 'MALE' , NULL , '18/PNK/5380' , 'Botheju' , 'Ahansa' , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 7 , 'SYSTEM' , '2021-07-29 15:30:31' , 'SYSTEM' , '2021-07-29 15:30:31' , '2018-02-09' , ' student12@agportal.com ' , 'H.' , 'MALE' , NULL , '18/PNK/5381' , 'Deyoni' , 'Nivethma' , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 11 , 'SYSTEM' , '2021-08-25 22:09:20' , 'SYSTEM' , '2021-08-25 22:09:20' , '2021-08-25' , ' urasika@gmail.com ' , 'Rasika' , 'MALE' , '0773732019' , 'NA' , 'Udagama' , NULL , '0773732019' , 'Web Administrator' , 'GUARDIAN' , 'BUDDHIST' , 6 ), ( 9 , 'SYSTEM' , '2021-08-17 19:23:10' , 'SYSTEM' , '2021-08-17 19:23:10' , '2018-02-09' , ' student18@agportal.com ' , 'Binuga' , 'MALE' , NULL , '18/PNK/5440' , 'Athukatiyawaththa' , 'Sithew' , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 10 , 'SYSTEM' , '2021-08-24 11:39:54' , 'SYSTEM' , '2021-08-24 11:39:54' , '2021-08-24' , ' maxpriyamal@gmail.com ' , 'Test' , 'MALE' , '0775186640' , 'NA' , 'Guardian' , NULL , '0775186640' , 'Naaa' , 'GUARDIAN' , 'BUDDHIST' , 5 ), ( 12 , 'SYSTEM' , '2021-08-25 22:41:48' , 'SYSTEM' , '2021-08-25 22:41:48' , '2018-02-09' , ' student23@agportal.com ' , 'Thenu' , 'MALE' , NULL , '18/PNK/5463' , 'Abeywickrama' , 'Akenya' , NULL , NULL , 'STUDENT' , 'BUDDHIST' , NULL ), ( 13 , 'SYSTEM' , '2021-08-27 14:15:28' , 'SYSTEM' , '2021-08-27 14:15:28' , '2021-08-27' , ' admin@daraka.lk ' , 'Test' , 'MALE' , '0771010064' , 'NA' , 'Guardian3' , NULL , '0771010064' , '' , 'GUARDIAN' , 'BUDDHIST' , 7 ), ( 14 , 'SYSTEM' , '2021-08-30 11:27:36' , 'SYSTEM' , '2021-08-30 11:27:36' , '2021-08-30' , ' malithadiss@gmail.com ' , 'Malitha' , 'MALE' , '0772643355' , 'NA' , 'Dissanayake' , NULL , '0772643355' , '' , 'GUARDIAN' , 'BUDDHIST' , 8 ), INSERT INTO `cdr` ( `calldate` , `clid` , `src` , `dst` , `dcontext` , `channel` , `dstchannel` , `lastapp` , `lastdata` , `duration` , `billsec` , `disposition` , `amaflags` , `accountcode` , `uniqueid` , `userfield` , `did` , `recordingfile` , `cnum` , `cnam` , `outbound_cnum` , `outbound_cnam` , `dst_cnam` , `linkedid` , `peeraccount` , `sequence` , `id` ) VALUES ( '2021-03-10 09:26:10' , '\"Manori\" <407>' , '407' , '0112832597' , 'from-internal' , 'PJSIP/407-000009e9' , 'PJSIP/Dialog-000009ea' , 'Dial' , 'PJSIP/0112832597@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 39 , 0 , 'NO ANSWER' , 3 , '' , '1615348570.2737' , '' , '' , '' , '407' , 'Manori' , '407' , 'Manori' , '' , '1615348570.2737' , '' , 2941 , 15066 ), ( '2021-03-10 09:28:09' , '\"117609400\" <117609400>' , '117609400' , 's' , 'ivr-3' , 'PJSIP/Dialog-000009ee' , '' , 'BackGround' , 'custom/Aayubowan&custom/Menu' , 7 , 7 , 'ANSWERED' , 3 , '' , '1615348689.2742' , '' , '0117121600' , '' , '' , '' , '' , '' , '' , '1615348689.2742' , '' , 2946 , 15067 ), ( '2021-03-10 09:28:27' , '\"117609400\" <117609400>' , '117609400' , 's' , 'ivr-3' , 'PJSIP/Dialog-000009ef' , '' , 'BackGround' , 'custom/Aayubowan&custom/Menu' , 4 , 4 , 'ANSWERED' , 3 , '' , '1615348707.2743' , '' , '0117121600' , '' , '' , '' , '' , '' , '' , '1615348707.2743' , '' , 2947 , 15068 ), ( '2021-03-10 09:27:00' , '\"Ramal\" <420>' , '420' , '0117520000' , 'from-internal' , 'PJSIP/420-000009ec' , 'PJSIP/Dialog-000009ed' , 'Dial' , 'PJSIP/0117520000@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 106 , 106 , 'ANSWERED' , 3 , '' , '1615348620.2740' , '' , '' , '' , '420' , 'Ramal' , '420' , 'Ramal' , '' , '1615348620.2740' , '' , 2944 , 15069 ), ( '2021-03-10 09:29:18' , '\"117609400\" <117609400>' , '117609400' , 's' , 'ivr-3' , 'PJSIP/Dialog-000009f0' , '' , 'BackGround' , 'custom/Aayubowan&custom/Menu' , 3 , 3 , 'ANSWERED' , 3 , '' , '1615348758.2744' , '' , '0117121600' , '' , '' , '' , '' , '' , '' , '1615348758.2744' , '' , 2948 , 15070 ), ( '2021-03-10 09:37:03' , '\"Thisala\" <410>' , '410' , '430' , 'ext-local' , 'PJSIP/410-000009f3' , 'PJSIP/430-000009f4' , 'Dial' , 'PJSIP/430/sip:430@ .168.1.160:2048;line=zxmssfnd,,HhTtrb(func-apply-sipheader' , 6 , 4 , 'ANSWERED' , 3 , '' , '1615349223.2747' , '' , '' , '' , '410' , 'Thisala' , '' , '' , '' , '1615349223.2747' , '' , 2951 , 15071 ), ( '2021-03-10 09:37:10' , '\"Sachith\" <434>' , '434' , '0117100600' , 'from-internal' , 'PJSIP/434-000009f5' , 'PJSIP/Dialog-000009f6' , 'Dial' , 'PJSIP/0117100600@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 6 , 0 , 'NO ANSWER' , 3 , '' , '1615349230.2749' , '' , '' , '' , '434' , 'Sachith' , '434' , 'Sachith' , '' , '1615349230.2749' , '' , 2953 , 15072 ), ( '2021-03-10 09:37:40' , '\"Sachith\" <434>' , '434' , '0712789716' , 'from-internal' , 'PJSIP/434-000009f7' , 'PJSIP/Dialog-000009f8' , 'Dial' , 'PJSIP/0712789716@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 109 , 79 , 'ANSWERED' , 3 , '' , '1615349260.2751' , '' , '' , '' , '434' , 'Sachith' , '434' , 'Sachith' , '' , '1615349260.2751' , '' , 2955 , 15073 ), ( '2021-03-10 09:42:21' , '\"Thushari\" <409>' , '409' , '0117640104' , 'from-internal' , 'PJSIP/409-000009f9' , 'PJSIP/Dialog-000009fa' , 'Dial' , 'PJSIP/0117640104@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 53 , 48 , 'ANSWERED' , 3 , '' , '1615349541.2753' , '' , '' , '' , '409' , 'Thushari' , '409' , 'Thushari' , '' , '1615349541.2753' , '' , 2957 , 15074 ), ( '2021-03-10 09:47:14' , '\"Manori\" <407>' , '407' , '117592866' , 'from-internal' , 'PJSIP/407-000009fb' , 'PJSIP/Dialog-000009fc' , 'Dial' , 'PJSIP/0117592866@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 19 , 14 , 'ANSWERED' , 3 , '' , '1615349834.2755' , '' , '' , '' , '407' , 'Manori' , '407' , 'Manori' , '' , '1615349834.2755' , '' , 2959 , 15075 ), ( '2021-03-10 09:47:38' , '\"Vinod\" <431>' , '431' , '0117959359' , 'from-internal' , 'PJSIP/431-000009fd' , 'PJSIP/Dialog-000009fe' , 'Dial' , 'PJSIP/0117959359@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 10 , 9 , 'ANSWERED' , 3 , '' , '1615349858.2757' , '' , '' , '' , '431' , 'Vinod' , '431' , 'Vinod' , '' , '1615349858.2757' , '' , 2961 , 15076 ), ( '2021-03-10 09:47:39' , '\"Thushari\" <409>' , '409' , '407' , 'ext-local' , 'PJSIP/409-000009ff' , 'PJSIP/407-00000a00' , 'Dial' , 'PJSIP/407/sip:407@ .168.1.184:5060,,HhTtrb(func-apply-sipheaders^s^1)' , 27 , 24 , 'ANSWERED' , 3 , '' , '1615349859.2759' , '' , '' , '' , '409' , 'Thushari' , '' , '' , '' , '1615349859.2759' , '' , 2963 , 15077 ), ( '2021-03-10 09:47:57' , '\"Thisala\" <410>' , '410' , '0117592866' , 'from-internal' , 'PJSIP/410-00000a01' , 'PJSIP/Dialog-00000a02' , 'Dial' , 'PJSIP/0117592866@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 17 , 12 , 'ANSWERED' , 3 , '' , '1615349877.2761' , '' , '' , '' , '410' , 'Thisala' , '410' , 'Thisala' , '' , '1615349877.2761' , '' , 2965 , 15078 ), ( '2021-03-10 09:49:00' , '\"Vinod\" <431>' , '431' , '0117959359' , 'from-internal' , 'PJSIP/431-00000a03' , 'PJSIP/Dialog-00000a04' , 'Dial' , 'PJSIP/0117959359@ ,300,Tb(func-apply-sipheaders^s^1,(1))U(sub-send-obroute' , 9 , 8 , 'ANSWERED' , 3 , '' , '1615349940.2763' , '' , '' , '' , '431' , 'Vinod' , '431' , 'Vinod' , '' , '1615349940.2763' , '' , 2967 , 15079 ),