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 family_name created_at repository description oflb_commits id family_id hash commit_date oflb_fonts id commit_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* + unique_id version foundry designer vendor_url designer_url base_filename file_type_id font_face_family_name 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 + 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 Copyright notice, Font Family name, Font Subfamily name, Unique font identifier, Full font name, Version string, Postscript name, Trademark, Manufacturer Name, Designer, Description, URL Vendor, URL Designer, License Description, License Info URL, Reserved, Preferred Family, Preferred Subfamily, Compatible Full, Sample text, PostScript CID findfont name Dates Cf. http://www.microsoft.com/typography/otspec/name.htm ============================== 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 : [email protected] Unsubscribe : https://launchpad.net/~aikiframework.admins More help : https://help.launchpad.net/ListHelp
