File: db.sql

/*
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');