jenkins-bot has submitted this change and it was merged. Change subject: Add sqlite support ......................................................................
Add sqlite support * This supports sqlite. Change-Id: I0835c47fb162510af8221b626c3a6ac069012187 --- R README.md M drop_field.sql M hit_counter_extension.sql M initial_count.sql M page_counter.sql M rename_table.sql 6 files changed, 11 insertions(+), 15 deletions(-) Approvals: Aaron Schulz: Looks good to me, approved jenkins-bot: Verified diff --git a/README.mediawiki b/README.md similarity index 100% rename from README.mediawiki rename to README.md diff --git a/drop_field.sql b/drop_field.sql index 0def052..d4159e3 100644 --- a/drop_field.sql +++ b/drop_field.sql @@ -1,3 +1,2 @@ -INSERT INTO /*$wgDBprefix*/hit_counter (page_id, page_counter) - SELECT /*$wgDBprefix*/page.page_id, /*$wgDBprefix*/page.page_counter FROM /*$wgDBprefix*/page; -ALTER TABLE /*$wgDBprefix*/page DROP page_counter; +INSERT INTO /*_*/hit_counter (page_id, page_counter) SELECT /*_*/page.page_id, /*_*/page.page_counter FROM /*_*/page; +ALTER TABLE /*_*/page DROP page_counter; diff --git a/hit_counter_extension.sql b/hit_counter_extension.sql index af7fae2..58813ed 100644 --- a/hit_counter_extension.sql +++ b/hit_counter_extension.sql @@ -1,3 +1,3 @@ -CREATE TABLE /*$wgDBprefix*/hit_counter_extension ( +CREATE TABLE /*_*/hit_counter_extension ( `hc_id` int(10) unsigned NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=utf8 MAX_ROWS=25000; diff --git a/initial_count.sql b/initial_count.sql index 1424148..003e0a1 100644 --- a/initial_count.sql +++ b/initial_count.sql @@ -1,3 +1 @@ - -INSERT INTO /*$wgDBprefix*/hit_counter (page_id, page_counter) - SELECT /*$wgDBprefix*/page.page_id, /*$wgDBprefix*/page.page_counter FROM /*$wgDBprefix*/page; +INSERT INTO /*_*/hit_counter (page_id, page_counter) SELECT /*_*/page.page_id, /*_*/page.page_counter FROM /*_*/page; diff --git a/page_counter.sql b/page_counter.sql index e15d98a..420e59e 100644 --- a/page_counter.sql +++ b/page_counter.sql @@ -1,6 +1,6 @@ -CREATE TABLE /*$wgDBprefix*/hit_counter ( - page_id INT(8) UNSIGNED NOT NULL, - page_counter BIGINT(20) UNSIGNED NOT NULL DEFAULT '0', - PRIMARY KEY (page_id), - INDEX (page_counter) -); +CREATE TABLE /*_*/hit_counter ( + page_id INT(8) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, + page_counter BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' +) /*$wgDBTableOptions*/; + +CREATE INDEX /*i*/page_counter ON /*_*/hit_counter (page_counter); \ No newline at end of file diff --git a/rename_table.sql b/rename_table.sql index f827974..56d8e42 100644 --- a/rename_table.sql +++ b/rename_table.sql @@ -1,2 +1 @@ -RENAME TABLE /*$wgDBprefix*/hitcounter TO /*$wgDBprefix*/hit_counter_extension; - +RENAME TABLE /*_*/hitcounter TO /*_*/hit_counter_extension; -- To view, visit https://gerrit.wikimedia.org/r/219235 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I0835c47fb162510af8221b626c3a6ac069012187 Gerrit-PatchSet: 5 Gerrit-Project: mediawiki/extensions/HitCounters Gerrit-Branch: master Gerrit-Owner: Paladox <thomasmulhall...@yahoo.com> Gerrit-Reviewer: Aaron Schulz <asch...@wikimedia.org> Gerrit-Reviewer: Legoktm <legoktm.wikipe...@gmail.com> Gerrit-Reviewer: MarkAHershberger <m...@nichework.com> Gerrit-Reviewer: Paladox <thomasmulhall...@yahoo.com> Gerrit-Reviewer: Siebrand <siebr...@kitano.nl> Gerrit-Reviewer: Springle <sprin...@wikimedia.org> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
