Changeset 484 for trunk/lib/Auth_SQL.inc.php

Timestamp:

Jul 30, 2014 10:43:49 PM (10 years ago)

Author:

anonymous

Message:

Changed private methods and properties to protected. A few minor bug fixes.

File:

• trunk/lib/Auth_SQL.inc.php (modified) (4 diffs)

trunk/lib/Auth_SQL.inc.php

@@ -41 +41 @@
 
     // Namespace of this auth object.
-    private $_ns;
+    protected $_ns;
 
     // Static var for test.
-    private $_authentication_tested;
+    protected $_authentication_tested;
 
     // Parameters to be configured by setParam.
-    private $_params = array();
-    private $_default_params = array(
+    protected $_params = array();
+    protected $_default_params = array(
 
         // Automatically create table and verify columns. Better set to false after site launch.
@@ -171 +171 @@
             // The minimal columns for a table compatable with the Auth_SQL class.
             $db->query("CREATE TABLE IF NOT EXISTS " . $db->escapeString($this->getParam('db_table')) . " (
-                " . $this->getParam('db_primary_key') . " smallint(11) NOT NULL auto_increment,
+                " . $this->getParam('db_primary_key') . " MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
                 " . $this->getParam('db_username_column') . " varchar(255) NOT NULL default '',
                 userpass VARCHAR(255) NOT NULL DEFAULT '',
@@ -189 +189 @@
                 added_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
                 modified_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
-                PRIMARY KEY (" . $this->getParam('db_primary_key') . "),
                 KEY " . $this->getParam('db_username_column') . " (" . $this->getParam('db_username_column') . "),
                 KEY userpass (userpass),
@@ -226 +225 @@
                 }
                 $db->query("CREATE TABLE IF NOT EXISTS " . $this->getParam('db_login_table') . " (
-                    " . $this->getParam('db_primary_key') . " SMALLINT(11) NOT NULL DEFAULT '0',
+                    " . $this->getParam('db_primary_key') . " MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',
                     login_datetime DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
                     remote_ip_binary CHAR(32) NOT NULL DEFAULT '',