create keep in sync field in db on app setup

[pub/Android/ownCloud.git] / src / eu / alefzero / owncloud / providers / FileContentProvider.java

diff --git a/src/eu/alefzero/owncloud/providers/FileContentProvider.java b/src/eu/alefzero/owncloud/providers/FileContentProvider.java
index c1ecef3..a6ffde6 100644 (file)
--- a/src/eu/alefzero/owncloud/providers/FileContentProvider.java
+++ b/src/eu/alefzero/owncloud/providers/FileContentProvider.java
@@ -35,6 +35,7 @@ import android.database.sqlite.SQLiteOpenHelper;
 import android.database.sqlite.SQLiteQueryBuilder;\r
 import android.net.Uri;\r
 import android.text.TextUtils;\r
 import android.database.sqlite.SQLiteQueryBuilder;\r
 import android.net.Uri;\r
 import android.text.TextUtils;\r

+import android.util.Log;\r

 \r
 /**\r
  * The ContentProvider for the ownCloud App.\r
 \r
 /**\r
  * The ContentProvider for the ownCloud App.\r


@@ -66,6 +67,10 @@ public class FileContentProvider extends ContentProvider {
                 ProviderTableMeta.FILE_CONTENT_TYPE);\r
         mProjectionMap.put(ProviderTableMeta.FILE_STORAGE_PATH,\r
                 ProviderTableMeta.FILE_STORAGE_PATH);\r
                 ProviderTableMeta.FILE_CONTENT_TYPE);\r
         mProjectionMap.put(ProviderTableMeta.FILE_STORAGE_PATH,\r
                 ProviderTableMeta.FILE_STORAGE_PATH);\r

+        mProjectionMap.put(ProviderTableMeta.FILE_LAST_SYNC_DATE,\r
+                ProviderTableMeta.FILE_LAST_SYNC_DATE);\r
+        mProjectionMap.put(ProviderTableMeta.FILE_KEEP_IN_SYNC,\r
+                ProviderTableMeta.FILE_KEEP_IN_SYNC);\r

     }\r
 \r
     private static final int SINGLE_FILE = 1;\r
     }\r
 \r
     private static final int SINGLE_FILE = 1;\r


@@ -197,6 +202,7 @@ public class FileContentProvider extends ContentProvider {
 \r
         @Override\r
         public void onCreate(SQLiteDatabase db) {\r
 \r
         @Override\r
         public void onCreate(SQLiteDatabase db) {\r

+            // files table\r

             db.execSQL("CREATE TABLE " + ProviderTableMeta.DB_NAME + "("\r
                     + ProviderTableMeta._ID + " INTEGER PRIMARY KEY, "\r
                     + ProviderTableMeta.FILE_NAME + " TEXT, "\r
             db.execSQL("CREATE TABLE " + ProviderTableMeta.DB_NAME + "("\r
                     + ProviderTableMeta._ID + " INTEGER PRIMARY KEY, "\r
                     + ProviderTableMeta.FILE_NAME + " TEXT, "\r


@@ -207,12 +213,18 @@ public class FileContentProvider extends ContentProvider {
                     + ProviderTableMeta.FILE_CONTENT_TYPE + " TEXT, "\r
                     + ProviderTableMeta.FILE_CONTENT_LENGTH + " INTEGER, "\r
                     + ProviderTableMeta.FILE_STORAGE_PATH + " TEXT, "\r
                     + ProviderTableMeta.FILE_CONTENT_TYPE + " TEXT, "\r
                     + ProviderTableMeta.FILE_CONTENT_LENGTH + " INTEGER, "\r
                     + ProviderTableMeta.FILE_STORAGE_PATH + " TEXT, "\r

-                    + ProviderTableMeta.FILE_ACCOUNT_OWNER + " TEXT);");\r
+                    + ProviderTableMeta.FILE_ACCOUNT_OWNER + " TEXT, "\r
+                    + ProviderTableMeta.FILE_LAST_SYNC_DATE + " INTEGER "\r
+                    + ProviderTableMeta.FILE_KEEP_IN_SYNC + " INTEGER );");\r

         }\r
 \r
         @Override\r
         public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r
         }\r
 \r
         @Override\r
         public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {\r

-\r
+            if (oldVersion == 1 && newVersion >= 2) {\r
+                db.execSQL("ALTER TABLE " + ProviderTableMeta.DB_NAME +\r
+                           " ADD COLUMN " + ProviderTableMeta.FILE_KEEP_IN_SYNC  + " INTEGER " +\r
+                           " DEFAULT 0");\r
+            }\r

         }\r
 \r
     }\r
         }\r
 \r
     }\r