Update:Remora Schema/Notes

Diagram

Schema Diagram

Schema Notes

• localization of user-facing strings
• extension flags
  • inactive
  • pre-release
  • admin review
  • site-specific
  • requires external software / account
  • has a privacy policy

• extension data additions
  • eula
  • privacy policy
  • notes for reviewers
  • tagline == summary
• generate simple pathnames for images/icons
  • extension icon, preview image, screenshots
• addons.description -> versions.description
• rename "versions" to "addon_versions"? nah...
• make addontype_id table instead of enum
  • plugin/search-engine become their own type
• collapse comments into reviews
  • "editors pick" as flag on addons
  • "editor review" to reviews

Meeting Notes

• regenerate install.rdf with metadata change
• XPIs containing XPIs (low-priority, just don't barf on it)
• user-has-extensions-installed (low priority)
• generate simple pathnames for images/icons
  • extension icon, preview image, screenshots
• reviews and ratings (need a review to add a rating)
• user flags
  • user permissions (externally; cake's ACL stuff)

Tier 1 and Tier 2 Locales

• en-US
• en-GB
• fr
• de
• ja
• pl
• es-ES
• zh-CN
• zh-TW
• cs
• da
• nl
• fi
• hu
• it
• ko
• pt-BR
• ru
• es-AR
• sv-SE
• tr