rss
FullBlogPluginに移行
ブログをFullBlogPluginに移行してみました。
ちなみにTickTackBlogプラグインから移行するためのSQLは以下のようになります。この後、添付ファイルは手でコピーします。まあ、使っている人がいないと思うけど。
insert into fullblog_posts
select
'blog'||substr('0000'||id,length(''||id),10) as name,
1 as version,
summary as title,
description as body,
time as publish_time,
changetime as version_time,
'' as version_comment,
reporter as version_author,
reporter as author,
component as categories
from ticket where type='ブログ';
insert into fullblog_comments
select
'blog'||substr('0000'||c.ticket,length(''||c.ticket),10) as name,
c.time as number,
c.newvalue as comment,
c.author as author,
c.time as time
from ticket_change c
where
c.ticket in (select id from ticket where type='ブログ')
and field = 'comment'
and newvalue <> ''
order by c.ticket,c.time;
update fullblog_comments
set number =
(select count(*) from fullblog_comments c2
where c2.name=fullblog_comments.name
and c2.time <= fullblog_comments.time);
insert into attachment
select 'blog' as type,
'blog'||substr('0000'||id,length(''||id),10) as id,
filename,
size,
time,
description,
author,
ipnr
from attachment
where
type='ticket'
and id in (select id from ticket where type='ブログ')
Comments
No comments.