/
test.sql
71 lines (70 loc) · 2.96 KB
/
test.sql
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
CREATE TABLE IF NOT EXISTS `flt_data` (
`id_spam` int(11) unsigned NOT NULL AUTO_INCREMENT,
`from_spam` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`mail_spam` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ip_addr` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_spam`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
INSERT INTO `flt_data` (`id_spam`, `from_spam`, `mail_spam`, `ip_addr`) VALUES
(1, 'Angel', 'bonser@gmail.com', ''),
(2, 'Mackenzie', 'lifestile@msn.com', ''),
(3, 'Mya', 'lightsoul@gmail.com', ''),
(4, 'Chase', 'pitfighter@hotmail.com', ''),
(5, 'Jackson', 'nogood87@yahoo.com', ''),
(6, 'Anthony', 'kidrock@msn.com', ''),
(7, 'Anthony', 'dirtbill@yahoo.com', ''),
(8, 'Sydney', 'lifestile@msn.com', ''),
(9, 'Layla', 'john@hotmail.com', ''),
(10, 'Jake', 'flyman@gmail.com', ''),
(11, 'crazyfrog', 'friend35@hotmail.com', ''),
(12, 'Angel', 'thebest@hotmail.com', ''),
(13, 'Sean', 'lightsoul@gmail.com', ''),
(14, 'Isaac', 'pitfighter@hotmail.com', ''),
(15, 'Aiden', 'freelife@yahoo.com', ''),
(16, 'Xavier', 'lifestile@msn.com', ''),
(17, 'Lillian', 'friend35@hotmail.com', ''),
(18, 'Angel', 'friend35@hotmail.com', ''),
(19, 'Sofia', 'fifa55@yahoo.com', ''),
(20, 'David', 'gobiz@gmail.com', ''),
(21, 'Morgan', 'deadman@gmail.com', ''),
(22, 'Thomas', 'heyjew@msn.com', ''),
(23, 'Serenity', 'freeman@hotmail.com', ''),
(24, 'Lucas', 'lightsoul@gmail.com', ''),
(25, 'coolman', 'fifa55@yahoo.com', ''),
(26, 'Emily', 'freelife@yahoo.com', ''),
(27, 'Eli', 'flyman@gmail.com', ''),
(28, 'heyjew', 'cooler111@yahoo.com', ''),
(29, 'Caroline', 'lightsoul@gmail.com', ''),
(30, 'Rebecca', 'greenwood@webtown.com', ''),
(31, 'Jack', 'heyjew@msn.com', ''),
(32, 'Olivia', 'lightsoul@gmail.com', ''),
(33, 'Cameron', 'lightsoul@gmail.com', ''),
(34, 'Valeria', 'getjoy@msn.com', ''),
(35, 'Leslie', 'incomeppc@hotmail.com', ''),
(36, 'Tyler', 'quaker@yahoo.com', ''),
(37, 'John', 'deadman@gmail.com', ''),
(38, 'Amelia', 'steep777@yahoo.com', ''),
(39, 'Michelle', 'goodboy@yahoo.com', ''),
(40, 'Natalie', 'eblanned@yahoo.com', ''),
(41, 'Ava', 'crazyfrog@hotmail.com', ''),
(42, 'Nathaniel', 'getjoy@msn.com', ''),
(43, 'Cole', 'coco888@msn.com', ''),
(44, 'Payton', 'quaker@yahoo.com', ''),
(45, 'Alyssa', 'coolman@msn.com', ''),
(46, 'nogood87', 'coco888@msn.com', ''),
(47, 'Layla', 'cooler111@yahoo.com', ''),
(48, 'Matthew', 'friend35@hotmail.com', ''),
(49, 'Khloe', 'thebest@hotmail.com', ''),
(50, 'Aiden', 'razer22@yahoo.com', ''),
(51, 'Daniel', 'goodsam@gmail.com', ''),
(52, 'Hunter', 'rikky@aol.com', ''),
(53, 'rikky', 'lightsoul@gmail.com', ''),
(54, 'Aidan', 'pitfighter@hotmail.com', ''),
(55, 'Peyton', 'coco888@msn.com', ''),
(56, 'greenwood', 'coco888@msn.com', ''),
(57, 'Lillian', 'deadman@gmail.com', ''),
(58, 'Devin', 'razer22@yahoo.com', ''),
(59, 'Elijah', 'razer22@yahoo.com', ''),
(60, 'Charles', 'behappy@yahoo.com', ''),
(61, 'Jaden', 'unlove@gmail.com', ''),
(62, 'Mary', 'dirtbill@yahoo.com', '188.143.232.111');