mysql vnos

Lep pozdrav. Malo sem se začel igrati z freeradiusom in me zanima zakaj hudica mi ne vnese tabele v mysql bazo. Mislim nekatere tabele mi ostale pa vrze ven napako.

Evo tabeli kateri vnese :

CREATE TABLE mtotacct (
MTotAcctId bigint(21) NOT NULL auto_increment,
UserName varchar(64) NOT NULL default '',
AcctDate date NOT NULL default '0000-00-00',
ConnNum bigint(12) default NULL,
ConnTotDuration bigint(12) default NULL,
ConnMaxDuration bigint(12) default NULL,
ConnMinDuration bigint(12) default NULL,
InputOctets bigint(12) default NULL,
OutputOctets bigint(12) default NULL,
NASIPAddress varchar(15) default NULL,
PRIMARY KEY (MTotAcctId),
KEY UserName (UserName),
KEY AcctDate (AcctDate),
KEY UserOnDate (UserName,AcctDate),
KEY NASIPAddress (NASIPAddress)
);

in

CREATE TABLE totacct (
TotAcctId bigint(21) NOT NULL auto_increment,
UserName varchar(64) NOT NULL default '',
AcctDate date NOT NULL default '0000-00-00',
ConnNum bigint(12) default NULL,
ConnTotDuration bigint(12) default NULL,
ConnMaxDuration bigint(12) default NULL,
ConnMinDuration bigint(12) default NULL,
InputOctets bigint(12) default NULL,
OutputOctets bigint(12) default NULL,
NASIPAddress varchar(15) default NULL,
PRIMARY KEY (TotAcctId),
KEY UserName (UserName),
KEY AcctDate (AcctDate),
KEY UserOnDate (UserName,AcctDate),
KEY NASIPAddress (NASIPAddress),
KEY NASIPAddressOnDate (AcctDate,NASIPAddress)
);

te dve brez problema uvoz , medtem ko teh pa ne jebe:

#
# Table structure for table 'userinfo'
#
CREATE TABLE userinfo (
id int(10) DEFAULT '0' NOT NULL auto_increment,
UserName varchar(30),
Name varchar(200),
Mail varchar(200),
Department varchar(200),
WorkPhone varchar(200),
HomePhone varchar(200),
Mobile varchar(200),
PRIMARY KEY (id),
KEY UserName (UserName),
KEY Departmet (Department)
);

in te

#
# Table structure for table 'badusers'
#
CREATE TABLE badusers (
id int(10) DEFAULT '0' NOT NULL auto_increment,
UserName varchar(30),
Date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
Reason varchar(200),
Admin varchar(30) DEFAULT '-',
PRIMARY KEY (id),
KEY UserName (UserName),
KEY Date (Date)
);

Teh dveh tabel ne vnese ampak napise : MySQL je vrnil: Dokumentacija
#1067 - Invalid default value for 'id'

neč men več jasno kaj bi blo. A bi lahko kdo to pogledal ka se mu kaj sanja kaj bi bilo. Rabim pa te tabele za freeradius admina.

Se zmeri ne dela. Ali ima kdo prazno bazo da jo samo uvozim ?

tole men dela

CREATE TABLE badusers(
id int( 10 ) NOT NULL AUTO_INCREMENT ,
UserName varchar( 30 ) ,
Date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL ,
Reason varchar( 200 ) ,
Admin varchar( 30 ) DEFAULT '-',
PRIMARY KEY ( id ) ,
KEY UserName( UserName ) ,
KEY Date( Date )
)