http://nekmat.com.my Got Leaked By Tupai_Kun

Got Leaked By Tupai_Kun
Thanks : BabyMoon | Arya Kun H7 | Revan Ar | Prass7
Family : SMC 45 | Razzer Attacker Network | Attacker Network Team |

http://nekmat.com.my

-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 27, 2009 at 03:15 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

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

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

CREATE TABLE `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 `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=1 ;

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


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

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

CREATE TABLE `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'),
('FC-3', 'Faculty'),
('PE-5', 'Permanent'),
('PR-4', 'Provisionary');

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

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

CREATE TABLE `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,
  `position` 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`, `position`) VALUES
(1, 2600874, 'Lester', 'Lubiano', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'Administrator'),
(8, 2600123, 'Princi', 'Nocasa', 'director', '235acfdf1375f5efd80203aca782a2f5e0f135ab', 'Director'),
(7, 2600847, 'Rod', 'Abulencia', 'faculty', '5cee1c23e1604e9ae4f2c0e93bbb4c6eb72b5f2c', 'Faculty');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ldays`
--
ALTER TABLE `ldays`
  ADD CONSTRAINT `FK_ldays` FOREIGN KEY (`posid`) REFERENCES `ldays` (`posid`),
  ADD CONSTRAINT `posid` FOREIGN KEY (`posid`) REFERENCES `position` (`posid`);