-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: rainloopdb
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `rainloop_ab_contacts`
--

DROP TABLE IF EXISTS `rainloop_ab_contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_ab_contacts` (
  `id_contact` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_contact_str` varchar(128) NOT NULL DEFAULT '',
  `id_user` int(10) unsigned NOT NULL,
  `display` varchar(255) NOT NULL DEFAULT '',
  `changed` int(10) unsigned NOT NULL DEFAULT '0',
  `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `etag` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '',
  PRIMARY KEY (`id_contact`),
  KEY `id_user_rainloop_ab_contacts_index` (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_ab_contacts`
--

LOCK TABLES `rainloop_ab_contacts` WRITE;
/*!40000 ALTER TABLE `rainloop_ab_contacts` DISABLE KEYS */;
INSERT INTO `rainloop_ab_contacts` VALUES (1,'12f9dda1-21b5-46a8-9213-7ead2bc28212',1,'sapsan@gmail.com',1522872447,0,''),(2,'dcfff271-ba99-4069-b242-6f679be540bc',2,'info@kitty-shop.com.ua',1615978664,0,''),(3,'b3f05271-5e97-49c3-b193-1b9ee067ec1f',2,'Aleksey Sergienko',1615978701,0,''),(4,'e30c9e9c-b77c-4fdb-9bdf-1ae14f46df5a',2,'grabarvadim88@ukr.net',1615980165,0,''),(5,'73f70687-b0d1-490b-9587-e8c4602b43d7',2,'Dmitry Ivanov',1615981825,0,''),(6,'feebb66f-9aca-4f9a-9f9e-01db1a9f1a05',3,'Dmitry Ivanov',1615983375,0,''),(7,'5cbe3682-374d-46a8-ade7-4779b427f45d',3,'Dmitry Ivanov',1615984361,0,''),(8,'edd65ea9-6897-4a93-8938-902f623836cf',2,'xen.ivanova@gmail.com',1630407716,0,'');
/*!40000 ALTER TABLE `rainloop_ab_contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainloop_ab_properties`
--

DROP TABLE IF EXISTS `rainloop_ab_properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_ab_properties` (
  `id_prop` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_contact` bigint(20) unsigned NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `prop_type` tinyint(3) unsigned NOT NULL,
  `prop_type_str` varchar(255) CHARACTER SET ascii NOT NULL DEFAULT '',
  `prop_value` text NOT NULL,
  `prop_value_custom` text NOT NULL,
  `prop_value_lower` text NOT NULL,
  `prop_frec` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_prop`),
  KEY `id_user_rainloop_ab_properties_index` (`id_user`),
  KEY `id_user_id_contact_rainloop_ab_properties_index` (`id_user`,`id_contact`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_ab_properties`
--

LOCK TABLES `rainloop_ab_properties` WRITE;
/*!40000 ALTER TABLE `rainloop_ab_properties` DISABLE KEYS */;
INSERT INTO `rainloop_ab_properties` VALUES (1,1,1,30,'','sapsan@gmail.com','','sapsan@gmail.com',1),(2,1,1,10,'','sapsan@gmail.com','','',0),(3,2,2,30,'','info@kitty-shop.com.ua','','info@kitty-shop.com.ua',1),(4,2,2,10,'','info@kitty-shop.com.ua','','',0),(5,3,2,30,'','a.sergienko@gmail.com','','a.sergienko@gmail.com',1),(6,3,2,15,'','Aleksey','','aleksey',0),(7,3,2,16,'','Sergienko','','sergienko',0),(8,3,2,10,'','Aleksey Sergienko','','',0),(9,4,2,30,'','grabarvadim88@ukr.net','','grabarvadim88@ukr.net',1),(10,4,2,10,'','grabarvadim88@ukr.net','','',0),(11,5,2,30,'','divan315@gmail.com','','divan315@gmail.com',1),(12,5,2,15,'','Dmitry','','dmitry',0),(13,5,2,16,'','Ivanov','','ivanov',0),(14,5,2,10,'','Dmitry Ivanov','','',0),(15,6,3,30,'','divan315@gmail.com','','divan315@gmail.com',1),(16,6,3,15,'','Dmitry','','dmitry',0),(17,6,3,16,'','Ivanov','','ivanov',0),(18,6,3,10,'','Dmitry Ivanov','','',0),(19,7,3,30,'','museum.reboot@gmail.com','','museum.reboot@gmail.com',2),(20,7,3,15,'','Dmitry','','dmitry',0),(21,7,3,16,'','Ivanov','','ivanov',0),(22,7,3,10,'','Dmitry Ivanov','','',0),(23,8,2,30,'','xen.ivanova@gmail.com','','xen.ivanova@gmail.com',2),(24,8,2,10,'','xen.ivanova@gmail.com','','',0);
/*!40000 ALTER TABLE `rainloop_ab_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainloop_system`
--

DROP TABLE IF EXISTS `rainloop_system`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_system` (
  `sys_name` varchar(50) NOT NULL,
  `value_int` int(10) unsigned NOT NULL DEFAULT '0',
  `value_str` varchar(128) NOT NULL DEFAULT '',
  KEY `sys_name_rainloop_system_index` (`sys_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_system`
--

LOCK TABLES `rainloop_system` WRITE;
/*!40000 ALTER TABLE `rainloop_system` DISABLE KEYS */;
INSERT INTO `rainloop_system` VALUES ('mysql-ab-version_version',3,'');
/*!40000 ALTER TABLE `rainloop_system` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rainloop_users`
--

DROP TABLE IF EXISTS `rainloop_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rainloop_users` (
  `id_user` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rl_email` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id_user`),
  KEY `rl_email_rainloop_users_index` (`rl_email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rainloop_users`
--

LOCK TABLES `rainloop_users` WRITE;
/*!40000 ALTER TABLE `rainloop_users` DISABLE KEYS */;
INSERT INTO `rainloop_users` VALUES (3,'admin@blazenails.com.ua'),(2,'info@blazenails.com.ua'),(1,'sapsan@test.nails.ua');
/*!40000 ALTER TABLE `rainloop_users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-06-03 12:08:13
