[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.77,1.78

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_tableanddata.php 
Log Message:
Fixed name of 'spamx' table (was hard-coded to 'gl_spamx')


Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.77
retrieving revision 1.78
diff -C2 -d -r1.77 -r1.78
*** mysql_tableanddata.php	14 Sep 2004 12:28:27 -0000	1.77
--- mysql_tableanddata.php	15 Sep 2004 17:56:11 -0000	1.78
***************
*** 596,604 ****
   
  $_SQL[41] = "
! CREATE TABLE {$_TABLES['spamx']} ("
! 	. " name varchar(20) NOT NULL default '',"
! 	. " value varchar(255) NOT NULL default '',"
! 	. " INDEX name (name)"
! 	. ") TYPE=MyISAM
  ";
  
--- 596,604 ----
   
  $_SQL[41] = "
! CREATE TABLE {$_TABLES['spamx']} (
!   name varchar(20) NOT NULL default '',
!   value varchar(255) NOT NULL default '',
!   PRIMARY KEY (name)
! ) TYPE=MyISAM
  ";
  
***************
*** 890,897 ****
  # Dumping data for spamx
  #
! $_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','zaraz.com')";
  
  $_INDEX[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_date(date)";
--- 890,897 ----
  # Dumping data for spamx
  #
! $_DATA[] = "INSERT INTO {$_TABLES['spamx']} VALUES ('Action','DeleteComment')";
! $_DATA[] = "INSERT INTO {$_TABLES['spamx']} VALUES ('Examine','BlackList')";
! $_DATA[] = "INSERT INTO {$_TABLES['spamx']} VALUES ('Examine','MTBlackList')";
! $_DATA[] = "INSERT INTO {$_TABLES['spamx']} VALUES ('Personal','zaraz.com')";
  
  $_INDEX[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_date(date)";