-- 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




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

--
-- 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 `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', '', '');

