summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-ss_active_users.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/ibm_db2/patch-ss_active_users.sql')
-rw-r--r--maintenance/ibm_db2/patch-ss_active_users.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/maintenance/ibm_db2/patch-ss_active_users.sql b/maintenance/ibm_db2/patch-ss_active_users.sql
new file mode 100644
index 00000000..f0e6d145
--- /dev/null
+++ b/maintenance/ibm_db2/patch-ss_active_users.sql
@@ -0,0 +1,11 @@
+CREATE TABLE site_stats (
+ ss_row_id BIGINT NOT NULL UNIQUE,
+ ss_total_views BIGINT DEFAULT 0,
+ ss_total_edits BIGINT DEFAULT 0,
+ ss_good_articles BIGINT DEFAULT 0,
+ ss_total_pages INTEGER DEFAULT -1,
+ ss_users INTEGER DEFAULT -1,
+ ss_active_users INTEGER DEFAULT -1,
+ ss_admins INTEGER DEFAULT -1,
+ ss_images INTEGER DEFAULT 0
+);