192
edits
MailNews:Address Book SQLite design: Difference between revisions
MailNews:Address Book SQLite design (view source)
Revision as of 18:41, 24 November 2007
, 24 November 2007→Proposed schema
(Start adding some requirements) |
|||
| Line 20: | Line 20: | ||
CREATE TABLE Cards ( | CREATE TABLE Cards ( | ||
CardKey INT NOT NULL PRIMARY KEY AUTOINCREMENT, | CardKey INT NOT NULL PRIMARY KEY AUTOINCREMENT, | ||
[ xxx CHAR for all defined names in nsAddressBook.idl ] | [ xxx CHAR for all defined names in nsAddressBook.idl ] -- ''Reduce these to core flags only?'' | ||
); | ); | ||
CREATE TABLE OtherProperties ( | CREATE TABLE OtherProperties ( | ||
| Line 29: | Line 29: | ||
CREATE TABLE Directories ( | CREATE TABLE Directories ( | ||
DirKey INT NOT NULL PRIMARY KEY AUTOINCREMENT, | DirKey INT NOT NULL PRIMARY KEY AUTOINCREMENT, | ||
Flags INT NOT NULL, | Flags INT NOT NULL, -- ''What flags might need to exist? Directory type?'' | ||
Name CHAR, | Name CHAR, | ||
Description CHAR | Description CHAR | ||
| Line 36: | Line 36: | ||
DirKey INT NOT NULL, | DirKey INT NOT NULL, | ||
CardKey INT NOT NULL | CardKey INT NOT NULL | ||
); | |||
CREATE TABLE HierarchyMap { | |||
ParentDir INT NOT NULL, | |||
ChildDir INT NOT NULL | |||
); | ); | ||