Change Database from Installation Script

Hello Friends,

I have downloaded nopcommerce 3.30 and I made some changes in the customer table of the database. I want to use this changes in the Installation script also.  Where can I found the Database Table Structures ? In nopcommerce 1.9 database structures are available in an sql script file.

Where can I found the Database Table Structures in 3.30 to make necessary changes ?

Please help.

Thanks in advance

App_Data/Install

N-Theme.com wrote:

There is no CREATE TABLE

Check Controllers/InstallController.cs

Nop.Services/Installation/

Can you please tell what is the exact file name ?

I found

public virtual void InstallData(string defaultUserEmail,
            string defaultUserPassword, bool installSampleData = true)
        {
            ExecuteSqlFile(_webHelper.MapPath("~/App_Data/Install/create_required_data.sql"));
            InstallLocaleResources();
            UpdateDefaultCustomer(defaultUserEmail, defaultUserPassword);
            UpdateDefaultStoreUrl();

            if (installSampleData)
            {
                ExecuteSqlFile(_webHelper.MapPath("~/App_Data/Install/create_sample_data.sql"));
            }
        }

But in this script there is no "CREATE TABLE" tag

Hi All,

Sorry if i get your question wrong !!!

There is no method/sql query for Creating tables in nop.
Table is created from Domain classes. Its code first approach used here. So Don't worry u not needed to write sql query of your extra fields you created. It will created automatic.

krutal wrote:

Thanks for you valuable reply

How can I add a New table and Modify tables with Default Values in Nopcommerce 3.30