From ce314be09d3f161ecce9c69d25c5e0b794bda869 Mon Sep 17 00:00:00 2001
From: kharwell <kharwell@lunkwill>
Date: Wed, 3 Feb 2016 17:04:59 -0500
Subject: [PATCH] realtime: Add database scripts for certified/13.1-cert3

---
 contrib/realtime/mssql/mssql_config.sql       | 30 ++++++++++++++++++-
 contrib/realtime/mysql/mysql_config.sql       | 26 ++++++++++++++++
 contrib/realtime/oracle/oracle_config.sql     | 30 ++++++++++++++++++-
 .../realtime/postgresql/postgresql_config.sql | 20 ++++++++++++-
 4 files changed, 103 insertions(+), 3 deletions(-)

diff --git a/contrib/realtime/mssql/mssql_config.sql b/contrib/realtime/mssql/mssql_config.sql
index 149e3247cd..d89ca2c2aa 100644
--- a/contrib/realtime/mssql/mssql_config.sql
+++ b/contrib/realtime/mssql/mssql_config.sql
@@ -998,7 +998,35 @@ ALTER TABLE ps_globals ADD endpoint_identifier_order VARCHAR(40) NULL;
 
 GO
 
-INSERT INTO alembic_version (version_num) VALUES ('45e3f47c6c44');
+-- Running upgrade 45e3f47c6c44 -> 498357a710ae
+
+ALTER TABLE ps_endpoints ADD rtp_keepalive INTEGER NULL;
+
+GO
+
+-- Running upgrade 498357a710ae -> 5a6ccc758633
+
+ALTER TABLE ps_endpoints ADD rtp_timeout INTEGER NULL;
+
+GO
+
+ALTER TABLE ps_endpoints ADD rtp_timeout_hold INTEGER NULL;
+
+GO
+
+-- Running upgrade 5a6ccc758633 -> 154177371065
+
+ALTER TABLE ps_globals ADD default_from_user VARCHAR(80) NULL;
+
+GO
+
+-- Running upgrade 154177371065 -> 28ce1e718f05
+
+ALTER TABLE ps_registrations ADD fatal_retry_interval INTEGER NULL;
+
+GO
+
+INSERT INTO alembic_version (version_num) VALUES ('28ce1e718f05');
 
 GO
 
diff --git a/contrib/realtime/mysql/mysql_config.sql b/contrib/realtime/mysql/mysql_config.sql
index f0471896ea..9e7c68f213 100644
--- a/contrib/realtime/mysql/mysql_config.sql
+++ b/contrib/realtime/mysql/mysql_config.sql
@@ -715,3 +715,29 @@ ALTER TABLE ps_globals ADD COLUMN endpoint_identifier_order VARCHAR(40);
 
 UPDATE alembic_version SET version_num='45e3f47c6c44';
 
+-- Running upgrade 45e3f47c6c44 -> 498357a710ae
+
+ALTER TABLE ps_endpoints ADD COLUMN rtp_keepalive INTEGER;
+
+UPDATE alembic_version SET version_num='498357a710ae';
+
+-- Running upgrade 498357a710ae -> 5a6ccc758633
+
+ALTER TABLE ps_endpoints ADD COLUMN rtp_timeout INTEGER;
+
+ALTER TABLE ps_endpoints ADD COLUMN rtp_timeout_hold INTEGER;
+
+UPDATE alembic_version SET version_num='5a6ccc758633';
+
+-- Running upgrade 5a6ccc758633 -> 154177371065
+
+ALTER TABLE ps_globals ADD COLUMN default_from_user VARCHAR(80);
+
+UPDATE alembic_version SET version_num='154177371065';
+
+-- Running upgrade 154177371065 -> 28ce1e718f05
+
+ALTER TABLE ps_registrations ADD COLUMN fatal_retry_interval INTEGER;
+
+UPDATE alembic_version SET version_num='28ce1e718f05';
+
diff --git a/contrib/realtime/oracle/oracle_config.sql b/contrib/realtime/oracle/oracle_config.sql
index eb8ab0ef99..b845717bfb 100644
--- a/contrib/realtime/oracle/oracle_config.sql
+++ b/contrib/realtime/oracle/oracle_config.sql
@@ -1000,7 +1000,35 @@ ALTER TABLE ps_globals ADD endpoint_identifier_order VARCHAR2(40 CHAR)
 
 /
 
-INSERT INTO alembic_version (version_num) VALUES ('45e3f47c6c44')
+-- Running upgrade 45e3f47c6c44 -> 498357a710ae
+
+ALTER TABLE ps_endpoints ADD rtp_keepalive INTEGER
+
+/
+
+-- Running upgrade 498357a710ae -> 5a6ccc758633
+
+ALTER TABLE ps_endpoints ADD rtp_timeout INTEGER
+
+/
+
+ALTER TABLE ps_endpoints ADD rtp_timeout_hold INTEGER
+
+/
+
+-- Running upgrade 5a6ccc758633 -> 154177371065
+
+ALTER TABLE ps_globals ADD default_from_user VARCHAR2(80 CHAR)
+
+/
+
+-- Running upgrade 154177371065 -> 28ce1e718f05
+
+ALTER TABLE ps_registrations ADD fatal_retry_interval INTEGER
+
+/
+
+INSERT INTO alembic_version (version_num) VALUES ('28ce1e718f05')
 
 /
 
diff --git a/contrib/realtime/postgresql/postgresql_config.sql b/contrib/realtime/postgresql/postgresql_config.sql
index 963ae58b67..63fac89840 100644
--- a/contrib/realtime/postgresql/postgresql_config.sql
+++ b/contrib/realtime/postgresql/postgresql_config.sql
@@ -741,7 +741,25 @@ ALTER TABLE ps_endpoints ADD COLUMN user_eq_phone yesno_values;
 
 ALTER TABLE ps_globals ADD COLUMN endpoint_identifier_order VARCHAR(40);
 
-INSERT INTO alembic_version (version_num) VALUES ('45e3f47c6c44');
+-- Running upgrade 45e3f47c6c44 -> 498357a710ae
+
+ALTER TABLE ps_endpoints ADD COLUMN rtp_keepalive INTEGER;
+
+-- Running upgrade 498357a710ae -> 5a6ccc758633
+
+ALTER TABLE ps_endpoints ADD COLUMN rtp_timeout INTEGER;
+
+ALTER TABLE ps_endpoints ADD COLUMN rtp_timeout_hold INTEGER;
+
+-- Running upgrade 5a6ccc758633 -> 154177371065
+
+ALTER TABLE ps_globals ADD COLUMN default_from_user VARCHAR(80);
+
+-- Running upgrade 154177371065 -> 28ce1e718f05
+
+ALTER TABLE ps_registrations ADD COLUMN fatal_retry_interval INTEGER;
+
+INSERT INTO alembic_version (version_num) VALUES ('28ce1e718f05');
 
 COMMIT;
 
-- 
2.47.2