🗂 Base de Donnees

The-Programmer - Script SQL complet a executer

📦 Installation Globale 📄 Modifications Scripts 🌎 Init Mapping 📦 Virtual Items

📋 Progression 0 / 2 etapes

🚀 Script SQL Complet Termine

✅ Instructions : Copiez et executez ce script complet dans votre base de donnees MySQL/MariaDB. Il contient toutes les modifications necessaires pour tous les produits The-Programmer.

⚠ Attention : Faites une sauvegarde de votre base de donnees avant d'executer ce script !

-- ============================================
-- THE-PROGRAMMER - SCRIPT SQL COMPLET
-- Executez ce script une seule fois
-- ============================================

-- ============================================
-- MODIFICATIONS TABLE PLAYERS
-- ============================================

-- Annuaire
ALTER TABLE `players` ADD COLUMN `annuaire` ENUM('0','1') NOT NULL DEFAULT '0';

-- DrivingQuestions
ALTER TABLE `players` ADD COLUMN `driving_questions` TEXT;

-- PermisPoints
ALTER TABLE `players` ADD COLUMN `points_data` TEXT;

-- Darknet
ALTER TABLE `players` ADD COLUMN `darknet_name` VARCHAR(50) DEFAULT NULL;
ALTER TABLE `players` ADD COLUMN `darknet_bitcoin` VARCHAR(50) NOT NULL DEFAULT '0';

-- ============================================
-- MODIFICATIONS TABLE VEHICLES
-- ============================================

-- CarPainter
ALTER TABLE `vehicles` ADD COLUMN `custom_color` VARCHAR(300) NOT NULL DEFAULT '-1';
ALTER TABLE `vehicles` ADD COLUMN `custom_rvmat` VARCHAR(300) NOT NULL DEFAULT '-1';
ALTER TABLE `vehicles` CHANGE `color` `color` TEXT NOT NULL;

-- AdvancedHacking
ALTER TABLE `vehicles` ADD COLUMN `security` VARCHAR(255) NULL;

-- ============================================
-- MODIFICATIONS TABLE HOUSES
-- ============================================

-- AdvancedHacking
ALTER TABLE `houses` ADD COLUMN `security` VARCHAR(255) NULL;

-- ============================================
-- NOUVELLES TABLES
-- ============================================

-- Interpol
CREATE TABLE IF NOT EXISTS `interpol` (
    `id` INT(6) NOT NULL AUTO_INCREMENT,
    `prenom` VARCHAR(32) NOT NULL,
    `nom` VARCHAR(32) NOT NULL,
    `naissance` TEXT NOT NULL,
    `adresse` TEXT NOT NULL,
    `ville` TEXT NOT NULL,
    `numero` VARCHAR(32) NOT NULL DEFAULT '0',
    `yeux` TEXT NOT NULL,
    `details` TEXT NOT NULL,
    `insert_time` TEXT NOT NULL,
    PRIMARY KEY (`id`)
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

CREATE TABLE IF NOT EXISTS `interpol_crimes` (
    `id` INT(6) NOT NULL AUTO_INCREMENT,
    `interpol_id` INT(6) NOT NULL,
    `crime` VARCHAR(64) NOT NULL,
    `price` INT(100) NOT NULL,
    `payed` TINYINT(1) NOT NULL DEFAULT '0',
    `insert_time` TEXT NOT NULL,
    PRIMARY KEY (`id`)
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB;

-- PermisPoints
CREATE TABLE IF NOT EXISTS `permis` (
    `id` INT(8) NOT NULL AUTO_INCREMENT,
    `pid` VARCHAR(17) NOT NULL DEFAULT '0',
    `permis_type` VARCHAR(255) NOT NULL DEFAULT '0',
    `reason` VARCHAR(255) NOT NULL DEFAULT '0',
    `insert_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) COLLATE='latin1_swedish_ci' ENGINE=InnoDB;

-- PetDog
CREATE TABLE IF NOT EXISTS `petdog` (
    `id` INT(6) NOT NULL AUTO_INCREMENT,
    `pid` VARCHAR(17) NOT NULL,
    `configName` VARCHAR(17) NOT NULL,
    `name` VARCHAR(32) NOT NULL,
    `alive` INT(6) NOT NULL DEFAULT '1',
    `side` VARCHAR(32) NOT NULL,
    PRIMARY KEY (`id`)
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

-- Darknet
CREATE TABLE IF NOT EXISTS `darknet_items` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner_id` INT(11) NOT NULL,
    `type` INT(11) NOT NULL,
    `classname` VARCHAR(100) NOT NULL,
    `number` INT(11) NOT NULL,
    `price` VARCHAR(50) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `darknet_tchat` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `text` TEXT NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `darknet_transferts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner_id` INT(11) NOT NULL,
    `text` VARCHAR(255) NOT NULL,
    `insert_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ============================================
-- FIN DU SCRIPT
-- ============================================
            

📄 Detail par Produit Termine

📖 Annuaire

ALTER TABLE `players` ADD COLUMN `annuaire` ENUM('0','1') NOT NULL DEFAULT '0';

🛈 Note : Mettez DEFAULT '0' pour que les joueurs soient automatiquement dans l'annuaire, ou DEFAULT '1' pour qu'ils doivent s'inscrire manuellement.

🚗 DrivingQuestions

ALTER TABLE `players` ADD COLUMN `driving_questions` TEXT;

🎲 PermisPoints

ALTER TABLE `players` ADD COLUMN `points_data` TEXT;

CREATE TABLE `permis` (
    `id` INT(8) NOT NULL AUTO_INCREMENT,
    `pid` VARCHAR(17) NOT NULL DEFAULT '0',
    `permis_type` VARCHAR(255) NOT NULL DEFAULT '0',
    `reason` VARCHAR(255) NOT NULL DEFAULT '0',
    `insert_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) COLLATE='latin1_swedish_ci' ENGINE=InnoDB;

👮 Interpol

CREATE TABLE `interpol` (
    `id` INT(6) NOT NULL AUTO_INCREMENT,
    `prenom` VARCHAR(32) NOT NULL,
    `nom` VARCHAR(32) NOT NULL,
    `naissance` TEXT NOT NULL,
    `adresse` TEXT NOT NULL,
    `ville` TEXT NOT NULL,
    `numero` VARCHAR(32) NOT NULL DEFAULT '0',
    `yeux` TEXT NOT NULL,
    `details` TEXT NOT NULL,
    `insert_time` TEXT NOT NULL,
    PRIMARY KEY (`id`)
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

CREATE TABLE `interpol_crimes` (
    `id` INT(6) NOT NULL AUTO_INCREMENT,
    `interpol_id` INT(6) NOT NULL,
    `crime` VARCHAR(64) NOT NULL,
    `price` INT(100) NOT NULL,
    `payed` TINYINT(1) NOT NULL DEFAULT '0',
    `insert_time` TEXT NOT NULL,
    PRIMARY KEY (`id`)
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB;

🎨 CarPainter

ALTER TABLE `vehicles` ADD COLUMN `custom_color` VARCHAR(300) NOT NULL DEFAULT '-1';
ALTER TABLE `vehicles` ADD COLUMN `custom_rvmat` VARCHAR(300) NOT NULL DEFAULT '-1';
ALTER TABLE `vehicles` CHANGE `color` `color` TEXT NOT NULL;

💻 AdvancedHacking

ALTER TABLE `houses` ADD COLUMN `security` VARCHAR(255) NULL;
ALTER TABLE `vehicles` ADD COLUMN `security` VARCHAR(255) NULL;

🕷 Darknet

ALTER TABLE `players` ADD COLUMN `darknet_name` VARCHAR(50) DEFAULT NULL;
ALTER TABLE `players` ADD COLUMN `darknet_bitcoin` VARCHAR(50) NOT NULL DEFAULT '0';

CREATE TABLE `darknet_items` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner_id` INT(11) NOT NULL,
    `type` INT(11) NOT NULL,
    `classname` VARCHAR(100) NOT NULL,
    `number` INT(11) NOT NULL,
    `price` VARCHAR(50) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `darknet_tchat` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `text` TEXT NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `darknet_transferts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner_id` INT(11) NOT NULL,
    `text` VARCHAR(255) NOT NULL,
    `insert_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

🐕 PetDog

CREATE TABLE `petdog` (
    `id` INT(6) NOT NULL AUTO_INCREMENT,
    `pid` VARCHAR(17) NOT NULL,
    `configName` VARCHAR(17) NOT NULL,
    `name` VARCHAR(32) NOT NULL,
    `alive` INT(6) NOT NULL DEFAULT '1',
    `side` VARCHAR(32) NOT NULL,
    PRIMARY KEY (`id`)
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB ROW_FORMAT=DYNAMIC;