ALTER TABLE groups ADD COLUMN `userSharedDocuments` tinyint(1) default '0';

ALTER TABLE groups CHANGE start_date start_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

UPDATE groups JOIN groupids USING (`group`) SET groups.userSharedDocuments = TRUE WHERE groupids.sharedDocuments = TRUE;

    SET @saved_cs_client     = @@character_set_client;
    SET character_set_client = utf8;
    CREATE TABLE `log_wiki` (
      `user_name` varchar(30) NOT NULL,
      `user_wiki` text,
      `date` DATETIME,
      PRIMARY KEY  (`user_name`,`date`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    SET character_set_client = @saved_cs_client;

    CREATE TABLE `user_wiki` (
      `user_name` varchar(30) NOT NULL,
      `user_wiki` text,
      `date` datetime DEFAULT NULL,
      PRIMARY KEY (`user_name`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

    insert ignore into user_wiki select user_name, "== personal data ==
    {| class=\"wikitable\" style=\"text-align:left;padding:15px\"
    |style=\"width: 5em\", rowspan=\"5\" | <image style=\"float: center\" />
    ! name || <name />
    |-
    !style=\"width: 10em\"| location || <location />
    |-
    ! date of birth || <birthday />
    |-
    ! profession || <profession />
    |-
    ! institution || <institution />
    |}

    ==scientific interests==
    <interests />

    ==hobby==
    <hobbies />

    ==my publications==
    <publications tags=\"myown\" layout=\"plain\" />

    ==my bookmarks==
    <bookmarks />
    ", CURRENT_TIMESTAMP() as date from user

    update user_wiki, groupids set user_wiki.user_wiki="==Grouppage of the group <name/>==
    <groupimage />

    ==Members==
    <members />

    ==Recently added bookmarks==
    <bookmarks tags=\"myown\" limit=\"3\" />

    ==Recently added publications==
    <publications order=\"asc\" keys=\"year\" limit=\"3\" />" where user_wiki.user_name=groupids.group_name