-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `fkr`
--

-- --------------------------------------------------------

--
-- Table structure for table `activitie`
--

CREATE TABLE `activitie` (
  `id` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `fb_link` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `activitie`
--

INSERT INTO `activitie` (`id`, `title`, `fb_link`, `created_at`) VALUES
(2, 'test2222', 'tttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt.ocmttttt', '2024-07-04 05:26:30');

-- --------------------------------------------------------

--
-- Table structure for table `admission_form`
--

CREATE TABLE `admission_form` (
  `aid` int(11) NOT NULL,
  `gr_no` int(11) NOT NULL,
  `student_name` varchar(255) NOT NULL,
  `father_name` varchar(255) NOT NULL,
  `place_of_birth` varchar(255) NOT NULL,
  `date_of_birth` date NOT NULL,
  `date_of_birth_in_words` varchar(255) NOT NULL,
  `cast` varchar(255) NOT NULL,
  `religion` varchar(255) NOT NULL,
  `last_school` varchar(255) NOT NULL,
  `class_admit` varchar(255) NOT NULL,
  `date_of_admission` date NOT NULL,
  `mailing_address` longtext NOT NULL,
  `student_b_form` varchar(255) NOT NULL,
  `g_cnic_no` varchar(255) NOT NULL,
  `g_name` varchar(255) NOT NULL,
  `mobail_no` int(11) NOT NULL,
  `w_no` int(11) NOT NULL,
  `crated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admission_form`
--

INSERT INTO `admission_form` (`aid`, `gr_no`, `student_name`, `father_name`, `place_of_birth`, `date_of_birth`, `date_of_birth_in_words`, `cast`, `religion`, `last_school`, `class_admit`, `date_of_admission`, `mailing_address`, `student_b_form`, `g_cnic_no`, `g_name`, `mobail_no`, `w_no`, `crated_at`) VALUES
(1, 1234, 'babar sweesw', 'fajr', 'rat', '0000-00-00', '', 'fsdsf', 'sds', 'dfsfd', 'dfd', '2025-07-16', '', '', '', '', 0, 0, '2025-07-10 23:38:45'),
(51, 31345, 'tt', 'tt', '22', '2025-07-23', 'ddd', 'ss', 'sd', 'ddd', 'ddd', '2025-07-09', 'dddddddddddd', 'dd', 'd', 'dd', 99999999, 2147483647, '2025-07-16 23:52:09');

-- --------------------------------------------------------

--
-- Table structure for table `fee_receipts`
--

CREATE TABLE `fee_receipts` (
  `id` int(11) NOT NULL,
  `receipt_no` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `student_name` varchar(100) DEFAULT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `class` varchar(50) DEFAULT NULL,
  `monthly_fee` int(11) DEFAULT 0,
  `admission_fee` int(11) DEFAULT 0,
  `exam_fee` int(11) DEFAULT 0,
  `dues` int(11) DEFAULT 0,
  `other_fee` int(11) DEFAULT 0,
  `total` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `fee_receipts`
--

INSERT INTO `fee_receipts` (`id`, `receipt_no`, `date`, `student_id`, `student_name`, `father_name`, `class`, `monthly_fee`, `admission_fee`, `exam_fee`, `dues`, `other_fee`, `total`) VALUES
(1, '1234', '2025-07-31', NULL, 'babar sweesw', 'fajr', 'one', 1000, 2000, 200, 1000, 500, 4700),
(2, '1234', '2025-07-31', 1, 'babar sweesw', 'fajr', 'two', 1000, 0, 0, 0, 0, 1000);

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` varchar(250) DEFAULT NULL,
  `desc` longtext DEFAULT NULL,
  `image` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `desc`, `image`, `created_at`) VALUES
(2, 'test2', 'tttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt.ocmrrrrrrrrrrrrrrrrrrr', 'uploads/WhatsApp Image 2024-07-01 at 10.20.52 PM.jpeg', '2024-07-04 05:25:35'),
(3, 'test33', 'test33', 'uploads/WhatsApp Image 2024-07-01 at 10.20.52 PM.jpeg', '2024-07-03 10:24:16');

-- --------------------------------------------------------

--
-- Table structure for table `school_leaving_form`
--

CREATE TABLE `school_leaving_form` (
  `id` int(11) NOT NULL,
  `gr_no` varchar(50) DEFAULT NULL,
  `student_name` varchar(100) DEFAULT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `place_of_birth` varchar(100) DEFAULT NULL,
  `dob_figure` varchar(50) DEFAULT NULL,
  `dob_words` varchar(255) DEFAULT NULL,
  `cast` varchar(50) DEFAULT NULL,
  `religion` varchar(50) DEFAULT NULL,
  `last_school` varchar(150) DEFAULT NULL,
  `class_admit` varchar(50) DEFAULT NULL,
  `date_of_admission` date DEFAULT NULL,
  `gr_no_slc` varchar(50) DEFAULT NULL,
  `current_class` varchar(50) DEFAULT NULL,
  `leaving_reason` text DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `school_leaving_form`
--

INSERT INTO `school_leaving_form` (`id`, `gr_no`, `student_name`, `father_name`, `place_of_birth`, `dob_figure`, `dob_words`, `cast`, `religion`, `last_school`, `class_admit`, `date_of_admission`, `gr_no_slc`, `current_class`, `leaving_reason`, `remarks`, `created_at`) VALUES
(1, '12345', 'babar wfsw', 'fajr', 'rat', '01-02-9333', 'ds', 'fsdsf', 'sds', 'dfsfd', 'dfd', '2025-07-16', '242342', 'adf', 'dgf', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '2025-07-17 23:14:15'),
(2, '1234', 'babar', 'fajr', 'rat', '01-02-9333', 'ds', 'fsdsf', 'sds', 'dfsfd', 'dfd', '2025-07-16', '242342', 'adf', 'dgf', 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', '2025-07-17 23:16:55');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activitie`
--
ALTER TABLE `activitie`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `admission_form`
--
ALTER TABLE `admission_form`
  ADD PRIMARY KEY (`aid`);

--
-- Indexes for table `fee_receipts`
--
ALTER TABLE `fee_receipts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `school_leaving_form`
--
ALTER TABLE `school_leaving_form`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activitie`
--
ALTER TABLE `activitie`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `admission_form`
--
ALTER TABLE `admission_form`
  MODIFY `aid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `fee_receipts`
--
ALTER TABLE `fee_receipts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `school_leaving_form`
--
ALTER TABLE `school_leaving_form`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
COMMIT;

