Blueprint changed by Christopher Adams: Whiteboard changed: 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 + id app_id name group_permissions group_level + 1 0 System Administrators SystemGOD 1 + 2 0 Modules Administrators ModulesGOD 2 + 3 0 Guests ViewPublished 100 + 4 0 Banned users ViewPublished 101 + 5 0 Members member 5 + 6 0 Secretaries secretary 3 + 7 0 Librarians librarian 4 oflb_faces id font_id ttf eot woff svg oflb_families id contributor_id common_name git_repo oflb_fonts ... oflb_favorites id member_id - font_id - + font_id ============================== - ORIGINAL 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
-- 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 : aikiframework.admins@lists.launchpad.net Unsubscribe : https://launchpad.net/~aikiframework.admins More help : https://help.launchpad.net/ListHelp
