aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/share/python/asterisk/create-table.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--share/python/asterisk/create-table.sql62
1 files changed, 0 insertions, 62 deletions
diff --git a/share/python/asterisk/create-table.sql b/share/python/asterisk/create-table.sql
deleted file mode 100644
index 4fe190f..0000000
--- a/share/python/asterisk/create-table.sql
+++ /dev/null
@@ -1,62 +0,0 @@
1USE %(database)s;
2CREATE TABLE IF NOT EXISTS `ast_sipfriends` (
3 `id` int(11) NOT NULL auto_increment,
4 `name` varchar(80) NOT NULL default '',
5 `host` varchar(31) NOT NULL default 'dynamic',
6 `nat` varchar(5) NOT NULL default 'route',
7 `type` enum('user','peer','friend') NOT NULL default 'friend',
8 `accountcode` varchar(20) default NULL,
9 `amaflags` varchar(13) default NULL,
10 `callgroup` varchar(10) default NULL,
11 `callerid` varchar(80) default NULL,
12 `call-limit` int(11) NOT NULL default '0',
13 `cancallforward` char(3) default 'no',
14 `canreinvite` char(3) default 'no',
15 `context` varchar(80) default 'pre_outgoing',
16 `defaultip` varchar(15) default NULL,
17 `dtmfmode` varchar(7) default NULL,
18 `fromuser` varchar(80) default NULL,
19 `fromdomain` varchar(80) default NULL,
20 `insecure` varchar(4) default NULL,
21 `language` char(2) default NULL,
22 `mailbox` varchar(50) default NULL,
23 `md5secret` varchar(80) default NULL,
24 `deny` varchar(95) default NULL,
25 `permit` varchar(95) default NULL,
26 `mask` varchar(95) default NULL,
27 `musiconhold` varchar(100) default NULL,
28 `pickupgroup` varchar(10) default NULL,
29 `qualify` char(3) default NULL,
30 `regexten` varchar(80) default NULL,
31 `restrictcid` char(3) default NULL,
32 `rtptimeout` char(3) default NULL,
33 `rtpholdtimeout` char(3) default NULL,
34 `secret` varchar(80) default NULL,
35 `setvar` varchar(100) default NULL,
36 `disallow` varchar(100) default 'all',
37 `allow` varchar(100) default 'g729',
38 `fullcontact` varchar(80) NOT NULL default '',
39 `ipaddr` varchar(15) NOT NULL default '',
40 `port` smallint(5) unsigned NOT NULL default '0',
41 `regserver` varchar(100) default NULL,
42 `regseconds` int(11) NOT NULL default '0',
43 `username` varchar(80) NOT NULL default '',
44 `user` varchar(255) NOT NULL,
45 `placement` varchar(255) NOT NULL,
46 `description` varchar(255) NOT NULL,
47 `delay` int(4) NOT NULL default '0',
48 `sortorder` int(11) NOT NULL default '1',
49 PRIMARY KEY (`id`),
50 UNIQUE KEY `name` (`name`)
51) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
52
53CREATE TABLE IF NOT EXISTS `extensions_table` (
54 `id` int(11) NOT NULL auto_increment,
55 `context` varchar(20) NOT NULL default '',
56 `exten` varchar(36) NOT NULL default '',
57 `priority` tinyint(4) NOT NULL default '0',
58 `app` varchar(20) NOT NULL default '',
59 `appdata` varchar(128) NOT NULL default '',
60 PRIMARY KEY (`context`,`exten`,`priority`),
61 KEY `id` (`id`)
62) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; \ No newline at end of file