View | Details | Raw Unified | Return to bug 8252 | Differences between
and this patch

Collapse All | Expand All

(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_article_galleys.xml (-2 / +9 lines)
 Lines 14-23    Link Here 
14
<data>
14
<data>
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
16
	<sql>
16
	<sql>
17
		<rename table="article_galleys" to="article_galleys_old" />
17
		<query driver="mysql">
18
18
			RENAME TABLE article_galleys TO article_galleys_old
19
		</query>
20
		<query driver="postgres7">
21
			SELECT * INTO article_galleys_old FROM article_galleys
22
		</query>
19
		<query driver="postgres7">
23
		<query driver="postgres7">
20
			DROP INDEX article_galleys_article_id
24
			DROP INDEX article_galleys_article_id
21
		</query>
25
		</query>
26
		<query driver="postgres7">
27
			DROP TABLE article_galleys
28
		</query>
22
	</sql>
29
	</sql>
23
</data>
30
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_articles.xml (-2 / +9 lines)
 Lines 14-21    Link Here 
14
<data>
14
<data>
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
16
	<sql>
16
	<sql>
17
		<rename table="articles" to="articles_old" />
17
		<query driver="mysql">
18
18
			RENAME TABLE articles TO articles_old
19
		</query>
20
		<query driver="postgres7">
21
			SELECT * INTO articles_old FROM articles
22
		</query>
19
		<query driver="postgres7">
23
		<query driver="postgres7">
20
			DROP INDEX articles_user_id
24
			DROP INDEX articles_user_id
21
		</query>
25
		</query>
 Lines 25-29    Link Here 
25
		<query driver="postgres7">
29
		<query driver="postgres7">
26
			DROP INDEX articles_section_id
30
			DROP INDEX articles_section_id
27
		</query>
31
		</query>
32
		<query driver="postgres7">
33
			DROP TABLE articles
34
		</query>
28
	</sql>
35
	</sql>
29
</data>
36
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_issues.xml (-2 / +9 lines)
 Lines 14-23    Link Here 
14
<data>
14
<data>
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
16
	<sql>
16
	<sql>
17
		<rename table="issues" to="issues_old" />
17
		<query driver="mysql">
18
	
18
			RENAME TABLE issues TO issues_old
19
		</query>
20
		<query driver="postgres7">
21
			SELECT * INTO issues_old FROM issues
22
		</query>
19
		<query driver="postgres7">
23
		<query driver="postgres7">
20
			DROP INDEX issues_journal_id
24
			DROP INDEX issues_journal_id
21
		</query>
25
		</query>
26
		<query driver="postgres7">
27
			DROP TABLE issues
28
		</query>
22
	</sql>	
29
	</sql>	
23
</data>
30
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles.xml (-2 / +9 lines)
 Lines 14-26    Link Here 
14
<data>
14
<data>
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
16
	<sql>
16
	<sql>
17
		<rename table="published_articles" to="published_articles_old" />
17
		<query driver="mysql">
18
18
			RENAME TABLE published_articles TO published_articles_old
19
		</query>
20
		<query driver="postgres7">
21
			SELECT * INTO published_articles_old FROM published_articles
22
		</query>
19
		<query driver="postgres7">
23
		<query driver="postgres7">
20
			DROP INDEX published_articles_article_id
24
			DROP INDEX published_articles_article_id
21
		</query>
25
		</query>
22
		<query driver="postgres7">
26
		<query driver="postgres7">
23
			DROP INDEX published_articles_issue_id
27
			DROP INDEX published_articles_issue_id
24
		</query>
28
		</query>
29
		<query driver="postgres7">
30
			DROP TABLE published_articles
31
		</query>
25
	</sql>
32
	</sql>
26
</data>
33
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files.xml (-2 / +9 lines)
 Lines 14-26    Link Here 
14
<data>
14
<data>
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
15
	<!-- Prepare migration of public ids and DOIs to settings tables -->
16
	<sql>
16
	<sql>
17
		<rename table="article_supplementary_files" to="article_supp_files_old" />
17
		<query driver="mysql">
18
18
			RENAME TABLE article_supplementary_files TO article_supp_files_old
19
		</query>
20
		<query driver="postgres7">
21
			SELECT * INTO article_supp_files_old FROM article_supplementary_files
22
		</query>
19
		<query driver="postgres7">
23
		<query driver="postgres7">
20
			DROP INDEX article_supplementary_files_file_id
24
			DROP INDEX article_supplementary_files_file_id
21
		</query>
25
		</query>
22
		<query driver="postgres7">
26
		<query driver="postgres7">
23
			DROP INDEX article_supplementary_files_article_id
27
			DROP INDEX article_supplementary_files_article_id
24
		</query>
28
		</query>
29
		<query>
30
			DROP TABLE article_supplementary_files
31
		</query>
25
	</sql>
32
	</sql>
26
</data>
33
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_notifications.xml (-3 / +10 lines)
 Lines 14-25    Link Here 
14
<data>
14
<data>
15
	<!-- Bug #6792: Notification overhaul -->
15
	<!-- Bug #6792: Notification overhaul -->
16
	<sql>
16
	<sql>
17
		<rename table="notifications" to="notifications_old" />
17
		<query driver="mysql">
18
			RENAME TABLE notifications TO notifications_old
19
		</query>
18
		<query driver="mysql">
20
		<query driver="mysql">
19
			RENAME TABLE notification_settings TO notification_settings_old
21
			RENAME TABLE notification_settings TO notification_settings_old
20
		</query>
22
		</query>
21
		<query driver="postgres7">
23
		<query driver="postgres7">
22
			SELECT setting_id, setting_name, setting_value, user_id, product, context INTO notification_settings_old FROM notification_settings
24
			SELECT * INTO notifications_old FROM notifications
25
		</query>
26
		<query driver="postgres7">
27
			SELECT * INTO notification_settings_old FROM notification_settings
28
		</query>
29
		<query driver="postgres7">
30
			DROP TABLE notifications
23
		</query>
31
		</query>
24
		<query driver="postgres7">
32
		<query driver="postgres7">
25
			DROP TABLE notification_settings
33
			DROP TABLE notification_settings
26
- 

Return to bug 8252