Durham University Database

-- phpMyAdmin SQL Dump
-- version 4.0.10.17
-- https://www.phpmyadmin.net
--
-- Host: mysql.dur.ac.uk
-- Generation Time: Apr 15, 2017 at 11:15 AM
-- Server version: 5.1.39-community-log
-- PHP Version: 5.3.27

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: `Pdcs8s08_CupboardDB`
--

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

--
-- Table structure for table `UsersTable`
--

CREATE TABLE IF NOT EXISTS `UsersTable` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(16) NOT NULL,
  `email` varchar(64) NOT NULL,
  `password` varchar(256) NOT NULL,
  `flags` tinyint(4) DEFAULT '0',
  `location` varchar(52) NOT NULL,
  `rating` float DEFAULT '3',
  `score` int(11) DEFAULT '0',
  `number` int(11) DEFAULT '0',
  `newMsg` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `UsersTable`
--

INSERT INTO `UsersTable` (`id`, `username`, `email`, `password`, `flags`, `location`, `rating`, `score`, `number`, `newMsg`) VALUES
(1, 'durham', '[email protected]', '0859b1fbda83fdef446d8ef2e670c7b6a79e50f97977d0bfea557cd65cd95bb8', 0, '52.94201777829491,-0.5767822265625', 3, 0, 0, ''),
(2, 'newuser', '[email protected]', '936a185caaa266bb9cbe981e9e05cb78cd732b0b3280eb944412bb6f8f8f07af', 0, '52.945327958220325,-1.153564453125', 3, 0, 0, '1'),
(3, 'meatLuvr', '[email protected]', 'a83f4bc532580c5554c7de98ded42aeea34845b4c558ffe46204c8d5aaa64d42', 64, '54.760144736815505,-1.5801644325256348', 3, 0, 0, '0'),
(4, 'dessertphile', '[email protected]', 'd292bf6fe251eaebe5e63f16eaf1a5aaba2f14ac99ca40696ef453a53b740482', 0, '28.458067121315263,77.0361328125', 3, 0, 0, ''),
(5, 'soumya', '[email protected]', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 2, '52.62972886718355,-1.1370849609375', 3, 0, 0, '0'),
(7, 'FoodieDave', '[email protected]', '9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08', 0, '51.85783521205157,-4.297027587890625', 3, 0, 0, '0'),
(8, 'sweettooth', '[email protected]', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 0, '53.774688845835776,-1.7523193359375', 3, 0, 0, ''),
(9, 'userrrrrr', '[email protected]', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 10, '54.7658396372816,-1.5875244140625', 3, 0, 0, ''),
(10, 'clare', '[email protected]', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', 2, '51.498484547170605,-0.1318359375', 3, 0, 0, '0'),
(11, 'genieirock', '[email protected]', '9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08', 1, '53.304287695123456,-2.9917144775390625', 3, 0, 0, '0');

/*!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 */;