[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