From b24058121c9a7d42ff310fb58031394b4eed28ea Mon Sep 17 00:00:00 2001
From: russell <russell@f38db490-d61c-443f-a65b-d21fe96a405b>
Date: Mon, 17 Sep 2007 20:24:50 +0000
Subject: Add support for #include, var_metric, and cat_metric in
 res_config_sqlite (closes issue #10738, rbraun_proformatique)

git-svn-id: http://svn.digium.com/svn/asterisk/trunk@82679 f38db490-d61c-443f-a65b-d21fe96a405b
---
 doc/res_config_sqlite.txt | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'doc')

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).
-- 
cgit v1.2.3