3,035
edits
Update:Remora Database Migration: Difference between revisions
Jump to navigation
Jump to search
Update:Remora Database Migration (view source)
Revision as of 20:02, 26 December 2006
, 26 December 2006→Previews
| Line 499: | Line 499: | ||
* No previews were migrated -- but we need to solve this issue to help get images over. | * No previews were migrated -- but we need to solve this issue to help get images over. | ||
* In order to pull them we'd need to generate the URI and grab them so we can insert them into the proper blob in the previews table | * In order to pull them we'd need to generate the URI and grab them so we can insert them into the proper blob in the previews table | ||
Old db: | |||
mysql> describe previews; | |||
+------------+------------------+------+-----+---------+----------------+ | |||
| Field | Type | Null | Key | Default | Extra | | |||
+------------+------------------+------+-----+---------+----------------+ | |||
| PreviewID | int(11) | | PRI | NULL | auto_increment | | |||
| PreviewURI | varchar(200) | | | | | | |||
| ID | int(5) | | MUL | 0 | | | |||
| caption | varchar(255) | | | | | | |||
| preview | enum('YES','NO') | | | NO | | | |||
+------------+------------------+------+-----+---------+----------------+ | |||
5 rows in set (0.00 sec) | |||
* "PreviewURI" column points to the relative path of the preview. | |||
* "ID" is the FK to main.ID | |||
* "caption" would get ported to dynamic l10n | |||
* "preview" would be "highlight" in the new previews table | |||
Moving to new db: | |||
* Use "https://addons.mozilla.org".$PreviewURI to grab the image and insert it into the filedata blog in the new db. | |||
* Filetype should be preserved as well so it can display properly in the images controller. | |||
=== Duplicate Files === | === Duplicate Files === | ||