Difference between revisions of "Table admin"

From Zen Cart(tm) Wiki
Jump to: navigation, search
Line 1: Line 1:
{{Template:menuBarDevelopers}}
 
== Database Version ==
 
:1.3.5
 
  
 
== Description ==
 
:Stores all access data for the admin panel.
 
 
 
== Table Details ==
 
=== Primary Key ===
 
:[[Table admin#admin_id|admin_id]]
 
 
=== Indexed Fields ===
 
:[[Table admin#admin_name|admin_name]]
 
:[[Table admin#admin_email|admin_email]]
 
 
 
== Columns ==
 
=== admin_id [[Image:Primary_key.gif|Primary Key]]===
 
:A unique, auto incremented value, to identify each admin record.
 
<BLOCKQUOTE>
 
{|
 
| Type: || int(11)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|-
 
| Extra: || auto_increment
 
|}
 
</BLOCKQUOTE>
 
 
 
=== admin_name [[Image:Index.gif|Index]]===
 
:The username of the administrator account.
 
<BLOCKQUOTE>
 
{|
 
| Type: || varchar(32)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== admin_email [[Image:Index.gif|Index]]===
 
: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>
 
{|
 
| Type: || varchar(96)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== admin_pass ===
 
: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>
 
{|
 
| Type: || varchar(40)
 
|-
 
| Null: || No
 
|-
 
| Default: ||
 
|}
 
</BLOCKQUOTE>
 
 
 
=== 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 ''0'' (restricted rights for the purpose of the ''Admin Demo'').
 
 
<BLOCKQUOTE>
 
{|
 
| Type: || tinyint(1)
 
|-
 
| Null: || No
 
|-
 
| Default: || 1
 
|}
 
</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.
 

Revision as of 00:36, 5 December 2007