DATABASE.sql
À propos du fichier
- Type de fichier
- Fichier SQL de 72 Ko (text/plain)
- Confidentialité
- Fichier public, envoyé le 2 janvier 2019 à 16:55, depuis l'adresse IP 85.190.x.x (DE)
- Sécurité
- Ne contient aucun Virus ou Malware connus - Dernière vérification: hier
- Statistiques
- La présente page de téléchargement a été vue 562 fois depuis l'envoi du fichier
- Page de téléchargement
-
Aperçu du fichier
-- NeoFrag Alpha 0.2.1
-- https://neofr.ag
--
-- Host: neofrag.localhost
-- Generation Time: Sat, 23 Jun 2018 08:23:34 +0000
-- Server version: MySQL 5.7.21
-- PHP Version: 5.6.35
SET FOREIGN_KEY_CHECKS = 0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET TIME_ZONE = "+02:00";
SET NAMES utf8;
--
-- Database: `neofrag`
--
-- --------------------------------------------------------
--
-- Table structure for table `nf_access`
--
DROP TABLE IF EXISTS `nf_access`;
CREATE TABLE `nf_access` (
`access_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id` int(11) unsigned NOT NULL,
`module` varchar(100) NOT NULL,
`action` varchar(100) NOT NULL,
PRIMARY KEY (`access_id`),
UNIQUE KEY `module_id` (`id`,`module`,`action`),
KEY `module` (`module`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_access`
--
INSERT INTO `nf_access` (`access_id`, `id`, `module`, `action`) VALUES
(11, 1, 'events', 'access_events_type'),
(8, 1, 'forum', 'category_announce'),
(7, 1, 'forum', 'category_delete'),
(9, 1, 'forum', 'category_lock'),
(6, 1, 'forum', 'category_modify'),
(10, 1, 'forum', 'category_move'),
(4, 1, 'forum', 'category_read'),
(5, 1, 'forum', 'category_write'),
(12, 2, 'events', 'access_events_type'),
(3, 2, 'talks', 'delete'),
(1, 2, 'talks', 'read'),
(2, 2, 'talks', 'write'),
(13, 3, 'events', 'access_events_type'),
(14, 4, 'events', 'access_events_type'),
(15, 5, 'events', 'access_events_type');
-- --------------------------------------------------------
--
-- Table structure for table `nf_access_details`
--
DROP TABLE IF EXISTS `nf_access_details`;
CREATE TABLE `nf_access_details` (
`access_id` int(11) unsigned NOT NULL,
`entity` varchar(100) NOT NULL,
`type` enum('group','user') NOT NULL DEFAULT 'group',
`authorized` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`access_id`,`entity`,`type`),
CONSTRAINT `nf_access_details_ibfk_1` FOREIGN KEY (`access_id`) REFERENCES `nf_access` (`access_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_access_details`
--
INSERT INTO `nf_access_details` (`access_id`, `entity`, `type`, `authorized`) VALUES
(2, 'visitors', 'group', '0'),
(3, 'admins', 'group', '1'),
(5, 'visitors', 'group', '0'),
(6, 'admins', 'group', '1'),
(7, 'admins', 'group', '1'),
(8, 'admins', 'group', '1'),
(9, 'admins', 'group', '1'),
(10, 'admins', 'group', '1');
-- --------------------------------------------------------
--
-- Table structure for table `nf_addon`
--
DROP TABLE IF EXISTS `nf_addon`;
CREATE TABLE `nf_addon` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type_id` int(11) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
`data` text,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`,`type_id`),
KEY `type_id` (`type_id`),
CONSTRAINT `nf_addon_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `nf_addon_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_addon`
--
INSERT INTO `nf_addon` (`id`, `type_id`, `name`, `data`) VALUES
(1, NULL, 'authenticator', NULL),
(2, 1, 'access', 'a:1:{s:7:\"enabled\";b:1;}'),
(3, 1, 'addons', 'a:1:{s:7:\"enabled\";b:1;}'),
(4, 1, 'admin', 'a:1:{s:7:\"enabled\";b:1;}'),
(5, 1, 'awards', 'a:1:{s:7:\"enabled\";b:1;}'),
(6, 1, 'comments', 'a:1:{s:7:\"enabled\";b:1;}'),
(7, 1, 'contact', 'a:1:{s:7:\"enabled\";b:1;}'),
(8, 1, 'events', 'a:1:{s:7:\"enabled\";b:1;}'),
(9, 1, 'forum', 'a:1:{s:7:\"enabled\";b:1;}'),
(10, 1, 'gallery', 'a:1:{s:7:\"enabled\";b:1;}'),
(11, 1, 'games', 'a:1:{s:7:\"enabled\";b:1;}'),
(12, 1, 'live_editor', 'a:1:{s:7:\"enabled\";b:1;}'),
(13, 1, 'members', 'a:1:{s:7:\"enabled\";b:1;}'),
(14, 1, 'monitoring', 'a:1:{s:7:\"enabled\";b:1;}'),
(15, 1, 'news', 'a:1:{s:7:\"enabled\";b:1;}'),
(16, 1, 'pages', 'a:1:{s:7:\"enabled\";b:1;}'),
(17, 1, 'partners', 'a:1:{s:7:\"enabled\";b:1;}'),
(18, 1, 'recruits', 'a:1:{s:7:\"enabled\";b:1;}'),
(19, 1, 'search', 'a:1:{s:7:\"enabled\";b:1;}'),
(20, 1, 'settings', 'a:1:{s:7:\"enabled\";b:1;}'),
(21, 1, 'statistics', 'a:1:{s:7:\"enabled\";b:1;}'),
(22, 1, 'talks', 'a:1:{s:7:\"enabled\";b:1;}'),
(23, 1, 'teams', 'a:1:{s:7:\"enabled\";b:1;}'),
(24, 1, 'user', 'a:1:{s:7:\"enabled\";b:1;}'),
(25, 2, 'admin', NULL),
(26, 2, 'azuro', NULL),
(27, 3, 'awards', 'a:1:{s:7:\"enabled\";b:1;}'),
(28, 3, 'breadcrumb', 'a:1:{s:7:\"enabled\";b:1;}'),
(29, 3, 'events', 'a:1:{s:7:\"enabled\";b:1;}'),
(30, 3, 'forum', 'a:1:{s:7:\"enabled\";b:1;}'),
(31, 3, 'gallery', 'a:1:{s:7:\"enabled\";b:1;}'),
(32, 3, 'header', 'a:1:{s:7:\"enabled\";b:1;}'),
(33, 3, 'html', 'a:1:{s:7:\"enabled\";b:1;}'),
(34, 3, 'members', 'a:1:{s:7:\"enabled\";b:1;}'),
(35, 3, 'module', 'a:1:{s:7:\"enabled\";b:1;}'),
(36, 3, 'navigation', 'a:1:{s:7:\"enabled\";b:1;}'),
(37, 3, 'news', 'a:1:{s:7:\"enabled\";b:1;}'),
(38, 3, 'partners', 'a:1:{s:7:\"enabled\";b:1;}'),
(39, 3, 'recruits', 'a:1:{s:7:\"enabled\";b:1;}'),
(40, 3, 'search', 'a:1:{s:7:\"enabled\";b:1;}'),
(41, 3, 'slider', 'a:1:{s:7:\"enabled\";b:1;}'),
(42, 3, 'talks', 'a:1:{s:7:\"enabled\";b:1;}'),
(43, 3, 'teams', 'a:1:{s:7:\"enabled\";b:1;}'),
(44, 3, 'user', 'a:1:{s:7:\"enabled\";b:1;}'),
(45, 4, 'de', 'a:2:{s:5:\"order\";i:3;s:7:\"enabled\";b:1;}'),
(46, 4, 'en', 'a:2:{s:5:\"order\";i:2;s:7:\"enabled\";b:1;}'),
(47, 4, 'es', 'a:2:{s:5:\"order\";i:4;s:7:\"enabled\";b:1;}'),
(48, 4, 'fr', 'a:2:{s:5:\"order\";i:1;s:7:\"enabled\";b:1;}'),
(49, 4, 'it', 'a:2:{s:5:\"order\";i:5;s:7:\"enabled\";b:1;}'),
(50, 4, 'pt', 'a:2:{s:5:\"order\";i:6;s:7:\"enabled\";b:1;}'),
(51, 5, 'battle_net', 'a:4:{s:5:\"order\";i:3;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(52, 5, 'facebook', 'a:4:{s:5:\"order\";i:0;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(53, 5, 'github', 'a:4:{s:5:\"order\";i:6;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(54, 5, 'google', 'a:4:{s:5:\"order\";i:2;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(55, 5, 'linkedin', 'a:4:{s:5:\"order\";i:7;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(56, 5, 'steam', 'a:4:{s:5:\"order\";i:4;s:7:\"enabled\";b:0;s:3:\"dev\";a:1:{s:3:\"key\";s:0:\"\";}s:4:\"prod\";a:1:{s:3:\"key\";s:0:\"\";}}'),
(57, 5, 'twitch', 'a:4:{s:5:\"order\";i:5;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(58, 5, 'twitter', 'a:4:{s:5:\"order\";i:1;s:7:\"enabled\";b:0;s:3:\"dev\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}s:4:\"prod\";a:2:{s:2:\"id\";s:0:\"\";s:6:\"secret\";s:0:\"\";}}'),
(59, 3, 'copyright', 'a:1:{s:7:\"enabled\";b:1;}'),
(60, 1, 'tools', 'a:1:{s:7:\"enabled\";b:1;}'),
(61, 3, 'about', 'a:1:{s:7:\"enabled\";b:1;}');
-- --------------------------------------------------------
--
-- Table structure for table `nf_addon_type`
--
DROP TABLE IF EXISTS `nf_addon_type`;
CREATE TABLE `nf_addon_type` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_addon_type`
--
INSERT INTO `nf_addon_type` (`id`, `name`) VALUES
(1, 'module'),
(2, 'theme'),
(3, 'widget'),
(4, 'language'),
(5, 'authenticator');
-- --------------------------------------------------------
--
-- Table structure for table `nf_awards`
--
DROP TABLE IF EXISTS `nf_awards`;
CREATE TABLE `nf_awards` (
`award_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`team_id` int(11) unsigned DEFAULT NULL,
`game_id` int(11) unsigned NOT NULL,
`image_id` int(11) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
`location` varchar(100) NOT NULL,
`date` date NOT NULL,
`description` text NOT NULL,
`platform` varchar(100) NOT NULL,
`ranking` int(11) unsigned NOT NULL,
`participants` int(11) unsigned NOT NULL,
PRIMARY KEY (`award_id`),
KEY `image_id` (`image_id`),
KEY `game_id` (`game_id`),
KEY `team_id` (`team_id`),
CONSTRAINT `nf_awards_ibfk_1` FOREIGN KEY (`team_id`) REFERENCES `nf_teams` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_awards_ibfk_2` FOREIGN KEY (`game_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_awards_ibfk_3` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_comment`
--
DROP TABLE IF EXISTS `nf_comment`;
CREATE TABLE `nf_comment` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned DEFAULT NULL,
`user_id` int(11) unsigned NOT NULL,
`module_id` int(11) unsigned NOT NULL,
`module` varchar(100) NOT NULL,
`content` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `user_id` (`user_id`),
KEY `module` (`module`),
CONSTRAINT `nf_comment_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `nf_comment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_comment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_dispositions`
--
DROP TABLE IF EXISTS `nf_dispositions`;
CREATE TABLE `nf_dispositions` (
`disposition_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`theme` varchar(100) NOT NULL,
`page` varchar(100) NOT NULL,
`zone` int(11) unsigned NOT NULL,
`disposition` text NOT NULL,
PRIMARY KEY (`disposition_id`),
UNIQUE KEY `theme` (`theme`,`page`,`zone`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_dispositions`
--
INSERT INTO `nf_dispositions` (`disposition_id`, `theme`, `page`, `zone`, `disposition`) VALUES
(1, 'azuro', '*', 0, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:3:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:1;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-7\";}}s:8:\"\0*\0_size\";N;}i:1;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:2;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-3\";}}s:8:\"\0*\0_size\";N;}i:2;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:3;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-2\";}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";s:18:\"align-items-center\";}}}'),
(2, 'azuro', '*', 1, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:4;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";s:18:\"align-items-center\";}}}'),
(3, 'azuro', '*', 2, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:2:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:5;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-7\";}}s:8:\"\0*\0_size\";N;}i:1;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:6;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-5\";}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";s:18:\"align-items-center\";}}}'),
(4, 'azuro', '*', 5, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:2:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:7;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-8\";}}s:8:\"\0*\0_size\";N;}i:1;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:6:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:8;s:9:\"\0*\0_style\";s:9:\"card-dark\";s:8:\"\0*\0_size\";N;}i:1;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:9;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}i:2;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:10;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}i:3;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:11;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}i:4;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:12;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}i:5;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:13;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";s:5:\"col-4\";}}s:9:\"\0*\0_style\";N;}}}'),
(5, 'azuro', '*', 7, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:14;s:9:\"\0*\0_style\";s:16:\"card-transparent\";s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(6, 'azuro', '*', 3, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:0:{}}'),
(7, 'azuro', '*', 4, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:0:{}}'),
(8, 'azuro', '*', 6, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:0:{}}'),
(9, 'azuro', '/', 3, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:15;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(10, 'azuro', '/', 4, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:3:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:16;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-4\";}}s:8:\"\0*\0_size\";N;}i:1;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:17;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-4\";}}s:8:\"\0*\0_size\";N;}i:2;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:18;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";s:5:\"col-4\";}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(11, 'azuro', 'forum/*', 5, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:19;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(12, 'azuro', 'forum/*', 6, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:2:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:24;s:9:\"\0*\0_style\";s:9:\"card-dark\";s:8:\"\0*\0_size\";s:5:\"col-4\";}}s:8:\"\0*\0_size\";N;}i:1;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:25;s:9:\"\0*\0_style\";s:9:\"card-dark\";s:8:\"\0*\0_size\";s:5:\"col-8\";}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(13, 'azuro', 'news/_news/*', 5, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:20;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(14, 'azuro', 'user/*', 5, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:21;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(15, 'azuro', 'search/*', 5, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:22;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}'),
(16, 'azuro', 'gallery/*', 5, 'O:27:\"NF\\NeoFrag\\Libraries\\Array_\":1:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Row\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:27:\"NF\\NeoFrag\\Displayables\\Col\":2:{s:9:\"\0*\0_array\";a:1:{i:0;O:30:\"NF\\NeoFrag\\Displayables\\Widget\":3:{s:10:\"\0*\0_widget\";i:23;s:9:\"\0*\0_style\";N;s:8:\"\0*\0_size\";N;}}s:8:\"\0*\0_size\";N;}}s:9:\"\0*\0_style\";N;}}}');
-- --------------------------------------------------------
--
-- Table structure for table `nf_events`
--
DROP TABLE IF EXISTS `nf_events`;
CREATE TABLE `nf_events` (
`event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type_id` int(11) unsigned NOT NULL,
`user_id` int(11) unsigned NOT NULL,
`image_id` int(11) unsigned DEFAULT NULL,
`title` varchar(100) NOT NULL,
`description` text NOT NULL,
`private_description` text NOT NULL,
`location` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`date_end` timestamp NULL DEFAULT NULL,
`published` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`event_id`),
KEY `user_id` (`user_id`),
KEY `type_id` (`type_id`) USING BTREE,
KEY `image_id` (`image_id`),
CONSTRAINT `nf_events_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `nf_events_types` (`type_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_events_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_events_ibfk_3` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_events_matches`
--
DROP TABLE IF EXISTS `nf_events_matches`;
CREATE TABLE `nf_events_matches` (
`event_id` int(11) unsigned NOT NULL,
`team_id` int(11) unsigned NOT NULL,
`opponent_id` int(11) unsigned NOT NULL,
`mode_id` int(11) unsigned DEFAULT NULL,
`webtv` varchar(100) NOT NULL,
`website` varchar(100) NOT NULL,
PRIMARY KEY (`event_id`),
KEY `opponent_id` (`opponent_id`),
KEY `mode_id` (`mode_id`),
KEY `team_id` (`team_id`),
CONSTRAINT `nf_events_matches_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `nf_events` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_events_matches_ibfk_2` FOREIGN KEY (`opponent_id`) REFERENCES `nf_events_matches_opponents` (`opponent_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_events_matches_ibfk_3` FOREIGN KEY (`mode_id`) REFERENCES `nf_games_modes` (`mode_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_events_matches_opponents`
--
DROP TABLE IF EXISTS `nf_events_matches_opponents`;
CREATE TABLE `nf_events_matches_opponents` (
`opponent_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`image_id` int(11) unsigned DEFAULT NULL,
`title` varchar(100) NOT NULL,
`website` varchar(100) NOT NULL,
`country` varchar(5) NOT NULL,
PRIMARY KEY (`opponent_id`),
KEY `image_id` (`image_id`),
CONSTRAINT `nf_events_matches_opponents_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_events_matches_rounds`
--
DROP TABLE IF EXISTS `nf_events_matches_rounds`;
CREATE TABLE `nf_events_matches_rounds` (
`round_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`event_id` int(11) unsigned NOT NULL,
`map_id` int(11) unsigned DEFAULT NULL,
`score1` int(11) NOT NULL,
`score2` int(11) NOT NULL,
PRIMARY KEY (`round_id`),
KEY `event_id` (`event_id`),
KEY `map_id` (`map_id`),
CONSTRAINT `nf_events_matches_rounds_ibfk_1` FOREIGN KEY (`map_id`) REFERENCES `nf_games_maps` (`map_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_events_matches_rounds_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `nf_events` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_events_participants`
--
DROP TABLE IF EXISTS `nf_events_participants`;
CREATE TABLE `nf_events_participants` (
`event_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`status` smallint(6) unsigned NOT NULL,
PRIMARY KEY (`event_id`,`user_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `nf_events_participants_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `nf_events` (`event_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_events_participants_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_events_types`
--
DROP TABLE IF EXISTS `nf_events_types`;
CREATE TABLE `nf_events_types` (
`type_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL,
`color` varchar(20) NOT NULL,
`icon` varchar(20) NOT NULL,
PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_events_types`
--
INSERT INTO `nf_events_types` (`type_id`, `type`, `title`, `color`, `icon`) VALUES
(1, 1, 'Entrainement', 'success', 'fa-gamepad'),
(2, 1, 'Match amical', 'info', 'fa-angellist'),
(3, 1, 'Match officiel', 'warning', 'fa-trophy'),
(4, 0, 'IRL', 'primary', 'fa-glass'),
(5, 0, 'Divers', 'default', 'fa-comments'),
(6, 1, 'Réunion', 'danger', 'fa-briefcase');
-- --------------------------------------------------------
--
-- Table structure for table `nf_file`
--
DROP TABLE IF EXISTS `nf_file`;
CREATE TABLE `nf_file` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
`path` varchar(100) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `path` (`path`),
KEY `user_id` (`user_id`),
CONSTRAINT `nf_file_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_file`
--
INSERT INTO `nf_file` (`id`, `user_id`, `name`, `path`, `date`) VALUES
(1, 1, 'Sans-titre-2.jpg', './upload/news/categories/ubfuejdfooirqya0pyltfeklja4ew4sn.jpg', '2015-05-30 00:34:16'),
(2, 1, 'logo.png', 'upload/partners/zwvmsjijfljaka4rdblgvlype1lnbwaw.png', '2016-05-07 18:51:53'),
(3, 1, 'logo_black.png', 'upload/partners/y4ofwq2ekppwnfpmnrmnafeivszlg5bd.png', '2016-05-07 18:51:53');
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum`
--
DROP TABLE IF EXISTS `nf_forum`;
CREATE TABLE `nf_forum` (
`forum_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned NOT NULL,
`is_subforum` enum('0','1') NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL,
`description` varchar(100) NOT NULL,
`order` smallint(6) unsigned NOT NULL DEFAULT '0',
`count_topics` int(11) unsigned NOT NULL DEFAULT '0',
`count_messages` int(11) unsigned NOT NULL DEFAULT '0',
`last_message_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`forum_id`),
KEY `last_message_id` (`last_message_id`),
CONSTRAINT `nf_forum_ibfk_1` FOREIGN KEY (`last_message_id`) REFERENCES `nf_forum_messages` (`message_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_forum`
--
INSERT INTO `nf_forum` (`forum_id`, `parent_id`, `is_subforum`, `title`, `description`, `order`, `count_topics`, `count_messages`, `last_message_id`) VALUES
(1, 1, '0', 'Discussions générales', 'Ceci est votre tout premier forum !', 0, 0, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_categories`
--
DROP TABLE IF EXISTS `nf_forum_categories`;
CREATE TABLE `nf_forum_categories` (
`category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`order` smallint(6) unsigned DEFAULT '0',
PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_forum_categories`
--
INSERT INTO `nf_forum_categories` (`category_id`, `title`, `order`) VALUES
(1, 'Général', 0);
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_messages`
--
DROP TABLE IF EXISTS `nf_forum_messages`;
CREATE TABLE `nf_forum_messages` (
`message_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`topic_id` int(11) unsigned NOT NULL,
`user_id` int(11) unsigned DEFAULT NULL,
`message` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`message_id`),
KEY `topic_id` (`topic_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `nf_forum_messages_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `nf_forum_topics` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_forum_messages_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_polls`
--
DROP TABLE IF EXISTS `nf_forum_polls`;
CREATE TABLE `nf_forum_polls` (
`topic_id` int(11) unsigned NOT NULL,
`question` varchar(100) NOT NULL,
`answers` text NOT NULL,
`is_multiple_choice` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_read`
--
DROP TABLE IF EXISTS `nf_forum_read`;
CREATE TABLE `nf_forum_read` (
`user_id` int(11) unsigned NOT NULL,
`forum_id` int(11) unsigned NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`user_id`,`forum_id`),
CONSTRAINT `nf_forum_read_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_topics`
--
DROP TABLE IF EXISTS `nf_forum_topics`;
CREATE TABLE `nf_forum_topics` (
`topic_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`forum_id` int(11) unsigned NOT NULL,
`message_id` int(11) unsigned DEFAULT NULL,
`title` varchar(100) NOT NULL,
`status` enum('-2','-1','0','1') NOT NULL DEFAULT '0',
`views` int(11) unsigned NOT NULL DEFAULT '0',
`count_messages` int(11) unsigned NOT NULL DEFAULT '0',
`last_message_id` int(11) unsigned DEFAULT NULL,
PRIMARY KEY (`topic_id`),
UNIQUE KEY `last_message_id` (`last_message_id`),
KEY `forum_id` (`forum_id`),
KEY `message_id` (`message_id`),
CONSTRAINT `nf_forum_topics_ibfk_1` FOREIGN KEY (`forum_id`) REFERENCES `nf_forum` (`forum_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_forum_topics_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `nf_forum_messages` (`message_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_forum_topics_ibfk_3` FOREIGN KEY (`last_message_id`) REFERENCES `nf_forum_messages` (`message_id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_topics_read`
--
DROP TABLE IF EXISTS `nf_forum_topics_read`;
CREATE TABLE `nf_forum_topics_read` (
`topic_id` int(11) unsigned NOT NULL,
`user_id` int(11) unsigned NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`topic_id`,`user_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `nf_forum_topics_read_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `nf_forum_topics` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_forum_topics_read_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_track`
--
DROP TABLE IF EXISTS `nf_forum_track`;
CREATE TABLE `nf_forum_track` (
`topic_id` int(11) unsigned NOT NULL,
`user_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`topic_id`,`user_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `nf_forum_track_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `nf_forum_topics` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_forum_track_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_forum_url`
--
DROP TABLE IF EXISTS `nf_forum_url`;
CREATE TABLE `nf_forum_url` (
`forum_id` int(11) unsigned NOT NULL,
`url` varchar(100) NOT NULL,
`redirects` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`forum_id`),
CONSTRAINT `nf_forum_url_ibfk_1` FOREIGN KEY (`forum_id`) REFERENCES `nf_forum` (`forum_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_gallery`
--
DROP TABLE IF EXISTS `nf_gallery`;
CREATE TABLE `nf_gallery` (
`gallery_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(11) unsigned NOT NULL,
`image_id` int(11) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
`published` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`gallery_id`),
KEY `category_id` (`category_id`),
KEY `image_id` (`image_id`),
CONSTRAINT `nf_gallery_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `nf_gallery_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_gallery_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_gallery_categories`
--
DROP TABLE IF EXISTS `nf_gallery_categories`;
CREATE TABLE `nf_gallery_categories` (
`category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`image_id` int(11) unsigned DEFAULT NULL,
`icon_id` int(11) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`category_id`),
KEY `image_id` (`image_id`),
KEY `icon_id` (`icon_id`),
CONSTRAINT `nf_gallery_categories_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `nf_gallery_categories_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_gallery_categories_lang`
--
DROP TABLE IF EXISTS `nf_gallery_categories_lang`;
CREATE TABLE `nf_gallery_categories_lang` (
`category_id` int(11) unsigned NOT NULL,
`lang` varchar(5) NOT NULL,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`category_id`,`lang`),
KEY `lang` (`lang`),
CONSTRAINT `nf_gallery_categories_lang_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `nf_gallery_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_gallery_images`
--
DROP TABLE IF EXISTS `nf_gallery_images`;
CREATE TABLE `nf_gallery_images` (
`image_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`thumbnail_file_id` int(11) unsigned NOT NULL,
`original_file_id` int(11) unsigned NOT NULL,
`file_id` int(11) unsigned NOT NULL,
`gallery_id` int(11) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
`description` text NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`views` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`image_id`),
KEY `file_id` (`file_id`),
KEY `gallery_id` (`gallery_id`),
KEY `original_file_id` (`original_file_id`),
KEY `thumbnail_file_id` (`thumbnail_file_id`),
CONSTRAINT `nf_gallery_images_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `nf_file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_gallery_images_ibfk_2` FOREIGN KEY (`gallery_id`) REFERENCES `nf_gallery` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_gallery_images_ibfk_3` FOREIGN KEY (`thumbnail_file_id`) REFERENCES `nf_file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_gallery_images_ibfk_4` FOREIGN KEY (`original_file_id`) REFERENCES `nf_file` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_gallery_lang`
--
DROP TABLE IF EXISTS `nf_gallery_lang`;
CREATE TABLE `nf_gallery_lang` (
`gallery_id` int(11) unsigned NOT NULL,
`lang` varchar(5) NOT NULL,
`title` varchar(100) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`gallery_id`,`lang`),
KEY `lang` (`lang`),
CONSTRAINT `nf_gallery_lang_ibfk_1` FOREIGN KEY (`gallery_id`) REFERENCES `nf_gallery` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_games`
--
DROP TABLE IF EXISTS `nf_games`;
CREATE TABLE `nf_games` (
`game_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` int(11) unsigned DEFAULT NULL,
`image_id` int(11) unsigned DEFAULT NULL,
`icon_id` int(11) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`game_id`),
KEY `image_id` (`image_id`),
KEY `icon_id` (`icon_id`),
KEY `parent_id` (`parent_id`),
CONSTRAINT `nf_games_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `nf_games_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `nf_games_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_games_lang`
--
DROP TABLE IF EXISTS `nf_games_lang`;
CREATE TABLE `nf_games_lang` (
`game_id` int(11) unsigned NOT NULL,
`lang` varchar(5) NOT NULL,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`game_id`,`lang`),
KEY `lang` (`lang`),
CONSTRAINT `nf_games_lang_ibfk_1` FOREIGN KEY (`game_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_games_maps`
--
DROP TABLE IF EXISTS `nf_games_maps`;
CREATE TABLE `nf_games_maps` (
`map_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`game_id` int(11) unsigned NOT NULL,
`image_id` int(11) unsigned DEFAULT NULL,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`map_id`),
KEY `game_id` (`game_id`),
KEY `image_id` (`image_id`),
CONSTRAINT `nf_games_maps_ibfk_1` FOREIGN KEY (`game_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_games_maps_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_games_modes`
--
DROP TABLE IF EXISTS `nf_games_modes`;
CREATE TABLE `nf_games_modes` (
`mode_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`game_id` int(11) unsigned NOT NULL,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`mode_id`),
KEY `game_id` (`game_id`),
CONSTRAINT `nf_games_modes_ibfk_1` FOREIGN KEY (`game_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_groups`
--
DROP TABLE IF EXISTS `nf_groups`;
CREATE TABLE `nf_groups` (
`group_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`color` varchar(20) NOT NULL,
`icon` varchar(20) NOT NULL,
`hidden` enum('0','1') NOT NULL DEFAULT '0',
`auto` enum('0','1') NOT NULL DEFAULT '0',
`order` smallint(6) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_groups_lang`
--
DROP TABLE IF EXISTS `nf_groups_lang`;
CREATE TABLE `nf_groups_lang` (
`group_id` int(11) unsigned NOT NULL,
`lang` varchar(5) NOT NULL,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`group_id`,`lang`),
KEY `lang` (`lang`),
CONSTRAINT `nf_groups_lang_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `nf_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_i18n`
--
DROP TABLE IF EXISTS `nf_i18n`;
CREATE TABLE `nf_i18n` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`lang_id` int(10) unsigned NOT NULL,
`model` varchar(100) DEFAULT NULL,
`model_id` int(10) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `lang_id` (`lang_id`,`model`,`model_id`,`name`) USING BTREE,
KEY `lang_id_2` (`lang_id`),
KEY `model` (`model`),
KEY `model_id` (`model_id`),
KEY `name` (`name`),
CONSTRAINT `nf_i18n_ibfk_1` FOREIGN KEY (`lang_id`) REFERENCES `nf_addon` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_log_db`
--
DROP TABLE IF EXISTS `nf_log_db`;
CREATE TABLE `nf_log_db` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`action` enum('0','1','2') NOT NULL,
`model` varchar(100) NOT NULL,
`primaries` varchar(100) DEFAULT NULL,
`data` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_log_i18n`
--
DROP TABLE IF EXISTS `nf_log_i18n`;
CREATE TABLE `nf_log_i18n` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`language` char(2) NOT NULL,
`key` char(32) NOT NULL,
`locale` text NOT NULL,
`file` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `language` (`language`,`key`,`file`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `nf_news`
--
DROP TABLE IF EXISTS `nf_news`;
CREATE TABLE `nf_news` (
`news_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(11) unsigned NOT NULL,
`user_id` int(11) unsigned NOT NULL,
`image_id` int(11) unsigned DEFAULT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`published` enum('0','1') NOT NULL DEFAULT '0',
`views` int(11) unsigned NOT NULL DEFAULT '0',
`vote` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`news_id`),
KEY `category_id` (`category_id`),
KEY `user_id` (`user_id`),
KEY `image_id` (`image_id`),
CONSTRAINT `nf_news_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `nf_news_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `nf_news_ibfk_4` FOREIGN KEY (`category_id`) REFERENCES `nf_news_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_news`
--
INSERT INTO `nf_news` (`news_id`, `category_id`, `user_id`, `image_id`, `date`, `published`, `views`, `vote`) VALUES
(1, 1, 1, NULL, CURRENT_TIMESTAMP, '1', 0, '0');
-- --------------------------------------------------------
--
-- Table structure for table `nf_news_categories`
--
DROP TABLE IF EXISTS `nf_news_categories`;
CREATE TABLE `nf_news_categories` (
`category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`image_id` int(11) unsigned DEFAULT NULL,
`icon_id` int(11) unsigned DEFAULT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`category_id`),
KEY `image_id` (`image_id`),
KEY `icon_id` (`icon_id`),
CONSTRAINT `nf_news_categories_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `nf_news_categories_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_file` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_news_categories`
--
INSERT INTO `nf_news_categories` (`category_id`, `image_id`, `icon_id`, `name`) VALUES
(1, 1, NULL, 'general');
-- --------------------------------------------------------
--
-- Table structure for table `nf_news_categories_lang`
--
DROP TABLE IF EXISTS `nf_news_categories_lang`;
CREATE TABLE `nf_news_categories_lang` (
`category_id` int(11) unsigned NOT NULL,
`lang` varchar(5) NOT NULL,
`title` varchar(100) NOT NULL,
PRIMARY KEY (`category_id`,`lang`),
KEY `lang` (`lang`),
CONSTRAINT `nf_news_categories_lang_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `nf_news_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_news_categories_lang`
--
INSERT INTO `nf_news_categories_lang` (`category_id`, `lang`, `title`) VALUES
(1, 'fr', 'Général');
-- --------------------------------------------------------
--
-- Table structure for table `nf_news_lang`
--
DROP TABLE IF EXISTS `nf_news_lang`;
CREATE TABLE `nf_news_lang` (
`news_id` int(11) unsigned NOT NULL,
`lang` varchar(5) NOT NULL,
`title` varchar(100) NOT NULL,
`introduction` text NOT NULL,
`content` text NOT NULL,
`tags` text NOT NULL,
PRIMARY KEY (`news_id`,`lang`),
KEY `lang` (`lang`),
CONSTRAINT `nf_news_lang_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `nf_news` (`news_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `nf_news_lang`
--
INSERT INTO `nf_news_lang` (`news_id`, `lang`, `title`, `introduction`, `content`, `tags`) VALUES
(1, 'fr', 'Bienvenue sur votre site NeoFrag Alpha !', 'Nec vox accusatoris ulla licet subditicii in his malorum quaerebatur acervis ut saltem specie tenus crimina praescriptis legum \r\ncommitterentur, quod aliquotiens fecere principes saevi: sed quicquid \r\nCaesaris mplacabilitati sedisset, id velut fas iusque perpensum \r\nconfestim urgebatur impleri.', 'Omitto iuris dictionem in libera civitate contra leges senatusque consulta; caedes relinquo; libidines praetereo, quarum acerbissimum extat indicium et ad insignem memoriam turpitudinis et paene ad iustum odium imperii nostri, quod constat nobilissimas virgines se in puteos abiecisse et morte voluntaria necessariam turpitudinem depulisse. Nec haec idcirco omitto, quod non gravissima sint, sed quia nunc sine teste dico.', 'NeoFrag,Cms,Alpha');
-- --------------------------------------------------------
--
-- Table structure for table `nf_pages`
--
DROP TABLE IF EXISTS `nf_pages`;
CREATE TABLE `nf_pages` (
`page_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`published` enum('0','1') NOT NULL DEFAULT '0',
Partager le fichier DATABASE.sql sur le Web et les réseaux sociaux:
Télécharger le fichier DATABASE.sql
