Changeset 474 for trunk/install/phpwebgallery_structure.sql

Timestamp:

Aug 5, 2004, 7:50:44 PM (20 years ago)

Author:

z0rglub

Message:

• non picture files management (adds column images.representative_ext)

• short_period + long_period replaced by a single recent_period

File:

• trunk/install/phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -126 +126 @@
   date_available date NOT NULL default '0000-00-00',
   date_creation date default NULL,
-  tn_ext char(3) NOT NULL default 'jpg',
+  tn_ext varchar(4) default '',
   name varchar(255) default NULL,
   comment text,
@@ -136 +136 @@
   keywords varchar(255) default NULL,
   storage_category_id smallint(5) unsigned default NULL,
+  representative_ext varchar(4) default NULL,
   PRIMARY KEY  (id),
   KEY images_i2 (date_available),
@@ -206 +207 @@
   expand enum('true','false') NOT NULL default 'false',
   show_nb_comments enum('true','false') NOT NULL default 'false',
-  short_period tinyint(3) unsigned NOT NULL default '7',
-  long_period tinyint(3) unsigned NOT NULL default '14',
+  recent_period tinyint(3) unsigned NOT NULL default '7',
   template varchar(255) NOT NULL default 'default',
   forbidden_categories text,