APNS MySQL Tables

  `development` enum(production,sandbox) character set latin1 NOT NULL default production,

Table 2: apns_devices (lines 31-48 optional)

This table keeps track of all unique devices registering for push notifications. We also keep track of the applications name and version number in case you are running multiple apps, you can see who is using what.

  `development` enum(production,sandbox) character set latin1 NOT NULL default production,
  `modified` timestamp NOT NULL default 0000-00-00 00:00:00 on update CURRENT_TIMESTAMP,
CREATE TRIGGER `Archive` BEFORE UPDATE ON `apns_devices` FOR EACH ROW INSERT INTO `apns_device_history` VALUES (

Table 3: apns_messages

This is where the messages you send to the user will go. By default, Easy APNs is setup to store the messages in queue and not actually deliver them until instructed elsewhere. This is where you would setup a cron job to process the data that still needs to be delivered.

  `status` enum(queued,delivered,failed) character set latin1 NOT NULL default queued,
  `modified` timestamp NOT NULL default 0000-00-00 00:00:00 on update CURRENT_TIMESTAMP,
一个session只能为自己获取锁和释放锁，不能为其他session获取锁，也不能释放由其他session保持的锁。
MySQL中lock tables和unlock tables浅析 MySQL中lock tables和unlock tables浅析   在MySQL中提供了锁定表（lock tables）和解锁表（unlock tables）的语法功能，ORACLE与SQL Server数据库当中没有这种语法。
win MySQL安装 MySQL是一个关系型数据库管理系统，由瑞典MySQL AB 公司开发，属于 Oracle 旗下产品。MySQL 是最流行的关系型数据库管理系统之一，在 WEB 应用方面，MySQL是最好的 RDBMS(Relational Database Management System，关系数据库管理系统) 应用软件之一。mysql5开源 , mysql8社区版。