[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.24,1.25
blaine at iowaoutdoors.org
blaine at iowaoutdoors.org
Sat Oct 9 15:06:53 EDT 2004
Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv15652/sql/updates
Modified Files:
mysql_1.3.9_to_1.3.10.php
Log Message:
Added location field - to account profile screen. New field added to userinfo table.
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.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** mysql_1.3.9_to_1.3.10.php 9 Oct 2004 18:21:30 -0000 1.24
--- mysql_1.3.9_to_1.3.10.php 9 Oct 2004 19:06:51 -0000 1.25
***************
*** 164,167 ****
--- 164,170 ----
$_SQL[] = "ALTER TABLE {$_TABLES['article_images']} CHANGE ai_sid ai_sid varchar(40) NOT NULL";
+ // Add new location fields to the userinfo table
+ $_SQL[] = "ALTER TABLE {$_TABLES['userinfo']} ADD location VARCHAR(96) NOT NULL AFTER about";
+
/**
* Install SpamX plugin (also handled updates from version 1.0)
More information about the geeklog-cvs
mailing list