-- MySQL dump 10.13  Distrib 5.7.23-23, for Linux (x86_64)
--
-- Host: localhost    Database: boticaco_wikiiso
-- ------------------------------------------------------
-- Server version	5.7.23-23

/*!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 utf8 */;
/*!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 */;
/*!50717 SELECT COUNT(*) INTO @rocksdb_has_p_s_session_variables FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema' AND TABLE_NAME = 'session_variables' */;
/*!50717 SET @rocksdb_get_is_supported = IF (@rocksdb_has_p_s_session_variables, 'SELECT COUNT(*) INTO @rocksdb_is_supported FROM performance_schema.session_variables WHERE VARIABLE_NAME=\'rocksdb_bulk_load\'', 'SELECT 0') */;
/*!50717 PREPARE s FROM @rocksdb_get_is_supported */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;
/*!50717 SET @rocksdb_enable_bulk_load = IF (@rocksdb_is_supported, 'SET SESSION rocksdb_bulk_load = 1', 'SET @rocksdb_dummy_bulk_load = 0') */;
/*!50717 PREPARE s FROM @rocksdb_enable_bulk_load */;
/*!50717 EXECUTE s */;
/*!50717 DEALLOCATE PREPARE s */;

--
-- Table structure for table `ipblocks`
--

DROP TABLE IF EXISTS `ipblocks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipblocks` (
  `ipb_id` int(11) NOT NULL AUTO_INCREMENT,
  `ipb_address` tinyblob NOT NULL,
  `ipb_user` int(10) unsigned NOT NULL DEFAULT '0',
  `ipb_by` int(10) unsigned NOT NULL DEFAULT '0',
  `ipb_reason` varbinary(767) NOT NULL DEFAULT '',
  `ipb_reason_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `ipb_timestamp` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  `ipb_auto` tinyint(1) NOT NULL DEFAULT '0',
  `ipb_anon_only` tinyint(1) NOT NULL DEFAULT '0',
  `ipb_create_account` tinyint(1) NOT NULL DEFAULT '1',
  `ipb_enable_autoblock` tinyint(1) NOT NULL DEFAULT '1',
  `ipb_expiry` varbinary(14) NOT NULL DEFAULT '',
  `ipb_range_start` tinyblob NOT NULL,
  `ipb_range_end` tinyblob NOT NULL,
  `ipb_deleted` tinyint(1) NOT NULL DEFAULT '0',
  `ipb_block_email` tinyint(1) NOT NULL DEFAULT '0',
  `ipb_by_text` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `ipb_by_actor` bigint(20) unsigned NOT NULL DEFAULT '0',
  `ipb_allow_usertalk` tinyint(1) NOT NULL DEFAULT '1',
  `ipb_parent_block_id` int(11) DEFAULT NULL,
  `ipb_sitewide` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ipb_id`),
  UNIQUE KEY `ipb_address` (`ipb_address`(255),`ipb_user`,`ipb_auto`,`ipb_anon_only`),
  KEY `ipb_user` (`ipb_user`),
  KEY `ipb_range` (`ipb_range_start`(8),`ipb_range_end`(8)),
  KEY `ipb_timestamp` (`ipb_timestamp`),
  KEY `ipb_expiry` (`ipb_expiry`),
  KEY `ipb_parent_block_id` (`ipb_parent_block_id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ipblocks`
--

LOCK TABLES `ipblocks` WRITE;
/*!40000 ALTER TABLE `ipblocks` DISABLE KEYS */;
INSERT INTO `ipblocks` VALUES (1,_binary 'Ricardo',87,4,_binary 'Nombre de usuario inaceptable',0,_binary '20100115115537',0,0,1,1,_binary 'infinity','','',0,1,'Cindylopez',0,1,NULL,1),(2,_binary 'Agustin.maidana',235,1,_binary 'Desvinculado de la empresa',0,_binary '20180212124938',0,0,1,0,_binary 'infinity','','',0,1,'Admin',0,0,NULL,1),(9,_binary 'Juan.falcon',232,1,'',0,_binary '20180328180313',0,0,1,1,_binary 'infinity','','',0,0,'Admin',0,0,NULL,1),(10,_binary 'Dante',126,1,'',0,_binary '20180328180344',0,0,1,1,_binary 'infinity','','',0,0,'Admin',0,0,NULL,1),(11,_binary 'Marthaddb',8,1,'',0,_binary '20180328180515',0,0,1,1,_binary 'infinity','','',0,0,'Admin',0,0,NULL,1),(14,_binary 'Amado',12,1,'',0,_binary '20200221164502',0,0,1,1,_binary 'infinity','','',0,1,'Admin',0,0,NULL,1),(16,_binary 'Emilio',3,1,'',0,_binary '20200225142855',0,0,1,0,_binary 'infinity','','',0,1,'Admin',0,0,NULL,1),(17,_binary 'Bruno.britos',211,1,_binary 'desvinculacion',0,_binary '20200518193656',0,0,1,1,_binary 'infinity','','',0,1,'Admin',0,0,NULL,1),(18,_binary 'Edith.pena',238,1,_binary 'desvinculacion',0,_binary '20200826194138',0,0,1,1,_binary 'infinity','','',0,1,'Admin',0,0,NULL,1),(20,_binary 'Edith.peña',231,1,_binary 'desvinculacion',0,_binary '20200826194212',0,0,1,1,_binary 'infinity','','',0,1,'Admin',0,0,NULL,1),(21,_binary 'Yumi.Kurohara',261,7,'',0,_binary '20201229191331',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(22,_binary 'Santiago.valdez',243,7,_binary 'DESVINCULACION',0,_binary '20201229191519',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(23,_binary 'Sara',94,7,_binary 'DESVINCULACION',0,_binary '20201229191530',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(25,_binary 'Vanesa.alvarez',224,7,_binary 'DESVINCULACION',0,_binary '20201229191552',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(26,_binary 'Vanessa.vega',195,7,_binary 'DESVINCULACION',0,_binary '20201229191603',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(27,_binary 'Yolanda',132,7,_binary 'DESVINCULACION',0,_binary '20201229191612',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(28,_binary 'Ricardocaceres',124,7,_binary 'DESVINCULACION',0,_binary '20201229191658',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(29,_binary 'Roberta',36,7,_binary 'DESVINCULACION',0,_binary '20201229191705',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(30,_binary 'Rosa.almada',226,7,_binary 'DESVINCULACION',0,_binary '20201229191718',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(31,_binary 'Cindylopez',4,7,_binary 'DESVINCULACION',0,_binary '20210211201303',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(32,_binary 'Felix',109,7,_binary 'DESVINCULACION',0,_binary '20210211201413',0,0,1,1,_binary 'infinity','','',0,0,'Mariajose',0,1,NULL,1),(33,_binary 'Evelin.garcia',54,7,_binary 'DESVINCULACION',0,_binary '20210211201444',0,0,1,1,_binary 'infinity','','',0,1,'Mariajose',0,0,NULL,1),(34,_binary 'Juanjose',319,5,'',0,_binary '20220121133408',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(35,_binary 'Rhasley',257,205,'',0,_binary '20220616211838',0,0,1,1,_binary 'infinity','','',0,1,'Josue.fleitas',0,0,NULL,1),(36,_binary 'Rhasley.Ferreira',256,205,'',0,_binary '20220616211951',0,0,1,1,_binary 'infinity','','',0,1,'Josue.fleitas',0,0,NULL,1),(37,_binary 'Alejandra,gonzalez',196,5,'',0,_binary '20220623215952',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(38,_binary 'Alejandro',164,5,'',0,_binary '20220623220108',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(39,_binary 'Adriana.troche',305,5,'',0,_binary '20230414154639',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(40,_binary 'Pamela',131,5,'',0,_binary '20230414154752',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(41,_binary 'Fatima Torres',258,5,'',0,_binary '20230414154825',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(42,_binary 'Viviana.chaparro',276,5,'',0,_binary '20230414154853',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(43,_binary 'Cecilia.ortiz',337,5,'',0,_binary '20230414155420',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(44,_binary 'Cynthia.gimenez',284,5,'',0,_binary '20230414155635',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1),(45,_binary 'Analiaojeda',151,5,'',0,_binary '20230414155745',0,0,1,1,_binary 'infinity','','',0,0,'Sandra.hermosa',0,1,NULL,1);
/*!40000 ALTER TABLE `ipblocks` ENABLE KEYS */;
UNLOCK TABLES;
/*!50112 SET @disable_bulk_load = IF (@is_rocksdb_supported, 'SET SESSION rocksdb_bulk_load = @old_rocksdb_bulk_load', 'SET @dummy_rocksdb_bulk_load = 0') */;
/*!50112 PREPARE s FROM @disable_bulk_load */;
/*!50112 EXECUTE s */;
/*!50112 DEALLOCATE PREPARE s */;
/*!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-04-16 17:18:22