messdb.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

Database: `messdb`

-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `address` varchar(150) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `phone` varchar(10) NOT NULL,
  `password` varchar(30) CHARACTER SET utf8 NOT NULL,
  `photo` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

-- Table structure for table `dinningstatus`
--

CREATE TABLE IF NOT EXISTS `dinningstatus` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `studentid` varchar(10) NOT NULL,
  `current_status` varchar(100) NOT NULL,
  `updated_on` date NOT NULL,
  `month` varchar(100) NOT NULL,
  `no_of_days_present` int(100) NOT NULL,
  `no_of_days_absent` int(100) NOT NULL,
  `foodtype` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

-- Table structure for table `fees`
--

CREATE TABLE IF NOT EXISTS `fees` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `enrollno` varchar(100) NOT NULL,
  `no_of_days_present` int(20) NOT NULL,
  `per_day_cost` float NOT NULL,
  `additional_charges` float NOT NULL,
  `total_fees` int(11) NOT NULL,
  `month` int(200) NOT NULL,
  `fees_paid` float NOT NULL,
  `final_fees` int(200) NOT NULL,
  `dues` int(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;


-- Table structure for table `issueitem`
--

CREATE TABLE IF NOT EXISTS `issueitem` (
  `id` int(200) NOT NULL AUTO_INCREMENT,
  `itemid` int(200) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `quantity` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=67 ;


-- Table structure for table `item`
--

CREATE TABLE IF NOT EXISTS `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemname` varchar(200) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;

-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `day` varchar(10) CHARACTER SET utf8 NOT NULL,
  `breakfast` varchar(200) CHARACTER SET utf8 NOT NULL,
  `lunch` varchar(200) CHARACTER SET utf8 NOT NULL,
  `dinner` varchar(200) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- Table structure for table `purchaseitem`
--

CREATE TABLE IF NOT EXISTS `purchaseitem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `seller` varchar(60) CHARACTER SET utf8 NOT NULL,
  `itemid` varchar(2000) CHARACTER SET utf8 NOT NULL,
  `quantity` float NOT NULL,
  `qunit` varchar(10) CHARACTER SET utf8 NOT NULL,
  `rate` float NOT NULL,
  `runit` varchar(10) CHARACTER SET utf8 NOT NULL,
  `date` date NOT NULL,
  `total` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=99 ;


-- Table structure for table `seller`
--

CREATE TABLE IF NOT EXISTS `seller` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopname` varchar(30) CHARACTER SET utf8 NOT NULL,
  `contact` varchar(10) CHARACTER SET utf8 NOT NULL,
  `address` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- Table structure for table `stock`
--

CREATE TABLE IF NOT EXISTS `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemid` int(11) NOT NULL,
  `quantity` float NOT NULL,
  `qunit` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

-- Table structure for table `student`
--

CREATE TABLE IF NOT EXISTS `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 NOT NULL,
  `course` varchar(30) CHARACTER SET utf8 NOT NULL,
  `enroll` varchar(6) CHARACTER SET utf8 NOT NULL,
  `room` int(3) NOT NULL,
  `block` varchar(2) CHARACTER SET utf8 NOT NULL,
  `email` varchar(50) CHARACTER SET utf32 NOT NULL,
  `password` varchar(30) CHARACTER SET utf8 NOT NULL,
  `photo` varchar(200) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;