PHP Classes

File: db.sql

Recommend this page to a friend!
  Classes of Hassan Ishfaq   Abdohoo Secure Login   db.sql   Download  
File: db.sql
Role: Auxiliary data
Content type: text/plain
Description: Database Structure
Class: Abdohoo Secure Login
Authenticate users with records in a MySQL table
Author: By
Last change:
Date: 14 years ago
Size: 2,547 bytes
 

Contents

Class file image Download
/* MySQL Data Transfer Source Host: localhost Source Database: abdohoo_jobportal Target Host: localhost Target Database: abdohoo_jobportal Date: 6/3/2009 5:26:36 AM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin_information -- ---------------------------- DROP TABLE IF EXISTS `admin_information`; CREATE TABLE `admin_information` ( `admin_id` int(11) NOT NULL, `admin_username` varchar(255) DEFAULT NULL, `admin_password` varchar(255) NOT NULL, `admin_full_name` varchar(255) NOT NULL, `admin_cell_no` varchar(255) NOT NULL, `admin_full_address` varchar(255) NOT NULL, `admin_country_b` varchar(255) NOT NULL, `admin_email_add` varchar(255) NOT NULL, `admin_role_name` varchar(255) NOT NULL, `admin_permission_id` int(11) NOT NULL COMMENT '1 for admin, 2 for employer manager, 3 for job seakers manager', `abdohoo_app_id` int(11) NOT NULL COMMENT 'from 100 to 500, from 501 to 95000 employers id, from 95001 to 270000 job seakers id', `admin_active_id` int(11) NOT NULL COMMENT '1 for active, 2 for deactivate, 3 for temp activate, 4 for temp deactivate', `admin_activation_date` date DEFAULT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- ---------------------------- -- Table structure for login_information -- ---------------------------- DROP TABLE IF EXISTS `login_information`; CREATE TABLE `login_information` ( `login_id` int(11) NOT NULL AUTO_INCREMENT, `abdohoo_unique_id` int(11) NOT NULL, `login_user_name` varchar(255) NOT NULL, `login_session_id` varchar(255) NOT NULL, `login_date_time` varchar(255) NOT NULL, `login_randomnumber` varchar(255) NOT NULL, `login_remoteip` varchar(255) NOT NULL, `login_useragent` varchar(255) NOT NULL, `login_remoteport` varchar(255) NOT NULL, `login_accesslevel` varchar(255) DEFAULT NULL, PRIMARY KEY (`login_id`) ) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `admin_information` VALUES ('1', 'admin', 'fe131d7f5a6b38b23cc967316c13dae2 ', 'Hassan Ishfaq', '03336114035', 'H.393, Ward No 18, Kahrorpacca', 'pakistan', 'hassan@abdohoo.com', 'admin', '1', '1', '1', null); INSERT INTO `login_information` VALUES ('60', '1', 'admin', 'b0711029b56dee3c0f4511a01140da60', '1241548653', '90797059', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.9) Gecko/2009040821 Firefox/3.0.9', '52815', 'c4ca4238a0b923820dcc509a6f75849b');