#!sql

UPDATE friends SET tag_name = "sys:network:bibsonomy-follower" WHERE tag_name = "sys:relation:Bibsonomy-Follower";
UPDATE log_friends SET tag_name = "sys:network:bibsonomy-follower" WHERE tag_name = "sys:relation:Bibsonomy-Follower";

INSERT IGNORE INTO friends (user_name, f_user_name, tag_name, friendship_date) (SELECT user_name, f_user_name, "sys:network:bibsonomy-follower", fellowship_date FROM followers);
INSERT IGNORE INTO log_friends (user_name, f_user_name, tag_name, friendship_date, friendship_end_date) (SELECT user_name, f_user_name, "sys:network:bibsonomy-follower", fellowship_date, fellowship_end_date FROM log_followers);


CREATE TABLE `log_postchange` (
    `post_owner` VARCHAR(50) NULL DEFAULT NULL,
    `post_editor` VARCHAR(50) NOT NULL,
    `old_content_id` INT(11) NOT NULL,
    `new_content_id` INT(11) NOT NULL,
    `current_content_id` INT(11) NOT NULL,
    `content_type` TINYINT(4) NOT NULL,
    `date` DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `sync` ADD `already_synced_once` TINYINT(1) NULL DEFAULT '0' AFTER `autosync`;

UPDATE sync s JOIN sync_data s2 ON s2.service_id = s.service_id AND s2.user_name = s.user_name SET s.already_synced_once = 1 WHERE s2.status = "done";