Changeset 2521 for trunk/install

Timestamp:

Sep 12, 2008, 4:17:35 AM (16 years ago)

Author:

rvelices

Message:

• images.file categories.permalink old_permalinks.permalink - become binary
• session security improvement: now the sessions are valid only for originating ip addr (with mask 255.255.0.0 to allow users behind load balancing proxies) -> stealing the session cookie is almost a non issue (with the exception of the 65536 machines in range)
• metadata sync from the sync button does not overwrite valid data with empty metadata
• other small fixes/enhancements:
  • added event get_category_image_orders
  • fix display issue with redirect.tpl (h1/h2 within h1)
  • fix known_script smarty function registration
  • query search form not submitted if q is empty
  • better admin css rules
  • some other minor changes (ws_core, rest_handler, functions_search...)

Location:

trunk/install

Files:

• db/77-database.php (added)
• piwigo_structure.sql (modified) (3 diffs)

trunk/install/piwigo_structure.sql

@@ -37 +37 @@
   `global_rank` varchar(255) default NULL,
   `image_order` varchar(128) default NULL,
-  `permalink` varchar(64) default NULL,
+  `permalink` varchar(64) binary default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `categories_i3` (`permalink`),
@@ -175 +175 @@
 CREATE TABLE `piwigo_images` (
   `id` mediumint(8) unsigned NOT NULL auto_increment,
-  `file` varchar(255) NOT NULL default '',
+  `file` varchar(255) binary NOT NULL default '',
   `date_available` datetime NOT NULL default '0000-00-00 00:00:00',
   `date_creation` date default NULL,
@@ -209 +209 @@
 CREATE TABLE `piwigo_old_permalinks` (
   `cat_id` smallint(5) unsigned NOT NULL default '0',
-  `permalink` varchar(64) NOT NULL default '',
+  `permalink` varchar(64) binary NOT NULL default '',
   `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00',
   `last_hit` datetime default NULL,