Add initial logic for setting up shared/published notebooks. Added logic to download...

[neighbornote/NeighborNote.git] / src / cx / fbn / nevernote / sql / LinkedNotebookTable.java

diff --git a/src/cx/fbn/nevernote/sql/LinkedNotebookTable.java b/src/cx/fbn/nevernote/sql/LinkedNotebookTable.java
index 71a1633..b5a32bb 100644 (file)
--- a/src/cx/fbn/nevernote/sql/LinkedNotebookTable.java
+++ b/src/cx/fbn/nevernote/sql/LinkedNotebookTable.java
@@ -49,6 +49,8 @@ public class LinkedNotebookTable {
                        "shareKey VarChar, " +\r
                        "uri VarChar, " +\r
                        "updateSequenceNumber Long," +\r
+                       "lastSequenceNumber Long," +\r
+                       "lastSequenceDate timestamp," +\r
                        "icon blob, " +\r
                        "isDirty boolean)"))                            \r
                logger.log(logger.HIGH, "Table LinkedNotebook creation FAILED!!!");   \r
@@ -64,10 +66,11 @@ public class LinkedNotebookTable {
                \r
         NSqlQuery query = new NSqlQuery(db.getConnection());\r
                check = query.prepare("Insert Into LinkedNotebook (guid, shareName, username,  "\r
-                               +"shardId, shareKey, uri, updateSequenceNumber, isDirty) "   \r
+                               +"shardId, shareKey, uri, updateSequenceNumber, isDirty, lastSequenceNumber, "\r
+                               + "lastSequenceDate) "   \r
                                + " Values("\r
                                +":guid, :shareName, :username, "\r
-                               +":shardId, :shareKey, :uri,:usn, :isDirty)");\r
+                               +":shardId, :shareKey, :uri,:usn, :isDirty, 0, '1969-12-31 19.00.00')");\r
                query.bindValue(":guid", tempNotebook.getGuid());\r
                query.bindValue(":shareName", tempNotebook.getShareName());\r
                query.bindValue(":username", tempNotebook.getUsername());\r