Changeset 2306 for trunk/install

Timestamp:

Apr 21, 2008, 12:20:20 AM (16 years ago)

Author:

rvelices

Message:

• merged function ordering() with update_global_rank() and also optimized the queries

File:

• trunk/install/upgrade_1.3.1.php (modified) (11 diffs)

trunk/install/upgrade_1.3.1.php

@@ -68 +68 @@
   ADD COLUMN commentable enum('true','false') NOT NULL default 'true'
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_categories
@@ -88 +88 @@
   SET date_temp = date
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_comments
@@ -123 +123 @@
   SET date_temp = date
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_history
@@ -204 +204 @@
   ADD INDEX images_i5 (date_creation)
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_sessions
@@ -219 +219 @@
   SET expiration_temp = expiration
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_sessions
@@ -234 +234 @@
   DROP COLUMN expiration_temp
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_sites
@@ -248 +248 @@
 DROP TABLE phpwebgallery_user_category
 ;",
-  
+
   "
 ALTER TABLE phpwebgallery_users
@@ -273 +273 @@
   ADD UNIQUE users_ui1 (username)
 ;",
-  
+
   "
 CREATE TABLE phpwebgallery_rate (
@@ -339 +339 @@
 {
   $existing_indexes = array();
-  
+
   $query = '
 SHOW INDEX
@@ -526 +526 @@
 
 // refresh calculated datas
-ordering();
 update_global_rank();
 update_category();
@@ -584 +583 @@
   array(
     'all sub-categories of private categories become private',
-    
+
     'user permissions and group permissions have been erased',