Minecraft THGBM's World

boozaa

Hummm...boozaa

Inscription : 29 Jan 2011

Messages : 1 771

Passer Worldguard sous MySQL

Plop,

comme j'ai un peu galéré pour la création des tables nécessaires à Worldguard en corrigeant quelques relations je me dis que ça pourrait servir à quelqu'un d'autre donc voici le SQL à importer si vous voulez utiliser Worldguard sous MySQL :

-- --------------------------------------------------------

--
-- Structure de la table `region`
--

CREATE TABLE IF NOT EXISTS `region` (
  `id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned NOT NULL DEFAULT '1',
  `type` enum('cuboid','poly2d','global') COLLATE utf8_bin NOT NULL,
  `priority` smallint(6) NOT NULL DEFAULT '0',
  `parent` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`,`world_id`),
  KEY `fk_region_world` (`world_id`),
  KEY `parent` (`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- --------------------------------------------------------

--
-- Structure de la table `region_cuboid`
--

CREATE TABLE IF NOT EXISTS `region_cuboid` (
  `region_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned NOT NULL DEFAULT '1',
  `min_x` bigint(20) NOT NULL,
  `min_y` bigint(20) NOT NULL,
  `min_z` bigint(20) NOT NULL,
  `max_x` bigint(20) NOT NULL,
  `max_y` bigint(20) NOT NULL,
  `max_z` bigint(20) NOT NULL,
  PRIMARY KEY (`region_id`,`world_id`),
  KEY `fk_region_cuboid_region` (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- --------------------------------------------------------

--
-- Structure de la table `region_flag`
--

CREATE TABLE IF NOT EXISTS `region_flag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `region_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned DEFAULT '1',
  `flag` varchar(45) COLLATE utf8_bin NOT NULL,
  `value` varchar(256) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_flags_region` (`region_id`,`world_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=35 ;


-- --------------------------------------------------------

--
-- Structure de la table `region_groups`
--

CREATE TABLE IF NOT EXISTS `region_groups` (
  `region_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned NOT NULL DEFAULT '1',
  `group_id` int(10) unsigned NOT NULL,
  `owner` tinyint(1) NOT NULL,
  PRIMARY KEY (`region_id`,`world_id`,`group_id`),
  KEY `fk_region_groups_region` (`region_id`),
  KEY `fk_region_groups_group` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `region_groups`
--


-- --------------------------------------------------------

--
-- Structure de la table `region_players`
--

CREATE TABLE IF NOT EXISTS `region_players` (
  `region_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned NOT NULL DEFAULT '1',
  `user_id` int(10) unsigned NOT NULL,
  `owner` tinyint(1) NOT NULL,
  PRIMARY KEY (`region_id`,`world_id`,`user_id`),
  KEY `fk_region_users_region` (`region_id`),
  KEY `fk_region_users_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


-- --------------------------------------------------------

--
-- Structure de la table `region_poly2d`
--

CREATE TABLE IF NOT EXISTS `region_poly2d` (
  `region_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned NOT NULL DEFAULT '1',
  `min_y` int(11) NOT NULL,
  `max_y` int(11) NOT NULL,
  PRIMARY KEY (`region_id`,`world_id`),
  KEY `fk_region_poly2d_region` (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `region_poly2d`
--


-- --------------------------------------------------------

--
-- Structure de la table `region_poly2d_point`
--

CREATE TABLE IF NOT EXISTS `region_poly2d_point` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `region_id` varchar(128) COLLATE utf8_bin NOT NULL,
  `world_id` int(10) unsigned DEFAULT '1',
  `x` bigint(20) NOT NULL,
  `z` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_region_poly2d_point_region_poly2d` (`region_id`,`world_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

--
-- Contenu de la table `region_poly2d_point`
--


-- --------------------------------------------------------

--
-- Structure de la table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;


-- --------------------------------------------------------

--
-- Structure de la table `world`
--

CREATE TABLE IF NOT EXISTS `world` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=2 ;

--
-- Contenu de la table `world`
--

INSERT IGNORE INTO `world` (`id`, `name`) VALUES
(1, 'world');

--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `region`
--
ALTER TABLE `region`
  ADD CONSTRAINT `fk_region_world1` FOREIGN KEY (`world_id`) REFERENCES `world` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `parent` FOREIGN KEY (`parent`) REFERENCES `region` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Contraintes pour la table `region_cuboid`
--
ALTER TABLE `region_cuboid`
  ADD CONSTRAINT `fk_region_cuboid_region` FOREIGN KEY (`region_id`, `world_id`) REFERENCES `region` (`id`, `world_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `region_flag`
--
ALTER TABLE `region_flag`
  ADD CONSTRAINT `fk_flags_region` FOREIGN KEY (`region_id`, `world_id`) REFERENCES `region` (`id`, `world_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `region_groups`
--
ALTER TABLE `region_groups`
  ADD CONSTRAINT `fk_region_groups_group` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_region_groups_region` FOREIGN KEY (`region_id`, `world_id`) REFERENCES `region` (`id`, `world_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `region_players`
--
ALTER TABLE `region_players`
  ADD CONSTRAINT `fk_region_users_region` FOREIGN KEY (`region_id`, `world_id`) REFERENCES `region` (`id`, `world_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_region_users_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `region_poly2d`
--
ALTER TABLE `region_poly2d`
  ADD CONSTRAINT `fk_region_poly2d_region` FOREIGN KEY (`region_id`, `world_id`) REFERENCES `region` (`id`, `world_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `region_poly2d_point`
--
ALTER TABLE `region_poly2d_point`
  ADD CONSTRAINT `fk_region_poly2d_point_region_poly2d` FOREIGN KEY (`region_id`, `world_id`) REFERENCES `region_poly2d` (`region_id`, `world_id`) ON DELETE CASCADE ON UPDATE CASCADE;

Prenez garde toutefois à modifier la ligne insérée dans la table 'world' pour y mettre le nom de votre monde par défaut (celui du server.properties) dans la colonne 'name'.

Enjoy,

tickleman

Administrateur

Inscription : 30 Jan 2011

Messages : 4 000

Re : Passer Worldguard sous MySQL

Ha tiens je savais pas qu'on pouvait mettre la config dans MySQL. Bon à savoir.

---

Admin un jour, Creeper toujours