Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

installing a .sql file


liamC

Recommended Posts

Just downloaded an add on which includes a .sql file

 

I am trying to install and it says the following:

 

INSTALLATION INSTRUCTIONS

 

 

 

STEP 1. Add new fields to db

 

 

 

Add the following fields to table products_options

 

You can either use the enclosed option_type_feature.sql or the following definitions

 

 

 

NAME: products_options_type

 

TYPE: int(5)

 

NULL: No

 

DEFAULT: 0

 

 

 

NAME: products_options_length

 

TYPE: smallint(2)

 

NULL: No

 

DEFAULT: 32

 

 

 

NAME: products_options_comment

 

TYPE: varchar(32)

 

NULL: Yes

 

DEFAULT: NULL

 

 

 

Add the following field to table customer_basket_attributes

 

 

 

NAME: products_options_value_text

 

TYPE: text

 

NULL: Yes

 

DEFAULT: Null

 

Where do I place the .sql file? Or how do I update?

 

Thanks

Liam

Link to comment
Share on other sites

To excplain a bit better.

When you are in your controlpanel for your DB the easiest way is to open up your option_type_feature.sql -file in an text editor, copy all content.

Choose your DB in your control-panel. Then hit the folder that is called "SQL".

 

Paste everything in to the largest window an then execute. Now it will create/update your db.

 

Done!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...