Changeset 347

Timestamp:

Feb 3, 2004, 1:00:01 AM (20 years ago)

Author:

z0rglub

Message:

2004.02.03_01h00 : auto commit

File:

• trunk/admin/phpwebgallery_structure.sql (modified) (5 diffs)

trunk/admin/phpwebgallery_structure.sql

@@ -1 +1 @@
 -- MySQL dump 8.21
 --
--- Host: localhost    Database: perfs_test
+-- Host: localhost    Database: devel
 ---------------------------------------------------------
 -- Server version       3.23.49-log
@@ -24 +24 @@
   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;
 
@@ -129 +126 @@
   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;
 
@@ -195 +190 @@
 
 --
--- 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'
 --
@@ -239 +221 @@
   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)