Posted By

JonnySnip3r on 10/05/12

Tagged

sql dump sslv3

Versions (?)

SQL Dump SSLv3

/ Published in: SQL

Just the sql dump for simple. secure. login v3

Highlighted TextExpand

# ************************************************************
# Sequel Pro SQL dump
# Version 3408
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: localhost (MySQL 5.5.27)
# Database: secure_login
# Generation Time: 2012-10-05 12:44:46 +0000
# ************************************************************

/*!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 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

# Dump of table members
# ------------------------------------------------------------

DROP TABLE IF EXISTS `members`;

CREATE TABLE `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(52) DEFAULT NULL,
  `lastname` varchar(52) DEFAULT NULL,
  `username` varchar(42) NOT NULL DEFAULT '',
  `password` varchar(40) NOT NULL DEFAULT '',
  `salt` varchar(40) DEFAULT NULL,
  `is_admin` int(1) NOT NULL DEFAULT '0',
  `email` varchar(128) NOT NULL DEFAULT '',
  `forgot_hash` varchar(40) DEFAULT NULL,
  `redirect` varchar(128) NOT NULL DEFAULT 'protected.php',
  `status` int(1) DEFAULT '0' COMMENT '0=awaiting activation;1=activated;2=moderator;3=admin;4=banned;',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

LOCK TABLES `members` WRITE;
/*!40000 ALTER TABLE `members` DISABLE KEYS */;

INSERT INTO `members` (`id`, `firstname`, `lastname`, `username`, `password`, `salt`, `is_admin`, `email`, `forgot_hash`, `redirect`, `status`)
VALUES
	(1,'John','Crossley','admin','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,1,'john@suburbanarctic.com','5f4dcc3b5aa765d61d8327deb882cf99','protected.php',3),
	(2,'Marilyn','Monroe','monroe','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,'marilyn.monroe@john-crossley.me','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8','protected.php',1);

/*!40000 ALTER TABLE `members` ENABLE KEYS */;
UNLOCK TABLES;

# Dump of table settings
# ------------------------------------------------------------

DROP TABLE IF EXISTS `settings`;

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `allow_registration` int(1) DEFAULT '1',
  `paypal_email` varchar(128) DEFAULT 'john@suburbanarctic.com',
  `protected_folder` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;

INSERT INTO `settings` (`id`, `allow_registration`, `paypal_email`, `protected_folder`)
VALUES
	(1,1,'john@suburbanarctic.com','secure');

/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!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 */;

Report this snippet Tweet

Comment:

You need to login to post a comment.

Posted By

Tagged

Versions (?)

SQL Dump SSLv3

Related snippets

Choose a language for easy browsing: