Create a new table from magento module

Create a new table from magento module

July 6, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Create a new table from magento module

Creating a New Table for Your Magento Admin Module

Hi there! I hope this post helps you get your Magento admin module up and running smoothly. Let’s dive into creating a new table using the mysql4-install-0.1.0.php file in your module.

Setting Up the SQL Installation File

You’re on the right track with your current setup:

<?php
  $installer = $this;
  $installer->startSetup();

  $installer->run("
    DROP TABLE IF EXISTS {$this->getTable('notes')};

    CREATE TABLE {$this->getTable('notes')} (
      `ppr_id` int(11) NOT NULL AUTO_INCREMENT,
      `notesku` bigint(20) NOT NULL,
      `notestatus`  smallint(16),
      PRIMARY KEY (`notes`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8
  ");

  $installer->endSetup();
?>

This script does exactly what you expect: it drops an existing table called notes, creates a new one, and sets up the columns with appropriate data types. The use of getTable('notes') ensures that the table name is prefixed correctly according to your Magento installation.

Configuring Your Module’s XML Files

Your config.xml file looks good as well:

<global>
    <models>
        <BAR>
            <class>Foo_BAR_Model</class>
            <resourceModel>BAR_mysql4</resourceModel>
        </BAR>

        <BAR_myslq4>
            <class>Foo_BAR_Model_Mysql4</class>
            <entities>
                <BAR>
                    <table>notes</table>
                </BAR>
            </entities>
        </BAR_myslq4>
    </models>

    <!-- ... other config elements -->
</global>

Here, you’re correctly defining your module’s models and resources. The BAR_mysql4 model is associated with the notes table.

Deploying Your Module

Now let’s discuss how to trigger this table creation:

  1. Enable your module: In the Magento admin panel, navigate to System > Configuration > Advanced. Under Disable Modules Output, find and enable your Foo_BAR module.

  2. Clear cache: After enabling the module, clear your Magento cache by going to System > Cache Management and clicking “Flush Cache Storage”.

  3. Install or upgrade: To trigger the installation of your new table structure:

    • For a fresh installation: Visit any page in the front-end or admin panel.
    • For an upgrade: Reinstall your module via composer (composer require foo/bar:*) or update it manually and run php bin/magento setup:upgrade.

Conclusion

You’re almost there! The combination of properly setting up your SQL installation file, configuring your XML files correctly, and following the deployment steps should create your new table without any issues.

Remember to always test changes in a development environment before deploying them to production. If you encounter any errors or need further assistance, feel free to explore our Magento development services for expert help.

Happy coding!

Database Extensions Admin Configuration

Our network