aboutsummaryrefslogtreecommitdiffstats
path: root/admin/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-02-10 23:46:51 +0000
committerz0rglub <z0rglub@piwigo.org>2004-02-10 23:46:51 +0000
commitb6be3902f812ef9ad91aa44d09329851de2bef3b (patch)
treebf1e59062a9dacee9752e6c4be4ab1bf61a5b7cb /admin/phpwebgallery_structure.sql
parent135346f2fcf3321f7826873372c74ed92f6d924b (diff)
adding all new features of branch 1.3, using new index naming convention
git-svn-id: http://piwigo.org/svn/trunk@356 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/phpwebgallery_structure.sql')
-rw-r--r--admin/phpwebgallery_structure.sql31
1 files changed, 25 insertions, 6 deletions
diff --git a/admin/phpwebgallery_structure.sql b/admin/phpwebgallery_structure.sql
index d6797c162..7f73acc73 100644
--- a/admin/phpwebgallery_structure.sql
+++ b/admin/phpwebgallery_structure.sql
@@ -1,6 +1,6 @@
-- MySQL dump 8.21
--
--- Host: localhost Database: devel
+-- Host: localhost Database: pwg-bsf
---------------------------------------------------------
-- Server version 3.23.49-log
@@ -23,7 +23,10 @@ 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,
- PRIMARY KEY (id)
+ uppercats varchar(255) NOT NULL default '',
+ PRIMARY KEY (id),
+ KEY categories_i1 (id),
+ KEY categories_i2 (id_uppercat)
) TYPE=MyISAM;
--
@@ -78,7 +81,7 @@ 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',
- KEY user_id (user_id,image_id)
+ PRIMARY KEY (user_id,image_id)
) TYPE=MyISAM;
--
@@ -125,7 +128,9 @@ 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)
+ PRIMARY KEY (image_id,category_id),
+ KEY image_category_i1 (image_id),
+ KEY image_category_i2 (category_id)
) TYPE=MyISAM;
--
@@ -174,7 +179,7 @@ CREATE TABLE phpwebgallery_sites (
id tinyint(4) NOT NULL auto_increment,
galleries_url varchar(255) NOT NULL default '',
PRIMARY KEY (id),
- UNIQUE KEY galleries_url (galleries_url)
+ UNIQUE KEY sites_ui1 (galleries_url)
) TYPE=MyISAM;
--
@@ -189,6 +194,19 @@ 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'
--
@@ -220,8 +238,9 @@ 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)
+ UNIQUE KEY users_ui1 (username)
) TYPE=MyISAM;
--