canmove, Confirmed users, Bureaucrats and Sysops emeriti
3,628
edits
MailNews:Address Book SQLite design: Difference between revisions
Jump to navigation
Jump to search
MailNews:Address Book SQLite design (view source)
Revision as of 09:41, 24 November 2007
, 24 November 2007Start adding some requirements
(New page: This page is meant for planning out a redesign of the Address Book to use SQLite instead of MDB. See [https://bugzilla.mozilla.org/show_bug.cgi?id=11050 bug 11050] and [https://bugzilla.mo...) |
(Start adding some requirements) |
||
| Line 1: | Line 1: | ||
This page is meant for planning out a redesign of the Address Book to use SQLite instead of MDB. See [https://bugzilla.mozilla.org/show_bug.cgi?id=11050 bug 11050] and [https://bugzilla.mozilla.org/show_bug.cgi?id=382876 bug 382876] for other details. | This page is meant for planning out a redesign of the Address Book to use SQLite instead of MDB. See [https://bugzilla.mozilla.org/show_bug.cgi?id=11050 bug 11050] and [https://bugzilla.mozilla.org/show_bug.cgi?id=382876 bug 382876] for other details. | ||
Proposed schema | == Requirements == | ||
These requirements are intended to be an aid to forming the schema for the SQLite and the implementation of it. For initial implementations, not all of the requirements need to be satisfied, but for a complete switch-over to SQLite as the default book, then they should all be satisfied. | |||
Note, these are WIP and haven't been discussed at this time --[[User:Standard8|Standard8]] 01:41, 24 November 2007 (PST) | |||
# The new AB/format shall supports all current address book fields | |||
# It shall be capable of being extended to support extra fields | |||
#* If possible this will be in a backwards-compatible fashion | |||
# Mailing lists shall be supported | |||
# Nested lists shall be capable of being supported | |||
#* Preferably the implementation shall support nested lists, however it is not a requirement that this is fully implemented in the address book before switching over to SQLite as the default book. | |||
# All functions shall be able to be accessed via nsIAbDirectory, without reference to the back end directory or the specific nsIAb*Directory | |||
#* The only exception to this rule is for functions which really are address book specific, e.g. authDN in nsIAbLDAPDirectory. | |||
== Proposed schema == | |||
CREATE TABLE Cards ( | CREATE TABLE Cards ( | ||
CardKey INT NOT NULL PRIMARY KEY AUTOINCREMENT, | CardKey INT NOT NULL PRIMARY KEY AUTOINCREMENT, | ||