The synchronization scheme of the mobile terminal and the server database

Server-side:

1, create data table

2, manipulate the log of the database. Define three fields (ID, Operation time, action content, distribution to the user ID of the owning phone)

Id:js UUID Value

Operation time: 2014/8/21-11:32:10

What to do: Store select,delete,update in JSON format

The user ID that is distributed to the owning phone: The phone is not required by every mobile phone user, and optionally updates the data.

Mobile phone side:

Build the empty library, directly take the server-side operation database log operation. Then take the server-side operation log, filter the time to operate.