Table admin

From Zen Cart(tm) Wiki
Revision as of 02:26, 5 December 2007 by DrByte (talk | contribs) (Reverted edits by Allcanadiansearch.ca (Talk); changed back to last version by DrByte)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.