public function up()
 {
     $conn = Doctrine_Manager::connection();
     $export = $conn->export;
     $export->alterTable('community_topic_comment', array('remove' => array('updated_at' => array())));
     $export->alterTable('community_topic', array('add' => array('topic_updated_at' => array('type' => 'timestamp', 'notnull' => false))));
     $export->alterTable('community_topic_comment', array('change' => array('member_id' => array('definition' => array('type' => 'integer', 'notnull' => false)))));
     $export->alterTable('community_topic', array('change' => array('member_id' => array('definition' => array('type' => 'integer', 'notnull' => false)))));
     $export->dropForeignKey('community_topic_comment', 'community_topic_comment_FK_2');
     $export->dropForeignKey('community_topic', 'community_topic_FK_2');
     $export->createForeignKey('community_topic_comment', array('name' => 'community_topic_comment_FK_2', 'local' => 'member_id', 'foreign' => 'id', 'foreignTable' => 'member', 'onDelete' => 'SET NULL'));
     $export->createForeignKey('community_topic', array('name' => 'community_topic_FK_2', 'local' => 'member_id', 'foreign' => 'id', 'foreignTable' => 'member', 'onDelete' => 'SET NULL'));
     $communityTopics = CommunityTopicPeer::doSelect(new Criteria());
     foreach ($communityTopics as $communityTopic) {
         $communityTopic->setTopicUpdatedAt($communityTopic->getUpdatedAt());
         $communityTopic->save();
     }
 }
 public function up()
 {
     $conn = Doctrine_Manager::connection();
     $export = $conn->export;
     $export->alterTable('community_topic_comment', array('add' => array('number' => array('type' => 'integer', 'default' => 0, 'notnull' => true))));
     $communityTopics = CommunityTopicPeer::doSelect(new Criteria());
     foreach ($communityTopics as $communityTopic) {
         $criteria = new Criteria();
         $criteria->add(CommunityTopicCommentPeer::COMMUNITY_TOPIC_ID, $communityTopic->getId());
         $criteria->addAscendingOrderByColumn(CommunityTopicCommentPeer::CREATED_AT);
         $communityTopicComments = CommunityTopicCommentPeer::doSelect($criteria);
         $i = 0;
         foreach ($communityTopicComments as $communityTopicComment) {
             $i++;
             $communityTopicComment->setNumber($i);
             $communityTopicComment->save();
         }
     }
     $export->alterTable('community_topic_comment', array('change' => array('number' => array('definition' => array('type' => 'integer', 'notnull' => true)))));
 }