--
-- Host: localhost    Database: munimazamarigob_agenda
-- ------------------------------------------------------


--
-- Table structure for table `ea_consents`
--

CREATE TABLE `ea_consents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` timestamp NULL DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  `first_name` varchar(256) DEFAULT NULL,
  `last_name` varchar(256) DEFAULT NULL,
  `email` varchar(512) DEFAULT NULL,
  `ip` varchar(256) DEFAULT NULL,
  `type` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_consents`
--


--
-- Table structure for table `ea_migrations`
--

CREATE TABLE `ea_migrations` (
  `version` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_migrations`
--

INSERT INTO `ea_migrations` (`version`) VALUES (21);

--
-- Table structure for table `ea_roles`
--

CREATE TABLE `ea_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) DEFAULT NULL,
  `slug` varchar(256) DEFAULT NULL,
  `is_admin` tinyint(4) DEFAULT NULL,
  `appointments` int(11) DEFAULT NULL,
  `customers` int(11) DEFAULT NULL,
  `services` int(11) DEFAULT NULL,
  `users` int(11) DEFAULT NULL,
  `system_settings` int(11) DEFAULT NULL,
  `user_settings` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_roles`
--

INSERT INTO `ea_roles` (`id`, `name`, `slug`, `is_admin`, `appointments`, `customers`, `services`, `users`, `system_settings`, `user_settings`) VALUES (1,'Administrator','admin',1,15,15,15,15,15,15),(2,'Provider','provider',0,15,15,0,0,0,15),(3,'Customer','customer',0,0,0,0,0,0,0),(4,'Secretary','secretary',0,15,15,0,0,0,15);

--
-- Table structure for table `ea_secretaries_providers`
--

CREATE TABLE `ea_secretaries_providers` (
  `id_users_secretary` int(11) NOT NULL,
  `id_users_provider` int(11) NOT NULL,
  PRIMARY KEY (`id_users_secretary`,`id_users_provider`),
  KEY `secretaries_users_provider` (`id_users_provider`),
  CONSTRAINT `secretaries_users_provider` FOREIGN KEY (`id_users_provider`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `secretaries_users_secretary` FOREIGN KEY (`id_users_secretary`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_secretaries_providers`
--


--
-- Table structure for table `ea_service_categories`
--

CREATE TABLE `ea_service_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) DEFAULT NULL,
  `description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_service_categories`
--


--
-- Table structure for table `ea_services`
--

CREATE TABLE `ea_services` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(256) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `currency` varchar(32) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `location` text DEFAULT NULL,
  `availabilities_type` varchar(32) DEFAULT 'flexible',
  `attendants_number` int(11) DEFAULT 1,
  `id_service_categories` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_service_categories` (`id_service_categories`),
  CONSTRAINT `services_service_categories` FOREIGN KEY (`id_service_categories`) REFERENCES `ea_service_categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_services`
--

INSERT INTO `ea_services` (`id`, `name`, `duration`, `price`, `currency`, `description`, `location`, `availabilities_type`, `attendants_number`, `id_service_categories`) VALUES (1,'REUNION CON EL ALCALDE ',10,0.00,'','','','fixed',5,NULL);

--
-- Table structure for table `ea_services_providers`
--

CREATE TABLE `ea_services_providers` (
  `id_users` int(11) NOT NULL,
  `id_services` int(11) NOT NULL,
  PRIMARY KEY (`id_users`,`id_services`),
  KEY `services_providers_services` (`id_services`),
  CONSTRAINT `services_providers_services` FOREIGN KEY (`id_services`) REFERENCES `ea_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `services_providers_users_provider` FOREIGN KEY (`id_users`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_services_providers`
--

INSERT INTO `ea_services_providers` (`id_users`, `id_services`) VALUES (2,1);

--
-- Table structure for table `ea_settings`
--

CREATE TABLE `ea_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(512) DEFAULT NULL,
  `value` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_settings`
--

INSERT INTO `ea_settings` (`id`, `name`, `value`) VALUES (1,'company_working_plan','{\"monday\":{\"start\":\"08:00\",\"end\":\"18:00\",\"breaks\":[{\"start\":\"13:00\",\"end\":\"15:00\"}]},\"tuesday\":{\"start\":\"08:00\",\"end\":\"18:00\",\"breaks\":[{\"start\":\"13:00\",\"end\":\"15:00\"}]},\"wednesday\":{\"start\":\"08:00\",\"end\":\"18:00\",\"breaks\":[{\"start\":\"13:00\",\"end\":\"15:00\"}]},\"thursday\":{\"start\":\"09:00\",\"end\":\"18:00\",\"breaks\":[]},\"friday\":{\"start\":\"08:00\",\"end\":\"18:00\",\"breaks\":[{\"start\":\"13:00\",\"end\":\"15:00\"}]},\"saturday\":null,\"sunday\":null}'),(2,'book_advance_timeout','10'),(3,'google_analytics_code',''),(4,'customer_notifications','1'),(5,'date_format','DMY'),(6,'require_captcha','0'),(7,'time_format','military'),(8,'display_cookie_notice','0'),(9,'cookie_notice_content','Cookie notice content.'),(10,'display_terms_and_conditions','0'),(11,'terms_and_conditions_content','Terms and conditions content.'),(12,'display_privacy_policy','0'),(13,'privacy_policy_content','Privacy policy content.'),(14,'first_weekday','monday'),(15,'require_phone_number','1'),(16,'api_token',''),(17,'display_any_provider','1'),(18,'company_name','MUNICIPALIDAD DISTRITAL DE MAZAMARI'),(19,'company_email','munimazamari@munimazamari.gob.pe'),(20,'company_link','https://www.gob.pe/munimazamari');

--
-- Table structure for table `ea_users`
--

CREATE TABLE `ea_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(256) DEFAULT NULL,
  `last_name` varchar(512) DEFAULT NULL,
  `email` varchar(512) DEFAULT NULL,
  `mobile_number` varchar(128) DEFAULT NULL,
  `phone_number` varchar(128) DEFAULT NULL,
  `address` varchar(256) DEFAULT NULL,
  `city` varchar(256) DEFAULT NULL,
  `state` varchar(128) DEFAULT NULL,
  `zip_code` varchar(64) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `timezone` varchar(256) DEFAULT 'UTC',
  `language` varchar(256) DEFAULT 'english',
  `id_roles` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_roles` (`id_roles`),
  CONSTRAINT `users_roles` FOREIGN KEY (`id_roles`) REFERENCES `ea_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `ea_users`
--

INSERT INTO `ea_users` (`id`, `first_name`, `last_name`, `email`, `mobile_number`, `phone_number`, `address`, `city`, `state`, `zip_code`, `notes`, `timezone`, `language`, `id_roles`) VALUES (1,'ROY CLEFER','USCAMAYTA PAHUACHO','munimazamari22@gmail.com','','918091913','','','','','','UTC','english',1),(2,'JHONY','APOLINARIO CASO','jane@example.org','','+1 (000) 000-0000','','','','','','UTC','english',2),(3,'James','Doe','james@example.org',NULL,'+1 (000) 000-0000',NULL,NULL,NULL,NULL,NULL,'UTC','english',3),(4,'JUAN','LEON PAUCAR','demo@gmail.com',NULL,'918091913','','',NULL,'',NULL,'UTC','spanish',3),(5,'roy','uscamayta','mauro.original@gmail.com',NULL,'9896121212','','',NULL,'',NULL,'UTC','spanish',3),(6,'XIMENA','SANTIAGO ORTIZ','JFJSDBGSHD@GMAIL.COM',NULL,'968574178','','',NULL,'',NULL,'UTC','spanish',3),(7,'LAURIS','LAURIS','FASFASG@gmail.com',NULL,'96587458','','',NULL,'','','UTC','english',3),(8,'peña','peña','fdfdsg@gmail.com',NULL,'96584258','','',NULL,'','','UTC','english',3),(9,'maria ','rios nauda','asfsfgeg@gmail.com',NULL,'965845351','','',NULL,'','asociacion de victimas','UTC','english',3),(10,'JAIME OSCAR','PACHECO GUTIERREZ','SDGGFG@GMAIL.COM',NULL,'96325841','','',NULL,'','MICAELA BASTIDAS','UTC','english',3),(11,'PEPE','ESPEIRITU VICENTE','FGDSG@GMAIL.COM',NULL,'963258741','','',NULL,'','DELEGADO VECINAL LOS ANGELES DE EDEN','UTC','english',3),(12,'MARGARITA','UNTIVEROS PALOMINO','SDFDKGI@GMAIL.COM',NULL,'9863258741','','',NULL,'','MAZAMARI','UTC','english',3),(13,'SDGVAG','DGSDGDS','FDZFDSFDDKGI@GMAIL.COM',NULL,'9863258741','','',NULL,'','LICENCIADOS DEL EJERCITO','UTC','english',3),(14,'roy','roy','adbsajdbsa@gmail.com',NULL,'944000135','','',NULL,'','','UTC','english',3),(15,'anselmo','ccora renojo','SDFDsKGI@GMAIL.COM',NULL,'9863258741','','',NULL,'','urb. valentin alvarez','UTC','english',3),(16,'David ','reymundo ala','SfsdDFDKGI@GMAIL.COM',NULL,'963258411','','',NULL,'','santa rosa de chiriari','UTC','english',3),(17,'deysi','carlos tello','SDFDKssGI@GMAIL.COM',NULL,'963258741','','',NULL,'','mazamari','UTC','english',3),(18,'NOEMI','HUAMAN PICHARDO','SDFDFDDKGI@GMAIL.COM',NULL,' 9863258741','','',NULL,'','JUNTA EVCONAL SAN VICENTE SAN CRISTOBAL','UTC','english',3),(19,'gloria','alcala','ddd@GMAIL.COM',NULL,'5165465156','','',NULL,'','asociacion tsinani','UTC','english',3),(20,'DANIEL','TINTAYO ','SDFDKGSI@GMAIL.COM',NULL,'83863863','','',NULL,'','FERREYROS ','UTC','english',3),(21,'ESTEFANI','AVELLANEDA DE LA O','SDDSGDFDKGI@GMAIL.COM',NULL,'56498465498','','',NULL,'','ASOC. SANTA ROSA DE LLAYLLA\n','UTC','english',3),(22,'ruben ','estrada caysahuana','SD5565565FDKGI@GMAIL.COM',NULL,'afafafafa','','',NULL,'','','UTC','english',3);

--
-- Dumping events for database 'munimazamarigob_agenda'
--

--
-- Dumping routines for database 'munimazamarigob_agenda'
--


