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]
