Skip to content

Instantly share code, notes, and snippets.

@cedricwalter

cedricwalter/migration

Last active December 19, 2015 03:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cedricwalter/5887730 to your computer and use it in GitHub Desktop.
Save cedricwalter/5887730 to your computer and use it in GitHub Desktop.
Download ZIP
migration script for my extension cedtag to internal Joomla 3.0/3.1.1 tag component
Raw
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;
@cedricwalter
Copy link
Author

a work in progress

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment