aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--admin/phpwebgallery_structure.sql244
1 files changed, 0 insertions, 244 deletions
diff --git a/admin/phpwebgallery_structure.sql b/admin/phpwebgallery_structure.sql
index d6797c162..e69de29bb 100644
--- a/admin/phpwebgallery_structure.sql
+++ b/admin/phpwebgallery_structure.sql
@@ -1,244 +0,0 @@
--- MySQL dump 8.21
---
--- Host: localhost Database: devel
----------------------------------------------------------
--- 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,
- PRIMARY KEY (id)
-) 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',
- KEY user_id (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)
-) 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 galleries_url (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_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',
- PRIMARY KEY (id),
- UNIQUE KEY username (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;
-