A theoretical DB table layout for the system described in "umo ue.txt"

= categories
  - id                                                3
  - name                                              Downloading Files

= extensions/themes/etc
  - guid                                              {0db6a6ab-51aa-435d-9204-447f524ae780}
  - name                                              Magpie
  - creator                                           Ben Goodger
  - contributor (s)
  - description                                       A set of media collection tools.
  - homepageURL                                       http://www.bengoodger.com/software/tabloader/
  - type*                                             0x00

  = item categories
    - guid                                            {0db6a6ab-51aa-435d-9204-447f524ae780}
    - category                                        3

  = item data
    - guid                                            {0db6a6ab-51aa-435d-9204-447f524ae780}
    - version                                         3.1
    - xpiurl                                          http://ftp.mozilla.org/pub/mozilla.org/extensions/{0db6a6ab-51aa-435d-9204-447f524ae780}/3.1.xpi
    - state*                                          0x02
    - reviewed by                                     bengoodger

  = target app associations
    - extension/theme guid                              {0db6a6ab-51aa-435d-9204-447f524ae780}
    - guid                                              {8b7e5e27-1d59-4208-8224-f3e3e903ef90}
    - minversion                                        0.8
    - maxversion                                        1.0

= target apps
  - guid                                              {8b7e5e27-1d59-4208-8224-f3e3e903ef90}
  - name                                              Firefox

= users
  - username                                          bengoodger
  - encrypted password                                qIQqLZr77NbdA
  - real name                                         Ben Goodger
  - email address                                     test@test.com
  - account flags (bit field*)                        0x07

  = user extensions/themes
    - username                                        bengoodger
    - guid                                            {0db6a6ab-51aa-435d-9204-447f524ae780}

= pending extension
  - date approval requested                           05/22/2004 18:34
  - guid                                              {0db6a6ab-51aa-435d-9204-447f524ae780}

*type
0x00 = extension
0x01 = theme
...

*state
0x00 = normal, visible
0x01 = waiting for review
0x02 = rejected

*account flags:
0x00 = normal developer account
0x01 = trusted developer (doesn't require review for extensions)
0x02 = editor account
0x04 = administrator