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

[Dirk Haun]

Update of /cvsroot/geeklog/Geeklog-1.x/sql/updates
In directory qs1489.pair.com:/tmp/cvs-serv1493/sql/updates

Modified Files:
	mysql_1.4.1_to_1.5.0.php 
Log Message:
'cid' and 'pid' need to be 32 characters (for backward compatibility)


Index: mysql_1.4.1_to_1.5.0.php
===================================================================
RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/updates/mysql_1.4.1_to_1.5.0.php,v
retrieving revision 1.37
retrieving revision 1.38
diff -C2 -d -r1.37 -r1.38
*** mysql_1.4.1_to_1.5.0.php	31 Dec 2007 13:38:23 -0000	1.37
--- mysql_1.4.1_to_1.5.0.php	1 Jan 2008 17:51:54 -0000	1.38
***************
*** 343,348 ****
      $P_SQL[] = "
      CREATE TABLE {$_TABLES['linkcategories']} (
!       cid varchar(20) NOT NULL,
!       pid varchar(20) NOT NULL,
        category varchar(32) NOT NULL,
        description text DEFAULT NULL,
--- 343,348 ----
      $P_SQL[] = "
      CREATE TABLE {$_TABLES['linkcategories']} (
!       cid varchar(32) NOT NULL,
!       pid varchar(32) NOT NULL,
        category varchar(32) NOT NULL,
        description text DEFAULT NULL,
***************
*** 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(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)";