[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.11_to_1.3.12.php,1.6,1.7

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv22332/updates

Modified Files:
	mysql_1.3.11_to_1.3.12.php 
Log Message:
Added a few indexes on the 'users' table


Index: mysql_1.3.11_to_1.3.12.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/updates/mysql_1.3.11_to_1.3.12.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** mysql_1.3.11_to_1.3.12.php	5 Feb 2005 05:07:10 -0000	1.6
--- mysql_1.3.11_to_1.3.12.php	6 Feb 2005 10:55:48 -0000	1.7
***************
*** 29,40 ****
--- 29,50 ----
  ) TYPE=MyISAM";
  
+ // some weblog directories to ping ...
  $_SQL[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (1, 'blo.gs', 'http://blo.gs/', 'http://ping.blo.gs/', 'weblogUpdates.extendedPing', 1)";
  $_SQL[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (2, 'Weblogs.Com', 'http://www.weblogs.com/', 'http://rpc.weblogs.com/RPC2', 'weblogUpdates.ping', 1)";
  $_SQL[] = "INSERT INTO {$_TABLES['pingservice']} (pid, name, site_url, ping_url, method, is_enabled) VALUES (3, 'Blogrolling.com', 'http://fresh.blogrolling.com/', 'http://rpc.blogrolling.com/pinger/', 'weblogUpdates.ping', 1)";
  
+ // max. number of entries to import into a portal block
  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD rdflimit smallint(5) unsigned NOT NULL default '0' AFTER rdfupdated";
  
+ // new story.ping feature (also see function upgrade_addFeature below)
  $_SQL[] = "INSERT INTO {$_TABLES['features']} (ft_name, ft_descr, ft_gl_core) VALUES ('story.ping', 'Ability to send pings, pingbacks, or trackbacks for stories', 1)";
  
+ // a few more indexes on the users table can' hurt ...
+ $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD INDEX users_username(username)";
+ $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD INDEX users_fullname(fullname)";
+ $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD INDEX users_email(email)";
+ $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD INDEX users_passwd(passwd)";
+ $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD INDEX users_pwrequestid(pwrequestid)";
+ 
  // for dynamic comments
  $_SQL[] = "INSERT INTO {$_TABLES['commentmodes']} (mode, name) VALUES ('dynamic', 'Dynamic')";