xdKZhf52

1<?php
2
3namespace tivolstoreAvailabilitySetup;
4
5use MagentoFrameworkSetupInstallSchemaInterface;
6use MagentoFrameworkSetupModuleContextInterface;
7use MagentoFrameworkSetupSchemaSetupInterface;
8use MagentoFrameworkDBDdlTable;
9
10class InstallSchema implements InstallSchemaInterface
11{
12public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
13{
14    $installer = $setup;
15    $installer->startSetup();
16
17    // Get tivol_storeavailability table
18    $tableName = $installer->getTable('tivol_storeavailability');
19    // Check if the table already exists
20    if ($installer->getConnection()->isTableExists($tableName) != true) {
21        // Create tivol_storeavailability table
22        $table = $installer->getConnection()
23            ->newTable($tableName)
24                        ->addColumn(
25                            'id',
26                            MagentoFrameworkDBDdlTable::TYPE_INTEGER,
27                            null,
28                            ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
29                            'Id'
30                        )
31                        ->addColumn(
32                            'label',
33                            MagentoFrameworkDBDdlTable::TYPE_TEXT,
34                            null,
35                            ['default' => null, 'nullable' => false],
36                            'Name'
37                        )
38                        ->addColumn(
39                            'value',
40                            MagentoFrameworkDBDdlTable::TYPE_TEXT,
41                            null,
42                            ['default' => null, 'nullable' => false],
43                            'Stores'
44                        );
45            ->setComment('News Table')
46            ->setOption('type', 'InnoDB')
47            ->setOption('charset', 'utf8');
48        $installer->getConnection()->createTable($table);
49    }
50
51    $installer->endSetup();
52}
53}
54	
55SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento.tivol_storeavailability' doesn't exist, query was: SELECT `main_table`.* FROM `tivol_storeavailability` AS `main_table`