h88SZWYZ

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