quNqkq8q

1CREATE TABLE IF NOT EXISTS `acdrchannels` (
2  `channel` varchar(50) NOT NULL,
3  `extension` varchar(20) NOT NULL default '',
4  `groupname` varchar(50) NOT NULL default '',
5  `name` varchar(100) default NULL,
6  PRIMARY KEY  (`channel`)
7);
8
9CREATE TABLE IF NOT EXISTS `acdrrates` (
10  `ratesid` int(16) NOT NULL auto_increment,
11  `prefix` varchar(14) NOT NULL default '',
12  `name` varchar(100) NOT NULL default '',
13  `cost` float(6,4) NOT NULL default '0.0000',
14  `connectcost` float(6,4) NOT NULL default '0.0000',
15  `includedsecond` int(11) NOT NULL default '0',
16  `step` int(11) NOT NULL default '1',
17  `trunk` varchar(200) NOT NULL default '',
18  PRIMARY KEY  (`ratesid`),
19  UNIQUE KEY `trunkprefix` (`prefix`,`trunk`)
20);
21
22CREATE TABLE IF NOT EXISTS `acdrcost` (
23  `id` int(11) NOT NULL auto_increment,
24  `uniqueid` varchar(32) default NULL,
25  `destination` varchar(80) default NULL,
26  `cost` decimal(6,2) default NULL,
27  PRIMARY KEY  (`id`),
28  UNIQUE KEY `uni` (`uniqueid`)
29); 
30
31CREATE TABLE IF NOT EXISTS `acdrnormalisationrules` (
32  `id` int(11) NOT NULL auto_increment,
33  `prepend` varchar(20) default NULL,
34  `prefix` varchar(20) default NULL,
35  `pattern` varchar(50) default NULL,
36  `sort` int(11) default NULL,
37  PRIMARY KEY  (`id`)
38);
39
40CREATE TABLE IF NOT EXISTS `acdrsetup` (
41  `id` int(11) NOT NULL auto_increment,
42  `keyword` varchar(50) default NULL,
43  `parameter` varchar(50) default NULL,
44  `value` varchar(100) default NULL,
45  PRIMARY KEY  (`id`),
46  UNIQUE KEY `keypar` (`keyword`,`parameter`)
47);
48
49CREATE TABLE IF NOT EXISTS `acdrusers` (
50  `id` int(11) NOT NULL auto_increment,
51  `login` varchar(30) default NULL,
52  `password` varchar(100) default NULL,
53  `name` varchar(100) default NULL,
54  `level` enum('admin','user') default 'user',
55  PRIMARY KEY  (`id`),
56  UNIQUE KEY `nombre` (`login`)
57);
58
59CREATE TABLE IF NOT EXISTS `acdruserchannel` (
60  `acdrusers_id` int(6) default NULL,
61  `acdrchannels_channel` varchar(50) default NULL,
62  UNIQUE KEY `unico` (`acdrusers_id`,`acdrchannels_channel`)
63);
64
65
66CREATE TABLE IF NOT EXISTS `acdruserfilter` (
67  `user` varchar(30) default NULL,
68  `param` varchar(30) default NULL,
69  `value` varchar(100) default NULL,
70   UNIQUE KEY `unico` (`user`,`param`,`value`)
71);
72
73INSERT IGNORE INTO `acdrusers` VALUES (1,'admin','d033e22ae348aeb5660fc2140aec35850c4da997','Administrator','admin');
74INSERT IGNORE INTO `acdruserchannel` VALUES (1,'-1');
75INSERT IGNORE INTO `acdruserfilter` VALUES ('admin','channel','-1');