How do I make a sql table?

[Tsuri Japan]

I'm trying to add a better version of the customer admin layout but in the contrib it says just add customer_notes field to your SQL database in the customer table.

 

I know how to get there and all but I'm not able to write a table.... :blush:

 

Can someone help me out a bit?

http://www.oscommerce.com/community/contri...h,customer+list

 

Thanks,

 

Nigelman :thumbsup:

[digbydo]

ALTER TABLE `customer` ADD `customers_notes` INT( 128 ) DEFAULT NULL;

might be what you are after, but back everything up first :)

[Tsuri Japan]

hey thanks for the help I really appreciate it..........but um she ain't working very well:

 

Error

SQL query:

 

ALTER TABLE `customer` ADD `customers_notes` INT( 128 ) DEFAULT NULL

 

MySQL said:

 

#1146 - Table 'tsuriXXXX_osc2.customer' doesn't exist

 

but it does???

 

thanks,

 

Nigelman

[bobg7]

Use this

 

ALTER TABLE `customers` ADD `customers_notes` INT( 128 ) DEFAULT NULL;

[Tsuri Japan]

Thanks man!!!!!!!

 

got it and now the contrib is working smooth as......funny thing though. After adding that SQL code I got this message:

 

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_meta_style.inc.php:27) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/common.lib.php on line 1154

 

but the contrib is working great, go figure?

 

Nigelman :thumbsup: