Freakolowsky has uploaded a new change for review.
https://gerrit.wikimedia.org/r/111735
Change subject: Fix Oracle 1.23 missing patches
......................................................................
Fix Oracle 1.23 missing patches
Change-Id: Ia91ed19bd4e3380f396ef895745dbd2014e1eb8b
---
M includes/installer/OracleUpdater.php
A maintenance/oracle/archives/patch-page_links_updated.sql
A maintenance/oracle/archives/patch-rc_source.sql
M maintenance/oracle/tables.sql
4 files changed, 13 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core
refs/changes/35/111735/1
diff --git a/includes/installer/OracleUpdater.php
b/includes/installer/OracleUpdater.php
index 88e5fbd..c7f1a4f 100644
--- a/includes/installer/OracleUpdater.php
+++ b/includes/installer/OracleUpdater.php
@@ -96,6 +96,8 @@
//1.23
array( 'addIndex', 'logging', 'i06',
'patch-logging_user_text_type_time_index.sql' ),
array( 'addIndex', 'logging', 'i07',
'patch-logging_user_text_time_index.sql' ),
+ array( 'addField', 'page', 'page_links_updated',
'patch-page_links_updated.sql' ),
+ array( 'addField', 'recentchanges', 'rc_source',
'patch-rc_source.sql' ),
// KEEP THIS AT THE BOTTOM!!
array( 'doRebuildDuplicateFunction' ),
diff --git a/maintenance/oracle/archives/patch-page_links_updated.sql
b/maintenance/oracle/archives/patch-page_links_updated.sql
new file mode 100644
index 0000000..5360329
--- /dev/null
+++ b/maintenance/oracle/archives/patch-page_links_updated.sql
@@ -0,0 +1,4 @@
+define mw_prefix='{$wgDBprefix}';
+
+ALTER TABLE &mw_prefix.page ADD page_links_updated TIMESTAMP(6) WITH TIME ZONE;
+
diff --git a/maintenance/oracle/archives/patch-rc_source.sql
b/maintenance/oracle/archives/patch-rc_source.sql
new file mode 100644
index 0000000..0c80afa
--- /dev/null
+++ b/maintenance/oracle/archives/patch-rc_source.sql
@@ -0,0 +1,3 @@
+define mw_prefix='{$wgDBprefix}';
+
+ALTER TABLE &mw_prefix.recentchanges ADD rc_source VARCHAR2(16);
diff --git a/maintenance/oracle/tables.sql b/maintenance/oracle/tables.sql
index a6b5350..f97bdc1 100644
--- a/maintenance/oracle/tables.sql
+++ b/maintenance/oracle/tables.sql
@@ -72,6 +72,7 @@
page_is_new CHAR(1) DEFAULT '0' NOT NULL,
page_random NUMBER(15,14) NOT NULL,
page_touched TIMESTAMP(6) WITH TIME ZONE,
+ page_links_updated TIMESTAMP(6) WITH TIME ZONE,
page_latest NUMBER DEFAULT 0 NOT NULL, -- FK?
page_len NUMBER DEFAULT 0 NOT NULL,
page_content_model VARCHAR2(32)
@@ -84,7 +85,7 @@
-- Create a dummy page to satisfy fk contraints especially with revisions
INSERT INTO &mw_prefix.page
- VALUES (0, 0, ' ', NULL, 0, 0, 0, 0, current_timestamp, 0, 0, NULL);
+ VALUES (0, 0, ' ', NULL, 0, 0, 0, 0, current_timestamp, NULL, 0, 0, NULL);
/*$mw$*/
CREATE TRIGGER &mw_prefix.page_set_random BEFORE INSERT ON &mw_prefix.page
@@ -402,7 +403,7 @@
CREATE TABLE &mw_prefix.recentchanges (
rc_id NUMBER NOT NULL,
rc_timestamp TIMESTAMP(6) WITH TIME ZONE NOT NULL,
- rc_cur_time TIMESTAMP(6) WITH TIME ZONE NOT NULL,
+ rc_cur_time TIMESTAMP(6) WITH TIME ZONE,
rc_user NUMBER DEFAULT 0 NOT NULL,
rc_user_text VARCHAR2(255) NOT NULL,
rc_namespace NUMBER DEFAULT 0 NOT NULL,
@@ -415,6 +416,7 @@
rc_this_oldid NUMBER DEFAULT 0 NOT NULL,
rc_last_oldid NUMBER DEFAULT 0 NOT NULL,
rc_type CHAR(1) DEFAULT '0' NOT NULL,
+ rc_source VARCHAR2(16),
rc_patrolled CHAR(1) DEFAULT '0' NOT NULL,
rc_ip VARCHAR2(15),
rc_old_len NUMBER,
--
To view, visit https://gerrit.wikimedia.org/r/111735
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ia91ed19bd4e3380f396ef895745dbd2014e1eb8b
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/core
Gerrit-Branch: master
Gerrit-Owner: Freakolowsky <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
