[SOLVED] Whats wrong with sql dump??

[dreamwest]

Whats wrong with sql dump??

 

Keep getting this mysql error

 

Error 
SQL query: 

# --------------------------------------------------------
#
# Table structure for table 'phpads_clients'
#
CREATE TABLE phpads_clients(

clientID mediumint( 9 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
clientname varchar( 255 ) NOT NULL ,
contact varchar( 255 ) ,
email varchar( 64 ) NOT NULL ,
views mediumint( 9 ) ,
clicks mediumint( 9 ) ,
clientusername varchar( 64 ) NOT NULL ,
clientpassword varchar( 64 ) NOT NULL ,
expire date DEFAULT '0000-00-00',
activate date DEFAULT '0000-00-00',
permissions mediumint( 9 ) ,
language varchar( 64 ) ,
active enum( 'true', 'false' ) NOT NULL ,
weight tinyint( 4 ) default '1' NOT NULL ,
parent mediumint( 9 ) DEFAULT '0' NOT NULL ,
report enum( 'true', 'false' ) NOT NULL ,
reportinterval mediumint( 9 ) DEFAULT '7' NOT NULL ,
reportlastdate date DEFAULT '0000-00-00' NOT NULL ,
reportdeactivate enum( 'true', 'false' ) NOT NULL ,
PRIMARY KEY ( clientID ) 
) 
MySQL said:  

#1067 - Invalid default value for 'clientID'  

 

Original sql.txt

 

# phpMyAdmin MySQL-Dump
# http://www.htmlwizard.net/phpMyAdmin/
#
# Host: localhost:3300 Database : phpads

# --------------------------------------------------------
#
# Table structure for table 'phpads_zones'
#

CREATE TABLE phpads_zones (
   zoneid mediumint(9) NOT NULL AUTO_INCREMENT,
   zonename varchar(255) NOT NULL,
   description varchar(255) NOT NULL,
   zonetype smallint(6) DEFAULT '0' NOT NULL,
   what blob NOT NULL,
   width smallint(6) DEFAULT '0' NOT NULL,
   height smallint(6) DEFAULT '0' NOT NULL,
   retrieval enum('random','cookie') DEFAULT 'random' NOT NULL,
   cachecontents blob,
   cachetimestamp int DEFAULT '0' NOT NULL,
   PRIMARY KEY (zoneid)
);


# --------------------------------------------------------
#
# Table structure for table 'phpads_adclicks'
#

CREATE TABLE phpads_adclicks (
   bannerID mediumint(9) DEFAULT '0' NOT NULL,
   t_stamp timestamp(14),
   host varchar(255) NOT NULL,
   KEY clientID (bannerID)
);


# --------------------------------------------------------
#
# Table structure for table 'phpads_adviews'
#

CREATE TABLE phpads_adviews (
   bannerID mediumint(9) DEFAULT '0' NOT NULL,
   t_stamp timestamp(14),
   host varchar(255) NOT NULL,
   KEY clientID (bannerID)
);



# --------------------------------------------------------
#
# Table structure for table 'phpads_banners'
#

CREATE TABLE phpads_banners (
   bannerID mediumint(9) NOT NULL auto_increment,
   clientID mediumint(9) DEFAULT '0' NOT NULL,
   active enum('true','false') NOT NULL,
   weight tinyint(4) default '1' NOT NULL,
   seq tinyint(4) default '0' NOT NULL,
   banner blob NOT NULL,
   width smallint(6) DEFAULT '0' NOT NULL,
   height smallint(6) DEFAULT '0' NOT NULL,
   format enum('gif','jpeg','png','html','url','web','swf') DEFAULT 'gif' NOT NULL,
   url varchar(255) NOT NULL,
   alt varchar(255) NOT NULL,
   status varchar(255) NOT NULL,
   keyword varchar(255) NOT NULL,
   bannertext varchar(255) NOT NULL,
   target varchar( default '' NOT NULL,
   description varchar(255) DEFAULT '' NOT NULL,
   autohtml enum('true','false') DEFAULT 'true' NOT NULL,   
   PRIMARY KEY (bannerID)
);



# --------------------------------------------------------
#
# Table structure for table 'phpads_clients'
#

CREATE TABLE phpads_clients (
   clientID mediumint(9) DEFAULT '0' NOT NULL auto_increment,
   clientname varchar(255) NOT NULL,
   contact varchar(255),
   email varchar(64) NOT NULL,
   views mediumint(9),
   clicks mediumint(9),
   clientusername varchar(64) NOT NULL,
   clientpassword varchar(64) NOT NULL,
   expire date DEFAULT '0000-00-00',
   activate date DEFAULT '0000-00-00',
   permissions mediumint(9),
   language varchar(64),
   active enum('true','false') NOT NULL,
   weight tinyint(4) default '1' NOT NULL,   
   parent mediumint(9) DEFAULT '0' NOT NULL,
   report enum('true','false') NOT NULL,
   reportinterval mediumint(9) DEFAULT '7' NOT NULL,
   reportlastdate date DEFAULT '0000-00-00' NOT NULL,
   reportdeactivate enum('true','false') NOT NULL,
   PRIMARY KEY (clientID)
);


# --------------------------------------------------------
#
# Table structure for table 'phpads_session'
#

CREATE TABLE phpads_session (
   SessionID varchar(32) NOT NULL,
   SessionData blob NOT NULL,
   LastUsed timestamp(14),
   PRIMARY KEY (SessionID)
);

# --------------------------------------------------------
#
# Table structure for table 'phpads_acls'
#

CREATE TABLE phpads_acls (
   bannerID mediumint(9) DEFAULT '0' NOT NULL,
   acl_con set('and','or') NOT NULL,
   acl_type enum('clientip','useragent','weekday','domain','source','time','language') NOT NULL,
   acl_data varchar(255) NOT NULL,
   acl_ad set('allow','deny') NOT NULL,
   acl_order int(10) unsigned DEFAULT '0' NOT NULL,
   KEY bannerID (bannerID),
   UNIQUE bannerID_2 (bannerID, acl_order)
);

# --------------------------------------------------------
#
# Table structure for table 'phpads_adstats'
#
CREATE TABLE phpads_adstats (
  views int(11) DEFAULT '0' NOT NULL,
  clicks int(11) DEFAULT '0' NOT NULL,
  day date DEFAULT '0000-00-00' NOT NULL,
  BannerID smallint(6) DEFAULT '0' NOT NULL,
  PRIMARY KEY (day,BannerID)
);

[toplay]

 

Remove:

 

DEFAULT '0'

 

from clientID line.

 

You can't have a default value on an auto_increment column.