[sr-dev] git:tteras/db_sqlite: utils: add sqlite support to kamctl/kamdbctl

[Timo Teras]

Module: sip-router
Branch: tteras/db_sqlite
Commit: 9d36d8537b21b2d1cd51dd639ad8c1b802af2672
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9d36d8537b21b2d1cd51dd639ad8c1b802af2672

Author: Natanael Copa <ncopa at alpinelinux.org>
Committer: Timo Teräs <timo.teras at iki.fi>
Date:   Thu May 26 07:18:44 2011 +0000

utils: add sqlite support to kamctl/kamdbctl

 - sql scripts copied from postgres versions and converted to sqlite
   (only major change was: sed s/SERIAL/INTEGER/)
 - kamdbctl.sqlite based on kamdbctl.postgres with permissions stuff
   removed (sqlite has unix file permissions only) and some mysql
   emulation removed too
 - no real ro-mode

---

 utils/kamctl/kamctl                          |    6 +
 utils/kamctl/kamctl.sqlite                   |   51 +++++++++
 utils/kamctl/kamctlrc                        |    6 +-
 utils/kamctl/kamdbctl                        |   13 ++
 utils/kamctl/kamdbctl.sqlite                 |  152 ++++++++++++++++++++++++++
 utils/kamctl/sqlite/acc-create.sql           |   28 +++++
 utils/kamctl/sqlite/alias_db-create.sql      |   12 ++
 utils/kamctl/sqlite/auth_db-create.sql       |   15 +++
 utils/kamctl/sqlite/avpops-create.sql        |   15 +++
 utils/kamctl/sqlite/carrierroute-create.sql  |   42 +++++++
 utils/kamctl/sqlite/cpl-create.sql           |   10 ++
 utils/kamctl/sqlite/dialog-create.sql        |   29 +++++
 utils/kamctl/sqlite/dialplan-create.sql      |   13 ++
 utils/kamctl/sqlite/dispatcher-create.sql    |   11 ++
 utils/kamctl/sqlite/domain-create.sql        |    8 ++
 utils/kamctl/sqlite/domainpolicy-create.sql  |   13 ++
 utils/kamctl/sqlite/drouting-create.sql      |   39 +++++++
 utils/kamctl/sqlite/group-create.sql         |   19 +++
 utils/kamctl/sqlite/htable-create.sql        |    9 ++
 utils/kamctl/sqlite/imc-create.sql           |   19 +++
 utils/kamctl/sqlite/lcr-create.sql           |   43 +++++++
 utils/kamctl/sqlite/matrix-create.sql        |    9 ++
 utils/kamctl/sqlite/msilo-create.sql         |   16 +++
 utils/kamctl/sqlite/mtree-create.sql         |    8 ++
 utils/kamctl/sqlite/pdt-create.sql           |    9 ++
 utils/kamctl/sqlite/permissions-create.sql   |   21 ++++
 utils/kamctl/sqlite/presence-create.sql      |   92 ++++++++++++++++
 utils/kamctl/sqlite/purple-create.sql        |    9 ++
 utils/kamctl/sqlite/registrar-create.sql     |   22 ++++
 utils/kamctl/sqlite/rls-create.sql           |   42 +++++++
 utils/kamctl/sqlite/siptrace-create.sql      |   20 ++++
 utils/kamctl/sqlite/speeddial-create.sql     |   14 +++
 utils/kamctl/sqlite/standard-create.sql      |    5 +
 utils/kamctl/sqlite/uac-create.sql           |   16 +++
 utils/kamctl/sqlite/uri_db-create.sql        |   10 ++
 utils/kamctl/sqlite/userblacklist-create.sql |   21 ++++
 utils/kamctl/sqlite/usrloc-create.sql        |   22 ++++
 37 files changed, 887 insertions(+), 2 deletions(-)

Diff:   http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=9d36d8537b21b2d1cd51dd639ad8c1b802af2672