80320 Simple Database Conversion

Hi, I am upgrading to a new customer management program and the drag is that the old software I use has a different database structure then the new one. These management pieces are PHP with MySQL backend so it should be pretty easy to convert the two MySQL databases. Here is the biggest problem: the old software stored data in this way: a table holidng customer data (email, name, address, auto id) and then a table holding account data (domain name, corresponding customer id). The new database holds one table for clients and each entry includes both the customer info and account info, if a customer has more then one account, it simply adds another entry. I need to convert the two tables into one using a script--that you create for me! Here is the table info: OLD DATABASE----- CUSTOMER TABLE: CustomerID int(10) unsigned NOT NULL auto_increment, First varchar(30) default NULL, Last varchar(40) default NULL, Address varchar(255) default NULL, Telephone varchar(16) default NULL, Fax varchar(16) default NULL, Email varchar(100) default NULL, City varchar(50) default NULL, State varchar(50) default NULL, Zip varchar(10) default NULL, Balance float(10,8) default NULL, CCNumber varchar(20) default NULL, CCName varchar(80) default NULL, Password varchar(50) default NULL, Company varchar(100) default NULL, CCExpire varchar(10) default NULL, Country varchar(100) default NULL, Overdraft float(10,8) default NULL ACCOUNTS TABLE: AccountID int(10) unsigned NOT NULL auto_increment, CustomerID int(10) unsigned default NULL, Username varchar(50) default NULL, Password varchar(50) default NULL, DateOpened date default NULL, DateClosed date default NULL, Status varchar(25) default NULL, PackageGroupID int(10) unsigned default NULL, Domain varchar(125) default NULL, LastDateBilled date default NULL, NEW DATABASE------- id int(4) NOT NULL auto_increment, surname varchar(100) default NULL, firstname varchar(100) default NULL, telephone varchar(100) default NULL, email varchar(100) default NULL, icq varchar(100) default NULL, referrer varchar(100) default NULL, house varchar(100) default NULL, street varchar(100) default NULL, town varchar(100) default NULL, state varchar(100) default NULL, country varchar(100) default NULL, postcode varchar(100) default NULL, domainname varchar(100) default NULL, domain varchar(100) default NULL, package varchar(100) default NULL, schedule varchar(100) default NULL, payment varchar(100) default NULL, username varchar(100) default NULL, password varchar(100) default NULL, ipaddress varchar(100) default NULL, startdate varchar(100) default NULL, invoicedate varchar(100) default NULL, duedate varchar(100) default NULL, amount varchar(100) default NULL, paid char(3) default 'Yes', status varchar(100) default 'Online', notes varchar(255) default NULL, language varchar(100) default '[login to view URL]', template varchar(100) default 'default', ---------- Anything from the old database that is not in the new database can be discarded. There is one more thing that needs to be noted, the new database stores a domain name as this: using [login to view URL] as the domain, domainname=example and domain=.com - a simply split function should be able to handle that. If you do not see info in the old database for the new database, that is fine, we will simply use a default for that non-existant data (since I won't be referring to it anyways). I know that this is a pretty easy task and my budget has been set at $15, unfortunately I cannot go over that and if you cannot work within that, please don't bid. I do not have the authority to change the budget, thus it will not be done. I will be going out of town on Tuesday and will return on Friday. I would like to have it done by Friday so that when I get back I can take care of all this. If you need any additional information, feel free to open a PMB. I will not be able to provide you with the "data" because it is confidential information, I will need to run the php script myself. One last note: $1 bids that are not $1 bids will be removed and reported to Scriptlance. Thanks for all your help and good luck!