Moving databse from live server to phpmyadmin error

Code: Select all

SQL query:

CREATE TABLE IF NOT EXISTS `address` (
`address_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customer_id` int( 11 ) NOT NULL ,
`firstname` varchar( 32 ) COLLATE utf8_bin NOT NULL default '',
`lastname` varchar( 32 ) COLLATE utf8_bin NOT NULL default '',
`company` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`company_id` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`tax_id` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`company_no` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`company_tax` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`address_1` varchar( 128 ) COLLATE utf8_bin NOT NULL ,
`address_2` varchar( 128 ) COLLATE utf8_bin NOT NULL ,
`city` varchar( 128 ) COLLATE utf8_bin NOT NULL ,
`postcode` varchar( 10 ) COLLATE utf8_bin NOT NULL ,
`country_id` int( 11 ) NOT NULL default '0',
`zone_id` int( 11 ) NOT NULL default '0'
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT =253;

MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key 

Code: Select all

-- Indexes for table `address`
--
ALTER TABLE `address`
 ADD PRIMARY KEY  (`address_id`), ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `affiliate`
--
ALTER TABLE `affiliate`
 ADD PRIMARY KEY  (`affiliate_id`);

--
-- Indexes for table `affiliate_transaction`
--
ALTER TABLE `affiliate_transaction`
 ADD PRIMARY KEY  (`affiliate_transaction_id`);

--
-- Indexes for table `attribute`
--
ALTER TABLE `attribute`
 ADD PRIMARY KEY  (`attribute_id`);

--
-- Indexes for table `attribute_description`
--
ALTER TABLE `attribute_description`
 ADD PRIMARY KEY  (`attribute_id`,`language_id`);

--
-- Indexes for table `attribute_group`
--
ALTER TABLE `attribute_group`
 ADD PRIMARY KEY  (`attribute_group_id`);

--
-- Indexes for table `attribute_group_description`
--
ALTER TABLE `attribute_group_description`
 ADD PRIMARY KEY  (`attribute_group_id`,`language_id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
 ADD PRIMARY KEY  (`banner_id`);

--
-- Indexes for table `banner_image`
--
ALTER TABLE `banner_image`
 ADD PRIMARY KEY  (`banner_image_id`);