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/Soon/AdminLogger/Setup/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * @license http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 * @author Hervé Guétin <[email protected]> <@herveguetin>
 * @copyright Copyright (c) 2018 Kaliop Digital Commerce (http://digitalcommerce.kaliop.com)
 */

namespace Soon\AdminLogger\Setup;

class InstallSchema implements \Magento\Framework\Setup\InstallSchemaInterface
{
    /**
     * Installs DB schema for a module
     *
     * @param \Magento\Framework\Setup\SchemaSetupInterface $setup
     * @param \Magento\Framework\Setup\ModuleContextInterface $context
     * @return void
     * @throws \Zend_Db_Exception
     */
    public function install(\Magento\Framework\Setup\SchemaSetupInterface $setup, \Magento\Framework\Setup\ModuleContextInterface $context)
    {
        $installer = $setup;
        $installer->startSetup();

        /**
         * Create table 'soon_adminlogger_log'
         */
        $table = $installer->getConnection()
            ->newTable($installer->getTable('soon_adminlogger_log'))
            ->addColumn('log_id', \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER, null, array(
                'identity' => true,
                'unsigned' => true,
                'nullable' => false,
                'primary' => true,
            ), 'Id')
            ->addColumn('uri', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, null, array(), 'URi')
            ->addColumn('full_action_name', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, null, array(), 'URi')
            ->addColumn('is_post', \Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT, null, array(), 'Is Post')
            ->addColumn('post_data', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, null, array(), 'Post Data')
            ->addColumn('admin_user', \Magento\Framework\DB\Ddl\Table::TYPE_TEXT, null, array(), 'Admin User')
            ->addColumn('created_at', \Magento\Framework\DB\Ddl\Table::TYPE_DATETIME, null, array(), 'Created At')
            ->setComment('Soon Admin Logger Log Lines');
        $installer->getConnection()->createTable($table);

        $installer->endSetup();
    }
}