Timeline Express Pro Modifications: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 30: | Line 30: | ||
***Create an Index on Column 1: Go, Index Choice: PRIMARY | ***Create an Index on Column 1: Go, Index Choice: PRIMARY | ||
*Use a SQL statement to copy the data from the postmeta Table to TT1 Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | *Use a SQL statement to copy the data from the postmeta Table to TT1 Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | ||
<syntaxhighlight lang="text"> | |||
INSERT INTO TT1 (post_id, meta_key, meta_value) | INSERT INTO TT1 (post_id, meta_key, meta_value) | ||
SELECT post_id, meta_key, meta_value | SELECT post_id, meta_key, meta_value | ||
| Line 36: | Line 36: | ||
WHERE meta_key = 'announcement_custom_excerpt'; | WHERE meta_key = 'announcement_custom_excerpt'; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
* Use a SQL statement to copy the data from the posts Table to TT2 Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | * Use a SQL statement to copy the data from the posts Table to TT2 Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | ||
<syntaxhighlight lang="text"> | |||
INSERT INTO TT2(ID, post_content, post_type) | INSERT INTO TT2(ID, post_content, post_type) | ||
SELECT ID, post_content, post_type | SELECT ID, post_content, post_type | ||
| Line 45: | Line 44: | ||
</syntaxhighlight>The number of rows copied into TT1 and TT2 should be the same | </syntaxhighlight>The number of rows copied into TT1 and TT2 should be the same | ||
* Use a SQL statement to copy the data from the TT1 Table to the posts Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | * Use a SQL statement to copy the data from the TT1 Table to the posts Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | ||
<syntaxhighlight lang="text"> | |||
UPDATE wp_posts INNER JOIN TT1 | UPDATE wp_posts INNER JOIN TT1 | ||
SET wp_posts.post_content = TT1.meta_value | SET wp_posts.post_content = TT1.meta_value | ||
| Line 51: | Line 50: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
* Use a SQL statement to copy the data from the TT2 Table to the postmeta Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | * Use a SQL statement to copy the data from the TT2 Table to the postmeta Table: Select Database in phpMyAdmin, SQL Tab, Go, with the following SQL statement; | ||
<syntaxhighlight lang="text"> | |||
UPDATE wp_postmeta INNER JOIN TT2 | UPDATE wp_postmeta INNER JOIN TT2 | ||
SET wp_postmeta.meta_value = TT2.post_content | SET wp_postmeta.meta_value = TT2.post_content | ||