Log Server Database Import

-- Server Log Viewer DB Dump
-- version 4.7.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `logserver`
--

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

--
-- Table structure for table `lv_banlist`
--

CREATE TABLE `lv_banlist` (
  `banid` INT(11) NOT NULL,
  `ipaddress` VARCHAR(40) COLLATE utf8_bin NOT NULL,
  `time` BIGINT(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `lv_groups`
--

CREATE TABLE `lv_groups` (
  `groupid` INT(11) NOT NULL,
  `groupname` VARCHAR(25) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `lv_groups`
--

INSERT INTO `lv_groups` (`groupid`, `groupname`) VALUES
(1, 'op'),
(2, 'admin'),
(3, 'mod'),
(4, 'default');

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

--
-- Table structure for table `lv_permissions`
--

CREATE TABLE `lv_permissions` (
  `permid` INT(11) NOT NULL,
  `userid` INT(11) DEFAULT NULL,
  `groupid` INT(11) DEFAULT NULL,
  `permission` VARCHAR(50) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `lv_permissions`
--

INSERT INTO `lv_permissions` (`permid`, `userid`, `groupid`, `permission`) VALUES
(1, NULL, 1, 'logserver *'),
(2, NULL, 1, '*'),
(3, NULL, 2, '-stop'),
(4, NULL, 2, '-op'),
(5, NULL, 2, '-deop'),
(6, NULL, 2, '*'),
(7, NULL, 3, 'ban'),
(8, NULL, 3, 'mute'),
(9, NULL, 3, 'kick'),
(10, NULL, 3, 'jail'),
(11, NULL, 4, 'logserver help'),
(12, NULL, 4, 'logserver getprevious'),
(13, NULL, 4, 'list'),
(14, NULL, 4, 'help'),
(15, NULL, 4, '?');

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

--
-- Table structure for table `lv_subscriptions`
--

CREATE TABLE `lv_subscriptions` (
  `subid` INT(11) NOT NULL,
  `userid` INT(11) DEFAULT NULL,
  `groupid` INT(11) DEFAULT NULL,
  `subgroupid` INT(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `lv_subscriptions`
--

INSERT INTO `lv_subscriptions` (`subid`, `userid`, `groupid`, `subgroupid`) VALUES
(1, NULL, 1, 2),
(2, NULL, 2, 3),
(3, NULL, 3, 4),
(5, 1, NULL, 1);

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

--
-- Table structure for table `lv_users`
--

CREATE TABLE `lv_users` (
  `userid` INT(11) NOT NULL,
  `username` VARCHAR(25) COLLATE utf8_bin NOT NULL,
  `salt` VARCHAR(16) COLLATE utf8_bin NOT NULL,
  `passhash` VARCHAR(64) COLLATE utf8_bin NOT NULL,
  `login_fails` INT(11) NOT NULL DEFAULT '0',
  `last_fail` BIGINT(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `lv_users`
--

INSERT INTO `lv_users` (`userid`, `username`, `salt`, `passhash`, `login_fails`, `last_fail`) VALUES
(1, 'admin', 'ac426944344d3752', '077a529aa4f4006be9e44475d3bf5741f6c68e90e9638e20270f5a2762b8d995', 0, NULL);

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

--
-- Table structure for table `lv_whitelist`
--

CREATE TABLE `lv_whitelist` (
  `whitelistid` INT(11) NOT NULL,
  `userid` INT(11) NOT NULL,
  `ipaddress` VARCHAR(40) COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `lv_whitelist`
--


--
-- Indexes for dumped tables
--

--
-- Indexes for table `lv_banlist`
--
ALTER TABLE `lv_banlist`
  ADD PRIMARY KEY (`banid`),
  ADD UNIQUE KEY `ipaddress` (`ipaddress`);

--
-- Indexes for table `lv_groups`
--
ALTER TABLE `lv_groups`
  ADD PRIMARY KEY (`groupid`),
  ADD UNIQUE KEY `groupname` (`groupname`);

--
-- Indexes for table `lv_permissions`
--
ALTER TABLE `lv_permissions`
  ADD PRIMARY KEY (`permid`);

--
-- Indexes for table `lv_subscriptions`
--
ALTER TABLE `lv_subscriptions`
  ADD PRIMARY KEY (`subid`);

--
-- Indexes for table `lv_users`
--
ALTER TABLE `lv_users`
  ADD PRIMARY KEY (`userid`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `lv_whitelist`
--
ALTER TABLE `lv_whitelist`
  ADD PRIMARY KEY (`whitelistid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `lv_banlist`
--
ALTER TABLE `lv_banlist`
  MODIFY `banid` INT(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lv_groups`
--
ALTER TABLE `lv_groups`
  MODIFY `groupid` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `lv_permissions`
--
ALTER TABLE `lv_permissions`
  MODIFY `permid` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `lv_subscriptions`
--
ALTER TABLE `lv_subscriptions`
  MODIFY `subid` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `lv_users`
--
ALTER TABLE `lv_users`
  MODIFY `userid` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `lv_whitelist`
--
ALTER TABLE `lv_whitelist`
  MODIFY `whitelistid` INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;