Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Changes to the Database Question


ecroswell21

Recommended Posts

Posted

An add-on I just downloaded has the below message about the database in the instructions. Can anyone help me understand what I am supposed to do with this? Am I supposed to add "member_level" as a new field in the customers table? And assign the attributes INT(5) and '0' NOT NULL;

 

Database

--------

You will have to add an extra field to the customers table of the data base

 

ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL;

 

 

Sorry for the newbie question ... thanks for the help.

Posted

Go to your MySQL database / PHPmyAdmin, and paste the SQL code in for formular:

 

ALTER TABLE `customers` ADD `member_level` INT(5) DEFAULT '0' NOT NULL;

 

Then is automatic would work../be done... :)

Archived

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

×
×
  • Create New...