[SOLVED] Removing auto increment from field

[shadowcaster]

Hi. I have a table with the structure:

CREATE TABLE otherpayments (
`advert_id` INT(11) NOT NULL AUTO_INCREMENT,
`cheque` INT(1) NOT NULL,
`postalorder` INT(1) NOT NULL,
`paypal` INT(1) NOT NULL,
`other` INT(1) NOT NULL,
PRIMARY KEY(`advertentie_id`)
);

 

Is it possible to remove the AUTO_INCREMENT from the advert_id field and how would I go about doing that?

 

Thanks in advance.

[GingerRobot]

You can do it easily enough in phpMyAdmin. However, the query is:

 

ALTER TABLE `otherpayments` CHANGE `advert_id` `advert_id` INT( 11 ) NOT NULL 

[shadowcaster]

Thanks mate.