Welcome Dhakkan
SETTING UP THE DATABASE SCHEMA AND POPULATING DATA IN TABLES:
";}
else
{echo "[*]...................Error purging database: " . mysql_error(); echo "";}
//Creating new database security
$sql="CREATE database `security`";
if (mysql_query($sql))
{echo "[*]...................Creating New database successfully";echo "";}
else
{echo "[*]...................Error creating database: " . mysql_error();echo "";}
//creating table users
$sql="CREATE TABLE security.users (id int(3) NOT NULL AUTO_INCREMENT, username varchar(20) NOT NULL, password varchar(20) NOT NULL, PRIMARY KEY (id))";
if (mysql_query($sql))
{echo "[*]...................Creating New Table 'users' successfully";echo "";}
else
{echo "[*]...................Error creating Table: " . mysql_error();echo "";}
//creating table emails
$sql="CREATE TABLE security.emails
(
id int(3)NOT NULL AUTO_INCREMENT,
email_id varchar(30) NOT NULL,
PRIMARY KEY (id)
)";
if (mysql_query($sql))
{echo "[*]...................Creating New Table 'emails' successfully"; echo "";}
else
{echo "[*]...................Error creating Table: " . mysql_error();echo "";}
//creating table uagents
$sql="CREATE TABLE security.uagents
(
id int(3)NOT NULL AUTO_INCREMENT,
uagent varchar(256) NOT NULL,
ip_address varchar(35) NOT NULL,
username varchar(20) NOT NULL,
PRIMARY KEY (id)
)";
if (mysql_query($sql))
{echo "[*]...................Creating New Table 'uagents' successfully";echo "";}
else
{echo "[*]...................Error creating Table: " . mysql_error();echo "";}
//creating table referers
$sql="CREATE TABLE security.referers
(
id int(3)NOT NULL AUTO_INCREMENT,
referer varchar(256) NOT NULL,
ip_address varchar(35) NOT NULL,
PRIMARY KEY (id)
)";
if (mysql_query($sql))
{echo "[*]...................Creating New Table 'referers' successfully";echo "";}
else
{echo "[*]...................Error creating Table: " . mysql_error();echo "";}
//inserting data
$sql="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'), ('9', 'admin1', 'admin1'), ('10', 'admin2', 'admin2'), ('11', 'admin3', 'admin3'), ('12', 'dhakkan', 'dumbo'), ('14', 'admin4', 'admin4')";
if (mysql_query($sql))
{echo "[*]...................Inserted data correctly into table 'users'";echo "";}
else
{echo "[*]...................Error inserting data: " . mysql_error();echo "";}
//inserting data
$sql="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')";
if (mysql_query($sql))
{echo "[*]...................Inserted data correctly into table 'emails'";echo "";}
else
{echo "[*]...................Error inserting data: " . mysql_error();echo "";}
//CREATE TABLE security.search (id int(3) NOT NULL AUTO_INCREMENT, search varchar(20) NOT NULL, PRIMARY KEY (id));
//INSERT INTO `security`.`search` (search) VALUES ( 'Dumb@dhakkan.com'), ('Angel@iloveu.com'), ('Dummy@dhakkan.local'), ( 'secure@dhakkan.local'), ( 'stupid@dhakkan.local'), ( 'superman@dhakkan.local'), ( 'batman@dhakkan.local'), ( 'admin@dhakkan.com')";
?>