[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.14,1.15

[tony at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.9_to_1.3.10.php 
Log Message:
Spamx is officially part of Geeklog.  All should work fine minus the upgrade file...I'm still missing some key data that I will add yet this weekend


Index: mysql_1.3.9_to_1.3.10.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/updates/mysql_1.3.9_to_1.3.10.php,v
retrieving revision 1.14
retrieving revision 1.15
diff -C2 -d -r1.14 -r1.15
*** mysql_1.3.9_to_1.3.10.php	22 Aug 2004 17:53:22 -0000	1.14
--- mysql_1.3.9_to_1.3.10.php	3 Sep 2004 19:59:56 -0000	1.15
***************
*** 148,150 ****
--- 148,2036 ----
  $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD INDEX blocks_name(name)";
  
+ // Time to add the SpamX table
+ $_SQL[] = "CREATE TABLE {$_TABLES['spamx']} ("
+ 	. " name varchar(20) NOT NULL default '',"
+ 	. " value varchar(255) NOT NULL default '',"
+ 	. " INDEX name (name)"
+ 	. ") TYPE=MyISAM
+ ";
[...1860 lines suppressed...]
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.com')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.info')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-play-poker-online.biz')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.info')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','poker-texas-hold-em.us')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.biz')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('MTBlacklist','i-texas-hold-em.us')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Action','DeleteComment')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Examine','BlackList')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Examine','MTBlackList')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','healz.com')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','x-stories.org')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','finance.resik.com')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','mature-bitch.com')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','maturefucked.com')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','geocities.com/mac_user1979')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','sexgirlz.org')";
+ $_DATA[] = "INSERT INTO gl_spamx VALUES ('Personal','bcure.com')";
+ 
  ?>