EL RESMON DE JAVI
🇪🇸 Español
🇪🇸 Español
  • 👋Bienvenido a El Resmon de Javi
  • ❓FAQS
  • ASSETS
    • 📻Resmon DJ Creator
      • ⚠️ Dependencias
      • 🛠️ Instalación
        • SQL
      • 📚 Guía
        • Cómo crear una mesa de DJ
        • Cómo crear partículas
      • 🔲Exports
        • Exportaciones del lado del cliente
Powered by GitBook
On this page
  1. ASSETS
  2. Resmon DJ Creator
  3. 🛠️ Instalación

SQL

CREATE TABLE IF NOT EXISTS `dj_particle` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `table_id` INT(11) NOT NULL,
    `name` TEXT NOT NULL,
    `coords` LONGTEXT NOT NULL,
    `button` TEXT DEFAULT NULL,
    PRIMARY KEY (`id`),
    CONSTRAINT `TABLA_TIENE_PARTICULAS` 
        FOREIGN KEY (`table_id`) 
        REFERENCES `dj_table` (`id`) 
        ON DELETE CASCADE 
        ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `dj_playlist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `license` text NOT NULL,
  `name` text NOT NULL,
  `urls` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `dj_table` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `coords` longtext NOT NULL,
  `job` text DEFAULT NULL,
  `item` text DEFAULT NULL,
  `distance` float NOT NULL,
  `url` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Previous🛠️ InstalaciónNext📚 Guía
📻