Ajuda com Tabela SQL

[fhilippe]

olá pessoal, estou com um arquivo de instalação de tabela no Mysql, só que não está instalando o re2_agents

para baixar a tabela completa

http://www.megaupload.com/?d=EAE9KJFR

<?

require_once("conn.php");

$q1 = "DROP TABLE IF EXISTS re2_admin";

mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_admin (

AdminID varchar(50) NOT NULL default '',

AdminPass varchar(32) NOT NULL default '',

AdminName varchar(100) NOT NULL default '',

AdminEmail varchar(150) NOT NULL default '',

PRIMARY KEY (AdminID))";

mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_admin VALUES ('admin', 'admin', 'Deb', 'neo@cyberia.ca')";

mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "DROP TABLE IF EXISTS re2_agents";

mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_agents (

AgentID int(10) NOT NULL auto_increment,

AccountType int(1) not null default '',

username varchar(50) NOT NULL default '',

password varchar(32) NOT NULL default '',

FirstName varchar(150) NOT NULL default '',

LastName varchar(150) NOT NULL default '',

resume text NOT NULL,

phone varchar(50) NOT NULL default '',

cellular varchar(50) NOT NULL default '',

pager varchar(250) NOT NULL default '',

ResumeImages text NOT NULL,

email varchar(150) NOT NULL default '',

logo varchar(255) NOT NULL default '',

RegDate int(10) NOT NULL default '0',

ExpDate int(10) NOT NULL default '0',

AccountStatus varchar(20) NOT NULL default 'pending',

PriorityLevel int(1) NOT NULL default '2',

offers int(3) NOT NULL default '0',

news char(1) NOT NULL default 'y',

NewsletterType varchar(10) NOT NULL default 'plain',

days10 char(1) NOT NULL default 'n',

days5 char(1) NOT NULL default 'n',

days1 char(1) NOT NULL default 'n',

PRIMARY KEY (AgentID),

UNIQUE KEY username(username),

UNIQUE KEY email(email)) ";

mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

//o erro está na linha acima

$q1 = "DROP TABLE IF EXISTS re2_banners";

mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

[Denis Courcy]

Oi 'fhilippe'

Corrija a linha

AccountType int(1) not null default '',

para que fique assim:

AccountType int(1) not null default '0',