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

START TRANSACTION;



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

--
-- Table structure for table `apply`
--

CREATE TABLE `apply` (
  `ID` int(11) NOT NULL,
  `reg_id` int(22) NOT NULL,
  `campus` varchar(50) NOT NULL,
  `department` varchar(50) NOT NULL,
  `discipline` varchar(50) NOT NULL,
  `category` varchar(22) NOT NULL,
  `bank` varchar(50) NOT NULL,
  `reciptNumber` int(50) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `apply`
--

INSERT INTO `apply` (`ID`, `reg_id`, `campus`, `department`, `discipline`, `category`, `bank`, `reciptNumber`, `date`) VALUES
(5, 2, 'main', 'english', 'mcs', 'self', 'ret', 12232, '2022-06-19'),
(6, 3, 'main', 'cs', 'mcs', 'self', 'Khabir', 112, '2022-06-13'),
(7, 4, 'garden', 'cs', 'cs', 'open', 'Khayber', 2231, '2022-06-08'),
(8, 5, '', 'cs', 'cs', 'open', 'Khayber', 2231, '2022-06-30'),
(9, 9, 'garden', 'cs', 'cs', 'open', 'Khayber', 12232, '2022-08-19'),
(10, 9, 'main', 'cs', 'cs', 'self', 'Khayber', 2231, '2022-08-12');

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

--
-- Table structure for table `bs`
--

CREATE TABLE `bs` (
  `ID` int(11) NOT NULL,
  `rollno` int(50) NOT NULL,
  `date` date NOT NULL,
  `obtainemarks` int(50) NOT NULL,
  `totalmarks` int(50) NOT NULL,
  `board` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bs`
--

INSERT INTO `bs` (`ID`, `rollno`, `date`, `obtainemarks`, `totalmarks`, `board`) VALUES
(1, 7, '2022-06-02', 444, 800, 'Mardan'),
(2, 12, '2022-06-15', 517, 1100, 'mardan board'),
(3, 0, '0000-00-00', 0, 0, '');

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

--
-- Table structure for table `decipline`
--

CREATE TABLE `decipline` (
  `ID` int(44) NOT NULL,
  `decipline` varchar(44) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `decipline`
--

INSERT INTO `decipline` (`ID`, `decipline`) VALUES
(1, 'BS'),
(2, 'MS');

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `ID` int(22) NOT NULL,
  `depatments` varchar(22) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`ID`, `depatments`) VALUES
(1, 'Computer'),
(2, 'Physics'),
(3, 'Maths'),
(6, 'Bcom'),
(8, 'Botany'),
(10, 'BBA');

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

--
-- Table structure for table `fsc`
--

CREATE TABLE `fsc` (
  `ID` int(11) NOT NULL,
  `reg_id` int(22) NOT NULL,
  `rollno` int(50) NOT NULL,
  `date` date NOT NULL,
  `obtainemarks` int(50) NOT NULL,
  `totalmarks` int(50) NOT NULL,
  `board` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `fsc`
--

INSERT INTO `fsc` (`ID`, `reg_id`, `rollno`, `date`, `obtainemarks`, `totalmarks`, `board`) VALUES
(1, 0, 40, '2022-06-06', 500, 1100, 'peshwar'),
(2, 0, 12, '2022-06-15', 450, 1100, 'mardan board'),
(3, 0, 231, '2022-06-21', 844, 1100, 'Pehawar'),
(5, 3, 201, '2021-07-19', 232, 1100, 'Pehawar'),
(6, 4, 112, '2021-02-20', 765, 1100, 'Pehawar'),
(7, 2, 102, '2022-05-31', 232, 1100, 'Pehawar'),
(8, 5, 123, '2022-06-30', 841, 1100, 'Pehawar'),
(9, 9, 201, '2022-08-01', 844, 1100, 'Pehawar');

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

--
-- Table structure for table `matric`
--

CREATE TABLE `matric` (
  `ID` int(11) NOT NULL,
  `reg_id` int(22) NOT NULL,
  `rollno` int(50) NOT NULL,
  `date` date NOT NULL,
  `obtainemarks` int(20) NOT NULL,
  `totalmarks` int(20) NOT NULL,
  `board` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `matric`
--

INSERT INTO `matric` (`ID`, `reg_id`, `rollno`, `date`, `obtainemarks`, `totalmarks`, `board`) VALUES
(2, 0, 40, '2022-06-09', 517, 1100, 'peshwar'),
(3, 0, 22, '2022-06-24', 844, 1100, 'Pehawar'),
(4, 0, 0, '0000-00-00', 0, 0, ''),
(7, 3, 231, '2019-08-19', 844, 1100, 'Pehawar'),
(8, 4, 12, '2022-06-20', 844, 1100, 'Pehawar'),
(9, 2, 22, '2022-06-30', 844, 1100, 'Pehawar'),
(10, 5, 22, '2022-06-22', 844, 1100, 'Pehawar'),
(11, 9, 479, '2022-08-01', 844, 1100, 'Pehawar');

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

--
-- Table structure for table `personal`
--

CREATE TABLE `personal` (
  `ID` int(11) NOT NULL,
  `reg_id` int(11) NOT NULL,
  `image` varchar(50) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `nationality` varchar(30) NOT NULL,
  `cnic` int(50) NOT NULL,
  `fathername` varchar(50) NOT NULL,
  `fathercnic` int(50) NOT NULL,
  `dateofbirth` date NOT NULL,
  `domicile` varchar(50) NOT NULL,
  `religion` varchar(20) NOT NULL,
  `bloodgroup` varchar(5) NOT NULL,
  `gardiannumber` int(20) NOT NULL,
  `tempraryaddress` varchar(100) NOT NULL,
  `permanentaddress` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `personal`
--

INSERT INTO `personal` (`ID`, `reg_id`, `image`, `fname`, `lname`, `gender`, `nationality`, `cnic`, `fathername`, `fathercnic`, `dateofbirth`, `domicile`, `religion`, `bloodgroup`, `gardiannumber`, `tempraryaddress`, `permanentaddress`) VALUES
(13, 2, '1600652520_lemon iced tea.jpg', 'jUnaid2113', 'jklasdhf0900@', 'male', 'pak', 2147483647, 'asd', 2147483647, '2022-06-19', 'peshaejasldf', 'islam', 'b+', 9830294, 'Charsadda Road', 'pehsawar\r\n'),
(16, 3, 'bkuc.jpg', 'Hanif ', 'Noor', 'male', '', 2147483647, 'Rafiq', 2147483647, '2022-06-19', 'peshawar', 'islam', 'b+', 301012390, 'Charsadda Road', 'peshawar\r\n'),
(17, 4, '1122.jpg', 'Mudassir', 'Rahman', 'male', 'pak', 2147483647, 'khanzamn', 2147483647, '2022-06-20', 'peshawar', 'islam', 'b+', 301012390, 'Charsadda Road', 'Charsadda Road'),
(19, 9, 'Screenshot (17).png', 'abuzar', 'Khan', 'male', 'pak', 2147483647, 'khanzamn', 2147483647, '2022-08-23', 'peshawar', 'islam', 'b+', 0, 'Charsadda Road', 'Charsadda road\r\n'),
(24, 5, 'Screenshot (3).png', 'junaid jan', 'sdf', 'male', 'pak', 2147483647, 'anything', 2147483647, '2022-08-16', 'peshawar', 'islam', 'b+', 0, 'Charsadda Road', 'lkasj');

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

--
-- Table structure for table `upload_doc`
--

CREATE TABLE `upload_doc` (
  `ID` int(22) NOT NULL,
  `migeration_certificate` varchar(255) NOT NULL,
  `domicile` varchar(255) NOT NULL,
  `ssc_dmc` varchar(255) NOT NULL,
  `hssc_dmc` varchar(33) NOT NULL,
  `condidate_cnic` varchar(33) NOT NULL,
  `parent_cnic` varchar(33) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `upload_doc`
--

INSERT INTO `upload_doc` (`ID`, `migeration_certificate`, `domicile`, `ssc_dmc`, `hssc_dmc`, `condidate_cnic`, `parent_cnic`) VALUES
(1, '', '', '', '', '', ''),
(2, '', '', '', '', '', ''),
(3, '', '', '', '', '', ''),
(4, 'Screenshot (14).png', '', '', '', '', ''),
(5, '', '', '', '', '', ''),
(6, '', '', '', '', '', ''),
(7, '', '', '', '', '', ''),
(8, '', '', '', '', '', ''),
(9, '', '', '', '', '', ''),
(10, '', '', '', '', '', ''),
(11, '', '', '', '', '', '');

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

--
-- Table structure for table `validinfo`
--

CREATE TABLE `validinfo` (
  `ID` int(11) NOT NULL,
  `reg_id` int(22) NOT NULL,
  `Do you have any sibling currently studing at xyz` varchar(50) NOT NULL,
  `Have you studied at xyz before?` varchar(50) NOT NULL,
  `Are you currently employed?` varchar(50) NOT NULL,
  `Have you ever been dropped out from any program at xyz?` varchar(50) NOT NULL,
  `Have you ever been expelled from any institute?` varchar(50) NOT NULL,
  `Will you require on campus hostel facility?` varchar(50) NOT NULL,
  `Will you require xyz Transport?` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `validinfo`
--

INSERT INTO `validinfo` (`ID`, `reg_id`, `Do you have any sibling currently studing at xyz`, `Have you studied at xyz before?`, `Are you currently employed?`, `Have you ever been dropped out from any program at xyz?`, `Have you ever been expelled from any institute?`, `Will you require on campus hostel facility?`, `Will you require xyz Transport?`) VALUES
(1, 0, 'no', 'no', 'no', 'no', 'no', 'no', 'yes'),
(2, 0, 'yes', 'yes', 'no', 'no', 'no', 'no', 'yes'),
(3, 2, 'yes', 'yes', 'no', 'no', 'yes', 'no', 'yes'),
(4, 3, 'no', 'yes', 'yes', 'no', 'no', 'yes', 'yes'),
(5, 4, 'no', 'yes', 'no', 'yes', 'yes', 'yes', 'yes'),
(6, 5, 'yes', 'no', 'yes', 'yes', 'no', 'no', 'yes'),
(7, 9, 'yes', 'no', 'yes', 'no', 'no', 'no', 'yes'),
(8, 9, 'no', 'no', 'no', 'no', 'no', 'no', 'yes');

--
-- Indexes for table `apply`
--
ALTER TABLE `apply`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `bs`
--
ALTER TABLE `bs`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `decipline`
--
ALTER TABLE `decipline`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `fsc`
--
ALTER TABLE `fsc`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `matric`
--
ALTER TABLE `matric`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `personal`
--
ALTER TABLE `personal`
  ADD PRIMARY KEY (`ID`),
  ADD UNIQUE KEY `reg_id` (`reg_id`);

--
-- Indexes for table `upload_doc`
--
ALTER TABLE `upload_doc`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `validinfo`
--
ALTER TABLE `validinfo`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for table `apply`
--
ALTER TABLE `apply`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `bs`
--
ALTER TABLE `bs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `decipline`
--
ALTER TABLE `decipline`
  MODIFY `ID` int(44) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
  MODIFY `ID` int(22) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `fsc`
--
ALTER TABLE `fsc`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `matric`
--
ALTER TABLE `matric`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `personal`
--
ALTER TABLE `personal`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `upload_doc`
--
ALTER TABLE `upload_doc`
  MODIFY `ID` int(22) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `validinfo`
--
ALTER TABLE `validinfo`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

