advanced code snippet search

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

Expand | Embed | Plain Text 
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Version 3408
  4. #
  5. # http://www.sequelpro.com/
  6. # http://code.google.com/p/sequel-pro/
  7. #
  8. # Host: localhost (MySQL 5.5.27)
  9. # Database: secure_login
  10. # Generation Time: 2012-10-05 12:44: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 members
  24. # ------------------------------------------------------------
  25.  
  26. DROP TABLE IF EXISTS `members`;
  27.  
  28. CREATE TABLE `members` (
  29.   `id` int(11) NOT NULL AUTO_INCREMENT,
  30.   `firstname` varchar(52) DEFAULT NULL,
  31.   `lastname` varchar(52) DEFAULT NULL,
  32.   `username` varchar(42) NOT NULL DEFAULT '',
  33.   `password` varchar(40) NOT NULL DEFAULT '',
  34.   `salt` varchar(40) DEFAULT NULL,
  35.   `is_admin` int(1) NOT NULL DEFAULT '0',
  36.   `email` varchar(128) NOT NULL DEFAULT '',
  37.   `forgot_hash` varchar(40) DEFAULT NULL,
  38.   `redirect` varchar(128) NOT NULL DEFAULT 'protected.php',
  39.   `status` int(1) DEFAULT '0' COMMENT '0=awaiting activation;1=activated;2=moderator;3=admin;4=banned;',
  40.   PRIMARY KEY (`id`)
  41. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  42.  
  43. LOCK TABLES `members` WRITE;
  44. /*!40000 ALTER TABLE `members` DISABLE KEYS */;
  45.  
  46. INSERT INTO `members` (`id`, `firstname`, `lastname`, `username`, `password`, `salt`, `is_admin`, `email`, `forgot_hash`, `redirect`, `status`)
  47. VALUES
  48. 	(1,'John','Crossley','admin','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,1,'[email protected]','5f4dcc3b5aa765d61d8327deb882cf99','protected.php',3),
  49. 	(2,'Marilyn','Monroe','monroe','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8',NULL,0,'[email protected]','5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8','protected.php',1);
  50.  
  51. /*!40000 ALTER TABLE `members` ENABLE KEYS */;
  52. UNLOCK TABLES;
  53.  
  54.  
  55. # Dump of table settings
  56. # ------------------------------------------------------------
  57.  
  58. DROP TABLE IF EXISTS `settings`;
  59.  
  60. CREATE TABLE `settings` (
  61.   `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  62.   `allow_registration` int(1) DEFAULT '1',
  63.   `paypal_email` varchar(128) DEFAULT '[email protected]',
  64.   `protected_folder` varchar(128) DEFAULT NULL,
  65.   PRIMARY KEY (`id`)
  66. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  67.  
  68. LOCK TABLES `settings` WRITE;
  69. /*!40000 ALTER TABLE `settings` DISABLE KEYS */;
  70.  
  71. INSERT INTO `settings` (`id`, `allow_registration`, `paypal_email`, `protected_folder`)
  72. VALUES
  73. 	(1,1,'[email protected]','secure');
  74.  
  75. /*!40000 ALTER TABLE `settings` ENABLE KEYS */;
  76. UNLOCK TABLES;
  77.  
  78.  
  79.  
  80. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  81. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  82. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  83. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  84. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  85. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Report this snippet  

You need to login to post a comment.