Changeset 356 for trunk

Timestamp:

Feb 11, 2004, 12:46:51 AM (20 years ago)

Author:

z0rglub

Message:

adding all new features of branch 1.3, using new index naming convention

File:

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

trunk/admin/phpwebgallery_structure.sql

@@ -1 +1 @@
 -- MySQL dump 8.21
 --
--- Host: localhost    Database: devel
+-- Host: localhost    Database: pwg-bsf
 ---------------------------------------------------------
 -- Server version       3.23.49-log
@@ -24 +24 @@
   uploadable enum('true','false') NOT NULL default 'false',
   representative_picture_id mediumint(8) unsigned default NULL,
-  PRIMARY KEY  (id)
+  uppercats varchar(255) NOT NULL default '',
+  PRIMARY KEY  (id),
+  KEY categories_i1 (id),
+  KEY categories_i2 (id_uppercat)
 ) TYPE=MyISAM;
 
@@ -79 +82 @@
   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)
+  PRIMARY KEY  (user_id,image_id)
 ) TYPE=MyISAM;
 
@@ -126 +129 @@
   image_id mediumint(8) unsigned NOT NULL default '0',
   category_id smallint(5) unsigned NOT NULL default '0',
-  PRIMARY KEY  (image_id,category_id)
+  PRIMARY KEY  (image_id,category_id),
+  KEY image_category_i1 (image_id),
+  KEY image_category_i2 (category_id)
 ) TYPE=MyISAM;
 
@@ -175 +180 @@
   galleries_url varchar(255) NOT NULL default '',
   PRIMARY KEY  (id),
-  UNIQUE KEY galleries_url (galleries_url)
+  UNIQUE KEY sites_ui1 (galleries_url)
 ) TYPE=MyISAM;
 
@@ -187 +192 @@
   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;
 
@@ -221 +239 @@
   long_period tinyint(3) unsigned NOT NULL default '14',
   template varchar(255) NOT NULL default 'default',
-  PRIMARY KEY  (id),
-  UNIQUE KEY username (username)
+  forbidden_categories text,
+  PRIMARY KEY  (id),
+  UNIQUE KEY users_ui1 (username)
 ) TYPE=MyISAM;