CREATE TABLE IF NOT EXISTS `lolli_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email_1` text,
  `email_2` text,
  `enabled` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `lolli_config` (`id`, `email_1`, `email_2`, `enabled`) VALUES
(1, 'info@bitonlive.com', 'info@bitonlive.com', 0);

CREATE TABLE IF NOT EXISTS `lolli_editions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `idtype` int(11) DEFAULT NULL,
  `timeedition` int(11) DEFAULT NULL,
  `maxtimeup` int(11) DEFAULT NULL,
  `days` varchar(7) DEFAULT NULL,
  `path` varchar(500) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `lolli_editionstype` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `lolli_historylog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) DEFAULT NULL,
  `password` varchar(245) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  `date1` datetime DEFAULT NULL,
  `pwd` varchar(245) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `lolli_uploads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dateup` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `idedition` int(11) DEFAULT NULL,
  `dateedition` varchar(45) DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `filename` varchar(245) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `lolli_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `lastname` varchar(45) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `password` varchar(245) DEFAULT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `enabled` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

INSERT INTO `lolli_users` (`id`, `name`, `lastname`, `email`, `password`, `level`, `enabled`) VALUES
(1, '.', 'admin', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 1, 1);


CREATE TABLE IF NOT EXISTS `lolli_editionsuser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iduser` int(11) NOT NULL,
  `idedition` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;