migration script for my extension cedtag to internal Joomla 3.0/3.1.1 tag component

migration

truncate  #__tags;

INSERT INTO sd7c5_tags
(id, parent_id, lft, rgt, `level`,
 path, title, alias, note, description,
 published, checked_out, checked_out_time, access, params,
 metadesc, metakey, metadata, created_user_id,
 created_time, created_by_alias, modified_user_id, modified_time,
 images, urls, hits,
 `language`, version, publish_up, publish_down)
SELECT
id, 1, 1, 2, 1,
`name`, `name`, `name`, '', if (description is null, '', description),
published, 0, '0000-00-00 00:00:00', 1, '{}',
'', '', '',
%%%%%%%Put here your userid %%%%%%%%
, created, '', 0, '0000-00-00 00:00:00',
'', '', hits, '*', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'
FROM sd7c5_cedtag_term;

a work in progress