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

[Joe Mucchiello]

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