sr-dev February 2013

sr-dev@lists.kamailio.org

45 participants
200 discussions

git:master: msilo: safety check for freeing tmp_extra_headers

by Daniel-Constantin Mierla

Module: sip-router Branch: master Commit: 23b84739a72c5cca1fd397fbe1a7468a621cc2e6 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=23b8473… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Wed Feb 6 23:08:02 2013 +0100 msilo: safety check for freeing tmp_extra_headers - it can be a static empty buffer - reported by Stoyan Mihaylov --- modules/msilo/msilo.c | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/modules/msilo/msilo.c b/modules/msilo/msilo.c index 209b309..efa49f1 100644 --- a/modules/msilo/msilo.c +++ b/modules/msilo/msilo.c @@ -1134,13 +1134,15 @@ static int m_dump(struct sip_msg* msg, str* owner_s) tmp_extra_hdrs /*extra_hdrs*/) < 0) { LM_ERR("headers building failed [%d]\n", mid); - pkg_free(tmp_extra_hdrs.s); + if(tmp_extra_hdrs.len>0) + pkg_free(tmp_extra_hdrs.s); if (msilo_dbf.free_result(db_con, db_res) < 0) LM_ERR("failed to free the query result\n"); msg_list_set_flag(ml, mid, MS_MSG_ERRO); goto error; } - pkg_free(tmp_extra_hdrs.s); + if(tmp_extra_hdrs.len>0) + pkg_free(tmp_extra_hdrs.s); LM_DBG("msg [%d-%d] for: %.*s\n", i+1, mid, pto->uri.len, pto->uri.s);

11 years, 2 months

git:master: xhttp_rpc Fix typo and minor formatting in README

by Olle E. Johansson

Module: sip-router Branch: master Commit: 1d6b2ce07c6b661ed3e3a1c31b8ec408d68ed4e9 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1d6b2ce… Author: Olle E. Johansson <oej(a)edvina.net> Committer: Olle E. Johansson <oej(a)edvina.net> Date: Wed Feb 6 20:42:50 2013 +0100 xhttp_rpc Fix typo and minor formatting in README --- modules/xhttp_rpc/README | 35 ++++++++++++++--------------- modules/xhttp_rpc/doc/xhttp_rpc_admin.xml | 18 ++++++++++---- 2 files changed, 30 insertions(+), 23 deletions(-) diff --git a/modules/xhttp_rpc/README b/modules/xhttp_rpc/README index 46fb5d4..9796bc3 100644 --- a/modules/xhttp_rpc/README +++ b/modules/xhttp_rpc/README @@ -81,19 +81,18 @@ Chapter 1. Admin Guide 1.1. Limitations - This module does not implement asynchronous RPC commands. It is - unlikely that asynchronous RPC commands will be executed from an RPC - web interface. - - This module does not accept parameters embedded in a structure (see RPC - documentation for more info about how parameters can be passed to RPC). - - At startup, all RPC commands are sorted and grouped based on their - format. The expected format is [group].[subcommand]. The initial - xhttp_rpc webpage displays all the retrieved groups. All RPC commands - are available as sub-menus of each [group]. If an RPC command is not in - the expected format, it will be dropped from the initial xhttp_rpc home - page menu. + * This module does not implement asynchronous RPC commands. It is + unlikely that asynchronous RPC commands will be executed from an + RPC web interface. + * This module does not accept parameters embedded in a structure (see + RPC documentation for more info about how parameters can be passed + to RPC). + * At startup, all RPC commands are sorted and grouped based on their + format. The expected format is [group].[subcommand]. The initial + xhttp_rpc webpage displays all the retrieved groups. All RPC + commands are available as sub-menus of each [group]. If an RPC + command is not in the expected format, it will be dropped from the + initial xhttp_rpc home page menu. 2. Dependencies @@ -118,8 +117,8 @@ Chapter 1. Admin Guide 3.1. xhttp_rpc_root (str) - It specifies the root path for RPC http requests. The link to the RPC - web interface must be constructed using the following patern: + Specifies the root path for RPC http requests. The link to the RPC web + interface must be constructed using the following pattern: http://[server_IP]:[tcp_port]/[xhttp_rpc_root] Default value is "rpc". @@ -131,8 +130,8 @@ modparam("xhttp_rpc", "xhttp_rpc_root", "http_rpc") 3.2. xhttp_rpc_buf_size (str) - It specifies the maximum length of the buffer used to write in the RPC - reply information in order to build the HTML response. + Specifies the maximum length of the buffer used to write the RPC reply + information in order to build the HTML response. Default value is 0 (auto set to 1/3 of the size of the configured pkg mem). @@ -146,7 +145,7 @@ modparam("xhttp", "xhttp_rpc_buf_size", ) 4.1. dispatch_xhttp_rpc() -4.1. dispatch_xhttp_rpc() +4.1. dispatch_xhttp_rpc() Handle the HTTP request and generate a response. diff --git a/modules/xhttp_rpc/doc/xhttp_rpc_admin.xml b/modules/xhttp_rpc/doc/xhttp_rpc_admin.xml index b5f8974..3b658e9 100644 --- a/modules/xhttp_rpc/doc/xhttp_rpc_admin.xml +++ b/modules/xhttp_rpc/doc/xhttp_rpc_admin.xml @@ -26,24 +26,32 @@ <section> <title>Limitations</title> + <itemizedlist> + <listitem> <para> This module does not implement asynchronous RPC commands. It is unlikely that asynchronous RPC commands will be executed from an RPC web interface. </para> + </listitem> + <listitem> <para> This module does not accept parameters embedded in a structure (see RPC documentation for more info about how parameters can be passed to RPC). </para> + </listitem> + <listitem> <para> At startup, all RPC commands are sorted and grouped based on - their format. The expected format is [group].[subcommand]. + their format. The expected format is [group].[subcommand]. The initial xhttp_rpc webpage displays all the retrieved groups. All RPC commands are available as sub-menus of each [group]. If an RPC command is not in the expected format, it will be dropped from the initial xhttp_rpc home page menu. </para> + </listitem> + </itemizedlist> </section> </section> @@ -82,9 +90,9 @@ <section> <title><varname>xhttp_rpc_root</varname> (str)</title> <para> - It specifies the root path for RPC http requests. + Specifies the root path for RPC http requests. The link to the RPC web interface must be constructed - using the following patern: + using the following pattern: http://[server_IP]:[tcp_port]/[xhttp_rpc_root] </para> <para> @@ -104,8 +112,8 @@ modparam("xhttp_rpc", "xhttp_rpc_root", "http_rpc") <section> <title><varname>xhttp_rpc_buf_size</varname> (str)</title> <para> - It specifies the maximum length of the buffer used - to write in the RPC reply information in order to + Specifies the maximum length of the buffer used + to write the RPC reply information in order to build the HTML response. </para> <para>

11 years, 2 months

git:admorten/sca DELETED: sca: fix potential leak of parsed To body

by Andrew Mortensen

Module: sip-router Branch: admorten/sca DELETED Commit: f4f776577d0011a1c87fdc59f130ca2ea26f1170 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f4f7765… Author: Andrew Mortensen <admorten(a)isc.upenn.edu> Committer: Andrew Mortensen <admorten(a)isc.upenn.edu> Date: Tue Nov 27 14:06:23 2012 -0500 sca: fix potential leak of parsed To body - if msg->to wasn't parsed, sca_subscription_from_request called parse_to, but never called free_to_params. - make the subscription to-tag independent of the parsed to_body with a pkg_malloc'd copy, freed in the caller. --- modules/sca/sca_subscribe.c | 34 ++++++++++++++++++++++++++-------- 1 files changed, 26 insertions(+), 8 deletions(-) diff --git a/modules/sca/sca_subscribe.c b/modules/sca/sca_subscribe.c index aadcf56..06ebae9 100644 --- a/modules/sca/sca_subscribe.c +++ b/modules/sca/sca_subscribe.c @@ -893,11 +893,13 @@ sca_subscription_delete_subscriber_for_event( sca_mod *scam, str *subscriber, return( 1 ); } +/* caller must pkg_free req_sub->rr.s and req_sub->dialog.to_tag.s */ int sca_subscription_from_request( sca_mod *scam, sip_msg_t *msg, int event_type, sca_subscription *req_sub ) { - struct to_body tmp_to, *to, *from; + struct to_body tmp_to = { 0 }; + struct to_body *to, *from; str contact_uri; str to_tag = STR_NULL; unsigned int expires = 0, max_expires; @@ -905,6 +907,8 @@ sca_subscription_from_request( sca_mod *scam, sip_msg_t *msg, int event_type, assert( req_sub != NULL ); + memset( req_sub, 0, sizeof( sca_subscription )); + /* parse required info first */ if ( !SCA_HEADER_EMPTY( msg->expires )) { if ( parse_expires( msg->expires ) < 0 ) { @@ -1012,15 +1016,25 @@ sca_subscription_from_request( sca_mod *scam, sip_msg_t *msg, int event_type, req_sub->dialog.id.len = 0; req_sub->dialog.call_id = msg->callid->body; req_sub->dialog.from_tag = from->tag_value; - req_sub->dialog.to_tag = to_tag; + + req_sub->dialog.to_tag.s = pkg_malloc( to_tag.len ); + if ( req_sub->dialog.to_tag.s == NULL ) { + LM_ERR( "Failed to pkg_malloc space for to-tag %.*s", + STR_FMT( &to_tag )); + goto error; + } + SCA_STR_COPY( &req_sub->dialog.to_tag, &to_tag ); + req_sub->dialog.subscribe_cseq = 0; req_sub->dialog.notify_cseq = 0; - //free_to_params( &tmp_to ); + free_to_params( &tmp_to ); + return( 1 ); error: - //free_to_params( &tmp_to ); + free_to_params( &tmp_to ); + return( -1 ); } @@ -1070,7 +1084,7 @@ sca_handle_subscribe( sip_msg_t *msg, char *p1, char *p2 ) if ( sca_subscription_copy_subscription_key( &req_sub, &sub_key ) < 0 ) { SCA_REPLY_ERROR( sca, 500, "Internal Server Error - copy dialog id", msg ); - return( -1 ); + goto done; } sca_subscription_print( &req_sub ); @@ -1082,6 +1096,9 @@ sca_handle_subscribe( sip_msg_t *msg, char *p1, char *p2 ) /* ensure we only calculate the hash table index once */ idx = sca_hash_table_index_for_key( sca->subscriptions, &sub_key ); + /* pkg_malloc'd in sca_subscription_copy_subscription_key above */ + pkg_free( sub_key.s ); + sca_hash_table_lock_index( sca->subscriptions, idx ); sub = sca_hash_table_index_kv_find_unsafe( sca->subscriptions, idx, @@ -1168,9 +1185,6 @@ sca_handle_subscribe( sip_msg_t *msg, char *p1, char *p2 ) } } - /* pkg_malloc'd in sca_subscription_copy_subscription_key() */ - pkg_free( sub_key.s ); - status = sca_ok_status_for_event( event_type ); status_text = sca_ok_text_for_event( event_type ); if ( sca_reply( sca, status, status_text, event_type, @@ -1207,6 +1221,10 @@ done: sca_hash_table_unlock_index( sca->subscriptions, idx ); } + if ( req_sub.dialog.to_tag.s != NULL ) { + pkg_free( req_sub.dialog.to_tag.s ); + } + return( rc ); }

11 years, 2 months

git:pd/msrp: modules/msrp: Fixed typos in MSRP README and added extra event_route example

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: da298e85166b873f4825e4baa96db0d317771e20 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=da298e8… Author: Peter Dunkley <peter.dunkley(a)crocodile-rcs.com> Committer: Peter Dunkley <peter.dunkley(a)crocodile-rcs.com> Date: Wed Feb 6 12:55:55 2013 +0000 modules/msrp: Fixed typos in MSRP README and added extra event_route example --- modules/msrp/README | 162 +++++++++++++++++++++++++++++++++++---- modules/msrp/doc/msrp_admin.xml | 142 +++++++++++++++++++++++++++++++++- 2 files changed, 283 insertions(+), 21 deletions(-) Diff: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=da2…

11 years, 2 months

git:pd/msrp: modules/msrp: Fixed error in msrp_cmap_lookup()

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: f56e82a286e00a17dbf02e9a5056ef73488b89b1 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f56e82a… Author: Peter Dunkley <peter.dunkley(a)crocodile-rcs.com> Committer: Peter Dunkley <peter.dunkley(a)crocodile-rcs.com> Date: Wed Feb 6 12:36:52 2013 +0000 modules/msrp: Fixed error in msrp_cmap_lookup() --- modules/msrp/msrp_cmap.c | 3 +-- 1 files changed, 1 insertions(+), 2 deletions(-) diff --git a/modules/msrp/msrp_cmap.c b/modules/msrp/msrp_cmap.c index 23a216b..f558172 100644 --- a/modules/msrp/msrp_cmap.c +++ b/modules/msrp/msrp_cmap.c @@ -354,8 +354,7 @@ int msrp_cmap_lookup(msrp_frame_t *mf) { if(itb->citemid>hid) { break; - } - if(itb->citemid>hid) { + } else { if(itb->sessionid.len == sesid.len && memcmp(itb->sessionid.s, sesid.s, sesid.len)==0) { LM_DBG("found session [%.*s]\n", sesid.len, sesid.s);

11 years, 2 months

git:pd/msrp: xhttp_pi: documentation updates

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: 62cd05a469f657b5371ecd1538f9c9b224f7e589 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=62cd05a… Author: Ovidiu Sas <osas(a)voipembedded.com> Committer: Ovidiu Sas <osas(a)voipembedded.com> Date: Tue Feb 5 10:06:47 2013 -0500 xhttp_pi: documentation updates --- modules/xhttp_pi/README | 4 +++- modules/xhttp_pi/doc/xhttp_pi_admin.xml | 10 ++++++++-- 2 files changed, 11 insertions(+), 3 deletions(-) diff --git a/modules/xhttp_pi/README b/modules/xhttp_pi/README index ed4a451..9381257 100644 --- a/modules/xhttp_pi/README +++ b/modules/xhttp_pi/README @@ -163,6 +163,8 @@ kamdbctl pframework create * DB1_STRING * DB1_STR * DB1_DATETIME + + Note: input field must be provided in 'YEAR-MM-DD HH:MM:SS' + format. * DB1_BLOB * DB1_BITMAP @@ -219,7 +221,7 @@ kamdbctl pframework create 4. To-do Features to be added in the future: - * full subscriber provisionning with automatic ha1/ha1b fields; + * full subscriber provisionning with automatic ha1/ha1b fields. 5. Dependencies diff --git a/modules/xhttp_pi/doc/xhttp_pi_admin.xml b/modules/xhttp_pi/doc/xhttp_pi_admin.xml index 45b03ed..4b7475e 100644 --- a/modules/xhttp_pi/doc/xhttp_pi_admin.xml +++ b/modules/xhttp_pi/doc/xhttp_pi_admin.xml @@ -130,7 +130,13 @@ kamdbctl pframework create <listitem><para>DB1_DOUBLE</para></listitem> <listitem><para>DB1_STRING</para></listitem> <listitem><para>DB1_STR</para></listitem> - <listitem><para>DB1_DATETIME</para></listitem> + <listitem><para>DB1_DATETIME</para> + <itemizedlist> + <listitem><para>Note: input field must be provided in + 'YEAR-MM-DD HH:MM:SS' format.</para> + </listitem> + </itemizedlist> + </listitem> <listitem><para>DB1_BLOB</para></listitem> <listitem><para>DB1_BITMAP</para></listitem> </itemizedlist> @@ -233,7 +239,7 @@ kamdbctl pframework create </para> <itemizedlist> <listitem><para> - full subscriber provisionning with automatic ha1/ha1b fields; + full subscriber provisionning with automatic ha1/ha1b fields. </para></listitem> </itemizedlist> </section>

11 years, 2 months

git:pd/msrp: modules/lcr: treat lcr_gw/ ip_addr empty string value same as null value

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: 1e16eb9c892358a972ae71f05ec138fbe0d23126 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1e16eb9… Author: Juha Heinanen <jh(a)tutpro.com> Committer: Juha Heinanen <jh(a)tutpro.com> Date: Wed Feb 6 11:21:11 2013 +0200 modules/lcr: treat lcr_gw/ip_addr empty string value same as null value --- modules/lcr/lcr_mod.c | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/modules/lcr/lcr_mod.c b/modules/lcr/lcr_mod.c index 757734d..9c5ff3f 100644 --- a/modules/lcr/lcr_mod.c +++ b/modules/lcr/lcr_mod.c @@ -943,7 +943,8 @@ static int insert_gws(db1_res_t *res, struct gw_info *gws, i); return 0; } - if (VAL_NULL(ROW_VALUES(row) + 1)) { + if (VAL_NULL(ROW_VALUES(row) + 1) || + (strlen((char *)VAL_STRING(ROW_VALUES(row) + 1)) == 0)) { ip_string.s = (char *)0; ip_addr.af = 0; ip_addr.len = 0;

11 years, 2 months

git:pd/msrp: ims_usrloc_pcscf: remove unused variables

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: d474abbb3d93c992ccff561909402ca1b52297bd URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d474abb… Author: Ovidiu Sas <osas(a)voipembedded.com> Committer: Ovidiu Sas <osas(a)voipembedded.com> Date: Sun Feb 3 10:50:47 2013 -0500 ims_usrloc_pcscf: remove unused variables --- modules/ims_usrloc_pcscf/ul_rpc.c | 6 +----- 1 files changed, 1 insertions(+), 5 deletions(-) diff --git a/modules/ims_usrloc_pcscf/ul_rpc.c b/modules/ims_usrloc_pcscf/ul_rpc.c index aed0411..257604f 100644 --- a/modules/ims_usrloc_pcscf/ul_rpc.c +++ b/modules/ims_usrloc_pcscf/ul_rpc.c @@ -56,17 +56,13 @@ static const char* ul_rpc_dump_doc[2] = { }; static void ul_rpc_dump(rpc_t* rpc, void* ctx) { - struct pcontact* c; - ppublic_t* p; dlist_t* dl; udomain_t* dom; time_t t; void* th; void* ah; - void* ih; - void* sr; void* sh; - int max, n, i, j; + int max, n, i; t = time(0); for (dl = root; dl; dl = dl->next) {

11 years, 2 months

git:pd/msrp: ims_icscf: getting rid of "defined but not used" compiler warning

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: 47276cf597ab941016fd49dbcfaaab3da8802834 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=47276cf… Author: Ovidiu Sas <osas(a)voipembedded.com> Committer: Ovidiu Sas <osas(a)voipembedded.com> Date: Sun Feb 3 23:36:26 2013 -0500 ims_icscf: getting rid of "defined but not used" compiler warning --- modules/ims_icscf/nds.c | 3 +++ modules/ims_icscf/nds.h | 2 -- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/modules/ims_icscf/nds.c b/modules/ims_icscf/nds.c index 0e5b06b..2f2668f 100644 --- a/modules/ims_icscf/nds.c +++ b/modules/ims_icscf/nds.c @@ -65,6 +65,9 @@ extern sl_api_t slb; +static str str_msg_403 = {MSG_403, 9}; +static str str_msg_500 = {MSG_500, 46}; + /** Defines the untrusted headers */ str untrusted_headers[]={ {"P-Asserted-Identity",19}, diff --git a/modules/ims_icscf/nds.h b/modules/ims_icscf/nds.h index 1f7abfa..29f973a 100644 --- a/modules/ims_icscf/nds.h +++ b/modules/ims_icscf/nds.h @@ -62,8 +62,6 @@ #define MSG_403 "Forbidden" #define MSG_500 "I-CSCF Error while stripping untrusted headers" -static str str_msg_403 = {MSG_403, 9}; -static str str_msg_500 = {MSG_500, 46}; int I_NDS_check_trusted(struct sip_msg* msg, char* str1, char* str2);

11 years, 2 months

git:pd/msrp: sca: restore correct table version number in db creation files .

by Peter Dunkley

Module: sip-router Branch: pd/msrp Commit: 60e60e26cebeea2d8e07ec4ffd036ab1f35e2f12 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=60e60e2… Author: Andrew Mortensen <admorten(a)isc.upenn.edu> Committer: Andrew Mortensen <admorten(a)isc.upenn.edu> Date: Fri Feb 1 11:45:32 2013 -0500 sca: restore correct table version number in db creation files. - Had been reverted by commit f636e215089a9b14daa113d93025831e827192b5 because the schema xml file had the wrong version number. --- utils/kamctl/db_berkeley/kamailio/version | 2 +- utils/kamctl/db_sqlite/sca-create.sql | 2 +- utils/kamctl/dbtext/kamailio/version | 2 +- utils/kamctl/mysql/sca-create.sql | 2 +- utils/kamctl/oracle/sca-create.sql | 2 +- utils/kamctl/postgres/sca-create.sql | 2 +- 6 files changed, 6 insertions(+), 6 deletions(-) diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index eb1d8e7..ef9cac4 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -95,7 +95,7 @@ rls_presentity|1 rls_watchers| rls_watchers|3 sca_subscriptions| -sca_subscriptions|0 +sca_subscriptions|1 silo| silo|7 sip_trace| diff --git a/utils/kamctl/db_sqlite/sca-create.sql b/utils/kamctl/db_sqlite/sca-create.sql index 1327b3f..46429fb 100644 --- a/utils/kamctl/db_sqlite/sca-create.sql +++ b/utils/kamctl/db_sqlite/sca-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0'); +INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1'); CREATE TABLE sca_subscriptions ( id INTEGER PRIMARY KEY NOT NULL, subscriber VARCHAR(255) NOT NULL, diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 9a3fe62..f76df16 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -42,7 +42,7 @@ purplemap:1 re_grp:1 rls_presentity:1 rls_watchers:3 -sca_subscriptions:0 +sca_subscriptions:1 silo:7 sip_trace:3 speed_dial:2 diff --git a/utils/kamctl/mysql/sca-create.sql b/utils/kamctl/mysql/sca-create.sql index f1633c6..b48d38b 100644 --- a/utils/kamctl/mysql/sca-create.sql +++ b/utils/kamctl/mysql/sca-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0'); +INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1'); CREATE TABLE sca_subscriptions ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, subscriber VARCHAR(255) NOT NULL, diff --git a/utils/kamctl/oracle/sca-create.sql b/utils/kamctl/oracle/sca-create.sql index 430fd66..f63ee40 100644 --- a/utils/kamctl/oracle/sca-create.sql +++ b/utils/kamctl/oracle/sca-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0'); +INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1'); CREATE TABLE sca_subscriptions ( id NUMBER(10) PRIMARY KEY, subscriber VARCHAR2(255), diff --git a/utils/kamctl/postgres/sca-create.sql b/utils/kamctl/postgres/sca-create.sql index 94ce539..b5da925 100644 --- a/utils/kamctl/postgres/sca-create.sql +++ b/utils/kamctl/postgres/sca-create.sql @@ -1,4 +1,4 @@ -INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0'); +INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1'); CREATE TABLE sca_subscriptions ( id SERIAL PRIMARY KEY NOT NULL, subscriber VARCHAR(255) NOT NULL,

11 years, 2 months

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev February 2013