Ayuda con install.php

[pablogross]

Hola necesito que me ayuden con este scrip de instalacion de tablas el cual de devuelve este error: Invalid default value for 'AccountType' at row 49


install.php (PARTE1 DEL SCRIP)

<?
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', ' email')";
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(50) 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__);

$q1 = "DROP TABLE IF EXISTS re2_banners";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_banners (
ClientID int(10) NOT NULL default '0',
BannerID int(10) NOT NULL auto_increment,
BannerURL varchar(255) NOT NULL default '',
BannerFile varchar(255) NOT NULL default '',
BannerAlt varchar(255) NOT NULL default '',
BannerType varchar(50) NOT NULL default '',
bCat int(10) NOT NULL default '0',
bSub int(10) NOT NULL default '0',
PRIMARY KEY (BannerID))";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "DROP TABLE IF EXISTS re2_categories";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_categories (
CategoryID int(10) NOT NULL auto_increment,
CategoryName varchar(255) NOT NULL default '',
PRIMARY KEY (CategoryID),
UNIQUE KEY CategoryName(CategoryName))";

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

$q1 = "INSERT INTO re2_categories VALUES (3, 'For Sale')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_categories VALUES (4, 'For Rent')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "DROP TABLE IF EXISTS re2_listings";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_listings (
ListingID int(10) NOT NULL auto_increment,
AgentID int(10) NOT NULL default '0',
CategoryID int(10) NOT NULL default '0',
SubcategoryID int(10) NOT NULL default '0',
address text NOT NULL,
city varchar(100) NOT NULL default '',
state varchar(100) NOT NULL default '',
country varchar(150) NOT NULL default '',
ShortDesc text NOT NULL,
DetailedDesc text NOT NULL,
Price float(15,2) NOT NULL default '0.00',
PropertyType varchar(50) NOT NULL default '',
neighbourhood text NOT NULL,
rooms int(2) NOT NULL default '0',
bathrooms int(2) NOT NULL default '0',
fireplace char(1) NOT NULL default 'n',
garage int(2) NOT NULL default '0',
SquareMeters float(15,2) NOT NULL default '0.00',
LotSize float(15,2) NOT NULL default '0.00',
HomeAge int(3) NOT NULL default '0',
NearSchool char(1) NOT NULL default 'n',
NearTransit char(1) NOT NULL default 'n',
NearPark char(1) NOT NULL default 'n',
OceanView char(1) NOT NULL default 'n',
LakeView char(1) NOT NULL default 'n',
MountainView char(1) NOT NULL default 'n',
OceanWaterfront char(1) NOT NULL default 'n',
LakeWaterfront char(1) NOT NULL default 'n',
RiverWaterfront char(1) NOT NULL default 'n',
image text NOT NULL,
DateAdded int(10) NOT NULL default '0',
visits int(10) NOT NULL default '0',
PRIMARY KEY (ListingID)) ";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "DROP TABLE IF EXISTS re2_mail_archive";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_mail_archive (
subject varchar(255) NOT NULL default '',
message text,
MailDate int(10) NOT NULL default '0')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "DROP TABLE IF EXISTS re2_prices";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_prices (
PackageName varchar(50) NOT NULL default '',
PriceID int(10) NOT NULL auto_increment,
PriceValue float(5,2) NOT NULL default '0.00',
Duration varchar(10) NOT NULL default '',
PriorityLevel int(1) NOT NULL default '0',
PriceType varchar(10) NOT NULL default '0',
offers int(10) NOT NULL default '0',
PRIMARY KEY (PriceID))";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_prices VALUES ('Realtor Bronze', 7, '14.95', '1', 1, 'Realtor', 5)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_prices VALUES ('Private Listing', 9, '9.95', '1', 1, 'Private', 1)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_prices VALUES ('Realtor Silver', 10, '24.95', '1', 1, 'Realtor', 10)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_prices VALUES ('Realtor Gold', 11, '39.95', '1', 1, 'Realtor', 20)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);



$q1 = "DROP TABLE IF EXISTS re2_priority";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_priority (
PriorityID int(10) NOT NULL auto_increment,
PriorityName varchar(50) NOT NULL default '',
PriorityLevel int(1) NOT NULL default '0',
PRIMARY KEY (PriorityID),
UNIQUE KEY PriorityName(PriorityName))";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "INSERT INTO re2_priority VALUES (1, 'Standard', 1)";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);




$q1 = "DROP TABLE IF EXISTS re2_settings";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);

$q1 = "CREATE TABLE re2_settings (
id int(1) NOT NULL default '0',
SiteTitle varchar(255) NOT NULL default '',
SiteName varchar(255) NOT NULL default '',
SiteKeywords varchar(255) NOT NULL default '',
SiteDescription text,
ContactEmail varchar(150) NOT NULL default '',
CompanyAddress text,
PayPalEmail varchar(150) NOT NULL default '',
SellerID int(6) NOT NULL default '0',
Agreement text NOT NULL,
sp_vendor_email varchar(255) NOT NULL default '',
sp_payee_email varchar(255) NOT NULL default '',
sp_secret_code varchar(255) NOT NULL default '')";
mysql_query($q1) or die(mysql_error()." at row ".__LINE__);