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

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.11_to_1.3.12.php 
Log Message:
Moved the list of sites to ping (weblog directory services like blo.gs) to the database.


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.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** mysql_1.3.11_to_1.3.12.php	29 Jan 2005 09:02:11 -0000	1.4
--- mysql_1.3.11_to_1.3.12.php	3 Feb 2005 19:57:40 -0000	1.5
***************
*** 18,21 ****
--- 18,36 ----
  ) TYPE=MyISAM";
  
+ $_SQL[] = "CREATE TABLE {$_TABLES['pingservice']} (
+   pid smallint(5) unsigned NOT NULL auto_increment,
+   name varchar(128) default NULL,
+   ping_url varchar(255) default NULL,
+   site_url varchar(255) default NULL,
+   method varchar(80) default NULL,
+   is_enabled tinyint(1) unsigned NOT NULL DEFAULT '1',
+   PRIMARY KEY (pid),
+   INDEX pingservice_is_enabled(is_enabled)
+ ) TYPE=MyISAM";
+ 
+ $_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)";
+ 
  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD rdflimit smallint(5) unsigned NOT NULL default '0' AFTER rdfupdated";