Creation of Tables for Membership Site

No database selected
create table users ( ID int unsigned not null auto_increment primary key, Name varchar(75), Address varchar(175), City varchar(75), State varchar(75), Zip varchar(15), Country varchar(75), Email varchar(75), Username varchar(75), Password varchar(75), active int unsigned not null, ref_by varchar(75), IP varchar(25), Date datetime, status int unsigned not null, Total float(8,2), Unpaid float(8,2), Paid float(8,2), RDate datetime, subscribed int unsigned not null )

No database selected
create table members ( ID int unsigned not null auto_increment primary key, Username varchar(75), Sponsor varchar(255), ref_by int unsigned not null, Level1 int unsigned not null, Level2 int unsigned not null, Level3 int unsigned not null, Level4 int unsigned not null, Level5 int unsigned not null, Level6 int unsigned not null, Level7 int unsigned not null, Level8 int unsigned not null, Level9 int unsigned not null, Level10 int unsigned not null, Leader int unsigned not null, Total float(8,2), Date datetime, MainID int unsigned not null, CDate datetime )

No database selected
create table plogs ( ID int unsigned not null auto_increment primary key, Username varchar(255), Amount float(8,2), purpose varchar(255), Date datetime )

No database selected
create table tlogs ( ID int unsigned not null auto_increment primary key, Username varchar(75), Amount float(8,2), purpose varchar(255), status int unsigned not null, Date datetime )

No database selected
create table commissions ( ID int unsigned not null auto_increment primary key, mstatus int unsigned not null, level int unsigned not null, fee float(8,2) )

No database selected
create table adminsettings ( sitename text, siteurl text, Email text, Username varchar(75), Password varchar(75), topbanner float(8,2), bottombanner float(8,2), Paypal varchar(75), Moneybookers varchar(175), Alertpay varchar(175), Ebullion varchar(75), levels int unsigned not null, profee float(8,2), minwithdrawal float(8,2), duration int unsigned not null, memberships int unsigned not null, showAddress int unsigned not null, showCity int unsigned not null, showState int unsigned not null, showZip int unsigned not null, showCountry int unsigned not null, yfwid int unsigned not null, confirmreq int unsigned not null, refnotification int unsigned not null )

No database selected
create table tadminsettings ( sitename text, siteurl text, Email text, Username varchar(75), Password varchar(75), Paypal varchar(175), Stormpay varchar(175), Sfipay varchar(175), displaytype int unsigned not null, numberofads int unsigned not null, numberoflinesofads int unsigned not null, dtitle text, dad text, durl text, adbgcolor varchar(175), tadfontface varchar(175), tadfontsize varchar(175), tadfontcolor varchar(175), adfontface varchar(175), adfontsize varchar(175), adfontcolor varchar(175), cadfontface varchar(175), cadfontsize varchar(175), cadfontcolor varchar(175), badbgcolor varchar(175), badfontface varchar(175), badfontsize varchar(175), badfontcolor varchar(175), bottomad text, bottomurl text, maxcharsperline int unsigned not null, ctext varchar(175) )

No database selected
create table sponsorads ( ID int unsigned not null auto_increment primary key, Username varchar(75), Subject text, Body text, WebsiteURL text, assigned int unsigned not null, remaining int unsigned not null, hits int unsigned not null, approved int unsigned not null, Date datetime, adtype int unsigned not null, Name text, Email text, PaymentDetails text )

No database selected
create table packages ( ID int unsigned not null auto_increment primary key, ptype int unsigned not null, impdays int unsigned not null, details text, fee float(8,2) )

No database selected
create table wtransaction ( ID int unsigned not null auto_increment primary key, Username varchar(75), PaymentMode varchar(75), Amount float(8,2), approved int unsigned not null, Date datetime )

No database selected
create table bannersads ( ID int unsigned not null auto_increment primary key, Password varchar(75), BannerURL text, WebsiteURL text, assigned int unsigned not null, remaining int unsigned not null, hits int unsigned not null, approved int unsigned not null, Date datetime, adtype int unsigned not null, Name text, Email text, PaymentDetails text )

No database selected
create table banners ( ID int unsigned not null auto_increment primary key, BannerURL text, Date datetime )

No database selected
create table soloads ( ID int unsigned not null auto_increment primary key, Subject text, Message text, Date datetime )

No database selected
create table pages ( ID int unsigned not null auto_increment primary key, PName varchar(255), pagedesc text, Date datetime )