Titre du sujet : Re: Conversion de base de données
par krysto sur 12/10/2010 23:12:19
les tables articles boost (phpboost) à convertir vers xoops : News
--
-- Structure de la table `phpboost_articles`
--
CREATE TABLE IF NOT EXISTS `phpboost_articles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idcat` int(11) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '',
`contents` mediumtext NOT NULL,
`icon` varchar(255) NOT NULL DEFAULT '',
`timestamp` int(11) NOT NULL DEFAULT '0',
`visible` tinyint(1) NOT NULL DEFAULT '0',
`start` int(11) NOT NULL DEFAULT '0',
`end` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`views` mediumint(9) NOT NULL DEFAULT '0',
`users_note` text,
`nbrnote` mediumint(9) NOT NULL DEFAULT '0',
`note` float NOT NULL DEFAULT '0',
`nbr_com` int(11) unsigned NOT NULL DEFAULT '0',
`lock_com` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idcat` (`idcat`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `contents` (`contents`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `phpboost_articles`
--
INSERT INTO `phpboost_articles` (`id`, `idcat`, `title`, `contents`, `icon`, `timestamp`, `visible`, `start`, `end`, `user_id`, `views`, `users_note`, `nbrnote`, `note`, `nbr_com`, `lock_com`) VALUES
(1, 1, 'Débuter avec le module Articles', 'Ce bref article va vous donner quelques conseils simples pour prendre en main ce module.<br />rn<br />rn<ul class="bb_ul">rn <li class="bb_li">Pour configurer votre module, <a href="/articles/admin_articles_config.php">cliquez ici</a>rn </li><li class="bb_li">Pour ajouter des catégories : <a href="/admin_articles_cat_add.php">cliquez ici</a> (les catégories et sous catégories sont à l''infini)rn </li><li class="bb_li">Pour ajouter un article, vous avez 2 solutions (les 2 arrivent au même lien)<br />rn <ul class="bb_ul">rn <li class="bb_li">Dans la catégorie souhaitée, cliquez sur le bouton ''Ajout''rn </li><li class="bb_li"><a href="/articles/admin_articles_add.php">Cliquez ici</a> pour l''ajouter via le panneau d''administration du module.<br />rn </li></ul>rn </li><li class="bb_li">Pour mettre en page vos articles, vous pouvez utiliser le langage bbcode ou l''éditeur WYSIWYG (cf cet <a href="http://www.phpboost.com/articles/articles-6-61+mise-en-page-du-contenu.php">article</a>)<br />rn</li></ul><br />rn<br />rnPour en savoir plus, n''hésitez pas à consulter la documentation du module sur le site de <a href="http://www.phpboost.com">PHPBoost</a>.<br />rn<br />rn<br />rnBonne utilisation de ce module.', '', 1242496981, 1, 0, 0, 1, 3, '0', 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_articles_cats`
--
CREATE TABLE IF NOT EXISTS `phpboost_articles_cats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_left` int(11) NOT NULL DEFAULT '0',
`id_right` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT '',
`contents` text,
`nbr_articles_visible` mediumint(9) unsigned NOT NULL DEFAULT '0',
`nbr_articles_unvisible` mediumint(9) unsigned NOT NULL DEFAULT '0',
`icon` varchar(255) NOT NULL DEFAULT '',
`aprob` tinyint(1) NOT NULL DEFAULT '0',
`auth` text,
PRIMARY KEY (`id`),
KEY `id_left` (`id_left`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `phpboost_articles_cats`
--
INSERT INTO `phpboost_articles_cats` (`id`, `id_left`, `id_right`, `level`, `name`, `contents`, `nbr_articles_visible`, `nbr_articles_unvisible`, `icon`, `aprob`, `auth`) VALUES
(1, 1, 2, 0, 'Catégorie de test', 'Articles de démonstration', 1, 0, 'articles.png', 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;}');
les tables boost forum à convertir vers xoops NewBB
--
-- Structure de la table `phpboost_forum_alerts`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_alerts` (
`id` mediumint(11) NOT NULL AUTO_INCREMENT,
`idcat` int(11) NOT NULL DEFAULT '0',
`idtopic` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`contents` text,
`user_id` int(11) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`idmodo` int(11) NOT NULL DEFAULT '0',
`timestamp` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idtopic` (`idtopic`,`user_id`,`idmodo`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Contenu de la table `phpboost_forum_alerts`
--
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_cats`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_cats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_left` int(11) NOT NULL DEFAULT '0',
`id_right` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`name` varchar(100) NOT NULL DEFAULT '',
`subname` varchar(150) NOT NULL DEFAULT '',
`nbr_topic` mediumint(9) NOT NULL DEFAULT '0',
`nbr_msg` mediumint(9) NOT NULL DEFAULT '0',
`last_topic_id` int(11) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '1',
`aprob` tinyint(1) NOT NULL DEFAULT '0',
`auth` text,
`url` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `last_topic_id` (`last_topic_id`),
KEY `id_left` (`id_left`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;
--
-- Contenu de la table `phpboost_forum_cats`
--
INSERT INTO `phpboost_forum_cats` (`id`, `id_left`, `id_right`, `level`, `name`, `subname`, `nbr_topic`, `nbr_msg`, `last_topic_id`, `status`, `aprob`, `auth`, `url`) VALUES
(1, 1, 4, 0, 'Catégorie de test', 'Catégorie de test', 1, 1, 1, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;s:2:"r2";i:7;}', ''),
(2, 2, 3, 1, 'Forum de test', 'Forum de test', 1, 1, 1, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;s:2:"r2";i:7;}', '');
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_history`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_history` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action` varchar(50) NOT NULL DEFAULT '',
`user_id` int(11) NOT NULL DEFAULT '0',
`user_id_action` int(11) NOT NULL DEFAULT '0',
`url` varchar(255) NOT NULL,
`timestamp` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Contenu de la table `phpboost_forum_history`
--
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_msg`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_msg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idtopic` int(11) NOT NULL DEFAULT '0',
`user_id` mediumint(9) NOT NULL DEFAULT '0',
`contents` text,
`timestamp` int(11) NOT NULL DEFAULT '0',
`timestamp_edit` int(11) NOT NULL DEFAULT '0',
`user_id_edit` int(11) NOT NULL DEFAULT '0',
`user_ip` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `idtopic` (`idtopic`,`user_id`,`timestamp`),
FULLTEXT KEY `contenu` (`contents`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `phpboost_forum_msg`
--
INSERT INTO `phpboost_forum_msg` (`id`, `idtopic`, `user_id`, `contents`, `timestamp`, `timestamp_edit`, `user_id_edit`, `user_ip`) VALUES
(1, 1, 1, 'Message de test sur le forum PHPBoost', 1286917362, 0, 0, '127.0.0.1');
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_poll`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_poll` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idtopic` int(11) NOT NULL DEFAULT '0',
`question` varchar(255) NOT NULL DEFAULT '',
`answers` text,
`voter_id` text,
`votes` text,
`type` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idtopic` (`idtopic`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Contenu de la table `phpboost_forum_poll`
--
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_topics`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_topics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idcat` int(11) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '',
`subtitle` varchar(75) NOT NULL DEFAULT '',
`user_id` int(11) NOT NULL DEFAULT '0',
`nbr_msg` mediumint(9) NOT NULL DEFAULT '0',
`nbr_views` mediumint(9) NOT NULL DEFAULT '0',
`last_user_id` int(11) NOT NULL DEFAULT '0',
`last_msg_id` int(11) NOT NULL DEFAULT '0',
`last_timestamp` int(11) NOT NULL DEFAULT '0',
`first_msg_id` int(11) NOT NULL DEFAULT '0',
`type` tinyint(1) NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`aprob` tinyint(1) NOT NULL DEFAULT '0',
`display_msg` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idcat` (`idcat`,`last_user_id`,`last_timestamp`,`type`),
FULLTEXT KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `phpboost_forum_topics`
--
INSERT INTO `phpboost_forum_topics` (`id`, `idcat`, `title`, `subtitle`, `user_id`, `nbr_msg`, `nbr_views`, `last_user_id`, `last_msg_id`, `last_timestamp`, `first_msg_id`, `type`, `status`, `aprob`, `display_msg`) VALUES
(1, 2, 'Test', 'Sujet de test', 1, 1, 0, 1, 1, 1286917362, 1, 0, 1, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_track`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_track` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idtopic` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`track` tinyint(1) NOT NULL DEFAULT '0',
`pm` tinyint(1) NOT NULL DEFAULT '0',
`mail` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `idtopic` (`idtopic`,`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Contenu de la table `phpboost_forum_track`
--
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_forum_view`
--
CREATE TABLE IF NOT EXISTS `phpboost_forum_view` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idtopic` int(11) NOT NULL DEFAULT '0',
`last_view_id` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`timestamp` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idv` (`idtopic`,`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Contenu de la table `phpboost_forum_view`
--
et les tables boost galery à convertir vers xoops TadGallerie
--
-- Structure de la table `phpboost_gallery`
--
CREATE TABLE IF NOT EXISTS `phpboost_gallery` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idcat` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`path` varchar(255) NOT NULL DEFAULT '',
`width` mediumint(9) NOT NULL DEFAULT '0',
`height` mediumint(9) NOT NULL DEFAULT '0',
`weight` mediumint(9) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL DEFAULT '0',
`aprob` tinyint(1) NOT NULL DEFAULT '0',
`views` int(11) NOT NULL DEFAULT '0',
`timestamp` int(11) NOT NULL DEFAULT '0',
`users_note` text,
`nbrnote` mediumint(9) NOT NULL DEFAULT '0',
`note` float NOT NULL DEFAULT '0',
`nbr_com` int(11) unsigned NOT NULL DEFAULT '0',
`lock_com` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idcat` (`idcat`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `phpboost_gallery`
--
INSERT INTO `phpboost_gallery` (`id`, `idcat`, `name`, `path`, `width`, `height`, `weight`, `user_id`, `aprob`, `views`, `timestamp`, `users_note`, `nbrnote`, `note`, `nbr_com`, `lock_com`) VALUES
(1, 1, 'PHPBoost 3!', 'phpboost3.jpg', 320, 264, 15614, 1, 1, 0, 1286917363, '', 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Structure de la table `phpboost_gallery_cats`
--
CREATE TABLE IF NOT EXISTS `phpboost_gallery_cats` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_left` int(11) NOT NULL DEFAULT '0',
`id_right` int(11) NOT NULL DEFAULT '0',
`level` int(11) NOT NULL DEFAULT '0',
`name` varchar(150) NOT NULL DEFAULT '',
`contents` text,
`nbr_pics_aprob` mediumint(9) unsigned NOT NULL DEFAULT '0',
`nbr_pics_unaprob` mediumint(9) unsigned NOT NULL DEFAULT '0',
`status` tinyint(1) NOT NULL DEFAULT '0',
`aprob` tinyint(1) NOT NULL DEFAULT '1',
`auth` text,
PRIMARY KEY (`id`),
KEY `id_left` (`id_left`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Contenu de la table `phpboost_gallery_cats`
--
INSERT INTO `phpboost_gallery_cats` (`id`, `id_left`, `id_right`, `level`, `name`, `contents`, `nbr_pics_aprob`, `nbr_pics_unaprob`, `status`, `aprob`, `auth`) VALUES
(1, 1, 2, 0, 'Test', 'Galerie de test', 1, 0, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:3;}');
Après pour les autres tables comme download je me débrouillerais ;) merci par avance pour votre aide pour faire comme pour les membres dans se topic, sans quoi tellement long à faire, perdre les données pas envisageable ça empêcherait de migrer vers xoops2.
|
