-- phpMyAdmin SQL Dump
-- version 3.3.2deb1ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 24, 2018 at 08:04 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.10-1~lucid+2uwsgi2

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

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

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

CREATE TABLE IF NOT EXISTS `clients` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `login` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `clients` (`id`, `name`, `submitter`, `date_submitted`, `login`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2012-02-01 16:10:43', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `clients_con`
--

CREATE TABLE IF NOT EXISTS `clients_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clients_con`
--

INSERT INTO `clients_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE IF NOT EXISTS `contacts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-08-15 00:34:29', 1, 0, 1, 5, 'Activate', 'change_status', 0, 1, 1),
(2, 'Deleted', 1, '2012-02-01 16:11:25', 0, 1, 0, 16, 'Delete', 'change_status', 0, 2, 1);

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

--
-- Table structure for table `contacts_con`
--

CREATE TABLE IF NOT EXISTS `contacts_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `contacts_con`
--

INSERT INTO `contacts_con` (`id`, `con_id`) VALUES
(1, 2),
(2, 1),
(3, 1);

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

--
-- Table structure for table `departments`
--

CREATE TABLE IF NOT EXISTS `departments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `departments_con`
--

CREATE TABLE IF NOT EXISTS `departments_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `departments_con`
--

INSERT INTO `departments_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

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

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `login` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `groups` (`id`, `name`, `submitter`, `date_submitted`, `login`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2009-10-08 05:40:06', 1, 0, 1, 5, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Suspended', 1, '2009-10-08 07:15:24', 0, 0, 1, 7, 'Suspend', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2011-08-11 19:33:36', 0, 1, 0, 16, 'Delete', 'change_status', 1, 3, 1);

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

--
-- Table structure for table `groups_con`
--

CREATE TABLE IF NOT EXISTS `groups_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `groups_con`
--

INSERT INTO `groups_con` (`id`, `con_id`) VALUES
(1, 2),
(1, 3),
(2, 1),
(2, 3),
(3, 1);

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

--
-- Table structure for table `jobs`
--

CREATE TABLE IF NOT EXISTS `jobs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2012-02-07 18:03:07', 1, 0, 1, 86, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 3),
(3, 'Deleted', 1, '2011-12-21 22:35:16', 0, 0, 0, 16, 'Delete', 'change_status', 1, 3, 1),
(51, 'On Hold', 1, '2012-01-11 16:01:55', 1, 1, 0, 19, 'On Hold', 'change_status', 0, 2, 1),
(52, 'Complete', 1, '2012-01-11 16:02:13', 1, 0, 1, 4, 'Complete', 'change_status', 0, 3, 1),
(53, 'Pending', 1, '2012-02-17 14:55:26', 1, 0, 1, 20, 'Pending', 'change_status', 0, 2, 1);

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

--
-- Table structure for table `jobs_con`
--

CREATE TABLE IF NOT EXISTS `jobs_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jobs_con`
--

INSERT INTO `jobs_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(4, 1),
(51, 1),
(52, 1),
(1, 3),
(2, 3),
(53, 3),
(4, 5),
(7, 5),
(8, 5),
(4, 6),
(5, 8),
(9, 8),
(8, 9),
(1, 51),
(51, 52);

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

--
-- Table structure for table `job_tracking`
--

CREATE TABLE IF NOT EXISTS `job_tracking` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `job_tracking`
--

INSERT INTO `job_tracking` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `job_tracking_con`
--

CREATE TABLE IF NOT EXISTS `job_tracking_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `job_tracking_con`
--

INSERT INTO `job_tracking_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `job_types`
--

CREATE TABLE IF NOT EXISTS `job_types` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `job_types`
--

INSERT INTO `job_types` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2012-01-05 11:28:49', 1, 0, 1, 86, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `job_types_con`
--

CREATE TABLE IF NOT EXISTS `job_types_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `job_types_con`
--

INSERT INTO `job_types_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `labour`
--

CREATE TABLE IF NOT EXISTS `labour` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `labour`
--

INSERT INTO `labour` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `labour_con`
--

CREATE TABLE IF NOT EXISTS `labour_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `labour_con`
--

INSERT INTO `labour_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

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

CREATE TABLE IF NOT EXISTS `leaves` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

INSERT INTO `leaves` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2012-01-05 15:11:54', 1, 0, 1, 86, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 3, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 4, 1),
(4, 'Approve', 1, '2012-01-05 15:12:07', 1, 0, 0, 4, 'Approve', 'change_status', 0, 2, 1);

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

--
-- Table structure for table `leaves_con`
--

CREATE TABLE IF NOT EXISTS `leaves_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `leaves_con`
--

INSERT INTO `leaves_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(1, 2),
(4, 2),
(5, 2),
(1, 3),
(2, 3),
(4, 3),
(5, 3),
(1, 4);

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

--
-- Table structure for table `materials_inventory`
--

CREATE TABLE IF NOT EXISTS `materials_inventory` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `materials_inventory`
--

INSERT INTO `materials_inventory` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `materials_inventory_con`
--

CREATE TABLE IF NOT EXISTS `materials_inventory_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials_inventory_con`
--

INSERT INTO `materials_inventory_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `quotes`
--

CREATE TABLE IF NOT EXISTS `quotes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `complete` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `quotes`
--

INSERT INTO `quotes` (`id`, `name`, `submitter`, `date_submitted`, `complete`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Open', 1, '2012-01-11 16:03:31', 0, 0, 1, 86, 'Reopen', 'change_status', 0, 1, 1),
(2, 'Deleted', 1, '2011-11-15 14:32:51', 0, 1, 0, 16, 'Delete', 'change_status', 1, 4, 1),
(3, 'Completed', 1, '2011-08-14 23:51:06', 1, 0, 1, 4, 'Complete', 'change_status', 0, 3, 1),
(4, 'On Hold', 1, '2012-01-11 16:03:44', 0, 0, 1, 19, 'On Hold', 'change_status', 0, 2, 1),
(5, 'Cancelled', 1, '2012-02-02 19:58:30', 0, 0, 0, 41, 'Cancel', 'change_status', 0, 5, 1);

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

--
-- Table structure for table `quotes_con`
--

CREATE TABLE IF NOT EXISTS `quotes_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quotes_con`
--

INSERT INTO `quotes_con` (`id`, `con_id`) VALUES
(1, 2),
(1, 4),
(1, 5),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(5, 3),
(6, 1),
(6, 2);

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

--
-- Table structure for table `quotes_tasks`
--

CREATE TABLE IF NOT EXISTS `quotes_tasks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `quotes_tasks`
--

INSERT INTO `quotes_tasks` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `quotes_tasks_con`
--

CREATE TABLE IF NOT EXISTS `quotes_tasks_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `quotes_tasks_con`
--

INSERT INTO `quotes_tasks_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `request`
--

CREATE TABLE IF NOT EXISTS `request` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;

--
-- Dumping data for table `request`
--

INSERT INTO `request` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-11-13 20:03:19', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 3),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 3),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 3),
(4, 'Awaiting Approval', 1, '2011-11-12 16:36:31', 1, 0, 1, 32, 'Awaiting Approval', 'change_status', 0, 42, 1),
(5, 'Pending Qualification', 1, '2011-11-14 19:04:31', 1, 0, 1, 75, 'Pending Qualification', 'change_status', 0, 40, 1),
(7, 'New', 1, '2011-11-14 16:32:19', 1, 0, 1, 35, 'New', 'change_status', 0, 41, 1),
(8, 'Qualified', 1, '2011-11-15 08:42:43', 1, 0, 1, 4, 'Qualified', 'change_status', 0, 38, 1),
(9, 'Pending Site Survey', 1, '2011-11-15 06:32:25', 1, 0, 1, 62, 'Pending Site Survey', 'change_status', 0, 39, 1),
(10, 'Pending Visual Art Mockup', 1, '2011-11-15 07:57:57', 1, 0, 1, 80, 'Pending Visual Art Mockup', 'change_status', 0, 11, 1),
(11, 'Completed Site Survey', 1, '2011-11-15 12:44:41', 1, 0, 1, 62, 'Completed Site Survey', 'change_status', 0, 12, 1),
(12, 'Completed Visual Art Mockup', 1, '2011-11-15 12:45:07', 1, 0, 1, 62, 'Completed Visual Art Mockup', 'change_status', 0, 13, 1),
(13, 'Pending Costing', 1, '2011-11-15 12:45:40', 1, 0, 1, 62, 'Pending Costing', 'change_status', 0, 14, 1),
(14, 'Pending Quotation', 1, '2011-11-15 12:46:11', 1, 0, 1, 62, 'Pending Quotation', 'change_status', 0, 15, 1),
(15, 'Quotation', 1, '2011-11-15 12:46:35', 1, 0, 1, 62, 'Quotation', 'change_status', 0, 16, 1),
(16, 'Quotation Completed', 1, '2011-11-15 12:46:47', 1, 0, 1, 85, 'Quotation Completed', 'change_status', 0, 17, 1),
(17, 'Revision Requested', 1, '2011-11-15 12:47:17', 1, 0, 1, 62, 'Revision Requested', 'change_status', 0, 18, 1),
(18, 'Pending Revision', 1, '2011-11-15 12:47:53', 1, 0, 1, 62, 'Pending Revision', 'change_status', 0, 19, 1),
(19, 'Revision Completed', 1, '2011-11-15 12:48:37', 1, 0, 1, 62, 'Revision Completed', 'change_status', 0, 20, 1),
(20, 'Pending Internal Approval', 1, '2011-11-15 12:49:40', 1, 0, 1, 62, 'Pending Internal Approval', 'change_status', 0, 21, 1),
(21, 'Internal Approval', 1, '2011-11-15 12:50:18', 1, 0, 1, 62, 'Internal Approval', 'change_status', 0, 22, 1),
(22, 'Costing', 1, '2011-11-15 12:50:35', 1, 0, 1, 62, 'Costing', 'change_status', 0, 23, 1),
(23, 'Internally Approved', 1, '2011-11-15 12:51:19', 1, 0, 1, 62, 'Internally Approved', 'change_status', 0, 24, 1),
(24, 'Submitted to Client', 1, '2011-11-15 12:52:18', 1, 0, 1, 62, 'Submitted to Client', 'change_status', 0, 25, 1),
(25, 'Pending Client Approval', 1, '2011-11-15 12:52:42', 1, 0, 1, 62, 'Pending Client Approval', 'change_status', 0, 26, 1),
(26, 'Client Approved', 1, '2011-11-15 12:53:14', 1, 0, 1, 62, 'Client Approved', 'change_status', 0, 27, 1),
(27, 'Client Cancelled', 1, '2011-11-15 12:53:32', 1, 0, 1, 62, 'Client Cancelled', 'change_status', 0, 28, 1),
(28, 'Pending Deposit Invoicing', 1, '2011-11-15 12:54:10', 1, 0, 1, 62, 'Pending Deposit Invoicing', 'change_status', 0, 29, 1),
(29, 'Deposit Invoicing', 1, '2011-11-15 12:54:35', 1, 0, 1, 62, 'Deposit Invoicing', 'change_status', 0, 30, 1),
(30, 'Deposit Invoicing Complete', 1, '2011-11-15 12:54:51', 1, 0, 1, 62, 'Deposit Invoicing Complete', 'change_status', 0, 31, 1),
(31, 'Pending Production Scheduling', 1, '2011-11-15 12:55:16', 1, 0, 1, 62, 'Pending Production Scheduling', 'change_status', 0, 32, 1),
(34, 'Site Survey', 1, '2011-11-15 13:17:59', 1, 0, 1, 62, 'Site Survey', 'change_status', 0, 33, 1),
(35, 'Visual Art Mockup', 25, '2011-12-06 00:00:00', 1, 0, 1, 0, '', 'change_status', 0, 34, 1),
(36, 'Client Cancelled', 1, '2011-11-16 11:02:58', 1, 0, 1, 62, 'Client Cancelled', 'change_status', 0, 35, 1),
(37, 'Installation', 1, '2011-11-16 11:39:20', 1, 0, 1, 62, 'Installation', 'change_status', 0, 36, 1),
(38, 'Pending Final Invoice', 1, '2011-11-16 11:41:05', 1, 0, 1, 62, 'Pending Final Invoice', 'change_status', 0, 37, 1),
(39, 'Scheduling', 1, '2011-11-16 11:47:58', 1, 0, 1, 62, 'Scheduling', 'change_status', 0, 1, 1),
(40, 'Pending Production Commencement', 1, '2011-11-16 11:50:29', 1, 0, 1, 62, 'Pending Production Commencement', 'change_status', 0, 2, 1),
(41, 'In Production', 1, '2011-11-16 11:54:20', 1, 0, 1, 62, 'In Production', 'change_status', 0, 3, 1),
(42, 'On Hold', 1, '2011-11-16 11:55:49', 1, 0, 1, 62, 'On Hold', 'change_status', 0, 4, 1),
(43, 'Pending Final/Quality Inspection', 1, '2011-11-16 12:00:37', 1, 0, 1, 62, 'Pending Final/Quality Inspection', 'change_status', 0, 5, 1),
(44, 'Pending Production Recommencement', 1, '2011-11-16 12:01:52', 1, 0, 1, 62, 'Pending Production Recommencement', 'change_status', 0, 6, 1),
(45, 'Pending Client Submission', 1, '2011-11-16 12:08:14', 1, 0, 1, 62, 'Pending Client Submission', 'change_status', 0, 7, 1),
(46, 'Changes/Fixes Required', 1, '2011-11-16 12:10:22', 1, 0, 1, 62, 'Changes/Fixes Required', 'change_status', 0, 8, 1),
(47, 'Pending Installation', 1, '2011-11-16 12:12:50', 1, 0, 1, 62, 'Pending Installation', 'change_status', 0, 9, 1),
(48, 'Pending Closure', 1, '2011-11-16 12:19:45', 1, 0, 1, 62, 'Pending Closure', 'change_status', 0, 10, 1),
(49, 'Closed', 1, '2011-12-13 10:13:47', 1, 0, 1, 62, 'Closed', 'change_status', 0, 0, 1);

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

--
-- Table structure for table `request_con`
--

CREATE TABLE IF NOT EXISTS `request_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `request_con`
--

INSERT INTO `request_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(4, 1),
(1, 2),
(1, 3),
(2, 3),
(1, 4),
(1, 5),
(4, 5),
(7, 5),
(8, 5),
(1, 6),
(4, 6),
(5, 8),
(9, 8),
(8, 9);

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

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

CREATE TABLE IF NOT EXISTS `schedules` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `schedules` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `schedules_con`
--

CREATE TABLE IF NOT EXISTS `schedules_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `schedules_con`
--

INSERT INTO `schedules_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `schedule_colors`
--

CREATE TABLE IF NOT EXISTS `schedule_colors` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `schedule_colors`
--

INSERT INTO `schedule_colors` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `schedule_colors_con`
--

CREATE TABLE IF NOT EXISTS `schedule_colors_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `schedule_colors_con`
--

INSERT INTO `schedule_colors_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `stock`
--

CREATE TABLE IF NOT EXISTS `stock` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Awaiting', 1, '2014-05-19 13:19:01', 1, 0, 1, 19, 'Reopen', 'change_status', 0, 1, 1),
(2, 'Partial', 1, '2014-05-19 13:19:28', 1, 0, 1, 7, 'Partial', 'change_status', 0, 2, 1),
(3, 'Completed', 1, '2014-05-19 13:19:50', 1, 0, 1, 4, 'Complete', 'change_status', 0, 3, 1),
(4, 'Cancelled', 1, '2014-06-10 00:00:00', 1, 0, 1, 16, 'Cancel', 'change_status', 0, 4, 1);

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

--
-- Table structure for table `stock_con`
--

CREATE TABLE IF NOT EXISTS `stock_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `stock_con`
--

INSERT INTO `stock_con` (`id`, `con_id`) VALUES
(1, 2),
(1, 3),
(1, 4),
(2, 1),
(2, 3),
(3, 1),
(4, 1);

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-08-15 00:26:28', 1, 0, 1, 5, 'Activate', 'change_status', 0, 1, 1),
(2, 'Deleted', 1, '2012-02-01 16:11:11', 0, 1, 0, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `suppliers_con`
--

CREATE TABLE IF NOT EXISTS `suppliers_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `suppliers_con`
--

INSERT INTO `suppliers_con` (`id`, `con_id`) VALUES
(1, 2),
(2, 1),
(3, 1);

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

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

CREATE TABLE IF NOT EXISTS `tasks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `tasks` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `tasks_con`
--

CREATE TABLE IF NOT EXISTS `tasks_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tasks_con`
--

INSERT INTO `tasks_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `task_templates`
--

CREATE TABLE IF NOT EXISTS `task_templates` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `task_templates`
--

INSERT INTO `task_templates` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `task_templates_con`
--

CREATE TABLE IF NOT EXISTS `task_templates_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `task_templates_con`
--

INSERT INTO `task_templates_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `templates`
--

CREATE TABLE IF NOT EXISTS `templates` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `templates_con`
--

CREATE TABLE IF NOT EXISTS `templates_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `templates_con`
--

INSERT INTO `templates_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `timesheets`
--

CREATE TABLE IF NOT EXISTS `timesheets` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `timesheets`
--

INSERT INTO `timesheets` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2012-02-01 12:45:53', 1, 0, 1, 86, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `timesheets_con`
--

CREATE TABLE IF NOT EXISTS `timesheets_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `timesheets_con`
--

INSERT INTO `timesheets_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(5, 2),
(1, 3),
(2, 3);

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `login` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

INSERT INTO `users` (`id`, `name`, `submitter`, `date_submitted`, `login`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2012-01-05 11:27:32', 1, 0, 1, 86, 'Re-activate', 'change_status', 0, 1, 1),
(2, 'Suspended', 1, '2010-07-29 00:58:25', 0, 0, 1, 7, 'Suspend', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2011-08-15 13:06:50', 0, 1, 0, 16, 'Delete', 'change_status', 1, 3, 1),
(4, 'Delete Forever', 1, '2009-10-19 08:39:54', 0, 0, 1, 10, 'Delete Forever', 'delete', 1, 4, 1);

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

--
-- Table structure for table `users_con`
--

CREATE TABLE IF NOT EXISTS `users_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_con`
--

INSERT INTO `users_con` (`id`, `con_id`) VALUES
(1, 2),
(1, 3),
(2, 1),
(2, 3),
(3, 1),
(3, 2),
(7, 1),
(7, 2),
(7, 3),
(7, 4);

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

--
-- Table structure for table `workflow`
--

CREATE TABLE IF NOT EXISTS `workflow` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `workflow`
--

INSERT INTO `workflow` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `workflow_con`
--

CREATE TABLE IF NOT EXISTS `workflow_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `workflow_con`
--

INSERT INTO `workflow_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);

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

--
-- Table structure for table `workflow_master`
--

CREATE TABLE IF NOT EXISTS `workflow_master` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `submitter` int(11) NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `active` tinyint(4) NOT NULL DEFAULT '0',
  `delete` tinyint(4) NOT NULL,
  `edit` tinyint(4) NOT NULL DEFAULT '1',
  `icon` tinyint(4) NOT NULL,
  `action_name` varchar(255) NOT NULL,
  `post` varchar(255) NOT NULL DEFAULT 'change_status',
  `hide` tinyint(4) NOT NULL,
  `ordering` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `submitter` (`submitter`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `workflow_master`
--

INSERT INTO `workflow_master` (`id`, `name`, `submitter`, `date_submitted`, `active`, `delete`, `edit`, `icon`, `action_name`, `post`, `hide`, `ordering`, `status`) VALUES
(1, 'Active', 1, '2011-09-13 16:05:11', 1, 0, 1, 57, 'Reactivate', 'change_status', 0, 1, 1),
(2, 'Inactive', 1, '2011-09-13 16:05:18', 1, 0, 1, 7, 'Inactive', 'change_status', 0, 2, 1),
(3, 'Deleted', 1, '2010-11-21 04:44:00', 0, 0, 1, 16, 'Delete', 'change_status', 0, 3, 1);

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

--
-- Table structure for table `workflow_master_con`
--

CREATE TABLE IF NOT EXISTS `workflow_master_con` (
  `id` int(11) unsigned NOT NULL,
  `con_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`,`con_id`),
  KEY `con_id` (`con_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `workflow_master_con`
--

INSERT INTO `workflow_master_con` (`id`, `con_id`) VALUES
(2, 1),
(3, 1),
(5, 1),
(1, 2),
(5, 2),
(1, 3),
(2, 3);
