-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 26, 2014 at 03:28 PM
-- Server version: 5.5.27
-- PHP Version: 5.4.7

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

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

--
-- Table structure for table `customers`
--

CREATE TABLE IF NOT EXISTS `customers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customers_id_index` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=292 ;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Rotman School of Management', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(2, 'Qu''Appelle Beef', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(3, 'Haft2 Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(4, 'Ryerson University', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(5, 'Taxi Advertising', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(6, 'Leo Burnett Company Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(7, 'TD Asset Management', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(8, 'Royal Ontario Museum', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(9, 'Shelf Talkers', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(10, 'Adidas Canada Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(11, 'The Production Kitchen', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(12, 'Pattison Outdoor Advertising', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(13, 'London Life', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(14, 'Up Fairmont', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(15, 'Mobile Climate Control', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(16, 'AECON Infrastructure Group', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(17, 'EPC Graphics Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(18, 'Springfield Graphics Company Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(19, 'Hillert & Associates Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(20, 'York University', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(21, 'TMX Equicom', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(22, 'University College - U of T', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(23, 'Four Seasons Hotels and Resorts', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(24, 'Art Gallery of Ontario', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(25, 'Goods + Services (c)', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(26, 'BTR Graphics 2005 Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(27, 'Canadian Co-Oper Woolgrowers Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(28, 'Environmental Defence Fund', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(29, 'Zibbers Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(30, 'Fuller Landau LLP', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(31, 'Whitman Emorson', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(32, 'John St.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(33, 'Express Packaging Solutions Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(34, 'Parcel Design', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(35, 'Fogo Island Inn', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(36, 'Binders Galore Division', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(37, 'Umbra Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(38, 'Penske Business Media', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(39, 'Hagon Design', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(40, 'Modern Age Plastics Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(41, 'Hasbro Canada Corporation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(42, 'HM & E Design Communications', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(43, 'Formcor Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(44, 'UNITAS Reputation Services', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(45, 'Mark IV  In-Store Solutions Partner', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(46, 'Zulu Alpha Kilo', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(47, 'Sony Computer Entertainment', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(48, 'Gus* Design Group', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(49, 'The Hive Strategic', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(50, 'Remax Promotions', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(51, 'U of T Faculty of Applied Science & Eng', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(52, 'RJ Multi Litho', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(53, 'Cumbrae''s', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(54, 'The Collective', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(55, 'Medcan Clinic', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(56, 'The Brand Factory', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(57, 'CBS Outdoor Production', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(58, '4Print - 4XM', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(59, 'Data Group of Companies', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(60, 'Cadillac Fairview', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(61, 'Prime Visual Marketing', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(62, 'OCAD University', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(63, 'Image Folie 2000 Inc', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(64, 'Sharon Hands Graphics Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(65, 'Grip Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(66, 'entro I G+A', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(67, 'Soapbox Design Communications', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(68, 'Continental Press', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(69, 'Dana Industries', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(70, 'University of Saskatchewan', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(71, 'Day Advertising Group Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(72, 'Havas Worldwide', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(73, 'Warnaco', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(74, 'Unisource Canada Inc. (c)', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(75, 'Maribo Marketing', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(76, 'New College - U of T', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(77, 'House of Forward Foundation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(78, 'Spirit Graphics', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(79, 'Secrets From Your Sister', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(80, 'Drake Properties', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(81, 'Quarry Integrated Communications', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(82, 'Greenwood College School', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(83, 'Gluskin Sheff & Associates Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(84, 'Obsidian Theatre Company', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(85, 'York Aluminum Storms Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(86, 'Viva & Co.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(87, 'Small Design', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(88, 'RBC  Investor Services', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(89, 'Red Bull Canada Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(90, 'Astley Gilbert Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(91, 'Grosnor Industries', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(92, 'Woodbridge School of Dance', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(93, 'Broken Fence Design', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(94, 'Sparkplug Marketing & Communications Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(95, 'SonoSite Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(96, 'franklinHEAVY', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(97, 'Lizard', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(98, 'TrepanierBaer Gallery', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(99, 'Nicholas Metivier Gallery', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(100, 'Nelson Industrial Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(101, 'Proof Graphics', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(102, 'Teknion Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(103, 'Lowe Roche', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(104, 'Odessey Business Products Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(105, 'Egale', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(106, 'PROforma Creative Precision', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(107, 'Golden Triangle Printing Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(108, 'Carte Blanche Creative', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(109, 'UPS Canada Marketing', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(110, 'Neziol Group', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(111, 'Moore Canada Corp.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(112, 'Debbie Tait', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(113, 'Illumiti', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(114, 'Re.Form  (AVW)', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(115, 'Stephen Bulger Gallery', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(116, 'Lumen Dynamics', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(117, 'Sputnik Design Partners Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(118, 'Kirsten J G MacLeod', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(119, 'WeirFoulds LLP', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(120, 'Heidelberg Canada (Customer)', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(121, 'Design Dialog', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(122, 'PrintNG Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(123, 'Big Picture Conferences Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(124, 'The Vine', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(125, 'Four Seasons Hotel Des Bergues Switzer', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(126, 'MZ Canada', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(127, 'The Workhouse', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(128, 'Bank of Montreal', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(129, 'Beta Office Automation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(130, 'Nuschool Design Agency', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(131, 'Penelope Stewart', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(132, 'Counterpunch Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(133, 'C.E.M. Graphics', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(134, 'Jackman', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(135, 'RL Solutions', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(136, 'Alexander Lithographers Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(137, 'Visual Inclination Media Studio', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(138, 'Canadian Cancer Society', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(139, 'PDAC', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(140, 'Mono Arts & Graphics Printing', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(141, 'F.S. Resort Maui', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(142, 'RSA', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(143, 'Mikhael Kale', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(144, 'Marin''s Canada', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(145, 'InterAction Council - Canadain Secretaria', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(146, 'Graphics House Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(147, 'Pen Canada', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(148, 'Boss Canada', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(149, 'Joseph Brant Hospital Foundation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(150, 'Trapeze Asset Management', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(151, 'RBC Capital Market', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(152, 'Mars Unlimited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(153, 'Sealy Canada Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(154, 'Whigby Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(155, 'Alden Print Management Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(156, 'Blyth Academy', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(157, 'ArchR Graphics', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(158, 'Visual Sonics Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(159, 'Plexpack Corp.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(160, 'Forrec', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(161, 'Topix', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(162, 'Bare English & Co.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(163, 'ALSO Collective', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(164, 'Daniel Ehrenworth Photographer', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(165, 'The White Room', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(166, 'Presslinx Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(167, 'Matter Company', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(168, 'Rethink Breast Cancer', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(169, 'John H. Daniels Faculty of Architecture,', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(170, 'CELLS FOR LIFE', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(171, 'Blake-Jarrett & Company Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(172, 'Two Minutes For Music', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(173, 'TIFF', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(174, 'RP Graphics Group Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(175, 'Matrix Technology Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(176, 'Newport Private Wealth Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(177, 'Trillium Imaging Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(178, 'Yorkview Medical', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(179, 'Darcor Limited', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(180, 'IOP Graphics Ltd.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(181, 'Fuse Marketing', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(182, 'Lua Creative', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(183, 'Canadian Public Relations Society', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(184, 'Southwest Binding Systems', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(185, 'Accutec', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(186, 'Questron Technologies Corporation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(187, 'CFMDC', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(188, 'Mozilla', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(189, 'Clark Stanley', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(190, 'NR Group', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(191, 'Canadian Hospitality Foundation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(192, 'Meta Design', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(193, 'Webcom Inc.', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(194, 'The Canadian Culture Thing', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(195, 'Escort Manufacturing Corporation', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(196, 'Cdn Assoc of Chain Drug Stores', '2014-08-07 00:51:19', '2014-08-07 00:51:19', NULL),
(197, 'Elko Media & Communications', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(198, 'ISE Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(199, 'Stylegarage', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(200, 'KMB Productions Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(201, 'Ontario Physiotherapy Association', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(202, 'DSFM (Law Firm)', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(203, 'Canadian Stage', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(204, 'NewQuest - Moe', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(205, 'Percon Constructions Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(206, 'Labusch Skywear', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(207, 'Underline Studio', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(208, 'Accolade Promotion Group', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(209, 'Darling & Ninth', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(210, 'Ministry Government Services', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(211, 'Moveable', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(212, 'Crossey Engineering Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(213, 'County of Lambton', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(214, 'Printcore Graphics Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(215, 'Break Point Communications', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(216, 'Colourfast Printing', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(217, 'Genuine Fine Print', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(218, 'SDI Marketing Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(219, 'Judith & N Alix Art Gallery', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(220, 'Gateway Visual Communications', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(221, 'MD  Precision Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(222, 'Devil''s Pulpit Golf Association', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(223, 'Secret Location', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(224, 'Carnivore Club', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(225, 'Spoke Agency', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(226, 'Daneson Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(227, 'Smokey Manufacturing', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(228, 'Barbara Edwards Contemporary', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(229, 'Decal Industries', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(230, 'TheatreFront', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(231, 'Townwood Homes', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(232, 'Utex Scientific Instruments Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(233, 'Enterprise Print & Litho Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(234, 'Jacknife Design Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(235, 'Consulate General of Italy', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(236, 'Canopy Strategic  Advisory', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(237, 'Spicers Inc', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(238, 'North Island Publishing Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(239, 'Sascha Hass', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(240, '5th Business Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(241, 'Aids Committee of Toronto', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(242, 'Ferncastle (Front Street) Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(243, 'Gardiner Museum', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(244, 'Umbra Ltd.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(245, 'Farrow Logistics', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(246, 'EVillages', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(247, 'Quadrangle Architects', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(248, 'Interbrand 1', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(249, 'Northern Ontario School of Medicine', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(250, 'Score Promotions', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(251, 'Lucky 21', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(252, 'Papirmass', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(253, 'Entertainment One Films', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(254, 'IIBYIV Design', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(255, 'Healthcare Human Factors', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(256, 'Encore Promotions', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(257, 'Band Collective', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(258, 'Clearwater Communications', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(259, 'Harbour Gallery', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(260, 'Mousetrap Designs', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(261, 'Invest Toronto', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(262, 'Integrated Asset Management Corp', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(263, 'Studio Newwork', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(264, 'Centennial Opticals', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(265, 'Innovation Clic', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(266, 'University of Guelph', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(267, 'Norprint', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(268, 'Wiser Choice Promotions', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(269, 'Renegade Brand Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(270, 'Red Urban', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(271, 'Coalition for Engaged Education', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(272, 'Hayter''s Turkey Products Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(273, 'Idea Couture Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(274, 'Concrete Design Communications Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(275, 'Godin Productions Limited', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(276, 'Grand Electric', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(277, 'Just Aluminum', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(278, 'Verax Construction', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(279, 'Roots Canada', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(280, 'Design Exchange', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(281, 'Thompson Toronto', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(282, 'Exchange Lab', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(283, 'Jim Norton Photography', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(284, 'aftermodern.lab Inc.', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(285, 'Terroir', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(286, 'Mercury Promotions & Fulfillment', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(287, 'Faith Agency', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(288, 'Maple Leaf Sports & Entertainment', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(289, 'Faculty of Medicine', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(290, 'ICG', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL),
(291, 'BANG! Creative Communications', '2014-08-07 00:51:20', '2014-08-07 00:51:20', NULL);

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

--
-- Table structure for table `equipment`
--

CREATE TABLE IF NOT EXISTS `equipment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `process_id` int(10) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `equipment_id_index` (`id`),
  KEY `equipment_process_id_index` (`process_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=28 ;

--
-- Dumping data for table `equipment`
--

INSERT INTO `equipment` (`id`, `process_id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Plate Making', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 1, 'File Adjustment', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 2, 'CD102', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 2, 'CD74', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(5, 2, 'SM52', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(6, 2, 'MGI', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(7, 2, 'Windmill', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(8, 3, 'Bobst Die Cutting', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(9, 3, 'Clamshell Grey', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(10, 3, 'Cylinder Press', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(11, 3, 'Folder', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(12, 3, 'Muller Stitcher', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(13, 3, 'Perfect Binder', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(14, 3, 'Round Cornering', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(15, 3, 'Drilling', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(16, 3, 'Hand Stitcher', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(17, 3, 'Guillotine', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(18, 3, 'Serifast', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(19, 3, 'AWT', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(20, 3, 'Hand Table', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(21, 3, 'Pot Devin', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(22, 3, 'Spray Booth', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(23, 3, 'Laser', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(24, 3, 'Flocking', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(25, 3, 'Handwork', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(26, 4, 'Shrink Wrapping', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(27, 4, 'Boxing', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `groups_name_unique` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
(1, 'Guest', '{"users":1}', '2014-08-07 00:40:50', '2014-08-07 19:50:48'),
(2, 'Admins', '{"admin":1,"users":1}', '2014-08-07 00:40:50', '2014-08-07 00:40:50'),
(3, 'Representative', '{"representative":1}', '2014-08-07 19:50:30', '2014-08-07 19:50:30');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2012_12_06_225921_migration_cartalyst_sentry_install_users', 1),
('2012_12_06_225929_migration_cartalyst_sentry_install_groups', 1),
('2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot', 1),
('2012_12_06_225988_migration_cartalyst_sentry_install_throttle', 1),
('2014_08_06_160011_processes', 1),
('2014_08_06_160034_equipment', 1),
('2014_08_06_181835_customers', 1),
('2014_08_06_181899_projects', 2),
('2014_08_25_161234_tasks', 3);

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

--
-- Table structure for table `processes`
--

CREATE TABLE IF NOT EXISTS `processes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `processes_id_index` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `processes`
--

INSERT INTO `processes` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Pre-Press', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(2, 'Printing', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(3, 'Finishing', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(4, 'Packaging', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL);

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

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `customer_id` int(10) unsigned NOT NULL,
  `docket` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sheets` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `due_date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stock` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `projects_id_index` (`id`),
  KEY `projects_user_id_index` (`user_id`),
  KEY `projects_customer_id_index` (`customer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=28 ;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `user_id`, `customer_id`, `docket`, `description`, `sheets`, `due_date`, `stock`, `created_at`, `updated_at`, `deleted_at`) VALUES
(14, 2, 39, 'D123456', 'Post Cards', '500', '29-08-2014', '16 Pt Gloss', '2014-08-25 23:03:08', '2014-08-25 23:03:08', '2014-08-13 04:00:00'),
(15, 2, 39, 'D123456', 'Post Cards', '500', '29-08-2014', '16 Pt Gloss', '2014-08-25 23:03:08', '2014-08-25 23:03:08', NULL),
(16, 1, 1, '4', 'yrdy', '5', '25-08-2014', '', '2014-08-25 23:08:34', '2014-08-25 23:08:34', NULL),
(17, 1, 1, '4', 'yrdy', '5', '25-08-2014', '', '2014-08-25 23:08:34', '2014-08-25 23:08:34', NULL),
(18, 1, 1, '4', 'test', '3', '25-08-2014', '', '2014-08-25 23:11:02', '2014-08-25 23:11:02', NULL),
(19, 1, 1, '4', 'test', '3', '25-08-2014', '', '2014-08-25 23:11:02', '2014-08-25 23:11:02', NULL),
(20, 1, 1, '3', 'test', '45', '25-08-2014', '', '2014-08-25 23:11:48', '2014-08-25 23:11:48', NULL),
(21, 1, 1, '3', 'test', '45', '25-08-2014', '', '2014-08-25 23:11:48', '2014-08-25 23:11:48', NULL),
(22, 1, 1, '3', '4', '5', '25-08-2014', '', '2014-08-25 23:12:39', '2014-08-25 23:12:39', NULL),
(23, 1, 1, '3', '4', '5', '25-08-2014', '', '2014-08-25 23:12:39', '2014-08-25 23:12:39', NULL),
(24, 1, 1, 'tse', 'tes', '5', '25-08-2014', '', '2014-08-25 23:14:26', '2014-08-25 23:14:26', NULL),
(25, 1, 1, '3', 'tes', '4', '25-08-2014', '', '2014-08-25 23:15:11', '2014-08-25 23:15:11', NULL),
(26, 4, 43, 'D9898', 'Business Cards', '5000', '25-08-2014', 'Pacesetter', '2014-08-25 23:15:36', '2014-08-25 23:15:36', NULL),
(27, 1, 1, '4', 'test', '5', '25-08-2014', '', '2014-08-25 23:16:37', '2014-08-25 23:16:37', NULL);

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

--
-- Table structure for table `tasks`
--

CREATE TABLE IF NOT EXISTS `tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(10) unsigned NOT NULL,
  `process_id` int(10) unsigned NOT NULL,
  `equipment_id` int(10) unsigned NOT NULL,
  `duration` double DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tasks_id_index` (`id`),
  KEY `tasks_project_id_index` (`project_id`),
  KEY `tasks_process_id_index` (`process_id`),
  KEY `tasks_equipment_id_index` (`equipment_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `project_id`, `process_id`, `equipment_id`, `duration`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(13, 14, 2, 6, 5, 'pending', '2014-08-25 23:03:08', '2014-08-25 23:03:08', NULL),
(14, 15, 2, 6, 5, 'pending', '2014-08-25 23:03:08', '2014-08-25 23:03:08', NULL),
(15, 16, 1, 1, 6, 'pending', '2014-08-25 23:08:34', '2014-08-25 23:08:34', NULL),
(16, 17, 1, 1, 6, 'pending', '2014-08-25 23:08:34', '2014-08-25 23:08:34', NULL),
(17, 18, 1, 1, 5, 'pending', '2014-08-25 23:11:02', '2014-08-25 23:11:02', NULL),
(18, 19, 1, 1, 5, 'pending', '2014-08-25 23:11:02', '2014-08-25 23:11:02', NULL),
(19, 20, 1, 1, 5, 'pending', '2014-08-25 23:11:48', '2014-08-25 23:11:48', NULL),
(20, 21, 1, 1, 5, 'pending', '2014-08-25 23:11:48', '2014-08-25 23:11:48', NULL),
(21, 22, 1, 1, 6, 'pending', '2014-08-25 23:12:39', '2014-08-25 23:12:39', NULL),
(22, 23, 1, 1, 6, 'pending', '2014-08-25 23:12:39', '2014-08-25 23:12:39', NULL),
(23, 24, 1, 1, 5, 'pending', '2014-08-25 23:14:26', '2014-08-25 23:14:26', NULL),
(24, 25, 1, 1, 5, 'pending', '2014-08-25 23:15:11', '2014-08-25 23:15:11', NULL),
(25, 26, 1, 1, 4, 'pending', '2014-08-25 23:15:36', '2014-08-25 23:15:36', NULL),
(26, 27, 1, 1, 6, 'pending', '2014-08-25 23:16:37', '2014-08-25 23:16:37', NULL);

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

--
-- Table structure for table `throttle`
--

CREATE TABLE IF NOT EXISTS `throttle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attempts` int(11) NOT NULL DEFAULT '0',
  `suspended` tinyint(1) NOT NULL DEFAULT '0',
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `last_attempt_at` timestamp NULL DEFAULT NULL,
  `suspended_at` timestamp NULL DEFAULT NULL,
  `banned_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `throttle_user_id_index` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `throttle`
--

INSERT INTO `throttle` (`id`, `user_id`, `ip_address`, `attempts`, `suspended`, `banned`, `last_attempt_at`, `suspended_at`, `banned_at`) VALUES
(1, 2, NULL, 0, 0, 0, NULL, NULL, NULL),
(2, 1, NULL, 0, 0, 0, NULL, NULL, NULL),
(3, 3, NULL, 0, 0, 0, NULL, NULL, NULL),
(4, 4, NULL, 0, 0, 0, NULL, NULL, NULL),
(5, 5, NULL, 0, 0, 0, NULL, NULL, NULL),
(6, 6, NULL, 0, 0, 0, NULL, NULL, NULL),
(7, 7, NULL, 0, 0, 0, NULL, NULL, NULL),
(8, 8, NULL, 0, 0, 0, NULL, NULL, NULL),
(9, 9, NULL, 0, 0, 0, NULL, NULL, NULL),
(10, 10, NULL, 0, 0, 0, NULL, NULL, NULL),
(11, 11, NULL, 0, 0, 0, NULL, NULL, NULL);

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `colour` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `permissions` text COLLATE utf8_unicode_ci,
  `activated` tinyint(1) NOT NULL DEFAULT '0',
  `activation_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `activated_at` timestamp NULL DEFAULT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  `persist_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `reset_password_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ext` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_activation_code_index` (`activation_code`),
  KEY `users_reset_password_code_index` (`reset_password_code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

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

INSERT INTO `users` (`id`, `email`, `password`, `colour`, `permissions`, `activated`, `activation_code`, `activated_at`, `last_login`, `persist_code`, `reset_password_code`, `first_name`, `last_name`, `title`, `phone`, `ext`, `fax`, `created_at`, `updated_at`) VALUES
(1, 'admin@admin.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'ffffff', NULL, 1, NULL, NULL, '2014-08-25 17:23:29', '$2y$10$X9YYV/1zl3seiPtXyqX4O.aUjkXMWxfEWpBPmOm/zF5TJxboSociG', NULL, 'Sean', 'Buller', 'Developer', '2268088037', '', '', '2014-08-07 00:40:50', '2014-08-25 17:23:29'),
(2, 'user@user.com', '$2y$10$Otk8nX32u/ul0Eai0tw.Le/9k9y9nsO4G582a2Q/WTIX8MJABf7fi', 'fe0000', NULL, 1, NULL, NULL, '2014-08-07 00:41:07', '$2y$10$fqmr8GpZEY..ioeYKIxxSOMQmn3d0P1EIwibsd3xfa8B8Yj6RWvWa', NULL, 'Mark', 'LaCaria', NULL, NULL, NULL, NULL, '2014-08-07 00:40:51', '2014-08-07 18:33:47'),
(3, 'rich@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'fe0000', NULL, 1, NULL, NULL, NULL, NULL, NULL, 'Rich', 'Pauptit', 'President', '416-742-1244', '227', '416-742-4571', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'david@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'fe0000', NULL, 1, NULL, NULL, NULL, NULL, NULL, 'David', 'Gallant', 'Vice President', '416-742-1245', '223', '416-742-4572', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'derek@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'fe0000', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Derek', 'Emerson', 'Sales/Marketing Manager', '416-742-1246', '225', '416-742-4573', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'ian@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', '3531ff', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Ian', 'Budge', 'Account Manager', '416-742-1247', '240', '416-742-4574', '0000-00-00 00:00:00', '2014-08-07 20:00:11'),
(7, 'lousie@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', '6200c9', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Louise', 'Alberts', 'Account Manager', '416-742-1248', '237', '416-742-4575', '0000-00-00 00:00:00', '2014-08-07 20:00:38'),
(8, 'steve@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'ce6301', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Steve', 'Frattaroli', 'Account Manager', '416-742-1249', '222', '416-742-4576', '0000-00-00 00:00:00', '2014-08-07 20:01:05'),
(9, 'hanniel@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', '32cb00', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Hanniel', 'Ghezzi', 'Account Manager', '416-742-1250', '229', '416-742-4577', '0000-00-00 00:00:00', '2014-08-07 20:00:53'),
(10, 'leslie@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'fe0000', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Leslie', 'Vonk', 'Production Coordinator', '416-742-1251', '241', '416-742-4578', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'randy@flashreproductions.com', '$2y$10$3Lb77itjjKIHjdJ/uoJUb.5MlhqrRMxHPehLUHvHANHRzD46mORCq', 'fe0000', NULL, 0, NULL, NULL, NULL, NULL, NULL, 'Randy', 'Irving', 'Production Manager', '416-742-1252', '224', '416-742-4579', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

--
-- Table structure for table `users_groups`
--

CREATE TABLE IF NOT EXISTS `users_groups` (
  `user_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users_groups`
--

INSERT INTO `users_groups` (`user_id`, `group_id`) VALUES
(1, 1),
(1, 2),
(2, 1);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `equipment`
--
ALTER TABLE `equipment`
  ADD CONSTRAINT `equipment_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `projects_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `projects_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_equipment_id_foreign` FOREIGN KEY (`equipment_id`) REFERENCES `equipment` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_process_id_foreign` FOREIGN KEY (`process_id`) REFERENCES `processes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tasks_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE;

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