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

START TRANSACTION;



--
-- Database: `cpplgmp_android_CollegeKatta`
--

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

--
-- Table structure for table `college_reg`
--

CREATE TABLE `college_reg` (
  `id` int NOT NULL,
  `c_name` varchar(20) NOT NULL DEFAULT ' ',
  `c_address` varchar(20) NOT NULL DEFAULT ' ',
  `c_pincode` varchar(20) NOT NULL DEFAULT ' ',
  `c_mono` varchar(20) NOT NULL DEFAULT ' ',
  `c_email` varchar(20) NOT NULL DEFAULT ' ',
  `c_password` varchar(20) NOT NULL DEFAULT ' ',
  `c_reenter_password` varchar(20) NOT NULL DEFAULT ' ',
  `category` varchar(20) NOT NULL DEFAULT ' '
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `college_reg`
--

INSERT INTO `college_reg` (`id`, `c_name`, `c_address`, `c_pincode`, `c_mono`, `c_email`, `c_password`, `c_reenter_password`, `category`) VALUES
(6, 'hh', 'hh', 'hh', 'hh', 'hh', 'hh', 'hh', 'Student'),
(7, 'gg', 'gg', 'gg', 'gg', 'gg', 'gg', 'gg', 'Teacher'),
(8, 'hh', 'kk', 'kk', 'kk', 'kk', 'kk', 'kk', 'College');

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

--
-- Table structure for table `registration`
--

CREATE TABLE `registration` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL DEFAULT ' ',
  `email` varchar(20) NOT NULL DEFAULT ' ',
  `password` varchar(20) NOT NULL DEFAULT ' ',
  `reenterPassword` varchar(20) NOT NULL DEFAULT ' ',
  `address` varchar(20) NOT NULL DEFAULT ' ',
  `pincode` varchar(20) NOT NULL DEFAULT ' ',
  `mob_No` varchar(20) NOT NULL DEFAULT ' ',
  `collegeName` varchar(20) NOT NULL DEFAULT ' ',
  `class` varchar(20) NOT NULL DEFAULT ' '
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`id`, `name`, `email`, `password`, `reenterPassword`, `address`, `pincode`, `mob_No`, `collegeName`, `class`) VALUES
(1, 'gg', 'gg', 'hh', 'hh', 'vv', 'gg', 'gh', 'gg', 'gh');

--
-- Indexes for dumped tables
--

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `college_reg`
--
ALTER TABLE `college_reg`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `registration`
--
ALTER TABLE `registration`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

