· 8 years ago · Jan 06, 2018, 04:06 PM
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
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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
29CREATE 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
49INSERT INTO `UsersTable` (`id`, `username`, `email`, `password`, `flags`, `location`, `rating`, `score`, `number`, `newMsg`) VALUES
50(1, 'durham', 'user@durham.com', '0859b1fbda83fdef446d8ef2e670c7b6a79e50f97977d0bfea557cd65cd95bb8', 0, '52.94201777829491,-0.5767822265625', 3, 0, 0, ''),
51(2, 'newuser', 'newuser@cupboard.com', '936a185caaa266bb9cbe981e9e05cb78cd732b0b3280eb944412bb6f8f8f07af', 0, '52.945327958220325,-1.153564453125', 3, 0, 0, '1'),
52(3, 'meatLuvr', 'meat@email.com', 'a83f4bc532580c5554c7de98ded42aeea34845b4c558ffe46204c8d5aaa64d42', 64, '54.760144736815505,-1.5801644325256348', 3, 0, 0, '0'),
53(4, 'dessertphile', 'desserts@cupboard.com', 'd292bf6fe251eaebe5e63f16eaf1a5aaba2f14ac99ca40696ef453a53b740482', 0, '28.458067121315263,77.0361328125', 3, 0, 0, ''),
54(5, 'soumya', 'soumya.singh@durham.ac.uk', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 2, '52.62972886718355,-1.1370849609375', 3, 0, 0, '0'),
55(7, 'FoodieDave', 'daveandgill@aol.com', '9f86d081884c7d659a2feaa0c55ad015a3bf4f1b2b0b822cd15d6c15b0f00a08', 0, '51.85783521205157,-4.297027587890625', 3, 0, 0, '0'),
56(8, 'sweettooth', 'sweettooth@cupboard.com', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 0, '53.774688845835776,-1.7523193359375', 3, 0, 0, ''),
57(9, 'userrrrrr', 'user@food.com', '1c8bfe8f801d79745c4631d09fff36c82aa37fc4cce4fc946683d7b336b63032', 10, '54.7658396372816,-1.5875244140625', 3, 0, 0, ''),
58(10, 'clare', 'blah@gmail.com', 'a665a45920422f9d417e4867efdc4fb8a04a1f3fff1fa07e998e86f7f7a27ae3', 2, '51.498484547170605,-0.1318359375', 3, 0, 0, '0'),
59(11, 'genieirock', 'genieirock1@yahoo.co.uk', '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 */;