-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- 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 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 */;

--
-- Table structure for table `quemlinkdoc`
--

DROP TABLE IF EXISTS `quemlinkdoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quemlinkdoc` (
  `id_link` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `table_name` char(30) NOT NULL DEFAULT '' COMMENT 'Tabla',
  `table_key` char(30) NOT NULL DEFAULT '' COMMENT 'Clave tabla',
  `nombre` text NOT NULL COMMENT 'Descripción',
  `fecha` date NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha',
  `hora` time NOT NULL DEFAULT '00:00:00' COMMENT 'Hora',
  `link` text NOT NULL COMMENT 'Link',
  `table_key_2` char(30) NOT NULL DEFAULT '' COMMENT 'Clave tabla 2',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  `sw_b2b` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Público (B2B)',
  `table_key_3` char(30) NOT NULL DEFAULT '' COMMENT 'Clave tabla 3',
  UNIQUE KEY `key0` (`id_link`,`id_tenant`),
  KEY `key1` (`id_tenant`,`fecha`,`hora`),
  KEY `key2` (`id_tenant`,`table_name`,`table_key`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quemlinkdoc`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `quemlinkdoc` WRITE;
/*!40000 ALTER TABLE `quemlinkdoc` DISABLE KEYS */;
INSERT INTO `quemlinkdoc` (`id_link`, `table_name`, `table_key`, `nombre`, `fecha`, `hora`, `link`, `table_key_2`, `id_tenant`, `sw_b2b`, `table_key_3`) VALUES (1,'maescuencrm_v','430000441','','2015-10-19','20:28:21','C:\\Users\\comercial\\Dropbox\\Cartas condiciones clientes\\2014','',1,0,''),(2,'cialpack','','','2017-11-27','12:37:04','','',1,0,''),(4,'maesarti','1010845','Link externo (AVANT B2B)','2018-07-23','18:52:31','https://www.youtube.com/watch?v=pGTjsBDkmJw','1',1,0,''),(5,'maesarti','1010845','Video Pérgola bioclimática (AVANT B2B)','2018-07-23','19:08:43','<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/pGTjsBDkmJw\" frameborder=\"0\" allow=\"autoplay; encrypted-media\" allowfullscreen></iframe>','1',1,0,''),(6,'maesarti','1010961','Solplay','2018-10-26','18:10:34','http:\\\\www.solplay.es','1',1,1,''),(11,'maescuen','430000999','Web Solplay','2020-05-25','14:27:58','http://www.solplay.es','',1,1,''),(12,'cialdoco','691864884463683253','https://solplaysl-my.sharepoint.com/:i:/g/personal/escaner_solplay_es/EaVn3OX3Uz9KtDZDFuROVqEBSO4_vJQgtIyKo6YUL3RQYQ?e=WqzJQs','2025-03-27','13:33:08','','',1,0,'');
/*!40000 ALTER TABLE `quemlinkdoc` 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 2025-10-30  8:42:00
