CREATE TABLE `phpwebgallery_categories` ( 
  `date_dernier` date NOT NULL default '0000-00-00', 
  `nb_images` smallint(5) unsigned NOT NULL default '0', 
  `name` varchar(255) default NULL, 
  `id_uppercat` tinyint(3) unsigned default NULL, 
  `id` tinyint(3) unsigned NOT NULL auto_increment, 
  `comment` text, 
  `dir` varchar(255) NOT NULL default '', 
  `rank` tinyint(3) unsigned default NULL, 
  `status` enum('visible','invisible') NOT NULL default 'visible', 
  PRIMARY KEY  (`id`) 
) TYPE=MyISAM; 
# -------------------------------------------------------- 
 
# 
# Table structure for table `phpwebgallery_config` 
# 
 
CREATE TABLE `phpwebgallery_config` ( 
  `periode_courte` smallint(5) unsigned NOT NULL default '7', 
  `periode_longue` smallint(5) unsigned NOT NULL default '14', 
  `prefixe_thumbnail` varchar(10) NOT NULL default 'TN-', 
  `webmaster` varchar(255) NOT NULL default '', 
  `mail_webmaster` varchar(255) NOT NULL default '', 
  `acces` enum('libre','restreint') NOT NULL default 'libre', 
  `session_id_size` tinyint(3) unsigned NOT NULL default '4', 
  `session_keyword` varchar(255) NOT NULL default '', 
  `session_time` tinyint(3) unsigned NOT NULL default '30', 
  `max_user_listbox` tinyint(3) unsigned NOT NULL default '10', 
  `expand` enum('true','false') NOT NULL default 'false' 
) TYPE=MyISAM; 
# -------------------------------------------------------- 
 
# 
# Table structure for table `phpwebgallery_history` 
# 
 
CREATE TABLE `phpwebgallery_history` ( 
  `date` int(11) NOT NULL default '0', 
  `login` varchar(15) default NULL, 
  `IP` varchar(50) NOT NULL default '', 
  `categorie` varchar(150) default NULL, 
  `page` varchar(50) default NULL, 
  `titre` varchar(150) default NULL, 
  `commentaire` varchar(200) default NULL 
) TYPE=MyISAM; 
# -------------------------------------------------------- 
 
# 
# Table structure for table `phpwebgallery_images` 
# 
 
CREATE TABLE `phpwebgallery_images` ( 
  `id` smallint(5) unsigned NOT NULL auto_increment, 
  `file` varchar(255) NOT NULL default '', 
  `cat_id` tinyint(3) unsigned NOT NULL default '0', 
  `date_available` date NOT NULL default '0000-00-00', 
  `date_creation` date default NULL, 
  `tn_ext` char(3) NOT NULL default 'jpg', 
  `name` varchar(255) default NULL, 
  `comment` varchar(255) default NULL, 
  `author` varchar(255) default NULL, 
  `hit` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`id`), 
  KEY `cat_id` (`cat_id`) 
) TYPE=MyISAM; 
# -------------------------------------------------------- 
 
# 
# Table structure for table `phpwebgallery_restrictions` 
# 
 
CREATE TABLE `phpwebgallery_restrictions` ( 
  `user_id` tinyint(3) NOT NULL default '0', 
  `cat_id` tinyint(3) NOT NULL default '0', 
  PRIMARY KEY  (`user_id`,`cat_id`) 
) TYPE=MyISAM; 
# -------------------------------------------------------- 
 
# 
# Table structure for table `phpwebgallery_sessions` 
# 
 
CREATE TABLE `phpwebgallery_sessions` ( 
  `id` varchar(255) binary NOT NULL default '', 
  `user_id` smallint(5) unsigned NOT NULL default '0', 
  `expiration` int(10) unsigned NOT NULL default '0', 
  `ip` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`id`) 
) TYPE=MyISAM; 
# -------------------------------------------------------- 
 
# 
# Table structure for table `phpwebgallery_users` 
# 
 
CREATE TABLE `phpwebgallery_users` ( 
  `id` smallint(5) unsigned NOT NULL auto_increment, 
  `pseudo` varchar(20) binary NOT NULL default '', 
  `password` varchar(255) NOT NULL default '', 
  `nombre_image_ligne` tinyint(1) unsigned NOT NULL default '5', 
  `nombre_ligne_page` tinyint(3) unsigned NOT NULL default '3', 
  `theme` varchar(255) NOT NULL default 'eexell/coldblue', 
  `sexe` enum('M','F') NOT NULL default 'M', 
  `status` enum('admin','membre','visiteur') NOT NULL default 'visiteur', 
  `language` varchar(50) NOT NULL default 'english', 
  `maxwidth` smallint(6) default NULL, 
  `maxheight` smallint(6) default NULL, 
  PRIMARY KEY  (`id`), 
  UNIQUE KEY `pseudo` (`pseudo`) 
) TYPE=MyISAM; 
 
 
INSERT INTO phpwebgallery_config VALUES (7, 14, 'TN-', 'webmaster', 'webmaster@domain.com', 'libre', 6, '', 30, 10, 'true'); 
 
INSERT INTO phpwebgallery_users VALUES (1, 'webmaster', 'd41d8cd98f00b204e9800998ecf8427e', 7, 4, 'eexell/coldblue', 'M', 'admin', 'english', NULL, NULL); 
INSERT INTO phpwebgallery_users VALUES (2, 'visiteur', 'd41d8cd98f00b204e9800998ecf8427e', 4, 2, 'eexell/coldblue', 'M', 'visiteur', 'english', NULL, NULL);