use asterisk;

DROP TABLE IF EXISTS `provision_config`;
CREATE TABLE `provision_config` (
  `id` int(3) NOT NULL auto_increment,
  `keyword` varchar(15) default NULL,
  `value` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
);
INSERT INTO `provision_config` VALUES (1,'adminpass','your-password-hr83rds'),(2,'userpass','your-password-d2m198ds');

DROP TABLE IF EXISTS `provision_log`;
CREATE TABLE `provision_log` (
  `id` int(3) NOT NULL auto_increment,
  `mac` varchar(12) NOT NULL,
  `provisioned` varchar(10) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `mac` (`mac`)
) ;

DROP TABLE IF EXISTS `provision_regex`;
CREATE TABLE `provision_regex` (
  `id` int(3) NOT NULL auto_increment,
  `regex` varchar(10) default NULL,
  `brand` varchar(16) default NULL,
  `script` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
); 
INSERT INTO `provision_regex` VALUES (1,'0004F2','Polycom','mkconfig-polycom.php'),(2,'00e075','Polycom','mkconfig-polycom.php'),(3,'00085D','Aastra','mkconfig-aastra.php'),(4,'cfg00','Grandstream','mkconfig-grandstream.php'),(5,'CTLSEP','Cisco','mkconfig-cisco.php');

DROP TABLE IF EXISTS `provision_registrars`;
CREATE TABLE `provision_registrars` (
  `id` int(3) NOT NULL auto_increment,
  `server_ip` varchar(16) default NULL,
  `server_name` varchar(30) default NULL,
  `server_port` varchar(6) default NULL,
  PRIMARY KEY  (`id`)
);


LOCK TABLES `provision_registrars` WRITE;
INSERT INTO `provision_registrars` VALUES (1,'172.16.23.1','Asterisk-1','5060'),(2,'172.16.23.2','Asterisk-2','5060'),(3,'172.16.23.3','Asterisk-3','5060');

DROP TABLE IF EXISTS `provision_servers`;
CREATE TABLE `provision_servers` (
  `id` int(3) NOT NULL auto_increment,
  `server_ip` varchar(16) default NULL,
  `server_dns` varchar(50) default NULL,
  `server_name` varchar(30) default NULL,
  `protocol` varchar(8) default NULL,
  `rule` text,
  PRIMARY KEY  (`id`)
);

LOCK TABLES `provision_servers` WRITE;
INSERT INTO `provision_servers` VALUES (1,'172.16.23.1','asterisk1.local.wedovoice.com','Asterisk-1','tftp://','/Sipura/$PN/cfg/$MA/$PRVST/$HWVER'),(2,'172.16.23.1','asterisk2.local.wedovoice.com','Asterisk-2','tftp://','/Sipura/$PN/cfg/$MA/$PRVST/$HWVER'),(3,'172.16.23.3','asterisk3.local.wedovoice.com','asterisk3.local.wedovoice.com','tftp://','/Sipura/$PN/cfg/$MA/$PRVST/$HWVER');