Update:Remora Schema: Difference between revisions
Jump to navigation
Jump to search
(→Notes) |
(hardcoding addontypes) |
||
| Line 21: | Line 21: | ||
* files.platform_id -> [https://bugzilla.mozilla.org/show_bug.cgi?id=279235 bug 279235] - if this bug is to be implemented, we need a files_platforms or versions_platforms table | * files.platform_id -> [https://bugzilla.mozilla.org/show_bug.cgi?id=279235 bug 279235] - if this bug is to be implemented, we need a files_platforms or versions_platforms table | ||
[[User:Fligtar|Fligtar]] 18:43, 28 August 2006 (PDT) | [[User:Fligtar|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. | |||
<pre> | |||
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');</pre> | |||
Revision as of 02:20, 11 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');