[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.7_to_1.3.8.php,1.2,1.3

[geeklog-cvs-admin at lists.geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/sql/updates
In directory internal.geeklog.net:/tmp/cvs-serv5089/sql/updates

Modified Files:
	mysql_1.3.7_to_1.3.8.php 
Log Message:
Replaced separate commentspeedlimit and submitspeedlimit tables with a general speedlimit table and new COM_ functions operating on it.


Index: mysql_1.3.7_to_1.3.8.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/sql/updates/mysql_1.3.7_to_1.3.8.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_1.3.7_to_1.3.8.php	5 May 2003 09:33:39 -0000	1.2
--- mysql_1.3.7_to_1.3.8.php	5 May 2003 16:52:35 -0000	1.3
***************
*** 5,7 ****
--- 5,18 ----
  $_SQL[] = "ALTER TABLE {$_TABLES['users']} ADD pwrequestid varchar(16) DEFAULT NULL";
  
+ $_SQL[] = "CREATE TABLE {$_TABLES['speedlimit']} (
+   id int(10) unsigned NOT NULL auto_increment,
+   ipaddress varchar(15) NOT NULL default '',
+   date int(10) unsigned default NULL,
+   type varchar(30) NOT NULL default 'submit',
+   PRIMARY KEY (id)
+ ) TYPE = MyISAM";
+ 
+ $_SQL[] = "DROP TABLES {$_TABLES['commentspeedlimit']}";
+ $_SQL[] = "DROP TABLES {$_TABLES['submitspeedlimit']}";
+ 
  ?>