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 (-1 / +6 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>
18
		    CREATE TABLE article_galleys_old AS SELECT * FROM article_galleys
19
		</query>
18
20
19
		<query driver="postgres7">
21
		<query driver="postgres7">
20
			DROP INDEX article_galleys_article_id
22
			DROP INDEX article_galleys_article_id
21
		</query>
23
		</query>
24
		<query>
25
			DROP TABLE article_galleys
26
		</query>
22
	</sql>
27
	</sql>
23
</data>
28
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_articles.xml (-1 / +6 lines)
 Lines 14-20    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>
18
		    CREATE TABLE articles_old AS SELECT * FROM articles
19
		</query>
18
20
19
		<query driver="postgres7">
21
		<query driver="postgres7">
20
			DROP INDEX articles_user_id
22
			DROP INDEX articles_user_id
 Lines 25-29    Link Here 
25
		<query driver="postgres7">
27
		<query driver="postgres7">
26
			DROP INDEX articles_section_id
28
			DROP INDEX articles_section_id
27
		</query>
29
		</query>
30
		<query>
31
			DROP TABLE articles
32
		</query>
28
	</sql>
33
	</sql>
29
</data>
34
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_issues.xml (-1 / +6 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>
18
		    CREATE TABLE issues_old AS SELECT * FROM issues
19
		</query>
18
	
20
	
19
		<query driver="postgres7">
21
		<query driver="postgres7">
20
			DROP INDEX issues_journal_id
22
			DROP INDEX issues_journal_id
21
		</query>
23
		</query>
24
		<query>
25
			DROP TABLE issues;
26
		</query>
22
	</sql>	
27
	</sql>	
23
</data>
28
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_published_articles.xml (-1 / +6 lines)
 Lines 14-20    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>
18
		    CREATE TABLE published_articles_old AS SELECT * FROM published_articles
19
		</query>
18
20
19
		<query driver="postgres7">
21
		<query driver="postgres7">
20
			DROP INDEX published_articles_article_id
22
			DROP INDEX published_articles_article_id
 Lines 22-26    Link Here 
22
		<query driver="postgres7">
24
		<query driver="postgres7">
23
			DROP INDEX published_articles_issue_id
25
			DROP INDEX published_articles_issue_id
24
		</query>
26
		</query>
27
		<query>
28
			DROP TABLE published_articles
29
		</query>
25
	</sql>
30
	</sql>
26
</data>
31
</data>
(-)a/dbscripts/xml/upgrade/2.4.0_idupgrade_supp_files.xml (-2 / +6 lines)
 Lines 14-20    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>
18
		    CREATE TABLE article_supp_files_old AS SELECT * FROM article_supplementary_files
19
		</query>
18
20
19
		<query driver="postgres7">
21
		<query driver="postgres7">
20
			DROP INDEX article_supplementary_files_file_id
22
			DROP INDEX article_supplementary_files_file_id
 Lines 22-26    Link Here 
22
		<query driver="postgres7">
24
		<query driver="postgres7">
23
			DROP INDEX article_supplementary_files_article_id
25
			DROP INDEX article_supplementary_files_article_id
24
		</query>
26
		</query>
27
		<query>
28
			DROP TABLE article_supplementary_files
29
		</query>
25
	</sql>
30
	</sql>
26
</data>
31
</data>
27
- 

Return to bug 8252