Web-Hacking-Simulation/project.sql at master · haxonic-com/Web-Hacking-Simulation · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `project`
--
-- --------------------------------------------------------

--
-- Table structure for table `csrf`BANK(not active)
--

CREATE TABLE IF NOT EXISTS `csrf` (
  `Id` int(5) NOT NULL,
  `Username` varchar(20) NOT NULL,
  `Password` varchar(20) NOT NULL,
  `Amount` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `csrf`
--

INSERT INTO `csrf` (`Id`, `Username`, `Password`, `Name`, `Account_id`, `Amount`)
(1, 'admin', 'password', 'John', 1102, 30000),
(2, 'admin2', 'password2', 'Michael', 1108, 70000);

-- --------------------------------------------------------
--
-- Table structure for table `csrf3`
--

CREATE TABLE IF NOT EXISTS `csrf3` (
  `Message` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `csrf3`
--


-- --------------------------------------------------------

--
-- Table structure for table `data`
--

CREATE TABLE IF NOT EXISTS `data` (
  `id` int(11) NOT NULL,
  `Gender` varchar(10) NOT NULL,
  `Username` varchar(15) NOT NULL,
  `Pin` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `data`
--

INSERT INTO `data` (`id`,`CardNo`,`CVV`, `Gender`, `Username`, `Pin`) VALUES
(1, '999444555213', '545', 'Female', 'Ella', '4488'),
(2, '555666111285', '588', 'Male', 'John', '8526'),
(3, '999444666213', '759', 'Female', 'Monica', '4328'),
(4, '557555666853', '823', 'Male', 'John', '8111'),
(5, '988556625254', '552', 'Female', 'Phoebe', '3698'),
(6, '558664522357', '835', 'Male', 'Max', '9552'),
(7, '954125414413', '568', 'Female', 'Bella', '8628'),
(8, '542121542002', '451', 'Male', 'Jack', '2368'),
(9, '452125451222', '782', 'Female', 'Maya', '5448'),
(10, '542114445225', '856', 'Male', 'Joey', '3255'),
(11, '525515454522', '267', 'Female', 'Rachel', '3541'),
(12, '888888444568', '245', 'Male', 'Mike', '4582'),
(13, '545454888862', '597', 'Male', 'Harvey', '4427'),
(14, '441222777858', '256', 'Female', 'Sheila', '8238'),
(15, '544455222558', '852', 'Male', 'Sean', '5452'),
(16, '452225889635', '888', 'Male', 'Jon', '1235'),
(17, '445458222585', '520', 'Female', 'Makaya', '5248'),
(18, '552566332478', '685', 'Male', 'Jacky', '2368');

------------------------

-----------------------------------------------------------------------
--
--XSS
--

CREATE TABLE IF NOT EXISTS `xss`(
`comment` VARCHAR(300) COLLATE latin1_swedish_ci NULL DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

---------------------------------------------------------------------------