API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2018
548
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 188.85 KB | None | 0 0
raw download clone embed print report
  1.  
  2. -- MySQL dump 10.13 Distrib 5.7.23, for Linux (x86_64)
  3. --
  4. -- Host: 146.185.132.111 Database: spacework_tenant_5
  5. -- ------------------------------------------------------
  6. -- Server version 5.7.23-0ubuntu0.18.04.1
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  10. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  11. /*!40101 SET NAMES utf8 */;
  12. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  13. /*!40103 SET TIME_ZONE='+00:00' */;
  14. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  15. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  16. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  17. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  18.  
  19. --
  20. -- Table structure for table `accounting_clients`
  21. --
  22.  
  23. DROP TABLE IF EXISTS `accounting_clients`;
  24. /*!40101 SET @saved_cs_client = @@character_set_client */;
  25. /*!40101 SET character_set_client = utf8 */;
  26. CREATE TABLE `accounting_clients` (
  27. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  28. `deleted_at` timestamp NULL DEFAULT NULL,
  29. `created_at` timestamp NULL DEFAULT NULL,
  30. `updated_at` timestamp NULL DEFAULT NULL,
  31. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  32. `active` tinyint(1) NOT NULL DEFAULT '1',
  33. `tax_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  34. `payment_terms` int(10) unsigned DEFAULT NULL,
  35. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  36. `bank_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  37. `bank_branch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  38. `bank_account` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  39. `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  40. `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  41. `zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  42. `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  43. `phone_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  44. `fax_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  45. `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  46. `emails` json DEFAULT NULL,
  47. PRIMARY KEY (`id`),
  48. KEY `accounting_clients_calendar_item_id_index` (`calendar_item_id`)
  49. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  50. /*!40101 SET character_set_client = @saved_cs_client */;
  51.  
  52. --
  53. -- Dumping data for table `accounting_clients`
  54. --
  55.  
  56. LOCK TABLES `accounting_clients` WRITE;
  57. /*!40000 ALTER TABLE `accounting_clients` DISABLE KEYS */;
  58. /*!40000 ALTER TABLE `accounting_clients` ENABLE KEYS */;
  59. UNLOCK TABLES;
  60.  
  61. --
  62. -- Table structure for table `accounting_documents`
  63. --
  64.  
  65. DROP TABLE IF EXISTS `accounting_documents`;
  66. /*!40101 SET @saved_cs_client = @@character_set_client */;
  67. /*!40101 SET character_set_client = utf8 */;
  68. CREATE TABLE `accounting_documents` (
  69. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  70. `created_at` timestamp NULL DEFAULT NULL,
  71. `updated_at` timestamp NULL DEFAULT NULL,
  72. `deleted_at` timestamp NULL DEFAULT NULL,
  73. `description` text COLLATE utf8_unicode_ci,
  74. `remarks` text COLLATE utf8_unicode_ci,
  75. `footer` text COLLATE utf8_unicode_ci,
  76. `type` int(11) NOT NULL,
  77. `document_date` datetime NOT NULL,
  78. `lang` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  79. `currency` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  80. `vat_type` int(11) NOT NULL,
  81. `cancellable` tinyint(1) NOT NULL,
  82. `signed` tinyint(1) NOT NULL,
  83. `business` json NOT NULL,
  84. `client` json NOT NULL,
  85. `income` json DEFAULT NULL,
  86. `payment` json DEFAULT NULL,
  87. `number` int(11) NOT NULL,
  88. `status` int(11) NOT NULL,
  89. `amount_due_vat` double(8,2) NOT NULL,
  90. `amount_exempt_vat` double(8,2) NOT NULL,
  91. `amount_excluded_vat` double(8,2) NOT NULL,
  92. `amount_local` double(8,2) NOT NULL,
  93. `vat` double(8,2) NOT NULL,
  94. `amount` double(8,2) NOT NULL,
  95. `currency_rate` double(8,2) NOT NULL,
  96. `url` json NOT NULL,
  97. `ref` json DEFAULT NULL,
  98. `accounting_provider_business_id` int(10) unsigned NOT NULL,
  99. `provider_document_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  100. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  101. PRIMARY KEY (`id`),
  102. KEY `accounting_documents_type_index` (`type`),
  103. KEY `accounting_documents_number_index` (`number`),
  104. KEY `accounting_documents_accounting_provider_business_id_index` (`accounting_provider_business_id`),
  105. KEY `accounting_documents_provider_document_id_index` (`provider_document_id`),
  106. KEY `accounting_documents_calendar_item_id_index` (`calendar_item_id`)
  107. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  108. /*!40101 SET character_set_client = @saved_cs_client */;
  109.  
  110. --
  111. -- Dumping data for table `accounting_documents`
  112. --
  113.  
  114. LOCK TABLES `accounting_documents` WRITE;
  115. /*!40000 ALTER TABLE `accounting_documents` DISABLE KEYS */;
  116. /*!40000 ALTER TABLE `accounting_documents` ENABLE KEYS */;
  117. UNLOCK TABLES;
  118.  
  119. --
  120. -- Table structure for table `activity_log`
  121. --
  122.  
  123. DROP TABLE IF EXISTS `activity_log`;
  124. /*!40101 SET @saved_cs_client = @@character_set_client */;
  125. /*!40101 SET character_set_client = utf8 */;
  126. CREATE TABLE `activity_log` (
  127. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  128. `log_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  129. `description` text COLLATE utf8_unicode_ci NOT NULL,
  130. `subject_id` int(11) DEFAULT NULL,
  131. `subject_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  132. `causer_id` int(11) DEFAULT NULL,
  133. `causer_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  134. `properties` text COLLATE utf8_unicode_ci,
  135. `created_at` timestamp NULL DEFAULT NULL,
  136. `updated_at` timestamp NULL DEFAULT NULL,
  137. PRIMARY KEY (`id`),
  138. KEY `activity_log_log_name_index` (`log_name`)
  139. ) ENGINE=InnoDB AUTO_INCREMENT=304 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  140. /*!40101 SET character_set_client = @saved_cs_client */;
  141.  
  142. --
  143. -- Dumping data for table `activity_log`
  144. --
  145.  
  146. LOCK TABLES `activity_log` WRITE;
  147. /*!40000 ALTER TABLE `activity_log` DISABLE KEYS */;
  148. INSERT INTO `activity_log` VALUES (1,'default','created',1,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:40','2018-08-13 17:32:40'),(2,'default','created',2,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(3,'default','created',3,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(4,'default','created',4,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(5,'default','created',5,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(6,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderMenuType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(7,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderMenuType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(8,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderMenuType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(9,'default','created',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderMenuType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(10,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(11,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(12,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(13,'default','created',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(14,'default','created',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(15,'default','created',1,'App\\Models\\Tenant\\CrmHall\\Organization',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(16,'default','created',1,'App\\Models\\Tenant\\CrmHall\\Company',1,'App\\Models\\System\\SystemUser','[]','2018-08-13 17:32:41','2018-08-13 17:32:41'),(17,'default','created',1,'App\\Models\\Tenant\\Shared\\LandingPage',NULL,NULL,'[]','2018-08-13 17:32:43','2018-08-13 17:32:43'),(18,'default','created',1,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-13 17:34:37','2018-08-13 17:34:37'),(19,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CatalogCategory',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:41:46','2018-08-13 17:41:46'),(20,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CatalogCategory',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:41:57','2018-08-13 17:41:57'),(21,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:43:10','2018-08-13 17:43:10'),(22,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:43:25','2018-08-13 17:43:25'),(23,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:44:38','2018-08-13 17:44:38'),(24,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:46:31','2018-08-13 17:46:31'),(25,'default','created',4,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:46:45','2018-08-13 17:46:45'),(26,'default','created',5,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:47:04','2018-08-13 17:47:04'),(27,'default','created',6,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:47:19','2018-08-13 17:47:19'),(28,'default','created',7,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:48:43','2018-08-13 17:48:43'),(29,'default','updated',2,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:48:50','2018-08-13 17:48:50'),(30,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CatalogCategory',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:49:41','2018-08-13 17:49:41'),(31,'default','created',8,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:50:11','2018-08-13 17:50:11'),(32,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CatalogCategory',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:51:14','2018-08-13 17:51:14'),(33,'default','created',9,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:51:49','2018-08-13 17:51:49'),(34,'default','created',10,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:52:20','2018-08-13 17:52:20'),(35,'default','deleted',5,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:53:25','2018-08-13 17:53:25'),(36,'default','created',6,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:53:37','2018-08-13 17:53:37'),(37,'default','created',7,'App\\Models\\Tenant\\CrmHall\\JoinSource',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 17:53:51','2018-08-13 17:53:51'),(38,'default','created',1,'App\\Models\\Tenant\\CrmHall\\ShoppingCart',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:03:06','2018-08-13 18:03:06'),(39,'default','created',11,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:04:03','2018-08-13 18:04:03'),(40,'default','created',12,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:07:02','2018-08-13 18:07:02'),(41,'default','created',13,'App\\Models\\Tenant\\CrmHall\\CatalogItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:08:36','2018-08-13 18:08:36'),(42,'default','created',1,'App\\Models\\Tenant\\CrmHall\\Attache',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:10:27','2018-08-13 18:10:27'),(43,'default','created',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderMenuType',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:10:48','2018-08-13 18:10:48'),(44,'default','created',6,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderMenuType',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:11:04','2018-08-13 18:11:04'),(45,'default','deleted',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:11:34','2018-08-13 18:11:34'),(46,'default','deleted',2,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:11:46','2018-08-13 18:11:46'),(47,'default','created',6,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrderSubmissionType',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:12:20','2018-08-13 18:12:20'),(48,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\Company',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:17:37','2018-08-13 18:17:37'),(49,'default','created',2,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-13 18:18:12','2018-08-13 18:18:12'),(50,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:32:10','2018-08-13 18:32:10'),(51,'default','created',1,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:32:10','2018-08-13 18:32:10'),(52,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:32:10','2018-08-13 18:32:10'),(53,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:32:10','2018-08-13 18:32:10'),(54,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\Organization',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:32:44','2018-08-13 18:32:44'),(55,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:35:13','2018-08-13 18:35:13'),(56,'default','created',1,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:36:59','2018-08-13 18:36:59'),(57,'default','created',1,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:36:59','2018-08-13 18:36:59'),(58,'default','created',1,'App\\Models\\Tenant\\Shared\\FeedActivityComment',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:37:13','2018-08-13 18:37:13'),(59,'default','created',1,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:37:44','2018-08-13 18:37:44'),(60,'default','created',2,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:37:46','2018-08-13 18:37:46'),(61,'default','created',1,'App\\Models\\Tenant\\Shared\\SmsMessage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:39:38','2018-08-13 18:39:38'),(62,'default','created',3,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:39:38','2018-08-13 18:39:38'),(63,'default','created',1,'App\\Models\\Tenant\\CrmHall\\File',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:40:06','2018-08-13 18:40:06'),(64,'default','created',4,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:40:06','2018-08-13 18:40:06'),(65,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:43:39','2018-08-13 18:43:39'),(66,'default','created',2,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:43:39','2018-08-13 18:43:39'),(67,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:43:39','2018-08-13 18:43:39'),(68,'default','created',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:43:39','2018-08-13 18:43:39'),(69,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:48:54','2018-08-13 18:48:54'),(70,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-13 18:48:54','2018-08-13 18:48:54'),(71,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:49:05','2018-08-13 18:49:05'),(72,'default','created',2,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:50:49','2018-08-13 18:50:49'),(73,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:51:04','2018-08-13 18:51:04'),(74,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:51:11','2018-08-13 18:51:11'),(75,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:53:49','2018-08-13 18:53:49'),(76,'default','updated',2,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:53:49','2018-08-13 18:53:49'),(77,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:53:49','2018-08-13 18:53:49'),(78,'default','updated',2,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:53:49','2018-08-13 18:53:49'),(79,'default','updated',1,'App\\Models\\Tenant\\CrmHall\\Company',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 18:54:33','2018-08-13 18:54:33'),(80,'default','created',2,'App\\Models\\Tenant\\Shared\\SmsMessage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:10:43','2018-08-13 19:10:43'),(81,'default','created',5,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:10:43','2018-08-13 19:10:43'),(82,'default','created',4,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:41:25','2018-08-13 19:41:25'),(83,'default','created',3,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:41:25','2018-08-13 19:41:25'),(84,'default','created',4,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:41:25','2018-08-13 19:41:25'),(85,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:41:25','2018-08-13 19:41:25'),(86,'default','created',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:41:26','2018-08-13 19:41:26'),(87,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:47:34','2018-08-13 19:47:34'),(88,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-13 19:47:34','2018-08-13 19:47:34'),(89,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:47:34','2018-08-13 19:47:34'),(90,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:47:34','2018-08-13 19:47:34'),(91,'default','updated',4,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:47:34','2018-08-13 19:47:34'),(92,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:47:50','2018-08-13 19:47:50'),(93,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:48:45','2018-08-13 19:48:45'),(94,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-13 19:48:46','2018-08-13 19:48:46'),(95,'default','updated',3,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 19:51:18','2018-08-13 19:51:18'),(96,'default','created',5,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:01:40','2018-08-13 20:01:40'),(97,'default','created',5,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:01:40','2018-08-13 20:01:40'),(98,'default','created',6,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:01:40','2018-08-13 20:01:40'),(99,'default','created',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:01:40','2018-08-13 20:01:40'),(100,'default','created',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:01:41','2018-08-13 20:01:41'),(101,'default','updated',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:06:04','2018-08-13 20:06:04'),(102,'default','updated',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:06:04','2018-08-13 20:06:04'),(103,'default','updated',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:06:04','2018-08-13 20:06:04'),(104,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:06:04','2018-08-13 20:06:04'),(105,'default','updated',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-13 20:06:06','2018-08-13 20:06:06'),(106,'default','updated',4,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:07:04','2018-08-13 20:07:04'),(107,'default','created',6,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:41:14','2018-08-13 20:41:14'),(108,'default','created',7,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:41:14','2018-08-13 20:41:14'),(109,'default','created',8,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:41:14','2018-08-13 20:41:14'),(110,'default','created',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:41:14','2018-08-13 20:41:14'),(111,'default','created',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:41:14','2018-08-13 20:41:14'),(112,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:43:48','2018-08-13 20:43:48'),(113,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:43:48','2018-08-13 20:43:48'),(114,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:43:48','2018-08-13 20:43:48'),(115,'default','updated',6,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:43:48','2018-08-13 20:43:48'),(116,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-13 20:43:50','2018-08-13 20:43:50'),(117,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:44:29','2018-08-13 20:44:29'),(118,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-13 20:44:29','2018-08-13 20:44:29'),(119,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:53:01','2018-08-13 20:53:01'),(120,'default','updated',5,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 20:55:51','2018-08-13 20:55:51'),(121,'default','created',2,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 21:12:17','2018-08-13 21:12:17'),(122,'default','created',6,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 21:12:18','2018-08-13 21:12:18'),(123,'default','created',7,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 21:13:58','2018-08-13 21:13:58'),(124,'default','created',9,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 21:13:58','2018-08-13 21:13:58'),(125,'default','created',8,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 21:13:58','2018-08-13 21:13:58'),(126,'default','created',6,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-13 21:13:58','2018-08-13 21:13:58'),(156,'default','created',3,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-14 18:35:21','2018-08-14 18:35:21'),(157,'default','created',24,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:36:00','2018-08-14 18:36:00'),(158,'default','created',24,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:36:00','2018-08-14 18:36:00'),(159,'default','created',25,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:36:00','2018-08-14 18:36:00'),(160,'default','created',7,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:36:00','2018-08-14 18:36:00'),(161,'default','deleted',24,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:36:24','2018-08-14 18:36:24'),(162,'default','created',26,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:37:10','2018-08-14 18:37:10'),(163,'default','created',25,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:37:10','2018-08-14 18:37:10'),(164,'default','created',27,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:37:10','2018-08-14 18:37:10'),(165,'default','created',8,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:37:10','2018-08-14 18:37:10'),(166,'default','deleted',26,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:37:22','2018-08-14 18:37:22'),(175,'default','created',32,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:26','2018-08-14 18:59:26'),(176,'default','created',30,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:26','2018-08-14 18:59:26'),(177,'default','created',31,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:26','2018-08-14 18:59:26'),(178,'default','created',33,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:26','2018-08-14 18:59:26'),(179,'default','created',9,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:26','2018-08-14 18:59:26'),(180,'default','created',34,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:45','2018-08-14 18:59:45'),(181,'default','created',32,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:45','2018-08-14 18:59:45'),(182,'default','created',35,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:45','2018-08-14 18:59:45'),(183,'default','created',10,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 18:59:45','2018-08-14 18:59:45'),(184,'default','deleted',32,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:00:39','2018-08-14 19:00:39'),(185,'default','created',36,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:03:02','2018-08-14 19:03:02'),(186,'default','created',33,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:03:02','2018-08-14 19:03:02'),(187,'default','created',37,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:03:02','2018-08-14 19:03:02'),(188,'default','created',11,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:03:02','2018-08-14 19:03:02'),(189,'default','created',2,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:04:17','2018-08-14 19:04:17'),(190,'default','created',7,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:04:17','2018-08-14 19:04:17'),(191,'default','created',3,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:05:10','2018-08-14 19:05:10'),(192,'default','created',8,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:05:10','2018-08-14 19:05:10'),(193,'default','created',38,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:00','2018-08-14 19:08:00'),(194,'default','created',34,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:00','2018-08-14 19:08:00'),(195,'default','created',35,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:00','2018-08-14 19:08:00'),(196,'default','created',39,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:00','2018-08-14 19:08:00'),(197,'default','created',12,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:00','2018-08-14 19:08:00'),(198,'default','created',3,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:33','2018-08-14 19:08:33'),(199,'default','created',9,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:08:33','2018-08-14 19:08:33'),(200,'default','created',4,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:09:53','2018-08-14 19:09:53'),(201,'default','created',10,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 19:09:53','2018-08-14 19:09:53'),(202,'default','created',4,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 20:45:56','2018-08-14 20:45:56'),(203,'default','created',11,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 20:45:56','2018-08-14 20:45:56'),(204,'default','created',5,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 20:46:49','2018-08-14 20:46:49'),(205,'default','created',12,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 20:46:49','2018-08-14 20:46:49'),(206,'default','deleted',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 20:47:15','2018-08-14 20:47:15'),(207,'default','created',4,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-14 21:19:49','2018-08-14 21:19:49'),(208,'default','created',5,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-14 21:19:49','2018-08-14 21:19:49'),(209,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 21:22:56','2018-08-14 21:22:56'),(210,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 21:24:35','2018-08-14 21:24:35'),(211,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-14 21:25:25','2018-08-14 21:25:25'),(212,'default','created',40,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 17:07:11','2018-08-15 17:07:11'),(213,'default','created',36,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 17:07:11','2018-08-15 17:07:11'),(214,'default','created',41,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 17:07:11','2018-08-15 17:07:11'),(215,'default','created',13,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 17:07:11','2018-08-15 17:07:11'),(216,'default','created',6,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-15 19:23:27','2018-08-15 19:23:27'),(217,'default','created',42,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 19:26:03','2018-08-15 19:26:03'),(218,'default','created',37,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 19:26:03','2018-08-15 19:26:03'),(219,'default','created',43,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 19:26:03','2018-08-15 19:26:03'),(220,'default','created',14,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 19:26:03','2018-08-15 19:26:03'),(221,'default','created',6,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 19:27:32','2018-08-15 19:27:32'),(222,'default','created',13,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-15 19:27:32','2018-08-15 19:27:32'),(223,'default','created',5,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-16 16:58:53','2018-08-16 16:58:53'),(224,'default','created',14,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-16 16:58:53','2018-08-16 16:58:53'),(225,'default','created',7,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-16 16:59:36','2018-08-16 16:59:36'),(226,'default','created',15,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-16 16:59:36','2018-08-16 16:59:36'),(227,'default','created',7,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-17 11:15:13','2018-08-17 11:15:13'),(228,'default','created',8,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-17 11:15:13','2018-08-17 11:15:13'),(229,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 11:16:28','2018-08-17 11:16:28'),(230,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 11:33:05','2018-08-17 11:33:05'),(231,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 11:44:36','2018-08-17 11:44:36'),(232,'default','updated',1,'App\\Models\\Tenant\\Shared\\LandingPage',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 11:45:32','2018-08-17 11:45:32'),(233,'default','created',44,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 14:07:02','2018-08-17 14:07:02'),(234,'default','created',38,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 14:07:02','2018-08-17 14:07:02'),(235,'default','created',45,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 14:07:02','2018-08-17 14:07:02'),(236,'default','created',15,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 14:07:02','2018-08-17 14:07:02'),(237,'default','created',6,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 14:08:34','2018-08-17 14:08:34'),(238,'default','created',16,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-17 14:08:34','2018-08-17 14:08:34'),(239,'default','created',9,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-19 13:37:31','2018-08-19 13:37:31'),(240,'default','created',10,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-19 16:18:17','2018-08-19 16:18:17'),(242,'default','created',47,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 16:25:26','2018-08-19 16:25:26'),(243,'default','created',39,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 16:25:27','2018-08-19 16:25:27'),(244,'default','created',48,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 16:25:27','2018-08-19 16:25:27'),(245,'default','created',16,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 16:25:27','2018-08-19 16:25:27'),(246,'default','created',7,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 16:56:34','2018-08-19 16:56:34'),(247,'default','created',17,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 16:56:34','2018-08-19 16:56:34'),(248,'default','created',49,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 17:30:49','2018-08-19 17:30:49'),(249,'default','created',40,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 17:30:49','2018-08-19 17:30:49'),(250,'default','created',50,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 17:30:49','2018-08-19 17:30:49'),(251,'default','created',17,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 17:30:49','2018-08-19 17:30:49'),(252,'default','created',8,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 17:31:54','2018-08-19 17:31:54'),(253,'default','created',18,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 17:31:55','2018-08-19 17:31:55'),(254,'default','created',8,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 18:09:46','2018-08-19 18:09:46'),(255,'default','created',19,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 18:09:46','2018-08-19 18:09:46'),(256,'default','created',9,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 18:10:39','2018-08-19 18:10:39'),(257,'default','created',20,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 18:10:39','2018-08-19 18:10:39'),(258,'default','created',9,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 20:47:09','2018-08-19 20:47:09'),(259,'default','created',21,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 20:47:10','2018-08-19 20:47:10'),(260,'default','created',10,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 20:48:01','2018-08-19 20:48:01'),(261,'default','created',22,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 20:48:01','2018-08-19 20:48:01'),(262,'default','created',51,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 21:55:53','2018-08-19 21:55:53'),(263,'default','created',52,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 21:58:31','2018-08-19 21:58:31'),(264,'default','created',10,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 22:19:05','2018-08-19 22:19:05'),(265,'default','created',23,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-19 22:19:06','2018-08-19 22:19:06'),(266,'default','created',53,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:28:39','2018-08-20 19:28:39'),(267,'default','created',41,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:28:39','2018-08-20 19:28:39'),(268,'default','created',18,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:28:39','2018-08-20 19:28:39'),(269,'default','created',6,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:28:39','2018-08-20 19:28:39'),(270,'default','updated',18,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:33:06','2018-08-20 19:33:06'),(271,'default','updated',18,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',NULL,NULL,'[]','2018-08-20 19:33:06','2018-08-20 19:33:06'),(272,'default','updated',6,'App\\Models\\Tenant\\CrmHall\\CalendarItemDateOption',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:33:06','2018-08-20 19:33:06'),(273,'default','updated',18,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:33:06','2018-08-20 19:33:06'),(274,'default','updated',53,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:33:06','2018-08-20 19:33:06'),(275,'default','updated',18,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-20 19:50:06','2018-08-20 19:50:06'),(276,'default','created',54,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:17:40','2018-08-21 16:17:40'),(277,'default','created',42,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:17:40','2018-08-21 16:17:40'),(278,'default','created',55,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:17:41','2018-08-21 16:17:41'),(279,'default','created',19,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:17:41','2018-08-21 16:17:41'),(280,'default','created',11,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-21 16:21:27','2018-08-21 16:21:27'),(281,'default','created',56,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:44:22','2018-08-21 16:44:22'),(282,'default','created',43,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:44:22','2018-08-21 16:44:22'),(283,'default','created',57,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:44:22','2018-08-21 16:44:22'),(284,'default','created',20,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 16:44:22','2018-08-21 16:44:22'),(285,'default','created',11,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 19:49:26','2018-08-21 19:49:26'),(286,'default','created',24,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 19:49:26','2018-08-21 19:49:26'),(287,'default','created',58,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 19:53:26','2018-08-21 19:53:26'),(288,'default','created',12,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 20:41:15','2018-08-21 20:41:15'),(289,'default','created',25,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 20:41:15','2018-08-21 20:41:15'),(290,'default','created',11,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 20:42:07','2018-08-21 20:42:07'),(291,'default','created',26,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 20:42:07','2018-08-21 20:42:07'),(292,'default','created',59,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 20:44:13','2018-08-21 20:44:13'),(293,'default','created',60,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:40:34','2018-08-21 21:40:34'),(294,'default','created',44,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:40:34','2018-08-21 21:40:34'),(295,'default','created',45,'App\\Models\\Tenant\\CrmHall\\Contact',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:40:34','2018-08-21 21:40:34'),(296,'default','created',61,'App\\Models\\Tenant\\CrmHall\\CalendarItem',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:40:35','2018-08-21 21:40:35'),(297,'default','created',21,'App\\Models\\Tenant\\CrmHall\\CalendarItemOrder',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:40:35','2018-08-21 21:40:35'),(298,'default','created',13,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:41:10','2018-08-21 21:41:10'),(299,'default','created',27,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:41:10','2018-08-21 21:41:10'),(300,'default','created',12,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:42:02','2018-08-21 21:42:02'),(301,'default','created',28,'App\\Models\\Tenant\\Shared\\FeedActivity',1,'App\\Models\\Tenant\\Shared\\User','[]','2018-08-21 21:42:02','2018-08-21 21:42:02'),(302,'default','created',12,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-22 15:45:19','2018-08-22 15:45:19'),(303,'default','created',13,'App\\Models\\Tenant\\Shared\\UserSession',NULL,NULL,'[]','2018-08-22 15:45:19','2018-08-22 15:45:19');
  149. /*!40000 ALTER TABLE `activity_log` ENABLE KEYS */;
  150. UNLOCK TABLES;
  151.  
  152. --
  153. -- Table structure for table `attaches`
  154. --
  155.  
  156. DROP TABLE IF EXISTS `attaches`;
  157. /*!40101 SET @saved_cs_client = @@character_set_client */;
  158. /*!40101 SET character_set_client = utf8 */;
  159. CREATE TABLE `attaches` (
  160. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  161. `created_at` timestamp NULL DEFAULT NULL,
  162. `updated_at` timestamp NULL DEFAULT NULL,
  163. `deleted_at` timestamp NULL DEFAULT NULL,
  164. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  165. `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  166. `content` text COLLATE utf8_unicode_ci NOT NULL,
  167. `dynamic_vars` json DEFAULT NULL,
  168. PRIMARY KEY (`id`)
  169. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  170. /*!40101 SET character_set_client = @saved_cs_client */;
  171.  
  172. --
  173. -- Dumping data for table `attaches`
  174. --
  175.  
  176. LOCK TABLES `attaches` WRITE;
  177. /*!40000 ALTER TABLE `attaches` DISABLE KEYS */;
  178. INSERT INTO `attaches` VALUES (1,'2018-08-13 18:10:27','2018-08-13 18:10:27',NULL,'ת� אים והבהרות להסכם','ת� אים והבהרות להסכם','<p class=\"MsoNormal\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;\nmso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">ת� אים\nוהבהרות להסכם <o:p></o:p></span></p>\n\n<p class=\"MsoNormal\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;\nmso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">א� ו\nמאשרים בזאת את הזמ� ת האירוע כמפורט לעיל <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpFirst\" dir=\"RTL\" style=\"text-indent:-18.0pt;\nmso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:Arial;mso-fareast-theme-font:minor-bidi;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">א.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n</span></span><!--[endif]--><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:\nminor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;\nmso-bidi-theme-font:minor-bidi\">במעמד חתימת החוזה ישלם המזמין את מלוא תמורת\nהאירוע כמפורט </span><span dir=\"LTR\"><o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span dir=\"RTL\"></span><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;\nmso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:\nminor-latin;mso-bidi-theme-font:minor-bidi\"><span dir=\"RTL\"></span><span dir=\"RTL\"></span>10%\nמערך ההזמ� ה ישולם בהמחאה במזומן במועד חתימת ההסכם <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">15% מערך ההזמ� ה אשר מועד פירעו� ה לא יאוחר מ45 יום לפ� י האירוע <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">יתרת התשלום בהמחאה אשר מועד פירעו� ה לא יאוחר מ3 ימים לאחר האירוע <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">המזמין ימסור גם המחאת ביטחון אשר תשמש להבטחת מ� ות הרזרבה\nוהתוספות&nbsp; <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">החברה רשאית לעשות שימוש בהמחאת הביטחון במידה והמזמין לא יפרע את\nמלוא התשלום לא יאוחר מ3 ימים מקיום האירוע <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\" style=\"text-indent:-18.0pt;\nmso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:Arial;mso-fareast-theme-font:minor-bidi;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">ב.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n</span></span><!--[endif]--><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:\nminor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;\nmso-bidi-theme-font:minor-bidi\">אקו\"ם :</span><span dir=\"LTR\"><o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">הזמ� ת תזמורת ו/או שירותי מוסיקה לאירוע ,באחריות המזמין .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">באחריות המזמין לוודא כי ל� ותן השירות יש� ן זכויות חוקיות להשמעת\nמוסיקה ו/או שידורה <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">על המזמין לשלם ישירות לאקו\"ם את האגרה בגין השמעת מוסיקה באירוע\n.<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">במידה ולא ימציא לחברה אישור בדבר תשלום אגרת אקו\"ם לא תורשה\nהשמעת מוסיקה במהלך האירוע .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\" style=\"text-indent:-18.0pt;\nmso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:Arial;mso-fareast-theme-font:minor-bidi;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">ג.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n</span></span><!--[endif]--><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:\nminor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;\nmso-bidi-theme-font:minor-bidi\">ביטול הזמ� ה מכל סיבה שהיא , למעט דחייה בשל כח\nעליון ודחייה בשל מצב חירום בהתאם להוראות פיקוד העורף יחוייב&nbsp; המזמין בפיצוי כספי מוסכם מראש כמפורט להלן : </span><span dir=\"LTR\"><o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">ביטול הזמ� ה עד 60 יום ממועד קיום האירוע יחייב את המזמין בפיצוי כספי\nשל 30% מערך ההזמ� ה .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">ביטול הזמ� ה 60 יום או פחות ממועד קיום האירוע יחייב את המזמין בפיצוי\nכספי של 60% מערך ההזמ� ה .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\" style=\"text-indent:-18.0pt;\nmso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:Arial;mso-fareast-theme-font:minor-bidi;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">ד.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n</span></span><!--[endif]--><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:\nminor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;\nmso-bidi-theme-font:minor-bidi\">הגדלת מספר המ� ות תיעשה ע\"י המזמין לא יאוחר\nמ48 שעות ממועד קיום האירוע .</span><span dir=\"LTR\"><o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">מספר המ� ות המי� ימאלי לתשלום לא יפחת בשום מקרה ממספר המ� ות הבסיסי\nהרשום בהסכם . <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">למען הסר כל ספק כמות המ� ות הבסיסית אי� ה כוללת את מ� ות הרזרבה .ספירת\nמ� ות הרזרבה תיעשה לפי כמות האורחים&nbsp;\nשהוספו בפועל. <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\" style=\"text-indent:-18.0pt;\nmso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:Arial;mso-fareast-theme-font:minor-bidi;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">ה.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n</span></span><!--[endif]--><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:\nminor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;\nmso-bidi-theme-font:minor-bidi\">ת� אים כללים : </span><span dir=\"LTR\"><o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">חל איסור מולט על הכ� סת דברי אוכל ושתייה ללא אישור מראש <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">חל איסור מוחלט על שימוש בקו� פטי לרבות קו� פטי יד� י הן באולם והן בגן\nהפתוח <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">חל איסור מוחלט על הפעלת זיקוקים או כל אמצי פירוטכ� יקה אחר , המזמין\nיהיה חייב לעשות שימוש במערכות ההגברה ,מסכים ותאורה המותק� ות באולם ,ולא תי� תן להכ� יס\nמערכות הגברה ותאורה חיצו� ית למעט להקה ו/או תזמורת ו/או זמר ו/או מופעי בידור .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">חל איסור מוחלט על הכ� סת שירותי בר, במות &nbsp;ומעצבים חיצו� ים ללא קבלת אישור בראש ובכתב\nמהחברה .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">במידה והאולם יעמוד לראשות המזמין מעבר לשעות המפורטות בהסכם ,מתחייב\nהמזמין לשלם לחברה סך של 1500 ₪ בגין כל שעה � וספת או חלק ממ� ה <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">ה� הלת החברה אי� ה אחראית ל� זקים שאי� ם תלויים בה כגון : שריפה ,הפסקת\nחשמל,הצפה ,ג� יבת חפצים וכיו\"ב או כל � זק לרכב החו� ה בח� יו� ים <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">בעל האירוע יהיה אחראי לכל שייגרם לאולם על ידי אורחיו.<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">אין החברה אחראית לכל � זק שייגרם ע\"י אחד הספקים שהוזמ� ו\nע\"י המזמין .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">על המזמין לוודא בטרם כי הספק מחזיק בכל הרישיו� ות והביטוחים <o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">לחברה שמורה שיקול הדעת הבלעדי לסרב כ� יסתו של ספק זה או אחר מכל סיבה\nשהיא ובכלל זה בשל היעדר רישיו� ות ו/או כיסוי ביטוחי הולם .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">על המזמין לוודא כי הספקים יגיעו בלבוש הולם וי� הגו בהתאם לדרישות\nהחברה .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">קירוי הגן בין החודשים אוקטובר לאפריל , � תון לשיקול דעתה הבלעדי\nוהמוחלט של החברה .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\" style=\"text-indent:-18.0pt;\nmso-list:l0 level1 lfo1\"><!--[if !supportLists]--><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-fareast-font-family:Arial;mso-fareast-theme-font:minor-bidi;mso-hansi-font-family:\nCalibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-bidi\">ו.<span style=\"font-variant-numeric: normal; font-variant-east-asian: normal; font-stretch: normal; font-size: 7pt; line-height: normal; font-family: &quot;Times New Roman&quot;;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n</span></span><!--[endif]--><span dir=\"RTL\"></span><span lang=\"HE\" style=\"font-family:&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:\nminor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;\nmso-bidi-theme-font:minor-bidi\">סידורי הושבה באולם יעשו בהתאם לסקיצה שיישלח\nמ� הל האירועים של החברה למזמין .</span><span dir=\"LTR\"><o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">למען הסר כל ספק הושבה של האורחים בשולח� ות היא לפי 10-12 אורחים\nבשולחן בלבד .<o:p></o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpMiddle\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\"><o:p>&nbsp;</o:p></span></p>\n\n<p class=\"MsoListParagraphCxSpLast\" dir=\"RTL\"><span lang=\"HE\" style=\"font-family:\n&quot;Arial&quot;,sans-serif;mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;\nmso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:\nminor-bidi\">א� ו מאשרים בזאת את הזמ� ת האירוע בהתאם לפרטים והת� אים המפורטים בהסכם\nזה&nbsp;<o:p></o:p></span></p>','[]');
  179. /*!40000 ALTER TABLE `attaches` ENABLE KEYS */;
  180. UNLOCK TABLES;
  181.  
  182. --
  183. -- Table structure for table `audits`
  184. --
  185.  
  186. DROP TABLE IF EXISTS `audits`;
  187. /*!40101 SET @saved_cs_client = @@character_set_client */;
  188. /*!40101 SET character_set_client = utf8 */;
  189. CREATE TABLE `audits` (
  190. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  191. `user_id` int(10) unsigned DEFAULT NULL,
  192. `event` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  193. `auditable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  194. `auditable_id` bigint(20) unsigned NOT NULL,
  195. `old_values` text COLLATE utf8_unicode_ci,
  196. `new_values` text COLLATE utf8_unicode_ci,
  197. `url` text COLLATE utf8_unicode_ci,
  198. `ip_address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  199. `user_agent` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  200. `tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  201. `created_at` timestamp NULL DEFAULT NULL,
  202. `updated_at` timestamp NULL DEFAULT NULL,
  203. PRIMARY KEY (`id`),
  204. KEY `audits_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`)
  205. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  206. /*!40101 SET character_set_client = @saved_cs_client */;
  207.  
  208. --
  209. -- Dumping data for table `audits`
  210. --
  211.  
  212. LOCK TABLES `audits` WRITE;
  213. /*!40000 ALTER TABLE `audits` DISABLE KEYS */;
  214. /*!40000 ALTER TABLE `audits` ENABLE KEYS */;
  215. UNLOCK TABLES;
  216.  
  217. --
  218. -- Table structure for table `calendar_item_activities`
  219. --
  220.  
  221. DROP TABLE IF EXISTS `calendar_item_activities`;
  222. /*!40101 SET @saved_cs_client = @@character_set_client */;
  223. /*!40101 SET character_set_client = utf8 */;
  224. CREATE TABLE `calendar_item_activities` (
  225. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  226. `deleted_at` timestamp NULL DEFAULT NULL,
  227. `created_at` timestamp NULL DEFAULT NULL,
  228. `updated_at` timestamp NULL DEFAULT NULL,
  229. `type` enum('phone_call','conversation','meeting','email','note','task','file','sms') COLLATE utf8_unicode_ci NOT NULL,
  230. `date` datetime NOT NULL,
  231. `content` text COLLATE utf8_unicode_ci NOT NULL,
  232. `data` json DEFAULT NULL,
  233. `calendar_item_id` int(10) unsigned NOT NULL,
  234. PRIMARY KEY (`id`),
  235. KEY `calendar_item_activities_calendar_item_id_index` (`calendar_item_id`)
  236. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  237. /*!40101 SET character_set_client = @saved_cs_client */;
  238.  
  239. --
  240. -- Dumping data for table `calendar_item_activities`
  241. --
  242.  
  243. LOCK TABLES `calendar_item_activities` WRITE;
  244. /*!40000 ALTER TABLE `calendar_item_activities` DISABLE KEYS */;
  245. /*!40000 ALTER TABLE `calendar_item_activities` ENABLE KEYS */;
  246. UNLOCK TABLES;
  247.  
  248. --
  249. -- Table structure for table `calendar_item_connections`
  250. --
  251.  
  252. DROP TABLE IF EXISTS `calendar_item_connections`;
  253. /*!40101 SET @saved_cs_client = @@character_set_client */;
  254. /*!40101 SET character_set_client = utf8 */;
  255. CREATE TABLE `calendar_item_connections` (
  256. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  257. `deleted_at` timestamp NULL DEFAULT NULL,
  258. `created_at` timestamp NULL DEFAULT NULL,
  259. `updated_at` timestamp NULL DEFAULT NULL,
  260. `calendar_item_id` int(10) unsigned NOT NULL,
  261. `calendar_item2_id` int(10) unsigned NOT NULL,
  262. PRIMARY KEY (`id`),
  263. KEY `calendar_item_connections_calendar_item_id_index` (`calendar_item_id`),
  264. KEY `calendar_item_connections_calendar_item2_id_index` (`calendar_item2_id`)
  265. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  266. /*!40101 SET character_set_client = @saved_cs_client */;
  267.  
  268. --
  269. -- Dumping data for table `calendar_item_connections`
  270. --
  271.  
  272. LOCK TABLES `calendar_item_connections` WRITE;
  273. /*!40000 ALTER TABLE `calendar_item_connections` DISABLE KEYS */;
  274. INSERT INTO `calendar_item_connections` VALUES (1,NULL,NULL,NULL,2,1),(2,NULL,NULL,NULL,8,7),(3,NULL,NULL,NULL,25,24),(4,NULL,NULL,NULL,27,26),(5,NULL,NULL,NULL,33,32),(6,NULL,NULL,NULL,35,34),(7,NULL,NULL,NULL,37,36),(8,NULL,NULL,NULL,39,38),(9,NULL,NULL,NULL,41,40),(10,NULL,NULL,NULL,43,42),(11,NULL,NULL,NULL,45,44),(12,NULL,NULL,NULL,48,47),(13,NULL,NULL,NULL,50,49),(14,NULL,NULL,NULL,51,50),(15,NULL,NULL,NULL,52,41),(16,NULL,NULL,NULL,55,54),(17,NULL,NULL,NULL,57,56),(18,NULL,NULL,NULL,58,48),(19,NULL,NULL,NULL,59,37),(20,NULL,NULL,NULL,61,60);
  275. /*!40000 ALTER TABLE `calendar_item_connections` ENABLE KEYS */;
  276. UNLOCK TABLES;
  277.  
  278. --
  279. -- Table structure for table `calendar_item_date_options`
  280. --
  281.  
  282. DROP TABLE IF EXISTS `calendar_item_date_options`;
  283. /*!40101 SET @saved_cs_client = @@character_set_client */;
  284. /*!40101 SET character_set_client = utf8 */;
  285. CREATE TABLE `calendar_item_date_options` (
  286. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  287. `deleted_at` timestamp NULL DEFAULT NULL,
  288. `created_at` timestamp NULL DEFAULT NULL,
  289. `updated_at` timestamp NULL DEFAULT NULL,
  290. `date` datetime NOT NULL,
  291. `comments` text COLLATE utf8_unicode_ci,
  292. `expired_at` datetime NOT NULL,
  293. `calendar_item_id` int(10) unsigned NOT NULL,
  294. `selected` tinyint(1) NOT NULL,
  295. PRIMARY KEY (`id`),
  296. KEY `calendar_item_date_options_calendar_item_id_index` (`calendar_item_id`)
  297. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  298. /*!40101 SET character_set_client = @saved_cs_client */;
  299.  
  300. --
  301. -- Dumping data for table `calendar_item_date_options`
  302. --
  303.  
  304. LOCK TABLES `calendar_item_date_options` WRITE;
  305. /*!40000 ALTER TABLE `calendar_item_date_options` DISABLE KEYS */;
  306. INSERT INTO `calendar_item_date_options` VALUES (1,NULL,'2018-08-13 18:43:39','2018-08-13 18:43:39','2018-08-09 03:00:00',NULL,'2018-08-20 18:43:39',3,0),(2,NULL,'2018-08-13 18:50:49','2018-08-13 18:53:49','2018-09-30 18:44:20','גכדגכגדכגדכד','2018-08-15 18:44:20',2,1),(3,NULL,'2018-08-13 19:41:26','2018-08-13 19:47:34','2018-09-05 03:00:00',NULL,'2018-08-20 19:41:25',4,1),(4,NULL,'2018-08-13 20:01:41','2018-08-13 20:06:04','2018-10-16 03:00:00',NULL,'2018-08-20 20:01:40',5,1),(5,NULL,'2018-08-13 20:41:14','2018-08-13 20:43:48','2018-11-01 02:00:00',NULL,'2018-08-20 20:41:14',6,1),(6,NULL,'2018-08-20 19:28:39','2018-08-20 19:33:06','2018-09-04 03:00:00',NULL,'2018-08-27 19:28:39',53,1);
  307. /*!40000 ALTER TABLE `calendar_item_date_options` ENABLE KEYS */;
  308. UNLOCK TABLES;
  309.  
  310. --
  311. -- Table structure for table `calendar_item_order_menu_types`
  312. --
  313.  
  314. DROP TABLE IF EXISTS `calendar_item_order_menu_types`;
  315. /*!40101 SET @saved_cs_client = @@character_set_client */;
  316. /*!40101 SET character_set_client = utf8 */;
  317. CREATE TABLE `calendar_item_order_menu_types` (
  318. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  319. `created_at` timestamp NULL DEFAULT NULL,
  320. `updated_at` timestamp NULL DEFAULT NULL,
  321. `deleted_at` timestamp NULL DEFAULT NULL,
  322. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  323. PRIMARY KEY (`id`)
  324. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  325. /*!40101 SET character_set_client = @saved_cs_client */;
  326.  
  327. --
  328. -- Dumping data for table `calendar_item_order_menu_types`
  329. --
  330.  
  331. LOCK TABLES `calendar_item_order_menu_types` WRITE;
  332. /*!40000 ALTER TABLE `calendar_item_order_menu_types` DISABLE KEYS */;
  333. INSERT INTO `calendar_item_order_menu_types` VALUES (1,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'צהריים'),(2,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'ערב'),(3,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'עסקי'),(4,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'גלאט כשר'),(5,'2018-08-13 18:10:48','2018-08-13 18:10:48',NULL,'קוקטייל'),(6,'2018-08-13 18:11:04','2018-08-13 18:11:04',NULL,'יום עיון');
  334. /*!40000 ALTER TABLE `calendar_item_order_menu_types` ENABLE KEYS */;
  335. UNLOCK TABLES;
  336.  
  337. --
  338. -- Table structure for table `calendar_item_order_submission_types`
  339. --
  340.  
  341. DROP TABLE IF EXISTS `calendar_item_order_submission_types`;
  342. /*!40101 SET @saved_cs_client = @@character_set_client */;
  343. /*!40101 SET character_set_client = utf8 */;
  344. CREATE TABLE `calendar_item_order_submission_types` (
  345. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  346. `created_at` timestamp NULL DEFAULT NULL,
  347. `updated_at` timestamp NULL DEFAULT NULL,
  348. `deleted_at` timestamp NULL DEFAULT NULL,
  349. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  350. PRIMARY KEY (`id`)
  351. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  352. /*!40101 SET character_set_client = @saved_cs_client */;
  353.  
  354. --
  355. -- Dumping data for table `calendar_item_order_submission_types`
  356. --
  357.  
  358. LOCK TABLES `calendar_item_order_submission_types` WRITE;
  359. /*!40000 ALTER TABLE `calendar_item_order_submission_types` DISABLE KEYS */;
  360. INSERT INTO `calendar_item_order_submission_types` VALUES (1,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'אמריקן סרויס'),(2,'2018-08-13 17:32:41','2018-08-13 18:11:46','2018-08-13 18:11:46','הגשה'),(3,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'הגשה מרכז שולחן'),(4,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'מז� ו� ים'),(5,'2018-08-13 17:32:41','2018-08-13 18:11:34','2018-08-13 18:11:34','1 שוט'),(6,'2018-08-13 18:12:20','2018-08-13 18:12:20',NULL,'יום עיון');
  361. /*!40000 ALTER TABLE `calendar_item_order_submission_types` ENABLE KEYS */;
  362. UNLOCK TABLES;
  363.  
  364. --
  365. -- Table structure for table `calendar_item_orders`
  366. --
  367.  
  368. DROP TABLE IF EXISTS `calendar_item_orders`;
  369. /*!40101 SET @saved_cs_client = @@character_set_client */;
  370. /*!40101 SET character_set_client = utf8 */;
  371. CREATE TABLE `calendar_item_orders` (
  372. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  373. `created_at` timestamp NULL DEFAULT NULL,
  374. `updated_at` timestamp NULL DEFAULT NULL,
  375. `deleted_at` timestamp NULL DEFAULT NULL,
  376. `form_number` int(11) DEFAULT NULL,
  377. `order_number` int(11) DEFAULT NULL,
  378. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  379. `company_id` int(10) unsigned DEFAULT NULL,
  380. `event_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  381. `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  382. `event_date` date DEFAULT NULL,
  383. `day_time_frame` enum('morning','noon','evening') COLLATE utf8_unicode_ci DEFAULT NULL,
  384. `from_hour` datetime DEFAULT NULL,
  385. `to_hour` datetime DEFAULT NULL,
  386. `contract_conditional_tasting` tinyint(1) NOT NULL DEFAULT '0',
  387. `status_changed_at` datetime DEFAULT NULL,
  388. `contacts` json DEFAULT NULL,
  389. `includes` json DEFAULT NULL,
  390. `not_includes` json DEFAULT NULL,
  391. `payment_terms` json DEFAULT NULL,
  392. `base_terms` json DEFAULT NULL,
  393. `comments` text COLLATE utf8_unicode_ci,
  394. `items` json DEFAULT NULL,
  395. `items_comments` text COLLATE utf8_unicode_ci,
  396. `companies_items` json DEFAULT NULL,
  397. `companies_items_comments` json DEFAULT NULL,
  398. `attaches` json DEFAULT NULL,
  399. `base_dish_price` int(11) DEFAULT NULL,
  400. `taste_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  401. `meeting_with_manager_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  402. `advance_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  403. `security_cheque_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  404. `akom_status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  405. `akom_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  406. `total_price` double(8,2) DEFAULT NULL,
  407. `total_paid` double(8,2) DEFAULT NULL,
  408. `balance_due` double(8,2) DEFAULT NULL,
  409. PRIMARY KEY (`id`),
  410. KEY `calendar_item_orders_calendar_item_id_index` (`calendar_item_id`),
  411. KEY `calendar_item_orders_company_id_index` (`company_id`)
  412. ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  413. /*!40101 SET character_set_client = @saved_cs_client */;
  414.  
  415. --
  416. -- Dumping data for table `calendar_item_orders`
  417. --
  418.  
  419. LOCK TABLES `calendar_item_orders` WRITE;
  420. /*!40000 ALTER TABLE `calendar_item_orders` DISABLE KEYS */;
  421. INSERT INTO `calendar_item_orders` VALUES (1,'2018-08-13 18:32:10','2018-08-13 18:53:49',NULL,1,1000,2,1,'wedding','event.closed','2018-09-30','evening','2018-08-13 19:30:58','2018-08-13 01:30:58',0,NULL,'[{\"id\": 1, \"email\": null, \"pivot\": {\"contact_id\": 1, \"calendar_item_id\": 2}, \"gender\": \"male\", \"address\": null, \"comments\": null, \"full_name\": \"� ת� אל אדרי\", \"last_name\": \"אדרי\", \"company_id\": 1, \"created_at\": \"2018-08-13 18:32:10\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"� ת� אל\", \"updated_at\": \"2018-08-13 18:32:10\", \"identity_number\": null, \"mobile_phone_number\": \"0502498900\", \"landline_phone_number\": null}, {\"id\": 1, \"email\": null, \"pivot\": {\"contact_id\": 1, \"calendar_item_id\": 2}, \"gender\": \"male\", \"address\": null, \"comments\": null, \"full_name\": \"� ת� אל אדרי\", \"last_name\": \"אדרי\", \"company_id\": 1, \"created_at\": \"2018-08-13 18:32:10\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"� ת� אל\", \"updated_at\": \"2018-08-13 18:32:10\", \"identity_number\": null, \"mobile_phone_number\": \"0502498900\", \"landline_phone_number\": null}]',NULL,NULL,NULL,'{\"reserve_number\": 20, \"base_dish_price\": 250, \"min_dishes_number\": 200, \"calendar_item_order_menu_type_id\": 2, \"calendar_item_order_submission_type_id\": 1}',NULL,'[{\"id\": 3, \"name\": \"מ� ה מאי-אוקטובר\", \"media\": [], \"price\": 250, \"currency\": \"ILS\", \"quantity\": 250, \"created_at\": \"2018-08-13 17:44:38\", \"deleted_at\": null, \"price_type\": \"per-unit\", \"updated_at\": \"2018-08-13 17:46:31\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 1}, {\"id\": 8, \"name\": \"הגברה תאורה ומסכים\", \"media\": [], \"price\": 4000, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 17:50:11\", \"deleted_at\": null, \"price_type\": \"fixed\", \"updated_at\": \"2018-08-13 17:50:11\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 3}, {\"id\": 9, \"name\": \"בר חוץ פרימיום\", \"media\": [], \"price\": 25, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 17:51:49\", \"deleted_at\": null, \"price_type\": \"per-unit\", \"updated_at\": \"2018-08-13 17:51:49\", \"description\": \"מתייחס למי� ימום 200 איש\", \"media_file_url\": null, \"catalog_category_id\": 3}, {\"id\": 11, \"name\": \"דמי חליצה\", \"media\": [], \"price\": 1800, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 18:04:03\", \"deleted_at\": null, \"price_type\": \"fixed\", \"updated_at\": \"2018-08-13 18:04:03\", \"description\": \"ברמ� /ית ביחס של 1:80\", \"media_file_url\": null, \"catalog_category_id\": 3}]','בה� תצץמךצבהמתצ� מבתהצמ� בהצת','[]','[]','{\"attache_1\": []}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,68325.00,NULL,NULL),(2,'2018-08-13 18:43:39','2018-08-13 18:43:39',NULL,2,NULL,3,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'2018-08-13 19:41:25','2018-08-13 19:51:18',NULL,3,1001,4,1,'brit','event.closed','2018-09-05','evening','2018-08-13 19:30:42','2018-08-13 01:30:42',0,NULL,'[{\"id\": 4, \"email\": null, \"pivot\": {\"contact_id\": 4, \"calendar_item_id\": 4}, \"gender\": \"male\", \"address\": null, \"comments\": null, \"full_name\": \"אימרן שומחייב\", \"last_name\": \"שומחייב\", \"company_id\": 1, \"created_at\": \"2018-08-13 19:41:25\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"אימרן\", \"updated_at\": \"2018-08-13 19:41:25\", \"identity_number\": \"323226274\", \"mobile_phone_number\": \"0545607489\", \"landline_phone_number\": null}, {\"id\": 3, \"email\": \"meitalfi@hotmail.com\", \"pivot\": {\"contact_id\": 3, \"calendar_item_id\": 4}, \"gender\": \"female\", \"address\": \"הס משה 8 פתח תקווה\", \"comments\": null, \"full_name\": \"מיטל שומחייב\", \"last_name\": \"שומחייב\", \"company_id\": 1, \"created_at\": \"2018-08-13 19:41:25\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"מיטל\", \"updated_at\": \"2018-08-13 19:41:25\", \"identity_number\": \"033498973\", \"mobile_phone_number\": \"0545605819\", \"landline_phone_number\": null}]',NULL,NULL,NULL,'{\"reserve_number\": 20, \"base_dish_price\": 180, \"min_dishes_number\": 180, \"calendar_item_order_menu_type_id\": 2, \"calendar_item_order_submission_type_id\": 1}','ברית ל אורי � תן','[{\"id\": 8, \"name\": \"הגברה תאורה ומסכים\", \"media\": [], \"price\": 0, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 17:50:11\", \"deleted_at\": null, \"price_type\": \"fixed\", \"updated_at\": \"2018-08-13 17:50:11\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 3}, {\"name\": \"מ� ה\", \"price\": 180, \"currency\": \"ILS\", \"quantity\": 180, \"price_type\": null, \"description\": null}]','4 עמדות מז� ו� ים בקבלת פ� ים \nכל מ� ה מעבר ל180 תתומחר לפי 175 ש\"ח','[]','[]','{\"attache_1\": []}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,32400.00,NULL,NULL),(4,'2018-08-13 20:01:40','2018-08-13 20:07:04',NULL,4,1002,5,1,'bar.mitzva','event.closed','2018-10-16','evening','2018-08-13 19:30:04','2018-08-13 01:30:04',0,NULL,'[{\"id\": 5, \"email\": \"mali.einat95@gmail.com\", \"pivot\": {\"contact_id\": 5, \"calendar_item_id\": 5}, \"gender\": \"male\", \"address\": \"הרב צעירי 10פתח תקווה\", \"comments\": null, \"full_name\": \"גלית עי� ת\", \"last_name\": \"עי� ת\", \"company_id\": 1, \"created_at\": \"2018-08-13 20:01:40\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"גלית\", \"updated_at\": \"2018-08-13 20:01:40\", \"identity_number\": \"31787815\", \"mobile_phone_number\": \"0502017001\", \"landline_phone_number\": null}, {\"id\": 6, \"email\": null, \"pivot\": {\"contact_id\": 6, \"calendar_item_id\": 5}, \"gender\": \"male\", \"address\": null, \"comments\": null, \"full_name\": \"עופר עי� ת\", \"last_name\": \"עי� ת\", \"company_id\": 1, \"created_at\": \"2018-08-13 20:01:40\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"עופר\", \"updated_at\": \"2018-08-13 20:01:40\", \"identity_number\": \"024375784\", \"mobile_phone_number\": \"0502017000\", \"landline_phone_number\": null}]',NULL,NULL,NULL,'{\"reserve_number\": 20, \"base_dish_price\": 180, \"min_dishes_number\": 200, \"calendar_item_order_menu_type_id\": 2, \"calendar_item_order_submission_type_id\": 1}','בר מצווה לראובן','[{\"id\": 3, \"name\": \"מ� ה מאי-אוקטובר\", \"media\": [], \"price\": 180, \"currency\": \"ILS\", \"quantity\": 200, \"created_at\": \"2018-08-13 17:44:38\", \"deleted_at\": null, \"price_type\": \"per-unit\", \"updated_at\": \"2018-08-13 17:46:31\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 1}, {\"id\": 8, \"name\": \"הגברה תאורה ומסכים\", \"media\": [], \"price\": 4000, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 17:50:11\", \"deleted_at\": null, \"price_type\": \"fixed\", \"updated_at\": \"2018-08-13 17:50:11\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 3}]','עוגת הפתעה כלולה\nאירוע גלאט מחפוד','[]','[]','{\"attache_1\": []}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,40000.00,NULL,NULL),(5,'2018-08-13 20:41:14','2018-08-13 20:55:51',NULL,5,1003,6,1,'wedding','event.closed','2018-11-01','evening','2018-08-13 19:30:22','2018-08-13 02:00:22',0,NULL,'[{\"id\": 7, \"email\": \"axlen1989@gmail.com\", \"pivot\": {\"contact_id\": 7, \"calendar_item_id\": 6}, \"gender\": \"female\", \"address\": \"יוסף ספיר 48\", \"comments\": null, \"full_name\": \"אלבי� ה קפרוב\", \"last_name\": \"קפרוב\", \"company_id\": 1, \"created_at\": \"2018-08-13 20:41:14\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"אלבי� ה\", \"updated_at\": \"2018-08-13 20:41:14\", \"identity_number\": \"322113218\", \"mobile_phone_number\": \"0547752477\", \"landline_phone_number\": null}, {\"id\": 8, \"email\": null, \"pivot\": {\"contact_id\": 8, \"calendar_item_id\": 6}, \"gender\": \"male\", \"address\": null, \"comments\": null, \"full_name\": \"אדוארד י� גלטוב\", \"last_name\": \"י� גלטוב\", \"company_id\": 1, \"created_at\": \"2018-08-13 20:41:14\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"אדוארד\", \"updated_at\": \"2018-08-13 20:41:14\", \"identity_number\": \"326838976\", \"mobile_phone_number\": \"0545205965\", \"landline_phone_number\": null}]',NULL,NULL,NULL,'{\"reserve_number\": 15, \"base_dish_price\": 250, \"min_dishes_number\": 150, \"calendar_item_order_menu_type_id\": 2, \"calendar_item_order_submission_type_id\": 1}',NULL,'[{\"id\": 4, \"name\": \"מ� ה � ובמבר\", \"media\": [], \"price\": 250, \"currency\": \"ILS\", \"quantity\": 150, \"created_at\": \"2018-08-13 17:46:45\", \"deleted_at\": null, \"price_type\": \"per-unit\", \"updated_at\": \"2018-08-13 17:46:45\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 1}, {\"id\": 8, \"name\": \"הגברה תאורה ומסכים\", \"media\": [], \"price\": 4000, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 17:50:11\", \"deleted_at\": null, \"price_type\": \"fixed\", \"updated_at\": \"2018-08-13 17:50:11\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 3}]',NULL,'[]','[]','{\"attache_1\": []}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,41500.00,NULL,NULL),(6,'2018-08-13 21:13:58','2018-08-13 21:13:58',NULL,6,NULL,8,NULL,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'2018-08-14 18:36:00','2018-08-14 18:36:00',NULL,7,NULL,25,NULL,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'2018-08-14 18:37:10','2018-08-14 18:37:10',NULL,8,NULL,27,NULL,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,'2018-08-14 18:59:26','2018-08-14 18:59:26',NULL,9,NULL,33,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,'2018-08-14 18:59:45','2018-08-14 18:59:45',NULL,10,NULL,35,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,'2018-08-14 19:03:02','2018-08-14 19:03:02',NULL,11,NULL,37,NULL,'bar.mitzva','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'2018-08-14 19:08:00','2018-08-14 19:08:00',NULL,12,NULL,39,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'2018-08-15 17:07:11','2018-08-15 17:07:11',NULL,13,NULL,41,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,'2018-08-15 19:26:03','2018-08-15 19:26:03',NULL,14,NULL,43,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,'2018-08-17 14:07:02','2018-08-17 14:07:02',NULL,15,NULL,45,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'2018-08-19 16:25:27','2018-08-19 16:25:27',NULL,16,NULL,48,NULL,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'2018-08-19 17:30:49','2018-08-19 17:30:49',NULL,17,NULL,50,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,'2018-08-20 19:28:39','2018-08-20 19:50:06',NULL,18,1004,53,1,'bar.mitzva','event.closed','2018-09-04','evening','2018-08-20 19:30:55','2018-08-20 01:30:55',0,NULL,'[{\"id\": 41, \"email\": \"shimrit@shtva.xo.il\", \"pivot\": {\"contact_id\": 41, \"calendar_item_id\": 53}, \"gender\": \"male\", \"address\": \"כץ 84 פתח תקווה\", \"comments\": null, \"full_name\": \"שימרית דוד\", \"last_name\": \"דוד\", \"company_id\": 1, \"created_at\": \"2018-08-20 19:28:39\", \"deleted_at\": null, \"fax_number\": null, \"first_name\": \"שימרית\", \"updated_at\": \"2018-08-20 19:28:39\", \"identity_number\": \"065956971\", \"mobile_phone_number\": \"0526666897\", \"landline_phone_number\": null}, {\"email\": null, \"gender\": \"male\", \"address\": null, \"comments\": null, \"last_name\": null, \"fax_number\": null, \"first_name\": null, \"identity_number\": null, \"mobile_phone_number\": null, \"landline_phone_number\": null}]',NULL,NULL,NULL,'{\"reserve_number\": 20, \"base_dish_price\": 180, \"min_dishes_number\": 200, \"calendar_item_order_menu_type_id\": 2, \"calendar_item_order_submission_type_id\": 1}',NULL,'[{\"id\": 10, \"name\": \"בר חוץ סופר פרימיום\", \"media\": [], \"price\": 1000, \"currency\": \"ILS\", \"quantity\": 1, \"created_at\": \"2018-08-13 17:52:20\", \"deleted_at\": null, \"price_type\": \"per-unit\", \"updated_at\": \"2018-08-13 17:52:20\", \"description\": null, \"media_file_url\": null, \"catalog_category_id\": 3}, {\"name\": \"מ� ה\", \"price\": 180, \"currency\": \"ILS\", \"quantity\": 200, \"price_type\": null, \"description\": null}]','המחיר כולל הגברה תאורה ומסכים \nוודקה גרגוס וגלןפידיך - תוספת 1000 ש\"ח','[]','[]','{\"attache_1\": []}',NULL,NULL,NULL,NULL,NULL,NULL,NULL,37000.00,NULL,NULL),(19,'2018-08-21 16:17:41','2018-08-21 16:17:41',NULL,19,NULL,55,1,'wedding','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,'2018-08-21 16:44:22','2018-08-21 16:44:22',NULL,20,NULL,57,1,'bat.mitzva','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,'2018-08-21 21:40:35','2018-08-21 21:40:35',NULL,21,NULL,61,1,'bar.mitzva','event.interested',NULL,NULL,NULL,NULL,0,NULL,'[{\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}, {\"email\": \"\", \"gender\": \"male\", \"address\": \"\", \"comments\": \"\", \"last_name\": \"\", \"fax_number\": \"\", \"first_name\": \"\", \"identity_number\": \"\", \"mobile_phone_number\": \"\", \"landline_phone_number\": \"\"}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  422. /*!40000 ALTER TABLE `calendar_item_orders` ENABLE KEYS */;
  423. UNLOCK TABLES;
  424.  
  425. --
  426. -- Table structure for table `calendar_item_user`
  427. --
  428.  
  429. DROP TABLE IF EXISTS `calendar_item_user`;
  430. /*!40101 SET @saved_cs_client = @@character_set_client */;
  431. /*!40101 SET character_set_client = utf8 */;
  432. CREATE TABLE `calendar_item_user` (
  433. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  434. `deleted_at` timestamp NULL DEFAULT NULL,
  435. `created_at` timestamp NULL DEFAULT NULL,
  436. `updated_at` timestamp NULL DEFAULT NULL,
  437. `calendar_item_id` int(10) unsigned NOT NULL,
  438. `user_id` int(10) unsigned NOT NULL,
  439. PRIMARY KEY (`id`),
  440. KEY `calendar_item_user_calendar_item_id_index` (`calendar_item_id`),
  441. KEY `calendar_item_user_user_id_index` (`user_id`)
  442. ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  443. /*!40101 SET character_set_client = @saved_cs_client */;
  444.  
  445. --
  446. -- Dumping data for table `calendar_item_user`
  447. --
  448.  
  449. LOCK TABLES `calendar_item_user` WRITE;
  450. /*!40000 ALTER TABLE `calendar_item_user` DISABLE KEYS */;
  451. INSERT INTO `calendar_item_user` VALUES (1,NULL,NULL,NULL,1,1),(2,NULL,NULL,NULL,2,1),(3,NULL,NULL,NULL,3,1),(4,NULL,NULL,NULL,4,1),(5,NULL,NULL,NULL,5,1),(6,NULL,NULL,NULL,6,1),(7,NULL,NULL,NULL,7,1),(8,NULL,NULL,NULL,8,1),(24,NULL,NULL,NULL,24,1),(25,NULL,NULL,NULL,25,1),(26,NULL,NULL,NULL,26,1),(27,NULL,NULL,NULL,27,1),(32,NULL,NULL,NULL,32,1),(33,NULL,NULL,NULL,33,1),(34,NULL,NULL,NULL,34,1),(35,NULL,NULL,NULL,35,1),(36,NULL,NULL,NULL,36,1),(37,NULL,NULL,NULL,37,1),(38,NULL,NULL,NULL,38,1),(39,NULL,NULL,NULL,39,1),(40,NULL,NULL,NULL,40,1),(41,NULL,NULL,NULL,41,1),(42,NULL,NULL,NULL,42,1),(43,NULL,NULL,NULL,43,1),(44,NULL,NULL,NULL,44,1),(45,NULL,NULL,NULL,45,1),(47,NULL,NULL,NULL,47,1),(48,NULL,NULL,NULL,48,1),(49,NULL,NULL,NULL,49,1),(50,NULL,NULL,NULL,50,1),(51,NULL,NULL,NULL,51,1),(52,NULL,NULL,NULL,52,1),(53,NULL,NULL,NULL,53,1),(54,NULL,NULL,NULL,54,1),(55,NULL,NULL,NULL,55,1),(56,NULL,NULL,NULL,56,1),(57,NULL,NULL,NULL,57,1),(58,NULL,NULL,NULL,58,1),(59,NULL,NULL,NULL,59,1),(60,NULL,NULL,NULL,60,1),(61,NULL,NULL,NULL,61,1);
  452. /*!40000 ALTER TABLE `calendar_item_user` ENABLE KEYS */;
  453. UNLOCK TABLES;
  454.  
  455. --
  456. -- Table structure for table `calendar_items`
  457. --
  458.  
  459. DROP TABLE IF EXISTS `calendar_items`;
  460. /*!40101 SET @saved_cs_client = @@character_set_client */;
  461. /*!40101 SET character_set_client = utf8 */;
  462. CREATE TABLE `calendar_items` (
  463. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  464. `created_at` timestamp NULL DEFAULT NULL,
  465. `updated_at` timestamp NULL DEFAULT NULL,
  466. `deleted_at` timestamp NULL DEFAULT NULL,
  467. `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  468. `start_date` datetime DEFAULT NULL,
  469. `end_date` datetime DEFAULT NULL,
  470. `event_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  471. `meeting_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  472. `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  473. `interest_period` json DEFAULT NULL,
  474. `guests_number` int(11) DEFAULT NULL,
  475. `join_source_id` int(10) unsigned DEFAULT NULL,
  476. `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  477. `meeting_comments` text COLLATE utf8_unicode_ci,
  478. `event_comments` text COLLATE utf8_unicode_ci,
  479. `attendee_address` text COLLATE utf8_unicode_ci,
  480. `data` json DEFAULT NULL,
  481. `foreign_crm_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  482. `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  483. `send_reminders` tinyint(1) NOT NULL DEFAULT '0',
  484. `send_invitations` tinyint(1) NOT NULL DEFAULT '1',
  485. `user_id` int(10) unsigned NOT NULL,
  486. `company_id` int(10) unsigned DEFAULT NULL,
  487. `number` int(11) DEFAULT NULL,
  488. `first_interest_date` datetime DEFAULT NULL,
  489. `second_interest_date` datetime DEFAULT NULL,
  490. PRIMARY KEY (`id`),
  491. KEY `calendar_items_join_source_id_index` (`join_source_id`),
  492. KEY `calendar_items_user_id_index` (`user_id`),
  493. KEY `calendar_items_company_id_index` (`company_id`)
  494. ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  495. /*!40101 SET character_set_client = @saved_cs_client */;
  496.  
  497. --
  498. -- Dumping data for table `calendar_items`
  499. --
  500.  
  501. LOCK TABLES `calendar_items` WRITE;
  502. /*!40000 ALTER TABLE `calendar_items` DISABLE KEYS */;
  503. INSERT INTO `calendar_items` VALUES (1,'2018-08-13 18:32:10','2018-08-14 20:47:15','2018-08-14 20:47:15','meeting','2018-08-26 08:00:00','2018-08-26 09:00:00','wedding','intro','meeting.pending','[\"july\", \"august\", \"sunday\", \"monday\", \"evening\"]',250,2,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(2,'2018-08-13 18:32:10','2018-08-13 18:53:49',NULL,'event','2018-09-30 19:30:20','2018-09-30 01:30:20','wedding','intro','event.closed','[\"july\", \"august\", \"sunday\", \"monday\", \"evening\"]',250,2,'החתו� ה של � ת� אל אדרי ו� ת� אל אדרי',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10000,NULL,NULL),(3,'2018-08-13 18:43:39','2018-08-13 18:43:39',NULL,'event','2018-08-09 03:00:00','2018-08-09 04:00:00','wedding',NULL,'event.optional','[\"october\"]',NULL,NULL,'החתו� ה של דגכדגכדגכ דגכדגכ ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10001,'2018-08-09 03:00:00',NULL),(4,'2018-08-13 19:41:25','2018-08-13 19:47:34',NULL,'event','2018-09-05 19:30:00','2018-09-05 01:30:00','brit',NULL,'event.closed','[\"september\", \"wednesday\"]',NULL,NULL,'הברית של אימרן שומחייב ומיטל שומחייב',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10002,'2018-09-05 03:00:00',NULL),(5,'2018-08-13 20:01:40','2018-08-13 20:06:04',NULL,'event','2018-10-16 19:30:00','2018-10-16 01:30:00','bar.mitzva',NULL,'event.closed','[\"october\"]',NULL,NULL,'הבר מצווה של גלית עי� ת ועופר עי� ת',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10003,'2018-10-16 03:00:00',NULL),(6,'2018-08-13 20:41:14','2018-08-13 20:43:48',NULL,'event','2018-11-01 19:30:00','2018-11-01 02:00:00','wedding',NULL,'event.closed','[\"november\"]',NULL,NULL,'החתו� ה של אלבי� ה קפרוב ואדוארד י� גלטוב',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10004,'2018-11-01 02:00:00',NULL),(7,'2018-08-13 21:13:58','2018-08-13 21:13:58',NULL,'meeting','2018-08-14 20:31:00','2018-08-14 21:00:00','wedding','intro','meeting.pending','[\"october\"]',250,NULL,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,NULL,NULL,NULL),(8,'2018-08-13 21:13:58','2018-08-13 21:13:58',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"october\"]',250,NULL,'החתו� ה של שגיא 052-5404540 ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,10005,NULL,NULL),(24,'2018-08-14 18:36:00','2018-08-14 18:36:24','2018-08-14 18:36:24','meeting','2018-08-15 03:00:00','2018-08-15 04:00:00','wedding','intro','meeting.pending','[\"monday\"]',123,NULL,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,NULL,NULL,NULL),(25,'2018-08-14 18:36:00','2018-08-14 18:36:00',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"monday\"]',123,NULL,'החתו� ה של גדש גדש ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,10006,NULL,NULL),(26,'2018-08-14 18:37:10','2018-08-14 18:37:22','2018-08-14 18:37:22','meeting','2018-08-08 03:00:00','2018-08-08 04:00:00','wedding','intro','meeting.pending','[\"august\"]',123,NULL,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,NULL,NULL,NULL),(27,'2018-08-14 18:37:10','2018-08-14 18:37:10',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"august\"]',123,NULL,'החתו� ה של זסב שדג ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,10007,NULL,NULL),(32,'2018-08-14 18:59:26','2018-08-14 19:00:39','2018-08-14 19:00:39','meeting','2018-08-19 20:00:00','2018-08-19 20:30:00','wedding','intro','meeting.pending','[\"february\", \"march\"]',198,1,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,'2018-02-20 00:00:00',NULL),(33,'2018-08-14 18:59:26','2018-08-14 18:59:26',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"february\", \"march\"]',198,1,'החתו� ה של רו� י רו� י ומורן מורן',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10008,'2018-02-20 00:00:00',NULL),(34,'2018-08-14 18:59:45','2018-08-14 18:59:45',NULL,'meeting','2018-08-19 20:00:00','2018-08-19 20:30:00','wedding','intro','meeting.pending','[\"february\", \"march\"]',200,1,'פגישת היכרות','מתע� יי� ת לחתו� ה בפברואר מרץ',NULL,NULL,NULL,NULL,'משרדים',1,0,1,1,NULL,'2018-02-20 00:00:00',NULL),(35,'2018-08-14 18:59:45','2018-08-14 18:59:45',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"february\", \"march\"]',200,1,'החתו� ה של רו� לי רו� לי ו','מתע� יי� ת לחתו� ה בפברואר מרץ',NULL,NULL,NULL,NULL,'משרדים',1,0,1,1,10009,'2018-02-20 00:00:00',NULL),(36,'2018-08-14 19:03:02','2018-08-14 19:03:02',NULL,'meeting','2018-08-07 03:00:00','2018-08-07 04:00:00','bar.mitzva','intro','meeting.pending','[\"october\"]',150,NULL,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,NULL,NULL,NULL),(37,'2018-08-14 19:03:02','2018-08-14 19:03:02',NULL,'event',NULL,NULL,'bar.mitzva','intro','event.interested','[\"october\"]',150,NULL,'הבר מצווה של גילה ובועז ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,10010,NULL,NULL),(38,'2018-08-14 19:08:00','2018-08-14 19:08:00',NULL,'meeting','2018-08-07 03:00:00','2018-08-07 04:00:00','wedding','intro','meeting.pending','[\"june\"]',250,1,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,0,1,1,NULL,NULL,NULL),(39,'2018-08-14 19:08:00','2018-08-14 19:08:00',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"june\"]',250,1,'החתו� ה של � ועה שרמן ועומרי רחמים',NULL,NULL,NULL,NULL,NULL,'משרדים',0,0,1,1,10011,NULL,NULL),(40,'2018-08-15 17:07:11','2018-08-15 17:07:11',NULL,'meeting','2018-08-19 17:00:00','2018-08-19 04:00:00','wedding','intro','meeting.pending','[\"winter\"]',180,1,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(41,'2018-08-15 17:07:11','2018-08-15 17:07:11',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"winter\"]',180,1,'החתו� ה של קרן וליעד ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10012,NULL,NULL),(42,'2018-08-15 19:26:03','2018-08-15 19:26:03',NULL,'meeting','2018-08-16 17:00:00','2018-08-16 17:30:00','wedding','intro','meeting.pending','[\"october\"]',300,NULL,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,0,1,1,NULL,NULL,NULL),(43,'2018-08-15 19:26:03','2018-08-15 19:26:03',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"october\"]',300,NULL,'החתו� ה של איל� ית ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,0,1,1,10013,NULL,NULL),(44,'2018-08-17 14:07:02','2018-08-17 14:07:02',NULL,'meeting','2018-08-19 21:30:00','2018-08-19 21:30:00','wedding','follow.up','meeting.pending','[\"april\"]',300,NULL,'פגישה ש� יה',NULL,NULL,NULL,NULL,NULL,'משרדים',0,0,1,1,NULL,NULL,NULL),(45,'2018-08-17 14:07:02','2018-08-17 14:07:02',NULL,'event',NULL,NULL,'wedding','follow.up','event.interested','[\"april\"]',300,NULL,'החתו� ה של רותם ושרון ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,0,1,1,10014,NULL,NULL),(47,'2018-08-19 16:25:26','2018-08-19 16:25:26',NULL,'meeting','2018-08-21 18:59:00','2018-08-21 18:30:00','wedding','follow.up','meeting.pending','[\"october\"]',200,1,'פגישה ש� יה','הוצע 215 או 235',NULL,NULL,NULL,NULL,'משרדים',1,1,1,NULL,NULL,'2018-10-25 00:00:00','2018-08-26 00:00:00'),(48,'2018-08-19 16:25:27','2018-08-19 16:25:27',NULL,'event',NULL,NULL,'wedding','follow.up','event.interested','[\"october\"]',200,1,'החתו� ה של הילה מימון ו','הוצע 215 או 235',NULL,NULL,NULL,NULL,'משרדים',1,1,1,NULL,10015,'2018-10-25 00:00:00','2018-08-26 00:00:00'),(49,'2018-08-19 17:30:49','2018-08-19 17:30:49',NULL,'meeting','2018-08-19 03:00:00','2018-08-19 04:00:00','wedding','intro','meeting.pending','[\"october\"]',400,NULL,'פגישת היכרות','בשר חלק רב� ות הוצע ע\"י שלומי 200 ש\"ח תאורה והגברה 4000',NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(50,'2018-08-19 17:30:49','2018-08-19 17:30:49',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"october\"]',400,NULL,'החתו� ה של איתמר ו','בשר חלק רב� ות הוצע ע\"י שלומי 200 ש\"ח תאורה והגברה 4000',NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10016,NULL,NULL),(51,'2018-08-19 21:55:53','2018-08-19 21:55:53',NULL,'meeting','2018-09-04 20:00:00','2018-08-20 20:29:00',NULL,'follow.up','meeting.pending',NULL,NULL,NULL,'פגישת התרשמות מאירוע','שם החתן מורן',NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(52,'2018-08-19 21:58:31','2018-08-19 21:58:31',NULL,'meeting','2018-09-04 22:00:00','2018-09-04 20:30:00',NULL,'follow.up','meeting.pending',NULL,NULL,NULL,'פגישה ש� יה','לדאוג לטעימה',NULL,NULL,NULL,NULL,'משרדים',0,1,1,NULL,NULL,NULL,NULL),(53,'2018-08-20 19:28:39','2018-08-20 19:33:06',NULL,'event','2018-09-04 19:30:00','2018-09-04 01:30:00','bar.mitzva',NULL,'event.closed','[\"september\"]',NULL,NULL,'הבר מצווה של שימרית דוד ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10017,'2018-09-04 03:00:00',NULL),(54,'2018-08-21 16:17:40','2018-08-21 16:17:40',NULL,'meeting','2018-08-21 20:01:00','2018-08-21 04:00:00','wedding','intro','meeting.pending','[\"november\"]',150,3,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(55,'2018-08-21 16:17:41','2018-08-21 16:17:41',NULL,'event',NULL,NULL,'wedding','intro','event.interested','[\"november\"]',150,3,'החתו� ה של יוכי ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10018,NULL,NULL),(56,'2018-08-21 16:44:22','2018-08-21 16:44:22',NULL,'meeting','2018-08-21 21:00:00','2018-08-21 04:00:00','bat.mitzva','intro','meeting.pending','[\"november\"]',250,1,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(57,'2018-08-21 16:44:22','2018-08-21 16:44:22',NULL,'event',NULL,NULL,'bat.mitzva','intro','event.interested','[\"november\"]',250,1,'הבת מצווה של פרח ו',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10019,NULL,NULL),(58,'2018-08-21 19:53:26','2018-08-21 19:53:26',NULL,'meeting','2018-08-28 19:31:00','2018-08-28 20:30:00',NULL,'follow.up','meeting.pending',NULL,NULL,NULL,'פגישה ש� יה',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(59,'2018-08-21 20:44:13','2018-08-21 20:44:13',NULL,'meeting','2018-08-28 20:00:00','2018-08-28 20:30:00',NULL,'follow.up','meeting.pending',NULL,NULL,NULL,'פגישה ש� יה',NULL,NULL,'פתח תקווה',NULL,NULL,'משרדים',0,1,1,1,NULL,NULL,NULL),(60,'2018-08-21 21:40:34','2018-08-21 21:40:34',NULL,'meeting','2018-08-21 22:00:00','2018-08-21 22:30:00','bar.mitzva','intro','meeting.pending','[\"january\"]',180,1,'פגישת היכרות',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,NULL,'2019-01-01 00:00:00',NULL),(61,'2018-08-21 21:40:35','2018-08-21 21:40:35',NULL,'event',NULL,NULL,'bar.mitzva','intro','event.interested','[\"january\"]',180,1,'הבר מצווה של שרון ושרון',NULL,NULL,NULL,NULL,NULL,'משרדים',0,1,1,1,10020,'2019-01-01 00:00:00',NULL);
  504. /*!40000 ALTER TABLE `calendar_items` ENABLE KEYS */;
  505. UNLOCK TABLES;
  506.  
  507. --
  508. -- Table structure for table `calendar_items_contacts`
  509. --
  510.  
  511. DROP TABLE IF EXISTS `calendar_items_contacts`;
  512. /*!40101 SET @saved_cs_client = @@character_set_client */;
  513. /*!40101 SET character_set_client = utf8 */;
  514. CREATE TABLE `calendar_items_contacts` (
  515. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  516. `deleted_at` timestamp NULL DEFAULT NULL,
  517. `created_at` timestamp NULL DEFAULT NULL,
  518. `updated_at` timestamp NULL DEFAULT NULL,
  519. `contact_id` int(10) unsigned NOT NULL,
  520. `calendar_item_id` int(10) unsigned NOT NULL,
  521. `type` enum('bride','groom','child','child.father','child.mother','groom.father','groom.mother','bride.father','bride.mother','producer','business.representative') COLLATE utf8_unicode_ci DEFAULT NULL,
  522. PRIMARY KEY (`id`),
  523. KEY `calendar_items_contacts_contact_id_index` (`contact_id`),
  524. KEY `calendar_items_contacts_calendar_item_id_index` (`calendar_item_id`)
  525. ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  526. /*!40101 SET character_set_client = @saved_cs_client */;
  527.  
  528. --
  529. -- Dumping data for table `calendar_items_contacts`
  530. --
  531.  
  532. LOCK TABLES `calendar_items_contacts` WRITE;
  533. /*!40000 ALTER TABLE `calendar_items_contacts` DISABLE KEYS */;
  534. INSERT INTO `calendar_items_contacts` VALUES (1,NULL,NULL,NULL,1,1,NULL),(2,NULL,NULL,NULL,1,2,NULL),(3,NULL,NULL,NULL,2,3,NULL),(4,NULL,NULL,NULL,3,4,NULL),(5,NULL,NULL,NULL,4,4,NULL),(6,NULL,NULL,NULL,5,5,NULL),(7,NULL,NULL,NULL,6,5,NULL),(8,NULL,NULL,NULL,7,6,NULL),(9,NULL,NULL,NULL,8,6,NULL),(10,NULL,NULL,NULL,9,7,NULL),(11,NULL,NULL,NULL,9,8,NULL),(26,NULL,NULL,NULL,24,24,NULL),(27,NULL,NULL,NULL,24,25,NULL),(28,NULL,NULL,NULL,25,26,NULL),(29,NULL,NULL,NULL,25,27,NULL),(34,NULL,NULL,NULL,30,32,NULL),(35,NULL,NULL,NULL,31,32,NULL),(36,NULL,NULL,NULL,30,33,NULL),(37,NULL,NULL,NULL,31,33,NULL),(38,NULL,NULL,NULL,32,34,NULL),(39,NULL,NULL,NULL,32,35,NULL),(40,NULL,NULL,NULL,33,36,NULL),(41,NULL,NULL,NULL,33,37,NULL),(42,NULL,NULL,NULL,34,38,NULL),(43,NULL,NULL,NULL,35,38,NULL),(44,NULL,NULL,NULL,34,39,NULL),(45,NULL,NULL,NULL,35,39,NULL),(46,NULL,NULL,NULL,36,40,NULL),(47,NULL,NULL,NULL,36,41,NULL),(48,NULL,NULL,NULL,37,42,NULL),(49,NULL,NULL,NULL,37,43,NULL),(50,NULL,NULL,NULL,38,44,NULL),(51,NULL,NULL,NULL,38,45,NULL),(52,NULL,NULL,NULL,39,47,NULL),(53,NULL,NULL,NULL,39,48,NULL),(54,NULL,NULL,NULL,40,49,NULL),(55,NULL,NULL,NULL,40,50,NULL),(56,NULL,NULL,NULL,41,53,NULL),(57,NULL,NULL,NULL,42,54,NULL),(58,NULL,NULL,NULL,42,55,NULL),(59,NULL,NULL,NULL,43,56,NULL),(60,NULL,NULL,NULL,43,57,NULL),(61,NULL,NULL,NULL,44,60,NULL),(62,NULL,NULL,NULL,45,60,NULL),(63,NULL,NULL,NULL,44,61,NULL),(64,NULL,NULL,NULL,45,61,NULL);
  535. /*!40000 ALTER TABLE `calendar_items_contacts` ENABLE KEYS */;
  536. UNLOCK TABLES;
  537.  
  538. --
  539. -- Table structure for table `calendar_notes`
  540. --
  541.  
  542. DROP TABLE IF EXISTS `calendar_notes`;
  543. /*!40101 SET @saved_cs_client = @@character_set_client */;
  544. /*!40101 SET character_set_client = utf8 */;
  545. CREATE TABLE `calendar_notes` (
  546. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  547. `deleted_at` timestamp NULL DEFAULT NULL,
  548. `created_at` timestamp NULL DEFAULT NULL,
  549. `updated_at` timestamp NULL DEFAULT NULL,
  550. `user_id` int(10) unsigned NOT NULL,
  551. `companies` json DEFAULT NULL,
  552. `content` text COLLATE utf8_unicode_ci NOT NULL,
  553. `color` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  554. `date` date NOT NULL,
  555. PRIMARY KEY (`id`),
  556. KEY `calendar_notes_user_id_index` (`user_id`)
  557. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  558. /*!40101 SET character_set_client = @saved_cs_client */;
  559.  
  560. --
  561. -- Dumping data for table `calendar_notes`
  562. --
  563.  
  564. LOCK TABLES `calendar_notes` WRITE;
  565. /*!40000 ALTER TABLE `calendar_notes` DISABLE KEYS */;
  566. /*!40000 ALTER TABLE `calendar_notes` ENABLE KEYS */;
  567. UNLOCK TABLES;
  568.  
  569. --
  570. -- Table structure for table `calls`
  571. --
  572.  
  573. DROP TABLE IF EXISTS `calls`;
  574. /*!40101 SET @saved_cs_client = @@character_set_client */;
  575. /*!40101 SET character_set_client = utf8 */;
  576. CREATE TABLE `calls` (
  577. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  578. `deleted_at` timestamp NULL DEFAULT NULL,
  579. `created_at` timestamp NULL DEFAULT NULL,
  580. `updated_at` timestamp NULL DEFAULT NULL,
  581. `start_date` datetime DEFAULT NULL,
  582. `end_date` datetime DEFAULT NULL,
  583. `call_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  584. `status` enum('answered','not.answered') COLLATE utf8_unicode_ci DEFAULT NULL,
  585. `destination_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  586. `recording_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  587. `type` enum('incoming','outgoing') COLLATE utf8_unicode_ci NOT NULL,
  588. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  589. `company_id` int(10) unsigned DEFAULT NULL,
  590. `contact_id` int(10) unsigned DEFAULT NULL,
  591. `user_id` int(10) unsigned DEFAULT NULL,
  592. `join_source_id` int(10) unsigned DEFAULT NULL,
  593. `call_origin_id` int(10) unsigned DEFAULT NULL,
  594. `comments` text COLLATE utf8_unicode_ci,
  595. PRIMARY KEY (`id`),
  596. KEY `calls_calendar_item_id_index` (`calendar_item_id`),
  597. KEY `calls_company_id_index` (`company_id`),
  598. KEY `calls_contact_id_index` (`contact_id`),
  599. KEY `calls_user_id_index` (`user_id`),
  600. KEY `calls_join_source_id_index` (`join_source_id`),
  601. KEY `calls_call_origin_id_index` (`call_origin_id`)
  602. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  603. /*!40101 SET character_set_client = @saved_cs_client */;
  604.  
  605. --
  606. -- Dumping data for table `calls`
  607. --
  608.  
  609. LOCK TABLES `calls` WRITE;
  610. /*!40000 ALTER TABLE `calls` DISABLE KEYS */;
  611. /*!40000 ALTER TABLE `calls` ENABLE KEYS */;
  612. UNLOCK TABLES;
  613.  
  614. --
  615. -- Table structure for table `campaign_deliveries`
  616. --
  617.  
  618. DROP TABLE IF EXISTS `campaign_deliveries`;
  619. /*!40101 SET @saved_cs_client = @@character_set_client */;
  620. /*!40101 SET character_set_client = utf8 */;
  621. CREATE TABLE `campaign_deliveries` (
  622. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  623. `created_at` timestamp NULL DEFAULT NULL,
  624. `updated_at` timestamp NULL DEFAULT NULL,
  625. `deleted_at` timestamp NULL DEFAULT NULL,
  626. `campaign_id` int(10) unsigned NOT NULL,
  627. `deliver_at` datetime DEFAULT NULL,
  628. `status` enum('pending','sent','cancelled') COLLATE utf8_unicode_ci NOT NULL,
  629. `channels` json DEFAULT NULL,
  630. `results` json DEFAULT NULL,
  631. `contacts` json DEFAULT NULL,
  632. PRIMARY KEY (`id`),
  633. KEY `campaign_deliveries_campaign_id_index` (`campaign_id`)
  634. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  635. /*!40101 SET character_set_client = @saved_cs_client */;
  636.  
  637. --
  638. -- Dumping data for table `campaign_deliveries`
  639. --
  640.  
  641. LOCK TABLES `campaign_deliveries` WRITE;
  642. /*!40000 ALTER TABLE `campaign_deliveries` DISABLE KEYS */;
  643. /*!40000 ALTER TABLE `campaign_deliveries` ENABLE KEYS */;
  644. UNLOCK TABLES;
  645.  
  646. --
  647. -- Table structure for table `campaigns`
  648. --
  649.  
  650. DROP TABLE IF EXISTS `campaigns`;
  651. /*!40101 SET @saved_cs_client = @@character_set_client */;
  652. /*!40101 SET character_set_client = utf8 */;
  653. CREATE TABLE `campaigns` (
  654. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  655. `created_at` timestamp NULL DEFAULT NULL,
  656. `updated_at` timestamp NULL DEFAULT NULL,
  657. `deleted_at` timestamp NULL DEFAULT NULL,
  658. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  659. `landing_page_id` bigint(20) unsigned DEFAULT NULL,
  660. `calendar_item_id` bigint(20) unsigned DEFAULT NULL,
  661. `inviteme_event_id` bigint(20) unsigned DEFAULT NULL,
  662. `contacts` json DEFAULT NULL,
  663. `data` json DEFAULT NULL,
  664. PRIMARY KEY (`id`),
  665. KEY `campaigns_landing_page_id_index` (`landing_page_id`),
  666. KEY `campaigns_calendar_item_id_index` (`calendar_item_id`),
  667. KEY `campaigns_inviteme_event_id_index` (`inviteme_event_id`)
  668. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  669. /*!40101 SET character_set_client = @saved_cs_client */;
  670.  
  671. --
  672. -- Dumping data for table `campaigns`
  673. --
  674.  
  675. LOCK TABLES `campaigns` WRITE;
  676. /*!40000 ALTER TABLE `campaigns` DISABLE KEYS */;
  677. /*!40000 ALTER TABLE `campaigns` ENABLE KEYS */;
  678. UNLOCK TABLES;
  679.  
  680. --
  681. -- Table structure for table `cashiers`
  682. --
  683.  
  684. DROP TABLE IF EXISTS `cashiers`;
  685. /*!40101 SET @saved_cs_client = @@character_set_client */;
  686. /*!40101 SET character_set_client = utf8 */;
  687. CREATE TABLE `cashiers` (
  688. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  689. `created_at` timestamp NULL DEFAULT NULL,
  690. `updated_at` timestamp NULL DEFAULT NULL,
  691. `deleted_at` timestamp NULL DEFAULT NULL,
  692. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  693. `comments` text COLLATE utf8_unicode_ci,
  694. `balance` double(8,2) NOT NULL,
  695. PRIMARY KEY (`id`)
  696. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  697. /*!40101 SET character_set_client = @saved_cs_client */;
  698.  
  699. --
  700. -- Dumping data for table `cashiers`
  701. --
  702.  
  703. LOCK TABLES `cashiers` WRITE;
  704. /*!40000 ALTER TABLE `cashiers` DISABLE KEYS */;
  705. /*!40000 ALTER TABLE `cashiers` ENABLE KEYS */;
  706. UNLOCK TABLES;
  707.  
  708. --
  709. -- Table structure for table `catalog_categories`
  710. --
  711.  
  712. DROP TABLE IF EXISTS `catalog_categories`;
  713. /*!40101 SET @saved_cs_client = @@character_set_client */;
  714. /*!40101 SET character_set_client = utf8 */;
  715. CREATE TABLE `catalog_categories` (
  716. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  717. `created_at` timestamp NULL DEFAULT NULL,
  718. `updated_at` timestamp NULL DEFAULT NULL,
  719. `deleted_at` timestamp NULL DEFAULT NULL,
  720. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  721. `companies` json DEFAULT NULL,
  722. PRIMARY KEY (`id`)
  723. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  724. /*!40101 SET character_set_client = @saved_cs_client */;
  725.  
  726. --
  727. -- Dumping data for table `catalog_categories`
  728. --
  729.  
  730. LOCK TABLES `catalog_categories` WRITE;
  731. /*!40000 ALTER TABLE `catalog_categories` DISABLE KEYS */;
  732. INSERT INTO `catalog_categories` VALUES (1,'2018-08-13 17:41:46','2018-08-13 17:41:46',NULL,'ערב','[1]'),(2,'2018-08-13 17:41:57','2018-08-13 17:41:57',NULL,'צהריים','[1]'),(3,'2018-08-13 17:49:41','2018-08-13 17:51:14',NULL,'כללי','[1]');
  733. /*!40000 ALTER TABLE `catalog_categories` ENABLE KEYS */;
  734. UNLOCK TABLES;
  735.  
  736. --
  737. -- Table structure for table `catalog_items`
  738. --
  739.  
  740. DROP TABLE IF EXISTS `catalog_items`;
  741. /*!40101 SET @saved_cs_client = @@character_set_client */;
  742. /*!40101 SET character_set_client = utf8 */;
  743. CREATE TABLE `catalog_items` (
  744. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  745. `created_at` timestamp NULL DEFAULT NULL,
  746. `updated_at` timestamp NULL DEFAULT NULL,
  747. `deleted_at` timestamp NULL DEFAULT NULL,
  748. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  749. `catalog_category_id` int(10) unsigned NOT NULL,
  750. `price_type` enum('per-unit','fixed') COLLATE utf8_unicode_ci NOT NULL,
  751. `price` double(8,2) NOT NULL,
  752. `description` text COLLATE utf8_unicode_ci,
  753. `currency` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ILS',
  754. PRIMARY KEY (`id`),
  755. KEY `catalog_items_catalog_category_id_index` (`catalog_category_id`)
  756. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  757. /*!40101 SET character_set_client = @saved_cs_client */;
  758.  
  759. --
  760. -- Dumping data for table `catalog_items`
  761. --
  762.  
  763. LOCK TABLES `catalog_items` WRITE;
  764. /*!40000 ALTER TABLE `catalog_items` DISABLE KEYS */;
  765. INSERT INTO `catalog_items` VALUES (1,'2018-08-13 17:43:10','2018-08-13 17:43:10',NULL,'מ� ה א-ה',2,'per-unit',125.00,NULL,'ILS'),(2,'2018-08-13 17:43:25','2018-08-13 17:48:50',NULL,'מ� ה שישי',2,'per-unit',145.00,NULL,'ILS'),(3,'2018-08-13 17:44:38','2018-08-13 17:46:31',NULL,'מ� ה מאי-אוקטובר',1,'per-unit',250.00,NULL,'ILS'),(4,'2018-08-13 17:46:45','2018-08-13 17:46:45',NULL,'מ� ה � ובמבר',1,'per-unit',230.00,NULL,'ILS'),(5,'2018-08-13 17:47:04','2018-08-13 17:47:04',NULL,'מ� ה דצמבר-פברואר',1,'per-unit',210.00,NULL,'ILS'),(6,'2018-08-13 17:47:19','2018-08-13 17:47:19',NULL,'מ� ה מרץ-אפריל',1,'per-unit',230.00,NULL,'ILS'),(7,'2018-08-13 17:48:43','2018-08-13 17:48:43',NULL,'מ� ה שישי צהריים',2,'per-unit',200.00,NULL,'ILS'),(8,'2018-08-13 17:50:11','2018-08-13 17:50:11',NULL,'הגברה תאורה ומסכים',3,'fixed',4000.00,NULL,'ILS'),(9,'2018-08-13 17:51:49','2018-08-13 17:51:49',NULL,'בר חוץ פרימיום',3,'per-unit',25.00,'מתייחס למי� ימום 200 איש','ILS'),(10,'2018-08-13 17:52:20','2018-08-13 17:52:20',NULL,'בר חוץ סופר פרימיום',3,'per-unit',35.00,NULL,'ILS'),(11,'2018-08-13 18:04:03','2018-08-13 18:04:03',NULL,'דמי חליצה',3,'fixed',1800.00,'ברמ� /ית ביחס של 1:80','ILS'),(12,'2018-08-13 18:07:02','2018-08-13 18:07:02',NULL,'בר לילה',3,'fixed',1500.00,NULL,'ILS'),(13,'2018-08-13 18:08:36','2018-08-13 18:08:36',NULL,'עמדה � וספת',3,'fixed',1500.00,NULL,'ILS');
  766. /*!40000 ALTER TABLE `catalog_items` ENABLE KEYS */;
  767. UNLOCK TABLES;
  768.  
  769. --
  770. -- Table structure for table `companies`
  771. --
  772.  
  773. DROP TABLE IF EXISTS `companies`;
  774. /*!40101 SET @saved_cs_client = @@character_set_client */;
  775. /*!40101 SET character_set_client = utf8 */;
  776. CREATE TABLE `companies` (
  777. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  778. `created_at` timestamp NULL DEFAULT NULL,
  779. `updated_at` timestamp NULL DEFAULT NULL,
  780. `deleted_at` timestamp NULL DEFAULT NULL,
  781. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  782. `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  783. `tax_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  784. `phone_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  785. `fax_number` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  786. `callcenter_provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  787. `callcenter_config` json DEFAULT NULL,
  788. `calendar_colors` json NOT NULL,
  789. `system_sms_source_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  790. `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  791. `accounting_provider_user_id` int(10) unsigned DEFAULT NULL,
  792. `accounting_provider_business_id` text COLLATE utf8_unicode_ci,
  793. `foreign_crm_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  794. `payable` tinyint(1) NOT NULL DEFAULT '0',
  795. `inviteme_hall_id` int(11) DEFAULT NULL,
  796. PRIMARY KEY (`id`),
  797. KEY `companies_accounting_provider_user_id_index` (`accounting_provider_user_id`),
  798. KEY `companies_foreign_crm_id_index` (`foreign_crm_id`),
  799. KEY `companies_inviteme_hall_id_index` (`inviteme_hall_id`)
  800. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  801. /*!40101 SET character_set_client = @saved_cs_client */;
  802.  
  803. --
  804. -- Dumping data for table `companies`
  805. --
  806.  
  807. LOCK TABLES `companies` WRITE;
  808. /*!40000 ALTER TABLE `companies` DISABLE KEYS */;
  809. INSERT INTO `companies` VALUES (1,'2018-08-13 17:32:41','2018-08-13 18:54:33',NULL,'AMORE','בן ציון גליס 28, פתח תקווה','515686467','035600345',NULL,NULL,NULL,'{\"other\": \"#000\", \"border\": \"#000\", \"locked\": \"#000\", \"event.offer\": \"#000\", \"event.closed\": \"#04b518\", \"event.canceled\": \"#000\", \"event.interested\": \"#000000\", \"pending.contract.sign\": \"#000\"}',NULL,'hall',NULL,NULL,NULL,0,86);
  810. /*!40000 ALTER TABLE `companies` ENABLE KEYS */;
  811. UNLOCK TABLES;
  812.  
  813. --
  814. -- Table structure for table `company_subscriptions`
  815. --
  816.  
  817. DROP TABLE IF EXISTS `company_subscriptions`;
  818. /*!40101 SET @saved_cs_client = @@character_set_client */;
  819. /*!40101 SET character_set_client = utf8 */;
  820. CREATE TABLE `company_subscriptions` (
  821. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  822. `created_at` timestamp NULL DEFAULT NULL,
  823. `updated_at` timestamp NULL DEFAULT NULL,
  824. `deleted_at` timestamp NULL DEFAULT NULL,
  825. `company_id` int(10) unsigned NOT NULL,
  826. `crm_plan_id` int(10) unsigned NOT NULL,
  827. `start_at` datetime NOT NULL,
  828. `ends_at` datetime NOT NULL,
  829. `data` json DEFAULT NULL,
  830. `status` enum('pending','active','suspended','cancelled','ends') COLLATE utf8_unicode_ci NOT NULL,
  831. PRIMARY KEY (`id`),
  832. KEY `company_subscriptions_company_id_index` (`company_id`),
  833. KEY `company_subscriptions_crm_plan_id_index` (`crm_plan_id`)
  834. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  835. /*!40101 SET character_set_client = @saved_cs_client */;
  836.  
  837. --
  838. -- Dumping data for table `company_subscriptions`
  839. --
  840.  
  841. LOCK TABLES `company_subscriptions` WRITE;
  842. /*!40000 ALTER TABLE `company_subscriptions` DISABLE KEYS */;
  843. /*!40000 ALTER TABLE `company_subscriptions` ENABLE KEYS */;
  844. UNLOCK TABLES;
  845.  
  846. --
  847. -- Table structure for table `contacts`
  848. --
  849.  
  850. DROP TABLE IF EXISTS `contacts`;
  851. /*!40101 SET @saved_cs_client = @@character_set_client */;
  852. /*!40101 SET character_set_client = utf8 */;
  853. CREATE TABLE `contacts` (
  854. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  855. `deleted_at` timestamp NULL DEFAULT NULL,
  856. `created_at` timestamp NULL DEFAULT NULL,
  857. `updated_at` timestamp NULL DEFAULT NULL,
  858. `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  859. `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  860. `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  861. `mobile_phone_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  862. `landline_phone_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  863. `fax_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  864. `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  865. `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  866. `identity_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  867. `gender` enum('male','female') COLLATE utf8_unicode_ci NOT NULL,
  868. `company_id` int(10) unsigned DEFAULT NULL,
  869. PRIMARY KEY (`id`),
  870. KEY `contacts_company_id_index` (`company_id`)
  871. ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  872. /*!40101 SET character_set_client = @saved_cs_client */;
  873.  
  874. --
  875. -- Dumping data for table `contacts`
  876. --
  877.  
  878. LOCK TABLES `contacts` WRITE;
  879. /*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
  880. INSERT INTO `contacts` VALUES (1,NULL,'2018-08-13 18:32:10','2018-08-13 18:32:10','� ת� אל','אדרי',NULL,'0502498900',NULL,NULL,NULL,NULL,NULL,'male',1),(2,NULL,'2018-08-13 18:43:39','2018-08-13 18:43:39','דגכדגכדגכ','דגכדגכ',NULL,'0502498900',NULL,NULL,NULL,NULL,NULL,'male',1),(3,NULL,'2018-08-13 19:41:25','2018-08-13 19:41:25','מיטל','שומחייב','meitalfi@hotmail.com','0545605819',NULL,NULL,NULL,'הס משה 8 פתח תקווה','033498973','male',1),(4,NULL,'2018-08-13 19:41:25','2018-08-13 19:41:25','אימרן','שומחייב',NULL,'0545607489',NULL,NULL,NULL,NULL,'323226274','male',1),(5,NULL,'2018-08-13 20:01:40','2018-08-13 20:01:40','גלית','עי� ת','mali.einat95@gmail.com','0502017001',NULL,NULL,NULL,'הרב צעירי 10פתח תקווה','31787815','male',1),(6,NULL,'2018-08-13 20:01:40','2018-08-13 20:01:40','עופר','עי� ת',NULL,'0502017000',NULL,NULL,NULL,NULL,'024375784','male',1),(7,NULL,'2018-08-13 20:41:14','2018-08-13 20:41:14','אלבי� ה','קפרוב','axlen1989@gmail.com','0547752477',NULL,NULL,NULL,'יוסף ספיר 48','322113218','male',1),(8,NULL,'2018-08-13 20:41:14','2018-08-13 20:41:14','אדוארד','י� גלטוב',NULL,'0545205965',NULL,NULL,NULL,NULL,'326838976','male',1),(9,NULL,'2018-08-13 21:13:58','2018-08-13 21:13:58','שגיא','052-5404540',NULL,'0525404540',NULL,NULL,NULL,NULL,NULL,'male',NULL),(24,NULL,'2018-08-14 18:36:00','2018-08-14 18:36:00','גדש','גדש',NULL,'123123',NULL,NULL,NULL,NULL,NULL,'male',NULL),(25,NULL,'2018-08-14 18:37:10','2018-08-14 18:37:10','זסב','שדג',NULL,'-',NULL,NULL,NULL,NULL,NULL,'male',NULL),(30,NULL,'2018-08-14 18:59:26','2018-08-14 18:59:26','רו� י','רו� י',NULL,'0546870019',NULL,NULL,NULL,NULL,NULL,'male',1),(31,NULL,'2018-08-14 18:59:26','2018-08-14 18:59:26','מורן','מורן',NULL,'123123123',NULL,NULL,NULL,NULL,NULL,'male',1),(32,NULL,'2018-08-14 18:59:45','2018-08-14 18:59:45','רו� לי','רו� לי',NULL,'0546870019',NULL,NULL,NULL,NULL,NULL,'male',1),(33,NULL,'2018-08-14 19:03:02','2018-08-14 19:03:02','גילה ובועז',NULL,NULL,'0547107188',NULL,NULL,NULL,NULL,NULL,'male',NULL),(34,NULL,'2018-08-14 19:08:00','2018-08-14 19:08:00','� ועה שרמן',NULL,NULL,'0558813132',NULL,NULL,NULL,NULL,NULL,'male',1),(35,NULL,'2018-08-14 19:08:00','2018-08-14 19:08:00','עומרי רחמים',NULL,NULL,'0545287879',NULL,NULL,NULL,NULL,NULL,'male',1),(36,NULL,'2018-08-15 17:07:11','2018-08-15 17:07:11','קרן וליעד',NULL,NULL,'0504445782',NULL,NULL,NULL,NULL,NULL,'male',1),(37,NULL,'2018-08-15 19:26:03','2018-08-15 19:26:03','איל� ית',NULL,NULL,'0526515127',NULL,NULL,NULL,NULL,NULL,'male',1),(38,NULL,'2018-08-17 14:07:02','2018-08-17 14:07:02','רותם ושרון',NULL,NULL,'0502331155',NULL,NULL,NULL,NULL,NULL,'male',1),(39,NULL,'2018-08-19 16:25:27','2018-08-19 16:25:27','הילה מימון',NULL,NULL,'0586225231',NULL,NULL,NULL,NULL,NULL,'male',NULL),(40,NULL,'2018-08-19 17:30:49','2018-08-19 17:30:49','איתמר',NULL,NULL,'0503764224',NULL,NULL,NULL,NULL,NULL,'male',1),(41,NULL,'2018-08-20 19:28:39','2018-08-20 19:28:39','שימרית','דוד','shimrit@shtva.xo.il','0526666897',NULL,NULL,NULL,'כץ 84 פתח תקווה','065956971','male',1),(42,NULL,'2018-08-21 16:17:40','2018-08-21 16:17:40','יוכי',NULL,NULL,'0526595538',NULL,NULL,NULL,NULL,NULL,'male',1),(43,NULL,'2018-08-21 16:44:22','2018-08-21 16:44:22','פרח',NULL,NULL,'0527829504',NULL,NULL,NULL,NULL,NULL,'male',1),(44,NULL,'2018-08-21 21:40:34','2018-08-21 21:40:34','שרון',NULL,NULL,'0507391329',NULL,NULL,NULL,NULL,NULL,'male',1),(45,NULL,'2018-08-21 21:40:34','2018-08-21 21:40:34','שרון',NULL,NULL,'0507391329',NULL,NULL,NULL,NULL,NULL,'male',1);
  881. /*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
  882. UNLOCK TABLES;
  883.  
  884. --
  885. -- Table structure for table `email_messages`
  886. --
  887.  
  888. DROP TABLE IF EXISTS `email_messages`;
  889. /*!40101 SET @saved_cs_client = @@character_set_client */;
  890. /*!40101 SET character_set_client = utf8 */;
  891. CREATE TABLE `email_messages` (
  892. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  893. `created_at` timestamp NULL DEFAULT NULL,
  894. `updated_at` timestamp NULL DEFAULT NULL,
  895. `deleted_at` timestamp NULL DEFAULT NULL,
  896. `to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  897. `contact_id` int(10) unsigned DEFAULT NULL,
  898. `content` text COLLATE utf8_unicode_ci NOT NULL,
  899. PRIMARY KEY (`id`),
  900. KEY `email_messages_contact_id_index` (`contact_id`)
  901. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  902. /*!40101 SET character_set_client = @saved_cs_client */;
  903.  
  904. --
  905. -- Dumping data for table `email_messages`
  906. --
  907.  
  908. LOCK TABLES `email_messages` WRITE;
  909. /*!40000 ALTER TABLE `email_messages` DISABLE KEYS */;
  910. /*!40000 ALTER TABLE `email_messages` ENABLE KEYS */;
  911. UNLOCK TABLES;
  912.  
  913. --
  914. -- Table structure for table `feed_activities`
  915. --
  916.  
  917. DROP TABLE IF EXISTS `feed_activities`;
  918. /*!40101 SET @saved_cs_client = @@character_set_client */;
  919. /*!40101 SET character_set_client = utf8 */;
  920. CREATE TABLE `feed_activities` (
  921. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  922. `created_at` timestamp NULL DEFAULT NULL,
  923. `updated_at` timestamp NULL DEFAULT NULL,
  924. `deleted_at` timestamp NULL DEFAULT NULL,
  925. `related_model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  926. `related_model_id` int(10) unsigned NOT NULL,
  927. `owner_model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  928. `owner_model_id` int(10) unsigned NOT NULL,
  929. `user_id` int(10) unsigned DEFAULT NULL,
  930. PRIMARY KEY (`id`),
  931. KEY `feed_activities_related_model_type_index` (`related_model_type`),
  932. KEY `feed_activities_related_model_id_index` (`related_model_id`),
  933. KEY `feed_activities_owner_model_type_index` (`owner_model_type`),
  934. KEY `feed_activities_owner_model_id_index` (`owner_model_id`),
  935. KEY `feed_activities_user_id_index` (`user_id`)
  936. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  937. /*!40101 SET character_set_client = @saved_cs_client */;
  938.  
  939. --
  940. -- Dumping data for table `feed_activities`
  941. --
  942.  
  943. LOCK TABLES `feed_activities` WRITE;
  944. /*!40000 ALTER TABLE `feed_activities` DISABLE KEYS */;
  945. INSERT INTO `feed_activities` VALUES (1,'2018-08-13 18:36:59','2018-08-13 18:36:59',NULL,'App\\Models\\Tenant\\CrmHall\\Note',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',2,1),(2,'2018-08-13 18:37:46','2018-08-13 18:37:46',NULL,'App\\Models\\Tenant\\CrmHall\\Task',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',2,1),(3,'2018-08-13 18:39:38','2018-08-13 18:39:38',NULL,'App\\Models\\Tenant\\Shared\\SmsMessage',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',2,1),(4,'2018-08-13 18:40:06','2018-08-13 18:40:06',NULL,'App\\Models\\Tenant\\CrmHall\\File',1,'App\\Models\\Tenant\\CrmHall\\CalendarItem',2,1),(5,'2018-08-13 19:10:43','2018-08-13 19:10:43',NULL,'App\\Models\\Tenant\\Shared\\SmsMessage',2,'App\\Models\\Tenant\\CrmHall\\CalendarItem',3,1),(6,'2018-08-13 21:12:18','2018-08-13 21:12:18',NULL,'App\\Models\\Tenant\\CrmHall\\Task',2,'App\\Models\\Tenant\\CrmHall\\CalendarItem',6,1),(7,'2018-08-14 19:04:17','2018-08-14 19:04:17',NULL,'App\\Models\\Tenant\\CrmHall\\Note',2,'App\\Models\\Tenant\\CrmHall\\CalendarItem',37,1),(8,'2018-08-14 19:05:10','2018-08-14 19:05:10',NULL,'App\\Models\\Tenant\\CrmHall\\Task',3,'App\\Models\\Tenant\\CrmHall\\CalendarItem',37,1),(9,'2018-08-14 19:08:33','2018-08-14 19:08:33',NULL,'App\\Models\\Tenant\\CrmHall\\Note',3,'App\\Models\\Tenant\\CrmHall\\CalendarItem',39,1),(10,'2018-08-14 19:09:53','2018-08-14 19:09:53',NULL,'App\\Models\\Tenant\\CrmHall\\Task',4,'App\\Models\\Tenant\\CrmHall\\CalendarItem',39,1),(11,'2018-08-14 20:45:56','2018-08-14 20:45:56',NULL,'App\\Models\\Tenant\\CrmHall\\Note',4,'App\\Models\\Tenant\\CrmHall\\CalendarItem',8,1),(12,'2018-08-14 20:46:49','2018-08-14 20:46:49',NULL,'App\\Models\\Tenant\\CrmHall\\Task',5,'App\\Models\\Tenant\\CrmHall\\CalendarItem',8,1),(13,'2018-08-15 19:27:32','2018-08-15 19:27:32',NULL,'App\\Models\\Tenant\\CrmHall\\Task',6,'App\\Models\\Tenant\\CrmHall\\CalendarItem',43,1),(14,'2018-08-16 16:58:53','2018-08-16 16:58:53',NULL,'App\\Models\\Tenant\\CrmHall\\Note',5,'App\\Models\\Tenant\\CrmHall\\CalendarItem',43,1),(15,'2018-08-16 16:59:36','2018-08-16 16:59:36',NULL,'App\\Models\\Tenant\\CrmHall\\Task',7,'App\\Models\\Tenant\\CrmHall\\CalendarItem',43,1),(16,'2018-08-17 14:08:34','2018-08-17 14:08:34',NULL,'App\\Models\\Tenant\\CrmHall\\Note',6,'App\\Models\\Tenant\\CrmHall\\CalendarItem',45,1),(17,'2018-08-19 16:56:34','2018-08-19 16:56:34',NULL,'App\\Models\\Tenant\\CrmHall\\Note',7,'App\\Models\\Tenant\\CrmHall\\CalendarItem',8,1),(18,'2018-08-19 17:31:55','2018-08-19 17:31:55',NULL,'App\\Models\\Tenant\\CrmHall\\Task',8,'App\\Models\\Tenant\\CrmHall\\CalendarItem',50,1),(19,'2018-08-19 18:09:46','2018-08-19 18:09:46',NULL,'App\\Models\\Tenant\\CrmHall\\Note',8,'App\\Models\\Tenant\\CrmHall\\CalendarItem',41,1),(20,'2018-08-19 18:10:39','2018-08-19 18:10:39',NULL,'App\\Models\\Tenant\\CrmHall\\Task',9,'App\\Models\\Tenant\\CrmHall\\CalendarItem',41,1),(21,'2018-08-19 20:47:10','2018-08-19 20:47:10',NULL,'App\\Models\\Tenant\\CrmHall\\Note',9,'App\\Models\\Tenant\\CrmHall\\CalendarItem',35,1),(22,'2018-08-19 20:48:01','2018-08-19 20:48:01',NULL,'App\\Models\\Tenant\\CrmHall\\Task',10,'App\\Models\\Tenant\\CrmHall\\CalendarItem',35,1),(23,'2018-08-19 22:19:06','2018-08-19 22:19:06',NULL,'App\\Models\\Tenant\\CrmHall\\Note',10,'App\\Models\\Tenant\\CrmHall\\CalendarItem',45,1),(24,'2018-08-21 19:49:26','2018-08-21 19:49:26',NULL,'App\\Models\\Tenant\\CrmHall\\Note',11,'App\\Models\\Tenant\\CrmHall\\CalendarItem',48,1),(25,'2018-08-21 20:41:15','2018-08-21 20:41:15',NULL,'App\\Models\\Tenant\\CrmHall\\Note',12,'App\\Models\\Tenant\\CrmHall\\CalendarItem',55,1),(26,'2018-08-21 20:42:07','2018-08-21 20:42:07',NULL,'App\\Models\\Tenant\\CrmHall\\Task',11,'App\\Models\\Tenant\\CrmHall\\CalendarItem',55,1),(27,'2018-08-21 21:41:10','2018-08-21 21:41:10',NULL,'App\\Models\\Tenant\\CrmHall\\Note',13,'App\\Models\\Tenant\\CrmHall\\CalendarItem',61,1),(28,'2018-08-21 21:42:02','2018-08-21 21:42:02',NULL,'App\\Models\\Tenant\\CrmHall\\Task',12,'App\\Models\\Tenant\\CrmHall\\CalendarItem',61,1);
  946. /*!40000 ALTER TABLE `feed_activities` ENABLE KEYS */;
  947. UNLOCK TABLES;
  948.  
  949. --
  950. -- Table structure for table `feed_activity_comments`
  951. --
  952.  
  953. DROP TABLE IF EXISTS `feed_activity_comments`;
  954. /*!40101 SET @saved_cs_client = @@character_set_client */;
  955. /*!40101 SET character_set_client = utf8 */;
  956. CREATE TABLE `feed_activity_comments` (
  957. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  958. `created_at` timestamp NULL DEFAULT NULL,
  959. `updated_at` timestamp NULL DEFAULT NULL,
  960. `deleted_at` timestamp NULL DEFAULT NULL,
  961. `feed_activity_id` int(10) unsigned NOT NULL,
  962. `user_id` int(10) unsigned NOT NULL,
  963. `content` text COLLATE utf8_unicode_ci NOT NULL,
  964. PRIMARY KEY (`id`),
  965. KEY `feed_activity_comments_feed_activity_id_index` (`feed_activity_id`),
  966. KEY `feed_activity_comments_user_id_index` (`user_id`)
  967. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  968. /*!40101 SET character_set_client = @saved_cs_client */;
  969.  
  970. --
  971. -- Dumping data for table `feed_activity_comments`
  972. --
  973.  
  974. LOCK TABLES `feed_activity_comments` WRITE;
  975. /*!40000 ALTER TABLE `feed_activity_comments` DISABLE KEYS */;
  976. INSERT INTO `feed_activity_comments` VALUES (1,'2018-08-13 18:37:13','2018-08-13 18:37:13',NULL,1,1,'עכיעכיכעיכיכ');
  977. /*!40000 ALTER TABLE `feed_activity_comments` ENABLE KEYS */;
  978. UNLOCK TABLES;
  979.  
  980. --
  981. -- Table structure for table `feed_followers`
  982. --
  983.  
  984. DROP TABLE IF EXISTS `feed_followers`;
  985. /*!40101 SET @saved_cs_client = @@character_set_client */;
  986. /*!40101 SET character_set_client = utf8 */;
  987. CREATE TABLE `feed_followers` (
  988. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  989. `created_at` timestamp NULL DEFAULT NULL,
  990. `updated_at` timestamp NULL DEFAULT NULL,
  991. `deleted_at` timestamp NULL DEFAULT NULL,
  992. `owner_model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  993. `owner_model_id` int(10) unsigned NOT NULL,
  994. `user_id` int(10) unsigned NOT NULL,
  995. PRIMARY KEY (`id`),
  996. KEY `feed_followers_owner_model_type_index` (`owner_model_type`),
  997. KEY `feed_followers_owner_model_id_index` (`owner_model_id`),
  998. KEY `feed_followers_user_id_index` (`user_id`)
  999. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1000. /*!40101 SET character_set_client = @saved_cs_client */;
  1001.  
  1002. --
  1003. -- Dumping data for table `feed_followers`
  1004. --
  1005.  
  1006. LOCK TABLES `feed_followers` WRITE;
  1007. /*!40000 ALTER TABLE `feed_followers` DISABLE KEYS */;
  1008. /*!40000 ALTER TABLE `feed_followers` ENABLE KEYS */;
  1009. UNLOCK TABLES;
  1010.  
  1011. --
  1012. -- Table structure for table `files`
  1013. --
  1014.  
  1015. DROP TABLE IF EXISTS `files`;
  1016. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1017. /*!40101 SET character_set_client = utf8 */;
  1018. CREATE TABLE `files` (
  1019. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1020. `created_at` timestamp NULL DEFAULT NULL,
  1021. `updated_at` timestamp NULL DEFAULT NULL,
  1022. `deleted_at` timestamp NULL DEFAULT NULL,
  1023. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1024. `original_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1025. `extension` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1026. `size` double(8,2) NOT NULL,
  1027. `description` text COLLATE utf8_unicode_ci,
  1028. PRIMARY KEY (`id`)
  1029. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1030. /*!40101 SET character_set_client = @saved_cs_client */;
  1031.  
  1032. --
  1033. -- Dumping data for table `files`
  1034. --
  1035.  
  1036. LOCK TABLES `files` WRITE;
  1037. /*!40000 ALTER TABLE `files` DISABLE KEYS */;
  1038. INSERT INTO `files` VALUES (1,'2018-08-13 18:40:06','2018-08-13 18:40:06',NULL,'5b71a656ac6af.jpg','קבלת פ� ים 3 .jpg','jpg',302.05,'שדגשדגש');
  1039. /*!40000 ALTER TABLE `files` ENABLE KEYS */;
  1040. UNLOCK TABLES;
  1041.  
  1042. --
  1043. -- Table structure for table `join_sources`
  1044. --
  1045.  
  1046. DROP TABLE IF EXISTS `join_sources`;
  1047. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1048. /*!40101 SET character_set_client = utf8 */;
  1049. CREATE TABLE `join_sources` (
  1050. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1051. `created_at` timestamp NULL DEFAULT NULL,
  1052. `updated_at` timestamp NULL DEFAULT NULL,
  1053. `deleted_at` timestamp NULL DEFAULT NULL,
  1054. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1055. `ref_phone_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1056. `comments` text COLLATE utf8_unicode_ci,
  1057. PRIMARY KEY (`id`)
  1058. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1059. /*!40101 SET character_set_client = @saved_cs_client */;
  1060.  
  1061. --
  1062. -- Dumping data for table `join_sources`
  1063. --
  1064.  
  1065. LOCK TABLES `join_sources` WRITE;
  1066. /*!40000 ALTER TABLE `join_sources` DISABLE KEYS */;
  1067. INSERT INTO `join_sources` VALUES (1,'2018-08-13 17:32:40','2018-08-13 17:32:40',NULL,'אתר אי� טר� ט',NULL,NULL),(2,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'היי� ו באירוע',NULL,NULL),(3,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'המלצה מחבר',NULL,NULL),(4,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'וואלה מזל טוב',NULL,NULL),(5,'2018-08-13 17:32:41','2018-08-13 17:53:25','2018-08-13 17:53:25','איזיווד',NULL,NULL),(6,'2018-08-13 17:53:37','2018-08-13 17:53:37',NULL,'פייסבוק',NULL,NULL),(7,'2018-08-13 17:53:51','2018-08-13 17:53:51',NULL,'גוגל',NULL,NULL);
  1068. /*!40000 ALTER TABLE `join_sources` ENABLE KEYS */;
  1069. UNLOCK TABLES;
  1070.  
  1071. --
  1072. -- Table structure for table `landing_pages`
  1073. --
  1074.  
  1075. DROP TABLE IF EXISTS `landing_pages`;
  1076. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1077. /*!40101 SET character_set_client = utf8 */;
  1078. CREATE TABLE `landing_pages` (
  1079. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1080. `created_at` timestamp NULL DEFAULT NULL,
  1081. `updated_at` timestamp NULL DEFAULT NULL,
  1082. `deleted_at` timestamp NULL DEFAULT NULL,
  1083. `company_id` int(10) unsigned DEFAULT NULL,
  1084. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1085. `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1086. `components` json DEFAULT NULL,
  1087. PRIMARY KEY (`id`),
  1088. KEY `landing_pages_company_id_index` (`company_id`),
  1089. KEY `landing_pages_type_index` (`type`)
  1090. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1091. /*!40101 SET character_set_client = @saved_cs_client */;
  1092.  
  1093. --
  1094. -- Dumping data for table `landing_pages`
  1095. --
  1096.  
  1097. LOCK TABLES `landing_pages` WRITE;
  1098. /*!40000 ALTER TABLE `landing_pages` DISABLE KEYS */;
  1099. INSERT INTO `landing_pages` VALUES (1,'2018-08-13 17:32:43','2018-08-17 11:45:32',NULL,1,'מי� יסייט','minisite','[{\"name\": \"header_photo\", \"photo_url\": \"5b731d74a0ae4.jpg\"}, {\"name\": \"header_sticky\", \"content\": \"אולם אירועים AMORE\"}, {\"data\": [{\"icon\": \"group\", \"text\": \"400 מקומות\"}, {\"icon\": \"fastfood\", \"text\": \"כשרות רב� ות (אפשרות בשרים חלק)\"}, {\"icon\": \"place\", \"text\": \"בן ציון גליס 28, פתח תקווה\"}], \"name\": \"light_data\"}, {\"name\": \"paragraph\", \"header\": \"אודות AMORE\", \"content\": \"<p class=\\\"MsoNormal\\\" dir=\\\"RTL\\\" style=\\\"margin: 0in 0in 8pt; color: rgb(34, 34, 34); text-align: right; direction: rtl; unicode-bidi: embed; line-height: 15.6933px; font-size: 11pt; font-family: Calibri, sans-serif;\\\"><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\"><b>תתכו� � ו להתאהב...</b></span></p><p class=\\\"MsoNormal\\\" dir=\\\"RTL\\\" style=\\\"margin: 0in 0in 8pt; color: rgb(34, 34, 34); text-align: right; direction: rtl; unicode-bidi: embed; line-height: 15.6933px; font-size: 11pt; font-family: Calibri, sans-serif;\\\"><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\">בלב איזור הבילויים והמסחר של אזור התעשיה המתחדש באם המושבות, פתח תקווה הקמ� ו את&nbsp;</span><span dir=\\\"LTR\\\">AMORE -&nbsp;</span><span dir=\\\"RTL\\\"></span><span dir=\\\"RTL\\\"></span><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\"><span dir=\\\"RTL\\\"></span><span dir=\\\"RTL\\\"></span>&nbsp;מתחם אירועים חדש המיועד&nbsp;</span><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\">לאירועים פרטיים ועסקיים של עד</span><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\">&nbsp;450 אורחים</span><span dir=\\\"LTR\\\"></span><span dir=\\\"LTR\\\"></span><span dir=\\\"LTR\\\"><span dir=\\\"LTR\\\"></span><span dir=\\\"LTR\\\"></span>.</span><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\"></span></p><p class=\\\"MsoNormal\\\" dir=\\\"RTL\\\" style=\\\"margin: 0in 0in 8pt; color: rgb(34, 34, 34); text-align: right; direction: rtl; unicode-bidi: embed; line-height: 15.6933px; font-size: 11pt; font-family: Calibri, sans-serif;\\\"><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\">המתחם משתרע על שטח של מעל 2000 מ”ר המעוצבים כ “גן אורב� י ירוק” יפהפה בשילוב אולם מרכזי לחוויה מסיבתית באווירה תל אביבית. &nbsp;</span><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\"></span></p><p class=\\\"MsoNormal\\\" dir=\\\"RTL\\\" style=\\\"margin: 0in 0in 8pt; color: rgb(34, 34, 34); text-align: right; direction: rtl; unicode-bidi: embed; line-height: 15.6933px; font-size: 11pt; font-family: Calibri, sans-serif;\\\"><span lang=\\\"HE\\\" style=\\\"font-family: Arial, sans-serif;\\\"><b>מספיקה הצצה חטופה כדי להרגיש את האווירה הייחודית והקסומה.</b></span></p>\"}, {\"name\": \"list\", \"header\": \"שירותי האולם ומידע � וסף\", \"categories\": [{\"name\": \"מתחם\", \"items\": [{\"label\": \"סוג המתחם\", \"value\": \"אולם וגן אירועים\"}, {\"label\": \"מספר אורחים\", \"value\": \"400\"}, {\"label\": \"כשרות\", \"value\": \"כשרות רב� ות (אפשרות בשרים חלק)\"}, {\"label\": \"רישיון עסק\", \"value\": \"בתוקף\"}]}, {\"name\": \"אפשרויות המתחם\", \"items\": [{\"label\": \"מיקום החופה\", \"value\": \"בקיץ- בגן פתוח, בחורף- הגן מקורה\"}, {\"label\": \"מיקום קבלת פ� ים\", \"value\": \"בקיץ- בגן פתוח, בחורף- הגן מקורה\"}, {\"label\": \"מיקום הארוחה\", \"value\": \"בתוך המב� ה\"}, {\"label\": \"תקופת פעילות\", \"value\": \"כל הש� ה\"}, {\"label\": \"מסכים והקר� ה\", \"value\": \"מול המתחם\"}]}, {\"name\": \"אירועים בסופ\\\"ש\", \"items\": [{\"label\": \"אירוע שישי צהריים\", \"value\": \"כן\"}]}, {\"name\": \"סוגי אירועים\", \"items\": [{\"label\": \"חתו� ה\", \"value\": \"כן\"}, {\"label\": \"בר/בת מצווה\", \"value\": \"כן\"}, {\"label\": \"ברית/ה\", \"value\": \"כן\"}, {\"label\": \"חי� ה\", \"value\": \"כן\"}, {\"label\": \"אירוע עסקי\", \"value\": \"כן\"}]}, {\"name\": \"המטבח\", \"items\": [{\"label\": \"קייטרי� ג\", \"value\": \"מטבח הבית\"}]}, {\"name\": \"שירותים � לווים\", \"items\": [{\"label\": \"� יקיון\", \"value\": \"לאורך כל האירוע\"}, {\"label\": \"אבטחה\", \"value\": \"לאורך כל האירוע\"}]}]}, {\"name\": \"photo_gallery\", \"header\": \"AMORE בתמו� ות\", \"photos\": [\"5b731d8799e08.jpg\", \"5b731d942a735.jpg\", \"5b731d9ec47b0.jpg\", \"5b731daf39024.jpg\"]}, {\"name\": \"navigation_block\", \"address\": \"בן ציון גליס 28, פתח תקווה\"}, {\"logo\": \"5b731dfcbf326.jpg\", \"name\": \"contact_us_sticky\", \"phone_number\": \"035600345\"}]');
  1100. /*!40000 ALTER TABLE `landing_pages` ENABLE KEYS */;
  1101. UNLOCK TABLES;
  1102.  
  1103. --
  1104. -- Table structure for table `leads`
  1105. --
  1106.  
  1107. DROP TABLE IF EXISTS `leads`;
  1108. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1109. /*!40101 SET character_set_client = utf8 */;
  1110. CREATE TABLE `leads` (
  1111. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1112. `created_at` timestamp NULL DEFAULT NULL,
  1113. `updated_at` timestamp NULL DEFAULT NULL,
  1114. `deleted_at` timestamp NULL DEFAULT NULL,
  1115. `full_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1116. `phone_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1117. `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1118. `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1119. `join_source_id` int(10) unsigned DEFAULT NULL,
  1120. `company_id` int(10) unsigned DEFAULT NULL,
  1121. `landing_page_id` int(10) unsigned DEFAULT NULL,
  1122. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  1123. `inviteme_event_id` int(10) unsigned DEFAULT NULL,
  1124. `status` enum('new','client','meeting','irrelevant.price','irrelevant.geo','irrelevant.guests_count','irrelevant.guest') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
  1125. `is_manual` tinyint(1) NOT NULL DEFAULT '1',
  1126. PRIMARY KEY (`id`),
  1127. KEY `leads_join_source_id_index` (`join_source_id`),
  1128. KEY `leads_company_id_index` (`company_id`),
  1129. KEY `leads_landing_page_id_index` (`landing_page_id`),
  1130. KEY `leads_calendar_item_id_index` (`calendar_item_id`),
  1131. KEY `leads_inviteme_event_id_index` (`inviteme_event_id`)
  1132. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1133. /*!40101 SET character_set_client = @saved_cs_client */;
  1134.  
  1135. --
  1136. -- Dumping data for table `leads`
  1137. --
  1138.  
  1139. LOCK TABLES `leads` WRITE;
  1140. /*!40000 ALTER TABLE `leads` DISABLE KEYS */;
  1141. /*!40000 ALTER TABLE `leads` ENABLE KEYS */;
  1142. UNLOCK TABLES;
  1143.  
  1144. --
  1145. -- Table structure for table `media`
  1146. --
  1147.  
  1148. DROP TABLE IF EXISTS `media`;
  1149. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1150. /*!40101 SET character_set_client = utf8 */;
  1151. CREATE TABLE `media` (
  1152. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1153. `model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1154. `model_id` bigint(20) unsigned NOT NULL,
  1155. `collection_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1156. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1157. `file_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1158. `mime_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1159. `disk` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1160. `size` int(10) unsigned NOT NULL,
  1161. `manipulations` json NOT NULL,
  1162. `custom_properties` json NOT NULL,
  1163. `responsive_images` json NOT NULL,
  1164. `order_column` int(10) unsigned DEFAULT NULL,
  1165. `created_at` timestamp NULL DEFAULT NULL,
  1166. `updated_at` timestamp NULL DEFAULT NULL,
  1167. PRIMARY KEY (`id`),
  1168. KEY `media_model_type_model_id_index` (`model_type`,`model_id`)
  1169. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1170. /*!40101 SET character_set_client = @saved_cs_client */;
  1171.  
  1172. --
  1173. -- Dumping data for table `media`
  1174. --
  1175.  
  1176. LOCK TABLES `media` WRITE;
  1177. /*!40000 ALTER TABLE `media` DISABLE KEYS */;
  1178. /*!40000 ALTER TABLE `media` ENABLE KEYS */;
  1179. UNLOCK TABLES;
  1180.  
  1181. --
  1182. -- Table structure for table `migrations`
  1183. --
  1184.  
  1185. DROP TABLE IF EXISTS `migrations`;
  1186. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1187. /*!40101 SET character_set_client = utf8 */;
  1188. CREATE TABLE `migrations` (
  1189. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1190. `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1191. `batch` int(11) NOT NULL,
  1192. PRIMARY KEY (`id`)
  1193. ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1194. /*!40101 SET character_set_client = @saved_cs_client */;
  1195.  
  1196. --
  1197. -- Dumping data for table `migrations`
  1198. --
  1199.  
  1200. LOCK TABLES `migrations` WRITE;
  1201. /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  1202. INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2018_04_03_122354_create_audits_table',1),(3,'2018_04_03_123908_create_media_table',1),(4,'2018_04_04_162655_create_user_sessions_table',1),(5,'2018_04_04_164220_create_user_verifications_table',1),(6,'2018_04_04_225749_create_permission_tables',1),(7,'2018_07_01_005052_create_activity_log_table',1),(8,'2018_07_01_034913_create_leads_table',1),(9,'2018_07_01_035534_create_landing_pages_table',1),(10,'2018_07_03_110522_create_feed_activites_table',1),(11,'2018_07_03_110729_create_feed_followers_table',1),(12,'2018_07_03_110821_create_feed_activity_comments_table',1),(13,'2018_07_10_044056_create_notifications_table',1),(14,'2018_07_22_144530_create_campaigns_table',1),(15,'2018_07_22_145016_create_campaign_deliveries_table',1),(16,'2018_07_30_174813_create_sms_templates_table',1),(17,'2018_04_03_184020_create_organizations_table',2),(18,'2018_04_05_231755_create_companies_table',2),(19,'2018_04_05_233929_create_tasks_table',2),(20,'2018_04_10_034628_create_join_sources_table',2),(21,'2018_04_10_050019_create_company_subscriptions_table',2),(22,'2018_04_10_051034_create_organization_cashiers_table',2),(23,'2018_04_10_052642_create_company_catalog_categories_table',2),(24,'2018_04_10_052801_create_company_catalog_items_table',2),(25,'2018_04_10_052937_create_company_shopping_carts_table',2),(26,'2018_04_10_053118_create_company_shopping_cart_catalog_items_table',2),(27,'2018_04_11_160610_create_organization_attaches_table',2),(28,'2018_04_11_162042_create_contacts_table',2),(29,'2018_04_11_182156_create_calendar_items_table',2),(30,'2018_04_11_185000_create_calendar_item_orders_table_table',2),(31,'2018_04_12_172903_create_calendar_items_contacts',2),(32,'2018_04_15_103055_create_users_companies_table',2),(33,'2018_04_15_103636_create_accounting_clients_table',2),(34,'2018_04_15_130613_create_calendar_item_activities_table',2),(35,'2018_04_15_144826_create_calendar_item_connections_table',2),(36,'2018_04_15_145218_create_calendar_item_date_options_table',2),(37,'2018_04_16_122626_create_calls_table',2),(38,'2018_04_17_002843_create_calendar_item_user_table',2),(39,'2018_04_17_013237_create_sms_messages_table',2),(40,'2018_06_02_153500_create_accounting_documents_table',2),(41,'2018_06_25_124031_create_calendar_item_order_menu_types_table',2),(42,'2018_06_25_124135_create_calendar_item_order_submission_types_table',2),(43,'2018_07_29_154939_create_calendar_notes_table',2),(44,'2018_07_31_163304_create_notes_table',2),(45,'2018_07_31_163424_create_email_messages_table',2),(46,'2018_07_31_163915_create_files_table',2);
  1203. /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  1204. UNLOCK TABLES;
  1205.  
  1206. --
  1207. -- Table structure for table `model_has_permissions`
  1208. --
  1209.  
  1210. DROP TABLE IF EXISTS `model_has_permissions`;
  1211. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1212. /*!40101 SET character_set_client = utf8 */;
  1213. CREATE TABLE `model_has_permissions` (
  1214. `permission_id` int(10) unsigned NOT NULL,
  1215. `model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1216. `model_id` bigint(20) unsigned NOT NULL,
  1217. PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  1218. KEY `model_has_permissions_model_type_model_id_index` (`model_type`,`model_id`),
  1219. CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
  1220. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1221. /*!40101 SET character_set_client = @saved_cs_client */;
  1222.  
  1223. --
  1224. -- Dumping data for table `model_has_permissions`
  1225. --
  1226.  
  1227. LOCK TABLES `model_has_permissions` WRITE;
  1228. /*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
  1229. /*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
  1230. UNLOCK TABLES;
  1231.  
  1232. --
  1233. -- Table structure for table `model_has_roles`
  1234. --
  1235.  
  1236. DROP TABLE IF EXISTS `model_has_roles`;
  1237. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1238. /*!40101 SET character_set_client = utf8 */;
  1239. CREATE TABLE `model_has_roles` (
  1240. `role_id` int(10) unsigned NOT NULL,
  1241. `model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1242. `model_id` bigint(20) unsigned NOT NULL,
  1243. PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  1244. KEY `model_has_roles_model_type_model_id_index` (`model_type`,`model_id`),
  1245. CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
  1246. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1247. /*!40101 SET character_set_client = @saved_cs_client */;
  1248.  
  1249. --
  1250. -- Dumping data for table `model_has_roles`
  1251. --
  1252.  
  1253. LOCK TABLES `model_has_roles` WRITE;
  1254. /*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
  1255. INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\Tenant\\Shared\\User',1),(2,'App\\Models\\Tenant\\Shared\\User',2),(1,'App\\Models\\Tenant\\Shared\\User',3);
  1256. /*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
  1257. UNLOCK TABLES;
  1258.  
  1259. --
  1260. -- Table structure for table `notes`
  1261. --
  1262.  
  1263. DROP TABLE IF EXISTS `notes`;
  1264. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1265. /*!40101 SET character_set_client = utf8 */;
  1266. CREATE TABLE `notes` (
  1267. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1268. `created_at` timestamp NULL DEFAULT NULL,
  1269. `updated_at` timestamp NULL DEFAULT NULL,
  1270. `deleted_at` timestamp NULL DEFAULT NULL,
  1271. `content` text COLLATE utf8_unicode_ci NOT NULL,
  1272. PRIMARY KEY (`id`)
  1273. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1274. /*!40101 SET character_set_client = @saved_cs_client */;
  1275.  
  1276. --
  1277. -- Dumping data for table `notes`
  1278. --
  1279.  
  1280. LOCK TABLES `notes` WRITE;
  1281. /*!40000 ALTER TABLE `notes` DISABLE KEYS */;
  1282. INSERT INTO `notes` VALUES (1,'2018-08-13 18:36:59','2018-08-13 18:36:59',NULL,'בלה בלה בלה'),(2,'2018-08-14 19:04:17','2018-08-14 19:04:17',NULL,'מתע� יי� ים לבר מצווה בחודש אוקטובר , הוצע 200 ש\"ח + 4000 ה.ת.מ .צריכה לבדוק מול אחיה ש� מצא בחו\"ל מתי מגיע'),(3,'2018-08-14 19:08:33','2018-08-14 19:08:33',NULL,'רוצים לבוא לראות אירוע'),(4,'2018-08-14 20:45:56','2018-08-14 20:45:56',NULL,'שוחחתי עימו אמר שלא יוכל להגיע היום , יהיה עימי בקשר לתיאום חוזר'),(5,'2018-08-16 16:58:53','2018-08-16 16:58:53',NULL,'לא עו� ה'),(6,'2018-08-17 14:08:34','2018-08-17 14:08:34',NULL,'הוצע 265 ש\"ח כולל הגברה תאורה מסכים ובר פרימיום כולל בר לילה ופי� וק בתפריט'),(7,'2018-08-19 16:56:34','2018-08-19 16:56:34',NULL,'לא עו� ה'),(8,'2018-08-19 18:09:46','2018-08-19 18:09:46',NULL,'היו בפגישה הוצע לחצי ש� ה הקרובה 200 לא כולל חמישי השאר רגיל , צריך להיות עמם בקשר לפ� י ה04/09 יגיעו לטעום את האוכל'),(9,'2018-08-19 20:47:09','2018-08-19 20:47:09',NULL,'מחיר השקה -הוצע 200 + 4000 מגיעים ב04/09 לתזכר לפ� י'),(10,'2018-08-19 22:19:05','2018-08-19 22:19:05',NULL,'לא הגיעו לפגישה ולא עו� ים'),(11,'2018-08-21 19:49:26','2018-08-21 19:49:26',NULL,'רוצים להגיע לראות אירוע ב04/09'),(12,'2018-08-21 20:41:15','2018-08-21 20:41:15',NULL,'מתע� יי� ת לחודש � ובמבר הוצע ל 150 מוזמ� ים גלאט מחפוד 215 + 4000 ש\"ח ה.ת.מ'),(13,'2018-08-21 21:41:10','2018-08-21 21:41:10',NULL,'הוצע כרגע מחירון , הובטח התגשמות במחיר , רוצים להגיע לראות אירוע ב04/09');
  1283. /*!40000 ALTER TABLE `notes` ENABLE KEYS */;
  1284. UNLOCK TABLES;
  1285.  
  1286. --
  1287. -- Table structure for table `notifications`
  1288. --
  1289.  
  1290. DROP TABLE IF EXISTS `notifications`;
  1291. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1292. /*!40101 SET character_set_client = utf8 */;
  1293. CREATE TABLE `notifications` (
  1294. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1295. `created_at` timestamp NULL DEFAULT NULL,
  1296. `updated_at` timestamp NULL DEFAULT NULL,
  1297. `deleted_at` timestamp NULL DEFAULT NULL,
  1298. `user_id` int(10) unsigned NOT NULL,
  1299. `deliver_at` datetime DEFAULT NULL,
  1300. `delivered` tinyint(1) NOT NULL DEFAULT '0',
  1301. `read` tinyint(1) NOT NULL DEFAULT '0',
  1302. `read_at` datetime DEFAULT NULL,
  1303. `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1304. `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1305. `related_model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1306. `related_model_id` int(10) unsigned NOT NULL,
  1307. `data` json DEFAULT NULL,
  1308. `channels` json DEFAULT NULL,
  1309. PRIMARY KEY (`id`),
  1310. KEY `notifications_user_id_index` (`user_id`),
  1311. KEY `notifications_related_model_type_index` (`related_model_type`),
  1312. KEY `notifications_related_model_id_index` (`related_model_id`)
  1313. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1314. /*!40101 SET character_set_client = @saved_cs_client */;
  1315.  
  1316. --
  1317. -- Dumping data for table `notifications`
  1318. --
  1319.  
  1320. LOCK TABLES `notifications` WRITE;
  1321. /*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
  1322. /*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
  1323. UNLOCK TABLES;
  1324.  
  1325. --
  1326. -- Table structure for table `organizations`
  1327. --
  1328.  
  1329. DROP TABLE IF EXISTS `organizations`;
  1330. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1331. /*!40101 SET character_set_client = utf8 */;
  1332. CREATE TABLE `organizations` (
  1333. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1334. `created_at` timestamp NULL DEFAULT NULL,
  1335. `updated_at` timestamp NULL DEFAULT NULL,
  1336. `deleted_at` timestamp NULL DEFAULT NULL,
  1337. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1338. `official_company_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1339. `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1340. `tax_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  1341. `phone_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  1342. `fax_number` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
  1343. `callcenter_provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1344. `callcenter_config` json DEFAULT NULL,
  1345. `meeting_color` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#6A6A6A',
  1346. `system_sms_source_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  1347. `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1348. PRIMARY KEY (`id`)
  1349. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1350. /*!40101 SET character_set_client = @saved_cs_client */;
  1351.  
  1352. --
  1353. -- Dumping data for table `organizations`
  1354. --
  1355.  
  1356. LOCK TABLES `organizations` WRITE;
  1357. /*!40000 ALTER TABLE `organizations` DISABLE KEYS */;
  1358. INSERT INTO `organizations` VALUES (1,'2018-08-13 17:32:41','2018-08-13 18:32:44',NULL,'AMORE','ש.ב הפקת אירועים בע״מ','בן ציון גליס 28, פתח תקווה','515686467','035600345',NULL,NULL,NULL,'#000000',NULL,NULL);
  1359. /*!40000 ALTER TABLE `organizations` ENABLE KEYS */;
  1360. UNLOCK TABLES;
  1361.  
  1362. --
  1363. -- Table structure for table `permissions`
  1364. --
  1365.  
  1366. DROP TABLE IF EXISTS `permissions`;
  1367. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1368. /*!40101 SET character_set_client = utf8 */;
  1369. CREATE TABLE `permissions` (
  1370. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1371. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1372. `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1373. `guard_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1374. `created_at` timestamp NULL DEFAULT NULL,
  1375. `updated_at` timestamp NULL DEFAULT NULL,
  1376. PRIMARY KEY (`id`)
  1377. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1378. /*!40101 SET character_set_client = @saved_cs_client */;
  1379.  
  1380. --
  1381. -- Dumping data for table `permissions`
  1382. --
  1383.  
  1384. LOCK TABLES `permissions` WRITE;
  1385. /*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
  1386. /*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
  1387. UNLOCK TABLES;
  1388.  
  1389. --
  1390. -- Table structure for table `role_has_permissions`
  1391. --
  1392.  
  1393. DROP TABLE IF EXISTS `role_has_permissions`;
  1394. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1395. /*!40101 SET character_set_client = utf8 */;
  1396. CREATE TABLE `role_has_permissions` (
  1397. `permission_id` int(10) unsigned NOT NULL,
  1398. `role_id` int(10) unsigned NOT NULL,
  1399. PRIMARY KEY (`permission_id`,`role_id`),
  1400. KEY `role_has_permissions_role_id_foreign` (`role_id`),
  1401. CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  1402. CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
  1403. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1404. /*!40101 SET character_set_client = @saved_cs_client */;
  1405.  
  1406. --
  1407. -- Dumping data for table `role_has_permissions`
  1408. --
  1409.  
  1410. LOCK TABLES `role_has_permissions` WRITE;
  1411. /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
  1412. /*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
  1413. UNLOCK TABLES;
  1414.  
  1415. --
  1416. -- Table structure for table `roles`
  1417. --
  1418.  
  1419. DROP TABLE IF EXISTS `roles`;
  1420. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1421. /*!40101 SET character_set_client = utf8 */;
  1422. CREATE TABLE `roles` (
  1423. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1424. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1425. `guard_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1426. `created_at` timestamp NULL DEFAULT NULL,
  1427. `updated_at` timestamp NULL DEFAULT NULL,
  1428. PRIMARY KEY (`id`)
  1429. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1430. /*!40101 SET character_set_client = @saved_cs_client */;
  1431.  
  1432. --
  1433. -- Dumping data for table `roles`
  1434. --
  1435.  
  1436. LOCK TABLES `roles` WRITE;
  1437. /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  1438. INSERT INTO `roles` VALUES (1,'מ� הל מערכת - AMORE','api','2018-08-13 17:32:41','2018-08-13 17:32:41'),(2,'סוכן - AMORE','api','2018-08-13 17:32:41','2018-08-13 17:32:41');
  1439. /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  1440. UNLOCK TABLES;
  1441.  
  1442. --
  1443. -- Table structure for table `shopping_cart_catalog_items`
  1444. --
  1445.  
  1446. DROP TABLE IF EXISTS `shopping_cart_catalog_items`;
  1447. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1448. /*!40101 SET character_set_client = utf8 */;
  1449. CREATE TABLE `shopping_cart_catalog_items` (
  1450. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1451. `created_at` timestamp NULL DEFAULT NULL,
  1452. `updated_at` timestamp NULL DEFAULT NULL,
  1453. `deleted_at` timestamp NULL DEFAULT NULL,
  1454. `shopping_cart_id` int(10) unsigned NOT NULL,
  1455. `catalog_item_id` int(10) unsigned NOT NULL,
  1456. `quantity` double(8,2) NOT NULL,
  1457. `price_type` enum('per-unit','fixed') COLLATE utf8_unicode_ci NOT NULL,
  1458. `price` double(8,2) NOT NULL,
  1459. PRIMARY KEY (`id`)
  1460. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1461. /*!40101 SET character_set_client = @saved_cs_client */;
  1462.  
  1463. --
  1464. -- Dumping data for table `shopping_cart_catalog_items`
  1465. --
  1466.  
  1467. LOCK TABLES `shopping_cart_catalog_items` WRITE;
  1468. /*!40000 ALTER TABLE `shopping_cart_catalog_items` DISABLE KEYS */;
  1469. INSERT INTO `shopping_cart_catalog_items` VALUES (1,'2018-08-13 18:03:06','2018-08-13 18:03:06',NULL,1,8,1.00,'fixed',4000.00),(2,'2018-08-13 18:03:06','2018-08-13 18:03:06',NULL,1,3,1.00,'per-unit',250.00);
  1470. /*!40000 ALTER TABLE `shopping_cart_catalog_items` ENABLE KEYS */;
  1471. UNLOCK TABLES;
  1472.  
  1473. --
  1474. -- Table structure for table `shopping_carts`
  1475. --
  1476.  
  1477. DROP TABLE IF EXISTS `shopping_carts`;
  1478. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1479. /*!40101 SET character_set_client = utf8 */;
  1480. CREATE TABLE `shopping_carts` (
  1481. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1482. `created_at` timestamp NULL DEFAULT NULL,
  1483. `updated_at` timestamp NULL DEFAULT NULL,
  1484. `deleted_at` timestamp NULL DEFAULT NULL,
  1485. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1486. `comments` text COLLATE utf8_unicode_ci,
  1487. `companies` json DEFAULT NULL,
  1488. PRIMARY KEY (`id`)
  1489. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1490. /*!40101 SET character_set_client = @saved_cs_client */;
  1491.  
  1492. --
  1493. -- Dumping data for table `shopping_carts`
  1494. --
  1495.  
  1496. LOCK TABLES `shopping_carts` WRITE;
  1497. /*!40000 ALTER TABLE `shopping_carts` DISABLE KEYS */;
  1498. INSERT INTO `shopping_carts` VALUES (1,'2018-08-13 18:03:06','2018-08-13 18:03:06',NULL,'חבילת ערב','חבילת ערב',NULL);
  1499. /*!40000 ALTER TABLE `shopping_carts` ENABLE KEYS */;
  1500. UNLOCK TABLES;
  1501.  
  1502. --
  1503. -- Table structure for table `sms_messages`
  1504. --
  1505.  
  1506. DROP TABLE IF EXISTS `sms_messages`;
  1507. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1508. /*!40101 SET character_set_client = utf8 */;
  1509. CREATE TABLE `sms_messages` (
  1510. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1511. `created_at` timestamp NULL DEFAULT NULL,
  1512. `updated_at` timestamp NULL DEFAULT NULL,
  1513. `deleted_at` timestamp NULL DEFAULT NULL,
  1514. `is_incoming` tinyint(1) NOT NULL,
  1515. `type` enum('sms','whatsapp') COLLATE utf8_unicode_ci NOT NULL,
  1516. `destination` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  1517. `text` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1518. `sender_user_id` int(10) unsigned DEFAULT NULL,
  1519. `company_id` int(10) unsigned DEFAULT NULL,
  1520. `contact_id` int(10) unsigned DEFAULT NULL,
  1521. `send_at` datetime DEFAULT NULL,
  1522. PRIMARY KEY (`id`),
  1523. KEY `sms_messages_sender_user_id_index` (`sender_user_id`),
  1524. KEY `sms_messages_company_id_index` (`company_id`),
  1525. KEY `sms_messages_contact_id_index` (`contact_id`)
  1526. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1527. /*!40101 SET character_set_client = @saved_cs_client */;
  1528.  
  1529. --
  1530. -- Dumping data for table `sms_messages`
  1531. --
  1532.  
  1533. LOCK TABLES `sms_messages` WRITE;
  1534. /*!40000 ALTER TABLE `sms_messages` DISABLE KEYS */;
  1535. INSERT INTO `sms_messages` VALUES (1,'2018-08-13 18:39:38','2018-08-13 18:39:38',NULL,0,'sms','0502498900','שדגשדגש',1,NULL,NULL,NULL),(2,'2018-08-13 19:10:43','2018-08-13 19:10:43',NULL,0,'sms','0502498900','asdasda',1,NULL,NULL,NULL);
  1536. /*!40000 ALTER TABLE `sms_messages` ENABLE KEYS */;
  1537. UNLOCK TABLES;
  1538.  
  1539. --
  1540. -- Table structure for table `sms_templates`
  1541. --
  1542.  
  1543. DROP TABLE IF EXISTS `sms_templates`;
  1544. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1545. /*!40101 SET character_set_client = utf8 */;
  1546. CREATE TABLE `sms_templates` (
  1547. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1548. `created_at` timestamp NULL DEFAULT NULL,
  1549. `updated_at` timestamp NULL DEFAULT NULL,
  1550. `deleted_at` timestamp NULL DEFAULT NULL,
  1551. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1552. `content` text COLLATE utf8_unicode_ci NOT NULL,
  1553. PRIMARY KEY (`id`)
  1554. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1555. /*!40101 SET character_set_client = @saved_cs_client */;
  1556.  
  1557. --
  1558. -- Dumping data for table `sms_templates`
  1559. --
  1560.  
  1561. LOCK TABLES `sms_templates` WRITE;
  1562. /*!40000 ALTER TABLE `sms_templates` DISABLE KEYS */;
  1563. /*!40000 ALTER TABLE `sms_templates` ENABLE KEYS */;
  1564. UNLOCK TABLES;
  1565.  
  1566. --
  1567. -- Table structure for table `tasks`
  1568. --
  1569.  
  1570. DROP TABLE IF EXISTS `tasks`;
  1571. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1572. /*!40101 SET character_set_client = utf8 */;
  1573. CREATE TABLE `tasks` (
  1574. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1575. `deleted_at` timestamp NULL DEFAULT NULL,
  1576. `created_at` timestamp NULL DEFAULT NULL,
  1577. `updated_at` timestamp NULL DEFAULT NULL,
  1578. `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1579. `description` text COLLATE utf8_unicode_ci,
  1580. `due_at` datetime DEFAULT NULL,
  1581. `list` enum('todo','in.progress','in.progress.advanced','in.progress.finishing','completed') COLLATE utf8_unicode_ci DEFAULT NULL,
  1582. `ui_position` int(11) NOT NULL,
  1583. `company_id` int(10) unsigned DEFAULT NULL,
  1584. `user_id` int(10) unsigned NOT NULL,
  1585. `appointed_user_id` int(10) unsigned DEFAULT NULL,
  1586. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  1587. `type` enum('email','fax','job','offer','other','phone','follow.up') COLLATE utf8_unicode_ci DEFAULT NULL,
  1588. PRIMARY KEY (`id`),
  1589. KEY `tasks_company_id_index` (`company_id`),
  1590. KEY `tasks_user_id_index` (`user_id`),
  1591. KEY `tasks_appointed_user_id_index` (`appointed_user_id`),
  1592. KEY `tasks_calendar_item_id_index` (`calendar_item_id`)
  1593. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1594. /*!40101 SET character_set_client = @saved_cs_client */;
  1595.  
  1596. --
  1597. -- Dumping data for table `tasks`
  1598. --
  1599.  
  1600. LOCK TABLES `tasks` WRITE;
  1601. /*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
  1602. INSERT INTO `tasks` VALUES (1,NULL,'2018-08-13 18:37:44','2018-08-13 18:37:44','לכתוב חוזה','חוזה מורחב','2018-08-15 12:00:00','todo',1,NULL,1,1,NULL,NULL),(2,NULL,'2018-08-13 21:12:17','2018-08-13 21:12:17','הבאת מקדמות','הבאת מקדמות','2018-08-20 17:00:00','todo',1,NULL,1,1,NULL,NULL),(3,NULL,'2018-08-14 19:05:10','2018-08-14 19:05:10','לבדוק מה קורה','לבדוק האם יש תשובות','2018-08-19 18:59:00','todo',1,NULL,1,1,NULL,NULL),(4,NULL,'2018-08-14 19:09:53','2018-08-14 19:09:53','ליצור קשר','ליצור קשר ולבדוק מה ע� יי� ים ולבדוק האם � יתן להביא לפגישה � וספת','2018-08-19 18:00:00','todo',1,NULL,1,1,NULL,NULL),(5,NULL,'2018-08-14 20:46:49','2018-08-14 20:46:49','לבדוק האם חזר','לבדוק האם יצר קשר , האמר שרוצה להגיע ביחד עם הבת זוג','2018-08-16 18:00:00','todo',1,NULL,1,1,NULL,NULL),(6,NULL,'2018-08-15 19:27:32','2018-08-15 19:27:32','לבדוק האם יצרה קשר ליתאום','מתע� יי� ת לגבי אירוע בחודש אוקטובר גלאט מחפוד , אמורה ליצור עימי קשר לתיאום פגישה','2018-08-16 16:30:00','todo',1,NULL,1,1,NULL,NULL),(7,NULL,'2018-08-16 16:59:36','2018-08-16 16:59:36','להתקשר שוב','להתקשר שוב','2018-08-17 10:00:00','todo',1,NULL,1,1,NULL,NULL),(8,NULL,'2018-08-19 17:31:54','2018-08-19 17:31:54','לבדוק מה ע� יי� ים','הכלה מצפת , צריך לחזור ולעדכן מה קורה','2018-08-23 16:00:00','todo',1,NULL,1,2,NULL,NULL),(9,NULL,'2018-08-19 18:10:39','2018-08-19 18:10:39','לבדוק האם מגיעים','לבדוק האם מגיעים לטעום , לתאם ב22:00','2018-09-02 16:00:00','todo',1,NULL,1,1,NULL,NULL),(10,NULL,'2018-08-19 20:48:01','2018-08-19 20:48:01','לתזכר פגישה','לתזכר לפ� י מגיעים ב20:00','2018-09-02 17:00:00','todo',1,NULL,1,1,NULL,NULL),(11,NULL,'2018-08-21 20:42:07','2018-08-21 20:42:07','מעקב','לראות מה ע� יי� ים','2018-08-23 18:59:00','todo',1,NULL,1,1,NULL,NULL),(12,NULL,'2018-08-21 21:42:02','2018-08-21 21:42:02','לבדוק','לבדוק אם מגיעים ב04/09','2018-09-02 18:01:00','todo',1,NULL,1,1,NULL,NULL);
  1603. /*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
  1604. UNLOCK TABLES;
  1605.  
  1606. --
  1607. -- Table structure for table `user_company`
  1608. --
  1609.  
  1610. DROP TABLE IF EXISTS `user_company`;
  1611. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1612. /*!40101 SET character_set_client = utf8 */;
  1613. CREATE TABLE `user_company` (
  1614. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1615. `deleted_at` timestamp NULL DEFAULT NULL,
  1616. `created_at` timestamp NULL DEFAULT NULL,
  1617. `updated_at` timestamp NULL DEFAULT NULL,
  1618. `user_id` int(10) unsigned NOT NULL,
  1619. `company_id` int(10) unsigned NOT NULL,
  1620. PRIMARY KEY (`id`),
  1621. KEY `user_company_user_id_index` (`user_id`),
  1622. KEY `user_company_company_id_index` (`company_id`)
  1623. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1624. /*!40101 SET character_set_client = @saved_cs_client */;
  1625.  
  1626. --
  1627. -- Dumping data for table `user_company`
  1628. --
  1629.  
  1630. LOCK TABLES `user_company` WRITE;
  1631. /*!40000 ALTER TABLE `user_company` DISABLE KEYS */;
  1632. INSERT INTO `user_company` VALUES (1,NULL,NULL,NULL,1,1),(2,NULL,NULL,NULL,2,1),(3,NULL,NULL,NULL,3,1);
  1633. /*!40000 ALTER TABLE `user_company` ENABLE KEYS */;
  1634. UNLOCK TABLES;
  1635.  
  1636. --
  1637. -- Table structure for table `user_sessions`
  1638. --
  1639.  
  1640. DROP TABLE IF EXISTS `user_sessions`;
  1641. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1642. /*!40101 SET character_set_client = utf8 */;
  1643. CREATE TABLE `user_sessions` (
  1644. `deleted_at` timestamp NULL DEFAULT NULL,
  1645. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1646. `created_at` timestamp NULL DEFAULT NULL,
  1647. `updated_at` timestamp NULL DEFAULT NULL,
  1648. `user_id` int(10) unsigned NOT NULL,
  1649. `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1650. `platform` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1651. `browser` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1652. `is_desktop` tinyint(1) NOT NULL,
  1653. `active` tinyint(1) NOT NULL,
  1654. `token_id` text COLLATE utf8_unicode_ci NOT NULL,
  1655. PRIMARY KEY (`id`),
  1656. KEY `user_sessions_user_id_index` (`user_id`)
  1657. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1658. /*!40101 SET character_set_client = @saved_cs_client */;
  1659.  
  1660. --
  1661. -- Dumping data for table `user_sessions`
  1662. --
  1663.  
  1664. LOCK TABLES `user_sessions` WRITE;
  1665. /*!40000 ALTER TABLE `user_sessions` DISABLE KEYS */;
  1666. INSERT INTO `user_sessions` VALUES (NULL,1,'2018-08-13 17:34:37','2018-08-13 17:34:37',1,'5.102.231.133','Windows','Chrome',1,1,'1'),(NULL,2,'2018-08-13 18:18:12','2018-08-13 18:18:12',1,'5.102.231.133','Windows','Chrome',1,1,'1'),(NULL,3,'2018-08-14 18:35:21','2018-08-14 18:35:21',1,'217.132.43.228','Linux','Chrome',1,1,'1'),(NULL,4,'2018-08-14 21:19:49','2018-08-14 21:19:49',1,'79.179.97.162','OS X','Chrome',1,1,'1'),(NULL,5,'2018-08-14 21:19:49','2018-08-14 21:19:49',1,'79.179.97.162','OS X','Chrome',1,1,'1'),(NULL,6,'2018-08-15 19:23:27','2018-08-15 19:23:27',1,'5.102.231.133','Windows','Chrome',1,1,'1'),(NULL,7,'2018-08-17 11:15:13','2018-08-17 11:15:13',1,'46.19.86.173','OS X','Chrome',1,1,'1'),(NULL,8,'2018-08-17 11:15:13','2018-08-17 11:15:13',1,'46.19.86.173','OS X','Chrome',1,1,'1'),(NULL,9,'2018-08-19 13:37:31','2018-08-19 13:37:31',1,'109.186.132.5','Linux','Chrome',1,1,'1'),(NULL,10,'2018-08-19 16:18:17','2018-08-19 16:18:17',1,'5.102.231.133','Windows','Chrome',1,1,'1'),(NULL,11,'2018-08-21 16:21:27','2018-08-21 16:21:27',1,'5.102.231.133','Windows','Chrome',1,1,'1'),(NULL,12,'2018-08-22 15:45:19','2018-08-22 15:45:19',1,'89.139.79.224','OS X','Chrome',1,1,'1'),(NULL,13,'2018-08-22 15:45:19','2018-08-22 15:45:19',1,'89.139.79.224','OS X','Chrome',1,1,'1');
  1667. /*!40000 ALTER TABLE `user_sessions` ENABLE KEYS */;
  1668. UNLOCK TABLES;
  1669.  
  1670. --
  1671. -- Table structure for table `user_verifications`
  1672. --
  1673.  
  1674. DROP TABLE IF EXISTS `user_verifications`;
  1675. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1676. /*!40101 SET character_set_client = utf8 */;
  1677. CREATE TABLE `user_verifications` (
  1678. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1679. `deleted_at` timestamp NULL DEFAULT NULL,
  1680. `created_at` timestamp NULL DEFAULT NULL,
  1681. `updated_at` timestamp NULL DEFAULT NULL,
  1682. `code` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  1683. `user_id` int(10) unsigned NOT NULL,
  1684. PRIMARY KEY (`id`),
  1685. KEY `user_verifications_user_id_index` (`user_id`)
  1686. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1687. /*!40101 SET character_set_client = @saved_cs_client */;
  1688.  
  1689. --
  1690. -- Dumping data for table `user_verifications`
  1691. --
  1692.  
  1693. LOCK TABLES `user_verifications` WRITE;
  1694. /*!40000 ALTER TABLE `user_verifications` DISABLE KEYS */;
  1695. /*!40000 ALTER TABLE `user_verifications` ENABLE KEYS */;
  1696. UNLOCK TABLES;
  1697.  
  1698. --
  1699. -- Table structure for table `users`
  1700. --
  1701.  
  1702. DROP TABLE IF EXISTS `users`;
  1703. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1704. /*!40101 SET character_set_client = utf8 */;
  1705. CREATE TABLE `users` (
  1706. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1707. `created_at` timestamp NULL DEFAULT NULL,
  1708. `updated_at` timestamp NULL DEFAULT NULL,
  1709. `deleted_at` timestamp NULL DEFAULT NULL,
  1710. `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1711. `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1712. `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1713. `phone_number` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  1714. `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1715. `gender` enum('male','female') COLLATE utf8_unicode_ci DEFAULT NULL,
  1716. `sip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1717. `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  1718. `calendar_item_id` int(10) unsigned DEFAULT NULL,
  1719. `ui_state` json DEFAULT NULL,
  1720. `enable_2fa` tinyint(1) NOT NULL DEFAULT '0',
  1721. `callcenter_config` json DEFAULT NULL,
  1722. `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  1723. `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  1724. PRIMARY KEY (`id`),
  1725. KEY `users_calendar_item_id_index` (`calendar_item_id`)
  1726. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1727. /*!40101 SET character_set_client = @saved_cs_client */;
  1728.  
  1729. --
  1730. -- Dumping data for table `users`
  1731. --
  1732.  
  1733. LOCK TABLES `users` WRITE;
  1734. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  1735. INSERT INTO `users` VALUES (1,'2018-08-13 17:32:41','2018-08-13 17:32:41',NULL,'אופיר','ויז� ברג','office@amore-events.co.il','0586553667','ofir','male',NULL,'$2y$10$RQ2eoSU0xYHZcE0B1fG7/eLd5Hw8P1ZmgZOIVuvaEefvK/CJYrp2S',NULL,NULL,0,NULL,NULL,NULL),(2,'2018-08-13 17:37:52','2018-08-13 17:37:52',NULL,'שלומי','בובליל','shlomi@amore-events.co.il','0524212525','shlomi','male',NULL,'$2y$10$gdB.rlV4UUoE4SGgp9dUq.e1Le.DfBonHrlLiIA3rX/qSq95/r7g.',NULL,NULL,0,NULL,NULL,NULL),(3,'2018-08-13 17:40:37','2018-08-13 17:40:37',NULL,'משה','שטראוס','moshe@amore-events.co.il','0523856453','moshe','male',NULL,'$2y$10$USpCp6wuDpM4QLFKNWsxYOY3ec.s88yxroGx94QgTOQyLbnYmCgyO',NULL,NULL,0,NULL,NULL,NULL);
  1736. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  1737. UNLOCK TABLES;
  1738. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  1739.  
  1740. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  1741. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  1742. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  1743. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1744. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1745. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  1746. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  1747.  
  1748. -- Dump completed on 2018-08-22 15:38:42
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!