--
-- Host: localhost    Database: kamailio
-- ------------------------------------------------------


--
-- Current Database: `kamailio`
--

USE `kamailio`;

--
-- Dumping data for table `acc`
--


--
-- Dumping data for table `active_watchers`
--


--
-- Dumping data for table `address`
--


--
-- Dumping data for table `aliases`
--


--
-- Dumping data for table `carrier_name`
--


--
-- Dumping data for table `carrierfailureroute`
--


--
-- Dumping data for table `carrierroute`
--


--
-- Dumping data for table `cdrs`
--


--
-- Dumping data for table `cpl`
--


--
-- Dumping data for table `custom_authorization`
--


--
-- Dumping data for table `dbaliases`
--

INSERT INTO `dbaliases` VALUES (1,'jon.langseth','example.com','jonl','example.com'),(34,'+4761135156','example.com','jonl','example.com'),(6,'+4773411490','example.com','externaluser','asteriskbox.example.com:5062'),(18,'+4773411495','example.com','sipp','example.com');

--
-- Dumping data for table `dialog`
--


--
-- Dumping data for table `dialplan`
--


--
-- Dumping data for table `dispatcher`
--


--
-- Dumping data for table `domain`
--

INSERT INTO `domain` VALUES (1,'example.com','1900-01-01 00:00:01');

--
-- Dumping data for table `domain_name`
--


--
-- Dumping data for table `domainpolicy`
--


--
-- Dumping data for table `globalblacklist`
--


--
-- Dumping data for table `grp`
--


--
-- Dumping data for table `htable`
--


--
-- Dumping data for table `imc_members`
--


--
-- Dumping data for table `imc_rooms`
--


--
-- Dumping data for table `lcr_gw`
--


--
-- Dumping data for table `lcr_rule`
--


--
-- Dumping data for table `lcr_rule_target`
--


--
-- Dumping data for table `location`
--


--
-- Dumping data for table `missed_calls`
--


--
-- Dumping data for table `pdt`
--


--
-- Dumping data for table `presentity`
--


--
-- Dumping data for table `pua`
--


--
-- Dumping data for table `purplemap`
--


--
-- Dumping data for table `re_grp`
--


--
-- Dumping data for table `rls_presentity`
--


--
-- Dumping data for table `rls_watchers`
--


--
-- Dumping data for table `silo`
--


--
-- Dumping data for table `sip_trace`
--


--
-- Dumping data for table `speed_dial`
--


--
-- Dumping data for table `statistics`
--


--
-- Dumping data for table `subscriber`
--

INSERT INTO `subscriber` VALUES (3,'jonl','example.com','f4837c002110e777170a7eba','jon.langseth@example.com','f24154226327c08b70f9884eae1bcc6f','41edc21917bb779abf1b1ab9b46ac36f',NULL,30,30),(5,'testuser','example.com','test12345user','justtesting@no.email','5a5437231dca810192a31be83b498af1','6218bae3b04f4f850d1aafb699125427',NULL,14,14),(40,'sipp','example.com','yQ7f5xsLCEmsGOa','sipp@example.com','','',NULL,14,14),(48,'foo','example.com','84ee6d6155abfbd408cbe0b2f','example@example.com','8fc0bd6512f0eb81a98e25e61c78ff25','95e59e343587489471d69a3557332641',NULL,14,14);

--
-- Dumping data for table `trusted`
--


--
-- Dumping data for table `uri`
--


--
-- Dumping data for table `userblacklist`
--


--
-- Dumping data for table `usr_preferences`
--


--
-- Dumping data for table `version`
--

INSERT INTO `version` VALUES ('acc',4),('missed_calls',3),('lcr_gw',1),('lcr_rule_target',1),('lcr_rule',1),('domain',1),('grp',2),('re_grp',1),('trusted',5),('address',4),('aliases',1004),('location',1004),('silo',5),('dbaliases',1),('uri',1),('speed_dial',2),('usr_preferences',2),('subscriber',6),('pdt',1),('dialog',5),('dispatcher',4),('dialplan',1),('imc_rooms',1),('imc_members',1),('cpl',1),('sip_trace',2),('domainpolicy',2),('carrierroute',3),('carrierfailureroute',2),('carrier_name',1),('domain_name',1),('userblacklist',1),('globalblacklist',1),('htable',1),('purplemap',1),('presentity',3),('active_watchers',9),('watchers',3),('xcap',3),('pua',6),('rls_presentity',0),('rls_watchers',1);

--
-- Dumping data for table `watchers`
--


--
-- Dumping data for table `xcap`
--


--
-- Current Database: `provision`
--

USE `provision`;

--
-- Dumping data for table `number_pool`
--

INSERT INTO `number_pool` VALUES (1,'2011-05-23 12:00:03','+4773411491'),(2,'2011-05-23 12:00:05','+4773411492'),(3,'2011-05-23 12:00:07','+4773411494'),(4,'2011-05-23 12:00:11','+4773411495'),(5,'2011-05-23 12:00:12','+4773411496'),(6,'2011-05-23 12:00:13','+4773411497'),(7,'2011-05-23 12:00:15','+4773411498'),(8,'2011-05-23 12:00:17','+4773411499'),(29,'2012-01-12 14:03:06','+4761135305'),(28,'2011-05-24 19:03:49','+4773411493'),(27,'2011-05-24 19:03:10','+4773411468'),(26,'2011-05-24 19:03:01','+4773411462');

--
-- Dumping data for table `phones`
--

INSERT INTO `phones` VALUES (1,'2011-05-10 12:06:14','c89c1d6db76c',1,NULL),(2,'2011-05-10 12:06:45','1cdf0f4a35eb',30,NULL),(3,'2011-05-10 12:06:49','1cdf0f4a35eb',1,NULL),(12,'2012-01-17 12:22:55','f00ba2ba5c00',1,NULL);

--
-- Dumping data for table `servers`
--

INSERT INTO `servers` VALUES (1,'example.com','example.com',5062,'pbx.example.com',5060,NULL);

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'2011-05-10 12:02:48','jonl','f4837c002110e777170a7eba','Langseth, Jon','example.com','example.com',5062,'pbx.example.com',5060,'jonl','(*xx*|*xx*x.|*xx*x.*|*xx|*xx.|xxx.)','73411463'),(30,'2012-01-12 16:53:59','foo','84ee6d6155abfbd408cbe0b2f0d363a9','Hey Yo','example.com','example.com',5062,'pbx.example.com',5060,'foo','(*xx*.|xxx.)','lolol'),(32,'2012-01-16 23:00:00','testuser','test12345user','Test User','example.com','example.com',5062,'pbx.example.com',5060,'jonl','(*xx*|*xx*x.|*xx*x.*|*xx|*xx.|xxx.)','testuser');


