Updated Schema Changes/Updates

[Bob]

// ################################ UPGRADE TO 2.3.9 ##################

Schema changes:

    public function upgrade2030970Step1()
    {
        $this->alterTable('xf_xa_ims_category', function (Alter $table)
        {
            $table->addColumn('allow_editor_reviews', 'tinyint')->setDefault(0)->after('question_reply_voting');
        });
    }

    public function upgrade2030970Step2()
    {
        $this->alterTable('xf_xa_ims_item', function (Alter $table)
        {
            $table->addColumn('editor_rating', 'float', '')->setDefault(0)->after('business_hours');
            $table->addColumn('editor_review_id', 'int')->setDefault(0)->after('editor_rating');
        });
    }

    public function upgrade2030970Step3()
    {
        $this->alterTable('xf_xa_ims_review', function (Alter $table)
        {
            $table->addColumn('is_editor_review', 'tinyint')->setDefault(0)->after('vote_count');
        });
    }

    public function upgrade2030970Step4()
    {
        $this->alterTable('xf_user', function(Alter $table)
        {
            $table->addColumn('xa_ims_editor_review_count', 'int')->setDefault(0)->after('xa_ims_item_count');
            $table->addKey('xa_ims_editor_review_count', 'ims_editor_review_count');
        });
    }

    public function upgrade2030970Step5()
    {   
        $this->createTable('xf_xa_ims_review_read', function(Create $table)
        {
            $table->addColumn('review_read_id', 'int')->autoIncrement();
            $table->addColumn('user_id', 'int');
            $table->addColumn('review_id', 'int');
            $table->addColumn('review_read_date', 'int');
            $table->addUniqueKey(['user_id', 'review_id']);
            $table->addKey('review_id');
            $table->addKey('review_read_date');
        });
    }

Updates:

Insert a New Widget to existing sites

    public function upgrade2030970Step6(): void
    {
        $this->insertNamedWidget('xa_ims_latest_editor_reviews');
    }