-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `virtual-tiendas-master-conex`
--

-- --------------------------------------------------------

--
-- Table structure for table `master_conexion`
--

CREATE TABLE `master_conexion` (
                                   `id_conexion` int(11) NOT NULL,
                                   `dominio` varchar(250) NOT NULL COMMENT 'Clave de consulta la conexion dinamica',
                                   `host` varchar(250) NOT NULL,
                                   `db` varchar(250) NOT NULL,
                                   `usuario` varchar(250) DEFAULT NULL,
                                   `clave` varchar(250) DEFAULT NULL,
                                   `registro` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `master_conexion`
--

INSERT INTO `master_conexion` (`id_conexion`, `dominio`, `host`, `db`, `usuario`, `clave`, `registro`) VALUES
                                                                                                           (1, 'tienda1.local', 'localhost', 'virtual-tiendas', 'root', '', '2025-05-09 11:03:05'),
                                                                                                           (2, 'tienda2.local', 'localhost', 'virtual-tiendas', 'root', '', '2025-05-09 11:03:05');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `master_conexion`
--
ALTER TABLE `master_conexion`
    ADD PRIMARY KEY (`id_conexion`),
  ADD UNIQUE KEY `master_conexion_dominio_uindex` (`dominio`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `master_conexion`
--
ALTER TABLE `master_conexion`
    MODIFY `id_conexion` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

