add spam flag to item table, DB version not incremented yet, give large sites a heads up to do it manually

1 files changed, 4 insertions, 0 deletions

diff --git a/update.php b/update.php
index e0591a3b3..d0fe1645b 100755
--- a/update.php
+++ b/update.php
@@ -1016,3 +1016,7 @@ function update_1118() {
 q("ALTER TABLE `contact` ADD `closeness` TINYINT( 2 ) NOT NULL DEFAULT '99' AFTER `reason` , ADD INDEX (`closensss`) ");
 q("update contact set closeness = 0 where self = 1");
 }
+
+function update_1119() {
+q("ALTER TABLE `item` ADD `spam` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `visible` , ADD INDEX (`spam`) ");
+}