This tutorial is all about Creating Database and Setting Up tables.
Now, I’m going to start this tutorial on how to create a database and set up the tables that are needed. You have to install XAMMP in your computer. After that, open the browser and type the “localhos/phpmyadmin/” in the navigation panel and press enter on the keyboard in your computer to redirect into the MySQL Localhost. Create a database and name it “dbinformation”. Then, do this query for creating all the tables.
For the employees table
[mysql]
CREATE TABLE IF NOT EXISTS employees
(
ID
int(11) AUTO_INCREMENT NOT NULL,
EMPLOYEE_ID
int(11) NOT NULL,
FIRST_NAME
varchar(255) DEFAULT NULL,
LAST_NAME
varchar(255) DEFAULT NULL,
MIDDLE_NAME
varchar(255) DEFAULT NULL,
ADDRESS
varchar(255) DEFAULT NULL,
PHONE_NUMBER
varchar(255) DEFAULT NULL,
STATUS
varchar(255) DEFAULT NULL,
BIRTH_DATE
datetime DEFAULT NULL,
BIRTH_PLACE
varchar(255) DEFAULT NULL,
GENDER
varchar(255) DEFAULT NULL,
AGE
int(11) DEFAULT NULL,
EMERG_CONTACT
varchar(255) DEFAULT NULL,
PRIMARY KEY (ID
),
KEY (EMPLOYEE_ID
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[/mysql]
For the employees work information table
[mysql]
CREATE TABLE IF NOT EXISTS employeesworkinfo
(
ID
int(11) AUTO_INCREMENT DEFAULT NULL,
EMPLOYEE_ID
varchar(255) NOT NULL,
D_RATE
varchar(255) DEFAULT NULL,
POSITION
varchar(90) DEFAULT NULL,
P_METHOD
varchar(255) DEFAULT NULL,
W_STATUS
varchar(255) DEFAULT NULL,
D_HIRED
datetime DEFAULT NULL,
PRIMARY KEY (ID
),
KEY (EMPLOYEE_ID
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[/mysql]
For the users table
[mysql]
CREATE TABLE IF NOT EXISTS USERACCOUNTS
(
ID
int(11) AUTO_INCREMENT DEFAULT NULL,
USER_ID
varchar(255) NOT NULL,
UNAME
varchar(255) DEFAULT NULL,
USERNAME
varchar(255) DEFAULT NULL,
PASS
varchar(255) DEFAULT NULL,
TYPE
varchar(30) DEFAULT NULL,
PRIMARY KEY (ID
),
KEY (USER_ID
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[/mysql]