Changeset 58 for trunk

Timestamp:

Aug 25, 2003, 1:00:01 AM (21 years ago)

Author:

z0rglub

Message:

/bin/date +"%Y.%m.%d_%Hh%M"

File:

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

trunk/admin/phpwebgallery_structure.sql

@@ -14 +14 @@
   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',
@@ -117 +117 @@
 
 --
+-- 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'
 --
@@ -124 +135 @@
   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,
@@ -136 +146 @@
   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;