WordPress database error: [Invalid default value for 'ac_Affiliate_Percent']CREATE TABLE IF NOT EXISTS ndweb_affiliate_users (
id int(11) NOT NULL AUTO_INCREMENT,
ac_userID int(11) NOT NULL,
ac_Name varchar(255) DEFAULT NULL,
ac_Company_Name varchar(100) DEFAULT NULL,
ac_Profession varchar(100) DEFAULT NULL,
ac_Phone_No varchar(20) DEFAULT NULL,
ac_dateJoined int(11) DEFAULT NULL,
ac_Payment_Method varchar(20) DEFAULT NULL,
ac_Paypal_Email varchar(100) DEFAULT NULL,
ac_Affiliate_Percent FLOAT DEFAULT NULL
PRIMARY KEY (id)
)
WordPress database error: [Duplicate column name 'ac_Payment_Method']ALTER TABLE ndweb_affiliate_users
ADD COLUMN ac_Payment_Method varchar(20) DEFAULT NULL,
ADD COLUMN ac_Paypal_Email varchar(100) DEFAULT NULL