aboutsummaryrefslogtreecommitdiffstats
path: root/admin/phpwebgallery_structure.sql
diff options
context:
space:
mode:
Diffstat (limited to 'admin/phpwebgallery_structure.sql')
-rw-r--r--admin/phpwebgallery_structure.sql20
1 files changed, 15 insertions, 5 deletions
diff --git a/admin/phpwebgallery_structure.sql b/admin/phpwebgallery_structure.sql
index 63f551ea9..f76bb8ba0 100644
--- a/admin/phpwebgallery_structure.sql
+++ b/admin/phpwebgallery_structure.sql
@@ -13,10 +13,10 @@ CREATE TABLE phpwebgallery_categories (
id smallint(5) unsigned NOT NULL auto_increment,
date_last date NOT NULL default '0000-00-00',
nb_images mediumint(8) unsigned NOT NULL default '0',
- name varchar(255) default NULL,
+ name varchar(255) NOT NULL default '',
id_uppercat smallint(5) unsigned default NULL,
comment text,
- dir varchar(255) NOT NULL default '',
+ dir varchar(255) default NULL,
rank tinyint(3) unsigned default NULL,
status enum('public','private') NOT NULL default 'public',
site_id tinyint(4) unsigned NOT NULL default '1',
@@ -116,6 +116,17 @@ CREATE TABLE phpwebgallery_history (
) TYPE=MyISAM;
--
+-- Table structure for table 'phpwebgallery_image_category'
+--
+
+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)
+) TYPE=MyISAM;
+
+--
-- Table structure for table 'phpwebgallery_images'
--
@@ -123,7 +134,6 @@ DROP TABLE IF EXISTS phpwebgallery_images;
CREATE TABLE phpwebgallery_images (
id mediumint(8) unsigned NOT NULL auto_increment,
file varchar(255) NOT NULL default '',
- cat_id smallint(5) unsigned NOT NULL default '0',
date_available date NOT NULL default '0000-00-00',
date_creation date default NULL,
tn_ext char(3) NOT NULL default 'jpg',
@@ -135,8 +145,8 @@ CREATE TABLE phpwebgallery_images (
width smallint(9) unsigned default NULL,
height smallint(9) unsigned default NULL,
keywords varchar(255) default NULL,
- PRIMARY KEY (id),
- KEY cat_id (cat_id)
+ storage_category_id smallint(5) unsigned default NULL,
+ PRIMARY KEY (id)
) TYPE=MyISAM;
--