Document CREATE statement for history table

[quintstoffers]

No description provided.

[zhuwenying]

Title : History table structure, create&insert statement

1. History database file path, name

   path : /data/data/com.quantimodo.sync/cache/
   name : syncs.sqlite

2. History table name

   history

3. field type and variable

   package VARCHAR //synced app label
   synccount INT // synced measurement count
   syncstate INT(1) //sync result ( 1 : success, -1 : failed)

4. create statement for history table

   CREATE TABLE IF NOT EXISTS history (
   package VARCHAR,
   synccount INT,
   syncstate INT(1)
   );

   1. insert value statement for history table (example)

      INSERT INTO history
      Values ( "Accupedo", 42, -1);

[mikepsinn]

@zhuwenying i think whenever you're documenting something, you want to put it in the wiki