Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/old/app/code/Magecomp/Savecartpro/Setup/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
namespace Magecomp\Savecartpro\Setup;

use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;

class InstallSchema implements InstallSchemaInterface
{
    public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
    {
		$installer = $setup;
        $installer->startSetup();

		// Savecartpro Main Table
		$table = $installer->getConnection()
            ->newTable($installer->getTable('savecart'))
			->addColumn(
                'savecart_id',
                \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                null,
                ['identity' => true,'nullable' => false,'primary' => true,'unsigned' => true],
                'Savecartpro ID'
			)
			->addColumn(
                'cart_name',
                \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
                255,
                [],
                'Cart Name'
            )
			->addColumn(
                'customer_id',
                 \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                 null,
                [],
                'Customer Id'
            )
			->addColumn(
                'created_at',
                \Magento\Framework\DB\Ddl\Table::TYPE_TIMESTAMP,
                null,
                ['nullable' => false, 'default' => \Magento\Framework\DB\Ddl\Table::TIMESTAMP_INIT],
                'Creation Time'
            );
        $installer->getConnection()->createTable($table);
		
		// Savecartpro Detail Table
		$table = $installer->getConnection()
            ->newTable($installer->getTable('savecart_detail'))
			->addColumn(
                'savecart_detail_id',
                \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                null,
                ['identity' => true,'nullable' => false,'primary' => true,'unsigned' => true],
                'Savecartpro Detail ID'
			)
			->addColumn(
                'savecart_id',
                 \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                 null,
                [],
                'Save Cart Id'
            )
			->addColumn(
                'quote_prd_id',
                 \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                 null,
                [],
                'Quote Product Id'
            )
			->addColumn(
                'quote_prd_qty',
                 \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
                 null,
                [],
                'Quote Product Qty'
            )
			->addColumn(
                'quote_prd_price',
                 \Magento\Framework\DB\Ddl\Table::TYPE_DECIMAL,
                 null,
                [],
                'Quote Product Price'
            )
            ->addColumn('quote_config_prd_data',
                \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
                1000,
                [],
                'Quote Configurable Product Data'
            );
        $installer->getConnection()->createTable($table);
    }
}