Update:Remora Schema

« Back to Remora Main

Schema

• Schema Diagram
• remora.sql
• Schema Birthing Photo
• linux8 PHPMyAdmin

Notes

Should the users table have a password field? Fligtar

Yes. That was an accidental omission. Morgamic

---

What about a table for canned review responses (if we still want them) and a table for auditing all developer/review/admin actions? Fligtar

---

• addons.approvalnotes -> versions.approvalnotes?
• versions.modifid -> versions.modified
• files.platform_id -> bug 279235 - if this bug is to be implemented, we need a files_platforms or versions_platforms table

Fligtar 18:43, 28 August 2006 (PDT)

---

I am hardcoding the addontype ids as follows. We can rename the actual types to whatever, but they have to stay with the associated id.

INSERT INTO `addontypes` (`id`, `name`, `created`, `modified`) VALUES (1, 'Extension', '2006-08-21 23:53:19', '2006-08-21 23:53:19'),
(2, 'Theme', '2006-08-21 23:53:24', '2006-08-21 23:53:24'),
(3, 'Dictionary', '2006-08-21 23:53:30', '2006-08-21 23:53:30'),
(4, 'Search Plugin', '2006-08-21 23:53:36', '2006-08-21 23:53:36'),
(5, 'Language Pack (Application)', '2006-08-21 23:53:58', '2006-08-21 23:53:58'),
(6, 'Language Pack (Add-on)', '2006-08-21 23:54:09', '2006-08-21 23:54:09');