Posts: 41
Threads: 20
Joined: Jun 2024
06-26-2024, 01:59 PM
(This post was last modified: 06-26-2024, 02:06 PM by UnicornLover67.)
website: cancomsecurity.com
Quote: "Cancom Security Inc. is dedicated to providing peace of mind to our
clients through proactive security services while enhancing their
personal safety and protecting their properties and proprietary
information."
Revenue: ~ $100M
download cancomsecurity.tar.gz
Hidden Content
You must register or login to view this content.
https://cancomsecurity.com/cyber-security/
CEO, Ronald Wells
[email=ronald.wells@cancomsecurity.com]ronald.wells@cancomsecurity.com[/email] Polsa72809!
416-994-6793 (he does not care about his clients & employees, offered to show vulnerabilities and not leak data for extremely good price lol)
![[Image: t9pdat.png]](https://external-content.duckduckgo.com/iu/?u=https%3A%2F%2Ffiles.catbox.moe%2Ft9pdat.png)
small example datas, Спасибо
userID,name,role,region,status,password,username,onboarding,securityLicence,authorizedClients,lastLoginDatetime
4,Ronald
Wells,Management,ON-GTA,1,6+,RonaldWells,0,250821,"[""91"",""187"",""89"",""182"",""202"",""175"",""196"",""157"",""190"",""219"",""92"",""94"",""177"",""183"",""201"",""131"",""88"",""186"",""206"",""107"",""17"",""184"",""172"",""151"",""154"",""159"",""153"",""155"",""18"",""102"",""103"",""20"",""21"",""149"",""15"",""16"",""146"",""140"",""235"",""178"",""22"",""26"",""185"",""236"",""220"",""221"",""142"",""23"",""207"",""110"",""127"",""41"",""145"",""73"",""74"",""72"",""194"",""181"",""218"",""133"",""170"",""105"",""96"",""121"",""44"",""39"",""29"",""31"",""30"",""104"",""40"",""34"",""32"",""35"",""33"",""28"",""37"",""38"",""36"",""27"",""122"",""143"",""101"",""144"",""191"",""42"",""192"",""118"",""43"",""215"",""212"",""147"",""45"",""134"",""208"",""46"",""193"",""47"",""200"",""106"",""49"",""217"",""165"",""50"",""51"",""52"",""162"",""168"",""53"",""54"",""210"",""160"",""55"",""56"",""166"",""163"",""161"",""62"",""64"",""167"",""57"",""58"",""164"",""171"",""59"
",""60"",""179"",""61"",""197"",""180"",""173"",""63"",""65"",""189"",""209"",""108"",""109"",""66"",""198"",""130"",""203"",""90"",""69"",""93"",""169"",""128"",""68"",""124"",""137"",""138"",""129"",""75"",""67"",""148"",""97"",""98"",""99"",""126"",""188"",""70"",""71"",""205"",""136"",""152"",""139"",""176"",""116"",""117"",""216"",""158"",""214"",""222"",""95"",""77"",""204"",""228"",""224"",""233"",""230"",""232"",""225"",""223"",""234"",""213"",""82"",""24"",""25"",""48"",""19"",""226"",""227"",""231"",""229"",""141"",""78"",""79"",""132"",""125"",""80"",""123"",""199"",""113"",""211"",""112"",""114"",""115"",""111"",""81"",""119"",""76"",""100"",""150"",""195"",""156"",""174"",""83"",""85"",""86"",""87"",""135"",""84""]",2024-06-12
00:30:33
id,userID,city,sin,email,gender,street,country,hire_date,last_name,sin_image,birth_date,first_name,bank_number,postal_code,indian_image,phone_number,approval_date,indian_status,account_number,first_aid_type,middle_initial,province_state,transit_number,drivers_licence,first_aid_image,indian_exp_date,sin_expiry_date,firearms_licence,first_aid_agency,healthcard_image,security_licence,healthcard_number,indian_reg_number,preapproval_notes,first_aid_exp_date,indian_inac_serial,healthcard_exp_date,direct_deposit_image,drivers_licence_class,drivers_licence_image,firearms_licence_auth,first_aid_certificate,firearms_licence_image,security_licence_class,security_licence_image,drivers_licence_exp_date,firearms_licence_exp_date,security_licence_exp_date,drivers_licence_issue_date
15,1208,<blank>,<blank>,mail@cancomsecurity.com,U,"1183 Finch Ave
West, Suite
205",CAN,2020-09-02,Test,0000015-sin.jpg,<blank>,Cancom,<blank>,m3j2g2,NULL,416-763-0000,<blank>,1,<blank>,Standard,1,ON,11251,W2045-34450-11110,0000015-first_aid.png,NULL,2022-02-25,<blank>,Rescue
&,NULL,11111110,<blank>,<blank>,NULL,2023-04-04,<blank>,NULL,0000015-direct_deposit.jpg,G,0000015-drivers_lic.jpeg,Restricted,2211344553,NULL,S,0000015-security_lic.jfif,2022-04-04,NULL,2022-04-04,2018-04-04
16,1210,Essex,492652295,shawn.leroux@gmail.com,M,297 Woodview
Drive,CAN,2020-09-08,wells,0000016-sin.jpg,2020-07-08,ryan,000,N8M
3E8,NULL,2267570000,NULL,1,123456789,Emergency,d,ON,03030,L2458*5986*5455,0000016-first_aid.jpg,NULL,2020-09-08,123456789,Cancom,0000016-health_card.jpg,223995,1616166361,<blank>,NULL,2022-09-08,<blank>,2022-10-08,0000016-direct_deposit.jpg,GM,0000016-drivers_lic.jpg,Restricted,12121212,0000016-firearms_lic.jpg,Guard,0000016-security_lic.jpg,2020-10-20,2022-10-08,2100-09-08,1986-11-08
17,1212,Toronto,123-456-789,scheduling@cancomsecurity.com,M,1183 Finch
Ave
West,CAN,2020-09-08,Dogan,0000017-sin.xltx,1984-03-08,Merdan,345,M6M1P5,NULL,416-763-0000,NULL,1,34554345,Standard,f,ON,54345,werwerwerwerwer,0000017-first_aid.xlsx,NULL,NULL,234wedfsdf234,Rescue
7,NULL,11167131,rwerwerwer234wer,<blank>,NULL,2024-11-08,<blank>,2020-12-22,0000017-direct_deposit.xltx,G,0000017-drivers_lic.xlsx,Restricted,234234234,NULL,Active,0000017-security_lic.xltx,2020-09-02,2022-10-13,2022-10-08,2022-10-11
18,1211,Toronto,59000006,carlosiglesias.cig@hotmail.com,M,1183 Finch
Ave West suite
205,CAN,2020-09-08,Testing6,0000018-sin.jpg,2020-09-30,carlos,562,M3J2G2,NULL,4168590719,NULL,1,123456789,Standard,m,ON,12345,987456123,0000018-first_aid.pdf,NULL,2023-07-08,000012345678,cancom,0000018-health_card.pdf,123456789,3216540000,<blank>,NULL,2023-06-08,<blank>,2028-11-04,0000018-direct_deposit.pdf,g,0000018-drivers_lic.png,<blank>,123456,0000018-firearms_lic.pdf,Guard
,0000018-security_lic.pdf,2023-09-08,2028-11-04,2025-11-04,2020-09-08
19,1214,Farrellton,510738651,vera.jesus@cancomsecurity.com,F,336 Ch
Newcommon,CAN,2020-09-08,Jesus,0000019-sin.pdf,1979-12-29,Vera,006,J0X
1T0,NULL,3439616386,NULL,1,0667303,Standard,L,QC,08761,J220929127906,0000019-first_aid.pdf,NULL,NULL,<blank>,St.
John
Ambulance,NULL,170408,<blank>,<blank>,NULL,2021-04-21,<blank>,NULL,0000019-direct_deposit.pdf,5,NULL,<blank>,1678005185,NULL,N/A,0000019-security_lic.pdf,2027-12-29,NULL,2020-09-29,2020-07-13
20,1215,Toronto,90210,james.deahl@cancomsecurity.com,U,"1183 Finch Ave
West,",CAN,2020-09-08,Deahl,0000020-sin.jpg,2020-09-08,James,123,M3J
2G2,NULL,4167630000,NULL,1,93729271,First
Responder,L,ON,12345,Dueudnffj,0000020-first_aid.jpg,NULL,2020-10-08,<blank>,Joes
bsmt,NULL,90210,<blank>,<blank>,NULL,2026-09-08,<blank>,NULL,0000020-direct_deposit.jpg,Q,0000020-drivers_lic.jpg,<blank>,90210,NULL,What
the hell does this
mean,0000020-security_lic.jpg,2020-11-08,NULL,2022-09-08,2019-09-08
21,1216,Gloucester,123 456
789,khalid.mahmood@cancomsecurity.com,U,1638 Cyrville
Rd,CAN,2020-09-08,test,0000021-sin.jpg,2020-09-07,khalid,123,K1B
3L8,NULL,343-998-8527,NULL,1,1234567890,Emergency,na,ON,12345,na,0000021-first_aid.jpg,NULL,NULL,<blank>,Rescue
7,NULL,11232845,<blank>,<blank>,NULL,2020-09-10,<blank>,NULL,0000021-direct_deposit.jpg,na,NULL,<blank>,N/A,NULL,N/A,0000021-security_lic.jpg,2020-09-09,NULL,2020-09-10,2020-09-10
27,8,Woburn,852 741 963,steve@home.com,F,18 Jefferson
Lane,CAN,2020-09-15,Treescome,0000027-sin.png,1982-11-11,Steve,123,01801,NULL,416-222-3333,2020-09-15,1,123
4567,<blank>,<blank>,ON,12345,<blank>,NULL,NULL,NULL,<blank>,<blank>,NULL,<blank>,<blank>,<blank>,NULL,NULL,<blank>,NULL,0000027-direct_deposit.png,<blank>,NULL,<blank>,<blank>,NULL,<blank>,NULL,NULL,NULL,NULL,NULL
28,1223,Ottawa,458759315,veracostadejesus@hotmail.com,F,1638 cyrville
rd,CAN,2020-09-23,jesus,0000028-sin.pdf,2005-01-28,veronica,006,K1B
3L8,NULL,7054279235,NULL,1,0667303,NULL,<blank>,ON,08761,<blank>,NULL,NULL,NULL,NULL,NULL,NULL,NULL,<blank>,<blank>,NULL,NULL,<blank>,NULL,0000028-direct_deposit.pdf,<blank>,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
userID,name,role,region,status,password,username,onboarding,securityLicence,authorizedClients,lastLoginDatetime
4,Ronald
Wells,Management,ON-GTA,1,6+,RonaldWells,0,250821,
clientID,email,name,status,distance,latitude,password,username,longitude,companyname,lastUpdatetime,tenantPassword,lastLoginDatetime,maxPermitsPerWeek,listLicensePlateRestrictions
15,pulsemanagement@rogers.com,Brookfield- The Pulse 5500 Yonge
St.,0,0,<blank>,from,ThePulseCondo1,<blank>,Brookfield,2022-12-05
1,0,<blank>,from,Torontolibrary,<blank>,TPL,NULL,Cancom2024,NULL,1,NULL
767,dispatch@cancomsecurity.com,BGIS-Reesor
Road,1,0,<blank>,PM官�,BGIS-Reesor Road,<blank>,BGIS,2024-05-15
11:30:16,cancom,NULL,0,NULL
768,dispatch@cancomsecurity.com,TPL Special Site
Patrol,1,0,<blank>,from,TPL Special Site Patrol,<blank>,TPL Special
Site Patrol,2024-05-17 10:21:58,Cancom123,NULL,1,NULL
769,dispatch@cancomsecurity.com,"Wigwamen - 14 Spadina Rd,
Toronto",1,0,<blank>,from,"Wigwamen - 14 Spadina Rd,
Toronto",<blank>,"Wigwamen - 14 Spadina Rd, Toronto",2024-05-28
07:47:02,Cancom123,NULL,1,NULL
770,dispatch@cancomsecurity.com,"McDonalds - 2736 Lakeshore Blvd West,
Etobicoke",1,0,<blank>,PM官�,mcdonaldslakeshore,<blank>,"McDonalds -
2736 Lakeshore Blvd West, Etobicoke",NULL,cancom,NULL,1,NULL
771,dispatch@cancomsecurity.com,Winmar Restoration - 195 Division St S
Arnprior,1,0,<blank>,from,Winmar Restoration - 195 Division St S
Arnprior,<blank>,Winmar Restoration - 195 Division St S
Arnprior,2024-06-10 11:16:48,Cancom123,NULL,1,NULL
id,realmId,name,expires_in,token_type,access_token,refresh_token,x_refresh_token_expires_in
1,123145709608464,Quickbooks,3600,bearer,eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0..m0dy2ex_4i73bPpsi4DmbQ.YAWRblCCJZTXGREIZnJbC4cqIwc-sjLLaJNfzQyjmG-305cC9nK8qbCkOZizWvuSl5p9Q2uVJmAlS7fwB0SP1iICqTTxkibaujXJn4gFIZhvu8KjBki1H_dbjvE5JXJbGkObKPD45Lk0A3-Ynap6FbpY6oA1aBl5vVuQZBYNQ2oKnz9dnnv5ojCjktDNsKgXb_ivD1h3xBPiKBzkCmUX8KU54jrxxrdRYm9I039cEl06qMQouQ90QKGQWjq3sJBHjiXOP1O8Rx8eMYyrJCdbD04xIA1x4C4Q_oYQ_a8T9IhBGHAkSnqMPpTtA5lbyV-ou_RlN_vRloIa7_lB30Usor6Vt7kjZCzuZI-W8Nv4GndnmfB9AkMHhzUfMqiAX-KRlsvFoMlZfsjMrwjmLfR1a55UG5-kh7scW8YU1wdbyxB47NXqUrPo8mN5QjbdxlfxvJdbY38TSE2VoutgZUVoIt2R9u4kHAasdtgqGzL5hLP_fQViIghOUXAEtOsPBN_M9JT_ZYr4hQS2KNfeBIK26qIw0RGmHkz_meP_OgtJ7BnTD6TUNEELwVhJQNEJT_tosp92hplutD4l1QQSTyIRBm33nciYCtld7AyzHBfCVOqkfD-MDPYYdd7Bf9uO-I7wQzlE-QpOglUcYnhotC7pTH7ocOI3eNGfK4tP0DyRy2n2zaunCt-laXi_X7XJHbijodks8pmX2-URaH_sQEWeJ5wSnM5x7vt69wXGxzIz9sc.sphTqVzz3tBWuW3G1siByw,AB11726893209I09YfR3JhaiXAPCQpKMfMamm2y0yUgZgXd4En,8726400
Database: cancom
Table: oauth_tokens
[8 columns]
+----------------------------+---------------+
| Column | Type |
+----------------------------+---------------+
| name | varchar(128) |
| access_token | varchar(4096) |
| expires_in | varchar(128) |
| id | int(11) |
| realmId | varchar(128) |
| refresh_token | varchar(512) |
| token_type | varchar(128) |
| x_refresh_token_expires_in | varchar(128) |
+----------------------------+---------------+
Database: cancom
Table: user_onboarding_pre_encrypt
[50 columns]
+----------------------------+-------------+
| Column | Type |
+----------------------------+-------------+
| sin | varchar(11) |
| account_number | varchar(20) |
| approval_date | date |
| bank_number | varchar(3) |
| birth_date | date |
| city | varchar(20) |
| country | varchar(20) |
| direct_deposit_image | tinytext |
| drivers_licence | varchar(17) |
| drivers_licence_class | varchar(5) |
| drivers_licence_exp_date | date |
| drivers_licence_image | tinytext |
| drivers_licence_issue_date | date |
| email | tinytext |
| firearms_licence | varchar(20) |
| firearms_licence_auth | varchar(20) |
| firearms_licence_exp_date | date |
| firearms_licence_image | tinytext |
| first_aid_agency | tinytext |
| first_aid_certificate | tinytext |
| first_aid_exp_date | date |
| first_aid_image | tinytext |
| first_aid_type | tinytext |
| first_name | tinytext |
| gender | varchar(1) |
| healthcard_exp_date | date |
| healthcard_image | tinytext |
| healthcard_number | varchar(20) |
| hire_date | date |
| id | int(11) |
| indian_exp_date | date |
| indian_image | tinytext |
| indian_inac_serial | varchar(20) |
| indian_reg_number | varchar(20) |
| indian_status | varchar(1) |
| last_name | tinytext |
| middle_initial | varchar(4) |
| phone_number | varchar(12) |
| postal_code | varchar(7) |
| preapproval_notes | text |
| province_state | varchar(2) |
| security_licence | tinytext |
| security_licence_class | tinytext |
| security_licence_exp_date | date |
| security_licence_image | tinytext |
| sin_expiry_date | date |
| sin_image | tinytext |
| street | tinytext |
| transit_number | varchar(5) |
| userID | int(11) |
+----------------------------+-------------+
Database: cancom
Table: vehicleinspection
[46 columns]
+---------------------+------------+
| Column | Type |
+---------------------+------------+
| locks | text |
| status | tinyint(4) |
| aircontrols | text |
| approvedID | int(11) |
| attachmentList | text |
| bApproved | bit(1) |
| battery | text |
| belts | text |
| decalsLights | text |
| dentsScratches | text |
| driverFirstName | tinytext |
| driverLastName | tinytext |
| electricSeats | text |
| ending | tinytext |
| filtres | text |
| fluids | text |
| foldingSeats | text |
| glowlights | text |
| headrests | text |
| horn | text |
| idClient | int(11) |
| idUser | int(11) |
| inspectionDatetime | datetime |
| interiorLights | text |
| lastOilChange | tinytext |
| lastUpdatetime | datetime |
| leaks | text |
| licencePlate | text |
| lightsSignals | text |
| makeModel | text |
| mirrors | text |
| nextOilChange | tinytext |
| notes | text |
| purchaseGasLitres | tinytext |
| purchaseGasPrice | tinytext |
| purchaseGasYesNo | tinytext |
| radio | text |
| seatBelts | text |
| startingKm | tinytext |
| submitDatetime | datetime |
| tirePressure | text |
| upholstery | text |
| vehicleInspectionID | int(11) |
| vehicleYear | text |
| windows | text |
| wipers | text |
+---------------------+------------+
Database: cancom
Table: user_checkin
[4 columns]
+-----------------+------------+
| Column | Type |
+-----------------+------------+
| checkin_status | tinyint(4) |
| clientID | int(11) |
| last_dt_checkin | datetime |
| userID | int(11) |
+-----------------+------------+
Database: cancom
Table: invoice_location
[6 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| id | int(11) |
| isIncludeBulk | tinyint(4) |
| locationId | int(11) |
| qb_customer_displayname | varchar(256) |
| qb_customer_id | int(11) |
| statHolidayMultiplier | float |
+-------------------------+--------------+
Database: cancom
Table: parkingpermit
[16 columns]
+-----------------+-------------+
| Column | Type |
+-----------------+-------------+
| from | datetime |
| status | tinyint(4) |
| approvedID | smallint(4) |
| bApproved | bit(1) |
| email | tinytext |
| expires | datetime |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| licensePlate | tinytext |
| parkingPermitID | int(11) |
| permitsGranted | tinyint(4) |
| submitDatetime | datetime |
| suite | tinytext |
| vehicleMake | tinytext |
| vehicleModel | tinytext |
+-----------------+-------------+
Database: cancom
Table: payroll_emp_loc
[8 columns]
+------------+-----------+
| Column | Type |
+------------+-----------+
| employeeId | int(11) |
| id | int(11) |
| idUser | int(11) |
| isCurrent | bit(1) |
| locationId | int(11) |
| rate | float |
| scheduleId | int(11) |
| updateDt | timestamp |
+------------+-----------+
Database: cancom
Table: user_onboarding
[62 columns]
+----------------------------+--------------+
| Column | Type |
+----------------------------+--------------+
| sin | blob |
| account_number | blob |
| approval_date | date |
| bank_number | blob |
| birth_date | blob |
| city | varchar(20) |
| country | varchar(20) |
| direct_deposit_image | tinytext |
| drivers_licence | blob |
| drivers_licence_class | varchar(5) |
| drivers_licence_exp_date | blob |
| drivers_licence_image | tinytext |
| drivers_licence_issue_date | blob |
| email | tinytext |
| firearms_licence | blob |
| firearms_licence_auth | blob |
| firearms_licence_exp_date | blob |
| firearms_licence_image | tinytext |
| first_aid_agency | tinytext |
| first_aid_certificate | blob |
| first_aid_exp_date | blob |
| first_aid_image | tinytext |
| first_aid_type | tinytext |
| first_name | tinytext |
| gender | varchar(1) |
| healthcard_exp_date | date |
| healthcard_image | tinytext |
| healthcard_number | varchar(20) |
| hire_date | date |
| id | int(11) |
| identification1_image | tinytext |
| identification2_image | tinytext |
| indian_exp_date | blob |
| indian_image | tinytext |
| indian_inac_serial | blob |
| indian_reg_number | blob |
| indian_status | varchar(1) |
| last_name | tinytext |
| middle_initial | varchar(4) |
| permit | blob |
| permit_expiry_date | blob |
| permit_image | tinytext |
| phone_number | varchar(12) |
| postal_code | varchar(7) |
| preapproval_notes | text |
| province_state | varchar(2) |
| security_licence | blob |
| security_licence_class | tinytext |
| security_licence_exp_date | blob |
| security_licence_image | tinytext |
| sin_expiry_date | blob |
| sin_image | tinytext |
| street | tinytext |
| transit_number | blob |
| uniform_glove | varchar(20) |
| uniform_hat | varchar(20) |
| uniform_pants_length | varchar(20) |
| uniform_pants_waist | varchar(20) |
| uniform_shirt | varchar(128) |
| uniform_shoe | varchar(20) |
| uniform_vest | varchar(128) |
| userID | int(11) |
+----------------------------+--------------+
Database: cancom
Table: patrol_history_detail
[8 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| bCodeScaned | tinyint(1) |
| bflagged | tinyint(1) |
| checkpointTime | datetime |
| geoCoords | tinytext |
| idCheckpoint | int(11) |
| idHistory | int(11) |
| images | text |
| note | text |
+----------------+------------+
Database: cancom
Table: patrol_checkpoints
[8 columns]
+--------------+------------+
| Column | Type |
+--------------+------------+
| description | text |
| name | tinytext |
| status | bit(1) |
| bImage | tinyint(4) |
| checkpointID | int(11) |
| idPatrol | int(11) |
| NFC_tag | tinytext |
| QR_code | tinytext |
+--------------+------------+
Database: cancom
Table: user
[11 columns]
+-------------------+--------------+
| Column | Type |
+-------------------+--------------+
| name | tinytext |
| role | tinytext |
| status | tinyint(4) |
| authorizedClients | text |
| lastLoginDatetime | datetime |
| onboarding | tinyint(4) |
| password | blob |
| region | varchar(128) |
| securityLicence | tinytext |
| userID | int(11) |
| username | tinytext |
+-------------------+--------------+
Database: cancom
Table: payroll_managers
[2 columns]
+----------------+---------+
| Column | Type |
+----------------+---------+
| id | int(11) |
| managerEidList | text |
+----------------+---------+
Database: cancom
Table: emails
[10 columns]
+---------------------+----------+
| Column | Type |
+---------------------+----------+
| bAlarmResponse | bit(1) |
| bGeneralOccurrence | bit(1) |
| bParkingEnforcement | bit(1) |
| bParkingPermit | bit(1) |
| bSecurityLog | bit(1) |
| bTrespass | bit(1) |
| bUseOfForce | bit(1) |
| email | tinytext |
| emailID | int(11) |
| idClient | int(11) |
+---------------------+----------+
Database: cancom
Table: securitylog
[14 columns]
+----------------+-------------+
| Column | Type |
+----------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| bApproved | bit(1) |
| details | text |
| endTime | time |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| securityLogID | int(11) |
| shiftDate | date |
| siteAddress | text |
| startTime | time |
| submitDatetime | datetime |
+----------------+-------------+
Database: cancom
Table: alarmresponse
[32 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| keys | tinytext |
| name | tinytext |
| status | tinyint(4) |
| actionTaken | text |
| alarmResponseID | int(11) |
| alarmStatus | varchar(128) |
| alarmTypeList | text |
| alarmTypeOther | tinytext |
| alarmZone | tinytext |
| approvedID | smallint(4) |
| arrivalTime | time |
| attachmentList | text |
| bApproved | bit(1) |
| comments | text |
| departureTime | time |
| dispatchRequestTypeList | text |
| fireDept | tinytext |
| idClient | int(11) |
| idUser | int(11) |
| isBilled | tinyint(4) |
| keyNumBoxNum | tinytext |
| lastUpdatetime | datetime |
| otherNames | tinytext |
| policeService | tinytext |
| receivedDatetime | datetime |
| reportToClient | tinytext |
| requestedBy | tinytext |
| serviceCallNum | tinytext |
| serviceDispatched | tinytext |
| siteAddress | text |
| submitDatetime | datetime |
| subscriber | tinytext |
+-------------------------+--------------+
Database: cancom
Table: elearning_course
[7 columns]
+--------------+--------------+
| Column | Type |
+--------------+--------------+
| code | varchar(30) |
| description | text |
| name | varchar(50) |
| status | varchar(128) |
| url | tinytext |
| archive_date | date |
| courseID | int(11) |
+--------------+--------------+
Database: cancom
Table: parkingenforcement
[23 columns]
+----------------------+-------------+
| Column | Type |
+----------------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| arrivalTime | time |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| calledTow | tinytext |
| departureTime | time |
| details | text |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| numOfTags | tinyint(4) |
| numOfTows | tinyint(4) |
| parkingEnforcementID | int(11) |
| place | text |
| policeDivision | tinytext |
| reportedDate | date |
| siteAddress | text |
| submitDatetime | datetime |
| towCompany | tinytext |
| towedTo | tinytext |
| truckLicNum | tinytext |
+----------------------+-------------+
Database: cancom
Table: postorders
[6 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| status | tinyint(4) |
| filepath | text |
| fileSize | int(11) |
| postOrdersID | int(11) |
| submitDatetime | timestamp |
| title | tinytext |
+----------------+------------+
Database: cancom
Table: corporate_policies
[6 columns]
+-------------------+------------+
| Column | Type |
+-------------------+------------+
| status | tinyint(4) |
| corporatePolicyID | int(11) |
| filepath | text |
| fileSize | int(11) |
| submitDatetime | timestamp |
| title | tinytext |
+-------------------+------------+
Database: cancom
Table: alert
[5 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| status | tinyint(4) |
| alertID | int(11) |
| detail | text |
| lastUpdatetime | datetime |
| submitDatetime | datetime |
+----------------+------------+
Database: cancom
Table: test
[2 columns]
+----------+--------------+
| Column | Type |
+----------+--------------+
| id | int(11) |
| myString | varchar(128) |
+----------+--------------+
Database: cancom
Table: elearning
[10 columns]
+-------------------+--------------+
| Column | Type |
+-------------------+--------------+
| name | varchar(40) |
| status | char(1) |
| authorizedCourses | text |
| dateRegistered | timestamp |
| email | varchar(128) |
| id | int(11) |
| lastLoginDatetime | datetime |
| password | blob |
| phone | varchar(12) |
| username | varchar(20) |
+-------------------+--------------+
Database: cancom
Table: trespass
[33 columns]
+----------------+-------------+
| Column | Type |
+----------------+-------------+
| status | tinyint(4) |
| address | tinytext |
| approvedID | smallint(4) |
| attachmentList | text |
| bApproved | bit(1) |
| birth | date |
| city | tinytext |
| clothing | tinytext |
| complexion | tinytext |
| country | tinytext |
| gender | tinytext |
| glasses | tinytext |
| haircolor | tinytext |
| hairlength | tinytext |
| height | tinytext |
| idClient | int(11) |
| idUser | int(11) |
| issuedAt | tinytext |
| issueDate | date |
| lastUpdatetime | datetime |
| marks | tinytext |
| nameFirst | tinytext |
| nameLast | tinytext |
| nameMiddle | tinytext |
| noticeReason | tinytext |
| offenceList | text |
| periodOfTime | tinytext |
| postal | tinytext |
| province | tinytext |
| submitDatetime | datetime |
| tattoos | tinytext |
| trespassID | int(11) |
| weight | tinytext |
+----------------+-------------+
Database: cancom
Table: generaloccurrence
[23 columns]
+---------------------------+-------------+
| Column | Type |
+---------------------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| complaintReceivedBy | tinytext |
| complaintReceivedDatetime | datetime |
| diaryDate | date |
| generalOccurrenceID | int(11) |
| idClient | int(11) |
| idOccurrenceType | int(11) |
| idUser | int(11) |
| initialInvestigationBy | tinytext |
| investigatedDatetime | datetime |
| lastUpdatetime | datetime |
| occurrenceDatetime | datetime |
| openClosed | tinytext |
| place | text |
| policeDivision | tinytext |
| reportedDatetime | datetime |
| siteAddress | text |
| submitDatetime | datetime |
| synopsis | text |
+---------------------------+-------------+
Database: cancom
Table: patrols
[5 columns]
+---------------+---------+
| Column | Type |
+---------------+---------+
| status | bit(1) |
| idClient | int(11) |
| patrolID | int(11) |
| whenFlagged | text |
| whenSubmitted | text |
+---------------+---------+
Database: cancom
Table: occurrencetype
[3 columns]
+------------------+------------+
| Column | Type |
+------------------+------------+
| name | tinytext |
| status | tinyint(4) |
| occurrenceTypeID | int(11) |
+------------------+------------+
Database: cancom
Table: client
[15 columns]
+------------------------------+-------------+
| Column | Type |
+------------------------------+-------------+
| name | tinytext |
| status | tinyint(4) |
| clientID | int(11) |
| companyname | tinytext |
| distance | int(11) |
| email | tinytext |
| lastLoginDatetime | datetime |
| lastUpdatetime | datetime |
| latitude | varchar(20) |
| listLicensePlateRestrictions | text |
| longitude | varchar(20) |
| maxPermitsPerWeek | tinyint(4) |
| password | blob |
| tenantPassword | tinytext |
| username | tinytext |
+------------------------------+-------------+
Database: cancom
Table: invoice_rates
[8 columns]
+-------------+-----------+
| Column | Type |
+-------------+-----------+
| id | int(11) |
| idUser | int(11) |
| isCurrent | bit(1) |
| locationId | int(11) |
| rate | float |
| rateSpecial | float |
| scheduleId | int(11) |
| updateDt | timestamp |
+-------------+-----------+
Database: cancom
Table: province
[4 columns]
+--------------+-------------+
| Column | Type |
+--------------+-------------+
| name | tinytext |
| abbreviation | varchar(10) |
| id | int(11) |
| short | varchar(2) |
+--------------+-------------+
Database: cancom
Table: internal_useofforce
[24 columns]
+---------------------------+--------------+
| Column | Type |
+---------------------------+--------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| complaintReceivedBy | tinytext |
| complaintReceivedDatetime | datetime |
| diaryDate | date |
| idClient | int(11) |
| idOccurrenceType | int(11) |
| idUser | int(11) |
| initialInvestigationBy | tinytext |
| internalUseOfForceID | int(11) |
| investigatedDatetime | datetime |
| lastUpdatetime | datetime |
| occurrenceDatetime | datetime |
| openClosed | tinytext |
| place | text |
| policeDivision | tinytext |
| province | varchar(128) |
| reportedDatetime | datetime |
| siteAddress | text |
| submitDatetime | datetime |
| synopsis | text |
+---------------------------+--------------+
Database: cancom
Table: patrol_history
[8 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| end | datetime |
| start | datetime |
| created | datetime |
| flaggedSentTo | text |
| historyID | int(11) |
| idPatrol | int(11) |
| idUser | int(11) |
| submittedSentTo | text |
+-----------------+----------+
Posts: 247
Threads: 49
Joined: Jul 2023
LOL good leak UnicornLover67
Posts: 67
Threads: 2
Joined: May 2024
Ronald Wells is a bit of a Nigger
Posts: 24
Threads: 10
Joined: Jun 2024
(06-26-2024, 01:59 PM)UnicornLover67 Wrote: website: cancomsecurity.com
Quote: "Cancom Security Inc. is dedicated to providing peace of mind to our
clients through proactive security services while enhancing their
personal safety and protecting their properties and proprietary
information."
Revenue: ~ $100M
download cancomsecurity.tar.gz
https://cancomsecurity.com/cyber-security/
CEO, Ronald Wells
[email=ronald.wells@cancomsecurity.com]ronald.wells@cancomsecurity.com[/email] Polsa72809!
416-994-6793 (he does not care about his clients & employees, offered to show vulnerabilities and not leak data for extremely good price lol)
small example datas, Спасибо
userID,name,role,region,status,password,username,onboarding,securityLicence,authorizedClients,lastLoginDatetime
4,Ronald
Wells,Management,ON-GTA,1,6+,RonaldWells,0,250821,"[""91"",""187"",""89"",""182"",""202"",""175"",""196"",""157"",""190"",""219"",""92"",""94"",""177"",""183"",""201"",""131"",""88"",""186"",""206"",""107"",""17"",""184"",""172"",""151"",""154"",""159"",""153"",""155"",""18"",""102"",""103"",""20"",""21"",""149"",""15"",""16"",""146"",""140"",""235"",""178"",""22"",""26"",""185"",""236"",""220"",""221"",""142"",""23"",""207"",""110"",""127"",""41"",""145"",""73"",""74"",""72"",""194"",""181"",""218"",""133"",""170"",""105"",""96"",""121"",""44"",""39"",""29"",""31"",""30"",""104"",""40"",""34"",""32"",""35"",""33"",""28"",""37"",""38"",""36"",""27"",""122"",""143"",""101"",""144"",""191"",""42"",""192"",""118"",""43"",""215"",""212"",""147"",""45"",""134"",""208"",""46"",""193"",""47"",""200"",""106"",""49"",""217"",""165"",""50"",""51"",""52"",""162"",""168"",""53"",""54"",""210"",""160"",""55"",""56"",""166"",""163"",""161"",""62"",""64"",""167"",""57"",""58"",""164"",""171"",""59"
",""60"",""179"",""61"",""197"",""180"",""173"",""63"",""65"",""189"",""209"",""108"",""109"",""66"",""198"",""130"",""203"",""90"",""69"",""93"",""169"",""128"",""68"",""124"",""137"",""138"",""129"",""75"",""67"",""148"",""97"",""98"",""99"",""126"",""188"",""70"",""71"",""205"",""136"",""152"",""139"",""176"",""116"",""117"",""216"",""158"",""214"",""222"",""95"",""77"",""204"",""228"",""224"",""233"",""230"",""232"",""225"",""223"",""234"",""213"",""82"",""24"",""25"",""48"",""19"",""226"",""227"",""231"",""229"",""141"",""78"",""79"",""132"",""125"",""80"",""123"",""199"",""113"",""211"",""112"",""114"",""115"",""111"",""81"",""119"",""76"",""100"",""150"",""195"",""156"",""174"",""83"",""85"",""86"",""87"",""135"",""84""]",2024-06-12
00:30:33
id,userID,city,sin,email,gender,street,country,hire_date,last_name,sin_image,birth_date,first_name,bank_number,postal_code,indian_image,phone_number,approval_date,indian_status,account_number,first_aid_type,middle_initial,province_state,transit_number,drivers_licence,first_aid_image,indian_exp_date,sin_expiry_date,firearms_licence,first_aid_agency,healthcard_image,security_licence,healthcard_number,indian_reg_number,preapproval_notes,first_aid_exp_date,indian_inac_serial,healthcard_exp_date,direct_deposit_image,drivers_licence_class,drivers_licence_image,firearms_licence_auth,first_aid_certificate,firearms_licence_image,security_licence_class,security_licence_image,drivers_licence_exp_date,firearms_licence_exp_date,security_licence_exp_date,drivers_licence_issue_date
15,1208,<blank>,<blank>,mail@cancomsecurity.com,U,"1183 Finch Ave
West, Suite
205",CAN,2020-09-02,Test,0000015-sin.jpg,<blank>,Cancom,<blank>,m3j2g2,NULL,416-763-0000,<blank>,1,<blank>,Standard,1,ON,11251,W2045-34450-11110,0000015-first_aid.png,NULL,2022-02-25,<blank>,Rescue
&,NULL,11111110,<blank>,<blank>,NULL,2023-04-04,<blank>,NULL,0000015-direct_deposit.jpg,G,0000015-drivers_lic.jpeg,Restricted,2211344553,NULL,S,0000015-security_lic.jfif,2022-04-04,NULL,2022-04-04,2018-04-04
16,1210,Essex,492652295,shawn.leroux@gmail.com,M,297 Woodview
Drive,CAN,2020-09-08,wells,0000016-sin.jpg,2020-07-08,ryan,000,N8M
3E8,NULL,2267570000,NULL,1,123456789,Emergency,d,ON,03030,L2458*5986*5455,0000016-first_aid.jpg,NULL,2020-09-08,123456789,Cancom,0000016-health_card.jpg,223995,1616166361,<blank>,NULL,2022-09-08,<blank>,2022-10-08,0000016-direct_deposit.jpg,GM,0000016-drivers_lic.jpg,Restricted,12121212,0000016-firearms_lic.jpg,Guard,0000016-security_lic.jpg,2020-10-20,2022-10-08,2100-09-08,1986-11-08
17,1212,Toronto,123-456-789,scheduling@cancomsecurity.com,M,1183 Finch
Ave
West,CAN,2020-09-08,Dogan,0000017-sin.xltx,1984-03-08,Merdan,345,M6M1P5,NULL,416-763-0000,NULL,1,34554345,Standard,f,ON,54345,werwerwerwerwer,0000017-first_aid.xlsx,NULL,NULL,234wedfsdf234,Rescue
7,NULL,11167131,rwerwerwer234wer,<blank>,NULL,2024-11-08,<blank>,2020-12-22,0000017-direct_deposit.xltx,G,0000017-drivers_lic.xlsx,Restricted,234234234,NULL,Active,0000017-security_lic.xltx,2020-09-02,2022-10-13,2022-10-08,2022-10-11
18,1211,Toronto,59000006,carlosiglesias.cig@hotmail.com,M,1183 Finch
Ave West suite
205,CAN,2020-09-08,Testing6,0000018-sin.jpg,2020-09-30,carlos,562,M3J2G2,NULL,4168590719,NULL,1,123456789,Standard,m,ON,12345,987456123,0000018-first_aid.pdf,NULL,2023-07-08,000012345678,cancom,0000018-health_card.pdf,123456789,3216540000,<blank>,NULL,2023-06-08,<blank>,2028-11-04,0000018-direct_deposit.pdf,g,0000018-drivers_lic.png,<blank>,123456,0000018-firearms_lic.pdf,Guard
,0000018-security_lic.pdf,2023-09-08,2028-11-04,2025-11-04,2020-09-08
19,1214,Farrellton,510738651,vera.jesus@cancomsecurity.com,F,336 Ch
Newcommon,CAN,2020-09-08,Jesus,0000019-sin.pdf,1979-12-29,Vera,006,J0X
1T0,NULL,3439616386,NULL,1,0667303,Standard,L,QC,08761,J220929127906,0000019-first_aid.pdf,NULL,NULL,<blank>,St.
John
Ambulance,NULL,170408,<blank>,<blank>,NULL,2021-04-21,<blank>,NULL,0000019-direct_deposit.pdf,5,NULL,<blank>,1678005185,NULL,N/A,0000019-security_lic.pdf,2027-12-29,NULL,2020-09-29,2020-07-13
20,1215,Toronto,90210,james.deahl@cancomsecurity.com,U,"1183 Finch Ave
West,",CAN,2020-09-08,Deahl,0000020-sin.jpg,2020-09-08,James,123,M3J
2G2,NULL,4167630000,NULL,1,93729271,First
Responder,L,ON,12345,Dueudnffj,0000020-first_aid.jpg,NULL,2020-10-08,<blank>,Joes
bsmt,NULL,90210,<blank>,<blank>,NULL,2026-09-08,<blank>,NULL,0000020-direct_deposit.jpg,Q,0000020-drivers_lic.jpg,<blank>,90210,NULL,What
the hell does this
mean,0000020-security_lic.jpg,2020-11-08,NULL,2022-09-08,2019-09-08
21,1216,Gloucester,123 456
789,khalid.mahmood@cancomsecurity.com,U,1638 Cyrville
Rd,CAN,2020-09-08,test,0000021-sin.jpg,2020-09-07,khalid,123,K1B
3L8,NULL,343-998-8527,NULL,1,1234567890,Emergency,na,ON,12345,na,0000021-first_aid.jpg,NULL,NULL,<blank>,Rescue
7,NULL,11232845,<blank>,<blank>,NULL,2020-09-10,<blank>,NULL,0000021-direct_deposit.jpg,na,NULL,<blank>,N/A,NULL,N/A,0000021-security_lic.jpg,2020-09-09,NULL,2020-09-10,2020-09-10
27,8,Woburn,852 741 963,steve@home.com,F,18 Jefferson
Lane,CAN,2020-09-15,Treescome,0000027-sin.png,1982-11-11,Steve,123,01801,NULL,416-222-3333,2020-09-15,1,123
4567,<blank>,<blank>,ON,12345,<blank>,NULL,NULL,NULL,<blank>,<blank>,NULL,<blank>,<blank>,<blank>,NULL,NULL,<blank>,NULL,0000027-direct_deposit.png,<blank>,NULL,<blank>,<blank>,NULL,<blank>,NULL,NULL,NULL,NULL,NULL
28,1223,Ottawa,458759315,veracostadejesus@hotmail.com,F,1638 cyrville
rd,CAN,2020-09-23,jesus,0000028-sin.pdf,2005-01-28,veronica,006,K1B
3L8,NULL,7054279235,NULL,1,0667303,NULL,<blank>,ON,08761,<blank>,NULL,NULL,NULL,NULL,NULL,NULL,NULL,<blank>,<blank>,NULL,NULL,<blank>,NULL,0000028-direct_deposit.pdf,<blank>,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
userID,name,role,region,status,password,username,onboarding,securityLicence,authorizedClients,lastLoginDatetime
4,Ronald
Wells,Management,ON-GTA,1,6+,RonaldWells,0,250821,
clientID,email,name,status,distance,latitude,password,username,longitude,companyname,lastUpdatetime,tenantPassword,lastLoginDatetime,maxPermitsPerWeek,listLicensePlateRestrictions
15,pulsemanagement@rogers.com,Brookfield- The Pulse 5500 Yonge
St.,0,0,<blank>,from,ThePulseCondo1,<blank>,Brookfield,2022-12-05
1,0,<blank>,from,Torontolibrary,<blank>,TPL,NULL,Cancom2024,NULL,1,NULL
767,dispatch@cancomsecurity.com,BGIS-Reesor
Road,1,0,<blank>,PM官�,BGIS-Reesor Road,<blank>,BGIS,2024-05-15
11:30:16,cancom,NULL,0,NULL
768,dispatch@cancomsecurity.com,TPL Special Site
Patrol,1,0,<blank>,from,TPL Special Site Patrol,<blank>,TPL Special
Site Patrol,2024-05-17 10:21:58,Cancom123,NULL,1,NULL
769,dispatch@cancomsecurity.com,"Wigwamen - 14 Spadina Rd,
Toronto",1,0,<blank>,from,"Wigwamen - 14 Spadina Rd,
Toronto",<blank>,"Wigwamen - 14 Spadina Rd, Toronto",2024-05-28
07:47:02,Cancom123,NULL,1,NULL
770,dispatch@cancomsecurity.com,"McDonalds - 2736 Lakeshore Blvd West,
Etobicoke",1,0,<blank>,PM官�,mcdonaldslakeshore,<blank>,"McDonalds -
2736 Lakeshore Blvd West, Etobicoke",NULL,cancom,NULL,1,NULL
771,dispatch@cancomsecurity.com,Winmar Restoration - 195 Division St S
Arnprior,1,0,<blank>,from,Winmar Restoration - 195 Division St S
Arnprior,<blank>,Winmar Restoration - 195 Division St S
Arnprior,2024-06-10 11:16:48,Cancom123,NULL,1,NULL
id,realmId,name,expires_in,token_type,access_token,refresh_token,x_refresh_token_expires_in
1,123145709608464,Quickbooks,3600,bearer,eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0..m0dy2ex_4i73bPpsi4DmbQ.YAWRblCCJZTXGREIZnJbC4cqIwc-sjLLaJNfzQyjmG-305cC9nK8qbCkOZizWvuSl5p9Q2uVJmAlS7fwB0SP1iICqTTxkibaujXJn4gFIZhvu8KjBki1H_dbjvE5JXJbGkObKPD45Lk0A3-Ynap6FbpY6oA1aBl5vVuQZBYNQ2oKnz9dnnv5ojCjktDNsKgXb_ivD1h3xBPiKBzkCmUX8KU54jrxxrdRYm9I039cEl06qMQouQ90QKGQWjq3sJBHjiXOP1O8Rx8eMYyrJCdbD04xIA1x4C4Q_oYQ_a8T9IhBGHAkSnqMPpTtA5lbyV-ou_RlN_vRloIa7_lB30Usor6Vt7kjZCzuZI-W8Nv4GndnmfB9AkMHhzUfMqiAX-KRlsvFoMlZfsjMrwjmLfR1a55UG5-kh7scW8YU1wdbyxB47NXqUrPo8mN5QjbdxlfxvJdbY38TSE2VoutgZUVoIt2R9u4kHAasdtgqGzL5hLP_fQViIghOUXAEtOsPBN_M9JT_ZYr4hQS2KNfeBIK26qIw0RGmHkz_meP_OgtJ7BnTD6TUNEELwVhJQNEJT_tosp92hplutD4l1QQSTyIRBm33nciYCtld7AyzHBfCVOqkfD-MDPYYdd7Bf9uO-I7wQzlE-QpOglUcYnhotC7pTH7ocOI3eNGfK4tP0DyRy2n2zaunCt-laXi_X7XJHbijodks8pmX2-URaH_sQEWeJ5wSnM5x7vt69wXGxzIz9sc.sphTqVzz3tBWuW3G1siByw,AB11726893209I09YfR3JhaiXAPCQpKMfMamm2y0yUgZgXd4En,8726400
Database: cancom
Table: oauth_tokens
[8 columns]
+----------------------------+---------------+
| Column | Type |
+----------------------------+---------------+
| name | varchar(128) |
| access_token | varchar(4096) |
| expires_in | varchar(128) |
| id | int(11) |
| realmId | varchar(128) |
| refresh_token | varchar(512) |
| token_type | varchar(128) |
| x_refresh_token_expires_in | varchar(128) |
+----------------------------+---------------+
Database: cancom
Table: user_onboarding_pre_encrypt
[50 columns]
+----------------------------+-------------+
| Column | Type |
+----------------------------+-------------+
| sin | varchar(11) |
| account_number | varchar(20) |
| approval_date | date |
| bank_number | varchar(3) |
| birth_date | date |
| city | varchar(20) |
| country | varchar(20) |
| direct_deposit_image | tinytext |
| drivers_licence | varchar(17) |
| drivers_licence_class | varchar(5) |
| drivers_licence_exp_date | date |
| drivers_licence_image | tinytext |
| drivers_licence_issue_date | date |
| email | tinytext |
| firearms_licence | varchar(20) |
| firearms_licence_auth | varchar(20) |
| firearms_licence_exp_date | date |
| firearms_licence_image | tinytext |
| first_aid_agency | tinytext |
| first_aid_certificate | tinytext |
| first_aid_exp_date | date |
| first_aid_image | tinytext |
| first_aid_type | tinytext |
| first_name | tinytext |
| gender | varchar(1) |
| healthcard_exp_date | date |
| healthcard_image | tinytext |
| healthcard_number | varchar(20) |
| hire_date | date |
| id | int(11) |
| indian_exp_date | date |
| indian_image | tinytext |
| indian_inac_serial | varchar(20) |
| indian_reg_number | varchar(20) |
| indian_status | varchar(1) |
| last_name | tinytext |
| middle_initial | varchar(4) |
| phone_number | varchar(12) |
| postal_code | varchar(7) |
| preapproval_notes | text |
| province_state | varchar(2) |
| security_licence | tinytext |
| security_licence_class | tinytext |
| security_licence_exp_date | date |
| security_licence_image | tinytext |
| sin_expiry_date | date |
| sin_image | tinytext |
| street | tinytext |
| transit_number | varchar(5) |
| userID | int(11) |
+----------------------------+-------------+
Database: cancom
Table: vehicleinspection
[46 columns]
+---------------------+------------+
| Column | Type |
+---------------------+------------+
| locks | text |
| status | tinyint(4) |
| aircontrols | text |
| approvedID | int(11) |
| attachmentList | text |
| bApproved | bit(1) |
| battery | text |
| belts | text |
| decalsLights | text |
| dentsScratches | text |
| driverFirstName | tinytext |
| driverLastName | tinytext |
| electricSeats | text |
| ending | tinytext |
| filtres | text |
| fluids | text |
| foldingSeats | text |
| glowlights | text |
| headrests | text |
| horn | text |
| idClient | int(11) |
| idUser | int(11) |
| inspectionDatetime | datetime |
| interiorLights | text |
| lastOilChange | tinytext |
| lastUpdatetime | datetime |
| leaks | text |
| licencePlate | text |
| lightsSignals | text |
| makeModel | text |
| mirrors | text |
| nextOilChange | tinytext |
| notes | text |
| purchaseGasLitres | tinytext |
| purchaseGasPrice | tinytext |
| purchaseGasYesNo | tinytext |
| radio | text |
| seatBelts | text |
| startingKm | tinytext |
| submitDatetime | datetime |
| tirePressure | text |
| upholstery | text |
| vehicleInspectionID | int(11) |
| vehicleYear | text |
| windows | text |
| wipers | text |
+---------------------+------------+
Database: cancom
Table: user_checkin
[4 columns]
+-----------------+------------+
| Column | Type |
+-----------------+------------+
| checkin_status | tinyint(4) |
| clientID | int(11) |
| last_dt_checkin | datetime |
| userID | int(11) |
+-----------------+------------+
Database: cancom
Table: invoice_location
[6 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| id | int(11) |
| isIncludeBulk | tinyint(4) |
| locationId | int(11) |
| qb_customer_displayname | varchar(256) |
| qb_customer_id | int(11) |
| statHolidayMultiplier | float |
+-------------------------+--------------+
Database: cancom
Table: parkingpermit
[16 columns]
+-----------------+-------------+
| Column | Type |
+-----------------+-------------+
| from | datetime |
| status | tinyint(4) |
| approvedID | smallint(4) |
| bApproved | bit(1) |
| email | tinytext |
| expires | datetime |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| licensePlate | tinytext |
| parkingPermitID | int(11) |
| permitsGranted | tinyint(4) |
| submitDatetime | datetime |
| suite | tinytext |
| vehicleMake | tinytext |
| vehicleModel | tinytext |
+-----------------+-------------+
Database: cancom
Table: payroll_emp_loc
[8 columns]
+------------+-----------+
| Column | Type |
+------------+-----------+
| employeeId | int(11) |
| id | int(11) |
| idUser | int(11) |
| isCurrent | bit(1) |
| locationId | int(11) |
| rate | float |
| scheduleId | int(11) |
| updateDt | timestamp |
+------------+-----------+
Database: cancom
Table: user_onboarding
[62 columns]
+----------------------------+--------------+
| Column | Type |
+----------------------------+--------------+
| sin | blob |
| account_number | blob |
| approval_date | date |
| bank_number | blob |
| birth_date | blob |
| city | varchar(20) |
| country | varchar(20) |
| direct_deposit_image | tinytext |
| drivers_licence | blob |
| drivers_licence_class | varchar(5) |
| drivers_licence_exp_date | blob |
| drivers_licence_image | tinytext |
| drivers_licence_issue_date | blob |
| email | tinytext |
| firearms_licence | blob |
| firearms_licence_auth | blob |
| firearms_licence_exp_date | blob |
| firearms_licence_image | tinytext |
| first_aid_agency | tinytext |
| first_aid_certificate | blob |
| first_aid_exp_date | blob |
| first_aid_image | tinytext |
| first_aid_type | tinytext |
| first_name | tinytext |
| gender | varchar(1) |
| healthcard_exp_date | date |
| healthcard_image | tinytext |
| healthcard_number | varchar(20) |
| hire_date | date |
| id | int(11) |
| identification1_image | tinytext |
| identification2_image | tinytext |
| indian_exp_date | blob |
| indian_image | tinytext |
| indian_inac_serial | blob |
| indian_reg_number | blob |
| indian_status | varchar(1) |
| last_name | tinytext |
| middle_initial | varchar(4) |
| permit | blob |
| permit_expiry_date | blob |
| permit_image | tinytext |
| phone_number | varchar(12) |
| postal_code | varchar(7) |
| preapproval_notes | text |
| province_state | varchar(2) |
| security_licence | blob |
| security_licence_class | tinytext |
| security_licence_exp_date | blob |
| security_licence_image | tinytext |
| sin_expiry_date | blob |
| sin_image | tinytext |
| street | tinytext |
| transit_number | blob |
| uniform_glove | varchar(20) |
| uniform_hat | varchar(20) |
| uniform_pants_length | varchar(20) |
| uniform_pants_waist | varchar(20) |
| uniform_shirt | varchar(128) |
| uniform_shoe | varchar(20) |
| uniform_vest | varchar(128) |
| userID | int(11) |
+----------------------------+--------------+
Database: cancom
Table: patrol_history_detail
[8 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| bCodeScaned | tinyint(1) |
| bflagged | tinyint(1) |
| checkpointTime | datetime |
| geoCoords | tinytext |
| idCheckpoint | int(11) |
| idHistory | int(11) |
| images | text |
| note | text |
+----------------+------------+
Database: cancom
Table: patrol_checkpoints
[8 columns]
+--------------+------------+
| Column | Type |
+--------------+------------+
| description | text |
| name | tinytext |
| status | bit(1) |
| bImage | tinyint(4) |
| checkpointID | int(11) |
| idPatrol | int(11) |
| NFC_tag | tinytext |
| QR_code | tinytext |
+--------------+------------+
Database: cancom
Table: user
[11 columns]
+-------------------+--------------+
| Column | Type |
+-------------------+--------------+
| name | tinytext |
| role | tinytext |
| status | tinyint(4) |
| authorizedClients | text |
| lastLoginDatetime | datetime |
| onboarding | tinyint(4) |
| password | blob |
| region | varchar(128) |
| securityLicence | tinytext |
| userID | int(11) |
| username | tinytext |
+-------------------+--------------+
Database: cancom
Table: payroll_managers
[2 columns]
+----------------+---------+
| Column | Type |
+----------------+---------+
| id | int(11) |
| managerEidList | text |
+----------------+---------+
Database: cancom
Table: emails
[10 columns]
+---------------------+----------+
| Column | Type |
+---------------------+----------+
| bAlarmResponse | bit(1) |
| bGeneralOccurrence | bit(1) |
| bParkingEnforcement | bit(1) |
| bParkingPermit | bit(1) |
| bSecurityLog | bit(1) |
| bTrespass | bit(1) |
| bUseOfForce | bit(1) |
| email | tinytext |
| emailID | int(11) |
| idClient | int(11) |
+---------------------+----------+
Database: cancom
Table: securitylog
[14 columns]
+----------------+-------------+
| Column | Type |
+----------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| bApproved | bit(1) |
| details | text |
| endTime | time |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| securityLogID | int(11) |
| shiftDate | date |
| siteAddress | text |
| startTime | time |
| submitDatetime | datetime |
+----------------+-------------+
Database: cancom
Table: alarmresponse
[32 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| keys | tinytext |
| name | tinytext |
| status | tinyint(4) |
| actionTaken | text |
| alarmResponseID | int(11) |
| alarmStatus | varchar(128) |
| alarmTypeList | text |
| alarmTypeOther | tinytext |
| alarmZone | tinytext |
| approvedID | smallint(4) |
| arrivalTime | time |
| attachmentList | text |
| bApproved | bit(1) |
| comments | text |
| departureTime | time |
| dispatchRequestTypeList | text |
| fireDept | tinytext |
| idClient | int(11) |
| idUser | int(11) |
| isBilled | tinyint(4) |
| keyNumBoxNum | tinytext |
| lastUpdatetime | datetime |
| otherNames | tinytext |
| policeService | tinytext |
| receivedDatetime | datetime |
| reportToClient | tinytext |
| requestedBy | tinytext |
| serviceCallNum | tinytext |
| serviceDispatched | tinytext |
| siteAddress | text |
| submitDatetime | datetime |
| subscriber | tinytext |
+-------------------------+--------------+
Database: cancom
Table: elearning_course
[7 columns]
+--------------+--------------+
| Column | Type |
+--------------+--------------+
| code | varchar(30) |
| description | text |
| name | varchar(50) |
| status | varchar(128) |
| url | tinytext |
| archive_date | date |
| courseID | int(11) |
+--------------+--------------+
Database: cancom
Table: parkingenforcement
[23 columns]
+----------------------+-------------+
| Column | Type |
+----------------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| arrivalTime | time |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| calledTow | tinytext |
| departureTime | time |
| details | text |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| numOfTags | tinyint(4) |
| numOfTows | tinyint(4) |
| parkingEnforcementID | int(11) |
| place | text |
| policeDivision | tinytext |
| reportedDate | date |
| siteAddress | text |
| submitDatetime | datetime |
| towCompany | tinytext |
| towedTo | tinytext |
| truckLicNum | tinytext |
+----------------------+-------------+
Database: cancom
Table: postorders
[6 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| status | tinyint(4) |
| filepath | text |
| fileSize | int(11) |
| postOrdersID | int(11) |
| submitDatetime | timestamp |
| title | tinytext |
+----------------+------------+
Database: cancom
Table: corporate_policies
[6 columns]
+-------------------+------------+
| Column | Type |
+-------------------+------------+
| status | tinyint(4) |
| corporatePolicyID | int(11) |
| filepath | text |
| fileSize | int(11) |
| submitDatetime | timestamp |
| title | tinytext |
+-------------------+------------+
Database: cancom
Table: alert
[5 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| status | tinyint(4) |
| alertID | int(11) |
| detail | text |
| lastUpdatetime | datetime |
| submitDatetime | datetime |
+----------------+------------+
Database: cancom
Table: test
[2 columns]
+----------+--------------+
| Column | Type |
+----------+--------------+
| id | int(11) |
| myString | varchar(128) |
+----------+--------------+
Database: cancom
Table: elearning
[10 columns]
+-------------------+--------------+
| Column | Type |
+-------------------+--------------+
| name | varchar(40) |
| status | char(1) |
| authorizedCourses | text |
| dateRegistered | timestamp |
| email | varchar(128) |
| id | int(11) |
| lastLoginDatetime | datetime |
| password | blob |
| phone | varchar(12) |
| username | varchar(20) |
+-------------------+--------------+
Database: cancom
Table: trespass
[33 columns]
+----------------+-------------+
| Column | Type |
+----------------+-------------+
| status | tinyint(4) |
| address | tinytext |
| approvedID | smallint(4) |
| attachmentList | text |
| bApproved | bit(1) |
| birth | date |
| city | tinytext |
| clothing | tinytext |
| complexion | tinytext |
| country | tinytext |
| gender | tinytext |
| glasses | tinytext |
| haircolor | tinytext |
| hairlength | tinytext |
| height | tinytext |
| idClient | int(11) |
| idUser | int(11) |
| issuedAt | tinytext |
| issueDate | date |
| lastUpdatetime | datetime |
| marks | tinytext |
| nameFirst | tinytext |
| nameLast | tinytext |
| nameMiddle | tinytext |
| noticeReason | tinytext |
| offenceList | text |
| periodOfTime | tinytext |
| postal | tinytext |
| province | tinytext |
| submitDatetime | datetime |
| tattoos | tinytext |
| trespassID | int(11) |
| weight | tinytext |
+----------------+-------------+
Database: cancom
Table: generaloccurrence
[23 columns]
+---------------------------+-------------+
| Column | Type |
+---------------------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| complaintReceivedBy | tinytext |
| complaintReceivedDatetime | datetime |
| diaryDate | date |
| generalOccurrenceID | int(11) |
| idClient | int(11) |
| idOccurrenceType | int(11) |
| idUser | int(11) |
| initialInvestigationBy | tinytext |
| investigatedDatetime | datetime |
| lastUpdatetime | datetime |
| occurrenceDatetime | datetime |
| openClosed | tinytext |
| place | text |
| policeDivision | tinytext |
| reportedDatetime | datetime |
| siteAddress | text |
| submitDatetime | datetime |
| synopsis | text |
+---------------------------+-------------+
Database: cancom
Table: patrols
[5 columns]
+---------------+---------+
| Column | Type |
+---------------+---------+
| status | bit(1) |
| idClient | int(11) |
| patrolID | int(11) |
| whenFlagged | text |
| whenSubmitted | text |
+---------------+---------+
Database: cancom
Table: occurrencetype
[3 columns]
+------------------+------------+
| Column | Type |
+------------------+------------+
| name | tinytext |
| status | tinyint(4) |
| occurrenceTypeID | int(11) |
+------------------+------------+
Database: cancom
Table: client
[15 columns]
+------------------------------+-------------+
| Column | Type |
+------------------------------+-------------+
| name | tinytext |
| status | tinyint(4) |
| clientID | int(11) |
| companyname | tinytext |
| distance | int(11) |
| email | tinytext |
| lastLoginDatetime | datetime |
| lastUpdatetime | datetime |
| latitude | varchar(20) |
| listLicensePlateRestrictions | text |
| longitude | varchar(20) |
| maxPermitsPerWeek | tinyint(4) |
| password | blob |
| tenantPassword | tinytext |
| username | tinytext |
+------------------------------+-------------+
Database: cancom
Table: invoice_rates
[8 columns]
+-------------+-----------+
| Column | Type |
+-------------+-----------+
| id | int(11) |
| idUser | int(11) |
| isCurrent | bit(1) |
| locationId | int(11) |
| rate | float |
| rateSpecial | float |
| scheduleId | int(11) |
| updateDt | timestamp |
+-------------+-----------+
Database: cancom
Table: province
[4 columns]
+--------------+-------------+
| Column | Type |
+--------------+-------------+
| name | tinytext |
| abbreviation | varchar(10) |
| id | int(11) |
| short | varchar(2) |
+--------------+-------------+
Database: cancom
Table: internal_useofforce
[24 columns]
+---------------------------+--------------+
| Column | Type |
+---------------------------+--------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| complaintReceivedBy | tinytext |
| complaintReceivedDatetime | datetime |
| diaryDate | date |
| idClient | int(11) |
| idOccurrenceType | int(11) |
| idUser | int(11) |
| initialInvestigationBy | tinytext |
| internalUseOfForceID | int(11) |
| investigatedDatetime | datetime |
| lastUpdatetime | datetime |
| occurrenceDatetime | datetime |
| openClosed | tinytext |
| place | text |
| policeDivision | tinytext |
| province | varchar(128) |
| reportedDatetime | datetime |
| siteAddress | text |
| submitDatetime | datetime |
| synopsis | text |
+---------------------------+--------------+
Database: cancom
Table: patrol_history
[8 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| end | datetime |
| start | datetime |
| created | datetime |
| flaggedSentTo | text |
| historyID | int(11) |
| idPatrol | int(11) |
| idUser | int(11) |
| submittedSentTo | text |
+-----------------+----------+
Thank you for fresh bases
Posts: 41
Threads: 20
Joined: Jun 2024
(06-26-2024, 04:51 PM)ALLAH44 Wrote: Ronald Wells is a bit of a Nigger
fuck ronald wells
Posts: 400
Threads: 4
Joined: Jul 2023
(06-26-2024, 01:59 PM)UnicornLover67 Wrote: website: cancomsecurity.com
Quote: "Cancom Security Inc. is dedicated to providing peace of mind to our
clients through proactive security services while enhancing their
personal safety and protecting their properties and proprietary
information."
Revenue: ~ $100M
download cancomsecurity.tar.gz
https://cancomsecurity.com/cyber-security/
CEO, Ronald Wells
[email=ronald.wells@cancomsecurity.com]ronald.wells@cancomsecurity.com[/email] Polsa72809!
416-994-6793 (he does not care about his clients & employees, offered to show vulnerabilities and not leak data for extremely good price lol)
small example datas, Спасибо
userID,name,role,region,status,password,username,onboarding,securityLicence,authorizedClients,lastLoginDatetime
4,Ronald
Wells,Management,ON-GTA,1,6+,RonaldWells,0,250821,"[""91"",""187"",""89"",""182"",""202"",""175"",""196"",""157"",""190"",""219"",""92"",""94"",""177"",""183"",""201"",""131"",""88"",""186"",""206"",""107"",""17"",""184"",""172"",""151"",""154"",""159"",""153"",""155"",""18"",""102"",""103"",""20"",""21"",""149"",""15"",""16"",""146"",""140"",""235"",""178"",""22"",""26"",""185"",""236"",""220"",""221"",""142"",""23"",""207"",""110"",""127"",""41"",""145"",""73"",""74"",""72"",""194"",""181"",""218"",""133"",""170"",""105"",""96"",""121"",""44"",""39"",""29"",""31"",""30"",""104"",""40"",""34"",""32"",""35"",""33"",""28"",""37"",""38"",""36"",""27"",""122"",""143"",""101"",""144"",""191"",""42"",""192"",""118"",""43"",""215"",""212"",""147"",""45"",""134"",""208"",""46"",""193"",""47"",""200"",""106"",""49"",""217"",""165"",""50"",""51"",""52"",""162"",""168"",""53"",""54"",""210"",""160"",""55"",""56"",""166"",""163"",""161"",""62"",""64"",""167"",""57"",""58"",""164"",""171"",""59"
",""60"",""179"",""61"",""197"",""180"",""173"",""63"",""65"",""189"",""209"",""108"",""109"",""66"",""198"",""130"",""203"",""90"",""69"",""93"",""169"",""128"",""68"",""124"",""137"",""138"",""129"",""75"",""67"",""148"",""97"",""98"",""99"",""126"",""188"",""70"",""71"",""205"",""136"",""152"",""139"",""176"",""116"",""117"",""216"",""158"",""214"",""222"",""95"",""77"",""204"",""228"",""224"",""233"",""230"",""232"",""225"",""223"",""234"",""213"",""82"",""24"",""25"",""48"",""19"",""226"",""227"",""231"",""229"",""141"",""78"",""79"",""132"",""125"",""80"",""123"",""199"",""113"",""211"",""112"",""114"",""115"",""111"",""81"",""119"",""76"",""100"",""150"",""195"",""156"",""174"",""83"",""85"",""86"",""87"",""135"",""84""]",2024-06-12
00:30:33
id,userID,city,sin,email,gender,street,country,hire_date,last_name,sin_image,birth_date,first_name,bank_number,postal_code,indian_image,phone_number,approval_date,indian_status,account_number,first_aid_type,middle_initial,province_state,transit_number,drivers_licence,first_aid_image,indian_exp_date,sin_expiry_date,firearms_licence,first_aid_agency,healthcard_image,security_licence,healthcard_number,indian_reg_number,preapproval_notes,first_aid_exp_date,indian_inac_serial,healthcard_exp_date,direct_deposit_image,drivers_licence_class,drivers_licence_image,firearms_licence_auth,first_aid_certificate,firearms_licence_image,security_licence_class,security_licence_image,drivers_licence_exp_date,firearms_licence_exp_date,security_licence_exp_date,drivers_licence_issue_date
15,1208,<blank>,<blank>,mail@cancomsecurity.com,U,"1183 Finch Ave
West, Suite
205",CAN,2020-09-02,Test,0000015-sin.jpg,<blank>,Cancom,<blank>,m3j2g2,NULL,416-763-0000,<blank>,1,<blank>,Standard,1,ON,11251,W2045-34450-11110,0000015-first_aid.png,NULL,2022-02-25,<blank>,Rescue
&,NULL,11111110,<blank>,<blank>,NULL,2023-04-04,<blank>,NULL,0000015-direct_deposit.jpg,G,0000015-drivers_lic.jpeg,Restricted,2211344553,NULL,S,0000015-security_lic.jfif,2022-04-04,NULL,2022-04-04,2018-04-04
16,1210,Essex,492652295,shawn.leroux@gmail.com,M,297 Woodview
Drive,CAN,2020-09-08,wells,0000016-sin.jpg,2020-07-08,ryan,000,N8M
3E8,NULL,2267570000,NULL,1,123456789,Emergency,d,ON,03030,L2458*5986*5455,0000016-first_aid.jpg,NULL,2020-09-08,123456789,Cancom,0000016-health_card.jpg,223995,1616166361,<blank>,NULL,2022-09-08,<blank>,2022-10-08,0000016-direct_deposit.jpg,GM,0000016-drivers_lic.jpg,Restricted,12121212,0000016-firearms_lic.jpg,Guard,0000016-security_lic.jpg,2020-10-20,2022-10-08,2100-09-08,1986-11-08
17,1212,Toronto,123-456-789,scheduling@cancomsecurity.com,M,1183 Finch
Ave
West,CAN,2020-09-08,Dogan,0000017-sin.xltx,1984-03-08,Merdan,345,M6M1P5,NULL,416-763-0000,NULL,1,34554345,Standard,f,ON,54345,werwerwerwerwer,0000017-first_aid.xlsx,NULL,NULL,234wedfsdf234,Rescue
7,NULL,11167131,rwerwerwer234wer,<blank>,NULL,2024-11-08,<blank>,2020-12-22,0000017-direct_deposit.xltx,G,0000017-drivers_lic.xlsx,Restricted,234234234,NULL,Active,0000017-security_lic.xltx,2020-09-02,2022-10-13,2022-10-08,2022-10-11
18,1211,Toronto,59000006,carlosiglesias.cig@hotmail.com,M,1183 Finch
Ave West suite
205,CAN,2020-09-08,Testing6,0000018-sin.jpg,2020-09-30,carlos,562,M3J2G2,NULL,4168590719,NULL,1,123456789,Standard,m,ON,12345,987456123,0000018-first_aid.pdf,NULL,2023-07-08,000012345678,cancom,0000018-health_card.pdf,123456789,3216540000,<blank>,NULL,2023-06-08,<blank>,2028-11-04,0000018-direct_deposit.pdf,g,0000018-drivers_lic.png,<blank>,123456,0000018-firearms_lic.pdf,Guard
,0000018-security_lic.pdf,2023-09-08,2028-11-04,2025-11-04,2020-09-08
19,1214,Farrellton,510738651,vera.jesus@cancomsecurity.com,F,336 Ch
Newcommon,CAN,2020-09-08,Jesus,0000019-sin.pdf,1979-12-29,Vera,006,J0X
1T0,NULL,3439616386,NULL,1,0667303,Standard,L,QC,08761,J220929127906,0000019-first_aid.pdf,NULL,NULL,<blank>,St.
John
Ambulance,NULL,170408,<blank>,<blank>,NULL,2021-04-21,<blank>,NULL,0000019-direct_deposit.pdf,5,NULL,<blank>,1678005185,NULL,N/A,0000019-security_lic.pdf,2027-12-29,NULL,2020-09-29,2020-07-13
20,1215,Toronto,90210,james.deahl@cancomsecurity.com,U,"1183 Finch Ave
West,",CAN,2020-09-08,Deahl,0000020-sin.jpg,2020-09-08,James,123,M3J
2G2,NULL,4167630000,NULL,1,93729271,First
Responder,L,ON,12345,Dueudnffj,0000020-first_aid.jpg,NULL,2020-10-08,<blank>,Joes
bsmt,NULL,90210,<blank>,<blank>,NULL,2026-09-08,<blank>,NULL,0000020-direct_deposit.jpg,Q,0000020-drivers_lic.jpg,<blank>,90210,NULL,What
the hell does this
mean,0000020-security_lic.jpg,2020-11-08,NULL,2022-09-08,2019-09-08
21,1216,Gloucester,123 456
789,khalid.mahmood@cancomsecurity.com,U,1638 Cyrville
Rd,CAN,2020-09-08,test,0000021-sin.jpg,2020-09-07,khalid,123,K1B
3L8,NULL,343-998-8527,NULL,1,1234567890,Emergency,na,ON,12345,na,0000021-first_aid.jpg,NULL,NULL,<blank>,Rescue
7,NULL,11232845,<blank>,<blank>,NULL,2020-09-10,<blank>,NULL,0000021-direct_deposit.jpg,na,NULL,<blank>,N/A,NULL,N/A,0000021-security_lic.jpg,2020-09-09,NULL,2020-09-10,2020-09-10
27,8,Woburn,852 741 963,steve@home.com,F,18 Jefferson
Lane,CAN,2020-09-15,Treescome,0000027-sin.png,1982-11-11,Steve,123,01801,NULL,416-222-3333,2020-09-15,1,123
4567,<blank>,<blank>,ON,12345,<blank>,NULL,NULL,NULL,<blank>,<blank>,NULL,<blank>,<blank>,<blank>,NULL,NULL,<blank>,NULL,0000027-direct_deposit.png,<blank>,NULL,<blank>,<blank>,NULL,<blank>,NULL,NULL,NULL,NULL,NULL
28,1223,Ottawa,458759315,veracostadejesus@hotmail.com,F,1638 cyrville
rd,CAN,2020-09-23,jesus,0000028-sin.pdf,2005-01-28,veronica,006,K1B
3L8,NULL,7054279235,NULL,1,0667303,NULL,<blank>,ON,08761,<blank>,NULL,NULL,NULL,NULL,NULL,NULL,NULL,<blank>,<blank>,NULL,NULL,<blank>,NULL,0000028-direct_deposit.pdf,<blank>,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
userID,name,role,region,status,password,username,onboarding,securityLicence,authorizedClients,lastLoginDatetime
4,Ronald
Wells,Management,ON-GTA,1,6+,RonaldWells,0,250821,
clientID,email,name,status,distance,latitude,password,username,longitude,companyname,lastUpdatetime,tenantPassword,lastLoginDatetime,maxPermitsPerWeek,listLicensePlateRestrictions
15,pulsemanagement@rogers.com,Brookfield- The Pulse 5500 Yonge
St.,0,0,<blank>,from,ThePulseCondo1,<blank>,Brookfield,2022-12-05
1,0,<blank>,from,Torontolibrary,<blank>,TPL,NULL,Cancom2024,NULL,1,NULL
767,dispatch@cancomsecurity.com,BGIS-Reesor
Road,1,0,<blank>,PM官�,BGIS-Reesor Road,<blank>,BGIS,2024-05-15
11:30:16,cancom,NULL,0,NULL
768,dispatch@cancomsecurity.com,TPL Special Site
Patrol,1,0,<blank>,from,TPL Special Site Patrol,<blank>,TPL Special
Site Patrol,2024-05-17 10:21:58,Cancom123,NULL,1,NULL
769,dispatch@cancomsecurity.com,"Wigwamen - 14 Spadina Rd,
Toronto",1,0,<blank>,from,"Wigwamen - 14 Spadina Rd,
Toronto",<blank>,"Wigwamen - 14 Spadina Rd, Toronto",2024-05-28
07:47:02,Cancom123,NULL,1,NULL
770,dispatch@cancomsecurity.com,"McDonalds - 2736 Lakeshore Blvd West,
Etobicoke",1,0,<blank>,PM官�,mcdonaldslakeshore,<blank>,"McDonalds -
2736 Lakeshore Blvd West, Etobicoke",NULL,cancom,NULL,1,NULL
771,dispatch@cancomsecurity.com,Winmar Restoration - 195 Division St S
Arnprior,1,0,<blank>,from,Winmar Restoration - 195 Division St S
Arnprior,<blank>,Winmar Restoration - 195 Division St S
Arnprior,2024-06-10 11:16:48,Cancom123,NULL,1,NULL
id,realmId,name,expires_in,token_type,access_token,refresh_token,x_refresh_token_expires_in
1,123145709608464,Quickbooks,3600,bearer,eyJlbmMiOiJBMTI4Q0JDLUhTMjU2IiwiYWxnIjoiZGlyIn0..m0dy2ex_4i73bPpsi4DmbQ.YAWRblCCJZTXGREIZnJbC4cqIwc-sjLLaJNfzQyjmG-305cC9nK8qbCkOZizWvuSl5p9Q2uVJmAlS7fwB0SP1iICqTTxkibaujXJn4gFIZhvu8KjBki1H_dbjvE5JXJbGkObKPD45Lk0A3-Ynap6FbpY6oA1aBl5vVuQZBYNQ2oKnz9dnnv5ojCjktDNsKgXb_ivD1h3xBPiKBzkCmUX8KU54jrxxrdRYm9I039cEl06qMQouQ90QKGQWjq3sJBHjiXOP1O8Rx8eMYyrJCdbD04xIA1x4C4Q_oYQ_a8T9IhBGHAkSnqMPpTtA5lbyV-ou_RlN_vRloIa7_lB30Usor6Vt7kjZCzuZI-W8Nv4GndnmfB9AkMHhzUfMqiAX-KRlsvFoMlZfsjMrwjmLfR1a55UG5-kh7scW8YU1wdbyxB47NXqUrPo8mN5QjbdxlfxvJdbY38TSE2VoutgZUVoIt2R9u4kHAasdtgqGzL5hLP_fQViIghOUXAEtOsPBN_M9JT_ZYr4hQS2KNfeBIK26qIw0RGmHkz_meP_OgtJ7BnTD6TUNEELwVhJQNEJT_tosp92hplutD4l1QQSTyIRBm33nciYCtld7AyzHBfCVOqkfD-MDPYYdd7Bf9uO-I7wQzlE-QpOglUcYnhotC7pTH7ocOI3eNGfK4tP0DyRy2n2zaunCt-laXi_X7XJHbijodks8pmX2-URaH_sQEWeJ5wSnM5x7vt69wXGxzIz9sc.sphTqVzz3tBWuW3G1siByw,AB11726893209I09YfR3JhaiXAPCQpKMfMamm2y0yUgZgXd4En,8726400
Database: cancom
Table: oauth_tokens
[8 columns]
+----------------------------+---------------+
| Column | Type |
+----------------------------+---------------+
| name | varchar(128) |
| access_token | varchar(4096) |
| expires_in | varchar(128) |
| id | int(11) |
| realmId | varchar(128) |
| refresh_token | varchar(512) |
| token_type | varchar(128) |
| x_refresh_token_expires_in | varchar(128) |
+----------------------------+---------------+
Database: cancom
Table: user_onboarding_pre_encrypt
[50 columns]
+----------------------------+-------------+
| Column | Type |
+----------------------------+-------------+
| sin | varchar(11) |
| account_number | varchar(20) |
| approval_date | date |
| bank_number | varchar(3) |
| birth_date | date |
| city | varchar(20) |
| country | varchar(20) |
| direct_deposit_image | tinytext |
| drivers_licence | varchar(17) |
| drivers_licence_class | varchar(5) |
| drivers_licence_exp_date | date |
| drivers_licence_image | tinytext |
| drivers_licence_issue_date | date |
| email | tinytext |
| firearms_licence | varchar(20) |
| firearms_licence_auth | varchar(20) |
| firearms_licence_exp_date | date |
| firearms_licence_image | tinytext |
| first_aid_agency | tinytext |
| first_aid_certificate | tinytext |
| first_aid_exp_date | date |
| first_aid_image | tinytext |
| first_aid_type | tinytext |
| first_name | tinytext |
| gender | varchar(1) |
| healthcard_exp_date | date |
| healthcard_image | tinytext |
| healthcard_number | varchar(20) |
| hire_date | date |
| id | int(11) |
| indian_exp_date | date |
| indian_image | tinytext |
| indian_inac_serial | varchar(20) |
| indian_reg_number | varchar(20) |
| indian_status | varchar(1) |
| last_name | tinytext |
| middle_initial | varchar(4) |
| phone_number | varchar(12) |
| postal_code | varchar(7) |
| preapproval_notes | text |
| province_state | varchar(2) |
| security_licence | tinytext |
| security_licence_class | tinytext |
| security_licence_exp_date | date |
| security_licence_image | tinytext |
| sin_expiry_date | date |
| sin_image | tinytext |
| street | tinytext |
| transit_number | varchar(5) |
| userID | int(11) |
+----------------------------+-------------+
Database: cancom
Table: vehicleinspection
[46 columns]
+---------------------+------------+
| Column | Type |
+---------------------+------------+
| locks | text |
| status | tinyint(4) |
| aircontrols | text |
| approvedID | int(11) |
| attachmentList | text |
| bApproved | bit(1) |
| battery | text |
| belts | text |
| decalsLights | text |
| dentsScratches | text |
| driverFirstName | tinytext |
| driverLastName | tinytext |
| electricSeats | text |
| ending | tinytext |
| filtres | text |
| fluids | text |
| foldingSeats | text |
| glowlights | text |
| headrests | text |
| horn | text |
| idClient | int(11) |
| idUser | int(11) |
| inspectionDatetime | datetime |
| interiorLights | text |
| lastOilChange | tinytext |
| lastUpdatetime | datetime |
| leaks | text |
| licencePlate | text |
| lightsSignals | text |
| makeModel | text |
| mirrors | text |
| nextOilChange | tinytext |
| notes | text |
| purchaseGasLitres | tinytext |
| purchaseGasPrice | tinytext |
| purchaseGasYesNo | tinytext |
| radio | text |
| seatBelts | text |
| startingKm | tinytext |
| submitDatetime | datetime |
| tirePressure | text |
| upholstery | text |
| vehicleInspectionID | int(11) |
| vehicleYear | text |
| windows | text |
| wipers | text |
+---------------------+------------+
Database: cancom
Table: user_checkin
[4 columns]
+-----------------+------------+
| Column | Type |
+-----------------+------------+
| checkin_status | tinyint(4) |
| clientID | int(11) |
| last_dt_checkin | datetime |
| userID | int(11) |
+-----------------+------------+
Database: cancom
Table: invoice_location
[6 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| id | int(11) |
| isIncludeBulk | tinyint(4) |
| locationId | int(11) |
| qb_customer_displayname | varchar(256) |
| qb_customer_id | int(11) |
| statHolidayMultiplier | float |
+-------------------------+--------------+
Database: cancom
Table: parkingpermit
[16 columns]
+-----------------+-------------+
| Column | Type |
+-----------------+-------------+
| from | datetime |
| status | tinyint(4) |
| approvedID | smallint(4) |
| bApproved | bit(1) |
| email | tinytext |
| expires | datetime |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| licensePlate | tinytext |
| parkingPermitID | int(11) |
| permitsGranted | tinyint(4) |
| submitDatetime | datetime |
| suite | tinytext |
| vehicleMake | tinytext |
| vehicleModel | tinytext |
+-----------------+-------------+
Database: cancom
Table: payroll_emp_loc
[8 columns]
+------------+-----------+
| Column | Type |
+------------+-----------+
| employeeId | int(11) |
| id | int(11) |
| idUser | int(11) |
| isCurrent | bit(1) |
| locationId | int(11) |
| rate | float |
| scheduleId | int(11) |
| updateDt | timestamp |
+------------+-----------+
Database: cancom
Table: user_onboarding
[62 columns]
+----------------------------+--------------+
| Column | Type |
+----------------------------+--------------+
| sin | blob |
| account_number | blob |
| approval_date | date |
| bank_number | blob |
| birth_date | blob |
| city | varchar(20) |
| country | varchar(20) |
| direct_deposit_image | tinytext |
| drivers_licence | blob |
| drivers_licence_class | varchar(5) |
| drivers_licence_exp_date | blob |
| drivers_licence_image | tinytext |
| drivers_licence_issue_date | blob |
| email | tinytext |
| firearms_licence | blob |
| firearms_licence_auth | blob |
| firearms_licence_exp_date | blob |
| firearms_licence_image | tinytext |
| first_aid_agency | tinytext |
| first_aid_certificate | blob |
| first_aid_exp_date | blob |
| first_aid_image | tinytext |
| first_aid_type | tinytext |
| first_name | tinytext |
| gender | varchar(1) |
| healthcard_exp_date | date |
| healthcard_image | tinytext |
| healthcard_number | varchar(20) |
| hire_date | date |
| id | int(11) |
| identification1_image | tinytext |
| identification2_image | tinytext |
| indian_exp_date | blob |
| indian_image | tinytext |
| indian_inac_serial | blob |
| indian_reg_number | blob |
| indian_status | varchar(1) |
| last_name | tinytext |
| middle_initial | varchar(4) |
| permit | blob |
| permit_expiry_date | blob |
| permit_image | tinytext |
| phone_number | varchar(12) |
| postal_code | varchar(7) |
| preapproval_notes | text |
| province_state | varchar(2) |
| security_licence | blob |
| security_licence_class | tinytext |
| security_licence_exp_date | blob |
| security_licence_image | tinytext |
| sin_expiry_date | blob |
| sin_image | tinytext |
| street | tinytext |
| transit_number | blob |
| uniform_glove | varchar(20) |
| uniform_hat | varchar(20) |
| uniform_pants_length | varchar(20) |
| uniform_pants_waist | varchar(20) |
| uniform_shirt | varchar(128) |
| uniform_shoe | varchar(20) |
| uniform_vest | varchar(128) |
| userID | int(11) |
+----------------------------+--------------+
Database: cancom
Table: patrol_history_detail
[8 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| bCodeScaned | tinyint(1) |
| bflagged | tinyint(1) |
| checkpointTime | datetime |
| geoCoords | tinytext |
| idCheckpoint | int(11) |
| idHistory | int(11) |
| images | text |
| note | text |
+----------------+------------+
Database: cancom
Table: patrol_checkpoints
[8 columns]
+--------------+------------+
| Column | Type |
+--------------+------------+
| description | text |
| name | tinytext |
| status | bit(1) |
| bImage | tinyint(4) |
| checkpointID | int(11) |
| idPatrol | int(11) |
| NFC_tag | tinytext |
| QR_code | tinytext |
+--------------+------------+
Database: cancom
Table: user
[11 columns]
+-------------------+--------------+
| Column | Type |
+-------------------+--------------+
| name | tinytext |
| role | tinytext |
| status | tinyint(4) |
| authorizedClients | text |
| lastLoginDatetime | datetime |
| onboarding | tinyint(4) |
| password | blob |
| region | varchar(128) |
| securityLicence | tinytext |
| userID | int(11) |
| username | tinytext |
+-------------------+--------------+
Database: cancom
Table: payroll_managers
[2 columns]
+----------------+---------+
| Column | Type |
+----------------+---------+
| id | int(11) |
| managerEidList | text |
+----------------+---------+
Database: cancom
Table: emails
[10 columns]
+---------------------+----------+
| Column | Type |
+---------------------+----------+
| bAlarmResponse | bit(1) |
| bGeneralOccurrence | bit(1) |
| bParkingEnforcement | bit(1) |
| bParkingPermit | bit(1) |
| bSecurityLog | bit(1) |
| bTrespass | bit(1) |
| bUseOfForce | bit(1) |
| email | tinytext |
| emailID | int(11) |
| idClient | int(11) |
+---------------------+----------+
Database: cancom
Table: securitylog
[14 columns]
+----------------+-------------+
| Column | Type |
+----------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| bApproved | bit(1) |
| details | text |
| endTime | time |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| securityLogID | int(11) |
| shiftDate | date |
| siteAddress | text |
| startTime | time |
| submitDatetime | datetime |
+----------------+-------------+
Database: cancom
Table: alarmresponse
[32 columns]
+-------------------------+--------------+
| Column | Type |
+-------------------------+--------------+
| keys | tinytext |
| name | tinytext |
| status | tinyint(4) |
| actionTaken | text |
| alarmResponseID | int(11) |
| alarmStatus | varchar(128) |
| alarmTypeList | text |
| alarmTypeOther | tinytext |
| alarmZone | tinytext |
| approvedID | smallint(4) |
| arrivalTime | time |
| attachmentList | text |
| bApproved | bit(1) |
| comments | text |
| departureTime | time |
| dispatchRequestTypeList | text |
| fireDept | tinytext |
| idClient | int(11) |
| idUser | int(11) |
| isBilled | tinyint(4) |
| keyNumBoxNum | tinytext |
| lastUpdatetime | datetime |
| otherNames | tinytext |
| policeService | tinytext |
| receivedDatetime | datetime |
| reportToClient | tinytext |
| requestedBy | tinytext |
| serviceCallNum | tinytext |
| serviceDispatched | tinytext |
| siteAddress | text |
| submitDatetime | datetime |
| subscriber | tinytext |
+-------------------------+--------------+
Database: cancom
Table: elearning_course
[7 columns]
+--------------+--------------+
| Column | Type |
+--------------+--------------+
| code | varchar(30) |
| description | text |
| name | varchar(50) |
| status | varchar(128) |
| url | tinytext |
| archive_date | date |
| courseID | int(11) |
+--------------+--------------+
Database: cancom
Table: parkingenforcement
[23 columns]
+----------------------+-------------+
| Column | Type |
+----------------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| arrivalTime | time |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| calledTow | tinytext |
| departureTime | time |
| details | text |
| idClient | int(11) |
| idUser | int(11) |
| lastUpdatetime | datetime |
| numOfTags | tinyint(4) |
| numOfTows | tinyint(4) |
| parkingEnforcementID | int(11) |
| place | text |
| policeDivision | tinytext |
| reportedDate | date |
| siteAddress | text |
| submitDatetime | datetime |
| towCompany | tinytext |
| towedTo | tinytext |
| truckLicNum | tinytext |
+----------------------+-------------+
Database: cancom
Table: postorders
[6 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| status | tinyint(4) |
| filepath | text |
| fileSize | int(11) |
| postOrdersID | int(11) |
| submitDatetime | timestamp |
| title | tinytext |
+----------------+------------+
Database: cancom
Table: corporate_policies
[6 columns]
+-------------------+------------+
| Column | Type |
+-------------------+------------+
| status | tinyint(4) |
| corporatePolicyID | int(11) |
| filepath | text |
| fileSize | int(11) |
| submitDatetime | timestamp |
| title | tinytext |
+-------------------+------------+
Database: cancom
Table: alert
[5 columns]
+----------------+------------+
| Column | Type |
+----------------+------------+
| status | tinyint(4) |
| alertID | int(11) |
| detail | text |
| lastUpdatetime | datetime |
| submitDatetime | datetime |
+----------------+------------+
Database: cancom
Table: test
[2 columns]
+----------+--------------+
| Column | Type |
+----------+--------------+
| id | int(11) |
| myString | varchar(128) |
+----------+--------------+
Database: cancom
Table: elearning
[10 columns]
+-------------------+--------------+
| Column | Type |
+-------------------+--------------+
| name | varchar(40) |
| status | char(1) |
| authorizedCourses | text |
| dateRegistered | timestamp |
| email | varchar(128) |
| id | int(11) |
| lastLoginDatetime | datetime |
| password | blob |
| phone | varchar(12) |
| username | varchar(20) |
+-------------------+--------------+
Database: cancom
Table: trespass
[33 columns]
+----------------+-------------+
| Column | Type |
+----------------+-------------+
| status | tinyint(4) |
| address | tinytext |
| approvedID | smallint(4) |
| attachmentList | text |
| bApproved | bit(1) |
| birth | date |
| city | tinytext |
| clothing | tinytext |
| complexion | tinytext |
| country | tinytext |
| gender | tinytext |
| glasses | tinytext |
| haircolor | tinytext |
| hairlength | tinytext |
| height | tinytext |
| idClient | int(11) |
| idUser | int(11) |
| issuedAt | tinytext |
| issueDate | date |
| lastUpdatetime | datetime |
| marks | tinytext |
| nameFirst | tinytext |
| nameLast | tinytext |
| nameMiddle | tinytext |
| noticeReason | tinytext |
| offenceList | text |
| periodOfTime | tinytext |
| postal | tinytext |
| province | tinytext |
| submitDatetime | datetime |
| tattoos | tinytext |
| trespassID | int(11) |
| weight | tinytext |
+----------------+-------------+
Database: cancom
Table: generaloccurrence
[23 columns]
+---------------------------+-------------+
| Column | Type |
+---------------------------+-------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| complaintReceivedBy | tinytext |
| complaintReceivedDatetime | datetime |
| diaryDate | date |
| generalOccurrenceID | int(11) |
| idClient | int(11) |
| idOccurrenceType | int(11) |
| idUser | int(11) |
| initialInvestigationBy | tinytext |
| investigatedDatetime | datetime |
| lastUpdatetime | datetime |
| occurrenceDatetime | datetime |
| openClosed | tinytext |
| place | text |
| policeDivision | tinytext |
| reportedDatetime | datetime |
| siteAddress | text |
| submitDatetime | datetime |
| synopsis | text |
+---------------------------+-------------+
Database: cancom
Table: patrols
[5 columns]
+---------------+---------+
| Column | Type |
+---------------+---------+
| status | bit(1) |
| idClient | int(11) |
| patrolID | int(11) |
| whenFlagged | text |
| whenSubmitted | text |
+---------------+---------+
Database: cancom
Table: occurrencetype
[3 columns]
+------------------+------------+
| Column | Type |
+------------------+------------+
| name | tinytext |
| status | tinyint(4) |
| occurrenceTypeID | int(11) |
+------------------+------------+
Database: cancom
Table: client
[15 columns]
+------------------------------+-------------+
| Column | Type |
+------------------------------+-------------+
| name | tinytext |
| status | tinyint(4) |
| clientID | int(11) |
| companyname | tinytext |
| distance | int(11) |
| email | tinytext |
| lastLoginDatetime | datetime |
| lastUpdatetime | datetime |
| latitude | varchar(20) |
| listLicensePlateRestrictions | text |
| longitude | varchar(20) |
| maxPermitsPerWeek | tinyint(4) |
| password | blob |
| tenantPassword | tinytext |
| username | tinytext |
+------------------------------+-------------+
Database: cancom
Table: invoice_rates
[8 columns]
+-------------+-----------+
| Column | Type |
+-------------+-----------+
| id | int(11) |
| idUser | int(11) |
| isCurrent | bit(1) |
| locationId | int(11) |
| rate | float |
| rateSpecial | float |
| scheduleId | int(11) |
| updateDt | timestamp |
+-------------+-----------+
Database: cancom
Table: province
[4 columns]
+--------------+-------------+
| Column | Type |
+--------------+-------------+
| name | tinytext |
| abbreviation | varchar(10) |
| id | int(11) |
| short | varchar(2) |
+--------------+-------------+
Database: cancom
Table: internal_useofforce
[24 columns]
+---------------------------+--------------+
| Column | Type |
+---------------------------+--------------+
| status | tinyint(4) |
| approvedID | smallint(4) |
| attachmentList | text |
| attachmentType | tinytext |
| bApproved | bit(1) |
| complaintReceivedBy | tinytext |
| complaintReceivedDatetime | datetime |
| diaryDate | date |
| idClient | int(11) |
| idOccurrenceType | int(11) |
| idUser | int(11) |
| initialInvestigationBy | tinytext |
| internalUseOfForceID | int(11) |
| investigatedDatetime | datetime |
| lastUpdatetime | datetime |
| occurrenceDatetime | datetime |
| openClosed | tinytext |
| place | text |
| policeDivision | tinytext |
| province | varchar(128) |
| reportedDatetime | datetime |
| siteAddress | text |
| submitDatetime | datetime |
| synopsis | text |
+---------------------------+--------------+
Database: cancom
Table: patrol_history
[8 columns]
+-----------------+----------+
| Column | Type |
+-----------------+----------+
| end | datetime |
| start | datetime |
| created | datetime |
| flaggedSentTo | text |
| historyID | int(11) |
| idPatrol | int(11) |
| idUser | int(11) |
| submittedSentTo | text |
+-----------------+----------+
great share
Posts: 1,144
Threads: 11
Joined: Aug 2023
This is great, thank you for sharing this here. Appreciate it
Posts: 11
Threads: 1
Joined: Apr 2024
lol good leak wish i can download it
|
