MailNews:Address Book SQLite design: Difference between revisions

MailNews:Address Book SQLite design (view source)

271 bytes removed , 28 January 2008

no edit summary

192

edits

@@ Line 20: / Line 20: @@
   CREATE TABLE Cards (
     CardKey INT NOT NULL PRIMARY KEY AUTOINCREMENT,
-    [ xxx CHAR for all defined names in nsAddressBook.idl ]
+    firstName CHAR,
+   lastName CHAR,
+   displayName CHAR,
+   nickName CHAR,
+   primaryEmail CHAR,
+   secondaryEmail CHAR,
+   popularityIndex INT NOT NULL,
+   preferMailFormat INT NOT NULL,
+   lastModifiedDate INT NOT NULL
   );
-  CREATE TABLE OtherProperties (
+  CREATE TABLE CardProperties (
     CardKey INT NOT NULL,
     Property CHAR NOT NULL,
@@ Line 40: / Line 48: @@
     ParentDir INT NOT NULL,
     ChildDir INT NOT NULL
- );
-=== Alternate modifications ===
- CREATE TABLE Cards (
-   CardKey INT NOT NULL PRIMARY KEY AUTOINCREMENT,
-   firstName CHAR,
-   lastName CHAR,
-   displayName CHAR,
-   nickName CHAR,
-   primaryEmail CHAR,
-   secondaryEmail CHAR,
-   popularityIndex INT NOT NULL,
-   preferMailFormat INT NOT NULL,
-   lastModifiedDate INT NOT NULL
- );
- CREATE TABLE CardProperties (
-   CardKey INT NOT NULL,
-   Property CHAR NOT NULL,
-   Value CHAR
   );