jenkins-bot has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/378974 )
Change subject: Add SQL table for `statistics` ...................................................................... Add SQL table for `statistics` This adds a `statistics` and `statisticsct` table based on `maintenance/INSTALL` and `api/includes/StatsBuilder`. This is necessary to develop locally on the Statistics module. Change-Id: Iaa81caab01a236e67fe9fe5ec8587e3a1efa6041 --- A erfgoedbot/sql/create_table_statistics.sql 1 file changed, 22 insertions(+), 0 deletions(-) Approvals: Lokal Profil: Looks good to me, approved jenkins-bot: Verified diff --git a/erfgoedbot/sql/create_table_statistics.sql b/erfgoedbot/sql/create_table_statistics.sql new file mode 100644 index 0000000..a409330 --- /dev/null +++ b/erfgoedbot/sql/create_table_statistics.sql @@ -0,0 +1,22 @@ +CREATE TABLE IF NOT EXISTS `statistics` ( + `day` date NOT NULL, + `item` varchar(50) NOT NULL, + `idx` varchar(100) NOT NULL, + `value` varchar(16) NOT NULL DEFAULT '0', + PRIMARY KEY (`day`,`item`,`idx`), + KEY `idx_day_idx` (`day`,`idx`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `statisticsct` ( + `img_name` varbinary(255) NOT NULL, + `img_user_id` int(5) NOT NULL, + `img_user_name` varchar(255) NOT NULL, + `img_page_id` int(8) NOT NULL, + `img_wlm_country` varchar(20) NOT NULL DEFAULT '', + `img_wlm_id` varchar(25) NOT NULL DEFAULT '', + `img_timestamp` varchar(14) NOT NULL, + `img_has_changed` tinyint(1) NOT NULL, + PRIMARY KEY (`img_name`), + KEY `idx_wlm_id` (`img_wlm_id`), + KEY `idx_ts` (`img_timestamp`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- To view, visit https://gerrit.wikimedia.org/r/378974 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: Iaa81caab01a236e67fe9fe5ec8587e3a1efa6041 Gerrit-PatchSet: 2 Gerrit-Project: labs/tools/heritage Gerrit-Branch: master Gerrit-Owner: Jean-Frédéric <jeanfrederic.w...@gmail.com> Gerrit-Reviewer: Jean-Frédéric <jeanfrederic.w...@gmail.com> Gerrit-Reviewer: Lokal Profil <lokal.pro...@gmail.com> Gerrit-Reviewer: Multichill <maar...@mdammers.nl> Gerrit-Reviewer: jenkins-bot <> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
