lib/db/db.schema
author fabien@tzone.org
Wed, 31 Dec 2008 16:26:22 -0500
changeset 75 4f6b7b48322f
parent 74 6784c4350b41
permissions -rw-r--r--
A lot of fix again, for folder view, bookmark editing and removal and some error handling.

users
 * id : int
 + name : string
 + full_name : string

preferences
 * userid : int
 + keywords_box : int
 + keywords_sort : string

bookmarks
 * id : int
 * userid : int
 + url : string
 + name : string
 + ldesc : string
 + added : date

keywords
 * id: int
 * userid : int
 + name : string

bookmarks_keywords
 * bookmark : int
 * keyword : int
 * userid : int

folders:
 * id : int
 * userid : int
 + keyword : int
 + parent : int

db_sequence:
 * seq_name : string
 * userid : int
 + nextid : int