DROP TABLE admin_commendation;

CREATE TABLE `admin_commendation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accno` int(11) DEFAULT NULL,
  `contractid` int(11) DEFAULT NULL,
  `comd_date` int(11) DEFAULT NULL,
  `description` mediumtext,
  `empid` varchar(25) DEFAULT NULL,
  `empname` varchar(50) DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `comd_status` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `comdn_idx` (`accno`,`contractid`,`comd_date`,`empid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE admin_minsmtg;

CREATE TABLE `admin_minsmtg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rfm_id` int(11) DEFAULT NULL,
  `mdfiled` int(11) DEFAULT NULL,
  `minutes` mediumtext,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `agency_rep` varchar(50) DEFAULT NULL,
  `rep_esign` varchar(50) DEFAULT NULL,
  `client_rep` varchar(50) DEFAULT NULL,
  `client_esign` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `minsmtg_idx` (`rfm_id`,`mdfiled`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO admin_minsmtg VALUES("1","3064","1569600000","Sample minutes of meeting
and plus
others
topics agenda
and more","1569643200","1569646800","misael","","joseph","");
INSERT INTO admin_minsmtg VALUES("2","3064","1581868800","test minutes","1581955200","0","automatic","","automatic","");



DROP TABLE admin_req_hdr;

CREATE TABLE `admin_req_hdr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agency` varchar(50) DEFAULT NULL,
  `accno` int(11) DEFAULT NULL,
  `contract_id` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `reqtime` int(11) DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `istatus` varchar(25) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `reqhdr_idx` (`agency`,`accno`,`contract_id`,`reqdate`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

INSERT INTO admin_req_hdr VALUES("1","GSIA","10","10","1569254400","1569297120","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("2","GSIA","10","10","1569254400","1569298560","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("3","GSIA","98","456","1569254400","1569303420","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("4","GSIA","10","10","1569254400","1569329340","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("5","GSIA","28","22","1569340800","1569423540","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("6","GSIA","98","456","1569340800","1569423840","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("7","GSIA","10","10","1569427200","1569455340","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("8","GSIA","98","456","1569427200","1569461040","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("9","GSIA","98","456","1569859200","1569939540","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("10","GSIA","28","22","1569859200","1569940020","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("11","GSIA","98","456","1569945600","1569982380","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("12","GSIA","10","10","1573142400","1573201200","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("13","GSIA","98","456","1573142400","1573201380","Jose Rizal","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("14","BlueFlame","28","22","1581868800","1581870300","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO admin_req_hdr VALUES("15","BlueFlame","28","22","1581868800","1581922560","albotra,Joseph Tarriela","NOT POSTED","NONE");



DROP TABLE admin_req_iscon;

CREATE TABLE `admin_req_iscon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `iscon_date` int(11) DEFAULT NULL,
  `description` mediumtext,
  `urgency` varchar(25) DEFAULT NULL,
  `iscon_status` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `reqiscon_idx` (`hdrid`,`reqno`,`iscon_date`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO admin_req_iscon VALUES("1","2","2978","1569254400","THIS IS A TEST CONCERN
more of this soon","High Priority","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("3","3","2993","1568476800","hope to finish this soon","Emergency","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("4","15","2996","1569427200","ANOTHER TEST","High Priority","RESOLVED","NONE-4");
INSERT INTO admin_req_iscon VALUES("5","15","2996","1569081600","ANOTHER TEST AGAIN","Emergency","RESOLVED","NONE-4");
INSERT INTO admin_req_iscon VALUES("6","9","3459","1569859200","Confirmation","High Priority","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("7","11","3601","1569945600","Minutes","Emergency","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("8","12","3721","1572537600","ADDITIONAL LADY GUARD","High Priority","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("9","13","3722","1572883200","RELIEVER FIVE (5) LG","Emergency","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("10","14","4636","1581436800","TEST","Emergency","PENDING","NONE");
INSERT INTO admin_req_iscon VALUES("11","15","4688","1581868800","test the qr code  now1","High Priority","PENDING","NONE");



DROP TABLE admin_req_mtg;

CREATE TABLE `admin_req_mtg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `what` mediumtext,
  `iwhere` varchar(50) DEFAULT NULL,
  `iwhen` int(11) DEFAULT NULL,
  `mtgtime` int(11) DEFAULT NULL,
  `attendees` mediumtext,
  `urgency` varchar(30) DEFAULT NULL,
  `mtg_status` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `reqmtg_idx` (`hdrid`,`reqno`,`reqdate`,`urgency`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

INSERT INTO admin_req_mtg VALUES("1","15","3060","1569427200","this is a test meeting","Head Office","1569772800","0","5~albotra , misael celis~09175110967~^^7~albotra , Joseph Tarriela~09175110967~^^","High Priority","DISAPPROVED","NONE-6-PENDING");
INSERT INTO admin_req_mtg VALUES("2","15","3064","1569427200","For testing only","Head Office","1569859200","1569455340","7~albotra , Joseph Tarriela~09175110967~^^","Emergency","APPROVED","NONE-7");
INSERT INTO admin_req_mtg VALUES("3","8","3069","1569427200","another request","Head Office","1569945600","1569461040","4~albotra , misael celis~09175110967~^^","High Priority","PENDING","NONE");
INSERT INTO admin_req_mtg VALUES("4","9","3459","1569859200","Operations","Head Office","1570204800","1569895200","SG","High Priority","PENDING","NONE");
INSERT INTO admin_req_mtg VALUES("5","10","3467","1569859200","Seminar","Site","1570291200","0","LG","High Priority","PENDING","NONE");
INSERT INTO admin_req_mtg VALUES("6","15","3721","1572796800","REQUEST FOR ADDITIONAL GUARD","Site","1574352000","0","5~albotra , misael celis~09175110967~^^","High Priority","APPROVED","NONE-12");
INSERT INTO admin_req_mtg VALUES("7","13","3722","1573228800","INCOMING SEMINAR FOR SAFETY","Head Office","1573228800","0","7~albotra , Joseph Tarriela~09175110967~^^","Emergency","PENDING","NONE");
INSERT INTO admin_req_mtg VALUES("8","15","4689","1581868800","pilot test","Head Office","1581868800","0","8~Jardio , Omar ~09165684608~^^9~Vasquez , Art ~09178892808~^^","High Priority","PENDING","NONE");



DROP TABLE app_foto;

CREATE TABLE `app_foto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datetaken` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `appmod` varchar(30) DEFAULT NULL,
  `findex` mediumtext,
  `filetype` varchar(50) DEFAULT NULL,
  `filesize` bigint(20) DEFAULT NULL,
  `i_status` varchar(20) DEFAULT NULL,
  `userid` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `appfoto_idx` (`userid`,`refno`,`datetaken`,`appmod`)
) ENGINE=InnoDB AUTO_INCREMENT=802 DEFAULT CHARSET=latin1;

INSERT INTO app_foto VALUES("758","1551283200","2034","OPRNS","9801BBDA-CB23-43CA-8E77-BA391E142D8B.jpeg","","450","NOT POSTED","5");
INSERT INTO app_foto VALUES("759","1553788800","2081","OPRNS","image.jpg","","2000","NOT POSTED","5");
INSERT INTO app_foto VALUES("760","1556553600","3897","OPRNS","1S_R2_07.jpg","","1450","NOT POSTED","7");
INSERT INTO app_foto VALUES("767","1551283200","456","asdf","1S_R2_07-3.jpg","hjh","2000","NOT POSTED","5");
INSERT INTO app_foto VALUES("773","1553788800","457","asdf","image2.jpg","dfg","1000","NOT POSTED","5");
INSERT INTO app_foto VALUES("774","1576191600","3897","OPRNS","Free_Sample_By_Wix.jpg","image/jpeg","6511","NOT POSTED","0");
INSERT INTO app_foto VALUES("775","1576191600","3897","OPRNS","BF.jpeg","image/jpeg","44128","NOT POSTED","0");
INSERT INTO app_foto VALUES("776","1576191600","3901","OPRNS","Koala.jpg","image/jpeg","780831","NOT POSTED","0");
INSERT INTO app_foto VALUES("777","1576191600","3897","OPRNS","Jellyfish.jpg","image/jpeg","775702","NOT POSTED","0");
INSERT INTO app_foto VALUES("778","1576278000","3099","CUSTMGT","BlueFlame.pdf","application/pdf","348798","NOT POSTED","0");
INSERT INTO app_foto VALUES("779","1576278000","3106","CUSTMGT","GSIA.pdf","application/pdf","341458","NOT POSTED","0");
INSERT INTO app_foto VALUES("780","1576278000","3009","CUSTMGT","OperationsUML.pdf","application/pdf","55107","NOT POSTED","0");
INSERT INTO app_foto VALUES("781","1576278000","3921","CUSTMGT","SecurityMod_UML.pdf","application/pdf","67195","NOT POSTED","0");
INSERT INTO app_foto VALUES("782","1576278000","3921","CUSTMGT","WiSI Technical Diagram.pdf","application/pdf","59483","NOT POSTED","0");
INSERT INTO app_foto VALUES("784","1581548400","4423","OPRNS","27143998857700l.jpg","image/jpeg","105454","NOT POSTED","7");
INSERT INTO app_foto VALUES("785","1581548400","4423","OPRNS","archer.gif","image/gif","1581","NOT POSTED","7");
INSERT INTO app_foto VALUES("786","1581634800","4493","OPRNS_EQPT_FDGS","image.jpg","image/jpeg","1653873","NOT POSTED","7");
INSERT INTO app_foto VALUES("788","1581609600","4493","OPRNS_EQPT_FDGS","1-4493-OPRNS_EQPT_FDGS-image.jpg","image/jpeg","1772770","NOT POSTED","7");
INSERT INTO app_foto VALUES("789","1581609600","4496","OPRNS_EQPT_FDGS","image.jpg","image/jpeg","1536824","NOT POSTED","7");
INSERT INTO app_foto VALUES("793","1581609600","4489","OPRNS_EQPT_FDGS","6-4489-OPRNS_EQPT_FDGS-image.jpg","image/jpeg","1141525","NOT POSTED","7");
INSERT INTO app_foto VALUES("794","1581609600","4489","OPRNS_EQPT_FDGS","7-4489-OPRNS_EQPT_FDGS-image.jpg","image/jpeg","1233563","NOT POSTED","7");
INSERT INTO app_foto VALUES("795","1581609600","4499","OPRNS_MPWR_IFDGS","8-4499-OPRNS_MPWR_IFDGS-image.jpg","image/jpeg","1443280","NOT POSTED","7");
INSERT INTO app_foto VALUES("796","1581609600","4499","OPRNS_EQPT_FDGS","9-4499-OPRNS_EQPT_FDGS-image.jpg","image/jpeg","1345711","NOT POSTED","7");
INSERT INTO app_foto VALUES("797","1581609600","4499","OPRNS_OPPLN_FDGS","11-4499-OPRNS_OPPLN_FDGS-image.jpg","image/jpeg","1428942","NOT POSTED","7");
INSERT INTO app_foto VALUES("798","1581609600","4499","OPRNS_TRG_FDGS","12-4499-OPRNS_TRG_FDGS-image.jpg","image/jpeg","1629930","NOT POSTED","7");
INSERT INTO app_foto VALUES("799","1581609600","3362","OPRNS_MPWR_IFDGS","13-3362-OPRNS_MPWR_IFDGS-image.jpg","image/jpeg","1565633","NOT POSTED","7");
INSERT INTO app_foto VALUES("800","1593014400","5218","OPRNS_TRG_FDGS","15-5218-OPRNS_TRG_FDGS-2.gif","image/gif","8153","NOT POSTED","7");
INSERT INTO app_foto VALUES("801","1593014400","5218","OPRNS_TRG_FDGS","16-5218-OPRNS_TRG_FDGS-3.jpg","image/jpeg","4049","NOT POSTED","7");



DROP TABLE contract_rsrcs;

CREATE TABLE `contract_rsrcs` (
  `id` int(2) unsigned NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `mp_officer` int(7) DEFAULT NULL,
  `mp_guards` int(7) DEFAULT NULL,
  `mp_others` int(7) DEFAULT NULL,
  `eqpt_fa` int(7) DEFAULT NULL,
  `eqpt_dtctr` int(7) DEFAULT NULL,
  `eqpt_comsurv` int(7) DEFAULT NULL,
  `eqpt_transpo` int(7) DEFAULT NULL,
  `eqpt_telco` int(7) DEFAULT NULL,
  `eqpt_ee` int(7) DEFAULT NULL,
  `eqpt_oee` int(7) DEFAULT NULL,
  `eqpt_others` int(7) DEFAULT NULL,
  `trg_list` varchar(100) DEFAULT NULL,
  `vi_as` int(7) DEFAULT NULL,
  `vi_asviu` varchar(25) DEFAULT NULL,
  `vi_tm` int(7) DEFAULT NULL,
  `vi_tmviu` varchar(25) DEFAULT NULL,
  `note` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contractrsrcs` (`contract_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

INSERT INTO contract_rsrcs VALUES("2","3191","2","20","0","10","2","2","1","2","1","0","1","ue10^^ue11^^","3","Quarterly","1","Yearly","none");
INSERT INTO contract_rsrcs VALUES("4","3005","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("5","3009","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("6","3011","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("7","3043","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("8","3045","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("9","3049","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("10","3056","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("11","3065","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("12","3108","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("13","3063","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("14","3113","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("15","3058","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("16","3062","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("17","3109","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("18","3107","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("20","3110","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("21","3111","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");
INSERT INTO contract_rsrcs VALUES("22","3112","0","0","0","0","0","0","0","0","0","0","0","","0","","0","","none");



DROP TABLE cust_contract;

CREATE TABLE `cust_contract` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) DEFAULT NULL,
  `accno` varchar(25) DEFAULT NULL,
  `contract_id` varchar(25) DEFAULT NULL,
  `title` mediumtext,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `no_posts` int(4) DEFAULT NULL,
  `cstatus` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  `agency` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custcont_idx` (`cust_id`,`accno`,`contract_id`,`agency`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

INSERT INTO cust_contract VALUES("10","10","2027","3005","Decription","1564588800","1596124800","2","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("11","11","2028","3009","RB-MJN","1564588800","1596124800","0","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("12","12","2029","3011","LD","1564588800","1567180800","2","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("13","13","2030","3043","CONTRACT","1567267200","1598889600","2","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("14","14","2032","3045","CONTRACT","1552579200","1584201600","3","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("15","15","2033","3049","CONTRACT","1567267200","1598889600","1","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("16","16","2035","3056","Contract","1567267200","1598889600","0","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("17","92","2115","3058","CONTRACT 1","1569772800","1601395200","1","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("20","93","2116","3062","CONTRACT 2","1569859200","1601481600","2","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("21","43","2065","3063","SAMPLE CONTRACT","1572796800","1604332800","1","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("22","28","2049","3065","SAMPLE CONTACT","1572796800","1604419200","1","ACTIVE","NONE","BlueFlame");
INSERT INTO cust_contract VALUES("23","96","2162","3107","Vcorp Contract","1577808000","1609430400","1","ACTIVE","NONE","BlueFlame");
INSERT INTO cust_contract VALUES("24","41","2063","3108","Pepsis Cabuyao","1577808000","1609430400","2","ACTIVE","NONE","BlueFlame");
INSERT INTO cust_contract VALUES("25","95","2161","3109","Pepsi Muntinlupa","1577808000","1609430400","3","ACTIVE","NONE","BlueFlame");
INSERT INTO cust_contract VALUES("26","98","2165","3110","San Buenaventura","1577808000","1609430400","4","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("27","99","2166","3111","Quezon Power","1577808000","1609430400","6","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("28","100","2167","3112","Murata","1577808000","1609430400","7","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("29","56","2078","3113","Film Pabrica","1577808000","1609430400","8","ACTIVE","NONE","GSIA");
INSERT INTO cust_contract VALUES("30","96","2162","3191","Vcorp 2","1621440000","1624377600","10","ACTIVE","NONE","BlueFlame");



DROP TABLE cust_docs;

CREATE TABLE `cust_docs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `description` mediumtext,
  `dateissued` int(11) DEFAULT NULL,
  `expiration` int(11) DEFAULT NULL,
  `dateupdated` int(11) DEFAULT NULL,
  `docstatus` varchar(25) DEFAULT NULL,
  `note` mediumtext,
  `refno` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custdocs_idx` (`contract_id`,`refno`,`expiration`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

INSERT INTO cust_docs VALUES("1","5","GDDO","test again","1567180800","1567612800","1567699200","Updated","no  non-sense","");
INSERT INTO cust_docs VALUES("2","10","LTO","License","1564588800","1596124800","1533052800","Updated","","");
INSERT INTO cust_docs VALUES("3","11","GDDO","GDDO","1564588800","1567180800","1564502400","Updated","test 123","3921");
INSERT INTO cust_docs VALUES("4","12","LTO","Driver License","1564588800","1661875200","1564588800","Updated","","");
INSERT INTO cust_docs VALUES("5","10","LTOPF","LTOPF","1564588800","1567180800","1567267200","Updated","LTOPF","");
INSERT INTO cust_docs VALUES("6","10","RSL","RSL","1564588800","1567180800","1567267200","Updated","RSL","");
INSERT INTO cust_docs VALUES("7","10","Business Permit","BP","1564588800","1567180800","1567526400","Updated","Business","");
INSERT INTO cust_docs VALUES("8","11","LTOPF","LTOPF","1567267200","1569772800","1567267200","Updated","LTOPF","");
INSERT INTO cust_docs VALUES("9","11","LTO","LTO","1564588800","1567267200","1564588800","Expired","LTO","");
INSERT INTO cust_docs VALUES("10","11","RSL","RSL","1567267200","1569772800","1567267200","Updated","RSL","");
INSERT INTO cust_docs VALUES("11","11","Business Permit","BP","1568044800","1569772800","1568044800","Updated","BP","");
INSERT INTO cust_docs VALUES("12","12","GDDO","GDDO","1561478400","1593100800","1561478400","Updated","","");
INSERT INTO cust_docs VALUES("13","12","LTOPF","LTOPF","1564070400","1595692800","1564070400","Updated","","");
INSERT INTO cust_docs VALUES("14","12","RSL","RSL","1562256000","1593878400","1562256000","Updated","","");
INSERT INTO cust_docs VALUES("15","12","Business Permit","BP","1562256000","1593878400","1562256000","Updated","","");
INSERT INTO cust_docs VALUES("16","13","GDDO","GDDO","1565798400","1597420800","1565798400","Updated","","");
INSERT INTO cust_docs VALUES("17","13","LTOPF","LTOPF","1565798400","1597420800","1565798400","Updated","","");
INSERT INTO cust_docs VALUES("18","13","LTO","LTO","1565798400","1597420800","1565798400","Updated","","");
INSERT INTO cust_docs VALUES("19","13","RSL","RSL","1547481600","1579017600","1547481600","Updated","","");
INSERT INTO cust_docs VALUES("20","13","Business Permit","BP","1552579200","1584201600","1552579200","Updated","","");
INSERT INTO cust_docs VALUES("21","14","GDDO","GDDO","1555257600","1586880000","1555257600","Updated","","");
INSERT INTO cust_docs VALUES("22","14","LTOPF","LTOPF","1552579200","1584201600","1555257600","Updated","","");
INSERT INTO cust_docs VALUES("23","14","LTO","LTO","1555257600","1586880000","1555257600","Updated","","");
INSERT INTO cust_docs VALUES("24","14","RSL","RSL","1555257600","1586880000","1555257600","Updated","","");
INSERT INTO cust_docs VALUES("25","14","Business Permit","BP","1555257600","1586880000","1555257600","Updated","","");
INSERT INTO cust_docs VALUES("26","20","GDDO","GDDO","1572796800","1604505600","1572537600","Updated","UPDATED","");
INSERT INTO cust_docs VALUES("27","20","LTOPF","LTOPF","1572796800","1573401600","1573142400","Expired","RENEWAL","");
INSERT INTO cust_docs VALUES("28","20","LTO","LTO","1572192000","1604073600","1572537600","Cancelled","CANCELLED","");
INSERT INTO cust_docs VALUES("29","20","RSL","RSL","1574611200","1606320000","1574006400","Updated","UPDATED","");
INSERT INTO cust_docs VALUES("30","20","Business Permit","BP","1574006400","1574265600","1572796800","Updated","UPDATED","");
INSERT INTO cust_docs VALUES("31","17","GDDO","GDDO","1575216000","1575388800","1574611200","Updated","GDDO","");
INSERT INTO cust_docs VALUES("32","17","LTOPF","LTOPF","1574006400","1574179200","1573747200","Updated","LTOPF","");
INSERT INTO cust_docs VALUES("33","17","LTO","LTO","1572796800","1573142400","1572537600","Updated","LTO","");
INSERT INTO cust_docs VALUES("34","17","RSL","RSL","1574006400","1574179200","1573747200","Updated","RSL","");
INSERT INTO cust_docs VALUES("35","17","Business Permit","BUSINESS PERMIT","1572796800","1572883200","1572451200","Updated","BUSINESS PERMIT","");
INSERT INTO cust_docs VALUES("36","16","GDDO","GDDO","1572796800","1604419200","1572796800","Updated","UPDATED","");
INSERT INTO cust_docs VALUES("37","16","LTOPF","LTOPF","1572796800","1572796800","1572537600","Expired","EXPIRED","");
INSERT INTO cust_docs VALUES("38","16","LTO","LTO","1572192000","1603814400","1572364800","Updated","UPDATED","");
INSERT INTO cust_docs VALUES("39","16","RSL","RSL","1572796800","1573660800","1572796800","Updated","UPDATED","");



DROP TABLE cust_equipments;

CREATE TABLE `cust_equipments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `ekind` varchar(40) DEFAULT NULL,
  `etype` varchar(40) DEFAULT NULL,
  `description` mediumtext,
  `qty` double DEFAULT NULL,
  `unit` varchar(20) DEFAULT NULL,
  `estatus` varchar(30) DEFAULT NULL,
  `readiness` int(2) DEFAULT NULL,
  `pms_date` int(11) DEFAULT NULL,
  `note` mediumtext,
  `refno` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custeqpt_idx` (`contract_id`,`refno`,`ekind`,`etype`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=latin1;

INSERT INTO cust_equipments VALUES("2","10","Telecommunication","DESKTOP/LAPTOP","LENOVO","1","Pcs.","Operational","1","1564588800","LENOVO","");
INSERT INTO cust_equipments VALUES("3","11","Communication and Surveillance","SEARCH LIGHT","Rechargeable","2","Pcs.","Available","1","1564934400","Working","");
INSERT INTO cust_equipments VALUES("4","12","Firearms","9MM","Short","1","Pcs.","Operational","1","1564588800","","");
INSERT INTO cust_equipments VALUES("5","11","Firearms",".38 Cal","","2","Pcs.","Operational","1","0","","");
INSERT INTO cust_equipments VALUES("6","12","Firearms","12 ga","","3","Pcs.","Operational","1","1565798400","","");
INSERT INTO cust_equipments VALUES("7","10","Firearms","5.6 mm","","5","Pcs.","Operational","1","1565020800","","");
INSERT INTO cust_equipments VALUES("8","10","Transportation","MOTORCYCLE","","3","Pcs.","Operational","1","1564848000","","");
INSERT INTO cust_equipments VALUES("9","11","Transportation","RESCUE/EMERGENCY VEHICLE/AMBULANCE","","1","Pcs.","Operational","1","1565107200","","");
INSERT INTO cust_equipments VALUES("10","12","Transportation","PATROL/BICYCLE","","7","Pcs.","Operational","1","1564329600","","");
INSERT INTO cust_equipments VALUES("11","11","Firearms","12 ga","","8","Pcs.","Operational","1","1564416000","","");
INSERT INTO cust_equipments VALUES("12","10","Detectors","SCANNER","Scanner","5","Pcs.","Operational","1","1567267200","Scanner","");
INSERT INTO cust_equipments VALUES("13","10","Communication and Surveillance","SEARCH LIGHT","SL","10","Pcs.","Operational","1","1567267200","SL","");
INSERT INTO cust_equipments VALUES("14","10","Detectors","WALK THROUGH","Walk Through","5","Pcs.","Operational","1","1567612800","WT","");
INSERT INTO cust_equipments VALUES("17","10","Detectors","HANDHELD","Handheld","5","Pcs.","Operational","1","1567699200","Handheld","");
INSERT INTO cust_equipments VALUES("18","10","Communication and Surveillance","CCTV","CCTV","9","Pcs.","Operational","1","1568217600","CCTV","");
INSERT INTO cust_equipments VALUES("19","10","Emergency Equipments","First Aid Kit","FAK","5","Pcs.","Operational","1","1567440000","FAK","");
INSERT INTO cust_equipments VALUES("20","10","Emergency Equipments","Fire Extinguisher","Fire Extinguisher","14","Pcs.","Operational","1","1564588800","FE","");
INSERT INTO cust_equipments VALUES("21","10","Firearms",".38 Cal","Cal","4","Pcs.","Operational","1","1561996800","Cal","");
INSERT INTO cust_equipments VALUES("22","10","Firearms","12 ga","Shot Gun","5","Pcs.","Operational","1","1566230400","Shot Gun","");
INSERT INTO cust_equipments VALUES("23","11","Detectors","WALK THROUGH","WALK","2","Pcs.","Operational","1","1567267200","WT","");
INSERT INTO cust_equipments VALUES("24","11","Detectors","HANDHELD","HAND","3","Pcs.","Operational","1","1567699200","HAND","");
INSERT INTO cust_equipments VALUES("25","11","Detectors","SCANNER","SCAN","5","Pcs.","Operational","1","1565020800","SCAN","");
INSERT INTO cust_equipments VALUES("26","11","Telecommunication","DESKTOP/LAPTOP","ASUS","3","Set","Operational","1","1562083200","ASUS","");
INSERT INTO cust_equipments VALUES("27","11","Telecommunication","MOBILE PHONE","SAMSUNG","2","Pcs.","Available","1","1566748800","SAMSUNG","");
INSERT INTO cust_equipments VALUES("28","12","Detectors","WALK THROUGH","WT","2","Set","Operational","1","1564416000","WT","");
INSERT INTO cust_equipments VALUES("29","12","Detectors","HANDHELD","HH","5","Pcs.","Operational","1","1564502400","HH","");
INSERT INTO cust_equipments VALUES("30","12","Communication and Surveillance","GUARD TOUR SYSTEM","GTS","2","Pcs.","Operational","1","1564934400","GTS","");
INSERT INTO cust_equipments VALUES("31","12","Transportation","PATROL/BICYCLE","P/T","7","Pcs.","Operational","1","1564243200","P/B","");
INSERT INTO cust_equipments VALUES("32","12","Telecommunication","INTERNET CONNECTION","IC","2","Set","Operational","1","1562428800","IC","");
INSERT INTO cust_equipments VALUES("33","12","Emergency Equipments","PPES","PPES","1","Set","Operational","1","1561824000","PPES","");
INSERT INTO cust_equipments VALUES("34","13","Firearms","9MM","9MM","4","Pcs.","Operational","1","1549036800","9MM","");
INSERT INTO cust_equipments VALUES("35","13","Detectors","SCANNER","SCANNER","4","Pcs.","Operational","1","1549382400","","");
INSERT INTO cust_equipments VALUES("36","13","Communication and Surveillance","SEARCH LIGHT","SL","5","Pcs.","Operational","1","1562860800","","");
INSERT INTO cust_equipments VALUES("37","13","Transportation","MOTORCYCLE","SINGLE","5","Pcs.","Operational","1","1559404800","","");
INSERT INTO cust_equipments VALUES("38","13","Telecommunication","DESKTOP/LAPTOP","LENOVO","5","Set","Operational","1","1563724800","","");
INSERT INTO cust_equipments VALUES("39","13","Emergency Equipments","First Aid Kit","FAD","5","Pcs.","Operational","1","1567440000","","");
INSERT INTO cust_equipments VALUES("40","14","Firearms","9MM","9MM","12","Pcs.","Operational","1","1553184000","","");
INSERT INTO cust_equipments VALUES("41","14","Detectors","HANDHELD","HAND","23","Pcs.","Operational","1","1551369600","","");
INSERT INTO cust_equipments VALUES("42","14","Communication and Surveillance","BASE RADIO","BASE","12","Pcs.","Operational","1","1554393600","","");
INSERT INTO cust_equipments VALUES("43","14","Transportation","SEGWAY/ATV","ATV","3","Pcs.","Operational","1","1552579200","","");
INSERT INTO cust_equipments VALUES("44","14","Telecommunication","MOBILE PHONE","IPHONE","5","Pcs.","Operational","1","1550937600","","");
INSERT INTO cust_equipments VALUES("45","14","Emergency Equipments","Fire Extinguisher","FE","20","Pcs.","Operational","1","1554480000","","");
INSERT INTO cust_equipments VALUES("46","15","Firearms","9MM","9MM","7","Pcs.","Operational","1","1567440000","","");
INSERT INTO cust_equipments VALUES("47","15","Firearms","5.6 mm","5.6MM","3","Pcs.","Operational","1","1567526400","","");
INSERT INTO cust_equipments VALUES("48","15","Detectors","SCANNER","SCAN","3","Pcs.","Operational","1","1567353600","","");
INSERT INTO cust_equipments VALUES("49","15","Communication and Surveillance","CCTV","CCTV","5","Pcs.","Operational","1","1567353600","","");
INSERT INTO cust_equipments VALUES("50","15","Communication and Surveillance","REPEATER","REPEAT","2","Pcs.","Operational","1","1567699200","","");
INSERT INTO cust_equipments VALUES("51","15","Transportation","MOTORCYCLE","SINGLE","4","Pcs.","Operational","1","1567526400","","");
INSERT INTO cust_equipments VALUES("52","17","Firearms","9MM","9MM","5","Pcs.","Operational","1","1569859200","","");
INSERT INTO cust_equipments VALUES("53","17","Detectors","HANDHELD","HH","3","Pcs.","Operational","1","1566748800","","");
INSERT INTO cust_equipments VALUES("54","17","Communication and Surveillance","SEARCH LIGHT","GTS","5","Pcs.","Operational","1","1569772800","GTS","");
INSERT INTO cust_equipments VALUES("55","17","Communication and Surveillance","SEARCH LIGHT","GTS","5","Pcs.","Operational","1","1569772800","GTS","");
INSERT INTO cust_equipments VALUES("56","17","Transportation","MOTORCYCLE","MTR","2","Pcs.","Operational","1","1569686400","","");
INSERT INTO cust_equipments VALUES("57","17","Telecommunication","MOBILE PHONE","MP","5","Pcs.","Operational","1","1569859200","","");
INSERT INTO cust_equipments VALUES("58","17","Emergency Equipments","First Aid Kit","FAK","4","Pcs.","Operational","1","1569859200","","");
INSERT INTO cust_equipments VALUES("59","21","Firearms",".38 Cal","(ARMSCOR 202)-794922","1","Pcs.","Operational","1","0","(SCTY Office) Good Condition","");
INSERT INTO cust_equipments VALUES("60","21","Firearms",".38 Cal","(Armscor 202)-877300","1","Pcs.","Operational","1","0","(SCTY Office) Good condition","");
INSERT INTO cust_equipments VALUES("61","21","Firearms",".38 Cal","(Armscor 202)-61735","1","Pcs.","Operational","1","0","(Gate 2) Good Condition","");
INSERT INTO cust_equipments VALUES("62","21","Firearms",".38 Cal","(Armscor 202)-845501","1","Pcs.","Operational","1","0","(CBU) Good Condition","");
INSERT INTO cust_equipments VALUES("63","21","Firearms","12 ga","10 ammos, .38 Cal. & 10 ammos of 12 gauge shotgun","1","Pcs.","Operational","1","0","(Pulled out by GSIA) Good Condition","");
INSERT INTO cust_equipments VALUES("64","21","Detectors","HANDHELD","Kenwood Radio Handheld-B3B07889","1","Pcs.","Operational","1","0","(Locker) Good condition","");
INSERT INTO cust_equipments VALUES("65","21","Detectors","HANDHELD","Kenwood Radio Handheld-B5C04218","1","Pcs.","Operational","1","0","(Gate 2) Defective PTT","");
INSERT INTO cust_equipments VALUES("66","21","Detectors","HANDHELD","Kenwood Radio Handheld-B5C04216","1","Pcs.","Operational","1","0","(DC) Good condition","");
INSERT INTO cust_equipments VALUES("67","21","Detectors","HANDHELD","Kenwood Radio Handheld-B4B02550","1","Pcs.","Operational","1","0","(Roving) Good condition","");
INSERT INTO cust_equipments VALUES("68","21","Detectors","HANDHELD","Kenwood Radio Handheld-B4B02548","1","Pcs.","Operational","1","0","(Parts) Good condition","");
INSERT INTO cust_equipments VALUES("69","21","Detectors","HANDHELD","Kenwood Radio Handheld-B4B02554","1","Pcs.","Operational","1","0","(SIC) Good condition (replace of damaged radio assigned at Main gate)","");
INSERT INTO cust_equipments VALUES("70","21","Detectors","HANDHELD","Kenwood Radio Handheld-B4304172","1","Pcs.","Operational","1","0","(Main Gate) defective last Feb. 27, 2018 by SG Alarcon Pio","");
INSERT INTO cust_equipments VALUES("71","21","Detectors","HANDHELD","Kenwood Radio Handheld-B4B02546","1","Pcs.","Operational","1","0","(CBU) Good condition","");
INSERT INTO cust_equipments VALUES("72","21","Detectors","HANDHELD","Kenwood Radio Handheld (2nd hand)-B4202615 ","1","Pcs.","Operational","1","1507910400","(Devanning) Good Condition","");
INSERT INTO cust_equipments VALUES("73","21","Detectors","HANDHELD","Kenwood Radio Handheld (2nd hand) -B3C04676","1","Pcs.","Operational","1","0","(Disposal) Good Condition","");
INSERT INTO cust_equipments VALUES("74","21","Detectors","HANDHELD","Kenwood Radio Handheld (2nd hand)-B4202614 ","1","Pcs.","Operational","1","0","(Warehouse 7) Good condition","");
INSERT INTO cust_equipments VALUES("75","21","Detectors","HANDHELD","Kenwood radio handheld (brand new)-B6502785 ","1","Pcs.","Operational","1","0","(ADC) Good Condition (delivered last Feb. 28, 2018)","");
INSERT INTO cust_equipments VALUES("76","21","Communication and Surveillance","CCTV","","16","Pcs.","Operational","1","0","16 UNITS","");
INSERT INTO cust_equipments VALUES("77","21","Detectors","SCANNER","Touch Checker Button","29","Pcs.","Operational","1","0","Touch Checker Button","");
INSERT INTO cust_equipments VALUES("78","21","Transportation","MOTORCYCLE","Kawasaki Fury w/ Sidecar","1","Pcs.","Operational","1","0","NO PLATE","");
INSERT INTO cust_equipments VALUES("79","21","Transportation","PATROL/BICYCLE","(Mountain bike)","2","Pcs.","Operational","1","0","(Mountain bike)","");
INSERT INTO cust_equipments VALUES("80","21","Detectors","SCANNER","METAL DETECTOR","5","Pcs.","Operational","1","0","USEABLE","");
INSERT INTO cust_equipments VALUES("81","21","Telecommunication","DESKTOP/LAPTOP","COMPUTER SET","1","Set","Operational","1","1572796800","MONITOR AND CPU","");
INSERT INTO cust_equipments VALUES("82","21","Telecommunication","DESKTOP/LAPTOP","Lenovo MONITOR","2","Pcs.","Operational","1","0","Lenovo MONITOR","");
INSERT INTO cust_equipments VALUES("83","21","Telecommunication","DESKTOP/LAPTOP","CPU ONLY (PC007NHD)","1","Pcs.","Operational","1","-28800","CPU ONLY (PC007NHD)","");
INSERT INTO cust_equipments VALUES("84","21","Telecommunication","MOBILE PHONE","SAMSUNG","1","Pcs.","Operational","1","0","SAMSUNG","");
INSERT INTO cust_equipments VALUES("85","22","Firearms",".38 Cal","F/A`S","1","Pcs.","Operational","1","0","877307","");
INSERT INTO cust_equipments VALUES("86","22","Firearms",".38 Cal","F/A`S","1","Pcs.","Operational","1","0","877294","");
INSERT INTO cust_equipments VALUES("87","22","Firearms",".38 Cal","22 ROUNDS","22","Others","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("88","22","Telecommunication","MOBILE PHONE","SAMSUNG SM-B105E (R2K700MXCR)","1","Pcs.","Operational","1","-28800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("89","22","Telecommunication","MOBILE PHONE","SAMSUNG GT-E1200Y (GT-E1200Y)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("90","22","Telecommunication","MOBILE PHONE","SAMSUNG GT-E1200Y (GT-E1200Y)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("91","22","Detectors","SCANNER","METAL DETECTOR","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("94","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14640)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("95","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14769)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("96","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14761)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("97","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B6601860)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("98","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B6601859)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("99","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14765)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("100","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14763)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("101","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14764)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("102","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14767)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("103","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7B14459)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("104","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14770)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("105","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B6601856)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("106","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B6601858)","1","Pcs.","Not Operational","1","-28800","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("107","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14768)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("108","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14762)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("109","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (9B6601857)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("110","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14108)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("111","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14110)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("112","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7C14766)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("113","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7414593)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("114","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B8813821)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("115","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B7415019)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("116","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B0900882)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("117","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B1800362)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("118","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B0602277)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("119","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B1800361)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("120","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (A9A00158)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("121","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B1800360)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("122","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (71201847)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("123","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (A9901620)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("124","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B0900607)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("125","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (A9A00129)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("126","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B1501582)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("127","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (B0900018)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("128","22","Communication and Surveillance","HANDHELD RADIO","TK-3107 (51100042)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("129","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4507379)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("130","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4202617)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("131","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5101997)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("132","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4202555)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("133","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B3C04677)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("134","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5803087)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("135","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4202616)","1","Pcs.","Not Operational","1","0","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("136","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4200521)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("137","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4202620)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("138","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5701827)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("139","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4202561)","1","Pcs.","Operational","1","-28800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("140","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4202551)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("141","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5701830)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("142","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5905634)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("143","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B4507383)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("144","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5101999)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("145","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5701826)","1","Pcs.","Operational","1","0","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("146","22","Communication and Surveillance","HANDHELD RADIO","TK-3000 (B5703956)","1","Pcs.","Not Operational","1","-28800","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("147","21","Other Electronic Equipments","Digital Camera","CANON (PC2197)","1","Pcs.","Operational","1","1572883200","GOOD CONDITION","");
INSERT INTO cust_equipments VALUES("148","21","Other","Search Stick","SEARCH STICK","12","Pcs.","Operational","1","0","SERVICEABLE-CONSUMABLE","");
INSERT INTO cust_equipments VALUES("149","21","Other","TRAFFIC VEST","VEST","12","Pcs.","Operational","1","1572796800","SERVICEABLE-CONSUMABLE","");
INSERT INTO cust_equipments VALUES("150","21","Other Electronic Equipments","Kenwood Battery Charger","BATTERY CHARGER","5","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("151","21","Other","Spare Battery","SPARE","3","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("152","21","Other","Spare Battery","SPARE","3","Pcs.","Not Operational","1","1572796800","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("156","22","Other","TRAFFIC VEST","VEST","4","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("158","22","Other Electronic Equipments","HIGH-TECH TOUCH GUARD","special equipment","1","Pcs.","Operational","1","1574956800","none","");
INSERT INTO cust_equipments VALUES("159","22","Other","TRAFFIC GLOVES"," TRAFFIC GLOVES","2","Set","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("160","22","Other","TRAFFIC SIGNAGE (STOP & GO)","TRAFFIC SIGNAGE","4","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("161","22","Other","TRAFFIC SIGNAGE (STOP & GO)","TRAFFIC SIGNAGE","4","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("162","22","Detectors","UNDER CHASSIS MIRROR","UC MIRROR","2","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("163","22","Other Electronic Equipments","Digital Camera","CANON IXUS","1","Others","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("164","22","Detectors","HANDHELD","METAL DETECTOR","3","Others","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("165","22","Other Electronic Equipments","BUNDY CLOCK","YOKATTA DX-6","1","Others","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("166","22","Communication and Surveillance","MEGAPHONE","FANON MP-5 (M0148727)","2","Others","Operational","1","1572796800","","");
INSERT INTO cust_equipments VALUES("167","22","Communication and Surveillance","MEGAPHONE","FANON MV-205 (M0175696)","2","Others","Operational","1","1572796800","","");
INSERT INTO cust_equipments VALUES("168","20","Firearms","9MM","9MM","5","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("169","20","Detectors","WALK THROUGH","WT","2","Set","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("170","20","Firearms",".38 Cal","REVOLVER","5","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("171","20","Firearms","12 ga","ARMSCOR","5","Pcs.","Operational","1","1573142400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("172","20","Detectors","HANDHELD","SCANNER","6","Pcs.","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("173","20","Detectors","SCANNER","SCANNER","2","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("174","20","Detectors","UNDER CHASSIS MIRROR","UCM (RT576)","4","Pcs.","Operational","1","1572451200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("175","20","Communication and Surveillance","CCTV","ROVER","25","Pcs.","Operational","1","1572969600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("176","20","Communication and Surveillance","HANDHELD RADIO","RADIO","12","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("177","20","Communication and Surveillance","BASE RADIO","BR","4","Pcs.","Operational","1","1572364800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("178","20","Communication and Surveillance","REPEATER","REPEATER","4","Set","Operational","1","1569772800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("179","20","Communication and Surveillance","SEARCH LIGHT","SL","12","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("180","20","Communication and Surveillance","GUARD TOUR SYSTEM","GTS","6","Pcs.","Operational","1","1570982400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("181","20","Communication and Surveillance","MEGAPHONE","MEGAPHONE","2","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("182","20","Communication and Surveillance","Rechargeable Spotlight","SPOTLIGHT","4","Pcs.","Not Operational","1","1572451200","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("183","20","Transportation","MOTORCYCLE","SINGLE (YKL-2131)","2","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("184","20","Transportation","SEGWAY/ATV","ATV (4848L)","1","Pcs.","Operational","1","1573401600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("185","20","Transportation","RESCUE/EMERGENCY VEHICLE/AMBULANCE","EV","1","Pcs.","Operational","1","1572537600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("186","20","Transportation","PATROL/BICYCLE","BIKE","4","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("187","20","Telecommunication","DESKTOP/LAPTOP","DELL COREi7","2","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("188","20","Telecommunication","MOBILE PHONE","SAMSUNG (J7-2019)","5","Pcs.","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("189","20","Telecommunication","MOBILE PHONE","IPHONE S","5","Pcs.","Operational","1","1572364800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("190","20","Telecommunication","INTERNET CONNECTION","GLOBE HOME PREPAID","2","Set","Operational","1","1572364800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("191","20","Emergency Equipments","Fire Extinguisher","FE","15","Pcs.","Operational","1","1572796800","CONSUMABLE","");
INSERT INTO cust_equipments VALUES("192","20","Emergency Equipments","First Aid Kit","FAK","5","Pcs.","Operational","1","1572364800","CONSUMABLE","");
INSERT INTO cust_equipments VALUES("193","20","Emergency Equipments","Sprinkler System","SS","30","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("194","20","Emergency Equipments","Standpipe and Fire Hose System ","SFHS","5","Pcs.","Operational","1","1573142400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("195","20","Emergency Equipments","PPES","PPES","1","Pcs.","Not Operational","1","1572192000","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("196","20","Emergency Equipments","G-ERT BOX","GB","1","Pcs.","Not Operational","1","1572796800","DEFECTIVE","");
INSERT INTO cust_equipments VALUES("197","20","Other Electronic Equipments","BUNDY CLOCK","BC","2","Pcs.","Operational","1","1572451200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("198","20","Other Electronic Equipments","CANON CAMERA","SKL-EOS","3","Pcs.","Operational","1","1573056000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("199","20","Other Electronic Equipments","JVM TOUCH GUARD","JTG","4","Set","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("200","20","Other Electronic Equipments","Digital Camera","SONY-DSC098","4","Pcs.","Operational","1","1572969600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("201","20","Other Electronic Equipments","Kenwood Battery Charger","CHARGER","4","Pcs.","Operational","1","1572451200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("202","20","Other","Spare Battery","SB","5","Pcs.","Available","1","1573747200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("203","20","Other","TRAFFIC VEST","TV","8","Pcs.","Operational","1","1573315200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("204","20","Other","TRAFFIC GLOVES","TG","8","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("205","20","Other","TRAFFIC SIGNAGE (STOP & GO)","TS S&G","6","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("206","20","Other","Search Stick","SS","10","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("207","17","Detectors","UNDER CHASSIS MIRROR","UCM","5","Pcs.","Operational","1","1573401600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("208","17","Communication and Surveillance","HANDHELD RADIO","HR","5","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("209","17","Transportation","MOTORCYCLE","HONDA","5","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("210","17","Telecommunication","INTERNET CONNECTION","SMART BRO POCKET WIFI","8","Pcs.","Operational","1","1572451200","CONSUMABLE","");
INSERT INTO cust_equipments VALUES("211","17","Other Electronic Equipments","Kenwood Battery Charger","KBC","5","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("212","17","Other Electronic Equipments","BUNDY CLOCK","BC","5","Pcs.","Operational","1","1572451200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("213","17","Other Electronic Equipments","Digital Camera","CANON","4","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("214","17","Other","Spare Battery","SB","8","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("215","17","Other","TRAFFIC VEST","TV","5","Pcs.","Operational","1","1572278400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("216","17","Other","TRAFFIC GLOVES","TG","8","Pcs.","Operational","1","1572364800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("217","17","Other","TRAFFIC SIGNAGE (STOP & GO)","SIGNAGE","5","Pcs.","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("218","17","Other","Search Stick","SS","8","Pcs.","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("219","16","Firearms",".38 Cal","REVOLVER","5","Pcs.","Operational","1","1572796800","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("220","16","Detectors","HANDHELD","HANDHELD","4","Pcs.","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("221","16","Communication and Surveillance","CCTV","SAMSUNG","24","Pcs.","Operational","1","1572192000","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("222","16","Transportation","PATROL/BICYCLE","MOUNTAIN BIKE","4","Pcs.","Operational","1","1573142400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("223","16","Telecommunication","DESKTOP/LAPTOP","LENOVO (COREi5)","3","Pcs.","Operational","1","1573401600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("224","16","Emergency Equipments","Fire Extinguisher","FIRE EXT","20","Pcs.","Operational","1","1573315200","CONSUMABLE","");
INSERT INTO cust_equipments VALUES("225","16","Other Electronic Equipments","Digital Camera","NIKON","2","Pcs.","Operational","1","1572105600","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("226","16","Other","TRAFFIC VEST","VEST","12","Pcs.","Operational","1","1569686400","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("227","13","Other Electronic Equipments","JVM TOUCH GUARD","JWM TOUCH GUARD","5","Pcs.","Operational","1","1572364800","JWM TOUCH GUARD","");
INSERT INTO cust_equipments VALUES("228","13","Communication and Surveillance","MEGAPHONE","MEGAPHONE","2","Pcs.","Operational","1","1572105600","MEGAPHONE","");
INSERT INTO cust_equipments VALUES("229","13","Emergency Equipments","First Aid Kit","FIRST AID KIT","4","Pcs.","Operational","1","1572192000","CONSUMABLE","");
INSERT INTO cust_equipments VALUES("230","13","Other","Spare Battery","SPARE","0","Pcs.","Operational","1","1569859200","SERVICEABLE","");
INSERT INTO cust_equipments VALUES("231","28","Transportation","MOTORCYCLE","MOTOR","2","Pcs.","Operational","1","1577808000","GOOD CONDITION","4136");
INSERT INTO cust_equipments VALUES("232","28","Firearms","12 ga","12GA","2","Pcs.","Operational","1","1577808000","GOOD CONDITION","4139");



DROP TABLE cust_fforces;

CREATE TABLE `cust_fforces` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `unitname` mediumtext,
  `contactno` varchar(15) DEFAULT NULL,
  `ffstatus` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `custffcs_idx` (`contract_id`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

INSERT INTO cust_fforces VALUES("1","8","BPSO","test again","45676","Closed","test also");
INSERT INTO cust_fforces VALUES("2","10","Traffic","Unit Name","12345","Active","");
INSERT INTO cust_fforces VALUES("3","11","PNP","RSL","511-7871","Active","");
INSERT INTO cust_fforces VALUES("4","12","BPSO","SACHEZ, GERO HUMPREY RAMOS","09357654321","Active","");
INSERT INTO cust_fforces VALUES("5","10","PNP","UNKNOWN ","515-90817","Moved","");
INSERT INTO cust_fforces VALUES("6","10","BPSO","ACTION FORCE","444-0009","Active","N/A");
INSERT INTO cust_fforces VALUES("7","10","Traffic","PSD","444-0002","Closed","N/A");
INSERT INTO cust_fforces VALUES("8","11","PNP","P/PRIVATE","NONE","Active","PNP");
INSERT INTO cust_fforces VALUES("9","11","BFP","F01","FIRE HOTLINE","Active","F01");
INSERT INTO cust_fforces VALUES("10","11","BPSO","BPSO","NONE","Active","BPSO");
INSERT INTO cust_fforces VALUES("11","11","Traffic","TRAFFIC","NONE","Active","TRAFFIC");
INSERT INTO cust_fforces VALUES("12","11","Others","OTHERS","NONE","Closed","NONE");
INSERT INTO cust_fforces VALUES("13","12","PNP","PNP","NONE","Active","");
INSERT INTO cust_fforces VALUES("14","12","BFP","BFP","NONE","Active","");
INSERT INTO cust_fforces VALUES("15","12","BPSO","BPSO","NONE","Active","");
INSERT INTO cust_fforces VALUES("16","12","Traffic","TRAFFIC","NONE","Active","");
INSERT INTO cust_fforces VALUES("17","12","Others","OTHERS","NONE","Active","");
INSERT INTO cust_fforces VALUES("18","13","PNP","PNP","NONE","Active","");
INSERT INTO cust_fforces VALUES("19","13","BFP","BFP","NONE","Active","");
INSERT INTO cust_fforces VALUES("20","13","BPSO","BPSO","NONE","Active","");
INSERT INTO cust_fforces VALUES("21","13","TRAFFIC","TRAFFIC","NONE","Active","");
INSERT INTO cust_fforces VALUES("22","13","Others","OTHERS","NONE","Moved","");
INSERT INTO cust_fforces VALUES("23","14","PNP","PNP","NONE","Active","");
INSERT INTO cust_fforces VALUES("24","14","BFP","BFP","NONE","Active","");
INSERT INTO cust_fforces VALUES("25","14","BPSO","BPSO","NONE","Active","");
INSERT INTO cust_fforces VALUES("26","14","Traffic","TRAFFIC","NONE","Active","");
INSERT INTO cust_fforces VALUES("27","14","Others","OTHERS","NONE","Closed","");
INSERT INTO cust_fforces VALUES("28","20","PNP","CIDG","09170617278","Active","CIDG");
INSERT INTO cust_fforces VALUES("29","20","BFP","CUBAO STATION","911","Active","BFP");
INSERT INTO cust_fforces VALUES("30","20","BPSO","LORENA MORENO","501-9321","Active","BPSO");
INSERT INTO cust_fforces VALUES("31","20","Traffic","GEMMA PADUA","091746585","Active","TRAFFIC");
INSERT INTO cust_fforces VALUES("32","20","Others","UNKNOWN","NONE","Active","OTHER");
INSERT INTO cust_fforces VALUES("33","17","PNP","SPD","117","Active","SPD");
INSERT INTO cust_fforces VALUES("34","17","BFP","BFP SANTOLAN STATION","118","Active","BFP SANTOLAN STATION");
INSERT INTO cust_fforces VALUES("35","17","BPSO","TAGUIG BPSO","987-5768","Active","TAGUIG BPSO");
INSERT INTO cust_fforces VALUES("36","17","Traffic","HIGHWAY PATROL GROUP","117","Active","HIGHWAY PATROL GROUP");
INSERT INTO cust_fforces VALUES("37","17","Others","RIDERS","119","Active","RIDERS");
INSERT INTO cust_fforces VALUES("38","16","PNP","MPD","117","Active","MPD");
INSERT INTO cust_fforces VALUES("39","16","BFP","BFP ALABANG ZAPOTE","115","Active","BFP ALABANG ZAPOTE");
INSERT INTO cust_fforces VALUES("40","16","BPSO","ALESSANDRA NICOLE","766-1261","Active","BPSO");
INSERT INTO cust_fforces VALUES("41","16","Traffic","HPG","9012313","Active","HPG");
INSERT INTO cust_fforces VALUES("42","22","PNP","Your Friendly Neighborhood Police","911","Active","test data");



DROP TABLE cust_geninfo;

CREATE TABLE `cust_geninfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accno` varchar(25) DEFAULT NULL,
  `name` mediumtext,
  `address` mediumtext,
  `brgy` varchar(50) DEFAULT NULL,
  `citymun` varchar(50) DEFAULT NULL,
  `province` varchar(50) DEFAULT NULL,
  `region` varchar(30) DEFAULT NULL,
  `contactno` mediumtext,
  `email` mediumtext,
  `as_empid` varchar(25) DEFAULT NULL,
  `as_name` varchar(100) DEFAULT NULL,
  `rep_name` varchar(100) DEFAULT NULL,
  `rep_bday` int(11) DEFAULT NULL,
  `rep_dept` varchar(40) DEFAULT NULL,
  `rep_position` varchar(40) DEFAULT NULL,
  `rep_contactno` varchar(25) DEFAULT NULL,
  `rep_email` mediumtext,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `custgeninfo_idx` (`accno`,`as_empid`,`as_name`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=latin1;

INSERT INTO cust_geninfo VALUES("10","2027","Colgate Palmolive Phils.","11th Floor, Three World Square Building, No. 22 Upper Mckinley Road, Taguig City, 1634","CUPANG","MUNTINLUPA","METRO MANILA","NCR","","","5000","Omar Jardio","Omar Jardio","-28800","HR","SG","312-3433","","none");
INSERT INTO cust_geninfo VALUES("11","2028","RB-MJN","2309 Chino Roces Ave, Makati, Metro Manila","BAYANAN","MAKATI","METRO MANILA","NCR","","","04562","Joselito O. Mayores","Jennifer Marasigan","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("12","2029","Immaculate Concepcion Academy","10 Grant, San Juan, 1502, Metro Manila","AMTI","BOLINEY","ABRA","CAR","","","5000","Omar Jardio","Avegail Cresta","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("13","2030","Jubilee Christian School","1603 - 1607 E. Rodriguez Sr. Ave, Quezon City, 1109 Metro manila","ALILEM DAYA (POB.)","ALILEM","ILOCOS SUR","REGION I","","","5000","Omar Jardio","Marlon Robles","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("14","2032","Total Phils. And all their closed stations","Zone 9, 2027 Pedro Gil St, Santa Ana, Manila City, 1109 Metro Manila","BARANGAY 10-M","CAVITE","CAVITE","REGION IV-A","","","","Omar Jardio","Omar Tardio","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("15","2033","Eagle Cement Corp. (Bulacan & Limay)","Barangay Akle, San Ildefonso, 3010 Bulakan","BARANGAY 1","SAN ILDEFONSO","BULACAN","REGION III","09053379654","gsia.ecc@gmail.com","0631","Mar June A. Guanga","Omar Jardio","-28800","Operations","Account Supervisor","09165684608","omar_jardio@gsia.com.ph","none");
INSERT INTO cust_geninfo VALUES("16","2035","Intertek Phils","2307 Chino Roces Ave Ext, Makati, 1231 Metro Manila","BAMBAN","INFANTA","PANGASINAN","REGION I","","","5000","Omar Jardio","Sarah Padua","-28800","","","","","none");
INSERT INTO cust_geninfo VALUES("17","2036","Phil Mfc of Murata","Tanuan, Batangas","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Omar Jardio","Omar Tardio","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("18","2037","QPL","62 H. Dela Costa Street, Barangay Daungan Mauban, Quezon, 4330 Philippines","AMBUCLAO","BOKOD","BENGUET","CAR","","","","Omar Jardio","Omar Tardio","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("19","2038","GNPD","Mariveles, Bataan","BAGU","MARIVELES","BATAAN","REGION III","09053379654","gsia.ecc@gmail.com","06301","Mar Junre A. Guanga","Omar Jardio","-28800","Operations","Account Supervisor","09165684608","omar_jardio@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("20","2039","Marsman Medical","Molave Building 2231, 1231 Chino Roces Ave, Makati, Metro Manila","AFUSING BATO","MAKATI","METRO MANILA","NCR","","","","Omar Jardio","","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("21","2040","Liquigas","Manila, Metro Manila","ALLIG","FLORA","APAYAO","CAR","","","","Omar Jardio","Omar Tardio","-28800","HR","SG","","","none");
INSERT INTO cust_geninfo VALUES("22","2042","JAE 1","B-2 L-1 P-3 Celestine Homes - Marinig, Cabuyao, Laguna","I-A","CABUYAO","LAGUNA","REGION IV-A","09178729973","gsia_jaeph1stfactory@yahoo.com","01262","Demsy S. Ruales","Jenny Ferrncullo","-28800","Operations","Account Supervisor","09175016618","jen_ferrancullo@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("23","2043","Analog Devices ","General Trias, Cavite","ALLANGIGAN","GENERAL TRIAS","CAVITE","REGION IV-A","","francia.bien@analog.com","04481","Frianca B. Bien","Jenny Ferrancullo","-28800","OPERATIONS","Supervisor","09175016618","jen_ferrancullo@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("24","2044","Maxim Mkt.","Gateway Business Park 4107, General Trias, Cavite","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","HR","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("25","2045","Kajima-Gateway","Sky Plaza Building, 12th Floor, 6788 Ayala Ave, Makati, 1200 Metro Manila","BANBAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("26","2047","Mitsuba Phils.","Lot 1 Block 14 Phase II First Cavite Industrial Estate, Barangay Langkaan, Dasmarinas, Cavite 4126","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("27","2048","Hotel Kimberly","Amadeo Road, Brgy. Kaybagal North, Crisanto Ave., Tagaytay, Cavite","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("28","2049","Fort Legend Towers","27F, Fort Legend Tower, 31st Street corner 3rd Avenue, Taguig, Metro Manila","BANBAN","TAGUIG","METRO MANILA","NCR","09272265410","allan_talorete@yahoo.com","01872","Allan Y. Talorete","Allan Y. Talorete","-28800","","","09272265410","allan_talorete@yahoo.com","none");
INSERT INTO cust_geninfo VALUES("29","2050","Picadilly Star Center","25th Floor, Picadilly Star Building, 4th Avenue, corner 27th Street, Bonifacio Global City, Taguig, 1634 Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("30","2051","Morning Star Center","347 Sen. Gil J. Puyat Ave, Makati, 1209 Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("31","2052","Morning Star Milling Corp","A.Z. Avis Sr. Extn, Riverside Dr, Pasig, 1600 Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("32","2053","Vita Center Corp / others","2nd Flr., Suntree Bldg., Meralco ave.,, Ortigas Center Pasig City. Philippines, San Antonio, Pasig, Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("33","2054","Royal Oil","Las Pinas, Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Jenny Ferrancullo","Jenny Ferrancullo","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("34","2056","Panasonic Mfg Phils","Ortigas Ave, Taytay, 1920 Rizal","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("35","2057","Fujitsu Die-Tech","13 East Science Avenue, Special Export Processing Zone, Laguna Technopark, Biñan, Laguna, Philippines","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("36","2058","Atlas Copco","Binan, Laguna","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("37","2059","Middleby, LTI & Las Pinas","30 Real Street, Alabang Zapote Road, Las Pinas","AYUSAN NORTE","VIGAN","ILOCOS SUR","REGION I","","","","Andy Villacrusis","Andy Villacrusis","-28800","Sg","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("38","2060","Joyson Phils","106 East Main Avenue, Special Economic Zone, Laguna Technopark, Biñan, 4024, Laguna","TRANCOVILLE","BI�AN","LAGUNA","REGION IV-A","09326067763","laguardasaucelo09@gmail.com","00537","Laguarda S. Saucelo","Andy Villacrusis","-28800","Operations","Account Supervisor","09297234794","andy_villacrusis@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("39","2061","Furukawa Phils","113 East Main Ave, Laguna Technopark, Biñan, 4026 Laguna","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("40","2062","GF Micro","134 East Main Avenue, Biñan, Laguna","BANBAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("41","2063","Pepsi Cola Phils. (Cabuyao)","Pepsi Cola Philippines, Plant National Highway, Tunasan, Muntinlupa, 1776 Metro Manila","TUNASAN","MUNTINLUPA","METRO MANILA","NCR","09173785700","leninloveranes_jeramil@yahoo.com","04709","Lenin D. Loveranes","Andy Villacrusis","315504000","Operations Department","Account Supervisor","09297234794","andy_villacrusis@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("42","2064","KAU Inc.","149 LOOP, PHASE 6-C TECHNOPARK, SEZ LAGUNA, E Main Ave, Biñan, Laguna","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("43","2065","Honda Cars Phils","105 South Main Avenue, Laguna Technopark, Santa Rosa City, Laguna","ALLANGIGAN","SANTA ROSA","LAGUNA","REGION IV-A","09998088859","hondasecurity@hondaphil.com","01555","Alvin Tabaquero","Andy Villacrusis","-28800","Operations","Account Supervisor","09297234794","andy_villacrusis@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("44","2066","Honda Parts Mfg Corp","101, Laguna Technopark II, N Science Ave, Biñan, Laguna","BANBAN","CONNOR FRANTA","LAGUNA","REGION IV-A","09156071702","hpmc_security@hondaparts.com.ph","05668","Sherwin P. Sadicon","Andy Villacrusis","-28800","Operations Department","Account Supervisor","09297234794","andy_villacrusis@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("45","2067","BMPI","Pasig City, Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Villacrusis","Andy Villacrusis","-28800","SG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("46","2068","EMD Nexem","#1 Ring Rd., Light Industry & Science Park II, Brgys. Real &, Calamba, Laguna","AYUSAN NORTE","VIGAN","ILOCOS SUR","REGION I","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("47","2069","Eaton FPIP","Tanauan, Batangas","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("48","2070","Rockwell Collins","Lot 18 Third Street, First Phil Ind. Park, Tanauan City, Batangas, Tanauan, Batangas","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","121-1423","","none");
INSERT INTO cust_geninfo VALUES("49","2071","Sonion Phils","Tanauan, Batangas","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("50","2072","Arkray","106 Pan-Philippine Hwy, Santo Tomas, Batangas","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("51","2073","Just Fruit","Almanza Dos, Las Pinas, Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("52","2074","Village Gourmet","Lot 22, Dahlia Street, T.S. Cruz Subdivision, Almanza II 1740","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("53","2075","Sika","888 Marcos Alvarez Ave, Las Pinas, 1747 Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","Goalden Oberes","-28800","LG","Supervisor","","","none");
INSERT INTO cust_geninfo VALUES("54","2076","Marsmans Int’l /  Residences","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("55","2077","Kajima (Murata & Honda Proj)","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("56","2078","Film Pabrica","20 Jupiter, Makati, 1209 Metro Manila","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","","-28800","","","","","none");
INSERT INTO cust_geninfo VALUES("57","2079","Proville","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Goalden Oberes","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("58","2080","Abraham Holdings","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("59","2082","Kings Court","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("60","2083","Legend Villas","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("61","2084","Kabayan Pasay/Monumento","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("62","2085","MICHCA Mkt","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("63","2086","MICHA Mnl","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("64","2087","MICHA Mandaluyong","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("65","2088","Magsaysay Learning","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("66","2089","Gamaliel","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("67","2090","Regent Food","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("68","2091","Team Energry","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("69","2092","Pinoy Pamilya","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("70","2093","A Magsaysay","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Emil Manza","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("71","2094","Ajinomoto HO Mkt","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("72","2095","All Ajinomoto Sites (Luzon wide)","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("73","2096","Panasonic Carmelray","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("74","2097","Advantek","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("75","2098","SHS","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("76","2099","Integrated Packaging Logistic Mfg","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("77","2100","Phinma Property","","AYUSAN NORTE","VIGAN","ILOCOS SUR","REGION I","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("78","2101","Eaton LISP","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("79","2102","Quanta Paper ","","ILI","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("80","2103","Major Drilling","","ILI","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("81","2104","TOHO Mfg","","ILI","CONNOR FRANTA","APAYAO","CAR","","","","Reiner Matias","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("82","2105","PKI","No address yet","ILI","CONNOR FRANTA","APAYAO","CAR","09298543275","lipa_security@gsia.com.ph","02223","Maxwel L. Montenegro","Maxwel L. Montenegro","315504000","","","09298543275","lipa_security@gsia.com.ph","none");
INSERT INTO cust_geninfo VALUES("83","2106","GNP Kauswagan","No Address Yet","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","09166882050","francia.bien@analog.com","04481","Andy Lano","Omar Jardio","-28800","Operations","Account Supervisor","09165684608","omar_jardio@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("84","2107","MARS Phils","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("85","2108","Mitsui","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("86","2109","Paper tree","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("87","2110","Boral","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("88","2111","SGS","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("89","2112","Onesimus (Mandaluyong & SM North)","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("90","2113","Art Nature","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("91","2114","ADGT","","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","","","","Andy Lano","","0","","","","","none");
INSERT INTO cust_geninfo VALUES("92","2115","NLREC","No address yet","AYALA ALABANG","MUNTINLUPA","METRO MANILA","NCR","09153580865","nlrecscty.gsia@gmail.com","06851","Joseph A. Alegado","JUANITA AUREADA","946828800","Operations","Account Sepervisor","09178652343","dereck_gervasio@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("93","2116","Northwind","","AYALA ALABANG","MUNTINLUPA","METRO MANILA","NCR","","","5002","Dereck Gervasio","Diega Panlilio","-288000","","SO","5019315","","none");
INSERT INTO cust_geninfo VALUES("94","2160","JAE 2","B-2 L-1 P-3 Celestine Homes - Marinig, Cabuyao, Laguna","BACLARAN","CABUYAO","LAGUNA","REGION IV-A","09178729646","gsia_jaeph1stfactory@yahoo.com","01262","Demsy S. Ruales","Jenny Ferrncullo","-28800","Operations","Account Supervisor","09175016618","jen_ferrancullo@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("95","2161","Pepsi Cola Phils. (Muntinlupa)","No address yet","BALANSAY","MAMBURAO","METRO MANILA","NCR","09464718185","muntinlupa.security@pcppi.com.ph","05041","Richard Zafe","Andy Villacrusis","0","Operations Department","Account Supervisor","09297234794","andy_villacrusis@gsia.com.ph ","none");
INSERT INTO cust_geninfo VALUES("96","2162","Vcorp","No address yet","BANOEN","QUIRINO","ILOCOS SUR","REGION I","09560870915","orlsme@yahoo.com","01879","Orlando S. Dela Rosa","Orlando S. Dela Rosa","0","","","09560870915","orlsme@yahoo.com","none");
INSERT INTO cust_geninfo VALUES("97","2164","Collins Aerospace","No address yet","AMATONG","ODIONGAN","ROMBLON","REGION IV-B","09109184792","reynald_advincula@beaerospace.com","05040","Jun S. Montuya","Aldrin C. Danao","-28800","","","09307270259","reynald_advincula@beaerospace.com","none");
INSERT INTO cust_geninfo VALUES("98","2165","San Buenventura","No address yet","ALLANGIGAN","CONNOR FRANTA","APAYAO","CAR","09078147444","gsia_sbpl@yahoo.com","05605","Napoleon R. Ramos","Napoleon R. Ramos","0","","","09078147444","gsia_sbpl@yahoo.com","none");
INSERT INTO cust_geninfo VALUES("99","2166","Quezon Power","Mauban, Quezon","ABO-ABO","MAUBAN","QUEZON","REGION IV-A","09479880653","gsia_qpl@yahoo.com","04332","Keinylle S. Tunacao","Keinylle S. Tunacao","-28800","","","09479880653","gsia_qpl@yahoo.com ","none");
INSERT INTO cust_geninfo VALUES("100","2167","Murata","No address yet","ALAWIHAO","DAET","CAMARINES NORTE","REGION V","09953389906","n/a","06725","Ramon R. Reyes Jr.","Ramon R. Reyes Jr.","0","","","09953389906","n/a","none");
INSERT INTO cust_geninfo VALUES("101","","Team Sual","No address yet","BOROCBOROC","ANINI-Y","AKLAN","NCR","09293339276","gsia.teamenergy@gmail.com","07066","Roberto B. Jimenez","Roberto B. Jimenez","-28800","","","09293339276","gsia.teamenergy@gmail.com","none");
INSERT INTO cust_geninfo VALUES("102","2174","SAMPLE COMPANY","NOT YET ADDRESS","BANAGO","BALABAGAN","LANAO DEL SUR","ARMMM","501-501111","N/A","1234","RENZETH OLXER","","0","","","","","none");



DROP TABLE cust_manpower;

CREATE TABLE `cust_manpower` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `mdate` int(11) DEFAULT NULL,
  `empid` varchar(25) DEFAULT NULL,
  `empname` mediumtext,
  `position` varchar(30) DEFAULT NULL,
  `shift` varchar(10) DEFAULT NULL,
  `mstatus` varchar(40) DEFAULT NULL,
  `note` mediumtext,
  `postno` int(4) DEFAULT NULL,
  `licno` varchar(30) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custmpwr_idx` (`contract_id`,`refno`,`empid`,`licno`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=latin1;

INSERT INTO cust_manpower VALUES("2","10","1564588800","8000","PADUA, SARAH MAGO","SG","Night","Active","SG","2","","");
INSERT INTO cust_manpower VALUES("3","11","1564588800","5","SAPIO, CLAIRE RAMOS","LG","Day","Active","","19","","");
INSERT INTO cust_manpower VALUES("4","12","1564588800","2","SANCHEZ, CAITLIN RAMOS","SD","Day","Active","","2","","");
INSERT INTO cust_manpower VALUES("5","10","1567267200","2001","ANGULO , RODEL C.","DC","Day","Active","M","1","0701-19","");
INSERT INTO cust_manpower VALUES("6","10","1567267200","2002","MANIBO, PASTOR B.","ADC","Day","Active","M","2","0702-19","");
INSERT INTO cust_manpower VALUES("8","10","1567267200","2003","LARDIZABAL, JAY G.","LG","Day","Active","F","3","0703","");
INSERT INTO cust_manpower VALUES("9","10","1567267200","2003","SANTOS, PRINCESS ROSELLE","LG","Day","Active","F","4","0701-19","");
INSERT INTO cust_manpower VALUES("10","10","1567267200","2004","TENOSO, PRINCE CHRISTIAN","SD","Day","Active","M","5","0701-19","");
INSERT INTO cust_manpower VALUES("11","10","1567267200","2005","TENOSO, PRINCESS MAE","LG","Day","Active","F","6","0701-19","");
INSERT INTO cust_manpower VALUES("12","10","1567267200","2006"," VIDUYA, XIAN KAEL","DAY-OFF RELIEVER","Day","Active","M","6","0701-19","");
INSERT INTO cust_manpower VALUES("13","10","1567267200","2007","VIDUYA, XED KENDRAE I.","CCTV OPERATOR","Day","Active","M","7","0701-19","");
INSERT INTO cust_manpower VALUES("14","10","1567267200","2007","VIDUYA, KAREN MAE I.","LG","Day","Active","F","7","0701-91","");
INSERT INTO cust_manpower VALUES("15","10","1567267200","2008","MUGOL, ARXEL P.","K9 Units","Day","Active","M","8","0701-19","");
INSERT INTO cust_manpower VALUES("16","10","1567267200","2009","LUGMAO, ALVIN ","SAFETY OFFICER","Day","Active","M","9","0701-19","");
INSERT INTO cust_manpower VALUES("17","10","1567353600","2010","BULDA, DIAN B.","NURSE","Day","Active","F","10","07096","");
INSERT INTO cust_manpower VALUES("18","11","1567353600","1","TACDERAS, CHRISTIAN P.","DC","Night","Active","M","1","123456","");
INSERT INTO cust_manpower VALUES("19","11","1567353600","3","CASTRO, JOSEPH NINO","ADC","Night","Active","M","3","123-0909","");
INSERT INTO cust_manpower VALUES("20","11","1567353600","2","BULDA, MARLO B.","SG","Day","Active"," M","3","4313678","");
INSERT INTO cust_manpower VALUES("21","11","1567353600","4","BASANEZ, JOHN MARICK DB","DC","Day","Active","M","5","565699898","");
INSERT INTO cust_manpower VALUES("22","12","1567267200","1","BERNARDO, DANIEL","DC","Day","Active","M","1","321456","");
INSERT INTO cust_manpower VALUES("23","12","1567699200","2","REID, NADINE","NURSE","Night","Active","F","2","789345","");
INSERT INTO cust_manpower VALUES("24","12","1567526400","3","CUNETA, SHERYL","LG","Day","Active","F","3","34512387","");
INSERT INTO cust_manpower VALUES("25","12","1568131200","4","PADILLA, JAKE","ADC","Day","Active","M","4","4532786","");
INSERT INTO cust_manpower VALUES("26","12","1567958400","5","CRUZ, SHARON","SG","Day","Active","M","6","4789876543","");
INSERT INTO cust_manpower VALUES("27","12","1567440000","6","SARMIENTO, RAUL","SD","Day","Active","M","6","1234987","");
INSERT INTO cust_manpower VALUES("28","13","1567958400","1","CUENCA, ROBIN","DC","Day","Active","","1","234578","");
INSERT INTO cust_manpower VALUES("29","13","1566748800","2","GONZAGA, TINA","LG","Night","Active","","3","095631","");
INSERT INTO cust_manpower VALUES("30","13","1566921600","4","GONZALES, GLAIZA","NURSE","Day","Active","","4","874567890","");
INSERT INTO cust_manpower VALUES("31","13","1567008000","3","MONTANO, CRISOSTOMO","ADC","Day","Active","","3","24RTWE2314","");
INSERT INTO cust_manpower VALUES("32","13","1567094400","5","GERONIMO, SHERAHWIN","SG","Day","Active","","5","235T445TG","");
INSERT INTO cust_manpower VALUES("33","13","1564588800","6","DE GUZMAN, HOWEE","SD","Day","Active","","6","123456YHN","");
INSERT INTO cust_manpower VALUES("34","13","1549036800","7","MEDEL, BITOY","DAY-OFF RELIEVER","Day","Active","","6","34567YUJM","");
INSERT INTO cust_manpower VALUES("35","13","1549123200","8","QUIZON, DIEGO","CCTV OPERATOR","Night","Active","","7","1458UJBC","");
INSERT INTO cust_manpower VALUES("36","13","1549123200","8","CRUZ, NIERVA","K9 Units","Day","Active","","8","4454565YHT","");
INSERT INTO cust_manpower VALUES("37","14","1552579200","1","HALILI, AYA","LG","Day","Active","","1","2345TGHJ","");
INSERT INTO cust_manpower VALUES("38","14","1552579200","2","GOMEZ, HERBERTA","LG","Day","Active","","2","123ERFDCV","");
INSERT INTO cust_manpower VALUES("39","14","1553011200","3","BAUTISTA, RAYVER","DC","Day","Active","","3","2EREDDW234","");
INSERT INTO cust_manpower VALUES("40","14","1553184000","4","BRENICA, ALJUN","ADC","Day","Active","","4","123RGFF567","");
INSERT INTO cust_manpower VALUES("41","14","1553184000","5","GATCHIALIAN, FRANK","ADC","Day","Active","","5","12345YH","");
INSERT INTO cust_manpower VALUES("42","14","1553788800","6","ROBREDO, RODRIGO","SG","Day","Active","","6","134RTH","");
INSERT INTO cust_manpower VALUES("43","14","1551974400","7","POE, LEONILO","SD","Day","Active","","7","1346DFG9","");
INSERT INTO cust_manpower VALUES("44","14","1552924800","7","GORDON, LITO","DAY-OFF RELIEVER","Day","Active","","7","5432OIUY","");
INSERT INTO cust_manpower VALUES("45","15","1561910400","1","DE LEON, CATHERINE","LG","Day","Active","","1","435678BDFL","");
INSERT INTO cust_manpower VALUES("46","15","1564588800","2","YNEZ, AYA","NURSE","Day","Active","","2","54345HGK","");
INSERT INTO cust_manpower VALUES("47","15","1563292800","3","DRILON, JOEL","DC","Day","Active","","3","3564653B5BN","");
INSERT INTO cust_manpower VALUES("49","15","0","4","BINAY, DIOKNO","ADC","Day","Active","","4","5457-SAMFEF23","");
INSERT INTO cust_manpower VALUES("50","15","1565971200","5","CHEL, JAYVEE","SG","Day","Active","","5","543GLREPO","");
INSERT INTO cust_manpower VALUES("51","15","1567526400","6","MORENO, JINGKO","SD","Day","Active","","6","5432GFG54","");
INSERT INTO cust_manpower VALUES("52","17","1567267200","1","Cunanan, Joy","K9 Units","Day","Active","LG","1","34345435","");
INSERT INTO cust_manpower VALUES("53","17","1568044800","2","Marquez, Vernie","DC","Day","Active","DC","2","567344","");
INSERT INTO cust_manpower VALUES("54","17","1569859200","3","Saturno, Jeremy","ADC","Night","Active","ADC","3","67899RFG45","");
INSERT INTO cust_manpower VALUES("55","20","1569772800","1","Magalong, Mario","DC","Day","Active","","1","23456TG","");
INSERT INTO cust_manpower VALUES("56","20","1569772800","2","Albayalde, Gerico","ADC","Day","Active","","2","2345KTL908","");
INSERT INTO cust_manpower VALUES("57","20","1569686400","4","Eleazar, Rogelia","NURSE","Day","Active","","4","34567890OOLUW","");
INSERT INTO cust_manpower VALUES("59","21","1567353600","3000","TABAQUERO, ALVIN S.","DC","Day","Active","S.O.","1","R0320160906254","");
INSERT INTO cust_manpower VALUES("60","21","1567353600","3001","APERDO, WILLIAM S.","ADC","Day","Active","S.O.","1","NCR20180206686","");
INSERT INTO cust_manpower VALUES("62","21","1567353600","3002","MORANO, ALBERTO","OTHER FUNCTION","Day","Active","SIC","1","R0120171205164","");
INSERT INTO cust_manpower VALUES("63","21","1567353600","3003","ARNADO, MEJUNFEL","OTHER FUNCTION","Day","Active","SCTY DRIVER","1","NCR20170626262","");
INSERT INTO cust_manpower VALUES("64","21","1567353600","3004","BEJAR, MARVIN JOSEPH","LG","Day","Active","LINE GUARD","1","R020190300694","");
INSERT INTO cust_manpower VALUES("65","21","1567353600","3005","BIBAL, JUAN PAULO","LG","Day","Active","LINE GUARD","1","R0420170407034","");
INSERT INTO cust_manpower VALUES("66","21","1572796800","3006","BULACAN, JOAN","LG","Day","Active","LADY GUARD","1","R0420161017359","");
INSERT INTO cust_manpower VALUES("67","21","1572796800","3007","CENIZA, NILO","DC","Day","Active","SCTY DRIVER","1","R04-0180200533","");
INSERT INTO cust_manpower VALUES("68","21","1572796800","3008","DE GUZMAN, JERMY","DC","Day","Active","SCTY DRIVER","1","R4A20171214678","");
INSERT INTO cust_manpower VALUES("69","21","1572796800","3009","DOTEN, MOHAIMIN","DC","Day","Active","SCTY DRIVER","1","R10-0190300071","");
INSERT INTO cust_manpower VALUES("70","21","1572796800","3010","ELE, EMMANUEL","DC","Day","Active","SCTY DRIVER","1","R0420170202706","");
INSERT INTO cust_manpower VALUES("71","21","1572796800","3011","GALLARDO","LG","Day","Active","LINE GUARD","1","NCR20170311956","");
INSERT INTO cust_manpower VALUES("72","21","1572796800","3012","GIMONY, CLYDE","LG","Day","Active","LINE GUARD","1","SBR 18178534","");
INSERT INTO cust_manpower VALUES("73","21","1572796800","3013","GRIPO, MELCHOR","LG","Day","Active","LINE GUARD","1","R0420170804121","");
INSERT INTO cust_manpower VALUES("74","21","1572796800","3014","HERNANDO, ZALDY","DC","Day","Active","SCTY DRIVER","1","R4201803088224","");
INSERT INTO cust_manpower VALUES("75","21","1572796800","3015","JORDAN, LIZA","LG","Day","Active","LADY GUARD","1","R0420160102254","");
INSERT INTO cust_manpower VALUES("76","21","1572796800","3016","LANARIA, RONALD","LG","Day","Active","LINE GUARD","1","R4A20181021423","");
INSERT INTO cust_manpower VALUES("77","21","1572796800","3017","MENIOLAS, GERALD","LG","Day","Active","LINE GUARD","1","NCR20180923381","");
INSERT INTO cust_manpower VALUES("78","21","1572796800","3018","PULIDO, GEROME","DC","Day","Active","SCTY DRIVER","1","R4A20180203629","");
INSERT INTO cust_manpower VALUES("79","21","1572796800","3019","RABINO, BRYAN","LG","Day","Active","LINE GUARD","1","R4B20171201159","");
INSERT INTO cust_manpower VALUES("80","21","1572796800","3020","REFE, FRANCIS","DC","Day","Active","SCTY DRIVER","1","R4A20180510755","");
INSERT INTO cust_manpower VALUES("81","21","1572796800","3021","SAMILLANO, JADE","LG","Day","Active","LADY GUARD","1","R0420170100733","");
INSERT INTO cust_manpower VALUES("82","21","1572796800","3022","SAMSON, RAFFY","LG","Day","Active","LINE GUARD","1","R04-0180200079","");
INSERT INTO cust_manpower VALUES("83","21","1572796800","3023","SIBULO, JENELYN","LG","Day","Active","LADY GUARD","1","R04-0180500085","");
INSERT INTO cust_manpower VALUES("85","21","1572796800","3024","SINOY, JANIE","LG","Day","Active","LADY GUARD","1","R4A20171214677","");
INSERT INTO cust_manpower VALUES("86","21","1572796800","3025","SODELA, REDEN","DC","Day","Active","SCTY DRIVER","1","R0520170300525","");
INSERT INTO cust_manpower VALUES("87","21","1572796800","3026","TALIP, FLORDELIZA","LG","Day","Active","LADY GUARD","1","R4A20171111709","");
INSERT INTO cust_manpower VALUES("88","21","1572796800","3027","TALIP, GARF FREDRICK","LG","Day","Active","LINE GUARD","1","R0420170100057","");
INSERT INTO cust_manpower VALUES("89","21","1572796800","3028","VILLAREAL, MARIANO","LG","Day","Active","LINE GUARD","1","R4A20171215173","");
INSERT INTO cust_manpower VALUES("90","21","1572796800","3029","JAURIGUE, RENNIE","DC","Day","Active","HEAD GUARD","1","R4A20180203595","");
INSERT INTO cust_manpower VALUES("91","21","1572796800","3030","NAVARRO, ANTHONY","LG","Day","Active","LINE GUARD","1","R4A20180614250","");
INSERT INTO cust_manpower VALUES("92","21","1572796800","3031","AM-IS, RANDY","DC","Day","Active","SCTY DRIVER","1","R0920171001757","");
INSERT INTO cust_manpower VALUES("93","22","1572883200","3032","TALORETE, ALLAN Y.","DC","Day","Active","DET. CMDR","1","R4A20171213243","");
INSERT INTO cust_manpower VALUES("94","22","1572883200","3033","CAHANAP, REDENTOR C.","DC","Day","Active","ASST. DET. CMDR","1","R09-O181200058","");
INSERT INTO cust_manpower VALUES("95","22","1572883200","3034","ACITA, DELMA A.","LG","Day","Active","","1","NCR-0180502973","");
INSERT INTO cust_manpower VALUES("96","22","1572883200","3035","ADERES, JASPER NEIL M.","LG","Day","Active","LINE GUARD","1","NCR20170947033","");
INSERT INTO cust_manpower VALUES("97","22","1572883200","3036","BAJALAN, RAYMUNDO D.","LG","Day","Active","LINE GUARD","1","NCR-O190202532","");
INSERT INTO cust_manpower VALUES("98","22","1572883200","3037","BARREDA, RONALD P.","LG","Day","Active","LINE GUARD","1","NCR20170946896","");
INSERT INTO cust_manpower VALUES("99","22","1572883200","3038","BOTIAL, MIRAFLOR T.","LG","Day","Active","LADY GUARD","1","NCR01901000197","");
INSERT INTO cust_manpower VALUES("100","22","1572883200","3039","BUHOK, ELMER V.","LG","Day","Active","LINE GUARD","1","NCR-0180302664","");
INSERT INTO cust_manpower VALUES("101","22","1572883200","3040","CABALLERO, ALEX A.","LG","Day","Active","LINE GUARD","1","NCR20171261532","");
INSERT INTO cust_manpower VALUES("102","22","1572883200","3041","COMPESINO, JUNGIE T.","LG","Day","Active","LINE GUARD","1","R04O181000745","");
INSERT INTO cust_manpower VALUES("103","22","1572883200","3042","COMPESINO, JUNGIE T.","LG","Day","Active","LINE GUARD","1","R04O181000745","");
INSERT INTO cust_manpower VALUES("104","22","1572883200","3043","DAGUMAN, JAYSON P.","LG","Day","Active","LINE GUARD","1","R0520171002933","");
INSERT INTO cust_manpower VALUES("105","22","1572883200","3044","DICHOSO, MELCHOR P.","LG","Day","Active","LINE GUARD","1","NCR-O190400858","");
INSERT INTO cust_manpower VALUES("106","22","1572883200","3045","DONIS, ALBIN L.","LG","Day","Active","LINE GUARD","1","R4A20170904504","");
INSERT INTO cust_manpower VALUES("107","22","1572883200","3046","ESPERANCILLA, CONSUELO","LG","Day","Active","LADY GUARD","1","NCR20170102374","");
INSERT INTO cust_manpower VALUES("108","22","1572883200","3047","HULIP, ARVIN B.","LG","Day","Active","LINE GUARD","1","NCR0180403467","");
INSERT INTO cust_manpower VALUES("109","22","1572883200","3048","JARA, EUSTAQUIO K JR. L.","LG","Day","Active","LINE GUARD","1","NCR-O190600161","");
INSERT INTO cust_manpower VALUES("110","22","1572883200","3049","LOPEZ, EDUARDO M.","LG","Day","Active","LINE GUARD","1","NCR20170729932","");
INSERT INTO cust_manpower VALUES("111","22","1572883200","3050","LOPEZ, EDUARDO M.","LG","Day","Active","LINE GUARD","1","NCR20170729932","");
INSERT INTO cust_manpower VALUES("113","22","1572883200","3051","MACASINAG, ISRAEL C.","LG","Day","Active","LINE GUARD","1","NCR20170205020","");
INSERT INTO cust_manpower VALUES("114","22","1572883200","3052","MERCADEJAS, GAY","LG","Day","Active","LADY GUARD","1","NCR-O190102597","");
INSERT INTO cust_manpower VALUES("115","22","1572883200","3053","MERCADEJAS, GAY","LG","Day","Active","LADY GUARD","1","NCR-O190102597","");
INSERT INTO cust_manpower VALUES("116","22","1572883200","3054","MIRANDILLA, RICHARD P.","LG","Day","Active","LINE GUARD","1","NCR20171156752","");
INSERT INTO cust_manpower VALUES("117","22","1572883200","3055","PRESQUITO, LEO","LG","Day","Active","LINE GUARD","1","NCR-0180401495","");
INSERT INTO cust_manpower VALUES("118","22","1572883200","3056","PUNAY, RICHARD C.","LG","Day","Active","LINE GUARD","1","R04-0181100365","");
INSERT INTO cust_manpower VALUES("119","22","1572883200","3057","ROSALES, DIESCINT E.","LG","Day","Active","LINE GUARD","1","NCR-0180402634","");
INSERT INTO cust_manpower VALUES("120","22","1572883200","3058","SABA, REMEGIO","LG","Day","Active","LINE GUARD","1","R04-0180301720","");
INSERT INTO cust_manpower VALUES("121","22","1572883200","3059","SOLIS, BENNY N.","LG","Day","Active","LINE GUARD","1","R4A20180101859","");
INSERT INTO cust_manpower VALUES("122","22","1572883200","3060","TAGUIAM, ROSALIO I.","LG","Day","Active","LINE GUARD","1","R07-0181100047","");
INSERT INTO cust_manpower VALUES("123","22","1572883200","3061","TIGUE, JOEL L.","LG","Day","Active","LINE GUARD","1","NCR20170946861","");
INSERT INTO cust_manpower VALUES("124","22","1572883200","3062","VILLACRUZ, JOHANESS JOHN","DC","Day","Active","TEM. RELIEVER","1","NCR0180904129","");
INSERT INTO cust_manpower VALUES("125","22","1572883200","3063","DECINA, JOVEL","DC","Day","Active","TEM. RELIEVER","1","NCR-20180924094","");
INSERT INTO cust_manpower VALUES("126","22","1572883200","3064","TORRES, MC ERVIN","DC","Day","Active","TEM. RELIEVER","1","R04-0180400698","");
INSERT INTO cust_manpower VALUES("127","22","1572883200","3065","PAULINO, LIEZEL","DC","Day","Active","TEM. RELIEVER","1","NCR-O190202667","");
INSERT INTO cust_manpower VALUES("128","22","1572883200","3066","TEJERO, BRIHILDA","DC","Day","Active","TEM. RELIEVER","1","CAR-O190600009","");
INSERT INTO cust_manpower VALUES("129","22","1572883200","3067","EBIO, REYNALDO JR.","DC","Day","Active","TEM. RELIEVER","1","NCR-O190701203","");
INSERT INTO cust_manpower VALUES("130","20","1572796800","3100","DELA VEGA, DEMERY A.","LG","Day","Active","LADY GUARD","1","345123","");
INSERT INTO cust_manpower VALUES("131","20","1572796800","3002","LUMBAGA, BLANCO O.","DC","Day","Active","DC","2","789043","");
INSERT INTO cust_manpower VALUES("132","20","1570377600","3003","LACZA, MARIO U.","ADC","Night","Active","ADC","4","223GDD45","");
INSERT INTO cust_manpower VALUES("133","20","1571673600","3004","MASCARINA, DAVID E.","SG","Day","Active","SG","5","129O00P","");
INSERT INTO cust_manpower VALUES("134","20","1570723200","3005","NADA, JAYSON I.","SD","Day","Active","SD","2","113245T","");
INSERT INTO cust_manpower VALUES("135","20","1571760000","3006","MONTANO, ARTURO L.","DAY-OFF RELIEVER","Day","Active","DOR","3","LK009987DF","");
INSERT INTO cust_manpower VALUES("136","20","1572883200","3007","TAN, GERONIMO","CCTV OPERATOR","Night","Active","CCTV OP","7","3211QWE445RF","");
INSERT INTO cust_manpower VALUES("137","20","1572969600","3008","CHENG, CHLUNG K.","K9 Units","Day","Active","K9","8","667J8IIO99P","");
INSERT INTO cust_manpower VALUES("138","20","1572883200","3009","MARIANO, GEMMA O.","NURSE","Day","Active","NURSE","1","45457JKOOL998","");
INSERT INTO cust_manpower VALUES("139","20","1569859200","3010","LUNA, ALFARO R.","SAFETY OFFICER","Day","Active","SO","2","8598598JJGR9065","");
INSERT INTO cust_manpower VALUES("140","17","1572192000","3011","TAMAYO, BERNARDO L.","DC","Day","Active","DC","1","777F6GGD6","");
INSERT INTO cust_manpower VALUES("141","17","1572105600","3012","SARMIENTO, REXY L.","ADC","Night","Active","ADC","2","LK888OO008FDU","");
INSERT INTO cust_manpower VALUES("142","17","1572278400","3013","BRAZA, JESS O.","SG","Day","Active","SG","3","8735YRHF","");
INSERT INTO cust_manpower VALUES("143","17","1572192000","3014","MORA, AVEGAIL I.","LG","Day","Active","LADY GUARD","4","475474F98RE4893","");
INSERT INTO cust_manpower VALUES("144","17","1572969600","3015","MULINGBAYAN, RAMIL Q.","LG","Day","Active","LINE GUARD","4","132DDFE3","");
INSERT INTO cust_manpower VALUES("145","17","1570377600","3016","MARASIGAN, MARLO U.","SD","Night","Active","SD","6","4545KL09","");
INSERT INTO cust_manpower VALUES("146","17","1572537600","3017","PAGDONSOLAN, JEREMY A.","DAY-OFF RELIEVER","Day","Active","DOR","6","4t94JIGFO9","");
INSERT INTO cust_manpower VALUES("147","17","1572364800","3018","SATURNINO, MIRANDA S.","CCTV OPERATOR","Night","Active","OPERATOR","7","LKDFJ777TDSG","");
INSERT INTO cust_manpower VALUES("148","17","1573056000","3019","ADVINCULA, PIA S.","NURSE","Day","Active","NURSE","3","SFD2223","");
INSERT INTO cust_manpower VALUES("149","17","1572796800","3020","CORNEJO, VIVIAN E.","K9 Units","Day","Active","K9 UNIT","2","SSDE22WE22","");
INSERT INTO cust_manpower VALUES("150","17","1572883200","3021","PABLO, RODOLFO K.","SAFETY OFFICER","Day","Active","SO","3","743H873EERR","");
INSERT INTO cust_manpower VALUES("151","17","-28800","3022","VALDERAMA, MARIA JOYCE T.","DC","Day","Active","HUNTER","2","SD3342","");
INSERT INTO cust_manpower VALUES("152","16","1572796800","3023","PADILLO, JANETTE O.","NURSE","Day","Active","NURSE","1","34834JKJKJ","");
INSERT INTO cust_manpower VALUES("153","16","1572883200","3024","EJERCITO, JOSEPHINE E.","DC","Day","Under Investigation","DC","2","E334FF","");
INSERT INTO cust_manpower VALUES("154","16","1573056000","3025","MILLARES, FERNANDO J.","ADC","Night","Suspended","ADC","3","343VM443","");
INSERT INTO cust_manpower VALUES("155","16","1572796800","3026","MOJERA, MORCON","SG","Day","AWOL","SG","3","DDEDE5553","");
INSERT INTO cust_manpower VALUES("156","16","1573401600","3027","MONTALBO, KENNEDY Y.","LG","Day","Active","LINE GUARD","5","SDED3445E","");
INSERT INTO cust_manpower VALUES("157","16","1571328000","3028","VILLAJIDA, NILDA T.","SD","Day","Active","SD","3","JDKFH887","");
INSERT INTO cust_manpower VALUES("158","16","1572969600","3029","LORESCA, LOVELY P.","DAY-OFF RELIEVER","Day","Active","DOR","5","634HGSD7K","");
INSERT INTO cust_manpower VALUES("159","16","1572451200","3030","MONTEALTO, MICAELA T.","CCTV OPERATOR","Night","Active","CCTV OPERATOR","6","23HHU8D9","");
INSERT INTO cust_manpower VALUES("160","16","1571328000","3031","LOJICA, JANELLA E.","K9 Units","Day","Active","K9 UNIT","7","2323WSE3","");
INSERT INTO cust_manpower VALUES("161","16","1570723200","3032","LONTOKERA, JENECCA R.","SAFETY OFFICER","Day","Active","SO","4","J7J80DSKJ","");
INSERT INTO cust_manpower VALUES("162","16","1570636800","3033","FONTANERA, HILDA R.","DC","Day","Active","OTHER","5","343DVVR45","");
INSERT INTO cust_manpower VALUES("163","28","1577808000","14353","SOTTO, ZETA II","LG","Day","Active","ACTIVE","12","456789JFF","4132");



DROP TABLE cust_op;

CREATE TABLE `cust_op` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `optype` varchar(40) DEFAULT NULL,
  `description` mediumtext,
  `opdatefr` int(11) DEFAULT NULL,
  `opdateto` int(11) DEFAULT NULL,
  `opstatus` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `custop_idx` (`contract_id`,`optype`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

INSERT INTO cust_op VALUES("1","10","Security Assessment","Security Assessment","1564588800","1567180800","On-going","");
INSERT INTO cust_op VALUES("2","11","Security and Safety Drill","Safety Drill","1533052800","1534176000","Completed","");
INSERT INTO cust_op VALUES("3","12","Security Assessment","Security","1564588800","1565798400","Completed","");
INSERT INTO cust_op VALUES("4","10","Security Plan","Security Plan","1561910400","1564502400","Completed","Security Plan");
INSERT INTO cust_op VALUES("5","10","Emergency/Response Plan","EMERGENCY","1567267200","1567699200","Completed","COMPLETE");
INSERT INTO cust_op VALUES("6","10","Security and Safety Drill","SSD","1568563200","1568736000","On-going","ON GOING");
INSERT INTO cust_op VALUES("7","11","Security Assessment","SA","1567353600","1567699200","Completed","COMPLETED");
INSERT INTO cust_op VALUES("8","11","Security Plan","SP","1569168000","1569513600","Pending","PENDING");
INSERT INTO cust_op VALUES("9","11","Emergency/Response Plan","EMERGENCY","1569859200","1570204800","Cancelled","CANCELLED");
INSERT INTO cust_op VALUES("10","12","Security Plan","SP","1567267200","1567612800","Completed","");
INSERT INTO cust_op VALUES("11","12","Emergency/Response Plan","E/RP","1558800000","1559145600","Completed","");
INSERT INTO cust_op VALUES("12","12","Security and Safety Drill","SSD","1561478400","1561824000","Completed","");
INSERT INTO cust_op VALUES("13","13","Security Assessment","SA","1549036800","1549036800","Completed","");
INSERT INTO cust_op VALUES("14","13","Security Plan","SP","1564675200","1564934400","Completed","");
INSERT INTO cust_op VALUES("15","13","Emergency/Response Plan","ERP","1565798400","1566057600","Completed","");
INSERT INTO cust_op VALUES("16","13","Security and Safety Drill","SASD","1565798400","1565798400","Completed","");
INSERT INTO cust_op VALUES("17","14","Security Assessment","SA","1555257600","1555257600","Completed","");
INSERT INTO cust_op VALUES("18","14","Security Plan","SP","1555257600","1555257600","Completed","");
INSERT INTO cust_op VALUES("19","14","Emergency/Response Plan","ERP","1555257600","1555257600","Completed","");
INSERT INTO cust_op VALUES("20","14","Security and Safety Drill","SASD","1555257600","1555257600","Completed","");
INSERT INTO cust_op VALUES("21","22","Security Assessment","SA","1574611200","1574784000","Pending","VENUE:SM SOUTHMALL");
INSERT INTO cust_op VALUES("22","22","Security Plan","SP","1572796800","1573228800","On-going","VENUE:DASMARINAS CAVITE");
INSERT INTO cust_op VALUES("23","20","Emergency/Response Plan","ERP","1574611200","1574956800","Cancelled","NOT AVAILABLE");
INSERT INTO cust_op VALUES("24","20","Security and Safety Drill","SSD","1572796800","1573056000","Completed","DONE");
INSERT INTO cust_op VALUES("25","17","Security Assessment","SA","1572796800","1573228800","On-going","VENUE:MAIN OFFICE");
INSERT INTO cust_op VALUES("26","17","Security Plan","S. PLAN","1574611200","1574956800","Pending","VENUE:HEAD OFFICE");
INSERT INTO cust_op VALUES("27","17","Emergency/Response Plan","EMERGENCY PLAN","1572105600","1572451200","Completed","COMPLETED");
INSERT INTO cust_op VALUES("28","17","Security and Safety Drill","SECURITY AND SAFETY DRILL","1574006400","1574352000","Cancelled","NOT AVAILABLE");
INSERT INTO cust_op VALUES("29","16","Security Assessment","VIP SECURITY","1574611200","1574956800","Pending","PENDING");
INSERT INTO cust_op VALUES("30","16","Security Plan","PLAN","1572192000","1572364800","Completed","COMPLETED");
INSERT INTO cust_op VALUES("31","16","Emergency/Response Plan","RESPONSE PLAN","1570118400","1570636800","Completed","COMPLETED");
INSERT INTO cust_op VALUES("32","16","Security and Safety Drill","SECURITY AND SAFETY DRILL","1575129600","1575561600","Cancelled","CANCELLED");



DROP TABLE cust_rep;

CREATE TABLE `cust_rep` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) DEFAULT NULL,
  `name` varchar(90) DEFAULT NULL,
  `department` varchar(40) DEFAULT NULL,
  `position` varchar(40) DEFAULT NULL,
  `mobileno` varchar(12) DEFAULT NULL,
  `email` mediumtext,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `custrep_idx` (`cust_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE cust_trng;

CREATE TABLE `cust_trng` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `description` mediumtext,
  `trng_date_fr` int(11) DEFAULT NULL,
  `trng_date_to` int(11) DEFAULT NULL,
  `trng_status` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `custtrg_idx` (`contract_id`,`type`,`trng_date_fr`,`trng_date_to`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

INSERT INTO cust_trng VALUES("1","7","Proficiency Firing","test data also","1567094400","1567440000","Completed","test data for training also");
INSERT INTO cust_trng VALUES("2","10","Training Plan","For Detective","1564588800","1564416000","On-going","");
INSERT INTO cust_trng VALUES("3","11","Training Plan","Firearms","1564761600","1565366400","Pending","");
INSERT INTO cust_trng VALUES("4","12","Training Plan","Training","1564588800","1564934400","Pending","");
INSERT INTO cust_trng VALUES("5","10","Proficiency Firing","PROF. FIRING","1567267200","1568304000","Completed","COMPLETE");
INSERT INTO cust_trng VALUES("6","10","CDP","CDP","1569168000","1569772800","Cancelled","CANCEL");
INSERT INTO cust_trng VALUES("7","10","Training Plan","TRAINING PLAN","1568563200","1568822400","On-going","ON GOING");
INSERT INTO cust_trng VALUES("8","11","Proficiency Firing","FIRING RANGE","1561910400","1562256000","Completed","COMPLETED");
INSERT INTO cust_trng VALUES("9","11","CDP","CDP","1568563200","1568908800","On-going","OG");
INSERT INTO cust_trng VALUES("10","12","Proficiency Firing","FIRING","1566662400","1567008000","Completed","COMPLETED");
INSERT INTO cust_trng VALUES("11","12","CDP","CDP","1564243200","1566662400","Completed","");
INSERT INTO cust_trng VALUES("12","13","Training Plan","TP","1549036800","1549900800","Completed","");
INSERT INTO cust_trng VALUES("13","13","Proficiency Firing","FIRING","1549900800","1550160000","Completed","");
INSERT INTO cust_trng VALUES("14","13","CDP","CDP","1569772800","1570204800","Cancelled","");
INSERT INTO cust_trng VALUES("15","14","Training Plan","INTEL","1552579200","1552320000","Completed","");
INSERT INTO cust_trng VALUES("16","14","Training Plan","SAFETY","1568822400","1569513600","Pending","");
INSERT INTO cust_trng VALUES("17","14","Proficiency Firing","FIRING","1552579200","1553443200","Completed","");
INSERT INTO cust_trng VALUES("18","14","CDP","CDP","1555257600","1556121600","Completed","");
INSERT INTO cust_trng VALUES("19","21","Training Plan","CUSTOMER SERVICE","1572019200","0","Pending","");
INSERT INTO cust_trng VALUES("20","21","Training Plan","SECURITY AWARENESS","1575043200","0","Pending","");
INSERT INTO cust_trng VALUES("21","21","Training Plan","WORKPLACE SAFETY & HAZARD ANALYSIS","1576857600","0","Pending","");
INSERT INTO cust_trng VALUES("22","22","Training Plan","DATA PRIVACY","1573056000","1574265600","Completed","");
INSERT INTO cust_trng VALUES("23","22","Training Plan","SELF DEFENSE TECHNIQUES","0","0","Completed","");
INSERT INTO cust_trng VALUES("24","22","Training Plan","GUN SAFETY","0","0","Completed","");
INSERT INTO cust_trng VALUES("25","22","Training Plan","OBSERVATION AND DETECTION","0","0","Pending","");
INSERT INTO cust_trng VALUES("26","22","Training Plan","BASIC INVESTIGATION","0","0","Pending","");
INSERT INTO cust_trng VALUES("27","22","Training Plan","SECURITY/SAFETY","0","0","Pending","");
INSERT INTO cust_trng VALUES("28","20","Training Plan","GUN AND AMMO","1574611200","1574956800","Pending","VENUE:SHANGRILA");
INSERT INTO cust_trng VALUES("29","20","Proficiency Firing","VIP","1574611200","1574956800","Completed","DONE");
INSERT INTO cust_trng VALUES("30","20","CDP","CDP","1572796800","1573228800","On-going","VENUE:EASTWOOD");
INSERT INTO cust_trng VALUES("31","17","Training Plan","GUNS AND AMMO","1572796800","1573747200","Pending","VENUE:CAMP CRAME");
INSERT INTO cust_trng VALUES("32","17","Proficiency Firing","PROF FIRING","1572796800","1572969600","Completed","VENUE:CAMP BAGONG DIWA");
INSERT INTO cust_trng VALUES("33","17","CDP","CDP","1574611200","1574870400","Cancelled","NOT AVAILABLE");
INSERT INTO cust_trng VALUES("34","16","Training Plan","TRAINING PLAN","1573488000","1574352000","Pending","PENDING");
INSERT INTO cust_trng VALUES("35","16","Proficiency Firing","FIRING","1573142400","1573401600","On-going","CAMP HENERAL LUNA");
INSERT INTO cust_trng VALUES("36","16","CDP","CDP","1572796800","1572969600","Completed","COMPLETED");



DROP TABLE cust_visitation;

CREATE TABLE `cust_visitation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) DEFAULT NULL,
  `officer_type` varchar(30) DEFAULT NULL,
  `frequency` int(3) DEFAULT NULL,
  `unit` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custvstn_idx` (`contract_id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

INSERT INTO cust_visitation VALUES("1","7","Top Management","4","Quarterly");
INSERT INTO cust_visitation VALUES("3","8","Account Supervisor","2","Monthly");
INSERT INTO cust_visitation VALUES("4","7","Top Management","4","Yearly");
INSERT INTO cust_visitation VALUES("9","11","Account Supervisor","1","Weekly");
INSERT INTO cust_visitation VALUES("10","5","Account Supervisor","2","Weekly");
INSERT INTO cust_visitation VALUES("11","10","Account Supervisor","2","Monthly");
INSERT INTO cust_visitation VALUES("12","13","Account Supervisor","2","Daily");
INSERT INTO cust_visitation VALUES("13","14","Account Supervisor","5","Weekly");
INSERT INTO cust_visitation VALUES("14","15","Account Supervisor","1","Daily");
INSERT INTO cust_visitation VALUES("15","10","Top Management","5","Monthly");
INSERT INTO cust_visitation VALUES("16","11","Top Management","2","Daily");
INSERT INTO cust_visitation VALUES("17","12","Top Management","1","Weekly");
INSERT INTO cust_visitation VALUES("18","13","Top Management","2","Monthly");
INSERT INTO cust_visitation VALUES("19","14","Top Management","4","Daily");
INSERT INTO cust_visitation VALUES("20","15","Top Management","6","Quarterly");
INSERT INTO cust_visitation VALUES("21","16","Account Supervisor","1","Semi-Annually");
INSERT INTO cust_visitation VALUES("22","16","Top Management","2","Yearly");
INSERT INTO cust_visitation VALUES("23","17","Account Supervisor","1","Daily");
INSERT INTO cust_visitation VALUES("24","17","Top Management","2","Weekly");
INSERT INTO cust_visitation VALUES("26","20","Account Supervisor","2","Daily");
INSERT INTO cust_visitation VALUES("27","20","Top Management","2","Weekly");
INSERT INTO cust_visitation VALUES("28","17","Account Supervisor","2","Daily");
INSERT INTO cust_visitation VALUES("29","17","Top Management","4","Weekly");
INSERT INTO cust_visitation VALUES("30","16","Account Supervisor","2","Daily");
INSERT INTO cust_visitation VALUES("31","16","Top Management","4","Weekly");
INSERT INTO cust_visitation VALUES("32","22","Account Supervisor","2","Daily");
INSERT INTO cust_visitation VALUES("33","22","Top Management","2","Weekly");
INSERT INTO cust_visitation VALUES("34","21","Account Supervisor","1","Weekly");
INSERT INTO cust_visitation VALUES("35","21","Top Management","2","Monthly");
INSERT INTO cust_visitation VALUES("36","21","Account Supervisor","3","Quarterly");
INSERT INTO cust_visitation VALUES("37","21","Top Management","4","Semi-Annually");



DROP TABLE dil_dtl;

CREATE TABLE `dil_dtl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdr_id` int(11) DEFAULT NULL,
  `dil_time` int(11) DEFAULT NULL,
  `postno` int(4) DEFAULT NULL,
  `code` varchar(25) DEFAULT NULL,
  `description` mediumtext,
  `duty_ofcr` mediumtext,
  `action` mediumtext,
  `note` mediumtext,
  `incidenttype` varchar(30) DEFAULT NULL,
  `category` varchar(30) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `concern` varchar(35) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dildtl_idx` (`hdr_id`,`refno`,`concern`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

INSERT INTO dil_dtl VALUES("4","4","1565677800","7","qwerty543","trying test","S1","very trying test","all notes","Major","Highlights","2034","");
INSERT INTO dil_dtl VALUES("5","5","1565863200","8","Dfg234","Nothing","S2","Ghostbuster","Ninja","Major","Lowlights","2081","");
INSERT INTO dil_dtl VALUES("6","6","1565949600","4","1543","Building","S3","Roving","Building C","None","Lowlights","2086","");
INSERT INTO dil_dtl VALUES("7","7","1568109600","0","cb123","inspecting premises","S1","None at the moment","Still testing","Major","Highlights","2091","");
INSERT INTO dil_dtl VALUES("8","8","1568856840","1","19999","Post 1","S1","Post 1","","Minor","Highlights","2740","");
INSERT INTO dil_dtl VALUES("9","9","1568856900","1","75154","Post 1","S2","Post 1","Post 1","Major","Lowlights","2743","");
INSERT INTO dil_dtl VALUES("10","10","1573207200","2","373","POST","S1","REPORT","MAIN OFFICE","Major","Highlights","3713","");
INSERT INTO dil_dtl VALUES("11","11","1573207200","1","00817","ABSENT","S1","ACTION","RELIEVER","Major","Highlights","3726","");
INSERT INTO dil_dtl VALUES("12","12","1573639200","1","67463","ABSENT","S1","REPORT","MAIN OFFICE","Major","Highlights","3810","");
INSERT INTO dil_dtl VALUES("13","13","1573621500","5","39636","SMOKING","S2","REPORT","MAIN OFFICE","Minor","Lowlights","3821","");
INSERT INTO dil_dtl VALUES("14","14","1576231200","2","3454","test","S1","test","none","Major","Highlights","3897","");
INSERT INTO dil_dtl VALUES("15","15","1576231200","2","75154","FUEL TANKER M/T DANIELLESAN UNDOCKED FROM JETTY PIER. INFORMED BY SG RICHARD BALABA (SECURITY CONTROL)","S1","FINISHED UNLOADING OF DIESEL FUEL FOR SBPL","S6","Major","Highlights","3901","");
INSERT INTO dil_dtl VALUES("16","16","1576210080","1","67463","12:08 26 MARCH 2019, ARRIVAL OF MR. DERICK GERVASIO AND MR. EMIL MANZA ON BOARD A WHITE MITSUBISHI MONTERO BEARING A PLATE NUMBER USQ 533 TO SECURITY SURVEY INSPECTION (SSI).","S1","FINISHING SECURITY SURVEY INSPECTION","S1","Minor","Lowlights","3903","");
INSERT INTO dil_dtl VALUES("17","17","1576248900","5","06583","DC KEN AND DC NAP WENT TO THE CONTRACT ADMINISTRATOR`S OFFICE ONBOARD AT VEHICLE PLATE #FO C651","S2","TO SUBMIT DOCUMENTS","S2","None","None","3906","");
INSERT INTO dil_dtl VALUES("18","20","1581328800","5","555123","DETAILS","S1","ACTION TAKEN","NOTE","Major","Highlights","4297","");
INSERT INTO dil_dtl VALUES("19","21","1581328800","12","567","DD","S4","AT","NT","Minor","None","4310","Logistics");



DROP TABLE dil_hdr;

CREATE TABLE `dil_hdr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) DEFAULT NULL,
  `contract_id` int(11) DEFAULT NULL,
  `dil_date` int(11) DEFAULT NULL,
  `officer` varchar(100) DEFAULT NULL,
  `dil_status` varchar(50) DEFAULT NULL,
  `alertlevel` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dilhdr_idx` (`client_id`,`contract_id`,`dil_date`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

INSERT INTO dil_hdr VALUES("4","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("5","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("6","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("7","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("8","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("9","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("10","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("11","98","456","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("12","92","17","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("13","92","17","1565625600","Jose Rizal","None","123");
INSERT INTO dil_hdr VALUES("14","28","22","1581091200","Jose Rizal","1565625600","123");
INSERT INTO dil_hdr VALUES("15","92","17","1576166400","","None","123");
INSERT INTO dil_hdr VALUES("16","92","17","1576166400","","None","123");
INSERT INTO dil_hdr VALUES("17","92","17","1576166400","","None","123");
INSERT INTO dil_hdr VALUES("18","28","22","1581264000","albotra,Joseph Tarriela","None","123");
INSERT INTO dil_hdr VALUES("19","92","17","1581264000","albotra,Joseph Tarriela","None","123");
INSERT INTO dil_hdr VALUES("20","92","17","1581264000","albotra,Joseph Tarriela","None","123");
INSERT INTO dil_hdr VALUES("21","92","17","1581264000","albotra,Joseph Tarriela","1581138180","123");



DROP TABLE doc_imgs;

CREATE TABLE `doc_imgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imgdate` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `appmod` varchar(15) DEFAULT NULL,
  `findex` mediumtext,
  `filetype` varchar(50) DEFAULT NULL,
  `filesize` bigint(20) DEFAULT NULL,
  `i_status` varchar(20) DEFAULT NULL,
  `userid` int(5) DEFAULT NULL,
  `dockind` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `docimgs_idx` (`refno`,`userid`,`imgdate`,`dockind`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO doc_imgs VALUES("1","1581980400","4767","RPTQRY","gsialogo_sm.jpg","image/jpeg","37567","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("4","1581980400","4786","RPTQRY","document_into3.jpg","image/jpeg","827","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("5","1581980400","4788","RPTQRY","27143998857700l.jpg","image/jpeg","105454","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("6","1581980400","4794","RPTQRY","bambang.jpg","image/jpeg","11514","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("7","1581980400","4797","RPTQRY","archer.gif","image/gif","1581","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("8","1581980400","4799","RPTQRY","0 031.jpg","image/jpeg","525269","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("9","1582153200","4880","RPTQRY","image.jpg","image/jpeg","1461411","NOT POSTED","7","RESPDOCIMG");
INSERT INTO doc_imgs VALUES("10","1594504800","5350","RPTQRY","Missing TD Acct no 018828.pdf","application/pdf","175010","NOT POSTED","7","RESPDOCIMG");



DROP TABLE eqpt_imgs;

CREATE TABLE `eqpt_imgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imgdate` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `appmod` varchar(15) DEFAULT NULL,
  `findex` mediumtext,
  `filetype` varchar(50) DEFAULT NULL,
  `filesize` bigint(20) DEFAULT NULL,
  `i_status` varchar(20) DEFAULT NULL,
  `userid` int(5) DEFAULT NULL,
  `viewtty` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eqptimgs_idx` (`refno`,`userid`,`imgdate`,`appmod`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO eqpt_imgs VALUES("1","1580400000","4139","CUSTMGT","Jellyfish.jpg","image/jpeg","775702","NOT POSTED","7","VIEW1");
INSERT INTO eqpt_imgs VALUES("2","1580400000","4139","CUSTMGT","Koala.jpg","image/jpeg","780831","NOT POSTED","7","VIEW2");



DROP TABLE lgstc_req_eqpt;

CREATE TABLE `lgstc_req_eqpt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `ekind` varchar(40) DEFAULT NULL,
  `etype` varchar(40) DEFAULT NULL,
  `description` mediumtext,
  `qty` int(4) DEFAULT NULL,
  `purpose` mediumtext,
  `note` mediumtext,
  `reqstatus` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `logreqeqpt_idx` (`hdrid`,`reqno`,`reqdate`,`reqstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

INSERT INTO lgstc_req_eqpt VALUES("2","36","2837","1568908800","Communication and Surveillance","HANDHELD RADIO","comms","4","","NONE-6","DISAPPROVED");
INSERT INTO lgstc_req_eqpt VALUES("3","7","2843","1571760000","Emergency Equipments","Sprinkler System","safety","8","","NONE","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("4","36","2957","1569168000","Communication and Surveillance","REPEATER","test again","8","","NONE-15","SERVED");
INSERT INTO lgstc_req_eqpt VALUES("5","18","3448","1569859200","Transportation","MOTORCYCLE","Motor","2","","NONE","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("6","20","3453","1569859200","Telecommunication","MOBILE PHONE","IPHONE","4","","NONE","APPROVED");
INSERT INTO lgstc_req_eqpt VALUES("7","21","3454","1581091200","Telecommunication","MOBILE PHONE","IPHONE","4","","NONE1569859200","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("8","22","3456","1569859200","Telecommunication","MOBILE PHONE","IPHONE","4","","NONE","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("9","24","3462","1581264000","Telecommunication","MOBILE PHONE","IPHONE","4","","NONE1569859200","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("10","36","3470","1569859200","Emergency Equipments","Fire Extinguisher","FE","2","","NONE-26","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("11","31","3719","1572710400","Communication and Surveillance","CCTV","CCTV","14","","NONE","APPROVED");
INSERT INTO lgstc_req_eqpt VALUES("12","36","4103","1580140800","Firearms","12 ga","tesr","2","","NONE-35","APPROVED");
INSERT INTO lgstc_req_eqpt VALUES("13","39","4672","1581868800","Transportation","MOTORCYCLE","patrol service","2","","NONE","APPROVED");
INSERT INTO lgstc_req_eqpt VALUES("14","40","4674","1581782400","Detectors","WALK THROUGH","test only","2","","NONE","PENDING");
INSERT INTO lgstc_req_eqpt VALUES("15","42","5338","1594396800","Detectors","HANDHELD","test","8","","NONE","PENDING");



DROP TABLE lgstc_req_hdr;

CREATE TABLE `lgstc_req_hdr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agency` varchar(50) DEFAULT NULL,
  `accno` int(11) DEFAULT NULL,
  `contract_id` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `reqtime` int(11) DEFAULT NULL,
  `author` mediumtext,
  `istatus` varchar(25) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `logreqhdr_idx` (`accno`,`contract_id`,`reqdate`,`agency`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

INSERT INTO lgstc_req_hdr VALUES("2","GSIA","10","10","1568822400","1568873820","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("3","GSIA","10","10","1568822400","1568873940","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("4","GSIA","10","10","1568822400","1568875020","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("5","GSIA","98","456","1568822400","1568893800","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("6","GSIA","98","456","1568822400","1568894400","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("7","GSIA","98","456","1568822400","1568895420","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("8","GSIA","98","456","1568822400","1568902200","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("9","GSIA","98","456","1568822400","1568902440","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("10","GSIA","10","10","1568822400","1568903040","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("11","GSIA","98","456","1568908800","1568909580","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("12","GSIA","98","456","1568908800","1568909880","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("13","GSIA","10","10","1568908800","1568910000","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("14","GSIA","98","456","1568995200","1569022500","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("15","GSIA","98","456","1569168000","1569252900","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("16","BLUEFLAME","28","22","1569859200","1569933600","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("17","","98","456","1569859200","1569934560","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("18","","92","17","1569859200","1569934620","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("19","GSIA","98","456","1569859200","1569935220","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("20","GSIA","98","456","1569859200","1569936060","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("21","BLUEFLAME","28","22","1569859200","1569936120","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("22","GSIA","98","456","1569859200","1569937620","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("23","GSIA","98","456","1569859200","1569937920","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("24","BLUEFLAME","28","22","1569859200","1569939780","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("25","GSIA","98","456","1569859200","1569940140","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("26","GSIA","98","456","1569859200","1569940200","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("27","GSIA","98","456","1569945600","1569972120","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("28","GSIA","98","456","1569945600","1569981780","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("29","GSIA","98","456","1569945600","1569982140","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("30","GSIA","98","456","1569945600","1570000740","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("31","GSIA","98","456","1573142400","1573201080","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("32","GSIA","98","456","1573142400","1573201200","Jose Rizal","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("33","GSIA","92","17","1574438400","1574483400","","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("34","GSIA","92","17","1580140800","1580183400","Villacrusis,Andepo D.","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("35","BLUEFLAME","92","17","1580140800","1580184660","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("36","BlueFlame","28","22","1581436800","1581497820","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("37","BlueFlame","28","22","1581868800","1581920340","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("38","BlueFlame","28","22","1581868800","1581920460","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("39","BlueFlame","28","22","1581868800","1581920580","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("40","BlueFlame","28","22","1581868800","1581921120","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("41","BlueFlame","28","22","1581868800","1581921420","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO lgstc_req_hdr VALUES("42","BlueFlame","28","22","1594396800","1594476840","albotra,Joseph Tarriela","NOT POSTED","NONE");



DROP TABLE lgstc_req_mpwr;

CREATE TABLE `lgstc_req_mpwr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `position` varchar(30) DEFAULT NULL,
  `gender` varchar(20) DEFAULT NULL,
  `qty` int(4) DEFAULT NULL,
  `urgency` varchar(30) DEFAULT NULL,
  `purpose` mediumtext,
  `reqstatus` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `logreqmpwr_idx` (`hdrid`,`reqno`,`reqdate`,`urgency`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

INSERT INTO lgstc_req_mpwr VALUES("2","3","2811","9","Officer","Female","8","High Priority","test 12345678","SERVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("3","4","2816","9","Lady Guard","Female","5","Emergency","augment","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("4","36","2936","1568995200","Officer","Male","6","Emergency","PENDING-14","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("5","16","3429","1569859200","Lady Guard","Female","2","High Priority","","SERVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("6","16","3429","1569859200","Lady Guard","Female","2","High Priority","Augment Personnel requirements","DISAPPROVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("7","17","3447","1569859200","Lady Guard","Female","1","High Priority","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("8","36","3448","1569859200","Lady Guard","Female","2","High Priority","PENDING-18","APPROVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("9","18","3448","1569859200","Lady Guard","Female","2","High Priority","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("10","19","3451","1569859200","Lady Guard","Female","2","High Priority","LG","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("11","20","3453","1569859200","Lady Guard","Female","5","High Priority","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("12","22","3456","1569859200","Lady Guard","Female","4","High Priority","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("13","23","3458","1569859200","Officer","Female","2","High Priority","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("14","16","3469","1569859200","Nurse","Female","2","High Priority","Lady Guard-pending-25","SERVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("15","26","3470","1569859200","Lady Guard","Female","2","High Priority","Nurse","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("16","16","3553","1569945600","Officer","Female","1","High Priority","Officer","SERVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("17","16","3599","1569945600","Officer","Female","2","Emergency","Emergency","DISAPPROVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("18","28","3599","1569945600","Officer","Female","2","Emergency","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("19","29","3600","1569945600","Lady Guard","Female","2","Emergency","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("20","30","3658","1569945600","Officer","Male","2","Emergency","test","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("21","31","3719","1573142400","Officer","Female","4","High Priority","RELIEVER","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("22","33","3874","1574438400","Lady Guard","Female","5","High Priority","ADDITIONAL","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("23","36","4101","1580140800","Security Guard","Male","6","Emergency","test-34","SERVED","NONE");
INSERT INTO lgstc_req_mpwr VALUES("24","37","4668","1581091200","Utility","Male","3","Emergency","test purposes","APPROVED","1581868800NONE");
INSERT INTO lgstc_req_mpwr VALUES("25","38","4670","1581868800","Security Guard","Male","1","Emergency","test again","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("26","42","5337","1594396800","Officer","Male","8","High Priority","urgent test","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("27","42","5337","1595865600","Officer","Male","0","High Priority","","PENDING","NONE");
INSERT INTO lgstc_req_mpwr VALUES("28","42","5341","1581264000","Officer","Female","2","Emergency","test908","APPROVED","NONE1595347200");



DROP TABLE lgstc_req_oppln;

CREATE TABLE `lgstc_req_oppln` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `type` mediumtext,
  `description` mediumtext,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `note` mediumtext,
  `reqstatus` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `logreqopplna_idx` (`hdrid`,`reqno`,`reqdate`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO lgstc_req_oppln VALUES("2","36","2853","1581091200","Security Plan","what the heck","1571241600","1572278400","1569340800NONE - 8","SERVED");
INSERT INTO lgstc_req_oppln VALUES("4","10","2858","1569340800","Emergency/Response Plan","test123 test explain","1568822400","1569427200","NONE","PENDING");
INSERT INTO lgstc_req_oppln VALUES("5","36","2858","1567612800","Security and Safety Drill","test explanation","1569254400","1569686400","NONE -10","DISAPPROVED");
INSERT INTO lgstc_req_oppln VALUES("6","18","3448","1569859200","Emergency/Response Plan","Emergency RP","1569859200","1570204800","NONE","PENDING");
INSERT INTO lgstc_req_oppln VALUES("7","27","3553","1569859200","Emergency/Response Plan","ERP","1570377600","1570636800","NONE","PENDING");
INSERT INTO lgstc_req_oppln VALUES("8","36","3553","1570204800","Security Plan","SP","1570982400","1571241600","NONE -27","APPROVED");
INSERT INTO lgstc_req_oppln VALUES("9","36","3720","1581264000","Security and Safety Drill","SSD","1573920000","1574352000","1572796800NONE - 32","DISAPPROVED");
INSERT INTO lgstc_req_oppln VALUES("10","40","4675","1581868800","Security and Safety Drill","test only","1581955200","1582560000","NONE","PENDING");
INSERT INTO lgstc_req_oppln VALUES("11","42","5339","1594396800","Security Assessment","test123","1594396800","1594396800","NONE","PENDING");



DROP TABLE lgstc_req_trng;

CREATE TABLE `lgstc_req_trng` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `reqdate` int(11) DEFAULT NULL,
  `type` mediumtext,
  `description` mediumtext,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `note` mediumtext,
  `reqstatus` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `logreqtrng_idx` (`hdrid`,`reqno`,`reqdate`,`reqstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO lgstc_req_trng VALUES("1","36","2862","1581091200","Training Plan","test 1234","1568736000","1569081600","1569772800NONE-11","SERVED");
INSERT INTO lgstc_req_trng VALUES("2","36","2863","1569772800","CDP","test again an again","1570118400","1571587200","NONE-12","DISAPPROVED");
INSERT INTO lgstc_req_trng VALUES("3","36","2864","1569427200","Proficiency Firing","shoot to kill","1569427200","1569513600","NONE-13","APPROVED");
INSERT INTO lgstc_req_trng VALUES("4","36","3448","1581264000","Training Plan","Inteligence","1570291200","1570723200","1569859200NONE-18","PENDING");
INSERT INTO lgstc_req_trng VALUES("5","41","4678","1581868800","CDP","test only","1581868800","1582646400","NONE","APPROVED");
INSERT INTO lgstc_req_trng VALUES("6","42","5340","1594396800","CDP","test4567","1594396800","1594396800","NONE","PENDING");



DROP TABLE mpwr_imgs;

CREATE TABLE `mpwr_imgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imgdate` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `appmod` varchar(15) DEFAULT NULL,
  `findex` mediumtext,
  `filetype` varchar(50) DEFAULT NULL,
  `filesize` bigint(20) DEFAULT NULL,
  `i_status` varchar(20) DEFAULT NULL,
  `userid` int(5) DEFAULT NULL,
  `viewtty` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mpwrimgs_idx` (`userid`,`refno`,`appmod`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

INSERT INTO mpwr_imgs VALUES("1","1580400000","4132","CUSTMGT","Princess Mae Tenoso-1x1.jpg","image/jpeg","62011","NOT POSTED","7","HEADPIC");
INSERT INTO mpwr_imgs VALUES("2","1580400000","4132","CUSTMGT","received_909232896099962_1.jpg","image/jpeg","140817","NOT POSTED","7","WBODYPIC");



DROP TABLE pdf_forms;

CREATE TABLE `pdf_forms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idate` int(11) DEFAULT NULL,
  `formname` mediumtext,
  `module` mediumtext,
  `istatus` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE qrc_ref;

CREATE TABLE `qrc_ref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE rqst_response;

CREATE TABLE `rqst_response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `respno` int(11) DEFAULT NULL,
  `respdate` int(11) DEFAULT NULL,
  `reqno` int(11) DEFAULT NULL,
  `resptype` varchar(50) DEFAULT NULL,
  `approval` varchar(25) DEFAULT NULL,
  `note` mediumtext,
  `apvstatus` varchar(25) DEFAULT NULL,
  `authorid` int(11) DEFAULT NULL,
  `authorname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reqresp_idx` (`reqno`,`respno`,`respdate`,`apvstatus`,`authorid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

INSERT INTO rqst_response VALUES("1","4786","0","4678","Training","APPROVED","test approval","NOT POSTED","7","");
INSERT INTO rqst_response VALUES("2","4786","0","4678","Training","APPROVED","test approval","NOT POSTED","7","");
INSERT INTO rqst_response VALUES("3","4786","0","4678","Training","APPROVED","test approval","NOT POSTED","7","albotra,Joseph Tarriela");
INSERT INTO rqst_response VALUES("4","4788","1582041600","3429","Manpower","DISAPPROVED","did not comply","NOT POSTED","7","albotra,Joseph Tarriela");
INSERT INTO rqst_response VALUES("5","4794","1582041600","3720","Operations Plan","DISAPPROVED","already given","NOT POSTED","7","albotra,Joseph Tarriela");
INSERT INTO rqst_response VALUES("6","4795","1594310400","4668","Manpower","SERVED","test again","NOT POSTED","7","albotra,Joseph Tarriela");
INSERT INTO rqst_response VALUES("7","4797","1582041600","4672","Equipment","APPROVED","anytime","NOT POSTED","7","albotra,Joseph Tarriela");
INSERT INTO rqst_response VALUES("8","4804","1594310400","4101","Manpower","SERVED","test again","NOT POSTED","7","albotra,Joseph Tarriela");
INSERT INTO rqst_response VALUES("9","5350","1594483200","4101","Manpower","SERVED","","NOT POSTED","7","albotra,Joseph Tarriela");



DROP TABLE rslvd_iscon;

CREATE TABLE `rslvd_iscon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isconid` int(11) DEFAULT NULL,
  `resdate` int(11) DEFAULT NULL,
  `resolution` mediumtext,
  `author` varchar(50) DEFAULT NULL,
  `reqstatus` varchar(35) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `rslvdiscon_idx` (`isconid`,`resdate`,`reqstatus`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

INSERT INTO rslvd_iscon VALUES("2","1","1579057007","test resolution again","","RESOLVED","NONE");
INSERT INTO rslvd_iscon VALUES("3","5","1579060210","test resolution number 5","","NOT POSTED","NONE");
INSERT INTO rslvd_iscon VALUES("4","5","1579060664","test resolution number 7","","NOT POSTED","NONE");



DROP TABLE vi_eqpt_fdgs;

CREATE TABLE `vi_eqpt_fdgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `ekind` varchar(80) DEFAULT NULL,
  `etype` varchar(80) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `eqc` varchar(30) DEFAULT NULL,
  `eqcn` mediumtext,
  `fnc` varchar(30) DEFAULT NULL,
  `fncn` mediumtext,
  `mtn` varchar(30) DEFAULT NULL,
  `mtnn` mediumtext,
  `docs` varchar(30) DEFAULT NULL,
  `docsn` mediumtext,
  `rdns` mediumtext,
  `rdnsn` varchar(30) DEFAULT NULL,
  `notes` mediumtext,
  PRIMARY KEY (`id`),
  KEY `vieqptfdgs_idx` (`hdrid`,`refno`,`ekind`,`etype`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

INSERT INTO vi_eqpt_fdgs VALUES("2","9","2669","Communication and Surveillance","SEARCH LIGHT","2","eqc1*Complete","this is a test note","fnc1*Complete","its working!","mtn2*Due for PMS","adfdaf","docs1^^docs2^^docs3^^","cvzcv","rdns2*2","zcvcv","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("3","9","2669","Communication and Surveillance","SEARCH LIGHT","2","eqc2*Incomplete","Missing parts","fnc2*Not Operational","wear and tear","mtn2*Due for PMS","for next month","docs2^^","no license","rdns2*2","not ready","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("4","15","0","Firearms","5.6 mm","5","eqc1*Complete","test","fnc1*Operational","test","mtn2*Due for PMS","due","docs1^^","not present","rdns2*2","not ready","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("5","15","0","Transportation","MOTORCYCLE","3","eqc1*Complete","test","fnc1*Operational","test","mtn2*Due for PMS","due","docs2^^","test","rdns3*3","test","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("6","15","0","Firearms","5.6 mm","5","eqc1*Complete","test","fnc1*Operational","test","mtn2*Due for PMS","due","docs1^^","not present","rdns2*2","not ready","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("7","15","3400","Transportation","MOTORCYCLE","3","eqc2*Incomplete","missing","fnc2*Not Operational","yes","mtn2*Due for PMS","due","docs2^^","active","rdns3*3","test","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("8","16","3408","Telecommunication","DESKTOP/LAPTOP","1","eqc1*Complete","Complete","fnc2*Not Operational","Not Operational","mtn2*Due for PMS","Check","docs2^^","","rdns3*3","","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("9","16","3408","Telecommunication","DESKTOP/LAPTOP","1","eqc1*Complete","Complete","fnc2*Not Operational","Not Operational","mtn2*Due for PMS","Check","docs2^^","","rdns3*3","","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("10","17","3411","Firearms","5.6 mm","5","eqc1*Complete","Complete 1","fnc1*Operational","Operational 1","mtn1*Current","Current1","docs3^^","Others 1","rdns2*2","2.2","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("11","17","3411","Firearms","5.6 mm","5","eqc1*Complete","Complete 1","fnc1*Operational","Operational 1","mtn1*Current","Current1","docs3^^","Others 1","rdns2*2","2.2","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("12","22","3439","Telecommunication","DESKTOP/LAPTOP","1","eqc1*Complete","Complete","fnc2*Not Operational","No Display","mtn2*Due for PMS","For Repair","docs3^^","Pull Out","rdns1*1","1.1","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("13","22","3440","Firearms","5.6 mm","5","eqc1*Complete","","fnc1*Operational","","mtn1*Current","","docs2^^","License Update","rdns1*1","","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("14","30","4489","Firearms",".38 Cal","22","eqc1*Complete","Complete","fnc1*Operational","Operational","mtn1*Current","Current","docs1^^","Ltopf","rdns1*1","1.1","NONE");
INSERT INTO vi_eqpt_fdgs VALUES("15","32","4499","Telecommunication","MOBILE PHONE","1","eqc2*Incomplete","Incomplete","fnc2*Not Operational","Not Operational","mtn2*Due for PMS","Due to PMS","docs3^^","Others","rdns2*2","2.2","NONE");



DROP TABLE vi_hdr;

CREATE TABLE `vi_hdr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agency` varchar(80) DEFAULT NULL,
  `cust_id` int(11) DEFAULT NULL,
  `contract_id` int(11) DEFAULT NULL,
  `vi_date` int(11) DEFAULT NULL,
  `vi_time` int(11) DEFAULT NULL,
  `officer` varchar(50) DEFAULT NULL,
  `vi_status` varchar(30) DEFAULT NULL,
  `vi_note` mediumtext,
  PRIMARY KEY (`id`),
  KEY `vihdr_idx` (`cust_id`,`contract_id`,`agency`,`vi_date`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;

INSERT INTO vi_hdr VALUES("6","GSIA","28","22","1568649600","1568709480","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("7","GSIA","11","11","1568649600","1568725980","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("8","GSIA","92","17","1568736000","1568759940","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("9","GSIA","41","24","1568736000","1568779800","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("10","GSIA","41","24","1568736000","1568788320","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("11","GSIA","98","26","1568736000","1568789760","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("12","GSIA","92","17","1568736000","1568791560","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("13","GSIA","98","26","1568736000","1568808240","Jose Rizal","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("14","GSIA","10","10","1569859200","1569911160","Jardio,Omar","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("15","GSIA","11","11","1569859200","1569912960","Jardio,Omar","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("16","GSIA","10","10","1569859200","1569930960","Jardio,Omar","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("17","GSIA","10","10","1569859200","1569931080","Jardio,Omar","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("18","GSIA","10","10","1569859200","1569933120","Gervasio,Dereck","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("19","GSIA","10","10","1569859200","1569933180","Gervasio,Dereck","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("20","GSIA","10","10","1569859200","1569933420","Jardio,Omar","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("21","","10","10","1569859200","1569933540","Jardio,Omar","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("22","","17","92","1569859200","1569934140","Gervasio,Dereck","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("23","BlueFlame","28","22","1573488000","1573539240","","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("24","GSIA","92","17","1574438400","1574488620","","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("25","BlueFlame","28","22","1581436800","1581483480","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("26","BlueFlame","28","22","1581523200","1581581460","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("27","BlueFlame","28","22","1581091200","1581646140","albotra,Joseph Tarriela","NOT POSTED","1581609600NONE");
INSERT INTO vi_hdr VALUES("28","GSIA","92","17","1581609600","1581646680","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("29","BlueFlame","28","22","1581609600","1581647940","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("30","BlueFlame","28","22","1581264000","1581648540","albotra,Joseph Tarriela","NOT POSTED","1581609600NONE");
INSERT INTO vi_hdr VALUES("31","BlueFlame","28","22","1581609600","1581648840","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("32","BlueFlame","28","22","1581609600","1581656520","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("33","BlueFlame","28","22","1582473600","1582510380","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("34","BlueFlame","92","17","1593014400","1593069120","albotra,Joseph Tarriela","NOT POSTED","NONE");
INSERT INTO vi_hdr VALUES("35","BlueFlame","28","22","0","0","Jardio,Omar","NOT POSTED","NONE");



DROP TABLE vi_mpwr_ifdg;

CREATE TABLE `vi_mpwr_ifdg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `postno` int(11) DEFAULT NULL,
  `empid` varchar(25) DEFAULT NULL,
  `licno` varchar(25) DEFAULT NULL,
  `ifdgs` mediumtext,
  `istatus` varchar(50) DEFAULT NULL,
  `notes` mediumtext,
  PRIMARY KEY (`id`),
  KEY `vimpif_idx` (`hdrid`,`refno`,`empid`,`licno`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO vi_mpwr_ifdg VALUES("3","32","2514","1","22331578","22331578","ue2^^ue14^^ph2^^oth3^^icom2^^3~22331578~Last and Final Warning^^","w2*2nd Warning","NONE-6");
INSERT INTO vi_mpwr_ifdg VALUES("6","7","2514","1","22331578","22331578","ue6^^ue17^^ue23^^ph1^^oth2^^oth3^^oth4^^icom3^^","w3*Last and Final Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("7","23","3362","1","3033","","ue3^^ue15^^ue22^^ph2^^oth2^^oth4^^icom1^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("8","14","3362","1","2001","2001","ue6^^ue7^^ue8^^ue9^^ue21^^ph5^^oth6^^oth11^^oth16^^icom1^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("9","14","3362","1","2002","2002","ue5^^ue13^^ue17^^ue23^^ue25^^ph1^^ph2^^oth1^^oth6^^oth7^^oth9^^oth10^^oth14^^oth15^^icom1^^","w2*2nd Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("10","22","3435","1","","","ue1^^ue9^^ue17^^ph1^^ph3^^ph5^^oth1^^oth7^^oth13^^icom2^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("11","23","3795","1","3032","3032","ue8^^ph2^^oth15^^icom2^^","w2*2nd Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("12","24","3880","1","1","1","ue6^^ue22^^oth1^^icom1^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("13","25","4371","1","3032","3032","ue9^^ph1^^oth7^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("14","26","4423","1","3032","3032","ue17^^ph3^^oth16^^","w3*Last and Final Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("15","31","4491","1","3032","3032","ue1^^ue9^^ue17^^ph2^^oth1^^oth7^^oth13^^icom1^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("16","31","4491","1","3032","3032","ue1^^ue10^^ue11^^ue12^^ph1^^oth1^^icom3^^","w1*1st Warning","NONE");
INSERT INTO vi_mpwr_ifdg VALUES("17","32","4499","1","3033","3033","ue9^^ph2^^oth1^^icom3^^","w1*1st Warning","NONE");



DROP TABLE vi_mpwr_ofdg;

CREATE TABLE `vi_mpwr_ofdg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `postno` int(4) DEFAULT NULL,
  `empid` varchar(25) DEFAULT NULL,
  `licno` varchar(30) DEFAULT NULL,
  `cfk` varchar(30) DEFAULT NULL,
  `cfkn` mediumtext,
  `sxs` varchar(30) DEFAULT NULL,
  `sxsn` mediumtext,
  `akg` varchar(30) DEFAULT NULL,
  `akgn` mediumtext,
  `ovfn` mediumtext,
  `ostatus` varchar(30) DEFAULT NULL,
  `notes` mediumtext,
  PRIMARY KEY (`id`),
  KEY `vimpof_idx` (`hdrid`,`refno`,`empid`,`licno`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO vi_mpwr_ofdg VALUES("1","6","2572","1","3059","R4A20180101859","cfk2*Fail","this is a test","sxs2*Fail","this another test","akg1*Pass","this is the third test","this is an overall findings","","NONE");
INSERT INTO vi_mpwr_ofdg VALUES("3","6","2572","1","3060","R07-0181100047","cfk2*Fail","what a day!","sxs1*Pass","there are seven s not 9","akg2*Fail","can shoot well but walk zigag","return to bed","","NONE");
INSERT INTO vi_mpwr_ofdg VALUES("4","8","2572","1","22331578","22331578","cfk2*Fail","what a day!","sxs2*Fail","there are seven s not 12","akg2*Fail","can shoot well but walk zigag","return to classroom","","NONE");
INSERT INTO vi_mpwr_ofdg VALUES("9","33","4931","1","3036","3036","cfk2*Fail","test failed","sxs1*Pass","ok test","akg1*Pass","looks ok","-test only-test 2 
-test3","","NONE");
INSERT INTO vi_mpwr_ofdg VALUES("10","35","5464","0","","","cfk1*Pass","","sxs1*Pass","","akg1*Pass","","Overall findings","","NONE");



DROP TABLE vi_oppln_fdgs;

CREATE TABLE `vi_oppln_fdgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `type` mediumtext,
  `description` mediumtext,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `imp` varchar(100) DEFAULT NULL,
  `impnotes` mediumtext,
  `rlv` varchar(100) DEFAULT NULL,
  `rlvnotes` mediumtext,
  `docs` varchar(100) DEFAULT NULL,
  `docsnotes` mediumtext,
  `rdns` varchar(100) DEFAULT NULL,
  `rdnsnotes` mediumtext,
  `opstatus` varchar(40) DEFAULT NULL,
  `notes` mediumtext,
  PRIMARY KEY (`id`),
  KEY `viopfdg_idx` (`hdrid`,`refno`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

INSERT INTO vi_oppln_fdgs VALUES("3","11","0","Security Assessment","SA","0","0","imp1*Executed","since last year","rlv1*for Renewal/Re-implementa","should be re-taught","docs1^^","not yet given","rdns1*3","ready","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("4","11","0","Security Assessment","SA","0","0","imp1*Executed","since last year","rlv1*for Renewal/Re-implementa","should be re-taught","docs1^^","not yet given","rdns1*3","ready not really","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("5","12","2712","Security Assessment","SA","0","0","imp1*Executed","fgfdgfd","rlv1*Current","sfgfgf","docs1^^docs2^^","","rdns3*3","qewrew fdfdfd","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("6","12","2713","Security Assessment","SA","1567353600","1567699200","imp1*Executed","adf","rlv1*for Renewal/Re-implementa","adf test","docs2^^docs3^^","adfdf","rdns1*1","adfd","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("7","18","3415","Security Assessment","Security Assessment","1564588800","1567180800","imp1*Executed","Executed","rlv1*Current","Current","docs1^^","Cert.","rdns1*1","1.1","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("8","21","3427","Emergency/Response Plan","EMERGENCY","1567267200","1567699200","imp1*Executed","","rlv1*Current","","docs2^^","","rdns1*1","","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("9","22","3442","Emergency/Response Plan","EMERGENCY","1567267200","1567699200","imp1*Executed","Emergency","rlv1*for Renewal/Re-implementation","Renewal","docs3^^","Renew","rdns1*1","1.1","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("10","31","4491","Security Assessment","For testing SA","1574611200","1574784000","imp1*Executed","Executed","rlv1*Current","Current","docs1^^","Certificates","rdns1*1","1.1","","NONE");
INSERT INTO vi_oppln_fdgs VALUES("11","32","4499","Security Assessment","Test only SA","1574611200","1574784000","imp1*Executed","Executed","rlv1*for Renewal/Re-implementation","For Renewal","docs3^^","Others","rdns1*1","1.1","","NONE");



DROP TABLE vi_trng_fdgs;

CREATE TABLE `vi_trng_fdgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `hdrid` int(11) DEFAULT NULL,
  `refno` int(11) DEFAULT NULL,
  `type` mediumtext,
  `description` mediumtext,
  `start` int(11) DEFAULT NULL,
  `end` int(11) DEFAULT NULL,
  `imp` varchar(100) DEFAULT NULL,
  `impnotes` mediumtext,
  `rlv` varchar(100) DEFAULT NULL,
  `rlvnotes` mediumtext,
  `docs` varchar(100) DEFAULT NULL,
  `docsnotes` mediumtext,
  `rdns` varchar(100) DEFAULT NULL,
  `rdnsnotes` mediumtext,
  `status` varchar(40) DEFAULT NULL,
  `notes` mediumtext,
  PRIMARY KEY (`id`),
  KEY `vitrgfdg_idx` (`hdrid`,`refno`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO vi_trng_fdgs VALUES("2","13","2719","Proficiency Firing","FIRING RANGE","1561910400","1562256000","imp2*for Execution","TEST20","rlv1*Current","TEST2 TEST5","docs1^^docs2^^","TEST3YTEST","rdns3*3","TEST4 NOT A TEST","","NONE");
INSERT INTO vi_trng_fdgs VALUES("3","19","3418","Proficiency Firing","PROF. FIRING","1567267200","1568304000","imp1*Executed","Executed","rlv1*Current","Current","docs2^^","Manuals","rdns2*2","2.2","","NONE");
INSERT INTO vi_trng_fdgs VALUES("4","20","3421","Training Plan","For Detective","1564588800","1564416000","imp2*for Execution","","rlv1*for Renewal/Re-implementation","","docs3^^","","rdns1*1","","","NONE");
INSERT INTO vi_trng_fdgs VALUES("5","20","3423","CDP","CDP","1569168000","1569772800","imp1*Executed","Executed","rlv1*Current","Current","docs1^^","Cert","rdns1*1","1.1","","NONE");
INSERT INTO vi_trng_fdgs VALUES("6","22","3444","Proficiency Firing","PROF. FIRING","1567267200","1568304000","imp1*Executed","Firing","rlv1*Current","Firing","docs3^^","Firing","rdns3*3","3.3","","NONE");
INSERT INTO vi_trng_fdgs VALUES("7","31","4491","Training Plan","for test only DATA PRIVACY","-28800","-28800","imp1*Executed","Executed","rlv1*Current","Current","docs1^^","Certificates","rdns1*1","1.1","","NONE");
INSERT INTO vi_trng_fdgs VALUES("8","32","4499","Training Plan","testing only DATA PRIVACY","-28800","-28800","imp2*for Execution","not yet executed","rlv1*Current","Current","docs2^^","Manuals","rdns3*3","3.3","","NONE");
INSERT INTO vi_trng_fdgs VALUES("9","34","5218","Training Plan","GUNS AND AMMO","1572796800","1573747200","imp1*Executed","","rlv1*Current","","docs2^^","","rdns1*1","","","NONE");
INSERT INTO vi_trng_fdgs VALUES("10","34","5218","Training Plan","GUNS AND AMMO","1572796800","1573747200","imp1*Executed","test","rlv1*for Renewal/Re-implementation","test","docs3^^","","rdns3*3","test","","NONE");



