--
-- Database: `loraserv`
--

ATTACH DATABASE '/tmp/loraserv' As 'loraserv';

-- --------------------------------------------------------

--
-- Table structure for table `lastjoininfo`
--

CREATE TABLE IF NOT EXISTS `lastjoininfo` (
  `deveui` varchar(16) PRIMARY KEY NOT NULL,
  `tmst` bigint(16) DEFAULT NULL,
  `devnoce` int(10) DEFAULT NULL,
  `upcnt` int(10) DEFAULT NULL
);

--
-- Table structure for table `transarg`
--

CREATE TABLE IF NOT EXISTS `transarg` (
  `deveui` varchar(16) PRIMARY KEY NOT NULL,
  `gwaddr` varchar(32) NOT NULL,
  `delay` int(10) NOT NULL,
  `rx1datarate` int(10) NOT NULL,
  `rx2datarate` int(10) NOT NULL,
  `rx2freq` float NOT NULL
);
