Update:Remora Database Migration: Difference between revisions

Line 328: Line 328:
==add-on specific information (per addon ID)==
==add-on specific information (per addon ID)==


===main to addons===
===main to addons, translations===
{| border="1"
{| border="1"
!Old Database!!New Database
!Old Database!!New Database
Line 336: Line 336:
|GUID||guid
|GUID||guid
|-
|-
|Name||name
|Name||translations.localized_string<br/>''insert into translations, then fetch id<br/>name
|-
|-
|Type||addontype_id<br/>''will have to find type in type table''
|Type||addontype_id<br/>''will have to find type in type table''
Line 346: Line 346:
|Homepage||homepage
|Homepage||homepage
|-
|-
|Description||description
|Description||translations.localized_string<br/>''insert into translations, then fetch id<br/>description
|-
|-
|Rating||averagerating
|Rating||averagerating
Line 358: Line 358:
| ||icon<br/>''use default value''
| ||icon<br/>''use default value''
|-
|-
|Description||summary<br/>''take up to 250 characters, do not break inside a word, add ellipsis if break is not at the end of sentence''
|Description||translations.localized_string<br/>''insert into translations, then fetch id<br/>summary<br/>''take up to 250 characters, do not break inside a word, add ellipsis if break is not at the end of sentence''
|-
|-
| ||inactive<br/>''use default value''
| ||inactive<br/>''use default value''
Confirmed users
675

edits