[evolution-ews] Add a bdata column in contacts table to cater future needs if anything arises.
- From: Chenthill Palanisamy <pchen src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [evolution-ews] Add a bdata column in contacts table to cater future needs if anything arises.
- Date: Tue, 10 May 2011 13:06:29 +0000 (UTC)
commit 7ffdad8ac6fd37c4d9f265aaaa18a636bdebf952
Author: Chenthill Palanisamy <pchenthill novell com>
Date: Tue May 10 16:49:26 2011 +0530
Add a bdata column in contacts table to cater future needs if anything
arises.
src/addressbook/e-book-backend-sqlitedb.c | 14 ++++++++++----
1 files changed, 10 insertions(+), 4 deletions(-)
---
diff --git a/src/addressbook/e-book-backend-sqlitedb.c b/src/addressbook/e-book-backend-sqlitedb.c
index 40f58cc..abf9d56 100644
--- a/src/addressbook/e-book-backend-sqlitedb.c
+++ b/src/addressbook/e-book-backend-sqlitedb.c
@@ -218,14 +218,19 @@ create_folders_table (EBookBackendSqliteDB *ebsdb,
gint ret;
/* sync_data points to syncronization data, it could be last_modified time
or a sequence number or some text depending on the backend.
+
parial_content says whether the contents are partially downloaded for
- auto-completion or if it has the complete content */
+ auto-completion or if it has the complete content.
+
+ Have not included a bdata here since the keys table should suffice any
+ additional need that arises.
+ */
const gchar *stmt = "CREATE TABLE IF NOT EXISTS folders \
( folder_id TEXT PRIMARY KEY, \
folder_name TEXT, \
sync_data TEXT, \
populated INTEGER \
- partial_content INTEGER)";
+ partial_content INTEGER)";
WRITER_LOCK (ebsdb);
ret = book_backend_sql_exec (ebsdb->priv->db, stmt, NULL, NULL , NULL);
@@ -253,7 +258,8 @@ create_contacts_table (EBookBackendSqliteDB *ebsdb,
{
gint ret;
gchar *stmt, *tmp;
-
+
+ /* bdata is a place holder if any future need arises */
stmt = sqlite3_mprintf ("CREATE TABLE IF NOT EXISTS %Q \
( uid TEXT PRIMARY KEY, \
nickname TEXT, full_name TEXT, \
@@ -261,7 +267,7 @@ create_contacts_table (EBookBackendSqliteDB *ebsdb,
email_1 TEXT, email_2 TEXT, \
email_3 TEXT, email_4 TEXT, \
partial_content INTEGER, \
- vcard TEXT)", folderid);
+ vcard TEXT, bdata TEXT)", folderid);
WRITER_LOCK (ebsdb);
ret = book_backend_sql_exec (ebsdb->priv->db, stmt, NULL, NULL , error);
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]