From 71ef8e810de57703185bf4d6ebf9d0d2a69a1a91 Mon Sep 17 00:00:00 2001 From: Stephen Soltesz Date: Tue, 15 Sep 2009 00:48:35 +0000 Subject: [PATCH] changes to the db for the previous patch. --- upgrade/monitor-server-3.0-21.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 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 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; -- 2.43.0