id 									BIGINT NOT NULL AUTO_INCREMENT,    label 								TEXT NOT NULL,    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;