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]
04 Aug 2002 04:36:09	postnuke_official/html/modules/base	pninit.php,1.6,1.7	Paul Rosania
	last of the critical dbs

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

Modified Files:
	pninit.php 
Log Message:
last of the critical dbs


Index: pninit.php
===================================================================
RCS file: /home/cvsroot/postnuke_official/html/modules/base/pninit.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** pninit.php	4 Aug 2002 03:12:30 -0000	1.6
--- pninit.php	4 Aug 2002 04:36:07 -0000	1.7
***************
*** 591,594 ****
--- 591,619 ----
      
      // *_user_data
+     $query = pnDBCreateTable($prefix . '_user_data',
+                              array('pn_uda_id'     => array('type'        => 'integer',
+                                                             'null'        => false,
+                                                             'default'     => '0',
+                                                             'increment'   => true,
+                                                             'primary_key' => true),
+                                    'pn_uda_propid' => array('type'        => 'integer',
+                                                             'null'        => false,
+                                                             'default'     => '0'),
+                                    'pn_uda_uid'    => array('type'        => 'integer',
+                                                             'null'        => false,
+                                                             'default'     => '0'),
+                                    'pn_uda_value'  => array('type'        => 'blob',
+                                                             'size'        => 'medium',
+                                                             'null'        => '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;
+     }
+     
      // *_user_perms
      $query = pnDBCreateTable($prefix . '_user_perms',
***************
*** 632,635 ****
--- 657,703 ----
      
      // *_user_property
+     $query = pnDBCreateTable($prefix . '_user_property',
+                              array('pn_prop_id'         => array('type'        => 'integer',
+                                                                  'null'        => false,
+                                                                  'default'     => '0',
+                                                                  'increment'   => true,
+                                                                  'primary_key' => true),
+                                    'pn_prop_label'      => array('type'        => 'varchar',
+                                                                  'size'        => 255,
+                                                                  'null'        => false,
+                                                                  'default'     => ''),
+                                    'pn_prop_dtype'      => array('type'        => 'integer',
+                                                                  'null'        => false,
+                                                                  'default'     => NULL),
+                                    'pn_prop_default'    => array('type'        => 'varchar',
+                                                                  'size'        => 255,
+                                                                  'default'     => NULL),
+                                    'pn_prop_validation' => array('type'        => 'varchar',
+                                                                  'size'        => 255,
+                                                                  'default'     => NULL)));
+     $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 . '_user_property',
+                              array('name'   => 'pn_prop_label_index',
+                                    'fields' => array('pn_prop_label'),
+                                    'unique' => 'true'));
+     $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;
+     }
+     
      // *_languages (?)
      
***************
*** 661,665 ****
      }
      
!     $query = "INSERT INTO {$prefix}_modules (pn_name, pn_type, pn_displayname, pn_description, pn_regid, pn_directory, pn_version, pn_admin_capable, pn_user_capable, pn_state) VALUES ('installer', 2, 'Installer', 'PostNuke Installer', 222, 'modules', '1.0', 1, 0, 3);";
      $dbconn->Execute($query);
      
--- 729,733 ----
      }
      
!     $query = "INSERT INTO {$prefix}_modules (pn_name, pn_type, pn_displayname, pn_description, pn_regid, pn_directory, pn_version, pn_admin_capable, pn_user_capable, pn_state) VALUES ('installer', 2, 'Installer', 'PostNuke Installer', 222, 'installer', '1.0', 1, 0, 3);";
      $dbconn->Execute($query);
      
***************
*** 673,676 ****
--- 741,755 ----
      
      $query = "INSERT INTO {$prefix}_modules (pn_name, pn_type, pn_displayname, pn_description, pn_regid, pn_directory, pn_version, pn_admin_capable, pn_user_capable, pn_state) VALUES ('base', 2, 'base', 'Base Module', 68, 'base', '0.1', 1, 1, 3);";
+     $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 = "INSERT INTO {$prefix}_modules (pn_name, pn_type, pn_displayname, pn_description, pn_regid, pn_directory, pn_version, pn_admin_capable, pn_user_capable, pn_state) VALUES ('authsystem', 2, 'AuthSystem', 'PostNuke default authentication module', 42, 'authsystem', '0.91', 1, 0, 3);";
      $dbconn->Execute($query);
      

View Statistics - Next Notice - Previous Notice