Installation: MySQL Database

[Peter Schmalfeldt]

There are two files for creating the MySQL tables you will need for
Easy APNS to function. You will only need to use one of them.

The primary file is named 'apns.sql' and can be located here:

http://easyapns.googlecode.com/svn/trunk/src/sql/apns.sql

You will want to use this file if you can, but you will need a MySQL
user with full admin access. The reason for this is because the
`apns_devices` table has a trigger that when a device registers that
already exists in the table, the current values are archived in
`apns_device_history` and then overwritten. This will allow you to
keep track and monitor changes in device activity.

If you do not have this level of access to your MySQL database, there
is an alternative file named 'apns_alt.sql' and it can be located
here:

http://easyapns.googlecode.com/svn/trunk/src/sql/apns_alt.sql

This will install the main tables you need for the Easy APNS
application to run, but will not archive all registrations. It will
only store NEW registrations, and update existing registrations.