Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Add new field in excisting database table


Kjolebutikken

Recommended Posts

I'm installing the contribution "Customers list improved". In the readme file it says:

 

Add customers_notes field to your SQL database in the customer table. Suggested size is 128.

 

There is no sql-file attatched in the package.

Somebody how can tell me how to do this?

 

Thank you:-)))

Kjolebutikken

Best regards

Kjolebutikken

Link to comment
Share on other sites

I'm installing the contribution "Customers list improved". In the readme file it says:

 

Add customers_notes field to your SQL database in the customer table. Suggested size is 128.

 

There is no sql-file attatched in the package.

Somebody how can tell me how to do this?

 

Thank you:-)))

Kjolebutikken

 

Nevermind, got it:-)))

Kjolebutikken

Best regards

Kjolebutikken

Link to comment
Share on other sites

I'm installing the contribution "Customers list improved". In the readme file it says:

 

Add customers_notes field to your SQL database in the customer table. Suggested size is 128.

 

There is no sql-file attatched in the package.

Somebody how can tell me how to do this?

 

Thank you:-)))

Kjolebutikken

 

Click on the customer table within phpMyAdmin, then click on the link for "structure". You'll see a list of the table's columns. At the bottom of that list is some text that says something along the lines of "Add __ fields" then some radio buttons, and a "Go" button. It should already default to 1 but if it doesn't enter 1 where I indicated the __ , then click go.

 

On the next page, enter the field name, the type (in this case likely varchar), then the length. Click the save button at the bottom and you are done.

 

Be well,

Tina

If you're not having fun you're not doing it right

 

Teach a person to fish rather than give them a loaf of bread or however that saying goes.

Link to comment
Share on other sites

Click on the customer table within phpMyAdmin, then click on the link for "structure". You'll see a list of the table's columns. At the bottom of that list is some text that says something along the lines of "Add __ fields" then some radio buttons, and a "Go" button. It should already default to 1 but if it doesn't enter 1 where I indicated the __ , then click go.

 

On the next page, enter the field name, the type (in this case likely varchar), then the length. Click the save button at the bottom and you are done.

 

Be well,

Tina

 

Thank you Tina:-)))

Best regards

Kjolebutikken

Best regards

Kjolebutikken

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...