CREATE DATABASE  IF NOT EXISTS `hoalienwebsite` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
USE `hoalienwebsite`;
-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: 127.0.0.1    Database: hoalienwebsite
-- ------------------------------------------------------
-- Server version	5.6.19

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `agents`
--

DROP TABLE IF EXISTS `agents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `fullname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `lien_client_id` int(10) unsigned NOT NULL,
  `hoa_client_id` int(10) unsigned NOT NULL,
  `enabled` tinyint(4) NOT NULL,
  `remember_token` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `agents_username_unique` (`username`),
  UNIQUE KEY `agents_lien_client_id_unique` (`lien_client_id`),
  UNIQUE KEY `agents_hoa_client_id_unique` (`hoa_client_id`),
  KEY `agents_fullname_index` (`fullname`),
  KEY `agents_password_index` (`password`),
  KEY `agents_phone_index` (`phone`),
  KEY `agents_email_index` (`email`),
  KEY `agents_fax_index` (`fax`),
  KEY `agents_enabled_index` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agents`
--

LOCK TABLES `agents` WRITE;
/*!40000 ALTER TABLE `agents` DISABLE KEYS */;
INSERT INTO `agents` VALUES (1,1,'Melissa Helfer','melissa.helfer','$2y$10$sWvfUjT64QGuVmZb3Kh1FulzXkcnpoeVPDgeZ4KOlOSedH/4WrOJK','809-589-6325 236','TAMTandA@logs.com','847-879-4850',539,37,1,'xCk1KoeESlCru2uUU00j9geC9vqdQzAB4wN57YKXMc4qwco7XHPkkcQ239L1','2014-10-15 00:09:52','2014-12-10 03:59:45');
/*!40000 ALTER TABLE `agents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `companies`
--

DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `county_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `zipcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  `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 `companies_company_name_unique` (`company_name`),
  KEY `companies_address_index` (`address`),
  KEY `companies_city_id_index` (`city_id`),
  KEY `companies_county_id_index` (`county_id`),
  KEY `companies_state_id_index` (`state_id`),
  KEY `companies_zipcode_index` (`zipcode`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `companies`
--

LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` VALUES (1,'TITLE & ABSTRACT AGENCY OF AMERICA','4630 WOODLAND COPORATE BLVD SUITE 160',300,1,13,'33120',1,'2014-10-15 00:01:06','2014-10-15 00:01:06'),(2,'SAURY TIGRE COMPANY','3155 SW 42 AVE STE 202',388,43,13,'33175',1,'2014-10-28 20:33:46','2014-10-28 20:33:46');
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `images`
--

DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `images`
--

LOCK TABLES `images` WRITE;
/*!40000 ALTER TABLE `images` DISABLE KEYS */;
INSERT INTO `images` VALUES (1,'slide-uno.png','slide-dos.png','0000-00-00 00:00:00','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu-items`
--

DROP TABLE IF EXISTS `menu-items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu-items` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `position` int(11) NOT NULL,
  `route` varchar(250) NOT NULL,
  `route_name` varchar(200) NOT NULL,
  `parent` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu-items`
--

LOCK TABLES `menu-items` WRITE;
/*!40000 ALTER TABLE `menu-items` DISABLE KEYS */;
INSERT INTO `menu-items` VALUES (1,'HOME',0,'index','home',0),(2,'TURNAROUND TIMES',1,'turnaround-times','turnaround.times',0),(3,'MUNICIPAL NUMBERS',3,'municipal-numbers','municipal.numbers',0),(4,'TAX COLLECTOR',2,'tax-collector','tax.collector',0),(8,'CONTACT US',7,'contact-us','contact.us',0),(9,'ORDER FORMS',4,'','',1),(10,'UPDATE ORDER',5,'','',1),(11,'CHECK STATUS',6,' ',' ',1);
/*!40000 ALTER TABLE `menu-items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu-sub_items`
--

DROP TABLE IF EXISTS `menu-sub_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menu-sub_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `parent` int(11) NOT NULL,
  `route` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `route_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu-sub_items`
--

LOCK TABLES `menu-sub_items` WRITE;
/*!40000 ALTER TABLE `menu-sub_items` DISABLE KEYS */;
INSERT INTO `menu-sub_items` VALUES (1,'LIEN Only',9,'orders/lien/create','order.lien.create'),(2,'HOA Only',9,'orders/hoa/create','order.hoa.create'),(3,'Both LIEN and HOA',9,'orders/lienhoaboth/create','order.lienhoaboth.create'),(4,'LIEN Only',10,'orders/lien/searchcomplete','order.lien.getSearchcomplete'),(5,'HOA Only',10,'orders/hoa/searchcomplete','order.hoa.getSearchcomplete'),(6,'Both LIEN and HOA',10,'orders/lienhoaboth/searchcomplete','order.lienhoaboth.getSearchcomplete'),(7,'LIEN Only',11,'orders/lien/index','order.lien.index'),(8,'HOA Only',11,'orders/hoa/index','order.hoa.index'),(9,'LIEN Only',12,'orders/lien/cancel','order.lien.cancel');
/*!40000 ALTER TABLE `menu-sub_items` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES ('2014_09_16_150214_create_companies_table',1),('2014_09_16_191249_create_requests_table',1),('2014_09_16_215318_create_agents_table',1),('2014_09_29_225709_images',1),('2014_10_01_191020_add_comment_to_requests_table',1),('2014_10_11_035631_create_menu-items_table',2),('2014_10_11_035631_create_menu-sub_items_table',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requests`
--

DROP TABLE IF EXISTS `requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contact_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `county_id` int(11) DEFAULT NULL,
  `state_id` int(11) DEFAULT NULL,
  `zipcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `send_email` tinyint(4) NOT NULL DEFAULT '0',
  `closed` tinyint(4) 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',
  `comment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `requests_company_name_index` (`company_name`),
  KEY `requests_contact_name_index` (`contact_name`),
  KEY `requests_phone_index` (`phone`),
  KEY `requests_email_index` (`email`),
  KEY `requests_fax_index` (`fax`),
  KEY `requests_address_index` (`address`),
  KEY `requests_city_id_index` (`city_id`),
  KEY `requests_county_id_index` (`county_id`),
  KEY `requests_state_id_index` (`state_id`),
  KEY `requests_zipcode_index` (`zipcode`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requests`
--

LOCK TABLES `requests` WRITE;
/*!40000 ALTER TABLE `requests` DISABLE KEYS */;
INSERT INTO `requests` VALUES (1,'Bravo Title Company','Saury Bravo','809-253-6532 5060','saury.bravo@gmail.com','809-253-7895','',NULL,NULL,0,'',0,0,'2014-10-14 23:05:02','2014-10-14 23:05:02','Seminar/Conference; if so witch one?\nvbxcvbxcvbxcvbxcvbxcvbxcvbxcvbxc'),(2,'SAURY TIGRE COMPANY','SAURY B 2','305-8222-9987 203','SEARCHES@ONESTEPLIEN.COM','305-822-9987','3155 SW 42 AVE STE 202',388,43,13,'33175',1,0,'2014-10-22 20:15:28','2014-10-22 20:15:34','Seminar/Conference; if so witch one?\nI HEARD IT FROM THE GRAPEVINE'),(3,'TIGRE SUPERSTAR','SAURY B2','305-822-9979 203','SEARCHES@ONESTEPLIEN.COM','305-822-9987','123155 SW 42 CIR STE 202',388,43,13,'33175',1,0,'2014-10-22 20:19:56','2014-10-22 20:19:58','Seminar/Conference; if so witch one?\nGRAPEVINE'),(4,'one-step lien search','GIULIANO','305-822-9979 203','SEARCHES@ONESTEPLIEN.COM','305-822-9987','13155 SW 42 STREET STE 202',388,43,13,'33175',1,0,'2014-11-14 20:30:21','2014-11-14 20:30:21','Seminar/Conference; if so which one?\n\nGOOGLE');
/*!40000 ALTER TABLE `requests` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2014-12-10  7:59:40