Blueprint changed by Christopher Adams: Whiteboard changed: PROPOSED 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_families id contributor_id - common_name + family_name created_at repository - designer - foundry - homepage* - project_url* - + oflb_fonts id family_id date common_name native_name sub_family style weight fixed_width fixed_size copyright license license_url glyph_count character_count fontaine_report + unique_id* + version* + foundry* + designer* + vendor_url* + designer_url* + oflb_glyphs id font_id orthography_id support_level_id percent_coverage missing_values oflb_orthographies id common_name native_name oflb_levels id support_level full partial fragmentary none oflb_files id font_id file_name format_id oflb_formats id format 1 otf 2 ttf 3 eot 4 woff 5 svg oflb_favorites id member_id font_id + + ============================== + + Font Metadata + + Names + Fontname + Family Name + Name for Humans + Weight + Version + Base Filename + Copyright + + TTF Names + Copyright + Family + Styles (SubFamily) + UniqueID + Fullname + Version + Manufacturer + Designer + Vendor URL + Designer URL + License + License URL + + Dates ============================== 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
