Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.4.11.1deb2+deb7u1
- -- http://www.phpmyadmin.net
- --
- -- Client: localhost
- -- Généré le: Mer 01 Avril 2015 à 15:11
- -- Version du serveur: 5.5.38
- -- Version de PHP: 5.4.4-14+deb7u14
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Base de données: `nation_light`
- --
- -- --------------------------------------------------------
- --
- -- Structure de la table `citizens`
- --
- CREATE TABLE IF NOT EXISTS `citizens` (
- `uuid` varchar(64) NOT NULL,
- `name` varchar(16) NOT NULL,
- `last_connexion` bigint(20) NOT NULL,
- `unban_time` bigint(20) NOT NULL,
- `connexion_time` bigint(20) NOT NULL,
- PRIMARY KEY (`uuid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Contenu de la table `citizens`
- --
- INSERT INTO `citizens` (`uuid`, `name`, `last_connexion`, `unban_time`, `connexion_time`) VALUES
- ('02424d04-3bfb-4808-bdc1-8e89f98341fa', 'BlixoWW', 1427044774, 0, 3858020),
- ('16351a5b-c7e7-4590-8c3d-78967463216d', 'thehugerot', 1426886107, 0, 7413512),
- ('49ada240-e1a5-46b1-b5c8-9f751a080b1f', 'stradivare', 1427138468, 0, 431808),
- ('4de28814-6e6a-4000-bab5-b0a0d18674bd', 'DixOr51', 1426882788, 0, 863239),
- ('509e991f-83ae-4c6a-b5dd-a02f5a5730a1', 'ilies91', 1426951517, 0, 449436),
- ('5bd81c1c-4369-4920-b658-19e94874eced', 'spizerf3', 1427130656, 0, 719155),
- ('65aa971b-df82-4489-95d6-4e8f08bd1645', 'lucioledeeper', 1427139199, 0, 6530213),
- ('68257b34-9a14-43c2-af5d-acfa98daa1b4', 'Purboule', 1427010754, 0, -1425273631219),
- ('685bd023-7a04-42d2-9074-ca37e4e0ba60', 'MrBatou', 1426952533, 0, 305),
- ('6dce018c-7b41-41f9-9fd2-b5f9928827c8', 'Dopeulien', 1427043304, 0, 4997549),
- ('736b3f0b-cdcf-49b3-96d1-284dcf3015ab', 'Kiminou', 1427132894, 0, 12311305),
- ('939f28f0-a409-48ec-a0db-04f9bb82d294', 'RoRo_PvP', 1426877486, 0, 1732036),
- ('93e0c69b-4750-480f-8583-4b7200048ae0', 'Revenge69', 1426886224, 0, 23759),
- ('9ff58b53-47d7-48c8-a4f9-848a4548d17a', 'PapyCube', 1426882266, 0, 5323),
- ('a3814c03-7378-4bd2-8684-ac90e99a1cd4', 'Zedbar', 1427128232, 0, 2531402),
- ('aacf5cb6-afe0-46f3-987d-0ce178e566fb', 'first4ever', 1426949073, 0, 5167),
- ('c3862581-e15f-4974-8edd-59d75fc7261f', 'Delyios', 1427149017061, 0, -4277165104850),
- ('dd7b313b-d28c-4f39-9ffc-5a0e0f32a0cc', 'Soundz59', 1427129882, 0, 2014547),
- ('e42e5c76-1789-4c78-ae93-4354fbd9a826', 'Kiloren', 1427131685, 0, 5690995),
- ('ea23d2d8-ecf5-4e14-a389-bf936ef66a7e', 'lapinoufou', 1427051867, 0, 1151028),
- ('feac5278-0c23-41b3-9c06-0d5ac9edbc43', 'Lemmy1916', 1426952553, 0, 347);
- -- --------------------------------------------------------
- --
- -- Structure de la table `conditions`
- --
- CREATE TABLE IF NOT EXISTS `conditions` (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `nomCondition` varchar(150) NOT NULL,
- `idObjectifAssocie` int(10) NOT NULL,
- `typeCondition` varchar(100) NOT NULL,
- `conditionRempli` tinyint(1) NOT NULL,
- `parametreCondition` varchar(400) NOT NULL,
- `queteur` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=213 ;
- --
- -- Contenu de la table `conditions`
- --
- INSERT INTO `conditions` (`id`, `nomCondition`, `idObjectifAssocie`, `typeCondition`, `conditionRempli`, `parametreCondition`, `queteur`) VALUES
- (209, 'Finir', 219, 'AllerA', 0, 'Trébuchet;670.0;40.0;-156.0;596.0;43.0;-145.0', 'admin'),
- (210, 'Finir', 220, 'AllerA', 1, 'Trébuchet;670.0;43.0;-145.0;596.0;40.0;-156.0', 'stradivare'),
- (211, 'Finir', 221, 'AllerA', 1, 'Trébuchet;670.0;43.0;-145.0;596.0;40.0;-156.0', 'stradivare'),
- (212, 'Finir', 222, 'AllerA', 1, 'Trébuchet;670.0;43.0;-145.0;596.0;40.0;-156.0', 'stradivare');
- -- --------------------------------------------------------
- --
- -- Structure de la table `donjons`
- --
- CREATE TABLE IF NOT EXISTS `donjons` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(64) NOT NULL,
- `timers` bigint(20) NOT NULL,
- `players_size` bigint(20) NOT NULL,
- `world_out` varchar(32) NOT NULL,
- `spawn_in` bigint(20) NOT NULL,
- `spawn_out` bigint(20) NOT NULL,
- `spawn_end` bigint(20) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
- --
- -- Contenu de la table `donjons`
- --
- INSERT INTO `donjons` (`id`, `name`, `timers`, `players_size`, `world_out`, `spawn_in`, `spawn_out`, `spawn_end`) VALUES
- (2, 'keladar', 0, 65537, 'keladar', 281139979616219, 281152863731672, 281152863731672),
- (7, 'Velchios', 0, 65537, 'Velchios', 1563371307258, 1520421634300, 1520421634296);
- -- --------------------------------------------------------
- --
- -- Structure de la table `evenements`
- --
- CREATE TABLE IF NOT EXISTS `evenements` (
- `id` int(10) NOT NULL AUTO_INCREMENT,
- `nomEvenement` varchar(150) NOT NULL,
- `idObjectifAssocie` int(10) NOT NULL,
- `typeEvenement` varchar(100) NOT NULL,
- `parametreEvenement` varchar(400) NOT NULL,
- `evenementRempli` tinyint(1) NOT NULL,
- `queteur` varchar(100) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=61 ;
- -- --------------------------------------------------------
- --
- -- Structure de la table `grids`
- --
- CREATE TABLE IF NOT EXISTS `grids` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `chunk_x` int(11) NOT NULL,
- `chunk_z` int(11) NOT NULL,
- `locality_id` int(11) NOT NULL,
- `world` varchar(32) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Structure de la table `localities`
- --
- CREATE TABLE IF NOT EXISTS `localities` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(64) NOT NULL,
- `type` varchar(16) NOT NULL,
- `min_y` tinyint(4) NOT NULL,
- `max_y` tinyint(4) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Structure de la table `objectifs`
- --
- CREATE TABLE IF NOT EXISTS `objectifs` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `nomObjectif` varchar(100) NOT NULL,
- `idQueteAssocie` varchar(100) NOT NULL,
- `objectifRempli` tinyint(1) NOT NULL,
- `queteur` varchar(100) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=223 ;
- --
- -- Contenu de la table `objectifs`
- --
- INSERT INTO `objectifs` (`id`, `nomObjectif`, `idQueteAssocie`, `objectifRempli`, `queteur`) VALUES
- (219, 'Gravir la tour', '78', 0, 'admin'),
- (220, 'Gravir la tour', '79', 1, 'stradivare'),
- (221, 'Gravir la tour', '80', 1, 'stradivare'),
- (222, 'Gravir la tour', '81', 1, 'stradivare');
- -- --------------------------------------------------------
- --
- -- Structure de la table `quetes`
- --
- CREATE TABLE IF NOT EXISTS `quetes` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `nomQuete` varchar(100) NOT NULL,
- `descriptionQuete` text NOT NULL,
- `descriptionReussite` text NOT NULL,
- `descriptionEchec` text NOT NULL,
- `messageRejet` text NOT NULL,
- `jourOuNuit` varchar(100) NOT NULL,
- `nationRequise` varchar(100) NOT NULL,
- `pointPVE` int(10) NOT NULL,
- `pointHonneur` int(10) NOT NULL,
- `queteAnterieur` varchar(100) NOT NULL,
- `ordreCondition` tinyint(1) NOT NULL,
- `queteRempli` tinyint(1) NOT NULL,
- `queteur` varchar(100) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=82 ;
- --
- -- Contenu de la table `quetes`
- --
- INSERT INTO `quetes` (`id`, `nomQuete`, `descriptionQuete`, `descriptionReussite`, `descriptionEchec`, `messageRejet`, `jourOuNuit`, `nationRequise`, `pointPVE`, `pointHonneur`, `queteAnterieur`, `ordreCondition`, `queteRempli`, `queteur`) VALUES
- (78, 'Tour du désespoir', 'J''ai oublié mon kebab en haut de la tour, va me le chercher', 'GG WP N00B Team, only bronze elo with me, I report U all', 'Alors victime, toujours une merde ?', 'Pas de message de rejet', 'Parametre desactivé', 'Parametre desactivé', -1, -1, 'Parametre desactivé', 0, 0, 'admin'),
- (79, 'Tour du désespoir', 'J''ai', 'GG', 'Alors', 'Pas de message de rejet', 'Parametre desactivé', 'Parametre desactivé', -1, -1, 'Parametre desactivé', 0, 1, 'stradivare'),
- (80, 'Tour du désespoir', 'J''ai oublié mon kebab en haut de la tour, va me le chercher', 'GG', 'Alors', 'Pas de message de rejet', 'Parametre desactivé', 'Parametre desactivé', -1, -1, 'Parametre desactivé', 0, 1, 'stradivare'),
- (81, 'Tour du désespoir', 'J''ai oublié mon kebab en haut de la tour, va me le chercher', 'GG WP N00B Team, only bronze elo with me, I report U all', 'Alors victime, toujours une merde ?', 'Pas de message de rejet', 'Parametre desactivé', 'Parametre desactivé', -1, -1, 'Parametre desactivé', 0, 1, 'stradivare');
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement