--
-- Host: localhost    Database: hpycs
-- ------------------------------------------------------


--
-- Table structure for table `college`
--

CREATE TABLE `college` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password1` varchar(255) NOT NULL,
  `password2` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `dateadded` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `college`
--

INSERT INTO `college` VALUES (1,'test','test@test.com','098f6bcd4621d373cade4e832627b4f6','test','162.158.191.156','Tuesday, June 01, 2021 01:16:12 am.'),(2,'Tishtar Irani','tishirani692002@gmail.com','d8b36fa2ce602b7258ecaa289cf70aa1','angel1','162.158.191.170','Tuesday, June 01, 2021 10:40:42 am.'),(3,'Zahan','turelzahan10@gmail.com','dd4b21e9ef71e1291183a46b913ae6f2','00000000','162.158.165.20','Tuesday, June 01, 2021 10:40:25 am.'),(4,'Mahnaz','mahnaz.pestonjamasp@gmail.com ','9fe8593a8a330607d76796b35c64c600','678','162.158.191.156','Tuesday, June 01, 2021 10:40:28 am.'),(5,'Daryus  Master','daryusmaster@gmail.com','d868e95d851a2e344eebf6041e8c250a','master@2005','162.158.165.174','Tuesday, June 01, 2021 10:42:19 am.');

--
-- Table structure for table `entry1`
--

CREATE TABLE `entry1` (
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `ip` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `entry1`
--


--
-- Table structure for table `entry2`
--

CREATE TABLE `entry2` (
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `entry2`
--


--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password1` varchar(255) NOT NULL,
  `password2` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `students`
--



