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

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.9_to_1.3.10.php 
Log Message:
Allow up to 40 characters for the story ID


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.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** mysql_1.3.9_to_1.3.10.php	30 Sep 2004 07:37:37 -0000	1.22
--- mysql_1.3.9_to_1.3.10.php	30 Sep 2004 08:02:35 -0000	1.23
***************
*** 160,163 ****
--- 160,167 ----
  $_SQL[] = "ALTER TABLE {$_TABLES['staticpage']} CHANGE sp_id sp_id varchar(40) NOT NULL";
  
+ // allow up to 40 characters for the story IDs, as they are editable now
+ $_SQL[] = "ALTER TABLE {$_TABLES['stories']} CHANGE sid sid varchar(40) NOT NULL";
+ $_SQL[] = "ALTER TABLE {$_TABLES['article_images']} CHANGE ai_sid ai_sid varchar(40) NOT NULL";
+ 
  /**
  * Install SpamX plugin (also handled updates from version 1.0)