SQL

This is the SQL structure used by this script.

CREATE TABLE IF NOT EXISTS `astral_safezones` (
            `id` INT NOT NULL AUTO_INCREMENT,
            `nombre` VARCHAR(100) DEFAULT NULL,
            `jobsWL` TINYINT(1) DEFAULT 0,
            `jobs` TEXT DEFAULT NULL,
            `velocidad` VARCHAR(10) DEFAULT NULL,
            `puntos` LONGTEXT NOT NULL,
            `showNotify` TINYINT(1) DEFAULT 0,
            `notificacion` TEXT DEFAULT NULL,
            `showNotifyExit` TINYINT(1) DEFAULT 0,
            `notificacionExit` TEXT DEFAULT NULL,
            `godmode` TINYINT(1) DEFAULT 0,
            `noShoot` TINYINT(1) DEFAULT 0, 
            `antivdm` TINYINT(1) DEFAULT 0,
            `noAFK` TINYINT(1) DEFAULT 0,
            `afkTime` VARCHAR(10) DEFAULT NULL,
            `afkNotify` TINYINT(1) DEFAULT 0,
            PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Last updated