Skip to content
Newer
Older
100755 39 lines (33 sloc) 1.23 KB
8e6458e @Audi-1 first commit
authored
1 DROP DATABASE IF EXISTS security;
2 CREATE database security;
3 USE security;
4 CREATE TABLE users
5 (
6 id int(3) NOT NULL AUTO_INCREMENT,
7 username varchar(20) NOT NULL,
8 password varchar(20) NOT NULL,
9 PRIMARY KEY (id)
10 );
11 CREATE TABLE emails
12 (
13 id int(3)NOT NULL AUTO_INCREMENT,
14 email_id varchar(30) NOT NULL,
15 PRIMARY KEY (id)
16 );
17 CREATE TABLE uagents
18 (
19 id int(3)NOT NULL AUTO_INCREMENT,
20 uagent varchar(256) NOT NULL,
21 ip_address varchar(35) NOT NULL,
22 username varchar(20) NOT NULL,
23 PRIMARY KEY (id)
24 );
25 CREATE TABLE referers
26 (
27 id int(3)NOT NULL AUTO_INCREMENT,
28 referer varchar(256) NOT NULL,
29 ip_address varchar(35) NOT NULL,
30 PRIMARY KEY (id)
31 );
32
33 INSERT INTO security.users (id, username, password) VALUES ('1', 'Dumb', 'Dumb'), ('2', 'Angelina', 'I-kill-you'), ('3', 'Dummy', 'p@ssword'), ('4', 'secure', 'crappy'), ('5', 'stupid', 'stupidity'), ('6', 'superman', 'genious'), ('7', 'batman', 'mob!le'), ('8', 'admin', 'admin');
34
35 INSERT INTO `security`.`emails` (id, email_id) VALUES ('1', 'Dumb@dhakkan.com'), ('2', 'Angel@iloveu.com'), ('3', 'Dummy@dhakkan.local'), ('4', 'secure@dhakkan.local'), ('5', 'stupid@dhakkan.local'), ('6', 'superman@dhakkan.local'), ('7', 'batman@dhakkan.local'), ('8', 'admin@dhakkan.com');
36
37
38
Something went wrong with that request. Please try again.