MailNews:Address Book SQLite design: Difference between revisions

MailNews:Address Book SQLite design (view source)

359 bytes added , 25 November 2007

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 ] -- ''Reduce these to core flags only?''
+    [ xxx CHAR for all defined names in nsAddressBook.idl ]
   );
   CREATE TABLE OtherProperties (
@@ Line 40: / Line 40: @@
     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,
+   lastModifiedDate INT NOT NULL
+ );
+ CREATE TABLE CardProperties (
+   CardKey INT NOT NULL,
+   Property CHAR NOT NULL,
+   Value CHAR
   );