String:
when do you use varchar or char or mediumtext
Integers:
int or tinyint ? whats the difference and does this mean the amount of available characters it allows ? tinyint(4) ? varchar(25)
so tax_id tinyint(9) default NULL, does that mean that if i have this 1111111111 it will strip the last "1" because there are a total of 10 "1" 's ?
CREATE TABLE account_affiliate_details (
id int(10) unsigned NOT NULL auto_increment,
percentage decimal(10,2) default NULL,
tax_classification varchar(25) default NULL,
tax_id tinyint(9) default NULL,
site_url varchar(52) default NULL,
site_stats_vistiors_p_month tinyint(11) default NULL,
site_stats_page_views_p_month tinyint(11) default NULL,
site_description varchar(255) default NULL,
site_sourceoftraffic varchar(255) default NULL,
xmlfeedId tinyint(11) default NULL,
isPaypalEnabled tinyint(1) default NULL,
paypalEmail varchar(50) default NULL,
created datetime default NULL,
modified datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE account_details (
id int(10) unsigned NOT NULL auto_increment,
name_first varchar(25) ,
name_middle char(1) ,
name_last varchar(25) ,
name_company varchar(60) ,
email varchar(50) ,
number_phone varchar(25) ,
number_fax varchar(25) ,
address_street varchar(50) ,
address_city varchar(30) ,
address_zip tinyint(5) ,
address_state char(20) ,
address_country varchar(50),
foundus mediumtext,
created datetime default NULL,
modified datetime default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE accounts (
id int(10) unsigned NOT NULL auto_increment,
Referred_advertisers tinyint(4) ,
Referred_affiliates tinyint(4) ,
otherAccountId int(10) ,
lastloginDate datetime,
balance decimal(10,2),
userid varchar(10),
password varchar(255) ,
created datetime,
modified datetime,
accounttype varchar(20) ,
accountstatus varchar(20) ,
PRIMARY KEY (id)
) TYPE=MyISAM;
