EL RESMON DE JAVI
🇬🇧 English
🇬🇧 English
  • 👋Welcome to El Resmon de Javi
  • ❓FAQS
  • ASSETS
    • 📻Resmon DJ Creator
      • ⚠️Dependecies
      • 🛠️Installation
        • SQL
      • 📚Guide
        • How to create a DJ Table
        • How to create particles
      • 🔲Exports
        • Client side exports
Powered by GitBook
On this page
  1. ASSETS
  2. Resmon DJ Creator
  3. 🛠️Installation

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🛠️InstallationNext📚Guide

Last updated 1 month ago

📻