Password List SQL

SUBMITTED BY: Guest

DATE: Dec. 4, 2013, 11:48 a.m.

FORMAT: Text only

SIZE: 2.6 kB

Raw Download

HITS: 670

Report
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.3.9
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Erstellungszeit: 11. September 2012 um 21:59
  7. -- Server Version: 5.5.8
  8. -- PHP-Version: 5.3.5
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8 */;
  18. --
  19. -- Datenbank: `pw-list`
  20. --
  22. -- --------------------------------------------------------
  24. --
  25. -- Tabellenstruktur für Tabelle `hash`
  26. --
  27. -- Erzeugt am: 11. September 2012 um 14:43
  28. --
  30. DROP TABLE IF EXISTS `hash`;
  31. CREATE TABLE IF NOT EXISTS `hash` (
  32. `HID` bigint(20) NOT NULL AUTO_INCREMENT,
  33. `PWID` bigint(20) NOT NULL,
  34. `MD5` varchar(64) COLLATE latin1_general_cs NOT NULL,
  35. `SHA` varchar(64) COLLATE latin1_general_cs NOT NULL,
  36. PRIMARY KEY (`HID`)
  37. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=1 ;
  39. --
  40. -- Daten für Tabelle `hash`
  41. --
  44. -- --------------------------------------------------------
  46. --
  47. -- Tabellenstruktur für Tabelle `pw`
  48. --
  49. -- Erzeugt am: 11. September 2012 um 14:57
  50. --
  52. DROP TABLE IF EXISTS `pw`;
  53. CREATE TABLE IF NOT EXISTS `pw` (
  54. `PWID` bigint(20) NOT NULL AUTO_INCREMENT,
  55. `PW` varchar(255) COLLATE latin1_general_cs NOT NULL,
  56. `COUNT` bigint(11) NOT NULL DEFAULT '1',
  57. `CID` int(11) NOT NULL DEFAULT '1',
  58. PRIMARY KEY (`PWID`),
  59. UNIQUE KEY `PW` (`PW`)
  60. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=3 ;
  62. --
  63. -- Daten für Tabelle `pw`
  64. --
  66. INSERT INTO `pw` (`PWID`, `PW`, `COUNT`, `CID`) VALUES
  67. (1, 'test', 1, 1),
  68. (2, 'TEST', 1, 2);
  70. -- --------------------------------------------------------
  72. --
  73. -- Tabellenstruktur für Tabelle `pw-cat`
  74. --
  75. -- Erzeugt am: 11. September 2012 um 14:39
  76. --
  78. DROP TABLE IF EXISTS `pw-cat`;
  79. CREATE TABLE IF NOT EXISTS `pw-cat` (
  80. `CID` int(11) NOT NULL AUTO_INCREMENT,
  81. `CATEGORY` varchar(150) COLLATE latin1_general_cs NOT NULL,
  82. PRIMARY KEY (`CID`),
  83. UNIQUE KEY `CATEGORY` (`CATEGORY`)
  84. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs AUTO_INCREMENT=4 ;
  86. --
  87. -- Daten für Tabelle `pw-cat`
  88. --
  90. INSERT INTO `pw-cat` (`CID`, `CATEGORY`) VALUES
  91. (1, 'non-cat'),
  92. (2, 'other'),
  93. (3, 'wordlist');
comments powered by Disqus