EmGXa6bY

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