Updated Schema Changes/Updates

[Bob]

// ################################ UPGRADE TO 2.3.2 ##################

Schema changes:

    public function upgrade2030270Step1()
    {
        $this->createTable('xf_xa_rms_website_url_check_log', function(Create $table)
        {
            $table->addColumn('website_url_check_log_id', 'int')->autoIncrement();
            $table->addColumn('item_id', 'int');
            $table->addColumn('location_id', 'int');
            $table->addColumn('website_url', 'text');
            $table->addColumn('website_url_check_date', 'int')->setDefault(0);
            $table->addColumn('website_url_check_code', 'int')->setDefault(0);
            $table->addColumn('website_url_check_result', 'enum')->values(['success', 'failure', 'moderated'])->setDefault('success');
            $table->addKey('item_id');
            $table->addKey('location_id');
            $table->addKey('website_url_check_date');
            $table->addKey(['item_id', 'website_url_check_date']);
            $table->addKey(['location_id', 'website_url_check_date']);
        });       
    }

    public function upgrade2030270Step2()
    {
        $this->alterTable('xf_xa_rms_category', function (Alter $table)
        {
            $table->addColumn('auto_feature', 'tinyint')->setDefault(0)->after('location_on_list_display_type');
        });
        
        $this->alterTable('xf_xa_rms_event', function (Alter $table)
        {
            $table->addColumn('featured', 'tinyint')->setDefault(0)->after('tags');
        });
        
        $this->alterTable('xf_xa_rms_item', function (Alter $table)
        {
            $table->addColumn('featured', 'tinyint')->setDefault(0)->after('tags');
        });

        $this->alterTable('xf_xa_rms_review', function (Alter $table)
        {
            $table->addColumn('featured', 'tinyint')->setDefault(0)->after('would_recommend');
        });       
    }

    public function upgrade2030270Step6(): void
    {
        $this->dropTable('xf_xa_rms_event_feature');
        $this->dropTable('xf_xa_rms_item_feature');
        $this->dropTable('xf_xa_rms_review_feature');
    }