· 8 years ago · Jul 23, 2018, 06:10 PM
1************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 185.41.8.135 (MySQL 5.5.5-10.1.34-MariaDB)
9# Database: stbgamefactor3st_game
10# Generation Time: 2018-07-23 09:12:46 +0000
11# ************************************************************
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/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21​
22​
23# Dump of table scores
24# ------------------------------------------------------------
25​
26DROP TABLE IF EXISTS `scores`;
27​
28CREATE TABLE `scores` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
31 `email` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
32 `company` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
33 `time` varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
34 `mailing` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37​
38LOCK TABLES `scores` WRITE;
39/*!40000 ALTER TABLE `scores` DISABLE KEYS */;
40​
41INSERT INTO `scores` (`id`, `name`, `email`, `company`, `time`, `mailing`)
42VALUES
43 (16,'Jordan Haines','jordan@factor3.co.uk','Factor 3','339',''),
44 (17,'Jordan Haines','jordan@factor3.co.uk','Factor3','897',''),
45 (18,'Jordan Haines','jordan@factor3.co.uk','Factor 3','557',''),
46 (19,'Jordan Haines','jordan@factor3.co.uk','Factor3','449',''),
47 (20,'Jordan Haines','jordan@factor3.co.uk','Factor 3','549',''),
48 (21,'Jordan Haines','jordan@factor3.co.uk','Factor 3','266',''),
49 (22,'Jordan Haines','jordan@factor3','Factor 3','179','Yes'),
50 (24,'Jordan Haines','jordan@factor3.co.uk','Factor 3','461','No'),
51 (25,'Joe','joe.morris@facskljslkjd.com','','45','No');
52​
53/*!40000 ALTER TABLE `scores` ENABLE KEYS */;
54UNLOCK TABLES;
55​
56​
57​
58/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
59/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
60/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
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 */;