PHP/MySQL Web Application

[Sherbs]

I am going to start looking into rebuilding our estimating and MIS system in PHP with a SQL powered database.

Are there any guides out there when it comes to database planning and preparation?

Will be the biggest project i've undertaken so far, so would like to get the structure set up correctly.

Quite a small company, but we have around a thousand customers and have done around 11,000 orders in 5 years. So will need to be scalable.

 

[Sherbs]

Currently in ASP, but the guys who developed it have let it stagnant for 5 years. I do not have access to the source code, but will be able to get our databases exported.

It could be a lot better and its no longer suiting our needs 100%.

Thinking about building it into a current framework, maybe symphony or wordpress? I've looked into CodeIgniter before, maybe its worth another look.