-- phpMyAdmin SQL Dump
-- version 4.2.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 10, 2015 at 04:36 PM
-- Server version: 5.5.32
-- PHP Version: 5.4.16

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

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

--
-- Table structure for table `fx_account_details`
--

CREATE TABLE IF NOT EXISTS `fx_account_details` (
`id` bigint(20) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `fullname` varchar(160) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `vat` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `language` varchar(40) COLLATE utf8_unicode_ci DEFAULT 'english',
  `department` int(11) NOT NULL,
  `avatar` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default_avatar.jpg',
  `allowed_modules` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=5 ;

--
-- Truncate table before insert `fx_account_details`
--

TRUNCATE TABLE `fx_account_details`;
--
-- Dumping data for table `fx_account_details`
--

INSERT INTO `fx_account_details` (`id`, `user_id`, `fullname`, `company`, `city`, `country`, `address`, `phone`, `vat`, `language`, `department`, `avatar`, `allowed_modules`) VALUES
(1, 1, 'John Doe', '-', NULL, NULL, '', '', '', 'english', 0, 'default_avatar.jpg', ''),
(2, 2, 'Sara Williams', '-', NULL, NULL, '', '453 123 5680', '', 'english', 0, 'default_avatar.jpg', ''),
(3, 3, 'Ronald Doe', '1', NULL, NULL, '', '453 123 5680', '', 'english', 0, 'default_avatar.jpg', ''),
(4, 4, 'Olivia Williams', '2', NULL, NULL, '', '27 43423 232', '', 'english', 0, 'default_avatar.jpg', '');

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

--
-- Table structure for table `fx_activities`
--

CREATE TABLE IF NOT EXISTS `fx_activities` (
`activity_id` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `module` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `module_field_id` int(11) NOT NULL,
  `activity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `activity_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `icon` varchar(32) COLLATE utf8_unicode_ci DEFAULT 'fa-coffee',
  `deleted` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

--
-- Truncate table before insert `fx_activities`
--

TRUNCATE TABLE `fx_activities`;
--
-- Dumping data for table `fx_activities`
--

INSERT INTO `fx_activities` (`activity_id`, `user`, `module`, `module_field_id`, `activity`, `icon`, `deleted`) VALUES
(1, 1, 'Clients', 1, 'Added a new company  ACME Inc.','fa-user', 0),
(2, 1, 'Clients', 2, 'Added a new company  Envato Inc.','fa-user', 0),
(3, 1, 'tickets', 1, 'Created a ticket # IPUEU90','fa-ticket', 0),
(4, 1, 'tickets', 2, 'Created a ticket # OCM4MDN','fa-ticket', 0),
(5, 1, 'tickets', 2, 'Replied a ticket # OCM4MDN','fa-ticket', 0),
(6, 1, 'projects', 1, 'Admin  created a project # #PRO15964','fa-coffee', 0),
(7, 1, 'projects', 1, 'Admin edited a project #PRO15964','fa-coffee', 0),
(8, 1, 'invoices', 1, ' created INVOICE #INV00001','fa-plus', 0),
(9, 1, 'invoices', 2, ' created INVOICE #INV00002','fa-plus', 0),
(10, 1, 'invoices', 2, 'Payment of EUR 113.91 received and applied','fa-usd', 0),
(11, 1, 'estimates', 1, 'Created estimate # EST54539','fa-plus',0),
(12, 1, 'projects', 1, 'Admin added new milestone: Initial Design Concepts','fa-laptop', 0),
(13, 1, 'projects', 1, 'Added a task titled:  Photoshop UI Design','fa-tasks', 0),
(14, 1, 'projects', 1, 'Added a task titled:  Admin Login Area', 'fa-tasks', 0),
(15, 1, 'projects', 1, 'Admin  added a file ', 'fa-file', 0),
(16, 1, 'projects', 1, 'Admin  added a file ', 'fa-file', 0),
(17, 1, 'projects', 1, 'Added an Issue #898775', 'fa-bug', 0),
(18, 1, 'projects', 1, 'Added a comment to Project', 'fa-comment', 0),
(19, 1, 'invoices', 3, ' created INVOICE #INV00003', 'fa-plus', 0),
(20, 1, 'invoices', 3, 'Admin  edited INVOICE #INV00003', 'fa-pencil', 0),
(21, 1, 'invoices', 3, 'Payment of EUR 1,343.10 received and applied to INVOICE #INV00003', 'fa-usd', 0),
(22, 1, 'invoices', 3, 'INVOICE #INV00003 marked as Sent', 'fa-envelope', 0),
(23, 1, 'invoices', 3, 'Payment of EUR 1,343.10 received and applied to INVOICE #INV00003', 'fa-usd', 0),
(24, 1, 'invoices', 3, 'Payment of EUR 1,342.10 received and applied to INVOICE #INV00003', 'fa-usd', 0),
(25, 1, 'invoices', 3, 'Payment of EUR 1341.1 received and applied to INVOICE #INV00003', 'fa-usd', 0);

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

--
-- Table structure for table `fx_api_keys`
--

CREATE TABLE IF NOT EXISTS `fx_api_keys` (
`id` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `api_key` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `level` int(2) NOT NULL,
  `ignore_limits` tinyint(1) NOT NULL DEFAULT '0',
  `is_private_key` tinyint(1) NOT NULL DEFAULT '0',
  `ip_addresses` text COLLATE utf8_unicode_ci,
  `date_created` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_api_keys`
--

TRUNCATE TABLE `fx_api_keys`;
--
-- Dumping data for table `fx_api_keys`
--

INSERT INTO `fx_api_keys` (`id`, `user`, `api_key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES
(1, 1, 'freelancer', 1, 0, 0, NULL, 1);

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

--
-- Table structure for table `fx_api_logs`
--

CREATE TABLE IF NOT EXISTS `fx_api_logs` (
`id` int(11) NOT NULL,
  `uri` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `method` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `params` text COLLATE utf8_unicode_ci,
  `api_key` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `time` int(11) NOT NULL,
  `rtime` float DEFAULT NULL,
  `authorized` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Truncate table before insert `fx_api_logs`
--

TRUNCATE TABLE `fx_api_logs`;
-- --------------------------------------------------------

--
-- Table structure for table `fx_assign_projects`
--

CREATE TABLE IF NOT EXISTS `fx_assign_projects` (
`a_id` int(11) unsigned NOT NULL,
  `assigned_user` int(11) NOT NULL,
  `project_assigned` int(11) NOT NULL,
  `assign_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Truncate table before insert `fx_assign_projects`
--

TRUNCATE TABLE `fx_assign_projects`;
--
-- Dumping data for table `fx_assign_projects`
--

INSERT INTO `fx_assign_projects` (`a_id`, `assigned_user`, `project_assigned`, `assign_date`) VALUES
(3, 1, 1, '2015-01-09 16:20:24'),
(4, 2, 1, '2015-01-09 16:20:24');

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

--
-- Table structure for table `fx_assign_tasks`
--

CREATE TABLE IF NOT EXISTS `fx_assign_tasks` (
`a_id` int(11) unsigned NOT NULL,
  `assigned_user` int(11) NOT NULL,
  `project_assigned` int(11) NOT NULL,
  `task_assigned` int(11) NOT NULL,
  `assign_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Truncate table before insert `fx_assign_tasks`
--

TRUNCATE TABLE `fx_assign_tasks`;
--
-- Dumping data for table `fx_assign_tasks`
--

INSERT INTO `fx_assign_tasks` (`a_id`, `assigned_user`, `project_assigned`, `task_assigned`, `assign_date`) VALUES
(1, 1, 1, 1, '2015-01-09 16:45:56'),
(2, 2, 1, 1, '2015-01-09 16:45:56'),
(3, 1, 1, 1, '2015-01-09 16:46:31'),
(4, 2, 1, 1, '2015-01-09 16:46:31');

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

--
-- Table structure for table `fx_bugs`
--

CREATE TABLE IF NOT EXISTS `fx_bugs` (
`bug_id` int(11) NOT NULL,
  `issue_ref` int(11) NOT NULL,
  `project` int(11) NOT NULL,
  `reporter` int(11) NOT NULL,
  `assigned_to` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `bug_status` enum('Unconfirmed','Confirmed','In Progress','Resolved','Verified') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Unconfirmed',
  `issue_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reproducibility` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `severity` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `priority` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `bug_description` text COLLATE utf8_unicode_ci NOT NULL,
  `reported_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified` varchar(64) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_bugs`
--

TRUNCATE TABLE `fx_bugs`;
--
-- Dumping data for table `fx_bugs`
--

INSERT INTO `fx_bugs` (`bug_id`, `issue_ref`, `project`, `reporter`, `assigned_to`, `bug_status`, `issue_title`, `reproducibility`, `severity`, `priority`, `bug_description`, `last_modified`) VALUES
(1, 898775, 1, 3, '1', 'Unconfirmed', 'Uninstalling process denied', 'Steps taken to produce the bug', 'Major', 'medium', 'Detailed description', '');

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

--
-- Table structure for table `fx_bug_comments`
--

CREATE TABLE IF NOT EXISTS `fx_bug_comments` (
`c_id` int(11) NOT NULL,
  `bug_id` int(11) NOT NULL,
  `comment_by` int(11) NOT NULL,
  `comment` text COLLATE utf8_unicode_ci NOT NULL,
  `date_commented` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_bug_comments`
--

TRUNCATE TABLE `fx_bug_comments`;
--
-- Dumping data for table `fx_bug_comments`
--

INSERT INTO `fx_bug_comments` (`c_id`, `bug_id`, `comment_by`, `comment`) VALUES
(1, 1, 1, 'I posted a comment');

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

--
-- Table structure for table `fx_bug_files`
--

CREATE TABLE IF NOT EXISTS `fx_bug_files` (
`file_id` int(11) NOT NULL,
  `bug` int(11) NOT NULL,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `date_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Truncate table before insert `fx_bug_files`
--

TRUNCATE TABLE `fx_bug_files`;
-- --------------------------------------------------------

--
-- Table structure for table `fx_captcha`
--

CREATE TABLE IF NOT EXISTS `fx_captcha` (
`captcha_id` bigint(13) unsigned NOT NULL,
  `captcha_time` int(10) unsigned NOT NULL,
  `ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `word` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Truncate table before insert `fx_captcha`
--

TRUNCATE TABLE `fx_captcha`;
--
-- Dumping data for table `fx_captcha`
--

INSERT INTO `fx_captcha` (`captcha_id`, `captcha_time`, `ip_address`, `word`) VALUES
(1, 1420760509, '::1', 'f1e2Q80o'),
(2, 1420760547, '::1', 'FBT2aP1w'),
(3, 1420760566, '::1', 'XyEF4rfo');

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

--
-- Table structure for table `fx_comments`
--

CREATE TABLE IF NOT EXISTS `fx_comments` (
`comment_id` int(11) NOT NULL,
  `project` int(11) NOT NULL,
  `posted_by` int(11) NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `date_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_comments`
--

TRUNCATE TABLE `fx_comments`;
--
-- Dumping data for table `fx_comments`
--

INSERT INTO `fx_comments` (`comment_id`, `project`, `posted_by`, `message`, `deleted`) VALUES
(1, 1, 1, 'This is one of my comments', 'No');

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

--
-- Table structure for table `fx_comment_replies`
--

CREATE TABLE IF NOT EXISTS `fx_comment_replies` (
`reply_id` int(11) NOT NULL,
  `parent_comment` int(11) NOT NULL,
  `reply_msg` text COLLATE utf8_unicode_ci NOT NULL,
  `replied_by` int(11) NOT NULL,
  `del` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `date_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Truncate table before insert `fx_comment_replies`
--

TRUNCATE TABLE `fx_comment_replies`;
-- --------------------------------------------------------

--
-- Table structure for table `fx_companies`
--

CREATE TABLE IF NOT EXISTS `fx_companies` (
`co_id` int(11) unsigned NOT NULL,
  `company_ref` int(32) NOT NULL,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `primary_contact` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `company_email` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `company_website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `company_phone` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `company_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `VAT` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `hosting_company` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `hostname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `port` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `account_password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `account_username` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Truncate table before insert `fx_companies`
--

TRUNCATE TABLE `fx_companies`;
--
-- Dumping data for table `fx_companies`
--

INSERT INTO `fx_companies` (`co_id`, `company_ref`, `company_name`, `primary_contact`, `company_email`, `company_website`, `company_phone`, `company_address`, `city`, `country`, `VAT`, `date_added`, `hosting_company`, `hostname`, `port`, `account_password`, `account_username`) VALUES
(1, 5366575, 'ACME Inc.', '3', 'wm@shuleportal.com', 'http://shuleportal.com', '+123 456 7895', '18 High St. Leeds', 'London', 'United Kingdom', '', '2015-01-09 15:59:28', '', '', '', '', ''),
(2, 9958922, 'Envato Inc.', '4', 'wm@gitbench.com', 'http://gitbench.com', '+123 456 7895', '19 Henry St. ', 'Pretoria', 'South Africa', '', '2015-01-09 16:01:37', '', '', '', '', '');

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

--
-- Table structure for table `fx_departments`
--

CREATE TABLE IF NOT EXISTS `fx_departments` (
`deptid` int(10) NOT NULL,
  `deptname` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `depthidden` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Truncate table before insert `fx_departments`
--

TRUNCATE TABLE `fx_departments`;
--
-- Dumping data for table `fx_departments`
--

INSERT INTO `fx_departments` (`deptid`, `deptname`, `depthidden`) VALUES
(1, 'Sales Department', NULL),
(2, 'Support Centre', NULL);

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

--
-- Table structure for table `fx_estimates`
--

CREATE TABLE IF NOT EXISTS `fx_estimates` (
`est_id` int(11) NOT NULL,
  `reference_no` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `client` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `due_date` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `discount` float NOT NULL,
  `notes` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Looking forward for your business.',
  `tax` int(11) NOT NULL DEFAULT '0',
  `status` enum('Accepted','Declined','Pending') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Pending',
  `date_sent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `est_deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `date_saved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `emailed` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `invoiced` enum('Yes','No') COLLATE utf8_unicode_ci DEFAULT 'No'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_estimates`
--

TRUNCATE TABLE `fx_estimates`;
--
-- Dumping data for table `fx_estimates`
--

INSERT INTO `fx_estimates` (`est_id`, `reference_no`, `client`, `due_date`, `currency`, `discount`, `notes`, `tax`, `status`, `date_sent`, `est_deleted`, `date_saved`, `emailed`, `invoiced`) VALUES
(1, 'EST54539', '2', '01-03-2015', 'USD', 0, 'Looking forward to doing business with you.', 12, 'Pending', '', 'No', '2015-01-09 16:43:31', 'No', 'No');

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

--
-- Table structure for table `fx_estimate_items`
--

CREATE TABLE IF NOT EXISTS `fx_estimate_items` (
`item_id` int(11) NOT NULL,
  `estimate_id` int(11) NOT NULL,
  `item_name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `item_desc` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `unit_cost` float NOT NULL,
  `quantity` int(11) NOT NULL,
  `total_cost` float NOT NULL,
  `date_saved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_estimate_items`
--

TRUNCATE TABLE `fx_estimate_items`;
--
-- Dumping data for table `fx_estimate_items`
--

INSERT INTO `fx_estimate_items` (`item_id`, `estimate_id`, `item_name`, `item_desc`, `unit_cost`, `quantity`, `total_cost`, `date_saved`) VALUES
(1, 1, 'Email Hosting', '500GB Email storage Space', 50.56, 3, 151.68, '2015-01-09 16:43:53');

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

--
-- Table structure for table `fx_fields`
--

CREATE TABLE IF NOT EXISTS `fx_fields` (
`id` int(10) NOT NULL,
  `deptid` int(10) NOT NULL,
  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `uniqid` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Truncate table before insert `fx_fields`
--

TRUNCATE TABLE `fx_fields`;
--
-- Dumping data for table `fx_fields`
--

INSERT INTO `fx_fields` (`id`, `deptid`, `name`, `uniqid`, `type`) VALUES
(1, 1, 'Purchase Code', 'f54affddcdfe53', 'text'),
(2, 2, 'Coupon code', 'f54afff0380a4e', 'text');

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

--
-- Table structure for table `fx_files`
--

CREATE TABLE IF NOT EXISTS `fx_files` (
`file_id` int(11) NOT NULL,
  `project` int(11) NOT NULL,
  `file_name` text COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `uploaded_by` int(11) NOT NULL,
  `date_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Truncate table before insert `fx_files`
--

TRUNCATE TABLE `fx_files`;
--
-- Dumping data for table `fx_files`
--

INSERT INTO `fx_files` (`file_id`, `project`, `file_name`, `description`, `uploaded_by`, `date_posted`) VALUES
(1, 1, '14208220290673d481.png', 'Description', 1, '2015-01-09 16:47:09'),
(2, 1, '14208220531373fca82.png', 'Description', 1, '2015-01-09 16:47:33');

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

--
-- Table structure for table `fx_invoices`
--

CREATE TABLE IF NOT EXISTS `fx_invoices` (
`inv_id` int(11) NOT NULL,
  `reference_no` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `client` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `due_date` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `notes` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'A finance charge of 1.5% will be made on unpaid balances after due day.Thank you for your business.',
  `allow_paypal` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `tax` float NOT NULL DEFAULT '0',
  `discount` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `recurring` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `r_freq` int(11) NOT NULL DEFAULT '31',
  `recur_start_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `recur_end_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `recur_frequency` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `recur_next_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `currency` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
  `status` enum('Unpaid','Paid') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Unpaid',
  `archived` int(11) NOT NULL DEFAULT '0',
  `date_sent` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `inv_deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `date_saved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `emailed` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `show_client` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `viewed` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;

--
-- Truncate table before insert `fx_invoices`
--

TRUNCATE TABLE `fx_invoices`;
--
-- Dumping data for table `fx_invoices`
--

INSERT INTO `fx_invoices` (`inv_id`, `reference_no`, `client`, `due_date`, `notes`, `allow_paypal`, `tax`, `discount`, `recurring`, `r_freq`, `recur_start_date`, `recur_end_date`, `recur_frequency`, `recur_next_date`, `currency`, `status`, `archived`, `date_sent`, `inv_deleted`, `date_saved`, `emailed`, `show_client`, `viewed`) VALUES
(1, 'INV00001', '2', '01-03-2015', 'Thank you for your business. Please process this invoice within the due date.', 'Yes', 5, '0', 'No', 31, '', '', '', '', 'EUR', 'Unpaid', 0, '', 'No', '2015-01-09 16:28:22', 'No', 'Yes', 'No'),
(2, 'INV00002', '1', '01-03-2015', 'Thank you for your business. Please process this invoice within the due date.', 'Yes', 4.5, '0', 'No', 31, '', '', '', '', 'EUR', 'Unpaid', 0, '', 'No', '2015-01-09 16:32:25', 'No', 'Yes', 'No'),
(3, 'INV00003', '2', '01-03-2015', 'Thank you for your business. Please process this invoice within the due date.', 'Yes', 21, '0', 'Yes', 7, '09-01-2015', '2015-10-01', '7D', '2015-03-08', 'EUR', 'Unpaid', 0, '2015-01-09 17:59:01', 'No', '2015-01-09 16:53:07', 'Yes', 'Yes', 'No');

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

--
-- Table structure for table `fx_items`
--

CREATE TABLE IF NOT EXISTS `fx_items` (
`item_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `item_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `item_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `unit_cost` float NOT NULL,
  `quantity` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `total_cost` float NOT NULL,
  `date_saved` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Truncate table before insert `fx_items`
--

TRUNCATE TABLE `fx_items`;
--
-- Dumping data for table `fx_items`
--

INSERT INTO `fx_items` (`item_id`, `invoice_id`, `item_name`, `item_desc`, `unit_cost`, `quantity`, `total_cost`, `date_saved`) VALUES
(1, 1, 'Email Hosting', '500GB Email storage Space', 65, '3', 195, '2015-01-09 16:28:42'),
(2, 1, 'Website ReDesign', 'Complete wordpress installation', 50, '2', 100, '2015-01-09 16:29:07'),
(3, 2, 'Database backups', '500GB Database backups', 54.5, '2', 109, '2015-01-09 16:32:58'),
(4, 3, 'Wordpress Installation', 'Complete wordpress installation', 250, '1', 250, '2015-01-09 16:53:32'),
(5, 3, 'Website ReDesign', 'Bought  domain and develop site', 860, '1', 860, '2015-01-09 16:54:40');

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

--
-- Table structure for table `fx_items_saved`
--

CREATE TABLE IF NOT EXISTS `fx_items_saved` (
`item_id` int(11) NOT NULL,
  `item_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `item_desc` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `unit_cost` int(11) NOT NULL,
  `deleted` enum('Yes','No') COLLATE utf8_unicode_ci DEFAULT 'No'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_items_saved`
--

TRUNCATE TABLE `fx_items_saved`;
--
-- Dumping data for table `fx_items_saved`
--

INSERT INTO `fx_items_saved` (`item_id`, `item_name`, `item_desc`, `unit_cost`, `deleted`) VALUES
(1, 'Domain Installation', 'SSL Installation', 250, 'No');

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

--
-- Table structure for table `fx_login_attempts`
--

CREATE TABLE IF NOT EXISTS `fx_login_attempts` (
`id` int(11) NOT NULL,
  `ip_address` varchar(40) NOT NULL,
  `login` varchar(50) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Truncate table before insert `fx_login_attempts`
--

TRUNCATE TABLE `fx_login_attempts`;
-- --------------------------------------------------------

--
-- Table structure for table `fx_messages`
--

CREATE TABLE IF NOT EXISTS `fx_messages` (
`msg_id` int(11) NOT NULL,
  `user_to` int(11) NOT NULL,
  `user_from` int(11) NOT NULL,
  `message` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('Read','Unread') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Unread',
  `attached_file` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date_received` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Truncate table before insert `fx_messages`
--

TRUNCATE TABLE `fx_messages`;
-- --------------------------------------------------------

--
-- Table structure for table `fx_milestones`
--

CREATE TABLE IF NOT EXISTS `fx_milestones` (
`id` int(11) NOT NULL,
  `milestone_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `project` int(11) NOT NULL,
  `start_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `due_date` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_milestones`
--

TRUNCATE TABLE `fx_milestones`;
--
-- Dumping data for table `fx_milestones`
--

INSERT INTO `fx_milestones` (`id`, `milestone_name`, `description`, `project`, `start_date`, `due_date`, `created`) VALUES
(1, 'Initial Design Concepts', 'Description', 1, '09-01-2015', '09-03-2015', '2015-01-09 16:45:29');

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

--
-- Table structure for table `fx_payments`
--

CREATE TABLE IF NOT EXISTS `fx_payments` (
`p_id` int(11) NOT NULL,
  `invoice` int(11) NOT NULL,
  `paid_by` int(11) NOT NULL,
  `payer_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `payment_method` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `amount` float NOT NULL,
  `trans_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `notes` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payment_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `month_paid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `year_paid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `inv_deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Truncate table before insert `fx_payments`
--

TRUNCATE TABLE `fx_payments`;
--
-- Dumping data for table `fx_payments`
--

INSERT INTO `fx_payments` (`p_id`, `invoice`, `paid_by`, `payer_email`, `payment_method`, `amount`, `trans_id`, `notes`, `payment_date`, `created_date`, `month_paid`, `year_paid`, `inv_deleted`) VALUES
(1, 2, 1, '', '1', 113.91, '573871', '', '09-01-2015', '2015-01-09 16:42:05', '01', '2015', 'No'),
(3, 3, 2, '', '1', 1, '581487', 'Paid by James via Bank of America', '09-01-2015', '2015-01-09 17:01:02', '01', '2015', 'No'),
(4, 3, 2, '', '1', 1, '444254', 'Paid by James via Bank of Europe', '09-01-2015', '2015-01-09 17:16:56', '01', '2015', 'No'),
(5, 3, 2, '', '3', 1341.1, '529224', 'Paid via Bank of Europa', '09-01-2015', '2015-01-09 17:24:23', '01', '2015', 'No');

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

--
-- Table structure for table `fx_projects`
--

CREATE TABLE IF NOT EXISTS `fx_projects` (
`project_id` int(11) NOT NULL,
  `project_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `project_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Project Title',
  `client` int(11) NOT NULL,
  `start_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `due_date` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `fixed_rate` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `hourly_rate` float NOT NULL,
  `fixed_price` float NOT NULL,
  `progress` int(11) NOT NULL,
  `notes` text COLLATE utf8_unicode_ci NOT NULL,
  `assign_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('On Hold','Active','Done') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
  `timer` enum('On','Off') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Off',
  `timer_started_by` int(11) NOT NULL,
  `timer_start` int(11) NOT NULL,
  `time_logged` int(11) NOT NULL,
  `proj_deleted` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No',
  `auto_progress` enum('TRUE','FALSE') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'FALSE',
  `estimate_hours` int(11) NOT NULL,
  `settings` text COLLATE utf8_unicode_ci NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_projects`
--

TRUNCATE TABLE `fx_projects`;
--
-- Dumping data for table `fx_projects`
--

INSERT INTO `fx_projects` (`project_id`, `project_code`, `project_title`, `client`, `start_date`, `due_date`, `fixed_rate`, `hourly_rate`, `fixed_price`, `progress`, `notes`, `assign_to`, `status`, `timer`, `timer_started_by`, `timer_start`, `time_logged`, `proj_deleted`, `auto_progress`, `estimate_hours`, `settings`, `date_created`) VALUES
(1, 'PRO15964', 'WIFI Hotspot management System', 1, '09-01-2015', '01-03-2015', 'No', 60, 0, 31, 'FTP Username: gitbench\r\nFTP Pass: gitbench@@\r\nFTP Hostname: gitbench.com', 'a:2:{i:0;s:1:"1";i:1;s:1:"2";}', 'Active', 'Off', 0, 0, 7200, 'No', 'FALSE', 3, '{"show_milestones":"on","show_project_tasks":"on","show_project_files":"on","show_timesheets":"on","show_project_bugs":"on","show_project_calendar":"on","show_project_comments":"on","project_id":"1"}', '2015-01-09 16:19:53');

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

--
-- Table structure for table `fx_project_timer`
--

CREATE TABLE IF NOT EXISTS `fx_project_timer` (
`timer_id` int(11) NOT NULL,
  `project` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `start_time` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `end_time` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `date_timed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_project_timer`
--

TRUNCATE TABLE `fx_project_timer`;
--
-- Dumping data for table `fx_project_timer`
--

INSERT INTO `fx_project_timer` (`timer_id`, `project`, `user`, `start_time`, `end_time`, `date_timed`) VALUES
(1, 1, 1, '1420814820', '1420822020', '2015-01-09 16:48:00');

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

--
-- Table structure for table `fx_saved_tasks`
--

CREATE TABLE IF NOT EXISTS `fx_saved_tasks` (
`template_id` int(11) NOT NULL,
  `task_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `task_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `visible` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `estimate_hours` float NOT NULL,
  `added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `saved_by` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_saved_tasks`
--

TRUNCATE TABLE `fx_saved_tasks`;
--
-- Dumping data for table `fx_saved_tasks`
--

INSERT INTO `fx_saved_tasks` (`template_id`, `task_name`, `task_desc`, `visible`, `estimate_hours`, `added`, `saved_by`) VALUES
(1, 'Website ReDesign', 'Description', 'Yes', 500, '2015-01-09 16:09:57', 1);

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

--
-- Table structure for table `fx_tasks`
--

CREATE TABLE IF NOT EXISTS `fx_tasks` (
`t_id` int(11) NOT NULL,
  `task_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `project` int(11) NOT NULL,
  `milestone` int(11) NOT NULL,
  `assigned_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `visible` enum('Yes','No') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Yes',
  `task_progress` int(11) NOT NULL DEFAULT '0',
  `timer_status` enum('On','Off') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Off',
  `timer_started_by` int(11) NOT NULL,
  `start_time` int(11) NOT NULL,
  `estimated_hours` int(11) NOT NULL,
  `logged_time` int(11) NOT NULL DEFAULT '0',
  `auto_progress` enum('TRUE','FALSE') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'FALSE',
  `due_date` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `added_by` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Truncate table before insert `fx_tasks`
--

TRUNCATE TABLE `fx_tasks`;
--
-- Dumping data for table `fx_tasks`
--

INSERT INTO `fx_tasks` (`t_id`, `task_name`, `project`, `milestone`, `assigned_to`, `description`, `visible`, `task_progress`, `timer_status`, `timer_started_by`, `start_time`, `estimated_hours`, `logged_time`, `auto_progress`, `due_date`, `date_added`, `added_by`) VALUES
(1, 'Photoshop UI Design', 1, 1, 'a:2:{i:0;s:1:"1";i:1;s:1:"2";}', 'Description', 'Yes', 80, 'Off', 0, 0, 0, 0, 'FALSE', '09-03-2015', '2015-01-09 16:45:56', 1),
(2, 'Admin Login Area', 1, 1, 'a:2:{i:0;s:1:"1";i:1;s:1:"2";}', 'Description', 'Yes', 100, 'Off', 0, 0, 0, 10800, 'FALSE', '09-03-2015', '2015-01-09 16:46:31', 1);

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

--
-- Table structure for table `fx_tasks_timer`
--

CREATE TABLE IF NOT EXISTS `fx_tasks_timer` (
`timer_id` int(11) NOT NULL,
  `task` int(11) NOT NULL,
  `pro_id` int(11) NOT NULL,
  `start_time` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `end_time` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user` int(11) NOT NULL,
  `date_timed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_tasks_timer`
--

TRUNCATE TABLE `fx_tasks_timer`;
--
-- Dumping data for table `fx_tasks_timer`
--

INSERT INTO `fx_tasks_timer` (`timer_id`, `task`, `pro_id`, `start_time`, `end_time`, `user`, `date_timed`) VALUES
(1, 2, 1, '1420811280', '1420822080', 1, '2015-01-09 16:48:23');

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

--
-- Table structure for table `fx_task_files`
--

CREATE TABLE IF NOT EXISTS `fx_task_files` (
`file_id` int(11) NOT NULL,
  `task` int(11) DEFAULT NULL,
  `file_name` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `file_ext` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `original_name` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8_unicode_ci NOT NULL,
  `file_status` enum('unconfirmed','confirmed','in_progress','done','verified') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unconfirmed',
  `uploaded_by` int(11) NOT NULL,
  `date_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Truncate table before insert `fx_task_files`
--

TRUNCATE TABLE `fx_task_files`;
-- --------------------------------------------------------

--
-- Table structure for table `fx_ticketreplies`
--

CREATE TABLE IF NOT EXISTS `fx_ticketreplies` (
`id` int(10) NOT NULL,
  `ticketid` int(10) NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `replier` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `replierid` int(10) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Truncate table before insert `fx_ticketreplies`
--

TRUNCATE TABLE `fx_ticketreplies`;
--
-- Dumping data for table `fx_ticketreplies`
--

INSERT INTO `fx_ticketreplies` (`id`, `ticketid`, `body`, `replier`, `replierid`, `time`) VALUES
(1, 2, 'I just replied your ticket', NULL, 1, '2015-01-09 16:19:11');

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

--
-- Table structure for table `fx_tickets`
--

CREATE TABLE IF NOT EXISTS `fx_tickets` (
`id` int(10) NOT NULL,
  `ticket_code` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `subject` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `department` int(11) DEFAULT NULL,
  `reporter` int(10) NOT NULL,
  `priority` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `additional` text COLLATE utf8_unicode_ci,
  `attachment` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Truncate table before insert `fx_tickets`
--

TRUNCATE TABLE `fx_tickets`;
--
-- Dumping data for table `fx_tickets`
--

INSERT INTO `fx_tickets` (`id`, `ticket_code`, `subject`, `body`, `status`, `department`, `reporter`, `priority`, `additional`, `attachment`, `created`) VALUES
(1, 'IPUEU90', 'Purchase not processed', 'Ticket Message', 'open', 1, 4, 'Low', '{"f54affddcdfe53":"MQn2HJi0U3IQulj3oCOO9CzOyX9wN\\/a8J4\\/tW6m8YAKzg8+u1WUrrfz6yRuxO4W78Dh0mTbQDk\\/ksJp2HJxpSg=="}', NULL, '2015-01-09 16:18:18'),
(2, 'OCM4MDN', 'Issue in Mozilla on Mac OS X', 'Ticket Message', 'answered', 2, 4, 'Low', '{"f54afff0380a4e":"bSlws59RuSMjEuoF\\/3iLnhdfcwQmRIte6liuWriBjpyCZF2G2ch1Li3yDp\\/5F5b5Y\\/APpTpGiZy1yJKcOt4fRA=="}', NULL, '2015-01-09 16:18:51');

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

--
-- Table structure for table `fx_un_sessions`
--

CREATE TABLE IF NOT EXISTS `fx_un_sessions` (
  `session_id` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
  `ip_address` varchar(16) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '0',
  `user_agent` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `fx_un_sessions`
--

TRUNCATE TABLE `fx_un_sessions`;
--
-- Dumping data for table `fx_un_sessions`
--

INSERT INTO `fx_un_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('3fb0048745bfe8dfd15dbe3c2d26dfe0', '::1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0', 1420896254, 'a:8:{s:9:"user_data";s:0:"";s:14:"requested_page";s:52:"http://localhost/foapi/projects/timesheet/add_time/1";s:7:"user_id";s:1:"1";s:8:"username";s:5:"admin";s:7:"role_id";s:1:"1";s:6:"status";s:1:"1";s:13:"previous_page";s:52:"http://localhost/foapi/projects/timesheet/add_time/1";s:4:"lang";s:7:"english";}'),
('800d0a341a9a9e7b6a86012f2ec5c03d', '::1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0', 1420903989, 'a:7:{s:9:"user_data";s:0:"";s:14:"requested_page";s:23:"http://localhost/foapi/";s:7:"user_id";s:1:"1";s:8:"username";s:5:"admin";s:7:"role_id";s:1:"1";s:6:"status";s:1:"1";s:13:"previous_page";s:23:"http://localhost/foapi/";}');

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

--
-- Table structure for table `fx_users`
--

CREATE TABLE IF NOT EXISTS `fx_users` (
`id` int(11) NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `role_id` int(11) NOT NULL DEFAULT '2',
  `activated` tinyint(1) NOT NULL DEFAULT '1',
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `ban_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_password_key` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_password_requested` datetime DEFAULT NULL,
  `new_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `new_email_key` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_ip` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;

--
-- Truncate table before insert `fx_users`
--

TRUNCATE TABLE `fx_users`;
--
-- Dumping data for table `fx_users`
--

INSERT INTO `fx_users` (`id`, `username`, `password`, `email`, `role_id`, `activated`, `banned`, `ban_reason`, `new_password_key`, `new_password_requested`, `new_email`, `new_email_key`, `last_ip`, `last_login`, `created`, `modified`) VALUES
(1, 'admin', '$P$Bwtiv.NYzcmsDIiVHURDD12DxdzCAd1', 'wm@gitbench.com', 1, 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '2015-01-10 16:33:19', '2015-01-09 00:43:04', '2015-01-10 15:33:19'),
(2, 'gitbench', '$P$BP8IxD7o/RrzJPj8rLc5RBs9gCbNju/', 'wm@shuleportal.com', 3, 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2015-01-09 17:03:33', '2015-01-09 16:03:33'),
(3, 'client', '$P$B6ecoiHGNBLUBlR/8BTXUcB6qLb0C3.', 'sara@gitbench.com', 2, 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2015-01-09 17:04:30', '2015-01-09 16:04:30'),
(4, 'olivia', '$P$BqfSoaecjY6dHi6lg3Fh7GSK72gRuY/', 'envato@gitbench.com', 2, 1, 0, NULL, NULL, NULL, NULL, NULL, '::1', '0000-00-00 00:00:00', '2015-01-09 17:06:27', '2015-01-09 16:06:27');

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

--
-- Table structure for table `fx_user_autologin`
--

CREATE TABLE IF NOT EXISTS `fx_user_autologin` (
  `key_id` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `user_agent` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `last_ip` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `fx_user_autologin`
--

TRUNCATE TABLE `fx_user_autologin`;
--
-- Indexes for dumped tables
--
