1. Database Schema

AGO3 DB SCHEMA

1.1. Artwork

• id
• user_id
• type_id
• category_id
• license_id
• version
• description
• date_added

nb: (thumbnail can be generated from user_id+artwork_id)

1.2. Downloads

• id
• artwork_id
• file
• download_count
• resolution_id -» in case of download being a background this field will have an value assigned

1.3. Resolutions

• id
• name -» name?
• size

1.4. Licences

• id
• name
• summary
• link

1.5. Types

• id
• name (= metacity,background,gtk2,icon,collection,screenshot,etc)
• description

1.6. Categories

• id
• name (= nature,abstract,gnome,etc)

1.7. Collection

• id
• description
• date
• user_id

1.8. Artwork_Collection

• artwork_id
• collection_id

1.9. Comments

• id
• artwork_id
• collection_id
• user_id
• body
• date
• (edit_date)
• status -» status ?

1.10. Votes

• artwork_id
• collection_id
• user_id
• rating

1.11. Users

• user_id
• username
• real_name
• password
• email
• homepage
• info (description)
• timezone
• location
• level (user, developer, moderator, admin)
• status (active, inactive, blocked, etc)

1.12. FAQ

• id
• type_id
• question
• answer

1.13. News

• id
• date
• title
• body
• user_id

1.14. Pages

• id
• date_edited
• body
• identifier