ccse.sql ( File view )

  • By cox 2014-08-14
  • View(s):156
  • Download(s):9
  • Point(s): 2
			-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 15, 2013 at 10:14 AM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `ccse`
--

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

--
-- Table structure for table `employee`
--

CREATE TABLE IF NOT EXISTS `employee` (
  `eid` int(100) NOT NULL,
  `fname` char(100) NOT NULL,
  `mname` char(100) NOT NULL,
  `lname` char(100) NOT NULL,
  `bday` varchar(100) NOT NULL,
  `age` int(100) NOT NULL,
  `gender` char(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `status` char(100) NOT NULL,
  `contact` int(100) NOT NULL,
  `posid` varchar(100) NOT NULL,
  `date_added` date NOT NULL,
  `added_by` varchar(100) NOT NULL,
  PRIMARY KEY (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`eid`, `fname`, `mname`, `lname`, `bday`, `age`, `gender`, `address`, `status`, `contact`, `posid`, `date_added`, `added_by`) VALUES
(0, 'fgbnfg', 'gfbgf', 'gfbgfb', 'March 3,1962', 676, 'Female', 'fghngg', ' Married', 4565654, 'DR-2', '2013-06-15', 'Lester'),
(3433, 'grggerg', 'egergreg', 'rrgreger', 'March 3,1962', 23, 'Male', 'werww', ' Married', 2147483647, 'FC-3', '2013-06-15', 'Lester'),
(4545, 'sdfsd', 'sdgsdg', 'sgs', 'Febuary 3,1962', 5, 'Male', 'dfgfg', ' Married', 546456456, 'DR-2', '2013-06-15', 'Lester'),
(897562, 'masangala', 'johanna', 'masangala', 'Febuary 17,1968', 60, 'Male', '50 mumias', ' Married', 701115689, 'PR-4', '2013-06-16', 'shiundu'),
(2400123, 'Princi', 'Hardcore', 'Nocasa', 'January 2,1985', 22, 'Male', 'Lingsat', ' Single', 2147483647, 'DR-2', '2008-11-15', 'Princi'),
(2600847, 'Rod Emmanuel', 'Perez', 'Abulencia', 'October 24,1989', 19, 'Male', 'Brgy 4 SFC', ' Single', 915123456, 'PE-5', '2008-12-13', 'Princi'),
(2600874, 'Lester', 'Quiza', 'Lubiano', 'April 7,1989', 19, 'Male', 'Dalumpinas', ' Single', 2147483647, 'AD-1', '2008-11-15', 'Princi'),
(2604256, 'Ronel Joy', 'Velarmino', 'Fernandez', 'August 15,1989', 19, 'Male', 'Bauang', ' Single', 920123456, 'PR-4', '2008-12-13', 'Princi'),
(7895623, 'judy', 'shirika', 'mammy', 'April 6,1990', 22, 'Female', '50 mmust', ' Married', 707536811, 'PE-5', '2013-06-16', 'shiundu'),
(27272478, 'shiundu', 'omondi', 'jonathan', 'October 10,1989', 23, 'Male', '3240 Eldoret', ' Single', 717002320, 'AD-1', '2013-06-17', 'shiundu'),
(27272479, 'ran', 'sirika', 'jona', 'Febuary 4,1989', 20, 'Male', '3240 eld', ' Single', 717002320, 'PR-4', '2013-06-16', 'shiundu'),
(27274589, 'ROSE', 'LILIAN', 'MASANGALA', 'June 6,1968', 50, 'Female', '50 mumias', ' Married', 720100064, 'PR-4', '2013-06-16', 'shiundu'),
(456855621, 'mark', 'john', 'domo', 'Febuary 11,1989', 89, 'Male', '123 eldy', ' Married', 722285720, 'PE-5', '2013-06-16', 'shiundu');

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

--
-- Table structure for table `ldays`
--

CREATE TABLE IF NOT EXISTS `ldays` (
  `id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `posid` varchar(10) NOT NULL,
  `adays` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `posid` (`posid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ldays`
--

INSERT INTO `ldays` (`id`, `posid`, `adays`) VALUES
(1, 'PR-4', 7),
(2, 'PE-5', 15);

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

--
-- Table structure for table `leaves`
--

CREATE TABLE IF NOT EXISTS `leaves` (
  `leaveid` int(100) NOT NULL AUTO_INCREMENT,
  `eid` int(100) DEFAULT NULL,
  `fdate` date DEFAULT NULL,
  `leavetype` char(100) DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `endate` date DEFAULT NULL,
  `reason` varchar(100) DEFAULT NULL,
  `recommending` char(100) DEFAULT 'pending',
  `deanstatus` char(100) NOT NULL DEFAULT 'pending',
  `directorstatus` char(100) NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`leaveid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `leaves`
--

INSERT INTO `leaves` (`leaveid`, `eid`, `fdate`, `leavetype`, `edate`, `endate`, `reason`, `recommending`, `deanstatus`, `directorstatus`) VALUES
(1, 2604256, '2009-02-11', 'day/s vacation leave with pay', '2009-02-10', '2009-02-17', 'sorry i will have my leave', 'Approved', 'Approval', 'Approved'),
(2, 2600847, '2013-06-15', 'day/s sick without pay', '2009-02-14', '2009-02-14', 'revenue', 'pending', 'Approval', 'pending'),
(3, 27274589, '2013-06-17', 'birthday leave with pay', '2013-06-17', '0000-00-00', 'pliz i humbly ask for leave from \r\nthe specified', 'pending', 'Approval', 'pending'),
(4, 27274589, '2013-06-17', 'birthday leave with pay', '2013-06-17', '0000-00-00', 'pliz i humbly ask for leave from \r\nthe specified', 'pending', 'Approval', 'pending'),
(5, 456855621, '2013-06-17', 'day/s emergency leave with pay', '2013-02-17', '2013-03-07', 'please i need leave', 'pending', 'Approval', 'pending'),
(6, 27272479, '2013-06-17', 'day/s emergency leave with pay', '2013-03-19', '2013-06-30', 'i have to attend for my nephew burrial', 'Approved', 'Approval', 'Approved'),
(7, 897562, '2013-06-17', 'day/s vacation leave without pay', '2013-06-17', '2013-07-19', 'vacation', 'Approved', 'Approval', 'Approved'),
(8, 2600847, '2013-07-26', 'day/s sick leave with pay', '2013-07-26', '2013-07-30', 'sick leave', 'Approved', 'Disapproval', 'Approved');

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

--
-- Table structure for table `position`
--

CREATE TABLE IF NOT EXISTS `position` (
  `posid` varchar(100) NOT NULL,
  `position` char(100) DEFAULT NULL,
  PRIMARY KEY (`posid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `position`
--

INSERT INTO `position` (`posid`, `position`) VALUES
('AD-1', 'Administrator'),
('DR-2', 'Director'),
('PE-5', 'Permanent'),
('PR-4', 'Provisionary');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `userid` int(3) NOT NULL,
  `eid` int(10) NOT NULL,
  `fname` varchar(20) NOT NULL,
  `lname` varchar(20) NOT NULL,
  `username` varchar(15) NOT NULL,
  `password` char(40) NOT NULL,
  `posid` varchar(25) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`userid`, `eid`, `fname`, `lname`, `username`, `password`, `posid`) VALUES
(1, 2600874, 'shiundu', 'jonathan', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'AD-1'),
(8, 2600123, 'Nyongesa', 'John', 'director', '235acfdf1375f5efd80203aca782a2f5e0f135ab', 'DR-2'),
(7, 2600847, 'Purity', 'Joan', 'manager', '5cee1c23e1604e9ae4f2c0e93bbb4c6eb72b5f2c', 'PE-5'),
(0, 27272479, 'man', 'yhj', 'nmbg', '40bd001563085fc35165329ea1ff5c5ecbdbbeef', 'FC-3'),
(0, 27272478, 'head of section', 'jonathan', 'shiundu', '360d20736eefda7d81e77f019b24dd474d12ea78', 'DR-2');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 2

Download
0 lines left, continue to read

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
add-employee.php8.98 kB04-07-14 10:43
add-user.php3.26 kB04-07-14 10:27
approve.php157.00 B07-02-09 04:33
date-added.php496.00 B14-02-09 00:10
db-backup-1371292492-5cac8f65a378cc19b150279db357c567.sql3.23 kB15-06-13 06:34
db-backup-1371360757-5cac8f65a378cc19b150279db357c567.sql3.80 kB16-06-13 01:32
db-backup-1371377572-5cac8f65a378cc19b150279db357c567.sql4.88 kB16-06-13 06:12
db-backup-1402914697-5cac8f65a378cc19b150279db357c567.sql6.12 kB16-06-14 13:31
db_backup.php1.79 kB09-11-08 22:21
del-users.php2.39 kB09-02-09 14:49
delete-employee.php2.51 kB07-02-09 05:11
delete-users.php2.32 kB10-02-09 14:45
del_emp.php2.44 kB07-02-09 05:14
deny.php158.00 B07-02-09 04:33
edate.php499.00 B13-02-09 13:42
edit-user.php2.15 kB14-02-09 00:05
editemp-frm.php3.08 kB30-12-08 15:53
edit_emp.php5.08 kB29-11-08 23:07
emp-list.php6.30 kB04-02-09 14:35
emp-profile.php1.67 kB14-02-09 00:03
endate.php499.00 B13-02-09 13:44
fdate.php487.00 B12-02-09 13:24
footer.html104.00 B18-06-14 18:01
header.html5.94 kB18-06-14 15:10
start.php344.00 B16-12-08 05:35
dwsync.xml286.00 B18-06-14 18:01
index.php2.14 kB25-06-14 15:21
logout.php848.00 B18-06-14 17:45
main-index.php397.00 B16-06-14 13:26
month.php486.00 B11-02-09 07:10
month2.php499.00 B13-02-09 14:59
print-report.php1.17 kB11-02-09 07:07
print.php5.41 kB25-06-14 13:41
search-edit.php3.86 kB17-12-08 06:09
search-edituser.php3.86 kB17-12-08 06:11
search.php3.89 kB15-06-13 12:53
verify-editemp.php561.00 B09-02-09 08:09
verifyedit-user.php454.00 B09-02-09 14:35
view-leave.php3.06 kB17-06-13 04:32
viewedit-employee.php5.72 kB14-02-09 00:15
viewedit-user.php4.38 kB09-02-09 07:03
viewpending-leaves.php2.50 kB15-06-13 12:49
dwsync.xml860.00 B04-07-14 10:43
ccse.sql7.20 kB15-08-13 06:14
date.inc.php589.00 B07-11-08 17:12
dbcon.php467.00 B11-06-14 17:19
dapproved.php184.00 B27-02-09 02:11
ddeny.php191.00 B07-02-09 04:33
emp-profile.php1.66 kB14-02-09 00:02
footer.html104.00 B18-06-14 18:00
header.html6.01 kB18-06-14 17:50
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 18:00
logout.php848.00 B18-06-14 17:43
main-index.php403.00 B18-06-14 17:58
search.php3.96 kB16-06-13 00:26
view-leave.php1.98 kB16-06-13 01:29
viewpending-leaves.php2.50 kB16-06-13 00:28
dwsync.xml288.00 B18-06-14 17:58
fidfrm.php1.64 kB16-06-13 01:15
approval.jpg1.82 kB01-12-08 06:42
approved.jpg1.87 kB01-12-08 06:40
back.gif7.49 kB15-10-08 20:36
Brain_Mill_Logo_1b-1.gif8.41 kB16-02-09 13:23
cancel.gif2.49 kB11-02-09 00:45
delete.jpg1.61 kB01-12-08 06:43
disapproval.jpg1.99 kB01-12-08 06:42
disapproved.jpg2.07 kB01-12-08 06:42
edit.jpg1.35 kB30-11-08 00:37
exthome.png79.83 kB16-02-09 12:16
login.gif208.73 kB08-02-09 07:34
logo.png106.01 kB16-06-14 13:23
nzoia.jpg425.23 kB15-06-13 15:31
print2.gif2.50 kB31-12-08 03:14
resume.gif3.03 kB30-12-08 15:26
top.gif13.75 kB16-06-14 13:36
view.gif2.52 kB20-12-08 00:06
top.gif.mno113.00 B16-06-14 13:36
footer.html104.00 B16-06-14 12:39
header.html5.76 kB18-06-14 17:51
start.php344.00 B08-09-08 13:34
dwsync.xml286.00 B18-06-14 17:51
index.php2.17 kB19-06-14 10:24
leave.php8.69 kB30-07-14 17:17
logout.php842.00 B18-06-14 17:27
main-index.php380.00 B18-06-14 18:07
mysql_connect.php645.00 B07-11-08 03:55
<NSC>0.00 BSystem.ppt 1940992
Reminder.txt192.00 B12-05-09 07:22
Resume.doc35.50 kB18-06-13 00:14
search.php3.50 kB16-06-13 01:21
setid.php1.31 kB21-02-09 08:21
view-availableleave.php1.41 kB07-02-09 04:59
view-leave.php1.67 kB20-02-09 15:51
viewpending-leaves.php2.19 kB16-06-13 01:17
dwsync.xml621.00 B30-07-14 17:17
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<New>0.00 B0% 15-06-13
<_notes>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<_notes>0.00 B09-08-14 11:29
<admin>0.00 B09-08-14 11:29
<database>0.00 B09-08-14 11:29
<director>0.00 B09-08-14 11:29
<images>0.00 B09-08-14 11:29
<includes>0.00 B09-08-14 11:29
<presentation>0.00 B09-08-14 11:29
<resume>0.00 B09-08-14 11:29
<sick-leave>0.00 B28-04-09 00:20
<_notes>0.00 B09-08-14 11:29
<OnlineLeaveSystem>0.00 B09-08-14 11:29
...

ccse.sql (931.49 kB)

Need 2 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