From 1d9b840cf8421ad06d81035f209149eceb1b357f Mon Sep 17 00:00:00 2001 From: z0rglub Date: Tue, 3 Feb 2004 00:00:01 +0000 Subject: 2004.02.03_01h00 : auto commit git-svn-id: http://piwigo.org/svn/trunk@347 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/phpwebgallery_structure.sql | 25 +++---------------------- 1 file changed, 3 insertions(+), 22 deletions(-) diff --git a/admin/phpwebgallery_structure.sql b/admin/phpwebgallery_structure.sql index d1c5343a6..d6797c162 100644 --- a/admin/phpwebgallery_structure.sql +++ b/admin/phpwebgallery_structure.sql @@ -1,6 +1,6 @@ -- MySQL dump 8.21 -- --- Host: localhost Database: perfs_test +-- Host: localhost Database: devel --------------------------------------------------------- -- Server version 3.23.49-log @@ -23,10 +23,7 @@ CREATE TABLE phpwebgallery_categories ( 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 id (id), - KEY id_uppercat (id_uppercat) + PRIMARY KEY (id) ) TYPE=MyISAM; -- @@ -128,9 +125,7 @@ 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 category_id (category_id), - KEY image_id (image_id) + PRIMARY KEY (image_id,category_id) ) TYPE=MyISAM; -- @@ -193,19 +188,6 @@ CREATE TABLE phpwebgallery_user_access ( 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' -- @@ -238,7 +220,6 @@ CREATE TABLE phpwebgallery_users ( 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 username (username) ) TYPE=MyISAM; -- cgit v1.2.3