/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 `administrators` */

DROP TABLE IF EXISTS `administrators`;

CREATE TABLE `administrators` (
  `idAdmin` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) NOT NULL DEFAULT '0',
  `passwd` varchar(255) NOT NULL DEFAULT '0',
  `privType` tinyint(1) NOT NULL DEFAULT '0',
  `Name` varchar(100) NOT NULL DEFAULT '0',
  `isSu` tinyint(1) DEFAULT '0',
  `isActive` tinyint(1) NOT NULL DEFAULT '1',
  `attempts` tinyint(1) NOT NULL DEFAULT '0',
  `created` int(11) NOT NULL DEFAULT '1',
  `updated` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`idAdmin`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `administrators` */

insert  into `administrators`(`idAdmin`,`login`,`passwd`,`privType`,`Name`,`isSu`,`isActive`,`attempts`,`created`,`updated`) values
(1,'admin','$2y$10$pbLSn.Kt9VLsHFL6OrxDY.v3RQu0Droz604j655n8GPu.nnxMz086',1,'Super user',1,1,0,123,123);

/*Table structure for table `apartments` */

DROP TABLE IF EXISTS `apartments`;

CREATE TABLE `apartments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUser` int(11) DEFAULT '0',
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'apartment',
  `url` varchar(255) DEFAULT NULL,
  `thumbnail` int(11) DEFAULT '0',
  `isActive` tinyint(1) DEFAULT '0',
  `isInRent` tinyint(1) DEFAULT '0',
  `price` double(16,4) DEFAULT NULL,
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

/*Data for the table `apartments` */

/*Table structure for table `apartments_availability` */

DROP TABLE IF EXISTS `apartments_availability`;

CREATE TABLE `apartments_availability` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idParameter` int(11) DEFAULT NULL,
  `availableFrom` int(11) DEFAULT '0',
  `availableUntil` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idParameter` (`idParameter`),
  CONSTRAINT `apartments_availability_ibfk_1` FOREIGN KEY (`idParameter`) REFERENCES `apartments_parameters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `apartments_availability` */

/*Table structure for table `apartments_descriptions` */

DROP TABLE IF EXISTS `apartments_descriptions`;

CREATE TABLE `apartments_descriptions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idApartment` int(11) NOT NULL,
  `title` varchar(200) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  KEY `Apartment ID from description` (`idApartment`),
  CONSTRAINT `Apartment ID from description` FOREIGN KEY (`idApartment`) REFERENCES `apartments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

/*Data for the table `apartments_descriptions` */

/*Table structure for table `apartments_gallery` */

DROP TABLE IF EXISTS `apartments_gallery`;

CREATE TABLE `apartments_gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idApartment` int(11) DEFAULT '0',
  `targetFolder` varchar(50) DEFAULT NULL,
  `hashName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `apartments_gallery` */

/*Table structure for table `apartments_groups` */

DROP TABLE IF EXISTS `apartments_groups`;

CREATE TABLE `apartments_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sysName` varchar(50) DEFAULT NULL,
  `humanName` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `apartments_groups` */

/*Table structure for table `apartments_locations` */

DROP TABLE IF EXISTS `apartments_locations`;

CREATE TABLE `apartments_locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `region` varchar(100) DEFAULT NULL,
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `apartments_locations` */

/*Table structure for table `apartments_parameters` */

DROP TABLE IF EXISTS `apartments_parameters`;

CREATE TABLE `apartments_parameters` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idApartment` int(11) NOT NULL,
  `idDescription` int(11) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `children` int(2) DEFAULT '0',
  `adults` int(2) DEFAULT '0',
  `beds` int(2) DEFAULT '0',
  `square` int(3) DEFAULT '0',
  `additional` text,
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `Apartment description ID` (`idDescription`),
  KEY `Apartment ID from params` (`idApartment`),
  CONSTRAINT `Apartment ID from params` FOREIGN KEY (`idApartment`) REFERENCES `apartments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `Apartment description ID` FOREIGN KEY (`idDescription`) REFERENCES `apartments_descriptions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

/*Data for the table `apartments_parameters` */

/*Table structure for table `apartments_requests` */

DROP TABLE IF EXISTS `apartments_requests`;

CREATE TABLE `apartments_requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUser` int(11) DEFAULT '0',
  `idApartment` int(11) DEFAULT '0',
  `requestNumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `message` text,
  `status` tinyint(1) DEFAULT '0',
  `created` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `apartments_requests` */

/*Table structure for table `auth_tokens` */

DROP TABLE IF EXISTS `auth_tokens`;

CREATE TABLE `auth_tokens` (
  `idToken` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `tokenFor` varchar(200) DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '0',
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`idToken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `auth_tokens` */

/*Table structure for table `chat_messages` */

DROP TABLE IF EXISTS `chat_messages`;

CREATE TABLE `chat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `senderId` int(11) DEFAULT '0',
  `userId` int(11) DEFAULT NULL,
  `msg` text,
  `isReadByAdmin` tinyint(1) DEFAULT '0',
  `isRead` tinyint(1) DEFAULT '0',
  `isAdmin` tinyint(1) DEFAULT '0',
  `created` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `chat_messages` */

/*Table structure for table `contact` */

DROP TABLE IF EXISTS `contact`;

CREATE TABLE `contact` (
  `idMsg` int(11) NOT NULL AUTO_INCREMENT,
  `contactEmail` varchar(150) DEFAULT '0',
  `contactText` text,
  `ip` varchar(150) DEFAULT NULL,
  `answered` tinyint(11) DEFAULT '0',
  `created` int(11) DEFAULT '0',
  KEY `idMsg` (`idMsg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `contact` */

/*Table structure for table `currencies` */

DROP TABLE IF EXISTS `currencies`;

CREATE TABLE `currencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currencyCode` varchar(5) DEFAULT NULL,
  `currencyName` varchar(35) DEFAULT NULL,
  `exchangeRate` double(16,5) DEFAULT '0.00000',
  `created` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*Data for the table `currencies` */

insert  into `currencies`(`id`,`currencyCode`,`currencyName`,`exchangeRate`,`created`) values
(1,'EUR','Евро',18.50000,12313123),
(2,'USD','Доллар',16.50000,1576895741);

/*Table structure for table `orders_list` */

DROP TABLE IF EXISTS `orders_list`;

CREATE TABLE `orders_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUser` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `orders_list` */

/*Table structure for table `push_clients` */

DROP TABLE IF EXISTS `push_clients`;

CREATE TABLE `push_clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pushToken` varchar(255) DEFAULT NULL,
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `push_clients` */

insert  into `push_clients`(`id`,`pushToken`,`created`,`updated`) values
(2,'W',1574466691,1574466691),
(3,'WEIJFIWEJF293JWFIWENFWENF239WEFFIWIOJFIWQF2',1574545530,1574545530);

/*Table structure for table `push_notifications` */

DROP TABLE IF EXISTS `push_notifications`;

CREATE TABLE `push_notifications` (
  `int` int(11) NOT NULL AUTO_INCREMENT,
  `fcmToken` varchar(255) DEFAULT NULL,
  `userId` int(11) DEFAULT '0',
  `msgTitle` varchar(100) DEFAULT NULL,
  `msgContent` text,
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `push_notifications` */

/*Table structure for table `registered_users` */

DROP TABLE IF EXISTS `registered_users`;

CREATE TABLE `registered_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(100) DEFAULT NULL,
  `userType` enum('guest','registered') DEFAULT NULL,
  `authToken` varchar(100) DEFAULT NULL,
  `idPushClient` int(11) DEFAULT '0',
  `passwd` varchar(100) DEFAULT NULL,
  `phoneNumber` varchar(70) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `ipAddr` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `fullName` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT '0',
  `canSell` tinyint(1) DEFAULT '0',
  `filterName` varchar(255) DEFAULT NULL,
  `created` int(11) DEFAULT '0',
  `updated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

/*Data for the table `registered_users` */

insert  into `registered_users`(`id`,`userName`,`userType`,`authToken`,`idPushClient`,`passwd`,`phoneNumber`,`email`,`ipAddr`,`fullName`,`isActive`,`canSell`,`filterName`,`created`,`updated`) values
(1,'qweqweqweqwe','registered','386b9729aec17ac4dd68',2,'$2y$10$3Ekwkj0Q9Nd9li7kklAh0eY2H2JEGlrG4IoLb94gV9YCNJEB9nqe2','+37377777158','tester@gmail.com','127.0.0.1','test test3QQ',0,1,'tesssstt',1573767136,1573767136),
(5,'dratuti','guest','a072a59c81e8064cda00',3,NULL,'+37377777151','dratuti@gmail.com','127.0.0.1','дратути',1,0,NULL,1574545943,1574545943),
(6,'admin',NULL,NULL,0,'$2y$10$Wc7aqUrzVaWiFiS/Aom8OOHbUVoN.JXfMgurfneoAIayt1g5HWto6','+37377747542','adminadmin@gmail.com','127.0.0.1','adminadminwqeq',1,1,NULL,1576897249,1576897249);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;