diff options
| author | z0rglub <z0rglub@piwigo.org> | 2003-08-24 23:00:01 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2003-08-24 23:00:01 +0000 |
| commit | 134e520c86aa1903e04a9826ad71b43eb8c3170b (patch) | |
| tree | 2b789ec5a037e1f84ba5516cd4383c13accb06b6 /admin/phpwebgallery_structure.sql | |
| parent | 6cbffaa646892d4d100967a5b28c86eefe1e051d (diff) | |
`/bin/date +"%Y.%m.%d_%Hh%M"`
git-svn-id: http://piwigo.org/svn/trunk@58 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | admin/phpwebgallery_structure.sql | 20 |
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; -- |