-- http://www.phpmyadmin.net
--




--
-- Database: `nmcn`
--

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

--
-- Table structure for table `institution`
--

CREATE TABLE IF NOT EXISTS `institution` (
`i_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `status` varchar(15) NOT NULL,
  `date` date NOT NULL,
  `admission_quota` varchar(50) NOT NULL,
  `remark` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `institution`
--
ALTER TABLE `institution`
 ADD PRIMARY KEY (`i_id`), ADD UNIQUE KEY `name` (`name`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `institution`
--
ALTER TABLE `institution`
MODIFY `i_id` int(11) NOT NULL AUTO_INCREMENT;
