Advertisement
Kulasangar

Sample

Dec 25th, 2014
336
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 14.62 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.2.0.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jan 07, 2014 at 05:54 AM
  7. -- Server version: 5.1.37
  8. -- PHP Version: 5.3.0
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12.  
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8 */;
  17.  
  18. --
  19. -- Database: `tutoring`
  20. --
  21.  
  22. -- --------------------------------------------------------
  23.  
  24. --
  25. -- Table structure for table `answer`
  26. --
  27.  
  28. CREATE TABLE IF NOT EXISTS `answer` (
  29.   `answerid` int(4) NOT NULL AUTO_INCREMENT,
  30.   `userid` int(11) NOT NULL,
  31.   `questionid` int(10) NOT NULL,
  32.   `description` varchar(400) NOT NULL,
  33.   `posteddate` varchar(18) NOT NULL,
  34.   PRIMARY KEY (`answerid`)
  35. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
  36.  
  37. --
  38. -- Dumping data for table `answer`
  39. --
  40.  
  41. INSERT INTO `answer` (`answerid`, `userid`, `questionid`, `description`, `posteddate`) VALUES
  42. (3, 3, 4, 'Go to settings and change the theme ', '19-12-13'),
  43. (4, 3, 4, 'you cant change the theme in iphone \r\nbut you can put some apps to change the look', '19-12-13'),
  44. (5, 3, 4, 'cant buddy', '19-12-13'),
  45. (6, 3, 0, ';o;o;o;', '19-12-13'),
  46. (7, 3, 35, 'daedaef', '19-12-13'),
  47. (8, 3, 35, 'fgfefe', '19-12-13'),
  48. (9, 3, 35, '', '19-12-13'),
  49. (10, 3, 35, 'fdfdfdf', '19-12-13'),
  50. (11, 3, 36, 'dsdsdsd', '19-12-13'),
  51. (12, 3, 37, 'dadad', '19-12-13'),
  52. (13, 3, 37, 'sdsd', '19-12-13'),
  53. (14, 3, 37, 'sdsd', '19-12-13'),
  54. (15, 3, 37, 'dsdsds', '19-12-13'),
  55. (16, 3, 1, 'Android is a mobile operating system', '28-12-13'),
  56. (17, 32, 0, 'hi', '07-01-14'),
  57. (18, 32, 0, 'hi', '07-01-14');
  58.  
  59. -- --------------------------------------------------------
  60.  
  61. --
  62. -- Table structure for table `category`
  63. --
  64.  
  65. CREATE TABLE IF NOT EXISTS `category` (
  66.   `categoryid` int(4) NOT NULL AUTO_INCREMENT,
  67.   `category` varchar(20) NOT NULL,
  68.   `categorydescription` varchar(20) NOT NULL,
  69.   PRIMARY KEY (`categoryid`)
  70. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  71.  
  72. --
  73. -- Dumping data for table `category`
  74. --
  75.  
  76. INSERT INTO `category` (`categoryid`, `category`, `categorydescription`) VALUES
  77. (1, 'php', ''),
  78. (2, 'android', ''),
  79. (3, 'asp.net', ''),
  80. (4, 'c#', '');
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Table structure for table `ci_sessions`
  86. --
  87.  
  88. CREATE TABLE IF NOT EXISTS `ci_sessions` (
  89.   `session_id` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '0',
  90.   `ip_address` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '0',
  91.   `user_agent` varchar(150) COLLATE utf8_bin NOT NULL,
  92.   `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  93.   `user_data` text COLLATE utf8_bin NOT NULL,
  94.   PRIMARY KEY (`session_id`)
  95. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  96.  
  97. --
  98. -- Dumping data for table `ci_sessions`
  99. --
  100.  
  101. INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
  102. ('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";}');
  103.  
  104. -- --------------------------------------------------------
  105.  
  106. --
  107. -- Table structure for table `login_attempts`
  108. --
  109.  
  110. CREATE TABLE IF NOT EXISTS `login_attempts` (
  111.   `id` int(11) NOT NULL AUTO_INCREMENT,
  112.   `ip_address` varchar(40) COLLATE utf8_bin NOT NULL,
  113.   `login` varchar(50) COLLATE utf8_bin NOT NULL,
  114.   `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  115.   PRIMARY KEY (`id`)
  116. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;
  117.  
  118. --
  119. -- Dumping data for table `login_attempts`
  120. --
  121.  
  122. INSERT INTO `login_attempts` (`id`, `ip_address`, `login`, `time`) VALUES
  123. (1, '::1', 'niro', '2014-01-07 05:37:08');
  124.  
  125. -- --------------------------------------------------------
  126.  
  127. --
  128. -- Table structure for table `permission`
  129. --
  130.  
  131. CREATE TABLE IF NOT EXISTS `permission` (
  132.   `permissionid` int(4) NOT NULL,
  133.   `usertypeid` int(4) NOT NULL,
  134.   `name` varchar(20) NOT NULL,
  135.   `description` varchar(100) NOT NULL,
  136.   PRIMARY KEY (`permissionid`)
  137. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  138.  
  139. --
  140. -- Dumping data for table `permission`
  141. --
  142.  
  143.  
  144. -- --------------------------------------------------------
  145.  
  146. --
  147. -- Table structure for table `question`
  148. --
  149.  
  150. CREATE TABLE IF NOT EXISTS `question` (
  151.   `questionid` int(10) NOT NULL AUTO_INCREMENT,
  152.   `userid` int(11) NOT NULL,
  153.   `categoryid` int(11) NOT NULL,
  154.   `title` varchar(50) NOT NULL,
  155.   `description` varchar(400) NOT NULL,
  156.   `posteddate` varchar(18) NOT NULL,
  157.   `tag1` int(4) NOT NULL,
  158.   `tag2` int(4) NOT NULL,
  159.   `tag3` int(4) NOT NULL,
  160.   PRIMARY KEY (`questionid`)
  161. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
  162.  
  163. --
  164. -- Dumping data for table `question`
  165. --
  166.  
  167. INSERT INTO `question` (`questionid`, `userid`, `categoryid`, `title`, `description`, `posteddate`, `tag1`, `tag2`, `tag3`) VALUES
  168. (1, 3, 0, 'Android ?', 'What is android ?', 'What is android ?', 0, 0, 0),
  169. (20, 3, 0, 'sd', 'ds', '19-12-13', 0, 0, 0),
  170. (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),
  171. (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),
  172. (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),
  173. (27, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
  174. (28, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
  175. (29, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
  176. (30, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
  177. (31, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
  178. (32, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
  179. (33, 3, 0, 'sds', 'dsd', '19-12-13', 0, 0, 0),
  180. (34, 3, 0, 'Screen broken', 'sdsdsd', '19-12-13', 0, 0, 0),
  181. (35, 3, 0, 'Screen brokendsds', 'fdfdf', '19-12-13', 0, 0, 0),
  182. (36, 3, 0, 'How to upgrade android?', 'dsdsd', '19-12-13', 0, 0, 0),
  183. (37, 3, 0, 'Screen brokendsds', 'sdsdsd', '19-12-13', 0, 0, 0),
  184. (38, 3, 0, '0', '0', '28-12-13', 0, 0, 0),
  185. (54, 3, 2, 'how to update to ios 7', 'new iphone user', '28-12-13', 0, 0, 0),
  186. (55, 3, 2, 'how to update to ios 7', 'new iphone user', '28-12-13', 0, 0, 0);
  187.  
  188. -- --------------------------------------------------------
  189.  
  190. --
  191. -- Table structure for table `question_rating`
  192. --
  193.  
  194. CREATE TABLE IF NOT EXISTS `question_rating` (
  195.   `questionid` int(11) NOT NULL,
  196.   `userid` int(11) NOT NULL,
  197.   `points` int(10) NOT NULL DEFAULT '0',
  198.   PRIMARY KEY (`questionid`,`userid`)
  199. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  200.  
  201. --
  202. -- Dumping data for table `question_rating`
  203. --
  204.  
  205. INSERT INTO `question_rating` (`questionid`, `userid`, `points`) VALUES
  206. (1, 31, 0),
  207. (1, 3, 1),
  208. (54, 3, 1),
  209. (20, 3, 1),
  210. (20, 31, 1),
  211. (24, 31, 1),
  212. (26, 31, -1),
  213. (26, 3, 1);
  214.  
  215. -- --------------------------------------------------------
  216.  
  217. --
  218. -- Table structure for table `tag`
  219. --
  220.  
  221. CREATE TABLE IF NOT EXISTS `tag` (
  222.   `tagid` int(4) NOT NULL AUTO_INCREMENT,
  223.   `tagname` varchar(20) NOT NULL,
  224.   PRIMARY KEY (`tagid`)
  225. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
  226.  
  227. --
  228. -- Dumping data for table `tag`
  229. --
  230.  
  231. INSERT INTO `tag` (`tagid`, `tagname`) VALUES
  232. (1, 'screen'),
  233. (2, 'battery'),
  234. (4, 'windows'),
  235. (3, 'os'),
  236. (5, 'nexus'),
  237. (6, 'android'),
  238. (7, 'iphone'),
  239. (8, 'blackberry'),
  240. (9, 'htc'),
  241. (15, 'nokia'),
  242. (16, 'speaker'),
  243. (17, 'update'),
  244. (18, 'ios');
  245.  
  246. -- --------------------------------------------------------
  247.  
  248. --
  249. -- Table structure for table `users`
  250. --
  251.  
  252. CREATE TABLE IF NOT EXISTS `users` (
  253.   `userid` int(11) NOT NULL AUTO_INCREMENT,
  254.   `firstname` varchar(40) COLLATE utf8_bin NOT NULL,
  255.   `lastname` varchar(40) COLLATE utf8_bin NOT NULL,
  256.   `username` varchar(50) COLLATE utf8_bin NOT NULL,
  257.   `password` varchar(255) COLLATE utf8_bin NOT NULL,
  258.   `email` varchar(100) COLLATE utf8_bin NOT NULL,
  259.   `joineddate` date NOT NULL,
  260.   `activated` tinyint(1) NOT NULL DEFAULT '1',
  261.   `banned` tinyint(1) NOT NULL DEFAULT '0',
  262.   `ban_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  263.   `new_password_key` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  264.   `new_password_requested` datetime DEFAULT NULL,
  265.   `new_email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  266.   `new_email_key` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  267.   `last_ip` varchar(40) COLLATE utf8_bin NOT NULL,
  268.   `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  269.   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  270.   `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  271.   `usertypeid` varchar(4) COLLATE utf8_bin NOT NULL,
  272.   `tutorstudentid` varchar(8) COLLATE utf8_bin NOT NULL,
  273.   PRIMARY KEY (`userid`)
  274. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=34 ;
  275.  
  276. --
  277. -- Dumping data for table `users`
  278. --
  279.  
  280. 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
  281. (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', ''),
  282. (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', ''),
  283. (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', ''),
  284. (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', ''),
  285. (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', ''),
  286. (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', ''),
  287. (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'),
  288. (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'),
  289. (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'),
  290. (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', ''),
  291. (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', '');
  292.  
  293. -- --------------------------------------------------------
  294.  
  295. --
  296. -- Table structure for table `user_autologin`
  297. --
  298.  
  299. CREATE TABLE IF NOT EXISTS `user_autologin` (
  300.   `key_id` char(32) COLLATE utf8_bin NOT NULL,
  301.   `user_id` int(11) NOT NULL DEFAULT '0',
  302.   `user_agent` varchar(150) COLLATE utf8_bin NOT NULL,
  303.   `last_ip` varchar(40) COLLATE utf8_bin NOT NULL,
  304.   `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  305.   PRIMARY KEY (`key_id`,`user_id`)
  306. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  307.  
  308. --
  309. -- Dumping data for table `user_autologin`
  310. --
  311.  
  312.  
  313. -- --------------------------------------------------------
  314.  
  315. --
  316. -- Table structure for table `user_profiles`
  317. --
  318.  
  319. CREATE TABLE IF NOT EXISTS `user_profiles` (
  320.   `id` int(11) NOT NULL AUTO_INCREMENT,
  321.   `user_id` int(11) NOT NULL,
  322.   `country` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  323.   `website` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  324.   PRIMARY KEY (`id`)
  325. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=32 ;
  326.  
  327. --
  328. -- Dumping data for table `user_profiles`
  329. --
  330.  
  331. INSERT INTO `user_profiles` (`id`, `user_id`, `country`, `website`) VALUES
  332. (1, 3, NULL, NULL),
  333. (2, 4, NULL, NULL),
  334. (3, 5, NULL, NULL),
  335. (4, 6, NULL, NULL),
  336. (5, 7, NULL, NULL),
  337. (6, 8, NULL, NULL),
  338. (7, 9, NULL, NULL),
  339. (8, 10, NULL, NULL),
  340. (9, 11, NULL, NULL),
  341. (10, 12, NULL, NULL),
  342. (11, 13, NULL, NULL),
  343. (12, 14, NULL, NULL),
  344. (13, 15, NULL, NULL),
  345. (14, 16, NULL, NULL),
  346. (15, 17, NULL, NULL),
  347. (16, 18, NULL, NULL),
  348. (17, 19, NULL, NULL),
  349. (18, 20, NULL, NULL),
  350. (19, 21, NULL, NULL),
  351. (20, 22, NULL, NULL),
  352. (21, 23, NULL, NULL),
  353. (22, 24, NULL, NULL),
  354. (23, 25, NULL, NULL),
  355. (24, 26, NULL, NULL),
  356. (25, 27, NULL, NULL),
  357. (26, 28, NULL, NULL),
  358. (27, 29, NULL, NULL),
  359. (28, 30, NULL, NULL),
  360. (29, 31, NULL, NULL),
  361. (30, 32, NULL, NULL),
  362. (31, 33, NULL, NULL);
  363.  
  364. -- --------------------------------------------------------
  365.  
  366. --
  367. -- Table structure for table `user_type`
  368. --
  369.  
  370. CREATE TABLE IF NOT EXISTS `user_type` (
  371.   `usertypeid` int(4) NOT NULL,
  372.   `usertypename` varchar(20) NOT NULL,
  373.   `usertypedescription` varchar(100) NOT NULL
  374. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  375.  
  376. --
  377. -- Dumping data for table `user_type`
  378. --
  379.  
  380. INSERT INTO `user_type` (`usertypeid`, `usertypename`, `usertypedescription`) VALUES
  381. (1, 'admin', 'Site Owner'),
  382. (2, 'Tutor', 'Privileged user who can answer questions'),
  383. (3, 'Student', 'Normal User who can answer and ask questions');
  384.  
  385. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  386. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  387. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement