Xaraya / Postnuke CVS Notices - Message

Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites

Directory filter : [ all ] / postnuke_official / html / modules / categories [ view in CVS ]

Date	Directory [filter]	File(s) [view]	Author [filter]
03 Aug 2002 00:17:41	postnuke_official/html/modules/categories	pninit.php,1.2,1.3	Mike
	some much-needed indexes

Update of /home/cvsroot/postnuke_official/html/modules/categories
In directory ns7.hostnuke.net:/tmp/cvs-serv31030

Modified Files:
	pninit.php 
Log Message:
some much-needed indexes


Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/html/modules/categories/pninit.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** pninit.php	27 Jul 2002 19:06:07 -0000	1.2
--- pninit.php	3 Aug 2002 00:17:39 -0000	1.3
***************
*** 48,52 ****
              $categoriescolumn[left] int(11) unsigned NOT NULL,
              $categoriescolumn[right] int(11) unsigned NOT NULL,
!             PRIMARY KEY($categoriescolumn[cid]))";
  
      $dbconn->Execute($sql);
--- 48,55 ----
              $categoriescolumn[left] int(11) unsigned NOT NULL,
              $categoriescolumn[right] int(11) unsigned NOT NULL,
!             PRIMARY KEY($categoriescolumn[cid]),
!             KEY $categoriescolumn[left] ($categoriescolumn[left]),
!             KEY $categoriescolumn[right] ($categoriescolumn[right])
!             )";
  
      $dbconn->Execute($sql);
***************
*** 64,68 ****
              $categorieslinkagecolumn[cid] int(11) NOT NULL,
              $categorieslinkagecolumn[iid] int(11) NOT NULL,
!             $categorieslinkagecolumn[modid] int(11) NOT NULL
              )";
      $dbconn->Execute($sql);
--- 67,74 ----
              $categorieslinkagecolumn[cid] int(11) NOT NULL,
              $categorieslinkagecolumn[iid] int(11) NOT NULL,
!             $categorieslinkagecolumn[modid] int(11) NOT NULL,
!             KEY $categorieslinkagecolumn[iid] ($categorieslinkagecolumn[iid]),
!             KEY $categorieslinkagecolumn[cid] ($categorieslinkagecolumn[cid]),
!             KEY $categorieslinkagecolumn[modid] ($categorieslinkagecolumn[modid])
              )";
      $dbconn->Execute($sql);

View Statistics - Next Notice - Previous Notice