Blueprint changed by Christopher Adams:

Whiteboard changed:
  CURRENT
  
  oflb_uploads_files
  1     file_id
  2     file_upload
  3     file_name
  4     file_nicname
  5     filesize
  6     file_order
  
  oflb_uploads_zip
  1     upload_id
  2     upload_user
  3     upload_name
  4     upload_license
  5     systags
  6     relative_dir
  7     usertags
  8     upload_tags
  9     upload_date
  10    upload_description
  11    upload_published
  12    upload_num_remixes
  13    upload_num_sources
  
  describe cc_tbl_openids
  1     openid
  2     openid_user
  3     openid_show
  
  describe cc_tbl_tag_pair
  1     tag_pair
  2     tag_pair_tag
  3     tag_pair_count
  
  describe cc_tbl_tags
  1     tags_tag
  2     tags_count
  3     tags_type
  4     tags_category
  
  aiki_users_groups
  (row)  id     name                    group_permissions       group_level
  
  1     1       System Administrators   SystemGOD       1
  2     2       Modules Administrators  ModulesGOD      2
  3     3       Guests                  ViewPublished           100
  4     4       Banned users            ViewPublished           101
  5     5       Normal User             normal                  4
  6     6       employees               employees               3
  
  describe aiki_users
  1     userid
  2     username
  3     full_name
  4     country
  5     sex
  6     job
  7     password
  8     usergroup
  9     email
  10    avatar
  11    homepage
  12    first_ip
  13    first_login
  14    last_login
  15    last_ip
  16    user_permissions
  17    maillist
  18    logins_number
  19    randkey
  20    is_active
  21    description
  
  font_metadata
    id
    file_id
    file_name
    upload_user
    date
    common_name
    native_name
    sub_family
    style
    weight
    fixed_width
    fixed_size
    copyright
    license
    license_url
    glyph_count
    character_count
    fontaine_report
  
  orthographies
    id
    font_id
    common_name
    native_name
    support_level
    percent_coverage
    missing_values
  
  ==============================
  
  PROPOSED
  
  aiki_users_groups
  (row)  id     name                    group_permissions       group_level
  
  1     1       System Administrators   SystemGOD               1
  2     2       Modules Administrators  ModulesGOD              2
  3     3       Guests                  ViewPublished           100
  4     4       Banned users            ViewPublished           101
  5     5       Site Members            Members                 4
  6     6       Site Librarians         Librarians              3
+ 
+ font_metadata
+   ttf
+   eot
+   woff
+   svg

-- 
Database structure and migrations for the first release
https://blueprints.launchpad.net/openfontlibrary/+spec/database-structure

_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help   : https://help.launchpad.net/ListHelp

Reply via email to