Places:BookmarksComments: Difference between revisions

Jump to navigation Jump to search
No edit summary
Line 111: Line 111:
= Tasks =
= Tasks =


* Update the db table initialization code to reflect the schema changes listed in the ERD section
* Places schema needs naming and consistency improvements
* Update all queries to reflect the schema changes
** Change file name to places.sqlite
* Update interfaces, implementors and callers affected by the schema changes
** Update the db table initialization code to reflect the schema changes listed in the ERD section
* Add the ability for bookmarks and separators to have Places URIs
** Update all queries to reflect the schema changes
* Change the place: URI generation code to use GUIDs
** Update interfaces, implementors and callers affected by the schema changes
* Add the revision management code to all insert/update operations on bookmarks, folders and separators.
 
* Bookmarks must be internally uniquely identifiable
** add auto-incrementing ID col to moz_bookmarks
** make interface changes to support bookmark IDs instead of place IDs
** update component and caller code to use bookmark IDs instead of place IDs
 
* Bookmarks must be externally uniquely identifiable
** Add GUID column to moz_bookmarks, moz_bookmarks_folders
** Add the ability for bookmarks and separators to have Places URIs
** Change the place: URI generation code to use GUIDs for non-dynamic objects
 
* Bookmarks, Folders and Separators should have simple versioning scheme
** Add revision column to moz_bookmarks, moz_bookmark_folders
** Add the revision management code to all insert/update operations on bookmarks, folders and separators.


= Open Questions =
= Open Questions =
Confirmed users, Bureaucrats and Sysops emeriti
2,088

edits

Navigation menu