Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.2.0.1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Jan 07, 2014 at 05:54 AM
- -- Server version: 5.1.37
- -- PHP Version: 5.3.0
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- /*!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: `tutoring`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `answer`
- --
- CREATE TABLE IF NOT EXISTS `answer` (
- `answerid` int(4) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `questionid` int(10) NOT NULL,
- `description` varchar(400) NOT NULL,
- `posteddate` varchar(18) NOT NULL,
- PRIMARY KEY (`answerid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
- --
- -- Dumping data for table `answer`
- --
- INSERT INTO `answer` (`answerid`, `userid`, `questionid`, `description`, `posteddate`) VALUES
- (3, 3, 4, 'Go to settings and change the theme ', '19-12-13'),
- (4, 3, 4, 'you cant change the theme in iphone \r\nbut you can put some apps to change the look', '19-12-13'),
- (5, 3, 4, 'cant buddy', '19-12-13'),
- (6, 3, 0, ';o;o;o;', '19-12-13'),
- (7, 3, 35, 'daedaef', '19-12-13'),
- (8, 3, 35, 'fgfefe', '19-12-13'),
- (9, 3, 35, '', '19-12-13'),
- (10, 3, 35, 'fdfdfdf', '19-12-13'),
- (11, 3, 36, 'dsdsdsd', '19-12-13'),
- (12, 3, 37, 'dadad', '19-12-13'),
- (13, 3, 37, 'sdsd', '19-12-13'),
- (14, 3, 37, 'sdsd', '19-12-13'),
- (15, 3, 37, 'dsdsds', '19-12-13'),
- (16, 3, 1, 'Android is a mobile operating system', '28-12-13'),
- (17, 32, 0, 'hi', '07-01-14'),
- (18, 32, 0, 'hi', '07-01-14');
- -- --------------------------------------------------------
- --
- -- Table structure for table `category`
- --
- CREATE TABLE IF NOT EXISTS `category` (
- `categoryid` int(4) NOT NULL AUTO_INCREMENT,
- `category` varchar(20) NOT NULL,
- `categorydescription` varchar(20) NOT NULL,
- PRIMARY KEY (`categoryid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
- --
- -- Dumping data for table `category`
- --
- INSERT INTO `category` (`categoryid`, `category`, `categorydescription`) VALUES
- (1, 'php', ''),
- (2, 'android', ''),
- (3, 'asp.net', ''),
- (4, 'c#', '');
- -- --------------------------------------------------------
- --
- -- Table structure for table `ci_sessions`
- --
- CREATE TABLE IF NOT EXISTS `ci_sessions` (
- `session_id` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '0',
- `ip_address` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '0',
- `user_agent` varchar(150) COLLATE utf8_bin NOT NULL,
- `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
- `user_data` text COLLATE utf8_bin NOT NULL,
- PRIMARY KEY (`session_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- --
- -- Dumping data for table `ci_sessions`
- --
- INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
- ('1af53cf45327444a3d319678ad57a839', '::1', 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', 1389102617, 'a:4:{s:9:"user_data";s:0:"";s:7:"user_id";s:2:"32";s:8:"username";s:5:"Senko";s:6:"status";s:1:"1";}');
- -- --------------------------------------------------------
- --
- -- Table structure for table `login_attempts`
- --
- CREATE TABLE IF NOT EXISTS `login_attempts` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `ip_address` varchar(40) COLLATE utf8_bin NOT NULL,
- `login` varchar(50) COLLATE utf8_bin NOT NULL,
- `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
- --
- -- Dumping data for table `login_attempts`
- --
- INSERT INTO `login_attempts` (`id`, `ip_address`, `login`, `time`) VALUES
- (1, '::1', 'niro', '2014-01-07 05:37:08');
- -- --------------------------------------------------------
- --
- -- Table structure for table `permission`
- --
- CREATE TABLE IF NOT EXISTS `permission` (
- `permissionid` int(4) NOT NULL,
- `usertypeid` int(4) NOT NULL,
- `name` varchar(20) NOT NULL,
- `description` varchar(100) NOT NULL,
- PRIMARY KEY (`permissionid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `permission`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `question`
- --
- CREATE TABLE IF NOT EXISTS `question` (
- `questionid` int(10) NOT NULL AUTO_INCREMENT,
- `userid` int(11) NOT NULL,
- `categoryid` int(11) NOT NULL,
- `title` varchar(50) NOT NULL,
- `description` varchar(400) NOT NULL,
- `posteddate` varchar(18) NOT NULL,
- `tag1` int(4) NOT NULL,
- `tag2` int(4) NOT NULL,
- `tag3` int(4) NOT NULL,
- PRIMARY KEY (`questionid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
- --
- -- Dumping data for table `question`
- --
- INSERT INTO `question` (`questionid`, `userid`, `categoryid`, `title`, `description`, `posteddate`, `tag1`, `tag2`, `tag3`) VALUES
- (1, 3, 0, 'Android ?', 'What is android ?', 'What is android ?', 0, 0, 0),
- (20, 3, 0, 'sd', 'ds', '19-12-13', 0, 0, 0),
- (24, 3, 0, 'How to upgrade android?', 'I am using JB 4.2 , I want to know how to upgrade to Kitkat 4.4?', '19-12-13', 0, 0, 0),
- (25, 3, 0, 'How to upgrade android?', 'I am using JB 4.2 , I want to know how to upgrade to Kitkat 4.4?', '19-12-13', 0, 0, 0),
- (26, 3, 0, 'How to upgrade android?', 'I am using JB 4.2 , I want to know how to upgrade to Kitkat 4.4?', '19-12-13', 0, 0, 0),
- (27, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
- (28, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
- (29, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
- (30, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
- (31, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
- (32, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
- (33, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
- (34, 3, 0, 'Screen broken', 'sdsdsd', '19-12-13', 0, 0, 0),
- (35, 3, 0, 'Screen brokendsds', 'fdfdf', '19-12-13', 0, 0, 0),
- (36, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
- (37, 3, 0, 'Screen brokendsds', 'sdsdsd', '19-12-13', 0, 0, 0),
- (38, 3, 0, '0', '0', '28-12-13', 0, 0, 0),
- (54, 3, 2, 'how to update to ios 7', 'new iphone user', '28-12-13', 0, 0, 0),
- (55, 3, 2, 'how to update to ios 7', 'new iphone user', '28-12-13', 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- Table structure for table `question_rating`
- --
- CREATE TABLE IF NOT EXISTS `question_rating` (
- `questionid` int(11) NOT NULL,
- `userid` int(11) NOT NULL,
- `points` int(10) NOT NULL DEFAULT '0',
- PRIMARY KEY (`questionid`,`userid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `question_rating`
- --
- INSERT INTO `question_rating` (`questionid`, `userid`, `points`) VALUES
- (1, 31, 0),
- (1, 3, 1),
- (54, 3, 1),
- (20, 3, 1),
- (20, 31, 1),
- (24, 31, 1),
- (26, 31, -1),
- (26, 3, 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `tag`
- --
- CREATE TABLE IF NOT EXISTS `tag` (
- `tagid` int(4) NOT NULL AUTO_INCREMENT,
- `tagname` varchar(20) NOT NULL,
- PRIMARY KEY (`tagid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
- --
- -- Dumping data for table `tag`
- --
- INSERT INTO `tag` (`tagid`, `tagname`) VALUES
- (1, 'screen'),
- (2, 'battery'),
- (4, 'windows'),
- (3, 'os'),
- (5, 'nexus'),
- (6, 'android'),
- (7, 'iphone'),
- (8, 'blackberry'),
- (9, 'htc'),
- (15, 'nokia'),
- (16, 'speaker'),
- (17, 'update'),
- (18, 'ios');
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE IF NOT EXISTS `users` (
- `userid` int(11) NOT NULL AUTO_INCREMENT,
- `firstname` varchar(40) COLLATE utf8_bin NOT NULL,
- `lastname` varchar(40) COLLATE utf8_bin NOT NULL,
- `username` varchar(50) COLLATE utf8_bin NOT NULL,
- `password` varchar(255) COLLATE utf8_bin NOT NULL,
- `email` varchar(100) COLLATE utf8_bin NOT NULL,
- `joineddate` date NOT NULL,
- `activated` tinyint(1) NOT NULL DEFAULT '1',
- `banned` tinyint(1) NOT NULL DEFAULT '0',
- `ban_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL,
- `new_password_key` varchar(50) COLLATE utf8_bin DEFAULT NULL,
- `new_password_requested` datetime DEFAULT NULL,
- `new_email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
- `new_email_key` varchar(50) COLLATE utf8_bin DEFAULT NULL,
- `last_ip` varchar(40) COLLATE utf8_bin NOT NULL,
- `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `usertypeid` varchar(4) COLLATE utf8_bin NOT NULL,
- `tutorstudentid` varchar(8) COLLATE utf8_bin NOT NULL,
- PRIMARY KEY (`userid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=34 ;
- --
- -- Dumping data for table `users`
- --
- INSERT INTO `users` (`userid`, `firstname`, `lastname`, `username`, `password`, `email`, `joineddate`, `activated`, `banned`, `ban_reason`, `new_password_key`, `new_password_requested`, `new_email`, `new_email_key`, `last_ip`, `last_login`, `created`, `modified`, `usertypeid`, `tutorstudentid`) VALUES
- (2, '', '', 'bruce', '$2a$08$40e0FYa3YQLBAGSOecj1t.vWVN5UDXtnqKZn.ExmKib19DDk87PS2', 'bruce@gmail.com', '0000-00-00', 1, 0, NULL, NULL, NULL, NULL, '81962861a50bda92c36b4eb36481bc5d', '::1', '0000-00-00 00:00:00', '2013-12-08 06:47:19', '2013-12-08 06:48:23', '0', ''),
- (3, '', '', 'test', '$2a$08$MiXe0fQ/qT0zaSULNhsd7eVslXeXe1.pardb9OdRrFKy8V8LSkA4q', 'test@gmail.com', '0000-00-00', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '2013-12-30 13:11:29', '2013-12-08 06:49:53', '2013-12-30 13:11:05', '1', ''),
- (4, '', '', 'admin', '$2a$08$inE/2XBn13dl1Wc5KqVqBuHGCEU.BXvu/6YIFsgRdL9pPEHKWA2J.', 'admin@gmail.com', '0000-00-00', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2013-12-08 07:25:32', '2013-12-08 07:25:08', '0', ''),
- (5, '', '', 'admin1', '$2a$08$4mbFIDQmVAL..mXzZTOc2eM9uJW9kUKvR9AG0t2rZ0r8NqbrgUSLK', 'admin1@yahoo.com', '0000-00-00', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2013-12-08 07:31:21', '2013-12-08 07:30:57', '0', ''),
- (7, '', '', 'student', '$2a$08$4Nb9xFJx6JlBZDq76ikJHeIGUjleDpg2sVARug9RFOpBxDHpE5pke', 'student@gmail.com', '0000-00-00', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2013-12-10 11:41:13', '2013-12-10 11:40:49', '0', ''),
- (8, '', '', 'admin5', '$2a$08$Z0zldgVbGG1lRk/h1LJgROQ2Pd5dp6Ki2TyjPMtScZhA2TgQQVsRe', 'admin5@admin.com', '0000-00-00', 1, 0, NULL, 'b2ea7270e4e27598a4601ebca4d0425a', '2013-12-10 12:11:11', NULL, NULL, '::1', '2013-12-10 12:07:19', '2013-12-10 12:07:10', '2013-12-25 01:52:16', '1', ''),
- (22, 'tutorf', 'tutorl', 'tutor', '$2a$08$.JRCSejqSi5RgPbSLzQUtOw1NuFBhdG2zw7QRUFFg2Jd4N8W/9oT2', 'tutor@gmail.com', '2013-12-24', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2013-12-24 11:38:33', '2013-12-24 11:38:09', '0', '2'),
- (29, '12345678', '12345678', '12345678', '$2a$08$6seR95ChdJfJG0GpWyQWN.8U9j3O71qg39.tAEqDCRf4qk3n7po3y', '12345678@gmail.com', '2013-12-24', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2013-12-24 13:32:49', '2013-12-25 01:51:59', '1', '3'),
- (31, 'jayasai', 'jayasai', 'jayasai', '$2a$08$2IguG5NEzJWHJH6uRmbM/e/BX5ZpPpMrmaLFse26QOCvJihKaIPIa', 'jayasai@gmail.com', '2013-12-25', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '2013-12-30 13:10:14', '2013-12-25 21:06:09', '2013-12-30 13:09:50', '3', 'tut45678'),
- (32, 'Senkordan', 'Satchi', 'Senko', '$2a$08$f0AAiJIwjYYKk2OMDrYUxuAzeh79luPjU207l3wttlhKuP2kP.06e', 'senko@yahoo.com', '2014-01-07', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '2014-01-07 05:48:07', '2014-01-07 05:38:47', '2014-01-07 05:47:43', '3', ''),
- (33, 'Niro', 'Suba', 'Niro', '$2a$08$BXMaT75HdB1LgQiY4FTJk.G9SV80XhPByL30r4b8SGYZl94wPXEcS', 'senkor@yahoo.com', '2014-01-07', 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2014-01-07 05:44:53', '2014-01-07 05:44:29', '3', '');
- -- --------------------------------------------------------
- --
- -- Table structure for table `user_autologin`
- --
- CREATE TABLE IF NOT EXISTS `user_autologin` (
- `key_id` char(32) COLLATE utf8_bin NOT NULL,
- `user_id` int(11) NOT NULL DEFAULT '0',
- `user_agent` varchar(150) COLLATE utf8_bin NOT NULL,
- `last_ip` varchar(40) COLLATE utf8_bin NOT NULL,
- `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- PRIMARY KEY (`key_id`,`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- --
- -- Dumping data for table `user_autologin`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `user_profiles`
- --
- CREATE TABLE IF NOT EXISTS `user_profiles` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `country` varchar(20) COLLATE utf8_bin DEFAULT NULL,
- `website` varchar(255) COLLATE utf8_bin DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=32 ;
- --
- -- Dumping data for table `user_profiles`
- --
- INSERT INTO `user_profiles` (`id`, `user_id`, `country`, `website`) VALUES
- (1, 3, NULL, NULL),
- (2, 4, NULL, NULL),
- (3, 5, NULL, NULL),
- (4, 6, NULL, NULL),
- (5, 7, NULL, NULL),
- (6, 8, NULL, NULL),
- (7, 9, NULL, NULL),
- (8, 10, NULL, NULL),
- (9, 11, NULL, NULL),
- (10, 12, NULL, NULL),
- (11, 13, NULL, NULL),
- (12, 14, NULL, NULL),
- (13, 15, NULL, NULL),
- (14, 16, NULL, NULL),
- (15, 17, NULL, NULL),
- (16, 18, NULL, NULL),
- (17, 19, NULL, NULL),
- (18, 20, NULL, NULL),
- (19, 21, NULL, NULL),
- (20, 22, NULL, NULL),
- (21, 23, NULL, NULL),
- (22, 24, NULL, NULL),
- (23, 25, NULL, NULL),
- (24, 26, NULL, NULL),
- (25, 27, NULL, NULL),
- (26, 28, NULL, NULL),
- (27, 29, NULL, NULL),
- (28, 30, NULL, NULL),
- (29, 31, NULL, NULL),
- (30, 32, NULL, NULL),
- (31, 33, NULL, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `user_type`
- --
- CREATE TABLE IF NOT EXISTS `user_type` (
- `usertypeid` int(4) NOT NULL,
- `usertypename` varchar(20) NOT NULL,
- `usertypedescription` varchar(100) NOT NULL
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `user_type`
- --
- INSERT INTO `user_type` (`usertypeid`, `usertypename`, `usertypedescription`) VALUES
- (1, 'admin', 'Site Owner'),
- (2, 'Tutor', 'Privileged user who can answer questions'),
- (3, 'Student', 'Normal User who can answer and ask questions');
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement