The Dhaka\r\nUniversity Graduate Zoologist Association (DUGZA) is a volunteer-led\r\norganization that is intended to provide devoted service to all graduate\r\nzoologist scattered in the different parts of the country as well as all over\r\nthe world. Its notion is to provide\r\nexclusive supports to all graduate zoologists and whole-hearted services to,\r\nthe Department of Zoology,
However, we can\r\naccomplish this goal with your support and involvement. The strength of DUGZA\r\nlies in the combined efforts of all Zoology Graduates. Our desire is to remain\r\nin constant touch with all of the DUGZA members.
Contact with the\r\nold cohorts’ (graduates) is important to the faculty and current students\r\nbecause of the feedback on the educational system, research, and the link with\r\nthe practical world including settling down in a particular project or job.\r\nFrom the alumni\'s point of view, continued contact with the faculty is\r\nimportant because of the opportunities for further professional and personal\r\ndevelopment, and contact with teachers and students.
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
DUGZA believes\r\nin life-long relationship between all the graduates by uniting their support\r\nand fostering their contributions and participation in various governances for\r\nthe benefits and needs of the graduates.
', '2025-11-17 04:12:10', '2025-11-17 04:12:10'); -- -------------------------------------------------------- -- -- Table structure for table `academic_informations` -- CREATE TABLE `academic_informations` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `admission_session` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `specialization` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `hall` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `university_reg` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `graduation_year` year(4) NOT NULL, `university_certificate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `academic_informations` -- INSERT INTO `academic_informations` (`id`, `user_id`, `admission_session`, `batch`, `specialization`, `hall`, `university_reg`, `graduation_year`, `university_certificate`, `created_at`, `updated_at`) VALUES (1, 2, '1996-97', '42nd', 'Parasitology', 'Dr. Muhammad Shahidullah Hall', 'Ha-98765', '2003', NULL, '2025-10-18 09:35:52', '2025-10-19 09:27:14'), (3, 3, '1992-93', '38th', 'Genetics & Molecular Biology', 'Jagannath Hall', 'HA 4170', '1996', 'uploads/PersonalPhoto/UMSM71760874074.jpg', '2025-10-19 12:11:14', '2025-10-19 12:11:14'), (4, 5, '1994-95', '40th', 'Fisheries', 'Dr. Muhammad Shahidullah Hall', 'SH-3310', '1998', NULL, '2025-10-22 06:16:31', '2025-10-22 06:16:31'), (5, 6, '1996-97', '42nd', 'Parasitology', 'Fazlul Huq Muslim Hall', '12345', '2003', NULL, '2025-10-28 14:47:31', '2025-10-28 14:47:31'), (6, 8, '1993-94', '39th', 'Fisheries', 'Dr. Muhammad Shahidullah Hall', 'Ha 3701', '1999', NULL, '2025-11-10 11:43:58', '2025-11-10 11:43:58'), (7, 9, '2000-01', '46th', 'Wildlife Biology', 'Fazlul Huq Muslim Hall', 'হ-৪৫৫৪', '2004', 'uploads/PersonalPhoto/4BFOP1762860751.jpg', '2025-11-11 12:02:31', '2025-11-11 12:02:31'), (8, 7, '1996-97', '42nd', 'Parasitology', 'Dr. Muhammad Shahidullah Hall', 'Ha 528', '2000', NULL, '2025-11-12 12:38:00', '2025-11-12 12:38:00'), (9, 32, '2005-06', '51st', 'Wildlife Biology', 'Jagannath Hall', 'H-4321', '2010', NULL, '2026-05-03 05:35:20', '2026-05-03 05:35:20'), (10, 40, '1998-99', '44th', 'Genetics & Molecular Biology', 'Fazlul Huq Muslim Hall', 'Ha-2424', '2003', NULL, '2026-06-09 12:35:40', '2026-06-09 12:35:40'); -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `aims_objectives` -- CREATE TABLE `aims_objectives` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `aims_objectives` -- INSERT INTO `aims_objectives` (`id`, `title`, `description`, `type`, `created_at`, `updated_at`) VALUES (4, NULL, 'The essence of\r\nthe Association\'s policy is to maintain close contacts between the current\r\ngraduate students and the ‘old cohort’, between DUGZA members and the faculty\r\nof the Department and between members among the old cohorts. Our policy is to\r\ncreate a life-long bond among all DUGZA members.
', 'Mission', '2025-11-17 04:48:17', '2025-11-17 04:48:17'); -- -------------------------------------------------------- -- -- Table structure for table `albums` -- CREATE TABLE `albums` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `albums` -- INSERT INTO `albums` (`id`, `title`, `cover_image`, `created_at`, `updated_at`) VALUES (2, 'Ifter -2025', 'uploads/albums/1763340381_MYn2u.jpg', '2025-11-17 01:16:21', '2025-11-25 10:47:27'); -- -------------------------------------------------------- -- -- Table structure for table `album_images` -- CREATE TABLE `album_images` ( `id` bigint(20) UNSIGNED NOT NULL, `album_id` bigint(20) UNSIGNED NOT NULL, `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `album_images` -- INSERT INTO `album_images` (`id`, `album_id`, `image_path`, `created_at`, `updated_at`) VALUES (12, 2, 'uploads/albums/1763340381_iJPnY.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (13, 2, 'uploads/albums/1763340381_WwkNE.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (14, 2, 'uploads/albums/1763340381_d7ZMQ.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (15, 2, 'uploads/albums/1763340381_VFN1L.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (16, 2, 'uploads/albums/1763340381_oa7bT.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (17, 2, 'uploads/albums/1763340381_N4uFU.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (18, 2, 'uploads/albums/1763340381_HuIcW.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (19, 2, 'uploads/albums/1763340381_lBWp1.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (20, 2, 'uploads/albums/1763340381_eoteh.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (21, 2, 'uploads/albums/1763340381_ptaiV.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'), (22, 2, 'uploads/albums/1763340381_Ni0dk.jpg', '2025-11-17 01:16:21', '2025-11-17 01:16:21'); -- -------------------------------------------------------- -- -- Table structure for table `announcements` -- CREATE TABLE `announcements` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `admission_session` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `committees` -- CREATE TABLE `committees` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `constitutions` -- CREATE TABLE `constitutions` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `constitutions` -- INSERT INTO `constitutions` (`id`, `title`, `description`, `created_at`, `updated_at`) VALUES (1, 'Dhaka University Graduate Zoologists Association (DUGZA)', 'We, the graduates, faculty and\r\ncurrent students of the Department of Zoology, University of Dhaka, recognizing\r\nthe vital role of zoological science in conserving biodiversity, promoting\r\nsustainable development, and protecting public and ecosystem health, establish\r\nthis Constitution to found the Dhaka University Graduate Zoologists Association\r\n(DUGZA). Acting in the spirit of unity, service, and stewardship, DUGZA shall\r\nfoster professional excellence, nurture leadership among students, support\r\nconservation and One Health initiatives, and advance the welfare of its members\r\nand the wider community.
Article I — Name, Address & Legal Status
1.1 Name: The name of the\r\nAssociation shall be Dhaka University Graduate Zoologists Association (DUGZA).
1.2 Registered Office: The\r\nregistered office of DUGZA shall be located at the Department of Zoology,\r\nUniversity of Dhaka, or such other address as determined by the Executive\r\nCommittee.
1.3 Legal Status: DUGZA is an\r\nindependent, non-profit association of graduates, faculty and students. DUGZA\r\nmay register under applicable national laws and shall comply with all legal and\r\ntax obligations.
Article II — Definitions
2.1 “Association” or “DUGZA”\r\nmeans Dhaka University Graduate Zoologists Association.
2.2 “Member” means a person whose\r\nmembership is valid under Article III.
2.3 “Preliminary Member / Student\r\nMember” means a current student of the Department of Zoology.
2.4 “General Assembly (GA)” means\r\nthe supreme body of members as defined in Article V.
2.5 “Executive Committee (EC)”\r\nmeans the elected managing committee as defined in Article VI.
(Other defined terms may be added\r\nas needed.)
Article III — Objectives
The objectives of DUGZA are to:\r\n3.1 Unite graduates, teachers, researchers and students of the Department of\r\nZoology for professional development, networking and fellowship.
3.2 Promote zoological research,\r\ninnovation, and dissemination of scientific knowledge.
3.3 Foster biodiversity\r\nconservation, ecosystem stewardship, and nature-based climate resilience.
3.4 Advance One Health principles\r\nconnecting human, animal, and environmental health.
3.5 Support student leadership,\r\nmentorship, internships and career development.
3.6 Organize community outreach,\r\ncitizen science, disaster response, and public awareness programs for inclusive\r\ndevelopment.
3.7 Provide welfare support,\r\nemergency assistance and promote peace and prosperity among members.
3.8 Build partnerships with\r\nacademic, governmental, non-governmental and international organizations to\r\nachieve the above objectives.
Article IV — Membership
4.1 Membership Categories:
a) Life Member — Graduates who\r\npay the life membership fee.
b) General Member — Alumni who\r\npay annual membership fees.
c) Preliminary / Student Member —\r\nCurrent students of the Department (nominal or no fee).
d) Honorary Member — Individuals\r\nof exceptional contribution, nominated and approved by EC/GA.
e) Institutional / Partner Member\r\n— Organizations allied with DUGZA’s objectives.
4.2 Eligibility: Graduates of the\r\nDepartment of Zoology are eligible for Life or General membership. Current\r\nstudents are eligible for Preliminary membership. Honorary and institutional\r\nmembership as defined above.
4.3 Enrollment: Applicants shall\r\ncomplete the official registration form and provide required documents. The\r\nSecretariat shall maintain the Member Registry.
4.4 Rights:
a) Life and General Members have\r\nvoting rights at GA (subject to registration and any dues requirements).
b) Preliminary / Student Members\r\nmay participate fully in events and committees but have limited voting rights\r\nas defined in bylaws.
c) Honorary and Institutional\r\nMembers have privileges as specified on admission.
4.5 Duties and Conduct: Members\r\nshall uphold DUGZA’s values, abide by this Constitution, respect the Code of\r\nConduct, and promptly pay fees where applicable.
4.6 Suspension/Termination:\r\nMembership may be suspended or terminated for misconduct or breach of rules\r\nfollowing a fair process as defined in the bylaws.
Article V — General Assembly (GA)
5.1 Composition and Authority:\r\nThe GA comprises all registered members and is the supreme decision-making body\r\nof DUGZA.
5.2 Annual General Meeting (AGM):
a) DUGZA shall hold an AGM at\r\nleast once per calendar year to approve reports, accounts, budgets, elect EC,\r\nand transact other business.
b) Notice: Members shall receive\r\nat least 30 days’ written notice of the AGM with agenda.
c) Quorum: The quorum for AGM\r\nshall be [specify percentage or number — e.g., 20% of registered voting\r\nmembers] unless otherwise specified.
d) Voting: Decisions shall be by\r\nsimple majority unless this Constitution requires a special majority.
5.3 Extraordinary General Meeting\r\n(EGM): An EGM may be convened by the EC, or upon written request of [specify\r\nnumber/percentage] members, to address urgent matters.
Article VI — Executive Committee (EC): Composition, Election &\r\nTenure
6.1 Composition: The EC shall be\r\nelected by the GA and shall consist of the following offices (or such offices\r\nas GA may decide):
President
Vice-Presidents
General Secretary
Joint Secretary
Treasurer
Organizing Secretary
Public Relations &\r\nCommunications Secretary
Academic & Research Secretary
Environment, Climate & One\r\nHealth Secretary
Student & Youth Affairs\r\nSecretary
Cultural & Welfare Secretary
Up to 10–15 General Members\r\nrepresenting batches, regions and professional sectors
6.2 Election & Tenure:
a) The EC shall be elected every\r\ntwo years by the GA.
b) Election procedure shall be\r\nprescribed by an Election Committee and by bylaws.
c) EC members may serve a maximum\r\nof [specify consecutive terms] unless waived by GA.
6.3 Vacancies: Vacancies may be\r\nfilled by EC appointment until the next GA as per bylaws.
6.4 Removal: An EC member may be\r\nremoved for cause following due process, including a fair hearing and vote by\r\nGA/EC as defined in bylaws.
Article VII — Powers and Duties of EC and Office Bearers
7.1 The EC shall implement GA decisions,\r\nmanage affairs, prepare budgets and annual reports, and oversee programs.
7.2 Specific duties (examples):
President: Provide leadership,\r\nrepresent DUGZA, preside over GA and EC.
Vice-President(s): Support\r\nPresident and oversee portfolios.
General Secretary: Administrative\r\nhead, maintain records, coordinate meetings and communication.
Joint Secretary: Assist General\r\nSecretary; student engagement liaison.
Treasurer: Financial management,\r\nbookkeeping, prepare accounts and budgets.
Other Secretaries/Coordinators:\r\nManage assigned portfolios (events, research, outreach, welfare,\r\ncommunications).
7.3 Committees: EC shall\r\nestablish Standing Committees (Academic & Research; Biodiversity &\r\nConservation; Climate & One Health; Student Affairs; Welfare; Finance &\r\nAudit; Communication & IT) and ad hoc committees as required. Committee\r\ncoordinators report to EC.
Article VIII — Secretariat, Records and Membership Registry
8.1 Secretariat: A Secretariat\r\nshall be maintained to support administration and program delivery, supervised\r\nby the General Secretary.
8.2 Records: DUGZA shall maintain\r\nrecords of members, minutes, financial statements and program reports. Records\r\nshall be stored electronically and in physical form as required.
8.3 Data Protection and Privacy.\r\nDUGZA shall protect members’ personal data and use it only for legitimate\r\nassociation purposes. Members give consent to store and use directory data\r\nduring registration.
Article IX — Finance, Funds and Audit
9.1 Sources of Funds: Membership\r\nfees, donations, grants, event revenue, fundraising and other lawful sources.
9.2 Financial Management:
a) The Treasurer shall maintain\r\naccurate accounts and bank records.
b) No funds shall be disbursed\r\nexcept upon authorization according to financial rules passed by the EC/GA.
9.3 Annual Accounts & Audit:\r\nThe accounts shall be audited annually by an independent auditor, and audited\r\naccounts presented to the AGM.
9.4 Fiscal Year. DUGZA’s\r\nfinancial year shall end on [e.g., 30 June] (or specify).
Article X — Meetings, Quorum & Voting
10.1 EC Meetings: EC shall meet\r\nat least [specify frequency, e.g., quarterly] or as required. Notice shall be\r\ngiven in advance.
10.2 Quorum: Quorum for EC\r\nmeetings shall be [specify number/percentage]. Quorum for committees determined\r\nby bylaws.
10.3 Voting: Decisions generally\r\nby simple majority; tie votes resolved by the Chair’s casting vote, unless\r\notherwise dictated.
10.4 Remote Participation:\r\nMeetings may be held virtually; participation shall be valid for quorum and\r\nvoting if procedures in bylaws are followed.
Article XI — Code of Conduct and Conflict Resolution
11.1 Code of Conduct: Members\r\nshall adhere to DUGZA’s Code of Conduct promoting respect, non-discrimination,\r\nacademic integrity and environmental ethics.
11.2 Grievance & Discipline:\r\nThe EC shall establish procedures for handling complaints, disciplinary action\r\nand appeals, ensuring fair hearings and confidentiality.
Article XII — Amendments to the Constitution
12.1 Proposal: Amendments may be\r\nproposed by the EC or by a petition signed by [specify percentage] of members.
12.2 Adoption: Amendments require\r\n[specify majority — e.g., two-thirds] of votes cast at the AGM or an EGM\r\nconvened for this purpose.
12.3 Notice: Proposed amendments\r\nmust be circulated to members at least [30] days prior to vote.
Article XIII — Dissolution
13.1 Dissolution: DUGZA may be\r\ndissolved by a resolution passed by [specify majority — e.g., two-thirds] of\r\nvoting members at a specially convened GA.
13.2 Disposal of Assets: On\r\ndissolution, assets after settlement of liabilities shall be transferred to an\r\nentity with similar objectives as decided by GA, or as required by law.
Article XIV — Transitional & Miscellaneous Provisions
14.1 Transitional EC: At\r\nformation, an interim EC may be appointed and shall call the first AGM within\r\n[e.g., 12 months].
14.2 Bylaws: GA may adopt bylaws\r\n& operational rules consistent with this Constitution for detailed\r\nprocedures (e.g., election rules, fees schedule, committee charters).
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
14.3 Effective Date: This\r\nConstitution becomes effective on adoption by the founding GA and remains in\r\nforce until amended
', '2025-11-16 13:42:00', '2025-11-16 13:42:00'); -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `conveners` -- CREATE TABLE `conveners` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `session` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `conveners` -- INSERT INTO `conveners` (`id`, `title`, `description`, `name`, `designation`, `session`, `organization`, `address`, `phone`, `fax`, `created_at`, `updated_at`) VALUES (1, NULL, 'Dear Graduates,
Please be\r\ninformed that we are going to be interacted soon with \'Dhaka University\r\nGraduate Zooloigists Association (DUGZA). Some young spirited graduates among\r\nus have started mobilizing activities related to the establishment of such\r\nassociation to our long lasting wish to remain in close touch with each other\r\neven after staying away for different occupational purposes.
We hope that we\r\nwould be able to form a platform on which we can share our joys and sorrows as\r\nwell as we can extend helps to each other and thus grow the seed of association\r\ninto a mature tree. We wish to enjoy lots of funs and amusements beyond normal\r\norganizational promotive activities for the betterment of us. We wish to meet\r\nat regular intervals and maintain regular communication. We wish to glorify the\r\npath of the graduate zoologists of
For your kind\r\ninformation we have already hosted our website at www.dugza.com
We expect a lot\r\nfrom you! Your valuable advice will give us inspiration regarding decorations\r\nand actions of our DUGZA.
Please fill in\r\nthe preliminary application form for enrolling in the association and for\r\nenrichment of our database. We have collected some data from the Department. We\r\nare presently organizing ourselves and we wish to seat with all of you in the\r\nfirst general meeting of the DUGZA, which will be held in a convenient time for\r\nmajority of us.
It is\r\nmentionable that the running graduates in the Department, i.e., MS students are\r\nin the heart of our beloved association.
We are regularly\r\nmeeting on every Friday from
We are also\r\nasking valuable suggestions from you for the slogan of DUGZA for the year 2007.\r\nWe also seek your valuable suggestions regarding development of your website.
Please actively\r\nparticipate yourself for the betterment of our common force and invite all the zoo\r\npals to your reach by circulating our thoughts.
With all the\r\nbest wishes
Cordially yours
Sucharit Basu Neogi
Convener, DUGZA\r\nSteering Committee
(Session\r\n1992-93)
Senior Research\r\nOfficer
Environmental\r\nMicrobiology Laboratory
Laboratory\r\nSciences Division
ICDDR,B: Centre\r\nfor Health and Population Research
Mohakhali,\r\nDhaka-1212
Phone: +88-02-8860523-32,\r\nExt. 2405
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
Fax: +88-02-8812529
', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-17 04:13:31', '2025-11-17 04:13:31'); -- -------------------------------------------------------- -- -- Table structure for table `employment_informations` -- CREATE TABLE `employment_informations` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `occupation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `organization` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `employment_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `job_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `previous_employments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `employment_informations` -- INSERT INTO `employment_informations` (`id`, `user_id`, `occupation`, `organization`, `designation`, `employment_country`, `job_type`, `previous_employments`, `created_at`, `updated_at`) VALUES (1, 2, 'Business', 'Shaptak (IT) Ltd.', 'Managing Director', 'Bangladesh', 'Private', '\"[{\\\"previous_occupation\\\":\\\"Business\\\",\\\"previous_organization\\\":\\\"Best Packing Macinery Co. Ltd.\\\",\\\"previous_designation\\\":\\\"Chairman\\\",\\\"previous_employment_country\\\":\\\"Bangladesh\\\",\\\"previous_job_type\\\":\\\"Private\\\"}]\"', '2025-10-18 09:41:52', '2025-10-18 09:41:52'), (2, 3, 'Senior Researcher', 'Coastal Development Partnership (CDP), Bangladesh', 'Research Advisor', 'Bangladesh', 'NGO', NULL, '2025-10-19 12:12:36', '2025-10-19 12:12:36'), (4, 5, 'SERVICE', 'Dhaka Bank Plc', 'SEVP', 'Bangladesh', 'Private', NULL, '2025-10-22 06:17:09', '2025-10-22 06:17:09'), (5, 6, 'Govt. Service', 'RAJUK', 'Director', 'Bangladesh', 'Government', NULL, '2025-10-28 14:49:38', '2025-10-28 14:49:38'), (6, 7, 'Private Service', 'Filament Engineering Ltd.', 'Assistant General Manager', 'Bangladesh', 'Private', NULL, '2025-10-29 04:47:16', '2025-10-29 04:47:16'), (7, 8, 'Banker', 'Dutch Bangla Bank', 'Vice president', 'Bangladesh', 'Private', NULL, '2025-11-10 11:46:27', '2025-11-10 11:46:27'), (8, 9, 'Service', 'Janata Bank PLC', 'Senior Principal Officer', 'Bangladesh', 'Government', NULL, '2025-11-11 12:04:31', '2025-11-11 12:04:31'), (9, 4, 'Researcher', 'icddr,b', 'Scientist', 'Bangladesh', 'Research', NULL, '2025-11-26 05:42:01', '2025-11-26 05:42:01'), (10, 32, 'Government Service', 'Rajdhani Unnayan kartripakkha', 'Deputy Director', 'Bangladesh', 'Government', NULL, '2026-05-03 05:37:01', '2026-05-03 05:37:01'), (11, 34, 'Scientist', 'Bangladesh Atomic Energy Commission', 'Principal Scientific Officer', 'Bangladesh', 'Government', NULL, '2026-05-07 08:53:23', '2026-05-07 08:53:23'), (12, 40, 'Publication', 'Trinoyon Prokashon', 'Publisher', 'Bangladesh', 'Research', '\"[{\\\"previous_occupation\\\":\\\"Teachership\\\",\\\"previous_organization\\\":\\\"Southern City College\\\",\\\"previous_designation\\\":\\\"Assistant Professor\\\",\\\"previous_employment_country\\\":\\\"Bangladesh\\\",\\\"previous_job_type\\\":\\\"Private\\\"}]\"', '2026-06-09 12:39:19', '2026-06-09 12:39:19'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `venue` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `organizer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time` time DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `title`, `slug`, `image`, `start_date`, `end_date`, `venue`, `organizer`, `time`, `description`, `created_at`, `updated_at`) VALUES (1, '24th International Biennial Conference and AGM 2025', '24th-international-biennial-conference-and-agm-2025-YPQc5', 'event_1777176232.jpg', '2026-07-18', NULL, 'Department of Zoology', 'Zoological Society of Bangladesh', '09:00:00', NULL, '2026-04-25 13:44:53', '2026-04-28 10:35:51'); -- -------------------------------------------------------- -- -- Table structure for table `event_attachments` -- CREATE TABLE `event_attachments` ( `id` bigint(20) UNSIGNED NOT NULL, `event_id` bigint(20) UNSIGNED NOT NULL, `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `extra_informations` -- CREATE TABLE `extra_informations` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `activities` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mentor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expectations` text COLLATE utf8mb4_unicode_ci, `share_details` tinyint(1) NOT NULL DEFAULT '0', `receive_updates` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `extra_informations` -- INSERT INTO `extra_informations` (`id`, `user_id`, `activities`, `website`, `linkedin`, `payment_status`, `mentor`, `expectations`, `share_details`, `receive_updates`, `created_at`, `updated_at`) VALUES (1, 2, '\"[\\\"Hi..\\\"]\"', 'http://www.shaptakbd.com', NULL, 'Not Applicable', 'Yes', 'Hi...', 0, 0, '2025-10-18 09:44:14', '2025-10-18 09:44:14'), (2, 3, '\"[\\\"Voluntary Activities:\\\\r\\\\nAssociate Editor and Review Editor, Frontiers in Public Health, Frontiers in Microbiology, Frontiers in \\\\r\\\\nMarine Science, Journal of Infection Genetics & Evolution, Microbial Ecology, Environmental \\\\r\\\\nMonitoring & Assessment, Asian Journal of Medical & Biological Research, Asian-Australasian \\\\r\\\\nJournal of Bioscience & Biotechnology. \\\\r\\\\nResearch Ambassador (since 2015), Leibniz Institute for Tropical Marine Research (ZMT), Bremen, \\\\r\\\\nGermany. \\\\r\\\\nAlumni Networking for University of Bremen, Max Planck Institute for Marine Microbiology, Osaka \\\\r\\\\nPrefecture University, Dhaka University, and International Centre for Diarrheal Disease Research, \\\\r\\\\nBangladesh (icddr,b) for the promotion of collaborative research and developmental cooperation. \\\\r\\\\nMember, American Society for Microbiology, Japan Student Service Organization (JASSO), DAAD \\\\r\\\\nAlumni Association, Ecosystem Services for Poverty Alleviation (ESPA), UK, Zoological Society of \\\\r\\\\nBangladesh, Bio-Safety & Bio-Security Association of Bangladesh, the Networks for Religious and \\\\r\\\\nTraditional Peacemakers, and Climate Change Professionals. Intergovernmental Panel on \\\\r\\\\nBiodiversity and Ecosystem Services (IPBES), Children Environmental Health Network, UNEP\\\\r\\\\nAPAN, International Ocean Institute. \\\\r\\\\nCoordinator & Trainer of the Trainees, Gender & Diversity, icddr,b (2013-2015).\\\"]\"', NULL, 'https://www.linkedin.com/in/sucharit-neogi-54131449', 'Pending', 'Yes', 'Networking, Promotion of research activities, Nature-based Solutions and Conservation-oriented programs, Events during Festivals, and Cultural and Sports programs, Building bridge between the young and the experienced veterans, Moving forward together', 1, 1, '2025-10-19 12:22:02', '2025-10-19 12:22:21'), (4, 4, '\"[\\\"He was also involved in extracurricular activities. Notably, he was an active member of the Dhaka University Film Society (DUFS) and served in several leadership roles, including General Secretary, Treasurer, and Office Secretary during his tenure.\\\"]\"', NULL, NULL, NULL, NULL, NULL, 0, 0, '2025-11-26 05:48:21', '2025-11-26 05:48:21'), (5, 34, '\"[\\\"1. Public Relation Secretary, Bangladesh Zoological Society (since 2023)\\\"]\"', NULL, NULL, NULL, NULL, NULL, 0, 0, '2026-05-07 08:56:09', '2026-05-07 08:56:09'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `frontends` -- CREATE TABLE `frontends` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `learnings` -- CREATE TABLE `learnings` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `author_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2025_05_07_075622_create_frontends_table', 1), (5, '2025_06_22_003526_create_admins_table', 1), (6, '2025_10_06_105052_create_personal_information_table', 1), (7, '2025_10_06_105113_create_academic_information_table', 1), (8, '2025_10_06_105126_create_employment_information_table', 1), (9, '2025_10_06_105146_create_extra_information_table', 1), (10, '2025_10_09_145523_create_news_table', 1), (11, '2025_10_11_113230_create_scientific_reports_table', 1), (12, '2025_10_11_181131_create_publications_table', 1), (13, '2025_10_14_182854_create_announcements_table', 1), (14, '2025_11_01_143019_create_albums_table', 1), (15, '2025_11_01_143108_create_album_images_table', 1), (16, '2025_11_01_163855_create_video_albums_table', 1), (17, '2025_11_01_163857_create_videos_table', 1), (18, '2025_11_03_140349_create_abouts_table', 1), (19, '2025_11_04_105557_create_conveners_table', 1), (20, '2025_11_04_143516_create_aims_objectives_table', 1), (21, '2025_11_04_175039_create_organograms_table', 1), (22, '2025_11_05_101140_create_committees_table', 1), (23, '2025_11_05_113627_create_constitutions_table', 1), (24, '2025_11_05_124619_create_events_table', 1), (25, '2025_11_06_112224_create_notices_table', 1), (26, '2025_11_09_180203_create_researches_table', 1), (27, '2025_11_10_191532_create_learnings_table', 1), (28, '2025_11_13_154525_create_contacts_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `date` date NOT NULL, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `admission_session` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `news_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `news` -- INSERT INTO `news` (`id`, `user_id`, `date`, `title`, `author`, `admission_session`, `image`, `description`, `document`, `news_link`, `created_at`, `updated_at`) VALUES (2, 2, '2026-05-14', 'Dengue Burden Estimation', 'Mohammad Shafiul Alam', NULL, 'uploads/NewsPhoto/bBZR61778908979.jpg', 'আমার সহকর্মী ডা. মাসুম বাংলাদেশে ২০২৫ সালে ডেঙ্গু ও চিকুনগুনিয়ার পরিস্থিতি নিরূপণের লক্ষ্যে আমি একটি অনলাইনভিত্তিক জরিপ পরিচালনা করছেন। অনুগ্রহ করে ৩–৫ মিনিট সময় নিয়ে ফর্মটি পূরণ করার জন্য অনুরোধ করা যাচ্ছে। পাশাপাশি, জরিপটি অন্যদের মাঝেও শেয়ার করার জন্য বিশেষভাবে অনুরোধ রইল। সহযোগিতার জন্য ধন্যবাদ ।সার্ভে লিংক:', '', 'https://docs.google.com/forms/d/e/1FAIpQLSclfVNECK0Z357g5IyXco-DPz8IrOtAmFd_jx7g3TMGdidWiQ/viewform?pli=1', '2026-05-14 06:53:52', '2026-05-16 10:29:44'); -- -------------------------------------------------------- -- -- Table structure for table `notices` -- CREATE TABLE `notices` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `author` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` date NOT NULL, `date_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `notices` -- INSERT INTO `notices` (`id`, `user_id`, `title`, `author`, `date`, `date_text`, `file`, `created_at`, `updated_at`) VALUES (9, 2, 'শুভ নববর্ষ ১৪৩৩!!', 'ডঃ সুচরিত বসু নিয়োগী', '2026-04-14', '2026-04-14', '1777795602.jpg', '2026-04-28 08:13:36', '2026-05-03 08:36:42'); -- -------------------------------------------------------- -- -- Table structure for table `organograms` -- CREATE TABLE `organograms` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_reset_tokens` -- INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES ('c.nhvacj.m@gmail.com', '$2y$12$MFSd.rWN2Os2REXhx8ZOyOJ.thWg5bw7GRjItBTfdDpZmmLvjB.o6', '2026-05-11 16:18:39'), ('catherine.hooper@gottschalks.com', '$2y$12$OuyUWx.ldjCk3rDiZUXWOOXFdyq2cH.plVeeTXBEOR.Ox.bCcZiTa', '2026-02-12 04:36:18'), ('cfabian@egtax.com', '$2y$12$OsxWht1NwZt08fOPyt/FuuImrR4gquiQmdPGviG0cr0SuHAqeZXy6', '2026-02-13 19:11:06'), ('codamad.at833@gmail.com', '$2y$12$DNKipxTEHtWRxC14G2Tthekxy1WfCUqDcCnua8HNkiWRC1ju.X5Ui', '2026-04-05 01:49:10'), ('douglas.donaway@cloverimaging.com', '$2y$12$wJxFl0B8QFQQgUGFgk5h.eYqKNDRMqHHPI9bc5dDCM91CE7VHZ5c6', '2026-02-10 03:53:20'), ('f.a.no.ga.so.w.a7.8@gmail.com', '$2y$12$hFLap0W6Ovf4lNU3M8i4XeW8xUHZ4wsTDHWgKQ03luVQD6KJOSl6a', '2026-05-07 00:47:01'), ('malescio@robert.ca', '$2y$12$zC8xqWF8tv5d9gWP/Ri8IeDDi7ZwdqP4ELgyfANE9xEQQO0ECrIWe', '2026-02-13 23:43:46'), ('o.f.i.n.u.v.i.fu.95@gmail.com', '$2y$12$TviUMuiem5txjbtgiGXaKewh1CyXNc3tuiJmL/w/DYquIBpTT2pfK', '2026-02-08 12:55:20'), ('p.a.yun.o.s.oy16@gmail.com', '$2y$12$cGspaQ7IkN8S/oVqJn/w6uRYKfcvjUlYDfovB7FAsMpLl.5K9bhuK', '2026-02-16 09:26:21'), ('popsahl@hotmail.com', '$2y$12$Cquh6YCsuw32vnnoZJ.idehiVpHIH8sf9HITynzKrKNdTow0ssnuy', '2026-02-12 13:32:16'), ('rmh2b3@yahoo.com', '$2y$12$zwuinStHSXm8b/UUNlV8T.U0CaPB.q/65k39KOKKGKKRcJK2WlXca', '2026-02-10 15:21:15'), ('stevem2@qpsisbest.com', '$2y$12$QcZv6CexHIu9AMDkN/wJuun8CqPiQxqCBdpIAaTKwVKIXltFjEdDK', '2026-02-10 03:32:19'), ('uyo.ge.n.e.ce.96.5@gmail.com', '$2y$12$QWZzMoFuZvjEl2LNOZMG9eWH9NtRHD7SDaU8Vp3RGXGbsI6oWUIFK', '2026-02-19 11:41:16'); -- -------------------------------------------------------- -- -- Table structure for table `personal_informations` -- CREATE TABLE `personal_informations` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `full_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `dob` date NOT NULL, `father_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `mother_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spouse_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nid_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `birth_certificate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `passport_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `home_district` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `present_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `blood_group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `id_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `personal_informations` -- INSERT INTO `personal_informations` (`id`, `user_id`, `full_name`, `gender`, `dob`, `father_name`, `mother_name`, `spouse_name`, `contact_number`, `email`, `id_type`, `nid_number`, `birth_certificate`, `passport_number`, `home_district`, `present_address`, `blood_group`, `id_photo`, `created_at`, `updated_at`) VALUES (1, 2, 'Shaiful Islam Khan', 'Male', '1980-02-02', 'Nazrul Islam Khan', 'Suraiya Islam', 'Tanzila Sharmin Tamanna', '01715175224', 'shaiful4u@gmail.com', 'nid', '4193687946', NULL, NULL, 'Dhaka', '49, South Kamalapur, Dhaka-1217', 'B+', 'uploads/PersonalPhoto/pMC2t1760859521.jpg', '2025-10-18 09:31:28', '2025-10-19 08:08:41'), (3, 3, 'Sucharit Basu Neogi', 'Male', '1974-01-06', 'Prodyot Kumar Basu Neogi', 'Krishna Basu Neogi', NULL, '+8801723053848', 'sbneogi@gmail.com', 'passport', NULL, NULL, 'A02983344', 'Tangail', 'M-10, NHA Tower, 16-17 Block-B, Lalmatia, Dhaka 1207', 'B+', 'uploads/PersonalPhoto/gGqjV1760873103.jpg', '2025-10-19 11:55:03', '2025-10-19 11:55:03'), (4, 4, 'Mohammad Shafiul Alam', 'Male', '1979-10-09', 'Md Sultan Ali Mia', 'Jebun Nessa', 'Fatema Rehana', '01711469232', 'shafiul.icddrb@gmail.com', 'nid', '19792694261639548', NULL, NULL, 'Sirajganj', 'Flat# 3e, House no.2, Road no. 104, Gulshan-2', 'AB+', 'uploads/PersonalPhoto/9zKC31761111978.jpg', '2025-10-22 06:16:18', '2025-10-22 06:16:18'), (5, 5, 'Masud Al Faruque', 'Male', '1976-01-31', 'Md. Maqbul Hossain', NULL, NULL, '01971161126', 'tamal0013@gmail.com', 'nid', '12345', NULL, NULL, 'Rangpur', 'Flat 2B, 173/B khilgaon Chaudhury Para Dhaka', 'O+', 'uploads/PersonalPhoto/N7bDo1761112502.jpeg', '2025-10-22 06:25:02', '2025-10-22 06:25:02'), (6, 6, 'A. B. M. Ehaanul Mamun', 'Male', '1978-12-30', 'Late Abdul Matin', 'Mrs. Aleya Khatun', NULL, '01735707070', 'mamunbcs25@gmail.com', 'nid', NULL, NULL, NULL, 'Bogura', 'Koigari, Ward#13, Bogura Pourosova, Bogura', 'O+', 'uploads/PersonalPhoto/Ces5w1761660915.jpg', '2025-10-28 14:45:16', '2025-10-28 14:45:16'), (7, 7, 'Muhammad Jahangir Hossain Munna', 'Male', '1980-02-15', 'Delwar Islam Sarker', 'Mabia Khatun', 'Shamima Akter', '+8801718361316', 'munna528@gmail.com', 'nid', '3727307203', NULL, NULL, 'Dhaka', 'Chamurkhan, Kanchkura, Uttarkhan, Dhaka', 'O+', 'uploads/PersonalPhoto/R1kFr1761711015.jpg', '2025-10-29 04:40:16', '2025-10-29 04:40:16'), (8, 8, 'Md. Yeasin Arafat', 'Male', '1975-02-10', 'Md Sultan Miah', 'Rahima Begum', 'Rebeka islam', '01712122009', 'yeasin1975@gmail.com', 'nid', '19755914439550838', NULL, NULL, 'Munshiganj', 'House 33, Road 10, Sector 10, Uttara, Dhaka', 'B+', 'uploads/PersonalPhoto/eOT3S1762772821.jpeg', '2025-11-10 11:37:01', '2025-11-10 11:37:01'), (9, 9, 'Muhammad Kamruzzaman Kamrul', 'Male', '1982-01-15', 'Md Abdul Gafur', 'FIRUJA AKTER', 'SHAHINA NASRIN', '01712669682', 'du.kamrul@gmail.com', 'nid', '8670045932', NULL, NULL, 'Netrakona', 'Mirpur, Dhaka', 'O+', 'uploads/PersonalPhoto/oaIAA1762949280.jpeg', '2025-11-11 11:59:23', '2025-11-12 12:38:00'), (10, 32, 'Bidhan Roy', 'Male', '1988-05-18', 'Birendra Nath Roy', 'Gita Roy', 'Sangita Roy', '01708368160', 'roy.bidhan.rajuk@gmail.com', 'nid', '5414075702171', NULL, NULL, 'Madaripur', 'RAJUK Officers Quarter, Malibag, Dhaka', 'O+', 'uploads/PersonalPhoto/vz6lK1777784638.jpeg', '2026-05-03 05:33:58', '2026-05-03 05:33:58'), (11, 34, 'Md. Hasanuzzaman', 'Male', '1972-09-02', 'Md. Sajidur Rahman', 'Hasina Begum', 'Farzana Yesmin', '008801715702202', 'hasan.baec@gmail.com', 'nid', '3254615366', NULL, NULL, 'Rajshahi', 'IFRB, Bangladesh Atomic Energy Commission', 'AB+', 'uploads/PersonalPhoto/El57G1778142575.jpg', '2026-05-07 08:59:35', '2026-05-07 09:01:13'), (12, 40, 'Atikur Rahman', 'Male', '1981-02-08', 'Abdul Hai Hawlader', 'Shahanara Begum', 'Nusrat Jahan Tuly', '01711183631', 'firstagrobd@gmail.com', 'nid', '5069996931', NULL, NULL, 'Barishal', 'Govt. School Street, Doleshwar, South Keranigonj, Dhaka-1311', 'O+', 'uploads/PersonalPhoto/Yftjf1781007435.jpg', '2026-06-09 12:33:38', '2026-06-09 12:47:15'); -- -------------------------------------------------------- -- -- Table structure for table `publications` -- CREATE TABLE `publications` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `admission_session` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `publications` -- INSERT INTO `publications` (`id`, `user_id`, `title`, `author`, `admission_session`, `description`, `document`, `link`, `created_at`, `updated_at`) VALUES (2, 4, 'Concurrent transmission of Zika virus during the 2023 dengue outbreak in Dhaka, Bangladesh', 'Mohammad Shafiul Alam', NULL, 'This study explores the co-transmission of Zika (ZIKV) and dengue (DENV) during the 2023 dengue outbreak in Bangladesh, shedding light on important public health and epidemiological issues. While Zika is typically a mild illness for most people, it can have serious neurological consequences, such as microcephaly in infants. Dengue, another mosquito-borne virus common in tropical regions like Bangladesh, affects a significant portion of the population. The research stands out because it marks the first recorded Zika cases in Dhaka and the first instance of Zika-Dengue co-infection in the country. This discovery is crucial for both local and global health communities, as it highlights the challenge of managing outbreaks of similar viruses at the same time, complicating diagnosis and treatment. The study calls for stronger surveillance and better public health measures to manage these viruses, particularly in densely populated areas where mosquitoborne illnesses spread rapidly. This work focuses on the importance of raising awareness and enhancing disease management practices to reduce the risks posed by these infections. The overlap in symptoms and the potentially serious outcomes for vulnerable groups, like pregnant women and newborns, make understanding Zika’s transmission and genetic variations critical. These insights can guide future efforts in vaccine development and public health interventions at the community level.', 'uploads/PublicationsDocs/DG26g1764134687.pdf', 'https://journals.plos.org/plosntds/article?id=10.1371/journal.pntd.0012866', '2025-11-26 05:54:47', '2025-11-26 05:54:47'); -- -------------------------------------------------------- -- -- Table structure for table `researches` -- CREATE TABLE `researches` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `author_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `author_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `author_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `researches` -- INSERT INTO `researches` (`id`, `user_id`, `title`, `author_name`, `author_class`, `description`, `link`, `file`, `author_photo`, `created_at`, `updated_at`) VALUES (1, 2, 'Global Concerns', 'Sucharit Basu Neogi', NULL, 'Science for a Sustainable and Compassionate Planet
Addressing the Planet’s Pressing Challeng
', NULL, 'uploads/research/files/research_7UzhoAgo1764848563.pptx', 'uploads/research/authors/author_Jwxazk6q1776927682.jpg', '2025-12-04 12:12:43', '2026-04-23 07:31:22'); -- -------------------------------------------------------- -- -- Table structure for table `scientific_reports` -- CREATE TABLE `scientific_reports` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `title` text COLLATE utf8mb4_unicode_ci NOT NULL, `author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `admission_session` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci NOT NULL, `document` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `scientific_reports` -- INSERT INTO `scientific_reports` (`id`, `user_id`, `title`, `author`, `admission_session`, `description`, `document`, `link`, `created_at`, `updated_at`) VALUES (2, 4, 'The Return of Chikungunya in Bangladesh in 2024: Implications for Future Outbreaks', 'Anamul Hasan , Md. Fahad Zamil , Afrida Tabassum Trina , Mohammad Sharif Hossain , Sajia Afreen , Dilruba Ahmed, and Mohammad Shafiul Alam', NULL, 'After a major outbreak in Bangladesh in 2017, chikungunya nearly vanished from its territory until its resurgence in late 2024. However, its symptomatic overlap with dengue virus (DENV), another major arbovirus, has hindered accurate diagnosis and reporting, resulting in limited molecular diagnostic efforts for chikungunya in this region. This diagnostic evaluation study aimed to detect and characterize arboviral infections at the molecular level, focusing on the re-emergence of chikungunya and implications for future outbreaks. Febrile individuals aged 5–65 years old presenting with fever onset within 2–5 days along with other corresponding febrile symptoms were prospectively recruited from the International Centre for Diarrhoeal Disease Research, Bangladesh diagnostic facilities in Dhaka, Bangladesh. After meeting inclusion and exclusion criteria, 569 of 1,280 screened individuals were enrolled, providing informed written consent/assent. Serum samples from 474 participants underwent real-time reverse transcription-polymerase chain reaction testing, revealing 213 positive cases for at least one arbovirus. Chikungunya cases totaled 55, including seven coinfections (six with DENV and the first documented chikungunya virus–Zika virus coinfection in Bangladesh). No infections were reported from January to August, with a peak in October and November. Most chikungunya virus infections (72.7%) had moderate to high viral loads, with symptoms of joint pain, myalgia, and headaches. This resurgence of chikungunya in late 2024 highlights the potential for a major outbreak in 2025, necessitating proactive measures to mitigate public health impact and ensure a robust response to this re-emerging threat.', NULL, 'https://www.ajtmh.org/view/journals/tpmd/113/3/article-p516.xml', '2025-11-26 05:50:51', '2025-11-26 05:50:51'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('a4R5S2eyLQz8MZSuA5IuxH6D9lr1uJCtiUSr8Fbu', NULL, '52.167.144.182', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWG5rWEhLUXUyVFNUSDdqTzJSRjRkdTdVeHlxMTEzeUs2RkVrTXJ1RyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9kdWd6YS5vcmcvYWxsX2V2ZW50cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1790411649), ('b0tcPwniEsJoP2Krhqe6DMDYWwrL7yYKo5Ixw3NG', NULL, '82.102.18.116', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibHcwYkJIRFM0bzhiQlBlSU5MN1MxMkdjWEJDdzN2Rms3empvbEI0biI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9kdWd6YS5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1790408882), ('bEwxqgmpRq3v97ZPwTMeiaD3uMmOWE6AkTUneA9U', NULL, '162.14.66.219', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTVQ5WDk0RlpidzA4NlJJd2RaUzVmd2tzWEh6VTVFN21ka1BaSEJGTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA6Imh0dHA6Ly93d3cuZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790409518), ('BvAeb4AmF2gpwKJaqUZbzHc3dvqBcet2iQbiguWy', NULL, '43.163.80.48', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaXJTeFg4dlp4ZGdDN2xGam1kQWozcm45dGgwN214M2FBemJDV0NyQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA6Imh0dHA6Ly93d3cuZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790421497), ('BZ53Hn3gcTHWtowCryhqfIaLIe1Y8H990ZwgXZf3', NULL, '43.153.87.54', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDlYM2dYTEJ2UnVDanhKTENudURDcmZ2R3MydHJhRkRBY1JJOXlpZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA6Imh0dHA6Ly93d3cuZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790407063), ('fVl8q3WtoTkFlIuIiPd1355VuPC4P8gUVsmEgd4W', NULL, '106.63.26.139', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYk5DVDZWYXhXZXJSbkZHNHk4VUNucHZaSGo2OERUcFFQNHZqSzR1TSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vbWFpbC5kdWd6YS5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1790418841), ('fZBfacW2vEoh010cnkTLV1oqIVtBoYWgsLr0f66W', NULL, '43.134.100.175', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY3lKMGw5NWNaalMxOXhraHplWVdPcEU1SndTTmNJRG1FcTFOd3RoRyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9kdWd6YS5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1790418676), ('KohYdsOghmTAlvztRJdyu5krm0CSHUJRYXmjb6wz', NULL, '66.249.66.202', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/154.0.8037.57 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYkpxdWZCcVltT05TYTExbDdZUTZWNlA1dGhlQ0kwQmNDaUtKMW8yVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTc6Imh0dHBzOi8vZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790411928), ('lc4P5reT3YhSV7bwe8ZTLgdnVFF6hyiUTZIQpto4', NULL, '34.38.113.44', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTnZtODNLOXJmZ3FlQmg2TEE5SDBJcWRRcEQ0UnQ3ZWg0elkyaWI0dSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTc6Imh0dHBzOi8vZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790413493), ('lEwH2C8La8lcj1UvQx4yYokPr3r98ttEiluR1gUx', NULL, '40.77.167.3', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicnJER0gxcTRla2RpWHU1cThGblRHR1lIcjhab1kzUVAxS3FpbURITyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHBzOi8vd3d3LmR1Z3phLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1790418033), ('NhyYPQLjQW6xQLbR0hmXSBeoENViLgfVLcCcrut5', NULL, '164.92.153.234', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUndtOVEyUkJ4NGtMSExJeHNmNXpyS0pUQU9TWUtVMHVkR0Zvajd3VCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9kdWd6YS5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1790406058), ('NKmNU2TGgl4ZUo5wgb9xIYW5pLOt5DAeFtUDDtEO', NULL, '42.193.171.36', 'Mozilla/5.0 (Linux; Android 7.1.1; 1801-A01 Build/NMF26X; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/57.0.2987.132 MQQBrowser/6.2 TBS/044111 Mobile Safari/537.36 V1_AND_SQ_7.6.5_864_YYB_D QQ/7.6.5.3595 NetType/WIFI WebP/0.3.0 Pixel/1080', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoicTBlWnpTcVRGNm5adlZYaVN1ZlJpeHZhVkhUM3ZUM0pQOEl3YTdWZiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790418516), ('NZnIAyAvptjPlZbYPFTL9m4WxE5vBOsRsUcTEWvS', NULL, '164.92.153.234', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSGhVTDNWaWhYRk1Na3BOc3RHSmlXdVZlbWk0ODNraFgzTnNZTzVVWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTc6Imh0dHBzOi8vZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790406059), ('OLc4c5IJs1aEINz81nkmp7M1jKyGdeZv36LX7u2h', NULL, '198.235.24.183', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR1pTS1RDRjlqRXdhVmZFS3dvNUNYMFBkSFlFSU1uUldoVm5QWUFHNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTc6Imh0dHBzOi8vZHVnemEub3JnIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1790417640), ('Qbq9xeSOnR3b8diGABilkv5ZfffA3Q4HJXxLt0bd', NULL, '66.132.186.166', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQmxuc1lWdHJqWnhJMklXRlNlOVV5RDdmdHFBNXJBc0pIZFZnUUR3eiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHBzOi8vd3d3LmR1Z3phLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1790421828), ('sQx6VILJOZFdFLW9ntUJz32oIaVIejyOSQikqgRS', NULL, '43.133.221.163', 'Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.5 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTUNvVHVLWnhJd003OWEzYTY4SENsamJ3Y29aNkhUaG9maHp1VUJmYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9kdWd6YS5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1790421553), ('t81tURSqghgcHTuCKwAuLYEUdol9AI4wgfnHKsrq', NULL, '106.63.26.132', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVXA2T0F4NUNRNzhSNmE4cVp2T2QwaVJyemd6RzVKdG9seld4SGJPeSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9tYWlsLmR1Z3phLm9yZyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1790418909), ('YpFame3YhlNQiutt6rIvyyiSl5pDHX9iD9aKqhqy', NULL, '198.235.24.173', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZjF2WXZ0UHBuWUlpaGgyZUpNY3FFRlNWTU0zM0tRTElzNlA1ZlZJNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9kdWd6YS5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1790418587); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `register_type` enum('student','general') COLLATE utf8mb4_unicode_ci NOT NULL, `student_id_card` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `member_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `profile_photo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default.jpg', `role` int(11) NOT NULL DEFAULT '3' COMMENT '1=super admin,2=admin,3= user', `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive', `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `phone`, `register_type`, `student_id_card`, `member_id`, `profile_photo`, `role`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'super admin', 'superadmin@gmail.com', NULL, '$2y$12$eM4guMeVsmks4VavUECedOHvme.WrZ9tHCEgGwX26yp04BPm2UZSu', '01700000000', 'general', NULL, NULL, 'default.jpg', 1, 'active', 'kcGj9KuBUVtM5kb7q2Y1dc7vJ7mKNVwlDvMbC4627I58vztQksLxyOSEDDDA', '2025-11-16 11:50:01', '2025-11-16 11:50:01'), (2, 'Shaiful Islam Khan', 'shaiful4u@gmail.com', NULL, '$2y$12$YFodUPms0h9/ukON7VXah.zZLRnXQXE/eSruB69t0ko8Rbqmp.ThW', '01715175224', 'general', NULL, 'GM-0002', 'default.jpg', 2, 'inactive', 'bQYsovrJDGVRCDBNWMyUR1uIGTEttE4EYtEk0Wu7c4hy37iYUZ7tQSxL8M47', NULL, '2026-04-26 05:28:00'), (3, 'Sucharit Basu Neogi', 'sbneogi@gmail.com', NULL, '$2y$12$zPrAC122pJbl7Kst.r/A0OVItGxhwNXrVz5QjhSLmqDWYSvpUrmCy', '+8801723053848', 'general', NULL, 'GM-0003', 'default.jpg', 2, 'active', 'aatX4nD6bJt42mdpQZu3gyUZRa11L5EGbIQSNvbFGDMFRhOMDAD23hO6o2Ha', NULL, '2026-04-25 10:20:28'), (4, 'Mohammad Shafiul Alam', 'shafiul.icddrb@gmail.com', NULL, '$2y$12$M.CJYLVn1kuqy.e416slFesl71eiYMxKB39Ew9PD1C64ymjsiykny', '01711469232', 'general', NULL, 'GM-0004', 'default.jpg', 2, 'active', 'YOBbyjFlgRkACKCWCgV7t8Oy8gol5o3n2rw3pkCLwwE8Hq2LRsHZ8oJq4PFK', NULL, '2026-04-25 10:20:34'), (5, 'Masud Al Faruque', 'tamal0013@gmail.com', NULL, '$2y$12$rD4E85rRYFdpSpjDe1w6su.x3325I6DGIWf3uTNWfVaTeKfr2zHdG', '01971161126', 'general', NULL, 'GM-0005', 'default.jpg', 2, 'active', NULL, NULL, '2026-04-25 10:20:53'), (6, 'A. B. M. Ehaanul Mamun', 'mamunbcs25@gmail.com', NULL, '$2y$12$1GQdT9lLw0lca1v8sHKcjOffkW8gdxrGoM5uOom7pLrUtnJF9fSii', '01735707070', 'general', NULL, 'GM-0006', 'default.jpg', 2, 'active', 'lxYXNAbG95sebUaEoPa5rNfkjx2Sv9DLpMoc6fdZeKItr69yiwFDYYWspqIc', NULL, '2026-04-25 10:20:57'), (7, 'Muhammad Jahangir Hossain Munna', 'munna528@gmail.com', NULL, '$2y$12$wsNFtKULOoUJREmNrDdQUOWvsCcWAjgBcj4y5NTYgqV/fFuVmSfVO', '+8801718361316', 'general', NULL, 'GM-0007', 'default.jpg', 2, 'active', 'MMMhftOY3eWkcKoc7UDvvPK1ZpeGiWtnt4yEoKpXn1psCkG2JW8yVVzKzk7Q', NULL, '2026-04-25 10:21:01'), (8, 'Md. Yeasin Arafat', 'yeasin1975@gmail.com', NULL, '$2y$12$xoO4EDpZWwQPVYY//jksQ.YwbZoOL8RqVH0hjoS/ofi9CazoZA4YW', '01712122009', 'general', NULL, 'GM-0008', 'default.jpg', 2, 'active', 'udjoOmDYtgfC7FVSuW6QaytxkNYs49oujGhbz9QC8HUULxCyd5ryDeAu98TA', NULL, '2026-04-25 10:21:13'), (9, 'Muhammad Kamruzzaman', 'du.kamrul@gmail.com', NULL, '$2y$12$7lyft3NT1ToVho/KSPhiwuZsGHMoFGZihARBBgyJ.By.p0xkYggq6', '01712669682', 'general', NULL, 'GM-0009', 'default.jpg', 2, 'inactive', 'CsHz902UuDItuN25No1HujG9Ed7GJyVppRi8SXgxjCYGQChyc2hrFmFKzaCo', NULL, '2025-11-20 07:08:03'), (32, 'Bidhan Roy', 'roy.bidhan.rajuk@gmail.com', NULL, '$2y$12$TqRhpw2I1.XoF6zKWoMvQudAsCqr.rEPwYFQYZtlhhUhx1bAXt3U.', '01708368160', 'general', NULL, 'GM-0010', 'default.jpg', 3, 'inactive', 'ItryFPkn3l1xXsktAmfXmWwbMMxDmPhMAt6JFg6pwar7FZhd94ZJt1xaBHPm', '2026-05-03 05:29:28', '2026-05-03 05:29:28'), (33, 'aTENkDevfhxQEabpPrGHpf', 'f.a.no.ga.so.w.a7.8@gmail.com', NULL, '$2y$12$tAKFFVTJX3v4cRRhwQsW7e/KfGk6Jch1RH0/za8N.Xn3hUSWDuBFG', '4209701616', 'general', NULL, 'GM-0011', 'default.jpg', 3, 'inactive', NULL, '2026-05-07 00:46:42', '2026-05-07 00:46:42'), (34, 'Md. Hasanuzzaman', 'hasan.baec@gmail.com', NULL, '$2y$12$5vMO0zgApnEGghujn6c7y.kU/LwJjmTyXgBLDcJo4xRuw9yal/at6', '008801715702202', 'general', NULL, 'GM-0012', 'default.jpg', 3, 'inactive', 'GGw8fh8twkuTerJpq1cTSVTY7JCTykEUG71Xt1ePxXDHg7pCv4sZXmrpX79l', '2026-05-07 08:37:01', '2026-05-07 08:37:01'), (35, 'VIdOoVYMiANYEMigzsdc', 'blupo13@verizon.net', NULL, '$2y$12$faS.sLwhEVDMIB/u2elQB.bDAkTmM1oOBOBoLYRMFWMsg/3VBuUHq', '7233502135', 'general', NULL, 'GM-0013', 'default.jpg', 3, 'inactive', NULL, '2026-05-07 20:17:51', '2026-05-07 20:17:51'), (36, 'WSbAtirdzSsAfDFM', 'apet.e.r.son.40.6@gmail.com', NULL, '$2y$12$WWAKrXWgqKpuraczCrnr3uF/I4ght/A7RGxkdzczwvqZCPdK1y28S', '2815587272', 'general', NULL, 'GM-0014', 'default.jpg', 3, 'inactive', NULL, '2026-05-09 22:21:38', '2026-05-09 22:21:38'), (37, 'LgXlWoKNXtkhODOiHmOKoa', 'jil.eq.o.kul.a634@gmail.com', NULL, '$2y$12$aYpfC4eD1gkUuRZbPDsW6e0R/uA7hbJzDRiqS3jCLSDgmwKu7T/6C', '4584730227', 'general', NULL, 'GM-0015', 'default.jpg', 3, 'inactive', NULL, '2026-05-10 08:36:48', '2026-05-10 08:36:48'), (38, 'RhxryOxVeCsDHOJoSvWEG', 'c.nhvacj.m@gmail.com', NULL, '$2y$12$xdWmJPurchb0meQoauDnA.da39eBAz1/c5VJ0hkGZOy9HbiSXTC.2', '9284495228', 'general', NULL, 'GM-0016', 'default.jpg', 3, 'inactive', NULL, '2026-05-11 16:18:19', '2026-05-11 16:18:19'), (39, 'gUvdIuOgAIhIWiRKSTXxd', 'mrivers2817@yahoo.com', NULL, '$2y$12$ru3ZX0BXY.pWb3DrvaNw5.jhPMUhSnMrs7NvIRMXIr.c3qcBqddhm', '2641342511', 'general', NULL, 'GM-0017', 'default.jpg', 3, 'inactive', NULL, '2026-05-11 20:33:59', '2026-05-11 20:33:59'), (40, 'Atikur Rahman', 'firstagrobd@gmail.com', NULL, '$2y$12$.zP9sgEfijiaBGfjFdPCqeeAstAdJT6jzOMmwo955uVfxDLhy5/My', '01711183631', 'general', NULL, 'GM-0018', 'default.jpg', 3, 'inactive', 'T6yfHquxyUx1DloMvosikz14eub8fS10RjiDCaHeGi4yjpGKnFkrMX9gOkd2', '2026-06-09 12:29:47', '2026-06-09 12:29:47'), (41, 'Kamrunnahar', 'kazinahardu@gmail.com', NULL, '$2y$12$aWZ8OFxogqUIS6aShLFnaO9a1MSNZOYH8J1XqTrKgmixhxhd/BPoi', '01627575686', 'general', NULL, 'GM-0019', 'default.jpg', 3, 'inactive', NULL, '2026-06-11 08:06:51', '2026-06-11 08:06:51'), (42, 'jzArLJMvzFOzgjjfCMZwxN', 'ze.kav.ip.oz83.6@gmail.com', NULL, '$2y$12$CbMrL/34UY/fbmc4A63ee.eznTZFJBL0wq3O2JAm8dbfwq0HsvNsK', '9213125155', 'general', NULL, 'GM-0020', 'default.jpg', 3, 'inactive', NULL, '2026-07-13 07:37:33', '2026-07-13 07:37:33'); -- -------------------------------------------------------- -- -- Table structure for table `videos` -- CREATE TABLE `videos` ( `id` bigint(20) UNSIGNED NOT NULL, `video_album_id` bigint(20) UNSIGNED NOT NULL, `video_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'youtube', `video_url` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `videos` -- INSERT INTO `videos` (`id`, `video_album_id`, `video_title`, `video_type`, `video_url`, `created_at`, `updated_at`) VALUES (1, 1, NULL, 'mp4', 'uploads/videos/mp4/1763342861_ifter_vedio_1.mp4', '2025-11-17 01:57:41', '2025-11-17 01:57:41'); -- -------------------------------------------------------- -- -- Table structure for table `video_albums` -- CREATE TABLE `video_albums` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `cover_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `video_albums` -- INSERT INTO `video_albums` (`id`, `title`, `cover_image`, `created_at`, `updated_at`) VALUES (1, 'Ifter-2024', 'uploads/videos/cover/1763342861_WhatsApp Image 2025-10-15 at 7.07.12 PM.jpeg', '2025-11-17 01:57:41', '2025-11-17 01:57:41'); -- -- Indexes for dumped tables -- -- -- Indexes for table `abouts` -- ALTER TABLE `abouts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `academic_informations` -- ALTER TABLE `academic_informations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `academic_informations_user_id_unique` (`user_id`); -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`); -- -- Indexes for table `aims_objectives` -- ALTER TABLE `aims_objectives` ADD PRIMARY KEY (`id`); -- -- Indexes for table `albums` -- ALTER TABLE `albums` ADD PRIMARY KEY (`id`); -- -- Indexes for table `album_images` -- ALTER TABLE `album_images` ADD PRIMARY KEY (`id`), ADD KEY `album_images_album_id_foreign` (`album_id`); -- -- Indexes for table `announcements` -- ALTER TABLE `announcements` ADD PRIMARY KEY (`id`), ADD KEY `announcements_user_id_foreign` (`user_id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `committees` -- ALTER TABLE `committees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `constitutions` -- ALTER TABLE `constitutions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contacts` -- ALTER TABLE `contacts` ADD PRIMARY KEY (`id`); -- -- Indexes for table `conveners` -- ALTER TABLE `conveners` ADD PRIMARY KEY (`id`); -- -- Indexes for table `employment_informations` -- ALTER TABLE `employment_informations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `employment_informations_user_id_unique` (`user_id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `events_slug_unique` (`slug`); -- -- Indexes for table `event_attachments` -- ALTER TABLE `event_attachments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `extra_informations` -- ALTER TABLE `extra_informations` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `extra_informations_user_id_unique` (`user_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `frontends` -- ALTER TABLE `frontends` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `learnings` -- ALTER TABLE `learnings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `news` -- ALTER TABLE `news` ADD PRIMARY KEY (`id`), ADD KEY `news_user_id_foreign` (`user_id`); -- -- Indexes for table `notices` -- ALTER TABLE `notices` ADD PRIMARY KEY (`id`), ADD KEY `notices_user_id_foreign` (`user_id`); -- -- Indexes for table `organograms` -- ALTER TABLE `organograms` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `personal_informations` -- ALTER TABLE `personal_informations` ADD PRIMARY KEY (`id`), ADD KEY `personal_informations_user_id_foreign` (`user_id`); -- -- Indexes for table `publications` -- ALTER TABLE `publications` ADD PRIMARY KEY (`id`), ADD KEY `publications_user_id_foreign` (`user_id`); -- -- Indexes for table `researches` -- ALTER TABLE `researches` ADD PRIMARY KEY (`id`), ADD KEY `researches_user_id_foreign` (`user_id`); -- -- Indexes for table `scientific_reports` -- ALTER TABLE `scientific_reports` ADD PRIMARY KEY (`id`), ADD KEY `scientific_reports_user_id_foreign` (`user_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- Indexes for table `videos` -- ALTER TABLE `videos` ADD PRIMARY KEY (`id`), ADD KEY `videos_video_album_id_foreign` (`video_album_id`); -- -- Indexes for table `video_albums` -- ALTER TABLE `video_albums` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `abouts` -- ALTER TABLE `abouts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `academic_informations` -- ALTER TABLE `academic_informations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `aims_objectives` -- ALTER TABLE `aims_objectives` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `albums` -- ALTER TABLE `albums` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `album_images` -- ALTER TABLE `album_images` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `announcements` -- ALTER TABLE `announcements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `committees` -- ALTER TABLE `committees` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `constitutions` -- ALTER TABLE `constitutions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `contacts` -- ALTER TABLE `contacts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `conveners` -- ALTER TABLE `conveners` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `employment_informations` -- ALTER TABLE `employment_informations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `event_attachments` -- ALTER TABLE `event_attachments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `extra_informations` -- ALTER TABLE `extra_informations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `frontends` -- ALTER TABLE `frontends` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `learnings` -- ALTER TABLE `learnings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `news` -- ALTER TABLE `news` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `notices` -- ALTER TABLE `notices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `organograms` -- ALTER TABLE `organograms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `personal_informations` -- ALTER TABLE `personal_informations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `publications` -- ALTER TABLE `publications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `researches` -- ALTER TABLE `researches` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `scientific_reports` -- ALTER TABLE `scientific_reports` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43; -- -- AUTO_INCREMENT for table `videos` -- ALTER TABLE `videos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `video_albums` -- ALTER TABLE `video_albums` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `academic_informations` -- ALTER TABLE `academic_informations` ADD CONSTRAINT `academic_informations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `album_images` -- ALTER TABLE `album_images` ADD CONSTRAINT `album_images_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE; -- -- Constraints for table `announcements` -- ALTER TABLE `announcements` ADD CONSTRAINT `announcements_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `employment_informations` -- ALTER TABLE `employment_informations` ADD CONSTRAINT `employment_informations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `extra_informations` -- ALTER TABLE `extra_informations` ADD CONSTRAINT `extra_informations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `news` -- ALTER TABLE `news` ADD CONSTRAINT `news_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `notices` -- ALTER TABLE `notices` ADD CONSTRAINT `notices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `personal_informations` -- ALTER TABLE `personal_informations` ADD CONSTRAINT `personal_informations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `publications` -- ALTER TABLE `publications` ADD CONSTRAINT `publications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `researches` -- ALTER TABLE `researches` ADD CONSTRAINT `researches_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `scientific_reports` -- ALTER TABLE `scientific_reports` ADD CONSTRAINT `scientific_reports_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `videos` -- ALTER TABLE `videos` ADD CONSTRAINT `videos_video_album_id_foreign` FOREIGN KEY (`video_album_id`) REFERENCES `video_albums` (`id`) ON DELETE CASCADE; COMMIT; /*!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 */;