jobscope.sql ( File view )

  • By webdev1122 2014-08-13
  • View(s):64
  • Download(s):0
  • Point(s): 1
			-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 10, 2010 at 05:01 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `jobscope`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `applicants`
-- 

CREATE TABLE `applicants` (
  `a_id` int(4) NOT NULL auto_increment,
  `a_uid` varchar(30) NOT NULL,
  `a_jid` varchar(30) NOT NULL,
  PRIMARY KEY  (`a_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

-- 
-- Dumping data for table `applicants`
-- 

INSERT INTO `applicants` (`a_id`, `a_uid`, `a_jid`) VALUES 
(17, '11', '15'),
(18, '10', '18'),
(19, '10', '15'),
(20, '12', '19'),
(21, '12', '17'),
(22, '12', '20'),
(23, '10', '17');

-- --------------------------------------------------------

-- 
-- Table structure for table `categories`
-- 

CREATE TABLE `categories` (
  `cat_id` int(4) NOT NULL auto_increment,
  `cat_nm` varchar(30) NOT NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

-- 
-- Dumping data for table `categories`
-- 

INSERT INTO `categories` (`cat_id`, `cat_nm`) VALUES 
(10, 'inport-export'),
(11, 'it-software'),
(12, 'it-hardware'),
(14, 'banking'),
(20, 'finance');

-- --------------------------------------------------------

-- 
-- Table structure for table `contact`
-- 

CREATE TABLE `contact` (
  `cont_id` int(4) NOT NULL auto_increment,
  `cont_fnm` varchar(30) NOT NULL,
  `cont_email` varchar(20) NOT NULL,
  `cont_query` varchar(300) NOT NULL,
  PRIMARY KEY  (`cont_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- 
-- Dumping data for table `contact`
-- 

INSERT INTO `contact` (`cont_id`, `cont_fnm`, `cont_email`, `cont_query`) VALUES 
(14, 'riddhi', 'riddhi_patel@gmail.c', 'xyz'),
(15, 'darshana', 'darshana@yahoo.com', 'abc');

-- --------------------------------------------------------

-- 
-- Table structure for table `employees`
-- 

CREATE TABLE `employees` (
  `ee_id` int(4) NOT NULL auto_increment,
  `ee_fnm` varchar(30) NOT NULL,
  `ee_pwd` varchar(10) NOT NULL,
  `ee_gender` varchar(1) NOT NULL,
  `ee_email` varchar(30) NOT NULL,
  `ee_add` varchar(300) NOT NULL,
  `ee_phno` varchar(10) NOT NULL,
  `ee_mobileno` varchar(10) NOT NULL,
  `ee_current_location` varchar(20) NOT NULL,
  `ee_annualsalary` int(10) NOT NULL,
  `ee_current_industry` varchar(20) NOT NULL,
  `ee_qualification` varchar(10) NOT NULL,
  `ee_profile` varchar(300) NOT NULL,
  `ee_resume` longtext NOT NULL,
  PRIMARY KEY  (`ee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- 
-- Dumping data for table `employees`
-- 

INSERT INTO `employees` (`ee_id`, `ee_fnm`, `ee_pwd`, `ee_gender`, `ee_email`, `ee_add`, `ee_phno`, `ee_mobileno`, `ee_current_location`, `ee_annualsalary`, `ee_current_industry`, `ee_qualification`, `ee_profile`, `ee_resume`) VALUES 
(10, 'megha', 'megha11', 'f', 'megha_patel@gmail.com', '"megha",2nd floor ,rajkot', '0281257254', '9934235456', 'rajkot', 45000, 'infosys', 'mba', 'xyz', 'uploads/megha.doc'),
(11, 'darshana', 'darshana', 'f', 'darshana_\\@yahoo.com', '"darshana",ahemadabad', '0792345672', '9423456789', 'mumbai', 35000, 'tcs', 'mtec', 'xyz', 'uploads/darshana.doc'),
(12, 'parth', 'parth1111', 'M', 'parth@gmail.com', '"parth",bhavnagar.', '0278213355', '9923555676', 'bhavnagar', 40000, 'tata', 'mba', 'xyz', 'uploads/parth.doc'),
(13, 'samir', '123123123', 'M', 'samir@gmail.com', '"samin",borivaly,mumbai.', '0112345678', '9987766554', 'mumbai', 40000, 'birla', 'mba', 'xyz', 'uploads/samin.doc');

-- --------------------------------------------------------

-- 
-- Table structure for table `employers`
-- 

CREATE TABLE `employers` (
  `er_id` int(4) NOT NULL auto_increment,
  `er_fnm` varchar(30) NOT NULL,
  `er_pwd` varchar(10) NOT NULL,
  `er_company` varchar(30) NOT NULL,
  `er_add` varchar(100) NOT NULL,
  `er_ph` varchar(10) NOT NULL,
  `er_email` varchar(30) NOT NULL,
  `er_company_profile` varchar(300) NOT NULL,
  PRIMARY KEY  (`er_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

-- 
-- Dum
...
...
(Please download the complete source code to view)
			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 1

Download
0 lines left, continue to read
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
category.php2.47 kB12-07-14|17:53
contact.php1.97 kB12-07-14|17:53
delete.png715.00 B12-03-06|23:22
img01.jpg1.06 kB06-09-09|11:19
img02.jpg355.00 B06-09-09|11:27
img03.jpg1.12 kB06-09-09|11:53
img04.jpg859.00 B06-09-09|11:53
img05.jpg2.90 kB06-09-09|11:57
img06.jpg10.31 kB06-09-09|12:33
img07.jpg16.93 kB06-09-09|12:36
img08.jpg18.01 kB06-09-09|12:36
img09.jpg332.00 B06-09-09|12:57
img10.jpg3.53 kB06-09-09|13:16
spacer.gif43.00 B24-06-09|01:31
Thumbs.db21.00 kB11-03-14|17:22
footer.inc.php94.00 B05-02-10|17:56
head.inc.php241.00 B05-02-10|18:03
logo.inc.php63.00 B12-02-10|17:33
menu.inc.php368.00 B03-04-10|18:57
search.inc.php206.00 B05-02-10|17:58
sidebar.inc.php1.51 kB11-03-14|17:28
index.php1.71 kB10-04-10|17:08
process_addcategories.php670.00 B12-07-14|17:53
process_delete.php434.00 B12-07-14|17:53
process_deletecategories.php683.00 B12-07-14|17:54
process_logout.php77.00 B18-03-10|20:38
process_verify.php357.00 B12-07-14|17:54
style.css6.33 kB05-02-10|17:28
verify.php2.29 kB12-07-14|17:54
backup0.00 B1636|28%
Contact.php1.96 kB20-03-10|17:11
employeeregister.php2.95 kB20-03-10|17:09
employerregister.php2.35 kB20-03-10|17:10
form.html290.00 B09-10-09|17:45
hourglass.png744.00 B12-03-06|23:23
house.png806.00 B12-03-06|23:23
delete.png715.00 B12-03-06|23:22
img01.jpg1.06 kB06-09-09|11:19
img02.jpg355.00 B06-09-09|11:27
img03.jpg1.12 kB06-09-09|11:53
img04.jpg859.00 B06-09-09|11:53
img05.jpg2.90 kB06-09-09|11:57
img06.jpg10.31 kB06-09-09|12:33
img07.jpg16.93 kB06-09-09|12:36
img08.jpg18.01 kB06-09-09|12:36
img09.jpg332.00 B06-09-09|12:57
img10.jpg3.53 kB06-09-09|13:16
spacer.gif43.00 B24-06-09|01:31
Thumbs.db23.00 kB11-03-14|17:28
footer.inc.php94.00 B05-02-10|17:56
head.inc.php241.00 B05-02-10|18:03
logo.inc.php63.00 B12-02-10|17:33
menu.inc.php1.01 kB03-04-10|17:28
search.inc.php206.00 B05-02-10|17:58
sidebar.inc.php1.37 kB11-03-14|17:30
index.php1.92 kB12-07-14|17:49
applicants.frm8.42 kB28-09-10|12:52
applicants.MYD140.00 B28-09-10|12:52
applicants.MYI2.00 kB28-09-10|12:52
categories.frm8.40 kB28-09-10|12:52
categories.MYD104.00 B28-09-10|12:52
categories.MYI2.00 kB28-09-10|12:52
contact.frm8.48 kB28-09-10|12:52
contact.MYD80.00 B28-09-10|12:52
contact.MYI2.00 kB28-09-10|12:52
db.opt65.00 B28-09-10|12:52
employees.frm8.92 kB28-09-10|12:52
employees.MYD556.00 B28-09-10|12:52
employees.MYI2.00 kB28-09-10|12:52
employers.frm8.63 kB28-09-10|12:52
employers.MYD512.00 B28-09-10|12:59
employers.MYI2.00 kB28-09-10|13:00
jobs.frm8.71 kB28-09-10|12:52
jobs.MYD540.00 B28-09-10|12:52
jobs.MYI2.00 kB28-09-10|12:52
jobscope.sql6.11 kB10-04-10|18:31
jobs_by_category.php2.14 kB12-07-14|17:50
job_details.php2.77 kB12-07-14|17:50
manage.php2.72 kB12-07-14|17:50
money.png738.00 B12-03-06|23:24
monitor.png612.00 B12-03-06|23:24
postjob.php2.72 kB12-07-14|17:50
process_apply.php406.00 B12-07-14|17:50
process_contact.php753.00 B12-07-14|17:51
process_del_job.php339.00 B12-07-14|17:51
process_employee_register.php2.38 kB12-07-14|17:51
process_employer_register.php1.17 kB12-07-14|17:51
process_login.php1.64 kB12-07-14|17:51
process_logout.php77.00 B18-03-10|20:38
process_postjob.php1.25 kB12-07-14|17:52
show.php2.49 kB12-07-14|17:52
star.png670.00 B12-03-06|23:27
style.css6.33 kB05-02-10|17:28
Semiproject_guidelines.doc47.50 kB10-04-10|19:26
Web.config7.66 kB23-10-10|18:22
images0.00 B12-07-14|17:40
includes0.00 B12-07-14|17:40
admin0.00 B12-07-14|17:54
images0.00 B12-07-14|17:40
includes0.00 B12-07-14|17:40
jobscope0.00 B12-07-14|17:40
uploads0.00 B12-07-14|17:40
jobscope0.00 B12-07-14|17:52
...
Sponsored links

jobscope.sql (177.24 kB)

Need 1 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D