Additions:
INSERT INTO `databasename`.`wikka-pages-table`
Deletions:
INSERT INTO `datbasename`.`wikka-pages-table`
Additions:
%%(mysql)
Deletions:
%%(sql)
SQL to import from
ErfurtWiki to
WikkaWiki:
INSERT INTO `datbasename`.`wikka-pages-table`
SELECT "" AS ID, `pagename` AS `tag`, FROM_UNIXTIME(`lastmodified`) AS `time`, `content` AS `body`, "UserName" AS `owner`, "USerName" AS `user`,"Y" AS `latest`, "write a descriptive note" AS `note`, "page" AS `handler`
FROM `erfurt-wiki-table`
WHERE 1
ORDER BY `pagename` ASC , `version` ASC ;
Cite as "Multiple Authors; WikiImport. Synesthesia Wiki; Retrieved 5th Dec 2008 from http://www.synesthesia.co.uk/wikka/WikiImport"