aboutsummaryrefslogtreecommitdiffstats
path: root/admin/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-02-03 00:00:01 +0000
committerz0rglub <z0rglub@piwigo.org>2004-02-03 00:00:01 +0000
commit1d9b840cf8421ad06d81035f209149eceb1b357f (patch)
tree7527a604993949919a3d71777d6b96fc9af62ba3 /admin/phpwebgallery_structure.sql
parentdaec9819eaa79bb6eebc4fb789cdc0cc43e8b6ba (diff)
2004.02.03_01h00 : auto commit
git-svn-id: http://piwigo.org/svn/trunk@347 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/phpwebgallery_structure.sql')
-rw-r--r--admin/phpwebgallery_structure.sql25
1 files 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;
--
@@ -194,19 +189,6 @@ CREATE TABLE phpwebgallery_user_access (
) 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;