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
+   idint
+   font_id
+   common_name
+   native_name
+   support_levelchar
+   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 Curators           Curators                3
+ 6     6       Site Librarians         Librarians              3

-- 
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