EtherPad Database Schema?

Question

Does anyone have an EtherPad Database schema? I searched for him, watched tons of queries, but could not find him.

I am interested in taking a look. I am also curious about how the EtherPad handlers / timing handlers are. Do they create new records for each save in the main pad table?

Answer 1

Here the complete schema is reset by mysql:

http://padm.us/schema

Here is a blog post about it:

http://appolo85.wordpress.com/2010/03/22/first-steps-understanding-etherpad/

Answer 2

Changes are saved as change sets, and operational transformations ( http://en.wikipedia.org/wiki/Operational_transformation ) are used every time the web browser wants to view the revision. Changes are saved in step units 1, 10, 100, etc. In revisions, there is also a property table, which may contain a name, date modified, etc.