structure.sql

structure.sql

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 22-12-2022 a las 16:43:21
-- Versión del servidor: 8.0.30
-- Versión de PHP: 8.1.10

SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Base de datos: `tcg-wallet`
--

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

--
-- Estructura de tabla para la tabla `card_image`
--

DROP TABLE IF EXISTS `card_image`;
CREATE TABLE `card_image` (
  `key_cart_image` int UNSIGNED NOT NULL COMMENT 'ID Increment',
  `fk_card_id` bigint UNSIGNED DEFAULT NULL,
  `image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_url_small` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `card_in_sets`
--

DROP TABLE IF EXISTS `card_in_sets`;
CREATE TABLE `card_in_sets` (
  `key_card_set` int UNSIGNED NOT NULL COMMENT 'ID Increment',
  `fk_card_id` bigint UNSIGNED DEFAULT NULL,
  `set_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `set_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `set_rarity` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `set_rarity_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `set_price` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_update` datetime DEFAULT '1986-09-09 01:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `card_list`
--

DROP TABLE IF EXISTS `card_list`;
CREATE TABLE `card_list` (
  `key_card` int UNSIGNED NOT NULL COMMENT 'ID Increment',
  `card_id` bigint UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Main Card ID',
  `card_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_atk` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_def` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_scale` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_race` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `card_attribute` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `card_archetype` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `card_image`
--
ALTER TABLE `card_image`
  ADD PRIMARY KEY (`key_cart_image`),
  ADD KEY `fk_card_id` (`fk_card_id`);

--
-- Indices de la tabla `card_in_sets`
--
ALTER TABLE `card_in_sets`
  ADD PRIMARY KEY (`key_card_set`),
  ADD KEY `fk_card_id` (`fk_card_id`,`set_name`,`set_code`,`set_rarity`,`set_rarity_code`,`set_price`,`last_update`);

--
-- Indices de la tabla `card_list`
--
ALTER TABLE `card_list`
  ADD PRIMARY KEY (`key_card`),
  ADD KEY `card_id` (`card_id`,`card_name`,`card_type`,`card_desc`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `card_image`
--
ALTER TABLE `card_image`
  MODIFY `key_cart_image` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Increment';

--
-- AUTO_INCREMENT de la tabla `card_in_sets`
--
ALTER TABLE `card_in_sets`
  MODIFY `key_card_set` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Increment';

--
-- AUTO_INCREMENT de la tabla `card_list`
--
ALTER TABLE `card_list`
  MODIFY `key_card` int UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID Increment';

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `card_image`
--
ALTER TABLE `card_image`
  ADD CONSTRAINT `card_image_ibfk_1` FOREIGN KEY (`fk_card_id`) REFERENCES `card_list` (`card_id`);

--
-- Filtros para la tabla `card_in_sets`
--
ALTER TABLE `card_in_sets`
  ADD CONSTRAINT `card_in_sets_ibfk_1` FOREIGN KEY (`fk_card_id`) REFERENCES `card_list` (`card_id`);
SET FOREIGN_KEY_CHECKS=1;
COMMIT;

/*!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 */;