Difference between revisions of "Table admin"

From Zen Cart(tm) Wiki
Jump to: navigation, search
m (Reverted edits by Allcanadiansearch.ca (Talk); changed back to last version by DrByte)
 
(16 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
{{Template:menuBarDevelopers}}
 
{{Template:menuBarDevelopers}}
{{Template:TOC}}
+
== Database Version ==
 +
1.3.0.2
 +
 
 +
 
 
== Description ==
 
== Description ==
The admin table stores all access data to the admin panel. The password is stored encrypted.
+
Stores all access data to the admin panel.
  
  
Line 16: Line 19:
 
== Columns ==
 
== Columns ==
  
=== admin_id ===
+
=== admin_id [[Image:Primary_key.gif|Primary Key]]===
:A unique, auto incremented value, to identify each admin entry.
+
:A unique, auto incremented value, to identify each admin record.
 
<BLOCKQUOTE>
 
<BLOCKQUOTE>
 
{|  
 
{|  
| Type: || int(11)  
+
| Type: || int(11)
 
|-  
 
|-  
 
| Null: || No
 
| Null: || No
 
|-
 
|-
| Default: || N/A
+
| Default: ||
 
|-  
 
|-  
| Extra: || auto_increment (Primary)
+
| Extra: || auto_increment
 
|}
 
|}
 
</BLOCKQUOTE>
 
</BLOCKQUOTE>
  
  
=== admin_name ===
+
=== admin_name [[Image:Index.gif|Index]]===
:The first and last name of the administrator account.
+
:The username of the administrator account.
 
<BLOCKQUOTE>
 
<BLOCKQUOTE>
 
{|  
 
{|  
| Type: || varchar(32)  
+
| Type: || varchar(32)
 
|-  
 
|-  
 
| Null: || No
 
| Null: || No
 
|-
 
|-
| Default: || N/A
+
| Default: ||
 
|}
 
|}
 
</BLOCKQUOTE>
 
</BLOCKQUOTE>
Line 45: Line 48:
  
 
=== admin_email ===
 
=== admin_email ===
:The email address of the administration account. Checked for validation before inserting it via the admin panel. Used to reset admin password when password is forgotten by admin.
+
:The email address of the administrator account. Checked for validation before inserting it via the admin panel. Used to reset admin password when password is forgotten by admin.
 
<BLOCKQUOTE>
 
<BLOCKQUOTE>
 
{|  
 
{|  
| Type: || varchar(96)  
+
| Type: || varchar(96)
 
|-  
 
|-  
 
| Null: || No
 
| Null: || No
 
|-
 
|-
| Default: || N/A
+
| Default: ||
 
|}
 
|}
 
</BLOCKQUOTE>
 
</BLOCKQUOTE>
Line 58: Line 61:
  
 
=== admin_pass ===
 
=== admin_pass ===
:Admin password encrypted with the password function [[Function_zen_encrypt_password|zen_encrypt_password()]]. The validation with an encrypted and a plain text password are made with the function [[Function_zen_validate_password|zen_validate_password()]].
+
:Administrator password encrypted with the password function [[Function_zen_encrypt_password|zen_encrypt_password()]]. The validation with an encrypted and a plain text password are made with the function [[Function_zen_validate_password|zen_validate_password()]].
 
<BLOCKQUOTE>
 
<BLOCKQUOTE>
 
{|  
 
{|  
| Type: || varchar(40)  
+
| Type: || varchar(40)
 
|-  
 
|-  
 
| Null: || No
 
| Null: || No
 
|-
 
|-
| Default: || N/A
+
| Default: ||
 
|}
 
|}
 
</BLOCKQUOTE>
 
</BLOCKQUOTE>
Line 71: Line 74:
  
 
=== admin_level ===
 
=== admin_level ===
:Admin level of the administration account. This is used to restrict access as admin when the admin demo is setup. Can be set to 1 (full rights) or 2-9 (restricted rights).
+
:Admin level of the administrator account. This is used to restrict access as admin when the admin demo is setup. Can be set to 1 (full rights) or 2-9 (restricted rights).
'''Someone needs to explian this one better. What is the difference between 2 - 9? What about 0 (the admin panel talks about a level 0)?'''
+
 
 +
At the present time, only 1 or 0 are used.  The other values are ignored.
 +
 
 
<BLOCKQUOTE>
 
<BLOCKQUOTE>
 
{|  
 
{|  
| Type: || tinyint(1)  
+
| Type: || tinyint(1)
 
|-  
 
|-  
 
| Null: || No
 
| Null: || No
Line 82: Line 87:
 
|}
 
|}
 
</BLOCKQUOTE>
 
</BLOCKQUOTE>
 +
 +
== Default Entries ==
 +
Although no default entries are loaded with a stock install (with or without demo data), they are populated when you run the install script and fill in these values via the form.

Latest revision as of 02:26, 5 December 2007

Database Version

1.3.0.2


Description

Stores all access data to the admin panel.


Table Details

Primary Key

admin_id

Indexed Fields

admin_name


Columns

admin_id Primary Key

A unique, auto incremented value, to identify each admin record.
Type: int(11)
Null: No
Default:
Extra: auto_increment


admin_name Index

The username of the administrator account.
Type: varchar(32)
Null: No
Default:


admin_email

The email address of the administrator account. Checked for validation before inserting it via the admin panel. Used to reset admin password when password is forgotten by admin.
Type: varchar(96)
Null: No
Default:


admin_pass

Administrator password encrypted with the password function zen_encrypt_password(). The validation with an encrypted and a plain text password are made with the function zen_validate_password().
Type: varchar(40)
Null: No
Default:


admin_level

Admin level of the administrator account. This is used to restrict access as admin when the admin demo is setup. Can be set to 1 (full rights) or 2-9 (restricted rights).

At the present time, only 1 or 0 are used. The other values are ignored.

Type: tinyint(1)
Null: No
Default: 1

Default Entries

Although no default entries are loaded with a stock install (with or without demo data), they are populated when you run the install script and fill in these values via the form.