-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 12, 2012 at 12:27 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

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: `capstone`
--
CREATE DATABASE `capstone` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `capstone`;

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

--
-- Table structure for table `clients`
--

CREATE TABLE IF NOT EXISTS `clients` (
  `client_id` int(12) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `middle_initial` varchar(5) NOT NULL,
  `gender` varchar(12) NOT NULL,
  `company` varchar(30) NOT NULL,
  `street` varchar(20) NOT NULL,
  `city` varchar(30) NOT NULL,
  `province` varchar(30) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `guards` varchar(200) NOT NULL,
  `trash` varchar(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`client_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`client_id`, `first_name`, `last_name`, `middle_initial`, `gender`, `company`, `street`, `city`, `province`, `contact`, `guards`, `trash`) VALUES
(6, 'puy', 'Puey', 'Choos', 'Choose Gende', 'Cookie Crumbs Inc.', '', '', '', '', '', '1'),
(11, 'thea', 'ybanez', 'B', 'Female', 'apple', '', '', '', '4442461', '', '0'),
(12, 'Maureen', 'Bergavera', 'B', 'Female', 'Apple', '', '', '', '', 'A,B', '0'),
(13, 'Juan', 'Dela Cruz', 'Choos', 'Choose Gende', '', '', '', '', '', '1', '1'),
(14, 'Asiong', 'Salonga', 'Choos', 'Choose Gende', '', '', '', '', '', '1,2,1,14', '0'),
(15, 'wer', '234', 'A', 'Female', 'wer', 'wer', 'wer', 'wer', 'wer', '14<br />17', '0');

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

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

CREATE TABLE IF NOT EXISTS `employees` (
  `emp_id` int(12) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `first_name` varchar(12) NOT NULL,
  `last_name` varchar(20) NOT NULL,
  `middle_initial` varchar(12) NOT NULL,
  `gender` varchar(12) NOT NULL,
  `street` varchar(20) NOT NULL,
  `city` varchar(20) NOT NULL,
  `province` varchar(30) NOT NULL,
  `birthdate` varchar(20) NOT NULL,
  `status` varchar(20) NOT NULL,
  `philhealth` varchar(20) NOT NULL,
  `sss` varchar(20) NOT NULL,
  `control` varchar(20) NOT NULL,
  `position` varchar(20) NOT NULL,
  `email` varchar(25) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `trash` varchar(10) NOT NULL DEFAULT '0',
  `contact_per` varchar(30) NOT NULL,
  `assignment` varchar(30) NOT NULL,
  `client` varchar(30) NOT NULL,
  `sitestreet` varchar(12) NOT NULL,
  `sitecity` varchar(50) NOT NULL,
  `siteprovince` varchar(50) NOT NULL,
  `skills` varchar(100) NOT NULL,
  `equipments` varchar(100) NOT NULL,
  `image` varchar(50) NOT NULL DEFAULT 'default.png',
  PRIMARY KEY (`emp_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

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

INSERT INTO `employees` (`emp_id`, `type`, `first_name`, `last_name`, `middle_initial`, `gender`, `street`, `city`, `province`, `birthdate`, `status`, `philhealth`, `sss`, `control`, `position`, `email`, `contact`, `trash`, `contact_per`, `assignment`, `client`, `sitestreet`, `sitecity`, `siteprovince`, `skills`, `equipments`, `image`) VALUES
(14, 'guard', '', 'badayos', 'B', 'Female', 'a', 'b', 'c', '01/03/2012', 'Single', '7789', '9875', '89', 'Administrator', 'yeah', '', '0', '', 'Assigned', '', '', '', '', '', '2', 'default.png'),
(17, 'guard', 'maria', 'ybanez', 'D', 'Female', 'a', 'b', 'c', '02/14/2012', 'Married', 'a', 'a', '', 'Administrator', 'a', 'a', '0', 'a', 'Assigned', 'Maureen Bergavera', 'a', 'a', 'a', 'a', 'a', '132844528731058.jpg'),
(18, 'guard', '123', '123', 'Choose Middl', 'Choose Gende', '123', '123', '123', '02/07/2012', 'Single', '123', '123', '', 'Janitorial Staff', '123', '', '0', '', 'Choose Status', 'thea ybanez', '', '', '', '', '', 'default.png'),
(19, 'emp', 'q123', '', 'Choose Middl', 'Choose Gende', '', '', '', '', 'Choose Status', '', '', '', 'Choose Position', '', '', '0', '', 'Choose Status', 'puy Puey', '', '', '', '', '', 'default.png'),
(20, 'guard', '', '', 'Choose Middl', 'Choose Gende', '', '', '', '', 'Choose Status', '', '', '', 'Choose Position', '', '', '0', '', 'Choose Status', 'puy Puey', '', '', '', '', '', 'default.png');

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

--
-- Table structure for table `equipments`
--

CREATE TABLE IF NOT EXISTS `equipments` (
  `equip_id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) NOT NULL,
  `type` varchar(30) NOT NULL,
  `model` varchar(30) NOT NULL,
  `brand` varchar(30) NOT NULL,
  `quantity` varchar(20) NOT NULL,
  `price` varchar(20) NOT NULL,
  `license` varchar(20) NOT NULL,
  `permit_from` varchar(20) NOT NULL,
  `permit_to` varchar(20) NOT NULL,
  `control_num` varchar(20) NOT NULL,
  `guards` text NOT NULL,
  `image` varchar(50) NOT NULL DEFAULT 'default.jpg',
  `license_pic` varchar(50) NOT NULL DEFAULT 'default.jpg',
  PRIMARY KEY (`equip_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `equipments`
--

INSERT INTO `equipments` (`equip_id`, `name`, `type`, `model`, `brand`, `quantity`, `price`, `license`, `permit_from`, `permit_to`, `control_num`, `guards`, `image`, `license_pic`) VALUES
(6, 'aa', 'Choose Equipment Type', 'model 2', 'brand y', '14', '1', '2', '01/31/2012', '02/28/2012', '123', '', 'default.jpg', 'default.jpg'),
(7, 'aa', 'Office', 'model 2', 'brand y', '14', '1', '2', '01/31/2012', '02/28/2012', '123', '2,3', 'default.jpg', 'default.jpg'),
(9, 'wer', 'Biometrics', 'model 1', 'brand x', 'wer', '123', '123', '01/31/2012', '01/30/2012', '123', '', '1327835238t.jpg', '1327835416s.jpg'),
(10, 'd', 'Office', 'model 2', 'brand y', 'd', 'd', 'd', '01/30/2012', '01/31/2012', 'd', 'pulis2 test lastname', 'default.jpg', 'default.jpg'),
(11, 's', 'Office', 'model 1', 'brand x', 'a', 'a', 'a', '01/30/2012', '01/04/2012', '1', '', '1327831635ins.jpg', 'default.jpg'),
(12, 'd', 'Biometrics', 'model 1', 'brand x', 'd', 'f', 'f', '01/25/2012', '01/31/2012', 'f', '', '1327831806s.jpg', 'default.jpg'),
(13, '5', 'Office', 'model 1', 'brand x', '17', '1', '4', '01/31/2012', '01/24/2012', '3', '', 'default.jpg', 'default.jpg'),
(14, 'sdf', 'Choose Equipment Type', 'model 1', 'brand x', 'sdf', 'sdf', 'sdf', '01/24/2012', '01/30/2012', '23', '', '1327833526anthemum.jpg', 'default.jpg'),
(15, 'ert', 'Choose Equipment Type', 'model 1', 'brand x', 'wer', 'wer', 'wer', '01/23/2012', '01/23/2012', '234', '', '1327833748ins.jpg', '1327833753s.jpg'),
(16, 'sder', 'Office', 'model 1', 'brand x', 'wer', 'wer', 'wer', '01/05/2012', '01/10/2012', '234', '', '1327834029house.jpg', '1327834037anthemum.jpg'),
(17, 'Althea', 'Biometrics', 'Apple', 'Apple', '3', '8900', '1233', '02/22/2012', '02/16/2012', '', '123123<br />maria ybanez', 'default.jpg', 'default.jpg'),
(18, 'twtewtrwer', 'Choose Equipment Type', '', '', '', '', '', '', '', '', 'badayos', 'default.jpg', 'default.jpg'),
(19, 'erwer', 'Choose Equipment Type', '', '', '', '', '', '', '', '', 'badayos', 'default.jpg', 'default.jpg'),
(20, 'fhj', 'Choose Equipment Type', '', '', '', '', '', '', '', '', 'badayos', 'default.jpg', 'default.jpg');

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

--
-- Table structure for table `expenses`
--

CREATE TABLE IF NOT EXISTS `expenses` (
  `exp_id` int(12) NOT NULL AUTO_INCREMENT,
  `exp_name` varchar(20) NOT NULL,
  `exp_type` varchar(30) NOT NULL,
  `quantity` varchar(20) NOT NULL,
  `cost` varchar(12) NOT NULL,
  `date` varchar(12) NOT NULL,
  `trash` varchar(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`exp_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`exp_id`, `exp_name`, `exp_type`, `quantity`, `cost`, `date`, `trash`) VALUES
(1, 'e', 'Default Purchase Expense', '17', '1', '01/02/2012', '1'),
(2, 'weh', 'Choose Type', '', '', '', '1'),
(3, 'tarong', 'Default Purchase Expense', '123', '123', '02/27/2012', '0'),
(4, 'CENECO Jan. 2012', 'Default Purchase Expense', '1', '1200.00', '02/24/2012', '0'),
(5, 'ahoi', 'Bank Fees', '6', '6', '02/21/2012', '1');

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

--
-- Table structure for table `history`
--

CREATE TABLE IF NOT EXISTS `history` (
  `history_id` int(11) NOT NULL AUTO_INCREMENT,
  `data` varchar(30) NOT NULL,
  `actions` varchar(20) NOT NULL,
  `date` varchar(20) NOT NULL,
  `user` varchar(20) NOT NULL,
  PRIMARY KEY (`history_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ;

--
-- Dumping data for table `history`
--

INSERT INTO `history` (`history_id`, `data`, `actions`, `date`, `user`) VALUES
(36, 'wwwwwwwwwww ererwer', 'added client', '2/12/2012 17:53:18', 'Admin'),
(2, ' badayos', 'modified employee', '2/12/2012 16:41:10', 'Admin'),
(37, 'Asiong Salonga', 'modified client', '2012-02-12 10:08 AM', 'Admin'),
(15, 'Admin', 'modified user', '2/12/2012 17:7:53', 'Admin'),
(43, '4', 'deleted sched', '2/12/2012 18:19:52', 'Admin'),
(47, '1', 'updated sched', '2/12/2012 18:33:12', 'Admin'),
(10, '234', 'added user', '2/12/2012 16:56:50', 'Admin'),
(11, '32', 'deleted user', '2/12/2012 17:1:9', 'Admin'),
(26, '13', 'deleted client', '2/12/2012 17:32:1', 'Admin'),
(50, 'wer', 'added sched', '2/12/2012 18:36:10', 'Admin'),
(53, '5', 'deleted equipment', '2/12/2012 18:54:16', 'Admin'),
(55, 'twtewtrwer', 'added equipment', '2/12/2012 18:58:8', 'Admin'),
(56, 'erwer', 'added equipment', '2/12/2012 19:0:41', 'Admin'),
(57, 'fhj', 'added equipment', '2/12/2012 19:2:37', 'Admin'),
(68, '02/07/2012 to 02/13/2012', 'modified transaction', '2/12/2012 19:43:46', 'Admin'),
(69, '02/15/2012 02/29/2012', 'added transaction', '2/12/2012 19:46:12', 'Admin');

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

--
-- Table structure for table `monitoring`
--

CREATE TABLE IF NOT EXISTS `monitoring` (
  `trans_id` int(12) NOT NULL AUTO_INCREMENT,
  `transact_from` varchar(12) NOT NULL,
  `transact_to` varchar(12) NOT NULL,
  `guards` varchar(90) NOT NULL,
  `client` varchar(30) NOT NULL,
  `equipments` varchar(90) NOT NULL,
  `ranking` varchar(20) NOT NULL,
  PRIMARY KEY (`trans_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `monitoring`
--

INSERT INTO `monitoring` (`trans_id`, `transact_from`, `transact_to`, `guards`, `client`, `equipments`, `ranking`) VALUES
(2, '01/04/2012', '01/22/2012', '123', 'thea', 'mia', '123123'),
(3, '12-15-2011', '12-05-2011', '123', 'a', 'b', '123123'),
(11, '02/07/2012', '02/01/2012', '2,1', '123', '6,9', '123'),
(12, '02/10/2012', '02/24/2012', 'falconeriebadayos,maria ybanez', 'Maureen Bergavera', 'wer,Maureen Bergavera', '7'),
(13, '02/09/2012', '02/14/2012', 'falconeriebadayos,123 123', 'Maureen Bergavera', 'ert,thea ybanez', 'ad'),
(14, '02/08/2012', '02/22/2012', '123123', 'Juan Dela Cruz', 'ert', '0'),
(15, '', '02/23/2012', '123123', 'puy Puey', 'test', 'u'),
(16, '02/07/2012', '02/24/2012', 'qq', 'puy Puey', 'test', ''),
(17, '02/08/2012', '', 'qq', 'puy Puey', 'test', ''),
(18, '02/07/2012', '02/13/2012', 'Array', 'puy Puey', 'Array', '4.75'),
(19, '02/15/2012', '02/29/2012', 'badayos', 'puy Puey', 'aa', '2.5');

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

--
-- Table structure for table `schedules`
--

CREATE TABLE IF NOT EXISTS `schedules` (
  `sched_id` int(12) NOT NULL AUTO_INCREMENT,
  `activity` varchar(50) NOT NULL,
  `date` varchar(20) NOT NULL,
  `time` varchar(20) NOT NULL,
  `persons` varchar(12) NOT NULL,
  `clients` varchar(300) NOT NULL,
  `street` varchar(20) NOT NULL,
  `city` varchar(20) NOT NULL,
  `province` varchar(30) NOT NULL,
  PRIMARY KEY (`sched_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `schedules`
--

INSERT INTO `schedules` (`sched_id`, `activity`, `date`, `time`, `persons`, `clients`, `street`, `city`, `province`) VALUES
(1, 'bacoloadiat', '', '02.00 AM', 'ako<br />ika', 'thea ybanez<br />puy Puey<br />puy Puey', 'lacson', 'bacolod', 'negros'),
(2, 'valentines', '02/14/2012', '7:00', 'ako,ikaw', '', 'lagoon', 'bacolod', 'negros'),
(7, 'wer', '02/06/2012', '12.30 PM', '4', ',', 'wer', 'wer', 'wer'),
(10, 'lagaw', 'Feb 06 2012', '12.00 PM', '9,9,4', '11,6,puy Puey', '123123', '123123', '123123'),
(11, 'wew', '02/16/2012', '12.00 PM', '14', 'puy Puey', '', '', ''),
(12, 'wew', '02/16/2012', '12.00 PM', '14', 'puy Puey', '', '', ''),
(13, 'wer', '02/18/2012', '12.00 PM', '14', 'puy Puey', '', '', '');

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

--
-- Table structure for table `test`
--

CREATE TABLE IF NOT EXISTS `test` (
  `test_id` int(12) NOT NULL AUTO_INCREMENT,
  `attendance` text NOT NULL,
  `custom` varchar(12) NOT NULL,
  `date` varchar(12) NOT NULL,
  PRIMARY KEY (`test_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`test_id`, `attendance`, `custom`, `date`) VALUES
(1, 'p1, test2, test3', '', ''),
(2, 'wertwet, wet2, wer3, wer4', '', ''),
(3, 'lim, serion, edwardo, drix, neil, eric, michael, roldan, fritz, lehi', 'wahateever', '12-05-2011');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(12) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(12) NOT NULL,
  `middle_initial` varchar(12) NOT NULL,
  `last_name` varchar(12) NOT NULL,
  `username` varchar(12) NOT NULL,
  `password` varchar(50) NOT NULL,
  `user_type` varchar(20) NOT NULL,
  `photo` varchar(50) NOT NULL DEFAULT 'default.jpg',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

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

INSERT INTO `users` (`user_id`, `first_name`, `middle_initial`, `last_name`, `username`, `password`, `user_type`, `photo`) VALUES
(1, 'Thea', 'Choose Middl', 'Ybanez', 'Admin', '21232f297a57a5a743894a0e4a801fc3', 'administrator', 'default.jpg'),
(25, 'arooz', 'Choose Middl', 'wop', '234', '234', 'Administrator', '1327838323ngeas.jpg'),
(26, 'Maria Althea', 'D', 'Ybanez', 'tsangthei', 'donaleigh', 'Administrator', '1327843466.jpg'),
(28, 'leo', 'Choose Middl', '', 'first', 'first', 'Administrator', 'default.jpg'),
(29, 'love', 'Choose Middl', 'love', 'love', '202cb962ac59', 'Administrator', 'default.jpg'),
(30, 'test', 'A', 'test', 'test', '098f6bcd4621d373cade4e832627b4f6', 'User', '132903398631369ngeas.jpg'),
(31, '1', 'Choose Middl', '2', '', 'd41d8cd98f00b204e9800998ecf8427e', 'Administrator', 'default.jpg'),
(33, 'wer', 'Choose Middl', '', '', 'd41d8cd98f00b204e9800998ecf8427e', 'Administrator', 'default.jpg'),
(34, '234', 'Choose Middl', '234', '234', '289dff07669d7a23de0ef88d2f7129e7', 'Administrator', 'default.jpg');

/*!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 */;
