lib/db/db.schema
author fabien@tzone.org
Wed, 31 Dec 2008 15:41:32 -0500
changeset 74 6784c4350b41
permissions -rw-r--r--
Cleanup of old code, fixes some errors with folders view and make it a standard action.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
74
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     1
users
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     2
 * id : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     3
 + name : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     4
 + full_name : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     5
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     6
preferences
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     7
 * userid : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     8
 + keywords_box : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
     9
 + keywords_sort : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    10
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    11
bookmarks
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    12
 * id : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    13
 * userid : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    14
 + url : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    15
 + name : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    16
 + ldesc : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    17
 + added : date
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    18
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    19
keywords
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    20
 * id: int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    21
 * userid : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    22
 + name : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    23
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    24
bookmarks_keywords
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    25
 * bookmark : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    26
 * keyword : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    27
 * userid : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    28
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    29
folders:
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    30
 * id : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    31
 * userid : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    32
 + keyword : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    33
 + parent : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    34
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    35
db_sequence:
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    36
 * seq_name : string
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    37
 * userid : int
6784c4350b41 Cleanup of old code, fixes some errors with folders view and make it a
fabien@tzone.org
parents:
diff changeset
    38
 + nextid : int