Forum Moderators: open

Message Too Old, No Replies

Sql Code Help

Reversing code already used

         

Fallen Angel

2:49 pm on Nov 15, 2007 (gmt 0)

10+ Year Member



Could someone please tell me what sql code that I need to run in my database to reverse and remove the following as I don't have a clue:

ALTER TABLE newsletters ADD template varchar(64) AFTER locked;
CREATE TABLE `newsletters_to_products` (
`newsletter_id` INT( 11 ) DEFAULT '0' NOT NULL ,
`products_id` INT( 11 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( `newsletter_id` , `products_id` )
);

I need to reverse the first line and remove the table newsletter_to_products

Many thanks

phranque

3:04 pm on Nov 15, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



ALTER TABLE newsletters DROP template;
DROP TABLE `newsletters_to_products`;

Fallen Angel

3:14 pm on Nov 15, 2007 (gmt 0)

10+ Year Member



Thanks very much for your help.