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;