INSERT INTO `tb_company` VALUES (77621,NULL,'WAVETEL TECHNOLOGY LIMITED','FLAT 1503,15/F, CARNIVAL COMMERCIAL BUILDING,  18 JAVA ROAD, NORTH POINT','Hong Kong  Hongkong  999077','','','','HK','2024-08-14','WAVETEL TECHNOLOGY LIMITED','FLAT 1503,15/F, CARNIVAL COMMERCIAL BUILDING,  18 JAVA ROAD, NORTH POINT','Hong Kong  Hongkong  999077','','','','HK',NULL),(77622,NULL,'Fortx','c/o Ward Goodman, 4 Cedar Park, Cobham Road','Wimborne    BH21 7SF','','','','GB','2024-08-14','Fortx','c/o Ward Goodman, 4 Cedar Park, Cobham Road','Wimborne    BH21 7SF','','','','GB',NULL),(77623,NULL,'Funtime Pickleball Inc.','2200 N. Commerce Parkway','Weston  FL  33326','','','','US','2024-08-16','Funtime Pickleball Inc.','2200 N. Commerce Parkway','Weston  FL  33326','','','','US',NULL),(77624,NULL,'Subeca','789 N Grove Rd  Suite 103','Richardson  TX  75081','','','','US','2024-08-16','Subeca','789 N Grove Rd  Suite 103','Richardson  TX  75081','','','','US',NULL),(77625,NULL,'WIKO Terminal Technology (Dongguan) Co., Ltd.','Building 3, No. 6, Hongmian Road, Songshan Lake Park, Dongguan City, Guangdong Province','Dongguan  Guangdong  523808','','','','CN','2024-08-16','WIKO Terminal Technology (Dongguan) Co., Ltd.','Building 3, No. 6, Hongmian Road, Songshan Lake Park, Dongguan City, Guangdong Province','Dongguan  Guangdong  523808','','','','CN',NULL),(77626,NULL,'Optomind Inc.','16 Deogyeong-daero #1556, Suite B-301, Yeongtong-gu','Suwon  Gyeonggi-do  16690','','','','KR','2024-08-17','Optomind Inc.','16 Deogyeong-daero #1556, Suite B-301, Yeongtong-gu','Suwon  Gyeonggi-do  16690','','','','KR',NULL),(77627,NULL,'LG Electornics ','LG Electronis 7','MŁAWA  Mazowieckie  06-500','','','','PL','2024-08-22','LG Electornics ','LG Electronis 7','MŁAWA  Mazowieckie  06-500','','','','PL',NULL),(77628,NULL,'Infinix mobility limited','RMS 05-15, 13A/F SOUTH TOWER WORLD FINANCE CTR HARBOUR CITY 17 CANTON RD TST KLN HONG KONG','HongKong  HongKong  999077','','','','HK','2024-08-22','Infinix mobility limited','RMS 05-15, 13A/F SOUTH TOWER WORLD FINANCE CTR HARBOUR CITY 17 CANTON RD TST KLN HONG KONG','','','','','HongKong  HongKong  999077',NULL),(77629,NULL,'Beijing Gctech Technology Co.,LTD','Room 409, 4 / F, Building 1, No. 18 Jingxing Street, East Industrial Base, Science and Technology Park, Changping District','Beijing    102200','','','','CN','2024-08-22','Beijing Gctech Technology Co.,LTD','Room 409, 4 / F, Building 1, No. 18 Jingxing Street, East Industrial Base, Science and Technology Park, Changping District','Beijing    102200','','','','CN',NULL),(77630,NULL,'G.Tech Technology Ltd.','No.8,Jinyuan 1st Road,Tangjiawan Town, High-tech Zone','Zhuhai  Guangdong  519085','','','','CN','2024-08-22','G.Tech Technology Ltd.','No.8,Jinyuan 1st Road,Tangjiawan Town, High-tech Zone','Zhuhai  Guangdong  519085','','','','CN',NULL),(77631,NULL,'Interdisciplinary Consulting Corporation','2405 NW 66th Ct','Gainesville  FL  32653-1633','','','','US','2024-08-22','Interdisciplinary Consulting Corporation','2405 NW 66th Ct','Gainesville  FL  32653-1633','','','','US',NULL),(77632,NULL,'Nanjing Simon Info Tech Co.,Ltd.','Room 1009, Building 3, No. 50, Jialingjiang East Street, Jianye District, Nanjing','Nanjing  Jiangsu  210019','','','','CN','2024-08-24','Nanjing Simon Info Tech Co.,Ltd.','Room 1009, Building 3, No. 50, Jialingjiang East Street, Jianye District, Nanjing','Nanjing  Jiangsu  210019','','','','CN',NULL),(77633,NULL,'Nokia Solutions and Networks GmbH & Co. KG','Werinherstrasse 91','München  Bavaria  D-81541','','','','DE','2024-08-24','Nokia Solutions and Networks GmbH & Co. KG','Werinherstrasse 91','','','','','München  Bavaria  D-81541',NULL),(77634,NULL,'Chongqing Zhouhai  intelligent  technology CO., Ltd','No. 8, Layer Rock Industrial Zone, Yulu Community, Yutang Street, Guangming District, Shenzhen','Shenzhen  Guangdong  518107','','','','CN','2024-09-01','Chongqing Zhouhai  intelligent  technology CO., Ltd','No. 8, Layer Rock Industrial Zone, Yulu Community, Yutang Street, Guangming District, Shenzhen','Shenzhen  Guangdong  518107','','','','CN',NULL),(77635,NULL,'Shanghai JINXVM Microelectronics Co.,Ltd.','Room 804, Building3, No.260 Maoyuan Road, Fengxian District, Shanghai, China','Shanghai    201403','','','','CN','2024-09-01','Shanghai JINXVM Microelectronics Co.,Ltd.','Room 804, Building3, No.260 Maoyuan Road, Fengxian District, Shanghai, China','Shanghai    201403','','','','CN',NULL),(77636,NULL,'SHENZHEN FENDA TECHNOLOGY CO., LTD','Fenda Hi-Tech Park, Zhoushi Road, Shiyan Town, Baoan District, Shenzhen City, Guangdong, China','Shenzhen  Guangdong  518108','','','','CN','2024-09-01','SHENZHEN FENDA TECHNOLOGY CO., LTD','Fenda Hi-Tech Park, Zhoushi Road, Shiyan Town, Baoan District, Shenzhen City, Guangdong, China','Shenzhen  Guangdong  518108','','','','CN',NULL),(77637,NULL,'Vivint Inc','3401 N Ashton Blvd','Lehi  UT  84043','','','','US','2024-09-01','Vivint Inc','3401 N Ashton Blvd','Lehi  UT  84043','','','','US',NULL),(77638,NULL,'Ubee Interactive Co., Limited','UNIT 2703A, 27/F., 148 ELECTRIC ROAD, NORTH POINT, HONG KONG','NORTH POINT    00000','','','','HK','2024-09-01','Ubee Interactive Co., Limited','UNIT 2703A, 27/F., 148 ELECTRIC ROAD, NORTH POINT, HONG KONG','NORTH POINT    00000','','','','HK',NULL),(77639,NULL,'SystemX Co.,Ltd.','102, Gosan-ro','Gunpo-si  Gyeonggi-do, Republic of Korea  15849','','','','KR','2024-09-01','SystemX Co.,Ltd.','102, Gosan-ro','Gunpo-si  Gyeonggi-do, Republic of Korea  15849','','','','KR',NULL),(77640,NULL,'Unis Flash Memory Technology(Chengdu)Co.,Ltd.','No. 2110, 21st Floor, Unit 1, Building 1, No. 505, West Section of Fucheng Avenue, High Tech. Zone, Chengdu City, Sichuan Provin','Chengdu  Sichuan  610000','','','','CN','2024-09-01','Unis Flash Memory Technology(Chengdu)Co.,Ltd.','No. 2110, 21st Floor, Unit 1, Building 1, No. 505, West Section of Fucheng Avenue, High Tech. Zone, Chengdu City, Sichuan Provin','Chengdu  Sichuan  610000','','','','CN',NULL),(77641,NULL,'ShieldSOS LLC','3700 Kyle Crossing, Suite 500','KYLE  TX  78640','','','','US','2024-09-01','ShieldSOS LLC','3700 Kyle Crossing, Suite 500','KYLE  TX  78640','','','','US',NULL),(77642,NULL,'INTENTSECURE Inc.,','717 HO, 42, Changeop-ro, Sujeong-gu','Seongnam-si  Gyeonggi-do  13449','','','','KR','2024-09-01','INTENTSECURE Inc.,','717 HO, 42, Changeop-ro, Sujeong-gu','Seongnam-si  Gyeonggi-do  13449','','','','KR',NULL),(77643,NULL,'Skychers Creations ShenZhen Limited','Room 907A, 9/F, Block T2, FongDa City, Longjing Village, Longzhu Avenue, Nanshan District','Shenzhen  Guangdong  518073','','','','CN','2024-09-01','Skychers Creations ShenZhen Limited','Room 907A, 9/F, Block T2, FongDa City, Longjing Village, Longzhu Avenue, Nanshan District','','','','','Shenzhen  Guangdong  518073',NULL),(77644,NULL,'Dongguan Mentech Optical & Magnetic Co., Ltd.','Building A, No. 157 Dongyuan Avenue, Shipai Town, Dongguan City, Guangdong Province','Dongguan    523000','','','','CN','2024-09-04','Dongguan Mentech Optical & Magnetic Co., Ltd.','Building A, No. 157 Dongyuan Avenue, Shipai Town, Dongguan City, Guangdong Province','Dongguan    523000','','','','CN',NULL),(77645,NULL,'TelHi Corporation','1-32-2, Kosuge','Katsushika-ku  Tokyo  1240001','','','','JP','2024-09-05','TelHi Corporation','1-32-2, Kosuge','Katsushika-ku  Tokyo  1240001','','','','JP',NULL),(77646,NULL,'Telechips, Inc.','27, Geumto-ro 80beon-gil, Sujeong-gu,','Seongnam-si,  Gyeonggi-do  13453','','','','KR','2024-09-07','Telechips, Inc.','27, Geumto-ro 80beon-gil, Sujeong-gu,','Seongnam-si,  Gyeonggi-do  13453','','','','KR',NULL),(77647,NULL,'FiSens GmbH','Salzdahlumer Str.196','Braunschweig    38126','','','','DE','2024-09-07','FiSens GmbH','Salzdahlumer Str.196','Braunschweig    38126','','','','DE',NULL),(77648,NULL,'HANSHOW TECHNOLOGY CO.,LTD.','The 1st Floor Podium and Floor 4 of Building 1, Floor 7 of Building 5, JiaxingPhotovoltaic Technology Innovation Park, No.1288, ','JIAXING    314000','','','','CN','2024-09-07','HANSHOW TECHNOLOGY CO.,LTD.','The 1st Floor Podium and Floor 4 of Building 1, Floor 7 of Building 5, JiaxingPhotovoltaic Technology Innovation Park, No.1288, ','JIAXING    314000','','','','CN',NULL),(77649,NULL,'FN-LINK TECHNOLOGY Ltd.','No.8, Litong Road, Liuyang Economic & Technical Development Zone, Changsha, Hunan,China','Changsha  Hunan  410329','','','','CN','2024-09-07','FN-LINK TECHNOLOGY Ltd.','No.8, Litong Road, Liuyang Economic & Technical Development Zone, Changsha, Hunan,China','','','','','Changsha  Hunan  410329',NULL),(77650,NULL,'Nanjing phx-gctech Information Technology Co., Ltd','Building 6, No. 1009, Tianyuan East Road, Jiangning District, Nanjing','NanJing  JiangSu  21000','','','','CN','2024-09-10','Nanjing phx-gctech Information Technology Co., Ltd','Building 6, No. 1009, Tianyuan East Road, Jiangning District, Nanjing','NanJing  JiangSu  21000','','','','CN',NULL),(77651,NULL,'Verifone, Inc.','2744 North University Drive','Coral Springs  FL  33065','','','','US','2024-09-10','Verifone, Inc.','2744 North University Drive','Coral Springs  FL  33065','','','','US',NULL),(77652,NULL,'MICIUS Laboratory','Room 429, Henan Academy of Sciences,No.228 Chongshili, Zhengdong New District','Zhengzhou City  Henan Province  450046','','','','CN','2024-09-10','MICIUS Laboratory','Room 429, Henan Academy of Sciences,No.228 Chongshili, Zhengdong New District','Zhengzhou City  Henan Province  450046','','','','CN',NULL),(77653,NULL,'Miba Battery Systems GmbH','Maximilianstrasse 4','Bad Leonfelden    4190','','','','AT','2024-09-12','Miba Battery Systems GmbH','Maximilianstrasse 4','Bad Leonfelden    4190','','','','AT',NULL),(77654,NULL,'Shenzhen SiACRRIER Industry Machines Co.,LTD','Room 1301, Building 6, Zhongke Valley Industrial Park, Zhonghuan Avenue, Shanxia Community, Pinghu Street, Longgang District, Sh','Shenzhen    518116','','','','CN','2024-09-12','Shenzhen SiACRRIER Industry Machines Co.,LTD','Room 1301, Building 6, Zhongke Valley Industrial Park, Zhonghuan Avenue, Shanxia Community, Pinghu Street, Longgang District, Sh','Shenzhen    518116','','','','CN',NULL),(77655,NULL,'Beijing Global Safety Technology Co., LTD.','Building 1, No.3 Fengxiu Middle Road, Haidian District','Beijing    100000','','','','CN','2024-09-12','Beijing Global Safety Technology Co., LTD.','Building 1, No.3 Fengxiu Middle Road, Haidian District','Beijing    100000','','','','CN',NULL),(77656,NULL,'Jiangxi Risound Electronics Co.,LTD','No 271,innovation Avenue, Jinggangshan economic and Technological Development Zone','Ji\'an  Jiangxi  343100','','','','CN','2024-09-12','Jiangxi Risound Electronics Co.,LTD','No 271,innovation Avenue, Jinggangshan economic and Technological Development Zone','Ji\'an  Jiangxi  343100','','','','CN',NULL),(77657,NULL,'SenArch ApS','C/O DTU Science Park Diplomvej 372, 1.','Kgs Lyngby  Copenhagen  2800','','','','DK','2024-09-13','SenArch ApS','C/O DTU Science Park Diplomvej 372, 1.','Kgs Lyngby  Copenhagen  2800','','','','DK',NULL),(77658,NULL,'Shenzhen SDMC Technology CO., LTD','Xin\'an 3rd Road, Dalang Community, Xin\'an Street','Shenzhen  Guangdong  518000','','','','CN','2024-09-14','Shenzhen SDMC Technology CO., LTD','Xin\'an 3rd Road, Dalang Community, Xin\'an Street','Shenzhen  Guangdong  518000','','','','CN',NULL),(77659,NULL,'Ring LLC','12515 Cerise Avenue','Hawthorne  CA  90250','','','','US','2024-09-14','Ring LLC','12515 Cerise Avenue','Hawthorne  CA  90250','','','','US',NULL),(77660,NULL,'Daikin Europe NV','Zandvoordestraat 300 ','Oostende  West-Vlaanderen  8400','','','','BE','2024-09-17','Daikin Europe NV','Zandvoordestraat 300 ','Oostende  West-Vlaanderen  8400','','','','BE',NULL),(77661,NULL,'Shenzhen iComm Semiconductor CO.,LTD','Room204,scientific research building,Tsinghua Hi-Tech Park,No.13 Langshan Road,Nanshan District','Shenzhen  Guangdong  518067','','','','CN','2024-09-17','Shenzhen iComm Semiconductor CO.,LTD','Room204,scientific research building,Tsinghua Hi-Tech Park,No.13 Langshan Road,Nanshan District','','','','','Shenzhen  Guangdong  518067',NULL),(77662,NULL,'SJIT Co., Ltd.','54-33 Dongtanhana 1-gil','Hwaseong-si  Gyeonggi-do  18423','','','','KR','2024-09-17','SJIT Co., Ltd.','54-33 Dongtanhana 1-gil','Hwaseong-si  Gyeonggi-do  18423','','','','KR',NULL),(77663,NULL,'ITLook','Karla Marksa st. 3b','Ufa    450008','','','','RU','2024-09-18','ITLook','Karla Marksa st. 3b','','','','','Ufa    450008',NULL),(77664,NULL,'Extreme Networks Headquarters','2121 RDU Center Drive ','Morrisville    27560','','','','US','2024-09-19','Extreme Networks Headquarters','2121 RDU Center Drive ','Morrisville    27560','','','','US',NULL),(77665,NULL,'Arlo Technology','480 North McCarthy Blvd, Suite 200','Milpitas  CA  95035','','','','US','2024-09-19','Arlo Technology','480 North McCarthy Blvd, Suite 200','Milpitas  CA  95035','','','','US',NULL),(77666,NULL,'CHENGDU XUGUANG TECHNOLOGY CO,LTD','2ND SECTION,PARK ROAD','CHENGDU  SICHUAN  610100 ','','','','CN','2024-09-20','CHENGDU XUGUANG TECHNOLOGY CO,LTD','2ND SECTION,PARK ROAD','CHENGDU  SICHUAN  610100 ','','','','CN',NULL),(77667,NULL,'Trident IoT','1903 Wright Pl, Ste 360','Carlsbad  CA  92008','','','','US','2024-09-20','Trident IoT','1903 Wright Pl, Ste 360','Carlsbad  CA  92008','','','','US',NULL),(77668,NULL,'BSH Electrical Appliances (Jiangsu) Co., Ltd.','Yaoxin Road No.208210046 NanjingJiangsu CN','NANJING  Jiangsu  210046','','','','CN','2024-09-20','BSH Electrical Appliances (Jiangsu) Co., Ltd.','Yaoxin Road No.208210046 NanjingJiangsu CN','','','','','NANJING  Jiangsu  210046',NULL),(77669,NULL,'SAFEMO PTE. LTD.','61 BUKIT BATOK CRESCENT #05-505 HENG LOONG BUILDING','Singapore    658078','','','','SG','2024-09-21','SAFEMO PTE. LTD.','61 BUKIT BATOK CRESCENT #05-505 HENG LOONG BUILDING','Singapore    658078','','','','SG',NULL),(77670,NULL,'Kiwibit Inc.','17880 Skypark Circle Suite 260','Irvine  CA  92614','','','','US','2024-09-21','Kiwibit Inc.','17880 Skypark Circle Suite 260','Irvine  CA  92614','','','','US',NULL),(77671,NULL,'Elkor Technologies Inc.','6 Bainard Street','London  Ontario  N6P1A8','','','','CA','2024-09-21','Elkor Technologies Inc.','6 Bainard Street','London  Ontario  N6P1A8','','','','CA',NULL),(77672,NULL,'Tianjin HuaLai Technology CO., Ltd.','2301, Building 5, Tianjin Science and Technology Plaza, (Tiankai Park) , Kexue East Road','Nankai District  Tianjin  300000','','','','CN','2024-09-21','Tianjin HuaLai Technology CO., Ltd.','2301, Building 5, Tianjin Science and Technology Plaza, (Tiankai Park) , Kexue East Road','Nankai District  Tianjin  300000','','','','CN',NULL),(77673,NULL,'SHENZHEN MICIPC TECHNOLOGY CO.,LTD','508,building 8,Hengda fashion Huigu,Fulong Road,Dalang street,Longhua District,Shenzhen','Shenzhen    518000','','','','CN','2024-09-21','SHENZHEN MICIPC TECHNOLOGY CO.,LTD','508,building 8,Hengda fashion Huigu,Fulong Road,Dalang street,Longhua District,Shenzhen','Shenzhen    518000','','','','CN',NULL),(77674,NULL,'MECHATRONICS INNOVATION TECHNOLOGIES, S.L.U.','Paseo de Belen 9A','Valladolid  Valladolid  47011','','','','ES','2024-09-21','MECHATRONICS INNOVATION TECHNOLOGIES, S.L.U.','Paseo de Belen 9A','Valladolid  Valladolid  47011','','','','ES',NULL),(77675,NULL,'Hangzhou Lanly Technology Co., Ltd.','Room A2035-2A, floor 2, building 2, No. 148, Wuchang Avenue, Wuchang Street, Yuhang District, Hangzhou','Hangzhou  Zhejiang  310000','','','','CN','2024-09-24','Hangzhou Lanly Technology Co., Ltd.','Room A2035-2A, floor 2, building 2, No. 148, Wuchang Avenue, Wuchang Street, Yuhang District, Hangzhou','Hangzhou  Zhejiang  310000','','','','CN',NULL),(77676,NULL,'TERAHOP PTE.LTD.','25 INTERNATIONAL BUSINESS PARK #02-72/75 GERMAN CENTRE SINGAPORE (609916)','Singapore    609916','','','','SG','2024-09-24','TERAHOP PTE.LTD.','25 INTERNATIONAL BUSINESS PARK #02-72/75 GERMAN CENTRE SINGAPORE (609916)','Singapore    609916','','','','SG',NULL),(77677,NULL,'Shenzhen Xunman Technology Co., Ltd','3/F., #Building B, tongfu Rd., qiaotou community, Fuhai St., Baoan Dist., ','Shenzhen    518000','','','','CN','2024-09-24','Shenzhen Xunman Technology Co., Ltd','3/F., #Building B, tongfu Rd., qiaotou community, Fuhai St., Baoan Dist., ','Shenzhen    518000','','','','CN',NULL),(77678,NULL,'Universal Global Scientific Industrial., Ltd','141, Lane 351, Taiping Road, Sec.1, Tsao Tuen','Nan-Tou  Taiwan  54261','','','','TW','2024-09-25','Universal Global Scientific Industrial., Ltd','141, Lane 351, Taiping Road, Sec.1, Tsao Tuen','Nan-Tou  Taiwan  54261','','','','TW',NULL),(77679,NULL,'FLIPPER DEVICES INC','2803 Philadelphia Pike Suite B #551','Claymont    19703','','','','US','2024-09-26','FLIPPER DEVICES INC','2803 Philadelphia Pike Suite B #551','','','','','Claymont    19703',NULL),(77680,NULL,'LS Mecapion','12-9, Hosandong-ro, Dalseo-gu, Deagu, Korea 42714','Deagu  Select State  KS002','','','','KR','2024-09-26','LS Mecapion','12-9, Hosandong-ro, Dalseo-gu, Deagu, Korea 42714','Deagu  Select State  KS002','','','','KR',NULL),(77681,NULL,'Vention','4767 Dagenais, Suite 201B','Montreal  Quebec  H4C 1L8','','','','CA','2024-09-27','Vention','4767 Dagenais, Suite 201B','Montreal  Quebec  H4C 1L8','','','','CA',NULL),(77682,NULL,'Hughes Network Systems, LLC','11717 Exploration Lane','Germantown  MD  20876','','','','US','2024-09-27','Hughes Network Systems, LLC','11717 Exploration Lane','Germantown  MD  20876','','','','US',NULL),(77683,NULL,'GooWi Wireless Technology Co., Limited','RM1601 East CreativeTech Plaza II, Tianan Digital Tech, Futian District ','Shenzhen  Guangdong  518000','','','','CN','2024-09-27','GooWi Wireless Technology Co., Limited','RM1601 East CreativeTech Plaza II, Tianan Digital Tech, Futian District ','Shenzhen  Guangdong  518000','','','','CN',NULL),(77684,NULL,'Huizhou Desay SV Automotive Co., Ltd.','No.103, Hechang 5th Road West, Zhongkai National Hi-tech Industrial Development Zone','Huizhou  Guangdong  516006','','','','CN','2024-09-27','Huizhou Desay SV Automotive Co., Ltd.','No.103, Hechang 5th Road West, Zhongkai National Hi-tech Industrial Development Zone','Huizhou  Guangdong  516006','','','','CN',NULL),(77685,NULL,'SHENZHEN WENXUN TECHNOLOGY CO.,LTD','JUNLINTIANXIA A-3705, XINSHA ROAD, FUTIAN DISTRICT','SHENZHEN     518048','','','','CN','2024-09-28','SHENZHEN WENXUN TECHNOLOGY CO.,LTD','JUNLINTIANXIA A-3705, XINSHA ROAD, FUTIAN DISTRICT','SHENZHEN     518048','','','','CN',NULL),(77686,NULL,'OPTOWL Co.,Ltd','16-1 Shinei-cho, Tsuzuki-ku','Yokohama  Kanagawa  2240035','','','','JP','2024-09-28','OPTOWL Co.,Ltd','16-1 Shinei-cho, Tsuzuki-ku','Yokohama  Kanagawa  2240035','','','','JP',NULL),(77687,NULL,'Senbiosys SA','rue de la Pierre-à-Mazel 39, c/o Microcity','Neuchâtel    2000','','','','CH','2024-10-01','Senbiosys SA','rue de la Pierre-à-Mazel 39, c/o Microcity','Neuchâtel    2000','','','','CH',NULL),(77688,NULL,'ikeja wireless (pty) ltd','218 Roan Crescent, Corporate Park North','Midrand  Gauteng  1685','','','','ZA','2024-10-01','ikeja wireless (pty) ltd','218 Roan Crescent, Corporate Park North','Midrand  Gauteng  1685','','','','ZA',NULL),(77689,NULL,'China Post Communication Equipment Co.,','Building 9, No. 11, Lane 450, Zhenda Roa','Shanghai    200436','','','','CN','2024-10-01','China Post Communication Equipment Co.,','Building 9, No. 11, Lane 450, Zhenda Roa','Shanghai    200436','','','','CN',NULL),(77690,NULL,'tonies GmbH','Oststraße 119','Düsseldorf  NRW  40210','','','','DE','2024-10-03','tonies GmbH','Oststraße 119','Düsseldorf  NRW  40210','','','','DE',NULL),(77691,NULL,'LeoLabs','Jankowicka 51','Rybnik    44-218','','','','PL','2024-10-09','LeoLabs','Jankowicka 51','Rybnik    44-218','','','','PL',NULL),(77692,NULL,' Jlztlink Industry(ShenZhen)Co.,Ltd. ','D-502#,Tongan logistics center,Sanwei hangkong 30#,Xiang street,Baoan,Shenzhen,Guangdong,China','Shenzhen  Guangdong  518102','','','','CN','2024-10-11',' Jlztlink Industry(ShenZhen)Co.,Ltd. ','D-502#,Tongan logistics center,Sanwei hangkong 30#,Xiang street,Baoan,Shenzhen,Guangdong,China','Shenzhen  Guangdong  518102','','','','CN',NULL),(77693,NULL,'CompuSoft A/S','Sunekær 9','Søndersø    5471','','','','DK','2024-10-11','CompuSoft A/S','Sunekær 9','Søndersø    5471','','','','DK',NULL),(77694,NULL,'Beijing China Electronics Intelligent Acoustics Technology Co.,Ltd','No.7B, Jiuxianqiao North Road, Chaoyang District, Beijing','Beijing  Beijing  100010','','','','CN','2024-10-11','Beijing China Electronics Intelligent Acoustics Technology Co.,Ltd','No.7B, Jiuxianqiao North Road, Chaoyang District, Beijing','Beijing  Beijing  100010','','','','CN',NULL),(77695,NULL,'Guizhou Huaxin Information Technology Co.,Ltd','Building 7#, Electronic Information Industry Park of Machang Town, Guian New Area, Guizhou Province.','Gui\'an New Area  Guizhou Province  550025','','','','CN','2024-10-15','Guizhou Huaxin Information Technology Co.,Ltd','Building 7#, Electronic Information Industry Park of Machang Town, Guian New Area, Guizhou Province.','','','','','Gui\'an New Area  Guizhou Province  550025',NULL),(77696,NULL,'Third Reality, Inc','4680 Batten Way','San Jose  CA  95135','','','','US','2024-10-16','Third Reality, Inc','4680 Batten Way','San Jose  CA  95135','','','','US',NULL),(77697,NULL,'DX ANTENNA CO.,LTD.','2F KUDAN FIRST PLACE4-1-28,KUDANKITA','CHIYODA-KU  TOKYO  102-0073','','','','JP','2024-10-17','DX ANTENNA CO.,LTD.','2F KUDAN FIRST PLACE4-1-28,KUDANKITA','CHIYODA-KU  TOKYO  102-0073','','','','JP',NULL),(77698,NULL,'IGEN Tech Co., Ltd.','Building H4, China IoT International Innovation Park, No. 6, Jingxian Road, Wuxi, Jiangsu, P. R. China','Wuxi  Jiangsu  214000','','','','CN','2024-10-17','IGEN Tech Co., Ltd.','Building H4, China IoT International Innovation Park, No. 6, Jingxian Road, Wuxi, Jiangsu, P. R. China','Wuxi  Jiangsu  214000','','','','CN',NULL),(77699,NULL,'Genbyte Technology Inc.','Building 4, 1st to 6th Floor, Huahongxintong Industrial Park, Intersection of Genyu Road and Nanming Road, Yutang Street, Guangm','Shenzhen  Guangdong  518107','','','','CN','2024-10-17','Genbyte Technology Inc.','Building 4, 1st to 6th Floor, Huahongxintong Industrial Park, Intersection of Genyu Road and Nanming Road, Yutang Street, Guangm','Shenzhen  Guangdong  518107','','','','CN',NULL),(77700,NULL,'Guangzhou Gizwits loT Technology Co.,Ltd','8F, Zhong Chuang Space, No.5, Tao Zhuang Road, Tian He District, Guangzhou,','Guangzhou    510630','','','','CN','2024-10-17','Guangzhou Gizwits loT Technology Co.,Ltd','8F, Zhong Chuang Space, No.5, Tao Zhuang Road, Tian He District, Guangzhou,','Guangzhou    510630','','','','CN',NULL),(77701,NULL,'Chipsea Technologies (Shenzhen) Corp.','3 / F, Block A, Building 2, Shenzhen Bay Innovation Technology Center, No.3156 keyuan South Road, Yuehai Street, Nanshan Distric','Shenzhen  Guangdong  518000','','','','CN','2024-10-17','Chipsea Technologies (Shenzhen) Corp.','3 / F, Block A, Building 2, Shenzhen Bay Innovation Technology Center, No.3156 keyuan South Road, Yuehai Street, Nanshan Distric','Shenzhen  Guangdong  518000','','','','CN',NULL),(77702,NULL,'UNEEVIU TECHNOLOGIES INDIA PRIVATE LIMITED','Sadguru Villa PL 123/128, Gorai Rd, Borivali West','Mumbai  Maharashtra  400091','','','','IN','2024-10-18','UNEEVIU TECHNOLOGIES INDIA PRIVATE LIMITED','Sadguru Villa PL 123/128, Gorai Rd, Borivali West','Mumbai  Maharashtra  400091','','','','IN',NULL),(77703,NULL,'Shenzhen Taichi Technology Limited','A1710, Nanshan Cloud Technology Building, Vanke Cloud City, Liuxin Third Street, Xili Community, Xili Street, Nanshan District, ','Shenzhen  Guangdong Province  518000','','','','CN','2024-10-18','Shenzhen Taichi Technology Limited','A1710, Nanshan Cloud Technology Building, Vanke Cloud City, Liuxin Third Street, Xili Community, Xili Street, Nanshan District, ','Shenzhen  Guangdong Province  518000','','','','CN',NULL),(77704,NULL,'EYESON SOLUTION CO.,Ltd','803, Woolim E Biz Center 1. 28, Digital-ro 33-gil','Guro-gu  Seoul  08377','','','','KR','2024-10-18','EYESON SOLUTION CO.,Ltd','803, Woolim E Biz Center 1. 28, Digital-ro 33-gil','Guro-gu  Seoul  08377','','','','KR',NULL),(77705,NULL,'SHENZHEN PINSU ZHILIAN INFORMATION TECHNOLOGY CO.,LTD.','32nd Floor, Building B, Shenzhen International Innovation Center, 1006 Shennan Avenue, Futian District','Shenzhen  Guangdong  518038','','','','CN','2024-10-19','SHENZHEN PINSU ZHILIAN INFORMATION TECHNOLOGY CO.,LTD.','32nd Floor, Building B, Shenzhen International Innovation Center, 1006 Shennan Avenue, Futian District','Shenzhen  Guangdong  518038','','','','CN',NULL),(77706,NULL,'Tozed Kangwei Tech Co.,Ltd','Room 1301, NO. 37 Jinlong , Nansha Street, Xiangjiang Financial Business Center, Nansha District','GuangZhou    511466','','','','CN','2024-10-19','Tozed Kangwei Tech Co.,Ltd','Room 1301, NO. 37 Jinlong , Nansha Street, Xiangjiang Financial Business Center, Nansha District','GuangZhou    511466','','','','CN',NULL),(77707,NULL,'Qingdao Goertek  Horizons Tecnology  Co.,LTD','155 Zhuzhou,road','Qingdao  Shandong  266101','','','','CN','2024-10-19','Qingdao Goertek  Horizons Tecnology  Co.,LTD','155 Zhuzhou,road','Qingdao  Shandong  266101','','','','CN',NULL);
/*!40000 ALTER TABLE `tb_company` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_device`
--

DROP TABLE IF EXISTS `tb_device`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_device` (
  `dev_id` mediumint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for each device class entry, primary key',
  `devname` varchar(128) NOT NULL COMMENT 'Device Class/Device Name',
  `notes` mediumtext COMMENT 'Any notes about this device entry (i.e. similarity to other devices, possible sub-classes, etc)',
  PRIMARY KEY (`dev_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_device`
--

LOCK TABLES `tb_device` WRITE;
/*!40000 ALTER TABLE `tb_device` DISABLE KEYS */;
INSERT INTO `tb_device` VALUES (1,'Smartphone','Smartphones are cellphones paired with additional computing hardware into a single unit. Early smartphones were essentially PDAs with a cellphone built-in. Modern smartphones are complete computing systems running full-blown operating systems. Smartphones often include Bluetooth and Wifi capability along with their cellular network ability.'),(2,'Videogame System','Videogame systems are consumer electronics used to play video games, including handheld systems. Many 21st century video game consoles come with built-in networking ability, both wired Ethernet and WiFi. The Nintendo DS has built-in bluetooth.'),(3,'Digital Video Recorder','DVRs are consumer electronics used to record television programming. All recording is done through digitization and storage is on hard drives. DVRs offer many advanced features, and may include wired and wireless network abilities.'),(4,'Network Interface Card','A Network Interface Card (NIC) is a peripheral that provides network capability to a computing device.'),(5,'Router','A router is a networking device that connects numerous networks together and routes traffic between them. This may include networks of different speeds, physical linkage and protocl (i.e. Ethernet and ATM).'),(6,'Switch','A network switch moves network traffic from multiple systems across a single segment. While switches are \"smart\" devices, they typically do not perform routing.'),(7,'Firewall','A firewall acts as a filtering device, stopping some network traffic based on a set of rules. Firewalls can limit traffic based on IP address, MAC address, TCP ports and in some cases actual traffic content.'),(8,'Wireless Access Point','Wireless Access Points (WAP) provide connectivity to 802.11 wireless clients. A WAP typically has a wired connection to a network as well as the wireless connectivity.'),(9,'Cellular Phone','Cellular phones provide telephone service through microwaves to and from cellular towers. While the cellular access can be used to perform Internet access, there are no MACs associated with Cellular access. However, cellphones frequently have Bluetooth functionality built-in.'),(10,'Wireless NIC','A Wireless Network Interface Card (NIC) may not be an actual expansion card. Many computing and electronic devices have WiFi capability built-in to them.'),(11,'Human Interface Device','A Human Interface Device (HID) is any computing peripheral that acts as an input and/or output interface between a computer and a human being. Typically, HIDs are keyboards, mice, trackballs, microphones and speakers.'),(12,'Physical Access Device','Any device used to control and/or monitor physical access, including electronic badge readers, motion sensors, CCTV cameras and so-on.'),(13,'Camera','Network-attached camera devices used for both still and video imaging. May include security cameras, video conferencing, scientific and other functions.'),(14,'Virtual Computer','A virtual computer is created by software running on a physical piece of computing hardware. Typically used to allow different operating systems to be run simultaneously, and to make more efficient use of pooled hardware resources. Not to be confused with emulation.'),(15,'KVM / Console','Keyboard-Video-Mouse devices as well as serial console devices allow multiple computing systems to be accessed through a single point. Network-attached KVM and console devices allow remote management of hardware that has no native remote access ability.'),(16,'Video Conferencing Device','A network-attached device capable of transmitting and receiving both audio and video. Used to provide remote conferencing between people in separate physical locations. Typically use H.263 or similar encoding schemas, often found on ISDN lines.'),(17,'SCADA Device','Supervisory Control And Data Acquisition (SCADA) systems provide automated access and management of real-world systems such as power, lighting, HVAC, natural gas, oil and others. These systems are not traditionally on IP networks. A SCADA network device should be considered exceptionally sensitive and fragile!'),(18,'Network Access Device','A network access device may be a router, switch, hub, firewall or combination of any of them. The purpose of any network access device is to provide network connectivity between computing systems and other network devices. This includes not only the physical network, but associated network services such as routing protocols, DHCP, and the like.'),(19,'Uninterruptible Power Supply','Commonly refferred to as a UPS, these devices are used to provide battery back-up power to equipment in the case of main power loss. UPS devices typically also provide power conditioning and surse suppression.');
/*!40000 ALTER TABLE `tb_device` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_media`
--

DROP TABLE IF EXISTS `tb_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_media` (
  `media_id` mediumint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for each media type entry. These values are to be referenced in a bitmask from the tb_OUI table, to support multiple media type entries for each OUI',
  `medianame` varchar(128) NOT NULL COMMENT 'Name of media type',
  `notes` mediumtext COMMENT 'Any notes about this media type (i.e. aliases, URLs, etc)',
  PRIMARY KEY (`media_id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_media`
--

LOCK TABLES `tb_media` WRITE;
/*!40000 ALTER TABLE `tb_media` DISABLE KEYS */;
INSERT INTO `tb_media` VALUES (1,'Ethernet','All wired implementations of Ethernet, including coaxial and twisted-pair. All speeds.'),(2,'Bluetooth','Short-range wireless connection standard, usable for serial-like communication. Common in cellphones and laptops.'),(4,'WiFi','WiFi, short for Wireless Fidelity, or better known to engineers as the 802.11 family of IEEE standards. Provides full network connectivity with no cables. Common in laptops, smartphones, modern video game consoles and a growing range of consumer goods.'),(6,'Bluetooth, WiFi','Bluetooth is a short-range wireless connection standard, usable for serial-like communication. Common in cellphones and laptops.\r\n\r\nWiFi, short for Wireless Fidelity, or better known to engineers as the 802.11 family of IEEE standards. Provides full network connectivity with no cables. Common in laptops, smartphones, modern video game consoles and a growing range of consumer goods.'),(8,'Token Ring','An alternative to Ethernet, established by IBM. Rarely used nowadays due to various technical limitations.'),(16,'FDDI','Fiber Distributed Data Interfaces (FDDI) provide long-range (124 miles) data transfers using optical signaling. '),(32,'ATM','Asynchronous Transfer Mode (ATM) is a wired network protocol. It\'s most common in telecom networks and for special uses such as video conferencing.'),(64,'ITU-T G.hn','ITU-T G.hn is a generic name for the family of networking protocols being developed for home networking purposes, including data networks over power lines, phone lines and coaxial cables.'),(128,'Virtual','Virtual network inerfaces appear in virtualized computer systems, usually mapping to physical network hardware. Found primarily in virtual computing systems such as VMWare.');
/*!40000 ALTER TABLE `tb_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_model`
--

DROP TABLE IF EXISTS `tb_model`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_model` (
  `model_id` mediumint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID for each device model entry, primary key',
  `dev_id` mediumint unsigned DEFAULT NULL COMMENT 'ID of device class this model entry is associated with (i.e. "Blackberry" is a model of "Smartphone" devices)',
  `modelname` varchar(128) NOT NULL COMMENT 'Name of the device model',
  `notes` tinytext COMMENT 'Any notes about this device model (i.e. model number, reference URL, aliases, etc)',
  PRIMARY KEY (`model_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_model`
--

LOCK TABLES `tb_model` WRITE;
/*!40000 ALTER TABLE `tb_model` DISABLE KEYS */;
INSERT INTO `tb_model` VALUES (1,14,'VMWare','VMWare is one of the older virtual machine software companies. Their products include VMWare Workstation, VMWare Server and VMWare vSphere.'),(2,14,'Virtual PC','The Virtual PC brand is owned by Microsoft, and includes server and workstation solutions. Microsoft bought Connectix Corp in 2003 to obtain it\'\'s virtual machine technology, which was re-branded as Virtual PC.'),(3,14,'Parallells','Parallels, Inc. products include workstation and server solutions with support for Windows, Linux and MacOS host platforms. Parallels offers virtualization on pure Mac hardware.'),(4,14,'Virtual Iron','Virtual Iron is based on the Open Source Xen virtualization technology, with a focus on server solutions. In May of 2009, the Virtual Iron corporation was bought by Oracle.'),(5,14,'Xen','Xen is a virtual computing technology originally developed out of the University of Cambridge. It is an Open Source technology, with multiple commercial implementations by RedHat, Oracle, Citrix and Novell.'),(6,14,'VirtualBox','VirtualBox is an Open Source virtualization product developed by Sun. It runs on Windows, Mac and Linux host platforms, and provides both workstation and server solutions.'),(7,1,'iPhone','The iPhone, developed by Apple, Inc., is perhaps the most ubiquitous smartphone as of 2009. It offers integrated cellular and WiFi network access as well as GPS and BlueTooth capacity.'),(8,1,'Treo','Originally developed by Handspring, the Treo brand Smartphones became a Palm product when Palm merged with Handspring in 2003. While Handspring was an earlier pioneer of Smartphones, they have lagged behind others in terms of features such as integrated W'),(9,1,'Blackberry','The Blackberry smartphone was developed by Research In Motion, commonly known as RIM. Blackberry smartphones initially were aimed at businesses but have become more common as a consumer smartphone.'),(10,15,'Raritan','Raritan is a company which exclusively makes KVM, Console and other datacenter management equipment.'),(11,2,'Datel Accessory','Datel manufactures various accessories for videogame systems, inlcuding USB network adaptors and BlueTooth headsets and keyboards');
/*!40000 ALTER TABLE `tb_model` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-10-22  0:01:41
