diff options
Diffstat (limited to 'share/python/asterisk/create-table.sql')
-rw-r--r-- | share/python/asterisk/create-table.sql | 62 |
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 @@ | |||
1 | USE %(database)s; | ||
2 | CREATE 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 | |||
53 | CREATE 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 | ||