Guidance on home motioning system

Most sensors are already there, from previous alarm. The letterbox/gate one is a future project, still debating whether to go wireless + solar for that, running wires is normally not an issue for me and I always prefer hardwired over wireless.

Thx for the mysql links, just wondering if it is a good thing for the PIR sensors though.