adding a new table to osc

[jloyzaga]

I tried adding this to my DB

ALTER TABLE `products` ADD `artists_id` INT(11) DEFAULT NULL AFTER `manufacturers_id`;

ALTER TABLE products` ADD INDEX (`artists_id`);

CREATE TABLE `artists` (

`artists_id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

`artists_name` VARCHAR(32) NOT NULL,

`artists_phone1` VARCHAR(20) DEFAULT NULL,

`artists_phone2` VARCHAR(20) DEFAULT NULL,

`artists_fax` VARCHAR(20) DEFAULT NULL,

`artists_email` VARCHAR(20) DEFAULT NULL,

`artists_url` VARCHAR(60) DEFAULT NULL,

`artists_comments` VARCHAR(255) DEFAULT NULL,

`date_added` DATETIME DEFAULT NULL,

`last_modified` DATETIME DEFAULT NULL

)

COMMENT = 'artists table add-in';

But I obviously couldn't

 

Could somebody check this out and if possible grab my latest b/u and apply this to it coz its not working for me!!!!!!

 

Please email me for the DB and update

Joe

[Daemonj]

Your syntax looks correct.

 

Do you get an error message or what happens?

[jloyzaga]

It seems fine when I create it locally but I cant understand how to get phpmyadmin to re-generate the .sql file to upload to my site to restore - can you help?

[Daemonj]

Why not just post the code into an SQL window on your server?

[jloyzaga]

did it!!!!

 

Close this thread