move admin/phpwebgallery_structure.sql to install/phpwebgallery_structure.sql

git-svn-id: http://piwigo.org/svn/trunk@381 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 0 insertions, 263 deletions

diff --git a/admin/phpwebgallery_structure.sql b/admin/phpwebgallery_structure.sql
deleted file mode 100644
index 7f73acc73..000000000
--- a/admin/phpwebgallery_structure.sql
+++ /dev/null
@@ -1,263 +0,0 @@
--- 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;
-