Update:Remora Schema: Difference between revisions
(→Schema) |
(→Schema) |
||
| Line 3: | Line 3: | ||
==Schema== | ==Schema== | ||
* [http://people.mozilla.org/~morgamic/remora.jpg Schema Diagram] | * [http://people.mozilla.org/~morgamic/remora.jpg Schema Diagram] | ||
* [http://svn.mozilla.org/addons/trunk/site/app/config/sql/remora.sql] | * [http://svn.mozilla.org/addons/trunk/site/app/config/sql/remora.sql remora.sql] | ||
* [http://www.flickr.com/photo_zoom.gne?id=205515439&size=l Schema Birthing Photo] | * [http://www.flickr.com/photo_zoom.gne?id=205515439&size=l Schema Birthing Photo] | ||
* [http://142.204.140.147:8080/db/ linux8 PHPMyAdmin] | * [http://142.204.140.147:8080/db/ linux8 PHPMyAdmin] | ||
Revision as of 07:34, 28 September 2006
Schema
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');
versions.dateadded and versions.dateupdated can be removed, as created and modified serve that purpose
applications_versions.created and modified can be removed, as cake does not take into account any additional fields in HABTM tables (including created and modified). I haven't looked at the other lookup tables, but additional fields can be removed there as well. Fligtar 11:56, 27 September 2006 (PDT)