[geeklog-devel] [geeklog-cvs] Geeklog-1.x/sql/updates mysql_1.4.1_to_1.5.0.php, 1.37, 1.38

Joe Mucchiello joe at ThrowingDice.com
Tue Jan 1 12:59:29 EST 2008


At 12:51 PM 1/1/2008, Dirk Haun wrote:
>'cid' and 'pid' need to be 32 characters (for backward compatibility)
>
>
>       $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} ADD 
> owner_id mediumint(8) unsigned NOT NULL default '1' AFTER date";
>       $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} CHANGE 
> category cid varchar(20) NOT NULL";
>!     $P_SQL[] = "ALTER TABLE {$_TABLES['links']} CHANGE category 
>cid varchar(20) NOT NULL";
>       $P_SQL[] = "INSERT INTO {$_TABLES['linkcategories']} (cid, 
> pid, category, description, tid, created, modified, group_id, 
> owner_id, perm_owner, perm_group, perm_members, perm_anon) "
>           . "VALUES ('site', 'root', 'Root', 'Website root', '', 
> NOW(), NOW(), 5, 2, 3, 3, 2, 2)";
>--- 366,370 ----
>       $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} ADD 
> owner_id mediumint(8) unsigned NOT NULL default '1' AFTER date";
>       $P_SQL[] = "ALTER TABLE {$_TABLES['linksubmission']} CHANGE 
> category cid varchar(20) NOT NULL";   // <<-------------------------------
>!     $P_SQL[] = "ALTER TABLE {$_TABLES['links']} CHANGE category 
>cid varchar(32) NOT NULL";
>       $P_SQL[] = "INSERT INTO {$_TABLES['linkcategories']} (cid, 
> pid, category, description, tid, created, modified, group_id, 
> owner_id, perm_owner, perm_group, perm_members, perm_anon) "
>           . "VALUES ('site', 'root', 'Root', 'Website root', '', 
> NOW(), NOW(), 5, 2, 3, 3, 2, 2)";

Shouldn't the linksubmission cid also be 32?


----
Joe Mucchiello
Throwing Dice Games
http://www.throwingdice.com 




More information about the geeklog-devel mailing list