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

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.9_to_1.3.10.php 
Log Message:
Extend max. length of static page IDs to 40 characters (again), as fresh 1.3.9 installs were still allowing only 20 characters ...


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.21
retrieving revision 1.22
diff -C2 -d -r1.21 -r1.22
*** mysql_1.3.9_to_1.3.10.php	28 Sep 2004 07:47:02 -0000	1.21
--- mysql_1.3.9_to_1.3.10.php	30 Sep 2004 07:37:37 -0000	1.22
***************
*** 156,159 ****
--- 156,162 ----
  $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_expire(expire)";
  
+ // extend max. length of static page IDs to 40 characters (again)
+ // (fresh installs of 1.3.9 were still using 20 characters)
+ $_SQL[] = "ALTER TABLE {$_TABLES['staticpage']} CHANGE sp_id sp_id varchar(40) NOT NULL";
  
  /**