--
-- Host: localhost    Database: serial_rad
-- ------------------------------------------------------


--
-- Table structure for table `nas`
--

CREATE TABLE `nas` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nasname` varchar(128) NOT NULL,
  `shortname` varchar(32) DEFAULT NULL,
  `type` varchar(30) DEFAULT 'other',
  `ports` int(5) DEFAULT NULL,
  `secret` varchar(60) NOT NULL DEFAULT 'secret',
  `server` varchar(64) DEFAULT NULL,
  `community` varchar(50) DEFAULT NULL,
  `description` varchar(200) DEFAULT 'RADIUS Client',
  PRIMARY KEY (`id`),
  KEY `nasname` (`nasname`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `nas`
--

INSERT INTO `nas` VALUES (1,'10.254.255.60','pm2-sp-lab','other',NULL,'testing123',NULL,NULL,'RADIUS Client');

--
-- Table structure for table `nasreload`
--

CREATE TABLE `nasreload` (
  `nasipaddress` varchar(15) NOT NULL,
  `reloadtime` datetime NOT NULL,
  PRIMARY KEY (`nasipaddress`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `nasreload`
--


--
-- Table structure for table `radacct`
--

CREATE TABLE `radacct` (
  `radacctid` bigint(21) NOT NULL AUTO_INCREMENT,
  `acctsessionid` varchar(64) NOT NULL DEFAULT '',
  `acctuniqueid` varchar(32) NOT NULL DEFAULT '',
  `username` varchar(64) NOT NULL DEFAULT '',
  `realm` varchar(64) DEFAULT '',
  `nasipaddress` varchar(15) NOT NULL DEFAULT '',
  `nasportid` varchar(32) DEFAULT NULL,
  `nasporttype` varchar(32) DEFAULT NULL,
  `acctstarttime` datetime DEFAULT NULL,
  `acctupdatetime` datetime DEFAULT NULL,
  `acctstoptime` datetime DEFAULT NULL,
  `acctinterval` int(12) DEFAULT NULL,
  `acctsessiontime` int(12) unsigned DEFAULT NULL,
  `acctauthentic` varchar(32) DEFAULT NULL,
  `connectinfo_start` varchar(128) DEFAULT NULL,
  `connectinfo_stop` varchar(128) DEFAULT NULL,
  `acctinputoctets` bigint(20) DEFAULT NULL,
  `acctoutputoctets` bigint(20) DEFAULT NULL,
  `calledstationid` varchar(50) NOT NULL DEFAULT '',
  `callingstationid` varchar(50) NOT NULL DEFAULT '',
  `acctterminatecause` varchar(32) NOT NULL DEFAULT '',
  `servicetype` varchar(32) DEFAULT NULL,
  `framedprotocol` varchar(32) DEFAULT NULL,
  `framedipaddress` varchar(15) NOT NULL DEFAULT '',
  `framedipv6address` varchar(45) NOT NULL DEFAULT '',
  `framedipv6prefix` varchar(45) NOT NULL DEFAULT '',
  `framedinterfaceid` varchar(44) NOT NULL DEFAULT '',
  `delegatedipv6prefix` varchar(45) NOT NULL DEFAULT '',
  `class` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`radacctid`),
  UNIQUE KEY `acctuniqueid` (`acctuniqueid`),
  KEY `username` (`username`),
  KEY `framedipaddress` (`framedipaddress`),
  KEY `framedipv6address` (`framedipv6address`),
  KEY `framedipv6prefix` (`framedipv6prefix`),
  KEY `framedinterfaceid` (`framedinterfaceid`),
  KEY `delegatedipv6prefix` (`delegatedipv6prefix`),
  KEY `acctsessionid` (`acctsessionid`),
  KEY `acctsessiontime` (`acctsessiontime`),
  KEY `acctstarttime` (`acctstarttime`),
  KEY `acctinterval` (`acctinterval`),
  KEY `acctstoptime` (`acctstoptime`),
  KEY `nasipaddress` (`nasipaddress`),
  KEY `class` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radacct`
--

INSERT INTO `radacct` VALUES (1,'05000005','a58e73232cb2c37fb29105df9cad2858','admin','','10.254.255.60','','','2024-06-13 02:54:41','2024-06-13 02:59:14','2024-06-13 02:59:14',NULL,273,'Local','','',0,0,'','','','Administrative-User','','','','','','',NULL),(2,'05000006','8e97db5e12ed1c0bb29d965d44e54c2b','admin','','10.254.255.60','','','2024-06-13 02:59:47','2024-06-13 02:59:47','2024-06-13 03:00:35',NULL,49,'Local','','',0,0,'','','','Administrative-User','','','','','','',NULL),(3,'05000007','8dc5c123212cd93eeafce38ec5a994f4','fredf','','10.254.255.60','1','Async','2024-06-13 03:04:09','2024-06-13 03:04:09','2024-06-13 03:10:32',NULL,383,'RADIUS','','',218176,8818,'','','Admin-Reset','Framed-User','PPP','10.254.255.61','','','','',NULL),(4,'05000008','72d9fcf49d355244079404d10de2618b','admin','','10.254.255.60','','','2024-06-13 03:10:17','2024-06-13 03:10:17','2024-06-13 03:10:36',NULL,20,'Local','','',0,0,'','','','Administrative-User','','','','','','',NULL),(5,'05000009','5eaafd0f9cf4dc68b7b74d43395ca8aa','fredf','','10.254.255.60','1','Async','2024-06-13 03:12:13','2024-06-13 03:12:13','2024-06-13 03:29:28',NULL,1035,'RADIUS','','',2261,3385,'','','Admin-Reset','Framed-User','PPP','10.254.255.62','','','','',NULL),(6,'0500000A','1b1c70d6cb1e3274a53eda90da584050','admin','','10.254.255.60','','','2024-06-13 03:29:16','2024-06-13 03:29:16','2024-06-13 12:04:47',NULL,30936,'Local','','',0,0,'','','','Administrative-User','','','','','','',NULL),(7,'0500000B','ba9494f53f8fec4d987892943cb4c7d3','ben','','10.254.255.60','2','Async','2024-06-13 11:50:48','2024-06-13 11:50:48','2024-06-13 11:53:49',NULL,181,'RADIUS','','',1996,796,'','','Lost-Carrier','Framed-User','PPP','10.254.255.63','','','','',NULL),(8,'0500000C','8742a4e449f380b95a71af7221d58261','ben','','10.254.255.60','2','Async','2024-06-13 12:01:58','2024-06-13 12:01:58','2024-06-13 12:02:17',NULL,19,'RADIUS','','',1366,1056,'','','Lost-Carrier','Framed-User','PPP','10.254.255.64','','','','',NULL),(9,'0500000D','a5935d059d111b2dda107f8cddb5deca','ben','','10.254.255.60','1','Async','2024-06-13 12:07:58','2024-06-13 12:07:58','2024-06-13 12:08:46',NULL,48,'RADIUS','','',1438,1516,'','','Lost-Carrier','Framed-User','PPP','10.254.255.65','','','','',NULL),(10,'0500000E','fd9ffcdfcc2bef6ab7bb702731e6d497','ben','','10.254.255.60','1','Async','2024-06-13 12:25:40','2024-06-13 12:25:40','2024-06-13 12:28:52',NULL,192,'RADIUS','','',1030,1056,'','','Lost-Carrier','Framed-User','PPP','10.254.255.68','','','','',NULL),(11,'0500000F','765167281938d6b87353f60d04888ecd','ben','','10.254.255.60','1','Async','2024-06-13 12:33:35','2024-06-13 12:33:35','2024-06-13 12:33:55',NULL,19,'RADIUS','','',1290,1316,'','','Lost-Carrier','Framed-User','PPP','10.254.255.69','','','','',NULL),(12,'05000010','129c0e91e4e3959e21f0b2f9c064ea71','ben','','10.254.255.60','2','Async','2024-06-13 12:57:22','2024-06-13 12:57:22','2024-06-13 13:00:27',NULL,185,'RADIUS','','',11763,11792,'','','Lost-Carrier','Framed-User','PPP','10.254.255.61','','','','',NULL);

--
-- Table structure for table `radcheck`
--

CREATE TABLE `radcheck` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '==',
  `value` varchar(253) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `username` (`username`(32))
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radcheck`
--

INSERT INTO `radcheck` VALUES (1,'fredf','Cleartext-Password',':=','wilma'),(2,'steve','MD5-Password',':=','7e39cfce74d155294619613f42484f18'),(3,'steve2','MD5-Password',':=','b43dc42f4a3a6729cab6584e854d436e'),(4,'mark','MD5-Password',':=','ea82410c7a9991816b5eeeebe195e20a'),(5,'ben','MD5-Password',':=','b50c0fd3adfc786454d7beacc16ceaf2');

--
-- Table structure for table `radgroupcheck`
--

CREATE TABLE `radgroupcheck` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '==',
  `value` varchar(253) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `groupname` (`groupname`(32))
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radgroupcheck`
--


--
-- Table structure for table `radgroupreply`
--

CREATE TABLE `radgroupreply` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '=',
  `value` varchar(253) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `groupname` (`groupname`(32))
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radgroupreply`
--

INSERT INTO `radgroupreply` VALUES (10,'dynamic','Framed-Compression',':=','Van-Jacobson-TCP-IP'),(11,'dynamic','Framed-Protocol',':=','PPP'),(12,'dynamic','Service-Type',':=','Framed-User'),(13,'dynamic','Framed-MTU',':=','1500');

--
-- Table structure for table `radpostauth`
--

CREATE TABLE `radpostauth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL DEFAULT '',
  `pass` varchar(64) NOT NULL DEFAULT '',
  `reply` varchar(32) NOT NULL DEFAULT '',
  `authdate` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `class` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `username` (`username`),
  KEY `class` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radpostauth`
--

INSERT INTO `radpostauth` VALUES (1,'steve','test','Access-Reject','2024-06-09 23:36:03.504036',NULL),(2,'steve','test','Access-Reject','2024-06-10 22:25:27.937670',NULL),(3,'steve','test','Access-Accept','2024-06-10 22:34:01.525868',NULL),(4,'steve','test2','Access-Reject','2024-06-10 22:34:23.363731',NULL),(5,'steve','test2','Access-Reject','2024-06-12 00:09:14.670793',NULL),(6,'steve','test2','Access-Reject','2024-06-12 00:09:18.766216',NULL),(7,'steve','test2','Access-Reject','2024-06-12 00:09:20.619776',NULL),(8,'steve','test2','Access-Reject','2024-06-12 00:09:22.342398',NULL),(9,'steve','test2','Access-Reject','2024-06-12 00:09:31.436273',NULL),(10,'steve','test2','Access-Reject','2024-06-12 00:09:33.216498',NULL),(11,'steve','test22','Access-Reject','2024-06-12 00:09:41.257008',NULL),(12,'steve','test22','Access-Reject','2024-06-12 00:09:43.378101',NULL),(13,'steve','test22','Access-Reject','2024-06-12 00:09:45.010395',NULL),(14,'steve','test22','Access-Reject','2024-06-12 00:09:46.616255',NULL),(15,'steve','test22','Access-Reject','2024-06-12 00:09:48.420935',NULL),(16,'steve','test22','Access-Reject','2024-06-12 00:09:50.211125',NULL),(17,'steve','test22','Access-Reject','2024-06-12 00:09:51.818569',NULL),(18,'steve','test22','Access-Reject','2024-06-12 00:14:48.223409',NULL),(19,'steve','test22','Access-Reject','2024-06-12 00:14:49.928171',NULL),(20,'steve','test22','Access-Reject','2024-06-12 00:14:51.507829',NULL),(21,'steve','test22','Access-Reject','2024-06-12 00:14:53.326091',NULL),(22,'steve','test22','Access-Reject','2024-06-12 00:14:56.036346',NULL),(23,'fredf','wilma','Access-Accept','2024-06-12 23:04:07.919009',NULL),(24,'fredf','wilma','Access-Accept','2024-06-12 23:12:11.486385',NULL),(25,'ben','s3rialp0rt','Access-Accept','2024-06-13 07:50:46.261788',NULL),(26,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:01:57.121667',NULL),(27,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:07:56.798173',NULL),(28,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:13:38.116025',NULL),(29,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:22:36.986637',NULL),(30,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:25:39.138106',NULL),(31,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:33:34.062863',NULL),(32,'ben','s3rialp0rt','Access-Accept','2024-06-13 08:57:20.596129',NULL);

--
-- Table structure for table `radreply`
--

CREATE TABLE `radreply` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL DEFAULT '',
  `attribute` varchar(64) NOT NULL DEFAULT '',
  `op` char(2) NOT NULL DEFAULT '=',
  `value` varchar(253) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `username` (`username`(32))
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radreply`
--


--
-- Table structure for table `radusergroup`
--

CREATE TABLE `radusergroup` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL DEFAULT '',
  `groupname` varchar(64) NOT NULL DEFAULT '',
  `priority` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `username` (`username`(32))
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radusergroup`
--

INSERT INTO `radusergroup` VALUES (1,'steve2','dynamic',1),(2,'steve','dynamic',1),(3,'fredf','dynamic',1),(4,'mark','dynamic',1),(5,'ben','dynamic',1);


