From c2f83639d49c4ff49acdaa5c6f3dd0a3c1edbdf9 Mon Sep 17 00:00:00 2001
From: redmatrix <mike@macgirvin.com>
Date: Wed, 7 Sep 2016 17:36:45 -0700
Subject: provide version info in /pubsites

---
 install/schema_mysql.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index 5e5b9d5be..9a4f58880 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1151,6 +1151,7 @@ CREATE TABLE IF NOT EXISTS `site` (
   `site_dead` smallint NOT NULL DEFAULT '0',
   `site_type` smallint NOT NULL DEFAULT '0',
   `site_project` char(255) NOT NULL DEFAULT '',
+  `site_version` varchar(32) NOT NULL DEFAULT '',
   PRIMARY KEY (`site_url`),
   KEY `site_flags` (`site_flags`),
   KEY `site_update` (`site_update`),
-- 
cgit v1.2.3

