Futurisma

Durham University Database

Jan 6th, 2018
426
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.10.17
  3. -- https://www.phpmyadmin.net
  4. --
  5. -- Host: mysql.dur.ac.uk
  6. -- Generation Time: Apr 15, 2017 at 11:15 AM
  7. -- Server version: 5.1.39-community-log
  8. -- PHP Version: 5.3.27
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `Pdcs8s08_CupboardDB`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `UsersTable`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `UsersTable` (
  30. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  31. `username` varchar(16) NOT NULL,
  32. `email` varchar(64) NOT NULL,
  33. `password` varchar(256) NOT NULL,
  34. `flags` tinyint(4) DEFAULT '0',
  35. `location` varchar(52) NOT NULL,
  36. `rating` float DEFAULT '3',
  37. `score` int(11) DEFAULT '0',
  38. `number` int(11) DEFAULT '0',
  39. `newMsg` varchar(32) NOT NULL,
  40. PRIMARY KEY (`id`),
  41. UNIQUE KEY `username` (`username`),
  42. UNIQUE KEY `email` (`email`)
  43. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
  44.  
  45. --
  46. -- Dumping data for table `UsersTable`
  47. --
  48.  
  49. INSERT INTO `UsersTable` (`id`, `username`, `email`, `password`, `flags`, `location`, `rating`, `score`, `number`, `newMsg`) VALUES
  50. (1, 'durham', '[email protected]', '0859b1fbda83fdef446d8ef2e670c7b6a79e50f97977d0bfea557cd65cd95bb8', 0, '52.94201777829491,-0.5767822265625', 3, 0, 0, ''),
  51. (2, 'newuser', '[email protected]', '936a185caaa266bb9cbe981e9e05cb78cd732b0b3280eb944412bb6f8f8f07af', 0, '52.945327958220325,-1.153564453125', 3, 0, 0, '1'),
  52. (3, 'meatLuvr', '[email protected]', 'a83f4bc532580c5554c7de98ded42aeea34845b4c558ffe46204c8d5aaa64d42', 64, '54.760144736815505,-1.5801644325256348', 3, 0, 0, '0'),
  53. (4, 'dessertphile', '[email protected]', 'd292bf6fe251eaebe5e63f16eaf1a5aaba2f14ac99ca40696ef453a53b740482', 0, '28.458067121315263,77.0361328125', 3, 0, 0, ''),
  54. (5, 'soumya', '[email protected]', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 2, '52.62972886718355,-1.1370849609375', 3, 0, 0, '0'),
  55. (7, 'FoodieDave', '[email protected]', '9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08', 0, '51.85783521205157,-4.297027587890625', 3, 0, 0, '0'),
  56. (8, 'sweettooth', '[email protected]', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 0, '53.774688845835776,-1.7523193359375', 3, 0, 0, ''),
  57. (9, 'userrrrrr', '[email protected]', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 10, '54.7658396372816,-1.5875244140625', 3, 0, 0, ''),
  58. (10, 'clare', '[email protected]', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', 2, '51.498484547170605,-0.1318359375', 3, 0, 0, '0'),
  59. (11, 'genieirock', '[email protected]', '9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08', 1, '53.304287695123456,-2.9917144775390625', 3, 0, 0, '0');
  60.  
  61. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  62. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  63. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment