-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 14-10-2014 a las 11:55:35
-- Versión del servidor: 5.6.12-log
-- Versión de PHP: 5.4.12
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 */;
--
-- Base de datos: `onesteplien`
--
CREATE DATABASE IF NOT EXISTS `onesteplien` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `onesteplien`;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `address`
--
CREATE TABLE IF NOT EXISTS `address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) DEFAULT NULL,
`state_id` smallint(6) DEFAULT NULL,
`zipcode` varchar(10) DEFAULT NULL,
`address` varchar(80) DEFAULT NULL,
`city` varchar(80) DEFAULT NULL,
`city_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `entity_id` (`entity_id`),
KEY `state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;
--
-- Volcado de datos para la tabla `address`
--
INSERT INTO `address` (`id`, `entity_id`, `state_id`, `zipcode`, `address`, `city`, `city_id`) VALUES
(1, 2, 10, '33461', '1078 MANOR DR', 'PALM SPRINGS', 543),
(2, 4, 10, '33606', '301 W PLATT ST, STE 375 ', 'TAMPA', 248),
(3, 5, 10, '33009', '1980 S OCEAN DR, STE B', 'HALLANDALE BEACH', NULL),
(4, 6, 10, '33326', 'P.O Box 266756', 'Weston', NULL),
(5, 7, 10, '33139', '1370 Washington Ave, Ste 203', '412', 412),
(6, 8, 10, '33761', '28100 US HWY 19 N, Ste 305', 'Clearwater', 581),
(7, 9, 10, '33169', '160 NW 176 St, Ste 301', 'Miami', NULL),
(8, 10, 10, '32839', '4700 Millenia Blvd, Ste 515', 'Orlando', 491),
(9, 11, 10, '32716', 'P.O. Box 162147', 'Altamonte Springs', 688),
(10, 12, 10, '32405-1073', '4110 36th Avenue West', 'Bradenton', NULL),
(11, 13, 10, '33330', '12240 SW 53 ST, Ste 512', 'Cooper City', NULL),
(12, 14, 10, '32579', 'P.O. Box 1096', 'Shalimar', NULL),
(13, 15, 10, '33647', '16801 Tampa Plams Blvd', 'Tampa', NULL),
(14, 16, 10, '33134', '800 Douglas Rd, Ste 880', 'Coral Gables', NULL),
(15, 17, 10, '32789', '1007 Greentree Dr', 'Winter Park', NULL),
(16, 18, 10, '33321', '8000 Lagos de Campo Blvd', 'Tamarac', NULL),
(17, 19, 10, '32210', '4736 Blanding Blvd', 'Jacksonville', NULL),
(18, 20, 10, '33469', '9601 SE Little Club Way', 'Tequesta', NULL),
(19, 21, 10, '33432', '433 SW 8 ST', 'Boca Raton', NULL),
(20, 22, 10, '34202', '9031 Town Center Pkwy', 'Lakewood Ranch', 787),
(21, 23, 10, '33703', '5001 Fourth St N, Ste A', 'St. Petersburg', NULL),
(22, 24, 10, '33907', '12734 Kenwood Ln, Ste 49', 'Ft. Myers', 1),
(23, 25, 10, '33155', '4909 SW 74 CT', 'Miami', 411);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `attentions`
--
CREATE TABLE IF NOT EXISTS `attentions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`updated_at` datetime NOT NULL,
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Volcado de datos para la tabla `attentions`
--
INSERT INTO `attentions` (`id`, `entity_id`, `updated_at`, `created_at`) VALUES
(3, 29, '2013-11-05 21:05:15', '2013-11-05 21:05:15'),
(4, 35, '2013-11-05 21:34:57', '2013-11-05 21:34:57'),
(5, 40, '2013-11-18 16:43:52', '2013-11-18 16:43:52'),
(6, 42, '2013-11-18 17:11:26', '2013-11-18 17:11:26'),
(7, 44, '2013-11-18 17:21:21', '2013-11-18 17:21:21'),
(8, 46, '2013-11-18 17:32:03', '2013-11-18 17:32:03'),
(9, 48, '2013-11-18 18:12:08', '2013-11-18 18:12:08'),
(10, 50, '2013-11-19 09:31:26', '2013-11-19 09:31:26'),
(11, 52, '2013-11-23 23:20:28', '2013-11-23 23:20:28');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `checks`
--
CREATE TABLE IF NOT EXISTS `checks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`order_detail_id` int(11) NOT NULL,
`model` varchar(30) NOT NULL,
`model_id` int(11) NOT NULL,
`order_file_id` int(11) DEFAULT NULL,
`user_id` int(11) NOT NULL,
`number` varchar(100) DEFAULT NULL,
`amount` decimal(10,2) NOT NULL,
`date` date NOT NULL,
`address` varchar(150) NOT NULL,
`pay_to` varchar(150) NOT NULL,
`memo` text,
`status` enum('0','1') DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`view` tinyint(1) NOT NULL DEFAULT '1',
`check_type_id` tinyint(4) NOT NULL DEFAULT '1',
`note` text,
`QB_check_id` varchar(255) DEFAULT NULL,
`is_cashier` enum('0','1') DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `order_detail_id` (`order_detail_id`),
KEY `user_id` (`user_id`),
KEY `checks_qb_check_id_index` (`QB_check_id`),
KEY `checks_is_cashier_index` (`is_cashier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=95 ;
--
-- Volcado de datos para la tabla `checks`
--
INSERT INTO `checks` (`id`, `order_id`, `order_detail_id`, `model`, `model_id`, `order_file_id`, `user_id`, `number`, `amount`, `date`, `address`, `pay_to`, `memo`, `status`, `created_at`, `updated_at`, `view`, `check_type_id`, `note`, `QB_check_id`, `is_cashier`) VALUES
(8, 7, 10, 'Homeowner', 1939, 7, 4, '258845', '200.00', '2014-06-11', 'Horizon Maintenance Services, Inc. \r\n5618 Hollywood Blvd FL 33021', 'Horizon Maintenance Services, Inc. ', 'File #: 47231-25 - 19363 NW 11 ST, hollywood, Florida, 33029', '1', '2014-06-11 21:55:19', '2014-06-13 21:00:25', 1, 1, NULL, NULL, NULL),
(9, 8, 8, 'Homeowner', 249, NULL, 4, NULL, '0.00', '2014-06-12', 'Sentry Management (Longwood) ', 'Sentry Management (Longwood) ', '', '0', '2014-06-12 21:35:10', '2014-06-12 21:35:10', 0, 1, NULL, NULL, NULL),
(12, 11, 12, 'Homeowner', 1934, 21, 4, '258843', '200.00', '2014-06-13', 'Neighborhood Property Management \r\n2083 W 76 ST Hialeah FL 33016', 'Neighborhood Property Management ', 'File #: 47447-25 - 6125 W 20 AVE 204, hialeah, Florida, 33012', '1', '2014-06-13 19:31:43', '2014-06-13 21:00:01', 1, 1, NULL, NULL, NULL),
(13, 10, 13, 'Collector', 9468, 26, 4, '259049', '175.00', '2014-06-16', 'Becker & Poliakoff, P.A. (West Palm Beach) \r\n625 N. Flagler Dr. - 7th FL FL 33401', 'THE RIDGE AT THE BLUFFS HOMEOWNERS ASSOCIATION, INC.', 'File #: 47437-25 - 102 RIDGE ROAD, Miramar, Florida, 33477', '1', '2014-06-16 15:08:24', '2014-06-16 23:35:34', 1, 1, NULL, NULL, NULL),
(14, 10, 13, 'Homeowner', 9474, 31, 4, '259047', '150.00', '2014-06-16', 'Ridge at the Bluffs HOA\r\n215 Cape Pointe Cir. FL 33477', 'Campbell Property Mgt', 'File #: 47437-25 - 102 RIDGE ROAD, miramar, Florida, 33477', '1', '2014-06-16 17:50:21', '2014-06-16 23:35:17', 1, 1, NULL, NULL, NULL),
(18, 16276, 1546, 'Homeowner', 168, 50, 1, 'test 16277 part 5', '415.00', '2014-06-23', 'Banyan Property Management \r\n2328 S. Congress Ave, Ste 1C West Palm Beach FL 33406', 'Banyan Property Management ', 'File #: TEST345 - 1422 NW 13 ST, miami, Florida, 33175', '1', '2014-06-23 18:14:21', '2014-06-30 15:30:44', 1, 1, NULL, NULL, NULL),
(21, 7, 10, 'Collector', 84, NULL, 12, NULL, '0.00', '2014-06-24', 'Eisinger, Brown, Lewis, Frankel & Chaiet ', 'Eisinger, Brown, Lewis, Frankel & Chaiet ', '', '0', '2014-06-24 21:24:51', '2014-06-24 21:24:51', 0, 1, NULL, NULL, NULL),
(22, 7, 9, 'Collector', 1982, NULL, 1, NULL, '0.00', '2014-06-25', 'Steven Reed Cohen, P.A. ', 'Steven Reed Cohen, P.A. ', '', '0', '2014-06-25 15:51:33', '2014-06-25 15:51:33', 0, 1, NULL, NULL, NULL),
(32, 16279, 1550, 'Homeowner', 249, NULL, 4, NULL, '0.00', '2014-06-30', 'Sentry Management (Longwood) ', 'Sentry Management (Longwood) ', '', '0', '2014-06-30 15:51:05', '2014-06-30 15:51:05', 0, 1, NULL, NULL, NULL),
(52, 16277, 1551, 'Homeowner', 66, 78, 1, 'test 16277', '175.00', '2014-06-30', 'Becker & Poliakoff, P.A. (Maitland) \r\n2500 Maitland Center Pkway, Ste 209 Maitland FL 32751', 'Becker & Poliakoff, P.A. (Maitland) ', 'File #: test 116 - 8579 NW 3 RD, miami, Florida, 33193', '1', '2014-06-30 19:53:11', '2014-07-04 15:55:21', 1, 1, NULL, NULL, NULL),
(60, 16277, 1552, 'Homeowner', 6, NULL, 2, NULL, '150.00', '2014-06-30', 'American Property Mgm ', 'American Property Mgm ', '', '0', '2014-06-30 20:18:17', '2014-06-30 20:18:17', 0, 1, NULL, NULL, NULL),
(62, 16280, 1554, 'Homeowner', 44, NULL, 2, NULL, '0.00', '2014-06-30', 'Brook Villas POA ', 'Brook Villas POA ', '', '0', '2014-06-30 20:21:31', '2014-06-30 20:21:31', 0, 1, NULL, NULL, NULL),
(65, 16282, 1555, 'Collector', 391, NULL, 2, NULL, '400.00', '2014-07-01', 'Clayton & McCulloh, P.A. ', 'Clayton & McCulloh, P.A. ', '', '0', '2014-07-01 15:28:47', '2014-07-01 15:28:47', 0, 1, NULL, NULL, NULL),
(79, 16282, 1555, 'Homeowner', 1169, 91, 2, '883', '200.00', '2014-07-02', 'Campbell Property Mgt (Margate) \r\n6350 Coral Lake Dr Margate FL 33063', 'Campbell Property Mgt (Margate) ', 'File #: test883 - 7312 silver palm dr, hollywood, Florida, 33024', '1', '2014-07-02 15:35:36', '2014-07-04 15:55:02', 1, 3, 'testing', NULL, NULL),
(94, 16290, 1561, 'Homeowner', 9478, NULL, 2, NULL, '0.00', '2014-07-02', 'New 2nd hoa ', 'New 2nd hoa ', '', '0', '2014-07-02 19:28:25', '2014-07-02 19:28:25', 0, 1, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `cities`
--
CREATE TABLE IF NOT EXISTS `cities` (
`id` smallint(11) NOT NULL AUTO_INCREMENT,
`county_id` smallint(11) NOT NULL,
`name` varchar(120) NOT NULL,
`turnaround` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
KEY `county_id` (`county_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
--
-- Volcado de datos para la tabla `cities`
--
INSERT INTO `cities` (`id`, `county_id`, `name`, `turnaround`) VALUES
(4, 3, 'hawthorne', '3/16'),
(5, 1, 'high springs', '4/15'),
(6, 1, 'la crosse', '1/15'),
(7, 1, 'melrose', '3/15'),
(8, 1, 'micanopy', '3/15'),
(9, 1, 'newberry', '1/15'),
(10, 1, 'waldo', '5/15'),
(11, 2, 'glen saint mary', '6/15'),
(12, 2, 'macclenny', '3/15'),
(13, 2, 'sanderson', '3/15'),
(14, 4, 'callaway', '1/15'),
(15, 4, 'cedar grove', '5/15'),
(16, 4, 'hiland park', '7/15'),
(17, 3, 'laguna beach', '10/15'),
(18, 3, 'lower grand lagoon', '11/15'),
(19, 3, 'lynn haven', '3/15'),
(20, 3, 'mexico beach', '5/15'),
(21, 3, 'panama city', '6/15'),
(22, 3, 'panama city beach', '10/15'),
(23, 5, 'parker', '5/15'),
(24, 5, 'pretty bayou', '10/15'),
(25, 3, 'springfield', '11/15'),
(26, 3, 'tyndall afb', '12/15'),
(27, 3, 'upper grand lagoon', '14/15'),
(28, 3, 'youngstown', '5/15');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `city`
--
CREATE TABLE IF NOT EXISTS `city` (
`CityID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`CountyID` int(11) NOT NULL,
`CityName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`CityCode` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`ExtraCharges` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`CreatedOn` time NOT NULL,
`CreatedBy` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`UpdatedOn` time NOT NULL,
`UpdatedBy` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`IsDeleted` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`StateID` int(11) NOT NULL,
`CityIDMySQL` int(11) NOT NULL,
PRIMARY KEY (`CityID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Volcado de datos para la tabla `city`
--
INSERT INTO `city` (`CityID`, `CountyID`, `CityName`, `CityCode`, `ExtraCharges`, `CreatedOn`, `CreatedBy`, `UpdatedOn`, `UpdatedBy`, `IsDeleted`, `StateID`, `CityIDMySQL`) VALUES
(1, 1, 'maracay', 'cuidad', 'd', '09:14:43', '1', '09:14:43', '1', '1', 1, 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `collectors`
--
CREATE TABLE IF NOT EXISTS `collectors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`is_cashier` tinyint(4) NOT NULL DEFAULT '0',
`attention` varchar(150) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`online` tinyint(4) unsigned NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
`note` text,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
-- Volcado de datos para la tabla `collectors`
--
INSERT INTO `collectors` (`id`, `entity_id`, `is_cashier`, `attention`, `created_at`, `updated_at`, `website`, `online`, `enabled`, `note`) VALUES
(1, 2, 0, 'Sue', '2014-01-16 13:09:24', '2014-01-16 13:43:29', '', 0, 1, NULL),
(2, 3, 0, '', '2014-01-16 13:42:41', '2014-01-16 13:43:09', '', 0, 1, NULL),
(3, 4, 0, '', '2014-01-16 13:45:29', '2014-08-22 18:36:30', 'www.blawgroup.com/paymentpage/', 1, 1, 'ORDER ONLINE'),
(4, 5, 0, '', '2014-01-16 13:49:24', '2014-01-16 13:49:24', 'lien.com', 0, 1, NULL),
(5, 6, 0, '', '2014-01-16 14:24:34', '2014-01-16 14:24:34', '', 0, 1, NULL),
(6, 7, 0, '', '2014-01-16 14:29:33', '2014-01-16 14:29:33', '', 0, 1, NULL),
(7, 8, 0, '', '2014-01-16 14:31:43', '2014-01-16 14:31:43', 'homewisedocs.com', 0, 1, NULL),
(8, 9, 0, '', '2014-01-16 14:33:46', '2014-01-16 14:33:46', '', 0, 1, NULL),
(9, 10, 0, '', '2014-01-16 14:35:33', '2014-01-16 14:35:33', 'community-mgmt.com', 0, 1, NULL),
(10, 11, 0, '', '2014-01-16 14:37:55', '2014-01-16 14:37:55', '', 0, 1, NULL),
(11, 12, 0, 'Linda', '2014-01-16 14:51:08', '2014-01-16 14:51:08', '', 0, 1, NULL),
(12, 13, 0, '', '2014-01-16 14:54:26', '2014-01-16 14:54:26', '', 0, 1, NULL),
(13, 14, 0, '', '2014-01-16 14:56:02', '2014-01-16 14:56:02', '', 0, 1, NULL),
(14, 15, 0, '', '2014-01-16 14:57:50', '2014-01-16 14:57:50', '', 0, 1, NULL),
(15, 16, 0, '', '2014-01-16 15:03:07', '2014-01-16 15:03:07', '', 0, 1, NULL),
(16, 17, 0, '', '2014-01-16 15:04:44', '2014-01-16 15:04:44', '', 0, 1, NULL),
(17, 18, 0, '', '2014-01-26 10:52:56', '2014-01-26 10:52:56', '', 0, 1, NULL),
(18, 19, 0, '', '2014-01-26 10:54:26', '2014-01-26 10:54:26', '', 0, 1, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `collector_fee`
--
CREATE TABLE IF NOT EXISTS `collector_fee` (
`collector_id` int(11) NOT NULL,
`fee_id` smallint(6) NOT NULL,
PRIMARY KEY (`collector_id`,`fee_id`),
KEY `fee_id` (`fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `collector_fee`
--
INSERT INTO `collector_fee` (`collector_id`, `fee_id`) VALUES
(1, 1),
(1, 2),
(3, 3),
(4, 4),
(4, 5),
(4, 6),
(5, 7),
(6, 8),
(8, 9),
(12, 10),
(16, 11),
(17, 12),
(18, 13),
(19, 14),
(23, 15),
(24, 16),
(24, 17),
(27, 18);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `contact_numbers`
--
CREATE TABLE IF NOT EXISTS `contact_numbers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`number` varchar(50) NOT NULL,
`contact_number_type_id` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
KEY `entity_id` (`entity_id`),
KEY `contact_number_type_id` (`contact_number_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
--
-- Volcado de datos para la tabla `contact_numbers`
--
INSERT INTO `contact_numbers` (`id`, `entity_id`, `number`, `contact_number_type_id`) VALUES
(1, 2, '561-357-9811', 1),
(2, 2, '561-357-0180', 1),
(3, 3, '239-275-5180', 1),
(4, 4, '813-258-8588', 1),
(5, 4, '813-221-7909', 2),
(6, 5, '954-457-9732', 1),
(7, 5, '954-456-8376', 1),
(8, 6, '954-733-3122', 1),
(9, 6, '954-733-3155', 2),
(10, 7, '786-228-9179', 1),
(11, 7, '786-228-9180', 2),
(12, 8, '727-796-5900', 1),
(13, 8, '727-584-2118', 2),
(14, 9, '305-652-6464', 1),
(15, 9, '305-652-8228', 2),
(16, 10, '407-903-9969', 1),
(17, 10, '407-903-9234', 2),
(18, 11, '407-682-3443', 1),
(19, 11, '407-682-0181', 2),
(20, 12, '941-753-7205', 1),
(21, 13, '954-680-3399', 1),
(22, 13, '954-680-0165', 2),
(23, 14, '850-581-8998', 1),
(24, 15, '813-514-6105', 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `contact_number_types`
--
CREATE TABLE IF NOT EXISTS `contact_number_types` (
`id` smallint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Volcado de datos para la tabla `contact_number_types`
--
INSERT INTO `contact_number_types` (`id`, `name`) VALUES
(3, 'Cell'),
(2, 'Fax'),
(1, 'Phone');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `counties`
--
CREATE TABLE IF NOT EXISTS `counties` (
`id` smallint(11) NOT NULL AUTO_INCREMENT,
`state_id` smallint(11) NOT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `state_id` (`state_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
--
-- Volcado de datos para la tabla `counties`
--
INSERT INTO `counties` (`id`, `state_id`, `name`) VALUES
(1, 10, 'alachua'),
(2, 10, 'baker'),
(3, 10, 'bay'),
(4, 10, 'bradford'),
(5, 10, 'brevard'),
(6, 10, 'broward'),
(7, 10, 'calhoun'),
(8, 10, 'charlotte'),
(9, 10, 'citrus'),
(10, 10, 'clay'),
(11, 10, 'collier'),
(12, 10, 'columbia'),
(13, 10, 'desoto'),
(14, 10, 'dixie'),
(15, 10, 'duval'),
(16, 10, 'escambia'),
(17, 10, 'flagler'),
(18, 10, 'franklin'),
(19, 10, 'gadsden');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `countries`
--
CREATE TABLE IF NOT EXISTS `countries` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`country` varchar(70) NOT NULL,
`citizenship` varchar(70) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `country` (`country`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Volcado de datos para la tabla `countries`
--
INSERT INTO `countries` (`id`, `country`, `citizenship`) VALUES
(1, 'United States', 'American'),
(2, 'Dominican Republic', 'Dominican');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `county`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `customers`
--
CREATE TABLE IF NOT EXISTS `customers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL,
`response_type_id` tinyint(4) NOT NULL,
`website` varchar(150) DEFAULT NULL,
`username` varchar(100) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `entity_id` (`entity_id`),
KEY `response_type_id` (`response_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
--
-- Volcado de datos para la tabla `customers`
--
INSERT INTO `customers` (`id`, `entity_id`, `contact_id`, `response_type_id`, `website`, `username`, `updated_at`, `created_at`, `enabled`) VALUES
(1, 9484, 9485, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(2, 9486, 9485, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(3, 9487, 9485, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(4, 9488, 9489, 1, 'www.carringtontitleservices.com', NULL, '2014-07-14 11:39:36', '2014-06-06 17:46:20', 1),
(5, 9490, 9491, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(6, 9492, 9493, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(7, 9494, 9493, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(8, 9495, 9493, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(9, 9496, 9497, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(10, 9498, 9499, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(11, 9500, 9501, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(12, 9502, 9503, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(13, 9504, 9505, 2, '', NULL, '2014-07-28 12:02:13', '2014-06-06 17:46:20', 0),
(14, 9506, 9507, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(15, 9508, 9509, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(16, 9510, 9511, 2, NULL, NULL, '2014-06-06 17:46:20', '2014-06-06 17:46:20', 1),
(17, 9512, 9513, 2, '', NULL, '2014-07-15 15:15:27', '2014-06-06 17:46:20', 1),
(18, 9514, 9515, 1, '', NULL, '2014-07-14 11:16:12', '2014-06-06 17:46:20', 1),
(19, 9516, 9517, 1, '', NULL, '2014-07-14 11:12:46', '2014-06-06 17:46:20', 1),
(20, 9518, 9519, 2, NULL, NULL, '2014-06-06 17:46:21', '2014-06-06 17:46:21', 1),
(21, 9520, 9521, 2, NULL, NULL, '2014-06-06 17:46:21', '2014-06-06 17:46:21', 1),
(22, 9522, 9523, 2, NULL, NULL, '2014-06-06 17:46:21', '2014-06-06 17:46:21', 1),
(23, 9524, 9525, 2, '', NULL, '2014-08-15 14:36:34', '2014-06-06 17:46:21', 0),
(24, 9526, 9527, 2, NULL, NULL, '2014-06-06 17:46:21', '2014-06-06 17:46:21', 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `customer_prices`
--
CREATE TABLE IF NOT EXISTS `customer_prices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`customer_id` int(11) NOT NULL,
`fee_type_id` tinyint(11) NOT NULL,
`county_id` smallint(11) DEFAULT NULL,
`price` decimal(10,2) NOT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customer_id` (`customer_id`),
KEY `fee_type_id` (`fee_type_id`),
KEY `county_id` (`county_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
--
-- Volcado de datos para la tabla `customer_prices`
--
INSERT INTO `customer_prices` (`id`, `customer_id`, `fee_type_id`, `county_id`, `price`, `created_at`, `updated_at`) VALUES
(1, 1, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(2, 1, 1, NULL, '120.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(3, 2, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(4, 2, 1, NULL, '150.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(5, 3, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(6, 3, 1, NULL, '120.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(7, 4, 1, NULL, '85.00', '2014-06-06 17:46:20', '2014-07-14 11:39:36'),
(9, 5, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(10, 5, 1, NULL, '120.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(11, 6, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(12, 6, 1, NULL, '120.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(13, 7, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(14, 7, 1, NULL, '120.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(15, 8, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(16, 8, 1, NULL, '120.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(17, 9, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(18, 9, 1, NULL, '125.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(19, 10, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(20, 10, 1, NULL, '150.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20'),
(21, 11, 2, NULL, '55.00', '2014-06-06 17:46:20', '2014-06-06 17:46:20');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `email_address`
--
CREATE TABLE IF NOT EXISTS `email_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`address` varchar(100) NOT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `entity_id` (`entity_id`),
KEY `address` (`address`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Volcado de datos para la tabla `email_address`
--
INSERT INTO `email_address` (`id`, `entity_id`, `address`, `created_at`, `updated_at`) VALUES
(1, 1, 'developing@onesteplien.com', '2014-01-16 00:00:00', '2014-01-16 00:00:00'),
(2, 4, 'ESTOPPELS@BLAWGROUP.COM', '2014-01-16 13:45:29', '2014-01-16 13:45:29'),
(3, 5, 'JWOODS@THEHEMISPHERES.COM', '2014-01-16 13:49:24', '2014-01-16 13:49:24'),
(4, 7, 'apms1370@gmail.com', '2014-01-16 14:29:33', '2014-01-16 14:29:33'),
(5, 9, 'c.kremen@associationmgtgroup.com', '2014-01-16 14:33:46', '2014-01-16 14:33:46'),
(6, 11, 'kbollo@vista-cam.com', '2014-01-16 14:37:55', '2014-01-16 14:37:55'),
(7, 12, 'tmolen224@tampabay.rr.com', '2014-01-16 14:51:08', '2014-01-16 14:51:08'),
(8, 13, 'cmsmatt@bellsouth.net', '2014-01-16 14:54:26', '2014-01-16 14:54:26'),
(9, 14, 'brendabythebay@cox.net', '2014-01-16 14:56:02', '2014-01-16 14:56:02'),
(10, 16, 'hr@hrllplaw.com', '2014-01-16 15:03:07', '2014-01-16 15:03:07'),
(11, 17, 'hbenzeev@cfl.rr.com', '2014-01-16 15:04:44', '2014-01-16 15:04:44'),
(12, 18, 'marierose@bellsouth.net', '2014-01-26 10:52:56', '2014-01-26 10:52:56');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `email_order`
--
CREATE TABLE IF NOT EXISTS `email_order` (
`id` int(11) NOT NULL,
`order_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`receiver` varchar(255) NOT NULL,
`sender` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`message` text,
`seen` enum('0','1') DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `entities`
--
CREATE TABLE IF NOT EXISTS `entities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(170) NOT NULL,
`lastname` varchar(80) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Volcado de datos para la tabla `entities`
--
INSERT INTO `entities` (`id`, `firstname`, `lastname`, `created_at`, `updated_at`) VALUES
(1, 'One Step Lien', '', '2014-01-16 00:00:00', '2014-01-16 00:00:00'),
(2, 'TREE LAKE HOMEOWNERS ASSOCIATION', NULL, '2014-01-16 13:09:24', '2014-01-16 13:09:24'),
(3, 'PINE MANOR IMPROVEMENT ASSOCIATION', NULL, '2014-01-16 13:42:41', '2014-01-16 13:42:41'),
(4, 'BUSINESS LAW GROUP, P.A.', NULL, '2014-01-16 13:45:29', '2014-01-16 13:45:29'),
(5, 'HEMISPHERES CONDOMINIUM ASSOCIATION', NULL, '2014-01-16 13:49:24', '2014-01-16 13:49:24'),
(6, 'Metro Realty Services, Inc.', NULL, '2014-01-16 14:24:34', '2014-01-16 14:24:34'),
(7, 'American Property Mgm', NULL, '2014-01-16 14:29:33', '2014-01-16 14:29:33'),
(8, 'Resource Property Mgt (Clearwater)', NULL, '2014-01-16 14:31:43', '2014-01-16 14:31:43'),
(9, 'Association Management Group', NULL, '2014-01-16 14:33:46', '2014-01-16 14:33:46'),
(10, 'Community Management Professionals', NULL, '2014-01-16 14:35:33', '2014-01-16 14:35:33'),
(11, 'Vista Community Assn Management', NULL, '2014-01-16 14:37:55', '2014-01-16 14:37:55'),
(12, 'Cortez Villas Property Association, Inc.', NULL, '2014-01-16 14:51:08', '2014-01-16 14:51:08'),
(13, 'Continental Management Solutions', NULL, '2014-01-16 14:54:26', '2014-01-16 14:54:26'),
(14, 'Shalimar POA, Inc', NULL, '2014-01-16 14:56:02', '2014-01-16 14:56:02');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `entity_files`
--
CREATE TABLE IF NOT EXISTS `entity_files` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`file_type_id` smallint(6) NOT NULL,
`path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT 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`),
KEY `entity_files_file_type_id_foreign` (`file_type_id`),
KEY `entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;
--
-- Volcado de datos para la tabla `entity_files`
--
INSERT INTO `entity_files` (`id`, `entity_id`, `file_type_id`, `path`, `url`, `name`, `created_at`, `updated_at`) VALUES
(1, 1170, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\1170', 'http://192.168.0.86:8080/files/entities/1170', '1404857832.1404317354.FedEx Ship Manager - Print Your Label(s).pdf', '2014-07-08 22:47:12', '2014-07-08 22:47:12'),
(2, 1170, 7, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\1170', 'http://192.168.0.86:8080/files/entities/1170', '1404858027.1404767228.GRS2.pdf', '2014-07-08 22:50:27', '2014-07-08 22:50:27'),
(3, 1170, 7, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\1170', 'http://192.168.0.86:8080/files/entities/1170', '1404858027.1404767228.GRS2.pdf', '2014-07-08 22:50:27', '2014-07-08 22:50:27'),
(5, 21636, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\21636', 'http://192.168.0.86:8080/files/entities/21636', '1406987888.Microsoft Outlook - Memo Style(2).pdf', '2014-08-02 14:28:08', '2014-08-02 14:28:08'),
(6, 4889, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\4889', 'http://192.168.0.86:8080/files/entities/4889', '1406989063.ALEXIS GONZALEZ PA.pdf', '2014-08-02 14:47:43', '2014-08-02 14:47:43'),
(7, 97, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\97', 'http://192.168.0.86:8080/files/entities/97', '1406989133.ALLIANCE CAS.pdf', '2014-08-02 14:48:53', '2014-08-02 14:48:53'),
(8, 197, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\197', 'http://192.168.0.86:8080/files/entities/197', '1406989173.ANTONIO DUARTE, P.A..pdf', '2014-08-02 14:49:33', '2014-08-02 14:49:33'),
(9, 8233, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\8233', 'http://192.168.0.86:8080/files/entities/8233', '1406989215.ARBOR HEIGHTS CONDOMINIUM ASSOCIATION.pdf', '2014-08-02 14:50:15', '2014-08-02 14:50:15'),
(10, 769, 1, 'C:\\Program Files (x86)\\Zend\\Apache2\\htdocs\\HoaOneStep\\public/files\\entities\\769', 'http://192.168.0.86:8080/files/entities/769', '1406989279.ASSOCIATION ADVOCACY GROUP.pdf', '2014-08-02 14:51:19', '2014-08-02 14:51:19');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `expenses`
--
CREATE TABLE IF NOT EXISTS `expenses` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`expense_type_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`invoice_id` int(11) unsigned DEFAULT NULL,
`check_id` int(11) DEFAULT NULL,
`quantity` int(11) unsigned NOT NULL DEFAULT '1',
`price` decimal(10,2) NOT NULL DEFAULT '0.00',
`description` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `expense_type_id` (`expense_type_id`),
KEY `user_id` (`user_id`),
KEY `check_id` (`check_id`),
KEY `notrep` (`order_id`,`quantity`,`price`,`description`) USING BTREE,
KEY `invoice_id` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
--
-- Volcado de datos para la tabla `expenses`
--
INSERT INTO `expenses` (`id`, `order_id`, `expense_type_id`, `user_id`, `invoice_id`, `check_id`, `quantity`, `price`, `description`, `created_at`, `updated_at`) VALUES
(14, 6, 4, 4, 2, NULL, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is NEW', '2014-06-11 21:07:38', '2014-06-11 21:14:15'),
(17, 7, 3, 4, 8, 8, 1, '200.00', 'Homeowner Pay to the Order of Horizon Maintenance Services, Inc. Memo: File #: 47231-25 - 19363 NW 11 ST, hollywood, Florida, 33029', '2014-06-11 21:55:20', '2014-06-25 16:11:15'),
(18, 7, 4, 4, 8, 8, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is NEW', '2014-06-11 21:55:20', '2014-06-25 16:11:15'),
(19, 7, 3, 4, 8, 8, 1, '10.00', 'Fee for generate check', '2014-06-11 21:55:20', '2014-06-25 16:11:15'),
(20, 8, 5, 4, 6, 9, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is UPDATE', '2014-06-12 21:35:10', '2014-06-23 16:25:32'),
(26, 11, 3, 4, 889, 12, 1, '200.00', 'Homeowner Pay to the Order of Neighborhood Property Management Memo: File #: 47447-25 - 6125 W 20 AVE 204, hialeah, Florida, 33012', '2014-06-13 19:31:43', '2014-08-22 14:30:58'),
(27, 11, 4, 4, 889, 12, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is NEW', '2014-06-13 19:31:43', '2014-08-22 14:30:58'),
(28, 11, 3, 4, 889, 12, 1, '10.00', 'Fee for generate check', '2014-06-13 19:31:43', '2014-08-22 14:30:58'),
(29, 10, 3, 4, 40, 13, 1, '175.00', 'Collector Pay to the Order of THE RIDGE AT THE BLUFFS HOMEOWNERS ASSOCIATION, INC. Memo: File #: 47437-25 - 102 RIDGE ROAD, Miramar, Florida, 33477', '2014-06-16 15:08:24', '2014-07-09 13:16:37'),
(30, 10, 4, 4, 40, 13, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is NEW', '2014-06-16 15:08:24', '2014-07-09 13:16:37'),
(31, 10, 3, 4, 40, 13, 1, '10.00', 'Fee for generate check', '2014-06-16 15:08:24', '2014-07-09 13:16:37'),
(32, 12, 4, 4, 5, NULL, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is NEW', '2014-06-16 16:26:08', '2014-06-16 16:33:32'),
(33, 10, 3, 4, 40, 14, 1, '150.00', 'Homeowner Pay to the Order of Campbell Property Mgt Memo: File #: 47437-25 - 102 RIDGE ROAD, miramar, Florida, 33477', '2014-06-16 17:50:21', '2014-07-09 13:16:37'),
(34, 10, 4, 4, 40, 14, 1, '45.00', 'BAYVIEW TITLE SERVICES fee for order type that is NEW', '2014-06-16 17:50:21', '2014-07-09 13:16:37');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `expense_types`
--
CREATE TABLE IF NOT EXISTS `expense_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Volcado de datos para la tabla `expense_types`
--
INSERT INTO `expense_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Fedex', '2014-02-03 22:04:07', '2014-02-03 22:04:09'),
(2, 'Copies', '2014-02-03 22:04:12', '2014-02-03 22:04:15'),
(3, 'Fees', '2014-02-03 22:04:17', '2014-02-03 22:04:19'),
(4, 'New Order', '2014-04-23 14:45:37', '2014-04-23 14:45:40'),
(5, 'Update Order', '2014-04-23 14:45:53', '2014-04-23 14:45:56'),
(6, 'Rush Order', '2014-04-23 14:46:06', '2014-04-23 14:46:09');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `fax_order`
--
CREATE TABLE IF NOT EXISTS `fax_order` (
`id` int(11) NOT NULL DEFAULT '0',
`order_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `fees`
--
CREATE TABLE IF NOT EXISTS `fees` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`fee_type_id` tinyint(4) NOT NULL,
`unit_id` smallint(6) DEFAULT NULL,
`amount` decimal(10,2) NOT NULL DEFAULT '0.00',
`period` varchar(11) DEFAULT NULL,
`comment` varchar(150) DEFAULT NULL,
`credit_card` tinyint(1) NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `unit_id` (`unit_id`) USING BTREE,
KEY `fee_type_id` (`fee_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
--
-- Volcado de datos para la tabla `fees`
--
INSERT INTO `fees` (`id`, `fee_type_id`, `unit_id`, `amount`, `period`, `comment`, `credit_card`, `enabled`) VALUES
(1, 1, 1, '75.00', '2-3', '', 0, 1),
(2, 2, 1, '0.00', '0', '', 0, 1),
(3, 1, 1, '325.00', '0', '', 0, 0),
(4, 1, 1, '150.00', '0', '', 0, 1),
(5, 3, 1, '150.00', '0', '', 0, 1),
(6, 2, 1, '150.00', '0', '', 0, 1),
(7, 1, 1, '80.00', '0', '', 0, 1),
(8, 1, 2, '150.00', '3-5', '', 0, 1),
(9, 1, 2, '150.00', '2-3', '', 0, 1),
(10, 1, 1, '75.00', '0', '', 0, 1),
(11, 1, 1, '10.00', '0', '', 0, 1),
(12, 1, 1, '100.00', '0', '', 0, 1),
(13, 1, 1, '100.00', '0', '', 0, 1),
(14, 1, 1, '100.00', '0', '', 0, 1),
(15, 1, 1, '150.00', '0', '', 0, 1),
(16, 1, 3, '250.00', '48', 'ONE FEE PER ASSOCIATION', 0, 1),
(17, 1, 2, '200.00', '5-7', 'ONE FEE PER ASSOCIATION', 0, 1),
(18, 1, 1, '150.00', '0', 'payable to assoc.', 0, 1),
(19, 1, 1, '150.00', '0', '', 0, 0),
(20, 1, 1, '150.00', '0', '', 0, 1),
(21, 1, 1, '150.00', '0', 'Cashier''s check', 0, 1),
(22, 1, 1, '150.00', '0', '', 0, 1);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `fee_homeowner`
--
CREATE TABLE IF NOT EXISTS `fee_homeowner` (
`homeowner_id` int(11) NOT NULL,
`fee_id` smallint(6) NOT NULL,
PRIMARY KEY (`homeowner_id`,`fee_id`),
KEY `fee_id` (`fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `fee_homeowner`
--
INSERT INTO `fee_homeowner` (`homeowner_id`, `fee_id`) VALUES
(1, 1),
(1, 2),
(3, 3),
(4, 4),
(4, 5),
(4, 6),
(5, 7),
(6, 8),
(8, 9),
(12, 10),
(16, 11),
(17, 12);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `fee_types`
--
CREATE TABLE IF NOT EXISTS `fee_types` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Volcado de datos para la tabla `fee_types`
--
INSERT INTO `fee_types` (`id`, `name`) VALUES
(1, 'Standard'),
(2, 'Update'),
(3, 'Rush');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `file_types`
--
CREATE TABLE IF NOT EXISTS `file_types` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
`order` tinyint(11) DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`collector` tinyint(4) NOT NULL DEFAULT '0',
`homeowner` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Volcado de datos para la tabla `file_types`
--
INSERT INTO `file_types` (`id`, `name`, `order`, `created_at`, `updated_at`, `collector`, `homeowner`) VALUES
(1, 'W9', 3, '2013-11-26 10:19:18', '2013-11-26 10:19:22', 1, 1),
(2, 'Check', 7, '2013-11-26 10:19:35', '2013-11-26 10:19:39', 1, 1),
(3, 'Estoppel', 1, '2013-12-26 17:21:36', '2013-12-26 17:21:38', 0, 1),
(4, 'Ledger', 2, '2013-12-26 17:21:48', '2013-12-26 17:21:50', 1, 1),
(5, 'Fedex', 5, '2013-12-26 17:22:00', '2013-12-26 17:22:02', 1, 1),
(6, 'CT', 4, '2013-12-26 17:22:10', '2013-12-26 17:22:12', 1, 1),
(7, 'Seller Auth', 6, '2013-12-26 17:22:26', '2013-12-26 17:22:30', 1, 1),
(8, 'Misc', 8, '2013-12-26 17:22:39', '2013-12-26 17:22:41', 1, 1),
(9, 'Pay off', 1, '2013-12-26 17:22:57', '2013-12-26 17:23:00', 1, 0),
(10, 'Invoice', NULL, '2014-02-21 13:29:17', '2014-02-21 13:29:22', 0, 0),
(11, 'Mail', 9, '2014-04-03 09:13:00', '2014-04-03 09:13:02', 1, 1),
(12, 'Original Request', NULL, '2014-07-07 10:35:00', '2014-07-07 10:35:03', 0, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `frequencies`
--
CREATE TABLE IF NOT EXISTS `frequencies` (
`id` tinyint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Volcado de datos para la tabla `frequencies`
--
INSERT INTO `frequencies` (`id`, `name`) VALUES
(1, 'Monthly'),
(2, 'Quarterly'),
(3, 'Semi-annually'),
(4, 'Yearly'),
(5, 'Other');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`parent_id` smallint(6) NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `groups_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Volcado de datos para la tabla `groups`
--
INSERT INTO `groups` (`id`, `name`, `parent_id`, `created_at`, `updated_at`) VALUES
(1, 'administrator', 0, '2013-07-31 10:59:19', '2013-07-31 10:59:25'),
(2, 'processor', 1, '2013-07-31 11:34:53', '2013-07-31 11:34:56'),
(3, 'caller', 2, '2013-11-14 08:52:43', '2013-11-14 08:52:46'),
(4, 'check generator', 1, '2013-11-14 08:53:34', '2013-11-14 08:53:37'),
(5, 'invoice generator', 1, '2014-04-18 08:36:28', '2014-04-18 08:36:31');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `homeowners`
--
CREATE TABLE IF NOT EXISTS `homeowners` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`entity_id` int(11) NOT NULL,
`is_cashier` tinyint(4) NOT NULL DEFAULT '0',
`mgmt_comp` varchar(150) DEFAULT NULL,
`attention` varchar(150) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`online` tinyint(1) unsigned NOT NULL DEFAULT '0',
`enabled` tinyint(1) NOT NULL DEFAULT '1',
`note` text,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `entity_id` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
--
-- Volcado de datos para la tabla `homeowners`
--
INSERT INTO `homeowners` (`id`, `entity_id`, `is_cashier`, `mgmt_comp`, `attention`, `created_at`, `updated_at`, `website`, `online`, `enabled`, `note`) VALUES
(1, 2, 0, '', 'Sue', '2014-01-16 13:09:24', '2014-01-16 13:43:29', '', 0, 1, NULL),
(2, 3, 0, '', '', '2014-01-16 13:42:41', '2014-01-16 13:43:09', '', 0, 1, NULL),
(3, 4, 0, '', '', '2014-01-16 13:45:29', '2014-01-16 13:45:29', '', 0, 1, NULL),
(4, 5, 0, '', '', '2014-01-16 13:49:24', '2014-01-16 13:49:24', '', 0, 1, NULL),
(5, 6, 0, '', '', '2014-01-16 14:24:34', '2014-01-16 14:24:34', '', 0, 1, NULL),
(6, 7, 0, '', '', '2014-01-16 14:29:33', '2014-06-30 15:20:29', 'apm.com', 1, 1, NULL),
(7, 8, 0, '', '', '2014-01-16 14:31:43', '2014-08-14 09:04:34', 'homewisedocs.com', 1, 1, ''),
(8, 9, 0, '', '', '2014-01-16 14:33:46', '2014-01-16 14:33:46', '', 0, 1, NULL),
(9, 10, 0, '', '', '2014-01-16 14:35:33', '2014-08-25 13:41:58', 'community-mgmt.com', 1, 1, ''),
(10, 11, 0, '', '', '2014-01-16 14:37:55', '2014-08-22 17:53:23', 'WWW.HOMEWISEDOCS.COM', 1, 1, ''),
(11, 12, 0, '', 'Linda', '2014-01-16 14:51:08', '2014-01-16 14:51:08', '', 0, 1, NULL),
(12, 13, 0, '', '', '2014-01-16 14:54:26', '2014-01-16 14:54:26', '', 0, 1, NULL),
(13, 14, 0, '', '', '2014-01-16 14:56:02', '2014-01-16 14:56:02', '', 0, 1, NULL),
(14, 15, 0, '', '', '2014-01-16 14:57:50', '2014-01-16 14:57:50', '', 0, 1, NULL),
(15, 16, 0, 'Douglas Entrance North Tower', '', '2014-01-16 15:03:07', '2014-01-16 15:03:07', '', 0, 1, NULL),
(16, 17, 0, '', '', '2014-01-16 15:04:44', '2014-01-16 15:04:44', '', 0, 1, NULL),
(17, 18, 0, '', '', '2014-01-26 10:52:56', '2014-01-26 10:52:56', '', 0, 1, NULL),
(18, 19, 0, '', '', '2014-01-26 10:54:26', '2014-01-26 10:54:26', '', 0, 1, NULL),
(19, 20, 0, '', '', '2014-01-26 10:56:45', '2014-01-26 10:56:45', '', 0, 1, NULL),
(20, 21, 0, '', 'Ed', '2014-01-26 10:58:47', '2014-01-26 10:58:47', '', 0, 1, NULL),
(21, 22, 0, '', '', '2014-01-26 11:00:56', '2014-08-25 08:23:37', 'homewisedocs.com', 1, 1, '');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `homeowner_options`
--
CREATE TABLE IF NOT EXISTS `homeowner_options` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Volcado de datos para la tabla `homeowner_options`
--
INSERT INTO `homeowner_options` (`id`, `name`) VALUES
(1, 'Yes'),
(2, 'No'),
(3, 'Voluntary'),
(4, 'Verification');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `images`
--
CREATE TABLE IF NOT EXISTS `images` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`primary` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`secundary` varchar(100) COLLATE utf8_unicode_ci NOT 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
--
-- Volcado de datos para la tabla `images`
--
INSERT INTO `images` (`id`, `primary`, `secundary`, `created_at`, `updated_at`) VALUES
(1, 'slide-dos.png', 'slide-uno.png', '2014-09-30 10:41:51', '2014-09-30 10:41:51'),
(2, 'Tulips.jpg', 'Koala.jpg', '2014-09-30 10:42:17', '2014-09-30 10:42:17'),
(3, 'slide-dos.png', 'slide-uno.png', '2014-10-01 19:52:15', '2014-10-01 19:52:15'),
(4, 'imagen3.jpg', 'imagen1.jpg', '2014-10-10 16:54:29', '2014-10-10 16:54:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `invoices`
--
CREATE TABLE IF NOT EXISTS `invoices` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`number` varchar(100) DEFAULT NULL,
`order_file_id` int(11) DEFAULT NULL,
`file_number` varchar(50) NOT NULL,
`total` decimal(11,2) DEFAULT '0.00',
`service` varchar(50) NOT NULL DEFAULT 'HOA',
`bill_to` varchar(255) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`note` text,
`order_status` tinyint(1) DEFAULT '0',
`view` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Volcado de datos para la tabla `invoices`
--
INSERT INTO `invoices` (`id`, `order_id`, `user_id`, `number`, `order_file_id`, `file_number`, `total`, `service`, `bill_to`, `created_at`, `updated_at`, `note`, `order_status`, `view`) VALUES
(1, 2, 2, '2013-04606', 1, '2013-04606', '55.00', 'HOA', 'BAYVIEW TITLE SERVICES ', '2014-06-10 16:46:54', '2014-06-10 16:49:06', 'PENDING ESTOPPEL', 0, 0),
(2, 6, 4, '425021', 17, '47238-25', '45.00', 'HOA', 'BAY HARBOR TITLE, INC ', '2014-06-11 21:14:15', '2014-06-12 21:07:54', '', 1, 0),
(3, 4, 12, '425510', 38, '47224-25', '510.00', 'HOA', 'BAYVIEW TITLE SERVICES ', '2014-06-16 13:40:48', '2014-06-19 20:04:06', '', 1, 0),
(4, 4, 12, '425510', 35, '47224-25', '510.00', 'HOA', 'BAYVIEW TITLE SERVICES ', '2014-06-16 13:41:02', '2014-06-16 20:47:21', '', 1, 0),
(5, 12, 4, '425506', 33, '47446-25', '45.00', 'HOA', 'BAYVIEW TITLE SERVICES ', '2014-06-16 16:33:32', '2014-06-16 20:39:28', '', 1, 0),
(6, 8, 12, '426559', 54, '2013-06198', '45.00', 'HOA', 'BAYVIEW TITLE SERVICES ', '2014-06-23 16:25:32', '2014-06-23 21:54:12', '', 1, 0),
(7, 16275, 2, '16275', 49, 'test 234', '195.00', 'HOA', 'TOTAL INVESTORS ', '2014-06-23 17:27:52', '2014-06-25 17:43:08', 'estoppel and payoff', 1, 0),
(8, 7, 12, '426856', 61, '47231-25', '699.95', 'HOA', 'BAYVIEW TITLE SERVICES ', '2014-06-25 16:11:15', '2014-06-25 21:08:30', '', 1, 0),
(9, 16276, 2, 'test 16275', 63, 'TEST345', '410.00', 'HOA', 'TOTAL INVESTORS ', '2014-06-27 16:45:01', '2014-07-18 18:28:25', 'don''t know what', 1, 0),
(10, 16278, 4, '427609', 89, '14-276856', '50.00', 'HOA', 'TITLE & ABSTRACT AGENCY OF AMERICA ', '2014-06-30 16:15:11', '2014-07-01 19:14:55', '', 1, 0),
(11, 16284, 4, '427675', 90, '14-276923', '50.00', 'HOA', 'TITLE & ABSTRACT AGENCY OF AMERICA ', '2014-07-01 19:54:52', '2014-07-01 22:30:29', '', 1, 0),
(12, 16290, 2, 'TEST 16290', 104, 'TEST 44562', '348.00', 'HOA', 'TOTAL INVESTORS ', '2014-07-02 19:37:57', '2014-07-02 19:38:34', 'PENDING', 0, 0),
(13, 16291, 2, 'TEST 16291', 108, 'test 6', '10.00', 'HOA', 'TOTAL INVESTORS ', '2014-07-03 15:07:07', '2014-07-03 16:05:04', '', 1, 0);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `menu-items`
--
CREATE TABLE IF NOT EXISTS `menu-items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`position` int(11) NOT NULL,
`route` varchar(250) NOT NULL,
`route_name` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
KEY `position` (`position`),
KEY `position_2` (`position`),
KEY `position_3` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Volcado de datos para la tabla `menu-items`
--
INSERT INTO `menu-items` (`id`, `name`, `position`, `route`, `route_name`) VALUES
(1, 'HOME', 0, 'index', 'home'),
(2, 'TURNAROUND TIMES', 1, 'turnaround-times', 'turnaround.times'),
(3, 'MUNICIPAL NUMBERS', 3, 'municipal-numbers', 'municipal.numbers'),
(4, 'TAX COLLECTOR', 2, 'tax-collector', 'tax.collector'),
(8, 'CONTACT US', 4, 'contact-us', 'contact.us');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `menu-sub_items`
--
CREATE TABLE IF NOT EXISTS `menu-sub_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`parent` int(11) NOT NULL,
`route` varchar(250) NOT NULL,
`route_name` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Volcado de datos para la tabla `menu-sub_items`
--
INSERT INTO `menu-sub_items` (`id`, `name`, `parent`, `route`, `route_name`) VALUES
(1, 'LIEN ONLY', 5, 'order-forms-lien-only', 'order.forms.lien.only'),
(2, 'HOA ONLY', 5, 'order-forms-hoa-only', 'order.forms.hoa.only'),
(3, 'BOTH LIEN AND HOA', 5, 'order-forms-both-lien-and-hoa', 'order.forms.both.lien.and.hoa'),
(4, 'UPDATE ORDER / LIEN ONLY', 6, 'update-order-lien-only', 'update.order.lien.only'),
(5, 'UPDATE ORDER / HOA ONLY', 6, 'update-order-hoa-only', 'update.order.hoa.only'),
(6, 'UPDATE ORDER / BOTH LIEN AND HOA', 6, 'update-order-both-lien-and-hoa', 'update.order.both.lien.and.hoa'),
(7, 'CHECK STATUS / LIEN ', 7, 'check-status-lien', 'check.status.lien'),
(8, 'CHECK STATUS / HOA', 7, 'check-status-hoa', 'check.status.hoa');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `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;
--
-- Volcado de datos para la tabla `migrations`
--
INSERT INTO `migrations` (`migration`, `batch`) VALUES
('2014_06_10_112527_add_attach_to_notes_table', 1),
('2014_06_11_094530_add_cols_to_order_details_table', 2),
('2014_06_23_171445_add_enabled_to_collectors_table', 3),
('2014_06_23_171517_add_enabled_to_homeowners_table', 3),
('2014_06_23_171532_add_enabled_to_customers_table', 3),
('2014_06_24_152209_add_remember_token_to_users_table', 4),
('2014_06_30_101042_add_homeowner_transfer_fee_due_to_order_details_table', 5),
('2014_06_30_101150_add_homeowner_application_fees_due_to_order_details_table', 5),
('2014_06_30_101350_add_homeowner_special_assessments_due_to_order_details_table', 5),
('2014_07_01_095247_create_entity_files_table', 6),
('2014_07_09_150705_add_stack_to_users_table', 7),
('2014_07_24_152109_add_qb_check_id_to_checks_table', 8),
('2014_07_28_163121_add_ms_order_id_to_orders_table', 8),
('2014_08_01_122416_add_is_cashier_to_checks', 9),
('2014_08_02_134416_add_more_fields_to_order_details_table', 10),
('2014_08_04_150139_add_notes_to_homeowners_table', 11),
('2014_08_04_150204_add_notes_to_collectors_table', 11),
('2014_08_11_142422_add_next_detail_to_order_details_table', 12),
('2014_08_18_104034_add_notes_to_order_details_table', 13),
('2014_08_20_094839_create_order_tranfers_table', 14),
('2014_09_24_182515_create_address_table', 0),
('2014_09_24_182515_create_attentions_table', 0),
('2014_09_24_182515_create_checks_table', 0),
('2014_09_24_182515_create_cities_table', 0),
('2014_09_24_182515_create_collector_fee_table', 0),
('2014_09_24_182515_create_collectors_table', 0),
('2014_09_24_182515_create_contact_number_types_table', 0),
('2014_09_24_182515_create_contact_numbers_table', 0),
('2014_09_24_182515_create_counties_table', 0),
('2014_09_24_182515_create_countries_table', 0),
('2014_09_24_182515_create_customer_prices_table', 0),
('2014_09_24_182515_create_customers_table', 0),
('2014_09_24_182515_create_email_address_table', 0),
('2014_09_24_182515_create_email_order_table', 0),
('2014_09_24_182515_create_entities_table', 0),
('2014_09_24_182515_create_entity_files_table', 0),
('2014_09_24_182515_create_expense_types_table', 0),
('2014_09_24_182515_create_expenses_table', 0),
('2014_09_24_182515_create_fax_order_table', 0),
('2014_09_24_182515_create_fee_homeowner_table', 0),
('2014_09_24_182515_create_fee_types_table', 0),
('2014_09_24_182515_create_fees_table', 0),
('2014_09_24_182515_create_file_types_table', 0),
('2014_09_24_182515_create_frequencies_table', 0),
('2014_09_24_182515_create_groups_table', 0),
('2014_09_24_182515_create_homeowner_options_table', 0),
('2014_09_24_182515_create_homeowners_table', 0),
('2014_09_24_182515_create_invoices_table', 0),
('2014_09_24_182515_create_note_types_table', 0),
('2014_09_24_182515_create_notes_table', 0),
('2014_09_24_182515_create_order_details_table', 0),
('2014_09_24_182515_create_order_files_table', 0),
('2014_09_24_182515_create_order_statuses_table', 0),
('2014_09_24_182515_create_order_transfer_table', 0),
('2014_09_24_182515_create_order_user_table', 0),
('2014_09_24_182515_create_orders_table', 0),
('2014_09_24_182515_create_properties_table', 0),
('2014_09_24_182515_create_response_types_table', 0),
('2014_09_24_182515_create_states_table', 0),
('2014_09_24_182515_create_units_table', 0),
('2014_09_24_182515_create_users_table', 0),
('2014_09_24_182518_add_foreign_keys_to_address_table', 0),
('2014_09_24_182518_add_foreign_keys_to_attentions_table', 0),
('2014_09_24_182518_add_foreign_keys_to_checks_table', 0),
('2014_09_24_182518_add_foreign_keys_to_cities_table', 0),
('2014_09_24_182518_add_foreign_keys_to_collector_fee_table', 0),
('2014_09_24_182518_add_foreign_keys_to_collectors_table', 0),
('2014_09_24_182518_add_foreign_keys_to_contact_numbers_table', 0),
('2014_09_24_182518_add_foreign_keys_to_counties_table', 0),
('2014_09_24_182518_add_foreign_keys_to_customer_prices_table', 0),
('2014_09_24_182518_add_foreign_keys_to_customers_table', 0),
('2014_09_24_182518_add_foreign_keys_to_email_address_table', 0),
('2014_09_24_182518_add_foreign_keys_to_email_order_table', 0),
('2014_09_24_182518_add_foreign_keys_to_entity_files_table', 0),
('2014_09_24_182518_add_foreign_keys_to_expenses_table', 0),
('2014_09_24_182518_add_foreign_keys_to_fee_homeowner_table', 0),
('2014_09_24_182518_add_foreign_keys_to_fees_table', 0),
('2014_09_24_182518_add_foreign_keys_to_homeowners_table', 0),
('2014_09_24_182518_add_foreign_keys_to_invoices_table', 0),
('2014_09_24_182518_add_foreign_keys_to_notes_table', 0),
('2014_09_24_182518_add_foreign_keys_to_order_details_table', 0),
('2014_09_24_182518_add_foreign_keys_to_order_files_table', 0),
('2014_09_24_182518_add_foreign_keys_to_order_user_table', 0),
('2014_09_24_182518_add_foreign_keys_to_orders_table', 0),
('2014_09_24_182518_add_foreign_keys_to_states_table', 0),
('2014_09_24_182518_add_foreign_keys_to_users_table', 0),
('2014_09_23_143809_order_lien', 15),
('2014_09_24_024444_order_hoa', 15),
('2014_09_29_225709_images', 16);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `municipal`
--
CREATE TABLE IF NOT EXISTS `municipal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`county_id` int(11) NOT NULL,
`water` varchar(100) NOT NULL,
`building` varchar(100) NOT NULL,
`code` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `county_id` (`county_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Volcado de datos para la tabla `municipal`
--
INSERT INTO `municipal` (`id`, `county_id`, `water`, `building`, `code`) VALUES
(2, 3, '1213', '1354', '58997-88'),
(3, 3, '407-571-8044', '407-571-8044', '407-571-8044'),
(4, 4, '388-418-6228', '388-418-6228', '388-418-6228'),
(5, 5, '941-708-6130', '941-708-6130', '941-708-6130'),
(6, 6, '850-653-8715', '850-653-8715', '850-653-8715'),
(7, 7, '407-703-1727', '407-703-1727', '407-703-1727'),
(8, 8, '863-494-3678', '863-494-3678', '863-494-3678'),
(9, 1, '407-703-1727', '407-703-1727', '407-703-1727'),
(10, 9, '863-494-3678', '863-494-3678', '863-494-3678');
-- --------------------------------------------------------
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `notes`
--
CREATE TABLE IF NOT EXISTS `notes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`note_type_id` smallint(6) NOT NULL,
`order_status_id` tinyint(11) NOT NULL,
`note` text,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`html` text,
`manual` tinyint(1) NOT NULL DEFAULT '0',
`attach` text,
PRIMARY KEY (`id`),
KEY `order_id` (`order_id`),
KEY `user_id` (`user_id`),
KEY `note_type_id` (`note_type_id`),
KEY `order_status_id` (`order_status_id`),
KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Volcado de datos para la tabla `notes`
--
INSERT INTO `notes` (`id`, `order_id`, `user_id`, `note_type_id`, `order_status_id`, `note`, `created_at`, `updated_at`, `html`, `manual`, `attach`) VALUES
(1, 1, 3, 1, 1, 'Order Date', '2014-06-09 16:39:18', '2014-06-09 16:39:18', NULL, 0, NULL),
(2, 1, 3, 1, 1, 'Order assigned to Alyssa Rodriguez', '2014-06-09 16:39:18', '2014-06-09 16:39:18', NULL, 0, NULL),
(3, 2, 3, 1, 1, 'Order Date', '2014-06-09 16:46:12', '2014-06-09 16:46:12', NULL, 0, NULL),
(4, 2, 3, 1, 1, 'Order assigned to Alyssa Rodriguez', '2014-06-09 16:46:12', '2014-06-09 16:46:12', NULL, 0, NULL),
(5, 2, 2, 1, 2, 'No charge for providing information Homeowner 1 (Community Assn Mgt of Lake County Inc. )', '2014-06-10 12:16:08', '2014-06-10 12:16:08', NULL, 0, NULL),
(6, 2, 2, 1, 2, 'File pending sent to invoicing, note: PENDING ESTOPPEL', '2014-06-10 12:16:54', '2014-06-10 12:16:54', NULL, 0, NULL),
(7, 2, 2, 1, 2, 'Invoice to BAYVIEW TITLE SERVICES . Invoice # 2013-04606', '2014-06-10 12:19:06', '2014-06-10 12:19:06', NULL, 0, NULL),
(8, 2, 2, 1, 2, 'Invoiced pending " BAYVIEW TITLE SERVICES " #2013-04606 , note: PENDING ESTOPPEL', '2014-06-10 12:19:06', '2014-06-10 12:19:06', NULL, 0, NULL),
(9, 2, 1, 1, 5, 'Fax sent 352-250-8511', '2014-06-10 15:24:46', '2014-06-10 15:24:46', NULL, 0, NULL),
(10, 2, 1, 3, 5, 'Email sent saury.bravo@gmail.com', '2014-06-10 15:37:17', '2014-06-10 15:37:17', 'Dear: BAYVIEW TITLE SERVICES
We would like to inform you of the status on the above mentioned file. As of today the latest information is as follows:
dsfgasdgsdfgsdfgsdfgsdfgsdfg
Please if you have any questions or concerns, do not hesitate to reach me at your earliest convenience.
Thank you for choosing One-Step Lien Search, we value business.
Have a Great Day!!!
root
One-Step Lien Search LLC
13155 SW 42 ST Suite 202
Miami, FL 33175
Tel: 305-822-9979 / Fax:
saury.bravo@gmail.com
www.onesteplien.com', 0, NULL),
(11, 2, 1, 3, 5, 'dsfgasdgsdfgsdfgsdfgsdfgsdfg', '2014-06-10 15:37:17', '2014-06-10 15:37:17', NULL, 1, NULL),
(12, 2, 2, 3, 5, 'Email sent MORAYMA@ONESTEPLIEN.COM', '2014-06-10 15:39:17', '2014-06-10 15:39:17', 'Dear: BAYVIEW TITLE SERVICES
We would like to inform you of the status on the above mentioned file. As of today the latest information is as follows:
test
Please if you have any questions or concerns, do not hesitate to reach me at your earliest convenience.
Thank you for choosing One-Step Lien Search, we value business.
Have a Great Day!!!
Morayma Ramos
One-Step Lien Search LLC
13155 SW 42 ST Suite 202
Miami, FL 33175
Tel: 305-822-9979 / Fax: 305-822-9987
morayma@onesteplien.com
www.onesteplien.com', 0, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `note_types`
--
CREATE TABLE IF NOT EXISTS `note_types` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`class` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Volcado de datos para la tabla `note_types`
--
INSERT INTO `note_types` (`id`, `name`, `class`) VALUES
(1, 'Show Website', 'label-success'),
(2, 'Internal Details', 'label-danger'),
(3, 'Inform Client Email', 'label-info'),
(4, 'Dashboard Code', 'label-warning');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order-hoa-only`
--
CREATE TABLE IF NOT EXISTS `order-hoa-only` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`requested` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`file_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`closing_date` date NOT NULL,
`rush_order` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`street_number` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`street_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`unit_number` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`zip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`country` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`folio_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`legal_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`buyer` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`seller` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`specific_instructions` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`hoa_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`hoa_phone` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`list_agent_realtor` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`agent_phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`document` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`search_responde_delivery` varchar(50) COLLATE utf8_unicode_ci NOT 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 `order_hoa_only_file_number_unique` (`file_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order-lien-only`
--
CREATE TABLE IF NOT EXISTS `order-lien-only` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`requested` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`file_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`closing_date` date NOT NULL,
`rush_order` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`street_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`street_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`unit_number` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`zip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`country` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`folio_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`legal_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`buyer` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`seller` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`specific_instructions` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`search_order_selection` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`aditional_searches` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`document` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`search_responde_delivery` varchar(50) COLLATE utf8_unicode_ci NOT 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 `order_lien_only_file_number_unique` (`file_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
--
-- Volcado de datos para la tabla `order-lien-only`
--
INSERT INTO `order-lien-only` (`id`, `requested`, `file_number`, `closing_date`, `rush_order`, `street_number`, `street_name`, `type`, `unit_number`, `city`, `zip`, `country`, `folio_number`, `legal_description`, `buyer`, `seller`, `specific_instructions`, `search_order_selection`, `aditional_searches`, `document`, `search_responde_delivery`, `created_at`, `updated_at`) VALUES
(1, '', '74893', '0000-00-00', NULL, '', '', '1', '', '', '', '1', '', ' ', '', '', ' ', 'N;', 'N;', '2.jpg', 'N;', '2014-09-30 03:45:45', '2014-09-30 03:45:45'),
(3, '', 'maria', '0000-00-00', NULL, '', '', '1', '', '', '', '1', '', ' ', '', '', ' ', 'N;', 'N;', '1.jpg', 'N;', '2014-09-30 03:46:35', '2014-09-30 03:46:35');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL,
`customer_id` int(11) DEFAULT NULL,
`customer_email` varchar(150) DEFAULT NULL,
`customer_phone` varchar(50) DEFAULT NULL,
`customer_contact` varchar(100) DEFAULT NULL,
`file_number` varchar(30) NOT NULL,
`property_id` int(11) NOT NULL,
`order_status_id` tinyint(6) NOT NULL,
`special_instruction` text,
`is_rush` enum('1','0') NOT NULL DEFAULT '0',
`is_update` enum('1','0') NOT NULL DEFAULT '0',
`homeowner_option_id` smallint(6) NOT NULL DEFAULT '1',
`request_date` date DEFAULT NULL,
`closing_date` date DEFAULT NULL,
`completed_date` date DEFAULT NULL,
`seller_name` varchar(100) DEFAULT NULL,
`buyer_name` varchar(100) DEFAULT NULL,
`hoa_name` varchar(255) DEFAULT NULL,
`hoa_tel` varchar(40) DEFAULT NULL,
`listing_agent_name` varchar(150) DEFAULT NULL,
`agent_tel` varchar(40) DEFAULT NULL,
`response_type_id` tinyint(4) NOT NULL,
`response_contact` varchar(150) DEFAULT NULL,
`is_revised` tinyint(1) NOT NULL DEFAULT '0',
`mail_file` enum('0','1') DEFAULT '0',
`invoice_file` enum('0','1') DEFAULT '0',
`final_response_file` varchar(255) DEFAULT NULL,
`notes` text,
`closed_user_id` int(11) DEFAULT NULL,
`created_by_id` int(11) DEFAULT NULL,
`invoice_no` int(11) DEFAULT NULL,
`invoice_date` date DEFAULT NULL,
`invoice_list_QB_id` varchar(20) DEFAULT NULL,
`mail` text,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`ms_order_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_status_id` (`order_status_id`),
KEY `customer_id` (`customer_id`),
KEY `property_id` (`property_id`),
KEY `created_by_id` (`created_by_id`),
KEY `homeowner_option_id` (`homeowner_option_id`),
KEY `closed_user_id` (`closed_user_id`),
KEY `orders_ms_order_id_index` (`ms_order_id`),
KEY `file_number` (`file_number`),
KEY `is_rush` (`is_rush`),
KEY `is_update` (`is_update`),
KEY `closing_date` (`closing_date`),
KEY `request_date` (`request_date`),
KEY `completed_date` (`completed_date`),
KEY `ms_order_id` (`ms_order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Volcado de datos para la tabla `orders`
--
INSERT INTO `orders` (`id`, `parent_id`, `customer_id`, `customer_email`, `customer_phone`, `customer_contact`, `file_number`, `property_id`, `order_status_id`, `special_instruction`, `is_rush`, `is_update`, `homeowner_option_id`, `request_date`, `closing_date`, `completed_date`, `seller_name`, `buyer_name`, `hoa_name`, `hoa_tel`, `listing_agent_name`, `agent_tel`, `response_type_id`, `response_contact`, `is_revised`, `mail_file`, `invoice_file`, `final_response_file`, `notes`, `closed_user_id`, `created_by_id`, `invoice_no`, `invoice_date`, `invoice_list_QB_id`, `mail`, `created_at`, `updated_at`, `ms_order_id`) VALUES
(1, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'SUSIE RANDAZZO', '2013-05624', 1, 4, '', '0', '1', 1, '2014-06-09', '2014-06-23', NULL, 'TBD', 'TBD', 'STAGECOACH PROPERTY OWNERS ASSOCIATION, INC.', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, '', NULL, 3, NULL, NULL, NULL, NULL, '2014-06-09 16:39:18', '2014-06-11 10:51:59', 0),
(2, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'SUSIE RANDAZZO', '2013-04606', 2, 4, '', '0', '1', 1, '2014-06-09', '2014-06-13', '2014-06-10', 'tbd', 'tbd', 'MAGNOLIA POINTE MASTER HOMEOWNERS'' ASSOCIATION, INC.', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, 'pending', 2, 3, NULL, NULL, NULL, NULL, '2014-06-09 16:46:12', '2014-06-27 15:05:42', 0),
(3, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'SUSIE RANDAZZO', '47222-25', 3, 3, '', '1', '0', 1, '2014-06-11', '2014-06-20', '2014-07-15', 'VARAS,MARGARITA; VARAS,JOHN ', 'TBD', 'GOLFVIEW TOWNHOUSES CONDOMINIUM PROPERTY OWNERS ASSOCIATION, INC. ', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, 'PLEASE REVIEW ATTACHED DOCUMENTS FOR ADDITIONAL FEES. NO VIOLATIONS. $200.00 APPLICATION FEE. NO 2ND HOA. NO SPECIAL ASSESSMENT SEE EMAIL. CDD ATTACHED. AS PER Shelly Darman, NO TRANSFER FEE. PET FEE $100.00', 12, 3, NULL, NULL, NULL, NULL, '2014-06-11 10:54:52', '2014-07-15 20:00:34', 0),
(4, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'SUSIE RANDAZZO', '47224-25', 4, 3, '', '0', '0', 1, '2014-06-11', '2014-06-20', '2014-06-19', 'FEDERAL NATIONAL MORTGAGE ASSOCIATION', 'TBD', 'RIVER OAKS CONDOMINIUM I ASSOCIATION, INC.', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, NULL, 12, 3, NULL, NULL, NULL, NULL, '2014-06-11 10:57:08', '2014-08-20 15:50:59', 0),
(5, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'SUSIE RANDAZZO', '47223-25', 5, 3, '', '0', '0', 1, '2014-06-11', '2014-06-20', '2014-07-09', 'FNMA (SHALOM SHOKI)', 'TBD', 'CITYSIDE CONDOMINIUM ASSOCIATION, INC. ', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, 'PLEASE REVIEW ATTACHED DOCUMENTS FOR ADDITIONAL FEES. APPLICATION FEE $100.00 PER PERSON. MOVE IN FEE $250.00', 12, 3, NULL, NULL, NULL, NULL, '2014-06-11 10:59:53', '2014-07-09 13:38:40', 0),
(6, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'HELGA MIRANDA', '47238-25', 6, 3, '', '0', '0', 2, '2014-06-11', '2014-06-25', '2014-06-12', 'Federal National Mortgage Assoc (RODRIGUEZ,ROCIO)', 'N/A', 'N/A', '', '', '', 1, 'lienletters@bayview-title.com', 1, '0', '0', NULL, 'DID NOT FIND ANYTHING TO INDICATE ASSOCIATION NAME.\r\n- NO PUD 2525 / 817\r\n- NO ASSOCIATION LIEN UNDER "RODRIGUEZ,ROCIO" OR "DAROCO."\r\nREFERENCE TITLE COMMITMENT. IF YOU HAVE ANY OTHER INFO, PLEASE ADVISE. (AR)', 4, 2, NULL, NULL, NULL, NULL, '2014-06-11 16:13:28', '2014-06-12 16:46:31', 0),
(7, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'HELGA MIRANDA', '47231-25', 7, 3, '', '0', '0', 1, '2014-06-11', '2014-06-25', '2014-06-25', 'FEDERAL NATIONAL MORTGAGE ASSN (FRANCOIS,CLAUDE)', 'N/A', 'CHAPEL TRAIL OWNERS ASSOCIATION, INC. ', '', '', '', 1, 'lienletters@bayview-title.com', 1, '0', '0', NULL, 'PLEASE REVIEW ATTACHED DOCUMENTS FOR ADDITIONAL FEES. SPECIAL ASSESSMENT LETTER ATTACHED ', 12, 2, NULL, NULL, NULL, NULL, '2014-06-11 16:15:06', '2014-07-18 15:00:07', 0),
(8, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'SUSIE RANDAZZO', '2013-06198', 8, 3, '', '0', '1', 1, '2014-06-11', '2014-06-25', '2014-06-24', 'Federal National Mortgage Assn (MAHARAJ HARRDEO)', 'N/A', 'COUNTRY RUN COMMUNITY ASSOCIATION ', '407-788-6700', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, 'PLEASE REVIEW ATTACHED DOCUMENTS FOR ADDITIONAL FEES. NO 2ND HOA, SEE ATTACHED EMAIL FOR VIOLATIONS. APPLICATION ATTACHED', 12, 2, NULL, NULL, NULL, NULL, '2014-06-11 16:18:20', '2014-06-24 16:42:45', 0),
(9, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'HELGA MIRANDA', '47433-25', 9, 3, '', '0', '0', 1, '2014-06-13', NULL, '2014-07-07', 'FEDERAL NATIONAL MORTGAGE ASSN', 'N/A', 'HILLCREST NO. 21, INC', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, 'NO SPECIAL ASSESSMENTS AT THIS TIME. NO OTHER ASSOCIATION. SEE EMAIL (UNABLE TO CONFIRM IF THERE IS A RECREATIONAL LEASE) CDD ATTACHED. NO LEDGER, DETAILED BREAKDOWN INCLUDED IN PAYOFF LETTER. APPLICATION FEE $100.00. CONDO DOCS $75.00. AS PER ASUNTA AT MGT, TRANSFER FEE $100.00. DUES ARE PAYABLE TO ASSOCIATION SEE ATTORNEY EMAIL', 12, 2, NULL, NULL, NULL, NULL, '2014-06-13 12:23:08', '2014-07-07 16:50:59', 0),
(10, NULL, 28, 'lienletters@bayview-title.com', '954-771-5522', 'HELGA MIRANDA', '47437-25', 10, 3, '', '0', '0', 1, '2014-06-13', NULL, '2014-07-09', 'FEDERAL NATIONAL MORTGAGE ASSN (HALLSTRAND RICHARD P & SHIRLEY L)', 'TBD', 'THE RIDGE AT THE BLUFFS HOMEOWNERS ASSOCIATION, INC.', '', '', '', 1, 'lienletters@bayview-title.com', 0, '0', '0', NULL, 'PLEASE REVIEW ATTACHED DOCUMENTS FOR ADDITIONAL FEES. BECKER DOES NOT RELEASE SEPARATE LEDGERS. INTEREST ACCRUES AT $0.52 PER DAY. NO TRANSFER FEE SEE EMAIL ', 12, 17, NULL, NULL, NULL, NULL, '2014-06-13 12:32:06', '2014-07-09 17:56:49', 0),
(13, NULL, NULL, NULL, NULL, NULL, '47231-26890', 1, 2, 'De prueba', '0', '1', 1, '2014-09-01', '2014-09-11', '2014-09-23', NULL, NULL, 'N/A', NULL, NULL, NULL, 0, NULL, 0, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order_details`
--
CREATE TABLE IF NOT EXISTS `order_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`homeowner_id` int(11) DEFAULT NULL,
`homeowner_hoa_name` varchar(255) DEFAULT NULL,
`homeowner_phone_ft` varchar(30) DEFAULT NULL,
`homeowner_phone_sd` varchar(30) DEFAULT NULL,
`homeowner_fee_id` smallint(11) DEFAULT NULL,
`homeowner_date_ordered` date DEFAULT NULL,
`homeowner_maintenance_fee` varchar(100) DEFAULT NULL,
`homeowner_frequency_id` tinyint(4) DEFAULT NULL,
`homeowner_current_due` varchar(100) DEFAULT NULL,
`homeowner_good_thru` date DEFAULT NULL,
`homeowner_violations` enum('0','3','2','1') DEFAULT NULL,
`homeowner_date_received` date DEFAULT NULL,
`homeowner_has_request` enum('1','0') NOT NULL DEFAULT '0',
`homeowner_send_mail` enum('1','0') NOT NULL DEFAULT '0',
`homeowner_send_fax` enum('1','0') NOT NULL DEFAULT '0',
`homeowner_check_id` int(11) DEFAULT NULL,
`homeowner_is_free` tinyint(1) NOT NULL DEFAULT '0',
`homeowner_transfer_fee_due` enum('0','1','2','3') DEFAULT NULL,
`homeowner_transfer_fee_amount` varchar(50) DEFAULT NULL,
`homeowner_application_fees_due` enum('0','1','2','3') DEFAULT NULL,
`homeowner_application_fees_amount` varchar(50) DEFAULT NULL,
`homeowner_special_assessments_due` enum('0','1','2','3') DEFAULT NULL,
`homeowner_special_assessments_amount` varchar(50) DEFAULT NULL,
`homeowner_special_assessments_notes` varchar(255) DEFAULT NULL,
`homeowner_file_estoppel` tinyint(1) unsigned NOT NULL DEFAULT '0',
`homeowner_file_ledger` tinyint(1) unsigned NOT NULL DEFAULT '0',
`homeowner_file_w9` tinyint(1) unsigned NOT NULL DEFAULT '0',
`collector_id` int(11) DEFAULT NULL,
`collector_fee_id` smallint(11) DEFAULT NULL,
`collector_date_received` date DEFAULT NULL,
`collector_date_ordered` date DEFAULT NULL,
`collector_current_due` varchar(100) DEFAULT NULL,
`collector_good_thru` date DEFAULT NULL,
`collector_has_request` enum('1','0') NOT NULL DEFAULT '0',
`collector_send_mail` enum('1','0') NOT NULL DEFAULT '0',
`collector_send_fax` enum('1','0') NOT NULL DEFAULT '0',
`collector_check_id` int(11) DEFAULT NULL,
`collector_is_free` tinyint(1) NOT NULL DEFAULT '0',
`collector_file_payoff` tinyint(1) unsigned NOT NULL DEFAULT '0',
`collector_file_ledger` tinyint(1) unsigned NOT NULL DEFAULT '0',
`collector_file_w9` tinyint(1) unsigned NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`next_detail` enum('Yes','No','N/A - Unable to confirm','Unable to confirm writting') DEFAULT NULL,
`notes` text,
PRIMARY KEY (`id`),
KEY `homeowner_id` (`homeowner_id`),
KEY `homeowner_frequency_id` (`homeowner_frequency_id`),
KEY `order_id` (`order_id`),
KEY `collector_id` (`collector_id`),
KEY `homeowner_fee_id` (`homeowner_fee_id`),
KEY `collector_fee_id` (`collector_fee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Volcado de datos para la tabla `order_details`
--
INSERT INTO `order_details` (`id`, `order_id`, `homeowner_id`, `homeowner_hoa_name`, `homeowner_phone_ft`, `homeowner_phone_sd`, `homeowner_fee_id`, `homeowner_date_ordered`, `homeowner_maintenance_fee`, `homeowner_frequency_id`, `homeowner_current_due`, `homeowner_good_thru`, `homeowner_violations`, `homeowner_date_received`, `homeowner_has_request`, `homeowner_send_mail`, `homeowner_send_fax`, `homeowner_check_id`, `homeowner_is_free`, `homeowner_transfer_fee_due`, `homeowner_transfer_fee_amount`, `homeowner_application_fees_due`, `homeowner_application_fees_amount`, `homeowner_special_assessments_due`, `homeowner_special_assessments_amount`, `homeowner_special_assessments_notes`, `homeowner_file_estoppel`, `homeowner_file_ledger`, `homeowner_file_w9`, `collector_id`, `collector_fee_id`, `collector_date_received`, `collector_date_ordered`, `collector_current_due`, `collector_good_thru`, `collector_has_request`, `collector_send_mail`, `collector_send_fax`, `collector_check_id`, `collector_is_free`, `collector_file_payoff`, `collector_file_ledger`, `collector_file_w9`, `created_at`, `updated_at`, `next_detail`, `notes`) VALUES
(1, 2, 1711, NULL, NULL, NULL, 2541, '2014-06-27', 'PENDING', NULL, NULL, NULL, NULL, NULL, '1', '0', '0', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 6, 46, NULL, '2014-06-10', NULL, NULL, '1', '0', '0', NULL, 0, 0, 0, 0, '2014-06-09 17:26:36', '2014-06-27 15:05:22', NULL, NULL),
(2, 5, 4135, 'CITYSIDE CONDOMINIUM ASSOCIATION', '561-697-8997 x7301', '561-697-8987', 2542, '2014-07-09', '1530.00', 2, '10,766.80 + 3768.98', '2014-09-30', '1', '2014-07-09', '1', '0', '0', 373, 0, '0', NULL, '1', '100.00', '2', NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', '0', NULL, 0, 0, 0, 0, '2014-06-11 11:30:19', '2014-07-09 09:58:48', NULL, NULL),
(3, 4, 871, 'RIVER OAKS CONDOMINIUM I ASSOCIATION, INC.', '813-868-1104', '813-868-1104', 2544, '2014-06-19', '254.35', 1, 'SEE PAYOFF', '2014-07-31', '0', '2014-06-13', '0', '0', '0', 16827, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 35, 2556, '2014-06-16', '2014-06-12', '3014.16', '2014-07-31', '1', '0', '0', 16828, 0, 0, 0, 0, '2014-06-11 11:59:09', '2014-08-20 15:50:59', NULL, NULL),
(4, 4, 871, 'RIVER OAKS REC', '813-868-1104', '813-868-1104', 2544, '2014-06-19', '92.49', 1, 'SEE PAYOFF', '2014-07-31', '0', '2014-06-13', '0', '0', '0', 16829, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 35, 2556, '2014-06-16', '2014-06-12', '949.71', '2014-07-31', '0', '0', '0', 16830, 0, 0, 0, 0, '2014-06-11 12:06:15', '2014-08-20 15:51:00', NULL, NULL),
(5, 3, 9473, 'GOLFVIEW TOWNHOUSES CONDOMINIUM PROPERTY OWNERS ASSOCIATION, INC. ', '954-345-1814', ' ', 2549, '2014-07-15', '300.00', 1, 'SEE PAYOFF', '2014-07-31', '0', '2014-07-14', '1', '0', '0', 550, 0, '0', NULL, '1', '200.00', '0', NULL, NULL, 0, 0, 0, 9466, 2566, '2014-07-14', '2014-06-16', '2715.00', '2014-07-31', '1', '0', '0', NULL, 1, 0, 0, 0, '2014-06-11 12:31:10', '2014-07-15 16:38:31', NULL, NULL),
(8, 8, 249, ' COUNTRY RUN COMMUNITY ASSOCIATION, INC. ', '407-788-6700 x405', '407-788-7488', 2553, '2014-06-24', '202.00', 4, '150.00', '2014-06-30', '1', '2014-06-23', '1', '0', '0', 9, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', NULL, 0, 0, 0, 0, '2014-06-11 16:25:12', '2014-06-24 16:16:23', NULL, NULL),
(9, 7, 1945, 'EM computer solutions', '954-458-5557', '954-458-5056', 2560, '2014-07-18', '200.00', 2, 'SEE PAYOFF', '2014-07-12', '1', '2014-06-16', '1', '0', '0', 688, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 1982, 2561, '2014-06-24', '2014-06-24', '1870.01', '2014-07-12', '0', '0', '0', 22, 0, 0, 0, 0, '2014-06-11 16:47:04', '2014-07-18 15:00:07', NULL, NULL),
(10, 7, 1939, ' WEITZER CHAPEL TRAIL HOMES HOA, INC. ', '954-966-1762', '954-357-0773', 1261, '2014-07-18', '76.00', 2, 'SEE PAYOFF', '2014-06-30', '1', '2014-06-20', '1', '0', '0', 8, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 84, 2558, '2014-06-24', '2014-06-20', '3233.04', '2014-06-30', '1', '0', '0', 21, 0, 0, 0, 0, '2014-06-11 17:22:35', '2014-07-18 15:00:07', NULL, NULL),
(11, 9, 1945, 'HILLCREST NO. 21, INC', '954-458-5557', '954-458-5056', 2555, '2014-07-07', '400.00', 1, 'SEE PAYOFF', '2014-07-26', '0', '2014-06-20', '1', '0', '0', 286, 0, '1', '100.00', '1', '100.00', '0', NULL, NULL, 0, 0, 0, 507, 394, '2014-07-03', '2014-06-13', '11,148.02', '2014-07-26', '1', '0', '0', NULL, 0, 0, 0, 0, '2014-06-13 12:52:34', '2014-07-07 15:55:37', NULL, NULL),
(12, 11, 1934, 'PALMETTO GARDENS NORTH CONDOMINIUM ASSOCIATION, INC. ', '305-819-2361', '305-825-0608', 1257, '2014-07-31', '194.24', 1, '408.48 see ledger ', '2014-08-31', '1', '2014-08-21', '1', '0', '0', 12, 0, '0', NULL, '1', '150.00', '0', NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', '0', NULL, 0, 0, 0, 0, '2014-06-13 15:00:15', '2014-08-22 10:04:01', 'No', 'PLEASE REVIEW ATTACHED DOCUMENTS FOR ADDITIONAL FEES. PROPERTY IS NO LONGER IN COLLECTIONS- SEE ATTACHED LEDGER FOR AMOUNT DUE. AMOUNT ON LEDGER $408.48 WILL REMAIN VALID THRU 8-31-2014; COLLECT NEXT ASSESSMENT $194.24 ON 9-1-2014- SEE ATTACHED EMAIL '),
(13, 10, 9474, 'THE RIDGE AT THE BLUFFS HOMEOWNERS ASSOCIATION, INC.', '561-744-3009', '561-744-4957', 2550, '2014-07-09', '490.00', 2, 'SEE PAYOFF', '2014-07-18', '1', '2014-07-07', '1', '0', '0', 14, 0, '0', NULL, '1', '200.00', '0', NULL, NULL, 0, 0, 0, 9468, 2557, '2014-06-25', '2014-06-16', '1947.66', '2014-07-18', '1', '0', '0', 13, 0, 0, 0, 0, '2014-06-16 10:37:42', '2014-07-09 17:56:49', NULL, NULL);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order_files`
--
CREATE TABLE IF NOT EXISTS `order_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL,
`order_detail_id` int(11) DEFAULT NULL,
`homeowner_id` int(11) DEFAULT NULL,
`collector_id` int(11) DEFAULT NULL,
`file_type_id` smallint(6) NOT NULL,
`path` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `file_type_id` (`file_type_id`),
KEY `order_id` (`order_id`),
KEY `homeowner_id` (`homeowner_id`),
KEY `collector_id` (`collector_id`),
KEY `order_detail_id` (`order_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
--
-- Volcado de datos para la tabla `order_files`
--
INSERT INTO `order_files` (`id`, `order_id`, `order_detail_id`, `homeowner_id`, `collector_id`, `file_type_id`, `path`, `name`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, NULL, NULL, 10, 'http://192.168.0.86:8080/files/orders/2', 'invoice.pdf', '2014-06-10 12:19:06', '2014-06-10 12:19:06'),
(2, 5, 2, 4135, NULL, 2, 'http://192.168.0.86:8080/files/orders/5/2/homeowner/4135', '1402501079.cityside.pdf', '2014-06-11 11:37:59', '2014-06-11 11:37:59'),
(3, 4, 3, 871, NULL, 2, 'http://192.168.0.86:8080/files/orders/4/3/homeowner/871', '1402502748.AVID_CONDO I.pdf', '2014-06-11 12:05:48', '2014-06-11 12:05:48'),
(4, 4, 4, 871, NULL, 2, 'http://192.168.0.86:8080/files/orders/4/4/homeowner/871', '1402502906.AVID_REC.pdf', '2014-06-11 12:08:26', '2014-06-11 12:08:26'),
(5, 6, NULL, NULL, NULL, 8, 'http://192.168.0.86:8080/files/orders/6', 'http___oncore.slcclerkofcourt.com_oncorewebnew_search.pdf', '2014-06-11 16:41:55', '2014-06-11 16:41:55'),
(6, 7, 9, 1945, NULL, 2, 'http://192.168.0.86:8080/files/orders/7/9/homeowner/1945', '1402521164.Memo Style.pdf', '2014-06-11 17:12:44', '2014-06-11 17:12:44'),
(7, 7, 10, 1939, NULL, 2, 'http://192.168.0.86:8080/files/orders/7/10/homeowner/1939', 'check-8.pdf', '2014-06-11 17:25:20', '2014-06-11 17:25:20'),
(8, 4, 3, 871, NULL, 3, 'http://192.168.0.86:8080/files/orders/4/3/homeowner/871', '1402582627.5125 RIVER OAKS.pdf', '2014-06-12 10:17:07', '2014-06-12 10:17:07'),
(9, 4, 4, 871, NULL, 3, 'http://192.168.0.86:8080/files/orders/4/4/homeowner/871', '1402582799.5125 REC.pdf', '2014-06-12 10:19:59', '2014-06-12 10:19:59'),
(10, 4, 3, 871, NULL, 1, 'http://192.168.0.86:8080/files/orders/4/3/homeowner/871', '1402583191.river oak condo.pdf', '2014-06-12 10:26:31', '2014-06-12 10:26:31'),
(11, 4, 4, 871, NULL, 1, 'http://192.168.0.86:8080/files/orders/4/4/homeowner/871', '1402583208.river oak rec.pdf', '2014-06-12 10:26:48', '2014-06-12 10:26:48'),
(12, 8, 8, 249, NULL, 8, 'http://192.168.0.86:8080/files/orders/8/8/homeowner/249', '1402588095.2525.pdf', '2014-06-12 11:48:15', '2014-06-12 11:48:15'),
(13, 8, 8, 249, NULL, 8, 'http://192.168.0.86:8080/files/orders/8/8/homeowner/249', '1402588172.4525 APPLICATION.pdf', '2014-06-12 11:49:32', '2014-06-12 11:49:32'),
(14, 8, 8, 249, NULL, 8, 'http://192.168.0.86:8080/files/orders/8/8/homeowner/249', '1402588261.4525 VIOLATION.pdf', '2014-06-12 11:51:01', '2014-06-12 11:51:01'),
(15, 6, NULL, NULL, NULL, 10, 'http://192.168.0.86:8080/files/orders/6', 'invoice.pdf', '2014-06-12 13:30:29', '2014-06-12 13:30:29'),
(16, 6, NULL, NULL, NULL, 10, 'http://192.168.0.86:8080/files/orders/6', 'summary.pdf', '2014-06-12 13:30:29', '2014-06-12 13:30:29');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order_statuses`
--
CREATE TABLE IF NOT EXISTS `order_statuses` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`color` varchar(10) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Volcado de datos para la tabla `order_statuses`
--
INSERT INTO `order_statuses` (`id`, `name`, `color`) VALUES
(1, 'New', '#e25856'),
(2, 'Processing', '#54728C'),
(3, 'Completed', '#8fc556'),
(4, 'Cancelled', '#000000'),
(5, 'Review', '#428bca'),
(6, 'Reject', '#f89406');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order_transfer`
--
CREATE TABLE IF NOT EXISTS `order_transfer` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(10) unsigned NOT NULL,
`transfer` tinyint(1) NOT NULL DEFAULT '0',
`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 `order_transfer_order_id_unique` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;
--
-- Volcado de datos para la tabla `order_transfer`
--
INSERT INTO `order_transfer` (`id`, `order_id`, `transfer`, `created_at`, `updated_at`) VALUES
(1, 16737, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:37'),
(2, 17726, 1, '2014-08-21 01:05:55', '2014-08-21 01:17:55'),
(3, 17815, 1, '2014-08-21 01:05:55', '2014-08-21 01:17:57'),
(4, 17819, 1, '2014-08-21 01:05:55', '2014-08-21 01:17:57'),
(6, 16285, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(7, 16301, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(8, 16302, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(9, 16309, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(10, 16316, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(11, 16317, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(12, 16337, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(13, 16356, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:28'),
(14, 16390, 1, '2014-08-21 01:05:55', '2014-08-21 01:11:29'),
(15, 16398, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(16, 16404, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(17, 16405, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(18, 16407, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(19, 16418, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(20, 16421, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(21, 16426, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(22, 16429, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(23, 16430, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(24, 16431, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:29'),
(25, 16433, 1, '2014-08-21 01:05:56', '2014-08-21 01:11:30');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `order_user`
--
CREATE TABLE IF NOT EXISTS `order_user` (
`order_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`order_id`,`user_id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Volcado de datos para la tabla `order_user`
--
INSERT INTO `order_user` (`order_id`, `user_id`) VALUES
(1, 4),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(6, 4),
(7, 4),
(8, 4),
(9, 4),
(10, 4),
(11, 4),
(12, 4),
(16275, 4),
(16278, 4);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `properties`
--
CREATE TABLE IF NOT EXISTS `properties` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`county_id` int(11) NOT NULL,
`city_id` int(11) NOT NULL,
`folio_number` varchar(150) NOT NULL,
`zipcode` varchar(20) NOT NULL,
`address` varchar(255) NOT NULL,
`legal_description` text NOT NULL,
`updated_at` datetime DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `county_id` (`county_id`),
KEY `city_id` (`city_id`),
KEY `folio_number` (`folio_number`),
KEY `address` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Volcado de datos para la tabla `properties`
--
INSERT INTO `properties` (`id`, `county_id`, `city_id`, `folio_number`, `zipcode`, `address`, `legal_description`, `updated_at`, `created_at`) VALUES
(1, 1, 561, '21-26-19-0040-00200-0050', '34639', '24847 GUN SMOKE DR', 'STAGECOACH VILLAGE PARCEL 4 PHASE 2 PB 36 PGS 133-135 LOT 5 BLK 2', '2014-06-09 17:21:06', '2014-06-09 16:39:18'),
(2, 4, 288, '25-22-26-130000009300', '34711', '17431 TAILFEATHER CT', 'MAGNOLIA POINTE SUB LOT 93 PB 40 PGS 1-6 ORB 4320 PG 1649', '2014-06-27 15:05:22', '2014-06-09 16:46:12'),
(3, 6, 70, '4841 15 BM 0040', '33065', '8707 NW 35 ST 4', 'GOLFVIEW TOWNHOUSE OF CORAL SPRINGS CONDO UNIT 4 ', '2014-07-15 16:38:31', '2014-06-11 10:54:52'),
(4, 8, 248, '039053-0194', '33617', '5125 PURITAN CIRCLE', 'RIVER OAKS CONDOMINIUM I PHASE 6 BLDG 11 UNIT 1103 TYPE C .84% UNDIVIDED SHARES IN COMMON ELEMENTS EXPENSES AND SURPLUS ', '2014-08-20 15:50:59', '2014-06-11 10:57:08'),
(5, 5, 551, '74-43-43-17-31-007-0034', '33401', '845 MILLBRAE CT 4', 'CITYSIDE CONDOMINIUM UNIT 4 BLDG 7C ', '2014-07-09 09:58:48', '2014-06-11 10:59:53'),
(6, 9, 726, '3420-720-1676-000-6', '34986', '6128 NW DAROCO TERR', 'N/A', '2014-06-12 16:46:31', '2014-06-11 16:13:28'),
(7, 7, 7, '5139 12 02 1370', '33029', '19363 NW 11 ST', 'AMERITRAIL SECTION TWO 151-28 B LOT 15 BLK 5 ', '2014-07-18 15:00:07', '2014-06-11 16:15:06'),
(8, 8, 4, '02-22-28-6046-05-200', '32818', '4525 GALLBERRY CT', 'OAK LANDING UNIT 2 57/17 LOT 520 ', '2014-06-24 16:16:23', '2014-06-11 16:18:20'),
(9, 2, 3, '5142 19 DE 1520', '33021', '4400 HILLCREST DRIVE 816B', 'HILLCREST NO 21 CONDO UNIT 816-B ', '2014-07-07 15:55:37', '2014-06-13 12:23:08'),
(10, 5, 7, '30-43-41-16-02-000-1440', '33477', '102 RIDGE ROAD', 'RIDGE AT THE BLUFFS LT 144 & N 9.67 FT OF TR O-2 LYING S OF & ADJ THERETO ', '2014-07-09 17:56:49', '2014-06-13 12:32:06'),
(11, 4, 4, '04-2035-060-0210', '33012', '6125 W 20 AVE 204', 'PALMETTO GARDENS NORTH CONDO UNIT 204 - 2ND FLOOR UNDIV 2.0288% INT IN COMMON ELEMENTS CLERKS FILE 74R247154 OR 13927-2761 1288 1 COC 24776-3140 06 2006 1', '2014-08-22 10:04:01', '2014-06-13 12:41:44'),
(12, 6, 8, '4940 25 02 1040', '33323', '11831 NW 26 STREET', 'FLA FRUIT LANDS CO SUB NO 1 25-49-40 2-17 D BEG AT NE COR OF TR 20,W 109.71 TO POB,W 94.22,S 132.93,E 94.22, N 132.85 TO POB AKA: LOT 13 TR 20 ', '2014-06-19 08:52:41', '2014-06-13 12:44:04'),
(13, 8, 1, '34-24-29-2671-00-210', '32837', '14719 GRAND COVE DR ', 'FALCON TRACE UNIT 9 53/85 LOT 21', '2014-06-18 11:36:44', '2014-06-18 11:36:44'),
(14, 1, 3, '00-42-45-09-17-000-0030', '33467', '7417 WESCOTT TER, ', 'LAKE CHARLESTON TR Y LT 3', '2014-06-18 11:36:44', '2014-06-18 11:36:44');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `response_types`
--
CREATE TABLE IF NOT EXISTS `response_types` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Volcado de datos para la tabla `response_types`
--
INSERT INTO `response_types` (`id`, `name`) VALUES
(1, 'Email'),
(2, 'Fax');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `states`
--
CREATE TABLE IF NOT EXISTS `states` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`country_id` smallint(6) NOT NULL,
`state` varchar(80) NOT NULL,
`code` varchar(10) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `country_id_state` (`country_id`,`state`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;
--
-- Volcado de datos para la tabla `states`
--
INSERT INTO `states` (`id`, `country_id`, `state`, `code`) VALUES
(1, 1, 'Alabama', 'AL'),
(2, 1, 'Alaska', 'AK'),
(3, 1, 'Arizona', 'AZ'),
(4, 1, 'Arkansas', 'AR'),
(5, 1, 'California', 'CA'),
(6, 1, 'Colorado', 'CO'),
(7, 1, 'Connecticut', 'CT'),
(8, 1, 'Delaware', 'DE'),
(9, 1, 'District of Columbia', 'DC'),
(10, 1, 'Florida', 'FL'),
(11, 1, 'Georgia', 'GA'),
(12, 1, 'Hawaii', 'HI'),
(13, 1, 'Idaho', 'ID'),
(14, 1, 'Illinois', 'IL'),
(15, 1, 'Indiana', 'IN'),
(16, 1, 'Iowa', 'IA'),
(17, 1, 'Kansas', 'KS'),
(18, 1, 'Kentucky', 'KY'),
(19, 1, 'Louisiana', 'LA');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `taxcollectordetails`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `tax_collector`
--
CREATE TABLE IF NOT EXISTS `tax_collector` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`county_id` int(100) NOT NULL,
`address` varchar(100) NOT NULL,
`phone` varchar(100) NOT NULL,
`website` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `county_id` (`county_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Volcado de datos para la tabla `tax_collector`
--
INSERT INTO `tax_collector` (`id`, `county_id`, `address`, `phone`, `website`) VALUES
(6, 8, 'Fort Lauderdale, FL 33301', '954-831-4000', 'https://www.broward.county-taxes.com/public/search/advanced?tab=r\r\ne'),
(7, 3, 'doral 1', '04249271991', 'http://www.calhouncountytaxcollector.com');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `turnaroundtime`
--
CREATE TABLE IF NOT EXISTS `turnaroundtime` (
`TATID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`CountyID` int(11) NOT NULL,
`CityID` int(11) NOT NULL,
`TurnAroundTime` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`CreatedOn` time NOT NULL,
`CreatedBy` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`UpdatedOn` time NOT NULL,
`UpdatedBy` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`TATID`),
KEY `CityID` (`CityID`),
KEY `CountyID` (`CountyID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
--
-- Volcado de datos para la tabla `turnaroundtime`
--
INSERT INTO `turnaroundtime` (`TATID`, `CountyID`, `CityID`, `TurnAroundTime`, `CreatedOn`, `CreatedBy`, `UpdatedOn`, `UpdatedBy`) VALUES
(1, 1, 1, 'Esto es un texto', '09:15:58', '1', '09:15:58', '1');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `units`
--
CREATE TABLE IF NOT EXISTS `units` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Volcado de datos para la tabla `units`
--
INSERT INTO `units` (`id`, `name`) VALUES
(1, ''),
(2, 'Days'),
(3, 'Hrs');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `updates`
--
CREATE TABLE IF NOT EXISTS `updates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Volcado de datos para la tabla `updates`
--
INSERT INTO `updates` (`id`, `title`) VALUES
(0, ''),
(1, 'update');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(70) NOT NULL,
`password` varchar(80) NOT NULL,
`entity_id` int(11) NOT NULL,
`email_address_id` int(11) NOT NULL,
`parent_id` int(11) NOT NULL DEFAULT '0',
`group_id` smallint(11) NOT NULL,
`enabled` enum('1','0') NOT NULL DEFAULT '0',
`orders` int(11) NOT NULL DEFAULT '0',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`stack_number` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `username_email_address_id` (`email_address_id`) USING BTREE,
KEY `users_groups_group_id` (`group_id`),
KEY `users_entities_entity_id` (`entity_id`),
KEY `users_stack_number_index` (`stack_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Volcado de datos para la tabla `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `entity_id`, `email_address_id`, `parent_id`, `group_id`, `enabled`, `orders`, `created_at`, `updated_at`, `remember_token`, `stack_number`) VALUES
(1, 'root', '$2y$08$hNmGTBFubAV8qX6dmGmaEOvGsMJpJMOCNm5pRxnF84Wcvw66DUVKq', 1, 1, 0, 1, '1', 0, '2014-01-16 00:00:00', '2014-08-18 11:27:16', 'pDjLpVMIBUtRLMa5OoOwL2zblRUqAV9768dPNTbsBFMsGIwTGVuQd8Qe2Nsf', 0),
(2, 'mramos', '$2y$08$J0s2UtRitgbgdZGY71eWsOiT9kwyZhAXGPZh2rUdpMT/wMoRzd9o2', 3521, 2096, 0, 1, '1', 0, '2014-03-13 06:04:41', '2014-08-25 17:28:37', 'QW6gKomk8zLK7hzeQyVV6ePj3gA2fe7cY8anNEhpUEoUQS0MAvv3c587Xcs9', 0),
(3, 'IBarrios', '$2y$08$KFjS1o9rVx0T0mJp9RfBwutfNp4oIL8hw4WH48mpifheY1.cVJOUq', 3522, 2097, 0, 1, '1', 0, '2014-03-13 06:05:39', '2014-08-25 17:51:00', 'qkeIPLjUyAiXNmm0Flrzr8zAd3Mi6NL18yuhE3FjubQUPpVrCeAIyGWzW74B', 0),
(4, 'ARodriguez', '$2y$08$0jL/KCmTqbPV2OtioMDYWOcUkIGUjoCsMlYoYD2Z4MAT/z9ztOBRa', 3523, 2098, 0, 2, '1', 35, '2014-03-13 06:06:30', '2014-08-25 18:51:07', 'gU3yo58NagxrUWfPTFDtI5Pbb7DvETT706qendSMLVnxdJck33DriXRc1yHF', 198),
(5, 'Tvelez', '$2y$08$NlOXIDQWEYd2Mup1hRMtNuv7bIP/Qe0fwmfcCUe7NlzZVfp8Wr8HG', 3524, 2099, 0, 2, '1', 30, '2014-03-13 06:07:15', '2014-08-25 18:51:07', 'gJLXp7yknPivL2X8flkVIoELmQvapr1VXhjgfKi6jLtvLkEyxsIXQhSa3Cnh', 197),
(6, 'SRuiz', '$2y$08$M0hDoBKOYQMFbfnHoK8mdeMlCWPDx83JTZctX2M/VpVHrB/EejqB.', 3525, 2100, 0, 2, '1', 10, '2014-03-13 06:07:49', '2014-08-25 17:46:07', '14jXiG45nCXx8i5cjZ6Pjhy67r5Is2P58iHldFj89ckHbdKup2ezsqBqyHck', 152),
(7, 'DBarnett', '$2y$08$Y4HKPz.DknQMaD71vHC4xeNGXY6yZHUi/Z2UzcgTt2XXdlp2Wx03q', 3526, 2101, 0, 2, '0', 0, '2014-03-13 06:09:29', '2014-08-18 12:36:32', NULL, 0),
(8, 'dgomez', '$2y$08$X4z7aTPE5P1YI0x7DD2Y5.innt834GZECJOQ2Mpj2sIVP2hlEEa6G', 3527, 2102, 0, 2, '1', 11, '2014-03-13 06:10:01', '2014-08-25 16:16:07', '9qGHZeDZFDEKEn43xtms8xt2ypqewh1sP1uZaPNM2MiMh4qD5vnsKuxUzs87', 133),
(11, 'JPerez', '$2y$08$B6eBnLda0JhYnrvvkCTw..SvzLpD1VClvyWHncBg1S7/Xv4TnrDkG', 3530, 2105, 6, 3, '1', 200, '2014-03-13 06:12:13', '2014-08-13 14:34:19', 'e4ivQCnJLdtTA6aU16vcOnfLfRbSx7i3P0QDvprq3NhMCWE8rP1mRCOpH1mI', 0),
(12, 'CTorres', '$2y$08$H7Yjr5tnM79V3CTe7j8mieKtDFUn/155tjdsZthUNLy1rW7ZnHBwm', 3531, 2106, 4, 3, '1', 300, '2014-03-13 06:12:52', '2014-08-15 17:26:43', '78efX3bYK4LAvndd1wZ1SMU9tsC1vtuwSGPIPzAgQ8xjBDBQ3RCnZmiFzAyv', 0);
/*!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 */;