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




--
-- Database: `cegsite`
--

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

--
-- Table structure for table `staffnews`
--

CREATE TABLE `staffnews` (
  `id` int(5) NOT NULL,
  `link` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `studentnews`
--

CREATE TABLE `studentnews` (
  `id` int(5) NOT NULL,
  `link` varchar(250) NOT NULL,
  `value` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `thirukurals`
--

CREATE TABLE `thirukurals` (
  `id` int(4) NOT NULL,
  `t4` varchar(250) CHARACTER SET utf8 NOT NULL,
  `t3` varchar(250) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `thirukurals`
--

INSERT INTO `thirukurals` (`id`, `t4`, `t3`) VALUES
(1, 'அடகà¯கமà¯ அமரரà¯ளà¯ உயà¯கà¯கà¯மà¯ அடஙà¯காமை ', 'ஆரிரà¯ளà¯ உயà¯தà¯தà¯ விடà¯மà¯.'),
(2, 'காகà¯க பொரà¯ளா அடகà¯கதà¯தை ஆகà¯கமà¯ ', 'அதனினூஉஙà¯ கிலà¯லை உயிரà¯கà¯கà¯.'),
(3, 'செறிவறிநà¯தà¯ சீரà¯மை பயகà¯கà¯மà¯ அறிவறிநà¯தà¯ ', 'ஆறà¯றினà¯ அடஙà¯கபà¯ பெறினà¯.');

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

--
-- Table structure for table `thoughts`
--

CREATE TABLE `thoughts` (
  `id` int(5) NOT NULL,
  `thought` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `thirukurals`
--
ALTER TABLE `thirukurals`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `thirukural` (`t4`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `staffnews`
--
ALTER TABLE `staffnews`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `studentnews`
--
ALTER TABLE `studentnews`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `thirukurals`
--
ALTER TABLE `thirukurals`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `thoughts`
--
ALTER TABLE `thoughts`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
