/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50647
 Source Host           : localhost:3306
 Source Schema         : cms_nebu

 Target Server Type    : MySQL
 Target Server Version : 50647
 File Encoding         : 65001

 Date: 28/08/2025 12:03:45
*/


-- ----------------------------
-- Table structure for news
-- ----------------------------
CREATE TABLE `news`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `excerpt` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cover_url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `category` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `author` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uq_news_slug`(`slug`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (1, 'Bienvenue sur NebulaCMS', 'bienvenue', 'Découvrez le nouveau site au style Frigost Karashii.', 'https://www.gamosaurus.com/wp-content/uploads/dofus/wakfu-s4/2560x1440_Yugo-Copie.jpg', 'NEWS', 'Contenu complet de la news…', 'Nebula', '2025-08-27 16:15:53');
INSERT INTO `news` VALUES (2, 'Mise à jour du serveur', 'maj-serveur', 'Nouvelles fonctionnalités et correctifs.', 'https://assets.tv5mondeplus.com/imagescaler002/tv5monde/tv5mondeplus/assets/107370746_74079A/posters/bdd93821e95bfd67ba2c2376435990b0/bdd93821e95bfd67ba2c2376435990b0.jpg?w=1273', 'RSA', 'Détails de la mise à jour…', 'Equipe', '2025-08-27 16:15:53');
INSERT INTO `news` VALUES (3, 'zizi bite hilicoupere', 'zizi', 'Il prend li kalash et il alloume tout l\'monde', 'https://www.ecranlarge.com/content/uploads/2020/03/wakfu-photo-1171020-630x380.jpg', 'KALASH', '🚧 Site en cours de développement 🚧\r\n\r\nBienvenue sur notre nouveau site !\r\nCelui-ci est actuellement en construction afin de vous offrir bientôt \r\nune plateforme complète, claire et facile d’utilisation.\r\n\r\n✅ De nouvelles fonctionnalités arriveront progressivement.\r\n✅ Les sections principales seront régulièrement mises à jour.\r\n✅ Votre expérience sera au centre de notre travail.\r\n\r\nMerci de votre patience et de votre soutien 🙏\r\nRestez connectés, l’aventure ne fait que commencer !\r\n', 'Kalash', '2025-08-28 11:07:52');
INSERT INTO `news` VALUES (4, 'bite chate couill', 'coptere', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (5, 'bite chate couill', 'coptere1', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (6, 'bite chate couill', 'coptere2', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (7, 'bite chate couill', 'coptere3', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (8, 'bite chate couill', 'coptere4', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (9, 'bite chate couill', 'coptere5', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (10, 'bite chate couill', 'coptere6', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');
INSERT INTO `news` VALUES (11, 'bite chate couill', 'coptere7', 'bite chate couill bite chate couill', 'https://media.ouest-france.fr/v1/pictures/41b0e97edfbbdb3a265526e58f36682b-wakfu-la-quete-des-six-dofus-eliatropes-dessin-anime-dessin-anime-programme-tv.jpg?width=1260&height=708&sign=8249615b8759172e846d515919dcaa5f17569d7ce9048f6c668deb92d207a6b2&client_id=bpservices', 'LICORNE', 'J\'aime les licornes et leurs jolie corne', 'Licorne', '2025-08-28 11:37:17');

-- ----------------------------
-- Table structure for stump_links
-- ----------------------------
CREATE TABLE `stump_links`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED NOT NULL,
  `stump_login` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uniq_user_login`(`user_id`, `stump_login`) USING BTREE,
  UNIQUE INDEX `uniq_stump_login`(`stump_login`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of stump_links
-- ----------------------------
INSERT INTO `stump_links` VALUES (1, 6, 'zebitriiste', '2025-08-28 03:32:46');
INSERT INTO `stump_links` VALUES (15, 7, 'sucemabite', '2025-08-28 09:51:26');
INSERT INTO `stump_links` VALUES (16, 7, 'sucmabite2', '2025-08-28 09:58:55');
INSERT INTO `stump_links` VALUES (17, 7, 'sucemabite3', '2025-08-28 10:06:41');
INSERT INTO `stump_links` VALUES (18, 7, 'sucemabite4', '2025-08-28 10:07:35');
INSERT INTO `stump_links` VALUES (19, 7, 'sucemabite5', '2025-08-28 10:07:47');
INSERT INTO `stump_links` VALUES (20, 7, 'sucemabite6', '2025-08-28 10:08:05');

