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_faces
- id
- font_id
- ttf
- eot
- woff
- svg
-
oflb_families
id
contributor_id
common_name
git_repo
oflb_fonts
- ...
+ id
+ date
+ common_name
+ native_name
+ sub_family
+ style
+ weight
+ fixed_width
+ fixed_size
+ copyright
+ license
+ license_url
+ glyph_count
+ character_count
+ fontaine_report
oflb_glyph_coverage
- id
- font_id
- orthography_id
- support_level_id
- percent_coverage
- missing_values
+ id
+ font_id
+ orthography_id
+ support_level_id
+ percent_coverage
+ missing_values
oflb_orthographies
- id
- common_name
- native_name
+ id
+ common_name
+ native_name
oflb_support_levels
+ id
+ support_level
+ full
+ partial
+ fragmentary
+ none
+
+ oflb_files
+ id
+ font_id
+ format_id
+
+ oflb_formats
id
- support_level
- full
- partial
- fragmentary
- none
+ format
+ otf
+ ttf
+ eot
+ woff
+ svg
oflb_favorites
- id
- member_id
- font_id
+ id
+ member_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 : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
