-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Mar 26 Juillet 2016 à 19:22
-- Version du serveur: 5.5.38
-- Version de PHP: 5.4.45-0+deb7u1




--
-- Base de données: `com`
--

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

--
-- Structure de la table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(25) NOT NULL,
  `pass` varchar(128) NOT NULL,
  `name` varchar(40) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `admlvl` tinyint(1) NOT NULL,
  `ugroup` tinyint(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `admins`
--

INSERT INTO `admins` (`id`, `user`, `pass`, `name`, `enabled`, `admlvl`, `ugroup`) VALUES
(1, 'admin', '450e14f936aa5a70150184303433d2f463695f53190f788e2c4c1142267d6402', '', 1, 0, 0);

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

--
-- Structure de la table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) DEFAULT NULL,
  `comment` varchar(50) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Contenu de la table `groups`
--

INSERT INTO `groups` (`id`, `name`, `comment`, `enabled`) VALUES
(1, 'CCcam', '', 1),
(2, 'Mgcamd', '', 1),
(3, 'Newcamd', '', 1),
(4, 'CS378X', '', 1),
(5, 'SERVER', '', 1);

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

--
-- Structure de la table `log_activity`
--

CREATE TABLE IF NOT EXISTS `log_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activity` tinyint(1) DEFAULT NULL,
  `adminid` int(11) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `data` varchar(50) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `log_genxmlreq`
--

CREATE TABLE IF NOT EXISTS `log_genxmlreq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(45) DEFAULT NULL,
  `genxmlkey` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `log_login`
--

CREATE TABLE IF NOT EXISTS `log_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(45) NOT NULL,
  `user` varchar(25) NOT NULL,
  `pass` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `profiles`
--

CREATE TABLE IF NOT EXISTS `profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) DEFAULT NULL,
  `cspvalue` varchar(25) DEFAULT NULL,
  `comment` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `profiles`
--

INSERT INTO `profiles` (`id`, `name`, `cspvalue`, `comment`) VALUES
(1, 'All', '', '');

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

--
-- Structure de la table `server`
--

CREATE TABLE IF NOT EXISTS `server` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `displayname` varchar(50) DEFAULT NULL,
  `ipmask` varchar(15) DEFAULT NULL,
  `profiles` varchar(500) DEFAULT NULL,
  `maxconn` varchar(4) DEFAULT NULL,
  `admin` varchar(1) DEFAULT NULL,
  `enabled` varchar(1) DEFAULT NULL,
  `mapexclude` varchar(1) DEFAULT NULL,
  `debug` varchar(1) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `email` varchar(254) DEFAULT NULL,
  `customvalues` varchar(255) DEFAULT NULL,
  `ecmrate` varchar(4) DEFAULT NULL,
  `startdate` date DEFAULT NULL,
  `expiredate` date DEFAULT NULL,
  `usrgroup` varchar(6) DEFAULT NULL,
  `boxtype` varchar(30) DEFAULT NULL,
  `macaddress` varchar(23) DEFAULT NULL,
  `serialnumber` varchar(128) DEFAULT NULL,
  `added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `addedby` varchar(4) DEFAULT NULL,
  `changed` timestamp NULL DEFAULT NULL,
  `changedby` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

--
-- Structure de la table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `cmumversion` varchar(8) NOT NULL,
  `servername` varchar(25) DEFAULT NULL,
  `timeout` varchar(4) NOT NULL,
  `rndstring` varchar(75) DEFAULT NULL,
  `rndstringlength` varchar(2) DEFAULT NULL,
  `loglogins` tinyint(1) DEFAULT NULL,
  `logactivity` tinyint(1) DEFAULT NULL,
  `cleanlogin` tinyint(1) DEFAULT NULL,
  `genxmlkey` varchar(50) DEFAULT NULL,
  `genxmlusrgrp` tinyint(1) DEFAULT NULL,
  `genxmllogreq` tinyint(1) DEFAULT NULL,
  `genxmldateformat` varchar(10) DEFAULT NULL,
  `genxmlintstrexp` tinyint(1) DEFAULT NULL,
  `def_autoload` tinyint(1) DEFAULT NULL,
  `def_ipmask` varchar(15) DEFAULT NULL,
  `def_profiles` varchar(500) DEFAULT NULL,
  `def_maxconn` varchar(4) DEFAULT NULL,
  `def_admin` varchar(1) DEFAULT NULL,
  `def_enabled` varchar(1) DEFAULT NULL,
  `def_mapexc` varchar(1) DEFAULT NULL,
  `def_debug` varchar(1) DEFAULT NULL,
  `def_custcspval` varchar(255) DEFAULT NULL,
  `def_ecmrate` varchar(4) DEFAULT NULL,
  `fetchcsp` tinyint(1) DEFAULT NULL,
  `cspsrv_ip` varchar(255) DEFAULT NULL,
  `cspsrv_port` varchar(6) DEFAULT NULL,
  `cspsrv_user` varchar(30) DEFAULT NULL,
  `cspsrv_pass` varchar(30) DEFAULT NULL,
  `cspsrv_protocol` tinyint(1) DEFAULT NULL,
  `comptables` tinyint(1) DEFAULT NULL,
  `extrausrtbl` tinyint(1) DEFAULT NULL,
  `notstartusrorder` varchar(4) DEFAULT NULL,
  `expusrorder` varchar(4) DEFAULT NULL,
  `soonexpusrorder` varchar(4) DEFAULT NULL,
  `autoupdcheck` tinyint(1) DEFAULT NULL,
  `usrorderby` varchar(12) DEFAULT NULL,
  `usrorder` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `settings`
--

INSERT INTO `settings` (`id`, `cmumversion`, `servername`, `timeout`, `rndstring`, `rndstringlength`, `loglogins`, `logactivity`, `cleanlogin`, `genxmlkey`, `genxmlusrgrp`, `genxmllogreq`, `genxmldateformat`, `genxmlintstrexp`, `def_autoload`, `def_ipmask`, `def_profiles`, `def_maxconn`, `def_admin`, `def_enabled`, `def_mapexc`, `def_debug`, `def_custcspval`, `def_ecmrate`, `fetchcsp`, `cspsrv_ip`, `cspsrv_port`, `cspsrv_user`, `cspsrv_pass`, `cspsrv_protocol`, `comptables`, `extrausrtbl`, `notstartusrorder`, `expusrorder`, `soonexpusrorder`, `autoupdcheck`, `usrorderby`, `usrorder`) VALUES
(1, '1.1', '', '600', '', '', 0, 0, 0, '', 0, 0, 'd-m-Y', 0, 0, '', 'N;', '', '', '', '', '', '', '', 0, '', '', '', '', 0, 0, 3, 'asc', 'asc', 'asc', 0, 'user', 'asc');

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

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(30) DEFAULT NULL,
  `password` varchar(30) DEFAULT NULL,
  `displayname` varchar(50) DEFAULT NULL,
  `ipmask` varchar(15) DEFAULT NULL,
  `profiles` varchar(500) DEFAULT NULL,
  `maxconn` varchar(4) DEFAULT NULL,
  `admin` varchar(1) DEFAULT NULL,
  `enabled` varchar(1) DEFAULT NULL,
  `mapexclude` varchar(1) DEFAULT NULL,
  `debug` varchar(1) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `email` varchar(254) DEFAULT NULL,
  `customvalues` varchar(255) DEFAULT NULL,
  `ecmrate` varchar(4) DEFAULT NULL,
  `startdate` date DEFAULT NULL,
  `expiredate` date DEFAULT NULL,
  `usrgroup` varchar(6) DEFAULT NULL,
  `boxtype` varchar(30) DEFAULT NULL,
  `macaddress` varchar(23) DEFAULT NULL,
  `serialnumber` varchar(128) DEFAULT NULL,
  `added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `addedby` varchar(4) DEFAULT NULL,
  `changed` timestamp NULL DEFAULT NULL,
  `changedby` varchar(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `user`, `password`, `displayname`, `ipmask`, `profiles`, `maxconn`, `admin`, `enabled`, `mapexclude`, `debug`, `comment`, `email`, `customvalues`, `ecmrate`, `startdate`, `expiredate`, `usrgroup`, `boxtype`, `macaddress`, `serialnumber`, `added`, `addedby`, `changed`, `changedby`) VALUES
(4, 'cccam', 'pass', '', '', 'N;', '', '', '1', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '1', '', '', '', '2016-07-26 15:20:38', '1', '0000-00-00 00:00:00', ''),
(5, 'mgcamd', 'pass', '', '', 'N;', '', '', '1', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '2', '', '', '', '2016-07-26 15:20:57', '1', '0000-00-00 00:00:00', ''),
(6, 'newcamd', 'passe', '', '', 'N;', '', '', '1', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '3', '', '', '', '2016-07-26 15:21:35', '1', '0000-00-00 00:00:00', ''),
(7, 'camd', 'passe', '', '', 'N;', '', '', '1', '', '', '', '', '', '', '0000-00-00', '0000-00-00', '4', '', '', '', '2016-07-26 15:21:49', '1', '0000-00-00 00:00:00', '');

