[sr-dev] git:master: db scheme: move usrloc and alias expire time 10 years to the future, to 2030
Henning Westerholt
hw at kamailio.org
Fri Sep 7 13:52:52 CEST 2012
Module: sip-router
Branch: master
Commit: 97173572a81b67dd5165de2948562d5db91168d5
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=97173572a81b67dd5165de2948562d5db91168d5
Author: Henning Westerholt <hw at kamailio.org>
Committer: Henning Westerholt <hw at kamailio.org>
Date: Fri Sep 7 12:57:30 2012 +0200
db scheme: move usrloc and alias expire time 10 years to the future, to 2030
---
lib/srdb1/schema/entities.xml | 4 ++--
utils/kamctl/db_berkeley/kamailio/aliases | 2 +-
utils/kamctl/db_berkeley/kamailio/location | 2 +-
utils/kamctl/db_sqlite/registrar-create.sql | 2 +-
utils/kamctl/db_sqlite/usrloc-create.sql | 2 +-
utils/kamctl/kamctlrc | 2 +-
utils/kamctl/kamdbctl.base | 2 +-
utils/kamctl/mysql/registrar-create.sql | 2 +-
utils/kamctl/mysql/usrloc-create.sql | 2 +-
utils/kamctl/oracle/registrar-create.sql | 2 +-
utils/kamctl/oracle/usrloc-create.sql | 2 +-
utils/kamctl/postgres/registrar-create.sql | 2 +-
utils/kamctl/postgres/usrloc-create.sql | 2 +-
13 files changed, 14 insertions(+), 14 deletions(-)
diff --git a/lib/srdb1/schema/entities.xml b/lib/srdb1/schema/entities.xml
index 8ff237d..2825157 100644
--- a/lib/srdb1/schema/entities.xml
+++ b/lib/srdb1/schema/entities.xml
@@ -21,8 +21,8 @@
<!ENTITY description_len "255">
<!ENTITY MYSQL_TABLE_TYPE "MyISAM">
<!ENTITY USERCOL "username">
-<!ENTITY DEFAULT_ALIASES_EXPIRES "2020-05-28 21:32:15">
-<!ENTITY DEFAULT_LOCATION_EXPIRES "2020-05-28 21:32:15">
+<!ENTITY DEFAULT_ALIASES_EXPIRES "2030-05-28 21:32:15">
+<!ENTITY DEFAULT_LOCATION_EXPIRES "2030-05-28 21:32:15">
<!ENTITY DEFAULT_Q "1.0">
<!ENTITY DEFAULT_CALLID "Default-Call-ID">
<!ENTITY DEFAULT_CSEQ "1">
diff --git a/utils/kamctl/db_berkeley/kamailio/aliases b/utils/kamctl/db_berkeley/kamailio/aliases
index edc1177..54a12f6 100644
--- a/utils/kamctl/db_berkeley/kamailio/aliases
+++ b/utils/kamctl/db_berkeley/kamailio/aliases
@@ -7,4 +7,4 @@ METADATA_READONLY
METADATA_LOGFLAGS
0
METADATA_DEFAULTS
-NIL|''|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL|0
+NIL|''|''|NULL|''|NULL|NULL|'2030-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL|0
diff --git a/utils/kamctl/db_berkeley/kamailio/location b/utils/kamctl/db_berkeley/kamailio/location
index edc1177..54a12f6 100644
--- a/utils/kamctl/db_berkeley/kamailio/location
+++ b/utils/kamctl/db_berkeley/kamailio/location
@@ -7,4 +7,4 @@ METADATA_READONLY
METADATA_LOGFLAGS
0
METADATA_DEFAULTS
-NIL|''|''|NULL|''|NULL|NULL|'2020-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL|0
+NIL|''|''|NULL|''|NULL|NULL|'2030-05-28 21:32:15'|1.0|'Default-Call-ID'|1|'1900-01-01 00:00:01'|0|0|''|NULL|NULL|NULL|0
diff --git a/utils/kamctl/db_sqlite/registrar-create.sql b/utils/kamctl/db_sqlite/registrar-create.sql
index 8743517..bcad0f6 100644
--- a/utils/kamctl/db_sqlite/registrar-create.sql
+++ b/utils/kamctl/db_sqlite/registrar-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE aliases (
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
- expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
+ expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2030-05-28 21:32:15' NOT NULL,
q REAL DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INTEGER DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql
index 72fd3d9..11442f6 100644
--- a/utils/kamctl/db_sqlite/usrloc-create.sql
+++ b/utils/kamctl/db_sqlite/usrloc-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE location (
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
- expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
+ expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2030-05-28 21:32:15' NOT NULL,
q REAL DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INTEGER DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/kamctlrc b/utils/kamctl/kamctlrc
index ceb6f54..93be3b0 100644
--- a/utils/kamctl/kamctlrc
+++ b/utils/kamctl/kamctlrc
@@ -52,7 +52,7 @@
# in db/schema/entities.xml too.
# FIXME
-# FOREVER="2020-05-28 21:32:15"
+# FOREVER="2030-05-28 21:32:15"
# DEFAULT_ALIASES_EXPIRES=$FOREVER
# DEFAULT_Q="1.0"
# DEFAULT_CALLID="Default-Call-ID"
diff --git a/utils/kamctl/kamdbctl.base b/utils/kamctl/kamdbctl.base
index b1cf561..60a0849 100644
--- a/utils/kamctl/kamdbctl.base
+++ b/utils/kamctl/kamdbctl.base
@@ -48,7 +48,7 @@ PRESENCE_TABLES=${PRESENCE_TABLES:-presentity active_watchers watchers xcap
# script and needed to be the same as in the database definitions.
# FIXME
-FOREVER=${FOREVER:-2020-05-28 21:32:15}
+FOREVER=${FOREVER:-2030-05-28 21:32:15}
DEFAULT_ALIASES_EXPIRES=${DEFAULT_ALIASES_EXPIRES:-${FOREVER}}
DEFAULT_Q=${DEFAULT_Q:-1.0}
DEFAULT_CALLID=${DEFAULT_CALLID:-Default-Call-ID}
diff --git a/utils/kamctl/mysql/registrar-create.sql b/utils/kamctl/mysql/registrar-create.sql
index 73f808c..640f7e8 100644
--- a/utils/kamctl/mysql/registrar-create.sql
+++ b/utils/kamctl/mysql/registrar-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE aliases (
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
- expires DATETIME DEFAULT '2020-05-28 21:32:15' NOT NULL,
+ expires DATETIME DEFAULT '2030-05-28 21:32:15' NOT NULL,
q FLOAT(10,2) DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INT(11) DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql
index dc1fa5a..fe26cca 100644
--- a/utils/kamctl/mysql/usrloc-create.sql
+++ b/utils/kamctl/mysql/usrloc-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE location (
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
- expires DATETIME DEFAULT '2020-05-28 21:32:15' NOT NULL,
+ expires DATETIME DEFAULT '2030-05-28 21:32:15' NOT NULL,
q FLOAT(10,2) DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INT(11) DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/oracle/registrar-create.sql b/utils/kamctl/oracle/registrar-create.sql
index 0409d84..d311b41 100644
--- a/utils/kamctl/oracle/registrar-create.sql
+++ b/utils/kamctl/oracle/registrar-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE aliases (
contact VARCHAR2(255) DEFAULT '',
received VARCHAR2(128) DEFAULT NULL,
path VARCHAR2(128) DEFAULT NULL,
- expires DATE DEFAULT to_date('2020-05-28 21:32:15','yyyy-mm-dd hh24:mi:ss'),
+ expires DATE DEFAULT to_date('2030-05-28 21:32:15','yyyy-mm-dd hh24:mi:ss'),
q NUMBER(10,2) DEFAULT 1.0 NOT NULL,
callid VARCHAR2(255) DEFAULT 'Default-Call-ID',
cseq NUMBER(10) DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql
index 386af40..67070c9 100644
--- a/utils/kamctl/oracle/usrloc-create.sql
+++ b/utils/kamctl/oracle/usrloc-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE location (
contact VARCHAR2(255) DEFAULT '',
received VARCHAR2(128) DEFAULT NULL,
path VARCHAR2(128) DEFAULT NULL,
- expires DATE DEFAULT to_date('2020-05-28 21:32:15','yyyy-mm-dd hh24:mi:ss'),
+ expires DATE DEFAULT to_date('2030-05-28 21:32:15','yyyy-mm-dd hh24:mi:ss'),
q NUMBER(10,2) DEFAULT 1.0 NOT NULL,
callid VARCHAR2(255) DEFAULT 'Default-Call-ID',
cseq NUMBER(10) DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/postgres/registrar-create.sql b/utils/kamctl/postgres/registrar-create.sql
index 2771e01..1f1c382 100644
--- a/utils/kamctl/postgres/registrar-create.sql
+++ b/utils/kamctl/postgres/registrar-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE aliases (
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
- expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
+ expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2030-05-28 21:32:15' NOT NULL,
q REAL DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INTEGER DEFAULT 1 NOT NULL,
diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql
index a74fe87..6125845 100644
--- a/utils/kamctl/postgres/usrloc-create.sql
+++ b/utils/kamctl/postgres/usrloc-create.sql
@@ -7,7 +7,7 @@ CREATE TABLE location (
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
- expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
+ expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2030-05-28 21:32:15' NOT NULL,
q REAL DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INTEGER DEFAULT 1 NOT NULL,
More information about the sr-dev
mailing list