Updated Misc updates

[Bob]

Edit History Handlers have been updated for all content types.

Edit Services have been updated for all content types that have Edit History Handlers.

Last edited by: Date/Time and Last edited by a moderator: Date/Time information is now displayed publicly on all sub content types that implement Edit History Handers (Questions, Reviews, Updates, Replies, etc)

Moderator Log Handlers have been updated for all content types that have Edit History Handlers

Moderator Log Handlers have been updated for all content types that have Reassign functionality.

Several new Phrases have been added, mostly pertaining to updates made to FAQs, Edit History Handlers and Moderator Log Handlers.

Added $this->enqueuePostUpgradeCleanUp(); to the postUpgrade() function in Setup.php as part of the new Automatic legacy file cleanup

 

[Bob]

// ################################ UPGRADE TO 2.3.6 ##################

Schema changes

    public function upgrade2030670Step1()
    {
        $this->alterTable('xf_xa_ims_category', function(Alter $table)
        {
            $table->addColumn('allow_claims', 'tinyint')->setDefault(0)->after('allow_poll');
            $table->addColumn('allow_questions', 'tinyint')->setDefault(1)->after('allow_business_hours');
            $table->addColumn('question_reply_voting', 'varchar', 25)->setDefault('')->after('allow_questions');
        });
    }
    
    public function upgrade2030670Step2()
    {
        $this->alterTable('xf_xa_ims_item', function(Alter $table)
        {
            $table->addColumn('claim_date', 'int')->setDefault(0)->after('overview_page_title');
            $table->addColumn('claim_id', 'int')->setDefault(0)->after('claim_date');
        });
    }
    
    public function upgrade2030670Step3()
    {
        $this->alterTable('xf_xa_ims_question', function(Alter $table)
        {
            $table->addColumn('is_faq', 'tinyint')->setDefault(0)->after('question_state');
            $table->addKey(['is_faq', 'item_id']);
        });
    }
    
    public function upgrade2030670Step4()
    {   
        $this->createTable('xf_xa_ims_claim', function(Create $table)
        {
            $table->addColumn('claim_id', 'int')->autoIncrement();
            $table->addColumn('item_id', 'int');
            $table->addColumn('user_id', 'int');
            $table->addColumn('username', 'varchar', 50)->setDefault('');
            $table->addColumn('claim_date', 'int')->setDefault(0);
            $table->addColumn('edit_date', 'int')->setDefault(0);
            $table->addColumn('approve_date', 'int')->setDefault(0);
            $table->addColumn('reject_date', 'int')->setDefault(0);
            $table->addColumn('claim_status', 'enum')->values(['pending','approved','rejected'])->setDefault('pending');
            $table->addColumn('message', 'mediumtext');
            $table->addColumn('status_message', 'mediumtext');
            $table->addColumn('attach_count', 'int')->setDefault(0);
            $table->addColumn('ip_id', 'int')->setDefault(0);
            $table->addColumn('embed_metadata', 'blob')->nullable();
            $table->addUniqueKey(['item_id', 'user_id']);
            $table->addKey(['claim_id', 'claim_date'], 'claim_id_claim_date');
            $table->addKey('user_id');
            $table->addKey('claim_date');
            $table->addKey('claim_status');
        });
    }