Changeset 474

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

Location:

trunk/install

Files:

• dbscheme.txt (modified) (3 diffs)
• phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/dbscheme.txt

@@ -57 +57 @@
 column:date_available            table:images         type:date                     nullable:Y
 column:date_creation             table:images         type:date                     nullable:N
-column:tn_ext                    table:images         type:char                     nullable:Y length:3   binary:N
+column:tn_ext                    table:images         type:varchar                  nullable:N length:4   binary:N
 column:name                      table:images         type:varchar                  nullable:N length:255 binary:N
 column:comment                   table:images         type:text                     nullable:N
@@ -67 +67 @@
 column:keywords                  table:images         type:varchar                  nullable:N length:255 binary:N
 column:storage_category_id       table:images         type:smallint                 nullable:N length:5   signed:N
+column:representative_ext        table:images         type:varchar                  nullable:N length:4   binary:N
 column:id                        table:sessions       type:varchar                  nullable:Y length:255 binary:Y
 column:user_id                   table:sessions       type:smallint                 nullable:Y length:5   signed:N
@@ -89 +90 @@
 column:expand                    table:users          type:enum('true','false')     nullable:Y
 column:show_nb_comments          table:users          type:enum('true','false')     nullable:Y
-column:short_period              table:users          type:tinyint                  nullable:Y length:3   signed:N
-column:long_period               table:users          type:tinyint                  nullable:Y length:3   signed:N
+column:recent_period             table:users          type:tinyint                  nullable:Y length:3   signed:N
 column:template                  table:users          type:varchar                  nullable:Y length:255 binary:N
 column:forbidden_categories      table:users          type:text                     nullable:N

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,