fee 							float DEFAULT 0 NOT NULL,	currency 						CHAR(3) DEFAULT 'USD',    status 							INT DEFAULT '0' NOT NULL,    numberofrun 					INT DEFAULT '0' NOT NULL,    datecreate 						TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    datelastrun 					TIMESTAMP,    emailreport 					TEXT,    totalcredit 					float NOT NULL DEFAULT 0,    totalcardperform 				INT DEFAULT '0' NOT NULL,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;ALTER TABLE cc_charge 	ADD COLUMN currency 				CHAR(3) DEFAULT 'USD';ALTER TABLE cc_charge 	ADD COLUMN id_cc_subscription_fee 	BIGINT DEFAULT '0';CREATE INDEX ind_cc_charge_id_cc_card				ON cc_charge (id_cc_card);CREATE INDEX ind_cc_charge_id_cc_subscription_fee 	ON cc_charge (id_cc_subscription_fee);CREATE INDEX ind_cc_charge_creationdate 			ON cc_charge (creationdate);-- ## 	INSTEAD USE CC_CHARGE  ##-- CREATE TABLE cc_subscription_fee_card (--     id 						BIGINT NOT NULL AUTO_INCREMENT,--     id_cc_card 				BIGINT NOT NULL,--     id_cc_subscription_fee 	BIGINT NOT NULL,--     datefee 				TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,--     fee 					FLOAT DEFAULT 0 NOT NULL,	-- 	fee_converted 			FLOAT DEFAULT 0 NOT NULL,-- 	currency 				CHAR(3) DEFAULT 'USD',--     PRIMARY KEY (id)-- )ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;-- -- CREATE INDEX ind_cc_subscription_fee_card_id_cc_card  				ON cc_subscription_fee_card (id_cc_card);-- CREATE INDEX ind_cc_subscription_fee_card_id_cc_subscription_fee 	ON cc_subscription_fee_card (id_cc_subscription_fee);-- CREATE INDEX ind_cc_subscription_fee_card_datefee 					ON cc_subscription_fee_card (datefee);-- Table Name: cc_outbound_cid_group-- For outbound CID Group-- group_name: Name of the Group Created.CREATE TABLE cc_outbound_cid_group (    id 						INT NOT NULL AUTO_INCREMENT,    creationdate 			TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    group_name 				VARCHAR(70) NOT NULL,        PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;-- Table Name: cc_outbound_cid_list-- For outbound CIDs -- outbound_cid_group: Foreign Key of the CID Group-- cid: Caller ID-- activated Field for Activated or Disabled t=activated.CREATE TABLE cc_outbound_cid_list (    id 					INT NOT NULL AUTO_INCREMENT,	outbound_cid_group	INT NOT NULL,	cid					CHAR(100) NULL,        activated 			INT NOT NULL DEFAULT 0,    creationdate 		TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,        PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;-- id_outbound_cidgroup: Outbound Calls CID Group NameALTER TABLE cc_ratecard ADD COLUMN id_outbound_cidgroup INT NOT NULL DEFAULT -1;INSERT INTO cc_templatemail VALUES ('payment', 'info@call-labs.com', 'Call-Labs', 'PAYMENT CONFIRMATION', 'Thank you for shopping at Call-Labs.Shopping details is as below.Item Name = <b>$itemName</b>Item ID = <b>$itemID</b>Amount = <b>$itemAmount</b>Payment Method = <b>$paymentMethod</b>Status = <b>$paymentStatus</b>Kind regards,Call Labs', '');INSERT INTO cc_templatemail VALUES ('invoice', 'info@call-labs.com', 'Call-Labs', 'A2BILLING INVOICE', 'Dear Customer.Attached is the invoice.Kind regards,Call Labs', '');-- Payment Methods TableCREATE TABLE cc_payment_methods (    id 								INT NOT NULL AUTO_INCREMENT,    payment_method 					CHAR(100) NOT NULL,    payment_filename 				CHAR(200) NOT NULL,    active 							CHAR(1) DEFAULT 'f' NOT NULL,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;Insert into cc_payment_methods (payment_method,payment_filename,active) values('paypal','paypal.php','t');Insert into cc_payment_methods (payment_method,payment_filename,active) values('Authorize.Net','authorizenet.php','t');Insert into cc_payment_methods (payment_method,payment_filename,active) values('MoneyBookers','moneybookers.php','t');CREATE TABLE cc_payments (  id 								int NOT NULL auto_increment,  customers_id 						varchar(60) NOT NULL,  customers_name 					varchar(200) NOT NULL,  customers_email_address 			varchar(96) NOT NULL,  item_name 						varchar(127),  item_id 							varchar(127),  item_quantity 					int NOT NULL DEFAULT 0,  payment_method 					varchar(32) NOT NULL,  cc_type 							varchar(20),  cc_owner 							varchar(64),  cc_number 						varchar(32),  cc_expires 						varchar(4),  orders_status 					int(5) NOT NULL,  orders_amount 					DECIMAL(14,6),  last_modified 					datetime,  date_purchased 					datetime,  orders_date_finished 				datetime,  currency 							char(3),  currency_value 					DECIMAL(14,6),  PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;-- Payment Status Lookup TableCREATE TABLE cc_payments_status (  id 								int NOT NULL auto_increment,  status_id 						int NOT NULL,  status_name 						varchar(200) NOT NULL,  PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;Insert into cc_payments_status (status_id,status_name) values (-2, 'Failed');Insert into cc_payments_status (status_id,status_name) values (-1, 'Denied');Insert into cc_payments_status (status_id,status_name) values (0, 'Pending');Insert into cc_payments_status (status_id,status_name) values (1, 'In-Progress');Insert into cc_payments_status (status_id,status_name) values (2, 'Completed');Insert into cc_payments_status (status_id,status_name) values (3, 'Processed');Insert into cc_payments_status (status_id,status_name) values (4, 'Refunded');Insert into cc_payments_status (status_id,status_name) values (5, 'Unknown');CREATE TABLE cc_configuration (  configuration_id int NOT NULL auto_increment,  configuration_title varchar(64) NOT NULL,  configuration_key varchar(64) NOT NULL,  configuration_value varchar(255) NOT NULL,  configuration_description varchar(255) NOT NULL,  configuration_type int NOT NULL DEFAULT 0,  use_function varchar(255) NULL,  set_function varchar(255) NULL,  PRIMARY KEY (configuration_id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description) values ('Login Username', 'MODULE_PAYMENT_AUTHORIZENET_LOGIN', 'testing', 'The login username used for the Authorize.net service');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description) values ('Transaction Key', 'MODULE_PAYMENT_AUTHORIZENET_TXNKEY', 'Test', 'Transaction Key used for encrypting TP data');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Transaction Mode', 'MODULE_PAYMENT_AUTHORIZENET_TESTMODE', 'Test', 'Transaction mode used for processing orders', 'tep_cfg_select_option(array(\'Test\', \'Production\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Transaction Method', 'MODULE_PAYMENT_AUTHORIZENET_METHOD', 'Credit Card', 'Transaction method used for processing orders', 'tep_cfg_select_option(array(\'Credit Card\', \'eCheck\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Customer Notifications', 'MODULE_PAYMENT_AUTHORIZENET_EMAIL_CUSTOMER', 'False', 'Should Authorize.Net e-mail a receipt to the customer?', 'tep_cfg_select_option(array(\'True\', \'False\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Enable Authorize.net Module', 'MODULE_PAYMENT_AUTHORIZENET_STATUS', 'True', 'Do you want to accept Authorize.net payments?', 'tep_cfg_select_option(array(\'True\', \'False\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Enable PayPal Module', 'MODULE_PAYMENT_PAYPAL_STATUS', 'True', 'Do you want to accept PayPal payments?','tep_cfg_select_option(array(\'True\', \'False\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description) values ('E-Mail Address', 'MODULE_PAYMENT_PAYPAL_ID', 'you@yourbusiness.com', 'The e-mail address to use for the PayPal service');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Transaction Currency', 'MODULE_PAYMENT_PAYPAL_CURRENCY', 'Selected Currency', 'The currency to use for credit card transactions', 'tep_cfg_select_option(array(\'Selected Currency\',\'USD\',\'CAD\',\'EUR\',\'GBP\',\'JPY\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description) values ('E-Mail Address', 'MODULE_PAYMENT_MONEYBOOKERS_ID', 'you@yourbusiness.com', 'The eMail address to use for the moneybookers service');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description) values ('Referral ID', 'MODULE_PAYMENT_MONEYBOOKERS_REFID', '989999', 'Your personal Referral ID from moneybookers.com');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Transaction Currency', 'MODULE_PAYMENT_MONEYBOOKERS_CURRENCY', 'Selected Currency', 'The default currency for the payment transactions', 'tep_cfg_select_option(array(\'Selected Currency\',\'EUR\', \'USD\', \'GBP\', \'HKD\', \'SGD\', \'JPY\', \'CAD\', \'AUD\', \'CHF\', \'DKK\', \'SEK\', \'NOK\', \'ILS\', \'MYR\', \'NZD\', \'TWD\', \'THB\', \'CZK\', \'HUF\', \'SKK\', \'ISK\', \'INR\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Transaction Language', 'MODULE_PAYMENT_MONEYBOOKERS_LANGUAGE', 'Selected Language', 'The default language for the payment transactions', 'tep_cfg_select_option(array(\'Selected Language\',\'EN\', \'DE\', \'ES\', \'FR\'), ');insert into cc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, set_function) values ('Enable moneybookers Module', 'MODULE_PAYMENT_MONEYBOOKERS_STATUS', 'True', 'Do you want to accept moneybookers payments?','tep_cfg_select_option(array(\'True\', \'False\'), ');ALTER TABLE cc_card ADD COLUMN id_subscription_fee INT DEFAULT 0, ADD COLUMN mac_addr CHAR(17) DEFAULT '00-00-00-00-00-00' NOT NULL;UPDATE cc_ui_authen SET perms = '32767' WHERE userid = '1';UPDATE cc_ui_authen SET perms = '32767' WHERE userid = '2';ALTER TABLE cc_invoices ADD COLUMN payment_date TIMESTAMP;ALTER TABLE cc_invoices ADD COLUMN payment_status INT DEFAULT 0;CREATE TABLE cc_epayment_log (    id 								INT NOT NULL AUTO_INCREMENT,    cardid 							INT DEFAULT 0 NOT NULL,    amount 							FLOAT DEFAULT 0 NOT NULL,	vat 							FLOAT DEFAULT 0 NOT NULL,    paymentmethod	 				CHAR(50) NOT NULL,       	cc_owner 						VARCHAR(64),  	cc_number 						VARCHAR(32),  	cc_expires 						VARCHAR(7),						       creationdate  					TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    status 							INT DEFAULT 0 NOT NULL,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;INSERT INTO cc_templatemail VALUES ('epaymentverify', 'info@call-labs.com', 'Call-Labs', 'Epayment Gateway Security Verification Failed', 'Dear AdministratorPlease check the Epayment Log, System has logged a Epayment Security failure. that may be a possible attack on epayment processing.Time of Transaction: $timePayment Gateway: $paymentgatewayAmount: $amountKind regards,Call Labs', '');CREATE TABLE cc_system_log (    id 								INT NOT NULL AUTO_INCREMENT,    iduser 							INT DEFAULT 0 NOT NULL,    loglevel	 					INT DEFAULT 0 NOT NULL,    action			 				TEXT NOT NULL,    description						MEDIUMTEXT,        data			 				BLOB,	tablename						VARCHAR(255),	pagename			 			VARCHAR(255),	ipaddress						VARCHAR(255),		creationdate  					TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,    PRIMARY KEY (id))ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_bin;