-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 10-02-2023 a las 17:15:40
-- Versión del servidor: 10.5.16-MariaDB
-- Versión de PHP: 8.0.20

START TRANSACTION;



--
-- Base de datos: `ads_server`
--

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

--
-- Estructura de tabla para la tabla `almacen`
--

CREATE TABLE `almacen` (
  `id` int(11) NOT NULL,
  `filename` varchar(200) NOT NULL,
  `size` int(10) NOT NULL,
  `video_width` int(10) NOT NULL,
  `video_height` int(10) NOT NULL,
  `video_lenght` int(10) NOT NULL,
  `thumbnail` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `user` varchar(20) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `listas`
--

CREATE TABLE `listas` (
  `id_lista` int(11) NOT NULL,
  `nombre_lista` varchar(200) NOT NULL,
  `videos_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `ultimo_usuario` varchar(200) NOT NULL,
  `creacion` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `players`
--

CREATE TABLE `players` (
  `id` int(11) NOT NULL,
  `player_name` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
  `lst_assoc` varchar(50) CHARACTER SET utf8 COLLATE utf8_spanish2_ci NOT NULL,
  `res_x` int(5) NOT NULL,
  `res_y` int(5) NOT NULL,
  `x0` int(5) NOT NULL,
  `y0` int(5) NOT NULL,
  `hour_start` varchar(2) COLLATE utf8_spanish_ci NOT NULL,
  `min_start` varchar(2) COLLATE utf8_spanish_ci NOT NULL,
  `hour_end` varchar(2) COLLATE utf8_spanish_ci NOT NULL,
  `min_end` varchar(2) COLLATE utf8_spanish_ci NOT NULL,
  `datecreate` date NOT NULL,
  `user` varchar(20) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `almacen`
--
ALTER TABLE `almacen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id` (`id`);

--
-- Indices de la tabla `listas`
--
ALTER TABLE `listas`
  ADD PRIMARY KEY (`id_lista`);

--
-- Indices de la tabla `players`
--
ALTER TABLE `players`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `almacen`
--
ALTER TABLE `almacen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `listas`
--
ALTER TABLE `listas`
  MODIFY `id_lista` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `players`
--
ALTER TABLE `players`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

