askceg.sql

-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 19, 2013 at 04:50 PM
-- Server version: 5.5.27
-- PHP Version: 5.4.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `askceg`
--

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

--
-- Table structure for table `ANSWER`
--

CREATE TABLE IF NOT EXISTS `ANSWER` (
  `a_id` int(20) NOT NULL AUTO_INCREMENT,
  `a_content` varchar(500) NOT NULL,
  `q_id` int(20) NOT NULL,
  `posted_by` int(20) NOT NULL,
  `scope` varchar(20) NOT NULL,
  `vote` int(20) NOT NULL,
  `timestamp` varchar(50) NOT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ;

--
-- Dumping data for table `ANSWER`
--

INSERT INTO `ANSWER` (`a_id`, `a_content`, `q_id`, `posted_by`, `scope`, `vote`, `timestamp`) VALUES
(1, 'cvcvcbvcv', 1, 2011103089, '', 0, '10:58 pm 02 Dec-12 '),
(2, 'hjhjgjghjj kghjgj gg gjhghjg', 1, 2011103089, '', 0, '10:58 pm 02 Dec-12 '),
(3, 'gdgdgdgdg!!!', 5, 2011103089, '', 0, '12:32 PM 11-Dec-12'),
(4, 'poda naaye\n\n', 1, 2011103089, '', 0, '07:47 PM 12-Dec-12'),
(5, 'dffdf', 1, 2011103089, '', 0, '11:20 AM 15-Dec-12'),
(6, 'fddgdg', 1, 2011103089, '', 0, '11:37 AM 15-Dec-12'),
(7, 'dgdgdgdgggdgd', 1, 2011103089, '', 0, '11:38 AM 15-Dec-12'),
(8, 'sgfsfsff', 3, 2011103090, '', 0, '11:53 AM 15-Dec-12'),
(9, 'sgxxsdgdwgd', 3, 2011103090, '', 0, '11:54 AM 15-Dec-12'),
(10, 'hhhfghghgh', 3, 2011103090, '', 0, '11:54 AM 15-Dec-12'),
(11, 'This is a pretty comprehensive summary of the startups by CEG alumni, although, could be a bit outdated. CEG Alumni Entrepreneur Network - 3rd slide.', 8, 2011103593, '', 0, '03:37 PM 15-Dec-12'),
(14, 'enaku purinjichu purinjichu purinjichu :P', 4, 2011103085, '', 0, '02:33 PM 17-Dec-12'),
(13, 'IIT', 8, 2011103089, '', 0, '10:50 PM 16-Dec-12'),
(15, 'Supercool :D', 10, 2011103090, '', 0, '10:54 PM 20-Dec-12'),
(16, 'ssfsfs', 3, 2011103089, '', 0, '04:57 PM 21-Dec-12'),
(17, 'ssfsfsd', 3, 2011103089, '', 0, '04:58 PM 21-Dec-12'),
(18, 'ssfsfsddfdf', 3, 2011103089, '', 0, '04:59 PM 21-Dec-12'),
(19, 'sfsfff\n', 3, 2011103089, '', 0, '05:00 PM 21-Dec-12'),
(20, 'donno', 4, 2011103089, '', 0, '07:48 PM 21-Dec-12'),
(21, 'dgdgd', 4, 2011103089, '', 0, '09:39 PM 21-Dec-12'),
(22, 'dgdgg\n', 2, 2011103089, '', 0, '10:08 PM 21-Dec-12'),
(23, 'i didnt even start yet...pls if anyone does complete..\nsend me a link to the h.w!!!', 31, 2011103089, '', 0, '02:21 AM 27-Dec-12'),
(25, 'here is the link to the program solutions\nhttps://accounts.google.com/ServiceLogin?service=mail&passive=true&rm=false&continue=http://mail.google.com/mail/&scc=1&ltmpl=default&ltmplcache=2\n', 31, 2011103085, '', 0, '02:23 AM 27-Dec-12'),
(26, 'i donno :P', 6, 2011103089, '', 0, '04:34 AM 27-Dec-12'),
(27, 'U shud promote the qs!', 38, 2011103089, '', 0, '05:06 AM 27-Dec-12'),
(28, 'hii', 23, 2011103089, '', 0, '05:15 AM 27-Dec-12'),
(29, 'it is lightweight!', 36, 2011103089, '', 0, '07:08 AM 27-Dec-12'),
(30, 'Views arent getting updated!', 35, 2011103089, '', 0, '03:49 AM 30-Dec-12'),
(31, 'Why is that?', 35, 2011103089, '', 0, '03:49 AM 30-Dec-12'),
(32, 'Ha ha ha!! :D', 35, 2011103089, '', 0, '03:49 AM 30-Dec-12'),
(33, 'i dint!', 31, 2011103089, '', 0, '03:50 AM 30-Dec-12'),
(34, 'server is slow!', 22, 2011103089, '', 0, '11:14 PM 30-Dec-12'),
(35, 'Why is that? 0.o', 22, 2011103089, '', 0, '11:45 PM 30-Dec-12'),
(36, 'asdasdasd', 22, 2011103089, '', 0, '11:46 PM 30-Dec-12'),
(37, 'sdsd sd sd', 22, 2011103089, '', 0, '12:26 AM 31-Dec-12'),
(38, 'adasdasdas', 42, 2011103089, '', 0, '02:00 AM 31-Dec-12'),
(39, 'I dont know!', 37, 2011103089, '', 0, '10:58 AM 06-Jan-13'),
(40, 'Anybody know?', 37, 2011103089, '', 0, '11:00 AM 06-Jan-13'),
(41, 'Haa', 31, 2011103089, '', 0, '11:32 PM 06-Jan-13'),
(42, 'Ha ha', 42, 2011103089, '', 0, '12:17 PM 09-Jan-13'),
(43, 'hehe', 42, 2011103089, '', 0, '03:41 PM 09-Jan-13'),
(44, 'hehe', 42, 2011103089, '', 0, '03:41 PM 09-Jan-13'),
(45, 'hehe', 42, 2011103089, '', 0, '03:41 PM 09-Jan-13'),
(46, 'hehe', 42, 2011103089, '', 0, '03:42 PM 09-Jan-13'),
(47, 'hee', 42, 2011103089, '', 0, '03:42 PM 09-Jan-13'),
(48, 'lol', 42, 2011103089, '', 0, '03:44 PM 09-Jan-13'),
(49, 'sfsdf \n', 42, 2011103089, '', 0, '03:44 PM 09-Jan-13'),
(50, 'sdffsdf', 42, 2011103089, '', 0, '03:44 PM 09-Jan-13'),
(51, 's', 42, 2011103089, '', 0, '04:25 PM 09-Jan-13'),
(52, 'asdasd', 42, 2011103089, '', 0, '04:25 PM 09-Jan-13'),
(53, 'sadsad', 42, 2011103089, '', 0, '04:26 PM 09-Jan-13'),
(72, '<p>dgdgdgdg<br></p>', 54, 2011103602, '', 0, '04:38 PM 28-Mar-13'),
(79, '<p>fsfsfsffsfsfsf</p>', 55, 2011103603, '', 0, '12:41 AM 29-Mar-13'),
(56, 'ssassa', 43, 2011103089, '', 0, '08:47 PM 09-Jan-13'),
(57, 'QQQ', 43, 2011103089, '', 0, '08:47 PM 09-Jan-13'),
(58, ':P', 40, 2011103053, '', 0, '06:36 PM 13-Jan-13'),
(59, 'QQWQ', 40, 2011103053, '', 0, '06:36 PM 13-Jan-13'),
(60, '!!', 22, 2011103053, '', 0, '07:10 PM 13-Jan-13'),
(61, '      ', 22, 2011103053, '', 0, '07:10 PM 13-Jan-13'),
(62, 'sdcscsdcsdc', 22, 2011103053, '', 0, '07:10 PM 13-Jan-13'),
(63, 'erre23edwcscscscs dc s ', 22, 2011103053, '', 0, '07:10 PM 13-Jan-13'),
(64, 'wasdsadasd asasd asd asdasd asdasaaa a', 45, 2011103089, '', 0, '07:25 PM 14-Jan-13'),
(65, 'qwqwqw12112 dfsdfsd  sdf sdf sdf dsfsd sd   sdf sd sdf sdfdfff', 22, 2011103089, '', 0, '07:45 PM 14-Jan-13'),
(66, 'khkkj\n', 3, 2011103602, '', 0, '01:16 AM 28-Mar-13'),
(67, '<p>patrick is modern sherlock!</p><p><br></p>', 55, 2011103602, '', 0, '04:30 AM 28-Mar-13'),
(68, '<p>sfsfsfssfsf</p><p>dddad</p><p>adadad<br></p>', 55, 2011103602, '', 0, '04:41 AM 28-Mar-13'),
(69, '<p>hello<br></p>', 54, 2011103602, '', 0, '04:28 PM 28-Mar-13'),
(70, 'gdgdgg', 54, 2011103602, '', 0, '04:28 PM 28-Mar-13'),
(71, 'wasup?', 54, 2011103602, '', 0, '04:28 PM 28-Mar-13'),
(73, '<p>dgdgdgdg<br></p>', 54, 2011103602, '', 0, '04:40 PM 28-Mar-13'),
(74, '<p>gdgdgggdg<br></p>', 55, 2011103089, '', 0, '05:10 PM 28-Mar-13'),
(75, '<p>gdgdgggdg<br></p>', 55, 2011103089, '', 0, '05:11 PM 28-Mar-13'),
(78, '<p>ffsfsf<br></p>', 55, 2011103089, '', 0, '06:15 PM 28-Mar-13'),
(77, 'sfffsfsff<br>sfsff<br><br><br><br>sfssfsf<br><br>fsfs<br>fs<br>f<br>f<br>s<br>f<br>f<br>s<br>s<br>f<br><br><br>s<br>fs<br>f<br>fsfffsfsfsssf<br>', 55, 2011103089, '', 0, '05:12 PM 28-Mar-13'),
(80, '<p>sffffff</p>', 55, 2011103603, '', 0, '03:20 AM 29-Mar-13'),
(81, '<p>sssffsfsf</p><p><br></p>', 9, 2011103603, '', 0, '04:40 AM 29-Mar-13'),
(82, '<p>u know?</p>', 4, 2011103599, '', 0, '06:52 PM 29-Mar-13'),
(83, '<p>AAA</p>', 54, 2, '', 0, '09:04 PM 30-Mar-13'),
(84, '<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><p>Haaaa</p></blockquote>', 54, 2, '', 0, '09:42 PM 30-Mar-13'),
(85, '<p>its differnt</p>', 60, 1, '', 0, '09:49 PM 30-Mar-13'),
(86, 'asdasdasd asdasdsad asdasdasd asdasd asdasdasd asdasdsad asdasdasd asdasd asd asda<p>asd</p><p>asd</p><p>asd</p><p>asd</p><p>asd</p><p>asdasd</p><p>asdas</p><p>&nbsp;asd asdasdas</p><p>as</p><p>asda</p><p>asd</p><p>asd</p><p>as</p><p>dasddasdasdasd asdasdsad asdasdasd asdasd asdasdasd asdasdsad asdasdasd asdasd asd asda<p>asd</p><p>asd</p><p>asd</p><p>asd</p><p>asd</p><p>asdasd</p><p>asdas</p><p>&nbsp;asd asdasdas</p><p>as</p><p>asda</p><p>asd</p><p>asd</p><p>as</p><p>dasddasdasdasd asdasdsad as', 60, 1, '', 0, '09:49 PM 30-Mar-13'),
(88, '<p>asasas</p><p><br></p>', 65, 1, '', 0, '09:57 PM 30-Mar-13'),
(89, '<p>vhvhghghgh</p><p>hgfhfhf</p><p>ggdgdg</p>', 65, 1, '', 0, '09:58 PM 30-Mar-13'),
(90, '<p>dasdasdsd</p>', 45, 1, '', 0, '10:32 PM 30-Mar-13'),
(91, '<p>aSAsaSA</p><p>aSAs</p>', 45, 1, '', 0, '10:33 PM 30-Mar-13'),
(92, 'ASsASsSAsSAs', 45, 1, '', 0, '10:33 PM 30-Mar-13'),
(93, '<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;">qweewqweqwe</blockquote>', 45, 1, '', 0, '10:33 PM 30-Mar-13'),
(94, 'qweqweqe', 45, 1, '', 0, '10:33 PM 30-Mar-13'),
(95, '<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><p>donna</p></blockquote>', 66, 1, '', 0, '06:00 AM 31-Mar-13'),
(96, '<p>:p</p>', 66, 1, '', 0, '06:00 AM 31-Mar-13'),
(97, '<p>asdasd</p>', 66, 1, '', 0, '06:01 AM 31-Mar-13'),
(98, '<p>asdasdd</p>', 65, 0, '', 0, '1364768742'),
(99, '<p>www</p>', 65, 0, '', 0, '1364768754'),
(100, '<p>qweqwewqe</p>', 65, 0, '', 0, '1364768771'),
(101, '<p>awsdasdasd</p>', 65, 0, '', 0, '1364768790'),
(102, '<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><p>AAA</p></blockquote>', 57, 1, '', 0, '1364773074'),
(103, '<p>erfervwr we we rwerwe rwr wrwer&nbsp;</p>', 57, 1, '', 0, '1364773089'),
(104, '<blockquote style="margin: 0 0 0 40px; border: none; padding: 0px;"><p>asass</p></blockquote>', 64, 3, '', 0, '1364820674'),
(105, '<p>cbcbcbcb</p>', 68, 2011103089, '', 0, '1366373240'),
(106, '<p>cbcbcbcb</p>', 68, 2011103089, '', 0, '1366373240'),
(107, '<p>vvvxvxvx</p>', 68, 2011103089, '', 0, '1366373271'),
(108, '<p>sfsfsf</p>', 68, 2011103089, '', 0, '1366373384'),
(109, '<p>fsfssfss</p>', 68, 2011103089, '', 0, '1366373547'),
(110, '<p>dggggdg</p>', 68, 2011103089, '', 0, '1366374787'),
(111, '<p>dgdgdgd</p>', 68, 2011103089, '', 0, '1366374953'),
(112, '<p>bcbcbb</p>', 24, 2011103089, '', 0, '1366374991'),
(113, '<p>ffsffsf</p>', 68, 2011103089, '', 0, '1366375147'),
(114, '<p>dggdgdgd</p>', 68, 2011103089, '', 0, '1366375177'),
(115, '<p>vbbccb</p>', 68, 2011103089, '', 0, '1366375195'),
(116, '<p>fsfsffsff</p>', 68, 3, '', 0, '1366375427'),
(117, '<p>sfsffsff</p>', 68, 3, '', 0, '1366375717'),
(118, 'fdfssfs', 68, 3, '', 0, '1366375812'),
(119, 'fsffssf', 68, 3, '', 0, '1366375956'),
(120, 'fsffssf', 68, 3, '', 0, '1366376108'),
(121, '<p>sfsffs</p>', 68, 3, '', 0, '1366376122'),
(122, '<p>vvvxvv</p>', 68, 3, '', 0, '1366376154'),
(123, '<p>dgdggdgg</p>', 68, 3, '', 0, '1366376196'),
(124, 'dvdgdg', 68, 3, '', 0, '1366376466'),
(125, '<p>testinh</p>', 68, 3, '', 0, '1366376608'),
(126, '<p>hello intiATION<br></p>', 60, 4, '', 0, '1366382197'),
(127, '<p>hello intiATION<br></p>', 60, 4, '', 0, '1366382272'),
(128, '<p>hello intiATION<br></p>', 60, 4, '', 0, '1366382272'),
(129, '<p>hello intiATION<br></p>', 60, 4, '', 0, '1366382283'),
(130, '<p>hello intiATION<br></p>', 60, 4, '', 0, '1366382344'),
(131, '<p>hello intiATION<br></p>', 60, 4, '', 0, '1366382620');

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

--
-- Table structure for table `CATEGORY`
--

CREATE TABLE IF NOT EXISTS `CATEGORY` (
  `category_id` int(20) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(50) NOT NULL,
  `category_desc` varchar(500) NOT NULL,
  `category_url` varchar(50) NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `CATEGORY`
--

INSERT INTO `CATEGORY` (`category_id`, `category_name`, `category_desc`, `category_url`) VALUES
(1, 'CSE', 'this is the official askceg page for CSE department.post your questions here for cse teachers and fellow CSE students \nto answer', 'cse'),
(2, 'ECE', 'this is the official askceg page for ECE department.post your questions here for ECE teachers and fellow ECE students \r\nto answer', 'ece'),
(3, 'MECHANICAL ENGINEERING', 'this is the official askceg page for mechanical department.post your questions here for Mech teachers and fellow Mech students  to answer', 'mechanical-engineering'),
(4, 'CIVIL ENGINEERING', 'this is the official askceg page for civil department.post your questions here for civil teachers and fellow civil students  to answer', 'civil-engineering'),
(5, 'EEE', 'this is the official askceg page for EEE department.post your questions here for EEE teachers and fellow EEE students  to answer', 'eee'),
(6, 'MISCELLANEOUS', 'Discuss with your fellow CEGians about any miscellaneous subjects!!', 'miscellaneous'),
(7, 'CLUBS/ORGANIZATION', 'Start an AskCEG page for clubs and organizations in CEG and get volunteers ,post your queries and share your interests', 'clubs-organization'),
(8, 'EVENTS', 'Start an AskCEG page for department symposiums, college events,etc and get volunteers ,post your queries and get answers from fellow CEGIANS', 'events'),
(9, 'IT', 'this is the official askceg page for IT department.post your questions here for IT teachers and fellow IT students  to answer', 'IT');

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

--
-- Table structure for table `dummy`
--

CREATE TABLE IF NOT EXISTS `dummy` (
  `id` int(50) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dummy`
--

INSERT INTO `dummy` (`id`, `name`) VALUES
(1, 'vishnu'),
(2, 'anto'),
(1, 'vvv'),
(1, 'vvv'),
(1, 'vvv'),
(1, 'vvv'),
(1, 'vvv');

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

--
-- Table structure for table `FB_DETAILS`
--

CREATE TABLE IF NOT EXISTS `FB_DETAILS` (
  `email` varchar(100) NOT NULL,
  `fb_user_id` varchar(100) NOT NULL,
  `access_token` varchar(200) NOT NULL,
  `seqid` bigint(11) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`seqid`),
  UNIQUE KEY `fb_user_id` (`fb_user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `FB_DETAILS`
--

INSERT INTO `FB_DETAILS` (`email`, `fb_user_id`, `access_token`, `seqid`, `timestamp`, `status`) VALUES
('dgr8geek@gmail.com', '100000673452300', 'BAAEeCZC9qCvUBABxot8IIQJaqpgZAnfzpoqLfFgtQAqVFfZCbxSZAEVfwZBm50aeFVJfNogf3wEIXR3Guj6JtmcIqZBAnFUHmawzzp2Xprymhky1PptKq3ZBCNgtjyCRlVa18Ha6XafdumZA1N1PYSvesBsoqRnWJUZCeZASJB3AdgqZCsKwiN0XjZAXPZAS9YWV69z', 5, '2013-04-01 13:06:50', 1),
('vigneshjayavel@gmail.com', '100005637937154', 'AAAEeCZC9qCvUBADh2YCTHRMPGHMd3G4QuHsDWHnI2sfzS13JKQ8WpCVcZAaqhRDEoPfVvJ8Tu1FCKfpDmGw1MhwYeOL85d3oRgslZAthp5ug0ZAypZBwX', 9, '2013-04-01 16:03:12', 1),
('vigneshjmsc@gmail.com', '100003324675095', 'AAAEeCZC9qCvUBAM17iVfs9jBME6Y7D8m3fMMNHHcnfxOxnuZBvmvywZBQZBDuIBbrBCzegNwU2igcMewLHNhZBNytVVfcw1St61scUl1hd1dSH89RRRtw', 8, '2013-04-01 13:30:14', 1),
('vishnuj81093@gmail.com', '100002276456345', 'BAAEeCZC9qCvUBAEvMnIYyxmbwnZCKAT0nsiI3oce34w0DhQ78OHIuDe2SyI6ZCcfe6iZA9HfQBZAnrEvmyhOVV83EYhtLOQXJUgY9BIVBnPvS8vLo1y3WvdyK4HkmZBYIr20inEYIRGNTLZAxKxZBYkT20JC9J0kWYKKa6pu2xz254z95RODrfuBgQc2BpEXkAtsgW6', 10, '2013-04-19 11:41:20', 1);

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

--
-- Table structure for table `FOLLOWERS`
--

CREATE TABLE IF NOT EXISTS `FOLLOWERS` (
  `q_id` int(20) NOT NULL,
  `user_id` int(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FOLLOWERS`
--

INSERT INTO `FOLLOWERS` (`q_id`, `user_id`) VALUES
(1, 2011103090),
(2, 2011103051),
(2, 2011103090),
(1, 2011103089),
(31, 2011103085),
(1, 2011103089),
(15, 2011103089),
(4, 2011103085),
(11, 2011103090),
(10, 2011103090),
(3, 2011103089),
(4, 2011103089),
(14, 2011103089),
(38, 2011103089),
(36, 2011103089),
(42, 2011103089),
(31, 2011103089),
(10, 2011103089),
(35, 2011103089),
(39, 2011103089),
(33, 2011103089),
(43, 2011103089),
(32, 2011103089),
(34, 2011103089),
(30, 2011103089),
(44, 2011103089),
(2, 2011103089),
(46, 2011103089),
(40, 2011103089),
(24, 2011103089),
(18, 2011103089),
(22, 2011103089),
(52, 2011103089),
(54, 2011103597),
(55, 2011103600),
(54, 2011103600),
(53, 2011103600),
(55, 2011103089),
(55, 2011103603),
(58, 2011103089),
(53, 1),
(4, 2),
(65, 2),
(2, 1),
(49, 1),
(18, 1),
(47, 1),
(54, 1),
(65, 1),
(63, 1),
(14, 8),
(43, 1),
(11, 1),
(27, 1),
(26, 1),
(66, 1),
(45, 1),
(40, 1),
(24, 1),
(5, 1),
(10, 1),
(33, 1),
(20, 1),
(65, 8),
(61, 8),
(64, 8),
(63, 8),
(62, 8),
(57, 8),
(53, 8),
(29, 8),
(22, 8),
(7, 8),
(51, 8),
(37, 8),
(26, 8),
(25, 8),
(57, 1),
(62, 1);

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

--
-- Table structure for table `GROUPS`
--

CREATE TABLE IF NOT EXISTS `GROUPS` (
  `group_id` int(20) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(50) NOT NULL,
  `group_desc` text NOT NULL,
  `group_level` varchar(20) NOT NULL,
  `department_id` int(20) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

--
-- Dumping data for table `GROUPS`
--

INSERT INTO `GROUPS` (`group_id`, `group_name`, `group_desc`, `group_level`, `department_id`) VALUES
(32, 'CIVIL  batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 4),
(8, 'ECE AB batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(9, 'ECE AB batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(10, 'ECE AB batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(11, 'ECE AB batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(12, 'ECE CD batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(13, 'ECE CD batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(14, 'ECE CD batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(15, 'ECE CD batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(16, 'ECE EF batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(17, 'ECE EF batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(18, 'ECE EF batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(19, 'ECE EF batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 2),
(20, 'CSE G batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(21, 'CSE G batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(22, 'CSE G batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(23, 'CSE G batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(24, 'CSE H batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(25, 'CSE H batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(26, 'CSE H batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(27, 'CSE H batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(28, 'CSE I batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(29, 'CSE I batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(30, 'CSE I batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(31, 'CSE I batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 1),
(33, 'CIVIL  batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 4),
(34, 'CIVIL  batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 4),
(35, 'CIVIL  batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 4),
(36, 'MECHANICAL AB batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(37, 'MECHANICAL AB batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(38, 'MECHANICAL AB batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(39, 'MECHANICAL AB batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(40, 'MECHANICAL CD batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(41, 'MECHANICAL CD batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(42, 'MECHANICAL CD batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(43, 'MECHANICAL CD batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 3),
(44, 'EEE  batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 5),
(45, 'EEE  batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 5),
(46, 'EEE  batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 5),
(47, 'EEE  batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 5),
(48, 'IT G batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(49, 'IT G batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(50, 'IT G batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(51, 'IT G batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(52, 'IT H batch 2009-2013', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(53, 'IT H batch 2010-2014', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(54, 'IT H batch 2011-2015', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9),
(55, 'IT H batch 2012-2016', 'Here you can discuss about all happenings in your class and to make it private select the private scope(vi\n      sible only to your batch mates) when creating a post/question', '', 9);

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

--
-- Table structure for table `GROUP_REQUEST`
--

CREATE TABLE IF NOT EXISTS `GROUP_REQUEST` (
  `user_id` int(20) NOT NULL,
  `group_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `GROUP_REQUEST`
--

INSERT INTO `GROUP_REQUEST` (`user_id`, `group_id`) VALUES
(2011103602, 1);

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

--
-- Table structure for table `NOTIFICATIONS`
--

CREATE TABLE IF NOT EXISTS `NOTIFICATIONS` (
  `notif_id` bigint(10) NOT NULL AUTO_INCREMENT,
  `receiver_type` varchar(100) NOT NULL,
  `receiver_id` varchar(100) NOT NULL,
  `notif_msg` varchar(1000) NOT NULL,
  `timestamp` varchar(100) NOT NULL,
  `initiator_id` int(10) NOT NULL,
  PRIMARY KEY (`notif_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=47 ;

--
-- Dumping data for table `NOTIFICATIONS`
--

INSERT INTO `NOTIFICATIONS` (`notif_id`, `receiver_type`, `receiver_id`, `notif_msg`, `timestamp`, `initiator_id`) VALUES
(33, 'u', '2', 'Narain followed you!', '1366380140', 0),
(34, 't', '2', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/">testing notif?...</a> in the topic <a href="">ibatch</a></b>', '1366380217', 0),
(35, 't', '4', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/">hello group?...</a> in the topic <a href="">Movies</a></b>', '1366380993', 0),
(36, 'g', '9', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/">hello group?...</a> in the topic <a href="">Movies</a></b>', '1366380993', 0),
(37, 't', '3', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/dsadad">dsadad...</a> in the topic <a href="">ibatch boys</a></b>', '1366381152', 0),
(38, 'g', '9', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/dsadad">dsadad...</a> in the topic <a href="">ibatch boys</a></b>', '1366381152', 0),
(39, 't', '3', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/zczczc-group-testing">zczczc group testing...</a> in the topic <a href="">ibatch boys</a></b>', '1366381215', 0),
(40, 'g', '9', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/zczczc-group-testing">zczczc group testing...</a> in the topic <a href="">ibatch boys</a></b>', '1366381215', 0),
(41, 't', '3', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/fsffffsf">fsffffsf...</a> in the topic <a href="">ibatch boys</a></b>', '1366381272', 0),
(42, 't', '4', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/group">group?...</a> in the topic <a href="http://vikki.askceg.ap01.aws.af.cm/ask/ProfileController/viewTopic/Movies">Movies</a></b>', '1366381486', 0),
(43, 'g', '9', 'Jetti asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/group">group?...</a> in the topic <a href="http://vikki.askceg.ap01.aws.af.cm/ask/ProfileController/viewTopic/Movies">Movies</a></b>', '1366381486', 0),
(44, 'u', '2', 'Narain answered your question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/how-is-askceg-different">how is askceg different?</a></b>', '1366382620', 4),
(45, 'u', '2', 'Narain followed you!', '1366382670', 4),
(46, 't', '2', 'Narain asked a question <b><a href="http://vikki.askceg.ap01.aws.af.cm/ask/AnswersController/viewAnswersForQuestion/testing-notif-now">testing notif now?\n...</a> in the topic <a href="http://vikki.askceg.ap01.aws.af.cm/ask/ProfileController/viewTopic/ibatch">ibatch</a></b>', '1366382915', 4);

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

--
-- Table structure for table `PROMOTE`
--

CREATE TABLE IF NOT EXISTS `PROMOTE` (
  `q_id` int(20) NOT NULL,
  `category_id` int(20) NOT NULL,
  `timestamp` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `QUESTION`
--

CREATE TABLE IF NOT EXISTS `QUESTION` (
  `q_id` int(10) NOT NULL AUTO_INCREMENT,
  `q_content` varchar(500) NOT NULL,
  `topic_id` int(10) NOT NULL,
  `posted_by` int(20) NOT NULL,
  `scope` int(20) NOT NULL,
  `timestamp` varchar(20) NOT NULL,
  `q_description` text NOT NULL,
  `views` int(20) NOT NULL,
  `followers` int(20) NOT NULL,
  `url` varchar(400) NOT NULL,
  `anonymous` int(20) NOT NULL,
  PRIMARY KEY (`q_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=79 ;

--
-- Dumping data for table `QUESTION`
--

INSERT INTO `QUESTION` (`q_id`, `q_content`, `topic_id`, `posted_by`, `scope`, `timestamp`, `q_description`, `views`, `followers`, `url`, `anonymous`) VALUES
(2, 'asdasd', 1, 2011103089, 0, '1364729876', 'asdasdasd', 5, 0, 'asdasd', 0),
(3, 'who is obama?', 1, 2011103090, 10, '1364729876', '', 27, 0, 'who-is-obama', 0),
(4, 'what is the rate of iphone 5?', 1, 2011103090, 0, '1364729876', '', 17, 0, 'what-is-the-rate-of-iphone-5', 0),
(5, 'GJHGJ??', 1, 2011103090, 0, '1364729876', 'DDDCD', 3, 0, 'GJHGJ', 0),
(6, 'What is Askceg?', 1, 2011103090, 0, '1364729876', '', 2, 0, 'What-is-Askceg', 0),
(7, 'sdsdsdd', 1, 2011103090, 0, '1364729876', '', 0, 0, 'sdsdsdd', 0),
(9, 'When is college reopening??', 1, 2011103089, 3, '1364729876', 'I dont want it to reopen at all!!! :P', 3, 0, 'When-is-college-reopening', 0),
(10, 'How cool is AskCEG? :D', 1, 2011103053, 0, '1364729876', '', 5, 0, 'How-cool-is-AskCEG-D', 0),
(11, 'ghikjfkjrf', 2, 2011103090, 0, '1364729876', '', 0, 0, 'ghikjfkjrf', 0),
(12, 'hey boys ?', 2, 2011103090, 0, '1364729876', '', 0, 0, 'hey-boys', 0),
(14, 'who is obama?', 1, 2011103089, 0, '1364729876', '', 0, 0, 'who-is-obama-1356110311', 0),
(15, 'who is obama?', 1, 2011103089, 0, '1364729876', '', 0, 0, 'who-is-obama-1356110408', 0),
(16, 'how u doing?', 3, 2011103089, 0, '1364729876', '', 0, 0, 'how-u-doing', 0),
(17, 'when is k13?', 5, 2011103089, 0, '1364729876', '', 0, 0, 'when-is-k13', 0),
(18, 'sfsfsff', 1, 2011103085, 0, '1364729876', '', 0, 0, 'sfsfsff', 0),
(20, 'dgdgg', 4, 2011103085, 0, '1364729876', '', 0, 0, 'dgdgg', 0),
(21, 'who is going to take webtech?', 2, 0, 0, '1364729876', '', 0, 0, 'who-is-going-to-take-webtech', 1),
(22, 'why is acoe website slow?', 3, 2011103089, 0, '1364729876', '', 4, 0, 'why-is-acoe-website-slow', 1),
(23, 'heeeeeey!!', 5, 604, 0, '1364729876', '', 0, 0, 'heeeeeey', 0),
(24, 'testing :D ????', 1, 2011103051, 0, '1364729876', '', 2, 0, 'testing', 0),
(25, 'testing radio button', 6, 2011103089, 0, '1364729876', '', 0, 0, 'testing-radio-button', 0),
(26, 'harry potter?', 4, 2011103089, 0, '1364729876', '', 0, 0, 'harry-potter', 0),
(27, 'qwert!', 5, 2011103089, 0, '1364729876', '', 0, 0, 'qwert', 0),
(28, 'svfvzsvzc', 6, 2011103089, 0, '1364729876', '', 0, 0, 'svfvzsvzc', 0),
(29, 'sss', 6, 2011103089, 0, '1364729876', '', 0, 0, 'sss', 0),
(30, 'is 4th sem easy?', 1, 2011103090, 1, '1364729876', '', 0, 0, 'is-4th-sem-easy', 0),
(31, 'did anyone complete the lab work?', 9, 2011103002, 1, '1364729876', '', 0, 0, 'checking-group-scope', 0),
(32, 'dsdggg', 1, 2011103089, 1, '1364729876', '', 0, 0, 'dsdggg', 0),
(33, 'fsfssfsf', 6, 2011103089, 0, '1364729876', '', 0, 0, 'fsfssfsf', 0),
(34, 'hello', 4, 2011103089, 0, '1364729876', '', 0, 0, 'hello', 0),
(35, 'from a fourth semester perspective,what are the subjects that we should be conceptually strong at for better future prospects or for future studies?\n', 7, 2011103089, 0, '1364729876', '', 0, 0, 'from-a-fourth-semester-perspective-what-are-the-subjects-that-we-should-be-conceptually-strong-at-for-better-future-prospects-or-for-future-studies', 0),
(42, '!@#$!^!@%!^@!&!!!', 1, 2011103089, 0, '1364729876', '', 0, 0, '-1356899351', 0),
(43, 'How can I learn coding?', 1, 2011103089, 0, '1364729876', '', 0, 0, 'How-can-I-learn-coding', 0),
(37, ' How to handle StackOverflowError in Java?', 9, 2011103089, 0, '1364729876', '', 0, 0, 'How-to-handle-StackOverflowError-in-Java', 0),
(38, '\nObjective-C/iOS vs Java - Career Prospects ? (A non-technical queries, well mostly)', 9, 2011103089, 0, '1364729876', '', 0, 0, '0-votes-0answers-18-views-Objective-C-iOS-vs-Java-Career-Prospects-A-non-technical-queries-well-mostly', 0),
(39, 'asdad', 5, 2011103089, 0, '1364729876', '', 0, 0, 'asdad', 0),
(40, 'why this kolaveri de?', 1, 2011103089, 0, '1364729876', '', 0, 0, 'why-this-kolaveri-de', 1),
(41, '********', 2, 2011103089, 0, '1364729876', '', 0, 0, '', 0),
(44, 'will this be private??', 3, 2011103089, 1, '1364729876', '', 0, 0, 'will-this-be-private', 0),
(45, 'sdfdfs sf sdfk jskdjfkj ksjdfkjkjksdfkjs ksjdkfjsdkjfksdjfk sdfjksdjfkjsdkf dsjfkjksdjfksjdkf skdf sdkfjsdkfjsdklfjsdkl jsdfk jsdklfj dkfjdfklgjskldfgjklsjgkj dflkgj jsdlkfg jkjjllkdjglkjdgkljslkdfjglksdfjg sdflgkjierti ierjtkljekltjkljekltj jekltj ekltjrekttetogtriogtrjiriyoiroy6i6yjiyjiyjyijyijyijyijyvjyjvyiyjiyjiyyijyijyij945 945i 945o opeioertioer erti ldfkvl kldfklv;kdflvk dlf;vk kldfv lkdf;vk;l l; ldfvl;kdfl;vkldfvkfldkvldfkvl dfvkldfkvldfvk;d erit0iertp dflgk ldfgklsdfdfs sf sdfk jskdjfkj', 8, 2011103089, 0, '1364729876', '', 4, 0, 'sdfdfs-sf-sdfk-jskdjfkj-ksjdfkjkjksdfkjs-ksjdkfjsdkjfksdjfk-sdfjksdjfkjsdkf-dsjfkjksdjfksjdkf-skdf-sdkfjsdkfjsdklfjsdkl-jsdfk-jsdklfj-dkfjdfklgjskldfgjklsjgkj-dflkgj-jsdlkfg-jkjjllkdjglkjdgkljslkdfjglksdfjg-sdflgkjierti-ierjtkljekltjkljekltj-jekltj-ekltjrekttetogtriogtrjiriyoiroy6i6yjiyjiyjyijyijyijyijyvjyjvyiyjiyjiyyijyijyij945-945i-945o-opeioertioer-erti-ldfkvl-kldfklv-kdflvk-dlf-vk-kldfv-lkdf-v', 0),
(46, 'asasas!', 4, 2011103089, 1, '1364729876', '', 0, 0, 'asasas', 0),
(47, 'fdggdf', 4, 2011103089, 0, '1364729876', 'dfgfdgdfgfdg', 0, 0, 'fdggdf', 0),
(48, 'new??', 4, 2011103089, 0, '1364729876', '', 0, 0, 'new', 0),
(49, 'sadadsd', 4, 2011103089, 0, '1364729876', '', 0, 0, 'sadadsd', 0),
(50, 'gjhghjgh', 4, 2011103089, 0, '1364729876', '', 0, 0, 'gjhghjgh', 0),
(51, 'erertet', 4, 2011103089, 0, '1364729876', '', 0, 0, 'erertet', 0),
(52, 'fwefwef vwe wer wer wer ', 9, 2011103089, 0, '1364729876', '', 0, 0, 'fwefwef-vwe-wer-wer-wer', 0),
(53, 'qwqw!', 9, 2011103089, 0, '1364729876', '', 0, 0, 'qwqw', 0),
(54, 'why do I need askCeg?', 1, 2011103597, 0, '1364729876', '', 23, 0, 'why-do-I-need-askCeg', 0),
(55, 'How is mentalist diff from sherlocks?', 1, 2011103600, 0, '1364729876', '', 0, 0, 'How-is-mentalist-diff-from-sherlocks', 0),
(57, 'heeeeeeeeello?', 4, 2011103602, 0, '1364729876', '', 5, 0, 'heeeeeeeeello', 0),
(58, 'ggggg', 4, 2011103089, 1, '1364729876', '', 0, 0, 'ggggg', 1),
(59, 'how is kd billa?', 11, 2011103599, 0, '1364729876', '', 0, 0, 'how-is-kd-billa', 0),
(60, 'how is askceg different?', 12, 2, 0, '1364729876', '', 13, 0, 'how-is-askceg-different', 0),
(61, 'zzx', 1, 2, 0, '1364729876', '', 3, 0, 'zzx', 0),
(62, 'aSAsASAsAS', 5, 2, 0, '1364729876', '', 1, 0, 'aSAsASAsAS', 0),
(63, 'asasdasd', 1, 2, 0, '1364729876', '', 1, 0, 'asasdasd', 0),
(64, 'sdasdsadadasad', 3, 2, 0, '1364729876', '', 4, 0, 'sdasdsadadasad', 0),
(65, 'zsdasd', 5, 2, 0, '1364729876', '', 21, 0, 'zsdasd', 0),
(68, 'Testing??', 1, 2, 0, '1366373166', 'Testing question', 20, 0, 'Testing-1366373166', 0),
(69, 'hello topic notification', 2, 3, 0, '1366378621', '', 0, 0, 'hello-topic-notification', 0),
(70, 'hello topic testing 2', 2, 3, 0, '1366379319', '', 0, 0, 'hello-topic-testing-2', 0),
(71, 'fsfsfsff', 2, 3, 0, '1366379477', '', 0, 0, 'fsfsfsff', 0),
(72, 'testing notif?', 2, 2, 0, '1366380217', '', 0, 0, 'testing-notif', 0),
(73, 'hello group?', 4, 2, 9, '1366380993', '', 0, 0, 'hello-group', 0),
(74, 'dsadad', 3, 2, 9, '1366381152', '', 0, 0, 'dsadad', 0),
(75, 'zczczc group testing?', 3, 2, 9, '1366381215', '', 0, 0, 'zczczc-group-testing', 0),
(76, 'fsffffsf', 3, 2, 0, '1366381272', '', 0, 0, 'fsffffsf', 0),
(77, 'group?', 4, 2, 9, '1366381486', '', 1, 0, 'group', 0),
(78, 'testing notif now?\n', 2, 4, 0, '1366382915', '\n\n', 1, 0, 'testing-notif-now', 0);

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

--
-- Table structure for table `QUESTION_POST_TO_TEACHER`
--

CREATE TABLE IF NOT EXISTS `QUESTION_POST_TO_TEACHER` (
  `q_id` int(20) NOT NULL,
  `user_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `REQUEST_USER`
--

CREATE TABLE IF NOT EXISTS `REQUEST_USER` (
  `user_id` int(20) NOT NULL,
  `request_id` int(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) NOT NULL,
  `group_id` int(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `user_level` int(20) NOT NULL DEFAULT '0',
  `email_id` varchar(20) NOT NULL,
  `user_year` int(11) NOT NULL,
  `user_degree` varchar(20) NOT NULL,
  `user_course` varchar(20) NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

--
-- Dumping data for table `REQUEST_USER`
--

INSERT INTO `REQUEST_USER` (`user_id`, `request_id`, `user_name`, `group_id`, `password`, `user_level`, `email_id`, `user_year`, `user_degree`, `user_course`) VALUES
(0, 33, 'hjkhhk', 1, '', 0, '', 2, '', '');

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

--
-- Table structure for table `TEACHER_DETAILS`
--

CREATE TABLE IF NOT EXISTS `TEACHER_DETAILS` (
  `user_id` int(20) NOT NULL,
  `graduated_at` varchar(200) NOT NULL,
  `field_of_interest` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TEACHER_DETAILS`
--

INSERT INTO `TEACHER_DETAILS` (`user_id`, `graduated_at`, `field_of_interest`) VALUES
(604, 'MTF college', '');

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

--
-- Table structure for table `TOPIC`
--

CREATE TABLE IF NOT EXISTS `TOPIC` (
  `topic_id` int(20) NOT NULL AUTO_INCREMENT,
  `topic_name` varchar(50) NOT NULL,
  `topic_desc` text NOT NULL,
  `posted_by` int(50) NOT NULL,
  `category_id` int(20) NOT NULL,
  `timestamp` varchar(50) NOT NULL,
  `topic_url` varchar(200) NOT NULL,
  PRIMARY KEY (`topic_id`),
  UNIQUE KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `TOPIC`
--

INSERT INTO `TOPIC` (`topic_id`, `topic_name`, `topic_desc`, `posted_by`, `category_id`, `timestamp`, `topic_url`) VALUES
(1, 'computer', '0', 2011103090, 1, '12-10-12', 'computer'),
(2, 'ibatch', '0', 2011103603, 5, '', 'ibatch'),
(3, 'ibatch boys', '0', 0, 1, '', 'ibatch-boys'),
(4, 'Movies', 'Contains all questions about movies!', 2011103090, 2, '', 'Movies'),
(5, 'battle of brains', '', 0, 3, '', 'battle-of-brains'),
(6, 'iphone is cool', '', 604, 4, '09:11 PM 23-Dec-12', 'iphone-is-cool'),
(7, 'placement', '', 2011103089, 3, '01:46 AM 27-Dec-12', 'placement'),
(8, 'programming', '', 2011103089, 1, '01:47 AM 27-Dec-12', 'programming'),
(9, 'JAVA labwork-4th sem', 'this is a askceg page where anyone can post questions related java lab and also post answer', 2011103089, 1, '02:09 AM 27-Dec-12', 'JAVA-labwork-4th-sem'),
(10, 'c++', '0', 2011103089, 1, '04:47 AM 27-Dec-12', 'c'),
(11, 'web', '0', 2011103602, 1, '01:18 AM 28-Mar-13', 'web'),
(12, 'Suckers', '', 2, 6, '11:12 AM 30-Mar-13', 'Suckers');

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

--
-- Table structure for table `TOPIC_DESC_HISTORY`
--

CREATE TABLE IF NOT EXISTS `TOPIC_DESC_HISTORY` (
  `topic_id` int(20) NOT NULL,
  `topic_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `TOPIC_FOLLOWERS`
--

CREATE TABLE IF NOT EXISTS `TOPIC_FOLLOWERS` (
  `topic_id` int(20) NOT NULL,
  `user_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `TOPIC_FOLLOWERS`
--

INSERT INTO `TOPIC_FOLLOWERS` (`topic_id`, `user_id`) VALUES
(1, 1),
(1, 3),
(2, 2),
(2, 4),
(1, 4);

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

--
-- Table structure for table `USERS`
--

CREATE TABLE IF NOT EXISTS `USERS` (
  `user_id` int(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) NOT NULL,
  `group_id` int(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `user_level` int(20) NOT NULL,
  `email_id` varchar(50) NOT NULL,
  `joined_on` varchar(50) NOT NULL,
  `user_year` int(20) NOT NULL,
  `user_degree` varchar(20) NOT NULL,
  `user_course` varchar(20) NOT NULL,
  `hash` varchar(100) NOT NULL,
  `complete` int(2) NOT NULL DEFAULT '0',
  `isNormalAccount` int(11) NOT NULL,
  `profile_pic` varchar(300) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `USERS`
--

INSERT INTO `USERS` (`user_id`, `user_name`, `group_id`, `password`, `user_level`, `email_id`, `joined_on`, `user_year`, `user_degree`, `user_course`, `hash`, `complete`, `isNormalAccount`, `profile_pic`) VALUES
(1, 'vikki', 8, '123123', 0, 'dgr8geek@gmail.com', '', 0, 'msc', '212', '', 1, 0, 'https://m.ak.fbcdn.net/profile.ak/hprofile-ak-prn1/173827_100000673452300_1106930760_t.jpg'),
(2, 'Jetti', 9, '123123', 1, 'jetti@gmail.com', '', 0, 'asas', 'asd', '', 1, 0, 'http://m-static.ak.fbcdn.net/rsrc.php/v1/yi/r/odA9sNLrE86.jpg'),
(3, 'bala', 8, '123123', 0, 'bala@gmail.com', '', 0, '', '', '', 0, 0, 'http://profile.ak.fbcdn.net/static-ak/rsrc.php/v1/yi/r/odA9sNLrE86.jpg'),
(4, 'Narain', 9, '123123', 0, 'narain@gmail.com', '', 0, '', '', '', 0, 0, ''),
(10, 'Vishnu', 0, '123', 0, 'vishnuj81093@gmail.com', '', 0, 'BE', 'CSE', '', 1, 0, 'https://fbcdn-profile-a.akamaihd.net/hprofile-ak-prn1/572552_100002276456345_349324707_t.jpg');

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

--
-- Table structure for table `USER_FOLLOWERS`
--

CREATE TABLE IF NOT EXISTS `USER_FOLLOWERS` (
  `user_id` int(20) NOT NULL,
  `follower` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `USER_FOLLOWERS`
--

INSERT INTO `USER_FOLLOWERS` (`user_id`, `follower`) VALUES
(2, 10),
(2, 2011103089),
(2, 4);

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

--
-- Table structure for table `USER_HISTORY_LOG`
--

CREATE TABLE IF NOT EXISTS `USER_HISTORY_LOG` (
  `user_id` int(20) NOT NULL,
  `group_id` int(20) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `USER_HISTORY_LOG`
--

INSERT INTO `USER_HISTORY_LOG` (`user_id`, `group_id`) VALUES
(2011103051, 1);

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

--
-- Table structure for table `USER_NOTIFICATIONS`
--

CREATE TABLE IF NOT EXISTS `USER_NOTIFICATIONS` (
  `user_id` int(20) NOT NULL,
  `notif_id` bigint(100) NOT NULL,
  `new` int(3) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `USER_NOTIFICATIONS`
--

INSERT INTO `USER_NOTIFICATIONS` (`user_id`, `notif_id`, `new`) VALUES
(2, 14, 0),
(2, 14, 0),
(2, 14, 0),
(2, 18, 1),
(2, 18, 1),
(2, 18, 1),
(2, 18, 1),
(2, 18, 1),
(2, 28, 1),
(2, 33, 1),
(2, 34, 1),
(4, 34, 1),
(2, 44, 1),
(2, 33, 1),
(2, 46, 1),
(4, 46, 1);

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

--
-- Table structure for table `VOTE`
--

CREATE TABLE IF NOT EXISTS `VOTE` (
  `a_id` int(20) NOT NULL,
  `user_id` int(20) NOT NULL,
  `vote` int(20) NOT NULL,
  `timestamp` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `VOTE`
--

INSERT INTO `VOTE` (`a_id`, `user_id`, `vote`, `timestamp`) VALUES
(33, 2011103089, 1, '11:30 PM 06-Jan-13'),
(25, 2011103089, -1, '11:31 PM 06-Jan-13'),
(23, 2011103089, 1, '11:31 PM 06-Jan-13'),
(40, 2011103089, 1, '11:33 PM 06-Jan-13'),
(39, 2011103089, 1, '11:33 PM 06-Jan-13'),
(38, 2011103089, -1, '12:16 PM 09-Jan-13'),
(42, 2011103089, 1, '01:17 PM 09-Jan-13'),
(47, 2011103089, -1, '03:42 PM 09-Jan-13'),
(49, 2011103089, -1, '03:44 PM 09-Jan-13'),
(48, 2011103089, 1, '03:44 PM 09-Jan-13'),
(50, 2011103089, 1, '03:44 PM 09-Jan-13'),
(45, 2011103089, -1, '03:44 PM 09-Jan-13'),
(44, 2011103089, -1, '03:44 PM 09-Jan-13'),
(46, 2011103089, -1, '03:44 PM 09-Jan-13'),
(54, 2011103089, 1, '06:30 PM 09-Jan-13'),
(53, 2011103089, -1, '06:30 PM 09-Jan-13'),
(51, 2011103089, -1, '06:30 PM 09-Jan-13'),
(52, 2011103089, 1, '06:30 PM 09-Jan-13'),
(55, 2011103089, 1, '06:57 PM 09-Jan-13'),
(56, 2011103089, 1, '08:47 PM 09-Jan-13'),
(59, 2011103053, 1, '06:36 PM 13-Jan-13'),
(59, 2011103089, -1, '06:37 PM 13-Jan-13'),
(37, 2011103053, 1, '07:09 PM 13-Jan-13'),
(36, 2011103053, 1, '07:09 PM 13-Jan-13'),
(35, 2011103053, 1, '07:09 PM 13-Jan-13'),
(34, 2011103053, -1, '07:09 PM 13-Jan-13'),
(27, 2011103089, 1, '08:09 PM 13-Jan-13'),
(64, 2011103089, -1, '07:25 PM 14-Jan-13'),
(37, 2011103089, 1, '07:40 PM 14-Jan-13'),
(36, 2011103089, -1, '07:40 PM 14-Jan-13'),
(60, 2011103089, -1, '07:40 PM 14-Jan-13'),
(63, 2011103089, 1, '07:40 PM 14-Jan-13'),
(62, 2011103089, 1, '07:40 PM 14-Jan-13'),
(61, 2011103089, 1, '07:40 PM 14-Jan-13'),
(35, 2011103089, -1, '07:40 PM 14-Jan-13'),
(34, 2011103089, -1, '07:41 PM 14-Jan-13'),
(65, 2011103089, 1, '07:45 PM 14-Jan-13'),
(21, 2011103089, 1, '05:15 PM 02-Mar-13'),
(20, 2011103089, -1, '05:16 PM 02-Mar-13'),
(19, 2011103602, 1, '01:14 AM 28-Mar-13'),
(66, 2011103602, 1, '01:16 AM 28-Mar-13'),
(82, 2011103599, 1, '06:52 PM 29-Mar-13'),
(71, 1, -1, '04:11 AM 30-Mar-13'),
(83, 2, 1, '09:34 PM 30-Mar-13'),
(84, 2, 1, '09:42 PM 30-Mar-13'),
(86, 1, 1, '09:51 PM 30-Mar-13'),
(85, 1, -1, '09:51 PM 30-Mar-13'),
(90, 1, 1, '10:33 PM 30-Mar-13'),
(97, 1, 1, '06:01 AM 31-Mar-13'),
(104, 1, 1, '03:14 PM 19-Apr-13');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;