Fairchild Cebu Community Multi-Purpose Cooperative db & user's accounts

rolik · 14.07.2024

hello everyone
today i'm selling db of fairchildcoop.org

8979 Client

SQL:

Table structure for table `member_record`
`m_id` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `m_client_id` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_type` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `f_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `l_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_no` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_email` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_gender` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_bdate` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_civStat` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_nationality` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_homeTown` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_currentAddr` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_occupation` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_tin` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_membershp_date` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_soa_nofnot` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_soa_coltr` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_votingStat` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_rec_id` int NOT NULL,
  `department` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `m_status` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

those same 11 sample of the db

SQL:

('002195C', '1089', 'Associate Member', 'John Reymart  Booc', NULL, 'Reyes', '09453950620', 'martreyes014@gmail.com', 'Male', '1997-06-14', 'Single', 'FILIPINO', 'B2 LOT 8 ANNEX 3 VILLA DEL RIO BABAG 2', '', '', '', '2024-03-04', '', '', NULL, 78, '1', 'Active'),
('002206', '1093', 'Associate Member', 'Gerardo M.', NULL, 'Helmet', '09165637041', '', 'Male', '1967-05-18', 'Married', ' PHILIPPINES', 'POBLACION, CORDOVA, CEBU', '', 'TECHNICIAN', '', '1996-08-02', '', '', NULL, 79, '1', 'Active'),
('002220', '1102', 'Regular Member', 'Jose  Borromeo', NULL, 'Nolasco', '09157264994', 'joey.b.nolasco.ocmi@gmail.com', 'Male', '1950-12-19', 'Married', 'FILIPINO', '#11 SUN VALLERY DR.', '', 'FINANCE', '108-391-410', '1994-05-15', '', '', NULL, 80, '1', 'Active'),
('002222', '1103', 'Associate Member', 'Richard  Getaruelas', NULL, 'Benolirao', '639424396366', 'christianbenolirao98@gmail.com', 'Male', '1980-02-28', 'Married', 'FILIPINO', 'MACTAN', 'ALCOY', 'UTILITY', '308 182 384', '2018-11-29', '', '', NULL, 81, '1', 'Active'),
('002566', '1332', 'Regular Member', 'Elmer  Gudilos', NULL, 'Butihen', '09310164297', 'elmergudilosbutihen@gmail.com', 'Male', '1969-07-15', 'Married', 'FILIPINO', 'TIMPOLOK, BABAG I LAPU-LAPU CITY, CEBU', '', 'TECHNICIAN', '108328484', '1989-11-17', '', '', NULL, 82, '1', 'Active'),
('002571', '1338', 'Regular Member', 'Eric  S.', NULL, 'Benolirao', '639165699008', 'ebenolirao@yahoo.com', 'Male', '1966-11-21', 'Married', 'FILIPINO', 'PUNTOD ALASKA MAMBALING CEBU PHLIS.', '', 'MAINTENANCE ENGR.', '108 381 492', '1989-08-09', '', '', NULL, 83, '1', 'Active'),
('002584', '1346', 'Associate Member', ' FABIOLO', NULL, 'BENIGNO', '', '', 'Male', '1989-06-15', 'Married', 'FILIPINO', '', '', '', '', '1989-06-15', '', '', NULL, 84, '1', 'Active'),
('002686', '1409', 'Associate Member', 'Joselito  Geonzon', NULL, 'Castañares', '09329113744', 'joselitocastanares5362@gmail.com', 'Male', '1962-05-03', 'Married', 'FILIPINO', 'PUSOK LAWIS', '', 'MANAGER', '108 383 644', '2021-11-29', '', '', NULL, 85, '1', 'Active'),
('002787', '1489', 'Associate Member', 'Raul  Bulao', NULL, 'Barrera', '09322936581', 'raulzski@yahoo.com', 'Male', '1967-04-17', 'Married', 'FILIPINO', 'ANNEX 1 BLK 1 LOT 2 BROOKFIELD SUBD., SUDTUNGAN ROAD', '', '', '', '2018-01-03', '', '', NULL, 86, '1', 'Active'),
('002820A', '1518', 'Associate Member', 'ANGELO COLITA', NULL, 'BANZUELA', '', '', 'Male', '2001-02-15', 'Single', 'FILIPINO' , 'BLK 4 L 6 RIDGES SUBD., PASEO ARCENAS, BANAWA, CEBU CITY', ', '2024-01-30', ', ', NULL, 87, '1', 'Active')
('002820B', '1519', 'Associate Member', ' ALEXANDER COLITA', NULL, 'BANZUELA', '', '', 'Male', '2002-09-24', 'Single', 'FILIPINO', 'BLK 4 L 6 RIDGES SUBD., PASEO ARCENAS, BANAWA, CEBU CITY', '', '', '', '2024-01-30', '', '', NULL, 88, '1', 'Active'),

i have user:pass of account access too

9497 user access

to view your statement of account and other coop details

sample :

SQL:

INSERT INTO `member_qr_code` (`id`, `m_id`, `m_qr`, `qr_unix`) VALUES
(1, 'ZBQYCM', '6567734179543454', 1715391935),
(2, 'ZBQVCM', '65677341786a3454', 1715391935),
(3, 'ZBQRZF', '6567734177696359', 1715391935),
(4, 'ZBQRPB', '6567734177693063', 1715391935),
(5, 'ZBQQZF', '6567734177536359', 1715391936),
(6, 'ZBQD3F', '6567734131453459', 1715391936),
(7, 'ZBQ78C', '6567734170305564', 1715391936),
(8, 'ZBPVQQ', '6567734278697750', 1715391936),
(9, 'ZBPVPD', '6567734278693061', 1715391936),
(10, 'ZBPNRF', '6567734233693859', 1715391936),
(11, 'ZBPFCX', '65677342316a3447', 1715391936),

u can decrypt the hash here easy : https://hashes.com/en/decrypt/hash

+ in total database size is 3.45 GB (3,712,542,156 bytes) full with loan and statements info ..

Fairchild Cebu Community Multi-Purpose Cooperative db & user's accounts

В этой теме можно использовать автоматический гарант!

rolik

RAID-массив