changes to the db for the previous patch.

[monitor.git] / upgrade / monitor-server-3.0-21.sql

diff --git a/upgrade/monitor-server-3.0-21.sql b/upgrade/monitor-server-3.0-21.sql
new file mode 100644 (file)
index 0000000..feb3b2c
--- /dev/null
+++ b/upgrade/monitor-server-3.0-21.sql
@@ -0,0 +1,11 @@
+-- If there's an existing database, these commands will upgrade it to the
+-- current version
+
+-- ALTER TABLE historysiterecord ADD COLUMN message_last_reply timestamp without time zone DEFAULT NULL;
+-- ALTER TABLE historysiterecord_history ADD COLUMN message_last_reply timestamp without time zone DEFAULT NULL;
+
+ALTER TABLE historysiterecord ADD COLUMN penalty_pause boolean DEFAULT False;
+ALTER TABLE historysiterecord_history ADD COLUMN penalty_pause boolean DEFAULT False;
+
+ALTER TABLE historysiterecord ADD COLUMN penalty_pause_time timestamp without time zone DEFAULT NULL;
+ALTER TABLE historysiterecord_history ADD COLUMN penalty_pause_time timestamp without time zone DEFAULT NULL;