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 / base [ view in CVS ]

Date	Directory [filter]	File(s) [view]	Author [filter]
03 Aug 2002 17:59:46	postnuke_official/html/modules/base	pninit.php,1.4,1.5	John Robeson
	another table added... needs proper indexing..

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

Modified Files:
	pninit.php 
Log Message:
another table added... needs proper indexing..


Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/html/modules/base/pninit.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** pninit.php	3 Aug 2002 10:23:17 -0000	1.4
--- pninit.php	3 Aug 2002 17:59:44 -0000	1.5
***************
*** 429,433 ****
      
      $query = pnDBCreateIndex($prefix . '_block_groups',
!                              array('name'   => 'pn_namoe_index',
                                     'fields' => array('pn_name'),
                                     'unique' => 'true'));
--- 429,433 ----
      
      $query = pnDBCreateIndex($prefix . '_block_groups',
!                              array('name'   => 'pn_name_index',
                                     'fields' => array('pn_name'),
                                     'unique' => 'true'));
***************
*** 441,446 ****
--- 441,502 ----
          return NULL;
      }
+ 
      // *_block_instances
+     $query = pnDBCreateTable($prefix . '_block_instances',
+                              array('pn_id'          => array('type'        => 'integer',
+                                                              'null'        => false,
+                                                              'default'     => '0',
+                                                              'increment'   => true,
+                                                              'primary_key' => true),
+                                    'pn_type_id'     => array('type'        => 'integer',
+                                                              'null'        => false,
+                                                              'default'     => '0'),
+                                    'pn_title'       => array('type'        => 'varchar',
+                                                              'size'        => 255,
+                                                              'null'        => true,
+                                                              'default'     => ''),
+                                    'pn_content'     => array('type'        => 'text',
+                                                              'default'     => ''),
+                                    'pn_template'    => array('type'        => 'varchar',
+                                                              'size'        => 255,
+                                                              'null'        => true,
+                                                              'default'     => ''),
+                                    'pn_state'       => array('type'        => 'tinyint',
+                                                              'size'        => 1,
+                                                              'null'        => false,
+                                                              'default'     => '1'),
+                                    'pn_refresh'     => array('type'        => 'integer',
+                                                              'null'        => false,
+                                                              'default'     => '0'),
+                                    'pn_last_update' => array('type'        => 'integer',
+                                                              'null'        => false,
+                                                              'default'     => '0')));
+     
+      $dbconn->Execute($query);
+         
+     // Check for db errors
+     if ($dbconn->ErrorNo() != 0) {
+         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
+         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
+                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
+         return NULL;
+     }
+     
+     $query = pnDBCreateIndex($prefix . '_block_groups',
+                              array('name'   => 'pn_id_index',
+                                    'fields' => array('pn_id'),
+                                    'unique' => 'false'));
+     $dbconn->Execute($query);
+     
+     // Check for db errors
+     if ($dbconn->ErrorNo() != 0) {
+         $msg = pnMLByKey('DATABASE_ERROR', $dbconn->ErrorMsg(), $query);
+         pnExceptionSet(PN_SYSTEM_EXCEPTION, 'DATABASE_ERROR',
+                        new SystemException(__FILE__.'('.__LINE__.'): '.$msg));
+         return NULL;
+     }
+                                                                                
      // *_block_types
+     
      // *_block_group_instances
      // *_users

View Statistics - Next Notice - Previous Notice