-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 10, 2015 at 07:19 AM
-- Server version: 5.5.42-cll
-- PHP Version: 5.4.31

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: `bronnern_gotool2`
--

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

--
-- Table structure for table `capcontrol3`
--

CREATE TABLE IF NOT EXISTS `capcontrol3` (
  `caplist_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL DEFAULT '0',
  `approved_id` int(11) NOT NULL DEFAULT '0',
  `ip` varchar(15) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL,
  `na1` int(11) NOT NULL,
  `compl1` int(11) NOT NULL,
  `approver` int(11) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_addedC` datetime NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `propic` varchar(200) COLLATE utf8_bin NOT NULL DEFAULT 'noimages.jpg',
  PRIMARY KEY (`caplist_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=90 ;

--
-- Dumping data for table `capcontrol3`
--

INSERT INTO `capcontrol3` (`caplist_id`, `task_id`, `approved_id`, `ip`, `status`, `na1`, `compl1`, `approver`, `date_added`, `date_addedC`, `customer_id`, `propic`) VALUES
(1, 183, 0, '0', 0, 3, 0, 195, '2014-01-31 07:41:42', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(2, 78, 0, '0', 0, 0, 0, 195, '2014-01-30 16:13:05', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(3, 51, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(4, 52, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(5, 83, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(6, 123, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(7, 129, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(8, 110, 0, '0', 0, 0, 0, 195, '2014-01-30 16:14:06', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(9, 111, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(10, 112, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(11, 113, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(12, 114, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(13, 115, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(14, 116, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(15, 145, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(16, 158, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(17, 159, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(18, 160, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(19, 167, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(20, 168, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(21, 169, 0, '0', 1, 2, 0, 195, '2014-01-30 16:22:45', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(22, 170, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(23, 85, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(24, 86, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(25, 87, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(26, 88, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(27, 64, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(28, 65, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(29, 66, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(30, 67, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(31, 68, 0, '0', 0, 1, 0, 195, '2014-01-30 20:30:03', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(32, 48, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(33, 53, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(34, 54, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(35, 55, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(36, 80, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(37, 81, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(38, 82, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(39, 184, 0, '0', 0, 3, 0, 195, '2014-01-31 07:41:42', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(40, 185, 0, '0', 0, 3, 0, 195, '2014-01-31 07:41:42', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(41, 186, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(42, 187, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(43, 198, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(44, 201, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(45, 49, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(46, 50, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(47, 58, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(48, 59, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(49, 60, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(50, 61, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(51, 62, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(52, 63, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(53, 124, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(54, 125, 0, '0', 1, 1, 0, 195, '2014-01-30 22:46:48', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(55, 138, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(56, 139, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(57, 140, 0, '0', 1, 2, 0, 195, '2014-01-31 07:46:35', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(58, 193, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(59, 194, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(60, 195, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(61, 196, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(62, 197, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(63, 204, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(64, 205, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(65, 206, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(66, 207, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(67, 240, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(68, 241, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(69, 242, 0, '0', 1, 3, 0, 195, '2014-01-31 11:04:29', '0000-00-00 00:00:00', 195, 'noimages.jpg'),
(70, 32, 0, '0', 1, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(71, 33, 0, '0', 3, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(72, 34, 0, '0', 3, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(73, 35, 0, '0', 3, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(74, 36, 0, '0', 3, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(75, 37, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(76, 38, 0, '0', 1, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(77, 39, 0, '0', 1, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(78, 58, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(79, 59, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(80, 61, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(81, 64, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(82, 66, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(83, 67, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(84, 68, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(85, 73, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(86, 89, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(87, 90, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(88, 91, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.jpg'),
(89, 92, 0, '0', 2, 4, 0, 224, '2014-02-13 16:10:44', '0000-00-00 00:00:00', 224, 'noimages.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 */;