| Re: Migration de newbb 3.0.8 í newbbex 1.6 |
Titre du sujet : Re: Migration de newbb 3.0.8 í newbbex 1.6
par eparcyl92 sur 27/08/2008 22:18:40
Merci Ghia
Pour les réponses aux sujets
Citation :
INSERT INTO xoops_bbex_topics (
topic_id,
topic_title,
topic_poster,
topic_time,
topic_views,
topic_replies,
topic_last_post_id,
forum_id,
topic_status,
topic_sticky
)
SELECT
topic_id,
topic_title,
topic_poster,
topic_time,
topic_views,
topic_replies,
topic_last_post_id,
forum_id,
topic_status,
topic_sticky
FROM xoops_bb_topics
Je pense que maintenant, il reste une partie que j'arrive pas à faire, c'est les fichiers attachés
Ceci est dans newbb:
Citation :
CREATE TABLE IF NOT EXISTS `xoops_bb_attachments` (
`attach_id` int(8) unsigned NOT NULL auto_increment,
`post_id` int(10) unsigned NOT NULL default '0',
`name_saved` varchar(255) collate latin1_german1_ci NOT NULL default '',
`name_disp` varchar(255) collate latin1_german1_ci NOT NULL default '',
`mimetype` varchar(255) collate latin1_german1_ci NOT NULL default '',
`online` tinyint(1) unsigned NOT NULL default '1',
`attach_time` int(10) unsigned NOT NULL default '0',
`download` int(10) unsigned NOT NULL default '0',
Et ceci est dans la partie newbbex:
Citation :
CREATE TABLE IF NOT EXISTS `xoops_bbex_files` (
`fileid` int(8) unsigned NOT NULL auto_increment,
`filerealname` varchar(255) NOT NULL default '',
`post_id` int(8) unsigned NOT NULL default '0',
`date` int(10) NOT NULL default '0',
`mimetype` varchar(64) NOT NULL default '',
`downloadname` varchar(255) NOT NULL default '',
`counter` int(8) unsigned NOT NULL default '0',
Si cette partie est résolu, ce serai vraiment super.
Bonne soirée
|
|
