diff options
author | Russell Bryant <russell@russellbryant.com> | 2007-09-17 20:24:50 +0000 |
---|---|---|
committer | Russell Bryant <russell@russellbryant.com> | 2007-09-17 20:24:50 +0000 |
commit | 3dc9e8f38a607daaf635cc86a10652d8392a4e55 (patch) | |
tree | 2acba30e3b142b64f0282bfdb6ba7ec5eb9a3534 /doc/res_config_sqlite.txt | |
parent | 96d9f820e9502d5c8b83c3104aada62b43f98524 (diff) |
Add support for #include, var_metric, and cat_metric in res_config_sqlite
(closes issue #10738, rbraun_proformatique)
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@82679 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'doc/res_config_sqlite.txt')
-rw-r--r-- | doc/res_config_sqlite.txt | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/doc/res_config_sqlite.txt b/doc/res_config_sqlite.txt index 9f1794429..39d31521a 100644 --- a/doc/res_config_sqlite.txt +++ b/doc/res_config_sqlite.txt @@ -15,6 +15,8 @@ */ CREATE TABLE ast_config ( id INTEGER, + cat_metric INT(11) NOT NULL DEFAULT 0, + var_metric INT(11) NOT NULL DEFAULT 0, commented TINYINT(1) NOT NULL DEFAULT 0, filename VARCHAR(128) NOT NULL DEFAULT '', category VARCHAR(128) NOT NULL DEFAULT 'default', @@ -23,8 +25,9 @@ CREATE TABLE ast_config ( PRIMARY KEY (id) ); +CREATE INDEX ast_config__idx__cat_metric ON ast_config(cat_metric); +CREATE INDEX ast_config__idx__var_metric ON ast_config(var_metric); CREATE INDEX ast_config__idx__filename_commented ON ast_config(filename, commented); -CREATE INDEX ast_config__idx__category ON ast_config(category); /* * CDR table (this table is automatically created if non existent). |