Difference between revisions of "Table admin"

From Zen Cart(tm) Wiki
Jump to: navigation, search
(Copied from dataweb.no/dm/)
 
m (Reverted edits by Allcanadiansearch.ca (Talk); changed back to last version by DrByte)
 
(19 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{Template::menuBarDevelopers}}
+
{{Template:menuBarDevelopers}}
 +
== Database Version ==
 +
1.3.0.2
  
  
==== Description ====
+
== Description ==
The admin table stores all access data to the admin panel. The password is stored encrypted with the admin id, admin level, admin email address, and admin user name..
+
Stores all access data to the admin panel.
  
  
==== Columns ====
+
== Table Details ==
  
===== admin_id =====
+
=== Primary Key ===
:integer(11), auto-increment
+
:[[Table admin#admin_id|admin_id]]
:a unique identifier  for the admin table entry
 
  
 +
=== Indexed Fields ===
 +
:[[Table admin#admin_name|admin_name]]
  
===== admin_name =====
 
:varchar(32)
 
:This database field stores the first and last name of the administrator account.
 
  
 +
== Columns ==
  
===== admin_email =====
+
=== admin_id [[Image:Primary_key.gif|Primary Key]]===
:varchar(96)
+
:A unique, auto incremented value, to identify each admin record.
:This database field stores the email address of the administration account and is checked for :validation before inserting it via the admin panel. This email address is used when a admin forgot his/her password.
+
<BLOCKQUOTE>
 +
{|
 +
| Type: || int(11)
 +
|-
 +
| Null: || No
 +
|-
 +
| Default: ||
 +
|-
 +
| Extra: || auto_increment
 +
|}
 +
</BLOCKQUOTE>
  
  
===== admin_pass =====
+
=== admin_name [[Image:Index.gif|Index]]===
:varchar(32)
+
:The username of the administrator account.
:This database field stores the 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(32)
 +
|-
 +
| Null: || No
 +
|-
 +
| Default: ||
 +
|}
 +
</BLOCKQUOTE>
  
  
===== admin_level =====
+
=== admin_email ===
:tiny integer(1)
+
: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.
:Stores the admin level of an administration account.
+
<BLOCKQUOTE>
:Possible values:
+
{|
:*1 - full admin rights if demo is enabled
+
| Type: || varchar(96)
:*2-9 - restricted admin rights if demo is enabled
+
|-
 +
| 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 2-9 (restricted rights).
 +
 
 +
At the present time, only 1 or 0 are used.  The other values are ignored.
 +
 
 +
<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.

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.