DROP TABLE IF EXISTS `oc_affiliate`;
CREATE TABLE `oc_affiliate` (
`affiliate_id` int(11) NOT NULL AUTO_INCREMENT,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(96) NOT NULL,
`telephone` varchar(32) NOT NULL,
`fax` varchar(32) NOT NULL,
`password` varchar(40) NOT NULL,
`salt` varchar(9) NOT NULL,
`company` varchar(40) NOT NULL,
`website` varchar(255) NOT NULL,
`address_1` varchar(128) NOT NULL,
`address_2` varchar(128) NOT NULL,
`city` varchar(128) NOT NULL,
`postcode` varchar(10) NOT NULL,
`country_id` int(11) NOT NULL,
`zone_id` int(11) NOT NULL,
`code` varchar(64) NOT NULL,
`commission` decimal(4,2) NOT NULL DEFAULT '0.00',
`tax` varchar(64) NOT NULL,
`payment` varchar(6) NOT NULL,
`cheque` varchar(100) NOT NULL,
`paypal` varchar(64) NOT NULL,
`bank_name` varchar(64) NOT NULL,
`bank_branch_number` varchar(64) NOT NULL,
`bank_swift_code` varchar(64) NOT NULL,
`bank_account_name` varchar(64) NOT NULL,
`bank_account_number` varchar(64) NOT NULL,
`ip` varchar(40) NOT NULL,
`status` tinyint(1) NOT NULL,
`approved` tinyint(1) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`affiliate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
если я правильно поняла, что это те данные что надо внести в базу