diff options
Diffstat (limited to 'install')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 263 |
1 files changed, 263 insertions, 0 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql new file mode 100644 index 000000000..7f73acc73 --- /dev/null +++ b/install/phpwebgallery_structure.sql @@ -0,0 +1,263 @@ +-- MySQL dump 8.21 +-- +-- Host: localhost Database: pwg-bsf +--------------------------------------------------------- +-- Server version 3.23.49-log + +-- +-- Table structure for table 'phpwebgallery_categories' +-- + +DROP TABLE IF EXISTS phpwebgallery_categories; +CREATE TABLE phpwebgallery_categories ( + id smallint(5) unsigned NOT NULL auto_increment, + date_last date default NULL, + nb_images mediumint(8) unsigned NOT NULL default '0', + name varchar(255) NOT NULL default '', + id_uppercat smallint(5) unsigned default NULL, + comment text, + dir varchar(255) default NULL, + rank tinyint(3) unsigned default NULL, + status enum('public','private') NOT NULL default 'public', + site_id tinyint(4) unsigned NOT NULL default '1', + visible enum('true','false') NOT NULL default 'true', + uploadable enum('true','false') NOT NULL default 'false', + representative_picture_id mediumint(8) unsigned default NULL, + uppercats varchar(255) NOT NULL default '', + PRIMARY KEY (id), + KEY categories_i1 (id), + KEY categories_i2 (id_uppercat) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_comments' +-- + +DROP TABLE IF EXISTS phpwebgallery_comments; +CREATE TABLE phpwebgallery_comments ( + id int(11) unsigned NOT NULL auto_increment, + image_id mediumint(8) unsigned NOT NULL default '0', + date int(11) unsigned NOT NULL default '0', + author varchar(255) default NULL, + content longtext, + validated enum('true','false') NOT NULL default 'false', + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_config' +-- + +DROP TABLE IF EXISTS phpwebgallery_config; +CREATE TABLE phpwebgallery_config ( + prefix_thumbnail varchar(10) default 'TN-', + webmaster varchar(255) NOT NULL default '', + mail_webmaster varchar(255) NOT NULL default '', + access enum('free','restricted') default 'free', + session_id_size tinyint(3) unsigned NOT NULL default '4', + session_keyword varchar(255) default NULL, + session_time tinyint(3) unsigned NOT NULL default '30', + max_user_listbox tinyint(3) unsigned NOT NULL default '10', + show_comments enum('true','false') NOT NULL default 'true', + nb_comment_page tinyint(4) NOT NULL default '10', + upload_available enum('true','false') NOT NULL default 'false', + upload_maxfilesize smallint(5) unsigned NOT NULL default '150', + upload_maxwidth smallint(5) unsigned NOT NULL default '800', + upload_maxheight smallint(5) unsigned NOT NULL default '600', + upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150', + upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100', + log enum('true','false') NOT NULL default 'false', + comments_validation enum('true','false') NOT NULL default 'false', + comments_forall enum('true','false') NOT NULL default 'false', + authorize_cookies enum('true','false') NOT NULL default 'false', + mail_notification enum('true','false') NOT NULL default 'false' +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_favorites' +-- + +DROP TABLE IF EXISTS phpwebgallery_favorites; +CREATE TABLE phpwebgallery_favorites ( + user_id smallint(5) unsigned NOT NULL default '0', + image_id mediumint(8) unsigned NOT NULL default '0', + PRIMARY KEY (user_id,image_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_group_access' +-- + +DROP TABLE IF EXISTS phpwebgallery_group_access; +CREATE TABLE phpwebgallery_group_access ( + group_id smallint(5) unsigned NOT NULL default '0', + cat_id smallint(5) unsigned NOT NULL default '0', + PRIMARY KEY (group_id,cat_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_groups' +-- + +DROP TABLE IF EXISTS phpwebgallery_groups; +CREATE TABLE phpwebgallery_groups ( + id smallint(5) unsigned NOT NULL auto_increment, + name varchar(255) NOT NULL default '', + PRIMARY KEY (id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_history' +-- + +DROP TABLE IF EXISTS phpwebgallery_history; +CREATE TABLE phpwebgallery_history ( + date int(11) NOT NULL default '0', + login varchar(15) default NULL, + IP varchar(50) NOT NULL default '', + category varchar(150) default NULL, + file varchar(50) default NULL, + picture varchar(150) default NULL +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_image_category' +-- + +DROP TABLE IF EXISTS phpwebgallery_image_category; +CREATE TABLE phpwebgallery_image_category ( + image_id mediumint(8) unsigned NOT NULL default '0', + category_id smallint(5) unsigned NOT NULL default '0', + PRIMARY KEY (image_id,category_id), + KEY image_category_i1 (image_id), + KEY image_category_i2 (category_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_images' +-- + +DROP TABLE IF EXISTS phpwebgallery_images; +CREATE TABLE phpwebgallery_images ( + id mediumint(8) unsigned NOT NULL auto_increment, + file varchar(255) NOT NULL default '', + 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 text, + author varchar(255) default NULL, + hit int(10) unsigned NOT NULL default '0', + filesize mediumint(9) unsigned default NULL, + width smallint(9) unsigned default NULL, + height smallint(9) unsigned default NULL, + keywords varchar(255) default NULL, + storage_category_id smallint(5) unsigned default NULL, + PRIMARY KEY (id), + KEY storage_category_id (storage_category_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_sessions' +-- + +DROP TABLE IF EXISTS 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_sites' +-- + +DROP TABLE IF EXISTS phpwebgallery_sites; +CREATE TABLE phpwebgallery_sites ( + id tinyint(4) NOT NULL auto_increment, + galleries_url varchar(255) NOT NULL default '', + PRIMARY KEY (id), + UNIQUE KEY sites_ui1 (galleries_url) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_user_access' +-- + +DROP TABLE IF EXISTS phpwebgallery_user_access; +CREATE TABLE phpwebgallery_user_access ( + user_id smallint(5) unsigned NOT NULL default '0', + cat_id smallint(5) unsigned NOT NULL default '0', + PRIMARY KEY (user_id,cat_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_user_category' +-- + +DROP TABLE IF EXISTS phpwebgallery_user_category; +CREATE TABLE phpwebgallery_user_category ( + user_id smallint(5) unsigned NOT NULL default '0', + category_id smallint(5) unsigned NOT NULL default '0', + date_last date default NULL, + nb_sub_categories smallint(5) unsigned NOT NULL default '0', + PRIMARY KEY (user_id,category_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_user_group' +-- + +DROP TABLE IF EXISTS phpwebgallery_user_group; +CREATE TABLE phpwebgallery_user_group ( + user_id smallint(5) unsigned NOT NULL default '0', + group_id smallint(5) unsigned NOT NULL default '0', + PRIMARY KEY (group_id,user_id) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_users' +-- + +DROP TABLE IF EXISTS phpwebgallery_users; +CREATE TABLE phpwebgallery_users ( + id smallint(5) unsigned NOT NULL auto_increment, + username varchar(20) binary NOT NULL default '', + password varchar(255) NOT NULL default '', + mail_address varchar(255) default NULL, + nb_image_line tinyint(1) unsigned NOT NULL default '5', + nb_line_page tinyint(3) unsigned NOT NULL default '3', + status enum('admin','guest') NOT NULL default 'guest', + language varchar(50) NOT NULL default 'english', + maxwidth smallint(6) default NULL, + maxheight smallint(6) default NULL, + expand enum('true','false') NOT NULL default 'false', + show_nb_comments enum('true','false') NOT NULL default 'false', + short_period tinyint(3) unsigned NOT NULL default '7', + long_period tinyint(3) unsigned NOT NULL default '14', + template varchar(255) NOT NULL default 'default', + forbidden_categories text, + PRIMARY KEY (id), + UNIQUE KEY users_ui1 (username) +) TYPE=MyISAM; + +-- +-- Table structure for table 'phpwebgallery_waiting' +-- + +DROP TABLE IF EXISTS phpwebgallery_waiting; +CREATE TABLE phpwebgallery_waiting ( + id int(10) unsigned NOT NULL auto_increment, + storage_category_id smallint(5) unsigned NOT NULL default '0', + file varchar(255) NOT NULL default '', + username varchar(255) NOT NULL default '', + mail_address varchar(255) NOT NULL default '', + date int(10) unsigned NOT NULL default '0', + tn_ext char(3) default NULL, + validated enum('true','false') NOT NULL default 'false', + infos text, + PRIMARY KEY (id) +) TYPE=MyISAM; + |